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
-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 sms...@cornell.edu 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
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
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 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
