Re: [Asterisk-Users] ASTCC not billing

[Bernard Cresencia]

That looks right, the database is being updated properly. The last call 
lasted 9 seconds and cost you 1.5c so it should show up in the database.


You did create a 2-digit card called '21' right?

- Original Message - 
From: Juan Luis Moyano [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion 
asterisk-users@lists.digium.com

Sent: Wednesday, June 29, 2005 12:13 AM
Subject: Re: [Asterisk-Users] ASTCC not billing



Bernard Cresencia wrote:

sorry, I meant my.cnf, not my.conf.

Once logging is enabled, I would do tail -f
/var/log/myslqd.log and watch as the database is being
accessed during a call.



I've done what Bernard suggested and this is my output from mysql.log on
a successful call to number 612 on FWD. I'd like to know if any of you
see something wrong or rare. Thanks a lot.

Time Id CommandArgument
050629  1:02:02   1 Connect [EMAIL PROTECTED] on astcc
050629  1:02:04   1 Query   SELECT * FROM cards WHERE number='21'
 1 Query   SELECT * FROM cards WHERE number='21'
 1 Query   SELECT * FROM cards WHERE number='21'
 1 Query   SELECT * FROM cards WHERE number='21'
 1 Query   UPDATE cards SET used='1801' WHERE
number='21'
 1 Query   UPDATE cards SET inuse='1' WHERE
number='21'
050629  1:02:10   1 Query   SELECT * FROM routes WHERE '612'
RLIKE pattern ORDER BY LENGTH(pattern) DESC
050629  1:02:25   1 Query   SELECT * FROM cards WHERE number='21'
 1 Query   SELECT * FROM trunks WHERE name='FWD'
050629  1:02:37   1 Query   INSERT INTO cdrs
(cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart)
VALUES ('21', '\Coco\ 21', '612', 'FWD', 'ANSWER', '9', '150', 'Wed
Jun 29 01:02:37 2005')
 1 Query   UPDATE cards SET used='1951' WHERE
number='21'
 1 Query   UPDATE cards SET inuse='0' WHERE
number='21'
 1 Query   SELECT * FROM cards WHERE number='21'
 1 Query   UPDATE cards SET used='1951' WHERE
number='21'
 1 Query   UPDATE cards SET inuse='0' WHERE
number='21'
 1 Quit

--
Juan Luis Moyano
[EMAIL PROTECTED]

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users 


___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Ade Agbero]

The reason for the problem is clear below, theASTERISKCDRDB database is being updatedinstead of theASTCCDB database which holds the cdrs and BILLCOST.

How can this problem be corrected???


3 Query UPDATE cards SET used='0' WHERE number='58767059'  3 Query UPDATE cards SET inuse='0' WHERE number='58767059'  3 Query SELECT * FROM cards WHERE number='58767059'  3 Query UPDATE cards SET used='0' WHERE number='58767059'  3 Query UPDATE cards SET inuse='0' WHERE number='58767059'  3 Quit   4 Connect [EMAIL PROTECTED] on asteriskcdrdb  4 Query INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('2005-06-29 05:17:42','\"Mike\" 1234','1234','777','TEST', 'SIP/1234-f285','SIP/213.45.62.117-1732','Dial','SIP/213.45.62.117/19315461298|30|HL(6:6:3)',42,42,'ANSWERED',3,'')Juan Luis Mo
 yano
 [EMAIL PROTECTED] wrote:
Bernard Cresencia wrote: sorry, I meant my.cnf, not my.conf. Once logging is enabled, I would do tail -f /var/log/myslqd.log and watch as the database is being accessed during a call.I've done what Bernard suggested and this is my output from mysql.log ona successful call to number 612 on FWD. I'd like to know if any of yousee something wrong or rare. Thanks a lot.Time Id Command Argument050629 1:02:02 1 Connect [EMAIL PROTECTED] on astcc050629 1:02:04 1 Query SELECT * FROM cards WHERE number='21'1 Query SELECT * FROM cards WHERE number='21'1 Query SELECT * FROM cards WHERE number='21'1 Query SELECT * FROM cards WHERE number='21'1 Query UPDATE cards SET used='1801' WHEREnumber='21'1 Query UPDATE cards SET inuse='1' WHEREnumber='21'050629 1:02:10 1 Query SELECT * FROM routes
  WHERE
 '612'RLIKE pattern ORDER BY LENGTH(pattern) DESC050629 1:02:25 1 Query SELECT * FROM cards WHERE number='21'1 Query SELECT * FROM trunks WHERE name='FWD'050629 1:02:37 1 Query INSERT INTO cdrs(cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart)VALUES ('21', '\"Coco\" 21', '612', 'FWD', 'ANSWER', '9', '150', 'WedJun 29 01:02:37 2005')1 Query UPDATE cards SET used='1951' WHEREnumber='21'1 Query UPDATE cards SET inuse='0' WHEREnumber='21'1 Query SELECT * FROM cards WHERE number='21'1 Query UPDATE cards SET used='1951' WHEREnumber='21'1 Query UPDATE cards SET inuse='0' WHEREnumber='21'1 Quit-- Juan Luis Moyano[EMAIL PROTECTED]___Asterisk-Users mailing listAsterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options
 visit:http://lists.digium.com/mailman/listinfo/asterisk-users
		How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! 
Photos___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Bernard Cresencia]

