Re: [Sqlrelay-discussion] cache manager Warning
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2006-05-11 15:10:56
|
Hello Rene, Looks like there might be 2 problems. The "Warning: using default id" means that it couldn't find a configuration for msdetest in the sqlrelay.conf file. It looks like you have it configured not to start any connections and add them as needed (connections=0, maxconnections>0). The warning is probably getting printed when the first query is run. Make sure the sqlrelay.conf file is readable by whatever user you've configured SQL Relay to run as (the runasuser/runasgroup parameters), as the sqlr-scaler process needs to be able to read the file in order to find the msdetest configuration when it starts an sqlr-connection process. I'm not sure about the EXEC problem. Try running "debug on;" before running your query in the sqlrsh program and see if the debug is helpful. If not, send it to me and it may help figure out what's going on. David Muse dav...@fi... On Wed, 2006-05-10 at 17:20 -0700, Rene Maldonado wrote: > Hi all, > > I'm starting sqlrelay, but when it starts the cache manager I get the > next message: > Starting scaler: > sqlr-scaler -id msdetest -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting cache manager: > sqlr-cachemanager > *Warning: using default id.* > > so far, no problem, if I execute (from the sqlrsh) a Select statement, > it works OK, > But, if I execute an EXEC procedureXX param1, param2; > it do not return the prompt again... > > Any idea what could be wrong? > > Thanks > Rene > > > > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |