Still trying to get VCL setup/configured and moving past the php-mcrypt issue,
I also receive the following message within my testsetup.php output:
Testing mysql connection ...
Error: fsockopen(): unable to connect to localhost:3306 (Permission denied)
Could not connect to port 3306 on localhost
For debugging purposes, I have stopped iptables. Here is the connection
information within my secrets.php file:
[root@rhel61 .ht-inc]# grep vcl secrets.php
$vclhost = 'localhost'; # name of mysql server
$vcldb = 'vcl'; # name of mysql database
$vclusername = 'vcluser'; # username to access database
$vclpassword = 'vcluserpassword'; # password to access database
Note the following outputs from MySQL:
mysql> show grants for vcluser@localhost;
+----------------------------------------------------------------------------------------------------------------+
| Grants for vcluser@localhost
|
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'vcluser'@'localhost' IDENTIFIED BY PASSWORD
'*BC54E34381D07EB1FF25938A2F524C17201FC22F' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES ON
`vcl`.* TO 'vcluser'@'localhost' |
+----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select host, user, password from mysql.user;
+-----------+---------+-------------------------------------------+
| host | user | password |
+-----------+---------+-------------------------------------------+
| localhost | root | *A195277AB4567B2C3C4CDCAF6B5B48409EFE6765 |
| 127.0.0.1 | root | *A195277AB4567B2C3C4CDCAF6B5B48409EFE6765 |
| localhost | vcluser | *BC54E34381D07EB1FF25938A2F524C17201FC22F |
+-----------+---------+-------------------------------------------+
Clark Cooper | Senior Systems Engineer
1301 Gervais Street, Suite 1800 | Columbia, SC 29201
(d) 803.978.2699 | (f) 803.733.5888
clark.coo...@vc3.com | www.VC3.com
Follow us:
