sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] Using native drivers to connect to other databases.

[Avery P. <ape...@gm...>]

On Wed, Oct 15, 2008 at 10:34 AM, Rolf <ro...@wi...> wrote:
> In the features list of SQL relay it says :
>
> An application coded using another database's native client API may be
> able to use SQL Relay without modification. SQL Relay provides drop-in
> replacement libraries for:
>
>    * MySQL
>    * PostgreSQL
>
> Does this mean that you have to use the drop-ins?

I think it means you *can* use the drop-ins if you want to use
unmodified mysql-using applications to connect to sqlrelay instead of
mysql.  It is not about replacing the mysql library when connecting
directly to mysql.

Avery

[Sqlrelay-discussion] Sqlrelay Debug details

[Ömer F. İ. <ome...@pi...>]

Hi,

We're using sqlrelay with a php website and oracle8 db. We use php-pear for
connecting to sqlrelay.

Sqlrelay and Oracle db running on seperate machines in the same network.

The site is working well for some time and the status is like this:

 

Open   Server Connections:  200

  Opened Server Connections:  200

 

  Open   Client Connections:  14

  Opened Client Connections:  41657

 

  Open   Server Cursors:      1000

  Opened Server Cursors:      1000

 

  Times  New Cursor Used:     0

  Times  Cursor Reused:       1462678

 

  Total  Queries:             731148

  Total  Errors:              755

 

Forked Listeners:           0

 

Sometimes open client connections suddenly increases. Oracle cpu usage at
that time is fine.

I wanna ask a few questions. Any help will be great.

 

Total Errors: 755 is that important? And what kind of errors is it counting?
Can i find them in the debug mode?

If a erronous query is sent to oracle, does it make sqlrelay get stuck or
something?

 

 

 

 

[Sqlrelay-discussion] Using native drivers to connect to other databases.

[Rolf <ro...@wi...>]

In the features list of SQL relay it says :

An application coded using another database's native client API may be
able to use SQL Relay without modification. SQL Relay provides drop-in
replacement libraries for:

    * MySQL

	

    * PostgreSQL



Does this mean that you have to use the drop-ins?


Rolf

[Sqlrelay-discussion] SQLRelay - queries won't run, waiting for available connection (HPUX 11.11, Oracle 10g)

[Bryan R. <BRe...@fn...>]

I'm running SQLRelay on an HPUX 11.11 system, attempting to connect to an Oracle 10g database.

Everything installs and starts without errors, but when attempting to connect and run any sort of query, nothing returns.

I've tried using the command-line utility "fields" as well as "sqlrsh" to connect - either will successfully spawn a new sqlr-listener-debug program (config has debug="listener_and_connection"), but then the listener simply stops after logging:
10/14/2008 08:22:35 CDT listener [23566] : acquiring exclusive shm access

10/14/2008 08:22:35 CDT listener [23566] : done acquiring exclusive shm access

10/14/2008 08:22:35 CDT listener [23566] : waiting for an available connection

-- and then does nothing further until it times out and exits.

There is 1 sqlr-connection-oracle8-debug daemon launched at start, the tail of whose log shows:
10/14/2008 08:22:35 CDT connection [23406] :    done releasing announce mutex

10/14/2008 08:22:35 CDT connection [23406] : done announcing availability...

10/14/2008 08:22:35 CDT connection [23406] : waiting for client...

-- and never logs any further data.

If I attempt multiple times, new listeners and (after the first attempt, when a new listener is spawned and "queued") new connection daemons are launched, but none ever establish a connection between listener and connection, simply getting the same "waiting for an available connection" and "waiting for client" message, respectively.

I've checked the "common problems" list in your documentation, and confirmed the var/sqlrelay/tmp directory has 777 permissions (as do the three subfolders: ipc, pids, and sockets), cleared the temp files out of all three subdirectories, confirmed 666 permissions on sockseq, cleared all visible shared memory and semaphore values in ipcs (originally there were a few "hung" from another user that I suspected for this problem), and still no connections.  I'm using "-config ~/sqlrelay/etc/sqlrelay.conf -id dev" flags that are identical to the ones used for sqlr-start, so I don't expect it should be attempting the wrong port for the connection.

When attempting the connection with sqlrsh, I receive:

SQLRShell - Version 0.22
        Connected to: localhost:9000 as sqlrelay

        type help; for a help.

0> select col2 from testtable;
Failed to authenticate.
 A network error may have ocurred.

        Rows Returned   : 0
        Fields Returned : 0
        System time     : 10000

0>


-- though when I check the logs for the listener on that connection, it still shows the same "waiting for available connection" message as the last line of the debug, and never shows having connected to the sqlr-connection daemon to even authenticate against Oracle itself - and shows having already authenticated against sqlrelay in the output above.  I also used sqlplus to connect to Oracle directly, and confirmed the ID/PW and oracle instance being used in the config information.  I also confirmed in the sqlr-connection debug logs, they are showing:

10/14/2008 08:22:04 CDT connection [23406] : logging in...

10/14/2008 08:22:04 CDT connection [23406] : done logging in

...

10/14/2008 08:22:04 CDT connection [23406] : waiting for available database...

connection : database is available

10/14/2008 08:22:04 CDT connection [23406] : database is available

-- seeming to imply to me that it is in fact connecting to oracle with the provided login information successfully in the connection daemon.

