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: [email protected] [mailto:[email protected]] On Behalf Of Alex Massover Sent: Wednesday, March 18, 2009 2:54 PM To: [email protected] 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.
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
