On Thu, Dec 31, 2009 at 6:49 PM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

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.

A great 2010 for you as well,
Daniel

On 12/31/09 11:51 AM, alex pappas wrote:
Hi henning,

I'm happy you enjoyed the beer. ;-)

I'm attaching some back traces from the core dump. I don't know C programming so I can't go further than that :-(

I will try also the odbc driver.

Thank you for the help
Best wishes for 2010

Alex

On Thu, Dec 31, 2009 at 12:14 PM, Henning Westerholt <henning.westerholt@1und1.de> wrote:

On Thu, December 31, 2009 10:55 am, alex pappas wrote:
> [..]

Hey Alex,

the restaurant was nice, the beer is indeed good there. :-)

> I just manage to connect with oracle with the following URL :
>
> modparam("sqlops","sqlcon","ca=>oracle://user:pass@alex.gr/cid_name.alex.gr
> ")

Good that you managed to find the correct syntax.

> Now I run into other problems. The same query that from ./kamailio_orasel
> give me result, when I try that from kamailio.cfg I get an error and
> after that the system is getting very high load.

This is probably caused from a segfault which caused a core dump. :-(
After this the system is busy to write the core file with the memory dump
to the disk, which can get really huge depending on the process number and
shared memory size. Do you managed to find some core dump? They should
located in the working directory of the server.

> The error is :
>
> kernel: kamailio[12442]: segfault at 0000000000000010 rip 00002b1b42952764
> rsp 00007fff6b144d30 error 4
>
> Does anyone had the same issue ?

The oracle module is probably one of the DB modules which has got the
least testing, due its dependencies. But i think they are some people
which successful using it. The next step would be to investigate the
backtrace from the core dump.

Another option would be to setup an unixodbc connection on the DB side and
then connect which the db_unixodbc module instead.

Regards,

Henning
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- 
Daniel-Constantin Mierla
* http://www.asipto.com/