If astccdb exists, go to the database configuration
page [Configure] and change the database name to the
correct one. You may have to set up permissions on
this database if it wasn't set up before. If it
doesn't exist, use the 'Create Database' button to
create a new one.
--- Ade Agbero [EMAIL PROTECTED] wrote:

 The reason for the problem is clear below, the
 ASTERISKCDRDB database is being updated instead of
 the ASTCCDB database which holds the cdrs and
 BILLCOST.
  
 How can this problem be corrected???
  
 
 3 Query   UPDATE cards SET used='0' WHERE
 number='58767059'
   3 Query   UPDATE cards SET
 inuse='0' WHERE number='58767059'
   3 Query   SELECT * FROM cards
 WHERE number='58767059'
   3 Query   UPDATE cards SET
 used='0' WHERE number='58767059'
   3 Query   UPDATE cards SET
 inuse='0' WHERE number='58767059'
   3 Quit   
   4 Connect
 [EMAIL PROTECTED] on asteriskcdrdb
   4 Query   INSERT
 INTO cdr 

(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode)
 VALUES ('2005-06-29 05:17:42','\Mike\
 1234','1234','777','TEST',

'SIP/1234-f285','SIP/213.45.62.117-1732','Dial','SIP/213.45.62.117/19315461298|30|HL(6:6:3)',42,42,'ANSWERED',3,'')
 
 
 
 Juan Luis Moyano [EMAIL PROTECTED]
 wrote:
 Bernard Cresencia wrote:
  sorry, I meant my.cnf, not my.conf.
 
  Once logging is enabled, I would do tail -f
  /var/log/myslqd.log and watch as the database is
 being
  accessed during a call.
 
 
 I've done what Bernard suggested and this is my
 output from mysql.log on
 a successful call to number 612 on FWD. I'd like to
 know if any of you
 see something wrong or rare. Thanks a lot.
 
 Time Id Command Argument
 050629 1:02:02 1 Connect [EMAIL PROTECTED] on astcc
 050629 1:02:04 1 Query SELECT * FROM cards WHERE
 number='21'
 1 Query SELECT * FROM cards WHERE number='21'
 1 Query SELECT * FROM cards WHERE number='21'
 1 Query SELECT * FROM cards WHERE number='21'
 1 Query UPDATE cards SET used='1801' WHERE
 number='21'
 1 Query UPDATE cards SET inuse='1' WHERE
 number='21'
 050629 1:02:10 1 Query SELECT * FROM routes WHERE
 '612'
 RLIKE pattern ORDER BY LENGTH(pattern) DESC
 050629 1:02:25 1 Query SELECT * FROM cards WHERE
 number='21'
 1 Query SELECT * FROM trunks WHERE name='FWD'
 050629 1:02:37 1 Query INSERT INTO cdrs

(cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart)
 VALUES ('21', '\Coco\ 21', '612', 'FWD',
 'ANSWER', '9', '150', 'Wed
 Jun 29 01:02:37 2005')
 1 Query UPDATE cards SET used='1951' WHERE
 number='21'
 1 Query UPDATE cards SET inuse='0' WHERE
 number='21'
 1 Query SELECT * FROM cards WHERE number='21'
 1 Query UPDATE cards SET used='1951' WHERE
 number='21'
 1 Query UPDATE cards SET inuse='0' WHERE
 number='21'
 1 Quit
 
 -- 
 Juan Luis Moyano
 [EMAIL PROTECTED]
 
 ___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com

http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
   
 -
 How much free photo storage do you get? Store your
 holiday snaps for FREE with Yahoo! Photos. Get
 Yahoo! Photos
___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com

http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:
   
http://lists.digium.com/mailman/listinfo/asterisk-users

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Ade Agbero]

