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:[email protected]] > Sent: Wednesday, March 18, 2009 5:22 PM > To: Alex Massover > Cc: [email protected] > 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:* [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 >> >> > > > > > 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
