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

A2B v. 1.9.4 & Asterisk 1.8
http://forum.asterisk2billing.org/viewtopic.php?f=34&t=9211		 Page 1 of 1
Author:  ubunter [ Sat Oct 08, 2011 12:53 pm ]
Post subject:  A2B v. 1.9.4 & Asterisk 1.8
Hello,
As I previously said, in other threads, and in my own tutorial to setup a2billing with asterisk 1.8, actually 1.8.7, current version today, all it seem to be properly working, and I have it fully in production.

But asterisk seem to be seeking for his kids, and don't find them, where the Cli are complaining with several warrings, and errors, in the moment when user are placing calls, messages such as:

Quote:
[Oct 1 15:49:50] ERROR[1831]: channel.c:7663 ast_get_group: Syntax error parsing group configuration 'NULL' at 'NULL'. Ignoring.
[Oct 1 15:49:50] WARNING[1831]: acl.c:422 ast_append_ha: Invalid IP address: NULL
[Oct 1 15:49:50] ERROR[1831]: chan_sip.c:26756 build_peer: Bad ACL entry in configuration line 0 : NULL
[Oct 1 15:49:50] ERROR[1831]: channel.c:7663 ast_get_group: Syntax error parsing group configuration 'NULL' at 'NULL'. Ignoring.
[Oct 1 15:49:50] WARNING[1831]: chan_sip.c:26699 build_peer: no value given for outbound proxy on line 0 of
[Oct 1 15:50:48] WARNING[1807]: acl.c:579 resolve_first: Unable to lookup ''
[Oct 1 15:50:50] ERROR[1807]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("", "(null)", ...): Name or service not known


Assuming that we're working in RealTime service.

The first consideration to appoint is, that Asterisk 1.8.7 when turn on the realtime, he reall all, everything from the DB, and nothing more from sip.conf or iax.conf files. So that's mean, the actual a2billing DB table are missing much failds, and need to be remapped to that need.
Because according to the contrib, included in asterisk 1.8.7 to setup the realtime DB, the DB have to incllude the following:

