[asterisk-bugs] [JIRA] (ASTERISK-22596) Compiling res_odbc against iODBC instead of unixodbc produces runtime errors

[Matt Jordan (JIRA)]

Matt Jordan created ASTERISK-22596:
--------------------------------------

             Summary: Compiling res_odbc against iODBC instead of unixodbc produces runtime errors
                 Key: ASTERISK-22596
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-22596
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Resources/res_odbc
    Affects Versions: 11.5.1
         Environment: Debian linux (squeeze), ODBC/MysQL
            Reporter: Patrick Maille
            Assignee: Walter Doekes


When I set (in res_odbc.conf):
username=>asterisk

the mysql logs show:
130904 15:51:30    57 Connect   Access denied for user 'a'@'localhost' (using password: YES)

If I set (in res_odbc.conf):
username=>debian

the mysql logs show:
130904 15:52:30    63 Connect   Access denied for user 'd'@'localhost' (using password: YES)

So it looks like it's only taking the first letter of the username for authentication to the database.

I confirmed that my odbc/mysql stack works:

$ echo "select 1" | isql -v asterisk-connector asterisk Test1234
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select 1
+---------------------+
| 1                   |
+---------------------+
| 1                   |
+---------------------+
SQLRowCount returns 1
1 rows fetched

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira