Hi Martin,

I ran into the same issue (among many others) when I was trying to connect OpenSER to Oracle. I ended up changing code in the unixodbc module. Here is a patch you can try, at your own risk of course... This will work if you use unixodbc only with Oracle.

--- /usr/src/openser-1.2.x/modules/unixodbc/utils.c 2007-06-05 17:12:58.000000000 +0300 +++ utils.c 2007-06-07 14:18:36.000000000 +0300 @@ -46,7 +46,7 @@ struct tm* t;

t = localtime(&_time); - return strftime(_result, _res_len, "%Y-%m-%d %H:%M:%S", t); + return strftime(_result, _res_len, "to_date('%Y-%m-%d %H:%M:%S','YYYY-MM-DD HH24:MI:SS')", t); }

--- /usr/src/openser-1.2.x/modules/unixodbc/val.c 2007-06-05 17:12:58.000000000 +0300 +++ val.c 2007-06-07 15:07:00.000000000 +0300 @@ -157,10 +181,8 @@ return -1; }

- *_s++ = '''; l = time2odbc(_v, _s, *_l - 1); - *(_s + l) = '''; - *_l = l + 2; + *_l = l; return 0; }

Regards,

George

Date: Wed, 8 Aug 2007 09:01:10 +0200 From: Martin.Gruber1@infineon.com Subject: [OpenSER-Users] OpenSER Oracle Connection To: users@openser.org Message-ID:

2934B34075D2164BB8F95C3EB2C813D90205DDC6@mucse341.eu.infineon.com Content-Type: text/plain; charset="us-ascii"

Hi @all,

I want to run OpenSER with ORACLE Database. I use unixODBC and libsqora.so.10.1 to connect to the DB. But now I have problems with inserting Data in the DB. When OpenSER wants to add Data in the "location" table I always get an error because of the timeformat (expires, last_modified)

I use SQL*Plus Client in Windows and when I write the Connection String from OpenSER usrloc here, everything is running well, Because I did alter session set nls_date_format = 'YYYY-MM-DD HH24:MM:SS'; Is it a Driver problem?

Does anybody have a solution or experience with it?

Thanks

Martin

Disclaimer The information in this e-mail and any attachments is confidential. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorized to, and must not, read, copy, distribute, use or retain this message or any part of it. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.