Code:
CREATE TABLE IF NOT EXISTS `sipfriends` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(10) NOT NULL,
      `ipaddr` varchar(15) DEFAULT NULL,
      `port` int(5) DEFAULT NULL,
      `regseconds` int(11) DEFAULT NULL,
      `defaultuser` varchar(10) DEFAULT NULL,
      `fullcontact` varchar(35) DEFAULT NULL,
      `regserver` varchar(20) DEFAULT NULL,
      `useragent` varchar(20) DEFAULT NULL,
      `lastms` int(11) DEFAULT NULL,
      `host` varchar(40) DEFAULT NULL,
      `type` enum('friend','user','peer') DEFAULT NULL,
      `context` varchar(40) DEFAULT NULL,
      `permit` varchar(40) DEFAULT NULL,
      `deny` varchar(40) DEFAULT NULL,
      `secret` varchar(40) DEFAULT NULL,
      `md5secret` varchar(40) DEFAULT NULL,
      `remotesecret` varchar(40) DEFAULT NULL,
      `transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,
      `dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,
      `directmedia` enum('yes','no','nonat','update') DEFAULT NULL,
      `nat` enum('yes','no','never','route') DEFAULT NULL,
      `callgroup` varchar(40) DEFAULT NULL,
      `pickupgroup` varchar(40) DEFAULT NULL,
      `language` varchar(40) DEFAULT NULL,
      `allow` varchar(40) DEFAULT NULL,
      `disallow` varchar(40) DEFAULT NULL,
      `insecure` varchar(40) DEFAULT NULL,
      `trustrpid` enum('yes','no') DEFAULT NULL,
      `progressinband` enum('yes','no','never') DEFAULT NULL,
      `promiscredir` enum('yes','no') DEFAULT NULL,
      `useclientcode` enum('yes','no') DEFAULT NULL,
      `accountcode` varchar(40) DEFAULT NULL,
      `setvar` varchar(40) DEFAULT NULL,
      `callerid` varchar(40) DEFAULT NULL,
      `amaflags` varchar(40) DEFAULT NULL,
      `callcounter` enum('yes','no') DEFAULT NULL,
      `busylevel` int(11) DEFAULT NULL,
      `allowoverlap` enum('yes','no') DEFAULT NULL,
      `allowsubscribe` enum('yes','no') DEFAULT NULL,
      `videosupport` enum('yes','no') DEFAULT NULL,
      `maxcallbitrate` int(11) DEFAULT NULL,
      `rfc2833compensate` enum('yes','no') DEFAULT NULL,
      `mailbox` varchar(40) DEFAULT NULL,
      `session-timers` enum('accept','refuse','originate') DEFAULT NULL,
      `session-expires` int(11) DEFAULT NULL,
      `session-minse` int(11) DEFAULT NULL,
      `session-refresher` enum('uac','uas') DEFAULT NULL,
      `t38pt_usertpsource` varchar(40) DEFAULT NULL,
      `regexten` varchar(40) DEFAULT NULL,
      `fromdomain` varchar(40) DEFAULT NULL,
      `fromuser` varchar(40) DEFAULT NULL,
      `qualify` varchar(40) DEFAULT NULL,
      `defaultip` varchar(40) DEFAULT NULL,
      `rtptimeout` int(11) DEFAULT NULL,
      `rtpholdtimeout` int(11) DEFAULT NULL,
      `sendrpid` enum('yes','no') DEFAULT NULL,
      `outboundproxy` varchar(40) DEFAULT NULL,
      `callbackextension` varchar(40) DEFAULT NULL,
      `registertrying` enum('yes','no') DEFAULT NULL,
      `timert1` int(11) DEFAULT NULL,
      `timerb` int(11) DEFAULT NULL,
      `qualifyfreq` int(11) DEFAULT NULL,
      `constantssrc` enum('yes','no') DEFAULT NULL,
      `contactpermit` varchar(40) DEFAULT NULL,
      `contactdeny` varchar(40) DEFAULT NULL,
      `usereqphone` enum('yes','no') DEFAULT NULL,
      `textsupport` enum('yes','no') DEFAULT NULL,
      `faxdetect` enum('yes','no') DEFAULT NULL,
      `buggymwi` enum('yes','no') DEFAULT NULL,
      `auth` varchar(40) DEFAULT NULL,
      `fullname` varchar(40) DEFAULT NULL,
      `trunkname` varchar(40) DEFAULT NULL,
      `cid_number` varchar(40) DEFAULT NULL,
      `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,
      `mohinterpret` varchar(40) DEFAULT NULL,
      `mohsuggest` varchar(40) DEFAULT NULL,
      `parkinglot` varchar(40) DEFAULT NULL,
      `hasvoicemail` enum('yes','no') DEFAULT NULL,
      `subscribemwi` enum('yes','no') DEFAULT NULL,
      `vmexten` varchar(40) DEFAULT NULL,
      `autoframing` enum('yes','no') DEFAULT NULL,
      `rtpkeepalive` int(11) DEFAULT NULL,
      `call-limit` int(11) DEFAULT NULL,
      `g726nonstandard` enum('yes','no') DEFAULT NULL,
      `ignoresdpversion` enum('yes','no') DEFAULT NULL,
      `allowtransfer` enum('yes','no') DEFAULT NULL,
      `dynamic` enum('yes','no') DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `name` (`name`),
      KEY `ipaddr` (`ipaddr`,`port`),
      KEY `host` (`host`,`port`)
) ENGINE=MyISAM;


So, as you can see, there's several fields missing, and several different expectations in the fields, related to the default values in comparison with the actual a2billing DB structurer.

Same issue with Iax, let's concentrate for the moment into SIP.

SO, what i did, first, I update the existing a2billing tables to adjust the default values expectation for asterisk, unless some of them, as I don't agree with this script at all, ie. the `host` varchar(40) DEFAULT NULL, for me should be `host` varchar(40) DEFAULT dynamic, ...etc. The relevant change in asterisk 1.8.7 is when asterisk deprecate the reinvite directive and sustitute it by directmedia, whih have to be: `directmedia` enum('yes','no','nonat','update') DEFAULT yes, not null as the script establish... etc

But changing that faild name in a2billing DB from canreinvite to directmedia, cause me problem in readin the DB, when I go to a2billing gui admin, and click in customers, voip-setting, I can't edit nothing, because there's an error in reading the database by the A2B_entity_friend.php, I tried to edit that's one to meet the DB, but I couldn't find that faild...


The suggestion is, to create a new structured DB for asterisk 1.8.7, and between this one, and the actual a2billing DB, create a view, to appoint asterisk to read from that view all needed details, and review all over the default faild to meet our configuration, because as I see, asterisk is not reading nothing from sip.conf general section... I hope I'm mistaking...

So, this is the ideas, I did't wrote to create the DB view yet, because just with editing the cc_sip_buddies table, I don't see any warring neither error more... the errors for the moment are coming from the iax table, when I user, over IAX are placing calls... so let's say, eventually solved... even the message is error, but it don't seem to be critical, as asterisk is looking for line 0 in sip.conf, he's referring in reality to a specific field in the DB to that expected DB structure ( field name, header...etc).

Regards,
Author:  vulcan [ Sat Oct 08, 2011 1:43 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Quote:
The suggestion is, to create a new structured DB for asterisk 1.8.7, and between this one, and the actual a2billing DB, create a view, to appoint asterisk to read from that view all needed details, and review all over the default faild to meet our configuration, because as I see, asterisk is not reading nothing from sip.conf general section... I hope I'm mistaking...


If you have two sip peers tables with a view overlapping them, you will have a different problem. Asterisk needs to update some of the fields during realtime. Mysql only allows update when the VIEW has one to one relationship with the source table.

In other words, have only one table. Add the fields you want to the cc_sip_buddies and create the VIEW with the names mapped the way you want.

I cant verify this behaviour you are getting because it's been some time since I used realtime with asterisk handling the registration.
Author:  ubunter [ Sat Oct 08, 2011 3:09 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
vulcan wrote:
Quote:
If you have two sip peers tables with a view overlapping them, you will have a different problem. Asterisk needs to update some of the fields during realtime. Mysql only allows update when the VIEW has one to one relationship with the source table.


Hmmmm, good point, this what I wanted to hear, and inssure,,, so making a simple view into two tables it's not a solution...

Quote:
In other words, have only one table. Add the fields you want to the cc_sip_buddies and create the VIEW with the names mapped the way you want.

I cant verify this behaviour you are getting because it's been some time since I used realtime with asterisk handling the registration.


Ok, this is the way Which I already had been started. First I alter the actual a2billing tables according what Asterisk Expect, and the error message, in sip just disappeared, so the experiment work. Now, I have a list about expected field to add to the DB, in this case, it would be more practical just to add this fields into a2billing table. A2billing will not read them because they useless for a2billing, and asterisk will find them as expected, and will stop to complain.

What I'm thinking, and this is the strange question, that some fields, as I said before, they should be in the general section of sip.conf, and what's mean is asterisk not reading nothing from the general section, so whatever directive I need to implement into sip, we will have to add it as a new field into the DB, or if not, asterisk will never read it... right??
Author:  vulcan [ Sat Oct 08, 2011 4:31 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Quote:
What I'm thinking, and this is the strange question, that some fields, as I said before, they should be in the general section of sip.conf, and what's mean is asterisk not reading nothing from the general section, so whatever directive I need to implement into sip, we will have to add it as a new field into the DB, or if not, asterisk will never read it... right??


You have to understand that the general section carries the basic defaults for the channel and devices attached to the channel. You should create a sip.conf with these.

The devices attached to the channel like a peer has it own set of parameters which takes precedence over the general settings where they overlap.

You can find what parameters allowed for the peer in the config/sip_sample.conf provided with the asterisk source code near the bottom. And also what parameters allowed for the general section.

You don't have to have every setting in the peer config, just those related to realtime and those you need.
Author:  ubunter [ Sat Oct 08, 2011 6:10 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Thanks Vulcan, but my question and doubt wasn't this exactly.

What I need to know, and insure is:

Q. Dose a2billing table order are case sensitive? I mean, dose there any problem in a2billing if I alter the fields order in cc_sip_buddies, and cc_iax_buddies, by inserting the missing fails required by asterisk?

Thanks,
Author:  vulcan [ Sat Oct 08, 2011 10:52 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
It's better to put them all at the end and leave the buddies table fairly intact unless you have a good reason to change the order.

The only precedence issues I know about are "allow" "disallow" and "deny" "permit" they must not be reordered.
Author:  ubunter [ Sun Oct 09, 2011 10:13 am ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Ok, so summarizing, Asterisk 1.8 miss from cc_sip_buddies table the following fields:

Code:
      `transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,
      `directmedia` enum('yes','no','nonat','update') DEFAULT NULL,
      `trustrpid` enum('yes','no') DEFAULT NULL,
      `promiscredir` enum('yes','no') DEFAULT NULL,
      `useclientcode` enum('yes','no') DEFAULT NULL,
      `allowoverlap` enum('yes','no') DEFAULT NULL,
      `videosupport` enum('yes','no') DEFAULT NULL,
      `rfc2833compensate` enum('yes','no') DEFAULT NULL,
      `session-timers` enum('accept','refuse','originate') DEFAULT NULL,
      `session-expires` int(11) DEFAULT NULL,
      `session-minse` int(11) DEFAULT NULL,
      `session-refresher` enum('uac','uas') DEFAULT NULL,
      `t38pt_usertpsource` varchar(40) DEFAULT NULL,
      `sendrpid` enum('yes','no') DEFAULT NULL,
      `callbackextension` varchar(40) DEFAULT NULL,
      `registertrying` enum('yes','no') DEFAULT NULL,
      `timert1` int(11) DEFAULT NULL,
      `timerb` int(11) DEFAULT NULL,
      `qualifyfreq` int(11) DEFAULT NULL,
      `constantssrc` enum('yes','no') DEFAULT NULL,
      `contactpermit` varchar(40) DEFAULT NULL,
      `contactdeny` varchar(40) DEFAULT NULL,
      `textsupport` enum('yes','no') DEFAULT NULL,
      `faxdetect` enum('yes','no') DEFAULT NULL,
      `buggymwi` enum('yes','no') DEFAULT NULL,
      `fullname` varchar(40) DEFAULT NULL,
      `trunkname` varchar(40) DEFAULT NULL,
      `mohinterpret` varchar(40) DEFAULT NULL,
      `parkinglot` varchar(40) DEFAULT NULL,
      `hasvoicemail` enum('yes','no') DEFAULT NULL,
      `call-limit` int(11) DEFAULT NULL,
      `g726nonstandard` enum('yes','no') DEFAULT NULL,
      `ignoresdpversion` enum('yes','no') DEFAULT NULL,
      `dynamic` enum('yes','no') DEFAULT NULL,



