sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] MySQL and BLOBs

[Devananda <kar...@ya...>]

Dear list,

A project I am currently working on requires that uploaded files be 
stored in MySQL for various purposes. Our application servers will be 
using SQL Relay to connect to MySQL 5.0. However, in testing, I have 
been unable to get SQL Relay to bind binary values to a prepared statement.

I've been combing through the SQL Relay source, and it looks like there 
_should_ be definitions for the ::inputBind* functions in 
src/connections/mysql/mysqlconnection.C (since there are definitions for 
those functions in the oracle and postgres connectors), but there are none.

In any case, here's a simple test case which fails for me:

-------

mysql> CREATE TABLE bin_test (id int(11) NOT NULL auto_increment, val 
mediumblob NOT NULL, PRIMARY KEY  (id) ) ;

-------

#!/usr/local/bin/php
<?php

$data="ab\x00de\x00";

# acquire a connection handle
$CON = 
sqlrcon_alloc("localhost",'','/tmp/sqlr-HMS','sqlruser','sqlrpass',0,1);
if (!$CON) {
    print "failed to get connection handle!\n";
    exit(1);
}

# acquire a cursor
$CUR = sqlrcur_alloc($CON);
if (!$CUR) {
    print "failed to get cursor!\n";
    exit(1);
}

sqlrcur_prepareQuery($CUR, 'INSERT INTO test.bin_test (val) VALUES 
(:data)');
if (!sqlrcur_inputBindBlob($CUR, 'data', $data, strlen($data))) {
    print "inputBindBlob failed\n";
    exit(1);
}

if (!sqlrcur_executeQuery($CUR)) {
    print "execute failed. Error: " . sqlrcur_errorMessage($CUR) . "\n";
    exit(1);
}

sqlrcur_free($CUR);
sqlrcon_free($CON);

exit(0);

?>

---------

When run, I get the following error message: "execute failed. Error: 
Column count doesn't match value count at row 1". Having started 
sqlrelay in debug mode, I see the following in the connection's log file 
(extra whitespace removed)
> new query
> handling query...
> getting query...
> querylength:
> 46
> query:
> INSERT INTO test.bin_test (val) VALUES (:data)
> getting query succeeded
> getting input binds...
> :data
> BLOB
> done getting input binds
> getting output binds...
> done getting output binds
> getting send column info...
> send column info
> done getting send column info...
> processing query...
> preparing/executing...
> commit or rollback check...
> done with commit or rollback check
> processing query failed
> done processing query
> handling error...
> returning error...
> failed to handle query: error
> done returning error
> done handling error...

When I alter the PHP code to call "sqlrcur_inputBind" instead of 
"sqlrcur_inputBindBlob", the query is successfully run, but the string 
is terminated at the first \x00 -- as expected for a C string.

Have I done something obviously wrong, or is the MySQL connector lacking 
this functionality?


Thanks in advance,
Devananda vdv

[Sqlrelay-discussion] php and apache with LD_PRELOAD

[Nick W. <woo...@ho...>]

Hi,

I am trying to get PHP to work with the drop in replacement libraries for 
MySQL.  I have setup the environment variable in my /etc/init.d/httpd PHP 
script to point to the correct library and when i set it manually in the 
shell and use mysql everything works fine.

On using php however, i get a Warning: mysql_connect() 
[function.mysql-connect]: Can't connect to MySQL server on '127.0.0.1' (4) 
in /var/www/vhosts/boggle.caterham.kudosdesigns.com/httpdocs/index.php on 
line 14
on trying to connect.

the getenv function does however return that the environment variable is set 
to:

/usr/lib/libmysql41sqlrelay.so

Have i setup PHP and Apache correctly to use the drop in replacement 
libraries or is there something else i should do?

Thanks,

Nick

[Sqlrelay-discussion] mysql proxy

[Nick W. <woo...@ho...>]

Hi All,

I am trying to setup SQL Relay to behave as an effective proxy for MySQL 
requests on any MySQL database.  I would like any person connecting to any 
database through mysql locally (192.168.51) through mysql.sock to connect 
out through SQL Relay to one of two back end servers - two nodes on a MySQL 
cluster (192.168.1.54 and 192.168.1.53).

I have setup SQLRelay with a configuration as described below:

<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
        <instance id="defaultid" port="3306" 
socket="/var/lib/mysql/mysql.sock" connections="1" maxconnections="6" 
dbase="mysql" maxqueuelength="0" growby="1" ttl="60" endofsession="commit" 
sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" 
authtier="database" handoff="pass">
                <users>
                </users>
                <connections>
                       <connection connectionid="kudos-file-linux-two" 
string="db=mysqlclustertest;user=root;password=XXXXXXXX;host=192.168.1.53;port=3306;" 
metric="1" behindloadbalancer="no" />
                <connection connectionid="kudos-file-linux-two" 
string="db=mysqlclustertest;user=root;password=XXXXXXXX;host=192.168.1.53;port=3306;" 
metric="1" behindloadbalancer="no" />
                </connections>
        </instance>

</instances>


I am having a few problems with this.  SQL relay seems to be mainly geared 
for connection to an individual database - is this correct?  With that in 
mind, i don't really want to specify a database in the connection string, 
but on reading the documentation there seems no other way.

I would really like for it to be able to connect to any database that is 
requested by the user through on the mysql proxy and for that to go off to 
the cluster.  (the authtier=database setting i presume would sort out any 
user being able to connect?)

Also, if i want to configure my proxy server to talk out using SQL Relay 
with the drop in libraries with PHP and Apache - is it just a case of 
modifying the /etc/init.d/httpd start up script with the LD_PRELOAD 
statement - or is it more complicated than this?

Any problems anyone can see with my configuration or ideas, please let me 
know!  I know someone has achieved what i am after ... but just not quite 
sure how they managed it!

Thanks,

Nick

[Sqlrelay-discussion] SQL Relay maillist test

[Toby L. <cn...@gm...>]

thanks

RE: [Sqlrelay-discussion] Server stops

[Pedro B. <pba...@in...>]

I reported that problem and with help from davide corio I managed to solve
that.
After that, me and another guy posted this problem of the server getting
real slow when no results where retrieved.

Don't know if you did anything else to your script besides adding "self" but
I tried it out and now when no results are retrieved it appears an error
without consuming the server. The error value states: 
-> len() of unsized object

Better this then a server completely stopped :)
Thanks for all the help!

