[asterisk-users] Ubuntu as remote MySQL server

[Ronald Wiplinger]

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