Can you show the output of netstat -tap?
For example:
[root@xxx postfix]# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:32769 *:* LISTEN 1734/rpc.statd
tcp 0 0 *:mysql *:* LISTEN 2176/mysqld
tcp 0 0 *:sunrpc *:* LISTEN 1716/portmap
tcp 0 0 *:81 *:* LISTEN 2515/ispconfig_http
tcp 0 0 xxx.xxx.xxx:domain *:* LISTEN 2638/named
tcp 0 0 192.168.1.101:domain *:* LISTEN 2638/named
tcp 0 0 192.168.0.100:domain *:* LISTEN 2638/named
tcp 0 0 localhost.localdomai:domain *:* LISTEN 2638/named
tcp 0 0 localhost.localdomain:ipp *:* LISTEN 2042/cupsd
tcp 0 0 localhost.localdomain:5335 *:* LISTEN 2024/mDNSResponder
tcp 0 0 *:smtp *:* LISTEN 7655/master
tcp 0 0 localhost.localdomain:rndc *:* LISTEN 2638/named
tcp 0 0 *:imaps *:* LISTEN 3413/dovecot
tcp 0 0 *:pop3s *:* LISTEN 3413/dovecot
tcp 0 0 *:pop3 *:* LISTEN 3413/dovecot
tcp 0 0 *:imap *:* LISTEN 3413/dovecot
tcp 0 0 *:http *:* LISTEN 2538/httpd
tcp 0 0 *:ftp *:* LISTEN 2654/proftpd: (acce
tcp 0 0 *:ssh *:* LISTEN 2072/sshd
tcp 0 0 ::1:rndc *:* LISTEN 2638/named
tcp 0 0 *:https *:* LISTEN 2538/httpd
tcp 0 148 xxx.xxx.xxx:ssh ::ffff:192.168.1.2:1407 ESTABLISHED 3029/0
This will show what services/ports are running on your sever. This should help you identify that your server has mySQL active. Finally, if you really want to verify that your sql database is configured correctly, then you can log into mysql and check by typing:
mysql -h localhost -u roundcube -p
Enter password: *Enter password for roundcube user here*
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 4.1.20
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW DATABASES;
+---------------+
| Database |
+---------------+
| roundcubemail |
| test |
+---------------+
2 rows in set (0.00 sec)
mysql> USE roundcubemail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW TABLES;
+-------------------------+
| Tables_in_roundcubemail |
+-------------------------+
| cache |
| contacts |
| identities |
| messages |
| session |
| users |
+-------------------------+
6 rows in set (0.01 sec)
mysql> exit;
Remember that the password you enter is the same one shown in your db.inc.php file on the line that reads:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
If you configured your database as described in the INSTALL file that came with the source code, then everything should check out when you attempt to access your database from the command line. Otherwise, you should reconfigure mysql by following the INSTALL file again.
Good Luck,
Craig.