Pedro Barbosa

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of David
Muse
Sent: segunda-feira, 22 de Maio de 2006 16:13
To: sql...@li...
Subject: RE: [Sqlrelay-discussion] Server stops

I believe that some other folks reported a similar problem with zope a
while ago and it turned out that the PySQLRDB.py program was missing a
"self" before some internal calls.

Try replacing your PySQLRDB.py file with the attached file.

Dave
dav...@fi...

On Tue, 2006-05-16 at 17:03 +0200, Davide Corio wrote:
> Il giorno mar, 16/05/2006 alle 15.56 +0100, Pedro Barbosa ha scritto:
> > Hi Davide, 
> > 
> > I tried to locate libct on my FC4 and all I found was:
> > 
> > /usr/lib/libct.so.3.0.0
> > /usr/lib/openoffice.org2.0/program/libctl680li.so
> > /usr/lib/libct.so.3
> > /usr/local/freetds/lib/libct.la
> > /usr/local/freetds/lib/libct.a
> > /usr/local/freetds/lib/libct.so.3.0.0
> > /usr/local/freetds/lib/libct.so
> > /usr/local/freetds/lib/libct.so.3
> > 
> > So this must not be the problem, right? 
> > Any other thoughts?  
> > 
> > P.S. I'm using sqlrelay 0.37.
> 
> Hi Pedro, I had to rebuild the sqlrelay 0.37 package provided with
> Debian against libct3, and now the problem seems to be solved.
> 
> Unfortunately I can't help you with Fedora :(
> 
> I think you can rebuild the srpm package or install the tgz archive
> directly.
> 

RE: [Sqlrelay-discussion] Server stops

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

