[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