AOLserver Wiki - User contributions [en]

Conf/Examples/DatabseExampleZeroOrOneRow

2012-01-17T15:50:19Z

Visitatvishal:

[[Conf/Examples/DatabseConfig| part of AOL Database Configuration with PostgreSQL]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users where user_id = 1"
set db [ns_db gethandle $pool]

set rec [ns_db 0or1row $db $sql]
if { $rec eq "" } {
# no rows returned
} else {
# 1 row returned
ns_puts [ns_set array $rec]
}
ns_db releasehandle $db
%>
</body>
</html>

------

'''Note'''

This command(ns_db 0or1row) expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.

Accessing A Database

2012-01-17T12:09:54Z

Visitatvishal:

: ''Note: This tutorial is still very incomplete as of 16aug2004.''

----

This is the simplest example of how to query a database. It is not the recommended way to do it.

<pre>
<%
# set pool "postgres_pool", defined in aolserver.tcl/config.tcl
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
ns_adp_puts "row: [ns_set array $row]"
}
ns_db releasehandle $db
%>
</pre>

'''Caveats:'''

* If you don't explicitly do an ''[ns_db releasehandle $db]'', that connection will not be returned to the pool, which can lead to accidentally exhausting all pool handles. This can easily happen if an uncaught Tcl error is thrown in code before the ''[ns_db releasehandle]'' call is made, thus causing it to never get executed.

This isn't true. All handles are released after the connection has finished processing. However, you should be aware that a db handle is a precious resource, so before you ''ns_return'' the results of your query, which may potentially take a long time, you should release your handles manually.

== See also ==

: [[ns_db]], [http://wiki.tcl.tk/13185 Introduction to Database Access With nstcl] on [http://wiki.tcl.tk/ The Tcler's Wiki] ''(the nstcl package reimplements the ns_* functions from AOLserver)''

[[Category:Documentation]]
[[Category:Tutorial]]

Conf/Examples/DatabseExampleDml

2012-01-13T09:39:48Z

Visitatvishal: Created page with ' part of AOL Database Configuration with PostgreSQL <html> <head><title>Testing of Database connection</title></head> <body> A simple…'

Conf/Examples/DatabseExampleZeroOrOneRow

2012-01-13T09:34:59Z

Visitatvishal:

[[Conf/Examples/DatabseConfig| part of AOL Database Configuration with PostgreSQL]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users where user_id = 1"
set db [ns_db gethandle $pool]

set rec [ns_db 0or1row $db $sql]
ns_puts [ns_set array $rec]
ns_db releasehandle $db
%>
</body>
</html>

------

'''Note'''

This command(ns_db 0or1row) expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.

Conf/Examples/DatabseExampleOneRow

2012-01-13T09:34:33Z

Visitatvishal:

[[Conf/Examples/DatabseConfig| part of AOL Database Configuration with PostgreSQL]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users where user_id = 1"
set db [ns_db gethandle $pool]

set rec [ns_db 1row $db $sql]
ns_puts [ns_set array $rec]
ns_db releasehandle $db
%>
</body>
</html>

------

'''Note'''

This command(ns_db 1row) expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.

Conf/Examples/DatabseExampleZeroOrOneRow

2012-01-12T12:19:19Z

Visitatvishal: Created page with ' part of AOL Database Configuration with PostgreSQL <html> <head><title>Testing of Database connection</title></head> <body> A simple…'

[[Conf/Examples/DatabseConfig| part of AOL Database Configuration with PostgreSQL]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]

set rec [ns_db 0or1row $db $sql]
ns_puts [ns_set array $rec]
ns_db releasehandle $db
%>
</body>
</html>

------

'''Note'''

This command(ns_db 0or1row) expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.

Conf/Examples/DatabseExampleOneRow

2012-01-12T12:18:13Z

Visitatvishal:

[[Conf/Examples/DatabseConfig| part of AOL Database Configuration with PostgreSQL]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]

set rec [ns_db 1row $db $sql]
ns_puts [ns_set array $rec]
ns_db releasehandle $db
%>
</body>
</html>

------

'''Note'''

This command(ns_db 1row) expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.

Conf/Examples/DatabseExampleOneRow

2012-01-12T12:15:33Z

Visitatvishal: Created page with ' part of AOL Database Configuration with PostgreSQL <html> <head><title>Testing of Database connection</title></head> <body> A simple…'

Conf/Examples

2012-01-12T12:13:37Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script using Tcl Library]]

* [[Conf/Examples/DatabseConfig | AOL Database Configuration with PostgreSQL]]
**[[Conf/Examples/DatabseExample | An example script(.adp) of database connection]]
**[[Conf/Examples/DatabseExampleOneRow | An example script(.adp) of database connection using ns_db 1row]]
**[[Conf/Examples/DatabseExampleZeroOrOneRow | An example script(.adp) of database connection using ns_db 0or1row]]
**[[Conf/Examples/DatabseExampleDml | An example script(.adp) of database connection using ns_db dml]]

Conf/Examples/DatabseExample

2012-01-11T13:54:15Z

Visitatvishal:

Conf/Examples/DatabseExample

2012-01-11T13:53:38Z

Visitatvishal:

[[Conf/Examples/DatabseConfig| part of AOL database connection Examples]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
ns_adp_puts "row: [ns_set array $row]"
}
ns_db releasehandle $db
%>
</body>
</html>

Conf/Examples/DatabseExample

2012-01-11T13:53:06Z

Visitatvishal:

[[Conf/Examples/AdpConfig| part of AOL database connection Examples]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
ns_adp_puts "row: [ns_set array $row]"
}
ns_db releasehandle $db
%>
</body>
</html>

Conf/Examples/DatabseExample

2012-01-11T13:51:13Z

Visitatvishal:

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
ns_adp_puts "row: [ns_set array $row]"
}
ns_db releasehandle $db
%>
</body>
</html>

