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.
166
How to / Re: How to disable postfix, clamav and bind server?
« on: October 31, 2021, 02:46:16 AM »
If you know they are "unneeded", why you already don't know to remove then?
Are you sure is really unneeded?
They are *vital* to most people here, for hosting services.
Regards,
Netino
Are you sure is really unneeded?
They are *vital* to most people here, for hosting services.
Code: [Select]
yum remove -y postfix
yum remove -y clamd clamav clamav-filesystem clamav-update clamav-lib clamav-data
yum remove -y bind bind-libs bind-libs-lite bind-export-libs bind-license bind-utils
Regards,
Netino
167
PHP / Re: User's PHP.INI Editor not working
« on: October 31, 2021, 02:36:36 AM »
Seems you have a permission problem with your ini file.
(Perhaps edited by root user?)
What are your user using? php-cgi, php-fpm.?
Regards,
Netino
(Perhaps edited by root user?)
What are your user using? php-cgi, php-fpm.?
Regards,
Netino
168
Installation / Re: EMERGENCY HELP ME
« on: October 31, 2021, 02:30:32 AM »I'm setting up the whole system, but I'm making mistakes on the rope. Please help me so I can publish my own server.
I want to be able to host a service for my domains with a static rope.
Yes, CWP is just for that.
Quote
I want to switch to the pro version of the panel
You must buy a license. Contact suppport at <>
Quote
I can't set up the static ip properly.
This needs to be configured before CWP. It must have been configured when your server was delivered. Contact your ISP for this.
Regards,
Netino
169
SSL / Re: Disable TLSv1.0 and v1.1 in openssl
« on: September 19, 2021, 04:39:29 AM »Hello, how can we disable TLS v1.0 and v1.1 in openSSL? We tries all but then openSSL breaks all. We are able to disable tls on apache and NGIX but not on openSSL. Please any suggestions?
Thanks, Ron
Are you by any chance referring to "OpenSSH" instead "OpenSSL"...?!
If so, then your best bet is to follow what the <https://cipherlist.eu> website says, as a starting point.
Change your /etc/ssh/sshd_config file as following:
Code: [Select]
Protocol 2
HostKey /etc/ssh/ssh_host_ed25519_key
HostKey /etc/ssh/ssh_host_rsa_key
HostKeyAlgorithms ssh-ed25519,rsa-sha2-512,rsa-sha2-256
KexAlgorithms curve25519-sha256@libssh.org,curve25519-sha256,diffie-hellman-group18-sha512,diffie-hellman-group16-sha512,diffie-hellman-group14-sha256,diffie-hellman-group-exchange-sha256
Ciphers chacha20-poly1305@openssh.com,aes256-gcm@openssh.com,aes128-gcm@openssh.com,aes256-ctr,aes192-ctr,aes128-ctr
MACs hmac-sha2-512-etm@openssh.com,hmac-sha2-256-etm@openssh.com,umac-128-etm@openssh.com
...and restart your openssh server (as root user):
Code: [Select]
# systemctl restart openssh
Regards,
Netino
170
DNS / Re: There are many query this website on BIND
« on: July 28, 2021, 07:39:56 PM »
As indicated in:
https://www.linuxquestions.org/questions/linux-newbie-8/there-are-many-query-this-website-on-my-dns-server-4175676097/
The solution is to Include the following lines in '/usr/local/csf/bin/csfpre.sh' file:
And restart csf/lfd:
Regards,
Netino
https://www.linuxquestions.org/questions/linux-newbie-8/there-are-many-query-this-website-on-my-dns-server-4175676097/
The solution is to Include the following lines in '/usr/local/csf/bin/csfpre.sh' file:
Code: [Select]
iptables -A INPUT -p udp --dport 53 -m string --algo kmp --string "pizzaseo" -j DROP
iptables -A INPUT -p udp --dport 53 -m string --algo kmp --from 0x38 --hex-string "|0000ff00010000292328000000000000|" -j DROP
And restart csf/lfd:
Code: [Select]
csf -x; csf -e
Regards,
Netino
171
Dovecot / Re: Need Domain specific sieve script instead of system global
« on: July 20, 2021, 12:04:10 AM »
From (adapted to CWP):
https://support.tigertech.net/sieve#sieve-filtering-for-jmp-2
Sieve filtering for an entire domain name
In addition to filters for each mailbox, it’s possible to create filters that apply to all addresses at your domain name. This is done by placing script files named “domain-before.sieve” and/or “domain-after.sieve” in your domain’s home directory:
You can put these on the server using an FTP connection to your home directory, or by using SFTP or a shell connection (both of which always have access to your home directory).
A “domain-before.sieve” script (if one exists) runs before any per-mailbox “mailbox.sieve” script, and a “domain-after.sieve” script (if one exists) runs after. So when a message arrives, three different Sieve script files will be searched for and used if present, in this order:
Each script is used only if a previous script didn’t discard the message or file it into a folder, so the order matters. If you want to create domain-wide rules that override “mailbox.sieve” scripts, you’d put them in the “domain-before.sieve” script. To create domain-wide rules that are used only if “mailbox.sieve” doesn’t do anything, you’d put them in “domain-after.sieve”.
https://support.tigertech.net/sieve#sieve-filtering-for-jmp-2
Sieve filtering for an entire domain name
In addition to filters for each mailbox, it’s possible to create filters that apply to all addresses at your domain name. This is done by placing script files named “domain-before.sieve” and/or “domain-after.sieve” in your domain’s home directory:
Code: [Select]
/var/vmail/example.com/domain-before.sieve
/var/vmail/example.com/domain-after.sieve
You can put these on the server using an FTP connection to your home directory, or by using SFTP or a shell connection (both of which always have access to your home directory).
A “domain-before.sieve” script (if one exists) runs before any per-mailbox “mailbox.sieve” script, and a “domain-after.sieve” script (if one exists) runs after. So when a message arrives, three different Sieve script files will be searched for and used if present, in this order:
Code: [Select]
/var/vmail/example.com/domain-before.sieve
/var/vmail/example.com/mailboxuser/mailbox.sieve
/var/vmail/example.com/domain-after.sieve
Each script is used only if a previous script didn’t discard the message or file it into a folder, so the order matters. If you want to create domain-wide rules that override “mailbox.sieve” scripts, you’d put them in the “domain-before.sieve” script. To create domain-wide rules that are used only if “mailbox.sieve” doesn’t do anything, you’d put them in “domain-after.sieve”.
172
How to / Re: [Howto] Install Rspamd
« on: July 07, 2021, 12:41:10 AM »Hello Netino,
I am getting the following error:
Sorry for long delay...
Quote
Code: [Select]# rspamadm configtest
2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:452: both auth_only (true) and sign_authenticated (true) for dkim_signing are specified, prefer auth_only
2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:452: both auth_only (true) and sign_authenticated (false) for arc are specified, prefer auth_only
You can comment or remove the "auth_only" variable in '/etc/rspamd/local.d/dkim_signing.conf' (and/or /etc/rspamd/local.d/arc.conf):
Code: [Select]
#auth_only = true;
Quote
Code: [Select]2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:242: conflicting names in surbl and rbl rules: SEM_URIBL_FRESH15_UNKNOWN, prefer surbl rule!
2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:242: conflicting names in surbl and rbl rules: SEM_URIBL_UNKNOWN, prefer surbl rule!
2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:242: conflicting names in surbl and rbl rules: URIBL_MULTI, prefer surbl rule!
2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:242: conflicting names in surbl and rbl rules: SURBL_MULTI, prefer surbl rule!
2020-10-18 13:20:15 #0(main) <>; lua; lua_cfg_transform.lua:242: conflicting names in surbl and rbl rules: DBL, prefer surbl rule!
syntax OK
You can remove entirely the file '/etc/rspamd/local.d/surbl.conf', due to rspamd now have replaced these functions in '/etc/rspamd/local.d/rbl.conf', at the current version(2.7) of rspamd.
Quote
Code: [Select]CLAM_VIRUS_FAIL (0) [failed to scan and retransmits exceed]
The message claims there was a problem trying to check the clam upstream-server. If upstream returns err, it try to contact different upstream for retransmits-1 times. If this doesn’t help, the function returns the message. Clam sometimes is a delayed daemon.
So, you must sure to configure more clamd daemons (in clamd.conf), or adding more memory to your server, or configure something like the following in "/etc/rspamd/local.d/antivirus.conf":
Code: [Select]
clamav {
...
timeout = 15.0;
retransmits = 4;
...
}
Quote
My Status :Code: [Select]# rspamc stat
Results for command: stat (0.186 seconds)
Messages scanned: 142
Messages with action reject: 3, 2.11%
Messages with action soft reject: 0, 0.00%
Messages with action rewrite subject: 0, 0.00%
Messages with action add header: 3, 2.11%
Messages with action greylist: 3, 2.11%
Messages with action no action: 133, 93.66%
Messages treated as spam: 6, 4.22%
Messages treated as ham: 136, 95.77%
Messages learned: 129
Connections count: 0
Control connections count: 61
Pools allocated: 137
Pools freed: 191
Bytes allocated: 3.92GiB
Memory chunks allocated: 4294966837
Shared chunks allocated: 33
Chunks freed: 0
Oversized chunks: 2
Fuzzy hashes in storage "rspamd.com": 1519996981
Fuzzy hashes stored: 1519996981
Statfile: BAYES_SPAM type: redis; length: 0; free blocks: 0; total blocks: 0; free: 0.00%; learned: 0; users: 0; languages: 0
Statfile: BAYES_HAM type: redis; length: 0; free blocks: 0; total blocks: 0; free: 0.00%; learned: 3; users: 1; languages: 0
Total learns: 3
Seems working...
Quote
Disabled:
SpamAssassin, Amavisd & Opendkim
Ok
Quote
another errorCode: [Select]2020-10-18 17:02:30 #1596(controller) <66e689>; csession; rspamd_controller_handle_lua_plugin: plugin handler /plugins/selectors/list_extractorss has not been found
2020-10-18 17:02:30 #1596(controller) <15eeb3>; csession; rspamd_controller_handle_lua_plugin: plugin handler /plugins/selectors/list_transformss has not been found
I could not reproduce this problem with 'rspamd_controller_handle_lua_plugin' handler.
Seems a problem with the controller, configured in '/etc/rspamd/local.d/worker-controller.inc'.
Code: [Select]
(...)
# Listen on all IPs (change, if needed)
bind_socket = "localhost:11334";
(...)
Try checking whether 'bind_socket' is set to "localhost:11334" or "127.0.0.1:11334" (as for IPv4) , or "[::1]:11334" (as for IPv6), and also if your controller is responding in one of these three configurations, and configure the file "worker-controller.inc" accordingly.
Code: [Select]
bind_socket = "127.0.0.1:11334";
orCode: [Select]
bind_socket = "[::1]:11334";
The Rspamd maillist has a discussion about the possibility of a misconfiguration in your reverse proxy
adding extra 's' at the end of plugin locations. check here:
https://lists.rspamd.com/pipermail/users/2020-October/001828.html
Quote
Code: [Select]2020-10-18 11:18:54 #1615(rspamd_proxy) <ddfbed>; proxy; dkim_module_load_key_format: cannot load dkim key /etc/opendkim/userkeys/ysseit.com/default.private: cannot map key file: '/etc/opendkim/userkeys/ysseit.com/default.private' Permission denied
2020-10-18 15:34:38 #1657(rspamd_proxy) <592d68>; proxy; dkim_module_load_key_format: cannot load dkim key /etc/opendkim/userkeys/ysseit.com/default.private: cannot map key file: '/etc/opendkim/userkeys/ysseit.com/default.private' Permission denied
2020-10-18 15:35:41 #1657(rspamd_proxy) <7db261>; proxy; dkim_module_load_key_format: cannot load dkim key /etc/opendkim/userkeys/ysseit.com/default.private: cannot map key file: '/etc/opendkim/userkeys/ysseit.com/default.private' Permission denied
You must to change ownership to 'opendkim' user:
Code: [Select]
# chown opendkim:opendkim /etc/opendkim/userkeys/ysseit.com/default.private
And the permissions (for security) to:
Code: [Select]
chmod 640 /etc/opendkim/userkeys/ysseit.com/default.private
chmod 644 /etc/opendkim/userkeys/ysseit.com/default.txt
Regards,
Netino
173
CentOS 7 Problems / Re: Log troubleshooting
« on: January 24, 2020, 04:08:14 AM »
What webserver are you using..?!
There are some possibilities.
Check search.
Found something like that:
http://forum.centos-webpanel.com/centos-webpanel-bugs/default-page-changed-to-index-html-on-all-sites!/
Regards,
Netino
There are some possibilities.
Check search.
Found something like that:
http://forum.centos-webpanel.com/centos-webpanel-bugs/default-page-changed-to-index-html-on-all-sites!/
Regards,
Netino
174
CentOS 5 Problems / Re: PROBLEM OF LOAD AVERAGES
« on: January 21, 2020, 02:21:35 AM »
Load averages are highly randomized, and is possible you will don't have two sequential commands, aparted from three or four seconds, run with equal values.
What the size of these differences?
Regards,
Netino
What the size of these differences?
Regards,
Netino
175
Installation / Re: Install in a Centos 7 with previous apps on it
« on: January 13, 2020, 04:19:07 AM »Hello, I want install Centos 7 64 bits Version, My question is: Can i install with previous apps running on VPS?
I have one helpdesk php made with mysql tables, IONIC Framework running just now,.
Did you know if is any trouble with install over?
Thank you i like this panel
No, you can't. At least if you don't wanna go crazy solving problems.
You must to install it in a clean server.
Regards,
Netino
176
CentOS 7 Problems / Re: Pure-FTP Failure
« on: January 13, 2020, 04:12:59 AM »
(I know it's a old thread, but is just to document the issue)
The error seems is in this line here:
It is claiming about "Too many levels of symbolic links" of the PID file.
You tried to run "journalctl -xe" almost 24 minutes after, too late to show logs.
Seems you tried to reinstalled the pure-ftpd server.
Check the permissions of the file '/var/run/pure-ftpd.pid' and the directory.
Removing this file and restarting pure-ftpd server may solve the issue.
If don't, would be good to post here the conf file "/etc/pure-ftpd/pure-ftpd.conf".
Regards,
Netino
The error seems is in this line here:
Code: [Select]
Nov 28 07:55:53 server systemd[1]: Can't open PID file /var/run/pure-ftpd.pid (yet?) after start: Too many levels of symbolic links
It is claiming about "Too many levels of symbolic links" of the PID file.
You tried to run "journalctl -xe" almost 24 minutes after, too late to show logs.
Seems you tried to reinstalled the pure-ftpd server.
Check the permissions of the file '/var/run/pure-ftpd.pid' and the directory.
Removing this file and restarting pure-ftpd server may solve the issue.
If don't, would be good to post here the conf file "/etc/pure-ftpd/pure-ftpd.conf".
Regards,
Netino
177
CentOS 7 Problems / Re: All files of users home directory gone after activate shell access with jailkit
« on: January 12, 2020, 09:59:26 PM »
From Jailkit documentation:
So, you did a chroot in your user's shell access..?!
If so, what the surprise..??
Chroot just exist to change the root of directories visible to that user.
But the files still exist there, in the same place, usually. But only visible to the root user.
Regards,
Netino
Code: [Select]
Jailkit is a set of utilities to limit user accounts to specific files using chroot() and or specific commands.(...)
So, you did a chroot in your user's shell access..?!
If so, what the surprise..??
Chroot just exist to change the root of directories visible to that user.
But the files still exist there, in the same place, usually. But only visible to the root user.
Regards,
Netino
178
MySQL / Re: Yum Manager and # yum update failing to update Maria SQL
« on: January 06, 2020, 03:03:16 AM »
I'm using OpenVZ7. So, when restart the MariaDB server with above trick, it fails to restart the MariaDB server.
Running "systemctl disable mysql" didn't solved the problem.
When upgraded MariaDB, I see was created a file "/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf":
For some reason, I cannot do nice/renice of processes priorities in OpenVZ7, although being root user.
I searched google, but could't find anything to solve this problem.
So, commenting the "Nice" parameter, and solved the problem.
I tried too to add "DefaultLimitNICE:-5:-5" to /etc/systemd/system.conf, but the problem persists.
But strangely, I can use "renice" the running processes by changing the process priority with "htop" tool (need to install it).
Seems a problem with sh/bash.
Regards,
Netino
Code: [Select]
# systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
# systemctl -l status mariadb
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─dontprotecthome.conf, limitnofile.conf, migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Dom 2020-01-05 19:10:02 -03; 2s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3081 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=201/NICE)
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: Starting MariaDB 10.2.30 database server...
Jan 05 19:10:02 painel.edeaas.com.br systemd[3081]: Failed at step NICE spawning /bin/sh: Permission denied
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: mariadb.service: control process exited, code=exited status=201
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: Failed to start MariaDB 10.2.30 database server.
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: Unit mariadb.service entered failed state.
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: mariadb.service failed.
Running "systemctl disable mysql" didn't solved the problem.
When upgraded MariaDB, I see was created a file "/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf":
Code: [Select]
# converted using /usr/bin/mariadb-service-convert
#
[Service]
Nice=-5
For some reason, I cannot do nice/renice of processes priorities in OpenVZ7, although being root user.
I searched google, but could't find anything to solve this problem.
So, commenting the "Nice" parameter, and solved the problem.
Code: [Select]
# converted using /usr/bin/mariadb-service-convert
#
#[Service]
#Nice=-5
# systemctl -l status mariadb
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Dom 2020-01-05 20:16:38 -03; 2h 51min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 9559 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 9441 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 9440 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 9527 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─9527 /usr/sbin/mysqld --basedir=/usr
I tried too to add "DefaultLimitNICE:-5:-5" to /etc/systemd/system.conf, but the problem persists.
But strangely, I can use "renice" the running processes by changing the process priority with "htop" tool (need to install it).
Seems a problem with sh/bash.
Regards,
Netino
179
Updates / Re: Update MariaDB >= 10.2
« on: January 06, 2020, 03:02:24 AM »
I'm using OpenVZ7. So, when restart the MariaDB server with above trick, it fails to restart the MariaDB server.
Running "systemctl disable mysql" didn't solved the problem.
When upgraded MariaDB, I see was created a file "/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf":
For some reason, I cannot do nice/renice of processes priorities in OpenVZ7, although being root user.
I searched google, but could't find anything to solve this problem.
So, commenting the "Nice" parameter, and solved the problem.
I tried too to add "DefaultLimitNICE:-5:-5" to /etc/systemd/system.conf, but the problem persists.
But strangely, I can use "renice" the running processes by changing the process priority with "htop" tool (need to install it).
Seems a problem with sh/bash.
Regards,
Netino
Code: [Select]
# systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
# systemctl -l status mariadb
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─dontprotecthome.conf, limitnofile.conf, migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Dom 2020-01-05 19:10:02 -03; 2s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3081 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=201/NICE)
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: Starting MariaDB 10.2.30 database server...
Jan 05 19:10:02 painel.edeaas.com.br systemd[3081]: Failed at step NICE spawning /bin/sh: Permission denied
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: mariadb.service: control process exited, code=exited status=201
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: Failed to start MariaDB 10.2.30 database server.
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: Unit mariadb.service entered failed state.
Jan 05 19:10:02 painel.edeaas.com.br systemd[1]: mariadb.service failed.
Running "systemctl disable mysql" didn't solved the problem.
When upgraded MariaDB, I see was created a file "/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf":
Code: [Select]
# converted using /usr/bin/mariadb-service-convert
#
[Service]
Nice=-5
For some reason, I cannot do nice/renice of processes priorities in OpenVZ7, although being root user.
I searched google, but could't find anything to solve this problem.
So, commenting the "Nice" parameter, and solved the problem.
Code: [Select]
# converted using /usr/bin/mariadb-service-convert
#
#[Service]
#Nice=-5
# systemctl -l status mariadb
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Dom 2020-01-05 20:16:38 -03; 2h 51min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 9559 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 9441 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 9440 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 9527 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─9527 /usr/sbin/mysqld --basedir=/usr
I tried too to add "DefaultLimitNICE:-5:-5" to /etc/systemd/system.conf, but the problem persists.
But strangely, I can use "renice" the running processes by changing the process priority with "htop" tool (need to install it).
Seems a problem with sh/bash.
Regards,
Netino
180
Updates / Re: Update MariaDB >= 10.2
« on: January 04, 2020, 11:11:21 PM »
You can have a problem with systemd daemon, being MySQL service pointed at CWP Dashboard as "No Active".
Checking for "mariadb" service after install, you find nothing.
Seeking for mysql service, you find:
Checking for the unit existence, you find:
Checking for MySQL with systemctl command:
For some strange reason, the manual upgrade MariaDB's installation does't auto enable the unit at systemd.
So, to resolve the CWP Dashboard problem, you simply enable mariadb:
Checking for the solution:
Regards,
Netino
Checking for "mariadb" service after install, you find nothing.
Seeking for mysql service, you find:
Code: [Select]
# systemctl | grep -i mysql
mysql.service loaded active running LSB: start and stop MariaDB
Checking for the unit existence, you find:
Code: [Select]
# ls -alF /usr/lib/systemd/system/mariadb.service* /usr/share/mysql/systemd/mariadb.service /etc/rc.d/init.d/mysql*
-rwxr-xr-x 1 root root 12192 Dez 4 20:38 /etc/rc.d/init.d/mysql*
lrwxrwxrwx 1 root root 17 Jun 17 2018 /etc/rc.d/init.d/mysqld -> /etc/init.d/mysql*
-rw-r--r-- 1 root root 5157 Dez 4 20:38 /usr/lib/systemd/system/mariadb.service
-rw-r--r-- 1 root root 4513 Out 29 2018 /usr/lib/systemd/system/mariadb.service.rpmsave
-rw-r--r-- 1 root root 5157 Dez 4 20:38 /usr/share/mysql/systemd/mariadb.service
Checking for MySQL with systemctl command:
Code: [Select]
# systemctl status mysql --no-pager
● mysql.service - LSB: start and stop MariaDB
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
Active: active (running) since Sáb 2020-01-04 03:33:10 -03; 16h ago
Docs: man:systemd-sysv-generator(8)
CGroup: /system.slice/mysql.service
├─8050 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/painel.edeaas.com.br.pid
└─8120 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err
# systemctl status mysqld --no-pager
● mysqld.service - LSB: start and stop MariaDB
Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
For some strange reason, the manual upgrade MariaDB's installation does't auto enable the unit at systemd.
So, to resolve the CWP Dashboard problem, you simply enable mariadb:
Code: [Select]
# systemctl enable mariadb
Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
Checking for the solution:
Code: [Select]
# systemctl status mysql --no-pager
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) (Result: exit-code) since Sáb 2020-01-04 03:33:10 -03; 16h ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
CGroup: /system.slice/mysql.service
├─8050 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/painel.edeaas.com.br.pid
└─8120 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err
# systemctl status mysqld --no-pager
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) (Result: exit-code) since Sáb 2020-01-04 03:33:10 -03; 16h ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
CGroup: /system.slice/mysql.service
├─8050 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/painel.edeaas.com.br.pid
└─8120 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err
# systemctl status mariadb --no-pager
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) (Result: exit-code) since Sáb 2020-01-04 03:33:10 -03; 16h ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
CGroup: /system.slice/mysql.service
├─8050 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/painel.edeaas.com.br.pid
└─8120 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err
# systemctl status mysql --no-pager
● mariadb.service - MariaDB 10.2.30 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) (Result: exit-code) since Sáb 2020-01-04 03:33:10 -03; 16h ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
CGroup: /system.slice/mysql.service
├─8050 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/painel.edeaas.com.br.pid
└─8120 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err
Regards,
Netino