Hi all,
I was trying to use MYSQL cmd in my externtion file, but i have some issue with some error:
here is my extention.
[mysqlt]
exten => _X.,1,MYSQL(Connect connid localhost asterisk pws dbname)
exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\ IPaddr,\ gwtype,\ prefix\ from\ gateway\ where\ id=4)
exten => _X.,3,MYSQL(Fetch fetchid ${resultid} IPaddr gwtype prefix)
exten => _X.,4,MYSQL(Query resultid ${connid} INSERT\ INTO\ radpostauth\ set\ user=${IPaddr})
exten => s,n,MYSQL(Disconnect ${connid})My Error:
[code]
Jul 9 08:53:04 WARNING[966] app_addon_sql_mysql.c: ast_MYSQL_fetch: numFields=1
Jul 9 08:53:04 WARNING[966] app_addon_sql_mysql.c: aMYSQL_query: mysql_store_result() failed on query INSERT INTO radpostauth set user=
[/code
I am not able to get value for user field of radpostauth.
Any idea please…
]