Re: [Sqlrelay-discussion] CVS head seems to be broken / need a version that works with MySQL 4.1.x

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

After starting the sqlrelay daemons, you need to use the sqlrelay client
program sqlrsh rather than the mysql client program.  It works similarly
to the mysql client program but speaks sqlrelay protocol rather than
mysql protocol.

You could also use the mysql client program and sqlrelay's
drop-in-replacement library for mysql:
http://sqlrelay.sourceforge.net/sqlrelay/dropin/mysql.html

There was a bug in sqlrelay CVS though that would cause it not to log in
to the database.  I fixed that last night.

Dave
dav...@fi...

On Mon, 2006-12-11 at 12:05 -1000, Joshua Hoblitt wrote:
> I've just updated rudiments & sqlrelay from CVS head and switch to MySQL
> 5.0.27. The good news is that SQLRelay is no longer segfaulting.  The bad
> news is that it will not connect to the MySQL server.
> 
> --
> mysql -u ipp -p ipp -P9000  --protocol=TCP
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 0 to server version: 5.0.0
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> show tables;
> ERROR:
> Couldn't connect to the databaseconnection daemon.
> Tried unix port /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/tmp/sockets/6Tried inet port -1795
> --
> 
> Is the that the right socket?  Shouldn't it be connecting to port 9000?
> Why isn't it looking at /tmp/sqlrelay.socket?  How do you pass
> configuration information to the client lib?  Is there a type converion
> issue in in the way the port # is handled? "-1795" seems to imply that
> the port setting is being corrupted somewhere.
> 
> sqlrelay.conf
> --
> <?xml version="1.0"?>
> <instances>
>     <instance id="ipp" port="9000" unixport="/tmp/sqlrelay.socket" dbase="mysql" connections="1" maxconnections="1" maxqueuelength="1" growby="1" ttl="60" endofsession="rollback" sessiontimeout="60" runasuser="jhoblitt" runasgroup="users" cursors="5" authtier="listener" handoff="reconnect" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="32768" maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0">
>         <users>
>             <user user="ipp" password="X"/>
>         </users>
>         <connections>
>             <connection connectionid="localmysql" string="user=ipp;password=X;db=ipp" metric="1" behindloadbalancer="1"/>
>         </connections>
>     </instance>
> </instances>
> --
> 
> Thanks,
> 
> -J
> 
> --
> On Tue, Oct 17, 2006 at 03:11:06PM -1000, Joshua Hoblitt wrote:
> > Hello,
> > 
> > I just discovered SQL Relay and have been trying to get it work for the
> > first time.  It seems that the latest stable release, 0.37.1, is
> > completely incompatible with MySQL 4.1.20.  Eg.,
> > 
> >     mysql -u X -p X -P9000
> >     Enter password:
> >     Debugging to:
> >     /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/debug/sqlr-listener.15087
> >     Segmentation fault
> > 
> > I dug through this list's archives and found a thread here:
> > 
> >     http://sourceforge.net/mailarchive/message.php?msg_id=12572938
> > 
> > that suggests there are some known issues with 0.37.1 & Mysql 4.1.x,
> > even if of a slightly different nature.  So I tried to build from CVS
> > and got this compilation error:
> > 
> >  g++ -Wall -pipe -pthread
> > -DTMP_DIR=\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/tmp\"
> > -DDEBUG_DIR=\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/debug\"
> > -DDEFAULT_CONFIG_FILE=\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//etc/sqlrelay.conf\"
> > -I./ -I../../ -I../../src/common -pthread -c cmdline.C  -fPIC -DPIC -o
> > .libs/cmdline.o
> > cmdline.C: In member function 'void cmdline::setId()':
> > cmdline.C:20: error: 'getValue' was not declared in this scope
> > cmdline.C: In member function 'void cmdline::setConfig()':
> > cmdline.C:30: error: 'getValue' was not declared in this scope
> > cmdline.C: In member function 'void cmdline::setLocalStateDir()':
> > cmdline.C:39: error: 'getValue' was not declared in this scope
> > make[2]: *** [cmdline.lo] Error 1
> > make[2]: Leaving directory `/home/moanui/jhoblitt/tmp/sqlrelay/src/util'
> > make[1]: *** [all] Error 2
> > make[1]: Leaving directory `/home/moanui/jhoblitt/tmp/sqlrelay/src'
> > make: *** [all] Error 2
> > 
> > Does this error leap out and anyone or should I take stab at fixing it?
> > 
> > Cheers,
> > 
> > -J
> > 
> > --
> 
> 
> 
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion