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
----
====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:
Revision [2032]
Edited on 2009-10-19 17:21:21 by RonnieArtAdditions:
""insert-raw-html-here""
Deletions:
----
====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
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""##
To visit the admin module you would need to type this URL in your web browser: ##""http://www.yourdomain.com/lists/admin""##
Deletions:
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
==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:
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.
Additions:
==[[PhplistDocumentation Phplist Documentation]] » [[PhplistInstallation Installation]] » [[PhpListConfiguration Configuring]] » ==
Deletions:
Additions:
==[[PhplistDocumentation Phplist Documentation]]» [[PhpListConfiguration Configuring]] » ==
Deletions:
==Installation » [[PhpListConfiguration Configuring]] » [[PhpListConfigDatabase Settings for database connection & web page locations]]==
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"
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:
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 HernoLAdditions:
[[PhplistDocumentation phplist Documentation]]
Deletions:
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"
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.
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:
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 BuzCarterAdditions:
==Installation » [[PhpListConfiguration Configuring]] »==
Deletions:
Revision [448]
Edited on 2006-02-05 20:50:20 by BuzCarterAdditions:
====Settings for database connection & web page locations====
Deletions:
Revision [445]
Edited on 2006-02-05 20:43:29 by BuzCarterAdditions:
==[[PhpListConfiguration Configuring phpList]] » ==
Deletions:
Revision [441]
Edited on 2006-02-05 20:31:42 by BuzCarterAdditions:
====Settings for database connection & web pages====
Deletions:
Revision [440]
Edited on 2006-02-05 20:30:53 by BuzCarterDeletions:
# Look for
# to find your language
#
$language_module = "english.inc";



