Asterisk can't connect to MySQL database
From Kolmisoft Wiki
Jump to navigationJump to search
If your asterisk is unable connect to your database, there could be several problems.
1) Make sure you have correct connection info in these files:
/home/mor/config/database.yml /etc/asterisk/mor.conf /etc/asterisk/res_mysql.conf /var/lib/asterisk/agi-bin/mor.conf /home/mor/public/c2c/c2c.php
/etc/asterisk/extconfig.conf -> make sure in this file correct database name is entered:
iaxusers = mysql,mor,devices iaxpeers = mysql,mor,devices sipusers = mysql,mor,devices sippeers = mysql,mor,devices realtime_ext => mysql,mor,extlines voicemail => mysql,mor_app02,voicemail_boxes
2) Check for /etc/hosts file, there could be incorrect info.
3) Check for DNS, ping MySQL server and double check if packets reaching MySQL server. iptraf program is very usefull in such situations.