sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] Can't bind undef to variable with Perl DBI

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

Thanks Tim, I'll apply this patch and get it into the next release.

Dave
dav...@fi...

On Fri, 2007-02-02 at 15:57 +0000, Tim Bunce wrote:
> On Fri, Feb 02, 2007 at 10:32:21AM +0000, Tim Bunce wrote:
> > On Fri, Feb 02, 2007 at 01:36:30PM +1100, ja...@th... wrote:
> > > Hi all,
> > > 
> > > I've recently started using sqlrelay's DBI driver to connect Perl to
> > > Oracle (sqlrelay 0.38). I find that I can't bind NULL values (undef,
> > > in Perl) to a prepared statement.
> > 
> > > Looking at the source code, I see that src/api/perl/Cursor/Cursor.xs
> > > tries to detect NULLness of bind values by comparing the SV's address
> > > to &sv_undef. I don't think that this is right - on my machine (Perl
> > > 5.8.4 on Linux) the comparison fails even thought the bind value is
> > > null.
> > > 
> > > I think the right way to check whether the SV structure contains undef
> > > is to use the SvOK macro. 
> > 
> > > Does anyone have any further thoughts on this?
> > 
> > Looks good to me.
> > 
> > Tim.
> > 
> > p.s. I've have some fixes to DBD::SQLRelay I need to dig out and post here.
> 
> I've attached it to this email.
> 
> These changes came from some work I did for Shopzilla to evaluate
> sqlrelay for use with Sybase.  I did that by setting the DBI_AUTOPROXY
> environment variable to refer to DBD::SQLRelay and then running
> DBD::Sybase's own test suite.
> 
> I'd recommend that approach to anyone looking to use DBD::SQLRelay.
> 
> DBD::SQLRelay still needs more love, but it won't be getting any more
> from me in the near future. Shopzilla decided not to use sqlrelay for
> their sybase application and are instead going to use the new DBD::Gofer
> driver that's part of DBI 1.54.
> 
> Tim.
> -------------------------------------------------------------------------
> 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] Can't bind undef to variable with Perl DBI

[Tim B. <Tim...@po...>]

On Fri, Feb 02, 2007 at 10:32:21AM +0000, Tim Bunce wrote:
> On Fri, Feb 02, 2007 at 01:36:30PM +1100, ja...@th... wrote:
> > Hi all,
> > 
> > I've recently started using sqlrelay's DBI driver to connect Perl to
> > Oracle (sqlrelay 0.38). I find that I can't bind NULL values (undef,
> > in Perl) to a prepared statement.
> 
> > Looking at the source code, I see that src/api/perl/Cursor/Cursor.xs
> > tries to detect NULLness of bind values by comparing the SV's address
> > to &sv_undef. I don't think that this is right - on my machine (Perl
> > 5.8.4 on Linux) the comparison fails even thought the bind value is
> > null.
> > 
> > I think the right way to check whether the SV structure contains undef
> > is to use the SvOK macro. 
> 
> > Does anyone have any further thoughts on this?
> 
> Looks good to me.
> 
> Tim.
> 
> p.s. I've have some fixes to DBD::SQLRelay I need to dig out and post here.

I've attached it to this email.

These changes came from some work I did for Shopzilla to evaluate
sqlrelay for use with Sybase.  I did that by setting the DBI_AUTOPROXY
environment variable to refer to DBD::SQLRelay and then running
DBD::Sybase's own test suite.

I'd recommend that approach to anyone looking to use DBD::SQLRelay.

DBD::SQLRelay still needs more love, but it won't be getting any more
from me in the near future. Shopzilla decided not to use sqlrelay for
their sybase application and are instead going to use the new DBD::Gofer
driver that's part of DBI 1.54.

Tim.

Re: [Sqlrelay-discussion] Can't bind undef to variable with Perl DBI

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

Yeah, it looks like my test script doesn't even test NULL binds.  I'll
apply this patch (and any that Tim posts), upgrade my test script and
get them into the next release.

Thanks!

David Muse
dav...@fi...