I believe that some other folks reported a similar problem with zope a
while ago and it turned out that the PySQLRDB.py program was missing a
"self" before some internal calls.

Try replacing your PySQLRDB.py file with the attached file.

Dave
dav...@fi...

On Tue, 2006-05-16 at 17:03 +0200, Davide Corio wrote:
> Il giorno mar, 16/05/2006 alle 15.56 +0100, Pedro Barbosa ha scritto:
> > Hi Davide, 
> > 
> > I tried to locate libct on my FC4 and all I found was:
> > 
> > /usr/lib/libct.so.3.0.0
> > /usr/lib/openoffice.org2.0/program/libctl680li.so
> > /usr/lib/libct.so.3
> > /usr/local/freetds/lib/libct.la
> > /usr/local/freetds/lib/libct.a
> > /usr/local/freetds/lib/libct.so.3.0.0
> > /usr/local/freetds/lib/libct.so
> > /usr/local/freetds/lib/libct.so.3
> > 
> > So this must not be the problem, right? 
> > Any other thoughts?  
> > 
> > P.S. I'm using sqlrelay 0.37.
> 
> Hi Pedro, I had to rebuild the sqlrelay 0.37 package provided with
> Debian against libct3, and now the problem seems to be solved.
> 
> Unfortunately I can't help you with Fedora :(
> 
> I think you can rebuild the srpm package or install the tgz archive
> directly.
> 

RE: [Sqlrelay-discussion] Server stops

[Davide C. <dav...@re...>]

Il giorno mar, 16/05/2006 alle 15.56 +0100, Pedro Barbosa ha scritto:
> Hi Davide,=20
>=20
> I tried to locate libct on my FC4 and all I found was:
>=20
> /usr/lib/libct.so.3.0.0
> /usr/lib/openoffice.org2.0/program/libctl680li.so
> /usr/lib/libct.so.3
> /usr/local/freetds/lib/libct.la
> /usr/local/freetds/lib/libct.a
> /usr/local/freetds/lib/libct.so.3.0.0
> /usr/local/freetds/lib/libct.so
> /usr/local/freetds/lib/libct.so.3
>=20
> So this must not be the problem, right?=20
> Any other thoughts? =20
>=20
> P.S. I'm using sqlrelay 0.37.

Hi Pedro, I had to rebuild the sqlrelay 0.37 package provided with
Debian against libct3, and now the problem seems to be solved.

Unfortunately I can't help you with Fedora :(

I think you can rebuild the srpm package or install the tgz archive
directly.

--=20
Davide Corio                                   dav...@re...
Redomino S.r.l.            C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/

RE: [Sqlrelay-discussion] Server stops

[Pedro B. <pba...@in...>]

Hi Davide, 

I tried to locate libct on my FC4 and all I found was:

/usr/lib/libct.so.3.0.0
/usr/lib/openoffice.org2.0/program/libctl680li.so
/usr/lib/libct.so.3
/usr/local/freetds/lib/libct.la
/usr/local/freetds/lib/libct.a
/usr/local/freetds/lib/libct.so.3.0.0
/usr/local/freetds/lib/libct.so
/usr/local/freetds/lib/libct.so.3

So this must not be the problem, right? 
Any other thoughts?  

P.S. I'm using sqlrelay 0.37.

Cheers
Pedro Barbosa


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Davide
Corio
Sent: segunda-feira, 15 de Maio de 2006 11:38
To: sql...@li...
Subject: Re: [Sqlrelay-discussion] Server stops

Il giorno lun, 15/05/2006 alle 11.16 +0100, Pedro Barbosa ha scritto:
> Hi!
> 
>  
> 
> I'm using zope and a DB in sql server and when a select is made that
> doesn't return any records the server almost stops and my CPU usage
> grows exponentially, working on it becomes almost impossible. That is
> until I stop the zope instance.

Hi Pedro,
it seems to be a problem related to libct1, you have to use libct3
(maybe)
-- 
Davide Corio                                   dav...@re...
Redomino S.r.l.            C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/

Re: [Sqlrelay-discussion] problems with empty resultset

[Davide C. <dav...@re...>]

