[Sqlrelay-discussion] Apache::DBI->connect_on_init() problems/questions
Brought to you by:
mused
|
From: Anthony G. <ant...@gm...> - 2008-05-22 16:48:08
|
While running *Apache::DBI->connect_on_init(**"dbi:SQLRelay:$sid", $user,
$password, {} )* in a server startup script, I keep getting the following
repeated errors until I *sqlr-stop* ....
Couldn't parse config file sqlrelay.conf.
Couldn't find id csg-db.
*After starting sqlr, I get the following **output from ps -fe | grep sqlr *
nly91717 2558 1 0 18:26 ? 00:00:00 sqlr-cachemanager
nly91717 3265 1 0 18:30 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3271 1 0 18:30 ? 00:00:00 sqlr-connection-oracle8 -id
csg-db -connectionid csg-db -config sqlrelay.conf
nly91717 3273 1 0 18:30 ? 00:00:00 sqlr-scaler -id csg-db
-config sqlrelay.conf
*While all the above errors are flying past, I run **ps -fe | grep sqlr and
this is the **output .... *
nly91717 2558 1 0 18:26 ? 00:00:00 sqlr-cachemanager
nly91717 3622 1 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3624 1 0 18:33 ? 00:00:00 sqlr-connection-oracle8 -id
csg-db -connectionid csg-db -config sqlrelay.conf
nly91717 3626 1 0 18:33 ? 00:00:00 sqlr-scaler -id csg-db
-config sqlrelay.conf
nly91717 3667 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3669 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3670 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3671 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3672 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3673 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 3674 3622 0 18:33 ? 00:00:00 sqlr-listener -id csg-db
-config sqlrelay.conf
nly91717 4531 3626 0 18:33 ? 00:00:00 sqlr-connection-oracle8
-silent -ttl 60 -id csg-db -connectionid csg-db -config sqlrelay.con
The web server is run as a different user than that which started sqlr. I
even set the following to 777 thinking that might have been the soln.
-rw------- 1 nly91717 appldev 4 May 22 18:38 sqlr-connection-csg-db.5442
-rw------- 1 nly91717 appldev 4 May 22 18:38 sqlr-listener-csg-db
-rw------- 1 nly91717 appldev 4 May 22 18:38 sqlr-scaler-csg-db
Everything works if I don't use connect_on_init(). So, I need tips/advice as
to what I'm doing wrong and how I could get this working with
Apache/mod_perl using connect_on_init()
Again, CIA
-Ants
--
Disclaimer: Technically speaking, I'm always wrong!
|