On Fri, 2007-02-02 at 13:36 +1100, ja...@th... wrote:
> Hi all,
> 
> I've recently started using sqlrelay's DBI driver to connect Perl to
> Oracle (sqlrelay 0.38). I find that I can't bind NULL values (undef,
> in Perl) to a prepared statement.
> 
> For instance, the following example produces the warning "ORA-01008:
> not all variables bound" when run against a test_table.
> 
> # ------------------------------------------------------------
> DBI->trace(1);
> 
> $sql = "insert into test_table ( count ) values ( ? )";
> 
> $c = DBI->connect(...) ;
> 
> $s = $c->prepare($sql);
> 
> $s->bind_param(1, undef);
> $s->execute;
> # ------------------------------------------------------------
> 
> Looking at the source code, I see that src/api/perl/Cursor/Cursor.xs
> tries to detect NULLness of bind values by comparing the SV's address
> to &sv_undef. I don't think that this is right - on my machine (Perl
> 5.8.4 on Linux) the comparison fails even thought the bind value is
> null.
> 
> I think the right way to check whether the SV structure contains undef
> is to use the SvOK macro. 
> 
> I tried making this change and it appears to solve the problem.
> 
> 
> --- Cursor.xs-orig      2007-02-02 13:04:15.000000000 +1100
> +++ Cursor.xs   2007-02-02 13:05:15.000000000 +1100
> @@ -114,7 +114,7 @@
>                                                 (uint32_t)SvIV(ST(4)));
>                 } else if (SvPOK(ST(2))) {
>                         THIS->substitution(variable,SvPV(ST(2),na));
> -               } else if (ST(2)==&sv_undef) {
> +               } else if (!SvOK(ST(2))) {
>                         THIS->substitution(variable,(const char *)NULL);
>                 } else {
>                         RETVAL=0;
> @@ -141,7 +141,7 @@
>                                                 (uint32_t)SvIV(ST(4)));
>                 } else if (SvPOK(ST(2))) {
>                         THIS->inputBind(variable,SvPV(ST(2),na));
> -               } else if (ST(2)==&sv_undef) {
> +               } else if (!SvOK(ST(2))) {
>                         THIS->inputBind(variable,(const char *)NULL);
>                 } else {
>                         RETVAL=0;
> @@ -159,7 +159,7 @@
>                 if (SvPOK(ST(2))) {
>                         THIS->inputBindBlob(variable,value,size);
>                         RETVAL=1;
> -               } else if (ST(2)==&sv_undef) {
> +               } else if (!SvOK(ST(2))) {
>                         THIS->inputBindBlob(variable,NULL,0);
>                 }
>         OUTPUT:
> @@ -175,7 +175,7 @@
>                 if (SvPOK(ST(2))) {
>                         THIS->inputBindClob(variable,value,size);
>                         RETVAL=1;
> -               } else if (ST(2)==&sv_undef) {
> +               } else if (!SvOK(ST(2))) {
>                         THIS->inputBindClob(variable,NULL,0);
>                 }
>         OUTPUT:
> 
> Does anyone have any further thoughts on this?
> 
> Cheers,
> James
> 
> -------------------------------------------------------------------------
> 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] Can't bind undef to variable with Perl DBI

[Tim B. <Tim...@po...>]

On Fri, Feb 02, 2007 at 01:36:30PM +1100, ja...@th... wrote:
> Hi all,
> 
> I've recently started using sqlrelay's DBI driver to connect Perl to
> Oracle (sqlrelay 0.38). I find that I can't bind NULL values (undef,
> in Perl) to a prepared statement.

> Looking at the source code, I see that src/api/perl/Cursor/Cursor.xs
> tries to detect NULLness of bind values by comparing the SV's address
> to &sv_undef. I don't think that this is right - on my machine (Perl
> 5.8.4 on Linux) the comparison fails even thought the bind value is
> null.
> 
> I think the right way to check whether the SV structure contains undef
> is to use the SvOK macro. 

> Does anyone have any further thoughts on this?

Looks good to me.

Tim.

p.s. I've have some fixes to DBD::SQLRelay I need to dig out and post here.

[Sqlrelay-discussion] Can't bind undef to variable with Perl DBI

[<ja...@th...>]

Hi all,

I've recently started using sqlrelay's DBI driver to connect Perl to
Oracle (sqlrelay 0.38). I find that I can't bind NULL values (undef,
in Perl) to a prepared statement.

For instance, the following example produces the warning "ORA-01008:
not all variables bound" when run against a test_table.

# ------------------------------------------------------------
DBI->trace(1);

$sql = "insert into test_table ( count ) values ( ? )";

$c = DBI->connect(...) ;

$s = $c->prepare($sql);

$s->bind_param(1, undef);
$s->execute;
# ------------------------------------------------------------

Looking at the source code, I see that src/api/perl/Cursor/Cursor.xs
tries to detect NULLness of bind values by comparing the SV's address
to &sv_undef. I don't think that this is right - on my machine (Perl
5.8.4 on Linux) the comparison fails even thought the bind value is
null.

I think the right way to check whether the SV structure contains undef
is to use the SvOK macro. 

I tried making this change and it appears to solve the problem.


