20 Apr
2011
20 Apr
'11
5:32 p.m.
Hello,
On 4/20/11 6:52 PM, laura testi wrote:
Hi all,
we are trying to setup a Kamailio as a SIP/SIMPLE presence server for
chat based on the guide published in SIP SIMPLE Presence Made Simple
with Kamailio 3.1.x on the site:
http://kb.asipto.com/kamailio:presence:k31-made-simple.
_The OS we are using is Linux RHEL 5.6 x64 and ORACLE 11g as Database_.
So I have compiled the db_oracle module using
instantclient-sdk-11.2.0.2 but when I start kamailio I receive the
following errors:
Apr 19 23:12:07 localhost /opt/openkore/sbin/kamailio[10394]: INFO:
db_oracle [ora_con.c:132]: server version is Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the
Partitioning, OLAP, Data Mining and Real Application Testing options
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
*db_oracle [res.c:423]: driver: ORA-24330: internal OCI error*
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
db_oracle [res.c:475]: error while converting rows
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
<core> [db_query.c:108]: error while storing result
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
<core> [db.c:366]: error in db_query
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
<core> [db.c:405]: querying version for table presentity
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
presence [presence.c:300]: error during table version check
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
<core> [sr_module.c:875]: init_mod(): Error while initializing module
presence (/opt/openkore/lib64/kamailio/modules_k/presence.so)
Apr 19 23:12:10 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
db_oracle [ora_con.c:173]: driver: ORA-03127: no new operations
allowed until the active operation ends
Apr 19 23:12:11 localhost /opt/openkore/sbin/kamailio[10394]: INFO:
db_oracle [db_oracle.c:91]: Oracle terminate
Is it a known bug of db_oracle module?
Could you please help me to solve this problem?
"internal OCI error" is very intuitive coming from Oracle, moreover
searching google for this ORA error says the action to do is "Contact
Oracle Support" :-)
Oracle module was developed some time ago, probably using an older
version of oracle server and library. You should add some debug messages
inside function get_rows() from modules_k/db_oracle/res.c in order to
see exactly what function threw the error. Then you may find more hints
searching on the web for that function name and error message.
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com