So, I went into that table and I add all over this missing fields and my actual cc_sip_buddies look like this:
Quote:
mysql> desc cc_sip_buddies;
+--------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| id_cc_card | int(11) | NO | | 0 | |
| name | varchar(80) | NO | UNI | NULL | |
| accountcode | varchar(40) | YES | | NULL | |
| regexten | varchar(40) | YES | | NULL | |
| amaflags | varchar(40) | YES | | NULL | |
| callgroup | varchar(40) | YES | | NULL | |
| callerid | varchar(40) | YES | | NULL | |
| canreinvite | varchar(20) | NO | | YES | |
| context | varchar(40) | YES | | NULL | |
| defaultip | varchar(40) | YES | | NULL | |
| dtmfmode | enum('rfc2833','info','shortinfo','inband','auto') | NO | | auto | |
| fromuser | varchar(40) | YES | | NULL | |
| fromdomain | varchar(40) | YES | | NULL | |
| host | varchar(40) | NO | MUL | dynamic | |
| insecure | varchar(40) | YES | | NULL | |
| language | varchar(40) | YES | | NULL | |
| mailbox | varchar(40) | YES | | NULL | |
| md5secret | varchar(40) | YES | | NULL | |
| nat | enum('yes','no','never','route') | YES | | NULL | |
| deny | varchar(40) | YES | | NULL | |
| permit | varchar(40) | YES | | NULL | |
| mask | varchar(95) | NO | | NULL | |
| pickupgroup | varchar(40) | YES | | NULL | |
| port | int(5) | YES | MUL | NULL | |
| qualify | varchar(40) | YES | | NULL | |
| restrictcid | char(1) | YES | | NULL | |
| rtptimeout | int(11) | YES | | NULL | |
| rtpholdtimeout | int(11) | YES | | NULL | |
| secret | varchar(40) | YES | | NULL | |
| type | enum('friend','user','peer') | YES | | NULL | |
| username | varchar(80) | NO | | NULL | |
| disallow | varchar(40) | NO | | all | |
| allow | varchar(40) | YES | | NULL | |
| musiconhold | varchar(100) | NO | | NULL | |
| regseconds | int(11) | YES | | NULL | |
| ipaddr | varchar(15) | YES | MUL | NULL | |
| cancallforward | char(3) | YES | | yes | |
| fullcontact | varchar(80) | NO | | NULL | |
| setvar | varchar(40) | YES | | NULL | |
| regserver | varchar(20) | YES | | NULL | |
| lastms | int(11) | YES | | NULL | |
| defaultuser | varchar(10) | YES | | NULL | |
| auth | varchar(40) | YES | | NULL | |
| subscribemwi | enum('yes','no') | YES | | NULL | |
| vmexten | varchar(40) | YES | | NULL | |
| cid_number | varchar(40) | YES | | NULL | |
| callingpres | enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') | YES | | NULL | |
| usereqphone | enum('yes','no') | YES | | NULL | |
| incominglimit | varchar(10) | NO | | | |
| subscribecontext | varchar(40) | NO | | | |
| musicclass | varchar(20) | NO | | | |
| mohsuggest | varchar(40) | YES | | NULL | |
| allowtransfer | enum('yes','no') | NO | | no | |
| autoframing | enum('yes','no') | YES | | NULL | |
| maxcallbitrate | int(11) | YES | | NULL | |
| outboundproxy | varchar(40) | NO | | | |
| rtpkeepalive | int(11) | YES | | NULL | |
| useragent | varchar(20) | YES | | NULL | |
| callcounter | enum('yes','no') | YES | | NULL | |
| busylevel | int(11) | YES | | NULL | |
| allowsubscribe | enum('yes','no') | YES | | NULL | |
| progressinband | enum('yes','no','never') | YES | | NULL | |
| transport | enum('udp','tcp','udp,tcp','tcp,udp') | YES | | NULL | |
| directmedia | enum('yes','no','nonat','update') | YES | | NULL | |
| trustrpid | enum('yes','no') | YES | | NULL | |
| promiscredir | enum('yes','no') | YES | | NULL | |
| useclientcode | enum('yes','no') | YES | | NULL | |
| allowoverlap | enum('yes','no') | YES | | NULL | |
| videosupport | enum('yes','no') | YES | | NULL | |
| rfc2833compensate | enum('yes','no') | YES | | NULL | |
| session-timers | enum('accept','refuse','originate') | YES | | NULL | |
| session-expires | int(11) | YES | | NULL | |
| session-minse | int(11) | YES | | NULL | |
| session-refresher | enum('uac','uas') | YES | | NULL | |
| t38pt_usertpsource | varchar(40) | YES | | NULL | |
| sendrpid | enum('yes','no') | YES | | NULL | |
| callbackextension | varchar(40) | YES | | NULL | |
| registertrying | enum('yes','no') | YES | | NULL | |
| timert1 | int(11) | YES | | NULL | |
| timerb | int(11) | YES | | NULL | |
| constantssrc | enum('yes','no') | YES | | NULL | |
| contactpermit | varchar(40) | YES | | NULL | |
| contactdeny | varchar(40) | YES | | NULL | |
| textsupport | enum('yes','no') | YES | | NULL | |
| faxdetect | enum('yes','no') | YES | | NULL | |
| buggymwi | enum('yes','no') | YES | | NULL | |
| fullname | varchar(40) | YES | | NULL | |
| trunkname | varchar(40) | YES | | NULL | |
| mohinterpret | varchar(40) | YES | | NULL | |
| parkinglot | varchar(40) | YES | | NULL | |
| hasvoicemail | enum('yes','no') | YES | | NULL | |
| call-limit | int(11) | YES | | NULL | |
| g726nonstandard | enum('yes','no') | YES | | NULL | |
| ignoresdpversion | enum('yes','no') | YES | | NULL | |
| dynamic | enum('yes','no') | YES | | NULL | |
+--------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
96 rows in set (0.00 sec)