--- Cursor.xs-orig      2007-02-02 13:04:15.000000000 +1100
+++ Cursor.xs   2007-02-02 13:05:15.000000000 +1100
@@ -114,7 +114,7 @@
                                                (uint32_t)SvIV(ST(4)));
                } else if (SvPOK(ST(2))) {
                        THIS->substitution(variable,SvPV(ST(2),na));
-               } else if (ST(2)==&sv_undef) {
+               } else if (!SvOK(ST(2))) {
                        THIS->substitution(variable,(const char *)NULL);
                } else {
                        RETVAL=0;
@@ -141,7 +141,7 @@
                                                (uint32_t)SvIV(ST(4)));
                } else if (SvPOK(ST(2))) {
                        THIS->inputBind(variable,SvPV(ST(2),na));
-               } else if (ST(2)==&sv_undef) {
+               } else if (!SvOK(ST(2))) {
                        THIS->inputBind(variable,(const char *)NULL);
                } else {
                        RETVAL=0;
@@ -159,7 +159,7 @@
                if (SvPOK(ST(2))) {
                        THIS->inputBindBlob(variable,value,size);
                        RETVAL=1;
-               } else if (ST(2)==&sv_undef) {
+               } else if (!SvOK(ST(2))) {
                        THIS->inputBindBlob(variable,NULL,0);
                }
        OUTPUT:
@@ -175,7 +175,7 @@
                if (SvPOK(ST(2))) {
                        THIS->inputBindClob(variable,value,size);
                        RETVAL=1;
-               } else if (ST(2)==&sv_undef) {
+               } else if (!SvOK(ST(2))) {
                        THIS->inputBindClob(variable,NULL,0);
                }
        OUTPUT:

Does anyone have any further thoughts on this?

Cheers,
James

Re: [Sqlrelay-discussion] ADODB compatibility?

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

Currently, there is no ADODB driver for SQL Relay.  However, there is a
Pear DB driver.  I've heard that there's a Pear DB driver for ADODB but
I've never used it.  It could be a solution though.

David Muse
dav...@fi...

On Mon, 2007-01-29 at 01:45 -0700, Brian Lucas wrote:
> Hi, curious to see if anybody is using PHP ADODB with SQL-Relay.  I've got a
> large project with all DB calls done in ADODB so rewriting isn't an option,
> but it seems like it shouldn't be too much work to integrate ADODB into
> SQL-Relay but I haven't had any luck doing so.  I'm not sure if I would need
> to rewrite an entire data dictionary for SQL-Relay or if there is a simple
> fix.  ADODB just hangs when it attempts to connect to an SQL-Relay listener.
> 
> The SQL-Relay functions work as expected
> ($con=sqlrcon_alloc("localhost",9300,"","user","pass",0,1);) in PHP and
> sqlrsh works fine.
> 
> Any ideas or suggestions?
> 
> Thanks, Brian
> 
> 
> -------------------------------------------------------------------------
> 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
> 

Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'

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

Could you post your sqlrleay.conf file?  It may be helpful to see.

Dave
dav...@fi...

On Mon, 2007-01-29 at 17:26 +0100, Garnier, Jeremie wrote:
> Hi all,
> 
> And when i want to use sqlr-connection-oracle, it can’t connect to the
> database as there is this error : 
> 
> OCIServerAttach() failed.
> 
>  Thanks,
> 
>  
> 
> Jérémie
> 
> 
>                                    
> ______________________________________________________________________
> De : Garnier, Jeremie 
> Envoyé : lundi 29 janvier 2007 17:14
> À : 'Discussion of topics related to SQL Relay'
> Objet : RE: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'
> 
> 
>  
> 
> Hi all,
> 
>  
> 
> I make some modification in Sql Relay in order to use Oracle XE… I
> don’t have any problems in the configuration/compilation.
> 
> But at the end, it don’t know were is the library sql_relay.so (in
> order to use it in PHP)?
> 
> It is normal that there is libpgsqlsqlrelay.so or libmysqlsqlrelay.so
> and not liboraclesqlrelay.so?
> 
> Thanks,
> 
>  
> 
> Jérémie 
> 
>  
> 
> -----Message d'origine-----
> De : sql...@li...
> [mailto:sql...@li...] De la part
> de David Muse
> Envoyé : mardi 16 janvier 2007 02:42
> À : Discussion of topics related to SQL Relay
> Objet : Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'
> 
>  
> 
> I believe that the PHP library is sql_relay.so rather than sqlrelay.so
> 
>  
> 
> On Mon, 2007-01-15 at 08:42 +0100, Garnier, Jeremie wrote:
> 
> > Hi all,
> 
> > 
> 
> >  
> 
> > 
> 
> > I try to use Sql Relay with Oracle 10g, Php5 and apache 2.2.3 on
> linux RedHat.
> 
> > 
> 
> > I make so modifications on Sql relay in order to use the version XE
> of Oracle. But no problem after, when I run make & make install, I
> have the library sqlrelay.so.
> 
> > 
> 
> > But when I try to use it on my web server, it done:
> 
> > 
> 
> >  
> 
> > 
> 
> > Warning : dl() : Invalid library (maybe not a PHP library)
> 'sqlrelay.so' ...
> 
> > 
> 
> > Fatal error : call to undefined function sqlrcon_alloc()...
> 
> > 
> 
> >  
> 
> > 
> 
> > I think all configurations are ok but it can't load the Sql relay
> library. I try to include it in the file php.ini but it done the same
> thing!
> 
> > 
> 
> > Is anyone having some ideas to resolve this???
> 
> > 
> 
> >  
> 
> > 
> 
> > Thanks,
> 
> > 
> 
> >  
> 
> > 
> 
> > Jérémie GARNIER
> 
> > 
> 
> > 
> 
> >
> ***********************************************************************************
> 
> > Information contained in this email message is confidential and may
> be privileged, and is intended only for use of the individual or
> entity named above. If the reader of this message is not the intended
> recipient, or the employee or agent responsible to deliver it to the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please immediately
> notify the pos...@nd... and destroy the original message.
> 
> >
> *********************************************************************************** 
> 
> > 
> 
> > 
> 
> >
> -------------------------------------------------------------------------
> 
> > 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
> 
> > 
> 
>  
> 
>  
> 
> -------------------------------------------------------------------------
> 
> 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
> 
> 
> ***********************************************************************************
> Information contained in this email message is confidential and may be
> privileged, and is intended only for use of the individual or entity
> named above. If the reader of this message is not the intended
> recipient, or the employee or agent responsible to deliver it to the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please immediately
> notify the pos...@nd... and destroy the original message.
> *********************************************************************************** 
> -------------------------------------------------------------------------
> 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

Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'

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

libpgsqlsqlrelay.so is the postgres drop-in-replacement library.  It
maps postgresql client functions to sqlrelay client functions and allows
apps that were coded to use the postgres client library to use sqlrelay
without changing the source code.

libmysqlsqlrelay.so is a similar library for mysql.

There isn't (yet) a similar library for oracle.

The library should be built in the src/api/php directory and should be
installed in whatever the php-extensions directory is on your machine.
If you look in the config.mk file created by the configure script, the
PHPEXTDIR variable should be set to the directory that sql_relay.so will
be installed in.

Dave
dav...@fi...

On Mon, 2007-01-29 at 17:14 +0100, Garnier, Jeremie wrote:
> Hi all,
> 
>  
> 
> I make some modification in Sql Relay in order to use Oracle XE… I
> don’t have any problems in the configuration/compilation.
> 
> But at the end, it don’t know were is the library sql_relay.so (in
> order to use it in PHP)?
> 
> It is normal that there is libpgsqlsqlrelay.so or libmysqlsqlrelay.so
> and not liboraclesqlrelay.so?
> 
> Thanks,
> 
>  
> 
> Jérémie 
> 
>  
> 
> -----Message d'origine-----
> De : sql...@li...
> [mailto:sql...@li...] De la part
> de David Muse
> Envoyé : mardi 16 janvier 2007 02:42
> À : Discussion of topics related to SQL Relay
> Objet : Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'
> 
>  
> 
> I believe that the PHP library is sql_relay.so rather than sqlrelay.so
> 
>  
> 
> On Mon, 2007-01-15 at 08:42 +0100, Garnier, Jeremie wrote:
> 
> > Hi all,
> 
> > 
> 
> >  
> 
> > 
> 
> > I try to use Sql Relay with Oracle 10g, Php5 and apache 2.2.3 on
> linux RedHat.
> 
> > 
> 
> > I make so modifications on Sql relay in order to use the version XE
> of Oracle. But no problem after, when I run make & make install, I
> have the library sqlrelay.so.
> 
> > 
> 
> > But when I try to use it on my web server, it done:
> 
> > 
> 
> >  
> 
> > 
> 
> > Warning : dl() : Invalid library (maybe not a PHP library)
> 'sqlrelay.so' ...
> 
> > 
> 
> > Fatal error : call to undefined function sqlrcon_alloc()...
> 
> > 
> 
> >  
> 
> > 
> 
> > I think all configurations are ok but it can't load the Sql relay
> library. I try to include it in the file php.ini but it done the same
> thing!
> 
> > 
> 
> > Is anyone having some ideas to resolve this???
> 
> > 
> 
> >  
> 
> > 
> 
> > Thanks,
> 
> > 
> 
> >  
> 
> > 
> 
> > Jérémie GARNIER
> 
> > 
> 
> > 
> 
> >
> ***********************************************************************************
> 
> > Information contained in this email message is confidential and may
> be privileged, and is intended only for use of the individual or
> entity named above. If the reader of this message is not the intended
> recipient, or the employee or agent responsible to deliver it to the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please immediately
> notify the pos...@nd... and destroy the original message.
> 
> >
> *********************************************************************************** 
> 
> > 
> 
> > 
> 
> >
> -------------------------------------------------------------------------
> 
> > 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
> 
> > 
> 
>  
> 
>  
> 
> -------------------------------------------------------------------------
> 
> 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
> 
> 
> ***********************************************************************************
> Information contained in this email message is confidential and may be
> privileged, and is intended only for use of the individual or entity
> named above. If the reader of this message is not the intended
> recipient, or the employee or agent responsible to deliver it to the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please immediately
> notify the pos...@nd... and destroy the original message.
> *********************************************************************************** 
> -------------------------------------------------------------------------
> 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

Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'

[Garnier, J. <JGa...@nd...>]

Hi all,

And when i want to use sqlr-connection-oracle, it can't connec=
t to the database as there is this error : 

OCIServerAttach() failed.
=

 Thanks,

 

J=E9r=E9mie

________________________________

De =
: Garnier, Jeremie 
Envoy=E9 : lundi 29 janvier 2007 17:14
=C0 : 'Discu=
ssion of topics related to SQL Relay'
Objet : RE: [Sqlrelay-discussion] =
: Invalid library PHP 'sqlrelay.so'

 

Hi all,

 

I make some m=
odification in Sql Relay in order to use Oracle XE... I don't have any pr=
oblems in the configuration/compilation.

But at the end, it don't know=
 were is the library sql_relay.so (in order to use it in PHP)?

It is n=
ormal that there is libpgsqlsqlrelay.so or libmysqlsqlrelay.so and not li=
boraclesqlrelay.so?

Thanks,

 

J=E9r=E9mie 

 

-----Message =
d'origine-----
De : sql...@li... [m=
ailto:sql...@li...] De la part de Da=
vid Muse
Envoy=E9 : mardi 16 janvier 2007 02:42
=C0 : Discussion of top=
ics related to SQL Relay
Objet : Re: [Sqlrelay-discussion] : Invalid lib=
rary PHP 'sqlrelay.so'

 

I believe that the PHP library is sql_rela=
y.so rather than sqlrelay.so

 

On Mon, 2007-01-15 at 08:42 +0100, G=
arnier, Jeremie wrote:

> Hi all,

> 

>  

> 

> I try to use =
Sql Relay with Oracle 10g, Php5 and apache 2.2.3 on linux RedHat.

> 
=

> I make so modifications on Sql relay in order to use the version XE o=
f Oracle. But no problem after, when I run make & make install, I have th=
e library sqlrelay.so.

> 

> But when I try to use it on my web serv=
er, it done:

> 

>  

> 

> Warning : dl() : Invalid library (ma=
ybe not a PHP library) 'sqlrelay.so' ...

> 

> Fatal error : call to=
 undefined function sqlrcon_alloc()...

> 

>  

> 

> I think al=
l configurations are ok but it can't load the Sql relay library. I try to=
 include it in the file php.ini but it done the same thing!

> 

> Is=
 anyone having some ideas to resolve this???

> 

>  

> 

> Than=
ks,

> 

>  

> 

> J=E9r=E9mie GARNIER

> 

> 

> ********=
*************************************************************************=
**

> Information contained in this email message is confidential and m=
ay be privileged, and is intended only for use of the individual or entit=
y named above. If the reader of this message is not the intended recipien=
t, or the employee or agent responsible to deliver it to the intended rec=
ipient, you are hereby notified that any dissemination, distribution or c=
opying of this communication is strictly prohibited. If you have received=
 this communication in error, please immediately notify the postmaster@nd=
s.com and destroy the original message.

> ****************************=
******************************************************* 

> 

> 

>=
 ------------------------------------------------------------------------=
-

> Take Surveys. Earn Cash. Influence the Future of IT

> Join Sour=
ceForge.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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV

> _______________________________________________

> 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 y=
our

opinions on IT & business topics through brief surveys - and earn =
cash

http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforg=
e&CID=3DDEVDEV

_______________________________________________

Sqlr=
elay-discussion mailing list

Sql...@li...=


https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

*=
*************************************************************************=
*********
Information contained in this email message is confidential an=
d may be privileged, and is intended only for use of the individual or en=
tity named above. If the reader of this message is not the intended recip=
ient, or the employee or agent responsible to deliver it to the intended =
recipient, you are hereby notified that any dissemination, distribution o=
r copying of this communication is strictly prohibited. If you have recei=
ved this communication in error, please immediately notify the postmaster=
@nds.com and destroy the original message.
*****************************=
****************************************************** 

Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'

[Garnier, J. <JGa...@nd...>]

Hi all,

 

I make some modification in Sql Relay in order to use Ora=
cle XE... I don't have any problems in the configuration/compilation.

=
But at the end, it don't know were is the library sql_relay.so (in order =
to use it in PHP)?