the database exists because that is where the cards\PINs are stored, without the card\PIN I can not make a call, so the database exists, the permissions issue also may not be valid because when I set a connection charge the connection charge is recorded as billcost, but the cost of the call is not added to the connection charge to make the total billcost.
So, it seems that the astcc.agi file I am using has a problem, perhaps you can send me your WORKING astcc.agi.
Bernard Cresencia [EMAIL PROTECTED] wrote:
If astccdb exists, go to the database configurationpage [Configure] and change the database name to thecorrect one. You may have to set up permissions onthis database if it wasn't set up before. If itdoesn't exist, use the 'Create Database' button tocreate a new one.--- Ade Agbero <[EMAIL PROTECTED]>wrote: The reason for the problem is clear below, the ASTERISKCDRDB database is being updated instead of the ASTCCDB database which holds the cdrs and BILLCOST.  How can this problem be corrected???   3 Query UPDATE cards SET used='0' WHERE number='58767059' 3 Query UPDATE cards SET inuse='0' WHERE number='58767059' 3 Query SELECT * FROM cards WHERE number='58767059' 3 Query UPDATE cards SET used='0' WHERE number='58767059'<
 BR>
 3 Query UPDATE cards SET inuse='0' WHERE number='58767059' 3 Quit  4 Connect  [EMAIL PROTECTED] on asteriskcdrdb 4 Query INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('2005-06-29 05:17:42','\"Mike\" 1234','1234','777','TEST','SIP/1234-f285','SIP/213.45.62.117-1732','Dial','SIP/213.45.62.117/19315461298|30|HL(6:6:3)',42,42,'ANSWERED',3,'')Juan Luis Moyano <[EMAIL PROTECTED]> wrote: Bernard Cresencia wrote:  sorry, I meant my.cnf, not my.conf.   Once logging is enabled, I would do tail -f  /var/log/myslqd.log and watch as the database is being  accessed during a call.   I've done what Bernard suggested and this is
 my output from mysql.log on a successful call to number 612 on FWD. I'd like to know if any of you see something wrong or rare. Thanks a lot.  Time Id Command Argument 050629 1:02:02 1 Connect [EMAIL PROTECTED] on astcc 050629 1:02:04 1 Query SELECT * FROM cards WHERE number='21' 1 Query SELECT * FROM cards WHERE number='21' 1 Query SELECT * FROM cards WHERE number='21' 1 Query SELECT * FROM cards WHERE number='21' 1 Query UPDATE cards SET used='1801' WHERE number='21' 1 Query UPDATE cards SET inuse='1' WHERE number='21' 050629 1:02:10 1 Query SELECT * FROM routes WHERE '612' RLIKE pattern ORDER BY LENGTH(pattern) DESC 050629 1:02:25 1 Query SELECT * FROM cards WHERE number='21' 1 Query SELECT * FROM trunks WHERE name='FWD' 050629 1:02:37 1 Query INSERT INTO
 cdrs(cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart) VALUES ('21', '\"Coco\" 21', '612', 'FWD', 'ANSWER', '9', '150', 'Wed Jun 29 01:02:37 2005') 1 Query UPDATE cards SET used='1951' WHERE number='21' 1 Query UPDATE cards SET inuse='0' WHERE number='21' 1 Query SELECT * FROM cards WHERE number='21' 1 Query UPDATE cards SET used='1951' WHERE number='21' 1 Query UPDATE cards SET inuse='0' WHERE number='21' 1 Quit  --  Juan Luis Moyano [EMAIL PROTECTED]  ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit:http://lists.digium.com/mailman/listinfo/asterisk-users 
   - How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos___ Asterisk-Users mailing list Asterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users___Asterisk-Users mailing listAsterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options visit:http://lists.digium.com/mailman/listinfo/asterisk-users
		How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! 
Photos___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Ade Agbero]

How does Asterisk calculate "BILLCOST", it appears the program for calculating BILLCOST may be wrong. Wherecan I locatethe program\file.Juan Luis Moyano [EMAIL PROTECTED] wrote:
Has anyone noticed that the primary key in the cdrs table is cardnum? soit won't record more than the first call made by different cards.Perhaps I'm not understanding the purpose of de cdrs table. Maybe onesolution is to add an auto_increment uniqueid field like in theasteriskcdrdb cdr table. Can anyone point me in the right direction onthis one?-- Juan Luis Moyano[EMAIL PROTECTED]___Asterisk-Users mailing listAsterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options visit:http://lists.digium.com/mailman/listinfo/asterisk-users
		Yahoo! Messenger
 NEW - crystal clear PC to PC
calling worldwide with voicemail
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Ade Agbero]

I have just installed [EMAIL PROTECTED] version 1.1,I have made a number of successful calls, but the bill cost remains "0".

I have kept everything simple:






Pattern
Comment
Trunks
Connect Fee
Inc. Seconds
Cost per additional minute



DANSAM
0
0
10






Trunk Name
Technology
Peer/Trunk

TEST
SIP
213.45.62.117

