sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] RE: [sqlrelay] sqlrelay-0.36pre4

[Samuel Luxford-W. <sl...@wi...>]

Ok - found the problem with it not being able to start the connections
whilst running sqlr-start:

 

sqlr-start is looking for sqlr-connection-freeTDS yet 'make install'
installs it as sqlr-connection-freetds.

 

Sam

 

  _____  

From: Samuel Luxford-Watts [mailto:sl...@wi...] 
Sent: 15 March 2005 17:09
To: sql...@ya...; sql...@li...
Subject: RE: [sqlrelay] sqlrelay-0.36pre4

 

Hi,

 

I have downloaded and installed this version onto a new install of SuSE 9.2
and come across the following probe:

 

1.	For some reason when I run sql-start -id ID the listener starts then
it bonbs out saying sqlr-connection-freeTDS: command not found - I have
setup /etc/login.defs and /etc/profile.local with the correct paths I am
sure this is my fault - but I cant find what I should change at the moment
so...
2.	If I start everything manually I still get the same problem as
before when using ZOPE - it connects n times and n+1 query freezes zope
until I run sqlr-stop. n=connections

 

Cheers,


Sam

 

  _____  

From: David Muse [mailto:dav...@fi...] 
Sent: 10 March 2005 02:42
To: sql...@li...; sql...@ya...
Subject: [sqlrelay] sqlrelay-0.36pre4

 

Hello,

I just uploaded a new pre-release of SQL Relay to
http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz
<http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz> 

I shelled out some cash for a copy of Mac OS X 10.3 and though it won't
install on any of the 4 macs I have at my house, it will run (though
very slowly) under PearPC.  As a result, SQL Relay compiles much more
cleanly under OS X.  There are still a few wrinkles to iron out, but it
generally works.

Several people have recently pointed out some performance problems,
especially with insert/update/delete's or selects that return small
result sets.  I made some improvements that should help significantly in
that area and I have more planned for the 0.36 release.

sqlrsh can run scripts now.

There are a few more bug fixes that I don't remember offhand too.

Give it a try, let me know what you run into.

David Muse
dav...@fi...

Ps.  If you haven't switched, join the new mailing list at sourceforge. 
See http://sqlrelay.sourceforge.net/mailinglist.html
<http://sqlrelay.sourceforge.net/mailinglist.html> 








Yahoo! Groups Sponsor



ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=12996q1sv/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705007183:HM/EXP=1110992930/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
etflix.com/Default?mqso=60190075> click here


Web Bug from
http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:
HM/A=2593423/rand=622064836

 

  _____  

Yahoo! Groups Links

*	To visit your group on the web, go to:
http://groups.yahoo.com/group/sqlrelay/
<http://groups.yahoo.com/group/sqlrelay/> 
  
*	To unsubscribe from this group, send an email to:
sql...@ya...
<mailto:sql...@ya...?subject=Unsubscribe> 
  
*	Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/>  Terms of Service. 

Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR Telephone
020 7593 5000 Fax 020 7593 5099 

Confidentiality 
This email message and any attachments are confidential; they may be subject
to legal professional privilege and are intended for the named recipient
only. If you are not the named recipient, please return the message and
enclosures immediately and delete them from your system.

Caution 
Before advice received only by email (whether by attachment or otherwise)
may be relied on, the authenticity of the communication must be verified by
means independent of email. 


Regulation 
The firm is regulated by the Law Society. 

Partners 
A list of partners is available for inspection at each office of the firm
and on the firm's website at www.winckworths.co.uk
<http://www.winckworths.co.uk> 


--------------
Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
Telephone 020 7593 5000 Fax 020 7593 5099

-Confidentiality- 
This email message and any attachments are confidential; they may be subject to legal professional privilege and are intended for the named recipient only. If you are not the named recipient, please return the message and enclosures immediately and delete them from your system.

-Caution- 
Before advice received only by email (whether by attachment or otherwise) may be relied on, the authenticity of the communication must be verified by means independent of email.

-Regulation- 
The firm is regulated by the Law Society. 

-Partners- 
A list of partners is available for inspection at each office of the firm and on the firm's website at http://www.winckworths.co.uk
 

[Sqlrelay-discussion] RE: [sqlrelay] sqlrelay-0.36pre4

[Samuel Luxford-W. <sl...@wi...>]

Hi,

 

I have downloaded and installed this version onto a new install of SuSE 9.2
and come across the following probe:

 

1.	For some reason when I run sql-start -id ID the listener starts then
it bonbs out saying sqlr-connection-freeTDS: command not found - I have
setup /etc/login.defs and /etc/profile.local with the correct paths I am
sure this is my fault - but I cant find what I should change at the moment
so...
2.	If I start everything manually I still get the same problem as
before when using ZOPE - it connects n times and n+1 query freezes zope
until I run sqlr-stop. n=connections

 

Cheers,


Sam

 

  _____  

From: David Muse [mailto:dav...@fi...] 
Sent: 10 March 2005 02:42
To: sql...@li...; sql...@ya...
Subject: [sqlrelay] sqlrelay-0.36pre4

 

Hello,

I just uploaded a new pre-release of SQL Relay to
http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz
<http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz> 

I shelled out some cash for a copy of Mac OS X 10.3 and though it won't
install on any of the 4 macs I have at my house, it will run (though
very slowly) under PearPC.  As a result, SQL Relay compiles much more
cleanly under OS X.  There are still a few wrinkles to iron out, but it
generally works.

Several people have recently pointed out some performance problems,
especially with insert/update/delete's or selects that return small
result sets.  I made some improvements that should help significantly in
that area and I have more planned for the 0.36 release.

sqlrsh can run scripts now.

There are a few more bug fixes that I don't remember offhand too.

Give it a try, let me know what you run into.

David Muse
dav...@fi...

Ps.  If you haven't switched, join the new mailing list at sourceforge. 
See http://sqlrelay.sourceforge.net/mailinglist.html
<http://sqlrelay.sourceforge.net/mailinglist.html> 





Yahoo! Groups Sponsor



ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=129bh6o5t/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705007183:HM/EXP=1110508988/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
etflix.com/Default?mqso=60190075> click here


Web Bug from
http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:
HM/A=2593423/rand=739034354

 

  _____  

Yahoo! Groups Links

*	To visit your group on the web, go to:
http://groups.yahoo.com/group/sqlrelay/
<http://groups.yahoo.com/group/sqlrelay/> 
  
*	To unsubscribe from this group, send an email to:
sql...@ya...
<mailto:sql...@ya...?subject=Unsubscribe> 
  
*	Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/>  Terms of Service. 


--------------
Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
Telephone 020 7593 5000 Fax 020 7593 5099

-Confidentiality- 
This email message and any attachments are confidential; they may be subject to legal professional privilege and are intended for the named recipient only. If you are not the named recipient, please return the message and enclosures immediately and delete them from your system.

-Caution- 
Before advice received only by email (whether by attachment or otherwise) may be relied on, the authenticity of the communication must be verified by means independent of email.

-Regulation- 
The firm is regulated by the Law Society. 

-Partners- 
A list of partners is available for inspection at each office of the firm and on the firm's website at http://www.winckworths.co.uk
 

[Sqlrelay-discussion] Problems installing Rudiments 0.27 in Solaris 8.0

[Bernard Wu <eya...@ya...>]

Hi list members,
Just trying to install rudiments-0.27 in Solaris 8.0.
The configure runs fine.
But when I try to run "make" I get the following
errors :

