Re: [Sqlrelay-discussion] DBD Borkenpipe

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

I believe the issue is that you're aiming the script at mysql rather
than at sqlrelay.

MySQL listens on port 3307.  SQL Relay connects to mysql and listens on
whatever port you configure it to listen on in your sqlrelay.conf file's
port parameter; usually 9000 or similar.  So your script would need to
connect to that port:

$dbh=DBI->connect("dbi:SQLRelay:host=127.0.0.1;port=9000;debug=1","user","password") or die DBI->errstr;

I think you're connecting to mysql and sending it sqlrelay commands,
which confuse it and eventually mysql closes the connection.

David Muse
dav...@fi...

On Wed, 2007-10-17 at 11:24 +0200, nemux wrote:
> Hello all,
> 
> i'm trying to do some tests with sqlrelay i'm doing that on :
> 
> FreeBSD 4.2 
> mysql client 3
> Mysql server 5.1
> sqlrelay-0.35_1 (installed from ports)
> 
> sqlrelay starts without problems but when i use this simple perl
> script :
> 
> #!/usr/bin/perl
> use DBI;
> 
> $dbh=DBI->connect("dbi:SQLRelay:host=127.0.0.1;port=3307;debug=1","user","password") or die DBI->errstr;
> 
> $dbh->disconnect;
> 
> #perl test.pl
> Connecting to listener...
> Inet socket: 127.0.0.1:3307
> Authenticating with listener : user:password
> No authentication error.
> Must Not Reconnect.
> Authenticating with connection : user:password
> Broken pipe
> #
> 
> I have the same error bypassing DBD using SQLRelay.pm  :
> 
> $con=SQLRelay::Connection->new("127.0.0.1","3307","","user","password",0,1);
> $cur=SQLRelay::Cursor->new($con);
> 
> $con->ping();
> 
> #perl testSQLRelay.pl
> Broken pipe
> #
> 
> i use DBI::mysql on the same server without issues 
> 
> Someone know how can i solve this issue ?
> 
> Thanks.
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> _________________________________________________________________
> Need personalized email and website? Look no further. It's easy
> with Doteasy $0 Web Hosting! Learn more at www.doteasy.com