sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] Connecting to sql relay from mysql client

[CyberGod <cyb...@li...>]

Hi,
I successfully installed, configured and run the software. The only 
problem I have now is how to connect to it form a mysql client. Port 
9000 is open (defined in the config file), the daemons are connected to 
the remote MySQL server based on host ip, user, pass and table and all 
services are running. I can remotely connect directly to the MySQL 
server using the same settings with the mysql command so its not a 
connectivity or mysql issue. Any suggestions where I can find log files 
if any?
Please advice how to test this setup with mysql client (I tried 
something like this: mysql --port=9000 --host=10.0.0.1 -pc@password, 
where the host ip is the ip of the server that sql-relay is running on).

Here's my config file:

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

<instances>
        <!-- Regular SQL Relay Instance -->
        <instance id="example" port="9000" socket="/tmp/example.socket" 
dbase="mysql" connections="3" maxconnections="15" maxqueuelength="5" 
growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
handoff="pass" deniedips="" allowedips="" debug="none" 
maxquerysize="65536" maxstringbindvaluelength="4000" 
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" 
listenertimeout="0">
                <users>
                        <user user="root" password="pass"/>
                </users>
                <connections>
                        <connection connectionid="db1" 
string="user=root;password=croot;db=test;host=10.0.0.10;port=3306;" 
metric="1" behindloadbalancer="no"/>
                </connections>
        </instance>
</instances>

Running processes:

11490 ?        Ss     0:00 sqlr-listener -id example -config 
/usr/local/firstworks/etc/sqlrelay.conf
11492 ?        Ss     0:00 sqlr-connection-mysql -id example 
-connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
11494 ?        Ss     0:00 sqlr-connection-mysql -id example 
-connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
11496 ?        Ss     0:00 sqlr-connection-mysql -id example 
-connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
11502 ?        Ss     0:00 sqlr-cachemanager


Thanks.
Konstantin

Re: [Sqlrelay-discussion] MySQL and Sqlrelay

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

If mysql is installed from the RPM, the configure script should
automatically detect it.  Make sure that the mysql devel RPM is also
installed.  It should be called mysql-devel or something similar.

Dave
dav...@fi...

On Thu, 2007-06-07 at 07:44 -0500, CyberGod wrote:
> Hello,
> I have MySQL5  installed (from a RPM binary) on my server (CentOS 5) and 
> it's working but the configure script for sqlrelay cannot find it. Any 
> suggestions to where should I point the --with-mysql-prefix option?
> 
> Thanks.
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] MySQL and Sqlrelay

[CyberGod <cyb...@li...>]

Hello,
I have MySQL5  installed (from a RPM binary) on my server (CentOS 5) and 
it's working but the configure script for sqlrelay cannot find it. Any 
suggestions to where should I point the --with-mysql-prefix option?

Thanks.

Re: [Sqlrelay-discussion] Rudiments gives an error during the ./configure

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

Could you email me the config.log file that the configure script
created.  It should have enough info in it to figure out what happened.

David Muse
dav...@fi...

On Wed, 2007-06-06 at 11:18 -0500, CyberGod wrote:
> I get this error when I try to ./configure Rudiments:
> 
> checking for socket libraries... configure: error: no combination of 
> networking libraries was found.
> 
> Any suggestions? I have CentOS 5.
> 
> Thanks
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] Rudiments gives an error during the ./configure

[CyberGod <cyb...@li...>]

I get this error when I try to ./configure Rudiments:

checking for socket libraries... configure: error: no combination of 
networking libraries was found.

Any suggestions? I have CentOS 5.

Thanks

Re: [Sqlrelay-discussion] spool

[Carles P. i E. <ca...@pi...>]

Hi!

On May/22/2007, David Muse wrote:
> Sorry, SQL Relay does not currently do that.  It's a neat idea though
> and probably wouldn't be too hard to implement.  I'll put it on the TODO
> list, but I'm not sure when I'll get around to it.

thanks for the rapid response! 
I will have to do it by hand in application level, would be fine to have
this in next versions.

Thank you again,

-- 
Carles Pina i Estany		GPG id: 0x8CBDAE64
	http://pinux.info	Manresa - Barcelona

Re: [Sqlrelay-discussion] spool

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

Sorry, SQL Relay does not currently do that.  It's a neat idea though
and probably wouldn't be too hard to implement.  I'll put it on the TODO
list, but I'm not sure when I'll get around to it.

David Muse
dav...@fi...

