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

[Joshua H. <jho...@if...>]

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=3DTCP
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/sqlrela=
y/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=3D"1.0"?>
<instances>
    <instance id=3D"ipp" port=3D"9000" unixport=3D"/tmp/sqlrelay.socket" db=
ase=3D"mysql" connections=3D"1" maxconnections=3D"1" maxqueuelength=3D"1" g=
rowby=3D"1" ttl=3D"60" endofsession=3D"rollback" sessiontimeout=3D"60" runa=
suser=3D"jhoblitt" runasgroup=3D"users" cursors=3D"5" authtier=3D"listener"=
 handoff=3D"reconnect" deniedips=3D"" allowedips=3D"" debug=3D"none" maxque=
rysize=3D"65536" maxstringbindvaluelength=3D"32768" maxlobbindvaluelength=
=3D"71680" idleclienttimeout=3D"-1" maxlisteners=3D"-1" listenertimeout=3D"=
0">
        <users>
            <user user=3D"ipp" password=3D"X"/>
        </users>
        <connections>
            <connection connectionid=3D"localmysql" string=3D"user=3Dipp;pa=
ssword=3DX;db=3Dipp" metric=3D"1" behindloadbalancer=3D"1"/>
        </connections>
    </instance>
</instances>
--

Thanks,

-J

--
On Tue, Oct 17, 2006 at 03:11:06PM -1000, Joshua Hoblitt wrote:
> Hello,
>=20
> 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.,
>=20
>     mysql -u X -p X -P9000
>     Enter password:
>     Debugging to:
>     /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/debug/sq=
lr-listener.15087
>     Segmentation fault
>=20
> I dug through this list's archives and found a thread here:
>=20
>     http://sourceforge.net/mailarchive/message.php?msg_id=3D12572938
>=20
> 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:
>=20
>  g++ -Wall -pipe -pthread
> -DTMP_DIR=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrela=
y/tmp\"
> -DDEBUG_DIR=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlre=
lay/debug\"
> -DDEFAULT_CONFIG_FILE=3D\"/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
>=20
> Does this error leap out and anyone or should I take stab at fixing it?
>=20
> Cheers,
>=20
> -J
>=20
> --



> -------------------------------------------------------------------------
> 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 ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion