Difference between revisions of "Asterisk can't connect to MySQL database"
From Kolmisoft Wiki
Jump to navigationJump to search
Line 8: | Line 8: | ||
/var/lib/asterisk/agi-bin/mor.conf | /var/lib/asterisk/agi-bin/mor.conf | ||
/home/mor/public/c2c/c2c.php | /home/mor/public/c2c/c2c.php | ||
/etc/asterisk/extconfig.conf -> make sure in this file correct database name is entered: | |||
iaxusers = mysql,'''mor''',devices | iaxusers = mysql,'''mor''',devices | ||
iaxpeers = mysql,'''mor''',devices | iaxpeers = mysql,'''mor''',devices |
Latest revision as of 11:35, 22 November 2011
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.