I finally figured out the correct settings for my install. PBXinaflash 1.5 CentOS 5.4 x64 bit, Asterisk 1.6.1.10 (addons 1.6.1.1), A2billing 1.6 Hickory.
One question that I have is why should the extconfig.conf file use "general" instead of a2billing data base name?
Make sure you set A2billing Use Realtime "use_realtime" to "Yes" under "System Settings"-->"Global List". Also reboot your box after you have made all the changes and it should work. ENJOY!
Here are my config files:
/ect/asterisk/extconfig.conf
Code:
iaxusers => mysql,general,cc_iax_buddies
iaxpeers => mysql,general,cc_iax_buddies
sipusers => mysql,general,cc_sip_buddies
sippeers => mysql,general,cc_sip_buddies
extensions => mysql,general,cc_sip_buddies
/ect/asterisk/res_mysql.conf
Code:
[general]
dbhost = 127.0.0.1
dbname = mya2billing
dbuser = a2billinguser
dbpass = YOURPASS
dbport = 3306
;dbsock = /var/lib/mysql/mysql.sock
/etc/a2billing.conf
Code:
[database]
hostname = localhost
; port for postgres is 5432 by default
port = 3306
user = a2billinguser
password = YOURPASS
dbname = mya2billing
; dbtype setting can either be mysql or postgres
dbtype = mysql