Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Fri Mar 29, 2024 10:51 am
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 12 posts ] 
Author Message
 Post subject: A2billing Realtime with Piaf configuration FIXED
PostPosted: Fri Feb 26, 2010 1:34 pm 
Offline

Joined: Mon Apr 06, 2009 1:01 am
Posts: 14
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!


Last edited by zane9362 on Sun Feb 28, 2010 6:25 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: SIP authentication
PostPosted: Fri Feb 26, 2010 3:35 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
set use_realtime to no


Top
 Profile  
 
 Post subject: Re: SIP authentication
PostPosted: Fri Feb 26, 2010 3:59 pm 
Offline

Joined: Mon Apr 06, 2009 1:01 am
Posts: 14
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


Top
 Profile  
 
 Post subject: Re: SIP authentication
PostPosted: Fri Feb 26, 2010 4:42 pm 
Offline

Joined: Wed Mar 15, 2006 11:58 pm
Posts: 325
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 :-)


Top
 Profile  
 
 Post subject: Re: SIP authentication
PostPosted: Fri Feb 26, 2010 4:52 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
 Post subject: Re: SIP authentication ARA
PostPosted: Fri Feb 26, 2010 5:37 pm 
Offline

Joined: Mon Apr 06, 2009 1:01 am
Posts: 14
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.


Top
 Profile  
 
 Post subject: Re: SIP authentication
PostPosted: Fri Feb 26, 2010 5:43 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
 Post subject: Re: SIP authentication with ARA
PostPosted: Sat Feb 27, 2010 2:03 pm 
Offline

Joined: Mon Apr 06, 2009 1:01 am
Posts: 14
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.


Top
 Profile  
 
 Post subject: Re: A2billing and Asterisk Realtime ARA config example
PostPosted: Sun Feb 28, 2010 6:23 pm 
Offline

Joined: Mon Apr 06, 2009 1:01 am
Posts: 14
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


Top
 Profile  
 
 Post subject: Re: A2billing Realtime with Piaf configuration FIXED
PostPosted: Mon Mar 01, 2010 8:01 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
 Post subject: Re: A2billing Realtime with Piaf configuration FIXED
PostPosted: Thu Apr 08, 2010 1:59 am 
Offline

Joined: Tue Apr 21, 2009 11:00 pm
Posts: 18
Great Post!

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


Top
 Profile  
 
 Post subject: Re: A2billing Realtime with Piaf configuration FIXED
PostPosted: Thu Apr 15, 2010 8:07 am 
Offline
User avatar

Joined: Fri Sep 18, 2009 5:46 pm
Posts: 132
Location: hhhhmmmmm
this is really nice post, will help me too


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 19 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group