[Asterisk-Users] Mysql cmd with Asterisk Problems

[pbx at itsngroup.com]

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/4000 at 129.46.90.210:4569-13", "Connect connid
localhost dbuser dbpass dbname")
    -- Executing MYSQL("IAX2/4000 at 129.46.90.210:4569-13", "Query resultid
5 SELECT ivr_password FROM users WHERE ivr-id = 1234")
    -- Executing MYSQL("IAX2/4000 at 129.46.90.210: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/4000 at 129.46.90.210:4569-13' in macro 'mmisd-login'
  == Spawn extension (ivr-mmisd-login, 1, 12) exited non-zero on
'IAX2/4000 at 129.46.90.210:4569-13'

When I use extensions.conf  hard coded i get:
    -- Executing MYSQL("IAX2/4000 at 129.46.90.210:4569-15", "Query resultid
5 SELECT ivr_password FROM users where ivr_id=1234") in new stack
    -- Executing MYSQL("IAX2/4000 at 129.46.90.210: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/4000 at 129.46.90.210:4569-15", "Clear 6") in
new stack
    -- Executing MYSQL("IAX2/4000 at 129.46.90.210:4569-15", "Disconnect 5")
in new stack
    -- Executing NoOp("IAX2/4000 at 129.46.90.210:4569-15", "ivr_password =
0000") in new stack

It works..

So.... how do I make this work in using mysql extensions!???

Thanks