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

[Bogdan-Andrei Iancu]

Hi Alex,

I agree with what you are saying - as we are playing some multiple 
database type, we should try to make sure that it fits to all of them. I 
will change the char to int.

Regards,
Bogdan

Alex Massover wrote:
> 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.
>
>
>
>