sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] [sqlrelay] Why no 'errno' with DBD::SQLRelay?

[<b-r...@ro...>]

	I've got Perl package that checks for the errno when there is a
MySQL error. However, I found that SQLRelay was not passing them through -
just the error text. As a result, I was getting failures that were not
being caught.

	Why does SQLRelay not pass through the errno?

$errno = $dbh->{ 'mysql_errno' } ;

	Thanks,

Roger

[Sqlrelay-discussion] [sqlrelay] Cursor Error

[<b-r...@ro...>]

	I've been working with the most recent version for a couple weeks,
and for the most part, it functions quite well. However, periodically I
get the following error:

Failed to get a cursor id. A network error may have ocurred.

	Since I'm not going across the network, I know that is not the
problem. However, there doesn't seem to be any other information out there
on this error.

	The query (SELECT) itself is perfectly valid, and will execute if
I simply rerun it. However, when it happens in a web script, an end user
gets a script failure message on their browser, which isn't very elegant.

	My questions:

1) What is happening?

2) Is there a solution to the problem?

3) Is there a preferred kludge (such as checking for this specific error
text and rerunning the query if found) if there is no solution?

	Thanks.

Roger

[Sqlrelay-discussion] [sqlrelay] Perl API versus Perl DBI API

[<b-r...@ro...>]

	Some initial tests with the Perl API indicated that we got a
performance hit of 50% or more by using the DBI directly. I'm not
particularly worried by this, as the connection pooling is a good
trade-off, and we will realize a considerable performance gain by
converting our existing applications to use MySQL rather than CSV.

	I really like the Perl DBI API as, other than the initial
dbi->connect(), everything else just works. At the moment, that's what I'm
using. Here is what I have done:

	I set up a 'low level' library with basic routines to access the
database tables - delete, insert, select, update. Each routine does it's
own dbi->connect(). There are no worries about looping through millions of
inserts to load a table - the rows get inserted on an as-needed basis, not
in bulk. The application scripts never call these routines directly.

	Next, I set up intermediary libraries that set up the various SQL
statements used, so they get formatted the way the applications require.
The application scripts call these libraries.

	One of the reasons for using SQLRelay is to avoid setting up and
breaking down the database connections, but since I'm using the Perl DBI
API, I don't think that is happening, because I still have to do a
dbi->connect(), even to get to SQLRelay. When I looked at the
documentation for the Perl API (native), it indicated that only session
can run at a time.

	My questions:

1) Does the native API (Perl API) only allow a single connection to
SQLRelay at a time?

2) If so, doesn't that negate the connection pooling benefits of SQLRelay?

3) If using the Perl DBI API, how does the connection performance to
SQLRelay compare to connecting directly to the database?

4) Is there a significant performance difference between using the native
API versus the Perl DBI API? What would that be?

5) I only want to send basic SQL statements to be executed, with only
MySQL built-in functions (basic delete, insert, select, and update). Which
API is recommended - native or Perl DBI API?

	Thanks,

Roger

[Sqlrelay-discussion] update sqlrelay-0.41/test/perl/mysql.pl

[Patrick K. <pk...@bo...>]

Hey,
 since out of the box the sqlrelay perl test (mysql.pl) does not work
anymore (together with MySQL 5+). I updated the test case (mainly MySQL
binding issues :var -> ? ).
Included are two patches:
- "test_perl_mysql_pl" which updates the old mysql.pl to work the newer
mysql_binding scheme
- "test_perl_mysql5_pl" which adds a new file "mysql5.pl" like David did
for test/c++ .

Regards,
 Patrick Kirsch

-- 
Software Developer

Bookandsmile GmbH
Inselstraße 20
04103 Leipzig
Tel: 0341 / 30 89 51 12
-
Email: Pat...@bo...
Web: http://www.billigflieger.de | http://www.bookandsmile.de

[Sqlrelay-discussion] Not all connections are used

[Renat S. <sr...@st...>]

Hello!

Today I've seen strange situation with sqlrelay-0.40.

Sqlr-scaler started 12 connections, as max as it can. But only 2 client 
connections were processed in time, and other requests were queued  in 
forked listeners. Where were other 10 connections and what were they 
doing? From the Oracle side these sessions were doing  nothing.

Take a look at sqlr-status output:

--begin--
   Open   Server Connections:  12
   Opened Server Connections:  427

   Open   Client Connections:  2
   Opened Client Connections:  76590

   Open   Server Cursors:      120
   Opened Server Cursors:      80739

   Times  New Cursor Used:     0
   Times  Cursor Reused:       9273202

   Total  Queries:             4706353
   Total  Errors:              16756

   Forked Listeners:           9
--end--

config:
     <instance id="ow_admin" port="19003" 
socket="/onyma/sqlrelay/var/sqlrelay_ow_admin.socket"
               addresses="0.0.0.0" dbase="oracle8" connections="1" 
maxconnections="12"
               maxqueuelength="0" growby="1" ttl="60" 
endofsession="rollback"
               sessiontimeout="600" runasuser="onyma" runasgroup="onyma"
               cursors="10" authtier="listener" handoff="pass" deniedips=""
               allowedips="" debug="none" maxquerysize="65536"
               maxstringbindvaluelength="32767" 
maxlobbindvaluelength="71680"
               idleclienttimeout="120" maxlisteners="64" 
listenertimeout="60"
               maxsessioncount="256">
         <users>
             <user user="ow_admin" password="ow_admin"/>
         </users>
         <connections>
             <connection connectionid="ow_admin"
 
string="user=ow_admin;password=ow_admin;oracle_sid=rdbms1;nls_lang=AMERICAN_AMERICA.UTF8;"
                         metric="1"/>
         </connections>
     </instance>



-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...

Re: [Sqlrelay-discussion] sqlr-listener problems (0.39.4)

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

Please post the PHP code you're using and the sqlrsh commands you're
running.  From that I should be able to tell what's going on.

David Muse
dav...@fi...

On Fri, 2009-05-29 at 11:13 +0800, Lost Snow wrote:
> Hi, 
>  
> My sqlrelay version is 0.39.4,  
> and I use php client api 
>  
> When I use sqlrcon_ping() to check the connection  
> It returns: 
>  
> Connecting to listener... 
> Unix socket: /tmp/sqlrelay.socket 
> Inet socket: sqlrelay:9001 
> Setting Error 
> Couldn't connect to the listener. 
>  
>  
> Then I use strace to check the listener 
>  
> select(8, [3 4 5 6 7], NULL, NULL, NULL) = 1 (in [6]) 
> accept(6, {sa_family=AF_INET, sin_port=htons(64726),
> sin_addr=inet_addr("127.0.0.1")}, [16]) = 16 
> setsockopt(16, SOL_TCP, TCP_NODELAY, [1], 4) = 0 
> semctl(53149703, 10, IPC_64|GETVAL, 0xbff549f8) = 14 
> semop(53149703, 0x9b0aac8, 1) = 0 
> clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|
> SIGCHLD, child_tidptr=0xb7ef09d8) = 4245 
> --- SIGCHLD (Child exited) @ 0 (0) --- 
> waitpid(-1, NULL, WNOHANG) = 4245 
> waitpid(-1, NULL, WNOHANG) = -1 ECHILD (No child processes) 
> sigreturn() = ? (mask now ~[INT KILL ALRM TERM CHLD STOP RTMIN]) 
> close(16) = 0 
>  
>  
> But when I use sqlrsh it is ok. 
>  
> How to resolve?  
> Thank you. 
> 
> ------------------------------------------------------------------------------
> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
> is a gathering of tech-side developers & brand creativity professionals. Meet
> the minds behind Google Creative Lab, Visual Complexity, Processing, & 
> iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
> _______________________________________________ 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] sqlr-listener problems (0.39.4)