panda:/tmp/rudiments-0.27 # make
cd src; make all
make: Fatal error in reader: ../features.mk, line 8:
Unexpected end of line seen
Current working directory /tmp/rudiments-0.27/src
*** Error code 1
make: Fatal error: Command failed for target `all'
panda:/tmp/rudiments-0.27 #

I am using gcc 3.3.2.

Any help is much appreciated.
TIA
Benrie Wu


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

[Sqlrelay-discussion] sqlrelay-0.36pre4

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

Hello,

I just uploaded a new pre-release of SQL Relay to
http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz

I shelled out some cash for a copy of Mac OS X 10.3 and though it won't
install on any of the 4 macs I have at my house, it will run (though
very slowly) under PearPC.  As a result, SQL Relay compiles much more
cleanly under OS X.  There are still a few wrinkles to iron out, but it
generally works.

Several people have recently pointed out some performance problems,
especially with insert/update/delete's or selects that return small
result sets.  I made some improvements that should help significantly in
that area and I have more planned for the 0.36 release.

sqlrsh can run scripts now.

There are a few more bug fixes that I don't remember offhand too.

Give it a try, let me know what you run into.

David Muse
dav...@fi...

Ps.  If you haven't switched, join the new mailing list at sourceforge. 
See http://sqlrelay.sourceforge.net/mailinglist.html

Re: [Sqlrelay-discussion] MySQL Load Testing

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

On Wed, 2 Mar 2005 10:16:12 -0000
Marvin Wright <MW...@la...> wrote:

> Hi David,
> 
> Thanks for the reply, I think you are right.
> I did some tests using only 50 clients and its consistenly very fast.
> 
> I think I will have to re-configure some of my pools so I can increase
> the connections in a particular pool as its quite possible that I may
> have 300 concurrent client connections.  Is there any limit in
> sqlrelay on pool size?  I guess the limit will be at the database
> size.

The limit of the pool size would depend on the number of concurrent
connections that the database can support and the amount of ram on the
server running SQL Relay.

> 
> Just to be sure, doing a con->endSession() gives back the session.
> I want to make sure I'm returning sessions to the pool as fast as I
> can.

That's correct.

> 
> Regards,
> 
> Marvin. 
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> David Muse
> Sent: 25 February 2005 15:39
> To: sql...@li...
> Subject: Re: [Sqlrelay-discussion] MySQL Load Testing
> 
> It really sounds like the bottleneck is a case of clients waiting on
> available connections.
> 
> The client doesn't actually log into the SQL Relay server until the
> first query is run, so even if it's bottlenecked waiting on an
> available connection, the client will stall out during the call to
> sendQuery.
> 
> When it's running slowly, take a look on the server and see if there
> aren't a bunch of sqlr-listener processes.  If there are, then most of
> them are holding on to client connections, waiting for an available
> database connection.
> 
> You could try load testing 50 clients and see how that runs.  I'd
> expect it to be fast.  Then, as you add more clients, it should slow
> down.  If it follows this pattern, then the slowdown must be due to
> clients waiting for available connections.  If it still runs slowly
> with 50 or fewer clients, then something else is going on.
> 
> Dave
> 
> On Mon, 14 Feb 2005 09:52:21 -0000
> Marvin Wright <MW...@la...> wrote:
> 
> > Hi David,
> > 
> > I'm having some issues while doing some load tests with sql relay.
> > 
> > I have a pool of 25 connections that may grow to 50 and I have 
> > assigned 50 cursors to the pool.
> > 
> > I've built a server application that uses this pool to connect to a 
> > local cache of data.
> > 
> > If I execute 1 request to my server app it returns a sub second 
> > response.
> > 
> > Now when load testing all the way to 300 concurrent requests the app
> > starts returning response of upto 10 seconds.
> > I've done some program tracing and filled the app with plenty of
> > logs, I seem to get a bottle neck on the actual sendQuery.
> > Some of these queries are taking 9 seconds to execute.  I'm also 
> > monitoring the database, the queries that are run are all under a 
> > second. The slow down seems to be somewhere in the sendQuery but 
> > that's all I can tell.
> > 
> > I thought at first that with only 50 max connections to the pool
> > that the threads might be waiting for a connection but it does seem
> > to be the case.
> >
> > If I switch access to this local cache off load-testing all the way
> > to 500 connections my app will return all connections under 2
> > seconds.
> > 
> > I'm running the new pre-release version 3 of sql relay.
> > 
> > Any ideas what may be the problem or what I can try ?
> > 
> > Many thanks.
> > 
> > 
> > Marvin Wright
> > Flights Developer
> > Lastminute.com
> > mw...@la...
> > +44 (0) 207 802 4543
> > 
> > 
> > 
> > *******************************************************************
> > *** This email and any files transmitted with it are confidential
> > and intended solely for the use of the individual or entity to whom
> > they are addressed. If you have received this email in error please
> > notify the system manager.
> > 
> > This footnote also confirms that this email message has been swept
> > by MIMEsweeper for the presence of computer viruses.
> > 
> > www.mimesweeper.com
> > *******************************************************************
> > ***
> > 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide Read honest & candid
> reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

RE: [Sqlrelay-discussion] MySQL Load Testing

[Marvin W. <MW...@la...>]

Hi David,

Thanks for the reply, I think you are right.
I did some tests using only 50 clients and its consistenly very fast.

I think I will have to re-configure some of my pools so I can increase the
connections in a particular pool as its quite possible that I may have 300
concurrent client connections.  Is there any limit in sqlrelay on pool size
?  I guess the limit will be at the database size.

Just to be sure, doing a con->endSession() gives back the session.
I want to make sure I'm returning sessions to the pool as fast as I can.

Regards,

Marvin. 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of David
Muse
Sent: 25 February 2005 15:39
To: sql...@li...
Subject: Re: [Sqlrelay-discussion] MySQL Load Testing

It really sounds like the bottleneck is a case of clients waiting on
available connections.

The client doesn't actually log into the SQL Relay server until the first
query is run, so even if it's bottlenecked waiting on an available
connection, the client will stall out during the call to sendQuery.

When it's running slowly, take a look on the server and see if there aren't
a bunch of sqlr-listener processes.  If there are, then most of them are
holding on to client connections, waiting for an available database
connection.

You could try load testing 50 clients and see how that runs.  I'd expect it
to be fast.  Then, as you add more clients, it should slow down.  If it
follows this pattern, then the slowdown must be due to clients waiting for
available connections.  If it still runs slowly with 50 or fewer clients,
then something else is going on.

Dave

On Mon, 14 Feb 2005 09:52:21 -0000
Marvin Wright <MW...@la...> wrote:

> Hi David,
> 
> I'm having some issues while doing some load tests with sql relay.
> 
> I have a pool of 25 connections that may grow to 50 and I have 
> assigned 50 cursors to the pool.
> 
> I've built a server application that uses this pool to connect to a 
> local cache of data.
> 
> If I execute 1 request to my server app it returns a sub second 
> response.
> 
> Now when load testing all the way to 300 concurrent requests the app 
> starts returning response of upto 10 seconds.
> I've done some program tracing and filled the app with plenty of logs, 
> I seem to get a bottle neck on the actual sendQuery.
> Some of these queries are taking 9 seconds to execute.  I'm also 
> monitoring the database, the queries that are run are all under a 
> second. The slow down seems to be somewhere in the sendQuery but 
> that's all I can tell.
> 
> I thought at first that with only 50 max connections to the pool that 
> the threads might be waiting for a connection but it does seem to be 
> the case.
>
> If I switch access to this local cache off load-testing all the way to 
> 500 connections my app will return all connections under 2 seconds.
> 
> I'm running the new pre-release version 3 of sql relay.
> 
> Any ideas what may be the problem or what I can try ?
> 
> Many thanks.
> 
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you have received this email in error please notify 
> the system manager.
> 
> This footnote also confirms that this email message has been swept by 
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] Couldn't find id postgresqltest.

[<gra...@ax...>]

Hi all,

I installed sqlrelay on Sarge and I added a postgre instance to my
sqlrelay.conf:

<instance id="postgresqltest"
           port="9000"
           socket="/tmp/postgresqltest.socket"
           dbase="postgresql"
           connections="3"
           maxconnections="5"
           maxqueuelength="0"
           growby="1"
           ttl="60"
           endofsession="commit"
           sessiontimeout="600"
           runasuser="nobody"
           runasgroup="nobody"
           cursors="5"
           authtier="listener"
           handoff="pass">
	<users>
		<user user="postgresqltest" password="postgresqltest"/>
	</users>
	<connections>
		<connection connectionid="postgresqltest"
		            string="host=localhost;db=testdb;user=testuser;password=testpassword"
		            metric="1"/>
	</connections>
</instance>

Issuing the command

		sqlr-start -id postgresqltest

it returns

		Couldn't find id postgresqltest.

Why? What is wrong there?
-- 
László Graf

Re: [Sqlrelay-discussion] how to ask sqlrelay if the database is not available

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

Some database API's provide functions that return the state of the tcp
connection to the database and some don't.  For databases that do, the
server side uses that function when the client runs a ping().  For
databases that don't provide such a function, the server runs "select 1"
or a similar query and examines the error code if it fails.

If the client runs a query (even "select 1") and the database is down,
then SQL Relay will try to log back in to the database over and over.
When the database comes back, it will rerun the query.

However, if a client runs ping() and the database doesn't provide a
native method for testing state of the connection, the SQL Relay
connection daemon runs "select 1" against the database, but bypasses
the code that causes the server to try to log back in over and
over.  If the query fails with an error indicating that the database has
gone down, it returns that immediately.

I just tested it against postgresql with my development version of SQL
Relay and it worked as I expected.  In 0.35, if ping() doesn't return
immediately, then there may be a bug in 0.35 that has since been fixed.

Dave

On Fri, 25 Feb 2005 11:22:34 -0800
"Yulius Tjahjadi" <yu...@xf...> wrote:

> Hi David,
>=20
> >From looking at the code, it looks like ping() basically sets up
> >"select
> 1"=20
> as the sql query string and executes it.  When I call ping w/o a
> database
> connection, it stalls just like if I were to run a regular query.
>=20
> I'm using postgres 7.4 and 8.0 with unix sockets and running fedora
> core 2.
> Doesn't the sqlrelay server have the state of the tcp connection to
> the database?  Is there a way to get at that?
>=20
> Thanks.
>=20
> yulius
>=20
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> David Muse
> Sent: Friday, February 25, 2005 8:31 AM
> To: sql...@li...
> Subject: Re: [Sqlrelay-discussion] how to ask sqlrelay if the database
> is not available
>=20
>=20
> For the first one, you could do a ping() before running the query.  If
> the ping() returns false then the database is down and you could
> display the other page.
>=20
> For the second one, I'll have to look into that.  Thanks for finding
> it. Hopefully I'll get it sorted out for the next release.
>=20
> Dave
> dav...@fi...
>=20
> On Thu, 24 Feb 2005 15:43:59 -0800
> "Yulius Tjahjadi" <yu...@xf...> wrote:
>=20
> > Hi,
> >=20
> > I have a couple of issues I'm trying to figure out.
> >=20
> > 1. We would like to handle a graceful database downtime by having
> > php know
> >    that our postgres database is down and display another page.=20
> >    Right
>=20
> > now,
> >    0.36-pre2 stalls on sqlrcur_sendQuery if the database is
> >    shutdown.=20
> > Is
> >    there a way to not stall and figure out if sqlrelay is connected
> >    from
> > php?
> >=20
> > 2. On 0.36-pre2 if postgres runs out of connection, sqlrelay will=20
> > crash.
> >    To reproduce this, run postgres w/ 10 max connections, run
> >    sqlrelay
>=20
> > with
> >    a pool of greater than 10.  On startup, it will crash.  This is
> >    not a big deal for me since we have a set pool size, but it might
> >    be an
>=20
> > issue
> >    for other people.
> >=20
> > yulius
> >=20
> >=20
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real=20
> > users. Discover which products truly live up to the hype. Start=20
> > reading now. http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> > _______________________________________________
> > Sqlrelay-discussion mailing list=20
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >=20
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20

RE: [Sqlrelay-discussion] how to ask sqlrelay if the database is not available

[Yulius T. <yu...@xf...>]

Hi David,

From looking at the code, it looks like ping() basically sets up "select
1"=20
as the sql query string and executes it.  When I call ping w/o a
database
connection, it stalls just like if I were to run a regular query.

I'm using postgres 7.4 and 8.0 with unix sockets and running fedora core
2.
Doesn't the sqlrelay server have the state of the tcp connection to the=20
database?  Is there a way to get at that?

Thanks.

yulius

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
David Muse
Sent: Friday, February 25, 2005 8:31 AM
To: sql...@li...
Subject: Re: [Sqlrelay-discussion] how to ask sqlrelay if the database
is not available


For the first one, you could do a ping() before running the query.  If
the ping() returns false then the database is down and you could display
the other page.

For the second one, I'll have to look into that.  Thanks for finding it.
Hopefully I'll get it sorted out for the next release.

Dave
dav...@fi...

On Thu, 24 Feb 2005 15:43:59 -0800
"Yulius Tjahjadi" <yu...@xf...> wrote:

> Hi,
>=20
> I have a couple of issues I'm trying to figure out.
>=20
> 1. We would like to handle a graceful database downtime by having php=20
> know
>    that our postgres database is down and display another page.  Right

> now,
>    0.36-pre2 stalls on sqlrcur_sendQuery if the database is shutdown.=20
> Is
>    there a way to not stall and figure out if sqlrelay is connected
>    from
> php?
>=20
> 2. On 0.36-pre2 if postgres runs out of connection, sqlrelay will=20
> crash.
>    To reproduce this, run postgres w/ 10 max connections, run sqlrelay

> with
>    a pool of greater than 10.  On startup, it will crash.  This is not
>    a big deal for me since we have a set pool size, but it might be an

> issue
>    for other people.
>=20
> yulius
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real=20
> users. Discover which products truly live up to the hype. Start=20
> reading now. http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list=20
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dick
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] how to ask sqlrelay if the database is not available

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

For the first one, you could do a ping() before running the query.  If
the ping() returns false then the database is down and you could display
the other page.

For the second one, I'll have to look into that.  Thanks for finding it.
 Hopefully I'll get it sorted out for the next release.

Dave
dav...@fi...

On Thu, 24 Feb 2005 15:43:59 -0800
"Yulius Tjahjadi" <yu...@xf...> wrote:

> Hi,
>=20
> I have a couple of issues I'm trying to figure out.
>=20
> 1. We would like to handle a graceful database downtime by having php
> know
>    that our postgres database is down and display another page.  Right
> now,
>    0.36-pre2 stalls on sqlrcur_sendQuery if the database is shutdown.
> Is
>    there a way to not stall and figure out if sqlrelay is connected
>    from
> php?
>=20
> 2. On 0.36-pre2 if postgres runs out of connection, sqlrelay will
> crash.
>    To reproduce this, run postgres w/ 10 max connections, run sqlrelay
> with
>    a pool of greater than 10.  On startup, it will crash.  This is not
>    a big deal for me since we have a set pool size, but it might be an
> issue
>    for other people.
>=20
> yulius
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20

Re: [Sqlrelay-discussion] Bug on php pear module - and testing

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

On Wed, 23 Feb 2005 18:28:58 +0100
"vieonet forums" <df...@vi...> wrote:

> I have to change on line in php pear module, as it send error when
> $this->affectedRows == 0 if fact it's the following
> $this->affectedRows != 0
> 

What line is this on?  I can't seem to find a case where the module
returns an error when affectedrows == 0.


> Second I made test with http_load with a simple script using direct
> sqlrelay php function (no pear), The script is just injecting records
> in Mysql Heap memory table. I use the same insert for sqlrelay and for
> sqlb The result are the folowing : 
> http_load set on 1000 simultaneous users, during 30 seconds :
> 
>     sqlrelay has been able to insert as best parameter I could 921
>     lines sqlb has been able to insert 9020 lines
> 
> It's normal ?
> 
> Why so much differents ?
> 
> The second thinks is that on sqlb all the line are inserted when the
> test is end. Which is not the case on sqlrelay, the insert carry on
> after the test is over.
> 
> I do the testing on the same machine, with the same memory usage.

Some people have reported this problem recently and I made some
modifications to improve performance.  I'm going to make another
pre-release soon that will contain these modifications.

> 
> Thanks for any more information
> 
> david

Re: [Sqlrelay-discussion] MySQL Load Testing

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

It really sounds like the bottleneck is a case of clients waiting on
available connections.

The client doesn't actually log into the SQL Relay server until the
first query is run, so even if it's bottlenecked waiting on an available
connection, the client will stall out during the call to sendQuery.

When it's running slowly, take a look on the server and see if there
aren't a bunch of sqlr-listener processes.  If there are, then most of
them are holding on to client connections, waiting for an available
database connection.

You could try load testing 50 clients and see how that runs.  I'd expect
it to be fast.  Then, as you add more clients, it should slow down.  If
it follows this pattern, then the slowdown must be due to clients
waiting for available connections.  If it still runs slowly with 50 or
fewer clients, then something else is going on.

Dave

On Mon, 14 Feb 2005 09:52:21 -0000
Marvin Wright <MW...@la...> wrote:

> Hi David,
> 
> I'm having some issues while doing some load tests with sql relay.
> 
> I have a pool of 25 connections that may grow to 50 and I have
> assigned 50 cursors to the pool.
> 
> I've built a server application that uses this pool to connect to a
> local cache of data.
> 
> If I execute 1 request to my server app it returns a sub second
> response.
> 
> Now when load testing all the way to 300 concurrent requests the app
> starts returning response of upto 10 seconds.
> I've done some program tracing and filled the app with plenty of logs,
> I seem to get a bottle neck on the actual sendQuery.
> Some of these queries are taking 9 seconds to execute.  I'm also
> monitoring the database, the queries that are run are all under a
> second. The slow down seems to be somewhere in the sendQuery but
> that's all I can tell.
> 
> I thought at first that with only 50 max connections to the pool that
> the threads might be waiting for a connection but it does seem to be
> the case.
>
> If I switch access to this local cache off load-testing all the way to
> 500 connections my app will return all connections under 2 seconds.
> 
> I'm running the new pre-release version 3 of sql relay.
> 
> Any ideas what may be the problem or what I can try ?
> 
> Many thanks.
> 
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> 
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 

[Sqlrelay-discussion] how to ask sqlrelay if the database is not available

[Yulius T. <yu...@xf...>]

Hi,

I have a couple of issues I'm trying to figure out.

1. We would like to handle a graceful database downtime by having php
know
   that our postgres database is down and display another page.  Right
now,
   0.36-pre2 stalls on sqlrcur_sendQuery if the database is shutdown.
Is
   there a way to not stall and figure out if sqlrelay is connected from
php?

2. On 0.36-pre2 if postgres runs out of connection, sqlrelay will crash.
   To reproduce this, run postgres w/ 10 max connections, run sqlrelay
with
   a pool of greater than 10.  On startup, it will crash.  This is not a
   big deal for me since we have a set pool size, but it might be an
issue
   for other people.

yulius

[Sqlrelay-discussion] Bug on php pear module - and testing

[vieonet f. <df...@vi...>]

I have to change on line in php pear module, as it send error when =
$this->affectedRows =3D=3D 0
if fact it's the following $this->affectedRows !=3D 0

Second I made test with http_load with a simple script using direct =
sqlrelay php function (no pear),=20
The script is just injecting records in Mysql Heap memory table.
I use the same insert for sqlrelay and for sqlb
The result are the folowing :=20
http_load set on 1000 simultaneous users, during 30 seconds :

    sqlrelay has been able to insert as best parameter I could 921 lines
    sqlb has been able to insert 9020 lines

It's normal ?

Why so much differents ?

The second thinks is that on sqlb all the line are inserted when the =
test is end. Which is not the case on sqlrelay, the insert carry on =
after the test is over.

I do the testing on the same machine, with the same memory usage.

Thanks for any more information

david

[Sqlrelay-discussion] MySQL Load Testing

[Marvin W. <MW...@la...>]

Hi David,

I'm having some issues while doing some load tests with sql relay.

I have a pool of 25 connections that may grow to 50 and I have assigned 50
cursors to the pool.

I've built a server application that uses this pool to connect to a local
cache of data.

If I execute 1 request to my server app it returns a sub second response.

Now when load testing all the way to 300 concurrent requests the app starts
returning response of upto 10 seconds.
I've done some program tracing and filled the app with plenty of logs, I
seem to get a bottle neck on the actual sendQuery.
Some of these queries are taking 9 seconds to execute.  I'm also monitoring
the database, the queries that are run are all under a second.
The slow down seems to be somewhere in the sendQuery but that's all I can
tell.

I thought at first that with only 50 max connections to the pool that the
threads might be waiting for a connection but it does seem to be the case.

If I switch access to this local cache off load-testing all the way to 500
connections my app will return all connections under 2 seconds.

I'm running the new pre-release version 3 of sql relay.

Any ideas what may be the problem or what I can try ?

Many thanks.


Marvin Wright
Flights Developer
Lastminute.com
mw...@la...
+44 (0) 207 802 4543



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

[Sqlrelay-discussion] sqlrelay-0.36pre3

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

Hello all,

There's a new prerelease of sqlrelay available at:
http://www.firstworks.com/sqlrelay-0.36pre3.tar.gz

There are 2 notable improvements in this pre-release:

* The PHP api cleans up after itself when the script exits, even if the
user clicked stop in the browser.  It's not necessary to register
a shutdown handler to free the cursor or connection anymore.

* Fixed some really obscure bugs that might cause everything to get
hung up if connections>maxconnections and handoff=pass

Give it a try, let me know if you run into any trouble.

Dave
dav...@fi...

RE: [Sqlrelay-discussion] MySQL on Fedora 3

[Marvin W. <MW...@la...>]

Hi David,

I`ve fixed my problem now.

