Topics

1

CentOS-WebPanel Bugs / Filemanager is broken again!

« on: April 23, 2021, 05:22:51 PM »

The CWP filemanager GUI is broken again.

https://pasteboard.co/JYGL17N.png

Tried running sh /scripts/update_cwp but no luck. Is this only me or everyone else is having same issue?

2

CentOS 7 Problems / mysqld: Can't lock aria control file

« on: May 29, 2020, 01:29:36 PM »

Hi,

I upgraded MariaDB from 10.1 to 10.3 following the instructions here - https://www.mysterydata.com/update-upgrade-to-mariadb-10-3-on-vestacp-cwp-centos-7/

After upgrading the mysql server is working perfectly without issues but when I'm logged into CWP GUI as root I do see MySQL server is marked as stopped. Even if I try starting/restarting mariadb it doesn't start.

Here's the output from the terminal.

Code: [Select]

[root@server1 ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.3.23 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: inactive (dead)
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
[root@server1 ~]#

After restarting mariadb I do see the following -

Code: [Select]

May 29 12:29:41 server1.domain.com systemd[1]: Starting MariaDB 10.3.23 database server...
May 29 12:29:42 server1.domain.com mysqld[1950]: 2020-05-29 12:29:42 0 [Note] /usr/sbin/mysqld (mysqld 10.3.23-MariaDB) starting as process 1950 ...
May 29 12:29:42 server1.domain.com mysqld[1950]: 2020-05-29 12:29:42 0 [Warning] Could not increase number of max_open_files to more than 16364 (request: 32183)
May 29 12:29:42 server1.domain.com mysqld[1950]: 2020-05-29 12:29:42 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds


May 29 12:07:06 server1.domain.com mysqld[1892]: 2020-05-29 12:07:06 0 [Note] InnoDB: 10.3.23 started; log sequence number 6504894; transaction id 4175
May 29 12:07:06 server1.domain.com mysqld[1892]: 2020-05-29 12:07:06 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
May 29 12:07:06 server1.domain.com mysqld[1892]: 2020-05-29 12:07:06 0 [Note] InnoDB: Buffer pool(s) load completed at 200529 12:07:06
May 29 12:07:06 server1.domain.com mysqld[1892]: 2020-05-29 12:07:06 0 [Note] Plugin 'FEEDBACK' is disabled.
May 29 12:07:06 server1.domain.com mysqld[1892]: 2020-05-29 12:07:06 0 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with...ria-tmp-tables
May 29 12:07:06 server1.domain.com mysqld[1892]: 2020-05-29 12:07:06 0 [ERROR] Aborting
May 29 12:07:08 server1.domain.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
May 29 12:07:08 server1.domain.com systemd[1]: Failed to start MariaDB 10.3.23 database server.
May 29 12:07:08 server1.domain.com systemd[1]: Unit mariadb.service entered failed state.
May 29 12:07:08 server1.domain.com systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.


May 29 12:31:00 server1.domain.com mysqld[1950]: 2020-05-29 12:31:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
May 29 12:31:01 server1.domain.com mysqld[1950]: 2020-05-29 12:31:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
May 29 12:31:01 server1.domain.com mysqld[1950]: 2020-05-29 12:31:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
May 29 12:31:02 server1.domain.com mysqld[1950]: 2020-05-29 12:31:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
May 29 12:31:02 server1.domain.com mysqld[1950]: 2020-05-29 12:31:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
May 29 12:31:03 server1.domain.com mysqld[1950]: 2020-05-29 12:31:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
May 29 12:31:03 server1.domain.com mysqld[1950]: 2020-05-29 12:31:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
May 29 12:31:04 server1.domain.com mysqld[1950]: 2020-05-29 12:31:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11



I'm also seeing multiple mysqld process is running.

Code: [Select]

[root@server1 ~]# ps aux | grep mysqld
root      1244  0.0  0.0 115540  1708 ?        S    12:04   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server1.domain.com.pid
mysql     1407  0.1  4.6 1309456 87888 ?       Sl   12:04   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server1.domain.com.err --pid-file=/var/lib/mysql/server1.domain.com.pid
mysql     1892  0.1  2.7 652428 51596 ?        Ssl  12:05   0:00 /usr/sbin/mysqld
root      1992  0.0  0.0 112780   732 pts/0    S+   12:06   0:00 grep --color=auto mysqld


So I stopped mysql and then could successfully start mariadb but the same issue continues everytime I reboot. I tried deleting aria_log_control manually which didn't fix this. Can anyone please tell me why this is happening and is there something I can do to fix this? Any suggestion would be highly appreciated. Thanks for reading.

3

CentOS-WebPanel GUI / Deleting old backups automatically

« on: May 17, 2020, 04:37:21 PM »

Hi,

I enabled "newbackup" around a month ago and choose backups to generate everyday. The backups are generating everyday as expected but as I'm seeing the old backups don't get deleted automatically. I just want to keep only one copy of every weekday's backup. Is there something I'm missing on the backup settings? I know I can crate cron to delete backup files older than X days but I would like to know if there's anything I can do from GUI. Any suggestion will be highly appreciated. Thanks.

Code: [Select]

[root@server1 newbackup]# tree
.
`-- full
    |-- daily
    |   |-- Friday
    |   |   |-- 2020-04-17
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-01
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-08
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   `-- 2020-05-15
    |   |       `-- accounts
    |   |           `-- wappyco.tar.gz
    |   |-- Monday
    |   |   |-- 2020-04-20
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-04
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   `-- 2020-05-11
    |   |       `-- accounts
    |   |           `-- wappyco.tar.gz
    |   |-- Saturday
    |   |   |-- 2020-04-18
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-02
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-09
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   `-- 2020-05-16
    |   |       `-- accounts
    |   |           `-- wappyco.tar.gz
    |   |-- Sunday
    |   |   |-- 2020-04-19
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-03
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   `-- 2020-05-10
    |   |       `-- accounts
    |   |           `-- wappyco.tar.gz
    |   |-- Thursday
    |   |   |-- 2020-04-16
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-04-23
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-04-30
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-07
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   `-- 2020-05-14
    |   |       `-- accounts
    |   |           `-- wappyco.tar.gz
    |   |-- Tuesday
    |   |   |-- 2020-04-21
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   |-- 2020-05-05
    |   |   |   `-- accounts
    |   |   |       `-- wappyco.tar.gz
    |   |   `-- 2020-05-12
    |   |       `-- accounts
    |   |           `-- wappyco.tar.gz
    |   `-- Wednesday
    |       |-- 2020-04-22
    |       |   `-- accounts
    |       |       `-- wappyco.tar.gz
    |       |-- 2020-04-29
    |       |   `-- accounts
    |       |       `-- wappyco.tar.gz
    |       |-- 2020-05-06
    |       |   `-- accounts
    |       |       `-- wappyco.tar.gz
    |       `-- 2020-05-13
    |           `-- accounts
    |               `-- wappyco.tar.gz
    `-- manual
        `-- accounts
            `-- wappyco.tar.gz

63 directories, 27 files
[root@server1 newbackup]#


4

CentOS 6 Problems / Nginx force download and custom error pages

« on: September 23, 2019, 07:26:19 PM »

Hello,

I have a couple of VPS with CWP installed and all of them are configured to use Nginx & Apache as WebServer. I recently had to rebuild the WebServer of one VPS as CWP was forcing me to do but since then Nginx force download for specific extensions aren't working as well as custom error pages. I have checked the Nginx version of the server where these two are not working and its' nginx/1.16.1. But they are working fine on CWP installation with nginx/1.14.0. I used the following configuration on nginx vhosts -

location ~* (.*\.mp4) {
types { application/octet-stream .mp4; }
default_type application/octet-stream;
}


error_page 404 403 /404.shtml;
        location = /404.shtml {
        root /path/to/directory;
                internal;
        }

Above configuration is working fine on nginx/1.14.0 but doesn't seem to be working on nginx/1.16.1.

[root@server1 ~]# nginx -v
nginx version: nginx/1.16.1
[root@server1 ~]# grep version /usr/local/cwpsrv/htdocs/resources/admin/include/version.php| awk '{print $NF}'| tr -d '"|;'
0.9.8.697
[root@server1 ~]#

Can anyone please assist me to configure Nginx force download and custom error pages on nginx/1.16.1 ?

5

Apache / Can't increase Apache MaxClients

« on: October 21, 2017, 08:59:19 PM »

Hello,

I have been trying to increase Apache MaxClients value from default 256 to higher one and followed these instructions - http://forum.centos-webpanel.com/apache/apache-maxclient-for-prefork-mpm/ but still no luck.

As per suggestion I have edited /usr/local/apache/conf/httpd.conf to include following

Code: [Select]

# Server-pool management (MPM specific)
Include conf/extra/httpd-mpm.conf

Then added mpm_prefork_module to /usr/local/apache/conf/extra/httpd-mpm.conf and restarted Apache but it's still not accepting more than 256 connections. Can anyone please help me out?

Code: [Select]

<IfModule mpm_prefork_module>
    StartServers          5
    MinSpareServers       5
    MaxSpareServers      10
    ServerLimit         5000
    MaxClients          5000
    MaxRequestsPerChild   0
</IfModule>