DID with A2B

renatofb · **Posted:** Sun Apr 11, 2010 6:03 pm

I was trying to configure DID for both purpose, Calling Cards and Costumer Use,

I would like to ask for help in order to configure it correctly, as I did not find any conclusive documentation on this.

as I try to dial in what I always get is:

Quote:

NOTICE[4178]: chan_sip.c:20059 handle_request_invite: Call from '' to extension '541130302525' rejected because extension not found.

If anyone could point me to the right direction to have this working properly, I would grateful for any help.

Best regards,
Renato.

manugmedia · **Joined:** Wed Feb 13, 2008 11:11 am **Posts:** 224

Quote:

NOTICE[4178]: chan_sip.c:20059 handle_request_invite: Call from '' to extension '541130302525' rejected because extension not found.

are you sending the DID to 541130302525, should be SIP/541130302525 or IAX2/541130302525

Hope Helps

Rgds
Eamonn

http://www.eatelco.com

renatofb · **Posted:** Sun Apr 11, 2010 11:08 pm

HI Eamonn

Thank you for your reply.

I actually created this DID 541130302525 in the did Section and gave the destination to a account number using SIP/account number.

when the call arrives I receive that messagem,

I believed with the dial plan bellow it would be able to match DID and pass the call to the account I associated to.

Code:

[a2billing-did]
exten => _X.,1,AGI(a2billing.php,2,did)
;exten => _X.,2,Goto(a2billing,${EXTEN},2)
exten => h,1,Hangup

Am I missing something?

Do I have to create any other kind of link in order to recognize the DID?

Rebards,
Renato.

manugmedia · **Joined:** Wed Feb 13, 2008 11:11 am **Posts:** 224

Here is my extions part of DID

Quote:

[a2billing-did]
exten => _X.,1,deadAGI(a2billing.php|1|did)
exten => _X.,2,Hangup

Create DID in the DID section create Destination in the DID Destination section. This should work. If not increase the verbosity to 4 and attach the CLI output here.

Rgds
Eamonn

renatofb · **Posted:** Mon Apr 12, 2010 8:18 pm

Hi Eamonn

I had exactly same dialplan, but I copied and paste anyway,

this is what I get

Quote:

[root@localhost agi-bin]# asterisk -vvvvr
Asterisk 1.6.2.6, Copyright (C) 1999 - 2010 Digium, Inc. and others.
Created by Mark Spencer <[email protected]>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
== Parsing '/etc/asterisk/asterisk.conf': == Found
Running as group 'asterisk'
== Parsing '/etc/asterisk/extconfig.conf': == Found
Connected to Asterisk 1.6.2.6 currently running on localhost (pid = 14748)
Verbosity is at least 4
== Using SIP RTP CoS mark 5
[Apr 12 16:49:36] NOTICE[14782]: chan_sip.c:20059 handle_request_invite: Call from '' to extension '541130302525' rejected because extension not found.
localhost*CLI>

I created a DID and directed it to a sip customer but it seems that inbound is not passing it to a2billing.php

manugmedia · **Joined:** Wed Feb 13, 2008 11:11 am **Posts:** 224

Quote:

Connected to Asterisk 1.6.2.6

Right, running asterisk 1.6, well i have no machine running the version so over to those who have 1.6 installed.

Rgds
Eamonn

http://www.eatelco.com

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Hi

In the first instance, you need to replace the |'s with ,'s (pipes with commas) in line with Asterisk 1.6 dial plan.

in the second instance, if the sip peers are not registering correctly, I would refer you to this post, viewtopic.php?f=13&t=7476

Joe

renatofb · **Posted:** Mon Apr 12, 2010 10:24 pm

Joe, you are right

it seems that realtime is not getting access to database.
I checked and database configuration is correct informed in res_mysql.conf and extconfig.conf

Quote:

Verbosity was 3 and is now 4
== Using SIP RTP CoS mark 5
[Apr 12 19:03:14] WARNING[16210]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: mya2billing (check res_mysql.conf)
[Apr 12 19:03:14] WARNING[16210]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: mya2billing (check res_mysql.conf)
[Apr 12 19:03:14] WARNING[16210]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: mya2billing (check res_mysql.conf)
[Apr 12 19:03:14] WARNING[16210]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: mya2billing (check res_mysql.conf)
[Apr 12 19:03:14] WARNING[16210]: res_config_mysql.c:431 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'mya2billing' (check res_mysql.conf)
[Apr 12 19:03:14] WARNING[16210]: res_config_mysql.c:431 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'mya2billing' (check res_mysql.conf)
[Apr 12 19:03:14] NOTICE[16210]: chan_sip.c:20059 handle_request_invite: Call from '' to extension '541130302525' rejected because extension not found.

