27 Apr
2011
27 Apr
'11
7 p.m.
Hi all,
I’m trying to configure my Kamailio server in order to use Oracle (v11g)
DB.
So, I have defined the DBURL, in the kamailio.cfg file:
DBURL "oracle://openser:openserrw@<Oracle server IP
Address>:1521/openserdb"
Where:
· openser/openserrw: is the user/pwd read/write user of the kamailio
oracle schema;
Could someone, please, tell me if the dburl is defined in the right format
and if it isn’t provide me the right one?
I would just add that using the kamailio_orasel tool complied with the same
oracle instant client sdk, I’m able to contact the oracle instance executing
query and so on…but, this tool use the TNSNAME defined in the
$TNS_ADMIN/tnsnames.ora oracle config file like below:
LAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = < Oracle server IP Address>)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = openserdb)
)
)
The command used to query the oracle DB successfully is:
./kamailio_orasel openser/openserrw@LAB -e "select * from subscriber;"
Thanks in advance.
Kind regards,
laura
On Thu, Apr 21, 2011 at 2:19 PM, laura testi <lau.testi(a)gmail.com> wrote:
Hello,
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.
thanks for your suggestion, Daniel.
I added debug messages inside the db_oracle/res.c module and I was able to
find the function ends in error.
This function is:
*OCIStmtFetch2(_c, con->errhp, 1, OCI_FETCH_LAST, 0, OCI_DEFAULT);*
where:
OCIStmt* _c;
ora_con_t* con;
I have also tried to compile the module using both the
instantclient-sdk-11.2.0.2 or oracle-instantclient-basic-10.2.0.3-1, but
receiving the same error.
Any idea?
Thanks and regards,
laura
On Wed, Apr 20, 2011 at 11:32 PM, Daniel-Constantin Mierla <
miconda(a)gmail.com> wrote:
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" :-)
Cheers,
Daniel
--
Daniel-Constantin Mierlahttp://www.asipto.com