asterisk2billing.org http://forum.asterisk2billing.org/ |
|
How to Access A2Billing datbase? http://forum.asterisk2billing.org/viewtopic.php?f=23&t=6918 |
Page 1 of 1 |
Author: | rboy22007 [ Thu Jan 14, 2010 7:24 pm ] |
Post subject: | How to Access A2Billing datbase? |
hi..i have two trixboxes and both have a2billing installed on them. lets say box A and Box B. what i want to do is share the a2billing database on Box A with Box B. i have changed the database connection in box B a2billing.Conf file: (trixbox1.localdomain is Box A) (trixbox2.localdomain is Box B) [database] hostname = trixbox1.localdomain ; port for postgres is 5432 by default port = 3306 user = a2billing_dbuser password = a2billing_dbpassword dbname = a2billing_dbname ; dbtype setting can either be mysql or postgres dbtype = mysql and in box A i have give the following command to give access to box B: echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'trixbox2.localdomain ' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd mysqladmin create mya2billing -u a2billinguser -pa2billing when log in to a2billing web interface on box B i don't see the data retrieved from box A a2billing. can someone help? is this the right approach? |
Author: | jroper [ Thu Jan 14, 2010 7:45 pm ] |
Post subject: | Re: How to Access A2Billing datbase? |
This is the right approach. Can you ping from one to the other using the domain names? Joe |
Author: | rboy22007 [ Thu Jan 14, 2010 10:29 pm ] |
Post subject: | Re: How to Access A2Billing datbase? |
hi..thanks joe, its working now, i simply put the host name ( host=trixbox1) first i couldn't ping using the name trixbox1.localdomain, then i discovered even though i changed the host name on the network gui interface, it didn't change in etc/hosts, so i changed it there. (127.0.0.1 trixbox2.localdomain trixbox2 localhost.localdomain localhost) i also want to point out that if anyone doing similar setup you need to change the dhch host name in network, default name is trixbox1, if both machines are in the same network, the route will get same name and it might cause conflict. again,thanks for your help joe. |
Author: | rboy22007 [ Mon Jan 18, 2010 12:35 pm ] |
Post subject: | Re: How to Access A2Billing datbase? |
hi... can you also tell me where is the a2b database is located? how do i increase the maximum connection to the database and also limit the number of concurrent calls hitting the asterisk box? thanks. |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |