LinuxMCE Forums

General => Users => Topic started by: pw44 on February 26, 2013, 12:23:34 am

Title: Asterisk CDR registering error.
Post by: pw44 on February 26, 2013, 12:23:34 am
Hya,
browsing the Asterisk CDR table, i did note the it registers wrong. Incoming calls coming via my SPA3102 is registered as caller id "Unknown Caller" <2122498618>, which is my POTS number.
Code: [Select]
calldate clid src dst dcontext channel dstchannel lastapp lastdata duration billsec disposition amaflags accountcode userfield uniqueid
2013-02-24 20:46:54 "Unknown Caller" <2122498618> 2122498618 2122498618 from-trunk SIP/2122498618-00000009 Local/204@trusted-cac0;1 Set TIMEOUT(response)=20 41 11 ANSWERED 3     1361749614.37
Is this error known?
TIA





Title: Re: Asterisk CDR registering error.
Post by: cfernandes on February 26, 2013, 11:43:15 am
my cdr is correct   check   on  db_phone_config.sh   

if look like that
  LINESSQL="$LINESSQL INSERT INTO $DB_Extensions_Table (context,exten,priority,app,appdata) VALUES
        ('$context','$phonenumber','1','Set','__FROM_DID=\${EXTEN}'),
        ('$context','$phonenumber','2','Set','PAI=\${SIP_HEADER(P-Asserted-Identity)}'),
        ('$context','$phonenumber','3','Set','PAF=\${SIP_HEADER(FROM)}'),
        ('$context','$phonenumber','4','Set','CURRENT_PAI_LENGTH=\${LEN(\${PAI})}'),
        ('$context','$phonenumber','5','Set','CURRENT_PAF_LENGTH=\${LEN(\${PAF})}'),
        ('$context','$phonenumber','6','gotoif','\$[\${CURRENT_PAI_LENGTH} > 0] ? 11'),
        ('$context','$phonenumber','7','gotoif','\$[\${CURRENT_PAF_LENGTH} > 0] ? 19'),
        ('$context','$phonenumber','8','Noop','Incoming call from \${CALLERID(num)}'),
        ('$context','$phonenumber','9','Set','FAX_RX='),
        ('$context','$phonenumber','10','Goto','custom-linuxmce,$line,1'),
        ('$context','$phonenumber','11','noop','config p asserted id ${PAI}'),
        ('$context','$phonenumber','12','set','tmpcid=\${CUT(PAI,:,2)}'),
        ('$context','$phonenumber','13','Set','tmpcid=\${CUT(tmpcid,@,1)}'),
        ('$context','$phonenumber','14','Set','CALLERID(num)=\${tmpcid}'),
        ('$context','$phonenumber','15','Noop','Incoming call from \${CALLERID(num)}'),
        ('$context','$phonenumber','16','Set','FAX_RX='),
        ('$context','$phonenumber','17','Set','CALLERID(ani)='),
        ('$context','$phonenumber','18','Goto','custom-linuxmce,$line,1'),
        ('$context','$phonenumber','19','noop','config SIP Header From ${PAF}'),
        ('$context','$phonenumber','20','set','tmpcid=\${CUT(PAF,:,2)}'),
        ('$context','$phonenumber','21','Set','tmpcid=\${CUT(tmpcid,@,1)}'),
        ('$context','$phonenumber','22','Set','CALLERID(num)=\${tmpcid}'),
        ('$context','$phonenumber','23','Noop','Incoming call from \${CALLERID(num)}'),
        ('$context','$phonenumber','24','Set','FAX_RX='),
        ('$context','$phonenumber','25','Set','CALLERID(ani)='),
        ('$context','$phonenumber','26','Goto','custom-linuxmce,$line,1');"

