Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - cronnin

Pages: [1]
1
CentOS 7 Problems / Re: Firewall problem
« on: March 17, 2020, 12:25:09 AM »
Ok, here is the message. It showed up after logging into CWP, situation resolved itself and everything started working.


Code: [Select]
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

2
CentOS 7 Problems / Re: Firewall problem
« on: March 15, 2020, 04:36:57 PM »
Commands work, but it happens often. It seems like if I don't get it resolved in a couple of days, mysql goes wild, and I have problem logging into CWP, while websites are down (WP: Error connecting to database).

Is there a way to prevent this?

3
CentOS 7 Problems / Firewall problem
« on: March 14, 2020, 06:16:01 PM »
Every now and then websites can't connect to DB, and I can't even get CWP login screen. Bunch of lines with php and mysql errors pop up. When I manage to get inside CWP I find Firewall off, and can't turn it on.

Dashbord says that Firewall is disabled, but when I try to Enable Firewall, message says csd and lfd are not disabled!
What's going on here?


4
CentOS 7 Problems / Re: Can't login to CWP
« on: February 19, 2020, 05:01:09 AM »
Sure. No firewall. There was a problem with a new Cloudflare SSL certificate. It was uploaded on the server, but wasn't seen for days and main website reported back error 526. I wanted to try to troubleshoot it and I probably did something very wrong late at night.

I had a backup from three days ago, so not much would have been lost. Maybe 3h of work. I lost 3x more time trying to find out what went wrong :)

5
CentOS 7 Problems / Re: Can't login to CWP
« on: February 19, 2020, 01:40:57 AM »
I managed to mysqldump the database.

As for the last suggestion, it didn't help.
Just for fun tried removing CSF, reinstalling firewalld, opening ports manually (although cmd propmts back with 'success' message, they still stay closed), reverting back to CSF. I'm deleting this server.

Thanks for the help, rcschaff.

6
CentOS 7 Problems / Re: Can't login to CWP
« on: February 18, 2020, 05:45:58 PM »
Those ports were already present in /etc/csf/csf.conf :

Code: [Select]

# Allow incoming TCP ports
TCP_IN = "20,21,2278,25,53,80,110,143,443,465,587,993,995,2030,2031,2082,2083,2086,2087,2095,2096"

# Allow outgoing TCP ports
TCP_OUT = "20,21,25,53,80,110,113,443,2030,2031,2082,2083,2086,2087,2095,2096,587,993,995"


# Allow incoming IPv6 TCP ports
TCP6_IN = "20,21,22,25,53,80,110,143,443,465,587,993,995,2030,2031,2082,2083,2086,2087,2095,2096"

# Allow outgoing IPv6 TCP ports
TCP6_OUT = "20,21,22,25,53,80,110,113,443,2030,2031,2082,2083,2086,2087,2095,2096,587,993,995"

Can't do csf -r, it gives me a bunch of nonsense, ending with:
Country Code Lookups setting MM_LICENSE_KEY must be set in /etc/csf/csf.conf to continue using the MaxMind databases

Opened an account at MaxMind, and generated licenseKey, but can't do much with it. Can't find instructions to upgrade. They just say to download some permalinks (which I did) and to copy them in the modal window (for which I have no idea what it is). Current version is 2.5.0
https://dev.maxmind.com/geoip/geoipupdate/

Code: [Select]
geoipupdate -v
geoipupdate -V

Ok, at least I've found the password on /root/.my.cnf




7
CentOS 7 Problems / Can't login to CWP
« on: February 18, 2020, 07:28:16 AM »
It seems something is messed up, ports 2030, 2031, 2078, 2076 are closed and I don't know hot to open them.
I think all firewalls are closed.

SFTP works over 2278 and I can download public_html.
I need the databases, but I don't know users or passwords on MariaDB.

This is a salvage operation, the server will be rebuilt, so no need to worry about the safety.

Pages: [1]