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.
Pages: [1]
1
CentOS 7 Problems / Cron freshclam-sleep job shows DB errors
« on: February 15, 2021, 08:31:44 AM »
Every few hours I get error message in cron logs:
I'm not using ClamAV and service is disabled. Also I don't see such cron task in the list.
What should I do to disable it?
Code: [Select]
/usr/share/clamav/freshclam-sleep
ERROR: Database test FAILED.
ERROR: Unexpected error when attempting to update database: daily
ERROR: Database update process failed: Test failed (8)
ERROR: Update failed.I'm not using ClamAV and service is disabled. Also I don't see such cron task in the list.
What should I do to disable it?
2
CentOS-WebPanel Bugs / CWP-CWP migration fails: Error API TOKEN
« on: January 10, 2021, 09:55:35 PM »
Im using latest CWP version: 0.9.8.1031 on source (CentOS 7.
and destination servers (CentOS 7.9)
I can ssh from dest to source, CSF is disabled on both
SSH and port 2304 opened on both, password and key auth allowed on both.
I have created API access key on source and trying to connect from dest to source following https://docs.control-webpanel.com/docs/admin-guide/user-accounts/cwp-to-cwp-migration and when I hit "Test and Save" I always get:
"Error API TOKEN
There is a problem with your TOKEN API"
In the logs:
So it connects successfully and drops.
I know the same issue was reported previously by other users and was gone with the latest build but I'm already using the latest build https://forum.centos-webpanel.com/index.php?topic=9483.msg33171#msg33171
Please help to fix this.
and destination servers (CentOS 7.9)I can ssh from dest to source, CSF is disabled on both
SSH and port 2304 opened on both, password and key auth allowed on both.
I have created API access key on source and trying to connect from dest to source following https://docs.control-webpanel.com/docs/admin-guide/user-accounts/cwp-to-cwp-migration and when I hit "Test and Save" I always get:
"Error API TOKEN
There is a problem with your TOKEN API"
In the logs:
Code: [Select]
2021-01-10 21:51:27 entre 1
2021-01-10 21:51:28 export SSHPASS='***'; /usr/bin/sshpass -e /usr/bin/ssh -p 223 -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o LogLevel=quiet root@185.235.130.135
2021-01-10 21:51:28 true
2021-01-10 21:51:28 entre 2
2021-01-10 21:51:29 /usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: WARNING: All keys were skipped because they already exist on the remote system.
(if you think this is a mistake, you may want to use -f option)
--> export SSHPASS=**********;/usr/bin/sshpass -e ssh-copy-id "-p 223" root@185.235.130.135 -o StrictHostKeyChecking=no 2>&1
2021-01-10 21:51:30 true
--> /usr/bin/ssh -p 223 -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o LogLevel=quiet root@185.235.130.135 test -d /usr/local/cwp/ && echo 'true' || echo 'false' 2>&1
2021-01-10 21:51:30 entre 3
2021-01-10 21:51:30 entre 4So it connects successfully and drops.
I know the same issue was reported previously by other users and was gone with the latest build but I'm already using the latest build https://forum.centos-webpanel.com/index.php?topic=9483.msg33171#msg33171
Please help to fix this.
3
CentOS-WebPanel Bugs / PHP Version Switcher v2 bug in config files
« on: December 23, 2020, 08:02:40 AM »
When going to the section "PHP Version Switcher v2" it shows errors:
Warning: parse_ini_file(/usr/local/cwpsrv/htdocs/resources/conf/el/php_switcher/versions.ini): failed to open stream: No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
Warning: array_keys() expects parameter 1 to be array, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
Warning: rsort() expects parameter 1 to be array, null given in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
Warning: Invalid argument supplied for foreach() in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
This is expected because there is no /usr/local/cwpsrv/htdocs/resources/conf/el/ folder exist.
I checked on 2 servers installed at different times: there are only
/usr/local/cwpsrv/htdocs/resources/conf/el7/ and /usr/local/cwpsrv/htdocs/resources/conf/el8/
folders exist.
This is a bug in the CWP code
Warning: parse_ini_file(/usr/local/cwpsrv/htdocs/resources/conf/el/php_switcher/versions.ini): failed to open stream: No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
Warning: array_keys() expects parameter 1 to be array, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
Warning: rsort() expects parameter 1 to be array, null given in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
Warning: Invalid argument supplied for foreach() in /usr/local/cwpsrv/htdocs/resources/admin/modules/php_switch_v2.php on line 0
This is expected because there is no /usr/local/cwpsrv/htdocs/resources/conf/el/ folder exist.
I checked on 2 servers installed at different times: there are only
/usr/local/cwpsrv/htdocs/resources/conf/el7/ and /usr/local/cwpsrv/htdocs/resources/conf/el8/
folders exist.
This is a bug in the CWP code
4
CentOS-WebPanel Bugs / Sorting in FileManager v2
« on: December 14, 2020, 07:44:59 PM »
When doing sort by date of size it sorts only by the first digit regardless of byte/KB/MB, year/month.
It's extremely not comfortable to use.
It's extremely not comfortable to use.
5
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/
6
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.
7
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?
8
Softaculous / How to enable Fantsctico F3 panel
« on: July 24, 2020, 04:51:22 PM »
Hi, in the CWP admin panel I don't see any tools to manage Fantsctico F3, but in the user panel I see it's available in the Script Installers section.
When clicking on it it shows error:
When clicking on it it shows error:
Quote
You are not authorized to use this module (fantastico_f3)- Contact Server AdminCould you please let me know how to enable it?
9
Softaculous / Trial Premium licence doesn't switch to free
« on: May 28, 2020, 08:07:40 AM »
It was told that after 1 month of Premium trial Softaculous automatically switch to Free license.
Instead it shows me error message:
License Inactive
Your license (###-###) is not active or it has expired. If your license has expired, please renew it to continue using this Software.
If has Refresh License link but nothing happens when I click on it.
How to switch to Free license?
Instead it shows me error message:
License Inactive
Your license (###-###) is not active or it has expired. If your license has expired, please renew it to continue using this Software.
If has Refresh License link but nothing happens when I click on it.
How to switch to Free license?
10
CentOS 7 Problems / CWP 7 can't login to user panel
« on: April 23, 2020, 06:03:01 PM »
Latest updated CWP 7.
I have 1 user created and one domain.
User has correct password and I can login with it over FTP.
When trying to login to user panel https://hostname:2083/login/?acc=logon
after clicking login button it stays showing "Please wait!" on green button and nothing happens.
I have tried assigning different packages to the user - didn't help.
Conteant of /home/user/.conf
cwp.ini
Also it's interesting that when I click edit user I can't see any settings already assigned and visible in "List users" table. Also I can't select from package, as drop-down is empty here, but I can assign package in the previous table but seem this doesn't apply.
Looks like CWP bug!
Please help!
I have 1 user created and one domain.
User has correct password and I can login with it over FTP.
When trying to login to user panel https://hostname:2083/login/?acc=logon
after clicking login button it stays showing "Please wait!" on green button and nothing happens.
I have tried assigning different packages to the user - didn't help.
Conteant of /home/user/.conf
cwp.ini
Code: [Select]
LANG=en
THEME=original
EMAIL=Also it's interesting that when I click edit user I can't see any settings already assigned and visible in "List users" table. Also I can't select from package, as drop-down is empty here, but I can assign package in the previous table but seem this doesn't apply.
Looks like CWP bug!
Please help!
11
CentOS 7 Problems / CWP 7 admin panel doesn't show up properly
« on: April 17, 2020, 12:33:53 PM »
Newly installed CWP 7 latest on CentOS 7.6
Nginx+Apache config
When login in to admin panel is doesn't show dashboard and in the left menu the items to not have expand/collapse arrows.
The only workaround to use the menu is to navigate to Notifications and Alerts after which arrows appear.
Dashboard doesn't show up at all.
Please help to fix it.
Nginx+Apache config
When login in to admin panel is doesn't show dashboard and in the left menu the items to not have expand/collapse arrows.
The only workaround to use the menu is to navigate to Notifications and Alerts after which arrows appear.
Dashboard doesn't show up at all.
Please help to fix it.
12
CentOS 7 Problems / CWP 7 generates PHP errors
« on: April 17, 2020, 10:20:37 AM »
On many pages on CWP admin panel I see multiple similar errors
the same I see in /usr/local/cwpsrv/logs/error_log
Some relate to WebServers_conf_editor.php
Other relate to ajax_ssl_certificate.php
Others relate to array multiple errors when working with SQL
All of them relate to the issues in CWP code.
At least array issue was noted many times in the Internet and could be resolved by modifying the code.
but here php code pages are base64 encoded and I can't modify them.
What can we done?
the same I see in /usr/local/cwpsrv/logs/error_log
Some relate to WebServers_conf_editor.php
Code: [Select]
2020/04/17 11:02:35 [error] 31259#0: *459 FastCGI sent in stderr: "PHP message: PHP Warning: Invalid argument supplied for foreach() in /usr/local/cwpsrv/htdocs/resources/admin/modules/WebServers_conf_editor.php on line 0" while reading upstream, client: 93.92.199.232, server: localhost, request: "GET /cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=WebServers_conf_editor HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "ipnets.ru:2031", referrer: "https://ipnets.ru:2031/cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=httpd_fullstatus"
Other relate to ajax_ssl_certificate.php
Code: [Select]
2020/04/17 11:17:53 [error] 31260#0: *975 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined variable: keeke in /usr/local/cwpsrv/htdocs/resources/admin/addons/ajax/ajax_ssl_certificate.php on line 0
PHP message: PHP Warning: in_array() expects parameter 2 to be array, string given in /usr/local/cwpsrv/htdocs/resources/admin/addons/ajax/ajax_ssl_certificate.php on line 0" while reading response header from upstream, client: 93.92.199.232, server: localhost, request: "POST /cwp_33098c336383410db4086d05640a0e26/admin/loader_ajax.php?ajax=ssl_certificate&acc=config HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "ipnets.ru:2031", referrer: "https://ipnets.ru:2031/cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=ssl_certificate"Others relate to array multiple errors when working with SQL
Code: [Select]
2020/04/17 11:34:03 [error] 31260#0: *1618 FastCGI sent in stderr: "PHP message: 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 message: 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 message: 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" while reading upstream, client: 93.92.199.232, server: localhost, request: "POST /cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=list_subdomains HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "ipnets.ru:2031", referrer: "https://ipnets.ru:2031/cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=list_subdomains"
2020/04/17 11:05:04 [error] 31260#0: *551 FastCGI sent in stderr: "PHP message: PHP Warning: Error while sending QUERY packet. PID=5745 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: 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 message: 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 message: 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
PHP message: 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 message: 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 message: PHP Warning: mysqli_fre" while reading upstream, client: 93.92.199.232, server: localhost, request: "POST /cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=add_subdomain HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "ipnets.ru:2031", referrer: "https://ipnets.ru:2031/cwp_33098c336383410db4086d05640a0e26/admin/index.php?module=add_subdomain"
All of them relate to the issues in CWP code.
At least array issue was noted many times in the Internet and could be resolved by modifying the code.
but here php code pages are base64 encoded and I can't modify them.
What can we done?
Pages: [1]