Il giorno ven, 12/05/2006 alle 13.05 +0200, Davide Corio ha scritto:
> Hi *,
> I'm using sqlrelay 0.37-1 with Zope.
>=20
> When I run a select which returns an empty resultset, the
> sqlr-connection keeps waiting for something and takes the 100% of the
> CPU.
>=20
> is it an issue?

I had to rebuild debian packages using libct3 instead of libct1


--=20
Davide Corio                                   dav...@re...
Redomino S.r.l.            C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/

Re: [Sqlrelay-discussion] Server stops

[Davide C. <dav...@re...>]

Il giorno lun, 15/05/2006 alle 11.16 +0100, Pedro Barbosa ha scritto:
> Hi!
>=20
> =20
>=20
> I=FFm using zope and a DB in sql server and when a select is made that
> doesn=FFt return any records the server almost stops and my CPU usage
> grows exponentially, working on it becomes almost impossible. That is
> until I stop the zope instance.

Hi Pedro,
it seems to be a problem related to libct1, you have to use libct3
(maybe)
--=20
Davide Corio                                   dav...@re...
Redomino S.r.l.            C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/

[Sqlrelay-discussion] Server stops

[Pedro B. <pba...@in...>]

Hi!

=20

I=92m using zope and a DB in sql server and when a select is made that =
doesn=92t
return any records the server almost stops and my CPU usage grows
exponentially, working on it becomes almost impossible. That is until I =
stop
the zope instance.

=20

Did anybody had similar problems?

Any help would be great

=20

=20

Pedro Barbosa,

=20

Servi=E7o de Informa=E7=E3o de Gest=E3o=20
INESC Porto - Laborat=F3rio Associado

=20

Campus da FEUP
R. Dr. Roberto Frias, n=BA 378
4200-465 PORTO
Ph :+351 22 209 4131
http://www.inescporto.pt
   =20

=20

[Sqlrelay-discussion] problems with empty resultset

[Davide C. <dav...@re...>]

Hi *,
I'm using sqlrelay 0.37-1 with Zope.

When I run a select which returns an empty resultset, the
sqlr-connection keeps waiting for something and takes the 100% of the
CPU.

is it an issue?

--=20
Davide Corio                                   dav...@re...
Redomino S.r.l.            C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/

Re: [Sqlrelay-discussion] SQLRelay and RaiseError problem

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

SQL Relay catches DB unavailable errors internally and attempts to
re-login over and over until the DB comes back up and then it runs the
query then.  So it never returns that particular error.

However, it should raise an exception for other errors, does it do that?

David Muse
dav...@fi...

On Fri, 2006-04-28 at 13:17 +0200, Albert Vila wrote:
> Hello,
> 
> I'm testing the SQLRelay with the perl DBI module and I have a  
> problem. The connection looks like:
> 
>    if ($sqlrelay{$hostKey}) {
> 
>     # SQLRelay connections
>      $self->{CONNECTION} = DBI->connect("DBI:SQLRelay:host=$host;port= 
> $port;", "$usuariMysql", "$pwdMysql", { RaiseError => 1, PrintError  
> => 0});
>    } else {
> 
>      # Normal connections using the DBI module
>      $self->{CONNECTION} = DBI->connect("DBI:$sgMysql:$database;host= 
> $host", "$usuariMysql", "$pwdMysql", { RaiseError => 1, PrintError =>  
> 0)};
>    }
> 
> And the code to perform an action looks like:
> 
>    eval {
>      $result = $connection->selectall_arrayref($query);
>    };
> 
>    # Error control
>    if ($@) {
>      my $error = $@;
>      if ($error =~ m/MySQL server has gone away/ || $error =~ m/Lost  
> connection to MySQL server during query/) {
>        # Reconnection
>        $self->doConnection($self->{DATABASE}, $self->{HOSTKEY});
>        $result = $connection->selectall_arrayref($query);
>      }
>    }
>    return $result;
> 
> However, using the normal DBI connection, the RaiseError works and I  
> can catch the exception. Using the SQLRelay I can't catch the  
> Exception. Is there a way to catch this Exceptions?
> 
> 
> Thanks in advance.
> 
> Albert
> 
> 
> 
> -------------------------------------------------------
> 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
> 

