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.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