[Lost S. <mem...@gm...>]

Hi,

My sqlrelay version is 0.39.4,
and I use php client api

When I use sqlrcon_ping() to check the connection
It returns:

Connecting to listener...
Unix socket: /tmp/sqlrelay.socket
Inet socket: sqlrelay:9001
Setting Error
Couldn't connect to the listener.


Then I use strace to check the listener

select(8, [3 4 5 6 7], NULL, NULL, NULL) = 1 (in [6])
accept(6, {sa_family=AF_INET, sin_port=htons(64726),
sin_addr=inet_addr("127.0.0.1")}, [16]) = 16
setsockopt(16, SOL_TCP, TCP_NODELAY, [1], 4) = 0
semctl(53149703, 10, IPC_64|GETVAL, 0xbff549f8) = 14
semop(53149703, 0x9b0aac8, 1) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD,
child_tidptr=0xb7ef09d8) = 4245
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, NULL, WNOHANG) = 4245
waitpid(-1, NULL, WNOHANG) = -1 ECHILD (No child processes)
sigreturn() = ? (mask now ~[INT KILL ALRM TERM CHLD STOP RTMIN])
close(16) = 0


But when I use sqlrsh it is ok.

How to resolve?
Thank you.

Re: [Sqlrelay-discussion] 'Persistent' Connections to SQLRelay from PHP

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

Welby,

There's no plan currently to provide persistent connections between the
client and SQL Relay.  You could chain them using the query routing
feature, but I believe that the local SQL Relay server will disconnect
from the remote SQL Relay server each time a local client disconnects
from it.

I believe that the only thing you could do to get better performance
than using PHP's persistent connections would be to run an instance of
SQL Relay on each web server and use the local socket option.

Your current setup should give you substantially better performance than
connecting and disconnecting directly to/from Oracle, but not better
performance than PHP's persistent connections.  The tradeoff is that
PHP's persistent connections could cause more connections to be opened
to the DB than SQL Relay would, which could ultimately be a problem.

I'm surprised at the 700 vs 150ms though, I wouldn't expect it to be
that much slower.  How much of that time does the DB say is spent
running the query?

Also, did you try the other tuning strategies described in:
http://sqlrelay.sourceforge.net/sqlrelay/tuning.html ?
If your requests are small, then using dontGetColumnInfo() would likely
help a lot, but might require code changes.  Also, make sure you're
using file descriptor passing.

Other than that, I'm not sure that much else could be done.  I'll have
to do some tests here and see if I get the same results.

David Muse
dav...@fi...

On Thu, 2009-05-28 at 17:49 +0100, Welby McRoberts wrote:
> Hello
> 
> We are currently in the process of deploying SQLRelay across our
> Authentication & Authorization estate and have unfortunately come into
> a slight show stopper. Due to the way that our Auth tier is written we
> deal with multiple small requests which is meaning a new connection
> tear up and tear down for each request. As SQLRelay isn't running on
> each of the web servers in the Auth Tier we've not been able to use
> the local socket and have noticed that our average time for a standard
> auth call (averaging at 5 requests) is taking upwards of 700mS. The
> same using Oracle with a persistent DB connection is taking around 150
> mS.
> Obviously we're quite anxious of this and would like to know if there
> are any plans to implement persistent connections in the SQLRelay PHP
> extension or if it is possible to 'chain' SQLRelay servers to each
> other (ie SQLRelay running on a web server connecting to our dedicated
> SQLRelay hosts which in turn connect to Oracle?
> 
> Thanks
> Welby
> 
> ------------------------------------------------------------------------------
> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
> is a gathering of tech-side developers & brand creativity professionals. Meet
> the minds behind Google Creative Lab, Visual Complexity, Processing, & 
> iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
> _______________________________________________
> 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] 'Persistent' Connections to SQLRelay from PHP

[Welby M. <wel...@wh...>]

Hello

We are currently in the process of deploying SQLRelay across our
Authentication & Authorization estate and have unfortunately come into
a slight show stopper. Due to the way that our Auth tier is written we
deal with multiple small requests which is meaning a new connection
tear up and tear down for each request. As SQLRelay isn't running on
each of the web servers in the Auth Tier we've not been able to use
the local socket and have noticed that our average time for a standard
auth call (averaging at 5 requests) is taking upwards of 700mS. The
same using Oracle with a persistent DB connection is taking around 150
mS.
Obviously we're quite anxious of this and would like to know if there
are any plans to implement persistent connections in the SQLRelay PHP
extension or if it is possible to 'chain' SQLRelay servers to each
other (ie SQLRelay running on a web server connecting to our dedicated
SQLRelay hosts which in turn connect to Oracle?

Thanks
Welby

Re: [Sqlrelay-discussion] "failed to connect to the database Couldn't log into database." error

[Christian V. <cv...@gm...>]

Thanks!

Already solved this problem. This last thing was a non-deleted comment on
the freetds.conf file :S

Soon i will post a complete update and short guide to install it in ubuntu.

Greetings,

On Fri, May 29, 2009 at 11:14 AM, David Muse <dav...@fi...>wrote:

> The only thing that stands out to me is the password='' part of the
> string="sybase..." parameter.  I think that will end up literally
> passing '' as the password.  Try just omitting the password part
> altogether:
>
> string="sybase=/etc/freetds/;user=sa;server=GOLDMINE;db=Goldmine;"
>
> and see what you get.  Or, configure the DB to have a password :)
>
> David Muse
> dav...@fi...
>
> On Thu, 2009-05-21 at 14:20 +0000, Christian Vielma wrote:
> > Hi there!
> >
> > I'm sorry to bother you because i always want to resolve the problem
> > by my own, but i'm really stucked with this problem, and it had to be
> > done three days ago :S
> >
> > I want to configure sql-relay to connect a Plone site to a MS SQL
> > Server. I have configured FreeTDS (and tested with isql that it
> > works), and because of some problem with ubuntu and sql-relay packages
> > (i guess) i decided to compile a fresh new Sql-relay 0.41 on my
> > system.
> >
> > I have configured the compile like this:
> > ./configure --disable-oracle --disable-mysql --disable-postgresql
> > --disable-sqlite --disable-sybase --disable-db2 --disable-firebird
> > --disable-mdbtools --disable-perl
> > --with-python-prefix="/usr/include/python2.4"
> >
> > (also tried with all enabled)
> >
> > The thing is that when i run:
> >
> > sqlr-start -id mssql
> >
> > It gives me the following output:
> > Starting listener:
> >   sqlr-listener -id mssql
> > -config /usr/local/firstworks/etc/sqlrelay.conf -debug
> > Debugging
> > to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12839
> >
> > Starting 1 connections to db1 :
> >   sqlr-connection-freetds -id mssql -connectionid db1
> > -config /usr/local/firstworks/etc/sqlrelay.conf -debug
> >
> > Starting scaler:
> >   sqlr-scaler -id mssql -debug
> > -config /usr/local/firstworks/etc/sqlrelay.conf
> >
> > cache manager already running.
> >
> >
> > Thanks to MP3.com for sponsoring:
> >     Clustered/Replicated database support.
> >     Perl API.
> > Thanks to FeedLounge for sponsoring:
> >     Query routing and filtering.
> > failed to connect to the database
> > Couldn't log into database.
> >
> >
> > I have tried starting the daemon individually and still gives me the
> > same error. I can't see the sqlr-connection debug because it fails
> > before it shows me some debug...
> >
> > I'm running Ubuntu 8.04, and these are my configuration files:
> >
> > /etc/freetds/freetds.conf:
> > --------
> > # A typical Microsoft SQL Server 2000 configuration
> > ;[GOLDMINE]
> >     host = 192.168.1.12
> >     port = 1433
> >     tds version = 8.0
> >     client charset = UTF-8
> > ---------
> >
> >
> > /usr/local/firstworks/etc/sqlrelay.conf:
> > <?xml version="1.0"?>
> > <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> >
> > <instances>
> >    <instance id="mssql" port="9000" socket="/tmp/examplesocket"
> > dbase="freetds" connections="1" maxconnections="15" maxqueuelength="5"
> > growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
> > runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
> > handoff="pass" debug="listener_and_connection">
> >       <users>
> >          <user user="sa" password=""/>
> >       </users>
> >       <connections>
> >          <connection connectionid="db1"
> >
> string="sybase=/etc/freetds/;user=sa;password='';server=GOLDMINE;db=Goldmine;"
> metric="1"/>
> >       </connections>
> >    </instance>
> > </instances>
> >
> >
> >
> > Do you have any idea what it could be? I ran out of ideas :S
> >
> > Thanks in advance.
> >
> > Greetings,
> >
> > --
> > Christian Vielma
> >
> > "Somos lo que hacemos día a día.
> > De modo que la excelencia no es un acto, sino un hábito" - Aristóteles
> >
> ------------------------------------------------------------------------------
> > Crystal Reports - New Free Runtime and 30 Day Trial
> > Check out the new simplified licensing option that enables
> > unlimited royalty-free distribution of the report engine
> > for externally facing server and web deployment.
> > http://p.sf.net/sfu/businessobjects
> > __________________________________________________
> > D O T E A S Y - "Join the web hosting revolution!"
> >              http://www.doteasy.com
> > _______________________________________________ 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
>
>
> ------------------------------------------------------------------------------
> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
> is a gathering of tech-side developers & brand creativity professionals.
> Meet
> the minds behind Google Creative Lab, Visual Complexity, Processing, &
> iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>



