Hi Daniel,<br><br>The result from the test:<br><br>ERROR:db_oracle:get_rows: driver: ORA-24330: internal OCI error<br>ERROR:db_oracle:db_oracle_store_result: error while converting rows<br>ERROR:core:db_do_raw_query: error while storing result<br>
ERROR:sqlops:sql_do_query: cannot do the query<br><br>We will see it in 2010 !<br><br>Happy new year!!<br><br>Alexandros<br><br><br><br><div class="gmail_quote">On Thu, Dec 31, 2009 at 6:49 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">miconda@gmail.com</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;">
<div 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<div><div></div><div class="h5"><br>
<br>
<br>
On 12/31/09 11:51 AM, alex pappas wrote:
</div></div><blockquote type="cite"><div><div></div><div class="h5">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" target="_blank">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><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><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><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>
</div></div><pre><fieldset></fieldset>
_______________________________________________
Kamailio (OpenSER) - Users mailing list
<div class="im"><a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
</div><a href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a></pre>
</blockquote><div class="im">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
* <a href="http://www.asipto.com/" target="_blank">http://www.asipto.com/</a>
</pre>
</div></div>
</blockquote></div><br>