Its work now... Thanks...
Here are the change I made:
My Trixbox server with A2B installed use the IP 192.168.0.XXX and my Fedora 8 server with Mysql installed use the IP 192.168.0.YYY.
A2B need to use the Fedora 8 mysql server. so I create a2billinguser with the GRANT PRIVILEGES on my F8 mysql database like this:
[Trixbox1.local~]#echo "GRANT ALL PRIVILEGES ON mya2billing.* TO 'a2billinguser'@'192.168.0.XXX' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -p
for to be able to login in mya2billing database on my local server (Fedora
:
[fedora@localhost]#echo "GRANT ALL PRIVILEGES ON mya2billing.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -p
I try to log into mysql server from my trixbox and its worked.
Modify a2billing.conf to use external database:
[Trixbox1.local~]#vi /etc/asterisk/a2billing.conf
[database]
hostname = 192.168.0.YYY
port = 5432
user = a2billinguser
password = a2billing
dbname = mya2billing
dbtype = mysql
Restart all service:
service mysqld restart
service httpd restart
Test... GOOOD!!!