[SOLVED] Using mysql with asterisk

Using mysql with asterisk

I have installed asterisk 11 on my centos 6 ,now i want to connect my asterisk with database I am following this .I have both installed and configured mysql

I have created an outbound call (b.call)

Channel: DAHDI/g0/09********
MaxRetries: 1
RetryTime: 60
WaitTime: 30
Context: out
Extension: 47******
Priority: 1

and a simple dialplan(extensions.conf)

[out]
exten => 47*****,1,NoOp(<-------IVR----------->)
same => n,dial(DAHDI/g0/09********)
same => n,MYSQL(Connect connid localhost username pass dbname)
same => n,MYSQL(Query resultid ${connid} INSERT INTO `emp` (`name`) VALUES ('Akash'))

My problem is that,first 2 lines of dialplan executes perfectly but database lines are not executed,cli shows only first 2 lines executed and last 2 lines not executed.

Am i missing any configuration settings??

Thanks

Solution

Very likly you have no app_mysql loaded.

I higly not recommend use outdated mysql app. Use instead function REALTIME and func_ODBC.