Re: [Sqlrelay-discussion] installing problem: sqlrelay on mac os x and/or php 5.1.2

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

Hey Harald,

I need to buy a mac :)

I once got an older version of SQL Relay working on Mac OS X, but I
don't remember what version of SQL Relay, what version of Mac OS X or
what version of perl, python, php, etc.

Back then, I ran Mac OS under PearPC, and though it was slow, it worked
well enough for me.  Since then, I upgraded my machine to a 64-bit
platform and haven't gotten PearPC to work on it yet.

>From that output, it looks like one of the libraries isn't getting built
properly.  I'd need to poke around on an actual OS X installation to see
what's going on.  In the second case, it looks like there's a stub
library that needs to be linked in.  Again, I'd need to poke around to
fix it.

I'll make a more concerted effort to get PearPC running again, or go buy
a mac.  One way or another 0.38 should support OS X.  Unfortunately, you
may have to wait until then.

Dave
dav...@fi...


On Sat, 2006-04-29 at 01:09 +0200, Harald Lapp wrote:
> hello,
>=20
> i'm new to sqlrelay and i have several question, because
> i can not get it to work on mac os x with php 5.1.2.
>=20
> i've first tried sqlrelay-0.37 which compiled without any
> problems but when i tried
>=20
> make install
>=20
> i got the following error:
>=20
> make -C src install
> make -C util install
> ../../mkinstalldirs /usr/local/firstworks/lib
> /bin/sh ../../libtool --mode=3Dinstall ../../install-sh -c
> libsqlrutil.la /usr/local/firstworks/lib
> libtool: install: `libsqlrutil.la' is not a valid libtool archive
> Try `libtool --help --mode=3Dinstall' for more information.
> make[2]: *** [install] Error 1
> make[1]: *** [install] Error 2
> make: *** [install] Error 2
>=20
>=20
> than i noticed on the mailing-list, that there's already sqlrelay-0.38-=
pre1
> available. but with that version i even can't compile the php module:
>=20
> /usr/bin/ld: Undefined symbols:
> __array_init
> __convert_to_string
> __emalloc
> __estrndup
> __zend_list_delete
> __zval_copy_ctor_func
> _add_assoc_long_ex
> _add_assoc_null_ex
> _add_assoc_stringl_ex
> _add_next_index_long
> _add_next_index_null
> _add_next_index_string
> _add_next_index_stringl
> _convert_to_array
> _convert_to_double
> _convert_to_long
> _zend_fetch_resource
> _zend_get_parameters_ex
> _zend_hash_index_find
> _zend_hash_num_elements
> _zend_printf
> _zend_register_list_destructors_ex
> _zend_register_resource
> _zend_wrong_param_count
> collect2: ld returned 1 exit status
> make[4]: *** [libsql_relay.la] Error 1
>=20
>=20
> is there anybody who runs sqlrelay with mac os x
> and/or php 5.1.2?
>=20
> many thanks in advance,
>=20
> kind regards
>=20
> Harald Lapp
>=20
> --
> http://www.pixelquelle.de/
> Deine kostenlose Bilddatenbank f=C3=BCr lizenzfreie Fotos
>=20
>=20
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, securit=
y?
> 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 Geron=
imo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=120709&bid&3057&dat=12164=
2
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20

Re: [Sqlrelay-discussion] configure does not recognize PHP

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

The configure script looks for the php-config program, which is part of
the php development package.

If you're running on an rpm-based machine, you may need to install the
php-devel rpm.  If on debian, you may need to install the php-dev deb.

If you built php from source and installed it in a place that the
configure script doesn't generally look, you may have to use the
--with-php-prefix option to specify where you installed it.

If none of that works, let me know and we'll troubleshoot it further.

David Muse
dav...@fi...

