Re: [Sqlrelay-discussion] Testing sqlrelay's drop-in replacement libraries on Debian Wheezy

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

Hmmm.  The mysql 5.1 library should work with 5.5.  I have a client that 
I think it using it with 5.5, but I could be wrong about that.  It's 
possible that one of the MySQL internal structures changed between 5.1 
and 5.5 and the code needs to be updated to handle that.  Take a look at 
the file src/api/mysql/mysql.cpp.  Near the top there are several 
ifdef's for different versions of MySQL.  Compare the structures defined 
for 5.1 with the ones defined in the mysql headers for 5.5.  If the 
sizes look different, then that could be the problem.  Otherwise, you'd 
have to enable debug and trace through it.

I just looked at the code for the postgres drop-in library and I don't 
see a function that returns the protocol version, so that could be 
tricky to solve.  It might be returned in a struct or there could be 
some set of commands that get run or something.  I'll look into it.  It 
should be possible to get it working in an upcoming release.

Dave

On 01/18/2013 12:23 PM, Petros Moisiadis wrote:
> I' ve tested sqlrelay's drop-in replacement libraries for MySQL and
> PostgreSQL on Debian Wheezy (x86_64).
>
> The drop-in for MySQL does not seem to work. It just hangs when trying
> to connect with the mysql client program. It asks for password and after
> entering it, it freezes without ever giving back a mysql prompt. Maybe
> this is related to the fact that Debian Wheezy comes with mysql 5.5, but
> sqlrelay provides libraries up to 5.1? If this is not relevant, I would
> be glad to do any tests needed to narrow down the possible causes of the
> problem.
>
> The drop-in replacement library for PostgreSQL works when using the psql
> client program.
> However, it is not usable if trying to connect with psycopg2, the most
> popular library to interface with postgres from python. In particular,
> psycopg2 checks for the protocol version of the connection and if it is
> not 3, it exits. Maybe sqlrelay's implementation of postgres api does
> not support protocol version requests. Dave, if that is the case, would
> it be easy to include support for this type of requests in a following
> release of sqlrelay?
>
> ------------------------------------------------------------------------------
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>