I'm aware that I need to substitute some fields, such as directmedia instead of reinvite...etc, but for the moment, I'm jjust testing this instance!!
So, I went back to asterisk and reload under versobe 5, but I still having the following Warring messages, when sip peers are trying to register:
Quote:
[Oct 9 09:57:13] WARNING[1835]: chan_sip.c:26699 build_peer: no value given for outbound proxy on line 0 of sip.conf.


What mean, is asterisk still missing same field else, but no idea, what more?? Thereof it's only Warring, no error any more...
Author:  ubunter [ Wed Oct 26, 2011 11:54 am ]
Post subject:  SOLVED: A2B v. 1.9.4 & Asterisk 1.8
Hello,
After turning, and testing, this issue I just got it solved, within really simple question....

the getaddr info error, it was coming only in iax registration, and Asterisk 1.8.7 wasn't able to register a2billing iax users.

SOLUTION, so stupid simple ((sorry)),

Just edit the DEFAULTip faild name in cc_iax_buddies to be 'defaultip'. It's apear that asterisk 1.8.7 don't like uppercase in fields name...

Then, we need to fix and be sure that a2billing will not rewrite this, because Asterisk 1.8 need to read the defaultip value as NULL, if not, after second registration, will require tolken, or declare the static Ip of the user. So, to fix this, we need to:
Edit ../form_data/FG_var_friend.inc first by replacing the previous DEFAULTIP to be accurate with the db field as "defaultip". Then be declaring the defailt ip value as NULl by adding the following line after line 126.

