Show Posts

Profile Info
- Summary
- Show Stats
- 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 - amlanrd

Pages: [1]

Installation / Recommended CentOS variant for new CWP installations

« on: July 26, 2021, 04:31:37 PM »

Hi,

I'm getting a new VPS. So I just wanted to know if CentOS 7 is still the recommended release for CWP?

Or, can I just install CWP on CentOS 8 Stream?

CentOS-WebPanel Bugs / Re: Mysqli connection refused for root user in Cent OS

« on: June 17, 2021, 05:22:25 PM »

I have fixed the postfix issue. And for FTP issue, I have reinstalled pure-ftpd. The FTP service is now started. But in the FTP status I noticed this line:

Code: [Select]

Jun 17 22:48:10 vmi426849.cubinix.com systemd[1]: pure-ftpd.service: Can't open PID file /var/run/pure-ftpd.pid (yet?) after start: No such file or directory

Please help!

CentOS-WebPanel Bugs / Re: Mysqli connection refused for root user in Cent OS

« on: June 17, 2021, 04:02:05 PM »

Hi,

I tried something else and it fixed almost 90% of the issue.

1. I have taken backup of the database folders from /var/lib/mysql/
2. Removed MariaDB and the directories.
3. Reinstalled the MariaDB.
4. Copied the backed up database folders to /var/lib/mysql/
5. Granted permissions to the folder.
6. Reset myswl password.

Now I can login to my CWP. But still I'm getting the following error message in the header area:

Code: [Select]

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Also, the FTP Server showing failed in the CWP Dashboard. If I try to start, it shows:

Code: [Select]

Failed to start pure-ftpd.service: Unit pure-ftpd.service not found.

CentOS-WebPanel Bugs / Re: Mysqli connection refused for root user in Cent OS

« on: June 17, 2021, 08:57:47 AM »

Syntax error after 3rd step:

Code: [Select]

[root@vmi426849 ~]# killall mysqld
[root@vmi426849 ~]# mysqld_safe --skip-grant-tables
210617 14:25:06 mysqld_safe Logging to '/var/lib/mysql/vmi426849.cubinix.com.err'.
210617 14:25:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@vmi426849 ~]# update user set Password=PASSWORD('5d89TF5Ug3N06qg') where user='root';
-bash: syntax error near unexpected token `('
[root@vmi426849 ~]#

CentOS-WebPanel Bugs / Re: Mysqli connection refused for root user in Cent OS

« on: June 16, 2021, 07:59:58 PM »

Getting the same error while updating cwp too:

Code: [Select]

[root@vmi426849 ~]# sh /usr/local/cwpsrv/htdocs/resources/scripts/update_cwp


====================================================
============= CentOS Web Panel Cron ================
====================================================


###########################
Firewall Flush Daily Blocks
###########################


######################
Update Server Packages
######################
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
PHP Warning:  mysqli_select_db() expects parameter 1 to be mysqli, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
[root@vmi426849 ~]#

CentOS-WebPanel Bugs / Re: Mysqli connection refused for root user in Cent OS

« on: June 16, 2021, 06:25:18 PM »

I got you, but the files doesn't exist. I only have the last file i.e. cwp_client_login.log

Code: [Select]

2021-06-16 21:08:38 root Successful Login from: 59.94.72.224 on: https://localhost:2031/login/index.php
2021-06-16 21:15:17 root Successful Login from: 59.94.72.224 on: https://localhost:2031/login/index.php
2021-06-16 21:19:07 root Successful Login from: 59.94.72.224 on: https://localhost:2087/login/index.php

CentOS-WebPanel Bugs / Re: Mysqli connection refused for root user in Cent OS

« on: June 16, 2021, 09:48:55 AM »

such files not available in the mentioned directories.

CentOS-WebPanel Bugs / Mysqli connection refused for root user in Cent OS

« on: June 14, 2021, 08:35:04 PM »

Suddenly I got this error while trying to login to the CWP Control panel.

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:

I have tried resetting the root password too. Also I have checked and confirm that the root password is same in both /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Someone please help.