ELMIT
May 26th, 2008, 04:51 AM
I have replaced a SuSE server with an Ubuntu 8.04 server.
The server runs MySQL, which is working locally. My Asterisk server (192.168.1.20) should access this MySQL server (192.168.1.254). I have left on the Asterisk server my old settings:
[general]
dbhost = 192.168.1.254
dbname = myasterisk
dbuser = myastuser
dbpass = myastpass
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
In MySQL I have setup a record with
INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`) VALUES
('192.168.1.20', 'root', '**********************', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);
However, the remote client (*.20) cannot connect to the server (*.254):
[May 26 11:50:21] ERROR[3096]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Failed to connect database server myasterisk on 192.168.1.254 (err 2003). Check debug for more info.
What do I miss?
bye
Ronald
The server runs MySQL, which is working locally. My Asterisk server (192.168.1.20) should access this MySQL server (192.168.1.254). I have left on the Asterisk server my old settings:
[general]
dbhost = 192.168.1.254
dbname = myasterisk
dbuser = myastuser
dbpass = myastpass
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
In MySQL I have setup a record with
INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`) VALUES
('192.168.1.20', 'root', '**********************', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);
However, the remote client (*.20) cannot connect to the server (*.254):
[May 26 11:50:21] ERROR[3096]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Failed to connect database server myasterisk on 192.168.1.254 (err 2003). Check debug for more info.
What do I miss?
bye
Ronald