Hi Alex, Thanks - already applied the patch.
So we still have to sort out the datatype stuff (with char for priority in lcr table). Regards, Bogdan Alex Massover wrote: > > 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 > > <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 > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