Firstly I was using  --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9
instead of --with-mysql-prefix=/opt/installs/sources/mysql-4.1.9

Then after filling the configure file with loads of debug it could not find
the libmysqlclient.so file.

It was looking in $paths/lib/opt so I changed this line to
$paths/libmysql/.libs

The full lines are

Old
                eval "LIBPATH=\"$paths/lib/opt\";
LIBSTRING=\"$paths/lib/opt/lib$LIBNAME.$SOSUFFIX\""
New
                eval "LIBPATH=\"$paths/libmysql/.libs\";
LIBSTRING=\"$paths/libmysql/.libs/lib$LIBNAME.$SOSUFFIX\""

I`m sure you`ll have a better way of doing it but this works for me for now.

Regards,

Marvin.


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Marvin
Wright
Sent: 09 February 2005 17:30
To: sql...@li...; sql...@ya...
Subject: RE: [Sqlrelay-discussion] MySQL on Fedora 3

I got it, I remove the - before pre2 :)

Thanks

Marvin 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of David
Muse
Sent: 09 February 2005 15:55
To: sql...@li...; sql...@ya...
Subject: Re: [Sqlrelay-discussion] MySQL on Fedora 3

There's a prerelease of version 0.36 available at
http://www.firstworks.com/sqlrelay-0.36-pre2.tar.gz
that should fix this problem (among others).  The tarball includes a
prerelease of the next version of rudiments as well.