Darren Wiebe [EMAIL PROTECTED] wrote:
We are using it on [EMAIL PROTECTED] version 1.1Darren Wiebe[EMAIL PROTECTED]Darren Wiebe wrote: Ade Agbero wrote: I set "notransfer=yes" and on SIP you set "canreinvite=no", but  ASTCC is still not billing.  I formated and reinstalled [EMAIL PROTECTED] and  got the latest CVS of Astcc, but ASTCC is still not billing.  What version of [EMAIL PROTECTED] can be confirmed  working with Astcc. I can try to find that out tomorrow. I don't know off the top of my  head. Did you try the latest stable version of asterisk? That is  what I did to resolve the issue. Darren Wiebe [EMAIL PROTECTED] */Darren Wiebe
 <[EMAIL PROTECTED]>/* wrote: On IAX you set "notransfer=yes" and on SIP you set "canreinvite=no" Darren Juan Luis Moyano wrote: On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo:   Do you have the notransfer and reinvite lines set properly? I had this same problem with ASTCC but found that if I removed asterisk including the source and did a clean reinstall it worked suddenly.  DarrenDarren, how is the proper way of setting notransfer and canreinvite lines on IAX. TIA.___ Asteris
 k-Users
 mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users  How much free photo storage do you get? Store your holiday snaps for  FREE with Yahoo! Photos. *Get Yahoo! Photos*    ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users___Asterisk-Users mailing listAsterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options visit:http://lists.digium.com/mailman/listinfo/asterisk-users
		Yahoo! Messenger
 NEW - crystal clear PC to PC
calling worldwide with voicemail
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Ade Agbero]

Please ignore previous email:

I have just installed [EMAIL PROTECTED] version 1.1,I have made a number of successful calls, but the bill cost remains "0".

I have kept everything simple:







Pattern
Comment
Trunks
Connect Fee
Inc. Seconds
Cost per additional minute

44.*

TEST
0
0
10


1.*

TEST
0
0
10







Trunk Name
Technology
Peer/Trunk

TEST
SIP
213.45.62.117
Darren Wiebe [EMAIL PROTECTED] wrote:
We are using it on [EMAIL PROTECTED] version 1.1Darren Wiebe[EMAIL PROTECTED]Darren Wiebe wrote: Ade Agbero wrote: I set "notransfer=yes" and on SIP you set "canreinvite=no", but  ASTCC is still not billing.  I formated and reinstalled [EMAIL PROTECTED] and  got the latest CVS of Astcc, but ASTCC is still not billing.  What version of [EMAIL PROTECTED] can be confirmed  working with Astcc. I can try to find that out tomorrow. I don't know off the top of my  head. Did you try the latest stable version of asterisk? That is  what I did to resolve the issue. Darren Wiebe [EMAIL PROTECTED] */Darren Wiebe
 <[EMAIL PROTECTED]>/* wrote: On IAX you set "notransfer=yes" and on SIP you set "canreinvite=no" Darren Juan Luis Moyano wrote: On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo:   Do you have the notransfer and reinvite lines set properly? I had this same problem with ASTCC but found that if I removed asterisk including the source and did a clean reinstall it worked suddenly.  DarrenDarren, how is the proper way of setting notransfer and canreinvite lines on IAX. TIA.___ Asteris
 k-Users
 mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users  How much free photo storage do you get? Store your holiday snaps for  FREE with Yahoo! Photos. *Get Yahoo! Photos*    ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users___Asterisk-Users mailing listAsterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options visit:http://lists.digium.com/mailman/listinfo/asterisk-users
		Yahoo! Messenger
 NEW - crystal clear PC to PC
calling worldwide with voicemail
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Bernard Cresencia]

Have you checked the cdr database in phpmyadmin to see
if it has some of the data? Maybe it's a permission
issue on your database. I would turn on mysql logging
in my.conf and see if you can find any error messages
there.


--- Ade Agbero [EMAIL PROTECTED] wrote:

 Please ignore previous email:
  
 I have just installed [EMAIL PROTECTED] version 1.1, I
 have made a number of successful calls, but the bill
 cost remains 0.
  
 I have kept everything simple:
 
  
  
 PatternCommentTrunksConnect FeeInc. SecondsCost per
 additional minute [input] 44.*TEST0010 [input] 
 [input]  [input] 1.*TEST0010
  
  
 Trunk NameTechnologyPeer/Trunk [input]
 TESTSIP213.45.62.117
 
 
 Darren Wiebe [EMAIL PROTECTED] wrote:
 We are using it on [EMAIL PROTECTED] version 1.1
 
 Darren Wiebe
 [EMAIL PROTECTED]
 
 
 Darren Wiebe wrote:
 
  Ade Agbero wrote:
 
  I set notransfer=yes and on SIP you set
 canreinvite=no, but 
  ASTCC is still not billing.
  
  I formated and reinstalled [EMAIL PROTECTED] and 
  got the latest CVS of Astcc, but ASTCC is still
 not billing.
  
  What version of [EMAIL PROTECTED] can be confirmed 
  working with Astcc.
 
 
  I can try to find that out tomorrow. I don't know
 off the top of my 
  head. Did you try the latest stable version of
 asterisk? That is 
  what I did to resolve the issue.
 
  Darren Wiebe
  [EMAIL PROTECTED]
 
 
  */Darren Wiebe /* wrote:
 
  On IAX you set notransfer=yes and on SIP you
 set canreinvite=no
 
  Darren
 
  Juan Luis Moyano wrote:
 
  On Sab, 25 de Junio de 2005, 5:20 pm, Darren
 Wiebe dijo:
  
  
  Do you have the notransfer and reinvite lines
 set properly? I
  had this
  same problem with ASTCC but found that if I
 removed asterisk
  including
  the source and did a clean reinstall it worked
 suddenly.
  
  Darren
  
  
  
  Darren, how is the proper way of setting
 notransfer and
  canreinvite lines
  on IAX. TIA.
  
  
  
 
  ___
  Asterisk-Users mailing list
  Asterisk-Users@lists.digium.com
 

http://lists.digium.com/mailman/listinfo/asterisk-users
  To UNSUBSCRIBE or update options visit:
 

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 


  How much free photo storage do you get? Store
 your holiday snaps for 
  FREE with Yahoo! Photos. *Get Yahoo! Photos* 
  
 
 
 


 
  ___
  Asterisk-Users mailing list
  Asterisk-Users@lists.digium.com
 

http://lists.digium.com/mailman/listinfo/asterisk-users
  To UNSUBSCRIBE or update options visit:
 

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
  ___
  Asterisk-Users mailing list
  Asterisk-Users@lists.digium.com
 

http://lists.digium.com/mailman/listinfo/asterisk-users
  To UNSUBSCRIBE or update options visit:
 

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
 ___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com

http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:

http://lists.digium.com/mailman/listinfo/asterisk-users
 
   
 -
 Yahoo! Messenger NEW - crystal clear PC to PCcalling
 worldwide with voicemail
___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com

http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:
   
http://lists.digium.com/mailman/listinfo/asterisk-users

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Bernard Cresencia]

sorry, I meant my.cnf, not my.conf.

Once logging is enabled, I would do tail -f
/var/log/myslqd.log and watch as the database is being
accessed during a call.


--- Ade Agbero [EMAIL PROTECTED] wrote:

 I have just installed [EMAIL PROTECTED] version 1.1, I
 have made a number of successful calls, but the bill
 cost remains 0.
  
 I have kept everything simple:
  
 PatternCommentTrunksConnect FeeInc. SecondsCost per
 additional minute [input] DANSAM0010
 
  
 Trunk NameTechnologyPeer/Trunk [input]
 TESTSIP213.45.62.117
  
 
 Darren Wiebe [EMAIL PROTECTED] wrote:
 We are using it on [EMAIL PROTECTED] version 1.1
 
 Darren Wiebe
 [EMAIL PROTECTED]
 
 
 Darren Wiebe wrote:
 
  Ade Agbero wrote:
 
  I set notransfer=yes and on SIP you set
 canreinvite=no, but 
  ASTCC is still not billing.
  
  I formated and reinstalled [EMAIL PROTECTED] and 
  got the latest CVS of Astcc, but ASTCC is still
 not billing.
  
  What version of [EMAIL PROTECTED] can be confirmed 
  working with Astcc.
 
 
  I can try to find that out tomorrow. I don't know
 off the top of my 
  head. Did you try the latest stable version of
 asterisk? That is 
  what I did to resolve the issue.
 
  Darren Wiebe
  [EMAIL PROTECTED]
 
 
  */Darren Wiebe /* wrote:
 
  On IAX you set notransfer=yes and on SIP you
 set canreinvite=no
 
  Darren
 
  Juan Luis Moyano wrote:
 
  On Sab, 25 de Junio de 2005, 5:20 pm, Darren
 Wiebe dijo:
  
  
  Do you have the notransfer and reinvite lines
 set properly? I
  had this
  same problem with ASTCC but found that if I
 removed asterisk
  including
  the source and did a clean reinstall it worked
 suddenly.
  
  Darren
  
  
  
  Darren, how is the proper way of setting
 notransfer and
  canreinvite lines
  on IAX. TIA.
  
  
  
 
  ___
  Asterisk-Users mailing list
  Asterisk-Users@lists.digium.com
 

http://lists.digium.com/mailman/listinfo/asterisk-users
  To UNSUBSCRIBE or update options visit:
 

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 


  How much free photo storage do you get? Store
 your holiday snaps for 
  FREE with Yahoo! Photos. *Get Yahoo! Photos* 
  
 
 
 


 
  ___
  Asterisk-Users mailing list
  Asterisk-Users@lists.digium.com
 

http://lists.digium.com/mailman/listinfo/asterisk-users
  To UNSUBSCRIBE or update options visit:
 

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
  ___
  Asterisk-Users mailing list
  Asterisk-Users@lists.digium.com
 

http://lists.digium.com/mailman/listinfo/asterisk-users
  To UNSUBSCRIBE or update options visit:
 

http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
 ___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com

http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:

http://lists.digium.com/mailman/listinfo/asterisk-users
 
   
 -
 Yahoo! Messenger NEW - crystal clear PC to PCcalling
 worldwide with voicemail
___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com

http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:
   
http://lists.digium.com/mailman/listinfo/asterisk-users

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Juan Luis Moyano]

Bernard Cresencia wrote:
 sorry, I meant my.cnf, not my.conf.

 Once logging is enabled, I would do tail -f
 /var/log/myslqd.log and watch as the database is being
 accessed during a call.


I've done what Bernard suggested and this is my output from mysql.log on
a successful call to number 612 on FWD. I'd like to know if any of you
see something wrong or rare. Thanks a lot.

Time Id CommandArgument
050629  1:02:02   1 Connect [EMAIL PROTECTED] on astcc
050629  1:02:04   1 Query   SELECT * FROM cards WHERE number='21'
  1 Query   SELECT * FROM cards WHERE number='21'
  1 Query   SELECT * FROM cards WHERE number='21'
  1 Query   SELECT * FROM cards WHERE number='21'
  1 Query   UPDATE cards SET used='1801' WHERE
number='21'
  1 Query   UPDATE cards SET inuse='1' WHERE
number='21'
050629  1:02:10   1 Query   SELECT * FROM routes WHERE '612'
RLIKE pattern ORDER BY LENGTH(pattern) DESC
050629  1:02:25   1 Query   SELECT * FROM cards WHERE number='21'
  1 Query   SELECT * FROM trunks WHERE name='FWD'
050629  1:02:37   1 Query   INSERT INTO cdrs
(cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart)
VALUES ('21', '\Coco\ 21', '612', 'FWD', 'ANSWER', '9', '150', 'Wed
Jun 29 01:02:37 2005')
  1 Query   UPDATE cards SET used='1951' WHERE
number='21'
  1 Query   UPDATE cards SET inuse='0' WHERE
number='21'
  1 Query   SELECT * FROM cards WHERE number='21'
  1 Query   UPDATE cards SET used='1951' WHERE
number='21'
  1 Query   UPDATE cards SET inuse='0' WHERE
number='21'
  1 Quit

-- 
Juan Luis Moyano
[EMAIL PROTECTED]

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Juan Luis Moyano]

Has anyone noticed that the primary key in the cdrs table is cardnum? so
it won't record more than the first call made by different cards.
Perhaps I'm not understanding the purpose of de cdrs table. Maybe one
solution is to add an auto_increment uniqueid field like in the
asteriskcdrdb cdr table. Can anyone point me in the right direction on
this one?

-- 
Juan Luis Moyano
[EMAIL PROTECTED]

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Juan Luis Moyano]

Also while looking at the cards table I noticed that the creation field
on a card is always changing to the date I made the last call from that
card. Is this the way it has to be?

-- 
Juan Luis Moyano
[EMAIL PROTECTED]

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Darren Wiebe]

We are using it on [EMAIL PROTECTED] version 1.1

Darren Wiebe
[EMAIL PROTECTED]


Darren Wiebe wrote:


Ade Agbero wrote:

I set notransfer=yes and on SIP you set canreinvite=no, but 
ASTCC  is still not billing.
 
I formated and reinstalled [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] and 
got the latest CVS of Astcc, but ASTCC  is still not billing.
 
What version of [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] can be confirmed 
working with Astcc.



I can try to find that out tomorrow.  I don't know off the top of my 
head.  Did you try the latest stable version of asterisk?  That is 
what I did to resolve the issue.


Darren Wiebe
[EMAIL PROTECTED]



*/Darren Wiebe [EMAIL PROTECTED]/* wrote:

On IAX you set notransfer=yes and on SIP you set canreinvite=no

Darren

Juan Luis Moyano wrote:

On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo:


Do you have the notransfer and reinvite lines set properly? I
had this
same problem with ASTCC but found that if I removed asterisk
including
the source and did a clean reinstall it worked suddenly.

Darren



Darren, how is the proper way of setting notransfer and
canreinvite lines
on IAX. TIA.




___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users


How much free photo storage do you get? Store your holiday snaps for 
FREE with Yahoo! Photos. *Get Yahoo! Photos* 
http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/ 





___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Juan Luis Moyano]

Darren Wiebe wrote:
 We are using it on [EMAIL PROTECTED] version 1.1
 
 Darren Wiebe
 [EMAIL PROTECTED]
 
 
 Darren Wiebe wrote:
 

Darren, could you post one working example of brands, trunks and routes
table? Thanks in advance.


-- 
Juan Luis Moyano
[EMAIL PROTECTED]

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Juan Luis Moyano]

On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo:
 Do you have the notransfer and reinvite lines set properly?  I had this
 same problem with ASTCC but found that if I removed asterisk including
 the source and did a clean reinstall it worked suddenly.

 Darren

Darren, how is the proper way of setting notransfer and canreinvite lines
on IAX. TIA.

-- 
Juan Luis Moyano
[EMAIL PROTECTED]

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Darren Wiebe]

On IAX you set notransfer=yes and on SIP you set canreinvite=no

Darren

Juan Luis Moyano wrote:


On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo:
 


Do you have the notransfer and reinvite lines set properly?  I had this
same problem with ASTCC but found that if I removed asterisk including
the source and did a clean reinstall it worked suddenly.

Darren

   


Darren, how is the proper way of setting notransfer and canreinvite lines
on IAX. TIA.

 



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Ade Agbero]

I set "notransfer=yes" and on SIP you set "canreinvite=no", but ASTCC is still not billing.

Iformated and reinstalled [EMAIL PROTECTED] andgot the latest CVS of Astcc, butASTCC is still not billing.

What version of [EMAIL PROTECTED] can be confirmed working with Astcc.
Darren Wiebe [EMAIL PROTECTED] wrote:
On IAX you set "notransfer=yes" and on SIP you set "canreinvite=no"DarrenJuan Luis Moyano wrote:On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo: Do you have the notransfer and reinvite lines set properly? I had thissame problem with ASTCC but found that if I removed asterisk includingthe source and did a clean reinstall it worked suddenly.Darren Darren, how is the proper way of setting notransfer and canreinvite lineson IAX. TIA. ___Asterisk-Users mailing listAsterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options
 visit:http://lists.digium.com/mailman/listinfo/asterisk-users
		How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! 
Photos___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Darren Wiebe]

Ade Agbero wrote:

I set notransfer=yes and on SIP you set canreinvite=no, but ASTCC  
is still not billing.
 
I formated and reinstalled [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
and got the latest CVS of Astcc, but ASTCC  is still not billing.
 
What version of [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] can be confirmed 
working with Astcc.


I can try to find that out tomorrow.  I don't know off the top of my 
head.  Did you try the latest stable version of asterisk?  That is what 
I did to resolve the issue.


Darren Wiebe
[EMAIL PROTECTED]



*/Darren Wiebe [EMAIL PROTECTED]/* wrote:

On IAX you set notransfer=yes and on SIP you set canreinvite=no

Darren

Juan Luis Moyano wrote:

On Sab, 25 de Junio de 2005, 5:20 pm, Darren Wiebe dijo:


Do you have the notransfer and reinvite lines set properly? I
had this
same problem with ASTCC but found that if I removed asterisk
including
the source and did a clean reinstall it worked suddenly.

Darren



Darren, how is the proper way of setting notransfer and
canreinvite lines
on IAX. TIA.




___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users


How much free photo storage do you get? Store your holiday snaps for 
FREE with Yahoo! Photos. *Get Yahoo! Photos* 
http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/ 





___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

[Asterisk-Users] ASTCC not billing

[Ade Agbero]

I have downloaded and tried a number of astcc.agi filesregarding this problem, but I can not get Astcc to bill for calls. If I apply a connection chrage Astcc billsfor the connection charge only, hence I get to make a 10 minute call for the rate of the connection charge only, because Astcc does not bill correctly.


		Yahoo! Messenger
 NEW - crystal clear PC to PC
calling worldwide with voicemail
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC not billing

[Darren Wiebe]

Do you have the notransfer and reinvite lines set properly?  I had this 
same problem with ASTCC but found that if I removed asterisk including 
the source and did a clean reinstall it worked suddenly.


Darren

Ade Agbero wrote:

I have downloaded and tried a number of astcc.agi files regarding this 
problem, but I can not get Astcc to bill for calls. If I apply a 
connection chrage Astcc bills for the connection charge only, hence I 
get to make a 10 minute call for the rate of the connection charge 
only, because Astcc does not bill correctly.
 
 



Yahoo! Messenger 
http://us.rd.yahoo.com/mail/uk/taglines/default/messenger/*http://uk.messenger.yahoo.com 
NEW - crystal clear PC to PC calling worldwide with voicemail 
http://us.rd.yahoo.com/mail/uk/taglines/default/messenger/*http://uk.beta.messenger.yahoo.com 





___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

[Asterisk-Users] ASTCC: potential billing issue and fix

[Nabeel Jafferali]

Before I start, I just want to say this is not necessarily a problem
with ASTCC, but may be a problem the way I have set up ASTCC (and
possibly the way others have set it up as well). The issue is that ASTCC
tries to match the pattern *anywhere* in the called number, not
necessarily only at the beginning.

I have set up ASTCC Routes like this:

1800TollfreeTrunk1  0   0   100
1416Canada  Trunk2  0   0   400
- other NANPA codes -
1   USA Trunk1  0   0   400
011971  UAE Trunk3  0   0   3000
- other international codes -

Now, for other international codes I have not included all the
countries, just the ones that are important for now. I has expected to
add others as they became necessary. However, today somebody called
011966... which is not one of the included countries. I guess it
instead picked up the 1 pattern and billed the call at 4c per minute.

To get around this, I tried to add:

011 Other   Trunk3  0   0   1

which should have charged $1 per minute for all other countries and sent
them out Trunk3. If I call 011966... it works fine. But, if I call
011416... it picks up the NANPA pattern for Canada defined, instead of
the non-NANPA catch-all I have defined.

I tried to fix the problem by adding 0112 to 0119 patterns (4-digit,
to make a better pattern match) to the routes table, so 011416...
would pick up 0114 instead of 1416, but it didn't work. Reordering
the mySQL table so these 8 non-NANPA catch-alls appeared at the top of
the table (before the 1416 and other NANPA entries) fixed it though.

--
Nabeel Jafferali
Tel: +1 (416) 628-9342  Toronto
 +1 (646) 225-7426  New York
FWD: 46990
Email/MSN: nabeelatjafferali.net
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] ASTCC: potential billing issue and fix

[Bruce Komito]

I had the same problem, and it's a database issue, not a code problem.
Use the character ^ in front of the pattern in the routes table, and I
think you will have better luck.  E.g., ^1416... will match only
numbers that start with 1416.

Bruce Komito
High Sierra Networks, Inc.
www.servers-r-us.com
(775) 236-5815


On Sat, 22 Jan 2005, Nabeel Jafferali wrote:

 Before I start, I just want to say this is not necessarily a problem
 with ASTCC, but may be a problem the way I have set up ASTCC (and
 possibly the way others have set it up as well). The issue is that ASTCC
 tries to match the pattern *anywhere* in the called number, not
 necessarily only at the beginning.

 I have set up ASTCC Routes like this:

 1800  TollfreeTrunk1  0   0   100
 1416  Canada  Trunk2  0   0   400
 - other NANPA codes -
 1 USA Trunk1  0   0   400
 011971UAE Trunk3  0   0   3000
 - other international codes -

 Now, for other international codes I have not included all the
 countries, just the ones that are important for now. I has expected to
 add others as they became necessary. However, today somebody called
 011966... which is not one of the included countries. I guess it
 instead picked up the 1 pattern and billed the call at 4c per minute.

 To get around this, I tried to add:

 011   Other   Trunk3  0   0   1

 which should have charged $1 per minute for all other countries and sent
 them out Trunk3. If I call 011966... it works fine. But, if I call
 011416... it picks up the NANPA pattern for Canada defined, instead of
 the non-NANPA catch-all I have defined.

 I tried to fix the problem by adding 0112 to 0119 patterns (4-digit,
 to make a better pattern match) to the routes table, so 011416...
 would pick up 0114 instead of 1416, but it didn't work. Reordering
 the mySQL table so these 8 non-NANPA catch-alls appeared at the top of
 the table (before the 1416 and other NANPA entries) fixed it though.

 --
 Nabeel Jafferali
 Tel: +1 (416) 628-9342  Toronto
  +1 (646) 225-7426  New York
 FWD: 46990
 Email/MSN: nabeelatjafferali.net
 ___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com
 http://lists.digium.com/mailman/listinfo/asterisk-users
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users

 This message has been categorized as Legitimate by Bayesian Analyzer.
 If you do not agree, please click on the link below to train the Analyzer.
 http://nospam.wpti.net/bt/a.aspx?M=C:%5Csmtpmail%5CBayesTraining%5C2005-01-22%5Cc2348896a2944f408c615aa0e5208995C=2

 --
 ---
 This message has been inspected by DynaComm i:mail
 ---




___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users