Conf/Examples/DatabseConfig

2012-01-11T13:50:16Z

Visitatvishal: /* TCL Library Configuration */

= AOL Database Configuration with PostgreSQL =
[[Conf/Examples | 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

----

[[Conf/Examples/DatabseExample | An example script(.adp) of database connection]]

Conf/Examples

2012-01-11T13:49:51Z

Visitatvishal: /* AOLServer Configuration Examples */

Conf/Examples/DatabseConfig

2012-01-11T13:49:13Z

Visitatvishal: /* TCL Library Configuration */

= TCL Library Configuration =
[[Conf/Examples | 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

----

[[Conf/Examples/DatabseExample | An example script(.adp) of database connection]]

Conf/Examples/DatabseConfig

2012-01-11T13:47:58Z

Visitatvishal: /* TCL Library Configuration */

Conf/Examples

2012-01-11T13:47:18Z

Visitatvishal: /* AOLServer Configuration Examples */

Conf/Examples

2012-01-11T13:46:39Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script using Tcl Library]]

* [[Conf/Examples/DatabseConfig | AOL Database Configuration with PostgreSQL]]
**[[Conf/Examples/DatabseExample | A simple tcl script example of Database Configuration]]

Conf/Examples

2012-01-11T13:46:10Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script using Tcl Library]]

* [[Conf/Examples/DatabseConfig | AOL Database Configuration with Postgres]]
**[[Conf/Examples/DatabseExample | A simple tcl script example of Database Configuration]]

Conf/Examples

2012-01-11T13:45:48Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script using Tcl Library]]

* [[Conf/Examples/DatabseConfig | AOL Server Database Configuration with Postgres]]
**[[Conf/Examples/DatabseExample | A simple tcl script example of Database Configuration]]

Conf/Examples/DatabseConfig

2012-01-11T09:36:12Z

Visitatvishal: /* TCL Library Configuration */

Conf/Examples/DatabseConfig

2012-01-11T09:34:44Z

Visitatvishal: /* TCL Library Configuration */

= TCL Library Configuration =
[[Conf/Examples | 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

----

'''Note'''

If a Tcl directory is specified, the init.tcl file in that directory is sourced first (if it exists), and then all the remaining .tcl files are sourced alphabetically.

**[[Conf/Examples/DatabseExample | A simple tcl script example of Database Configuration]]

Conf/Examples/TclExample

2012-01-11T09:32:22Z

Visitatvishal:

ns_register_proc GET /hello.html hello
ns_register_proc POST /hello.html hello

proc hello {} {
set set_id [ns_conn form]
set param_value [ns_set get $set_id foo]
ns_return 200 text/html "Hello World. Value $param_value"
}

Conf/Examples/TclExample

2012-01-11T09:32:01Z

Visitatvishal:

[[Conf/Examples/AdpConfig| part of ADP Config Examples]]
ns_register_proc GET /hello.html hello
ns_register_proc POST /hello.html hello

proc hello {} {
set set_id [ns_conn form]
set param_value [ns_set get $set_id foo]
ns_return 200 text/html "Hello World. Value $param_value"
}

Conf/Examples/DatabseExample

2012-01-11T09:31:06Z

Visitatvishal:

<html>
<head><title>Testing of ADP</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
ns_adp_puts "row: [ns_set array $row]"
}
ns_db releasehandle $db
%>
</body>
</html>

Conf/Examples/DatabseExample

2012-01-11T09:30:53Z

Visitatvishal:

Conf/Examples/DatabseExample

2012-01-11T09:30:14Z

Visitatvishal: Created page with ' <html> <head><title>Testing of ADP</title></head> <body> kjhkjhk <% set pool "postgres_pool" set sql "select * from users" set db [ns_db gethandle $pool] …'

<html>
<head><title>Testing of ADP</title></head>
<body>
kjhkjhk
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
ns_adp_puts "row: [ns_set array $row]"
}
ns_db releasehandle $db
%>

</body>
</html>

Conf/Examples/DatabseConfig

2012-01-11T09:20:34Z

Visitatvishal: /* TCL Library Configuration */

= TCL Library Configuration =
[[Conf/Examples | 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

----

'''Note'''

If a Tcl directory is specified, the init.tcl file in that directory is sourced first (if it exists), and then all the remaining .tcl files are sourced alphabetically.

[[Conf/Examples/DatabaseExample| A simple tcl script example of Database Configuration]]

Conf/Examples

2012-01-11T09:20:13Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script using Tcl Library]]

* [[Conf/Examples/DatabseConfig | TCL Database Configuration]]
**[[Conf/Examples/DatabseExample | A simple tcl script example of Database Configuration]]

Conf/Examples/DatabseConfig

2012-01-11T09:18:40Z

Visitatvishal: /* TCL Library Configuration */

