SQLSTATE[HY000] [2002] Permission denied

[rashantha]

Hi Everyone,

I am new to froxlor moving from Sentora. Setting up on Centos 7. I followed these directions with PHP 7.

https://www.vultr.com/docs/how-to-install-the-froxlor-server-management-panel-on-centos-7

I am getting the error below and from googling I reckon it not a password issue. I did the installation twice just to make sure it's not a password issue. It looks more like a connection issue.

So I checked to make sure it's not a port issue. Any help would be greatly appreciated.

semanage port -l | grep http_port_t
http_port_t                    tcp      80, 81, 443, 488, 8008, 8009, 8443, 9000
pegasus_http_port_t            tcp      5988
 

Checking MySQL-root access...

SQLSTATE[HY000] [2002] Permission denied

There seems to be a problem with the database-connection. Cannot continue. Please go back and check your credentials.

[rashantha]

Success!

I had to remove the DB creation and let the install script do it for me.

I also disabled selinux.

I should create guide.

[d00p]

did you try 

etsebool httpd_can_network_connect_db 1

I'm not very familiar with centos and the SELinux stuff...see https://stackoverflow.com/questions/34673627/sqlstatehy000-2002-permission-denied?answertab=votes#tab-top

[rashantha]

Thanks for the fast response.

So I did 

getsebool -a | grep httpd 

and then followed with  setsebool -P httpd_can_network_connect_db 1 after that

I was able to run the install and successfully but then when you click login link it takes you back to the install and not the login.

Do you recommend another Centos 7/PhP install guide?

[d00p]

Are you sure the setup completed successfully and you READ everything on the last screen CAREFULLY?

[rashantha]

Yes. All green.

If I run it again it states that it was already run.

[rashantha]

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| froxlor            |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.04 sec)
 

[rashantha]

[rashantha]

If I run it again...

 

[rashantha]

So I have solved this by creating the file manually 'userdata.inc.php'

I do get a login screen now. But I have a feeling something is wrong. most likely with permissions, but no clue...

[rashantha]

Nah.

User not found. Login Admin.

[d00p]

Because as said you did Not read carefully:

9 hours ago, rashantha said:

Why do you think there is yellow Text instead of all green? Again: read carefully...

Alternatively, Set correct permissions so that the Webserver User can write to /var/www/html/froxlor

[rashantha]

13 hours ago, d00p said:

 

Because as said you did Not read carefully:

Why do you think there is yellow Text instead of all green? Again: read carefully...

Alternatively, Set correct permissions so that the Webserver User can write to /var/www/html/froxlor

I did run this... so not sure why it couldn't create the file.

chown -R apache:apache /var/www/html/froxlor

d00p - do you see any other issues in that guide - https://www.vultr.com/docs/how-to-install-the-froxlor-server-management-panel-on-centos-7

 

 

[rashantha]

Going to try 1 last time... thinking of SELINUX=disabled but not sure about this? If anyone has installed on CENTOS7 any further input would be appreciated. tia.

 

 

[rashantha]

 

Hey @d00p I have tried several times. I keep getting that the file can't be written

 

looked at user of egrep -i '^user|^group' /etc/httpd/conf/httpd.conf 

tried chown apache: -R froxlor (after cd into correct folder)

also tried sudo chown -R apache:apache /var/www/html/froxlor

still getting below. If I create the file then I get no user. Any other advice?