It is normal that there is libpgsqlsqlrelay.so or l=
ibmysqlsqlrelay.so and not liboraclesqlrelay.so?

Thanks,

 

J=E9r=
=E9mie 

 

-----Message d'origine-----
De : sqlrelay-discussion-bou=
nc...@li... [mailto:sql...@li...=
ceforge.net] De la part de David Muse
Envoy=E9 : mardi 16 janvier 2007 0=
2:42
=C0 : Discussion of topics related to SQL Relay
Objet : Re: [Sqlre=
lay-discussion] : Invalid library PHP 'sqlrelay.so'

 

I believe tha=
t the PHP library is sql_relay.so rather than sqlrelay.so

 

On Mon,=
 2007-01-15 at 08:42 +0100, Garnier, Jeremie wrote:

> Hi all,

> 

=
>  

> 

> I try to use Sql Relay with Oracle 10g, Php5 and apache 2.=
2.3 on linux RedHat.

> 

> I make so modifications on Sql relay in o=
rder to use the version XE of Oracle. But no problem after, when I run ma=
ke & make install, I have the library sqlrelay.so.

> 

> But when I =
try to use it on my web server, it done:

> 

>  

> 

> Warning =
: dl() : Invalid library (maybe not a PHP library) 'sqlrelay.so' ...

