[unixODBC][MySQL][ODBC 8.0(a) Driver]Access Denied For User

Home » Asterisk Users » [unixODBC][MySQL][ODBC 8.0(a) Driver]Access Denied For User
Asterisk Users 4 Comments

Command:
sudo asterisk -rvvvv

Output:

Running as user ‘asterisk’

Running under group ‘asterisk’

Connected to Asterisk 16.14.0 currently running on localhost (pid = 1925)

[Nov 4 20:35:46] WARNING[2037]: res_odbc.c:1067 odbc_obj_connect:
res_odbc: Error SQLConnect=-1 errno45 [unixODBC][MySQL][ODBC 8.0(a)
Driver]Access denied for user ‘asterisk’@’localhost’ (using password:

How to fix this? Please Help. Thanks.

With Hope,

Prabhakaran

P.S: Work at Stake Because of this Error :frowning_face:

4 thoughts on - [unixODBC][MySQL][ODBC 8.0(a) Driver]Access Denied For User

  • Check that the user ‘asterisk’ is allowed to connect to MySQL from ‘localhost’
    using the password you have (hopefully) defined in /etc/odbc.ini and
    /etc/asterisk/res_odbc.conf

    Antony.

    —
    Don’t procrastinate – put it off until tomorrow.

    Please reply to the list;
    please *don’t* CC me.

    —

  • Hi Sir,
    You are right. The password present in the following file is wrong:
    /etc/asterisk/res_odbc.conf But right now that file is read only. How to make changes in it… Please reply..

    With Hope, Prabhakaran

  • chmod +w /etc/asterisk/res_odbc.conf

    Antony.

    —
    How many Prolog programmers does it take to change a lightbulb?
    No.

    Please reply to the list;
    please *don’t* CC me.

    —

  • Hi Sir, Thanks for your reply. That issue has been fixed now. But after that I am having the below issue:

    Endpoints are unavailable:
    command:
    $ sudo asterisk -rvvvv
    *CLI> pjsip show endpoints

    Output:
    Endpoint:

    I/OAuth:

    Aor:

    Contact:

    Transport:

    Identify:

    Match:
    Channel:

    Exten: CLCID:
    =========================================================================================
    Endpoint: 0000f30A0A01
    Unavailable 0 of inf
    InAuth: 0000f30A0A01/0000f30A0A01
    Aor: 0000f30A0A01 1
    Transport: transport-udp udp 0 0 0.0.0.0:5060

    Endpoint: 0000f30B0B02
    Unavailable 0 of inf
    InAuth: 0000f30B0B02/0000f30B0B02
    Aor: 0000f30B0B02 1
    Transport: transport-udp udp 0 0 0.0.0.0:5060

    Objects found: 2

    localhost*CLI>
    I already have posted a separate mail thread for the issue. Since I haven’t received any reply for more than 12 Hours. I am sharing the same here also.

    With Hope, Prabhakaran