Config setup currently in place (I turned down the listenertimeout and sessiontimeout variables after first experiencing the issue, so that I didn't wait 10 minutes for a listener to die.  I've also tried it with connections="3" to no avail, as all three still fail to show as available to the spawned listener when attempting a connection, despite showing in their respective logs that they are flagged as available.  I'm currently starting the process manually with sqlr-start as the user bredshaw.):

<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instances>

        <!-- Regular SQL Relay Instance -->
        <instance id="dev" port="9000" socket="/tmp/dev.socket" dbase="oracle8" connections="1" maxconnections="5" maxqueuelength="0" growby="1" ttl="60" endofsession="rollback" sessiontimeout="30" runasuser="bredshaw" runasgroup="usergrp" cursors="1" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="listener_and_connection" maxquerysize="512" maxstringbindvaluelength="512" maxlobbindvaluelength="1024" idleclienttimeout="-1" maxlisteners="10" listenertimeout="30" reloginatstart="no">
                <users>
                        <user user="sqlrelay" password="XXXXXXXX"/>
                </users>
                <connections>
                        <connection connectionid="dev" string="user=bredshaw;password=XXXXXXXX;oracle_sid=dev;oracle_home=/usr3/oracle" metric="1" behindloadbalancer="no"/>
                </connections>
        </instance>
</instances>

(note, some server names have been changed, to protect the innocent :)

Bryan Redshaw

[Sqlrelay-discussion] compiling on mac os x 10.5.5

[Mark M. <mar...@gm...>]

Hello,I'm attempting to build sqlrelay on my mac osx 10.5.5 machine. And all
I really need is the sql_relay.so on my machine so I can use
php/sql_relay.so to connect to our sql_relay host.

Rudiments compiles fine. But sqlrelay does not.

after executing make I get:
g++  -o .libs/libsql_relay.0.0.0.so -bundle  .libs/sql_relay.o  -lphp
-L/Users/mm/Downloads/sqlrelay-0.39.4/src/api/c++/src
/Users/mm/Downloads/sqlrelay-0.39.4/src/api/c++/src/.libs/libsqlrclient.dylib
-L/usr/local/firstworks/lib /usr/local/firstworks/lib/librudiments.dylib
-lpthread -lssl -lcrypto -ldl
first try errors :
ld: library not found for -lphp
collect2: ld returned 1 exit status
make[4]: *** [libsql_relay.la] Error 1

second try errors :
ld: library not found for -lphp
collect2: ld returned 1 exit status
make[4]: *** [libsql_relay.la] Error 1

third try errors :
ld: library not found for -lphp
collect2: ld returned 1 exit status
make[4]: *** [libsql_relay.la] Error 1

make[3]: *** [all] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2

Admittedly, I do not compile a lot of software on osx so I'm not sure what's
happening here. Things compiled fine on our 3 rh linux servers.

I'm wondering if there's just an envirnonment variable that's not set so it
doesn't find the php libraries. Or if php5 isn't built on osx in a way that
will allow sqlrelay what it needs to build.

Any help would be appreciated.
Thanks,
mark

[Sqlrelay-discussion] sqlrelay and re-excuted queries with db2

[Matt H. <mh...@co...>]

I am using sqlrelay version 0.39.4, the perl api (not dbi), and ibm db2.  
I cannot re-use a prepared query.  When the second "executeQuery" is 
issued, the process hangs.  The database is fine, but the sqlrelay server 
must be restarted.

The perl:

use SQLRelay::Connection;
use SQLRelay::Cursor;
my $conn = SQLRelay::Connection->new('host',port,"",'user','pass',0,1);
my $cur = SQLRelay::Cursor->new($conn);
$cur->prepareQuery("query");
$cur->clearBinds();
$cur->inputBind(1,13);
$cur->executeQuery() || $cur->errorMessage();
$cur->clearBinds();
$cur->inputBind(1,2);
$cur->executeQuery() || $cur->errorMessage(); # hangs here
$conn->endSession();

This is from the server logs:

[snip]

processing query...

re-executing...

commit or rollback check...

done with commit or rollback check

processing query failed

done processing query

handling error...

returning error...

done returning error

database is down...

[snip]

Any help would be appreciated, 
Thanks

Re: [Sqlrelay-discussion] PHP5 + PDO + SQL Relay

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

Sorry, currently SQL Relay only has a Pear DB module, not a PDO module.

Dave Muse
dav...@fi...

On Thu, 2008-08-14 at 09:00 -0300, Joao Gilberto Magalhaes wrote:
> Is there any way to connect through SQL Relay using PDO for PHP5?
> 
> I have an Debian Etch, PHP 5.2.0-etch8 and I noted in Debian repository
> have pre-compiled SQL Relay modules, includind PHP.
> 
> Thank you.
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

[Sqlrelay-discussion] PHP5 + PDO + SQL Relay

[Joao G. M. <jo...@by...>]

Is there any way to connect through SQL Relay using PDO for PHP5?

I have an Debian Etch, PHP 5.2.0-etch8 and I noted in Debian repository
have pre-compiled SQL Relay modules, includind PHP.

Thank you.

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

> This command only apply the patch on the source.
>
> You must run:
>
> # make clean
> # ./configure
> # make
> # make install
>
> After applying the patch.

hi,

trying to install sqlrelay-0.39.4 from sources inside another machine
(Ubuntu 8.04 64 bits), I'm getting this:

./configure

***** Programs ***************
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking how to run the C preprocessor... gcc -E
checking for a BSD-compatible install... /usr/bin/install -c
checking whether ln -s works... yes
checking whether make sets $(MAKE)... yes
******************************

***** Libtool ****************
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for a sed that does not truncate output... /bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking how to recognise dependent libraries... pass_all
checking for ANSI C header files... no
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... no
checking for dlfcn.h... yes
checking how to run the C++ preprocessor... g++ -E
checking for g77... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for epcf90... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for gfortran... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether  accepts -g... no
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc static flag  works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld -m elf_x86_64
checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
appending configuration tag "F77" to libtool
checking for -ar... ar
******************************

***** Platform ***************
checking for dynamic library extension... so
checking whether ld -rpath works... yes
checking whether ps aux works... yes
checking for -pipe option... yes
checking for -Wall... yes
checking if gcc -pthread works during compile phase... yes
******************************

***** Inline Functions *******
checking inline... yes
******************************

***** threads ****************
pthreads includes... -pthread
pthreads libs... -lpthread
******************************

***** Libraries **************
checking for tgetnum in -ltermcap... yes
checking for add_history in -lhistory... no
checking for readline in -lreadline... no
checking no extra libraries are required for socket-related calls... yes
checking for dlopen in -ldl... yes
checking for aioread in -laio... no
checking features.h usability... yes
checking features.h presence... yes
checking for features.h... yes
checking for broken glibc-2.3... no
checking if iconv takes const char ** argument... no
******************************

***** Rudiments **************
rudiments includes... -pthread
rudiments libs... -lrudiments -lpthread -lrt -lrt -lcrypt -ldl
******************************

***** Oracle *****************
checking for oracle includes and libraries... no
******************************

***** MySQL ******************
******************************

***** PostgreSQL *************
checking if PostgreSQL can be dynamically linked without -lcrypt... yes
checking if PostgreSQL has PQfmod... yes
checking if PostgreSQL has PQsetNoticeProcessor... yes
checking if PostgreSQL has PQprepare... yes
checking if PostgreSQL has PQexecPrepared... yes
checking if PostgreSQL has PQserverVersion... yes
postgresql includes... -I/usr/include/postgresql
postgresql libs... -lpq
******************************

***** SQLite *****************
sqlite includes... -DSQLITE3
sqlite libs... -lsqlite3
checking for sqlite3_bind_int... yes
******************************

***** FreeTDS ******************
checking whether ctpublic.h contains function definitions... yes
freetds libs... -lct
******************************

***** Sybase *****************
******************************

***** ODBC *********************
checking if UnixODBC needs threads... no
checking if iODBC needs threads... no
checking if SQLBindParameter takes SQLLEN * argument... yes
checking if SQLColAttribute takes SQLLEN * argument... yes
checking if SQLRowCount takes SQLLEN * argument... yes
checking if SQLBindCol takes SQLLEN * argument... yes
checking for SQLConnectW... yes
odbc includes...
odbc libs... -liodbc -liodbcinst
******************************

***** DB2 **********************
db2 version... 8
******************************

***** Firebird **************
******************************

***** MDB Tools **************
glib includes... -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
glib libs... -lglib-2.0
******************************

***** Perl *******************
checking for perl... perl
******************************

***** Python 2.1 or newer ****
python includes... -I/usr/include/python2.4
******************************

***** Zope *******************
enable zope: yes
checking for Zope...
******************************

***** Ruby *******************
checking for ruby... ruby
******************************

***** Java *******************
checking for gcj... no
checking for fastjar... no
******************************

***** TCL ********************
******************************

***** PHP ********************
checking for php-config... php-config
php includes... -I/usr/include/php5 -I/usr/include/php5/main
-I/usr/include/php5/TSRM -I/usr/include/php5/Zend
-I/usr/include/php5/ext -I/usr/include/php5/ext/date/lib
******************************

***** GTK+ *******************
checking for gtk-config... no
******************************

***** Headers ****************
checking for dirent.h that defines DIR... yes
checking for library containing opendir... none required
checking for ANSI C header files... (cached) no
checking for unistd.h... (cached) yes
checking for strings.h... (cached) yes
******************************

***** Structures *************
checking for mode_t... yes
checking return type of signal handlers... void
checking for unsupported signals...  SIGEMT SIGWAITING SIGLWP
SIGFREEZE SIGTHAW SIGCANCEL SIGLOST SIGRTMIN SIGRTMAX
checking namespace support... yes
******************************

***** Output Files ***********
configure: creating ./config.status
config.status: creating config.mk
config.status: creating src/api/perl/Connection/Connection.pm
config.status: creating src/api/perl/Cursor/Cursor.pm
config.status: creating src/api/perl/DBD/SQLRelay.pm
config.status: creating bin/sqlr-stop
config.status: creating bin/sqlrclient-config
config.status: creating bin/sqlrclientwrapper-config
config.status: creating init/openserver/init.d/sqlrelay
config.status: creating init/redhat/init.d/sqlrelay
config.status: creating init/slackware/rc.d/rc.sqlrelay
config.status: creating init/debian/init.d/sqlrelay
config.status: creating init/netbsd/rc.d/sqlrelay
config.status: creating init/freebsd/rc.d/sqlrelay
config.status: creating test/test
config.status: creating sqlrelay-c++.pc
config.status: creating sqlrelay-c.pc
config.status: creating config.h

***** Summary ***********************************************
 Version      : 0.39.4

 APIs         : C/C++       yes           Perl       yes
                Python      yes           Ruby       yes
                PHP         yes           Java       no
                TCL         no            Zope       no

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

If you expected a Connection or API that doesn't show up in the Summary
then the configure script probably couldn't find a package it needed to
build it.  You can manually specify package locations using command line
options.

Type:  configure --help   for a list of options.


Thanks to MP3.com for sponsoring:
	Clustered/Replicated database support.
	Perl API.
Thanks to FeedLounge for sponsoring:
	Query routing and filtering.

so it seems all ok.
but, when I type make I get these strange errors:
http://www.python-it.org/make.txt.
I've patched sources before installing them.

any ideas about solving this problem?
thanks a lot. :)