>=
 

> Fatal error : call to undefined function sqlrcon_alloc()...

> 
=

>  

> 

> I think all configurations are ok but it can't load the =
Sql relay library. I try to include it in the file php.ini but it done th=
e same thing!

> 

> Is anyone having some ideas to resolve this???
=

> 

>  

> 

> Thanks,

> 

>  

> 

> J=E9r=E9mie GARNIE=
R

> 

> 

> ******************************************************=
*****************************

> Information contained in this email me=
ssage is confidential and may be privileged, and is intended only for use=
 of the individual or entity named above. If the reader of this message i=
s not the intended recipient, or the employee or agent responsible to del=
iver it to the intended recipient, you are hereby notified that any disse=
mination, distribution or copying of this communication is strictly prohi=
bited. If you have received this communication in error, please immediate=
ly notify the pos...@nd... and destroy the original message.

> *=
*************************************************************************=
********* 

> 

> 

> ---------------------------------------------=
----------------------------

> 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=3Dj=
oin.php&p=3Dsourceforge&CID=3DDEVDEV

> _______________________________=
________________

> Sqlrelay-discussion mailing list

> Sqlrelay-disc=
us...@li...

> https://lists.sourceforge.net/lists/lis=
tinfo/sqlrelay-discussion

> 

 

 

----------------------------=
---------------------------------------------

Take Surveys. Earn Cash.=
 Influence the Future of IT

Join SourceForge.net's Techsay panel and y=
ou'll get the chance to share your

opinions on IT & business topics th=
rough brief surveys - and earn cash

http://www.techsay.com/default.php=
?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV

________________________=
_______________________

Sqlrelay-discussion mailing list