Give it a try and see how it goes.

Dave
dav...@fi...

On Tue, 8 Feb 2005 23:19:48 -0000
Marvin Wright <MW...@la...> wrote:

> 
> Hi,
> 
> I've sent this message to the yahoo groups board too as still both are 
> being used.
> Sorry for any repetition.
> 
> 
> I can not configure sqlrelay 0.35 at all on fedora 3.
> 
> I have untared the mysql source into
> 
> /opt/installs/sources/mysql-4.1.9
> 
> I then try to configure as below
> 
> ./configure --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9
> 
> but always I get
> 
> configure: WARNING: MySQL support will not be built.
> 
> Any ideas ? Whats it looking for ?
> 
> Regards,
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you have received this email in error please notify 
> the system manager.
> 
> This footnote also confirms that this email message has been swept by 
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

RE: [Sqlrelay-discussion] MySQL on Fedora 3

[Marvin W. <MW...@la...>]

Hi David,

I untar'd the new version.

Rudiments installs without any problems.

I still get the same problem with ./configure
--with-mysql-prefix=/opt/installs/sources/mysql-4.1.9

It can not find whatever its looking for in there ?

Marvin. 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Marvin
Wright
Sent: 09 February 2005 17:30
To: sql...@li...; sql...@ya...
Subject: RE: [Sqlrelay-discussion] MySQL on Fedora 3

