[Kamailio-Users] oracle sqlops URL

[Henning Westerholt]

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