Sqlrelay-d=
isc...@li...

https://lists.sourceforge.net/lists/li=
stinfo/sqlrelay-discussion

*******************************************=
****************************************
Information contained in this e=
mail message is confidential and may be privileged, and is intended only =
for use of the individual or entity named above. If the reader of this me=
ssage is not the intended recipient, or the employee or agent responsible=
 to deliver it to the intended recipient, you are hereby notified that an=
y dissemination, distribution or copying of this communication is strictl=
y prohibited. If you have received this communication in error, please im=
mediately notify the pos...@nd... and destroy the original message.=

***********************************************************************=
************ 

[Sqlrelay-discussion] ADODB compatibility?

[Brian L. <blu...@gm...>]

Hi, curious to see if anybody is using PHP ADODB with SQL-Relay.  I've got a
large project with all DB calls done in ADODB so rewriting isn't an option,
but it seems like it shouldn't be too much work to integrate ADODB into
SQL-Relay but I haven't had any luck doing so.  I'm not sure if I would need
to rewrite an entire data dictionary for SQL-Relay or if there is a simple
fix.  ADODB just hangs when it attempts to connect to an SQL-Relay listener.

The SQL-Relay functions work as expected
($con=sqlrcon_alloc("localhost",9300,"","user","pass",0,1);) in PHP and
sqlrsh works fine.

Any ideas or suggestions?

Thanks, Brian

Re: [Sqlrelay-discussion] SQLRELAY PHP - TRANSACTION COMMIT ROLLBACK.

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

What database are you using?  Does it support rollback?

If so, some databases (like postgresql) require that you use a BEGIN
query to begin a transaction and then end the transaction with a COMMIT
or ROLLBACK, but if you don't BEGIN then all queries are committed
automatically.

Some other database interfaces do the BEGIN for you, but SQL Relay
requires that you do the BEGIN yourself.

Dave

On Thu, 2007-01-18 at 11:15 +0100, Rony Cohen wrote:
> Hello,
> 
> I'm using SQLRELAY with PHP.
> 
> I meet problems when I want Rollback.
> That doesn't work at all....
> 
> I put :
> 
> SqlrelayClass::ConnexionBDD();
> sqlrcon_autoCommitOff(SqlrelayClass::$dbConn);
> 
>                         try{
>                             ... somes send queries .....
> 
> 
> // I PUT AN EXCEPTION  HERE....
>                             throw new MyException("error");
> 
> 
>                             SqlrelayClass::commit();
>                             SqlrelayClass::EndSessionBDD();
> 
>                         }
> 
>                         catch(MyException $ActionErr){
> 
> // MY ROLLBACK
>                             sqlrcon_rollback(SqlrelayClass::$dbConn);
> 
>                         }
> 
> SqlrelayClass::CloseConnexionBDD();
> 
> 
> 
> I do that, but all my queries still work,  and  are register in my
> DataBASE. 
> 
> Can someone Tell my WHY ..??
> THANK YOU FOR THE HELP.
> Rony
> 
> -------------------------------------------------------------------------
> 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

[Sqlrelay-discussion] SQLRELAY PHP - TRANSACTION COMMIT ROLLBACK.

[Rony C. <coh...@gm...>]

Hello,

I'm using SQLRELAY with PHP.

I meet problems when I want Rollback.
That doesn't work at all....

I put :

SqlrelayClass::ConnexionBDD();
sqlrcon_autoCommitOff(SqlrelayClass::$dbConn);

                        try{
                            ... somes send queries .....


// I PUT AN EXCEPTION  HERE....
                            throw new MyException("error");


                            SqlrelayClass::commit();
                            SqlrelayClass::EndSessionBDD();

                        }

                        catch(MyException $ActionErr){

// MY ROLLBACK
                            sqlrcon_rollback(SqlrelayClass::$dbConn);

                        }

SqlrelayClass::CloseConnexionBDD();



I do that, but all my queries still work,  and  are register in my DataBASE.


Can someone Tell my WHY ..??
THANK YOU FOR THE HELP.
Rony

Re: [Sqlrelay-discussion] Problem with retrieving result set from DB2 V9

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

Cool.  Glad that's all it was :)

Dave

On Tue, 2007-01-16 at 13:15 +0200, Denis Chapligin wrote:
> Dear David,
> 
> 
> I've turned on your workaround for V8.2 and now everything works just
> fine. My fault, i've thought this bug has been fixed in V9.
> 
> 2007/1/16, David Muse <dav...@fi...>:
> > Turn on debug and send me the output.  Hopefully it'll shed some light
> > on the problem.
> >
> > If not, there's a bug in db2 8.1 involved with fetching the row number.
> > It's possible that it's been fixed since then and my workaround no
> > longer works.  If the debug from the query program doesn't help, then
> > I'll see if I can come up with a patch that uses a different workaround.
> >
> > David Muse
> > dav...@fi...
> >
> > On Fri, 2007-01-12 at 20:14 +0200, Denis Chapligin wrote:
> > > Hello!
> > >
> > >
> > > I've been using DB2 V9 and sqlrelay 0.37 from Debian/Etch and have a
> > > problem retrieving result set from sqlrelay server. I've run same
> > > query via DB2 control center and and "query" utility. DB2CC returns
> > > about 150 rows and this is correct, but "query" returns only one row.
> > > What i'm doing wrong?
> > >
> 
> -------------------------------------------------------------------------
> 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
> 