Code: [Select]
| calldate            | clid           | src            | dst | dcontext          | channel              | dstchannel | lastapp    | lastdata | duration | billsec | disposition | amaflags | accountcode | userfield | uniqueid       |
+---------------------+----------------+----------------+-----+-------------------+----------------------+------------+------------+----------+----------+---------+-------------+----------+-------------+-----------+----------------+
| 2013-02-25 12:28:52 | 18021382320001 | 18021382320001 | s   | from-sip-external | SIP/0.0.0.0-00000060 |            | Congestion | 5        |       13 |      13 | ANSWERED    |        3 |             |           | 1361806132.367 |
| 2013-02-25 12:18:53 | 13021382320001 | 13021382320001 | s   | from-sip-external | SIP/0.0.0.0-0000005f |            | Congestion | 5        |       13 |      13 | ANSWERED    |        3 |             |           | 1361805533.366 |
| 2013-02-25 12:08:54 | 15021382320001 | 15021382320001 | s   | from-sip-external | SIP/0.0.0.0-0000005e |            | Congestion | 5        |       13 |      13 | ANSWERED    |        3 |             |           | 1361804934.365 |
+---------------------+----------------+----------------+-----+-------------------+----------------------+------------+------------+----------+----------+---------+-------------+----------+-------------+-----------+----------------+
Title: Re: Asterisk CDR registering error.
Post by: pw44 on February 27, 2013, 08:45:01 pm
This is what i have in my db_phone_config.sh. The last apt-get update && upgrade is three days ago.

LINESSQL="$LINESSQL INSERT INTO $DB_Extensions_Table (context,exten,priority,app,appdata) VALUES \
        ('$context','$phonenumber','1','Set','__FROM_DID=\${EXTEN}'), \
        ('$context','$phonenumber','2','Set','PAI=\${SIP_HEADER(FROM)}'),\
        ('$context','$phonenumber','3','gotoif','\$[\"\${PAI}\" = \"\"] ? 4:8'), \
        ('$context','$phonenumber','4','Set','CALLERID(num)=\${CALLERID(ani)}'), \
        ('$context','$phonenumber','5','Noop','Incoming call from \${CALLERID(num)}'), \
        ('$context','$phonenumber','6','Set','FAX_RX='), \
        ('$context','$phonenumber','7','Goto','custom-linuxmce,$line,1'),\
        ('$context','$phonenumber','8','noop','Using p-asserted-id SIP header: ${PAI}'),\
        ('$context','$phonenumber','9','set','tmpcid=\${CUT(PAI,:,2)}'), \
        ('$context','$phonenumber','10','Set','tmpcid=\${CUT(tmpcid,@,1)}'), \
        ('$context','$phonenumber','11','Set','CALLERID(num)=\${tmpcid}'),\
        ('$context','$phonenumber','12','Noop','Incoming call from \${CALLERID(num)}'),\
        ('$context','$phonenumber','13','Set','FAX_RX='), \
        ('$context','$phonenumber','14','Goto','custom-linuxmce,$line,1');"
}

It's different from yours.
Title: Re: Asterisk CDR registering error.
Post by: cfernandes on February 27, 2013, 10:08:29 pm
try  with  my   
Title: Re: Asterisk CDR registering error.
Post by: phenigma on February 28, 2013, 04:53:47 am
This is what i have in my db_phone_config.sh. The last apt-get update && upgrade is three days ago.
...
It's different from yours.

Your db_phone_config.sh is a 5 month old version.  Did apt-get report any packages held back?

J.

Title: Re: Asterisk CDR registering error.
Post by: pw44 on February 28, 2013, 10:47:39 am
Your db_phone_config.sh is a 5 month old version.  Did apt-get report any packages held back?

J.



No, apt-get report did no report held back.
Title: Re: Asterisk CDR registering error.
Post by: phenigma on February 28, 2013, 02:32:50 pm
No, apt-get report did no report held back.

Try:

Code: [Select]
apt-get install --reinstall lmce-asterisk

J.
Title: Re: Asterisk CDR registering error.
Post by: pw44 on March 01, 2013, 12:35:39 am
apt-get install --reinstall lmce-asterisk done. What's next?
Title: Re: Asterisk CDR registering error.
Post by: phenigma on March 01, 2013, 12:52:39 am
That should have installed a newer db_phone_config.sh script with the additional entries in the config.  If it did not you may need to clear your apt cache and try the reinstall again.

J.
Title: Re: Asterisk CDR registering error.
Post by: pw44 on March 01, 2013, 11:56:19 pm
Thx J and Carlos,
worked like a charm. Now, registering the incoming calls correctly.
Thx again.
Title: Re: Asterisk CDR registering error.
Post by: phenigma on March 02, 2013, 06:18:46 pm
Your welcome.  Glad it's back up and working!

Jason.