RE: failed mysql connection
That was it... SeLinux was enabled, but apparently not configured to allow as mentioned in the installation steps: /usr/sbin/setsebool -P httpd_can_network_connect=1 Thank you, Clark -Original Message- From: dcheb...@gmu.edu [mailto:dcheb...@gmu.edu] Sent: Tuesday, February 28, 2012 8:53 AM To: vcl-user@incubator.apache.org Subject: Re: failed mysql connection 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 -
Re: failed mysql connection
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
Re: failed mysql connection
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Feb 27, 2012 at 09:36:51PM +, 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 > This might seem like a dumb question but do you have MySQL set up to listen on port 3306? I've seen some installations that only enable the Unix domain socket for safety reasons. - -- Scott M. Sorrentino CIT Systems & Operations, Cornell University 726 Rhodes Hall // (607) 254-8535 GnuPG fingerprint: 6E30 0B83 43F8 CF8B 3B44 7DBE 6AAE DFC9 1DE6 8C1C -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk9M3gMACgkQaq7fyR3mjByC4gCdEi/Ko/4DgrLb7jz9+pLQSpCK 1QoAn3MpbECUwxMaSSFpcdVeojTmCBnd =3dT1 -END PGP SIGNATURE-
RE: failed mysql connection
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 -
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 - signature.asc Description: Message signed with OpenPGP using GPGMail
