No application 'mysql' for extension

Asterisk Asterisk Support
1

Hello,

I am having fedora 8. and I have installed asterisk-1.6.0.26 and asterisk-addons-1.6.0.4, mysql-5.0.45-4.fc8.

I am trying to make SIP to PSTN calling and vise versa using PRI lines. I am having my database in mysql.
When I dial any number, its giving me the following error message. I have also given the access privileges to the database.
please guide me, if anything is missing or wrong.

[color=#800040]no application ‘mysql’ for extension (from-pstn, … )
[/color]

Following is my extension.conf file

[from-pstn]
exten => _X.,1,Answer()
exten => _X.,n,MYSQL(Connect connid 127.0.0.1 root root call_center)
exten => _X.,n,MYSQL(Query resultid ${connid} select ProcessID from ProcessMaster where TollFreeNo=${EXTEN})
exten => _X.,n,MYSQL(Fetch fetchid ${resultid} ProcessID)
exten => _X.,n,MYSQL(Clear ${resultid})
exten => _X.,n,MYSQL(Disconnect ${connid})

=========================

Thanks for your support in advance.

-Urmi

2

You can see if you have mysql modules:
asterisk>module show like mysql
Answer to this question on my server is:

app_addon_sql_mysql.so Simple Mysql Interface 0
res_config_mysql.so MySQL RealTime Configuration Driver 0
cdr_addon_mysql.so MySQL CDR Backend 0
I think you surely need at least app_addon_sql_mysql.so and may be not now but in future res_config_mysql.so

3

Hello,

The mysql module is not there. Can you please tell me whats wrong with this ? What I am missing ?

*CLI> module show like mysql
Module Description Use Count
0 modules loaded

I have install mysql as well in the system.

==========================================
[root@localhost ~]# rpm -qa | grep mysql
mysql+±2.3.2-2.fc8
mysql-query-browser-5.0r12-3.fc8
mysql-devel-5.0.45-4.fc8
mysql-connector-odbc-3.51.14r248-2.fc8
mysql+±manuals-2.3.2-2.fc8
mysql-gui-tools-5.0r12-3.fc8
mysql-libs-5.0.45-4.fc8
mysql-gui-common-5.0r12-3.fc8
mysql-bench-5.0.45-4.fc8
mysql-connector-java-3.1.12-3.fc6
mysql-test-5.0.45-4.fc8
php-mysql-5.2.4-3
mysql+±devel-2.3.2-2.fc8
mysql-proxy-0.5.1-3.fc8
mysql-5.0.45-4.fc8
mysql-server-5.0.45-4.fc8
mysql-administrator-5.0r12-3.fc8

Thank you for your support.

-Urmi

4

Hello,

The problem is solved. I have recompile the asterisk-addons as follows.
make distclean
./configure
make
make install

then restarted the asterisk. mysql module is installed in asterisk.
And my dial plan is working well. :smile:

-Urmi