"A database error occurred"
The message "A database error occurred" is shown when SyMAP cannot
access the MySQL database. There are several possible causes.
Check the database privileges
The database user specified in the SyMAP params file (db_clientuser)
may not have remote access to the database as specified in the mysql.user table.
As an example, to add remote access from all hosts for user named 'db_clientuser':
mysql> use mysql;
mysql> insert into user values ('%','db_clientuser',PASSWORD('db_clientpasswd'),'Y','Y','Y','Y','Y','Y','N','N','N',
'N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0);
mysql> flush privileges;
Also try using the mysqlaccess script to show which entries in the mysql
privilege tables are in use for a particular host/user/password.
Check the MySQL configuration
The MySQL configuration file (/etc/my.cnf) should not contain any
of the following lines that prevent remote access to the database.
bind_address=127.0.0.1
skip_networking
Make sure the port is visible
If the database is on a different computer, test that its port 3306 is visible
from your computer:
telnet <server address> 3306
If it doesn't make a connection then either the server isn't running, or the
port is blocked by a firewall. Contact a system administrator. (Note,
to get out of telnet type "^]".)