On Thu, Dec 31, 2009 at 10:51 AM, alex pappas <rebel.pappas@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@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@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@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