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

[Adrian-Cristian G. <adr...@gm...>]

I have the same problem. Try instal 0.39.4. For me it works. The 0.40 keeps
give me the same problem over and over.

2009/3/23 Luis Mauricio Calderon Castro <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. Sign up today.<http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008>
>
>
> ------------------------------------------------------------------------------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>