On Wed, 2007-05-23 at 01:26 +0200, Carles Pina i Estany wrote:
> Hello,
> 
> I am not using sqlrelay (yet) but I am trying to know if it is possible
> to do one thing:
> 
> I need that one application doesn't block when application is doing
> "updates" or "inserts", even if there is no connection to Mysql server.
> 
> Yes, I could control in application logic, but would be faster for me to
> use sqlrelay.
> 
> My architecture would be typical:
> 
> (Python code) ---- sqlrelay -------???------- mysqlserver
> 
> If "???" connection is not setted up, sqlrelay should accept
> update/inserts and send to server when connection to mysqlserver is
> available again.
> 
> Is this thing done by sqlrelay by default? 
> 
> Thank you very much and excuse me for so basic question, I have not
> found in sqlrelay documentation (probably my blame),
> 

[Sqlrelay-discussion] spool

[Carles P. i E. <ca...@pi...>]

Hello,

I am not using sqlrelay (yet) but I am trying to know if it is possible
to do one thing:

I need that one application doesn't block when application is doing
"updates" or "inserts", even if there is no connection to Mysql server.

Yes, I could control in application logic, but would be faster for me to
use sqlrelay.

My architecture would be typical:

(Python code) ---- sqlrelay -------???------- mysqlserver

If "???" connection is not setted up, sqlrelay should accept
update/inserts and send to server when connection to mysqlserver is
available again.

Is this thing done by sqlrelay by default? 

Thank you very much and excuse me for so basic question, I have not
found in sqlrelay documentation (probably my blame),

-- 
Carles Pina i Estany		GPG id: 0x8CBDAE64
	http://pinux.info	Manresa - Barcelona

[Sqlrelay-discussion] sqlrelay server failover

[caballerociucciu <cab...@li...>]

Hi all,

I'm trying to use the sqlrelay server failover feature.

I dont't have a Load Balancer so I've implemented SQL Relay server failover
using Round Robin DNS and

it works fine! 

I don't want to overload the DNS, asking him to resolve the "SQLRelay
virtual server" for every sqlrelay connection the client needs.

I've checked that even if I have the nscd deamon running on the client
calling the sqlrelay server, the DNS is always called, so it seems that the
nscd cache is not used by sqlrelay.

Have I missed something?

Thank you.

Ciao.

--Stefano

[Sqlrelay-discussion] Using SQL Relay with MySQL Cluster

[Masao K. <ma...@gm...>]

I'm trying to use SQL Relay 0.38 with MySQL Cluster 5.1.17, but only
the SELECT statements work.  The INSERTs succeed with the
sqlrcur_sendQuery function, but no row is actually inserted into the
database, even though the autoincrement value still gets incremented.

I tested my SQL Relay setup with a normal MySQL 4.1.20 database and it
works fine.

Is this a limitation of SQL Relay and a cluster?  or is SQL Relay not
compatible with MySQL 5.1?

What versions of SQL Relay and MySQL Cluster are compatible?

Thanks in advance,

Masao

Re: [Sqlrelay-discussion] What to do with "Failed to get a cursor id."?

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

Usually it means that the SQL Relay connection daemon crashed.  But it's
rare to see it.  Is that the only query it does it with?  Try running
SQL Relay with only 1 db connection and see if afterward the
sqlr-connection-mysql process is still running.  If so, see if other
queries work, or if they all start generating errors.

David Muse
dav...@fi...

On Fri, 2007-05-04 at 14:43 -0700, Masao Kitamura wrote:
> I've gotten my SQLRelay to work previously, but today I found an error
> that I can't find the answer to on Google or in the list archives (the
> SF.net search always times out).
> 
> Does anyone know what this error means?
> 
> # query -id mysqltest "show tables;"
> Failed to get a cursor id.
>  A network error may have ocurred.
> 
> I've tried killing all my SQLRelay processes and restarting, but I
> still get the same error.
> 
> Thanks in advance,
> 
> Masao
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] What to do with "Failed to get a cursor id."?

[Masao K. <ma...@gm...>]

I've gotten my SQLRelay to work previously, but today I found an error
that I can't find the answer to on Google or in the list archives (the
SF.net search always times out).

Does anyone know what this error means?

# query -id mysqltest "show tables;"
Failed to get a cursor id.
 A network error may have ocurred.

I've tried killing all my SQLRelay processes and restarting, but I
still get the same error.

Thanks in advance,

Masao

Re: [Sqlrelay-discussion] Trouble configuring SQL Relay with MySQL support

[Masao K. <ma...@gm...>]

