Messages

1366

Installation / Re: unkown database root_cwp

« on: July 29, 2023, 01:49:14 AM »

An older copy is available here:

Code: [Select]

curl -O http://dl1.centos-webpanel.com/files/cwp/sql/root_cwp.sqlYou could edit the install script so as to reference this SQL source instead so as to complete the installation.

EDIT: Bing's cached copy indicates that the dl1 linked file is the same as the static.cdn version of the root_cwp.sql file. So my suggestion is a valid workaround until the devs get this sorted.

1367

Installation / Re: it asks for mysql password on first install

« on: July 28, 2023, 11:02:08 PM »

You've supplied the MySQL root user password (not the system root user)?
And as a prerequisite, you've successful run mysql_secure_installation ?

1368

Updates / Re: CWP fails update jumped 3 versions

« on: July 28, 2023, 10:54:07 PM »

mod_rewrite module is no longer installed in latest cwp

That would be putting a (metaphorical) gun to your head and pulling the trigger. Or amputating a major limb (done using that arm now). mod_rewrite is a default, essential apache module, so they would not fail to include it.

Code: [Select]

[root@srv# locate mod_rewrite
/usr/local/apache/include/mod_rewrite.h
/usr/local/apache/manual/images/mod_rewrite_fig1.gif
/usr/local/apache/manual/images/mod_rewrite_fig1.png
/usr/local/apache/manual/images/mod_rewrite_fig2.gif
/usr/local/apache/manual/images/mod_rewrite_fig2.png
/usr/local/apache/manual/mod/mod_rewrite.html
/usr/local/apache/manual/mod/mod_rewrite.html.en
/usr/local/apache/manual/mod/mod_rewrite.html.fr.utf8
/usr/local/apache/modules/mod_rewrite.so


1369

Installation / Re: unkown database root_cwp

« on: July 28, 2023, 10:49:23 PM »

You can manually create the root_cwp database if need be. But are you supplying valid SQL DB credentials to the install script?

1370

E-Mail / Re: Mail Transport Unavailable - Postfix

« on: July 28, 2023, 10:48:02 PM »

In TCP Out, add port 465

Definitely add 465 (SSL/TLS), in order to support Windows Mail, Outlook, and Mac Mail. Other MUAs (mail user agents) such as Thunderbird default to STARTTLS on standard ports (25 for SMTP, 143 for IMAP), but in order to support the widest range of clients, you should support 25, 465, and 587 (submission).

My csf.conf is as Starburst recommended, so nothing to add there. I am country code blocking CN, RU, KP, NG, and a few other "hacky" countries, but that doesn't interfere with Gmail delivery. I would second his recommendation to try rebuilding the mail server as a matter of housekeeping. Do you have any Google-specific API keys in your DNS?

1371

Information / Re: Roundcube big security issue.

« on: July 28, 2023, 10:17:10 PM »

cd /scripts
./mail_roundcube_update

Note that you don't want to do this if you've manually updated to roundcube 1.5.3 per Sandeep's instructions. The "logic" of the roundcube update script does not take into account the currently installed version and will merrily blow away a newer 1.5.x install and install 1.4.11 instead.

1372

E-Mail / Re: Mail Transport Unavailable - Postfix

« on: July 28, 2023, 12:58:23 AM »

Are you checking with Google's Postmaster Tools to gain more insight into your deliverability issues from Google's perspective? Gmail can be particularly finicky, even if you have SSL, reverse DNS and SPF/DMARC records all set up. One compromised account on one of my servers was all it took to shut down deliverability to Gmail and it took a good deal of work (and some time) to get it flowing again.

1373

Updates / Re: CWP fails update jumped 3 versions

« on: July 28, 2023, 12:54:49 AM »

Are you installing beta versions, or stable releases (2 weeks tested)? I'm on the more conservative track.

1374

CentOS 7 Problems / Re: disk space limit calculation on accounts

« on: July 28, 2023, 12:51:02 AM »

Sorry, I advertise my hosting as "No More Tiers" (a play on Johnson & Johnson's Baby Shampoo). So I don't have any disk quotas in place. I only have 2TB SSDs in play , so any hard limits are still years away for me. But the "More details" hamburger menu seems to accurately list the SQL DB and mail usage under the Accounts list.

1375

CentOS 7 Problems / Re: help with disk space usage on accounts

« on: July 28, 2023, 12:33:21 AM »

thanks for your help on this forum, you seem to be the the only one helping

I was going to say, don't forget Starburst -- his legend is cemented on this forum. Maybe I post more prolifically, but his salient, helpful posts are spot on! And although newer, Cyberspace appears to be very knowledgeable and helpful as well!

1376

Installation / Re: best practices with cwp

« on: July 27, 2023, 10:28:19 PM »

CentOS 7.9 currently
Starburst recommends AlmaLinux 8.8.
Josemnunez said the devs are hard at work on EL9 support.
So I am targeting AlmaLinux 9 for next spring deployment. Looking to ELevate my CentOS 7.9 servers to AlmaLinux 9 at that time.

But AWSmonster has the best CWP setup documentation I've seen -- better than the wiki.

1377

CentOS 7 Problems / Re: help with disk space usage on accounts

« on: July 27, 2023, 10:23:23 PM »

bugaboo, from what I understand. Sing with me now:

99 bugs in the code, you take one down, fix it around, 105 bugs in the code...

1378

CentOS 7 Problems / Re: 'gir1.2-vte+' process using cpu 100% and memory 94%

« on: July 27, 2023, 10:21:36 PM »

Is your server set to terminal only (local TTY/SSH) -- in other words, do you have the GUI disabled (as it should be for a server)?

Code: [Select]

systemctl set-default multi-user.target

1379

MySQL / Re: Excessive resource usage: mysql

« on: July 27, 2023, 10:17:52 PM »

How much memory do you have allocated on your server? I have 6GB on one VM and this is a typical htop sample:

Code: [Select]

   PID USER      PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command
 17790 mysql      20   0 1552M  431M  6804 S  0.0  7.6  0:00.06 /usr/sbin/mariadbd
  1314 mysql      20   0 1552M  431M  6804 S  0.0  7.6 23:40.57 /usr/sbin/mariadbd
 17804 mysql      20   0 1552M  431M  6804 S  0.0  7.6  0:00.06 /usr/sbin/mariadbd

1380

Updates / Re: CWP fails update jumped 3 versions

« on: July 27, 2023, 10:10:24 PM »

It's been failing to apply for me, still showing as available (with/without CSF enabled). I'll see if the update applies via cron overnight.