Sure....<br><br>but by the logs the module seems to be loaded but there are some errors with it:<br><br>Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: NOTICE:core:main: version: opensips 1.5.1-notls (i386/linux) <br>
Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: INFO:core:main: using 32 Mb shared memory <br>Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: INFO:core:main: using 1 Mb private memory per process <br>Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:add_avp_galias: registering <serial_branch> for avp id <16725044> <br>
Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:init_stats_collector: statistics manager successfully initialized <br>Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:init_mod: initializing module oracle <br>
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 <br>Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:init_mod: initializing module drouting <br>
Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: INFO:drouting:dr_init: Dynamic-Routing - initializing <br>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 <br>
Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:db_bind_mod: using export interface to bind db_oracle <br>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 <br>
Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_init> in module db_oracle not found <br>Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_close> in module db_oracle not found <br>
Apr 23 17:13:23 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_query> in module db_oracle not found <br>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 <br>
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 <br>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 <br>
Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_insert> in module db_oracle not found <br>Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_delete> in module db_oracle not found <br>
Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_update> in module db_oracle not found <br>Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:core:find_mod_export: <db_replace> in module db_oracle not found <br>
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 <br>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 <br>
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 <br>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 ? <br>
Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: ERROR:core:init_mod: failed to initialize module drouting <br>Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: ERROR:core:main: error while initializing modules <br>
Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:xlog:destroy: destroy module... <br>Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:tm:tm_shutdown: tm_shutdown : start <br>Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:tm:tm_shutdown: emptying hash table <br>
Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:tm:tm_shutdown: releasing timers <br>Apr 23 17:13:24 lab7 /usr/local/sbin/opensips[20350]: DBG:tm:tm_shutdown: removing semaphores <br>Apr 23 17:13:25 lab7 /usr/local/sbin/opensips[20350]: DBG:tm:tm_shutdown: destroying callback lists <br>
Apr 23 17:13:25 lab7 /usr/local/sbin/opensips[20350]: DBG:tm:tm_shutdown: tm_shutdown : done <br>Apr 23 17:13:25 lab7 /usr/local/sbin/opensips[20350]: INFO:db_oracle:destroy: Oracle terminate <br><br><div><br></div><div>Thanks,</div>
<div><br></div><div>Noel</div><div><br>On Thu, Apr 23, 2009 at 5:19 PM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>> wrote:<br>> Hi Noel,<br>><br>> Looks like the the db_oracle module is not found and loaded....Could you<br>
> post the whole log in debug mode (debug=6) ?<br>><br>> Regards,<br>> Bogdan<br>><br>> Noel R. Morais wrote:<br>>><br>>> Hi Guys,<br>>><br>>> I have a working script with mysql and I'm migrating it to work with<br>
>> oracle.<br>>><br>>> I've compiled opensips with db_oracle support and I'm loading the<br>>> module by: loadmodule "db_oracle.so"<br>>><br>>> I'm setting the drouting db_url parameter as follow:<br>
>><br>>> modparam("drouting", "db_url", "oracle://USERNAME:PASSWORD@HOST:1521/SID")<br>>><br>>> I'm getting the follow error:<br>>><br>>> Apr 23 16:20:26 lab7 /usr/local/sbin/opensips[18100]:<br>
>> INFO:drouting:dr_init: Dynamic-Routing - initializing<br>>> Apr 23 16:20:26 lab7 /usr/local/sbin/opensips[18100]:<br>>> ERROR:core:db_check_api: module db_oracle does not export db_use_table<br>>> function<br>
>> Apr 23 16:20:26 lab7 /usr/local/sbin/opensips[18100]:<br>>> CRITICAL:drouting:dr_init: cannot bind to database module! Did you<br>>> forget to load a database module ?<br>>><br>>> I really don't have even a clue of what is wrong ....<br>
>><br>>> Thanks,<br>>><br>>> Noel<br>>><br>>> _______________________________________________<br>>> Users mailing list<br>>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>><br>>> <br>><br>><br><br></div>