https://panoptic.com/mediawiki/aolserver/api.php?action=feedcontributions&feedformat=atom&user=Peterchaplin
AOLserver Wiki - User contributions [en]
2026-04-25T22:41:37Z
User contributions
MediaWiki 1.34.2
https://panoptic.com/mediawiki/aolserver/index.php?title=Conf/Examples/DatabseConfig&diff=14366
Conf/Examples/DatabseConfig
2012-07-02T10:39:01Z
<p>Peterchaplin: /* AOL Database Configuration with PostgreSQL */</p>
<hr />
<div>= AOL Database Configuration with PostgreSQL = <br />
[[Conf/Examples | part of AOLserver Config Examples]]<br />
<br />
'''The config file'''<br />
<br />
# Global Parameters<br />
ns_section ns/parameters<br />
ns_param home /usr/lib/aolserver4<br />
ns_param servername "Main AOLserver Process"<br />
ns_param serverlog /var/log/aolserver4/virtual-hosts.log<br />
ns_param pidfile /var/run/aolserver4/virtual-hosts.pid<br />
<br />
ns_section ns/servers<br />
ns_param server1 "Website 1"<br />
<br />
# virtual server 1 <br />
ns_section ns/server/server1<br />
ns_param directoryfile index.html<br />
ns_param pageroot /var/www/vhost1<br />
<br />
# modules for server1<br />
ns_section ns/server/server1/modules<br />
ns_param nssock nssock.so<br />
ns_param nslog nslog.so<br />
ns_param nscgi nscgi.so<br />
ns_param nscp nscp.so<br />
ns_param nsdb nsdb.so; # Load the generic database module<br />
<br />
# Configure nssock<br />
ns_section ns/server/server1/module/nssock<br />
ns_param port 80<br />
ns_param address 127.0.0.1<br />
<br />
# Configure server1 accesslog<br />
ns_section ns/server/server1/module/nslog<br />
ns_param file /var/log/aolserver4/example1.com.access.log<br />
<br />
# Database configuration<br />
ns_section "ns/db/drivers"<br />
ns_param postgres_driver nspostgres.so<br />
ns_section "ns/db/pools"<br />
ns_param postgres_pool "Postgres Pool"<br />
ns_section "ns/db/pool/postgres_pool"<br />
ns_param driver postgres_driver<br />
ns_param datasource 127.0.0.1:5432:mydb<br />
ns_param user postgres<br />
ns_param password pass@12345<br />
ns_param connections 1<br />
ns_param logsqlerrors true<br />
ns_param verbose false<br />
<br />
# Configure server1 to use postgres_pool<br />
ns_section "ns/server/server1/db"<br />
ns_param Pools "*"<br />
ns_param DefaultPool "postgres_pool"<br />
----<br />
<br />
<br />
<br />
[[Conf/Examples/DatabseExample | An example script(.adp) of database connection]]</div>
Peterchaplin
https://panoptic.com/mediawiki/aolserver/index.php?title=Conf/Examples/DatabseConfig&diff=14364
Conf/Examples/DatabseConfig
2012-07-02T10:38:33Z
<p>Peterchaplin: /* AOL Database Configuration with PostgreSQL */</p>
<hr />
<div>= AOL Database Configuration with PostgreSQL = <br />
[[Conf/Examples | part of AOLserver Config Examples]]<br />
<br />
'''The config file'''<br />
<br />
# Global Parameters<br />
ns_section ns/parameters<br />
ns_param home /usr/lib/aolserver4<br />
ns_param servername "Main AOLserver Process"<br />
ns_param serverlog /var/log/aolserver4/virtual-hosts.log<br />
ns_param pidfile /var/run/aolserver4/virtual-hosts.pid<br />
<br />
ns_section ns/servers<br />
ns_param server1 "Website 1"<br />
<br />
# virtual server 1 <br />
ns_section ns/server/server1<br />
ns_param directoryfile index.html<br />
ns_param pageroot /var/www/vhost1<br />
<br />
# modules for server1<br />
ns_section ns/server/server1/modules<br />
ns_param nssock nssock.so<br />
ns_param nslog nslog.so<br />
ns_param nscgi nscgi.so<br />
ns_param nscp nscp.so<br />
ns_param nsdb nsdb.so; # Load the generic database module<br />
<br />
# Configure nssock<br />
ns_section ns/server/server1/module/nssock<br />
ns_param port 80<br />
ns_param address 127.0.0.1<br />
<br />
# Configure server1 accesslog<br />
ns_section ns/server/server1/module/nslog<br />
ns_param file /var/log/aolserver4/example1.com.access.log<br />
<br />
# Database configuration<br />
ns_section "ns/db/drivers"<br />
ns_param postgres_driver nspostgres.so<br />
ns_section "ns/db/pools"<br />
ns_param postgres_pool "Postgres Pool"<br />
ns_section "ns/db/pool/postgres_pool"<br />
ns_param driver postgres_driver<br />
ns_param datasource 127.0.0.1:5432:mydb<br />
ns_param user postgres<br />
ns_param password pass@12345<br />
ns_param connections 1<br />
ns_param logsqlerrors true<br />
ns_param verbose false<br />
<br />
# Configure server1 to use postgres_pool<br />
ns_section "ns/server/server1/db"<br />
ns_param Pools "*"<br />
ns_param DefaultPool "postgres_pool"<br />
<br />
----<br />
<br />
<br />
<br />
[[Conf/Examples/DatabseExample | An example script(.adp) of database connection]]</div>
Peterchaplin