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