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

[Anthony G. <cyc...@ya...>]

Okay, I've sorted this one out. I overlook the fact that I only had one connection in my .conf file and for good measure, changed the runas* params.

On to the next question/email

-Ants

Disclaimer: Technically speaking, I am always wrong!

--- On Thu, 22/5/08, Anthony Gardner <ant...@gm...> wrote:
From: Anthony Gardner <ant...@gm...>
Subject: [Sqlrelay-discussion] Apache::DBI->connect_on_init() problems/questions
To: "Discussion of topics related to SQL Relay" <sql...@li...>
Date: Thursday, 22 May, 2008, 5:48 PM

 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!
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html