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

[Noel R. Morais]

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> 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> 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
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >>
> >>
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090423/81cd52d1/attachment-0001.htm