a2billing connection failed

Discussion in 'General' started by souxinh, Apr 11, 2011.

  1. souxinh

    Joined:
    Apr 6, 2010
    Messages:
    36
    Likes Received:
    0
    I reset the password for a2billing using mysql admin but got error message saying the mysql.priv flush fail/no found. now when I click on calling card, it show connection failed and when I use the phone, it said good bye and disconnect.

    Mysql show no a2billing user, I added in a2billing user with a2billing password still not working.

    what is the default a2billing username and password and privilege? Please let me know how to resolved this please....anyone....Help
     
  2. jgutierrez

    Joined:
    Feb 28, 2008
    Messages:
    5,737
    Likes Received:
    0
    Take a look at /etc/asterisk/a2billing.conf or /etc/a2billing.conf

    user = a2billinguser
    password = a2billing
    dbname = mya2billing
     
  3. souxinh

    Joined:
    Apr 6, 2010
    Messages:
    36
    Likes Received:
    0
    Hi, thank for response.

    I look like the connection from elastix to calling card problem. (like from elastix web page, you click on extras and then calling card tab. That when it show connection failed)

    in my a2billing.conf
    it already shown same.

    user = a2billinguser
    password = a2billing
    dbname = mya2billing

    hmm...what went wrong?????
     
  4. souxinh

    Joined:
    Apr 6, 2010
    Messages:
    36
    Likes Received:
    0
    Re:a2billing connection failed ****Solved*****

    First, turn display error message on and error startup on in php.ini

    Shown as follow;
    ERROR 1045 (28000): Access denied for user 'a2billing'@'localhost' (using password: YES) from /var/www/html/a2billing/adodb/lib/......

    run
    echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -pxxxxxxxx

    and woopi, it back to normal again.

    Thanks everyone.

    Souxinh
     

Share This Page