Conf/Examples/DatabseConfig

AOL Database Configuration with PostgreSQL

part of AOLserver Config Examples

The config file

# Global Parameters
ns_section ns/parameters
ns_param home /usr/lib/aolserver4
ns_param servername "Main AOLserver Process"
ns_param serverlog /var/log/aolserver4/virtual-hosts.log
ns_param pidfile /var/run/aolserver4/virtual-hosts.pid

ns_section ns/servers
ns_param   server1 "Website 1"

# virtual server 1 
ns_section ns/server/server1
ns_param   directoryfile   index.html
ns_param   pageroot        /var/www/vhost1

# modules for server1
ns_section ns/server/server1/modules
  ns_param   nssock        nssock.so
  ns_param   nslog         nslog.so
  ns_param   nscgi         nscgi.so
  ns_param   nscp          nscp.so
  ns_param   nsdb          nsdb.so; # Load the generic database module

# Configure nssock
ns_section ns/server/server1/module/nssock
  ns_param port 80
  ns_param address 127.0.0.1

# Configure server1 accesslog
  ns_section ns/server/server1/module/nslog
  ns_param   file            /var/log/aolserver4/example1.com.access.log

# Database configuration
  ns_section "ns/db/drivers"
  ns_param postgres_driver nspostgres.so
  ns_section "ns/db/pools"
  ns_param postgres_pool "Postgres Pool"
  ns_section "ns/db/pool/postgres_pool"
  ns_param driver      postgres_driver
  ns_param datasource  127.0.0.1:5432:mydb
  ns_param user        postgres
  ns_param password    pass@12345
  ns_param connections 1
  ns_param logsqlerrors true
  ns_param verbose      false

# Configure server1 to use postgres_pool
  ns_section "ns/server/server1/db"
  ns_param Pools "*"
  ns_param DefaultPool "postgres_pool"
 

---

An example script(.adp) of database connection