<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hello,<br>
<br>
seems that connaction handle was not initialized for raw queries. I did
a fix, but I had no oracle libs or server to test. Try to get last svn
branch 1.5 and see if it is better now. If not, will fix next year.<br>
<br>
A great 2010 for you as well,<br>
Daniel<br>
<br>
<br>
On 12/31/09 11:51 AM, alex pappas wrote:
<blockquote
cite="mid:88b5e74c0912310251j31fe526fp554c09ed8077dfe2@mail.gmail.com"
type="cite">Hi henning,<br>
<br>
I'm happy you enjoyed the beer. ;-)<br>
<br>
I'm attaching some back traces from the core dump. I don't know C
programming so I can't go further than that :-( <br>
<br>
I will try also the odbc driver.<br>
<br>
Thank you for the help<br>
Best wishes for 2010<br>
<br>
Alex<br>
<br>
<br>
<br>
<br>
<div class="gmail_quote">On Thu, Dec 31, 2009 at 12:14 PM, Henning
Westerholt <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On
Thu, December 31, 2009 10:55 am, alex pappas wrote:<br>
> [..]<br>
<br>
Hey Alex,<br>
<br>
the restaurant was nice, the beer is indeed good there. :-)<br>
<div class="im"><br>
> I just manage to connect with oracle with the following URL :<br>
><br>
> modparam("sqlops","sqlcon","ca=>oracle://<a
moz-do-not-send="true" href="http://user:pass@alex.gr/cid_name.alex.gr"
target="_blank">user:pass@alex.gr/cid_name.alex.gr</a><br>
> ")<br>
<br>
</div>
Good that you managed to find the correct syntax.<br>
<div class="im"><br>
> Now I run into other problems. The same query that from
./kamailio_orasel<br>
> give me result, when I try that from kamailio.cfg I get an error
and<br>
> after that the system is getting very high load.<br>
<br>
</div>
This is probably caused from a segfault which caused a core dump. :-(<br>
After this the system is busy to write the core file with the memory
dump<br>
to the disk, which can get really huge depending on the process number
and<br>
shared memory size. Do you managed to find some core dump? They should<br>
located in the working directory of the server.<br>
<div class="im"><br>
> The error is :<br>
><br>
> kernel: kamailio[12442]: segfault at 0000000000000010 rip
00002b1b42952764<br>
> rsp 00007fff6b144d30 error 4<br>
><br>
> Does anyone had the same issue ?<br>
<br>
</div>
The oracle module is probably one of the DB modules which has got the<br>
least testing, due its dependencies. But i think they are some people<br>
which successful using it. The next step would be to investigate the<br>
backtrace from the core dump.<br>
<br>
Another option would be to setup an unixodbc connection on the DB side
and<br>
then connect which the db_unixodbc module instead.<br>
<br>
Regards,<br>
<font color="#888888"><br>
Henning<br>
<br>
</font></blockquote>
</div>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Kamailio (OpenSER) - Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
<a class="moz-txt-link-freetext" href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
* <a class="moz-txt-link-freetext" href="http://www.asipto.com/">http://www.asipto.com/</a>
</pre>
</body>
</html>