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: 



Reply via email to