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

[Alex Massover]

Hi!

Is it on purpose char? In every DB creation script it's some type of int. The data is numeric. Probably in the module code the variable is also int.
I just don't see a reason why is it char in the doc. Is there such thing like 'unsigned char'? I'm familiar with 'unsigned int'.

I'm not DBA, but 'char' looks very strange to me and makes troubles at least with MSSQL and ODBC.

--
Best Regards,
Alex Massover

-----Original Message-----
From: Bogdan-Andrei Iancu [mailto:bogdan at voice-system.ro]
Sent: Wednesday, March 18, 2009 5:22 PM
To: Alex Massover
Cc: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?

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
>




This mail was received via Mail-SeCure System.





This mail was sent via Mail-SeCure System.