I got it, I remove the - before pre2 :)

Thanks

Marvin 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of David
Muse
Sent: 09 February 2005 15:55
To: sql...@li...; sql...@ya...
Subject: Re: [Sqlrelay-discussion] MySQL on Fedora 3

There's a prerelease of version 0.36 available at
http://www.firstworks.com/sqlrelay-0.36-pre2.tar.gz
that should fix this problem (among others).  The tarball includes a
prerelease of the next version of rudiments as well.

Give it a try and see how it goes.

Dave
dav...@fi...

On Tue, 8 Feb 2005 23:19:48 -0000
Marvin Wright <MW...@la...> wrote:

> 
> Hi,
> 
> I've sent this message to the yahoo groups board too as still both are 
> being used.
> Sorry for any repetition.
> 
> 
> I can not configure sqlrelay 0.35 at all on fedora 3.
> 
> I have untared the mysql source into
> 
> /opt/installs/sources/mysql-4.1.9
> 
> I then try to configure as below
> 
> ./configure --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9
> 
> but always I get
> 
> configure: WARNING: MySQL support will not be built.
> 
> Any ideas ? Whats it looking for ?
> 
> Regards,
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you have received this email in error please notify 
> the system manager.
> 
> This footnote also confirms that this email message has been swept by 
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