cheers

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python

[Sqlrelay-discussion] sqlrelay with python

[孙庚 <tss...@16...>]

Hi all:
    how can i use python with sqlrelay?


from SQLRelay import PySQLRClient

con=PySQLRClient.sqlrconnection('host',9000,'','user','password',0,1)
cur=PySQLRClient.sqlrcursor(con)

.. execute some queries ...

where should i download the python's SQLRelay mod?


 

 

Re: [Sqlrelay-discussion] compile sqlrelay/rudiments with HP-UX aCC compiler problems

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

It looks like the configure script isn't able to detect mmap.  You
should be able to make distclean, run configure again, then manually
edit include/rudiments/private/config.h and replace:

/* Some systems have mmap */
/* #undef RUDIMENTS_HAVE_MMAP */

with:

/* Some systems have mmap */
#define RUDIMENTS_HAVE_MMAP 1

That will force the build to realize that mmap exists.  You should be
able to get a little further.

Send me your config.log file too, maybe I'll be able to figure out why
mmap isn't auto-detected.

Dave

On Wed, 2008-07-30 at 11:57 -0500, Brian Millett wrote:
> I'm trying to compile sqlrelay & rudiments with aCC: HP ANSI C++ B3910B A.03.52
> system HP-UX B.11.11 U 9000/800 and I'm having all kinds of issues.
> 
> In rudiments, I have the following in the config.mk
> 
> BASECPPFLAGS =  -D_REENTRANT -D_THREAD_SAFE -D__EXTENSIONS__ -D__STDC_EXT__  -AP 
> -D_HPUX_SOURCE -I/usr3/local/openssl-0.9.7b/include
> 
> But I cannot get passed compiling xmlsax.C
> 
> The HP-UX does have mmap, but I can not figure out what memorymap datatype is.  There is a 
> src/memorymap.C, but that is not included in the xmlsax.C file.
> 
> I'm at an impasse.  Any help will be greatly appreciated.
> 
> error:
> 
>   /opt/softbench/bin/aCC -D_XOPEN_SOURCE -D_XOPEN_SOURCE_EXTENDED -D_HPUX_SOURCE 
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DOPENSSL_THREADS -D_REENTRANT -D_THREAD_SAFE 
> -D__EXTENSIONS__ -D__STDC_EXT__ -AP -D_HPUX_SOURCE -I/usr3/local/openssl-0.9.7b/include 
> -I../ -I../include -c xmlsax.C  +Z -DPIC -o .libs/xmlsax.o
> Error (future) 600: "/usr/include/sys/stat.h", line 147 # Type specifier is omitted; "int" 
> is no longer assumed.
>           inline lstat __((const char *, struct stat *));
>                  ^^^^^
> Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 433 # Type specifier is 
> omitted; "int" is no longer
>      assumed.
>      inline truncate(const char *a, off_t b)         { return __truncate64(a,b); }
>             ^^^^^^^^
> Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 434 # Type specifier is 
> omitted; "int" is no longer
>      assumed.
>      inline prealloc(int a, off_t b)                 { return __prealloc64(a,b);
>             ^^^^^^^^
> Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 435 # Type specifier is 
> omitted; "int" is no longer
>      assumed.
>      inline lockf(int a, int b, off_t c)             { return __lockf64(a,b,c); }
>             ^^^^^
> Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 436 # Type specifier is 
> omitted; "int" is no longer
>      assumed.
>      inline ftruncate(int a, off_t b)                { return __ftruncate64(a,b); }
>             ^^^^^^^^^
> Error 419: "xmlsax.C", line 23 # 'memorymap' is used as a type, but has not been defined 
> as a type.
>                      memorymap       _mm;
>                      ^^^^^^^^^
> Error 186: "xmlsax.C", line 108 # Left side of '.' requires a class object; type found was 
> 'int'.
>                              pvt->_mm.detach();
>                              ^^^^^^^^
> Error 186: "xmlsax.C", line 821 # Left side of '.' requires a class object; type found was 
> 'int'.
>                      pvt->_mm.detach();
>                      ^^^^^^^^
> Error 186: "xmlsax.C", line 832 # Left side of '.' requires a class object; type found was 
> 'int'.
>              if (pvt->_mm.attach(pvt->_fl.getFileDescriptor(),
>                  ^^^^^^^^
> Error 186: "xmlsax.C", line 834 # Left side of '.' requires a class object; type found was 
> 'int'.
>                      pvt->_string=static_cast<char *>(pvt->_mm.getData());
>                                                       ^^^^^^^^
> Warning:	1 future errors were detected and ignored. Add a '+p' option to detect and fix 
> them before they become fatal errors in a future release. Behavior of this ill-formed 
> program is not guaranteed to match that of a well-formed program
> gmake[1]: *** [xmlsax.lo] Error 1
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

[Sqlrelay-discussion] Configuration

[Ze R. <jra...@gm...>]

We have this scenario:

- 5 Oracle Servers 10R2 in a Oracle RAC.
- 10 Application servers running Apache and PHP5
- We have 500 thousand inserts a day
- Over 10 million selects
- At peak, 9 thousand connections to the database simoutaneously.

We compiled sqlrelay and put it running. But it can't stand for 2 minutes.

I have read a post here, where someone says that has a sqlrelay deploy
handling 12000 requests per second.

The question is, how can we get this performance? If someone could show us
the config file, just to know where we are doing wrong, we'd appreciate very
much.

Thanks!

José Roberto

[Sqlrelay-discussion] compile sqlrelay/rudiments with HP-UX aCC compiler problems

[Brian M. <bmi...@gm...>]

I'm trying to compile sqlrelay & rudiments with aCC: HP ANSI C++ B3910B A.03.52
system HP-UX B.11.11 U 9000/800 and I'm having all kinds of issues.

In rudiments, I have the following in the config.mk

BASECPPFLAGS =  -D_REENTRANT -D_THREAD_SAFE -D__EXTENSIONS__ -D__STDC_EXT__  -AP 
-D_HPUX_SOURCE -I/usr3/local/openssl-0.9.7b/include

But I cannot get passed compiling xmlsax.C

The HP-UX does have mmap, but I can not figure out what memorymap datatype is.  There is a 
src/memorymap.C, but that is not included in the xmlsax.C file.

I'm at an impasse.  Any help will be greatly appreciated.

error:

  /opt/softbench/bin/aCC -D_XOPEN_SOURCE -D_XOPEN_SOURCE_EXTENDED -D_HPUX_SOURCE 
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DOPENSSL_THREADS -D_REENTRANT -D_THREAD_SAFE 
-D__EXTENSIONS__ -D__STDC_EXT__ -AP -D_HPUX_SOURCE -I/usr3/local/openssl-0.9.7b/include 
-I../ -I../include -c xmlsax.C  +Z -DPIC -o .libs/xmlsax.o
Error (future) 600: "/usr/include/sys/stat.h", line 147 # Type specifier is omitted; "int" 
is no longer assumed.
          inline lstat __((const char *, struct stat *));
                 ^^^^^
Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 433 # Type specifier is 
omitted; "int" is no longer
     assumed.
     inline truncate(const char *a, off_t b)         { return __truncate64(a,b); }
            ^^^^^^^^
Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 434 # Type specifier is 
omitted; "int" is no longer
     assumed.
     inline prealloc(int a, off_t b)                 { return __prealloc64(a,b);
            ^^^^^^^^
Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 435 # Type specifier is 
omitted; "int" is no longer
     assumed.
     inline lockf(int a, int b, off_t c)             { return __lockf64(a,b,c); }
            ^^^^^
Warning (anachronism) 600: "/usr/include/sys/unistd.h", line 436 # Type specifier is 
omitted; "int" is no longer
     assumed.
     inline ftruncate(int a, off_t b)                { return __ftruncate64(a,b); }
            ^^^^^^^^^
Error 419: "xmlsax.C", line 23 # 'memorymap' is used as a type, but has not been defined 
as a type.
                     memorymap       _mm;
                     ^^^^^^^^^
Error 186: "xmlsax.C", line 108 # Left side of '.' requires a class object; type found was 
'int'.
                             pvt->_mm.detach();
                             ^^^^^^^^
Error 186: "xmlsax.C", line 821 # Left side of '.' requires a class object; type found was 
'int'.
                     pvt->_mm.detach();
                     ^^^^^^^^
Error 186: "xmlsax.C", line 832 # Left side of '.' requires a class object; type found was 
'int'.
             if (pvt->_mm.attach(pvt->_fl.getFileDescriptor(),
                 ^^^^^^^^
Error 186: "xmlsax.C", line 834 # Left side of '.' requires a class object; type found was 
'int'.
                     pvt->_string=static_cast<char *>(pvt->_mm.getData());
                                                      ^^^^^^^^
Warning:	1 future errors were detected and ignored. Add a '+p' option to detect and fix 
them before they become fatal errors in a future release. Behavior of this ill-formed 
program is not guaranteed to match that of a well-formed program
gmake[1]: *** [xmlsax.lo] Error 1



-- 
Brian Millett - [ Laurel Takeshima, "The Gathering"]
"We were talking the other day about how nobody's seen a Vorlon before
  and he said that according to legend, one human did see a Vorlon...he
  turned to stone."

Re: [Sqlrelay-discussion] pgpool - II

[Kalyan R. <kal...@gm...>]

Hi,
 I am trying to exec "query" command in sqlrelay.
For that I used this simple program to test to see if it works.

#include <stdio.h>

int main(){

char * args[] = {" -id"," as8","select count(*) from schools","
-config  sqlrelay.conf",(char *) 0 };
execvp("/usr/local/sqlrelay/bin/query",args);

}

 where as8 is the sqlrelay instance id and schools is one of the
tables in my db.
However, when I run it it generates an error:

postgres@NTH-DNB2:~/sqlrelay$ gcc exec.c
postgres@NTH-DNB2:~/sqlrelay$ ./a.out
usage: query  host port socket user password query [debug]
  or   query  [-config configfile] -id id query [debug]

I also tested by varying the parameters in different ways but still
couldn't get it running.
sqlrelay.conf is located in the current directory.

Please help me in this, as I need to run many such instances to do testing.
Thanks,
Kalyan.

On 7/11/08, Kalyan Raghu <kal...@gm...> wrote:
> Hi Frank,
>  thanks for your reply.
>  As you said, I am working in the second way,  client <--> sqlrelay  <-->
> pgpool <-->   postgresql DB.
>
>  It was only a small problem in the configuration of sqlrelay because of
> which I couldn't connect to the pgpool.
>  Now, everything is working fine.
>
>  Thanks,
>  Kalyan.
>
> On Thu, Jul 10, 2008 at 6:23 PM, Frank Joerdens <fr...@jo...> wrote:
>
>> On 7/10/08, Kalyan Raghu <kal...@gm...> wrote:
>> > Hi all,
>> >   Is SQLRelay compatible with pgpool - II ?
>> >
>> >   When I run a "normal" instance which connects to pgpool - II, it is
>> > working fine. I am able to send queries to pgpool - II via this
>> > instance.
>> >
>> >   When I run a query router instance, which connects to this normal
>> > instance, I am not able to send the queries to pgpool - II.
>>
>> I may have been trying something very similar with pgbouncer (a more
>> lightweight pgpool competitor) just now. What is your setup like? If
>> it is sth like
>>
>> client <-> pgpool <-> sqlrelay <-> pg
>>
>> then we are maybe facing the same problem, which is to talk to
>> sqlrelay somehow from a client that is set up to talk to postgres
>> directly. For which there is a compatibility driver:
>>
>> http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html
>>
>> but it doesn't work for me from either Python via psycopg2 or trying
>> to let pgbouncer talk to sqlrelay via this SQL Relay drop-in
>> replacement library for PostgreSQL ...
>>
>> But it sounds more like you are trying someting like
>>
>> client <-> sqlrelay <-> pgpool <-> pg
>>
>> I think my problem is that it may be difficult for us to quickly
>> replace the psycopg2 driver with the native SQL Relay python driver.
>> Hence trying with the compatibility layer. I am curious about how you
>> are doing it?!
>>
>> Cheers,
>>
>> Frank
>>
>> -------------------------------------------------------------------------
>> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>> Studies have shown that voting for your favorite open source project,
>> along with a healthy diet, reduces your potential for chronic lameness
>> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>

[Sqlrelay-discussion] SQLRelay/FreeTDS/PHP only returning first 2033 bytes of column

[Michael A. <mi...@mi...>]

Hi there,

Curious problem. If I run an XML query, say SELECT * FROM big_table FOR 
XML AUTO through sqlrsh, it'll show me the full XML result set. However 
if I run the same query through the PHP SQLRelay library, it'll only 
return the first 2033 characters of the result set, chopping off much of 
the output.

I'm using PHP5.2, SQL Server 2005, FreeTDS 0.82RC1, SQLRelay 0.39.4. 
I've had a look at the PHP client library code and can't see any obvious 
places where a column length could be getting set. It doesn't appear to 
be a FreeTDS issue, as it's happily fetching the full result set through 
sqlrsh. I've tried using both prepareQuery and sendQuery and both 
exhibit the same behaviour. Running sqlrcur_getFieldLength($sqlrcurref, 
0, 0) also says 2033 so it would seem to be something at the C++ level. 
Just seems odd that sqlrsh runs the command fine, yet the PHP output is 
clipped.

Any pointers most appreciated. Thanks,
--Michael Adams

Re: [Sqlrelay-discussion] pgpool - II

[Kalyan R. <kal...@gm...>]

Hi Frank,
 thanks for your reply.
 As you said, I am working in the second way,  client <--> sqlrelay  <-->
pgpool <-->   postgresql DB.

 It was only a small problem in the configuration of sqlrelay because of
which I couldn't connect to the pgpool.
 Now, everything is working fine.

 Thanks,
 Kalyan.

On Thu, Jul 10, 2008 at 6:23 PM, Frank Joerdens <fr...@jo...> wrote:

> On 7/10/08, Kalyan Raghu <kal...@gm...> wrote:
> > Hi all,
> >   Is SQLRelay compatible with pgpool - II ?
> >
> >   When I run a "normal" instance which connects to pgpool - II, it is
> > working fine. I am able to send queries to pgpool - II via this instance.
> >
> >   When I run a query router instance, which connects to this normal
> > instance, I am not able to send the queries to pgpool - II.
>
> I may have been trying something very similar with pgbouncer (a more
> lightweight pgpool competitor) just now. What is your setup like? If
> it is sth like
>
> client <-> pgpool <-> sqlrelay <-> pg
>
> then we are maybe facing the same problem, which is to talk to
> sqlrelay somehow from a client that is set up to talk to postgres
> directly. For which there is a compatibility driver:
>
> http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html
>
> but it doesn't work for me from either Python via psycopg2 or trying
> to let pgbouncer talk to sqlrelay via this SQL Relay drop-in
> replacement library for PostgreSQL ...
>
> But it sounds more like you are trying someting like
>
> client <-> sqlrelay <-> pgpool <-> pg
>
> I think my problem is that it may be difficult for us to quickly
> replace the psycopg2 driver with the native SQL Relay python driver.
> Hence trying with the compatibility layer. I am curious about how you
> are doing it?!
>
> Cheers,
>
> Frank
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

thanks a lot Leandro, it works.
but now I have another problem: I can't connect with the database. I get:

antonio@HAL9000:~$ sqlr-start -id myid

Starting listener:
  sqlr-listener -id myid -config /usr/local/firstworks/etc/sqlrelay.conf

Starting 3 connections to db1 :
  sqlr-connection-odbc -id myid -connectionid db1 -config
/usr/local/firstworks/etc/sqlrelay.conf
Couldn't log into database.
*** glibc detected *** sqlr-connection-odbc: double free or corruption
(fasttop): 0x08052f00 ***
======= Backtrace: =========
/lib/tls/i686/cmov/libc.so.6[0xb7bf7a85]
/lib/tls/i686/cmov/libc.so.6(cfree+0x90)[0xb7bfb4f0]
/usr/lib/libiodbc.so.2(SQLFreeHandle+0x183)[0xb7f69d83]
sqlr-connection-odbc[0x804c590]
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1(_ZN18sqlrconnection_svr17logOutUpdateStatsEv+0x18)[0xb7f2330a]
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1(_ZN18sqlrconnection_svr15closeConnectionEv+0xc2)[0xb7f2237a]
sqlr-connection-odbc[0x804d0fa]
sqlr-connection-odbc[0x804d2db]
/lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0)[0xb7ba2450]
sqlr-connection-odbc(_ZN14sqlrcursor_svr17checkForTempTableEPKcj+0x31)[0x804abe1]
======= Memory map: ========
08048000-0804f000 r-xp 00000000 08:03 8915075
/usr/local/firstworks/bin/sqlr-connection-odbc
0804f000-08050000 rw-p 00006000 08:03 8915075
/usr/local/firstworks/bin/sqlr-connection-odbc
08050000-08071000 rw-p 08050000 00:00 0          [heap]
b7a00000-b7a21000 rw-p b7a00000 00:00 0
b7a21000-b7b00000 ---p b7a21000 00:00 0
b7b54000-b7b5d000 r-xp 00000000 08:03 7578995
/lib/tls/i686/cmov/libnss_files-2.7.so
b7b5d000-b7b5f000 rw-p 00008000 08:03 7578995
/lib/tls/i686/cmov/libnss_files-2.7.so
b7b5f000-b7b67000 r-xp 00000000 08:03 7578999
/lib/tls/i686/cmov/libnss_nis-2.7.so
b7b67000-b7b69000 rw-p 00007000 08:03 7578999
/lib/tls/i686/cmov/libnss_nis-2.7.so
b7b69000-b7b7d000 r-xp 00000000 08:03 7578989
/lib/tls/i686/cmov/libnsl-2.7.so
b7b7d000-b7b7f000 rw-p 00013000 08:03 7578989
/lib/tls/i686/cmov/libnsl-2.7.so
b7b7f000-b7b81000 rw-p b7b7f000 00:00 0
b7b81000-b7b88000 r-xp 00000000 08:03 7578991
/lib/tls/i686/cmov/libnss_compat-2.7.so
b7b88000-b7b8a000 rw-p 00006000 08:03 7578991
/lib/tls/i686/cmov/libnss_compat-2.7.so
b7b8a000-b7b8c000 rw-p b7b8a000 00:00 0
b7b8c000-b7cd5000 r-xp 00000000 08:03 7578978    /lib/tls/i686/cmov/libc-2.7.so
b7cd5000-b7cd6000 r--p 00149000 08:03 7578978    /lib/tls/i686/cmov/libc-2.7.so
b7cd6000-b7cd8000 rw-p 0014a000 08:03 7578978    /lib/tls/i686/cmov/libc-2.7.so
b7cd8000-b7cdc000 rw-p b7cd8000 00:00 0
b7cdc000-b7ce6000 r-xp 00000000 08:03 7561280    /lib/libgcc_s.so.1
b7ce6000-b7ce7000 rw-p 0000a000 08:03 7561280    /lib/libgcc_s.so.1
b7ce7000-b7d0a000 r-xp 00000000 08:03 7578986    /lib/tls/i686/cmov/libm-2.7.so
b7d0a000-b7d0c000 rw-p 00023000 08:03 7578986    /lib/tls/i686/cmov/libm-2.7.so
b7d0c000-b7df4000 r-xp 00000000 08:03 8669242    /usr/lib/libstdc++.so.6.0.9
b7df4000-b7df7000 r--p 000e8000 08:03 8669242    /usr/lib/libstdc++.so.6.0.9
b7df7000-b7df9000 rw-p 000eb000 08:03 8669242    /usr/lib/libstdc++.so.6.0.9
b7df9000-b7dff000 rw-p b7df9000 00:00 0
b7dff000-b7e01000 r-xp 00000000 08:03 7578984    /lib/tls/i686/cmov/libdl-2.7.so
b7e01000-b7e03000 rw-p 00001000 08:03 7578984    /lib/tls/i686/cmov/libdl-2.7.so
b7e03000-b7e0c000 r-xp 00000000 08:03 7578982
/lib/tls/i686/cmov/libcrypt-2.7.so
b7e0c000-b7e0e000 rw-p 00008000 08:03 7578982
/lib/tls/i686/cmov/libcrypt-2.7.so
b7e0e000-b7e35000 rw-p b7e0e000 00:00 0
b7e35000-b7e3c000 r-xp 00000000 08:03 7579008    /lib/tls/i686/cmov/librt-2.7.so
b7e3c000-b7e3e000 rw-p 00006000 08:03 7579008    /lib/tls/i686/cmov/librt-2.7.so
b7e3e000-b7e3f000 rw-p b7e3e000 00:00 0
b7e3f000-b7e53000 r-xp 00000000 08:03 7579004
/lib/tls/i686/cmov/libpthread-2.7.so
b7e53000-b7e55000 rw-p 00013000 08:03 7579004
/lib/tls/i686/cmov/libpthread-2.7.so
b7e55000-b7e57000 rw-p b7e55000 00:00 0
b7e57000-b7edf000 r-xp 00000000 08:03 9937056
/usr/lib/librudiments-0.30.so.1.0.0
b7edf000-b7ee2000 rw-p 00087000 08:03 9937056
/usr/lib/librudiments-0.30.so.1.0.0
b7ee2000-b7efe000 r-xp 00000000 08:03 8847621
/usr/local/firstworks/lib/libsqlrclient-0.39.4.so.1.0.0
b7efe000-b7eff000 rw-p 0001c000 08:03 8847621
/usr/local/firstworks/lib/libsqlrclient-0.39.4.so.1.0.0
b7eff000-b7f0f000 r-xp 00000000 08:03 8847617
/usr/local/firstworks/lib/libsqlrutil-0.39.4.so.1.0.0
b7f0f000-b7f10000 rw-p 0000f000 08:03 8847617
/usr/local/firstworks/lib/libsqlrutil-0.39.4.so.1.0.0
b7f10000-b7f2a000 r-xp 00000000 08:03 8848309
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1.0.0
b7f2a000-b7f2b000 rw-p 0001a000 08:03 8848309
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1.0.0
b7f2b000-b7f2c000 rw-p b7f2b000 00:00 0
b7f2c000-b7f3d000 r-xp 00000000 08:03 9937166    /usr/lib/libiodbcinst.so.2.1.18
b7f3d000-b7f3e000 rw-p 00010000 08:03 9937166    /usr/lib/libiodbcinst.so.2.1.18
b7f3e000-b7f85000 r-xp 00000000 08:03 9937165    /usr/lib/libiodbc.so.2.1.18
b7f85000-b7f87000 rw-p 00046000 08:03 9937165    /usr/lib/libiodbc.so.2.1.18
b7f8e000-b7f95000 r--s 00000000 08:03 3457263
/usr/lib/gconv/gconv-modules.cache
b7f95000-b7f96000 rw-s 00000000 00:09 2687028    /SYSV010345b0 (deleted)
b7f96000-b7f98000 rw-p b7f96000 00:00 0
b7f98000-b7f99000 r-xp b7f98000 00:00 0          [vdso]
b7f99000-b7fb3000 r-xp 00000000 08:03 7561235    /lib/ld-2.7.so
b7fb3000-b7fb5000 rw-p 00019000 08:03 7561235    /lib/ld-2.7.so
bfda1000-bfdb6000 rw-p bffeb000 00:00 0          [stack]
Aborted

sqlr-connection-odbc failed to start.


Thanks to MP3.com for sponsoring:
	Clustered/Replicated database support.
	Perl API.
Thanks to FeedLounge for sponsoring:
	Query routing and filtering.

while my sqlrelay.conf's section is:

	<instance id="myid" port="9000" socket="/tmp/example.socket"
dbase="odbc" connections="3" maxconnections="15" maxqueuelength="5"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="antonio" runasgroup="antonio" cursors="5"
authtier="listener" handoff="pass" deniedips="" allowedips=""
debug="none" maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1"
listenertimeout="0" reloginatstart="false">
		<users>
			<user user="antonio" password="thepassword1"/>
		</users>
		<connections>
			<connection connectionid="db1"
string="user=sergio;password=thepassword2;server=138.66.220.19;db=anagrafe;dns=FreeTDS;"
metric="1" behindloadbalancer="no"/>
		</connections>
	</instance>

any help about this?
thanks again.

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python

Re: [Sqlrelay-discussion] pgpool - II

[Frank J. <fr...@jo...>]

On 7/10/08, Kalyan Raghu <kal...@gm...> wrote:
> Hi all,
>   Is SQLRelay compatible with pgpool - II ?
>
>   When I run a "normal" instance which connects to pgpool - II, it is
> working fine. I am able to send queries to pgpool - II via this instance.
>
>   When I run a query router instance, which connects to this normal
> instance, I am not able to send the queries to pgpool - II.

I may have been trying something very similar with pgbouncer (a more
lightweight pgpool competitor) just now. What is your setup like? If
it is sth like

client <-> pgpool <-> sqlrelay <-> pg

then we are maybe facing the same problem, which is to talk to
sqlrelay somehow from a client that is set up to talk to postgres
directly. For which there is a compatibility driver:

http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html

but it doesn't work for me from either Python via psycopg2 or trying
to let pgbouncer talk to sqlrelay via this SQL Relay drop-in
replacement library for PostgreSQL ...

But it sounds more like you are trying someting like

client <-> sqlrelay <-> pgpool <-> pg

I think my problem is that it may be difficult for us to quickly
replace the psycopg2 driver with the native SQL Relay python driver.
Hence trying with the compatibility layer. I am curious about how you
are doing it?!

Cheers,

Frank

[Sqlrelay-discussion] pgpool - II

[Kalyan R. <kal...@gm...>]

Hi all,
  Is SQLRelay compatible with pgpool - II ?

  When I run a "normal" instance which connects to pgpool - II, it is
working fine. I am able to send queries to pgpool - II via this instance.

 When I run a query router instance, which connects to this normal instance,
I am not able to send the queries to pgpool - II.

 The backend data base is postgresql.

Versions I use:
 slqrelay       0.39.3
 pgpool II     2.0.1
 postgresql  8.2.5

Thanks.

[Sqlrelay-discussion] Talking to SQLRelay via psycopg2 and drop-in replacement library for PostgreSQL

[Frank J. <fr...@jo...>]

Hello! I am trying to talk to SQLRelay from python via psycopg2 and
the drop-in replacement library for PostgreSQL. this is what I get at
the python end:

--- snip ---
frank@host09:~$ python
Python 2.5.2 (r252:60911, May 28 2008, 19:19:25)
[GCC 4.2.4 (Debian 4.2.4-1)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg2
>>> conn = psycopg2.connect("user='routeruser' host='localhost' password='routerpassword' port='9000' dbname='foo'")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg2.OperationalError: can't fetch client_encoding
--- snap ---

and the SQLRelay debug log says:

--- snip ---
getting authentication...

listener-based authentication succeeded

incrementing session count...

waiting for exclusive access...

done waiting for exclusive access...

1

waiting for the scaler...

done waiting for the scaler...

done incrementing session count

getting a connection...

acquiring exclusive shm access

done acquiring exclusive shm access

waiting for an available connection

done waiting for an available connection

handoff=pass

signalling connection that we've read

done signalling connection that we've read

releasing exclusive shm access

done releasing exclusive shm access

done getting a connection

passing descriptor...

done passing descriptor

decrementing busy listeners

done decrementing busy listeners
--- snap ---

The lib appears to support:

PQclientEncoding	                yes
PQsetClientEncoding	yes

And it seems to look alright from the debug log - but python barfs.

Any ideas how to fix this?

Cheers,

Frank

Re: [Sqlrelay-discussion] Use with standard programs

[Alain M. <al...@po...>]

Ok, thanks for the info but...

I had already read those pages careefully. It shows how to use drop-in 
libraries in Linux. The problem is when I *need* to use some client in 
Windows. Most of them may not

But reading more carefully your explanation, maybe you are really 
answering my question :) - Can I have an ODBC server in my Linux machine 
and this in turn use the drop-in library and thus be accessed by any 
windows client program?

This would be PERFECT, is there any tutorial about that?

Thanks,
Alain

David Muse escreveu:
> Using the sqlrelay drop-in-replacement libraries, in theory, you can use
> SQL Relay with any program except PHP that supports mysql or postgresql.
> 
> See these pages for more info:
> http://sqlrelay.sourceforge.net/sqlrelay/dropin/mysql.html
> http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html
> 
> If an app uses odbc, then in theory, you could configure ODBC to use
> mysql or postgresql, then use the drop-in replacement libraries on top
> of that.
> 
> I say in theory because I haven't tried doing that with lots of apps and
> there could be things that don't work.
> 
> I'm currently working on an ODBC api for SQL Relay which should enable
> it to work with any app that uses ODBC without having to pretend to be
> mysql or postgresql.  But it has turned out to be quite a project and
> may be a while before it's production-ready.
> 
> Dave
> 
> On Fri, 2008-07-04 at 21:45 -0300, Alain M. wrote:
>> Hi,
>>
>> is it possible to access SqlRelay (and it's backend database) using 
>> standard programs like Delphi or report manager?
>>
>> Is this what the ODBC API is about? If so, how far is it in the Todo list?
>>
>> Thanks for any information,
>> Alain
>>

Re: [Sqlrelay-discussion] Working instance becomes problematic w/o obvious reason

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

Over the years, I've had sporadic reports of this but have rarely been
able to reproduce it reliably or narrow down what causes it.  In the few
cases that we were able to narrow it down, it was with Oracle databases
and we discovered that an individual connection daemon would get hung
trying to run a particular query.  Over a period of weeks that same
query would end up getting run on all of the connection daemons, hanging
each.  Eventually there weren't enough connection daemons running to
handle the traffic and the error you describe would occur.  In some
cases, Oracle had to be patched, in others SQL Relay had to be fixed.
In all cases though, there was a specific, offending query.  We
discovered the exact query by logging all queries and then replaying the
log through SQL Relay.  I'd recommend doing something like that to find
out exactly what query is causing the problem.  If you can narrow that
down, I can figure out a fix.

In theory, it's also possible for a PIX firewall to cause that problem,
though it usually presents itself differently.  See this page for more
info on that:
http://sqlrelay.sourceforge.net/sqlrelay/faq.html#firewallhang

David Muse
dav...@fi...


On Mon, 2008-06-30 at 10:15 +0200, Christian Hansel wrote:
> Hi all
> 
> 
> We are running sql-relay 0.39.4 with perl and mysql 5.0 with multiple
> server-connections with upwards 100K queries per day.
> 
> While everything works fine, we do have, from time to time, the problem
> that one of the connections simply hangs for whatever reason.
> 
> Once this problem occurs we get a "Couldnt connect to the listener"
> error message. After running sqlr-stop and sqlr-start the problem is
> solved again. 
> 
> We have spent weeks examining this problem but couldnt get any further.
> There simply is no obvious reason. The connection works fine and then
> suddenly the listener hangs it self. We first figured we created too
> much traffic, but the problem also occurs at times when there is less
> than 5 queries per minute. 
> 
> We also tried to create this problem manually to verify it or to examine
> it. However, we failed. We simply are not able to cause the
> listener/connection to hang it self and to report this error. Even after
> pushing the multiple amount of statements sqlr usually has to process.
> Nothing. We can not recreate the problem manually
> 
> 
> Today, for the first time, while being logged in to the server (console)
> and running sqlr-stop & sqlr-start on the specific instance after we had
> the problem, I got error messages dumped to the console. Unfortunately,
> I could not find any hint on the web when researching the error string:
> 
> handleQuery called with reexceute flag set to 0
> processQuery got ... [correct SQL Statement]
> 
> Excerpt from the sqlrelay.conf file :
> 
> <instance id="d02w" port="9022" socket="" dbase="mysql" connections="10"
> maxconnections="10" maxqueuelength="10" growby="2" ttl="10"
> endofsession="commit" sessiontimeout="600" runasuser="sqlrelay"
> runasgroup="sqlrelay" cursors="5" authtier="listener" handoff="pass"
> deniedips="" allowedips="127.0.0.1" addresses="127.0.0.1" debug="none"
> maxquerysize="65536" maxstringbindvaluelength="4000"
> maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1"
> listenertimeout="2">
>      <users>
>              <user user="XXXXXXXXXX" password="XXXXXXXX"/>
>      </users>
>      <connections>
>         <connection connectionid="d02w"
> string="user=XXXXXX;password=XXXXX;db=flyocache4w;host=172.16.37.XXX;port=XXXX;" metric="10" behindloadbalancer="no"/>
>      </connections>
>      <router>
>      </router>    
> </instance>
> 
> 
> Anybody has any hints ?
> 
> TIA,
> 
> Chris
> 
> 
> 
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] Use with standard programs

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

Using the sqlrelay drop-in-replacement libraries, in theory, you can use
SQL Relay with any program except PHP that supports mysql or postgresql.

See these pages for more info:
http://sqlrelay.sourceforge.net/sqlrelay/dropin/mysql.html
http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html

If an app uses odbc, then in theory, you could configure ODBC to use
mysql or postgresql, then use the drop-in replacement libraries on top
of that.

I say in theory because I haven't tried doing that with lots of apps and
there could be things that don't work.

I'm currently working on an ODBC api for SQL Relay which should enable
it to work with any app that uses ODBC without having to pretend to be
mysql or postgresql.  But it has turned out to be quite a project and
may be a while before it's production-ready.

Dave

On Fri, 2008-07-04 at 21:45 -0300, Alain M. wrote:
> Hi,
> 
> is it possible to access SqlRelay (and it's backend database) using 
> standard programs like Delphi or report manager?
> 
> Is this what the ODBC API is about? If so, how far is it in the Todo list?
> 
> Thanks for any information,
> Alain
> 
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[Leandro G. <le...@de...>]

This command only apply the patch on the source.

You must run:

# make clean
# ./configure
# make
# make install

After applying the patch.

===================================================================
 Leandro Barros Grandinetti <le...@de...>
 Gerente de Desenvolvimento <des...@de...>
 Devel-IT - http://www.devel-it.com.br - http://www.devel-it.org
 Fones: São Paulo +55 11 2124-7474 - Ourinhos: +55 14 3324-1200
 Ivoz: #1029
===================================================================



moaiamorfo escreveu:
>> Copy the patch to root source folder of sqlrelay, enter the directory and
>> type:
>>
>> patch -p1 < fix-wnolongdouble.dpatch
>>
>> The patch works for me using sqlrelay 0.39.4 in ubuntu 8.04
>>     
>
> thanks, the last question: this command executes also the three
> compiling steps (./configure, make and make install) or, after typing
> it, I must also compile sqlrelay sources?
>
> thanks again. :)
>
>   

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

> Copy the patch to root source folder of sqlrelay, enter the directory and
> type:
>
> patch -p1 < fix-wnolongdouble.dpatch
>
> The patch works for me using sqlrelay 0.39.4 in ubuntu 8.04

thanks, the last question: this command executes also the three
compiling steps (./configure, make and make install) or, after typing
it, I must also compile sqlrelay sources?

thanks again. :)

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python