sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] SQLRelay in Shared Hosting Environment

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

It's not possible to have SQL Relay send all writes to the master and
distribute reads over a set of slaves.  The 2-instance method Ionut
described is the closest thing you can do currently.

David Muse
dav...@fi...


On Mon, 2005-07-25 at 15:49 +0300, Ionut Ciocirlan wrote:
> Chris,
>  
> It might still be possible with SQL Relay, maybe someone else / David
> will shed some more light on the issue. 
>  
> And afaik it can be done with MySql Cluster, never played with it
> though.
>  
> Ionut
>  
>         ----- Original Message ----- 
>         From: Christian Keil 
>         To: sql...@li... ;
>         sql...@li... 
>         Sent: Monday, July 25, 2005 3:01 PM
>         Subject: AW: [Sqlrelay-discussion] SQLRelay in Shared Hosting
>         Environment
>         
>         
>         Hello Ionut,
>          
>         what I was trying to do was putting sqlrelay into the
>         environment without having to change any scripts at all.
>         i.e. sqlrelay taking over the internal ip of the first sql
>         node used in all client scripts and doing the distribution by
>         itself. 
>          
>         So far I think it is impossible with sqlrelay.
>          
>         Regards
>          
>         Christian
>         
>         
>         ______________________________________________________________
>         Von: sql...@li... im
>         Auftrag von Ionut Ciocirlan
>         Gesendet: Mo 25.07.2005 14:02
>         An: sql...@li...
>         Betreff: Re: [Sqlrelay-discussion] SQLRelay in Shared Hosting
>         Environment
>         
>         
>         Hi Chris,
>          
>         Yes, you can. Use configure more connections using
>         <connection> tags under an instance's <connections>.
>         This will solve the load-balanced reads. You can also
>         influence the balancing by playing with the metric attribute.
>         E.g.:
>          
>         <instance id="balanced" ....>
>         ....
>             <connections>
>                 <connection connectionid="master" ... />
>                 <connection connectionid="slave_1" ... />
>                 ........
>                 <connection connectionid="slave_n" ... />
>             </connections>
>         </instance>
>          
>          
>         However, as you're doing single master replication, your best
>         bet for writes is to create another <instance> that has only a
>         single <connection> -- to the master server. E.g.:
>          
>         <instance id="master" ....>
>         ....
>             <connections>
>                 <connection connectionid="master" ... />
>             </connections>
>         </instance>
>          
>          
>         You will then need to modify the client app to do writes using
>         the master instance, and reads using the balanced instance,
>         which might be a pain if the app's db layer is not OO.
>          
>         Ionut
>                 ----- Original Message ----- 
>                 From: Christian Keil 
>                 To: sql...@li... 
>                 Sent: Sunday, July 24, 2005 8:21 PM
>                 Subject: [Sqlrelay-discussion] SQLRelay in Shared
>                 Hosting Environment
>                 
>                 
>                 Hello,
>                 
>                  
>                 
>                 i have gone through the Documentation of SQLRelay
>                 working together with mySQL. Can I use the System to
>                 make 2+n mySQL Servers available under a single ip ? 
>                 
>                  
>                 
>                 I want to send all write queries to one machine and
>                 split the reads among the rest machines.
>                 
>                  
>                 
>                 Thanks in Advance
>                 
>                  
>                 
>                 Chris
>                 
>                 
>         !DSPAM:42e4d406225172468415119! 

Re: [Sqlrelay-discussion] Using sqlrelay from c#

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

Sorry, not currently.  It's on the TODO list, but I haven't gotten
around to implementing it yet.

David Muse
dav...@fi...

On Mon, 2005-07-25 at 11:46 -0500, Batok wrote:
> Is it possible to access sqlrelay from c#?
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

Re: [Sqlrelay-discussion] ORA-01405 and CLOB's

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

Interesting.  I'll have to look into that and see.  I think one of the
tests in my test suite fetches a NULL clob from a table, but not through
a stored procedure.  I wonder if this is a special case.  Could you send
me a sample stored procedure that exhibits the problem?

David Muse
dav...@fi...

On Mon, 2005-07-25 at 14:46 -0700, Mark Baldwin-c wrote:
> Greetings,
> 
> I had a more rambling post on this last week but after some more
> investigation I've been able to pin down the problem. Hopefully, someone
> out there has some insight.
> 
> We have a stored procedure that returns a CLOB provided someone passes
> in a valid key. If the key exists, SQLRelay happily returns the bound
> CLOB. However, if the key doesn't exist SQLRelay catches an ORA-01405
> Fetched column is NULL error. Any other way of calling the same
> procedure (SQL*Plus, PHP/OCI, etc) with bound variables and a
> non-existent key returns the null field without complaint.
> 
> Is there anyway of making SQLRelay ignore the ORA-01405?
> 
> Thanks in advance,
> Mark
> 
> The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please notify the sender by reply email and delete the message and any attachments.
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

Re: [Sqlrelay-discussion] Debian 3.1 Install -- Socket Problem

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

What are the runasuser and runasgroup settings set to for the instance
you're trying to start?  If /tmp has 755 permissions, then unless
they're both set to the owner of the /tmp, then you won't be able to
create a socket there.

Also, is this a custom kernel build?  Is it possible that unix socket
support was accidentally removed from the kernel?

David Muse
dav...@fi...