RE: [Sqlrelay-discussion] MySQL on Fedora 3

[Marvin W. <MW...@la...>]

I got it, I remove the - before pre2 :)

Thanks

Marvin 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of David
Muse
Sent: 09 February 2005 15:55
To: sql...@li...; sql...@ya...
Subject: Re: [Sqlrelay-discussion] MySQL on Fedora 3

There's a prerelease of version 0.36 available at
http://www.firstworks.com/sqlrelay-0.36-pre2.tar.gz
that should fix this problem (among others).  The tarball includes a
prerelease of the next version of rudiments as well.

Give it a try and see how it goes.

Dave
dav...@fi...

On Tue, 8 Feb 2005 23:19:48 -0000
Marvin Wright <MW...@la...> wrote:

> 
> Hi,
> 
> I've sent this message to the yahoo groups board too as still both are 
> being used.
> Sorry for any repetition.
> 
> 
> I can not configure sqlrelay 0.35 at all on fedora 3.
> 
> I have untared the mysql source into
> 
> /opt/installs/sources/mysql-4.1.9
> 
> I then try to configure as below
> 
> ./configure --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9
> 
> but always I get
> 
> configure: WARNING: MySQL support will not be built.
> 
> Any ideas ? Whats it looking for ?
> 
> Regards,
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you have received this email in error please notify 
> the system manager.
> 
> This footnote also confirms that this email message has been swept by 
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

RE: [Sqlrelay-discussion] MySQL on Fedora 3

[Marvin W. <MW...@la...>]

That URL does seem to work for me.

Marvin 


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of David
Muse
Sent: 09 February 2005 15:55
To: sql...@li...; sql...@ya...
Subject: Re: [Sqlrelay-discussion] MySQL on Fedora 3

There's a prerelease of version 0.36 available at
http://www.firstworks.com/sqlrelay-0.36-pre2.tar.gz
that should fix this problem (among others).  The tarball includes a
prerelease of the next version of rudiments as well.

Give it a try and see how it goes.

Dave
dav...@fi...

On Tue, 8 Feb 2005 23:19:48 -0000
Marvin Wright <MW...@la...> wrote:

