<!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=797070410-05032007>Hello,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>First of all
congratulations to everyone involved in the new release. I haven't been
able to get my hands on it yet, but just reading about it makes me very excited.
Great job!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>I would like to
address the issue of Openser and Oracle working together. We are currently using
Openser with a local MySQL. Our main database is Oracle and we are just copying
data to MySQL so that Openser can work. This is a little difficult to maintain
so I thought I would try to make Openser use directly our Oracle. Of course I
ran into a number of issues. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>1. modules/acc and
unixodbc. The acc_db_request() was not working because inserting a string in a
date column does not work with Oracle. So, I had to change functions time2str()
and time2odbc() in order to make this work. Also had to change acc.c to treat
column time as DB_TIME instead of DB_STR (I think this could be treated as a
bug).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>2. modules/lcr. The
query uses char_length() and rand() which I had to replace with lengthc() and
dbms_random.value. Should these be modules params?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>3.
modules/avpops. All issues were resolved by config changes and replacing
avp_db_load() with avp_db_query(). </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>4. modules/auth_db,
alias_db, uri_db, group. Since MySQL is case insensitive and Oracle is not, I
made changes in the code to use raw_query() instead of query(). All queries have
to be in the form "select ... from ... where username=upper(...)"
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>I would be happy to
provide patches and help in any way in order to make this migration easier in
the future. However I am not sure whether my changes are general enough for
everybody to use. So, do you have any suggestions about how to deal with these
issues?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>Another issue that
came up is the number of connections from Openser to the database. In our
case, listening to five interfaces, with tcp disabled and children=5,
we get 28 connections to DB which is a great waste of resources. From those five
interfaces, one is receiving the bulk of traffic and the rest receive minimal
traffic. Since each child has its own connection, then what is the purpose of
connection pooling? How difficult would it be to have a common connection pool
for all children?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=797070410-05032007>sorry for the long
email and thank you in advance for any answer.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007>George</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=797070410-05032007></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>