On Tue, 2005-07-26 at 09:47 -0500, Ben Gribaudo wrote:
> Hello,
> 
> I am attempting to get SQLRelay running on a new Debian 3.1 box. Would any
> of you be able to point me in the right direction to get sqlr-listener
> listening on sqlrelay.socket? I'm getting "Could not listen on unix
> socket: /tmp/sqlrelay.socket".
> 
> I've googled but haven't come up with anything on this. Permissions on
> /tmp are 755 and I am attempting to run /etc/init.d/sqlrelay start as root.
> 
> Full error message and version information below.
> 
> Thank you,
> Ben
> 
> 
> 
> Error message
> ==================
> Starting listener:
>   sqlr-listener -id iblp-test -config /etc/sqlrelay/sqlrelay.conf
> Could not listen on unix socket: /tmp/sqlrelay.socket
> Make sure that the file and directory are readable and writable.
> 
> 
> sqlr-listener failed to start.
> 
> Versions
> ========
> sqlrelay                       0.35-10
> sqlrelay-doc                   0.32-4
> sqlrelay-freetds               0.35-10 (not used)
> sqlrelay-odbc                  0.35-10
> We're also using a modified sybase driver.
> sybase-ase                     11.0.3.3-7
> sybase-doc                     11.0.3.3-7
> sybase-ocsd                    10.0.4-7
> 
> cat /proc/version
> =================
> Linux version 2.6.8-2-686-smp (ho...@ta...) (gcc
> version 3.3.5 (Debian 1:3.3.5-12)) #1 SMP Thu May 19 17:27:55 JST 2005
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] MySQL connections question

[Tony B. <to...@do...>]

I'm running sqlrelay 0.36.4 with MySQL 4.1 on a tinysofa.org linux 2.6 
kernel and connect via Python scripts.  Everything is setup OK and runs 
fine.  When I start the MySQL server, it appears to start up 10 sessions 
(via ps -ef).  I see one of these lines:
root 982 1 0 16:33 pts/0 00:00:00 /bin/sh 
/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data 
--pid-file=/usr/local/

and 10 of these lines:
mysql 1014 982 0 16:34 pts/0 00:00:00 /usr/local/mysql/libexec/mysqld 
--basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --us

When I fire up sqlrelay, I get an additional (x) number of the second 
lines above based on the intial number of connections I set in the 
sqlrelay.conf file.  Is there a way to make sqlrelay use one of the 
existing sessions already started?  Or can I alter the MySQL my.cnf file 
to not start as many connections?  Anyone know how this works?  Thanks!

[Sqlrelay-discussion] Debian 3.1 Install -- Socket Problem

[Ben G. <me...@be...>]

Hello,

I am attempting to get SQLRelay running on a new Debian 3.1 box. Would any
of you be able to point me in the right direction to get sqlr-listener
listening on sqlrelay.socket? I'm getting "Could not listen on unix
socket: /tmp/sqlrelay.socket".

I've googled but haven't come up with anything on this. Permissions on
/tmp are 755 and I am attempting to run /etc/init.d/sqlrelay start as root.

Full error message and version information below.

Thank you,
Ben



Error message
==================
Starting listener:
  sqlr-listener -id iblp-test -config /etc/sqlrelay/sqlrelay.conf
Could not listen on unix socket: /tmp/sqlrelay.socket
Make sure that the file and directory are readable and writable.


sqlr-listener failed to start.

Versions
========
sqlrelay                       0.35-10
sqlrelay-doc                   0.32-4
sqlrelay-freetds               0.35-10 (not used)
sqlrelay-odbc                  0.35-10
We're also using a modified sybase driver.
sybase-ase                     11.0.3.3-7
sybase-doc                     11.0.3.3-7
sybase-ocsd                    10.0.4-7

cat /proc/version
=================
Linux version 2.6.8-2-686-smp (ho...@ta...) (gcc
version 3.3.5 (Debian 1:3.3.5-12)) #1 SMP Thu May 19 17:27:55 JST 2005

[Sqlrelay-discussion] ORA-01405 and CLOB's

[Mark Baldwin-c <mar...@io...>]

Greetings,

I had a more rambling post on this last week but after some more
investigation I've been able to pin down the problem. Hopefully, someone
out there has some insight.

We have a stored procedure that returns a CLOB provided someone passes
in a valid key. If the key exists, SQLRelay happily returns the bound
CLOB. However, if the key doesn't exist SQLRelay catches an ORA-01405
Fetched column is NULL error. Any other way of calling the same
procedure (SQL*Plus, PHP/OCI, etc) with bound variables and a
non-existent key returns the null field without complaint.

Is there anyway of making SQLRelay ignore the ORA-01405?

Thanks in advance,
Mark

The information contained in this email message may be privileged, =
confidential and protected from disclosure. If you are not the intended =
recipient, any dissemination, distribution or copying is strictly =
prohibited. If you think that you have received this email message in =
error, please notify the sender by reply email and delete the message =
and any attachments.

[Sqlrelay-discussion] Using sqlrelay from c#

[Batok <ba...@sm...>]

Is it possible to access sqlrelay from c#?

Re: [Sqlrelay-discussion] SQLRelay in Shared Hosting Environment

[Ionut C. <ion...@av...>]

Chris,

It might still be possible with SQL Relay, maybe someone else / David =
will shed some more light on the issue.=20

And afaik it can be done with MySql Cluster, never played with it =
though.

Ionut

  ----- Original Message -----=20
  From: Christian Keil=20
  To: sql...@li... ; =
sql...@li...=20
  Sent: Monday, July 25, 2005 3:01 PM
  Subject: AW: [Sqlrelay-discussion] SQLRelay in Shared Hosting =
Environment


  Hello Ionut,

  what I was trying to do was putting sqlrelay into the environment =
without having to change any scripts at all.
  i.e. sqlrelay taking over the internal ip of the first sql node used =
in all client scripts and doing the distribution by itself.=20

  So far I think it is impossible with sqlrelay.

  Regards

  Christian


-------------------------------------------------------------------------=
-----
  Von: sql...@li... im Auftrag von =
Ionut Ciocirlan
  Gesendet: Mo 25.07.2005 14:02
  An: sql...@li...
  Betreff: Re: [Sqlrelay-discussion] SQLRelay in Shared Hosting =
Environment


  Hi Chris,

  Yes, you can. Use configure more connections using <connection> tags =
under an instance's <connections>.
  This will solve the load-balanced reads. You can also influence the =
balancing by playing with the metric attribute. E.g.:

  <instance id=3D"balanced" ....>
  ....
      <connections>
          <connection connectionid=3D"master" ... />
          <connection connectionid=3D"slave_1" ... />
          ........
          <connection connectionid=3D"slave_n" ... />
      </connections>
  </instance>


  However, as you're doing single master replication, your best bet for =