Re: [Sqlrelay-discussion] Problem with retrieving result set from DB2 V9

[Denis C. <aka...@gm...>]

Dear David,


I've turned on your workaround for V8.2 and now everything works just
fine. My fault, i've thought this bug has been fixed in V9.

2007/1/16, David Muse <dav...@fi...>:
> Turn on debug and send me the output.  Hopefully it'll shed some light
> on the problem.
>
> If not, there's a bug in db2 8.1 involved with fetching the row number.
> It's possible that it's been fixed since then and my workaround no
> longer works.  If the debug from the query program doesn't help, then
> I'll see if I can come up with a patch that uses a different workaround.
>
> David Muse
> dav...@fi...
>
> On Fri, 2007-01-12 at 20:14 +0200, Denis Chapligin wrote:
> > Hello!
> >
> >
> > I've been using DB2 V9 and sqlrelay 0.37 from Debian/Etch and have a
> > problem retrieving result set from sqlrelay server. I've run same
> > query via DB2 control center and and "query" utility. DB2CC returns
> > about 150 rows and this is correct, but "query" returns only one row.
> > What i'm doing wrong?
> >

Re: [Sqlrelay-discussion] Problem with retrieving result set from DB2 V9

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

Turn on debug and send me the output.  Hopefully it'll shed some light
on the problem.

If not, there's a bug in db2 8.1 involved with fetching the row number.
It's possible that it's been fixed since then and my workaround no
longer works.  If the debug from the query program doesn't help, then
I'll see if I can come up with a patch that uses a different workaround.

David Muse
dav...@fi...

On Fri, 2007-01-12 at 20:14 +0200, Denis Chapligin wrote:
> Hello!
> 
> 
> I've been using DB2 V9 and sqlrelay 0.37 from Debian/Etch and have a
> problem retrieving result set from sqlrelay server. I've run same
> query via DB2 control center and and "query" utility. DB2CC returns
> about 150 rows and this is correct, but "query" returns only one row.
> What i'm doing wrong?
> 
> -------------------------------------------------------------------------
> 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
> 

