nimafire
find / -name Support > u
سلام.
من میخواهم یه برنامه روی سرور نصب کنم ولی با کار با data base مشکل دارم.
در قسمت instal نرم افزار نوشته:
من یه database با نام InnoDB ساختم و یه user و pass براش تعریف کردم.
حالا اگه در فایل instal را اجراکنم و نصب کنم با data base هماهنگ میشه؟
من میخواهم یه برنامه روی سرور نصب کنم ولی با کار با data base مشکل دارم.
در قسمت instal نرم افزار نوشته:
>> PRE-INSTALL
Please check you have a PHP4.x version installed. We have not tested on
PHP5.x yet. You are welcome to try. GDLib 2.x needs to be installed. You
will see errors on a 1.x version. You are welcome to modify the
File.class.php file to cope with a v1.x version. FreeType needs to be
installed.
Database
The standard SQL statements we supply create InnoDB, a MySQL transaction-safe
storage engine. It has been designed for maximum performance when processing
large data volumes. Its CPU efficiency is probably not matched by any other
disk-based relational database engine. It has been proven to handle an average
load of 800 inserts/updates per second. You may wish to change this prior to
installation by editting the /install/aroundme.sql file.
For more information: http://dev.mysql.com/doc/mysql/en/innodb-overview.html
CHARACTER SETS
Unicode provides a unique number for every character, no matter what the
platform, no matter what the program, no matter what the language. The Unicode
Standard has been adopted by such industry leaders including Apple, HP, IBM,
Microsoft, Oracle, SAP, Sun, Sybase and Unisys. Unicode is required by modern
standards such as XML, Java, ECMAScript (JavaScript), LDAP, CORBA 3.0, WML,
etc., and is the official way to implement ISO/IEC 10646. It is supported
in many operating systems, all modern browsers, and many other products.
Unicode enables a single software product or a single website to be targeted
across multiple platforms, languages and countries without re-engineering
and allows data to be transported through many different systems without
corruption.
We have adopted UNICODE for AROUNDMe. In /install/aroundme.sql we create our
database tables using "CHARACTER SET utf8". We recommend that you use this.
For more information:
http://www.unicode.org/
http://dev.mysql.com/doc/mysql/en/charset-unicode.html
>> INSTALL
1. Please read the terms of the license prior to install. 3rd party classes
are included for ease. Please note, these are under separate license.
FTP note: When uploading a font to your website you have to set the
transfer mode to binary.
2. Use the included install/aroundme.sql file to populate a database (you will need
to manually create a new database first). For development we recommend
using MySQL, however ADOdb supports many database types. Please note, we
have only tested this software with MySQL. No support for other databases
can be given at this time.
You can edit the aroundme.sql file to change the prefix of the database
name. By default this is "am_<database_table_name>", but if you wish
to have multiple instances of AROUNDMe under one account you can edit this
to anything such as "am_dev_<database_table_name>" - remember to update
the server_config file db_prefic var to reflect your changes.
3. Edit the /config/config_aroundme.inc.php with your server and database
connection variables.
4. [optional] If you require spell checking and you have Aspell installed
update the $c_node['node']['language']['aspell']['command'] variable to
include the path to you Aspell installation. Standard aspell installs
are:
WINDOWS '"C:\Program Files\Aspell\bin\aspell.exe"'
GNU/Linux "/usr/local/bin/aspell"
5. Edit the .htaccess file and replace the 404 error URL with your own.
>> SETUP
1. Register as a user and complete the registration process. Once complete
select the user from the am_user table in the database and change the
'role_id' column to the $c_acs['arr_acs']['resource']['administration']
(admin privilege) value found in the config_acs.inc.php config file:
(default is 101)
The user_id will be "1". This is insecure. We recommend that you change
the user_id to be a random number between 1 and 100000.
If you change this you will also need to update your profile user_id:
UPDATE am_user_profile set user_id=X where user_id=1;
where X equals your user_id
2. Setup the administrator privileges. Insert the 'allow_access' privilege
into the am_acs_permission table. Default is:
INSERT INTO `am_acs_permission` VALUES (1, 101, X, 101);
where X equals your user_id
3. Logoff and log in again. You will now see a "node admin" button appear at
the top of the page. Press that and select "acs". Check the boxes for the
permissions for the administrator to grant yourself permissions throughout
the system (recommended that you check all boxes in first column) and
press "update permissions".
4. start playing.
>> CRON
1. Set the $c_node['cron']['enabled'] config var to true and then just
schedule the script newsletter scripts:
nlt_send.php
When a user or a group sends a newsletter nlt_send will send out X
newsletters every time cron activates the script until there are no
more newsletters to send.
The number of newsletter send each time is defined by the
$c_node['newsletter']['nr_per_batch'] config variable. As default
this is set to 10 per script excecution:
$c_node['newsletter']['nr_per_batch'] = "10";
Setup a crontab that will send X newsletters (default 10) every Y times
per day. You should consider the number of projected users, the number of
projected newsletters, the number of mail servers and the processing
speed of your server when doing this. If you are unsure and you just
want to get up and running set this to execute every 15 minutes:
10,25,40,55 * * * * /usr/bin/wget -q http://<path>/nlt_send.php
This will run at 10,25,40 and 55 minutes past each hour.
nlt_digest_send.php
This file runs the weekly digest email. It selects all the people that
registered on the same day as the run time (ie: it will send an email to
everyone who registered on a monday on monday).
0,15,30,45 * * * * /usr/bin/wget -q http://<path>/nlt_digest_send.php
This will run at 0,15,30 and 45 minutes past each hour.
>> COMMON ERRORS
1. No GDLIB Installed (Windows only)
You will need GDLib support active for uploading images. Php4.3.x and up
has this built in, but not activated:
Now you should have a file named php.ini.dist (for this document we will
assume it to be in in this path "c:\php\"). Rename that to php.ini and copy
it to the root of you Windows directory, C:/WINDOWS/ (be sure to back up
the one that is there).
change:
extension_dir = ":/"
to:
extension_dir= " C:\php\extensions"
uncomment to extension:
change:
;extension=php_gd2.dll
to:
extension=php_gd2.dll
You must restart to see the changes take effect.
2. Session Errors (Windows only)
You will need to set up a session save path in php.ini. Edit php.ini:
change
session.save_path = "/tmp"
to:
session.save_path = "C:\tmp\"
(C:\tmp\ used as example - you can change the directory path to suit you)
>> UNSUPPORTED LANGUAGES
You can add a language by translating the language files, adding an ID to the
config file and by updating set_locale function in the User.class.php file, but
we would be happier if you worked with us so that we add it and everyone gets it.
Please check you have a PHP4.x version installed. We have not tested on
PHP5.x yet. You are welcome to try. GDLib 2.x needs to be installed. You
will see errors on a 1.x version. You are welcome to modify the
File.class.php file to cope with a v1.x version. FreeType needs to be
installed.
Database
The standard SQL statements we supply create InnoDB, a MySQL transaction-safe
storage engine. It has been designed for maximum performance when processing
large data volumes. Its CPU efficiency is probably not matched by any other
disk-based relational database engine. It has been proven to handle an average
load of 800 inserts/updates per second. You may wish to change this prior to
installation by editting the /install/aroundme.sql file.
For more information: http://dev.mysql.com/doc/mysql/en/innodb-overview.html
CHARACTER SETS
Unicode provides a unique number for every character, no matter what the
platform, no matter what the program, no matter what the language. The Unicode
Standard has been adopted by such industry leaders including Apple, HP, IBM,
Microsoft, Oracle, SAP, Sun, Sybase and Unisys. Unicode is required by modern
standards such as XML, Java, ECMAScript (JavaScript), LDAP, CORBA 3.0, WML,
etc., and is the official way to implement ISO/IEC 10646. It is supported
in many operating systems, all modern browsers, and many other products.
Unicode enables a single software product or a single website to be targeted
across multiple platforms, languages and countries without re-engineering
and allows data to be transported through many different systems without
corruption.
We have adopted UNICODE for AROUNDMe. In /install/aroundme.sql we create our
database tables using "CHARACTER SET utf8". We recommend that you use this.
For more information:
http://www.unicode.org/
http://dev.mysql.com/doc/mysql/en/charset-unicode.html
>> INSTALL
1. Please read the terms of the license prior to install. 3rd party classes
are included for ease. Please note, these are under separate license.
FTP note: When uploading a font to your website you have to set the
transfer mode to binary.
2. Use the included install/aroundme.sql file to populate a database (you will need
to manually create a new database first). For development we recommend
using MySQL, however ADOdb supports many database types. Please note, we
have only tested this software with MySQL. No support for other databases
can be given at this time.
You can edit the aroundme.sql file to change the prefix of the database
name. By default this is "am_<database_table_name>", but if you wish
to have multiple instances of AROUNDMe under one account you can edit this
to anything such as "am_dev_<database_table_name>" - remember to update
the server_config file db_prefic var to reflect your changes.
3. Edit the /config/config_aroundme.inc.php with your server and database
connection variables.
4. [optional] If you require spell checking and you have Aspell installed
update the $c_node['node']['language']['aspell']['command'] variable to
include the path to you Aspell installation. Standard aspell installs
are:
WINDOWS '"C:\Program Files\Aspell\bin\aspell.exe"'
GNU/Linux "/usr/local/bin/aspell"
5. Edit the .htaccess file and replace the 404 error URL with your own.
>> SETUP
1. Register as a user and complete the registration process. Once complete
select the user from the am_user table in the database and change the
'role_id' column to the $c_acs['arr_acs']['resource']['administration']
(admin privilege) value found in the config_acs.inc.php config file:
(default is 101)
The user_id will be "1". This is insecure. We recommend that you change
the user_id to be a random number between 1 and 100000.
If you change this you will also need to update your profile user_id:
UPDATE am_user_profile set user_id=X where user_id=1;
where X equals your user_id
2. Setup the administrator privileges. Insert the 'allow_access' privilege
into the am_acs_permission table. Default is:
INSERT INTO `am_acs_permission` VALUES (1, 101, X, 101);
where X equals your user_id
3. Logoff and log in again. You will now see a "node admin" button appear at
the top of the page. Press that and select "acs". Check the boxes for the
permissions for the administrator to grant yourself permissions throughout
the system (recommended that you check all boxes in first column) and
press "update permissions".
4. start playing.
>> CRON
1. Set the $c_node['cron']['enabled'] config var to true and then just
schedule the script newsletter scripts:
nlt_send.php
When a user or a group sends a newsletter nlt_send will send out X
newsletters every time cron activates the script until there are no
more newsletters to send.
The number of newsletter send each time is defined by the
$c_node['newsletter']['nr_per_batch'] config variable. As default
this is set to 10 per script excecution:
$c_node['newsletter']['nr_per_batch'] = "10";
Setup a crontab that will send X newsletters (default 10) every Y times
per day. You should consider the number of projected users, the number of
projected newsletters, the number of mail servers and the processing
speed of your server when doing this. If you are unsure and you just
want to get up and running set this to execute every 15 minutes:
10,25,40,55 * * * * /usr/bin/wget -q http://<path>/nlt_send.php
This will run at 10,25,40 and 55 minutes past each hour.
nlt_digest_send.php
This file runs the weekly digest email. It selects all the people that
registered on the same day as the run time (ie: it will send an email to
everyone who registered on a monday on monday).
0,15,30,45 * * * * /usr/bin/wget -q http://<path>/nlt_digest_send.php
This will run at 0,15,30 and 45 minutes past each hour.
>> COMMON ERRORS
1. No GDLIB Installed (Windows only)
You will need GDLib support active for uploading images. Php4.3.x and up
has this built in, but not activated:
Now you should have a file named php.ini.dist (for this document we will
assume it to be in in this path "c:\php\"). Rename that to php.ini and copy
it to the root of you Windows directory, C:/WINDOWS/ (be sure to back up
the one that is there).
change:
extension_dir = ":/"
to:
extension_dir= " C:\php\extensions"
uncomment to extension:
change:
;extension=php_gd2.dll
to:
extension=php_gd2.dll
You must restart to see the changes take effect.
2. Session Errors (Windows only)
You will need to set up a session save path in php.ini. Edit php.ini:
change
session.save_path = "/tmp"
to:
session.save_path = "C:\tmp\"
(C:\tmp\ used as example - you can change the directory path to suit you)
>> UNSUPPORTED LANGUAGES
You can add a language by translating the language files, adding an ID to the
config file and by updating set_locale function in the User.class.php file, but
we would be happier if you worked with us so that we add it and everyone gets it.
من یه database با نام InnoDB ساختم و یه user و pass براش تعریف کردم.
حالا اگه در فایل instal را اجراکنم و نصب کنم با data base هماهنگ میشه؟
