Clark Could you also check that selinux is disabled?
On Feb 28, 2012, at 8:51 , Clark Cooper wrote: > Yes, I'm able to make a connection from command line (using the password in > the secrets file): > > [root@rhel61 ~]# mysql -u vcluser -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3 > Server version: 5.1.61 Source distribution > > > I still get the connection error after making the suggested MySQL grant: > > mysql> GRANT ALL ON vcl.* TO 'vcluser'@'localhost'; > Query OK, 0 rows affected (0.00 sec) > > Thanks, > Clark > > > -----Original Message----- > From: dcheb...@gmu.edu [mailto:dcheb...@gmu.edu] > Sent: Monday, February 27, 2012 8:54 PM > To: vcl-user@incubator.apache.org > Subject: Re: failed mysql connection > > 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 > ----------------- > > Thank you. ----------------- Dmitri Chebotarov dcheb...@gmu.edu 703-993-6175 -----------------
signature.asc
Description: Message signed with OpenPGP using GPGMail