this is my res_mysql.conf

Code:

[general]
dbhost = localhost
dbname = mya2billing
dbuser = a2billinguser
dbpass = a2billing
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

any idea what might be wrong?

The odd thing is that sip users are beeing created in the database.

manugmedia · **Joined:** Wed Feb 13, 2008 11:11 am **Posts:** 224

how is your extconfig.conf setup?

mine

Quote:

sipusers => mysql,mya2billing,cc_sip_buddies
sippeers => mysql,mya2billing,cc_sip_buddies

iaxusers => mysql,mya2billing,cc_iax_buddies
iaxpeers => mysql,mya2billing,cc_iax_buddies

voicemail => mysql,mya2billing,voicemail_users

but i understand in 1.6 (still to try it though)

Quote:

sipusers => mysql,general,cc_sip_buddies
sippeers => mysql,general,cc_sip_buddies

iaxusers => mysql,general,cc_iax_buddies
iaxpeers => mysql,general,cc_iax_buddies

voicemail => mysql,general,voicemail_users

Rgds
Eamonn

http://www.eatelco.com

ladude626 · **Joined:** Tue Apr 21, 2009 11:00 pm **Posts:** 18

For Asterisk 1.6.2.6 you have to use a "," instead of a "|". Plus deadAGI() will be deprecated soon so you should use AGI(). You don't want your a2billing system to go dead on the next asterisk update or anything.

Quote:

[a2billing-did]
exten => _X.,1,AGI(a2billing.php,1,did)
exten => h,1,Hangup

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Quote:

Plus deadAGI() will be deprecated soon so you should use AGI(). You don't want your a2billing system to go dead on the next asterisk update or anything.

In bold, underlined and in capital letters so you take notice:-

YOU SHOULD NOT USE AGI - YOU MUST USE deadagi

Joe

renatofb · **Posted:** Tue Apr 13, 2010 5:59 pm

Hi guys,

I tested as suggested, the error message to realtime is gone but still getting the same problem with DID
See the final configuration files bellow.

Quote:

[root@localhost~]# asterisk -vvvvr
Asterisk 1.6.2.6, Copyright (C) 1999 - 2010 Digium, Inc. and others.
Created by Mark Spencer <[email protected]>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
== Parsing '/etc/asterisk/asterisk.conf': == Found
Running as group 'asterisk'
== Parsing '/etc/asterisk/extconfig.conf': == Found
== Binding sipusers to mysql/general/cc_sip_buddies
== Binding sippeers to mysql/general/cc_sip_buddies
== Binding iaxusers to mysql/general/cc_iax_buddies
== Binding iaxpeers to mysql/general/cc_iax_buddies
Connected to Asterisk 1.6.2.6 currently running on localhost (pid = 6430)
Verbosity is at least 4
== Using SIP RTP CoS mark 5
[Apr 13 14:35:09] NOTICE[6460]: chan_sip.c:20059 handle_request_invite: Call from '' to extension '551135169005' rejected because extension not found.
localhost*CLI>

res_mysql.conf file

Code:

[general]
dbhost = localhost
dbname = mya2billing
dbuser = a2billinguser
dbpass = a2billing
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
requirement = createclose

extconfig.conf file

Code:

sipusers => mysql,general,cc_sip_buddies
sippeers => mysql,general,cc_sip_buddies
iaxusers => mysql,general,cc_iax_buddies
iaxpeers => mysql,general,cc_iax_buddies

dial plan in extensions_a2billing.conf

Code:

[a2billing-did]
exten => _X.,1,deadAGI(a2billing.php,2,did)
exten => _X.,2,Hangup

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Hi

What is the result of

Code:

realtime load sipusers name 551135169005

Joe

renatofb · **Posted:** Tue Apr 13, 2010 7:06 pm

Joe, only reminding, this the DID, and it is created and its destination is SIP/3389635046
Okay, result is:

Quote:

localhost*CLI> realtime load sipusers name 551135169005
No rows found matching search criteria.

I would also like to show this other error messaged that just showed up.
it seems there is a missing table, how comes?

Quote:

