<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=087545914-01032007>hello
all</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=087545914-01032007></SPAN></FONT> </DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>I am loading
the following 10 modules that use an oracle database through unixodbc.
</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2>modparam("usrloc|acc", "db_url", "unixodbc://<SPAN
class=087545914-01032007>user</SPAN>:<SPAN
class=087545914-01032007>pass</SPAN>@/OracleODBC-10g")<BR>modparam("auth_db|alias_db|uri_db|group|permissions|lcr|domain", "db_url",
"unixodbc://<SPAN
class=087545914-01032007>user:pass</SPAN>@/OracleODBC-10g")<BR>modparam("avpops",
"avp_url", "unixodbc://<SPAN class=087545914-01032007>user</SPAN>:<SPAN
class=087545914-01032007>pass</SPAN>@/OracleODBC-10g")<BR>
<DIV><SPAN class=087545914-01032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>In my config I have
fork=yes and tcp is enabled</FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>With 5 listen
addresses </FONT></SPAN><SPAN class=087545914-01032007><FONT face=Arial
size=2>and </FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007></SPAN><SPAN class=087545914-01032007><FONT
face=Arial size=2>children=1 : 10 connections in the
database.</FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>children=2 : 16
connections </FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>children=3 :
22 connections </FONT></SPAN></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=087545914-01032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=087545914-01032007>With 4 listen
address and </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=087545914-01032007>
<DIV><SPAN class=087545914-01032007></SPAN><SPAN class=087545914-01032007><FONT
face=Arial size=2>children=1 : 9 connections in the
database.</FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>children=2 : 14
connections </FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>children=3
: 19 connections</FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=087545914-01032007><FONT face=Arial size=2>Could anyone help me
understand the relation between listen addresses, number of children and number
of modules that use the db?</FONT></SPAN></DIV>
<DIV><SPAN class=087545914-01032007>Also these numbers are the same whether I
use MySQL both through the mysql module and the unixodbc module. Looking into
the code, it seems like there is connection pooling into the unixodbc module.
However I get all these connections. What am I doing wrong?</SPAN></DIV>
<DIV><SPAN class=087545914-01032007></SPAN> </DIV>
<DIV><SPAN class=087545914-01032007>thank you for any help</SPAN></DIV>
<DIV><SPAN class=087545914-01032007></SPAN> </DIV>
<DIV><SPAN class=087545914-01032007>George</SPAN></DIV>
<DIV><SPAN
class=087545914-01032007></SPAN> </DIV></SPAN></FONT></DIV></BODY><!--[object_id=#altectelecoms.gr#]--><FONT face=Tahoma size=2><FONT color=#0000ff>
<H1><FONT face="Arial Greek" color=#c0c0c0 size=2><SPAN lang=EN-GB>Disclaimer</SPAN></FONT></H1>
<P class=MsoNormal style="MARGIN: 5pt 0cm; mso-layout-grid-align: none"><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US">The information in this e-mail and any attachments is confidential. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are </SPAN><SPAN lang=EN-GB style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US">the</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US"> intended recipient or his/her representative you are not authorized to, and must not, read, copy, distribute, use or retain this message or any part of it. E-mail transmission cannot be</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US"> </SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US">guaranteed to be secure or error-free as information could be</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US"> </SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US">intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.</SPAN><SPAN lang=EN-GB style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P></FONT></FONT></HTML>