writes is to create another <instance> that has only a single =
<connection> -- to the master server. E.g.:

  <instance id=3D"master" ....>
  ....
      <connections>
          <connection connectionid=3D"master" ... />
      </connections>
  </instance>


  You will then need to modify the client app to do writes using the =
master instance, and reads using the balanced instance, which might be a =
pain if the app's db layer is not OO.

  Ionut
    ----- Original Message -----=20
    From: Christian Keil=20
    To: sql...@li...=20
    Sent: Sunday, July 24, 2005 8:21 PM
    Subject: [Sqlrelay-discussion] SQLRelay in Shared Hosting =
Environment


    Hello,



    i have gone through the Documentation of SQLRelay working together =
with mySQL. Can I use the System to make 2+n mySQL Servers available =
under a single ip ?=20



    I want to send all write queries to one machine and split the reads =
among the rest machines.



    Thanks in Advance



    Chris

  !DSPAM:42e4d406225172468415119! 

AW: [Sqlrelay-discussion] SQLRelay in Shared Hosting Environment

[Christian K. <c....@do...>]

Hello Ionut,
=20
what I was trying to do was putting sqlrelay into the environment =
without having to change any scripts at all.
i.e. sqlrelay taking over the internal ip of the first sql node used in =
all client scripts and doing the distribution by itself.=20
=20
So far I think it is impossible with sqlrelay.
=20
Regards
=20
Christian

________________________________

Von: sql...@li... im Auftrag von =
Ionut Ciocirlan
Gesendet: Mo 25.07.2005 14:02
An: sql...@li...
Betreff: Re: [Sqlrelay-discussion] SQLRelay in Shared Hosting =
Environment


Hi Chris,
=20
Yes, you can. Use configure more connections using <connection> tags =
under an instance's <connections>.
This will solve the load-balanced reads. You can also influence the =
balancing by playing with the metric attribute. E.g.:
=20
<instance id=3D"balanced" ....>
....
    <connections>
        <connection connectionid=3D"master" ... />
        <connection connectionid=3D"slave_1" ... />
        ........
        <connection connectionid=3D"slave_n" ... />
    </connections>
</instance>
=20
=20
However, as you're doing single master replication, your best bet for =
writes is to create another <instance> that has only a single =
<connection> -- to the master server. E.g.:
=20
<instance id=3D"master" ....>
....
    <connections>
        <connection connectionid=3D"master" ... />
    </connections>
</instance>
=20
=20
You will then need to modify the client app to do writes using the =
master instance, and reads using the balanced instance, which might be a =
pain if the app's db layer is not OO.
=20
Ionut

	----- Original Message -----=20
	From: Christian Keil <mailto:c....@do...> =20
	To: sql...@li...=20
	Sent: Sunday, July 24, 2005 8:21 PM
	Subject: [Sqlrelay-discussion] SQLRelay in Shared Hosting Environment
=09
=09

	Hello,

	=20

	i have gone through the Documentation of SQLRelay working together with =
mySQL. Can I use the System to make 2+n mySQL Servers available under a =
single ip ?=20

	=20

	I want to send all write queries to one machine and split the reads =
among the rest machines.

	=20

	Thanks in Advance

	=20

	Chris

!DSPAM:42e4d406225172468415119!=20

Re: [Sqlrelay-discussion] SQLRelay in Shared Hosting Environment

[Ionut C. <ion...@av...>]

Hi Chris,

Yes, you can. Use configure more connections using <connection> tags =
under an instance's <connections>.
This will solve the load-balanced reads. You can also influence the =
balancing by playing with the metric attribute. E.g.:

<instance id=3D"balanced" ....>
....
    <connections>
        <connection connectionid=3D"master" ... />
        <connection connectionid=3D"slave_1" ... />
        ........
        <connection connectionid=3D"slave_n" ... />
    </connections>
</instance>


However, as you're doing single master replication, your best bet for =
writes is to create another <instance> that has only a single =
<connection> -- to the master server. E.g.:

<instance id=3D"master" ....>
....
    <connections>
        <connection connectionid=3D"master" ... />
    </connections>
</instance>


You will then need to modify the client app to do writes using the =
master instance, and reads using the balanced instance, which might be a =
pain if the app's db layer is not OO.

Ionut
  ----- Original Message -----=20
  From: Christian Keil=20
  To: sql...@li...=20
  Sent: Sunday, July 24, 2005 8:21 PM
  Subject: [Sqlrelay-discussion] SQLRelay in Shared Hosting Environment


  Hello,

  =20

  i have gone through the Documentation of SQLRelay working together =
with mySQL. Can I use the System to make 2+n mySQL Servers available =
under a single ip ?=20

  =20

  I want to send all write queries to one machine and split the reads =
among the rest machines.

  =20

  Thanks in Advance

  =20

  Chris

[Sqlrelay-discussion] SQLRelay in Shared Hosting Environment

[Christian K. <c....@do...>]

Hello,

=20

i have gone through the Documentation of SQLRelay working together with
mySQL. Can I use the System to make 2+n mySQL Servers available under a
single ip ?=20

=20

I want to send all write queries to one machine and split the reads
among the rest machines.

=20

Thanks in Advance

=20

Chris

[Sqlrelay-discussion] only one mysqld daemon?

[linuxman <lin...@bl...>]

hi all,
 
Here is pstree output in my debian/linux box:
     sqlr-cachemanag
     10*[sqlr-connection]
     2*[sqlr-listener]
     2*[sqlr-scaler]

and, only one mysqld daemon there! very strange here.
 
The problem is, is it normal or something wrong with my sqlrelay
configuration? 
 
Here is my sqlrelay.conf:
 
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
 
<instances>
 
    <instance id="test1" port="9000"
