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.