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

[Walter Doekes (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-22459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=210520#comment-210520 ] 

Walter Doekes commented on ASTERISK-22459:
------------------------------------------

Something along the lines of {{issueA22459_warn_when_using_iodbc.patch}} perhaps.

Note that on my Ubuntu 13.04, {{iodbc2}} has some crazy package dependency rules that won't even allow me to install libmyodbc (or unixodbc) and libiodbc2 together anymore. So the potential problem will at least be gone there (for as long as that lasts).

{noformat}
$ apt-cache show libmyodbc | grep libiodbc2
Recommends: libodbc1 | libiodbc2
Breaks: libiodbc2, odbcinst1debian2 (<< 2.2.14p2-3), unixodbc (<< 2.2.14p2-3)
{noformat}

:P
                
> Compiling res_odbc against iODBC instead of unixodbc produces runtime errors
> ----------------------------------------------------------------------------
>
>                 Key: ASTERISK-22459
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-22459
>             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
>         Attachments: extrafull, issueA22459_warn_when_using_iodbc.patch
>
>
> 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