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

[Noel R. Morais]

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/8a0064f0/attachment-0001.htm