Re: db_oracle module can not work

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: db_oracle module can not work

Bogdan-Andrei Iancu
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@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>


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: db_oracle module can not work

Bogdan-Andrei Iancu
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" <[hidden email]> 写道:
> >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@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>


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users