socket="/usr/local/firstworks/var/sqlrelay/tmp/sqlrelay_9000.sock"
dbase="mysql" connections="5"      maxconnections="75" maxqueuelength="5"
growby="5" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="sqlrelay"                    runasgroup="sqlrelay" cursors="5"
authtier="listener" handoff="pass" deniedips="" allowedips=""
debug="connection">
        <users>
            <user user="root" password="xxx"/ <mailto:mysql@peakinfo> >
        </users>
        <connections>
            <connection connectionid="test"
string="user=root;password=xxx;db=xxx;socket=/var/run/mysqld/mysqld.sock" />
        </connections>
    </instance>
 
    <instance id="test2" port="9001"
socket="/usr/local/firstworks/var/sqlrelay/tmp/sqlrelay_9001.sock"
dbase="mysql"               connections="5" maxconnections="75"
maxqueuelength="5" growby="1" ttl="60" endofsession="commit"
sessiontimeout="600" runasuser="sqlrelay"    runasgroup="sqlrelay"
cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips=""
debug="connection">
        <users>
            <user user="root" password="xxx"/ <mailto:mysql@peakinfo> >
        </users>
        <connections>
            <connection connectionid="test3"
string="user=root;password=xxx;db=test;host=localhost;port=3306" />
        </connections>
    </instance>
</instances>

Thanks in advance!
 
linuxman

[Sqlrelay-discussion] =?gb2312?B?tPC4tDogW1NxbHJlbGF5LWRpc2N1c3Npb25dILTwuLQ6IFtTcWxyZQ==?= =?gb2312?B?bGF5LWRpc2N1c3Npb25dIGFib3V0IGluc2VydF9pZA==?=

[linuxman <lin...@bl...>]

Work it out!
=20
It seemed that, this line:
=20
$row =3D sqlrcur_getRowAssoc($this->_cur);
=20
has something wrong, I replace this line with:
=20
$insertId =3D sqlcrur_getField($this->_cur, 0, "Insert_ID");
=20
then everything go well...
=20
But another problem, I don't know when to free the resources that
sqlrcon_alloc and sqlrcur_alloc applied?
=20
The trick is that, I can not free the cursor returned by =
sqlcur_sendQuery
just after sendQuery finished, because I must transfer the cursor to
resultset as the parameter.=20
=20
Thanks!=20


  _____ =20

=B7=A2=BC=FE=C8=CB: sql...@li...
[mailto:sql...@li...] =B4=FA=B1=ED =
Josh Johnson
=B7=A2=CB=CD=CA=B1=BC=E4: 2005=C4=EA7=D4=C221=C8=D5 23:08
=CA=D5=BC=FE=C8=CB: sql...@li...
=D6=F7=CC=E2: Re: [Sqlrelay-discussion] =B4=F0=B8=B4: =
[Sqlrelay-discussion] about insert_id


