[Sqlrelay-discussion] Running sqlr-scaler locally

[Tim P. <ti...@gm...>]

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