[asterisk-bugs] [JIRA] (ASTERISK-22459) username not parsed correctly in res_odbc.conf

[Michael L. Young (JIRA)]

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

Michael L. Young commented on ASTERISK-22459:
---------------------------------------------

This is interesting since, I am currently using res_odbc.conf (mysql) without any issues parsing the username.  

Can you post your full res_odbc.conf file (sanitized)?

A complete debug log may help triage the issue. This document will provide instructions on how to collect debugging logs from an Asterisk machine for the purpose of helping bug marshals troubleshoot an issue: https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information

Thanks



                
> username not parsed correctly in res_odbc.conf
> ----------------------------------------------
>
>                 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
>
> 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