provided by Star2Billing S.L.

Hi guys,

Has anyone of you used external database for a2billing? if so what is the advantage and disadvantage?

I plan to have a dedicated database server for a2billing, and have a few * boxes and I would like to them to share the same a2billing database, so if one of them is down the others can still be functional.

Thanks in advanced.

Advice please?? Hmm.. i guess we all are using local databases for a2billing setup huh? Has ony tried external database before??

Please let me know. Thanks

I too am wondering if I can have multiple asterisk boxes running a2 off of an external database? And how I would go about doing that.

Thanks

well I do use MySQL database on a server other than one where Asterisk/a2billing is running. What's a big deal? I haven't tested it with 2 or more Asterisk yet, but I do not foresee any problem here.

could please post your steps here

thanks

I have a pair of external MySQL databases running in a replication scenario for redundancy sitting on the inside network of my environment. On the Asterisk side it's a simple matter of pointing your a2billing.conf to the IP/Hostname of your DB, ensuring your database can accept external connections through the grant privileges and of course making sure iptables is not blocking port 3306.

On v1.3 you would add external access privileges something like this in MySQL.

GRANT ALL PRIVILEGES ON a2billing.* TO 'a2admin'@'192.168.1.100' IDENTIFIED BY 'a2adminpassword' WITH GRANT OPTION;

Moving sip/iax-friends can be done with rsync to copy over to your Asterisk server(s).

Hi I'm a neobie in a2billing,

I want to have this setup on my trixbox two...

Trixbox
IP address : 192.168.0.XXX
ran A2Billing and Free PBX

Fedora 8
IP address : 192.168.0.YYY
ran Mysql server

All daemon work fine and I made the wrote here and i receive this mesg when I try to log in my a2b server:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.168.0.YYY' (113) in /var/www/html/A2Billing_UI/lib/adodb/drivers/adodb-mysql.inc.php on line 358
Connection failed

Please help....

Added after 4 minutes:

I open the port 3360 on my fedora 8 server to allow external connexion on mysql server.... same thing.

hi, make sure you have set user permissions on Fedora 8 mysql.

I'm not expert on MySQL but I would imagine you have to grant access to the username/IP address combination as detailed in gcall's post that you repled to.
You need to get to the stage where: from 192.168.0.XXX logs in successfully before A2B will work.

Ok Guys, Many tahks for your quick replys to my preocupation.
I will test it and let you know...

Mery christmas to all

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!!!