Hi.. .and thank you for your help.
I just tried your example.. and yes it did return what i wanted (with my
information)
One thing I need to add here i'm using mysql-realtime configuration.
So when I'm running using mysql extensions I get this:
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-13", "Connect connid
localhost dbuser dbpass dbname")
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-13", "Query resultid
5 SELECT ivr_password FROM users WHERE ivr-id = 1234")
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-13", "Fetch fetchid
ivr_password")
May 18 10:59:43 WARNING[12640]: app_addon_sql_mysql.c:113 find_identifier:
Identifier 0, identifier_type 2 not found in identifier list
May 18 10:59:43 WARNING[12640]: app_addon_sql_mysql.c:328 aMYSQL_fetch:
aMYSQL_fetch: Invalid result identifier 0 passed
== Spawn extension (macro-mmisd-login, s, 9) exited non-zero on
'IAX2/[EMAIL PROTECTED]:4569-13' in macro 'mmisd-login'
== Spawn extension (ivr-mmisd-login, 1, 12) exited non-zero on
'IAX2/[EMAIL PROTECTED]:4569-13'
When I use extensions.conf hard coded i get:
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-15", "Query resultid
5 SELECT ivr_password FROM users where ivr_id=1234") in new stack
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-15", "Fetch fetchid 6
ivr_password") in new stack
May 18 10:57:41 WARNING[12640]: app_addon_sql_mysql.c:316 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-15", "Clear 6") in
new stack
-- Executing MYSQL("IAX2/[EMAIL PROTECTED]:4569-15", "Disconnect 5")
in new stack
-- Executing NoOp("IAX2/[EMAIL PROTECTED]:4569-15", "ivr_password =
0000") in new stack
It works..
So.... how do I make this work in using mysql extensions!???
Thanks
_______________________________________________
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