This worked thanks to both of you.

% rpm -i MySQL-devel-5.1.17-0.glibc23.i386.rpm

>
> Probably the dev package for mysql.
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Trouble configuring SQL Relay with MySQL support

[Seth M. <se...@ro...>]

Masao Kitamura wrote:
> I am new to SQL Relay and don't see an easy way to search the mailing
> list archives, so here's my question...
>
> After everything I've tried, I keep getting this:
>
> % ./configure --with-mysql-prefix=/usr/share/mysql
>
> ***** MySQL ******************
> configure: WARNING: MySQL support will not be built.
> ******************************
>
> I've tried many variations on the mysql-prefix and nothing works.
>
> I successfully installed Rudiments prior to this.
>
> MySQL is definitely up and running.
>
> sqlrelay-0.38.tar.gz
> MySQL-server-5.1.17-0.glibc23.i386.rpm
> Linux x86 FC4
>
> What am I missing?
>
>   

Probably the dev package for mysql.

Re: [Sqlrelay-discussion] Trouble configuring SQL Relay with MySQL support

[Gabriel M. <gmi...@gm...>]

On 5/2/07, Masao Kitamura <ma...@gm...> wrote:
> I am new to SQL Relay and don't see an easy way to search the mailing
> list archives, so here's my question...
>
> After everything I've tried, I keep getting this:
>
     you need the client development librariy (which includes the
headers and libraries), while i am not a fedora champ, for debian and
many others they are in /usr/include. you need to have similar output
such as this ...

$ locate mysql.h
/usr/include/mysql/mysql.h

ls /usr/include/mysql/
errmsg.h    my_alloc.h   my_getopt.h  my_no_pthread.h  mysqld_error.h
mysql_version.h  raid.h         sslopt-longopts.h
keycache.h  my_config.h  my_global.h  my_pthread.h     mysql_embed.h
my_sys.h         sql_common.h   sslopt-vars.h
m_ctype.h   my_dbug.h    my_list.h    mysql_com.h      mysql.h
my_xml.h         sql_state.h    typelib.h
m_string.h  my_dir.h     my_net.h     mysqld_ername.h  mysql_time.h
ndb              sslopt-case.h

$ locate libmysqlclient
/usr/lib/libmysqlclient.a
/usr/lib/libmysqlclient.la
/usr/lib/libmysqlclient_r.a
/usr/lib/libmysqlclient_r.la
/usr/lib/libmysqlclient_r.so
/usr/lib/libmysqlclient_r.so.15
/usr/lib/libmysqlclient_r.so.15.0.0
/usr/lib/libmysqlclient.so
/usr/lib/libmysqlclient.so.15
/usr/lib/libmysqlclient.so.15.0.0

-- 
Gabriel Millerd

[Sqlrelay-discussion] Trouble configuring SQL Relay with MySQL support

[Masao K. <ma...@gm...>]

I am new to SQL Relay and don't see an easy way to search the mailing
list archives, so here's my question...

After everything I've tried, I keep getting this:

% ./configure --with-mysql-prefix=/usr/share/mysql

***** MySQL ******************
configure: WARNING: MySQL support will not be built.
******************************

I've tried many variations on the mysql-prefix and nothing works.

I successfully installed Rudiments prior to this.

MySQL is definitely up and running.

sqlrelay-0.38.tar.gz
MySQL-server-5.1.17-0.glibc23.i386.rpm
Linux x86 FC4

What am I missing?

Thanks in advance,

Masao

[Sqlrelay-discussion] sqlrelay-mysql mapping

[Sekou A. <sek...@to...>]

It appears that the query tag in sqlrelay.conf file is CASE SENSITIVE.
I have a working config where DML/DDL are going to "master" and other
queries are going to "slave"

however I notice that the reults of the select query when presented as a
list of comma separated values is actually merging the reults of two
columns.

This is causing UPDATES where columns are presented with wrong values eg
results like=20

NULLNULL instead of NULL,NULL
NULL"0" instead of NULL,"0"
NULL"" instead of NULL,""

Is there some way to resolve this, it appears to be formating related=20

			S. Sekou Abodunrin=20
		=09




This email is confidential and may also be privileged. If you are not =
the intended recipient please notify us immediately by telephoning +44 =
(0)20 7452 5300 or email pos...@to.... You should not copy =
it or use it for any purpose nor disclose its contents to any other =
person. Touch Local cannot accept liability for statements made which =
are clearly the sender's own and are not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300

