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 <[email protected] > <mailto:[email protected]>> 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 > <[email protected] <mailto:[email protected]>> 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:passw...@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 > >> [email protected] <mailto:[email protected]> > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >> > >> > > > > > > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
