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

[Bogdan-Andrei Iancu]

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