Re: [Sqlrelay-discussion] sqlrelay INSERTS going to "slave"

[Chris C. <cc...@gm...>]

Sekou,

You need to tweak your regexes, those will never match your queries

try:

                               <query pattern="^\s*select.*from.*"/>
                               <query pattern="^\s*insert\s+into.*"/>
                               <query pattern="^\s*update.*"/>
                               <query pattern="^\s*delete\s+from.*"/>
                               <query pattern="^\s*drop\s+table.*"/>
                               <query pattern="^\s*create\s+table.*"/>

Also bear in mind that with that select rule, no select queries will
ever get sent to your slave.

 - CC

On 4/27/07, Sekou Abodunrin <sek...@to...> wrote:
>
> Hi,
>
> I am running sqlrelay-0.38
> I have sqlrelay in routing and filtering mode. It is configured to route
> DML/DDL queries to "master" and other quries to "slave"
> all queries including INSERTS are going to the "slave" and nothing is going
> to "master"
>
> find below my router definition:
>
>
>         <router>
>                         <!-- he haw haw sekou! this will send all DML/DDL
> queries to "master"  -->
>                         <route host="" port="" socket="/tmp/master.socket"
> user="master" password="masterpass">
>                                 <query pattern="^\s*select\s+.*\s+from\s+"/>
>                                 <query pattern="^\s*insert\s+into\s+"/>
>                                 <query pattern="^\s*update\s+"/>
>                                 <query pattern="^\s*delete\s+from\s+"/>
>                                 <query pattern="^\s*drop\s+table\s+"/>
>                                 <query pattern="^\s*create\s+table\s+"/>
>                         </route>
>                         <!-- grab a doughnut ... this sends all other
> queries to "slave" -->
>                         <route host="" port="" socket="/tmp/slave.socket"
> user="slave" password="slavepass">
>                                 <query pattern=".*"/>
>                         </route>
>                 </router>
>
> Any ideas?
>
>                         S. Sekou Abodunrin
>
>
> This email is confidential and may also be privileged. If you are not the intended recipient please notify us immediately by telephoning +44 (0)20 7452 5300 or email pos...@to.... You should not copy it or use it for any purpose nor disclose its contents to any other person. Touch Local cannot accept liability for statements made which are clearly the sender's own and are not made on behalf of the firm.
>
> Touch Local Limited
> Registered Number: 2885607
> VAT Number: GB896112114
> Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
> +44 (0)20 7452 5300
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

[Sqlrelay-discussion] sqlrelay INSERTS going to "slave"

[Sekou A. <sek...@to...>]

Hi,

I am running sqlrelay-0.38
I have sqlrelay in routing and filtering mode. It is configured to route
DML/DDL queries to "master" and other quries to "slave"
all queries including INSERTS are going to the "slave" and nothing is =
going
to "master"

find below my router definition:


	<router>
                        <!-- he haw haw sekou! this will send all =
DML/DDL
queries to "master"  -->
                        <route host=3D"" port=3D"" =
socket=3D"/tmp/master.socket"
user=3D"master" password=3D"masterpass">
                                <query =
pattern=3D"^\s*select\s+.*\s+from\s+"/>
                                <query =
pattern=3D"^\s*insert\s+into\s+"/>
                                <query pattern=3D"^\s*update\s+"/>
                                <query =
pattern=3D"^\s*delete\s+from\s+"/>
                                <query pattern=3D"^\s*drop\s+table\s+"/>
                                <query =
pattern=3D"^\s*create\s+table\s+"/>
                        </route>
                        <!-- grab a doughnut ... this sends all other
queries to "slave" -->
                        <route host=3D"" port=3D"" =
socket=3D"/tmp/slave.socket"
user=3D"slave" password=3D"slavepass">
                                <query pattern=3D".*"/>
                        </route>
                </router>

Any ideas?

			S. Sekou Abodunrin=20
		=09

This email is confidential and may also be privileged. If you are not =
the intended recipient please notify us immediately by telephoning +44 =
(0)20 7452 5300 or email pos...@to.... You should not copy =
it or use it for any purpose nor disclose its contents to any other =
person. Touch Local cannot accept liability for statements made which =
are clearly the sender's own and are not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300

[Sqlrelay-discussion] sqlrelay - mysql returns 10 rows always

[Sekou A. <sek...@to...>]

I have configured sqlrelay in the following scenario:

router instance routes/filters queries to two instances, =
sqlrelay-port9001
takes updates,inserts and all other type queries go to sqlrelay-port9002
mysql queries to sqlrelay-port9001 & sqlrelay-port9002 return full =
results
but mysql queries to router returns 10 rows of results no matter the =
query
type.

