Messages

241

CentOS 7 Problems / Re: how to check background processes for sudden high read throughput

« on: October 29, 2024, 12:02:21 AM »

Also, I found "top" shows high "sy" when the average load is high. "sy" indicates how much cpu is consumed by "system". High "sy" could indicate problems with the kernel, some driver or node your VPS is hosted on.

242

MySQL / Re: MySQL Manager in CWP not working

« on: October 28, 2024, 11:18:32 PM »

Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

Run:

Code: [Select]

ls -ld /var/lib/mysql
ls -l /var/lib/mysql

in shell as root and show output.

Anyway, it doesn't look like CWP problem.

Moreover, to update the database of MariaDB 10.6+ the following command must be executed:

Code: [Select]

mariadb-upgrade
Run it and look for result.

243

MySQL / Re: MySQL Manager in CWP not working

« on: October 28, 2024, 05:57:43 PM »

PHP outrput looks good. Try to reset the root password anyway and then update the password in:

/root/.my.cnf
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

Additionally, make sure the login and password inside the file /root/.my.cnf is quoted by single quotas like:

Code: [Select]

user='mylogin'
password='mypassword'

because some chars (!@#$%^) could be recognized as special chars.

244

CentOS 7 Problems / Re: how to check background processes for sudden high read throughput

« on: October 28, 2024, 05:52:09 PM »

To monitor disk I/O, try to use "iotop":

Code: [Select]

yum -y install iotop
Additionally, try to find which ip generates high network traffic using "iftop".

Code: [Select]

yum -y install iftop

245

DNS / Re: help with name servers

« on: October 28, 2024, 05:45:26 PM »

The simplest way:

1. Add one or more extra IPs to your dedicated server/vps. You have to assign as many IPs to the server as many nameservers you want to use.

2. Register the nameservers at your registrar to the main and extra ips of your server.

3. Add the  corresponding DNS A records for each nameserver at the DNS cluster used by the domain associated with your nameservers.

In this case you could provide your namesers for your users and you or your users won't have to manage the DNS records of each domain/subdomain you create on your server/vps.

However, this case has a disadvantage: If your server or bind (DNS service) running on your server is down then it will make all domain names including email service even if the domain uses 3rd party MX server is down too.

If you decide to use 3rd party DNS service like CloudFlare then you or your user will have to create DNS records (A,CNAME, MX, etc) for the domain/subdomain at CloudFlare every time when a new domain/subdomain is created on your server. To automate this process you can write scripts to add/remove/update DNS records at the external DNS service using hooks:
https://wiki.centos-webpanel.com/action-hooks

246

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 27, 2024, 10:13:50 PM »

There are a lot of errors "can't resolve". Make sure the DNS resolver on your VPS/Server is operating fine.

247

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 27, 2024, 02:38:32 PM »

It could cause high disk i/o usage:

Code: [Select]

2024-10-27 13:59:18 4465 [Warning] InnoDB: Could not free any blocks in the buffer pool! 8064 blocks are in use and 0 free. Consider increasing innodb_buffer_pool_size.
Consider to optimize MySQL/MariaDB performance:
https://mariadb.com/kb/en/optimization-and-tuning/

248

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 27, 2024, 01:52:28 PM »

Have you checked logs ?

249

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 27, 2024, 09:56:46 AM »

If logging is disabled then do following:

1. Open the file:

Code: [Select]

/etc/my.cnf.d/server.cnf2. Add the lines:

Code: [Select]

general_log = On
general_log_file = /var/log/mysqld.log
log_error = /var/log/mysqld_error.log
under [server]

3. Restart MySQL/MariaDB.

250

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 27, 2024, 08:32:21 AM »

Check logs of the SQL service, if there is nothing then try to optimize MySQL (enable caching if disabled).

251

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 27, 2024, 01:07:13 AM »

It looks like high cpu usage is caused by high i/o wait. Does your server use hard disks not  ssd/nvme disks ?

252

CentOS 7 Problems / Re: CPU high usage after mariadb upgrade 10.11

« on: October 26, 2024, 09:31:31 PM »

I just recommend you to start from the investigation of MariaDB log file, other system logs, if there is nothing then check SQL queries "show processlist;", check RAM usage, etc.

253

Postfix / Re: connection refused to a domain on another virtual machine

« on: October 25, 2024, 01:05:23 PM »

Did you check what happens when CWP rebuilds the mail config ? Does it not remove the extra records (transport policy) added by hand ?

Just for information if someone decides to apply the same solution.

Thank you.

254

MySQL / Re: MySQL Manager in CWP not working

« on: October 24, 2024, 09:41:47 PM »

Show output of:

Code: [Select]

php -v
php -m
executed on your server by root.

255

MySQL / Re: MySQL Manager in CWP not working

« on: October 24, 2024, 07:11:54 AM »

Are you able to connect to MySQL/MariaDB from shell using the login details from the files listed below ?

Code: [Select]

/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf