Your pool is called gameskillspool and your in /db/pool you just have
gamespool.
Respectfully,
Darren Ferguson
Xavier Bourguignon wrote:
Hi all,
I have this in my config file:
ns_section "ns/server/games-admin/modules"
ns_param nssock $bindir/nssock.so
ns_param nslog $bindir/nslog.so
ns_param nscp $bindir/nscp.so
ns_param nsdb $bindir/nsdb.so
ns_param shared_tcl tcl
ns_section "ns/db/drivers"
ns_param postgres nspostgres.so
ns_section "ns/db/pools"
ns_param gameskillspool "Postgres"
ns_section "ns/db/pool/gamespool"
ns_param Driver postgres
ns_param Connections 5
ns_param DataSource localhost::games
ns_param User postgres
ns_param Password "secret"
ns_param Verbose On
ns_param LogSQLErrors On
ns_param ExtendedTableInfo On
ns_param Connection 5
ns_section "ns/server/games-admin/db"
ns_param Pools *
I have the following in my db.tcl file:
set db [ns_db gethandle "gamespool"]
set datasource [ns_db datasource $db]
set dbtype [ns_db dbtype $db]
set driver [ns_db driver $db]
set poolname [ns_db poolname $db]
set user [ns_db user $db]
set password [ns_db password $db]
In file admin_op.tcl I do this:
set row [ns_db select $db "select * from tadminoptype;"]
while { [ns_db getrow $db $row] } {
ns_log Notice "[ns_set get $row type] - [ns_set get $row desc]"
}
The problem is that the code in admin_op does not work, I get this error:
can't read "db": no such variable
while executing
"ns_db select $db "select * from tadminoptype;""
But if I put this code in the db.tcl file, then it works fine.
Can someone tell me if some settings are wrong, or if I am using ns_db
incorrectly?
Thank you
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
