[Sqlrelay-discussion] sqlr-start; sqlr-listener problems

[Luis M. C. C. <lmc...@ho...>]

Hi!!
I’m having problems with the slr-start comand. Because the sqlr-listener command doesn’t create the “sqlr-listener-example” file needed by the sqlr-scaler command.
 
[root@localhost bin]# ./sqlr-start -debug -id example -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var
 
Starting listener:
  sqlr-listener -id example -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.718
 
Starting 3 connections to db1 :
  sqlr-connection-mysql -id example -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.720
  sqlr-connection-mysql -id example -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.722
  sqlr-connection-mysql -id example -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.724
 
Starting scaler:
  sqlr-scaler -id example -debug  -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var
 
sqlr-scaler error: 
        The file /usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-example 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.
 
 
sqlr-scaler failed to start.
 
 
Thanks to MP3.com for sponsoring: 
        Clustered/Replicated database support.
        Perl API.
Thanks to FeedLounge for sponsoring: 
        Query routing and filtering.
 
 
However, if I execute the command by itself, the “sqlr-listener-example” is created successfully.
 
But when trying to access the database with the command, the response is a failure.
[root@localhost bin]# sqlrsh 192.168.1.123 9000 "" user1 password1
SQLRShell - Version 0.22
        Connected to: 192.168.1.123:9000 as user1
 
        type help; for a help.
 
0> ping;
        The database is down.
 
Also, in the sqlrelay.conf file I got this configuration.
<instance id="example" port="9000" socket="/tmp/examplesocket" dbase="mysql"
 
Does this means that a file called “/tmp/examplesocket” has to be created? Because I don’t see it anywhere.
 
Thanks.
 
Atte
Luis Mauricio Calderon Castro.
_________________________________________________________________
Windows Live Hotmail now works up to 70% faster.
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008