On Wed, 2006-05-10 at 17:47 +0000, Alexandru Cristescu wrote:
> Hello,
> 
> I'm having trouble building sqlrelay. When I run the ./configure script
> it informs me that PHP will not be built. I do have php installed, "php
> -v" yelds the following output:
> 
> 
> PHP 4.3.9 (cgi) (built: Oct 20 2004 14:52:04)
> Copyright (c) 1997-2004 The PHP Group
> Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
> 
> 
> The docs do not clearly state what exactly I do need, so any help here
> would be apreciated.
> 
> 
> 
> -------------------------------------------------------
> 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
> 

Re: [Sqlrelay-discussion] cache manager Warning

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

Hello Rene,

Looks like there might be 2 problems.  The "Warning: using default id"
means that it couldn't find a configuration for msdetest in the
sqlrelay.conf file.

It looks like you have it configured not to start any connections and
add them as needed (connections=0, maxconnections>0).  The warning is
probably getting printed when the first query is run.

Make sure the sqlrelay.conf file is readable by whatever user you've
configured SQL Relay to run as (the runasuser/runasgroup parameters), as
the sqlr-scaler process needs to be able to read the file in order to
find the msdetest configuration when it starts an sqlr-connection
process.

I'm not sure about the EXEC problem.  Try running "debug on;" before
running your query in the sqlrsh program and see if the debug is
helpful.  If not, send it to me and it may help figure out what's going
on.

David Muse
dav...@fi...

On Wed, 2006-05-10 at 17:20 -0700, Rene Maldonado wrote:
> Hi all,
> 
>   I'm starting sqlrelay, but when it starts the cache manager I get the 
> next message:
> Starting scaler:
>   sqlr-scaler  -id msdetest -config /usr/local/firstworks/etc/sqlrelay.conf
> 
> Starting cache manager:
>   sqlr-cachemanager
> *Warning: using default id.*
> 
> so far, no problem, if I execute (from the sqlrsh)  a Select statement, 
> it works OK,
> But, if I execute an EXEC procedureXX param1, param2;
> it do not return the prompt again...
> 
> Any idea what could be wrong?
> 
> Thanks
>   Rene
> 
> 
> 
> 
> 
> -------------------------------------------------------
> 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
> 

Re: [Sqlrelay-discussion] configure with tcl

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

The configure script looks pretty hard for the tcl headers and
libraries.  If they're in an unusual spot, you may need to use the
--with-tcl-include and --with-tcl-libraries option when running it.

If you're running an rpm-based system, make sure you have the tcl-devel
rpm installed.  On debian-based systems, I believe there are tcl-dev
deb's that need to be installed.

Dave
dav...@fi...

On Mon, 2006-05-08 at 18:41 -0700, Rene Maldonado wrote:
> Hi,
>    How do I make sure to configure sqlrelay with tcl support?
> 
> I have installed tcl 8.4, but the configure script don't recognizes tcl.
> 
> Thanks in advance.
> 
>   Rene
> 
> 
> 
> -------------------------------------------------------
> 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
> 

[Sqlrelay-discussion] cache manager Warning

[Rene M. <rma...@bt...>]

Hi all,

  I'm starting sqlrelay, but when it starts the cache manager I get the 
next message:
Starting scaler:
  sqlr-scaler  -id msdetest -config /usr/local/firstworks/etc/sqlrelay.conf

Starting cache manager:
  sqlr-cachemanager
*Warning: using default id.*

so far, no problem, if I execute (from the sqlrsh)  a Select statement, 
it works OK,
But, if I execute an EXEC procedureXX param1, param2;
it do not return the prompt again...

Any idea what could be wrong?

Thanks
  Rene

[Sqlrelay-discussion] configure does not recognize PHP

[Alexandru C. <ale...@qu...>]

Hello,

I'm having trouble building sqlrelay. When I run the ./configure script
it informs me that PHP will not be built. I do have php installed, "php
-v" yelds the following output:


PHP 4.3.9 (cgi) (built: Oct 20 2004 14:52:04)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies


The docs do not clearly state what exactly I do need, so any help here
would be apreciated.

[Sqlrelay-discussion] configure with tcl

[Rene M. <rma...@bt...>]

Hi,
   How do I make sure to configure sqlrelay with tcl support?

