[OpenSIPS-Users] db_oracle module can not work

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Aug 6 05:28:16 CEST 2009


Hi,

That is more than strange - I will need to put some time and try to 
compile the oracle module by myself and to give it a try.

Regards,
Bogdan

happybirdgo wrote:
> Hi, We use OpenSIPS version 1.52
> Oracle lib with OpenSIPS is 
> instantclient-basic-linux-x86-64-10.2.0.3-20070103 .
> instantclient-sdk-linux-x86-64-10.2.0.3-20070103
>
> We also tried with oracle-instantclient11.1-basic-11.1.0.7.0-1.x86_64
> oracle-instantclient11.1-devel-11.1.0.7.0-1.x86_64
> And got the same error.
>
> We hope to know db_oracle can work with which version of OpenSIPS?
>
> Thanks.
>
> 在2009-08-04,"Bogdan-Andrei Iancu" <bogdan at voice-system.ro> 写道:
> >Hi,
> >
> >what version of opensips are you using ?
> >
> >Regards,
> >Bogdan
> >
> >happybirdgo wrote:
> >> Hello bogdan and noelrocha,
> >> Have you solved the problem about db_oracle?
> >>
> >> Now I have the same problem when using db_oracle.
> >>
> >> In opensips.cfg:
> >> loadmodule "db_oracle.so" # this works OK
> >>
> >> But after using db_oracle in other modules, such as:
> >> modparam("usrloc", "db_url", 
> >> "oracle://opensipsuser:opensipspasswd@oracle_host:1521/orcl")
> >>
> >> Opensips could not start up. It reported many errors ,such as :
> >>
> >> Aug 4 10:28:06 [16978] DBG:db_oracle:oracle_mod_init: Oracle client 
> >> version is 10.2.0.3.0
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: initializing module signaling
> >> Aug 4 10:28:06 [16978] NOTICE:signaling:mod_init: initializing module ...
> >> Aug 4 10:28:06 [16978] DBG:core:find_cmd_export_t: found <load_tm>(0) 
> >> in module tm [/usr/local/lib64/opensips/modules/]
> >> Aug 4 10:28:06 [16978] DBG:core:find_cmd_export_t: found <load_sl>(0) 
> >> in module sl [/usr/local/lib64/opensips/modules/]
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: initializing module sl
> >> Aug 4 10:28:06 [16978] INFO:sl:mod_init: Initializing StateLess engine
> >> Aug 4 10:28:06 [16978] DBG:core:MD5StringArray: MD5 calculated: 
> >> 62c27e3502f51337fbc6502ea9e65b9d
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: registering stats for sl
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: initializing module tm
> >> Aug 4 10:28:06 [16978] INFO:tm:mod_init: TM - initializing...
> >> Aug 4 10:28:06 [16978] DBG:tm:init_callid: Call-ID initialization: 
> >> '2153745d5ba319e3'
> >> Aug 4 10:28:06 [16978] DBG:tm:lock_initialize: lock initialization started
> >> [root at cvonpsl0 ~]# Aug 4 10:28:06 [16978] DBG:core:MD5StringArray: MD5 
> >> calculated: a7e3b45ff8e8dd7a37d44b171c2006e9
> >> Aug 4 10:28:06 [16978] DBG:core:MD5StringArray: MD5 calculated: 
> >> a950d3cf3a09dc3741c2f6c80df6a02d
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: registering stats for tm
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: register MI for tm
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: initializing module rr
> >> Aug 4 10:28:06 [16978] DBG:rr:mod_init: rr - initializing
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: initializing module maxfwd
> >> Aug 4 10:28:06 [16978] INFO:maxfwd:mod_init: initializing...
> >> Aug 4 10:28:06 [16978] DBG:core:init_mod: initializing module usrloc
> >> Aug 4 10:28:06 [16978] DBG:usrloc:mod_init: initializing
> >> Aug 4 10:28:06 [16978] INFO:usrloc:ul_init_locks: locks array size 512
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_bind_api> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:db_bind_mod: using export interface to 
> >> bind db_oracle
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_use_table> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_init> in module 
> >> db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_close> in module 
> >> db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_query> in module 
> >> db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_fetch_result> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_raw_query> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_free_result> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_insert> in module 
> >> db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_delete> in module 
> >> db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_update> in module 
> >> db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_replace> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_last_inserted_id> 
> >> in module db_oracle not found
> >> Aug 4 10:28:06 [16978] DBG:core:find_mod_export: <db_insert_update> in 
> >> module db_oracle not found
> >> Aug 4 10:28:06 [16978] ERROR:core:db_check_api: module db_oracle does 
> >> not export db_use_table function
> >> Aug 4 10:28:06 [16978] ERROR:usrloc:mod_init: failed to bind database 
> >> module
> >> Aug 4 10:28:06 [16978] ERROR:core:init_mod: failed to initialize 
> >> module usrloc
> >> Aug 4 10:28:06 [16978] ERROR:core:main: error while initializing modules
> >> Aug 4 10:28:06 [16978] DBG:presence_xml:destroy: start
> >> Aug 4 10:28:06 [16978] NOTICE:presence:destroy: destroy module ...
> >> Aug 4 10:28:06 [16978] DBG:xlog:destroy: destroy module...
> >> Aug 4 10:28:06 [16978] DBG:tm:tm_shutdown: tm_shutdown : start
> >> Aug 4 10:28:06 [16978] DBG:tm:unlink_timer_lists: emptying DELETE list
> >> Aug 4 10:28:06 [16978] DBG:tm:tm_shutdown: emptying hash table
> >> Aug 4 10:28:06 [16978] DBG:tm:tm_shutdown: releasing timers
> >> Aug 4 10:28:06 [16978] DBG:tm:tm_shutdown: removing semaphores
> >> Aug 4 10:28:06 [16978] DBG:tm:tm_shutdown: destroying callback lists
> >> Aug 4 10:28:06 [16978] DBG:tm:tm_shutdown: tm_shutdown : done
> >> Aug 4 10:28:06 [16978] INFO:db_oracle:destroy: Oracle terminate
> >>
> >> We run opensip on RHEL5 x_64 .
> >> Could you give some suggestions to solve this problem?
> >> Thanks.
> >>
> >>
> >>
> >>
> >> ------------------------------------------------------------------------
> >> 没有广告的终身免费邮箱,www.yeah.net <http://www.yeah.net/?from=footer> 
> >
>   
>
>
> ------------------------------------------------------------------------
> 没有广告的终身免费邮箱,www.yeah.net <http://www.yeah.net/?from=footer> 




More information about the Users mailing list