sqlrelay-port9001
<instance id=3D"master" port=3D"9001" socket=3D"/tmp/master.socket" =
dbase=3D"mysql"
connections=3D"12" maxconnections=3D"30" maxqueuelength=3D"10" =
growby=3D"2" ttl=3D"60"
endofsession=3D"commit" sessiontimeout=3D"600" runasuser=3D"nobody"
runasgroup=3D"nobody" cursors=3D"120" authtier=3D"listener" =
handoff=3D"pass"
maxquerysize=3D"655360" maxstringbindvaluelength=3D"40000"
maxlobbindvaluelength=3D"716800" idleclienttimeout=3D"-1">

sqlrelay-port9002
<instance id=3D"slave" port=3D"9002" socket=3D"/tmp/slave.socket" =
dbase=3D"mysql"
connections=3D"12" maxconnections=3D"60" maxqueuelength=3D"10" =
growby=3D"2" ttl=3D"60"
endofsession=3D"commit" sessiontimeout=3D"600" runasuser=3D"nobody"
runasgroup=3D"nobody" cursors=3D"20" authtier=3D"listener" =
handoff=3D"pass"
maxquerysize=3D"655360" maxstringbindvaluelength=3D"40000"
maxlobbindvaluelength=3D"716800" idleclienttimeout=3D"-1">

ROUTER
<instance id=3D"router" port=3D"9000" socket=3D"/tmp/router.socket" =
dbase=3D"router"
connections=3D"18" maxconnections=3D"90" maxqueuelength=3D"5" =
growby=3D"2" ttl=3D"60"
endofsession=3D"commit" sessiontimeout=3D"600" runasuser=3D"nobody"
runasgroup=3D"nobody" cursors=3D"10" authtier=3D"listener" =
handoff=3D"pass"
maxquerysize=3D"655360" maxstringbindvaluelength=3D"40000"
maxlobbindvaluelength=3D"716800" idleclienttimeout=3D"-1">

Any ideas?
			S. Sekou Abodunrin=20
		=09




This email is confidential and may also be privileged. If you are not =
the intended recipient please notify us immediately by telephoning +44 =
(0)20 7452 5300 or email pos...@to.... You should not copy =
it or use it for any purpose nor disclose its contents to any other =
person. Touch Local cannot accept liability for statements made which =
are clearly the sender's own and are not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300

Re: [Sqlrelay-discussion] courier w/ sqlrelay

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

On Tue, 2007-04-24 at 17:01 -0500, Gabriel Millerd wrote:
> On 4/24/07, David Muse <dav...@fi...> wrote:
> > I've heard of courier-auth-postfix, the pop-before-smtp solution for
> > postfix where pop logins are recorded in mysql.  Is this what you're
> > referring to?
> >
>    This is more for posterity than for aiding me, I have moved on to
> Dovecot. Courier is nice for plug-in play, but scaled horribly.
> 
>    Courier has its own auth-daemon for username, password, uid, gid,
> homedir, attrib lookups. All of its products (pop3, pop3s, imap,
> imap3, and mta, a webmail, a groupware piece) use this daemon. It also
> has its own flavor of "daemon tools" where these pieces are   cascaded
> in a series of subprocesses. Where a ps -ef command would give you the
> following, which I edited for easy of viewing:
> 
> /usr/sbin/courierlogger /usr/lib/courier/authlib/authdaemond.
>   \_ /usr/lib/courier/authlib/authdaemond.mysql
>   \_ /usr/lib/courier/authlib/authdaemond.mysql
>   \_ /usr/lib/courier/authlib/authdaemond.mysql
> 
> The actual process /usr/lib/courier/authlib/authdaemond.mysql is the
> only part that is linked to libmysqlclient. So using the LD_PRELOAD
> method we would edit its parent process
> "/usr/lib/courier/authlib/authdaemond" and export the correct library
> that corresponds with what we found from the ldd output. And when we
> get frustrated we can edit all the scripts all the way back to the
> "/etc/init.d" script with the same results. It doesn't work, perhaps
> flushing its environment in some way?

Weird.  Yeah, maybe it is.  That would make sense.  Can't think of
anything else that would cause it.

> 
> I have a few products using this method and the results are amazing.
> Obviously an underutilized / promoted product.
> 

Just curious, what other products have you used it with?

Dave

Re: [Sqlrelay-discussion] courier w/ sqlrelay

