a2billing connection failed

souxinh

Joined
Apr 6, 2010
Messages
36
Likes
0
Points
0
#1
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
 

jgutierrez

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

user = a2billinguser
password = a2billing
dbname = mya2billing
 

souxinh

Joined
Apr 6, 2010
Messages
36
Likes
0
Points
0
#3
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?????
 

souxinh

Joined
Apr 6, 2010
Messages
36
Likes
0
Points
0
#4
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
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,901
Messages
130,885
Members
17,562
Latest member
colak
Top