how to connect elastix-asterisk to remote database?

Question

I have been working on elastix on a local setup ,and I have copied the database to remote server , now I am struggling to configure elastix and a2billing to that remote database , I have changed the following files but still not connecting to the remote database :

./asterisk/cdr_mysql.conf --> to change for cdr tables
./asterisk/cbmysql.conf --> to change for meetme app
./asterisk/res_mysql.conf --> to change a2billing realtime
./a2billing.conf  --> to change main a2billing database

appreciate the help if something is missing

Regards,

Answer 1

With the "struggling" word is hard to tell wich is your error or problem. Most common problems is security from MySQL refusing to connect remote IP Addresses. Also is the confusing that Elastix use Sqlite3 databases (stored in /var/www/db) and Asterisk use MySQL, but the Call details record is in MySQL asteriskcdrdb, so I am thinking is this your target:

1. Open and Edit "etc/my.cnf" using vi or any editor.
2. Add "skip-grant-tables" under [mysqld]. Save changes.
3. Restart MySql to take the changes using "service mysqld start".