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 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 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>