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.
541
Nginx / Re: Nginx Ultimate Bad Bot Blocker for CWP and CWP PRO !
« on: May 05, 2024, 01:58:42 PM »
That's one drawback with CWP -- precious little advance communication or a roadmap for features. Not unless josemnunez pops in and gives a word. That's the only way we knew EL9 support was in beta!
542
PHP / Re: Memcached php 8x
« on: May 05, 2024, 03:43:03 AM »
Which version of php 8 specifically? 8.0, 8.1, 8.2, 8.3?
543
Information / Re: question about centos
« on: May 05, 2024, 03:41:40 AM »
CentOS 7 just went EOL (end of life) in April of 2024. There may be a couple more critical security updates, and paid extended support is available. But there's no need to keep things on life support. An upgrade path exists to transition over to AlmaLinux 8, using their ELevate tool. So that is the path forward to keep your CWP server secure and up to date (and then when CWP is stable on EL9 releases, you can update to AlmaLinux 9).
544
E-Mail / Re: Roundcube: Connection to Storage Server Failed
« on: May 05, 2024, 03:38:24 AM »
Do your logs give you any clues?
/usr/local/cwpsrv/var/services/roundcube/logs/
especially /usr/local/cwpsrv/var/services/roundcube/logs/errors.log
Usually storage server errors with Roundcube indicate an IMAP connection issue. Is dovecot functioning normally? So also check out
/usr/local/cwpsrv/var/services/roundcube/logs/
especially /usr/local/cwpsrv/var/services/roundcube/logs/errors.log
Code: [Select]
grep storage /usr/local/cwpsrv/var/services/roundcube/logs/errors.logUsually storage server errors with Roundcube indicate an IMAP connection issue. Is dovecot functioning normally? So also check out
Code: [Select]
/var/log/dovecot-debug.log
/var/log/dovecot-info.log
/var/log/dovecot.log
545
CentOS 8 Problems / Re: mysql get 300% cpu
« on: May 04, 2024, 02:05:33 AM »
Of course, I meant / etc / my.cnf -- I was on the run for that last message.
I'm a belt & suspenders kind of person, so I use both:
https://launchpad.net/mysql-tuning-primer (shell)
https://github.com/major/MySQLTuner-perl (perl)
There's also phpMyAdmin > Status > Advisor for some recommendations.
If you want the full Swiss Army knife, get mysqlreport:
http://hackmysql.com/mysqlreport
and mytop:
http://jeremy.zawodny.com/mysql/mytop/
As for Invision Power Board, this seemed salient:
https://dba.stackexchange.com/questions/91428/invision-power-board-3-4-6-mysql-locks-during-query-with-pending-updates
Check the accepted answer -- make sure you are ussing InnoDB and not MyISAM for the table engine. Also note that it may be counter-intuitive, but having too large a tmp table size may reduce performance.
Also, why does your server not have swap? Seems odd to me...
I'm a belt & suspenders kind of person, so I use both:
https://launchpad.net/mysql-tuning-primer (shell)
https://github.com/major/MySQLTuner-perl (perl)
There's also phpMyAdmin > Status > Advisor for some recommendations.
If you want the full Swiss Army knife, get mysqlreport:
http://hackmysql.com/mysqlreport
and mytop:
http://jeremy.zawodny.com/mysql/mytop/
As for Invision Power Board, this seemed salient:
https://dba.stackexchange.com/questions/91428/invision-power-board-3-4-6-mysql-locks-during-query-with-pending-updates
Check the accepted answer -- make sure you are ussing InnoDB and not MyISAM for the table engine. Also note that it may be counter-intuitive, but having too large a tmp table size may reduce performance.
Also, why does your server not have swap? Seems odd to me...
546
CentOS 8 Problems / Re: mysql get 300% cpu
« on: May 03, 2024, 07:27:30 PM »
You have to edit your / etc / mysql.conf with your performance tuning options. I would definitely recommend the perl tuning script -- it gives very good suggestions as to what the tuned options should be on your system.
547
E-Mail / Re: Backup migration between Cpanel and CWP
« on: May 02, 2024, 09:27:57 PM »
At this point, you may be best off moving the cPanel backup (.tar.gz) file to the CWP server. Expand it, then you can manually move the mailbox contents into the corresponding /var/vmail domain folders.
548
CentOS 8 Problems / Re: mysql get 300% cpu
« on: May 02, 2024, 09:22:52 PM »
Does your forum software recommend any MySQL tuning options? I know various CMS platforms have specific recommendations (e.g. Drupal needs a much larger max_allowed_packet). Have you looked at general purpose MySQL tuning scripts?
Code: [Select]
https://github.com/major/MySQLTuner-perl
549
CentOS 5 Problems / Re: ftp and webmail ip address
« on: May 02, 2024, 01:56:49 AM »
If you're behind a router with your server, look into hairpin NAT. But unless you're just tinkering with a home lab server, I would suggest getting a dedicated static IP (internet routable) for your CWP server.
550
PHP Selector / Re: phpfm not work
« on: May 02, 2024, 01:54:53 AM »
If you added PHP-FPM 8.3, you have to move forward the user config files from 8.1 or 8.2, editing their contents to reflect the proper version...
Code: [Select]
cp /opt/alt/php-fpm82/usr/etc/php-fpm.d/users/user.conf /opt/alt/php-fpm83/usr/etc/php-fpm.d/users/user.conf
nano /opt/alt/php-fpm83/usr/etc/php-fpm.d/users/user.confChange the socket and slowlog references to the new 8.3 version:Code: [Select]
[user]
listen = /opt/alt/php-fpm83/usr/var/sockets/frogstew.sock
listen.allowed_clients = 127.0.0.1
;listen.owner = "user"
listen.group = "nobody"
listen.mode = 0660
user = "user"
group = "user"
;request_slowlog_timeout = 15s
;slowlog = /opt/alt/php-fpm83/usr/var/log/php-fpm-slowlog-user.log
pm = ondemand
pm.max_children = 4
pm.max_requests = 4000
pm.process_idle_timeout = 15s
;listen.backlog = -1
;request_terminate_timeout = 0s
rlimit_files = 131072
rlimit_core = unlimited
catch_workers_output = yes
env[HOSTNAME] = $HOSTNAME
env[TMP] = /home/user/tmp
env[TMPDIR] = /home/user/tmp
env[TEMP] = /home/user/tmp
env[PATH] = /usr/local/bin:/usr/bin:/bin
551
DKIM / Re: DKIM not need to start
« on: May 02, 2024, 01:49:05 AM »
You must have DMARC, DKIM, and SPF records in place to interact with Gmail. Also start looking into ARC, because it will be the next thing to support down the road...
552
CentOS 8 Problems / Re: mysql get 300% cpu
« on: May 02, 2024, 01:47:29 AM »
How many cores? Dedicated or VPS? What is your typical load and how many user accounts do you have? Have you done any MySQL tuning? The CWP dashboard is notoriously unreliable. Have you watched htop or Netdata on your server for awhile?
553
Backup / Re: Connection test Successful FTP connection not send ftp file
« on: April 29, 2024, 06:20:10 PM »
Precious little details are being provided to be able to offer a diagnosis or solution to this problem. More details, logs, assurances of open firewall ports, etc.
555
CentOS 7 Problems / Re: Google indexing link to CWP
« on: April 25, 2024, 08:45:40 PM »
Do you actually use the "cpanel" service record? That's one I don't support for my servers; I require my clients to append :2083, which is familiar to many people coming from cPanel servers
