date:20171016

Re: [asterisk-users] Confbridge GUI?

2017-10-16 Thread Dan Austin

Interesting.  Are you using the included cbend.php script to terminate 
conferences?
I occasionally get questions about using WMM with Confbridge, and to date I have
not had an answer .

If you can provide details, even vague ones, about how you did it, I can update 
the
WMM package.

Dan

-Original Message-
From: asterisk-users-boun...@lists.digium.com 
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Richard Kenner
Sent: Friday, October 13, 2017 2:14 PM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] Confbridge GUI?

>  I have a very old server that is used only for conferences on 
> Meetme.  To manage the conference rooms we use Web Meetme.  Now it is 
> time to upgrade everything but since Meetme is no longer available I 
> need to find a replacement GUI to manage the conference rooms.  Anyone 
> know a solution that works with Confbridge?  

It's straightforward to use web-meetme with Confbridge; we've been doing
it here for years.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

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


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

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

Re: [asterisk-users] Realtime extensions, Multiple SQL lookups?

2017-10-16 Thread Dovid Bender

It's been years since I have used real time but can it be because of the
GoSub?



On Mon, Oct 16, 2017 at 12:39 PM, John Kiniston 
wrote:

> I'm toying with the idea of replacing a statically generated file I
> include in my extensions.conf with a realtime lookup against my database.
>
> I've got it working but something seems off in my logs, It looks like I'm
> getting two lookups for every priority?
>
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
> 0x7f8da8002938 from class 'odbc_kiniston-test'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0;
> SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND
> context = ?
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
> ('exten') = '5206700792 <(520)%20670-0792>'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
> ('priority') = '5'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
> ('context') = 'sip-in'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
> handle 0x7f8da8002938 into pool
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
> 0x7f8da8002938 from class 'odbc_kiniston-test'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0;
> SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND
> context = ?
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
> ('exten') = '5206700792 <(520)%20670-0792>'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
> ('priority') = '5'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
> ('context') = 'sip-in'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
> handle 0x7f8da8002938 into pool
> [Oct 12 16:45:24] VERBOSE[26541][C-000e] pbx_realtime.c: Executing
> [5206700792 <(520)%20670-0792>@sip-in:5] Gosub("PJSIP/trunks1-000e",
> "sub-setupinboundcall,s,1(kiniston,Pop_Country_Crossover,300,VOIP)")
>
> ---SNIP---
>
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
> 0x7f8da8002938 from class 'odbc_kiniston-test'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0;
> SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND
> context = ?
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
> ('exten') = '5206700792 <(520)%20670-0792>'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
> ('priority') = '6'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
> ('context') = 'sip-in'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
> handle 0x7f8da8002938 into pool
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
> 0x7f8da8002938 from class 'odbc_kiniston-test'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0;
> SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND
> context = ?
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
> ('exten') = '5206700792 <(520)%20670-0792>'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
> ('priority') = '6'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
> ('context') = 'sip-in'
> [Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
> handle 0x7f8da8002938 into pool
> [Oct 12 16:45:24] VERBOSE[26541][C-000e] pbx_realtime.c: Executing
> [5206700792 <(520)%20670-0792>@sip-in:6] Goto("PJSIP/trunk1-000e",
> "kiniston-ivr,s,1")
> [Oct 12 16:45:24] VERBOSE[26541][C-000e] pbx_builtins.c: Goto
> (kiniston-ivr,s,1)
>
>
>
> The contents of my table are just
> idcontextextenpriorityappappdata
> 7301702413361087843 sip-in5206700792 <(520)%20670-0792>5
> Gosubsub-setupinboundcall,s,1(kiniston,Pop_Country_Crossover,300,VOIP)
> 7301702413361087848sip-in5206700792 <(520)%20670-0792>6
> Gotokiniston-ivr,s,1
>
> My extensions.conf
> [sip-in]
> exten => _X.,1,Log(NOTICE,Incoming ${CHANNEL:0:3} call DID: ${EXTEN} from
> CallerID: ${CALLERID(num)} ${CALLERID(name)}, ANI:${CALLERID(ani)}
> ANI2:${CALLINGANI2})
> exten => _X.,2,Set(ARRAY(CDR(firstext),CDR(firstcontext))=${EXTEN},${
> CONTEXT})
> exten => _X.,3,Set(ARRAY(__FirstEXT,__FirstContext)=${EXTEN},${CONTEXT})
> exten => _X.,4,Set(CHANNEL(hangup_handler_push)=cdr-fixup,s,1)
> exten => _X.,7,Hangup()
> switch => Realtime/sip-in@extensions/p
>
>
> Has anyone else noticed this behavior? Is it expected? I dont' see any
> mentions of it in any the docs.
>
> --
> A human being should be able to change a diaper, plan an invasion, butcher
> a hog, conn a ship, design a building, write a sonnet, balance accounts,
> build a wall, set a bone, comfort the dying, take orders, give orders,
> cooperate, act alone, solve equations, analyze a n

[asterisk-users] Realtime extensions, Multiple SQL lookups?

2017-10-16 Thread John Kiniston

I'm toying with the idea of replacing a statically generated file I include
in my extensions.conf with a realtime lookup against my database.

I've got it working but something seems off in my logs, It looks like I'm
getting two lookups for every priority?

[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
0x7f8da8002938 from class 'odbc_kiniston-test'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0; SQL:
SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context
= ?
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
('exten') = '5206700792'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
('priority') = '5'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
('context') = 'sip-in'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
handle 0x7f8da8002938 into pool
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
0x7f8da8002938 from class 'odbc_kiniston-test'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0; SQL:
SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context
= ?
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
('exten') = '5206700792'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
('priority') = '5'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
('context') = 'sip-in'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
handle 0x7f8da8002938 into pool
[Oct 12 16:45:24] VERBOSE[26541][C-000e] pbx_realtime.c: Executing
[5206700792@sip-in:5] Gosub("PJSIP/trunks1-000e",
"sub-setupinboundcall,s,1(kiniston,Pop_Country_Crossover,300,VOIP)")

---SNIP---

[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
0x7f8da8002938 from class 'odbc_kiniston-test'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0; SQL:
SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context
= ?
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
('exten') = '5206700792'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
('priority') = '6'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
('context') = 'sip-in'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
handle 0x7f8da8002938 into pool
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Reusing ODBC handle
0x7f8da8002938 from class 'odbc_kiniston-test'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Skip: 0; SQL:
SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context
= ?
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 1
('exten') = '5206700792'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 2
('priority') = '6'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_config_odbc.c: Parameter 3
('context') = 'sip-in'
[Oct 12 16:45:24] DEBUG[26541][C-000e] res_odbc.c: Releasing ODBC
handle 0x7f8da8002938 into pool
[Oct 12 16:45:24] VERBOSE[26541][C-000e] pbx_realtime.c: Executing
[5206700792@sip-in:6] Goto("PJSIP/trunk1-000e", "kiniston-ivr,s,1")
[Oct 12 16:45:24] VERBOSE[26541][C-000e] pbx_builtins.c: Goto
(kiniston-ivr,s,1)



The contents of my table are just
idcontextextenpriorityappappdata
7301702413361087843 sip-in52067007925Gosub
sub-setupinboundcall,s,1(kiniston,Pop_Country_Crossover,300,VOIP)
7301702413361087848sip-in52067007926Gotokiniston-ivr,s,1

My extensions.conf
[sip-in]
exten => _X.,1,Log(NOTICE,Incoming ${CHANNEL:0:3} call DID: ${EXTEN} from
CallerID: ${CALLERID(num)} ${CALLERID(name)}, ANI:${CALLERID(ani)}
ANI2:${CALLINGANI2})
exten =>
_X.,2,Set(ARRAY(CDR(firstext),CDR(firstcontext))=${EXTEN},${CONTEXT})
exten => _X.,3,Set(ARRAY(__FirstEXT,__FirstContext)=${EXTEN},${CONTEXT})
exten => _X.,4,Set(CHANNEL(hangup_handler_push)=cdr-fixup,s,1)
exten => _X.,7,Hangup()
switch => Realtime/sip-in@extensions/p


Has anyone else noticed this behavior? Is it expected? I dont' see any
mentions of it in any the docs.

-- 
A human being should be able to change a diaper, plan an invasion, butcher
a hog, conn a ship, design a building, write a sonnet, balance accounts,
build a wall, set a bone, comfort the dying, take orders, give orders,
cooperate, act alone, solve equations, analyze a new problem, pitch manure,
program a computer, cook a tasty meal, fight efficiently, die gallantly.
Specialization is for insects.
---Heinlein
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users m

Re: [asterisk-users] Confbridge GUI?

Re: [asterisk-users] Realtime extensions, Multiple SQL lookups?

[asterisk-users] Realtime extensions, Multiple SQL lookups?

3 matches

Site Navigation

Mail list logo

Footer information