Clark

Are you able to connect to mysql from command line on rhel61 host, 'mysql -u 
vcluser -p' ?
Can you also try with GRAND ALL ON vcl.* TO 'vcluser'@localhost?

On Feb 27, 2012, at 16:36 , Clark Cooper wrote:

> 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: 
> 
> 
> 




Thank you.

-----------------
Dmitri Chebotarov
dcheb...@gmu.edu
703-993-6175
-----------------


Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

Reply via email to