waqas.mehmood90
2016-Jan-13 18:05 UTC
[asterisk-users] asterisk-users Digest, Vol 138, Issue 8
How to get user extention no in agi php scrip from which he's calling on ivr
i am using cid and able to get his name but not his extention no please help me
Sent from my Samsung Galaxy smartphone.
-------- Original message --------
From: asterisk-users-request at lists.digium.com
Date:13/01/2016 11:00 PM (GMT+05:00)
To: asterisk-users at lists.digium.com
Cc:
Subject: asterisk-users Digest, Vol 138, Issue 8
Send asterisk-users mailing list submissions to
asterisk-users at lists.digium.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.digium.com/mailman/listinfo/asterisk-users
or, via email, send a message with subject or body 'help' to
asterisk-users-request at lists.digium.com
You can reach the person managing the list at
asterisk-users-owner at lists.digium.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of asterisk-users digest..."
Today's Topics:
1. cdr_odbc: Error in ExecDirect: -1 (Vitor Mazuco)
2. "pjsip show endpoints" returns "No Objects Found" in
13.7.0-rc2 (Matthew Murphy)
3. Re: "pjsip show endpoints" returns "No Objects Found"
in
13.7.0-rc2 (Joshua Colp)
4. Re: "pjsip show endpoints" returns "No Objects Found"
in
13.7.0-rc2 (Matthew Murphy)
5. Re: cdr_odbc: Error in ExecDirect: -1 (Patrick Laimbock)
----------------------------------------------------------------------
Message: 1
Date: Wed, 13 Jan 2016 11:48:51 -0200
From: Vitor Mazuco <vitor.mazuco at gmail.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
Subject: [asterisk-users] cdr_odbc: Error in ExecDirect: -1
Message-ID:
<CAOs3ALZYi5WQEh89UEztwNHELj+ttLqi8r1+JxPiS-sBFP-ptg at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Hi everybody!
I'm trying to install a CDR Viewer
https://github.com/g613/asterisk-cdr-viewer
I'ts work well, but my problem is to make Asterisk store to MySQL using ODBC
When I make a call the CLI returns for me
See the log:
== Using SIP RTP CoS mark 5
-- Executing [2021 at ramais:1] Dial("SIP/2020-00000000",
"SIP/2021,60,tT") in new stack
== Using SIP RTP CoS mark 5
-- Called SIP/2021
-- SIP/2021-00000001 is ringing
> 0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
[Jan 13 11:31:07] NOTICE[2279][C-00000000]: res_rtp_asterisk.c:4441
ast_rtp_read: Unknown RTP codec 95 received from '(null)'
-- SIP/2021-00000001 answered SIP/2020-00000000
> 0x7fd3b4004eb0 -- Probation passed - setting RTP source
address to 192.168.25.100:8000
> 0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
> cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] WARNING[2279][C-00000000]: res_odbc.c:604
ast_odbc_direct_execute: SQL Execute error! Verifying connection to
asterisk [asterisk-connector]...
> cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] ERROR[2279][C-00000000]: cdr_odbc.c:177 odbc_log:
CDR direct execute failed
See my res_odbc.conf
[asterisk]
enabled = yes
dsn = asterisk-connector
username = root
password = 100567
pooling = no
limit = 1
pre-connect = yes
What can be happened?
Thank in advanced.
------------------------------
Message: 2
Date: Wed, 13 Jan 2016 14:26:08 +0000
From: Matthew Murphy <mrmdev at outlook.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
Subject: [asterisk-users] "pjsip show endpoints" returns "No
Objects
Found" in 13.7.0-rc2
Message-ID:
<CY1PR15MB0314208EC2C6D60FA4A5F6AFD9CB0 at
CY1PR15MB0314.namprd15.prod.outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi everyone,
I have just upgraded to Asterisk 13.7.0-rc2 and noticed that when I type
"pjsip show endpoints" at the CLI, I get "No Objects Found".
However, if I request information on a specific endpoint, (for example:
"pjsip show endpoint 101") then I get all of the information for that
endpoint as expected.
This seems to have started as soon as I upgraded to 13.7.0-rc2. I tried with
pjproject 2.4 and now pjproject 2.4.5 and get the same result.
Has anyone else seen this or is it something that is unique to my situation?
Thanks,
--Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20160113/d8804cd5/attachment-0001.html>
------------------------------
Message: 3
Date: Wed, 13 Jan 2016 10:34:49 -0400
From: Joshua Colp <jcolp at digium.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
Subject: Re: [asterisk-users] "pjsip show endpoints" returns "No
Objects Found" in 13.7.0-rc2
Message-ID: <56966089.9050909 at digium.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Matthew Murphy wrote:> Hi everyone,
>
>
> I have just upgraded to *Asterisk 13.7.0-rc2* and noticed that when I
> type "/pjsip show endpoints/" at the CLI, I get "/No Objects
Found/".
Are you using realtime? A regression was found[1] in rc2 when realtime
was in use which would cause this to happen. Only contacts were
mentioned but it would impact other things. There is now an rc3 which
has a fix for this in it.
[1] https://issues.asterisk.org/jira/browse/ASTERISK-25689
--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
------------------------------
Message: 4
Date: Wed, 13 Jan 2016 14:57:16 +0000
From: Matthew Murphy <mrmdev at outlook.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
Subject: Re: [asterisk-users] "pjsip show endpoints" returns "No
Objects Found" in 13.7.0-rc2
Message-ID:
<CY1PR15MB0314437898C2C3A0CC99EE78D9CB0 at
CY1PR15MB0314.namprd15.prod.outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
I am using realtime - you got it!
Great to know it already has a fix. I'll pull in rc3 and go from there.
Thanks a lot for your help!
--Matt
________________________________________
From: asterisk-users-bounces at lists.digium.com <asterisk-users-bounces at
lists.digium.com> on behalf of Joshua Colp <jcolp at digium.com>
Sent: Wednesday, January 13, 2016 9:34 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] "pjsip show endpoints" returns "No
Objects Found" in 13.7.0-rc2
Matthew Murphy wrote:> Hi everyone,
>
>
> I have just upgraded to *Asterisk 13.7.0-rc2* and noticed that when I
> type "/pjsip show endpoints/" at the CLI, I get "/No Objects
Found/".
Are you using realtime? A regression was found[1] in rc2 when realtime
was in use which would cause this to happen. Only contacts were
mentioned but it would impact other things. There is now an rc3 which
has a fix for this in it.
[1] https://issues.asterisk.org/jira/browse/ASTERISK-25689
--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
------------------------------
Message: 5
Date: Wed, 13 Jan 2016 18:13:02 +0100
From: Patrick Laimbock <patrick at laimbock.com>
To: asterisk-users at lists.digium.com
Subject: Re: [asterisk-users] cdr_odbc: Error in ExecDirect: -1
Message-ID: <5696859E.9060205 at laimbock.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
On 01/13/16 14:48, Vitor Mazuco wrote:> Hi everybody!
>
> I'm trying to install a CDR Viewer
https://github.com/g613/asterisk-cdr-viewer
>
> I'ts work well, but my problem is to make Asterisk store to MySQL using
ODBC
>
> When I make a call the CLI returns for me
>
> See the log:
> == Using SIP RTP CoS mark 5
> -- Executing [2021 at ramais:1] Dial("SIP/2020-00000000",
> "SIP/2021,60,tT") in new stack
> == Using SIP RTP CoS mark 5
> -- Called SIP/2021
> -- SIP/2021-00000001 is ringing
> > 0x7fd3f8014240 -- Probation passed - setting RTP source
> address to 192.168.25.49:35528
> [Jan 13 11:31:07] NOTICE[2279][C-00000000]: res_rtp_asterisk.c:4441
> ast_rtp_read: Unknown RTP codec 95 received from '(null)'
> -- SIP/2021-00000001 answered SIP/2020-00000000
> > 0x7fd3b4004eb0 -- Probation passed - setting RTP source
> address to 192.168.25.100:8000
> > 0x7fd3f8014240 -- Probation passed - setting RTP source
> address to 192.168.25.49:35528
> > cdr_odbc: Error in ExecDirect: -1
> [Jan 13 11:31:08] WARNING[2279][C-00000000]: res_odbc.c:604
> ast_odbc_direct_execute: SQL Execute error! Verifying connection to
> asterisk [asterisk-connector]...
> > cdr_odbc: Error in ExecDirect: -1
> [Jan 13 11:31:08] ERROR[2279][C-00000000]: cdr_odbc.c:177 odbc_log:
> CDR direct execute failed
>
>
> See my res_odbc.conf
>
> [asterisk]
> enabled = yes
> dsn = asterisk-connector
> username = root
> password = 100567
> pooling = no
> limit = 1
> pre-connect = yes
>
> What can be happened?
>
> Thank in advanced.
Just a guess but try setting "pooling" to yes and "limit" to
a higher value.
Best,
Patrick
------------------------------
_______________________________________________
--Bandwidth and Colocation Provided by http://www.api-digital.com--
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
End of asterisk-users Digest, Vol 138, Issue 8
**********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20160113/242dc594/attachment.html>
On Wednesday 13 Jan 2016, waqas.mehmood90 wrote:> How to get user extention no in agi php scrip from which he's calling on > ivr i am using cid and able to get his name but not his extention no > please help meWithin the dialplan, what you are looking for would be ${CALLERID(num)} . So you could just pass this as a parameter to your AGI script. BUT, it may well be already there as an environment variable within the script. Try writing a "dummy" AGI script that simply dumps the environment array to a temporary file and then returns to the dialplan. -- AJS Note: Originating address only accepts e-mail from list! If replying off- list, change address to asterisk1list at earthshod dot co dot uk .