-- 
Christian Vielma

"Somos lo que hacemos día a día.
De modo que la excelencia no es un acto, sino un hábito" - Aristóteles

Re: [Sqlrelay-discussion] SQL Relay 0.41 Couldn't parse config file sqlrelay.conf

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

Wow, this is quite a bug.  Basically, if you don't have an addresses
attribute, then it won't listen for inet connections at all.

The patch and workaround are both correct though.  Either should take
care of the problem.

I'm rolling this patch into the next release now.  Thanks for finding
that Alexey.

David Muse
dav...@fi...

On Fri, 2009-05-22 at 01:29 +0400, Alex wrote:
> Hi all!
> 
> Problem in file
> src/util/sqlrconfigfile.C
> --------------
> sqlrconfigfile::sqlrconfigfile() : xmlsax() {
>         addresses=new char *[1];
>         addresses[0]=charstring::duplicate("0.0.0.0");
>         addresscount=1;    //  in  original  file addresscount=0;
>         port=0;
>         listenoninet=false;
>         unixport=charstring::duplicate("");
>         listenonunix=false;
> ----------
> Try patch file...
> 
> or  add  in  config file parameter: addresses="0.0.0.0" not sure about
> this...
> 
> addresscount=0 it's small error in code
> addreses array length = 1 and addresscount must have 1
> 
> 
> O> Hi all,
> 
> O> I've installed SQL Relay 0.41. There is error when I try to run
> O> it. Initially my sqlrelay.conf is like this:
> O> ------START CONFIG---------------
> O> <?xml version="1.0"?>
> O> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> O> <instances>
> O> 	<instance id="mysql1" port="9000" socket="/tmp/mysql1.socket"
> O> dbase="mysql" connections="3" maxconnections="20"
> O> maxqueuelength="2" growby="1" ttl="60" maxsessioncount="10"
> O> endofsession="commit" sessiontimeout="600" runasuser="nobody"
> O> runasgroup="nobody" cursors="5" authtier="listener" handoff="pass"
> O> deniedips="" allowedips="" debug="none" maxquerysize="65536"
> O> maxstringbindvaluelength="32768" maxlobbindvaluelength="71680"
> O> idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
> O> reloginatstart="no" timequeriessec="-1" timequeriesusec="-1">
> O> 		<users>
> O> 			<user user="user" password="pw"/>
> O> 		</users>
> O> 		<connections>
> O> 			<connection connectionid="mysql1"
> O> string="user=me;password=pass;db=db1;socket=/var/lib/mysql/mysql.sock"
> O> metric="1" behindloadbalancer="no"/>
> O> 		</connections>
> O> 	</instance>
> 
> O> </instances>
> O> ------END CONFIG---------------
> 
> O> When I run "sqlr-start -id mysql1", I get this:
> O> --------START ERR MSG--------
> O> Starting listener:
> O>   sqlr-listener -id mysql1 -config /usr/local/etc/sqlrelay.conf
> 
> O> Starting 3 connections to mysql1 :
> O>   sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
> O>   sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
> O>   sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
> 
> O> Starting scaler:
> O>   sqlr-scaler -id mysql1 -config /usr/local/etc/sqlrelay.conf
> 
> O> sqlr-scaler error: 
> O> 	The file /usr/local/var/sqlrelay/tmp/pids/sqlr-listener-mysql1 was not found.
> O> 	This usually means that the sqlr-listener is not running.
> O> 	The sqlr-listener must be running for the sqlr-scaler to start.
> 
> 
> O> sqlr-scaler failed to start.
> 
> 
> O> Thanks to MP3.com for sponsoring: 
> O> 	Clustered/Replicated database support.
> O> 	Perl API.
> O> Thanks to FeedLounge for sponsoring: 
> O> 	Query routing and filtering.
> O> --------END ERR MSG--------
> 
> O> I followed a solution found at:
> O> http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion
> 
> O> and added a dummy instance as first entry. When I try to run again, I get this error:
> O> Couldn't parse config file /usr/local/etc/sqlrelay.conf.
> O> Couldn't find id mysql1.
> 
> O> I've checked and sqlrelay.conf is readable by all groups. So I
> O> assume it must a problem with the XML parser. I'm using 0.41 while
> O> the person giving the solution is using 0.40. Not sure is there is
> O> any change in both versions that makes the solution not working.
> 
> O> Anyone knows of a solution? Or will this be fixed in the coming versions?
> 
> O> Thanks,
> O> Olivia
> 
> 
> 
> 
>       
> 
> O> ------------------------------------------------------------------------------
> O> Crystal Reports - New Free Runtime and 30 Day Trial
> O> Check out the new simplified licensing option that enables 
> O> unlimited royalty-free distribution of the report engine 
> O> for externally facing server and web deployment. 
> O> http://p.sf.net/sfu/businessobjects
> O> _______________________________________________
> O> Sqlrelay-discussion mailing list
> O> Sql...@li...
> O> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> O> __________ NOD32 4084 (20090518) Information __________
> 
> O> This message was checked by NOD32 antivirus system.
> O> http://www.eset.com
> 
> 
> 
> 


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

Re: [Sqlrelay-discussion] "failed to connect to the database Couldn't log into database." error

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

The only thing that stands out to me is the password='' part of the
string="sybase..." parameter.  I think that will end up literally
passing '' as the password.  Try just omitting the password part
altogether:

string="sybase=/etc/freetds/;user=sa;server=GOLDMINE;db=Goldmine;"

and see what you get.  Or, configure the DB to have a password :)

David Muse
dav...@fi...

