Changing Asterisk Database Server

Hi,

I would just like to know from where can i change IP address of database server for asterisk.
I have installed
asterisk on = 192.168.0.10
mysql database server on = 192.168.0.15

so i just want to set 192.168.0.15 as main database server for asterisk. from where can i dot that, which file need to be edited.

Hi mudasir!

I have about the same.

In Asterisk edit the file
/etc/asterisk/res_mysql.conf

[general] dbhost = 192.168.0.15 dbname = DBname dbuser = DBusername dbpass = DBpassword dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock (or where you have it)
This works for me for the CDR data!

If you do some SQL DB lookups in the dialplan you should do the changes in there!