= TCL Library Configuration =
[[Conf/Examples | 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

----

'''Note'''

If a Tcl directory is specified, the init.tcl file in that directory is sourced first (if it exists), and then all the remaining .tcl files are sourced alphabetically.

[[Conf/Examples/DatabaseExample| A simple tcl example for Database Configuration]]

Conf/Examples/DatabseConfig

2012-01-11T09:17:28Z

Visitatvishal: Created page with '= TCL Library Configuration = part of AOLserver Config Examples '''The config file''' # Global Parameters ns_section ns/parameters ns_param home /usr/li…'

= TCL Library Configuration =
[[Conf/Examples | 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

----

'''Note'''

If a Tcl directory is specified, the init.tcl file in that directory is sourced first (if it exists), and then all the remaining .tcl files are sourced alphabetically.

[[Conf/Examples/TclExample| A simple tcl script using Tcl Library]]

Conf/Examples

2012-01-11T09:13:52Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script using Tcl Library]]

* [[Conf/Examples/DatabseConfig | TCL Database Configuration]]
**[[Conf/Examples/DatabseExample | A simple tcl example for Database Configuration]]

Conf/Examples/TclConfig

2012-01-06T15:07:46Z

Visitatvishal:

= TCL Library Configuration =
[[Conf/Examples | 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

# 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

# Configure TCL Library
ns_section ns/server/server1/tcl
ns_param library /var/www/vhost1/tcl

----

'''Note'''

If a Tcl directory is specified, the init.tcl file in that directory is sourced first (if it exists), and then all the remaining .tcl files are sourced alphabetically.

[[Conf/Examples/TclExample| A simple tcl script using Tcl Library]]

Conf/Examples/TclConfig

2012-01-06T14:19:23Z

Visitatvishal: /* ADP Configuration */

Conf/Examples/TclConfig

2012-01-06T10:44:15Z

Visitatvishal: /* ADP Configuration */

= ADP Configuration =
[[Conf/Examples | 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

# 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

# Configure TCL Library
ns_section ns/server/server1/tcl
ns_param library /var/www/vhost1/tcl

----

[[Conf/Examples/TclExample| A simple tcl script using Tcl Library]]

Conf/Examples

2012-01-06T10:41:47Z

Visitatvishal: /* AOLServer Configuration Examples */

Conf/Examples/TclExample

2012-01-06T10:39:31Z

Visitatvishal:

Conf/Examples/TclConfig

2012-01-06T10:38:42Z

Visitatvishal: /* ADP Configuration */

Conf/Examples/TclConfig

2012-01-06T09:38:19Z

Visitatvishal: /* ADP Configuration */

Conf/Examples

2012-01-06T09:38:00Z

Visitatvishal: /* AOLServer Configuration Examples */

Conf/Examples/TclExample

2012-01-06T09:37:05Z

Visitatvishal: Created page with 'ns_register_proc GET /hello.html hello ns_register_proc POST /hello.html hello proc hello {} { set set_id [ns_conn form] set param_value [ns_set get $set_id foo] n…'

Conf/Examples/TclConfig

2012-01-06T09:35:34Z

Visitatvishal: Created page with '= ADP Configuration = part of AOLserver Config Examples '''The config file''' # Global Parameters ns_section ns/parameters ns_param home /usr/lib/aolser…'

Conf/Examples

2012-01-06T09:33:28Z

Visitatvishal: /* AOLServer Configuration Examples */

= AOLServer Configuration Examples =

* [[Conf/Examples/Minimal | Minimal Configuration]] - the bare minimum

* [[Conf/Examples/VirtualHosts | Virtual Hosts]] - listen on the same port for several hostnames as per HTTP 1.1
* [[Conf/Examples/Servers | Minimal Config for 2 Servers]] - 2 virtual servers listening on 2 ports.

* [[Conf/Examples/Full | Full Configuration]]

* [[Conf/Examples/CgiConfig | CGI Configuration]]
** [[Conf/Examples/CgiConfig/TclExample | A simple tcl CGI script example]]
** [[Conf/Examples/CgiConfig/TclParamExample | A tcl CGI script with GET parameters example]]
**[[Conf/Examples/CgiConfig/ShExample | A simple shell script example]]

* [[Conf/Examples/AdpConfig | ADP Configuration]]
**[[Conf/Examples/AdpExample | A simple tcl script example of Adp]]
**[[Conf/Examples/AdpParamExample | A simple tcl script example of Adp with GET parameters]]

* [[Conf/Examples/TclConfig | TCL Library Configuration]]
**[[Conf/Examples/TclExample | A simple tcl script example of Adp]]
**[[Conf/Examples/TclParamExample | A simple tcl script example of Adp with GET parameters]]

Conf/Examples/AdpParamExample

2012-01-06T09:13:48Z

Visitatvishal:

[[Conf/Examples/AdpConfig| part of ADP Config Examples]]

<html>
<head><title>Testing of ADP</title></head>
<body>
<%
set ns_set [ns_conn form]
set param_value [ns_set get $ns_set foo]
ns_puts $param_value
%>
</body>
</html>

----
To use with the example config, save the file to:
/var/www/vhost1/test.adp

Conf/Examples/AdpParamExample

2012-01-06T09:13:24Z

Visitatvishal:

[[Conf/Examples/AdpConfig| part of ADP Config Examples]]

<html>
<head><title>Testing of ADP</title></head>
<body>
<%
set set_conn [ns_conn form]
set param_value [ns_set get $set_conn foo]
ns_puts $param_value
%>
</body>
</html>

----
To use with the example config, save the file to:
/var/www/vhost1/test.adp

Conf/Examples

2012-01-06T09:12:29Z

Visitatvishal: /* AOLServer Configuration Examples */

Nscp

2012-01-05T16:50:51Z

Visitatvishal:

See: [http://cvs.sourceforge.net/viewcvs.py/*checkout*/aolserver/aolserver/nscp/nscp.html?rev=HEAD SF CVS: aolserver/nscp/nscp.html]

NaviServer includes a control port interface that can be enabled with the nscp module. This control port interface allows you to telnet to a specified host and port where you can administer the server and execute database commands while the server is running.

The control port interface is a Tcl interface. Within it, you can execute any Tcl command that Tcl libraries and ADP can; the only exceptions being the ns_conn commands.

To administer a server with the control port interface while it is running, the nscp module must be loaded into the server. To set permissions for the server, the nsperm module must also be loaded. To execute database commands while the server is running, you must also configure database services for the server, including database drivers and pools.

Configuring the Control Port Interface
#
# Control port -- nscp
#
ns_section "ns/server/${servername}/module/nscp"
ns_param port 9999 ;# Control port listens on port 9999
ns_param address "127.0.0.1" ;# For security, use 127.0.0.1 only
# Control port users
ns_section "ns/server/${servername}/module/nscp/users"
# The default password for nsadmin is "x". You should change it.
# type "ns_crypt newpassword salt" and put the encrypted string below.
ns_param user "nsadmin:t2GqvvaiIUbF2:" ;# sample user="nsadmin", pw="x".
ns_section "ns/server/${servername}/modules"
# ...
ns_param nscp nscp.so

Some things to notice about the configuration are:

*The port parameter defines the port that the interface will listen on. The default is 9999.
*The address parameter defines the hostname to bind to. The default is 127.0.0.1 so that you can only connect to the control port if you are already logged on to the computer where the server is running.
*The user parameter defines users who can log into the control port. There are three semicolon-separated fields. The first is username (nsadmin); the second is a Unix-like password hash. You can create a password by typing "ns_crypt mypasswd salt". As with Unix, only the first four characters are used.

An example to use Control Port Interface

# telnet localhost 9999
login: nsadmin
password: x

Welcome to servername running at /usr/local/ns/bin/nsd (pid 22413)
NaviServer/4.99.2 for linux built on Sep 7 2006 at 20:38:59
CVS Tag: $Name$
servername:nscp 1>

'''Useful Commands'''

Type "lsort [info commands]" for a complete list of commands available to you. You can type nearly any Tcl command available to NaviServer Tcl libraries and ADPs. This includes the complete Tcl core and nearly any ns_* command. Type "lsort [info commands ns*]" for a sorted list of NaviServer Tcl commands.

Useful commands:
*ns_shutdown -- Shuts down the server.
*ns_info uptime -- How long the server has been running.
*ns_info threads -- How many threads are running
*exit -- Exit the control port.

Nscp

2012-01-05T16:16:46Z

Visitatvishal:

Conf/Examples/AdpParamExample

2012-01-04T09:54:49Z

Visitatvishal:

[[Conf/Examples/AdpConfig| part of ADP Config Examples]]

<html>
<head><title>Testing of ADP</title></head>
<body>
<%
set r [ns_conn form $conn]
set param_value [ns_set get $r foo]
ns_puts $param_value
%>
</body>
</html>

---------------------------------------------------------------------------------
Save the file at below location:
/var/www/vhost1/test.adp