larger smaller normal text version of this page

Revision [2033]

Last edited on 2009-10-19 21:40:51 by AlStillero [Reverted edits by RonnieArt]
Additions:
==[[PhplistDocumentation Phplist Documentation]] » [[PhplistInstallation Installation]] » [[PhpListConfiguration Configuring]] » ==
----

====Settings for database connection & web page locations====


This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages are located. If you experience any database connection errors, odds are it's because of a problem here.

==Database connection settings==
Begin with these settings:
1) ##$database_host##: where is the mySQL database installed (on what server)? The most common (and simple) installation has the database on the same server (computer) as the web site's server. Therefore, the default value of "localhost" is probably ok.
1) ##$database_name##: on the host (above) what is the name of the database where phpList's tables have been installed?
1) ##$database_user##: what is the name of the database user that has Insert, Update, Delete privileges on the above database?
1) ##$database_password##: what is this user's password?

==Using a database prefix==
Most people install each application's tables in their own database. That is, if you have a CMS you would have a CMS database. A photo gallery would have its own, too. If, however, for some reason you want (or need) to install multiple applications within the same database it is critical that the table names be unique.

phpList gives you the option during installation of choosing a ##table prefix##. This means that should more than one of your applications require a table named "user" the database will not be confused by an ambiguous name; there's only one "user" table. By default phpList prefixes all of its tables: ##phplist_##
This also makes [[BackupDatabase backups]] easier.

==Specifying the location of your phplist files==
Finally, you need to specify where the phpList script files are located on your server. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively. For instance, let's say you installed phplist in a subdirectory of your root directory called "lists". Then the following default settings should work:

%%(php)
$pageroot = '/lists';
$adminpages = '/lists/admin';
%%
**Note**: Keep in mind you cannot change the name of the admin directory. However, you can change the name of the ##'lists'## directory.

If you configured phpList as in the above example, you should be able to browse to your subscribe page by using the following URL in your web browser: ##""http://www.yourdomain.com/lists""##
To visit the admin module you would need to type this URL in your web browser: ##""http://www.yourdomain.com/lists/admin""##


== this block in config.php ==
%%(php)
# what is your Mysql database server
# most common is "localhost". Yahoo Small Business hosting uses "mysql"
$database_host = "localhost";

# what is the name of the database we are using
$database_name = "phplistdb";

# who do we log in as?
$database_user = "phplist";

# and what password do we use
$database_password = 'phplist';

# if you use multiple installations of PHPlist you can set this to
# something to identify this one. it will be prepended to email report
# subjects
$installation_name = 'PHPlist';

# if you want a prefix to all your tables, specify it here,
$table_prefix = "phplist_";

# if you want to use a different prefix to user tables, specify it here.
# read README.usertables for more information
$usertable_prefix = "phplist_user_";

# if you change the path to the PHPlist system, make the change here as well
# path should be relative to the root directory of your webserver (document root)
# you cannot actually change the "admin", but you can change the "lists"
$pageroot = '/lists';
$adminpages = '/lists/admin';%%


**Related pages:**
~ [[PhpListConfiguration Configuring]]
~ [[PhplistTroubleshooting Troubleshooting]]

----
CategoryDocumentation
Deletions:
""insert-raw-html-here""


Revision [2032]

Edited on 2009-10-19 17:21:21 by RonnieArt
Additions:
""insert-raw-html-here""
Deletions:
==[[PhplistDocumentation Phplist Documentation]] » [[PhplistInstallation Installation]] » [[PhpListConfiguration Configuring]] » ==
----

====Settings for database connection & web page locations====


This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages are located. If you experience any database connection errors, odds are it's because of a problem here.

==Database connection settings==
Begin with these settings:
1) ##$database_host##: where is the mySQL database installed (on what server)? The most common (and simple) installation has the database on the same server (computer) as the web site's server. Therefore, the default value of "localhost" is probably ok.
1) ##$database_name##: on the host (above) what is the name of the database where phpList's tables have been installed?
1) ##$database_user##: what is the name of the database user that has Insert, Update, Delete privileges on the above database?
1) ##$database_password##: what is this user's password?

==Using a database prefix==
Most people install each application's tables in their own database. That is, if you have a CMS you would have a CMS database. A photo gallery would have its own, too. If, however, for some reason you want (or need) to install multiple applications within the same database it is critical that the table names be unique.