> 
> Hi,
> 
> I've sent this message to the yahoo groups board too as still both are 
> being used.
> Sorry for any repetition.
> 
> 
> I can not configure sqlrelay 0.35 at all on fedora 3.
> 
> I have untared the mysql source into
> 
> /opt/installs/sources/mysql-4.1.9
> 
> I then try to configure as below
> 
> ./configure --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9
> 
> but always I get
> 
> configure: WARNING: MySQL support will not be built.
> 
> Any ideas ? Whats it looking for ?
> 
> Regards,
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you have received this email in error please notify 
> the system manager.
> 
> This footnote also confirms that this email message has been swept by 
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews
on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] MySQL on Fedora 3

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

There's a prerelease of version 0.36 available at
http://www.firstworks.com/sqlrelay-0.36-pre2.tar.gz
that should fix this problem (among others).  The tarball includes a
prerelease of the next version of rudiments as well.

Give it a try and see how it goes.

Dave
dav...@fi...

On Tue, 8 Feb 2005 23:19:48 -0000
Marvin Wright <MW...@la...> wrote:

> 
> Hi,
> 
> I've sent this message to the yahoo groups board too as still both are
> being used.
> Sorry for any repetition.
> 
> 
> I can not configure sqlrelay 0.35 at all on fedora 3.
> 
> I have untared the mysql source into
> 
> /opt/installs/sources/mysql-4.1.9
> 
> I then try to configure as below
> 
> ./configure --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9
> 
> but always I get
> 
> configure: WARNING: MySQL support will not be built.
> 
> Any ideas ? Whats it looking for ?
> 
> Regards,
> 
> Marvin Wright
> Flights Developer
> Lastminute.com
> mw...@la...
> +44 (0) 207 802 4543
> 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> 
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
> **********************************************************************
> 

[Sqlrelay-discussion] MySQL on Fedora 3

[Marvin W. <MW...@la...>]

Hi,

I've sent this message to the yahoo groups board too as still both are being
used.
Sorry for any repetition.


I can not configure sqlrelay 0.35 at all on fedora 3.

I have untared the mysql source into

/opt/installs/sources/mysql-4.1.9

I then try to configure as below

./configure --enable-mysql-prefix=/opt/installs/sources/mysql-4.1.9

but always I get

configure: WARNING: MySQL support will not be built.

Any ideas ? Whats it looking for ?

Regards,

Marvin Wright
Flights Developer
Lastminute.com
mw...@la...
+44 (0) 207 802 4543



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Re: [Sqlrelay-discussion] several sqlr-listener process

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

This is usually caused by scripts that fail to call sqlrcon_free when
the when someone hits abort in the browser.

There's more info at=20
http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php

In the next release, the PHP driver will clean up after itself better
and it won't be necessary to do it yourself.

David Muse
dav...@fi...

On Tue, 8 Feb 2005 10:50:54 -0500
Daniel Eduardo Mass=F3n <ddm...@gm...> wrote:

> Hi everyone , .. im using sqlrelay for oracle, and im connecting
> trough the php api, ... some times im having lots of sqlr-listener
> process and it ends up hanging the box, .. anyone knows why this
> happens ?? is it related to tuning issues ???
>=20
> thanks , ...=20
>=20
> DANIEL
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20

[Sqlrelay-discussion] several sqlr-listener process

[<ddm...@gm...>]

Hi everyone , .. im using sqlrelay for oracle, and im connecting
trough the php api, ... some times im having lots of sqlr-listener
process and it ends up hanging the box, .. anyone knows why this
happens ?? is it related to tuning issues ???

thanks , ... 

DANIEL

[Sqlrelay-discussion] rudiments-0.28pre2 compile error

[Samuel Luxford-W. <sl...@wi...>]

Hi Dave,

 

I have tried your suggestion of editing src/client.C and inserting:

 

#include <stdlib.h>

 

It now gets further through the compile but seem  fails at the linking stage
with the following error:

 

make[1]: Entering directory `/home/slw/rudiments-0.28pre2/src'

/bin/sh ../libtool --mode=compile g++ -Wall -Wall -pipe -D_REENTRANT
-I../ -I../include -c unixclientsocket.C -o unixclientsocket.lo

 g++ -Wall -Wall -pipe -D_REENTRANT -I../ -I../include -c unixclientsocket.C
-fPIC -DPIC -o .libs/unixclientsocket.o

unixclientsocket.C: In member function `virtual void 

   unixclientsocket::initialize(namevaluepairs*)':

unixclientsocket.C:49: error: `atoi' undeclared (first use this function)

unixclientsocket.C:49: error: (Each undeclared identifier is reported only
once 

   for each function it appears in.)

make[1]: *** [unixclientsocket.lo] Error 1

make[1]: Leaving directory `/home/slw/rudiments-0.28pre2/src'

make: *** [all] Error 2

 

 

 

Also - any joy with that zope problem?

 

Thanks,

 

Sam


--------------
Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
Telephone 020 7593 5000 Fax 020 7593 5099

-Confidentiality- 
This email message and any attachments are confidential; they may be subject to legal professional privilege and are intended for the named recipient only. If you are not the named recipient, please return the message and enclosures immediately and delete them from your system.

-Caution- 
Before advice received only by email (whether by attachment or otherwise) may be relied on, the authenticity of the communication must be verified by means independent of email.

-Regulation- 
The firm is regulated by the Law Society. 

-Partners- 
A list of partners is available for inspection at each office of the firm and on the firm's website at http://www.winckworths.co.uk