[Sqlrelay-discussion] Apache::DBI->connect_on_init() problems/questions

[Anthony G. <ant...@gm...>]

 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!