asterisk2billing.org
http://forum.asterisk2billing.org/

A2billing Realtime with Piaf configuration FIXED
http://forum.asterisk2billing.org/viewtopic.php?f=33&t=7197
Page 1 of 1

Author:  zane9362 [ Fri Feb 26, 2010 1:34 pm ]
Post subject:  A2billing Realtime with Piaf configuration FIXED

I have a fresh install of latest PIAF and A2B 1.6. I am having an issue with SIP authentication. When I change any SIP property through the A2B GUI the additional_a2billing_sip.conf is not being updated and all SIP client authentication fails. I have tried set rights on the file to 777 and that did not work. As of right now the file owner is asterisk and rights 664. Does any one know where I am going wrong with my permissions settings. Thanks!

Author:  jroper [ Fri Feb 26, 2010 3:35 pm ]
Post subject:  Re: SIP authentication

set use_realtime to no

Author:  zane9362 [ Fri Feb 26, 2010 3:59 pm ]
Post subject:  Re: SIP authentication

Thank you Joe! Why would this not work in the current form with real time ON? Did I miss something during the setup for real time to work correctly. I would rather use real time rather than config files. Thanks again!

BTW I have made sure that all realtime features are enabled according to this post.
viewtopic.php?f=21&t=6640&hilit=use_realtime

Author:  bruce [ Fri Feb 26, 2010 4:42 pm ]
Post subject:  Re: SIP authentication

I don't think PIAF is using asterisk real-time as it uses FreePBX as well. I think the post you pointed to only sets A2Billing to access real-time only if your asterisk is configured to use real-time as well, which I don't think it is in case of FreePBX.

I reserve the right to be wrong on this :-)

Author:  jroper [ Fri Feb 26, 2010 4:52 pm ]
Post subject:  Re: SIP authentication

Asterisk can use both text files and realtime, and because FreePBX does not use realtime, A2Billing can, but you do have to configure it.

Joe

Author:  zane9362 [ Fri Feb 26, 2010 5:37 pm ]
Post subject:  Re: SIP authentication ARA

Sorry but I'm a bit confused now. PIAF is compiled for ARA by default correct Joe? So in effect all I should have to do is enable A2b's/Asterisk settings as I made referenced to in the previous link correct? If this is true then I have completed the setup and ARA w A2b is still not working correctly.

Author:  jroper [ Fri Feb 26, 2010 5:43 pm ]
Post subject:  Re: SIP authentication

I've not checked, but you can check yourself with make menuselect in the /usr/src/asterisk-addons directory.

/var/log/asterisk/full should give you more information, and running some of the realtime commands to check your connection will help too.

Joe

Author:  zane9362 [ Sat Feb 27, 2010 2:03 pm ]
Post subject:  Re: SIP authentication with ARA

Yes PIAF does have ARA installed by default.

Here is the issue ARA does not see mya2billing database or res_config_mysql.c does not for some reason. Log and config files below. Am I missing a setting or config file? Thanks again for the help.

-log file-
Code:
[2010-02-27 01:44:17] WARNING[2937] res_config_mysql.c: MySQL RealTime: Invalid database specified: mya2billing
[2010-02-27 01:44:17] WARNING[2937] res_config_mysql.c: MySQL RealTime: Invalid database specified: mya2billing
[2010-02-27 01:44:17] NOTICE[2937] chan_sip.c: Registration from '<sip:[email protected]>' failed for '192.168.2.16' - No matching peer found


-a2bconfig-
Code:
[database]
hostname = localhost
; port for postgres is 5432 by default
port = 3360
user = a2billinguser
password = XXXXXX
dbname = mya2billing
; dbtype setting can either be mysql or postgres
dbtype = mysql


-res_mysql.conf-
Code:
[general]
dbhost = 127.0.0.1
dbname = mya2billing
dbuser = a2billinguser
dbpass = XXXXXX
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock


-extconfig.conf-
Code:
iaxusers => mysql,mya2billing,cc_iax_buddies
iaxpeers => mysql,mya2billing,cc_iax_buddies
sipusers => mysql,mya2billing,cc_sip_buddies
sippeers => mysql,mya2billing,cc_sip_buddies
extensions => mysql,mya2billing,cc_sip_buddies


-mysql log-
Code:
100227 01:41:09  mysqld started
100227  1:41:10  InnoDB: Started; log sequence number 0 43655
100227  1:41:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution


btw creating an ext and connecting to an ext under freepbx works fine.

Author:  zane9362 [ Sun Feb 28, 2010 6:23 pm ]
Post subject:  Re: A2billing and Asterisk Realtime ARA config example

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

Author:  jroper [ Mon Mar 01, 2010 8:01 am ]
Post subject:  Re: A2billing Realtime with Piaf configuration FIXED

Hi

I ran into this problem this AM.

On version 1.4 of asterisk it seems you have to put the database name:
e.g.
sippeers => mysql,a2billing14,cc_sip_buddies

In version 1.6 of asterisk, the context name of the database connection settings in res_mysql.conf

e.g.
sippeers => mysql,general,cc_sip_buddies

Joe

Author:  ladude626 [ Thu Apr 08, 2010 1:59 am ]
Post subject:  Re: A2billing Realtime with Piaf configuration FIXED

Great Post!

This will greatly increase performance on my server and eliminate the need to reload asterisk whenever a new user signup.

Author:  flatpack [ Thu Apr 15, 2010 8:07 am ]
Post subject:  Re: A2billing Realtime with Piaf configuration FIXED

this is really nice post, will help me too

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/