[Gabriel M. <gmi...@gm...>]

On 4/24/07, David Muse <dav...@fi...> wrote:
> I've heard of courier-auth-postfix, the pop-before-smtp solution for
> postfix where pop logins are recorded in mysql.  Is this what you're
> referring to?
>
   This is more for posterity than for aiding me, I have moved on to
Dovecot. Courier is nice for plug-in play, but scaled horribly.

   Courier has its own auth-daemon for username, password, uid, gid,
homedir, attrib lookups. All of its products (pop3, pop3s, imap,
imap3, and mta, a webmail, a groupware piece) use this daemon. It also
has its own flavor of "daemon tools" where these pieces are   cascaded
in a series of subprocesses. Where a ps -ef command would give you the
following, which I edited for easy of viewing:

/usr/sbin/courierlogger /usr/lib/courier/authlib/authdaemond.
  \_ /usr/lib/courier/authlib/authdaemond.mysql
  \_ /usr/lib/courier/authlib/authdaemond.mysql
  \_ /usr/lib/courier/authlib/authdaemond.mysql

The actual process /usr/lib/courier/authlib/authdaemond.mysql is the
only part that is linked to libmysqlclient. So using the LD_PRELOAD
method we would edit its parent process
"/usr/lib/courier/authlib/authdaemond" and export the correct library
that corresponds with what we found from the ldd output. And when we
get frustrated we can edit all the scripts all the way back to the
"/etc/init.d" script with the same results. It doesn't work, perhaps
flushing its environment in some way?

I have a few products using this method and the results are amazing.
Obviously an underutilized / promoted product.

-- 
Gabriel Millerd

Re: [Sqlrelay-discussion] courier w/ sqlrelay

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

I've heard of courier-auth-postfix, the pop-before-smtp solution for
postfix where pop logins are recorded in mysql.  Is this what you're
referring to?

If so, sorry, I haven't used it, but I'd bet that the
drop-in-replacement library for mysql would work with it.  Does postfix
run as a daemon, or is it called by sendmail?  If it's called by
sendmail, you could either add an LD_PRELOAD prior to launching the
sendmail daemon, or you could move postfix to postfix.bin and write a
wrapper script like:

#!/bin/sh

export LD_PRELOAD=\
/usr/local/firstworks/lib/libmysql50sqlrelay-0.39.so.1.0.0
postfix.bin $@

and name it postfix.

Either one should work.

Dave
dav...@fi...

On Sun, 2007-04-22 at 20:45 -0500, Gabriel Millerd wrote:
> Has anyone configured courier-auth to work with sqlrelay? Specifically
> a drop in replacement
> 
> If your at all familiar with courier-auth, its a daisy chain of
> processes, from /etc/init.d/ to a script in /usr/sbin which starts a
> logging wrapper that is exec'ed that starts the actual auth process
> ... which uses a lib that actually calls libmysql (the only part that
> has a ldd that is to mysql).
> 
> I have been trying to extend this another layer to get a LD_PRELOAD in
> that will get inherited properly rather than recompile. Which I am not
> sure will help really.
> 
> I am running a debian installation if that is of interest or helps.
> 

[Sqlrelay-discussion] courier w/ sqlrelay

[Gabriel M. <gmi...@gm...>]

Has anyone configured courier-auth to work with sqlrelay? Specifically
a drop in replacement

If your at all familiar with courier-auth, its a daisy chain of
processes, from /etc/init.d/ to a script in /usr/sbin which starts a
logging wrapper that is exec'ed that starts the actual auth process
... which uses a lib that actually calls libmysql (the only part that
has a ldd that is to mysql).

I have been trying to extend this another layer to get a LD_PRELOAD in
that will get inherited properly rather than recompile. Which I am not
sure will help really.

I am running a debian installation if that is of interest or helps.

-- 
Gabriel Millerd

[Sqlrelay-discussion] Memory leak in sqlr-connection-db2?

[Denis C. <aka...@gm...>]

Hello


I have a strange situtation with running SQLRelay (both 0.37 and 0.38)
in a front of DB2/Linux (V8 FP14). It looks like SQLRelay connection
daemons leak in about 400 bytes per second, so all my memory ends up
in about 5 hours. I've been runing about 350 simultaneous connections,
and they start from 2GB of ram and ends at about 12GB of ram and then
server crashes. I also know that the leak is definitely on the
SQLRelay side, cause i've tried to stop all applications one-by-one
and memory was freed only after SQLRelay shutdown. How can i fix this?