Re: [Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'

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

I believe that the PHP library is sql_relay.so rather than sqlrelay.so

On Mon, 2007-01-15 at 08:42 +0100, Garnier, Jeremie wrote:
> Hi all,
> 
>  
> 
> I try to use Sql Relay with Oracle 10g, Php5 and apache 2.2.3 on linux RedHat.
> 
> I make so modifications on Sql relay in order to use the version XE of Oracle. But no problem after, when I run make & make install, I have the library sqlrelay.so.
> 
> But when I try to use it on my web server, it done:
> 
>  
> 
> Warning : dl() : Invalid library (maybe not a PHP library) 'sqlrelay.so' ...
> 
> Fatal error : call to undefined function sqlrcon_alloc()...
> 
>  
> 
> I think all configurations are ok but it can't load the Sql relay library. I try to include it in the file php.ini but it done the same thing!
> 
> Is anyone having some ideas to resolve this???
> 
>  
> 
> Thanks,
> 
>  
> 
> Jérémie GARNIER
> 
> 
> ***********************************************************************************
> Information contained in this email message is confidential and may be privileged, and is intended only for use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the pos...@nd... and destroy the original message.
> *********************************************************************************** 
> 
> 
> -------------------------------------------------------------------------
> 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
> 

[Sqlrelay-discussion] : Invalid library PHP 'sqlrelay.so'

[Garnier, J. <JGa...@nd...>]

Hi all,

 

I try to use Sql Relay with Oracle 10g, Php5 and apache 2=
.2.3 on linux RedHat.

I make so modifications on Sql relay in order to=
 use the version XE of Oracle. But no problem after, when I run make & ma=
ke install, I have the library sqlrelay.so.

But when I try to use it o=
n my web server, it done:

 

Warning : dl() : Invalid library (maybe=
 not a PHP library) 'sqlrelay.so' ...

Fatal error : call to undefined =
function sqlrcon_alloc()...

 

I think all configurations are ok but=
 it can't load the Sql relay library. I try to include it in the file php=
.ini but it done the same thing!

Is anyone having some ideas to resolv=
e this???

 

Thanks,

 

J=E9r=E9mie GARNIER


**************=
*********************************************************************
In=
formation contained in this email message is confidential and may be priv=
ileged, and is intended only for use of the individual or entity named ab=
ove. If the reader of this message is not the intended recipient, or the =
employee or agent responsible to deliver it to the intended recipient, yo=
u are hereby notified that any dissemination, distribution or copying of =
this communication is strictly prohibited. If you have received this comm=
unication in error, please immediately notify the pos...@nd... and =
destroy the original message.
******************************************=
***************************************** 

[Sqlrelay-discussion] Problem with retrieving result set from DB2 V9

[Denis C. <aka...@gm...>]

Hello!


I've been using DB2 V9 and sqlrelay 0.37 from Debian/Etch and have a
problem retrieving result set from sqlrelay server. I've run same
query via DB2 control center and and "query" utility. DB2CC returns
about 150 rows and this is correct, but "query" returns only one row.
What i'm doing wrong?

[Sqlrelay-discussion] Invalid library PHP 'sqlrelay.so'

[Garnier, J. <JGa...@nd...>]

Hi all,

 

I try to use Sql Relay with Oracle 10g, Php5 and apache 2=
.2.3 on linux RedHat.

I make so modifications on Sql relay in order to=
 use the version XE of Oracle. But no problem after, when I run make & ma=
ke install, I have the library sqlrelay.so.

But when I try to use it o=
n my web server, it done:

 

Warning : dl() : Invalid library (maybe=
 not a PHP library) 'sqlrelay.so' ...

Fatal error : call to undefined =
function sqlrcon_alloc()...

 

I think all configurations are ok but=
 it can't load the Sql relay library. I try to include it in the file php=
.ini but it done the same thing!

Is anyone having some ideas to resolv=
e this???

 

Thanks,

 

J=E9r=E9mie GARNIER

 

***********=
************************************************************************
=
Information contained in this email message is confidential and may be pr=
ivileged, and is intended only for use of the individual or entity named =
above. If the reader of this message is not the intended recipient, or th=
e employee or agent responsible to deliver it to the intended recipient, =
you are hereby notified that any dissemination, distribution or copying o=
f this communication is strictly prohibited. If you have received this co=
mmunication in error, please immediately notify the pos...@nd... an=
d destroy the original message.
****************************************=
******************************************* 

[Sqlrelay-discussion] Anyone using the Sybase sqlrelay driver?

[Tim B. <Tim...@po...>]

I'm looking at using sqlrelay in a large production environment that
currently uses Perl DBI + DBD::Sybase.

In order to test the degree of compatibility between DBD::Sybase and
DBD::SQLRelay + sqlr-connection-sybase I'm using the DBI_AUTOPROXY
mechanism to run the DBD::Sybase test suite through DBD::SQLRelay.

So far the results are not encouraging. The test suite finds many
problems with sqlr-connection-sybase. (Plus some with DBD::SQLRelay
that I've now patched to fix.)

There seem to be very few mentions of sybase in the mailing list archives
so I was wondering if either very few people are using it, or if those
who are are simply very happy.

Does anyone on the list have experience with the sybase driver?

I had started patching sqlr-connection-sybase to address the issues
being shown up by the test suite but now I'm thinking the best course of
action is to create a new sqlrelay sybase driver using the very robust
and mature DBD::Sybase code.

Any thoughts?

Tim.

Re: [Sqlrelay-discussion] sqlrelay rc initscript

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

Thanks for finding that!

I'll update the rest of the init scripts for the other platforms too and
it'll be in the next release.

David Muse
dav...@fi...

On Tue, 2007-01-09 at 11:22 +0100, Ragnar Rova wrote:
> Hello. 
> 
> I found two small bugs in sqlr-start/stop
> 
> If the machine was rebooted uncleanly and thus sqlr-stop
> was not run, stale pidfiles are left preventing sqlr-start to
> start them. sqlr-start should check if the pidfiles point
> to living pids.
> 
> Sometimes sqlr-stop does not kill all processes (can not reproduce)
> 
> I wrote and tested the following script only on HP-UX B.11.11 (attached sqlrelay.rc)
> -------------------------------------------------------------------------
> 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

[Sqlrelay-discussion] Invalid Library sqlrelay.so

[Garnier, J. <JGa...@nd...>]

Hi all,

 

I try to use Sql Relay with Oracle 10g, Php5 and apache 2=
.2.3.

I make so modifications on Sql relay in order to use the version=
 XE of Oracle. But no problem after, when I run make & make install, I ha=
ve the library sqlrelay.so.

But when I try to use it on my web server,=
 it done:

 

Warning : dl() : Invalid library (maybe not a PHP libra=
ry) 'sqlrelay.so' ...

Fatal error : call to undefined function sqlrcon=
_alloc()...

 

I think all configurations are ok but it can't load t=
he Sql relay library. I try to include it in the file php.ini but it done=
 the same thing!

Is anyone having some ideas to resolve this???

 
=

Thanks,

 

J=E9r=E9mie GARNIER

********************************=
***************************************************
Information containe=
d in this email message is confidential and may be privileged, and is int=
ended only for use of the individual or entity named above. If the reader=
 of this message is not the intended recipient, or the employee or agent =
responsible to deliver it to the intended recipient, you are hereby notif=
ied that any dissemination, distribution or copying of this communication=
 is strictly prohibited. If you have received this communication in error=
, please immediately notify the pos...@nd... and destroy the origin=
al message.
************************************************************=
*********************** 

[Sqlrelay-discussion] sqlrelay-0.38-1.src.rpm installation failed

[Nguyen T. H. <th...@gm...>]

Here is detailed info:

# rpm -ivh sqlrelay-0.38-1.src.rpm
error: sqlrelay-0.38-1.src.rpm: headerRead failed: region trailer: BAD, tag
1885692672 type 6516841 offset -1862297466 count 1768947769
error: sqlrelay-0.38-1.src.rpm cannot be installed

My OS is Centos 4.

[Sqlrelay-discussion] sqlrelay rc initscript

[Ragnar R. <rr...@mi...>]

Hello. 

I found two small bugs in sqlr-start/stop

If the machine was rebooted uncleanly and thus sqlr-stop
was not run, stale pidfiles are left preventing sqlr-start to
start them. sqlr-start should check if the pidfiles point
to living pids.

Sometimes sqlr-stop does not kill all processes (can not reproduce)

I wrote and tested the following script only on HP-UX B.11.11 (attached sqlrelay.rc)