I had a feeling it was more complicated than I thought :) I haven't used
sqlrelay enough (I've been using it with PEAR) to have run into this =
problem
myself, but it's something I'll have to deal with too...=20

-- JJ

linuxman wrote:=20

thanks for JJ's quick response !



The code below is from the model class of my application:



....

if the $query is insert something:



                $this->_masterDb =3D & Db::getDb("sqlrelay",9001);

                $this->_cur =3D sqlrcur_alloc( $this->_masterDb );

                sqlrcur_sendQuery( $this->_cur, "set names 'utf8'" );

                sqlrcur_sendQuery( $this->_cur, $query );



                $result =3D

$this->convertFromEmptySqlRelayResult($this->_cur);



                sqlrcur_sendQuery($this->_cur, "SELECT LAST_INSERT_ID() =
as

Insert_ID");

                $row =3D sqlrcur_getRowAssoc($this->_cur);

                        $this->log->debug("Row is =
".LogUtil::format($row));

                $result->setInsertID($row["Insert_ID"]);

                sqlrcon_endSession($this->_masterDb);

=20

and convertFromEmptySqlRelayResult is here:



    function convertFromEmptySqlRelayResult( $cur ){

        $recordset =3D new EmptyMysqlResultSet_SqlRelay( $cur );

        return $recordset;

    }



And, EmptyMysqlResultSet_SqlRelay is defined as below:



class EmptyMysqlResultSet_SqlRelay{

    var $fields =3D false;

    var $EOF =3D true;

    function MoveNext() {return;}

    function RecordCount() {return 0;}

    function FieldCount() {return 0;}

    function EOF(){return TRUE;}

    function Close(){return true;}



    function emptyMysqlResultSet_SqlRelay($cur){

        $this->cursor =3D $cur;

    }



    function Affected_Rows(){

        return sqlrcur_affectedRows($this->cursor);

    }



    function setInsertID($id){

        $this->insert_ID =3D $id;

    }



    function getInsertID(){

        return $this->insert_ID;

    }

}



You see, sqlrelay is running port 9001, the query is like "INSERT ....".



But the problem is,  SELECT LAST_INSERT_ID() always return 0, I know =
this by

watch the log output of  "$this->log->debug("Row is

".LogUtil::format($row))".



Any problem of my codes ? or any other way to get insert id?=20



Thanks!



-----=D3=CA=BC=FE=D4=AD=BC=FE-----

=B7=A2=BC=FE=C8=CB: sql...@li...

[mailto:sql...@li...] =B4=FA=B1=ED =
Josh Johnson

=B7=A2=CB=CD=CA=B1=BC=E4: 2005=C4=EA7=D4=C221=C8=D5 22:14

=CA=D5=BC=FE=C8=CB: sql...@li...

=D6=F7=CC=E2: Re: [Sqlrelay-discussion] about insert_id



try: SELECT LAST_INSERT_ID();



-- JJ



linuxman wrote:



 =20

hi all,



I use mysql+php+adodb in my web application, and want to use sqlrelay=20

as database polling. But, I don't know how to get insert id just after=20

inserting a record with sqlrelay? you know , there is Insert_ID in=20

adodb to get the insert id, but I have not find the same function in=20

the php api of sqlrelay.



I used the 0.36 version of sqlrelay.



Any hints? Thanks in advance!



Linuxman











-------------------------------------------------------

SF.Net email is sponsored by: Discover Easy Linux Migration Strategies=20

   =20

>from IBM. Find simple to follow Roadmaps, straightforward articles,=20

 =20

informative Webcasts and more! Get everything you need to get up to=20

speed, fast. http://ads.osdn.com/?ad_id=3D7477
<http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick>
&alloc_id=3D16492&op=3Dclick

_______________________________________________

Sqlrelay-discussion mailing list

Sql...@li...

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

=20



   =20









-------------------------------------------------------

SF.Net email is sponsored by: Discover Easy Linux Migration Strategies =
from

IBM. Find simple to follow Roadmaps, straightforward articles, =
informative

Webcasts and more! Get everything you need to get up to speed, fast.

http://ads.osdn.com/?ad_id=3D7477
<http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick>
&alloc_id=3D16492&op=3Dclick

_______________________________________________

Sqlrelay-discussion mailing list

Sql...@li...

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









-------------------------------------------------------

SF.Net email is sponsored by: Discover Easy Linux Migration Strategies

from IBM. Find simple to follow Roadmaps, straightforward articles,

informative Webcasts and more! Get everything you need to get up to

speed, fast. http://ads.osdn.com/?ad_idt77
<http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dclick> =
&alloc_id=16492&op=3Dclick

_______________________________________________

Sqlrelay-discussion mailing list

Sql...@li...

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

 =20

Re: [Sqlrelay-discussion] Problem with Python cPickle and blobs

[Ville S. <vs...@eb...>]

Hi Dave,

Python len seems to be working correctly with pickled data.

I did find out that cPickle.dumps(sdata) works ok. This generates string 
representation of the pickled data, which doesn't contain a \0 character. 
(I had a typo in my earlier test, the create procedure used string data, 
the modify procedure used binary, which is why I thought neither dumps 
worked.)

If I use the HIGHEST_PROTOCOL with dumps, it generates binary data. This 
seems to have a problem with inputBindBlob(), unless I'm still doing 
something wrong. So if I am right, you should be able to recreate the 
problem with something like this:

   sdata={'spam': {'eggs': 'spamspam', 'answers': {1:'', 2:'foo', 3:'bar'}}}
   ...
   bdata = cPickle.dumps(sdata, 2)  # uses HIGHEST_PROTOCOL
   blen = len(bdata)
   cur.inputBindBlob('colname', bdata, blen)
   ...
   # read the data by using normal select
   ...
   mydata = cPickle.loads(fields[0])
   # this throws EOFError (at least in my case)

I think '' generates \x00 or \x0, which becomes EOF with inputBindBlob. 
Perhaps it encodes \x00 as \0? Or maybe the problem is in the select?
Is it ok to use normal select to read blobs?

Thanks,
Ville


On Thu, 21 Jul 2005, Firstworks/4access wrote:

> Ville,
>
> I was actually looking at that last night.  I'm believe you're on track.
> inputBind() does a strlen() of the string to decide how many characters
> to store in the database.  strlen() interprets \0's as end-of-string
> markers, so only part of the data gets stored in the blob.  Then, later
> when you fetch and unpickle it, only part of it gets unpickled.  I
> believe the solution is to use inputBindBlob() or inputBindClob() rather
> than inputBind() to store the pickled data.  inputBindBlob() and
> inputBindClob() take a length parameter and ignore \0's.
>
> Give it a try and let me know whether it works or not.
>
> Dave
> dav...@fi...
>
> On Thu, 2005-07-21 at 12:31 +0100, Ville Silventoinen wrote:
>> Hi,
>>
>> I'm using PySQLRClient from sqlrelay-0.36 (with rudiments-0.28.2)
>> to store blobs in Oracle 9.2.0 database.
>>
>> I'm not sure if this has been fixed in the recent sqlrelay release,
>> but I'm experiencing problems when I store a Python data structure
>> (dictionary object) to a blob using Pythons cPickle module. Everything
>> works great until one of the values in the pickled object is an empty
>> string (''). After that cPickle.load fails to read the data, it raises
>> EOFError exception. So I wonder if PySQLRClient interprets the pickled
>> '' as an end-of-file character?
>>
>> If I try loading/saving similar data structure to a file, it works ok.
>>
>> Thanks for any advice,
>>
>> Ville
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] =?GB2312?B?tPC4tDogW1NxbHJlbGF5LWRpc2N1?= =?GB2312?B?c3Npb25dIGFib3V0IGluc2VydF9pZA==?=

[Josh J. <jos...@un...>]

I had a feeling it was more complicated than I thought :) I haven't used
sqlrelay enough (I've been using it with PEAR) to have run into this
problem myself, but it's something I'll have to deal with too...

-- JJ

linuxman wrote:

>thanks for JJ's quick response !
>
>The code below is from the model class of my application:
>
>....
>if the $query is insert something:
>
>                $this->_masterDb =3D & Db::getDb("sqlrelay",9001);
>                $this->_cur =3D sqlrcur_alloc( $this->_masterDb );
>                sqlrcur_sendQuery( $this->_cur, "set names 'utf8'" );
>                sqlrcur_sendQuery( $this->_cur, $query );
>
>                $result =3D
>$this->convertFromEmptySqlRelayResult($this->_cur);
>
>                sqlrcur_sendQuery($this->_cur, "SELECT LAST_INSERT_ID() =
as
>Insert_ID");
>                $row =3D sqlrcur_getRowAssoc($this->_cur);
>                        $this->log->debug("Row is ".LogUtil::format($row=
));
>                $result->setInsertID($row["Insert_ID"]);
>                sqlrcon_endSession($this->_masterDb);
>=20
>and convertFromEmptySqlRelayResult is here:
>
>    function convertFromEmptySqlRelayResult( $cur ){
>        $recordset =3D new EmptyMysqlResultSet_SqlRelay( $cur );
>        return $recordset;
>    }
>
>And, EmptyMysqlResultSet_SqlRelay is defined as below:
>
>class EmptyMysqlResultSet_SqlRelay{
>    var $fields =3D false;
>    var $EOF =3D true;
>    function MoveNext() {return;}
>    function RecordCount() {return 0;}
>    function FieldCount() {return 0;}
>    function EOF(){return TRUE;}
>    function Close(){return true;}
>
>    function emptyMysqlResultSet_SqlRelay($cur){
>        $this->cursor =3D $cur;
>    }
>
>    function Affected_Rows(){
>        return sqlrcur_affectedRows($this->cursor);
>    }
>
>    function setInsertID($id){
>        $this->insert_ID =3D $id;
>    }
>
>    function getInsertID(){
>        return $this->insert_ID;
>    }
>}
>
>You see, sqlrelay is running port 9001, the query is like "INSERT ....".
>
>But the problem is,  SELECT LAST_INSERT_ID() always return 0, I know thi=
s by
>watch the log output of  "$this->log->debug("Row is
>".LogUtil::format($row))".
>
>Any problem of my codes ? or any other way to get insert id?=20
>
>Thanks!
>
>-----=D3=CA=BC=FE=D4=AD=BC=FE-----
>=B7=A2=BC=FE=C8=CB: sql...@li...
>[mailto:sql...@li...] =B4=FA=B1=ED Jo=
sh Johnson
>=B7=A2=CB=CD=CA=B1=BC=E4: 2005=C4=EA7=D4=C221=C8=D5 22:14
>=CA=D5=BC=FE=C8=CB: sql...@li...
>=D6=F7=CC=E2: Re: [Sqlrelay-discussion] about insert_id
>
>try: SELECT LAST_INSERT_ID();
>
>-- JJ
>
>linuxman wrote:
>
> =20
>
>>hi all,
>>
>>I use mysql+php+adodb in my web application, and want to use sqlrelay=20
>>as database polling. But, I don't know how to get insert id just after=20
>>inserting a record with sqlrelay? you know , there is Insert_ID in=20
>>adodb to get the insert id, but I have not find the same function in=20
>>the php api of sqlrelay.
>>
>>I used the 0.36 version of sqlrelay.
>>
>>Any hints? Thanks in advance!
>>
>>Linuxman
>>
>>
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies=20
>>   =20
>>
>>from IBM. Find simple to follow Roadmaps, straightforward articles,=20
> =20
>
>>informative Webcasts and more! Get everything you need to get up to=20
>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dcl=
ick
>>_______________________________________________
>>Sqlrelay-discussion mailing list
>>Sql...@li...
>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>=20
>>
>>   =20
>>
>
>
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies f=
rom
>IBM. Find simple to follow Roadmaps, straightforward articles, informati=
ve
>Webcasts and more! Get everything you need to get up to speed, fast.
>http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick
>_______________________________________________
>Sqlrelay-discussion mailing list
>Sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>from IBM. Find simple to follow Roadmaps, straightforward articles,
>informative Webcasts and more! Get everything you need to get up to
>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dclick
>_______________________________________________
>Sqlrelay-discussion mailing list
>Sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> =20
>

[Sqlrelay-discussion] =?gb2312?B?tPC4tDogW1NxbHJlbGF5LWRpc2N1c3Npb25dIGFib3V0IGluc2VydF9pZA==?=

[linuxman <lin...@bl...>]

thanks for JJ's quick response !

The code below is from the model class of my application:

....
if the $query is insert something:

                $this->_masterDb =3D & Db::getDb("sqlrelay",9001);
                $this->_cur =3D sqlrcur_alloc( $this->_masterDb );
                sqlrcur_sendQuery( $this->_cur, "set names 'utf8'" );
                sqlrcur_sendQuery( $this->_cur, $query );

                $result =3D
$this->convertFromEmptySqlRelayResult($this->_cur);

                sqlrcur_sendQuery($this->_cur, "SELECT LAST_INSERT_ID() =
as
Insert_ID");
                $row =3D sqlrcur_getRowAssoc($this->_cur);
                        $this->log->debug("Row is =
".LogUtil::format($row));
                $result->setInsertID($row["Insert_ID"]);
                sqlrcon_endSession($this->_masterDb);
=20
and convertFromEmptySqlRelayResult is here:

    function convertFromEmptySqlRelayResult( $cur ){
        $recordset =3D new EmptyMysqlResultSet_SqlRelay( $cur );
        return $recordset;
    }

And, EmptyMysqlResultSet_SqlRelay is defined as below:

class EmptyMysqlResultSet_SqlRelay{
    var $fields =3D false;
    var $EOF =3D true;
    function MoveNext() {return;}
    function RecordCount() {return 0;}
    function FieldCount() {return 0;}
    function EOF(){return TRUE;}
    function Close(){return true;}

    function emptyMysqlResultSet_SqlRelay($cur){
        $this->cursor =3D $cur;
    }

    function Affected_Rows(){
        return sqlrcur_affectedRows($this->cursor);
    }

    function setInsertID($id){
        $this->insert_ID =3D $id;
    }

    function getInsertID(){
        return $this->insert_ID;
    }
}

You see, sqlrelay is running port 9001, the query is like "INSERT ....".

But the problem is,  SELECT LAST_INSERT_ID() always return 0, I know =
this by
watch the log output of  "$this->log->debug("Row is
".LogUtil::format($row))".

Any problem of my codes ? or any other way to get insert id?=20

Thanks!

-----=D3=CA=BC=FE=D4=AD=BC=FE-----
=B7=A2=BC=FE=C8=CB: sql...@li...
[mailto:sql...@li...] =B4=FA=B1=ED =
Josh Johnson
=B7=A2=CB=CD=CA=B1=BC=E4: 2005=C4=EA7=D4=C221=C8=D5 22:14
=CA=D5=BC=FE=C8=CB: sql...@li...
=D6=F7=CC=E2: Re: [Sqlrelay-discussion] about insert_id

try: SELECT LAST_INSERT_ID();

-- JJ

linuxman wrote:

>=20
>hi all,
>
>I use mysql+php+adodb in my web application, and want to use sqlrelay=20
>as database polling. But, I don't know how to get insert id just after=20
>inserting a record with sqlrelay? you know , there is Insert_ID in=20
>adodb to get the insert id, but I have not find the same function in=20
>the php api of sqlrelay.
>
>I used the 0.36 version of sqlrelay.
>
>Any hints? Thanks in advance!
>
>Linuxman
>
>
>
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies=20
>from IBM. Find simple to follow Roadmaps, straightforward articles,=20
>informative Webcasts and more! Get everything you need to get up to=20
>speed, fast. =
http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick
>_______________________________________________
>Sqlrelay-discussion mailing list
>Sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> =20
>




-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies =
from
IBM. Find simple to follow Roadmaps, straightforward articles, =
informative
Webcasts and more! Get everything you need to get up to speed, fast.
http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] about insert_id

[Josh J. <jos...@un...>]

try: SELECT LAST_INSERT_ID();

-- JJ

linuxman wrote:

> 
>hi all,
>
>I use mysql+php+adodb in my web application, and want to use sqlrelay as
>database polling. But, I don't know how to get insert id just after
>inserting a record with sqlrelay? you know , there is Insert_ID in adodb to
>get the insert id, but I have not find the same function in the php api of
>sqlrelay.
>
>I used the 0.36 version of sqlrelay.
>
>Any hints? Thanks in advance!
>
>Linuxman
>
>
>
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>from IBM. Find simple to follow Roadmaps, straightforward articles,
>informative Webcasts and more! Get everything you need to get up to
>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>_______________________________________________
>Sqlrelay-discussion mailing list
>Sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>  
>

[Sqlrelay-discussion] about insert_id

[linuxman <lin...@bl...>]

 
hi all,

I use mysql+php+adodb in my web application, and want to use sqlrelay as
database polling. But, I don't know how to get insert id just after
inserting a record with sqlrelay? you know , there is Insert_ID in adodb to
get the insert id, but I have not find the same function in the php api of
sqlrelay.

I used the 0.36 version of sqlrelay.

Any hints? Thanks in advance!

Linuxman

Re: [Sqlrelay-discussion] Problem with Python cPickle and blobs

[Ville S. <vs...@eb...>]

Hi Dave,

thanks for replying so quickly.

Unfortunately I am already using the sqlrcursor.inputBindBlob.
I also pass the length parameter, which I get by calling Python
len function:

sdata = cPickle.dumps(data)
slen  = len(sdata)

Could len give a wrong length? I will do some tests. I have also
tried "cPickle,dumps(data, 2)" as well, same problem.

I have avoided the problem now by using None instead of '' values.
That seems to work fine.

Thanks,
Ville



On Thu, 21 Jul 2005, Firstworks/4access wrote:

> Ville,
>
> I was actually looking at that last night.  I'm believe you're on track.
> inputBind() does a strlen() of the string to decide how many characters
> to store in the database.  strlen() interprets \0's as end-of-string
> markers, so only part of the data gets stored in the blob.  Then, later
> when you fetch and unpickle it, only part of it gets unpickled.  I
> believe the solution is to use inputBindBlob() or inputBindClob() rather
> than inputBind() to store the pickled data.  inputBindBlob() and
> inputBindClob() take a length parameter and ignore \0's.
>
> Give it a try and let me know whether it works or not.
>
> Dave
> dav...@fi...
>
> On Thu, 2005-07-21 at 12:31 +0100, Ville Silventoinen wrote:
>> Hi,
>>
>> I'm using PySQLRClient from sqlrelay-0.36 (with rudiments-0.28.2)
>> to store blobs in Oracle 9.2.0 database.
>>
>> I'm not sure if this has been fixed in the recent sqlrelay release,
>> but I'm experiencing problems when I store a Python data structure
>> (dictionary object) to a blob using Pythons cPickle module. Everything
>> works great until one of the values in the pickled object is an empty
>> string (''). After that cPickle.load fails to read the data, it raises
>> EOFError exception. So I wonder if PySQLRClient interprets the pickled
>> '' as an end-of-file character?
>>
>> If I try loading/saving similar data structure to a file, it works ok.
>>
>> Thanks for any advice,
>>
>> Ville
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Problem with Python cPickle and blobs

[Firstworks/4access <dav...@fi...>]

Ville,

I was actually looking at that last night.  I'm believe you're on track.
inputBind() does a strlen() of the string to decide how many characters
to store in the database.  strlen() interprets \0's as end-of-string
markers, so only part of the data gets stored in the blob.  Then, later
when you fetch and unpickle it, only part of it gets unpickled.  I
believe the solution is to use inputBindBlob() or inputBindClob() rather
than inputBind() to store the pickled data.  inputBindBlob() and
inputBindClob() take a length parameter and ignore \0's.

Give it a try and let me know whether it works or not.

Dave
dav...@fi...

On Thu, 2005-07-21 at 12:31 +0100, Ville Silventoinen wrote:
> Hi,
> 
> I'm using PySQLRClient from sqlrelay-0.36 (with rudiments-0.28.2)
> to store blobs in Oracle 9.2.0 database.
> 
> I'm not sure if this has been fixed in the recent sqlrelay release,
> but I'm experiencing problems when I store a Python data structure
> (dictionary object) to a blob using Pythons cPickle module. Everything
> works great until one of the values in the pickled object is an empty
> string (''). After that cPickle.load fails to read the data, it raises
> EOFError exception. So I wonder if PySQLRClient interprets the pickled
> '' as an end-of-file character?
> 
> If I try loading/saving similar data structure to a file, it works ok.
> 
> Thanks for any advice,
> 
> Ville
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] Problem with Python cPickle and blobs

[Ville S. <vs...@eb...>]

Hi,

I'm using PySQLRClient from sqlrelay-0.36 (with rudiments-0.28.2)
to store blobs in Oracle 9.2.0 database.

I'm not sure if this has been fixed in the recent sqlrelay release,
but I'm experiencing problems when I store a Python data structure
(dictionary object) to a blob using Pythons cPickle module. Everything
works great until one of the values in the pickled object is an empty
string (''). After that cPickle.load fails to read the data, it raises
EOFError exception. So I wonder if PySQLRClient interprets the pickled
'' as an end-of-file character?

If I try loading/saving similar data structure to a file, it works ok.

Thanks for any advice,

Ville

RE: [Sqlrelay-discussion] Multiple connection

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

Great, glad that's all it was :)

Dave

On Wed, 2005-07-20 at 16:07 -0500, Guo, Jinnan wrote:
> Dave,
> 
> Sorry, false alarm. I didn't use sqlr-start, instead I used my own script which only start only connection.
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of
> Firstworks/4access
> Sent: July 20, 2005 04:54 PM
> To: sql...@li...
> Subject: Re: [Sqlrelay-discussion] Multiple connection
> 
> 
> If there's only 1 sqlr-connection-oracle7 process running then that does
> mean that only 1 connection is available.  Your sqlrelay.conf file looks
> right though, 4 connections should start and grow by 2 for a maximum of
> 10.  Could you send me the output of sqlr-start and ps -efa | grep sqlr?
> 
> Dave
> 
> On Wed, 2005-07-20 at 15:37 -0500, Guo, Jinnan wrote:
> > David,
> > 
> > I want to set up the sqlrelay connect to the database with 4
> > connections initially and grow by 2 until 10 connections reached.
> > After startup, I can only see one sqlr-connection process running,
> > does that mean I have only one connection available? Could you please
> > check my conf file and tell me what is wrong?
> > 
> > <?xml version="1.0"?> 
> > <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> > 
> > <instances>
> > 
> >         <instance id="example" port="5559"
> > socket="/usr/local/firstworks/var/sqlrelay/tmp/socket.file"
> > dbase="oracle7" connections="4" maxconnections="10" maxqueuelength="5"
> > growby="2" ttl="60" endofsession="commit" sessiontimeout="600"
> > runasuser="nobody" runasgroup="nobody" cursors="2" authtier="listener"
> > handoff="pass" deniedips="" allowedips="" debug="none">
> > 
> >                 <users> 
> >                         <user user="" password=""/> 
> >                 </users> 
> >                 <connections> 
> >                         <connection connectionid="db1"
> > string="user=abc;password=def;oracle_sid=mydb.world;" metric="1"/>
> > 
> >                 </connections> 
> >         </instance>
> > 
> > </instances>
> > 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

RE: [Sqlrelay-discussion] Multiple connection

[Guo, J. <Jin...@pa...>]

Dave,

Sorry, false alarm. I didn't use sqlr-start, instead I used my own =
script which only start only connection.

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of
Firstworks/4access
Sent: July 20, 2005 04:54 PM
To: sql...@li...
Subject: Re: [Sqlrelay-discussion] Multiple connection


If there's only 1 sqlr-connection-oracle7 process running then that does
mean that only 1 connection is available.  Your sqlrelay.conf file looks
right though, 4 connections should start and grow by 2 for a maximum of
10.  Could you send me the output of sqlr-start and ps -efa | grep sqlr?

Dave

On Wed, 2005-07-20 at 15:37 -0500, Guo, Jinnan wrote:
> David,
>=20
> I want to set up the sqlrelay connect to the database with 4
> connections initially and grow by 2 until 10 connections reached.
> After startup, I can only see one sqlr-connection process running,
> does that mean I have only one connection available? Could you please
> check my conf file and tell me what is wrong?
>=20
> <?xml version=3D"1.0"?>=20
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
>=20
> <instances>
>=20
>         <instance id=3D"example" port=3D"5559"
> socket=3D"/usr/local/firstworks/var/sqlrelay/tmp/socket.file"
> dbase=3D"oracle7" connections=3D"4" maxconnections=3D"10" =
maxqueuelength=3D"5"
> growby=3D"2" ttl=3D"60" endofsession=3D"commit" sessiontimeout=3D"600"
> runasuser=3D"nobody" runasgroup=3D"nobody" cursors=3D"2" =
authtier=3D"listener"
> handoff=3D"pass" deniedips=3D"" allowedips=3D"" debug=3D"none">
>=20
>                 <users>=20
>                         <user user=3D"" password=3D""/>=20
>                 </users>=20
>                 <connections>=20
>                         <connection connectionid=3D"db1"
> string=3D"user=3Dabc;password=3Ddef;oracle_sid=3Dmydb.world;" =
metric=3D"1"/>
>=20
>                 </connections>=20
>         </instance>
>=20
> </instances>
>=20



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. =
http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] Multiple connection

[Firstworks/4access <dav...@fi...>]

If there's only 1 sqlr-connection-oracle7 process running then that does
mean that only 1 connection is available.  Your sqlrelay.conf file looks
right though, 4 connections should start and grow by 2 for a maximum of
10.  Could you send me the output of sqlr-start and ps -efa | grep sqlr?

Dave

On Wed, 2005-07-20 at 15:37 -0500, Guo, Jinnan wrote:
> David,
> 
> I want to set up the sqlrelay connect to the database with 4
> connections initially and grow by 2 until 10 connections reached.
> After startup, I can only see one sqlr-connection process running,
> does that mean I have only one connection available? Could you please
> check my conf file and tell me what is wrong?
> 
> <?xml version="1.0"?> 
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> 
> <instances>
> 
>         <instance id="example" port="5559"
> socket="/usr/local/firstworks/var/sqlrelay/tmp/socket.file"
> dbase="oracle7" connections="4" maxconnections="10" maxqueuelength="5"
> growby="2" ttl="60" endofsession="commit" sessiontimeout="600"
> runasuser="nobody" runasgroup="nobody" cursors="2" authtier="listener"
> handoff="pass" deniedips="" allowedips="" debug="none">
> 
>                 <users> 
>                         <user user="" password=""/> 
>                 </users> 
>                 <connections> 
>                         <connection connectionid="db1"
> string="user=abc;password=def;oracle_sid=mydb.world;" metric="1"/>
> 
>                 </connections> 
>         </instance>
> 
> </instances>
>