[OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?

[Alex Massover]

Indeed db_unixodbc is broken in 1.4.x, I uploaded a patch.

https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389


--
Best Regards,
Alex Massover
VoIP R&D TL
Jajah Inc.
________________________________
From: users-bounces at lists.opensips.org [mailto:users-bounces at lists.opensips.org] On Behalf Of Alex Massover
Sent: Wednesday, March 18, 2009 2:54 PM
To: users at lists.opensips.org
Subject: [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?

I'm trying to setup LCR via ODBC with MSSQL. It's working for me with 1.3.2, but not with 1.4.4.

I get in syslog:
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_get_columns: no columns returned from the query
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_convert_result: getting column names failed
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_store_result: failed to convert result
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_do_query: error while storing result
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_table_version: error in db_query
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_check_table_version: querying version for table gw
Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:lcr:mod_init: error during table version check.

In ODBC trace:
[ODBC][19160][SQLDriverConnect.c][1487]
                Exit:[SQL_SUCCESS]
                        Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length = 43 (SQL_NTS)]]
[ODBC][19160][SQLAllocHandle.c][510]
                Entry:
                        Handle Type = 3
                        Input Handle = 0xd7e7308
[ODBC][19160][SQLAllocHandle.c][872]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0xd7dfc68
[ODBC][19160][SQLExecDirect.c][233]
                Entry:
                        Statement = 0xd7dfc68
                        SQL = [][length = 55]               <-- Should be a query here?
[ODBC][19160][SQLExecDirect.c][496]
                Exit:[SQL_SUCCESS]
[ODBC][19160][SQLNumResultCols.c][149]
                Entry:
                        Statement = 0xd7dfc68
                        Column Count = 0xbfcf6d6a
[ODBC][19160][SQLNumResultCols.c][234]
                Exit:[SQL_SUCCESS]
                        Count = 0xbfcf6d6a -> 0
[ODBC][19160][SQLFreeHandle.c][203]
                Entry:
                        Handle Type = 1
                        Input Handle = 0xd4c2400
[ODBC][19160][SQLFreeHandle.c][217]Error: HY010

Here's ODBC trace from working 1.3.2:

[ODBC][3376][SQLDriverConnect.c][1487]
                Exit:[SQL_SUCCESS]
                        Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length = 43 (SQL_NTS)]]
[ODBC][3376][SQLAllocHandle.c][510]
                Entry:
                        Handle Type = 3
                        Input Handle = 0xd1d20c0
[ODBC][3376][SQLAllocHandle.c][872]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0xd1d5ec8
[ODBC][3376][SQLExecDirect.c][233]
                Entry:
                        Statement = 0xd1d5ec8
                        SQL = [select table_version from version where table_name='gw'][length = 55 (SQL_NTS)]


isql also works:

SQL> select table_version from version where table_name='gw';
+--------------+
| table_version|
+--------------+
| 7            |
+--------------+

Any chance that ODBC is broken in 1.4.x?


--
Best Regards,
Alex Massover


This mail was sent via Mail-SeCure System.



This mail was received via Mail-SeCure System.





This mail was sent via Mail-SeCure System.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090318/45e10976/attachment-0001.htm