Re: [Sqlrelay-discussion] cache manager Warning

[David M. <dav...@fi...>]

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
>