On Thu, 2009-05-21 at 14:20 +0000, Christian Vielma wrote:
> Hi there!
> 
> I'm sorry to bother you because i always want to resolve the problem
> by my own, but i'm really stucked with this problem, and it had to be
> done three days ago :S
> 
> I want to configure sql-relay to connect a Plone site to a MS SQL
> Server. I have configured FreeTDS (and tested with isql that it
> works), and because of some problem with ubuntu and sql-relay packages
> (i guess) i decided to compile a fresh new Sql-relay 0.41 on my
> system. 
> 
> I have configured the compile like this: 
> ./configure --disable-oracle --disable-mysql --disable-postgresql
> --disable-sqlite --disable-sybase --disable-db2 --disable-firebird
> --disable-mdbtools --disable-perl
> --with-python-prefix="/usr/include/python2.4"
> 
> (also tried with all enabled)
> 
> The thing is that when i run:
> 
> sqlr-start -id mssql
> 
> It gives me the following output:
> Starting listener:
>   sqlr-listener -id mssql
> -config /usr/local/firstworks/etc/sqlrelay.conf -debug
> Debugging
> to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12839
> 
> Starting 1 connections to db1 :
>   sqlr-connection-freetds -id mssql -connectionid db1
> -config /usr/local/firstworks/etc/sqlrelay.conf -debug
> 
> Starting scaler:
>   sqlr-scaler -id mssql -debug
> -config /usr/local/firstworks/etc/sqlrelay.conf
> 
> cache manager already running.
> 
> 
> Thanks to MP3.com for sponsoring: 
>     Clustered/Replicated database support.
>     Perl API.
> Thanks to FeedLounge for sponsoring: 
>     Query routing and filtering.
> failed to connect to the database
> Couldn't log into database.
> 
> 
> I have tried starting the daemon individually and still gives me the
> same error. I can't see the sqlr-connection debug because it fails
> before it shows me some debug...
> 
> I'm running Ubuntu 8.04, and these are my configuration files:
> 
> /etc/freetds/freetds.conf:
> --------
> # A typical Microsoft SQL Server 2000 configuration
> ;[GOLDMINE]
>     host = 192.168.1.12
>     port = 1433
>     tds version = 8.0
>     client charset = UTF-8
> ---------
> 
> 
> /usr/local/firstworks/etc/sqlrelay.conf:
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> 
> <instances>
>    <instance id="mssql" port="9000" socket="/tmp/examplesocket"
> dbase="freetds" connections="1" maxconnections="15" maxqueuelength="5"
> growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
> runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
> handoff="pass" debug="listener_and_connection">
>       <users>
>          <user user="sa" password=""/>
>       </users>
>       <connections>
>          <connection connectionid="db1"
> string="sybase=/etc/freetds/;user=sa;password='';server=GOLDMINE;db=Goldmine;" metric="1"/>
>       </connections>
>    </instance>    
> </instances>
> 
> 
>     
> Do you have any idea what it could be? I ran out of ideas :S
> 
> Thanks in advance.
> 
> Greetings,
> 
> -- 
> Christian Vielma
> 
> "Somos lo que hacemos día a día.
> De modo que la excelencia no es un acto, sino un hábito" - Aristóteles
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables 
> unlimited royalty-free distribution of the report engine 
> for externally facing server and web deployment. 
> http://p.sf.net/sfu/businessobjects
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
> _______________________________________________ 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] mysql TEXT field

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

There's no configurable parameter for it, but you could recompile the
code.  You should be able to edit
src/connections/mysql/mysqlconnection.h and set MAX_ITEM_BUFFER_SIZE
from 32768 to whatever size you like.

Doing that will probably make the connection daemon use more memory, so
be careful how large you set it.

Dave
dav...@fi...

On Thu, 2009-05-28 at 10:28 -0400, Stéphane HENRY wrote:
> Hi,
> 
> 
> I use sqlrelay version 0.38.
> I have a Mysql table with a TEXT field, this field contains data
> length >32k for each field. I can't get this field using sqlrelay. Is
> there a parameter or something to set to allow to retreive a field >
> 32k ?
> 
> 
> Thanks !
> 
> 
> Stéphane
> ------------------------------------------------------------------------------
> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
> is a gathering of tech-side developers & brand creativity professionals. Meet
> the minds behind Google Creative Lab, Visual Complexity, Processing, & 
> iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
> _______________________________________________ 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] mysql TEXT field

[Stéphane H. <ste...@gm...>]

Hi,
I use sqlrelay version 0.38.
I have a Mysql table with a TEXT field, this field contains data length >32k
for each field. I can't get this field using sqlrelay. Is there a parameter
or something to set to allow to retreive a field > 32k ?

Thanks !

Stéphane

Re: [Sqlrelay-discussion] SQL Relay 0.41 Couldn't parse config file sqlrelay.conf

[Alex <al...@lb...>]

Hi all!

Problem in file
src/util/sqlrconfigfile.C
--------------
sqlrconfigfile::sqlrconfigfile() : xmlsax() {
        addresses=new char *[1];
        addresses[0]=charstring::duplicate("0.0.0.0");
        addresscount=1;    //  in  original  file addresscount=0;
        port=0;
        listenoninet=false;
        unixport=charstring::duplicate("");
        listenonunix=false;
----------
Try patch file...

or  add  in  config file parameter: addresses="0.0.0.0" not sure about
this...

addresscount=0 it's small error in code
addreses array length = 1 and addresscount must have 1


O> Hi all,

O> I've installed SQL Relay 0.41. There is error when I try to run
O> it. Initially my sqlrelay.conf is like this:
O> ------START CONFIG---------------
O> <?xml version="1.0"?>
O> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
O> <instances>
O> 	<instance id="mysql1" port="9000" socket="/tmp/mysql1.socket"
O> dbase="mysql" connections="3" maxconnections="20"
O> maxqueuelength="2" growby="1" ttl="60" maxsessioncount="10"
O> endofsession="commit" sessiontimeout="600" runasuser="nobody"
O> runasgroup="nobody" cursors="5" authtier="listener" handoff="pass"
O> deniedips="" allowedips="" debug="none" maxquerysize="65536"
O> maxstringbindvaluelength="32768" maxlobbindvaluelength="71680"
O> idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
O> reloginatstart="no" timequeriessec="-1" timequeriesusec="-1">
O> 		<users>
O> 			<user user="user" password="pw"/>
O> 		</users>
O> 		<connections>
O> 			<connection connectionid="mysql1"
O> string="user=me;password=pass;db=db1;socket=/var/lib/mysql/mysql.sock"
O> metric="1" behindloadbalancer="no"/>
O> 		</connections>
O> 	</instance>

O> </instances>
O> ------END CONFIG---------------

O> When I run "sqlr-start -id mysql1", I get this:
O> --------START ERR MSG--------
O> Starting listener:
O>   sqlr-listener -id mysql1 -config /usr/local/etc/sqlrelay.conf

O> Starting 3 connections to mysql1 :
O>   sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
O>   sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
O>   sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf

O> Starting scaler:
O>   sqlr-scaler -id mysql1 -config /usr/local/etc/sqlrelay.conf

O> sqlr-scaler error: 
O> 	The file /usr/local/var/sqlrelay/tmp/pids/sqlr-listener-mysql1 was not found.
O> 	This usually means that the sqlr-listener is not running.
O> 	The sqlr-listener must be running for the sqlr-scaler to start.


O> sqlr-scaler failed to start.


O> Thanks to MP3.com for sponsoring: 
O> 	Clustered/Replicated database support.
O> 	Perl API.
O> Thanks to FeedLounge for sponsoring: 
O> 	Query routing and filtering.
O> --------END ERR MSG--------

O> I followed a solution found at:
O> http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion

O> and added a dummy instance as first entry. When I try to run again, I get this error:
O> Couldn't parse config file /usr/local/etc/sqlrelay.conf.
O> Couldn't find id mysql1.

O> I've checked and sqlrelay.conf is readable by all groups. So I
O> assume it must a problem with the XML parser. I'm using 0.41 while
O> the person giving the solution is using 0.40. Not sure is there is
O> any change in both versions that makes the solution not working.

O> Anyone knows of a solution? Or will this be fixed in the coming versions?

O> Thanks,
O> Olivia




      

O> ------------------------------------------------------------------------------
O> Crystal Reports - New Free Runtime and 30 Day Trial
O> Check out the new simplified licensing option that enables 
O> unlimited royalty-free distribution of the report engine 
O> for externally facing server and web deployment. 
O> http://p.sf.net/sfu/businessobjects
O> _______________________________________________
O> Sqlrelay-discussion mailing list
O> Sql...@li...
O> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

O> __________ NOD32 4084 (20090518) Information __________

O> This message was checked by NOD32 antivirus system.
O> http://www.eset.com




-- 
Best Regards
 Alexey Leontev                      mailto:al...@lb...

[Sqlrelay-discussion] "failed to connect to the database Couldn't log into database." error

[Christian V. <cv...@gm...>]

Hi there!

I'm sorry to bother you because i always want to resolve the problem by my
own, but i'm really stucked with this problem, and it had to be done three
days ago :S

I want to configure sql-relay to connect a Plone site to a MS SQL Server. I
have configured FreeTDS (and tested with isql that it works), and because of
some problem with ubuntu and sql-relay packages (i guess) i decided to
compile a fresh new Sql-relay 0.41 on my system.

I have configured the compile like this:
./configure --disable-oracle --disable-mysql --disable-postgresql
--disable-sqlite --disable-sybase --disable-db2 --disable-firebird
--disable-mdbtools --disable-perl
--with-python-prefix="/usr/include/python2.4"

(also tried with all enabled)

*The thing is that when i run:*

sqlr-start -id mssql

*It gives me the following output:*
Starting listener:
  sqlr-listener -id mssql -config /usr/local/firstworks/etc/sqlrelay.conf
-debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12839

Starting 1 connections to db1 :
  sqlr-connection-freetds -id mssql -connectionid db1 -config
/usr/local/firstworks/etc/sqlrelay.conf -debug

Starting scaler:
  sqlr-scaler -id mssql -debug  -config
/usr/local/firstworks/etc/sqlrelay.conf

cache manager already running.


Thanks to MP3.com for sponsoring:
    Clustered/Replicated database support.
    Perl API.
Thanks to FeedLounge for sponsoring:
    Query routing and filtering.
*failed to connect to the database*
*Couldn't log into database.*

I have tried starting the daemon individually and still gives me the same
error. I can't see the sqlr-connection debug because it fails before it
shows me some debug...

I'm running Ubuntu 8.04, and these are my configuration files:

*/etc/freetds/freetds.conf:*
--------
# A typical Microsoft SQL Server 2000 configuration
;[GOLDMINE]
    host = 192.168.1.12
    port = 1433
    tds version = 8.0
    client charset = UTF-8
---------

*/usr/local/firstworks/etc/sqlrelay.conf*:
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instances>
   <instance id="*mssql*" port="9000"
socket="/tmp/examplesocket"*dbase="freetds"
* connections="1" maxconnections="15" maxqueuelength="5" growby="1" ttl="60"
endofsession="commit" sessiontimeout="600" runasuser="nobody"
runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" *
debug="listener_and_connection"*>
      <users>
         <user *user="sa" password=""*/>
      </users>
      <connections>
         <connection connectionid="*db1*" string="*
sybase=/etc/freetds/;user=sa;password='';server=GOLDMINE;db=Goldmine;*"
metric="1"/>
      </connections>
   </instance>
</instances>


Do you have any idea what it could be? I ran out of ideas :S

Thanks in advance.

Greetings,

-- 
Christian Vielma

"Somos lo que hacemos día a día.
De modo que la excelencia no es un acto, sino un hábito" - Aristóteles

[Sqlrelay-discussion] SQL Relay 0.41 Couldn't parse config file sqlrelay.conf

[Olivia <oli...@ya...>]

Hi all,

I've installed SQL Relay 0.41. There is error when I try to run it. Initially my sqlrelay.conf is like this:
------START CONFIG---------------
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
	<instance id="mysql1" port="9000" socket="/tmp/mysql1.socket" dbase="mysql" connections="3" maxconnections="20" maxqueuelength="2" growby="1" ttl="60" maxsessioncount="10" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="32768" maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0" reloginatstart="no" timequeriessec="-1" timequeriesusec="-1">
		<users>
			<user user="user" password="pw"/>
		</users>
		<connections>
			<connection connectionid="mysql1" string="user=me;password=pass;db=db1;socket=/var/lib/mysql/mysql.sock" metric="1" behindloadbalancer="no"/>
		</connections>
	</instance>

</instances>
------END CONFIG---------------

When I run "sqlr-start -id mysql1", I get this:
--------START ERR MSG--------
Starting listener:
  sqlr-listener -id mysql1 -config /usr/local/etc/sqlrelay.conf

Starting 3 connections to mysql1 :
  sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
  sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
  sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf

Starting scaler:
  sqlr-scaler -id mysql1 -config /usr/local/etc/sqlrelay.conf

sqlr-scaler error: 
	The file /usr/local/var/sqlrelay/tmp/pids/sqlr-listener-mysql1 was not found.
	This usually means that the sqlr-listener is not running.
	The sqlr-listener must be running for the sqlr-scaler to start.


sqlr-scaler failed to start.


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

I followed a solution found at:
http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion

and added a dummy instance as first entry. When I try to run again, I get this error:
Couldn't parse config file /usr/local/etc/sqlrelay.conf.
Couldn't find id mysql1.

I've checked and sqlrelay.conf is readable by all groups. So I assume it must a problem with the XML parser. I'm using 0.41 while the person giving the solution is using 0.40. Not sure is there is any change in both versions that makes the solution not working.

Anyone knows of a solution? Or will this be fixed in the coming versions?

Thanks,
Olivia




      

Re: [Sqlrelay-discussion] sqlr-listener-0.4X dies with Oracle10g x86_64

[Ignacio B. <ign...@gm...>]

Thanks  Benoit,


I managed to run 0.4X version adding a dummy instance to
sqlrelay.conf, and seems works fine. I haven't  found errors, but
after reading your post, I am worried: I wanted to upgrade from 0.39.4
to 0.4X to check if that solves the hanging sessions. I will try
compile again using the oracle full client.

Thank you very much for your reply.

Ignacio Barrancos

Re: [Sqlrelay-discussion] sqlr-listener-0.4X dies with Oracle10g x86_64

[Benoit C. <ben...@fr...>]

Hi,

I also had a lot a problems with sqlrelay 0-4x and oracle 10G, (sqlrelay
running out of cursors or segfault).
Actually, I'm still using 0.39.4 for production

I had reported it and David M. is working on it (your changelog's quote).
I'm waiting for a new release.


For your problem, you can try looking at :
- the simplest one : is
/usr/local/stow/sqlrelay-0.41/var/sqlrelay/tmp/pids/ writable by
"sqlrelay user" (depends on your sqlrelay.conf file).
- i also had a similar problem by having a miswritten sqlrelay.conf file
with a single instance. Have a look at your file (maybe post it here)
and try to define a second instance
- i'm using oracle full client. instantclient causes me lots of troubles
 :)  you can try to compile sqlrelay with the oracle full client but if it
works actually fine with instant client and 0.39.4 i dont think i would
change something.
- the sqlr-scaler process only start if in your conf file your have
different values betwin connections and maxconnections

I understand your using sqlrelay 0.39.4 rpm. You can try to recompile
0.39.4 see if it's working fine with your way. If not, may be you doing
something wrong.

But I think there is some kind of problems with sqlrelay 0.40 / 0.41 and
oracle

Best regards.

Benoit Cattié



Ignacio Barrancos a écrit :
> Hi,
>
> This weekend, I tried to compile sqlrelay 0.41 in a 32bits server, using:
>
>    Oracle server:  Oracle XE 10.2.0.1
>    Operative System:       RHEL4U3  i386
>    GCC version:              3.4.5 20051201 (Red Hat 3.4.5-2)
>    Rudiments version:      0.32
>    Oracle Client:      oracle-instantclient-basic-10.2.0.3-1.i386.rpm
>                              oracle-instantclient-devel-10.2.0.3-1.i386.rpm
>                              oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
>                              oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm
>
> And I got the same result:  0.39.4 Works fine, sqlr-listener startup
> and all ok.   0.41 doesn't work ... when i execute "sqlr-start -id
> oracletest"  ...  sqlr-listener dies, and sqlr-scaler can't start.
>
>
> May be exists some problem with Oracle and  later versions than  sqlrelay-39.4 ?
>
> Thanks in advance,
> Ignacio.
>
>
>
> 2009/5/7, Ignacio Barrancos <ign...@gm...>:
>   
>> Hi guys,
>>
>>  I'm using sqlrelay-0.39.4 on my 64bits server:
>>
>>   Operative System:   RHEL5U2 x86_64
>>   GCC version:        4.1.2 20071124 (Red Hat 4.1.2-42)
>>   Rudiments version:  0.31
>>   Oracle Client:      oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
>>                       oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm
>>                       oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm
>>                       oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm
>>
>>
>>   This version works fine on my web server (i have installed in
>>  /usr/local/firstworks), but sometimes, after has many visits
>>  simultaneous and CPU load is high, i must restart apache2, and
>>  sqlr-connection-oracle8 proccess hangs and then i can't stop sqlrelay
>>  (sqlr-stop)
>>
>>   I have read the ChangeLog of new versions, i want test these news
>>  version:  I'm trying run sqlrelay-0.41, sqlrelay-0.40, and
>>  sqlrelay-CVS_HEAD compiled with-oracle support on my server, like i
>>  done for sqlrelay-0.39.4 and using the same programs and libraries.
>>
>>   I'm using "stow" command for the compilation, because i can test
>>  diferent versions.
>>
>>   The Oracle Instantclient x86_64 installs the libraries at
>>  /usr/lib/oracle/10.2.0.3/client64/lib/ and the includes at
>>  /usr/include/oracle/10.2.0.3/client64.  I have edit to "configure"
>>  file (after tar xzvf VERSION_SQLRELAY.tgz)  and  apply this patch:
>>
>>
>>  --------8<-- Patch_on_configure ------8<---------------
>>  22994c22994
>>  <                               if ( test -r
>>  "/usr/lib/oracle/$version/client/lib/libclntsh.$SOSUFFIX" -a -r
>>  "/usr/include/oracle/$version/client/oci.h" )
>>  ---
>>  >                               if ( test -r "/usr/lib/oracle/$version/client64/lib/libclntsh.$SOSUFFIX" -a -r "/usr/include/oracle/$version/client64/oci.h" )
>>  22997,22999c22997,22999
>>  <                                       ORACLELIBSPATH="/usr/lib/oracle/$version/client/lib"
>>  <                                       ORACLELIBS="-L/usr/lib/oracle/$version/client/lib -lclntsh -lnnz10"
>>  <                                       ORACLEINCLUDES="-I/usr/include/oracle/$version/client"
>>  ---
>>  >                                       ORACLELIBSPATH="/usr/lib/oracle/$version/client64/lib"
>>  >                                       ORACLELIBS="-L/usr/lib/oracle/$version/client64/lib -lclntsh -lnnz10"
>>  >                                       ORACLEINCLUDES="-I/usr/include/oracle/$version/client64"
>>  --------8<-- Patch_on_configure ------8<---------------
>>
>>
>>
>>   Then, for compile 0.41,  i executed:
>>
>>
>>
>>
>>  --------8<---- commands for compile -------8<-------------
>>
>>   ./configure --prefix=/usr/local/stow/sqlrelay-0.41 --disable-python
>>  --disable-mysql --disable-postgresql --disable-sqlite
>>  --disable-freetds --disable-sybase --disable-odbc --disable-db2
>>  --disable-firebird --disable-mdbtools --disable-perl --disable-zope
>>  --disable-ruby --disable-java --disable-tcl --disable-gtk
>>
>>   make
>>   make install
>>
>>  # With these lines i can install on /usr/local/bin, /usr/local/lib,
>>  etc,  with stow.
>>
>>   cd /usr/local/stow
>>   cp /usr/local/firstworks/etc/sqlrelay.conf sqlrelay-0.41/etc/
>>
>>   stow sqlrelay-0.41
>>
>>  --------8<---- commands for compile -------8<-------------
>>
>>
>>
>>   Then, execute these commands to launch SQLRelay
>>
>>
>>  -------8<-------launch sqlrelay ----------8<--------------
>>   export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client64/lib:/usr/local/lib:${LD_LIBRARY_PATH}
>>   export TNS_ADMIN=/home
>>   export NLS_LANG=American_America.WE8ISO8859P1
>>
>>   sqlr-start -id oracletest
>>  -------8<-------launch sqlrelay ----------8<--------------
>>
>>
>>
>>   And i obtain this output....
>>
>>
>>
>>  -------8<-------output--------------------8<--------------
>>   Starting listener:
>>   sqlr-listener -id oracletest -config
>>  /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>
>>   Starting 5 connections to oracletest :
>>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>
>>   Starting scaler:
>>   sqlr-scaler -id oracletest -config
>>  /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>
>>   sqlr-scaler error:
>>         The file /usr/local/stow/sqlrelay-0.41/var/sqlrelay/tmp/pids/sqlr-listener-oracletest
>>  was not found.
>>         This usually means that the sqlr-listener is not running.
>>         The sqlr-listener must be running for the sqlr-scaler to start.
>>
>>
>>  sqlr-scaler failed to start.
>>
>>
>>  Thanks to MP3.com for sponsoring:
>>         Clustered/Replicated database support.
>>         Perl API.
>>  Thanks to FeedLounge for sponsoring:
>>         Query routing and filtering.
>>
>>  -------8<-------output--------------------8<--------------
>>
>>
>>
>>   It seems that, when start the maximum sqlr-connection-oracle8
>>  connections that i have configured in sqlrelay.conf (five in my case)
>>  , the sqlr-listener proccess dies, and then sqlr-scaler startup fails,
>>  because it can't found sqlr-listener-oracletest.
>>
>>   I have try some versions: sqlrelay-0.41, sqlrelay-0.40, and
>>  sqlrelay-CVS_HEAD, and most recents Oracle Instants clients for 64bits
>>  (10.2.0.4) and all versions upper than 0.39.4, i obtained de same
>>  result, in the same server ...
>>
>>
>>   - what am I doing wrong?
>>   - Is a bug?
>>   - what can I do to debug if it's a configuration problem?
>>
>>
>>   thanks in advance,
>>
>>
>>   Ignacio Barrancos.
>>
>>     
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image 
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>   

Re: [Sqlrelay-discussion] sqlr-listener-0.4X dies with Oracle10g x86_64

[Ignacio B. <ign...@gm...>]

Hi,

This weekend, I tried to compile sqlrelay 0.41 in a 32bits server, using:

   Oracle server:  Oracle XE 10.2.0.1
   Operative System:       RHEL4U3  i386
   GCC version:              3.4.5 20051201 (Red Hat 3.4.5-2)
   Rudiments version:      0.32
   Oracle Client:      oracle-instantclient-basic-10.2.0.3-1.i386.rpm
                             oracle-instantclient-devel-10.2.0.3-1.i386.rpm
                             oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
                             oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

And I got the same result:  0.39.4 Works fine, sqlr-listener startup
and all ok.   0.41 doesn't work ... when i execute "sqlr-start -id
oracletest"  ...  sqlr-listener dies, and sqlr-scaler can't start.


May be exists some problem with Oracle and  later versions than  sqlrelay-39.4 ?

Thanks in advance,
Ignacio.



2009/5/7, Ignacio Barrancos <ign...@gm...>:
> Hi guys,
>
>  I'm using sqlrelay-0.39.4 on my 64bits server:
>
>   Operative System:   RHEL5U2 x86_64
>   GCC version:        4.1.2 20071124 (Red Hat 4.1.2-42)
>   Rudiments version:  0.31
>   Oracle Client:      oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
>                       oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm
>                       oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm
>                       oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm
>
>
>   This version works fine on my web server (i have installed in
>  /usr/local/firstworks), but sometimes, after has many visits
>  simultaneous and CPU load is high, i must restart apache2, and
>  sqlr-connection-oracle8 proccess hangs and then i can't stop sqlrelay
>  (sqlr-stop)
>
>   I have read the ChangeLog of new versions, i want test these news
>  version:  I'm trying run sqlrelay-0.41, sqlrelay-0.40, and
>  sqlrelay-CVS_HEAD compiled with-oracle support on my server, like i
>  done for sqlrelay-0.39.4 and using the same programs and libraries.
>
>   I'm using "stow" command for the compilation, because i can test
>  diferent versions.
>
>   The Oracle Instantclient x86_64 installs the libraries at
>  /usr/lib/oracle/10.2.0.3/client64/lib/ and the includes at
>  /usr/include/oracle/10.2.0.3/client64.  I have edit to "configure"
>  file (after tar xzvf VERSION_SQLRELAY.tgz)  and  apply this patch:
>
>
>  --------8<-- Patch_on_configure ------8<---------------
>  22994c22994
>  <                               if ( test -r
>  "/usr/lib/oracle/$version/client/lib/libclntsh.$SOSUFFIX" -a -r
>  "/usr/include/oracle/$version/client/oci.h" )
>  ---
>  >                               if ( test -r "/usr/lib/oracle/$version/client64/lib/libclntsh.$SOSUFFIX" -a -r "/usr/include/oracle/$version/client64/oci.h" )
>  22997,22999c22997,22999
>  <                                       ORACLELIBSPATH="/usr/lib/oracle/$version/client/lib"
>  <                                       ORACLELIBS="-L/usr/lib/oracle/$version/client/lib -lclntsh -lnnz10"
>  <                                       ORACLEINCLUDES="-I/usr/include/oracle/$version/client"
>  ---
>  >                                       ORACLELIBSPATH="/usr/lib/oracle/$version/client64/lib"
>  >                                       ORACLELIBS="-L/usr/lib/oracle/$version/client64/lib -lclntsh -lnnz10"
>  >                                       ORACLEINCLUDES="-I/usr/include/oracle/$version/client64"
>  --------8<-- Patch_on_configure ------8<---------------
>
>
>
>   Then, for compile 0.41,  i executed:
>
>
>
>
>  --------8<---- commands for compile -------8<-------------
>
>   ./configure --prefix=/usr/local/stow/sqlrelay-0.41 --disable-python
>  --disable-mysql --disable-postgresql --disable-sqlite
>  --disable-freetds --disable-sybase --disable-odbc --disable-db2
>  --disable-firebird --disable-mdbtools --disable-perl --disable-zope
>  --disable-ruby --disable-java --disable-tcl --disable-gtk
>
>   make
>   make install
>
>  # With these lines i can install on /usr/local/bin, /usr/local/lib,
>  etc,  with stow.
>
>   cd /usr/local/stow
>   cp /usr/local/firstworks/etc/sqlrelay.conf sqlrelay-0.41/etc/
>
>   stow sqlrelay-0.41
>
>  --------8<---- commands for compile -------8<-------------
>
>
>
>   Then, execute these commands to launch SQLRelay
>
>
>  -------8<-------launch sqlrelay ----------8<--------------
>   export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client64/lib:/usr/local/lib:${LD_LIBRARY_PATH}
>   export TNS_ADMIN=/home
>   export NLS_LANG=American_America.WE8ISO8859P1
>
>   sqlr-start -id oracletest
>  -------8<-------launch sqlrelay ----------8<--------------
>
>
>
>   And i obtain this output....
>
>
>
>  -------8<-------output--------------------8<--------------
>   Starting listener:
>   sqlr-listener -id oracletest -config
>  /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>
>   Starting 5 connections to oracletest :
>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>   sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>  -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>
>   Starting scaler:
>   sqlr-scaler -id oracletest -config
>  /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>
>   sqlr-scaler error:
>         The file /usr/local/stow/sqlrelay-0.41/var/sqlrelay/tmp/pids/sqlr-listener-oracletest
>  was not found.
>         This usually means that the sqlr-listener is not running.
>         The sqlr-listener must be running for the sqlr-scaler to start.
>
>
>  sqlr-scaler failed to start.
>
>
>  Thanks to MP3.com for sponsoring:
>         Clustered/Replicated database support.
>         Perl API.
>  Thanks to FeedLounge for sponsoring:
>         Query routing and filtering.
>
>  -------8<-------output--------------------8<--------------
>
>
>
>   It seems that, when start the maximum sqlr-connection-oracle8
>  connections that i have configured in sqlrelay.conf (five in my case)
>  , the sqlr-listener proccess dies, and then sqlr-scaler startup fails,
>  because it can't found sqlr-listener-oracletest.
>
>   I have try some versions: sqlrelay-0.41, sqlrelay-0.40, and
>  sqlrelay-CVS_HEAD, and most recents Oracle Instants clients for 64bits
>  (10.2.0.4) and all versions upper than 0.39.4, i obtained de same
>  result, in the same server ...
>
>
>   - what am I doing wrong?
>   - Is a bug?
>   - what can I do to debug if it's a configuration problem?
>
>
>   thanks in advance,
>
>
>   Ignacio Barrancos.
>

[Sqlrelay-discussion] sqlr-listener-0.4X dies with Oracle10g x86_64

[Ignacio B. <ign...@gm...>]

Hi guys,

I'm using sqlrelay-0.39.4 on my 64bits server:

  Operative System:   RHEL5U2 x86_64
  GCC version:        4.1.2 20071124 (Red Hat 4.1.2-42)
  Rudiments version:  0.31
  Oracle Client:      oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
                      oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm
                      oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm
                      oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm


 This version works fine on my web server (i have installed in
/usr/local/firstworks), but sometimes, after has many visits
simultaneous and CPU load is high, i must restart apache2, and
sqlr-connection-oracle8 proccess hangs and then i can't stop sqlrelay
(sqlr-stop)

 I have read the ChangeLog of new versions, i want test these news
version:  I'm trying run sqlrelay-0.41, sqlrelay-0.40, and
sqlrelay-CVS_HEAD compiled with-oracle support on my server, like i
done for sqlrelay-0.39.4 and using the same programs and libraries.

 I'm using "stow" command for the compilation, because i can test
diferent versions.

 The Oracle Instantclient x86_64 installs the libraries at
/usr/lib/oracle/10.2.0.3/client64/lib/ and the includes at
/usr/include/oracle/10.2.0.3/client64.  I have edit to "configure"
file (after tar xzvf VERSION_SQLRELAY.tgz)  and  apply this patch:


--------8<-- Patch_on_configure ------8<---------------
22994c22994
< 				if ( test -r
"/usr/lib/oracle/$version/client/lib/libclntsh.$SOSUFFIX" -a -r
"/usr/include/oracle/$version/client/oci.h" )
---
> 				if ( test -r "/usr/lib/oracle/$version/client64/lib/libclntsh.$SOSUFFIX" -a -r "/usr/include/oracle/$version/client64/oci.h" )
22997,22999c22997,22999
< 					ORACLELIBSPATH="/usr/lib/oracle/$version/client/lib"
< 					ORACLELIBS="-L/usr/lib/oracle/$version/client/lib -lclntsh -lnnz10"
< 					ORACLEINCLUDES="-I/usr/include/oracle/$version/client"
---
> 					ORACLELIBSPATH="/usr/lib/oracle/$version/client64/lib"
> 					ORACLELIBS="-L/usr/lib/oracle/$version/client64/lib -lclntsh -lnnz10"
> 					ORACLEINCLUDES="-I/usr/include/oracle/$version/client64"
--------8<-- Patch_on_configure ------8<---------------



 Then, for compile 0.41,  i executed:




--------8<---- commands for compile -------8<-------------

 ./configure --prefix=/usr/local/stow/sqlrelay-0.41 --disable-python
--disable-mysql --disable-postgresql --disable-sqlite
--disable-freetds --disable-sybase --disable-odbc --disable-db2
--disable-firebird --disable-mdbtools --disable-perl --disable-zope
--disable-ruby --disable-java --disable-tcl --disable-gtk

 make
 make install

# With these lines i can install on /usr/local/bin, /usr/local/lib,
etc,  with stow.

 cd /usr/local/stow
 cp /usr/local/firstworks/etc/sqlrelay.conf sqlrelay-0.41/etc/

 stow sqlrelay-0.41

--------8<---- commands for compile -------8<-------------



 Then, execute these commands to launch SQLRelay


-------8<-------launch sqlrelay ----------8<--------------
 export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client64/lib:/usr/local/lib:${LD_LIBRARY_PATH}
 export TNS_ADMIN=/home
 export NLS_LANG=American_America.WE8ISO8859P1

 sqlr-start -id oracletest
-------8<-------launch sqlrelay ----------8<--------------



 And i obtain this output....



-------8<-------output--------------------8<--------------
 Starting listener:
  sqlr-listener -id oracletest -config
/usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf

 Starting 5 connections to oracletest :
  sqlr-connection-oracle8 -id oracletest -connectionid oracletest
-config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
  sqlr-connection-oracle8 -id oracletest -connectionid oracletest
-config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
  sqlr-connection-oracle8 -id oracletest -connectionid oracletest
-config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
  sqlr-connection-oracle8 -id oracletest -connectionid oracletest
-config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
  sqlr-connection-oracle8 -id oracletest -connectionid oracletest
-config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf

 Starting scaler:
  sqlr-scaler -id oracletest -config
/usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf

 sqlr-scaler error:
	The file /usr/local/stow/sqlrelay-0.41/var/sqlrelay/tmp/pids/sqlr-listener-oracletest
was not found.
	This usually means that the sqlr-listener is not running.
	The sqlr-listener must be running for the sqlr-scaler to start.


sqlr-scaler failed to start.


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

-------8<-------output--------------------8<--------------



 It seems that, when start the maximum sqlr-connection-oracle8
connections that i have configured in sqlrelay.conf (five in my case)
, the sqlr-listener proccess dies, and then sqlr-scaler startup fails,
because it can't found sqlr-listener-oracletest.

 I have try some versions: sqlrelay-0.41, sqlrelay-0.40, and
sqlrelay-CVS_HEAD, and most recents Oracle Instants clients for 64bits
(10.2.0.4) and all versions upper than 0.39.4, i obtained de same
result, in the same server ...

 	
 - what am I doing wrong?
 - Is a bug?
 - what can I do to debug if it's a configuration problem?


 thanks in advance,

 Ignacio Barrancos.

[Sqlrelay-discussion] SQLrelay reconnect

[Stéphane H. <ste...@gm...>]

Hi,
I use MySQL as the database server with SQLRelay. Everything is fine, except
when I restart the MySQL server, SQLRelay daemon seems to be blocked, is
there a way to force SQLRelay to reconnect (re-establish) the connection to
the real MySQL server ?

Thanks a lot !

Stephane

Re: [Sqlrelay-discussion] Can SQLRelay be used with C# and SQL Server?

[Unai R. <me...@u-...>]

Dear David,

Thank you so much for your clarification.

With Best Wishes,
unai

On Thu, 30 Apr 2009 10:10:04 -0400, David Muse <dav...@fi...>
wrote:
> There is no C# API for SQL Relay.  SQL Relay sort-of works on windows
> under Cygwin.  I've been working on native windows support, but it's
> incomplete and has been slow-going.  Unfortunately I don't think you'll
> be able to do what you're looking for right now.
> 
> David Muse
> dav...@fi...

Re: [Sqlrelay-discussion] sqlrelay on solaris - "std::bad_alloc" - solved

[Renat S. <sr...@st...>]

David Muse пишет:
> life, but I can't remember where.  I know that it occurs if you're out
> of memory, 

Hello!

By default memory on Sun Solaris for one user is limited to 1/4 of 
phisycal memory 
(http://docs.sun.com/app/docs/doc/817-0404/chapter1-33?a=view 
project.max-shm-memory).
Sqlrelay allocates a lot of memory in cursor constructor. For example if 
you set cursors=10 then it'll allocate 10*10*256*32k = 800M. For N-th 
connection you get "std::bad_alloc".

You have 2 ways to solve a problem - decrease the amount of allocated 
memory (see 
http://sqlrelay.sourceforge.net/sqlrelay/tuning.html#memoryusage ) or 
tune some OS parameter. I'm not a solaris guru so just for example this 
is tuning for oracle:

prctl -n project.max-shm-memory -v 4gb -r -i project oracle
projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...

Re: [Sqlrelay-discussion] Can SQLRelay be used with C# and SQL Server?

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

There is no C# API for SQL Relay.  SQL Relay sort-of works on windows
under Cygwin.  I've been working on native windows support, but it's
incomplete and has been slow-going.  Unfortunately I don't think you'll
be able to do what you're looking for right now.

David Muse
dav...@fi...

On Thu, 2009-04-30 at 02:36 -0600, Unai Rodriguez wrote:
> Dear All,
> 
> We are currently developing an application using C# and SQL Server. The
> developers are using Microsoft Visual Studio 2005 as IDE.
> 
> I have been trying to find out whether it would be possible to use SQLRelay
> within our system. It seems it is not, but I would like to make sure.
> 
> >From my understanding, SQLRelay supports a number of programming languages
> and database abstraction layers, but I do not think C# is included.
> 
> I thought of using the C++ API on our C# code as a possible approach, but I
> am a bit concerned about stability and performance with this approach.
> 
> Does anyone have figured out a way of doing this?
> 
> Thank you so much,
> unai
> 
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations 
> Conference from O'Reilly Media. Velocity features a full day of 
> expert-led, hands-on workshops and two days of sessions from industry 
> leaders in dedicated Performance & Operations tracks. Use code vel09scf 
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> 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