30 Dec
2009
30 Dec
'09
7:43 p.m.
Hi all,
happy 2010 for all of us!
Dear friends I'm trying to setup a sqlops connection to an Oracle db. I
loaded the db_oracle module with (loadmodule "db_oracle.so") without
parameters. The connection string that I gave in sqlops module is :
modparam("sqlops","sqlcon","ca2=>user/pass@ip_addres:1521:db_name")
When i try to start kamailio I get the following errors and kamailio does
NOT start:
ERROR:core:db_check_api: module db_user/pass@ip does not export db_use_table
function
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
ERROR:core:main_loop: init_child failed for UDP listener
Thank in advance and merry Christmas
Alex
30 Dec
30 Dec
10:05 p.m.
On Wed, December 30, 2009 8:43 pm, alex pappas wrote:
Dear friends I'm trying to setup a sqlops
connection to an Oracle db. I
loaded the db_oracle module with (loadmodule "db_oracle.so") without
parameters. The connection string that I gave in sqlops module is :
modparam("sqlops","sqlcon","ca2=>user/pass@ip_addres:1521:db_name")
When i try to start kamailio I get the following errors and kamailio does
NOT start:
ERROR:core:db_check_api: module db_user/pass@ip does not export
db_use_table
function
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
ERROR:core:main_loop: init_child failed for UDP listener
Hello Alex,
you need to replace "db_name" with the name of a actual DB module. So for
example "mysql", or "oracle" in your case. Here a complete example
for
mysql:
modparam("sqlops","sqlcon","ca=>mysql://openser:abc@localhost/openser")
Regards,
Henning
31 Dec
31 Dec
8:51 a.m.
HI Henning,
How was the restaurant last night? They have there great beer! ;-)
I tried also :
modparam("sqlops","sqlcon","ca=>oracle://user/pass@IP:1521:cid")
but it gave me all the following errors
ERROR:db_oracle:db_oracle_new_connection: invalid parameter value
ERROR:core:db_do_init: could not add connection to the pool
ERROR:sqlops:sql_connect: failed to connect to the database [ca]
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
ERROR:core:main_loop: init_child failed for UDP listener
ERROR:db_oracle:db_oracle_new_connection: invalid parameter value
ERROR:core:db_do_init: could not add connection to the pool
ERROR:sqlops:sql_connect: failed to connect to the database [ca]
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 3
ERROR:core:main_loop: init_child failed for UDP listener
INFO:mi_datagram:datagram_process: a new child 0/4893
From the script kamailio_orasel it runs only if I give
the folowing format:
./kamailio_orasel user/pass@
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=iota.alex.gr
)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=cid_name.alex.gr)))" -e "select
prefix from ported_numbers where number = '6937630910';"
When I try to add the above format in sqlops connection then I get many many
errors..
have you any idea on how is the right way to write the sqlops URL ?
Cheers
Alex
On Thu, Dec 31, 2009 at 12:05 AM, Henning Westerholt <
henning.westerholt(a)1und1.de> wrote:
On Wed, December 30, 2009 8:43 pm, alex pappas wrote:
Dear friends I'm trying to setup a sqlops
connection to an Oracle db. I
loaded the db_oracle module with (loadmodule "db_oracle.so") without
parameters. The connection string that I gave in sqlops module is :
modparam("sqlops","sqlcon","ca2=>user/pass@ip_addres:1521:db_name")
When i try to start kamailio I get the following errors and kamailio does
NOT start:
ERROR:core:db_check_api: module db_user/pass@ip does not export
db_use_table
function
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
ERROR:core:main_loop: init_child failed for UDP listener
Hello Alex,
you need to replace "db_name" with the name of a actual DB module. So for
example "mysql", or "oracle" in your case. Here a complete example
for
mysql:
modparam("sqlops","sqlcon","ca=>mysql://openser:abc@localhost/openser")
Regards,
Henning
9:55 a.m.
Hi all
I just manage to connect with oracle with the following URL :
modparam("sqlops","sqlcon","ca=>oracle://user:pass@alex.gr/cid_name.alex.gr
")
Now I run into other problems. The same query that from ./kamailio_orasel
give me result, when I try that from kamailio.cfg I get an error and after
that the system is getting very high load.
The error is :
kernel: kamailio[12442]: segfault at 0000000000000010 rip 00002b1b42952764
rsp 00007fff6b144d30 error 4
Does anyone had the same issue ?
Cheers
Alex
On Thu, Dec 31, 2009 at 10:51 AM, alex pappas <rebel.pappas(a)gmail.com>wrote;wrote:
HI Henning,
How was the restaurant last night? They have there great beer! ;-)
I tried also :
modparam("sqlops","sqlcon","ca=>oracle://user/pass@IP:1521:cid")
but it gave me all the following errors
ERROR:db_oracle:db_oracle_new_connection: invalid parameter value
ERROR:core:db_do_init: could not add connection to the pool
ERROR:sqlops:sql_connect: failed to connect to the database [ca]
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
ERROR:core:main_loop: init_child failed for UDP listener
ERROR:db_oracle:db_oracle_new_connection: invalid parameter value
ERROR:core:db_do_init: could not add connection to the pool
ERROR:sqlops:sql_connect: failed to connect to the database [ca]
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 3
ERROR:core:main_loop: init_child failed for UDP listener
INFO:mi_datagram:datagram_process: a new child 0/4893
From the script kamailio_orasel it runs only if I give the folowing format:
./kamailio_orasel user/pass@
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=iota.alex.gr
)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=cid_name.alex.gr)))" -e "select
prefix from ported_numbers where number = '6937630910';"
When I try to add the above format in sqlops connection then I get many
many errors..
have you any idea on how is the right way to write the sqlops URL ?
Cheers
Alex
On Thu, Dec 31, 2009 at 12:05 AM, Henning Westerholt <
henning.westerholt(a)1und1.de> wrote:
On Wed, December 30, 2009 8:43 pm, alex pappas
wrote:
Dear friends I'm trying to setup a sqlops
connection to an Oracle db. I
loaded the db_oracle module with (loadmodule "db_oracle.so") without
parameters. The connection string that I gave in sqlops module is :
modparam("sqlops","sqlcon","ca2=>user/pass@ip_addres:1521:db_name")
When i try to start kamailio I get the following errors and kamailio
does
NOT start:
ERROR:core:db_check_api: module db_user/pass@ip does not export
db_use_table
function
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
ERROR:core:main_loop: init_child failed for UDP listener
Hello Alex,
you need to replace "db_name" with the name of a actual DB module. So for
example "mysql", or "oracle" in your case. Here a complete example
for
mysql:
modparam("sqlops","sqlcon","ca=>mysql://openser:abc@localhost/openser")
Regards,
Henning
10:14 a.m.
On Thu, December 31, 2009 10:55 am, alex pappas wrote:
[..]
Hey Alex,
the restaurant was nice, the beer is indeed good there. :-)
I just manage to connect with oracle with the
following URL :
modparam("sqlops","sqlcon","ca=>oracle://user:pass@alex.gr/cid_name.alex.gr
")
Good that you managed to find the correct syntax.
Now I run into other problems. The same query that
from ./kamailio_orasel
give me result, when I try that from kamailio.cfg I get an error and
after that the system is getting very high load.
This is probably caused from a segfault which caused a core dump. :-(
After this the system is busy to write the core file with the memory dump
to the disk, which can get really huge depending on the process number and
shared memory size. Do you managed to find some core dump? They should
located in the working directory of the server.
The error is :
kernel: kamailio[12442]: segfault at 0000000000000010 rip 00002b1b42952764
rsp 00007fff6b144d30 error 4
Does anyone had the same issue ?
The oracle module is probably one of the DB modules which has got the
least testing, due its dependencies. But i think they are some people
which successful using it. The next step would be to investigate the
backtrace from the core dump.
Another option would be to setup an unixodbc connection on the DB side and
then connect which the db_unixodbc module instead.
Regards,
Henning
10:51 a.m.
Hi henning,
I'm happy you enjoyed the beer. ;-)
I'm attaching some back traces from the core dump. I don't know C
programming so I can't go further than that :-(
I will try also the odbc driver.
Thank you for the help
Best wishes for 2010
Alex
On Thu, Dec 31, 2009 at 12:14 PM, Henning Westerholt <
henning.westerholt(a)1und1.de> wrote:
On Thu, December 31, 2009 10:55 am, alex pappas
wrote:
[..]
Hey Alex,
the restaurant was nice, the beer is indeed good there. :-)
I just manage to connect with oracle with the
following URL :
modparam("sqlops","sqlcon","ca=>oracle://
user:pass@alex.gr/cid_name.alex.gr
")
Good that you managed to find the correct syntax.
Now I run into other problems. The same query
that from ./kamailio_orasel
give me result, when I try that from kamailio.cfg I get an error and
after that the system is getting very high load.
This is probably caused from a segfault which caused a core dump. :-(
After this the system is busy to write the core file with the memory dump
to the disk, which can get really huge depending on the process number and
shared memory size. Do you managed to find some core dump? They should
located in the working directory of the server.
The error is :
kernel: kamailio[12442]: segfault at 0000000000000010 rip
00002b1b42952764
rsp 00007fff6b144d30 error 4
Does anyone had the same issue ?
The oracle module is probably one of the DB modules which has got the
least testing, due its dependencies. But i think they are some people
which successful using it. The next step would be to investigate the
backtrace from the core dump.
Another option would be to setup an unixodbc connection on the DB side and
then connect which the db_unixodbc module instead.
Regards,
Henning
4:49 p.m.
Hello,
seems that connaction handle was not initialized for raw queries. I did
a fix, but I had no oracle libs or server to test. Try to get last svn
branch 1.5 and see if it is better now. If not, will fix next year.
A great 2010 for you as well,
Daniel
On 12/31/09 11:51 AM, alex pappas wrote:
Hi henning,
I'm happy you enjoyed the beer. ;-)
I'm attaching some back traces from the core dump. I don't know C
programming so I can't go further than that :-(
I will try also the odbc driver.
Thank you for the help
Best wishes for 2010
Alex
On Thu, Dec 31, 2009 at 12:14 PM, Henning Westerholt
<henning.westerholt(a)1und1.de <mailto:henning.westerholt@1und1.de>> wrote:
On Thu, December 31, 2009 10:55 am, alex pappas wrote:
--
Daniel-Constantin Mierla
* http://www.asipto.com/
[..]
Hey Alex,
the restaurant was nice, the beer is indeed good there. :-)
I just manage to connect with oracle with the
following URL :
modparam("sqlops","sqlcon","ca=>oracle://user:pass@alex.gr/cid_name.alex.gr
<http://user:pass@alex.gr/cid_name.alex.gr>
")
Good that you managed to find the correct syntax.
Now I run into other problems. The same query
that from
./kamailio_orasel
give me result, when I try that from kamailio.cfg
I get an error and
after that the system is getting very high load.
This is probably caused from a segfault which caused a core dump. :-(
After this the system is busy to write the core file with the
memory dump
to the disk, which can get really huge depending on the process
number and
shared memory size. Do you managed to find some core dump? They should
located in the working directory of the server.
The error is :
kernel: kamailio[12442]: segfault at 0000000000000010 rip
00002b1b42952764
rsp 00007fff6b144d30 error 4
Does anyone had the same issue ?
The oracle module is probably one of the DB modules which has got the
least testing, due its dependencies. But i think they are some people
which successful using it. The next step would be to investigate the
backtrace from the core dump.
Another option would be to setup an unixodbc connection on the DB
side and
then connect which the db_unixodbc module instead.
Regards,
Henning
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
6:02 p.m.
Hi Daniel,
The result from the test:
ERROR:db_oracle:get_rows: driver: ORA-24330: internal OCI error
ERROR:db_oracle:db_oracle_store_result: error while converting rows
ERROR:core:db_do_raw_query: error while storing result
ERROR:sqlops:sql_do_query: cannot do the query
We will see it in 2010 !
Happy new year!!
Alexandros
On Thu, Dec 31, 2009 at 6:49 PM, Daniel-Constantin Mierla <miconda(a)gmail.com
wrote:
> Hello,
>
> seems that connaction handle was not initialized for raw queries. I did a
> fix, but I had no oracle libs or server to test. Try to get last svn branch
> 1.5 and see if it is better now. If not, will fix next year.
>
> A great 2010 for you as well,
> Daniel
>
>
>
> On 12/31/09 11:51 AM, alex pappas wrote:
>
> Hi henning,
>
> I'm happy you enjoyed the beer. ;-)
>
> I'm attaching some back traces from the core dump. I don't know C
> programming so I can't go further than that :-(
>
> I will try also the odbc driver.
>
> Thank you for the help
> Best wishes for 2010
>
> Alex
>
>
>
>
> On Thu, Dec 31, 2009 at 12:14 PM, Henning Westerholt <
> henning.westerholt(a)1und1.de wrote:
>
>> On Thu, December 31, 2009 10:55 am, alex pappas wrote:
>> > [..]
>>
>> Hey Alex,
>>
>> the restaurant was nice, the beer is indeed good there. :-)
>>
>> > I just manage to connect with oracle with the following URL :
>> >
>> > modparam("sqlops","sqlcon","ca=>oracle://
>> user:pass@alex.gr/cid_name.alex.gr
>> > ")
>>
>> Good that you managed to find the correct syntax.
>>
>> > Now I run into other problems. The same query that from
>> ./kamailio_orasel
>> > give me result, when I try that from kamailio.cfg I get an error and
>> > after that the system is getting very high load.
>>
>> This is probably caused from a segfault which caused a core dump. :-(
>> After this the system is busy to write the core file with the memory dump
>> to the disk, which can get really huge depending on the process number and
>> shared memory size. Do you managed to find some core dump? They should
>> located in the working directory of the server.
>>
>> > The error is :
>> >
>> > kernel: kamailio[12442]: segfault at 0000000000000010 rip
>> 00002b1b42952764
>> > rsp 00007fff6b144d30 error 4
>> >
>> > Does anyone had the same issue ?
>>
>> The oracle module is probably one of the DB modules which has got the
>> least testing, due its dependencies. But i think they are some people
>> which successful using it. The next step would be to investigate the
>> backtrace from the core dump.
>>
>> Another option would be to setup an unixodbc connection on the DB side and
>> then connect which the db_unixodbc module instead.
>>
>> Regards,
>>
>> Henning
>>
>>
>
> _______________________________________________
> Kamailio (OpenSER) - Users mailing list
> Users@lists.kamailio.orghttp://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>
>
> --
> Daniel-Constantin Mierla
> * http://www.asipto.com/
>
>
8 Jan
8 Jan
5:45 p.m.
On Thursday 31 December 2009, alex pappas wrote:
The result from the test:
ERROR:db_oracle:get_rows: driver: ORA-24330: internal OCI error
ERROR:db_oracle:db_oracle_store_result: error while converting rows
ERROR:core:db_do_raw_query: error while storing result
ERROR:sqlops:sql_do_query: cannot do the query
Hi Alex,
sorry for the late reply.. Ok, interesting error. The documentation from
oracle is not really helpful in this regards:
ORA-24330 internal OCI error
Cause: An internal OCI error has occurred.
Action: Contact Oracle Support Services.
http://download.oracle.com/docs/cd/B10501_01/server.920/a96525/e24280.htm
Probably stupid question, but does the DB works otherwise, e.g. if you access
with a command line client? Then probably the module did something wrong. But
its hard to say what exactly just from this error message..
Cheers,
Henning
5:51 p.m.
Ah, the joy of expensive, proprietary crap...
On 01/08/2010 12:45 PM, Henning Westerholt wrote:
On Thursday 31 December 2009, alex pappas wrote:
--
Alex Balashov - Principal
Evariste Systems
Web : http://www.evaristesys.com/
Tel : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
The result from the test:
ERROR:db_oracle:get_rows: driver: ORA-24330: internal OCI error
ERROR:db_oracle:db_oracle_store_result: error while converting rows
ERROR:core:db_do_raw_query: error while storing result
ERROR:sqlops:sql_do_query: cannot do the query
Hi Alex,
sorry for the late reply.. Ok, interesting error. The documentation from
oracle is not really helpful in this regards:
ORA-24330 internal OCI error
Cause: An internal OCI error has occurred.
Action: Contact Oracle Support Services.
http://download.oracle.com/docs/cd/B10501_01/server.920/a96525/e24280.htm
Probably stupid question, but does the DB works otherwise, e.g. if you access
with a command line client? Then probably the module did something wrong. But
its hard to say what exactly just from this error message..
Cheers,
Henning
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
7:41 p.m.
Hi Henning,
As I mentioned in previous email , when I'm running the query with the
./kamailio_orasel tool I get respond normally.
Why I wanted to try oracle is that we already have one oracle db that keeps
the portability data (and works with other systems) and also people that
maintain this database.
Anyway thanks for the help ;-)
Alex
On Fri, Jan 8, 2010 at 8:08 PM, Henning Westerholt <
henning.westerholt(a)1und1.de> wrote:
On Friday 08 January 2010, Alex Balashov wrote:
Ah, the joy of expensive, proprietary crap...
Hey Alex,
indeed, really beautiful organized and linked error messages, but
completely
useless. ;-)
Henning
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
11 Jan
11 Jan
10:25 a.m.
On Friday 08 January 2010, alex pappas wrote:
As I mentioned in previous email , when I'm
running the query with the
./kamailio_orasel tool I get respond normally.
Why I wanted to try oracle is that we already have one oracle db that keeps
the portability data (and works with other systems) and also people that
maintain this database.
Anyway thanks for the help ;-)
Hi Alex,
ah, ok.. This is then indeed strange. Do you've a contact to an oracle guru
who perhaps know what this error message means and could help in debugging the
DB module? Otherwise you could try your luck with the db_unixodbc driver, as
discussed previously.
Cheers,
Henning
5386
days inactive
5398
days old
12 comments
4 participants
participants (4)
-
Alex Balashov -
alex pappas -
Daniel-Constantin Mierla -
Henning Westerholt