Linux sysadmin needed (CentOS +some PHP mysql knowledge)

[holden1]

We have an issue with our website (Tor hidden service), we would like to hire someone to walk us through a fix.

Issue appears to be that our front end code cannot connect to the MySQL instance running on the server.
Suspect it's a permissions issue. We have SSH access to the dedicated server (CentOS) and are looking for someone who can spend a few hours with us in a chat walking us through the steps required to fix the problem. Willing to pay 75$/hr if you can get it done in a few hours.

This is the error code that appears when accessing our URL:

Code:

ERROR: Unable to connect to MySQL server! Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Once on the server, I did start mysqld but that didn't seem to solve the problem. I am able to access mysql shell on the server, the site runs on PHP.

Skills required: CentOS, PHP, mysql and linux sysadmin, possibly Tor hidden services, though I don't think the issue resides there.

Please email me directly at:

henry.holden@yandex.com

Include a GitHub profile if possible. Payment will be issued in BTC upon successful completion of the project and suitable compensation for your time will be provided given a reasonable effort even if a solution is not found.

Thanks for looking!

Henry

[1715215745]

1715215745

[1715215745]

1715215745

[1715215745]

1715215745

[SmartIphone]

Wanted to send you an email but couldn't send because of this error:

Code:

Delivery to the following recipient failed permanently:

     henry.holden@yandex.com

Technical details of permanent failure:
Google tried to deliver your message, but it was rejected by the server for the recipient domain yandex.com by mx.yandex.ru. [2a02:6b8::89].

The error that the other server returned was:
550 5.7.1 Policy rejection on the target address

Anyway I'm sending you a PM.

[Bitsky]

If you want to check perms, here are the default ones from a CentOS7 box of mine:

Code:

[root@srv ~]# rpm -q mariadb-server
mariadb-server-5.5.50-1.el7_2.x86_64

[root@srv ~]# rpm -V mariadb-server

[root@srv ~]# ls -laZ /var/lib/mysql/mysql.sock 
srwxrwxrwx. mysql mysql system_u:object_r:mysqld_var_run_t:s0 /var/lib/mysql/mysql.sock

[root@srv ~]# ps aux | grep -v grep | grep mariadb
mysql    15079  0.1  7.9 904956 80768 ?        Sl   09:20   0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock

Fix perms in case they are messed up

Code:

[root@srv ~]# chmod 777 /var/lib/mysql/mysql.sock 
[root@srv ~]# restorecon -rF /var/lib/mysql/

I don't think it might be a SELinux issue, but you can try

Code:

[root@srv ~]# setsebool -P httpd_can_network_connect_db on