phpList gives you the option during installation of choosing a ##table prefix##. This means that should more than one of your applications require a table named "user" the database will not be confused by an ambiguous name; there's only one "user" table. By default phpList prefixes all of its tables: ##phplist_##
This also makes [[BackupDatabase backups]] easier.

==Specifying the location of your phplist files==
Finally, you need to specify where the phpList script files are located on your server. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively. For instance, let's say you installed phplist in a subdirectory of your root directory called "lists". Then the following default settings should work:

%%(php)
$pageroot = '/lists';
$adminpages = '/lists/admin';
%%
**Note**: Keep in mind you cannot change the name of the admin directory. However, you can change the name of the ##'lists'## directory.

If you configured phpList as in the above example, you should be able to browse to your subscribe page by using the following URL in your web browser: ##""http://www.yourdomain.com/lists""##
To visit the admin module you would need to type this URL in your web browser: ##""http://www.yourdomain.com/lists/admin""##


== this block in config.php ==
%%(php)
# what is your Mysql database server
# most common is "localhost". Yahoo Small Business hosting uses "mysql"
$database_host = "localhost";

# what is the name of the database we are using
$database_name = "phplistdb";

# who do we log in as?
$database_user = "phplist";

# and what password do we use
$database_password = 'phplist';

# if you use multiple installations of PHPlist you can set this to
# something to identify this one. it will be prepended to email report
# subjects
$installation_name = 'PHPlist';

# if you want a prefix to all your tables, specify it here,
$table_prefix = "phplist_";

# if you want to use a different prefix to user tables, specify it here.
# read README.usertables for more information
$usertable_prefix = "phplist_user_";

# if you change the path to the PHPlist system, make the change here as well
# path should be relative to the root directory of your webserver (document root)
# you cannot actually change the "admin", but you can change the "lists"
$pageroot = '/lists';
$adminpages = '/lists/admin';%%


**Related pages:**
~ [[PhpListConfiguration Configuring]]
~ [[PhplistTroubleshooting Troubleshooting]]

----
CategoryDocumentation


Revision [1380]

Edited on 2007-09-16 16:50:46 by AlStillero [Minor edit]
Additions:
If you configured phpList as in the above example, you should be able to browse to your subscribe page by using the following URL in your web browser: ##""http://www.yourdomain.com/lists""##
To visit the admin module you would need to type this URL in your web browser: ##""http://www.yourdomain.com/lists/admin""##
Deletions:
In this example, the link to your subscribe page would be: ##""http://www.yourdomain.com/lists""##
And the link to the admin module would be: ##""http://www.yourdomain.com/lists/admin""##


Revision [1343]

Edited on 2007-08-11 21:40:34 by AlStillero [Added explanation of pageroot and adminpages settings]
Additions:
This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages are located. If you experience any database connection errors, odds are it's because of a problem here.
==Database connection settings==
==Using a database prefix==
This also makes [[BackupDatabase backups]] easier.
==Specifying the location of your phplist files==
Finally, you need to specify where the phpList script files are located on your server. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively. For instance, let's say you installed phplist in a subdirectory of your root directory called "lists". Then the following default settings should work:
$adminpages = '/lists/admin';
%%
In this example, the link to your subscribe page would be: ##""http://www.yourdomain.com/lists""##
And the link to the admin module would be: ##""http://www.yourdomain.com/lists/admin""##
**Note**: Keep in mind you cannot change the name of the admin directory. However, you can change the name of the ##'lists'## directory.
**Related pages:**
~ [[PhpListConfiguration Configuring]]
~ [[PhplistTroubleshooting Troubleshooting]]
CategoryDocumentation
Deletions:
This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages are located.
If you experience any database connection errors, odds are it's because of a problem here.
This also makes backups easier.
Finally, you need to specify where the phpList web page files are located for your install. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively.


Revision [887]

Edited on 2006-10-22 03:26:54 by AlStillero [minor edit]
Additions:
==[[PhplistDocumentation Phplist Documentation]] » [[PhplistInstallation Installation]] » [[PhpListConfiguration Configuring]] » ==
Deletions:
==[[PhplistDocumentation Phplist Documentation]]» [[PhpListConfiguration Configuring]] » ==


Revision [796]

