[OpenSIPS-Users] drounting and db_oracle: db_oracle module seems to be never loaded

Bogdan-Andrei Iancu bogdan at voice-system.ro
Fri Apr 24 14:07:35 CEST 2009


Hi Noel,

It is really strange as the log shows that the API import function 
(<db_bind_api>) is not found in the module and the module searching 
in"db_oracle" is correct...

I see the module is loading correctly as there is a shutdown log from it.

Maybe some linking problems (for db_oracle.so).....

Regards,
Bogdan

Noel R. Morais wrote:
> Hi Bogdan,
>
> I thought that it could be something related to the instantclient 
> version since I'm using the last release. I've changed the 
> instantclient to 10.2.0.3 (recommended by the module) and I'm getting 
> the same error....
>
> Thanks,
>
>
> Noel
>
> On Thu, Apr 23, 2009 at 5:35 PM, Noel R. Morais <noelrocha at gmail.com 
> <mailto:noelrocha at gmail.com>> wrote:
>
>     Sure....
>
>     but by the logs the module seems to be loaded but there are some
>     errors with it:
>
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     NOTICE:core:main: version: opensips 1.5.1-notls (i386/linux)
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     INFO:core:main: using 32 Mb shared memory
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     INFO:core:main: using 1 Mb private memory per process
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:add_avp_galias: registering <serial_branch> for avp id
>     <16725044>
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:init_stats_collector: statistics manager successfully
>     initialized
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:init_mod: initializing module oracle
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:db_oracle:oracle_mod_init: Oracle client version is 11.1.0.7.0
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:init_mod: initializing module drouting
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     INFO:drouting:dr_init: Dynamic-Routing - initializing
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_bind_api> in module db_oracle not found
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:db_bind_mod: using export interface to bind db_oracle
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_use_table> in module db_oracle not
>     found
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_init> in module db_oracle not found
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_close> in module db_oracle not found
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_query> in module db_oracle not found
>     Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_fetch_result> in module db_oracle
>     not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_raw_query> in module db_oracle not
>     found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_free_result> in module db_oracle not
>     found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_insert> in module db_oracle not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_delete> in module db_oracle not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_update> in module db_oracle not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_replace> in module db_oracle not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_last_inserted_id> in module
>     db_oracle not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:core:find_mod_export: <db_insert_update> in module db_oracle
>     not found
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     ERROR:core:db_check_api: module db_oracle does not export
>     db_use_table function
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     CRITICAL:drouting:dr_init: cannot bind to database module! Did you
>     forget to load a database module ?
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     ERROR:core:init_mod: failed to initialize module drouting
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     ERROR:core:main: error while initializing modules
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:xlog:destroy: destroy module...
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:tm:tm_shutdown: tm_shutdown : start
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:tm:tm_shutdown: emptying hash table
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:tm:tm_shutdown: releasing timers
>     Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:tm:tm_shutdown: removing semaphores
>     Apr 23 17:13:25 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:tm:tm_shutdown: destroying callback lists
>     Apr 23 17:13:25 lab7 /usr/local/sbin/opensips[20350]:
>     DBG:tm:tm_shutdown: tm_shutdown : done
>     Apr 23 17:13:25 lab7 /usr/local/sbin/opensips[20350]:
>     INFO:db_oracle:destroy: Oracle terminate
>
>
>     Thanks,
>
>     Noel
>
>     On Thu, Apr 23, 2009 at 5:19 PM, Bogdan-Andrei Iancu
>     <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>     > Hi Noel,
>     >
>     > Looks like the the db_oracle module is not found and
>     loaded....Could you
>     > post the whole log in debug mode (debug=6) ?
>     >
>     > Regards,
>     > Bogdan
>     >
>     > Noel R. Morais wrote:
>     >>
>     >> Hi Guys,
>     >>
>     >> I have a working script with mysql and I'm migrating it to work
>     with
>     >> oracle.
>     >>
>     >> I've compiled opensips with db_oracle support and I'm loading the
>     >> module by: loadmodule "db_oracle.so"
>     >>
>     >> I'm setting the drouting db_url parameter as follow:
>     >>
>     >> modparam("drouting", "db_url",
>     "oracle://USERNAME:PASSWORD@HOST:1521/SID")
>     >>
>     >> I'm getting the follow error:
>     >>
>     >> Apr 23 16:20:26 lab7 /usr/local/sbin/opensips[18100]:
>     >> INFO:drouting:dr_init: Dynamic-Routing - initializing
>     >> Apr 23 16:20:26 lab7 /usr/local/sbin/opensips[18100]:
>     >> ERROR:core:db_check_api: module db_oracle does not export
>     db_use_table
>     >> function
>     >> Apr 23 16:20:26 lab7 /usr/local/sbin/opensips[18100]:
>     >> CRITICAL:drouting:dr_init: cannot bind to database module! Did you
>     >> forget to load a database module ?
>     >>
>     >> I really don't have even a clue of what is wrong ....
>     >>
>     >> Thanks,
>     >>
>     >> Noel
>     >>
>     >> _______________________________________________
>     >> Users mailing list
>     >> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>     >>
>     >>  
>     >
>     >
>
>




More information about the Users mailing list