Verbosity is at least 4
> Saved useragent "Linksys/PAP2T-5.1.6(LS)" for peer 3389635046
> Found column 'id' of type 'int(11)'
> Found column 'id_cc_card' of type 'int(11)'
> Found column 'name' of type 'varchar(80)'
> Found column 'accountcode' of type 'varchar(20)'
> Found column 'regexten' of type 'varchar(20)'
> Found column 'amaflags' of type 'char(7)'
> Found column 'callgroup' of type 'char(10)'
> Found column 'callerid' of type 'varchar(80)'
> Found column 'canreinvite' of type 'varchar(20)'
> Found column 'context' of type 'varchar(80)'
> Found column 'DEFAULTip' of type 'char(15)'
> Found column 'dtmfmode' of type 'char(7)'
> Found column 'fromuser' of type 'varchar(80)'
> Found column 'fromdomain' of type 'varchar(80)'
> Found column 'host' of type 'varchar(31)'
> Found column 'insecure' of type 'varchar(20)'
> Found column 'language' of type 'char(2)'
> Found column 'mailbox' of type 'varchar(50)'
> Found column 'md5secret' of type 'varchar(80)'
> Found column 'nat' of type 'char(3)'
> Found column 'deny' of type 'varchar(95)'
> Found column 'permit' of type 'varchar(95)'
> Found column 'mask' of type 'varchar(95)'
> Found column 'pickupgroup' of type 'char(10)'
> Found column 'port' of type 'char(5)'
> Found column 'qualify' of type 'char(7)'
> Found column 'restrictcid' of type 'char(1)'
> Found column 'rtptimeout' of type 'char(3)'
> Found column 'rtpholdtimeout' of type 'char(3)'
> Found column 'secret' of type 'varchar(80)'
> Found column 'type' of type 'char(6)'
> Found column 'username' of type 'varchar(80)'
> Found column 'disallow' of type 'varchar(100)'
> Found column 'allow' of type 'varchar(100)'
> Found column 'musiconhold' of type 'varchar(100)'
> Found column 'regseconds' of type 'int(11)'
> Found column 'ipaddr' of type 'char(15)'
> Found column 'cancallforward' of type 'char(3)'
> Found column 'fullcontact' of type 'varchar(80)'
> Found column 'setvar' of type 'varchar(100)'
> Found column 'regserver' of type 'varchar(20)'
> Found column 'lastms' of type 'varchar(11)'
> Found column 'defaultuser' of type 'varchar(40)'
> Found column 'auth' of type 'varchar(10)'
> Found column 'subscribemwi' of type 'varchar(10)'
> Found column 'vmexten' of type 'varchar(20)'
> Found column 'cid_number' of type 'varchar(40)'
> Found column 'callingpres' of type 'varchar(20)'
> Found column 'usereqphone' of type 'varchar(10)'
> Found column 'incominglimit' of type 'varchar(10)'
> Found column 'subscribecontext' of type 'varchar(40)'
> Found column 'musicclass' of type 'varchar(20)'
> Found column 'mohsuggest' of type 'varchar(20)'
> Found column 'allowtransfer' of type 'varchar(20)'
> Found column 'autoframing' of type 'varchar(10)'
> Found column 'maxcallbitrate' of type 'varchar(15)'
> Found column 'outboundproxy' of type 'varchar(40)'
> Found column 'rtpkeepalive' of type 'varchar(15)'
[Apr 13 15:28:43] WARNING[6460]: res_config_mysql.c:614 update_mysql: Attempted to update column 'useragent' in table 'cc_sip_buddies', but column does not exist!
localhost*CLI>

renatofb · **Posted:** Tue Apr 13, 2010 7:46 pm

And if I issue that command against a sip customer like 3389635046
(this is the sipuser I am trying to connect the DID 551135169005 and in a2billing is set destination SIP/3389635046)

Quote:

localhost*CLI> realtime load sipusers name 3389635046
Column Name Column Value
-------------------- --------------------
id 3
id_cc_card 1
name 3389635046
accountcode 3389635046
regexten 3389635046
amaflags billing
callerid 997362868477128
context a2billing
dtmfmode RFC2833
host dynamic
nat yes
port 5061
qualify no
secret 4244235432
type friend
username 3389635046
allow ulaw,alaw,gsm,g729
regseconds 1271190492
ipaddr 10.0.1.201
cancallforward yes
lastms 0
localhost*CLI>

provided by Star2Billing S.L.

DID with A2B

Who is online