Quote:
$defaultip_default= "value='NULL'";


Then fix the requirecalltoken value in cc_iax_buddies as 'auto', and execute that query updating all over your users value.

By the way, Asterisk 1.8 has just deprecate the reinvite directive, so, if you're editing that file, it's time to fix this issue into a2billing also, so, make a serch and replace the value "canreinvite" to by "directmedia". Save the FG_var_friend.inc, and come back to cc_sip_buddies and edit the fail named as canreinvite, to be directmedia, default YES, this will insure you that asterisk will work properly with the new "directmedia", which is really great to perform interconnection spead, reduce PDD, and highly interesting in wholesale and intensive traffic. Insure that positive value for all over existing users.

SOLVED, just reload asterisk, and it's work like charm...

Regards
Author:  sergiocesar [ Wed Dec 28, 2011 11:32 am ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
I think something still missing to do.
I edited something on a customer iax profile and they could no longer authenticate. come to find that the field defaultip is no longer "NULL" but empty "" and that prevents the customer from auth.
where can that be fixed?
I manually changed the database to be NULL again and the customer authenticated immediately.
Author:  acaratt [ Sat Apr 21, 2012 4:18 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Hi,

Did you figure how to update the fields and be able to use the a2billing GUI? If not you are looking at the wrong scrip. Look at FG_var_friend.inc, be careful when you replace the field name cuz there are function with UPPER letters, if you want to be consistent change the filed and function name with the proper case.

I did it and I was able to use A2billing GUI.


Kind regards,

Al
Author:  sergiocesar [ Sun Jul 15, 2012 12:33 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
sergiocesar wrote:
I think something still missing to do.
I edited something on a customer iax profile and they could no longer authenticate. come to find that the field defaultip is no longer "NULL" but empty "" and that prevents the customer from auth.
where can that be fixed?
I manually changed the database to be NULL again and the customer authenticated immediately.


Anyone have a fix for this? still not able to edit the customer IAX setting without manually changing the database to a "(Null)" instead of empty ""
even if all I change is the codec The null value of the defaultip field is changed by a empty or blank.
Adding the line (#126) ($defaultip_default= "value='NULL'";) on file FG_var_friend.inc as suggested above does not fix the problem.
I also noticed that it does the same for language and other fields that are default created as NULL.
Author:  chriswnl [ Thu Sep 27, 2012 1:52 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Having the same issue with NULL vs empty on this. Some hunting around Asterisk docs suggests using a default IP for IAX realtime users of 0.0.0.0 when using realtime. This seems to be working for me, and if it continues to do so, I shall be changing the default value at database level also to 0.0.0.0.
Author:  carlosmp [ Tue Oct 02, 2012 4:09 pm ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
ubunter - seems you forgot the qualifyfreq` int(11) DEFAULT NULL, in the final database. I was comparing the fields to make sure I had them, and saw I had 97...
Author:  donsr [ Mon Mar 11, 2013 1:41 am ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Just wanted to post this so others know..

I updated FreePBX last night and started seeing the below error on the CLI.

Code:
build_peer: '' is not a valid RTP hold time


Simple fix was to set the DEFAULTip field in cc_sip_buddies to 0.0.0.0 as has been suggested here.

Good Day! :laugh:
Author:  jansalex [ Fri Jan 16, 2015 11:58 am ]
Post subject:  Re: A2B v. 1.9.4 & Asterisk 1.8
Hi Donsr,

Simple fix was to set the DEFAULTip field in cc_sip_buddies to 0.0.0.0, don't solve my problem :

WARNING[26558][C-000001d2]: chan_sip.c:30673 build_peer: '' is not a valid RTP hold time at line 0. Using default.
WARNING[26558][C-000001d2]: chan_sip.c:30510 build_peer: no value given for outbound proxy on line 0 of sip.conf
WARNING[26558][C-000001d2]: chan_sip.c:30673 build_peer: '' is not a valid RTP hold time at line 0. Using default.
WARNING[26558][C-000001d2]: chan_sip.c:30510 build_peer: no value given for outbound proxy on line 0 of sip.conf

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