sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] nodejs client for sql relay

[Alfred F. <alf...@gm...>]

Hi,

were can I find the nodejs client for sql relay?

It seems that npm doesn know sqlrealy.

Kind regards,

Alfred Foltin

[Sqlrelay-discussion] windows odbc connector international symbols support patch

[Игорь Д. <la...@ma...>]

 
 
--
Игорь Драч

[Sqlrelay-discussion] Possible fix for configure.vbs

[Игорь Д. <la...@ma...>]

only the English version of cl compiler contains the word  "Version".
For example output for Russian version :
cl
Оптимизирующий компилятор Microsoft (R) C/C++ версии 19.28.29913 для x86
(C) Корпорация Майкрософт (Microsoft Corporation).  Все права защищены.
 
 
--- a/configure.vbs    2020-09-16 08:04:21.000000000 +0300
+++ b/configure.vbs    2021-04-16 13:51:18.470136848 +0300
@@ -283,12 +283,7 @@
 if arch="80x86" then
     arch="x86"
 end if
-version=""
-for i=lbound(parts) to ubound(parts)
-    if parts(i)="Version" then
-        version=parts(i+1)
-    end if
-next
+version=parts(ubound(parts)-2)
 parts=split(version,".")
 version=parts(0)
 
--
Игорь Драч

[Sqlrelay-discussion] fix for ODBC2 drivers

[Игорь Д. <la...@ma...>]

SQL_DESC_LENGTH,  SQL_DESC_TYPE,  SQL_DESC_PRECISION,SQL_DESC_BASE_TABLE_NAME  attributes only for ODBC 3.0 and higher
https://docs.microsoft.com/ru-ru/sql/odbc/reference/syntax/sqlcolattribute-function?view=sql-server-ver15
 
 
--- a/odbc.cpp    2020-09-16 08:04:17.000000000 +0300
+++ b/odbc.cpp    2021-04-16 00:16:09.428262800 +0300
@@ -3126,27 +3126,45 @@
                     charstring::length(column[i].name);
 
                 // column length
