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.
16
SSL / Re: how to install letsencrypt for admin panel & user panel ?
« on: December 14, 2020, 07:55:04 AM »is any simple way to install letsencrypt cert with autoupdate to panel in 2020?The simplest is to redirect it in the cwp conf file to some of your domains added to the panel to have it autoupdated.
17
Updates / Re: Anacron job for updates fails to Update Server Packages
« on: December 13, 2020, 09:47:18 PM »
What is the way to contact support?
18
Updates / Re: Anacron job for updates fails to Update Server Packages
« on: December 11, 2020, 01:00:16 PM »
Anyone?
Support team, can you look at it please?
Support team, can you look at it please?
19
Postfix / Re: Having issues with mail server
« on: December 09, 2020, 08:53:40 AM »
Most probably you are blacklisted then
Check your server at https://mxtoolbox.com/blacklists.aspx
Check your server at https://mxtoolbox.com/blacklists.aspx
20
Postfix / Re: No "postfix" database, CWP7, MariaDB, Centos 7
« on: December 09, 2020, 08:52:30 AM »
No, I didn't import any data, just created tables.
The names of the tables I took from conf file - it was mentioned there which tables it queries.
Attach it for your reference.
The names of the tables I took from conf file - it was mentioned there which tables it queries.
Attach it for your reference.
21
Dovecot / Dovecot log full of MySQL server has gone away
« on: December 07, 2020, 11:24:29 AM »
Hi, my dovecot log is full of the same warnings:
I read this is related to MySQL timeouts but to adjust it?
https://mariadb.com/kb/en/transaction-timeouts/
Quote
Dec 07 12:19:41 auth-worker(4671): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:20:41 auth-worker(4671): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:23:41 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 57 secs)
Dec 07 12:24:41 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:25:05 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 24 secs)
Dec 07 12:25:05 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 141 secs)
Dec 07 12:25:41 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 32 secs)
Dec 07 12:26:41 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:27:41 auth-worker(9017): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:28:41 auth-worker(11342): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:29:41 auth-worker(11342): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:30:41 auth-worker(11342): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:31:41 auth-worker(12869): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:31:59 auth-worker(12869): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 18 secs)
Dec 07 12:31:59 auth-worker(12869): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 78 secs)
Dec 07 12:32:41 auth-worker(12869): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 42 secs)
Dec 07 12:33:41 auth-worker(12869): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:34:41 auth-worker(12869): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:35:41 auth-worker(14540): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 60 secs)
Dec 07 12:36:40 auth-worker(14540): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 59 secs)
Dec 07 12:36:57 auth-worker(14540): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 17 secs)
Dec 07 13:52:50 auth-worker(18421): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 38 secs)
Dec 07 14:07:15 auth-worker(25110): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 48 secs)
I read this is related to MySQL timeouts but to adjust it?
https://mariadb.com/kb/en/transaction-timeouts/
22
Postfix / Re: SMTP Connection timed out...
« on: December 07, 2020, 11:12:55 AM »
Yo may be probably blacklisted.
Check your ip and domain at https://mxtoolbox.com/blacklists.aspx
Check your ip and domain at https://mxtoolbox.com/blacklists.aspx
23
Postfix / Re: Dovecot failed: Permission denied
« on: December 07, 2020, 11:10:23 AM »
Check you config dovecot.conf
Find out under which user stats is running (here it's divecot/wheel):
The user who start doveadm is not a member of the group under the service stats is running. That's why when you or some service try to access stats-writer which you run under dovecot:wheel you receive this error.
If you change the service to run under group where this user is member it will have access to the stats. So some process (imap maybe) is trying to access the stats-writer and this process is running under another user and that's why you get this access denied message.
Solution:
You can allow all users to have access to stats-writer by changing the mode to 0666 (which is not good) or change the group under the stats-writer is running to "mail" (change to real group name you use) and add all services that need to have access to the stats to that group.
Actually for me the working config is:
So you better to adjust to the real group of the stats-writer.
Find out under which user stats is running (here it's divecot/wheel):
Code: [Select]
service stats {
unix_listener stats-reader {
user = dovecot
group = wheel
mode = 0660
}
unix_listener stats-writer {
user = dovecot
group = wheel
mode = 0660
}
}
Root cause:The user who start doveadm is not a member of the group under the service stats is running. That's why when you or some service try to access stats-writer which you run under dovecot:wheel you receive this error.
If you change the service to run under group where this user is member it will have access to the stats. So some process (imap maybe) is trying to access the stats-writer and this process is running under another user and that's why you get this access denied message.
Solution:
You can allow all users to have access to stats-writer by changing the mode to 0666 (which is not good) or change the group under the stats-writer is running to "mail" (change to real group name you use) and add all services that need to have access to the stats to that group.
Actually for me the working config is:
Code: [Select]
service stats {
unix_listener stats {
mode = 0662
}
}but it may not work for you as I'm using root.So you better to adjust to the real group of the stats-writer.
24
Postfix / Re: Securing POSTFIX
« on: December 07, 2020, 10:58:08 AM »
It's not secure enough in teams of spam filtering.
You need to tweak it a lot:
https://www.linuxbabe.com/mail-server/block-email-spam-postfix
You need to tweak it a lot:
https://www.linuxbabe.com/mail-server/block-email-spam-postfix
25
Postfix / Re: RBL not added to postfix main.cf
« on: December 07, 2020, 10:52:13 AM »
Mine config is:
For Spamrat you need to add:
Note of the tab in the beginning of each parameter line - this is mandatory.
Code: [Select]
# rules restrictions
smtpd_client_restrictions =
permit_mynetworks,
permit_sasl_authenticated,
reject_unauth_pipelining,
reject_unknown_address,
reject_unknown_client_hostname
smtpd_helo_restrictions =
permit_mynetworks,
permit_sasl_authenticated,
reject_non_fqdn_helo_hostname,
reject_unknown_helo_hostname
smtpd_sender_restrictions =
permit_sasl_authenticated,
permit_mynetworks,
# check_client_access hash:/etc/postfix/white_client_access,
# check_recipient_access hash:/etc/postfix/white_recipient_access,
reject_invalid_hostname,
reject_non_fqdn_hostname,
reject_non_fqdn_sender,
reject_unknown_client_hostname,
reject_unknown_reverse_client_hostname,
reject_unknown_sender_domain,
reject_unknown_hostname,
reject_unlisted_sender,
reject_rbl_client zombie.dnsbl.sorbs.net,
reject_rbl_client cbl.abuseat.org,
reject_rbl_client zen.spamhaus.org,
reject_rbl_client bl.spamcop.net,
reject_rbl_client dnsbl.sorbs.net,
reject_rbl_client spam.dnsbl.anonmails.de,
reject_rbl_client b.barracudacentral.org,
reject_rbl_client z.mailspike.net,
reject_rhsbl_sender dbl.spamhaus.org,
reject_rhsbl_sender db.wpbl.info,
reject_rhsbl_sender psbl.surriel.com,
permit
smtpd_recipient_restrictions =
permit_sasl_authenticated,
permit_mynetworks,
# check_client_access hash:/etc/postfix/access,
# check_recipient_access hash:/etc/postfix/recipient_access,
reject_unauth_destination,
reject_non_fqdn_sender,
reject_non_fqdn_recipient,
reject_unknown_recipient_domain,
reject_invalid_hostname,
reject_non_fqdn_hostname,
reject_unauth_pipelining,
reject_unlisted_recipient,
reject_multi_recipient_bounce,
reject_rbl_client zombie.dnsbl.sorbs.net,
reject_rbl_client cbl.abuseat.org,
reject_rbl_client zen.spamhaus.org,
reject_rbl_client bl.spamcop.net,
reject_rbl_client spam.dnsbl.anonmails.de,
reject_rbl_client b.barracudacentral.org,
reject_rbl_client z.mailspike.net,
reject_rbl_client dnsbl.sorbs.net,
reject_rhsbl_helo dbl.spamhaus.org,
reject_rhsbl_reverse_client dbl.spamhaus.org,
permit
For Spamrat you need to add:
Code: [Select]
reject_rbl_client dyna.spamrats.com
Note of the tab in the beginning of each parameter line - this is mandatory.
26
Postfix / Re: Email Auto Responders mysql-virtual_vacation.cf: Permission denied
« on: December 07, 2020, 10:47:42 AM »
I have the make issue, please let me know the permissions which are now set over mysql-virtual_vacation.cf ?
(For me it owner: vacation, group mail set as default)
(For me it owner: vacation, group mail set as default)
27
Postfix / Re: Having issues with mail server
« on: December 07, 2020, 10:45:07 AM »
SMTP ports are closed by default.
Just open it in the FW.
Just open it in the FW.
28
Postfix / Re: No "postfix" database, CWP7, MariaDB, Centos 7
« on: December 07, 2020, 10:42:19 AM »
I had the same issue because I was installing it to the server with MariaDB already and Db was not created.
But I have created all of the DB tables myself, assigned postfix account permissions and it worked perfectly well.
Which tables to create I just took from conf files of postfix.
But I have created all of the DB tables myself, assigned postfix account permissions and it worked perfectly well.
Which tables to create I just took from conf files of postfix.
29
Updates / Anacron job for updates fails to Update Server Packages
« on: December 06, 2020, 04:42:36 PM »
Daily in the Anacron job 'cron.daily' (/etc/cron.daily/cwp:) I have the errors in the output:
I've checked RPM packages and they seem to be healthy
This continues for a week while I didn't do any changes to the server.
Before that for 2 weeks there was anoter error in the job output which is now replaced with a new one:
and before that there was another one (continued for months):
Please help to get rid of these errors.
Code: [Select]
######################
Update Server Packages
######################
error: rpmdb: BDB0113 Thread/process 7861/140498072618816 failed: BDB1507 Thread died in Berkeley DB library
error: db5 error(-30973) from dbenv->failchk: BDB0087 DB_RUNRECOVERY: Fatal error, run database recovery
error: cannot open Packages index using db5 - (-30973)
error: cannot open Packages database in /var/lib/rpm
...
Error: rpmdb open failed
error: rpmdb: BDB0113 Thread/process 7861/140498072618816 failed: BDB1507 Thread died in Berkeley DB library
error: db5 error(-30973) from dbenv->failchk: BDB0087 DB_RUNRECOVERY: Fatal error, run database recovery
error: cannot open Packages index using db5 - (-30973)
error: cannot open Packages database in /var/lib/rpm
CRITICAL:yum.main:
I've checked RPM packages and they seem to be healthy
Code: [Select]
# /usr/lib/rpm/rpmdb_verify /var/lib/rpm/Packages
BDB5105 Verification of /var/lib/rpm/Packages succeeded.This continues for a week while I didn't do any changes to the server.
Before that for 2 weeks there was anoter error in the job output which is now replaced with a new one:
Code: [Select]
######################
Update Server Packages
######################
TERM environment variable not set.
Redirecting to /bin/systemctl restart cwpsrv.service
Redirecting to /bin/systemctl restart cwp-phpfpm.service
Redirecting to /bin/systemctl reload cwpsrv.service
Redirecting to /bin/systemctl reload cwp-phpfpm.service
PHP Warning: Error while sending QUERY packet. PID=8349 in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php(0) : eval()'d code on line 57
PHP Fatal error: Uncaught Error: Call to undefined function mysql_error() in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php(0) : eval()'d code:57
Stack trace:
#0 /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php(0): unknown()
#1 {main}
thrown in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php(0) : eval()'d code on line 57
Date which backup script is using: 2020-11-28 00:30:36and before that there was another one (continued for months):
Code: [Select]
######################
Update Server Packages
######################
Redirecting to /bin/systemctl restart cwpsrv.service
PHP Warning: Error while sending QUERY packet. PID=11462 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
Redirecting to /bin/systemctl restart httpd.service
PHP Warning: Error while sending QUERY packet. PID=11462 in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
Redirecting to /bin/systemctl reload httpd.service
Redirecting to /bin/systemctl reload nginx.service
Redirecting to /bin/systemctl reload httpd.service
Date which backup script is using: 2020-11-12 00:41:49Please help to get rid of these errors.
30
DKIM / DKIM Manager fails to connect to MySQL
« on: December 06, 2020, 04:23:00 PM »
When opening DKIM Manager section it shows multiple errors connecting to MySQL
Root account is set with password and doesn't have any other issues with the other SQL tables.
There is no bind-address set in /etc/my.cnf so I don't know if localhost if suitable for connection.
Seems it's not happy with @localhost (may be it wants "127.0.0.1" but I don't know which CWP config files to change) or for some reason root is missing some permissions over some table?
How to fix it?
Code: [Select]
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Warning: mysqli_query(): Couldn't fetch mysqli in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Notice: Trying to get property 'num_rows' of non-object in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Warning: mysqli_query(): Couldn't fetch mysqli in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Notice: Trying to get property 'num_rows' of non-object in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Warning: mysqli_query(): Couldn't fetch mysqli in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Notice: Trying to get property 'num_rows' of non-object in /usr/local/cwpsrv/htdocs/resources/admin/modules/dkim.php on line 0
Root account is set with password and doesn't have any other issues with the other SQL tables.
There is no bind-address set in /etc/my.cnf so I don't know if localhost if suitable for connection.
Seems it's not happy with @localhost (may be it wants "127.0.0.1" but I don't know which CWP config files to change) or for some reason root is missing some permissions over some table?
How to fix it?
