> I also dropped the quotes on the dnis=${IVR-Exten}.
That's only allowed if the dnis column doesn't contain a string.
--
Andreas SikkemaBBeyond
Software EngineerPlaneetbaan 4
+31 (0)23 70743422132 HZ Hoofddorp
___
It can get confusing at first but once you get the hang of it, its a breeze.
first take a look at: http://www.voip-info.org/wiki-Asterisk+cmd+MYSQL
there is plenty of (correct)info and (working)examples on this page.
you have to \escape a space,quote and double quote, comma and backslash - so
you
Sorry, me again..
I'm at a loss as to why your example worked and mine didn't - I was
using one of the last examples I found during my searches.
Can you tell me when/why I need to use the escape or quotes? Is there
some basic rule to follow? I'm asking because there is
a confusing mix of exam
That's the correct syntax:
exten => s,1,Noop()
exten => s,n,MYSQL(Connect connid localhost root passw0rd dax)
exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\
dnislookup\ WHERE\ dnis=${IVR-Exten})
exten => s,n,MYSQL(Fetch fetchid ${resultid} password)
exten => s,n,MYSQL(Clear
Sorry,
From the logs I see:
Apr 13 13:32:06 WARNING[19854] app_addon_sql_mysql.c: Identifier 0,
identifier_type 2 not found in identifier list
Apr 13 13:32:06 WARNING[19854] app_addon_sql_mysql.c: aMYSQL_fetch:
Invalid result identifier 0 passed
Using this:
exten => s,1,Noop()
exten => s,n,M
On Fri, 13 Apr 2007, Barton Fisher said something to this effect:
What wrong with this:
Well... what is wrong with it? :-)
I'm not trying to be funny, but, what are the symptoms that it doesn't
work? Error output on Asterisk console? Logs? Anything you can provide
would be helpful.
Barton Fisher wrote:
What wrong with this:
[get-dnisinfo]
; sub-routine to get owner's password
exten => s,1,Verbose( == )
exten => s,n,MYSQL(Connect connid localhost root password dax)
exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\
dnislookup\ WHERE\ dnis=\'${IVR-Exten}\'