-                erg=SQLColAttribute(stmt,i+1,SQL_DESC_LENGTH,
+                if (!charstring::compare(odbcconn->odbcversion,"2")) {
+                    erg=SQLColAttribute(stmt,i+1,SQL_COLUMN_LENGTH,
                         NULL,0,NULL,
                         &(column[i].length));
+                } else {
+                    erg=SQLColAttribute(stmt,i+1,SQL_DESC_LENGTH,
+                        NULL,0,NULL,
+                        &(column[i].length));
+                }
                 if (erg!=SQL_SUCCESS &&
                     erg!=SQL_SUCCESS_WITH_INFO) {
                     return false;
                 }
     
                 // column type
-                erg=SQLColAttribute(stmt,i+1,SQL_DESC_TYPE,
+                if (!charstring::compare(odbcconn->odbcversion,"2")) {
+                    erg=SQLColAttribute(stmt,i+1,SQL_COLUMN_TYPE,
+                        NULL,0,NULL,
+                        &(column[i].type));
+                } else {
+                    erg=SQLColAttribute(stmt,i+1,SQL_DESC_TYPE,
                         NULL,0,NULL,
                         &(column[i].type));
+                }
                 if (erg!=SQL_SUCCESS &&
                     erg!=SQL_SUCCESS_WITH_INFO) {
                     return false;
                 }
 
                 // column precision
-                erg=SQLColAttribute(stmt,i+1,SQL_DESC_PRECISION,
+                if (!charstring::compare(odbcconn->odbcversion,"2")) {
+                    erg=SQLColAttribute(stmt,i+1,SQL_COLUMN_PRECISION,
+                        NULL,0,NULL,
+                        &(column[i].precision));
+                } else {
+                    erg=SQLColAttribute(stmt,i+1,SQL_DESC_PRECISION,
                         NULL,0,NULL,
                         &(column[i].precision));
+                }
                 // Some drivers (Redshift) like to return -1
                 // for the precision of some (TEXT/NTEXT)
                 // columns.  This wreaks havoc on the client
@@ -3161,9 +3179,15 @@
                 }
 
                 // column scale
-                erg=SQLColAttribute(stmt,i+1,SQL_DESC_SCALE,
+                if (!charstring::compare(odbcconn->odbcversion,"2")) {
+                    erg=SQLColAttribute(stmt,i+1,SQL_COLUMN_SCALE,
                         NULL,0,NULL,
                         &(column[i].scale));
+                } else {
+                    erg=SQLColAttribute(stmt,i+1,SQL_DESC_SCALE,
+                        NULL,0,NULL,
+                        &(column[i].scale));
+                }
                 if (erg!=SQL_SUCCESS &&
                     erg!=SQL_SUCCESS_WITH_INFO) {
                     return false;
@@ -3208,12 +3232,21 @@
                 }
 
                 // table name
-                erg=SQLColAttribute(stmt,i+1,
+                if (!charstring::compare(odbcconn->odbcversion,"2")) {
+                    erg=SQLColAttributes(stmt,i+1,
+                        SQL_COLUMN_TABLE_NAME,
+                        column[i].table,4096,
+                        (SQLSMALLINT *)
+                        &(column[i].tablelength),
+                        NULL);
+                } else {
+                    erg=SQLColAttribute(stmt,i+1,
                         SQL_DESC_BASE_TABLE_NAME,
                         column[i].table,4096,
                         (SQLSMALLINT *)
                         &(column[i].tablelength),
                         NULL);
+                }
                 if (erg!=SQL_SUCCESS &&
                     erg!=SQL_SUCCESS_WITH_INFO) {
                     return false;
 
 
--
Игорь Драч

[Sqlrelay-discussion] sqlrcur_getRowAssoc

[Jiří W. <jir...@gm...>]

Hello,

I have an issue with sqlrcur_getRowAssoc, it returns rarely (5 times in row
after restart, sometimes in X+n request - very strange behavior) correct
data and in most cases incorrect - corrupted data.

Note: There is no issue to call mentioned query from sqldeveloper etc.

e.g. correct one:

Parsing Column Info
	Actual row count: unknown
	Affected row count: 0
	Column count: 5
	""."LOG_TYPE_ID","NUMBER", 22 (38,0) NOT NULL
	""."LABEL","VARCHAR2", 1020 (0,0) NOT NULL
	""."LOG_TYPE_TABLE_REFERENCE","VARCHAR2", 1020 (0,0) NOT NULL
	""."REFERENCE","VARCHAR2", 1020 (0,0)
	""."INCOMING_DB_ID","NUMBER", 22 (38,0) NOT NULL

incorrect one:

Parsing Column Info
	Actual row count: unknown
	Affected row count: 0
	Column count: 5
	""." ","NUMBER", 22 (38,0) NOT NULL
	""."�P� ","VARCHAR2", 120 (0,0) NOT NULL
	""."","VARCHAR2", 1020 (0,0)
	""."  �","NUMBER", 22 (38,0) NOT NULL
	""."","UNKNOWN", 0 (0,0) NOT NULL

Versions
-------------
PHP 7.0.30-0ubuntu0.16.04.1
Ubuntu 16.04
SQL Relay 1.3.0
Oracle instant client 12.2.0.1.0-2


PHP code
---------------

> <?php
> error_reporting(E_ALL);
> ini_set('display_errors', 1);
> include(getenv('EM_DB_CONFIG'));
> echo '<h1>PACKAGE TYPE</h1>';
> $con = sqlrcon_alloc(
>     $config['databaseConnection']['xy-client']['sqlr']['client']['host'],
>     $config['databaseConnection']['xy-client']['sqlr']['client']['port'],
>     '',
>     $config['databaseConnection']['xy-client']['sqlr']['client']['user'],
>
> $config['databaseConnection']['xy-client']['sqlr']['client']['password'],
>     1,
>     3
> );
> sqlrcon_debugOn($con);
> echo '<pre>';
> $cur = sqlrcur_alloc($con);
>
> sqlrcur_prepareQuery($cur, "begin
> em_order.PCK_ORDER_LOG_TYPE.P_SELECT(:in1, :in2, :out1, :out2); end;");
> sqlrcur_inputBind($cur, "in1", null);
> sqlrcur_inputBind($cur, "in2", null);
> sqlrcur_defineOutputBindCursor($cur, "out1");
> sqlrcur_defineOutputBindInteger($cur, "out2");
> sqlrcur_executeQuery($cur);
> //$bindcur = sqlrcur_getOutputBindCursor($cur, "out1");
> $bindcur = sqlrcur_getOutputBindcursor($cur, "out1");
> sqlrcur_fetchFromBindCursor($bindcur);
> echo '</pre>';
> # print fields from table
> for ($i = 0; $i < sqlrcur_rowCount($bindcur); $i++) {
>     var_dump(sqlrcur_getRowAssoc($bindcur, $i));
>     /*
>     for ($j = 0; $j < sqlrcur_colCount($bindcur); $j++) {
>         echo sqlrcur_getField($bindcur, $i, $j);
>         echo ", ";
>     }
>     echo "\n";
>     */
> }
> sqlrcur_free($bindcur);
> sqlrcur_free($cur);
> sqlrcon_free($con);
>
> //======================
> echo '<h1>PACKAGE CARIER</h1>';
> $con1 = sqlrcon_alloc(
>     $config['databaseConnection']['xy-client']['sqlr']['client']['host'],
>     $config['databaseConnection']['xy-client']['sqlr']['client']['port'],
>     '',
>     $config['databaseConnection']['xy-client']['sqlr']['client']['user'],
>
> $config['databaseConnection']['xy-client']['sqlr']['client']['password'],
>     1,
>     3
> );
> sqlrcon_debugOn($con1);
> echo '<pre>';
> $cur1 = sqlrcur_alloc($con1);
> sqlrcur_prepareQuery($cur1, "begin
> em_order.PCK_CARRIER_10183.P_GET_CARRIER(:in1, :in2, :in3, :out1, :out2);
> end;");
> sqlrcur_inputBind($cur1, "in1", null);
> sqlrcur_inputBind($cur1, "in2", null);
> sqlrcur_inputBind($cur1, "in3", null);
> sqlrcur_defineOutputBindCursor($cur1, "out1");
> sqlrcur_defineOutputBindInteger($cur1, "out2");
> sqlrcur_executeQuery($cur1);
> //$bindcur = sqlrcur_getOutputBindCursor($cur, "out1");
> $bindcur1 = sqlrcur_getOutputBindcursor($cur1, "out1");
> sqlrcur_fetchFromBindCursor($bindcur1);
>
> echo '</pre>';
> # print fields from table
> for ($i = 0; $i < sqlrcur_rowCount($bindcur1); $i++) {
>     var_dump(sqlrcur_getRowAssoc($bindcur1, $i));
>     /*
>     for ($j = 0; $j < sqlrcur_colCount($bindcur); $j++) {
>         echo sqlrcur_getField($bindcur, $i, $j);
>         echo ", ";
>     }
>     echo "\n";
>     */
> }
> sqlrcur_free($bindcur1);
> sqlrcur_free($cur1);
> sqlrcon_free($con1);

[Sqlrelay-discussion] Auditing

[Troels A. <tr...@ar...>]

Hello,

Let's say I have a database X which contains data of a nature where I 
need to audit log the statements which are being sent to the database, 
including values of bind variables. And let's say that for various 
reasons, database X does not provide audit log facilities.

Can I place SQL Relay in front of the database and make SQL Relay handle 
audit logging of statements?

-- 
Regards,
Troels Arvin, Copenhagen, Denmark

[Sqlrelay-discussion] [Ubuntu14 x64][PHP 5.5.9] - segfaults

[Jiří W. <jir...@gm...>]

Hello,

I'm trying to implement older version of SQL Relay (0.41) for PHP 5.5.9
running under Ubuntu Server 14.04.LTS (x64). It works well for Ubuntu
Server 12.04 LTS and PHP 5.3.10.


*PHP 5.5.9 + Ubuntu Server 14.04.LTS*

May 17 06:16:59 web800 kernel: php5-fpm[17422]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]
May 17 06:17:02 web800 kernel: php5-fpm[19457]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]
May 17 06:21:11 web800 kernel: php5-fpm[19461]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]
May 17 06:21:12 web800 kernel: php5-fpm[20423]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]
May 17 06:21:13 web800 kernel: php5-fpm[20425]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]
May 17 06:21:14 web800 kernel: php5-fpm[20427]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]
May 17 06:21:15 web800 kernel: php5-fpm[20429]: segfault at 0 ip
00007f90bf2d26bf sp 00007ffde86f4bb8 error 6 in
libsqlrclient-0.41.so.1.0.0[7f90bf2c0000+18000]

Every request caused SIGSEGV and then master process spawn new process
etc....but final result is HTTP 500 for every single request.

May 17 06:08:27 webX00 php-fpm[15086]: [WARNING] [pool fo-currys] child
17373 exited on signal 11 (SIGSEGV - core dumped) after 23.731039 seconds
from start


I try to understand from OS point of view what it does mean:

http://stackoverflow.com/questions/2549214/interpreting-segfault-messages

I anyone solved similar issue please advise.

Thank you very much


Jiri

[Sqlrelay-discussion] SQLRelay Proxy Configuration

[Tom <to...@th...>]

Hello,



Thanks fort he great product.



The connection to Postgres via SQLRSH and via the Postgresql-Dropin from
localhost (the machine running the SQLR-START) works fine.

I see as well, a service runs on 0.0.0.0:5432:



[root@sqlr /]# netstat -nalp | grep :5432

tcp        0      0 0.0.0.0:5432            0.0.0.0:*
LISTEN      22121/sqlr-listener



Now I try to connect from another machine directly tot he sqlr-listener
with psql:



[root@pclient /]# psql -h sqlr -p 5432 -U user -W mydb



I get asked for the password, but no psql commandline appears.



How can I use the SQLRelay really as proxy speaking native postgresql to
the backend ?



Any help is appreciated.



Thomas

[Sqlrelay-discussion] (no subject)

[Moses G. <mos...@gm...>]

I am try to install and use sqlrelay with php pdo mysql in Debian 7.1 wheezy

the steps that i followed

first download sqlrealy and rudiments

Tar vxzf rudiments-0.48.tar.gz
Cd rudiments-0.48
. / Configure – prefix = /usr/local/rudiments
Make
Make install

Tar vxzf sqlrelay-0.57.tar.gz

Cd sqlrelay-0.57

apt-get install php5-dev

./configure --prefix=/usr/local/sqlrelay
--with-rudiments-prefix=/usr/local/rudiments

then i got this output

        ***** Summary ***********************************************
         Version      : 0.57

         Command Line : Readline Support          no


         APIs         : C/C++       yes           Perl       yes
                        Python      no            Ruby       no
                        PHP         yes           Java       yes
                        PHP PDO     yes           ODBC       no
                        TCL         no            Erlang     no

         Connections  : Oracle8     no            MySQL      dynamic
                        PostgreSQL  no            SQLite     no
                        FreeTDS     no            Sybase     no
                        ODBC        no            DB2        no
                        Firebird    no            MDB Tools  no
        *************************************************************

Make

Make install

extension=pdo_sqlrelay.so in php.ini and finally restart apache2

but while restating apache2 i get this error in apache2 error.log

[] [notice] caught SIGTERM, shutting down PHP Warning: PHP Startup: Unable
to load dynamic library '/usr/lib/php5/20100525/pdo_sqlrelay.so' -
/usr/lib/php5/20100525/pdo_sqlrelay.so: undefined symbol:
php_pdo_int64_to_str in Unknown on line 0 [] [notice] Apache/2.2.22
(Debian) PHP/5.4.4-14+deb7u14 mod_ssl/2.2.22 OpenSSL/1.0.1e configured --
resuming normal operations

but i have this file /usr/lib/php5/20100525/pdo_sqlrelay.so present in that
same location
-- 
*Thanks and Regards,*
*Moses  Gangipogu*

Re: [Sqlrelay-discussion] Error While runnnig SQL Relay ..

[MA M. A. (5542) <MAn...@ag...>]

You will get such a response if there is no instance running with the specified id. Are you sure you have the name right? What is the output you get when you run sqlr-start? Please also supply a list of the running processes for the sqlrelay user.

________________________________
From: Rahul Sharma [ra...@in...]
Sent: Monday, August 18, 2014 5:24 AM
To: sql...@li...
Subject: [Sqlrelay-discussion] Error While runnnig SQL Relay ..

HI All,
      I have installed SQLRELAY on my Oracle Database , But as soon as i start it and try to use it gives me below error:-


[oracle@ora5 ~]$ /usr/local/firstworks/bin/sqlr-status -id test_mesh
Couldn't attach to shared memory segment: No such file or directory



--
Thanks & Regards
Rahul Sharma
Manager Database
IndiaMART Intermesh Ltd.

[X]<http://www.indiamart.com/mobile/>

Follow IndiaMART.com<http://www.indiamart.com> for latest updates on this and more: [X] <https://plus.google.com/+indiamart>  [X] <https://www.facebook.com/IndiaMART>  [X] <https://twitter.com/IndiaMART>  Mobile Channel: [X] <https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8>  [X] <https://play.google.com/store/apps/details?id=com.indiamart.m>  [X] <http://m.indiamart.com/>
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>Watch How to grow your business with IndiaMART's award winning product - "Buy Leads"<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>.

[Sqlrelay-discussion] Error While runnnig SQL Relay ..

[Rahul S. <ra...@in...>]

HI All,
      I have installed SQLRELAY on my Oracle Database , But as soon as i
start it and try to use it gives me below error:-


[oracle@ora5 ~]$ /usr/local/firstworks/bin/sqlr-status -id test_mesh
Couldn't attach to shared memory segment: No such file or directory



-- 
*Thanks & Regards*
*Rahul Sharma*
*Manager **Database*
*IndiaMART Intermesh Ltd.*

-- 
 <http://www.indiamart.com/mobile/>

Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this 
and more: <https://plus.google.com/+indiamart> 
<https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART> Mobile 
Channel: 
<https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8> 
<https://play.google.com/store/apps/details?id=com.indiamart.m> 
<http://m.indiamart.com/>
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>*Watch 
How to grow your business with IndiaMART's award winning product - "Buy 
Leads" 
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>.*

Re: [Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client

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

Hmmm.   You're right.  That's interesting...  I wonder how Oracle is 
building those RPM's.  There's a step at the end of the process where 
rpmbuild digs through the files and automatically builds the list of 
files that it provides.  Or at least, it appears to.  Maybe it doesn't 
though.  Maybe that has to be done manually.  I wonder if the SQL Relay 
RPM's have the same issue!

I'd bet that it would be fairly straightforward to build a spec file 
that re-packages the oracle RPM's and includes that info.

Dave

On 7/3/2014 9:21 AM, MA Martin Andrews (5542) wrote:
> I am installing the rpm's from our custom repo. I think the problem is with the instant client rpm - it does not say it "provides" any if the libraries it contains:
>
> [root@stg-sqlrelay1 ~]# rpm -q --provides oracle-instantclient12.1-basic
> oracle-instantclient12.1-basic = 12.1.0.1.0-1
>
> For you edification - here is the full output I get when installing the rpm with yum:
>
> [root@stg-sqlrelay1 ~]#
> [root@stg-sqlrelay1 ~]# yum install -y oracle-instantclient12.1-basic
> Loaded plugins: fastestmirror
> Loading mirror speeds from cached hostfile
>   * agcom: cf
>   * base: cf
>   * epel: cf
>   * extras: cf
>   * update: cf
> Setting up Install Process
> Resolving Dependencies
> --> Running transaction check
> ---> Package oracle-instantclient12.1-basic.x86_64 0:12.1.0.1.0-1 will be installed
> --> Finished Dependency Resolution
>
> Dependencies Resolved
>
> ==========================================================================================
>   Package                              Arch         Version              Repository   Size
> ==========================================================================================
> Installing:
>   oracle-instantclient12.1-basic       x86_64       12.1.0.1.0-1         agcom        67 M
>
> Transaction Summary
> ==========================================================================================
> Install       1 Package(s)
>
> Total size: 67 M
> Installed size: 205 M
> Downloading Packages:
> Running rpm_check_debug
> Running Transaction Test
> Transaction Test Succeeded
> Running Transaction
>    Installing : oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64                     1/1
>    Verifying  : oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64                     1/1
>
> Installed:
>    oracle-instantclient12.1-basic.x86_64 0:12.1.0.1.0-1
>
> Complete!
> [root@stg-sqlrelay1 ~]#
> [root@stg-sqlrelay1 ~]# yum install -y sqlrelay-oracle8
> Loaded plugins: fastestmirror
> Loading mirror speeds from cached hostfile
>   * agcom: cf
>   * base: cf
>   * epel: cf
>   * extras: cf
>   * update: cf
> Setting up Install Process
> Resolving Dependencies
> --> Running transaction check
> ---> Package sqlrelay-oracle8.x86_64 0:0.54-1 will be installed
> --> Processing Dependency: libclntsh.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
> --> Processing Dependency: libnnz12.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
> --> Processing Dependency: libons.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
> --> Processing Dependency: libclntshcore.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
> --> Finished Dependency Resolution
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>             Requires: libclntshcore.so.12.1()(64bit)
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>             Requires: libons.so()(64bit)
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>             Requires: libclntsh.so.12.1()(64bit)
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>             Requires: libnnz12.so()(64bit)
>   You could try using --skip-broken to work around the problem
>   You could try running: rpm -Va --nofiles --nodigest
> [root@stg-sqlrelay1 ~]#
>
> -----Original Message-----
> From: David Muse [mailto:dav...@fi...]
> Sent: Wednesday, July 02, 2014 9:24 PM
> To: Discussion of topics related to SQL Relay
> Subject: Re: [Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client
>
> Hi Martin,
>
> ...
>
> Did you install instantclient using yum or rpm?
>
> ...
>
> It looks like you've set up your own repo to install sqlrelay from.  A
> solution would be to put the oracle instantclient rpms in your yum repo
> as well.  If you already did that though then I'm not sure what's going
> on.  I'd probably need to run some tests here and/or poke around on your
> system.
>
> Dave
> dav...@fi...
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client

[MA M. A. (5542) <MAn...@ag...>]

I am installing the rpm's from our custom repo. I think the problem is with the instant client rpm - it does not say it "provides" any if the libraries it contains:

[root@stg-sqlrelay1 ~]# rpm -q --provides oracle-instantclient12.1-basic
oracle-instantclient12.1-basic = 12.1.0.1.0-1

For you edification - here is the full output I get when installing the rpm with yum:

[root@stg-sqlrelay1 ~]# 
[root@stg-sqlrelay1 ~]# yum install -y oracle-instantclient12.1-basic
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * agcom: cf
 * base: cf
 * epel: cf
 * extras: cf
 * update: cf
Setting up Install Process
Resolving Dependencies  
--> Running transaction check
---> Package oracle-instantclient12.1-basic.x86_64 0:12.1.0.1.0-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================
 Package                              Arch         Version              Repository   Size
==========================================================================================
Installing:
 oracle-instantclient12.1-basic       x86_64       12.1.0.1.0-1         agcom        67 M

Transaction Summary
==========================================================================================
Install       1 Package(s)

Total size: 67 M
Installed size: 205 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64                     1/1 
  Verifying  : oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64                     1/1 

Installed:
  oracle-instantclient12.1-basic.x86_64 0:12.1.0.1.0-1                                    

Complete!
[root@stg-sqlrelay1 ~]# 
[root@stg-sqlrelay1 ~]# yum install -y sqlrelay-oracle8
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * agcom: cf
 * base: cf
 * epel: cf
 * extras: cf
 * update: cf
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package sqlrelay-oracle8.x86_64 0:0.54-1 will be installed
--> Processing Dependency: libclntsh.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libnnz12.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libons.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libclntshcore.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Finished Dependency Resolution
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libclntshcore.so.12.1()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libons.so()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libclntsh.so.12.1()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libnnz12.so()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@stg-sqlrelay1 ~]#

-----Original Message-----
From: David Muse [mailto:dav...@fi...] 
Sent: Wednesday, July 02, 2014 9:24 PM
To: Discussion of topics related to SQL Relay
Subject: Re: [Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client

Hi Martin,

...

Did you install instantclient using yum or rpm?

...

It looks like you've set up your own repo to install sqlrelay from.  A 
solution would be to put the oracle instantclient rpms in your yum repo 
as well.  If you already did that though then I'm not sure what's going 
on.  I'd probably need to run some tests here and/or poke around on your 
system.

Dave
dav...@fi...

Re: [Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client

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

Hi Martin,

Unfortunately the mailing list is all but dead.  People just aren't fond 
of mass email any more.  Feel free to send questions like this directly 
to me though.

Did you install instantclient using yum or rpm?

If you installed it using rpm, then...

I'm not exactly sure how yum does its dependency resolution but I 
suspect that it does it by integrating all of the repodata into a single 
local database and resolving dependencies against that.  I don't believe 
that it integrates the local rpm database as well.

If you installed the oracle instantclient rpms using rpm then their 
files would be in the rpm database.  If you then installed the sqlrelay 
rpms using rpm rather than yum, then rpm should find the dependencies in 
the rpm database and not display any error.

But, if you install the oracle instantclient rpms using rpm and then 
install sqlrelay using yum, yum might only look in the repodata to 
resolve dependencies and since the instantclient rpms aren't in that 
repodata, their files aren't found.  I'm not 100% sure of that, but I 
suspect that's what's happening.

It looks like you've set up your own repo to install sqlrelay from.  A 
solution would be to put the oracle instantclient rpms in your yum repo 
as well.  If you already did that though then I'm not sure what's going 
on.  I'd probably need to run some tests here and/or poke around on your 
system.

Dave
dav...@fi...

On 7/2/2014 4:16 PM, MA Martin Andrews (5542) wrote:
> I am trying to install the binary distributed rpm’s using yum, and I am
> getting complaints about missing dependencies when installing
> sqlrelay-oracle8-0.54-1.x86_64 . The “missing” libraries are installed
> via oracle’s instant client rpm. If I forcefully install the
> sqlrelay-oracle8 rpm, sqlrelay is able to connect to oracle okay. I
> would like to use yum for our installs. Any ideas on avoiding the
> dependency errors?
>
> [root@stg-sqlrelay1 ~]# yum  install sqlrelay-oracle8
>
> Loaded plugins: fastestmirror
>
> Loading mirror speeds from cached hostfile
>
> * agcom: cf
>
> * base: cf
>
> * epel: cf
>
> * extras: cf
>
> * update: cf
>
> Setting up Install Process
>
> Resolving Dependencies
>
> --> Running transaction check
>
> ---> Package sqlrelay-oracle8.x86_64 0:0.54-1 will be installed
>
> --> Processing Dependency: libclntsh.so.12.1()(64bit) for package:
> sqlrelay-oracle8-0.54-1.x86_64
>
> --> Processing Dependency: libnnz12.so()(64bit) for package:
> sqlrelay-oracle8-0.54-1.x86_64
>
> --> Processing Dependency: libons.so()(64bit) for package:
> sqlrelay-oracle8-0.54-1.x86_64
>
> --> Processing Dependency: libclntshcore.so.12.1()(64bit) for package:
> sqlrelay-oracle8-0.54-1.x86_64
>
> --> Finished Dependency Resolution
>
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>
>             Requires: libclntshcore.so.12.1()(64bit)
>
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>
>             Requires: libons.so()(64bit)
>
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>
>             Requires: libclntsh.so.12.1()(64bit)
>
> Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
>
>             Requires: libnnz12.so()(64bit)
>
> You could try using --skip-broken to work around the problem
>
> You could try running: rpm -Va --nofiles –nodigest
>
> [root@stg-sqlrelay1 ~]# ls /usr/lib/oracle/12.1/client64/lib
>
> libclntshcore.so.12.1  libocci.so.12.1  libons.so         ojdbc7.jar
>
> libclntsh.so.12.1      libociei.so      liboramysql12.so  xstreams.jar
>
> libnnz12.so            libocijdbc12.so  ojdbc6.jar
>
> [root@stg-sqlrelay1 ~]# rpm -qi oracle-instantclient12.1-basic
>
> Name        : oracle-instantclient12.1-basic  Relocations: (not relocatable)
>
> Version     : 12.1.0.1.0                        Vendor: Oracle Corporation
>
> Release     : 1                             Build Date: Fri 24 May 2013
> 01:22:52 PM EDT
>
> Install Date: Tue 24 Jun 2014 12:56:25 PM EDT      Build Host:
> adc4150438.us.oracle.com
>
> Group       : Applications/File             Source RPM:
> oracle-instantclient12.1-basic-12.1.0.1.0-1.src.rpm
>
> Size        : 214591244                        License: Oracle
>
> Signature   : (none)
>
> Packager    : Nobody <no...@or...>
>
> URL         : http://www.oracle.com/
>
> Summary     : Instant Client for Oracle Database 11g
>
> Description :
>
> Instant Client allows you to run your applications without installing
> the standard Oracle client or having an ORACLE_HOME.  OCI, OCCI, ODBC,
> and JDBC applications work without modification, while using
> significantly less disk space than before.  No recompile, no hassle.
>
> This is the Basic package, supporting OCI, OCCI, and JDBC-OCI with all
>
> languages.
>
> --------
>
> Martin Andrews
>
> man...@ag...
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
>
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

[Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client

[MA M. A. (5542) <MAn...@ag...>]

I am trying to install the binary distributed rpm's using yum, and I am getting complaints about missing dependencies when installing sqlrelay-oracle8-0.54-1.x86_64 . The "missing" libraries are installed via oracle's instant client rpm. If I forcefully install the sqlrelay-oracle8 rpm, sqlrelay is able to connect to oracle okay. I would like to use yum for our installs. Any ideas on avoiding the dependency errors?

[root@stg-sqlrelay1 ~]# yum  install sqlrelay-oracle8
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* agcom: cf
* base: cf
* epel: cf
* extras: cf
* update: cf
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package sqlrelay-oracle8.x86_64 0:0.54-1 will be installed
--> Processing Dependency: libclntsh.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libnnz12.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libons.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libclntshcore.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Finished Dependency Resolution
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libclntshcore.so.12.1()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libons.so()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libclntsh.so.12.1()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libnnz12.so()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles -nodigest


[root@stg-sqlrelay1 ~]# ls /usr/lib/oracle/12.1/client64/lib
libclntshcore.so.12.1  libocci.so.12.1  libons.so         ojdbc7.jar
libclntsh.so.12.1      libociei.so      liboramysql12.so  xstreams.jar
libnnz12.so            libocijdbc12.so  ojdbc6.jar


[root@stg-sqlrelay1 ~]# rpm -qi oracle-instantclient12.1-basic
Name        : oracle-instantclient12.1-basic  Relocations: (not relocatable)
Version     : 12.1.0.1.0                        Vendor: Oracle Corporation
Release     : 1                             Build Date: Fri 24 May 2013 01:22:52 PM EDT
Install Date: Tue 24 Jun 2014 12:56:25 PM EDT      Build Host: adc4150438.us.oracle.com
Group       : Applications/File             Source RPM: oracle-instantclient12.1-basic-12.1.0.1.0-1.src.rpm
Size        : 214591244                        License: Oracle
Signature   : (none)
Packager    : Nobody <no...@or...>
URL         : http://www.oracle.com/
Summary     : Instant Client for Oracle Database 11g
Description :
Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME.  OCI, OCCI, ODBC, and JDBC applications work without modification, while using significantly less disk space than before.  No recompile, no hassle.

This is the Basic package, supporting OCI, OCCI, and JDBC-OCI with all
languages.

--------
Martin Andrews
man...@ag...

[Sqlrelay-discussion] Batched Statements with Router

[Chris T. <bla...@gm...>]

I am using the Router to separate create,update,drop,delete,insert from
selects for the purpose of a Master Slave setup, when using MySQL to
connect.

When trying to use batch statements directly to the router (via ODBC
connector) it fails to process, if i sqlrsh, the statements are executed
one by one.  Is this intended behavior, is it something that can be
adjusted with a setting (looked everywhere maybe i just dunno what i'm
looking for).

[Sqlrelay-discussion] Sqlrely 0.55 PHP pdo issue

[lee a. <an...@gm...>]

Hi all
We are testing sqlrely's PDO extension with mysql and getting some problems.
When execute "SHOW FULL COLUMS FROM table"
Column 'Type' 'Default' return a resource instead of string .

Any suggestion will be appreciated

Many thnaks
Angus

Re: [Sqlrelay-discussion] include config files using XML entities?

[Cal H. <ca...@fb...>]

Okay thanks for the info David.  It's not that important, just a nicety, as
you said.  I've got about 40 different database instances to manage, and it
would make it a little more convenient for puppet to manage.


---------------------------------------------------------------
Cal Heldenbrand
   Web Operations at FBS
   Creators of flexmls <http://flexmls.com>® and Spark
Platform<http://sparkplatform.com>
   ca...@fb...


On Wed, Jan 8, 2014 at 11:36 AM, David Muse <dav...@fi...>wrote:

> Hi Cal,
>
> Unfortunately, the ENTITY tag isn't currently supported.  SQL Relay uses
> a fairly simple XML parser from the Rudiments library that doesn't
> support a few things, including entity tags.  It does support "built-in"
> entities like &quot; and &apos; and &#110; and so forth, but not
> entities defined with the entity tag.
>
> It is on my to-do list.  It's funny, it's is actually one of the older
> tasks in my PM system but it's always been in the "nice-to-have"
> category and I just haven't gotten around to it yet.
>
> If it's is important to you guys, then I'd be happy to implement it for
> you on a contract basis.  Let me know if you're interested.
>
> Dave
> dav...@fi...
>
> On 1/7/2014 2:44 PM, Cal Heldenbrand wrote:
> > Hi everyone,
> >
> > Is it possible to create a file hierarchy for the config file using the
> > ENTITY tag in DOCTYPE?  Here's what I tried in sqlrelay.conf:
> >
> > --------------------------------------------------------
> > <?xml version="1.0"?>
> > <!DOCTYPE instances SYSTEM "sqlrelay.dtd" [
> >    <!ENTITY server1 SYSTEM "/opt/sqlrelay/etc/db2/server1.xml">
> > ]>
> > <instances>
> >    &server1;
> > </instances>
> > --------------------------------------------------------
> >
> > ----------------  server1.xml  --------------------
> > <instance id="server1"
> >     ...
> >>
> >     <connections> ...
> > </instance>
> > --------------------------------------------------------
> >
> > But, it seems that on startup, sql relay does not find my "server1"
> > instance and it fails, with no error logs or anything useful.
> >
> > # ./sqlr-start -id server1
> > Couldn't find id server1.
> >
> > Does the XML parser just plain not support doing include files?  Or can
> > you spot anything wrong with my syntax?  I'm certainly no XML expert.
> >
> > Thanks!
> >
> > --Cal
> >
> >
> >
> ------------------------------------------------------------------------------
> > Rapidly troubleshoot problems before they affect your business. Most IT
> > organizations don't have a clear picture of how application performance
> > affects their revenue. With AppDynamics, you get 100% visibility into
> your
> > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
> AppDynamics Pro!
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> >
> > _______________________________________________________
> > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> >                http://www.doteasy.com
> >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] include config files using XML entities?

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

Hi Cal,

Unfortunately, the ENTITY tag isn't currently supported.  SQL Relay uses 
a fairly simple XML parser from the Rudiments library that doesn't 
support a few things, including entity tags.  It does support "built-in" 
entities like " and ' and n and so forth, but not 
entities defined with the entity tag.

It is on my to-do list.  It's funny, it's is actually one of the older 
tasks in my PM system but it's always been in the "nice-to-have" 
category and I just haven't gotten around to it yet.

If it's is important to you guys, then I'd be happy to implement it for 
you on a contract basis.  Let me know if you're interested.

Dave
dav...@fi...

On 1/7/2014 2:44 PM, Cal Heldenbrand wrote:
> Hi everyone,
>
> Is it possible to create a file hierarchy for the config file using the
> ENTITY tag in DOCTYPE?  Here's what I tried in sqlrelay.conf:
>
> --------------------------------------------------------
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd" [
>    <!ENTITY server1 SYSTEM "/opt/sqlrelay/etc/db2/server1.xml">
> ]>
> <instances>
>    &server1;
> </instances>
> --------------------------------------------------------
>
> ----------------  server1.xml  --------------------
> <instance id="server1"
>     ...
>>
>     <connections> ...
> </instance>
> --------------------------------------------------------
>
> But, it seems that on startup, sql relay does not find my "server1"
> instance and it fails, with no error logs or anything useful.
>
> # ./sqlr-start -id server1
> Couldn't find id server1.
>
> Does the XML parser just plain not support doing include files?  Or can
> you spot anything wrong with my syntax?  I'm certainly no XML expert.
>
> Thanks!
>
> --Cal
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
>
> _______________________________________________
> 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
>

[Sqlrelay-discussion] include config files using XML entities?

[Cal H. <ca...@fb...>]

Hi everyone,

Is it possible to create a file hierarchy for the config file using the
ENTITY tag in DOCTYPE?  Here's what I tried in sqlrelay.conf:

--------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd" [
  <!ENTITY server1 SYSTEM "/opt/sqlrelay/etc/db2/server1.xml">
]>
<instances>
  &server1;
</instances>
--------------------------------------------------------

----------------  server1.xml  --------------------
<instance id="server1"
   ...
>
   <connections> ...
</instance>
--------------------------------------------------------

But, it seems that on startup, sql relay does not find my "server1"
instance and it fails, with no error logs or anything useful.

# ./sqlr-start -id server1
Couldn't find id server1.

Does the XML parser just plain not support doing include files?  Or can you
spot anything wrong with my syntax?  I'm certainly no XML expert.

Thanks!

--Cal

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

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

Woohoo!  No problem.

On 1/6/2014 4:08 PM, Cal Heldenbrand wrote:
> Hi David,
>
> Yes, that appears to work as expected.  Thanks for the quick fix!
>
> --Cal
>
>
> On Wed, Jan 1, 2014 at 5:41 PM, David Muse <dav...@fi...
> <mailto:dav...@fi...>> wrote:
>
>     Hi Cal,
>
>     It looks like I forgot to flip the sense of an if when I un-nested its
>     contents.
>
>     It'll be fixed in the next release of sqlrelay/rudiments, but for a
>     quick fix...
>
>     In the rudiments library, edit src/socketclient.cpp (or if you're using
>     an older version, src/clientsocket.cpp) and look for an if statement
>     like this, near line 235:
>
>              if (error::getErrorNumber()==EINPROGRESS ||
>                      error::getErrorNumber()==EWOULDBLOCK) {
>                      retval=RESULT_ERROR;
>                      goto cleanup;
>              }
>
>     Change it to:
>
>              if (error::getErrorNumber()!=EINPROGRESS &&
>                      error::getErrorNumber()!=EWOULDBLOCK) {
>                      retval=RESULT_ERROR;
>                      goto cleanup;
>              }
>
>     Note the !='s rather than =='s and && rather than ||.
>
>     Recompile and reinstall rudiments:
>
>              make
>              sudo make install
>
>     And it should work.
>
>     Let me know if you run into any more problems.
>
>     And thanks for finding that bug!
>
>     Dave
>     dav...@fi... <mailto:dav...@fi...>
>
>     On 1/1/2014 6:23 PM, David Muse wrote:
>      > Hi Cal,
>      >
>      > Interesting...  I'll do some tests here, figure out what's
>     happening and
>      > let you know what I find.
>      >
>      > Dave
>      >
>      > On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
>      >> Hi David,
>      >>
>      >> I'm attempting to write a weighted round-robin connection method
>     for an
>      >> easy failover mechanism on multiple SQL Relay servers.  It
>     appears that
>      >> the C++ sqlrconnection::setConnectTimeout() function isn't
>     behaving like
>      >> I'd expect.  It seems that no matter what values I pass to it, the
>      >> connection *always* fails.
>      >>
>      >> Here's the general idea I'm doing:
>      >>
>      >> bool success = false;
>      >> do
>      >> {
>      >>       /*
>      >>         select random sql relay server
>      >>        */
>      >>
>      >>        tmpconn = new sqlrconnection(hostname, port, NULL,
>      >>              user, pass, 0, 1);
>      >>        tmpconn->debugOn();
>      >>        tmpconn->setConnectTimeout(10, 5000000);
>      >>
>      >>        const char *version = tmpconn->serverVersion();
>      >>        printf("version: '%s'\n", version);
>      >>        if ( version )
>      >>           success = true;
>      >>
>      >>        /* Breaking out after a few tries */
>      >> }
>      >> while ( success == false );
>      >>
>      >> Running that, I get something like this:
>      >>
>      >> <pre>
>      >> Connecting to listener...
>      >> </pre>
>      >> <pre>
>      >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>     <http://127.0.0.1:9000>
>      >> </pre>
>      >> <pre>
>      >> Setting Error
>      >> </pre>
>      >> <pre>
>      >> Couldn't connect to the listener.
>      >> </pre>
>      >> version: '(null)'
>      >>
>      >> But when I comment out the setConnectTimeout() call, it works
>     just fine:
>      >>
>      >> <pre>
>      >> Connecting to listener...
>      >> </pre>
>      >> <pre>
>      >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>     <http://127.0.0.1:9000>
>      >> </pre>
>      >> <pre>
>      >> Authenticating :  ...
>      >> </pre>
>      >> <pre>
>      >> Server Version...
>      >> </pre>
>      >> <pre>
>      >> Checking for error
>      >> </pre>
>      >> <pre>
>      >> No error occurred
>      >> </pre>
>      >> <pre>
>      >> 0.53.1
>      >> </pre>
>      >> version: '0.53.1'
>      >>
>      >> I've played around with different values for seconds and
>     microseconds.
>      >> (I want a timeout of 5 seconds, however that can be accomplished)
>      >>
>      >> Thanks for any help!
>      >>
>      >> --Cal
>      >>
>      >>
>      >>
>     ------------------------------------------------------------------------------
>      >>
>      >> Rapidly troubleshoot problems before they affect your business.
>     Most IT
>      >> organizations don't have a clear picture of how application
>     performance
>      >> affects their revenue. With AppDynamics, you get 100% visibility
>     into
>      >> your
>      >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>      >> AppDynamics Pro!
>      >>
>     http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>      >>
>      >>
>      >> _______________________________________________________
>      >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>      >> http://www.doteasy.com
>      >>
>      >>
>      >>
>      >> _______________________________________________
>      >> Sqlrelay-discussion mailing list
>      >> Sql...@li...
>     <mailto:Sql...@li...>
>      >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>      >>
>      >>
>      >> _______________________________________________________
>      >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>      >> http://www.doteasy.com
>      >>
>
>     ------------------------------------------------------------------------------
>     Rapidly troubleshoot problems before they affect your business. Most IT
>     organizations don't have a clear picture of how application performance
>     affects their revenue. With AppDynamics, you get 100% visibility
>     into your
>     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>     AppDynamics Pro!
>     http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>     _______________________________________________
>     Sqlrelay-discussion mailing list
>     Sql...@li...
>     <mailto:Sql...@li...>
>     https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
>
> _______________________________________________
> 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
>

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

[Cal H. <ca...@fb...>]

Hi David,

Yes, that appears to work as expected.  Thanks for the quick fix!

--Cal


On Wed, Jan 1, 2014 at 5:41 PM, David Muse <dav...@fi...>wrote:

> Hi Cal,
>
> It looks like I forgot to flip the sense of an if when I un-nested its
> contents.
>
> It'll be fixed in the next release of sqlrelay/rudiments, but for a
> quick fix...
>
> In the rudiments library, edit src/socketclient.cpp (or if you're using
> an older version, src/clientsocket.cpp) and look for an if statement
> like this, near line 235:
>
>         if (error::getErrorNumber()==EINPROGRESS ||
>                 error::getErrorNumber()==EWOULDBLOCK) {
>                 retval=RESULT_ERROR;
>                 goto cleanup;
>         }
>
> Change it to:
>
>         if (error::getErrorNumber()!=EINPROGRESS &&
>                 error::getErrorNumber()!=EWOULDBLOCK) {
>                 retval=RESULT_ERROR;
>                 goto cleanup;
>         }
>
> Note the !='s rather than =='s and && rather than ||.
>
> Recompile and reinstall rudiments:
>
>         make
>         sudo make install
>
> And it should work.
>
> Let me know if you run into any more problems.
>
> And thanks for finding that bug!
>
> Dave
> dav...@fi...
>
> On 1/1/2014 6:23 PM, David Muse wrote:
> > Hi Cal,
> >
> > Interesting...  I'll do some tests here, figure out what's happening and
> > let you know what I find.
> >
> > Dave
> >
> > On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
> >> Hi David,
> >>
> >> I'm attempting to write a weighted round-robin connection method for an
> >> easy failover mechanism on multiple SQL Relay servers.  It appears that
> >> the C++ sqlrconnection::setConnectTimeout() function isn't behaving like
> >> I'd expect.  It seems that no matter what values I pass to it, the
> >> connection *always* fails.
> >>
> >> Here's the general idea I'm doing:
> >>
> >> bool success = false;
> >> do
> >> {
> >>       /*
> >>         select random sql relay server
> >>        */
> >>
> >>        tmpconn = new sqlrconnection(hostname, port, NULL,
> >>              user, pass, 0, 1);
> >>        tmpconn->debugOn();
> >>        tmpconn->setConnectTimeout(10, 5000000);
> >>
> >>        const char *version = tmpconn->serverVersion();
> >>        printf("version: '%s'\n", version);
> >>        if ( version )
> >>           success = true;
> >>
> >>        /* Breaking out after a few tries */
> >> }
> >> while ( success == false );
> >>
> >> Running that, I get something like this:
> >>
> >> <pre>
> >> Connecting to listener...
> >> </pre>
> >> <pre>
> >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> >> </pre>
> >> <pre>
> >> Setting Error
> >> </pre>
> >> <pre>
> >> Couldn't connect to the listener.
> >> </pre>
> >> version: '(null)'
> >>
> >> But when I comment out the setConnectTimeout() call, it works just fine:
> >>
> >> <pre>
> >> Connecting to listener...
> >> </pre>
> >> <pre>
> >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> >> </pre>
> >> <pre>
> >> Authenticating :  ...
> >> </pre>
> >> <pre>
> >> Server Version...
> >> </pre>
> >> <pre>
> >> Checking for error
> >> </pre>
> >> <pre>
> >> No error occurred
> >> </pre>
> >> <pre>
> >> 0.53.1
> >> </pre>
> >> version: '0.53.1'
> >>
> >> I've played around with different values for seconds and microseconds.
> >> (I want a timeout of 5 seconds, however that can be accomplished)
> >>
> >> Thanks for any help!
> >>
> >> --Cal
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >>
> >> Rapidly troubleshoot problems before they affect your business. Most IT
> >> organizations don't have a clear picture of how application performance
> >> affects their revenue. With AppDynamics, you get 100% visibility into
> >> your
> >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
> >> AppDynamics Pro!
> >>
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> >>
> >>
> >> _______________________________________________________
> >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> >>                http://www.doteasy.com
> >>
> >>
> >>
> >> _______________________________________________
> >> 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
> >>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

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

Hi Cal,

It looks like I forgot to flip the sense of an if when I un-nested its 
contents.

It'll be fixed in the next release of sqlrelay/rudiments, but for a 
quick fix...

In the rudiments library, edit src/socketclient.cpp (or if you're using 
an older version, src/clientsocket.cpp) and look for an if statement 
like this, near line 235:

	if (error::getErrorNumber()==EINPROGRESS ||
		error::getErrorNumber()==EWOULDBLOCK) {
		retval=RESULT_ERROR;
		goto cleanup;
	}

Change it to:

	if (error::getErrorNumber()!=EINPROGRESS &&
		error::getErrorNumber()!=EWOULDBLOCK) {
		retval=RESULT_ERROR;
		goto cleanup;
	}

Note the !='s rather than =='s and && rather than ||.

Recompile and reinstall rudiments:

	make
	sudo make install

And it should work.

Let me know if you run into any more problems.

And thanks for finding that bug!

Dave
dav...@fi...

On 1/1/2014 6:23 PM, David Muse wrote:
> Hi Cal,
>
> Interesting...  I'll do some tests here, figure out what's happening and
> let you know what I find.
>
> Dave
>
> On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
>> Hi David,
>>
>> I'm attempting to write a weighted round-robin connection method for an
>> easy failover mechanism on multiple SQL Relay servers.  It appears that
>> the C++ sqlrconnection::setConnectTimeout() function isn't behaving like
>> I'd expect.  It seems that no matter what values I pass to it, the
>> connection *always* fails.
>>
>> Here's the general idea I'm doing:
>>
>> bool success = false;
>> do
>> {
>>       /*
>>         select random sql relay server
>>        */
>>
>>        tmpconn = new sqlrconnection(hostname, port, NULL,
>>              user, pass, 0, 1);
>>        tmpconn->debugOn();
>>        tmpconn->setConnectTimeout(10, 5000000);
>>
>>        const char *version = tmpconn->serverVersion();
>>        printf("version: '%s'\n", version);
>>        if ( version )
>>           success = true;
>>
>>        /* Breaking out after a few tries */
>> }
>> while ( success == false );
>>
>> Running that, I get something like this:
>>
>> <pre>
>> Connecting to listener...
>> </pre>
>> <pre>
>> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>> </pre>
>> <pre>
>> Setting Error
>> </pre>
>> <pre>
>> Couldn't connect to the listener.
>> </pre>
>> version: '(null)'
>>
>> But when I comment out the setConnectTimeout() call, it works just fine:
>>
>> <pre>
>> Connecting to listener...
>> </pre>
>> <pre>
>> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>> </pre>
>> <pre>
>> Authenticating :  ...
>> </pre>
>> <pre>
>> Server Version...
>> </pre>
>> <pre>
>> Checking for error
>> </pre>
>> <pre>
>> No error occurred
>> </pre>
>> <pre>
>> 0.53.1
>> </pre>
>> version: '0.53.1'
>>
>> I've played around with different values for seconds and microseconds.
>> (I want a timeout of 5 seconds, however that can be accomplished)
>>
>> Thanks for any help!
>>
>> --Cal
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Rapidly troubleshoot problems before they affect your business. Most IT
>> organizations don't have a clear picture of how application performance
>> affects their revenue. With AppDynamics, you get 100% visibility into
>> your
>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>> AppDynamics Pro!
>> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>>
>>
>> _______________________________________________________
>> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>>                http://www.doteasy.com
>>
>>
>>
>> _______________________________________________
>> 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
>>

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

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

Hi Cal,

Interesting...  I'll do some tests here, figure out what's happening and 
let you know what I find.

Dave

On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
> Hi David,
>
> I'm attempting to write a weighted round-robin connection method for an
> easy failover mechanism on multiple SQL Relay servers.  It appears that
> the C++ sqlrconnection::setConnectTimeout() function isn't behaving like
> I'd expect.  It seems that no matter what values I pass to it, the
> connection *always* fails.
>
> Here's the general idea I'm doing:
>
> bool success = false;
> do
> {
>       /*
>         select random sql relay server
>        */
>
>        tmpconn = new sqlrconnection(hostname, port, NULL,
>              user, pass, 0, 1);
>        tmpconn->debugOn();
>        tmpconn->setConnectTimeout(10, 5000000);
>
>        const char *version = tmpconn->serverVersion();
>        printf("version: '%s'\n", version);
>        if ( version )
>           success = true;
>
>        /* Breaking out after a few tries */
> }
> while ( success == false );
>
> Running that, I get something like this:
>
> <pre>
> Connecting to listener...
> </pre>
> <pre>
> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> </pre>
> <pre>
> Setting Error
> </pre>
> <pre>
> Couldn't connect to the listener.
> </pre>
> version: '(null)'
>
> But when I comment out the setConnectTimeout() call, it works just fine:
>
> <pre>
> Connecting to listener...
> </pre>
> <pre>
> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> </pre>
> <pre>
> Authenticating :  ...
> </pre>
> <pre>
> Server Version...
> </pre>
> <pre>
> Checking for error
> </pre>
> <pre>
> No error occurred
> </pre>
> <pre>
> 0.53.1
> </pre>
> version: '0.53.1'
>
> I've played around with different values for seconds and microseconds.
> (I want a timeout of 5 seconds, however that can be accomplished)
>
> Thanks for any help!
>
> --Cal
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
>
> _______________________________________________
> 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
>

[Sqlrelay-discussion] setConnectTimeout() not working correctly?

[Cal H. <ca...@fb...>]

Hi David,

I'm attempting to write a weighted round-robin connection method for an
easy failover mechanism on multiple SQL Relay servers.  It appears that the
C++ sqlrconnection::setConnectTimeout() function isn't behaving like I'd
expect.  It seems that no matter what values I pass to it, the connection
*always* fails.

Here's the general idea I'm doing:

bool success = false;
do
{
     /*
       select random sql relay server
      */

      tmpconn = new sqlrconnection(hostname, port, NULL,
            user, pass, 0, 1);
      tmpconn->debugOn();
      tmpconn->setConnectTimeout(10, 5000000);

      const char *version = tmpconn->serverVersion();
      printf("version: '%s'\n", version);
      if ( version )
         success = true;

      /* Breaking out after a few tries */
}
while ( success == false );

Running that, I get something like this:

<pre>
Connecting to listener...
</pre>
<pre>
Inet socket: 127.0.0.1:9000
</pre>
<pre>
Setting Error
</pre>
<pre>
Couldn't connect to the listener.
</pre>
version: '(null)'

But when I comment out the setConnectTimeout() call, it works just fine:

<pre>
Connecting to listener...
</pre>
<pre>
Inet socket: 127.0.0.1:9000
</pre>
<pre>
Authenticating :  ...
</pre>
<pre>
Server Version...
</pre>
<pre>
Checking for error
</pre>
<pre>
No error occurred
</pre>
<pre>
0.53.1
</pre>
version: '0.53.1'

I've played around with different values for seconds and microseconds.  (I
want a timeout of 5 seconds, however that can be accomplished)

Thanks for any help!

--Cal