[Kamailio-Users] oracle sqlops URL

[alex pappas]

Hi all

I just manage to connect with oracle with the following URL :

modparam("sqlops","sqlcon","ca=>oracle://user:pass@alex.gr/cid_name.alex.gr
")

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.

The error is :

kernel: kamailio[12442]: segfault at 0000000000000010 rip 00002b1b42952764
rsp 00007fff6b144d30 error 4

Does anyone had the same issue ?

Cheers
Alex



On Thu, Dec 31, 2009 at 10:51 AM, alex pappas <rebel.pappas at gmail.com>wrote:

> HI Henning,
>
> How was the restaurant last night? They have there great beer!  ;-)
>
> I tried also :
> modparam("sqlops","sqlcon","ca=>oracle://user/pass@IP:1521:cid")
> but it gave me all the following errors
>
>
> ERROR:db_oracle:db_oracle_new_connection: invalid parameter value
> ERROR:core:db_do_init: could not add connection to the pool
> ERROR:sqlops:sql_connect: failed to connect to the database [ca]
> ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
> ERROR:core:main_loop: init_child failed for UDP listener
> ERROR:db_oracle:db_oracle_new_connection: invalid parameter value
> ERROR:core:db_do_init: could not add connection to the pool
> ERROR:sqlops:sql_connect: failed to connect to the database [ca]
> ERROR:core:init_mod_child: failed to initializing module sqlops, rank 3
> ERROR:core:main_loop: init_child failed for UDP listener
> INFO:mi_datagram:datagram_process: a new child 0/4893
>
> From the script kamailio_orasel it runs only if I give the folowing format:
>
> ./kamailio_orasel user/pass@
> "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=iota.alex.gr
> )(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=cid_name.alex.gr)))" -e "select
> prefix from ported_numbers where number = '6937630910';"
>
> When I try to add the above format in sqlops connection then I get many
> many errors..
>
> have you any idea on how is the right way to write the sqlops URL ?
>
> Cheers
> Alex
>
>
>
>
> On Thu, Dec 31, 2009 at 12:05 AM, Henning Westerholt <
> henning.westerholt at 1und1.de> wrote:
>
>> On Wed, December 30, 2009 8:43 pm, alex pappas wrote:
>> > Dear friends I'm trying to setup a sqlops connection to an Oracle db. I
>> > loaded the db_oracle module with (loadmodule "db_oracle.so") without
>> > parameters. The connection string that I gave in sqlops module is :
>> > modparam("sqlops","sqlcon","ca2=>user/pass at ip_addres:1521:db_name")
>> >
>> > When i try to start kamailio I get the following errors and kamailio
>> does
>> > NOT start:
>> >
>> > ERROR:core:db_check_api: module db_user/pass at ip does not export
>> > db_use_table
>> > function
>> > ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
>> > ERROR:core:main_loop: init_child failed for UDP listener
>>
>> Hello Alex,
>>
>> you need to replace "db_name" with the name of a actual DB module. So for
>> example "mysql", or "oracle" in your case. Here a complete example for
>> mysql:
>>
>> modparam("sqlops","sqlcon","ca=>mysql://openser:abc@localhost/openser")
>>
>> Regards,
>>
>> Henning
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20091231/dcbff141/attachment.htm>