<div>Hi <span class="Apple-style-span" style="border-collapse: collapse; white-space: pre-wrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">Bogdan,</span></div><div><br></div>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 <span class="Apple-style-span" style="border-collapse: collapse; ">10.2.0.3 (recommended by the module) and I'm getting the same error....</span><div>
<span class="Apple-style-span" style="border-collapse: collapse;"><br></span></div><div><span class="Apple-style-span" style="border-collapse: collapse;">Thanks,</span></div><div><span class="Apple-style-span" style="border-collapse: collapse;"><br>
</span></div><div><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></div><div><span class="Apple-style-span" style="border-collapse: collapse;">Noel<br></span><br><div class="gmail_quote">On Thu, Apr 23, 2009 at 5:35 PM, Noel R. Morais <span dir="ltr"><<a href="mailto:noelrocha@gmail.com">noelrocha@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">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><font color="#888888"><div>Noel</div></font><div><div></div><div class="h5"><div><br>On Thu, Apr 23, 2009 at 5:19 PM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro" target="_blank">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" target="_blank">Users@lists.opensips.org</a><br>
>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>><br>>> <br>><br>><br><br></div>
</div></div></blockquote></div><br></div>