I have installed tcl 8.4, but the configure script don't recognizes tcl.

Thanks in advance.

  Rene

[Sqlrelay-discussion] installing problem: sqlrelay on mac os x and/or php 5.1.2

[Harald L. <har...@gm...>]

hello,

i'm new to sqlrelay and i have several question, because
i can not get it to work on mac os x with php 5.1.2.

i've first tried sqlrelay-0.37 which compiled without any
problems but when i tried

make install

i got the following error:

make -C src install
make -C util install
../../mkinstalldirs /usr/local/firstworks/lib
/bin/sh ../../libtool --mode=3Dinstall ../../install-sh -c
libsqlrutil.la /usr/local/firstworks/lib
libtool: install: `libsqlrutil.la' is not a valid libtool archive
Try `libtool --help --mode=3Dinstall' for more information.
make[2]: *** [install] Error 1
make[1]: *** [install] Error 2
make: *** [install] Error 2


than i noticed on the mailing-list, that there's already sqlrelay-0.38-pre1
available. but with that version i even can't compile the php module:

/usr/bin/ld: Undefined symbols:
__array_init
__convert_to_string
__emalloc
__estrndup
__zend_list_delete
__zval_copy_ctor_func
_add_assoc_long_ex
_add_assoc_null_ex
_add_assoc_stringl_ex
_add_next_index_long
_add_next_index_null
_add_next_index_string
_add_next_index_stringl
_convert_to_array
_convert_to_double
_convert_to_long
_zend_fetch_resource
_zend_get_parameters_ex
_zend_hash_index_find
_zend_hash_num_elements
_zend_printf
_zend_register_list_destructors_ex
_zend_register_resource
_zend_wrong_param_count
collect2: ld returned 1 exit status
make[4]: *** [libsql_relay.la] Error 1


is there anybody who runs sqlrelay with mac os x
and/or php 5.1.2?

many thanks in advance,

kind regards

Harald Lapp

--
http://www.pixelquelle.de/
Deine kostenlose Bilddatenbank f=FCr lizenzfreie Fotos

[Sqlrelay-discussion] SQLRelay and RaiseError problem

[Albert V. <av...@im...>]

Hello,

I'm testing the SQLRelay with the perl DBI module and I have a  
problem. The connection looks like:

   if ($sqlrelay{$hostKey}) {

    # SQLRelay connections
     $self->{CONNECTION} = DBI->connect("DBI:SQLRelay:host=$host;port= 
$port;", "$usuariMysql", "$pwdMysql", { RaiseError => 1, PrintError  
=> 0});
   } else {

     # Normal connections using the DBI module
     $self->{CONNECTION} = DBI->connect("DBI:$sgMysql:$database;host= 
$host", "$usuariMysql", "$pwdMysql", { RaiseError => 1, PrintError =>  
0)};
   }

And the code to perform an action looks like:

   eval {
     $result = $connection->selectall_arrayref($query);
   };

   # Error control
   if ($@) {
     my $error = $@;
     if ($error =~ m/MySQL server has gone away/ || $error =~ m/Lost  
connection to MySQL server during query/) {
       # Reconnection
       $self->doConnection($self->{DATABASE}, $self->{HOSTKEY});
       $result = $connection->selectall_arrayref($query);
     }
   }
   return $result;

However, using the normal DBI connection, the RaiseError works and I  
can catch the exception. Using the SQLRelay I can't catch the  
Exception. Is there a way to catch this Exceptions?


Thanks in advance.

Albert

Re: [Sqlrelay-discussion] performance statistics

[Devananda <kar...@ya...>]

