Re: [Sqlrelay-discussion] Running sqlr-scaler locally

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

It looks like the scaler really doesn't support -localstatedir.  It
should but it doesn't.  A quick fix would be to edit src/scaler/scaler.C
and replace instances of TMP_DIR with whatever directory you want to
use.  Then rebuild and reinstall.

I'll fix this in the next release.

David Muse
dav...@fi...

On Fri, 2008-05-16 at 23:35 -0700, Tim Piatenko wrote:
> Hi folks,
> 
> I have just successfully setup SQLRelay to connect to a MS SQL db, but
> all my efforts are being spoiled by the fact that I can't seem to be
> able to run sqlr-scaler ... The problem is that I don't have write
> permissions to /var/cache/sqlrelay/tmp/, which is where the scaler
> looks for the sqlr-listener-x file. I'm using the "sqlr-start -id ID
> -config CONFIGFILE [-localstatedir LOCALSTATEDIR]" form to start the
> listener and the connection daemons, and they work fine. I have them
> running and writing tmp files as well as debugging output in my home
> dir. So when I try to run "query -id ID -config MYCONFIG select ...",
> it just hangs forever. I looked in the debug files and saw the
> following:
> 
> tim@xyz debug: cat sqlr-listener.12775
> 
> 05/16/2008 22:57:44 PST listener [12775] : creating shared memory and semaphores
> 
>  ... blah blah blah ...
> 
> 05/16/2008 23:01:53 PST listener [12775] : forked a child: 12814
> 
> 05/16/2008 23:01:53 PST listener [12775] : waiting for client connection...
> 
> tim@xyz debug: cat sqlr-listener.12814
> 
> 05/16/2008 23:01:53 PST listener [12814] : getting authentication...
> 
> 05/16/2008 23:01:53 PST listener [12814] : 	listener-based
> authentication succeeded
> 
> 05/16/2008 23:01:53 PST listener [12814] : incrementing session count...
> 
> and then nothing ... it never gets incremented.
> 
> Is there really nothing I can do? I can't believe that there's a
> "-localstatedir" option for everything but the scaler. When I try to
> run the scaler, I get:
> 
> sqlr-scaler error:
> 	The file /var/cache/sqlrelay/tmp/sqlr-listener-sql1 was not found.
> 	This usually means that the sqlr-listener is not running.
> 	The sqlr-listener must be running for the sqlr-scaler to start.
> 
> Is there no way to tell it where my local tmp file is?
> 
> Thanks!
> 
> -Tim
> 
> -------------------------------------------------------------------------
> 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
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com