[Kamailio-Users] oracle sqlops URL

alex pappas rebel.pappas at gmail.com
Thu Dec 31 19:02:54 CET 2009


Hi Daniel,

The result from the test:

ERROR:db_oracle:get_rows: driver: ORA-24330: internal OCI error
ERROR:db_oracle:db_oracle_store_result: error while converting rows
ERROR:core:db_do_raw_query: error while storing result
ERROR:sqlops:sql_do_query: cannot do the query

We will see it in 2010 !

Happy new year!!

Alexandros



On Thu, Dec 31, 2009 at 6:49 PM, Daniel-Constantin Mierla <miconda at 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 at 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 at 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 at lists.kamailio.orghttp://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/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20091231/b496b4f6/attachment.htm>


More information about the sr-users mailing list