Re: [Kamailio-Users] oracle sqlops URL

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 &lt;miconda(a)gmail.com > 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> >> 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/ > >