Edited on 2006-10-17 04:46:32 by AlStillero [minor edit]
Additions:
==[[PhplistDocumentation Phplist Documentation]]» [[PhpListConfiguration Configuring]] » ==
Deletions:
[[PhplistDocumentation phplist Documentation]]
==Installation » [[PhpListConfiguration Configuring]] » [[PhpListConfigDatabase Settings for database connection & web page locations]]==


Revision [786]

Edited on 2006-10-16 16:22:26 by AlStillero [minor edits]
Additions:
==Installation » [[PhpListConfiguration Configuring]] » [[PhpListConfigDatabase Settings for database connection & web page locations]]==
This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages are located.
Finally, you need to specify where the phpList web page files are located for your install. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively.
# you cannot actually change the "admin", but you can change the "lists"
Deletions:
==Installation » [[PhpListConfiguration Configuring]] »==
This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages live.
Finally, you need to specify where the php web page files are located for your install. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively.


Revision [597]

Edited on 2006-07-17 15:53:52 by HernoL
Additions:
[[PhplistDocumentation phplist Documentation]]
Deletions:
PhplistDocumentation


Revision [508]

Edited on 2006-04-12 20:32:09 by GeorgeLerner [added comment for Yahoo Small Business hosting]
Additions:
# most common is "localhost". Yahoo Small Business hosting uses "mysql"


Revision [487]

Edited on 2006-02-11 09:07:42 by YanB [minor formatting]
Additions:
This is the most commonly modified portion of ##config.php## because it tells phpList how to connect to the database and where phpList's administration web pages live.
1) ##$database_host##: where is the mySQL database installed (on what server)? The most common (and simple) installation has the database on the same server (computer) as the web site's server. Therefore, the default value of "localhost" is probably ok.
1) ##$database_name##: on the host (above) what is the name of the database where phpList's tables have been installed?
1) ##$database_user##: what is the name of the database user that has Insert, Update, Delete privileges on the above database?
1) ##$database_password##: what is this user's password?
phpList gives you the option during installation of choosing a ##table prefix##. This means that should more than one of your applications require a table named "user" the database will not be confused by an ambiguous name; there's only one "user" table. By default phpList prefixes all of its tables: ##phplist_##
This also makes backups easier.
Finally, you need to specify where the php web page files are located for your install. Both for the user and for the administrator. These two settings are : ##$pageroot## and ##$adminpages##, respectively.
Deletions:
This is the most commonly modified portion of config.php because it tells phpList how to connect to the database and where phpList's administration web pages live.
1) $database_host: where is the mySQL database installed (on what server)? The most common (and simple) installation has the database on the same server (computer) as the web site's server. Therefore, the default value of "localhost" is probably ok.
1) $database_name: on the host (above) what is the name of the database where phpList's tables have been installed?
1) $database_user: what is the name of the database user that has Insert, Update, Delete privileges on the above database?
1) $database_password: what is this user's password?
phpList gives you the option during installation of choosing a "table prefix". This means that should more than one of your applications require a table named "user" the database will not be confused by an ambiguous name; there's only one "user" table. By default phpList prefixes all of its tables "phplist_". This also makes backups easier.
Finally, you need to specify where the php web page files are located for your install. Both for the user and for the administrator. These two settings are : $pageroot and $adminpages, respectively.


Revision [469]

Edited on 2006-02-06 04:49:14 by BuzCarter
Additions:
==Installation » [[PhpListConfiguration Configuring]] »==
Deletions:
==[[PhpListConfiguration Configuring phpList]] » ==


Revision [448]

Edited on 2006-02-05 20:50:20 by BuzCarter
Additions:
====Settings for database connection & web page locations====
Deletions:
====Settings for database connection & web pages====


Revision [445]

Edited on 2006-02-05 20:43:29 by BuzCarter
Additions:
==[[PhpListConfiguration Configuring phpList]] » ==
Deletions:
==Configuring phpList==


Revision [441]

Edited on 2006-02-05 20:31:42 by BuzCarter
Additions:
====Settings for database connection & web pages====
Deletions:
====General settings for language and database====


Revision [440]

Edited on 2006-02-05 20:30:53 by BuzCarter
Deletions:
# select the language module to use
# Look for .inc files in the texts directory
# to find your language
#
$language_module = "english.inc";


Revision [439]

The oldest known version of this page was created on 2006-02-05 20:30:07 by BuzCarter
Page was generated in 0.0520 seconds