Devananda wrote:
> Rodney Holm wrote:
>> Here is a short thread regarding the implementation of statistics 
>> gathering.
>>
>> Unfortunately Im not able to work on this anytime soon, hopefully 
>> this information will come in handy to others looking to add this 
>> most desirable feature to sqlrelay.
>>
> Rodney,
>
> Thank you for sending me that thread. It gave me a starting point, and 
> I've been digging into the source for a few hours now. I've reached a 
> bit of a wall, however -- how does the sqlrconnection class relate to 
> the sqlrconnection_svr class? My understanding of it is that the 
> former is instantiated w/in each API's library and used to connect to 
> the sqlr connection daemon, whereas the latter is how each sqlr 
> connection daemon actually connects to the particular database server.
>
> I was hoping to modify the sqlrsh tool just enough to get it to read 
> info from the shared memory segment, but am having (most likely 
> conceptual) trouble figuring out how to get that information -- sqlrsh 
> only has an instance of sqlrconnection, so I'm guessing that I will 
> need to create interfaces in both these classes to request/receive the 
> status data which will be stored in the shared mem segment.
>
> Any thoughts?
>
> Regards,
> Devananda
I was looking at this from the wrong perspective initially.

While I'm sure there's plenty of room for improvement in what I've done, 
I do have a working CLI program which reads from the shmdata, and I have 
modified the mysql connector to update that data as appropriate. Feels 
like quite a triumph, tbh - it's been about 7 years since I wrote any 
serious c/c++!

In brief, what I've done is create another 'connections' class called 
"status", with nearly all the functions replaced by stubs. I rearranged 
sqlrconnection_svr::initConnection() slightly, so that the shared memory 
is initialized before the attempt (or failure) to connect to the actual 
database, thus allowing the status class access to shared memory even 
though it will not connect to any database. Of course, I added some 
counters to the shmdata struct itself. Adding counters, and enabling 
other connectors to interact with the counters should be very simple -- 
within any class derived from sqlrconnection_svr, it is 
"statistics->$param(++|--)", and within a class derived from 
sqlrcursor_svr, it is "conn->statistics->$param(++|--)".

What is the proper way for me to upload and share these changes? I have 
a sourceforge cvs account already (I created a module for mysql 
administration, http://sourceforge.net/projects/mycat/, though work has 
kept me from updating that project recently). If it's better that I 
create a diff and send that, or something else, let me know.

Cheers,
Devananda

[Sqlrelay-discussion] Server becames slow

[Pedro B. <pba...@in...>]

Hi!

=20

I=92ve been having some problems when querying a sql server database =
from a
FC4 box.=20

If I right any Portuguese characters on the sql string or if the sql is
about to return 0 results my server gets all messed up and if I don=92t
restart zope my server gets very slow.

I=92m assuming I have to define the charset to iso-8859-1 and language =
to PT
?!?!?

What about when the sql returns no records?

=20

PS. I can do a select statement with portugese characters trough tsql =
from
freetds.

=20

Any thoughts?

=20

Thanks

=20

=20

Pedro Barbosa,

=20

Servi=E7o de Informa=E7=E3o de Gest=E3o=20
INESC Porto - Laborat=F3rio Associado

=20

Campus da FEUP
R. Dr. Roberto Frias, n=BA 378
4200-465 PORTO
Ph :+351 22 209 4131
http://www.inescporto.pt
   =20

=20

Re: [Sqlrelay-discussion] performance statistics

[Devananda <kar...@ya...>]

Rodney Holm wrote:
> Here is a short thread regarding the implementation of statistics 
> gathering.
>
> Unfortunately Im not able to work on this anytime soon, hopefully this 
> information will come in handy to others looking to add this most 
> desirable feature to sqlrelay.
>
Rodney,

Thank you for sending me that thread. It gave me a starting point, and 
I've been digging into the source for a few hours now. I've reached a 
bit of a wall, however -- how does the sqlrconnection class relate to 
the sqlrconnection_svr class? My understanding of it is that the former 
is instantiated w/in each API's library and used to connect to the sqlr 
connection daemon, whereas the latter is how each sqlr connection daemon 
actually connects to the particular database server.

I was hoping to modify the sqlrsh tool just enough to get it to read 
info from the shared memory segment, but am having (most likely 
conceptual) trouble figuring out how to get that information -- sqlrsh 
only has an instance of sqlrconnection, so I'm guessing that I will need 
to create interfaces in both these classes to request/receive the status 
data which will be stored in the shared mem segment.

Any thoughts?

Regards,
Devananda