I did that all except “You must have MySQL installed and the development package”. I dont want MySQL on my asterisk server since im accessing an external mySQL dB. Is thier a reason I still need it on thier to be able to do this?
I put this in the dial plan
exten => 904,1,MYSQL(Connect connid 192.168.3.33 root password test)
and get this in the cli
[Jan 2 21:31:23] WARNING[26380]: pbx.c:1797 pbx_extension_helper: No application ‘MYSQL’ for extension (internal, 904, 1)
hi
plz check with following command in Asterisk console "show applications’
& check in application list MYSQL application is included or not . also check asterisk module module directory.
as CLI logs shows ur MYSQL application not install on Asterisk
The message is clear, if you want to build the mysql addon stuff you must have mysql and mysql development packages installed but you don’t have to run the mysql server on your box, just have it installed.
localhost*CLI> show applications
-= Registered Asterisk Applications =-
MP3Player: Play an MP3 file or stream
MusicOnHold: Play Music On Hold indefinitely
NBScat: Play an NBS local stream
It still does not show MYSQL as being installed in the CLI…
so it looks like i need the mysql-devel still correct?
CustomGT: I have faith in you . In order to use MySQL with asterisk you need the add-ons. They are not hard to compile just do:
wget URL_FOR_ADD_ONS_PACKAGE_THAT_YOU_WANT
tar -zxvf package_name
cd /package folder
make clean
make
make install
and then just restart asterisk.
Also I personally use AGI’s for PHP so I can run some other logic(/code) in php. I think that is more of a personal preference.
Edited ‘Makefile’ and insert a line ‘ASTCFLAGS+=-DMYSQL_LOGUNIQUEID’ after the ‘ASTCFLAGS+=-fPIC’ line
make clean
./configure
make
make install
restarted asterisk
and it still doesnt show up with 'show applications’
I have not done this below part::
You must also have the DBD::mysql perl module installed!! Ensure your root@localhost user does not have a password then run the following:
perl -MCPAN -e "install DBD::mysql"
You can then apply your root@localhost password again (or make sure that you have an empty password for root, but be aware…)
@CustomGT, you should check if you have installed the development files of the mysql package, the package should be named something like mysql-dev, then rebuild the mysql addon package.
@Dovid, I agree with you, to me too php and phpagi are the best tools to work with an sql database server, I use the mysql addon just to store the cdr records in a mysql database.
[quote=“mbruni”]@CustomGT, you should check if you have installed the development files of the mysql package, the package should be named something like mysql-dev, then rebuild the mysql addon package.
@Dovid, I agree with you, to me too php and phpagi are the best tools to work with an sql database server, I use the mysql addon just to store the cdr records in a mysql database.
Cheers.
Marco Bruni[/quote]
Awesome thanks for the advice I got it to show up now in the cli. I think I have finally passed that Linux newbie stage, and it feels great. It really limits your asterisk abilities if you dont know it.
PHP is so easy for mysql if im in windows, because im an advanced windows user. In linux its a little harder for me still, but ill be working with it soon for the reasons you stated. For what im doing that MYSQL cmd is simpler.
192.168.3.33 is the IP of my laptop, not my asterisk server. I can run PHP page on my laptop to connect to the MYSQL with host of ‘localhost’ and connect to the db and run queries so I know it works. (i mean i got apache/php/mysql on my laptop and I can run PHP pages with mysql queries…) Maybe the laptop is not allowing the asterisk server to access the mysql dB?
It takes a long time for the second line to come up also, I assume it is timing out…
thanks for the help. I didnt get to use this as it was for linux and I didnt have any linux computers around.
I did get it to work tho! For future readers:
I used a computer at another location. So at the location with the mysql db I had to open up a port in the dsl modem to forward to the mysql db.
Then I had to edit the my.ini file (my.conf in linux i think), i basicly uncommented out the information and put in my information.
Then I had to go into phpmyadmin and add the computer that was outside the network to the permissions. It then allowed me to connect, and I ran my first mysql command on asterisk.
Thier was a syntax error in my string but at least it tried to run it, ill look at that later tonite hopefully…
thanks for the help, this is one project almost done that i have been working on for a few weeks
Here is a basic query I did, its tested and works for anyone looking for help on MYSQL cmd. The wiki helped some but they always try to do too advanced things with the examples…
[quote=“CustomGT”];
192.168.3.33 is the IP of my laptop, not my asterisk server. I can run PHP page on my laptop to connect to the MYSQL with host of ‘localhost’ and connect to the db and run queries so I know it works. (i mean i got apache/php/mysql on my laptop and I can run PHP pages with mysql queries…) Maybe the laptop is not allowing the asterisk server to access the mysql dB?
It takes a long time for the second line to come up also, I assume it is timing out…[/quote]
do you have the ‘%’ in the Mysql.users database? Maybe your mysql server accepts connection from mysql only, so you have to add the ip of your asterisk server or you can use %
[quote=“vctor”][quote=“CustomGT”];
192.168.3.33 is the IP of my laptop, not my asterisk server. I can run PHP page on my laptop to connect to the MYSQL with host of ‘localhost’ and connect to the db and run queries so I know it works. (i mean i got apache/php/mysql on my laptop and I can run PHP pages with mysql queries…) Maybe the laptop is not allowing the asterisk server to access the mysql dB?
It takes a long time for the second line to come up also, I assume it is timing out…[/quote]
do you have the ‘%’ in the Mysql.users database? Maybe your mysql server accepts connection from mysql only, so you have to add the ip of your asterisk server or you can use %[/quote]
I fixed all this already. mySQL wasnt accepting connections from other hosts besides localhost. I had to edit my.ini (windows) then go into phpmyadmin and give permissions to the hosts trying to connect to the mySQL database.
. In order to use MySQL with asterisk you need the add-ons. They are not hard to compile just do: