Show Posts

31

MySQL / Re: error establishing database connection

« on: October 08, 2018, 04:32:24 AM »

what is output of this command

Code: [Select]

systemctl status mariadb.service -l

32

SSL / Re: Issue Installing SSL

« on: October 08, 2018, 04:30:26 AM »

https://yourserverip:2087/admin/index.php?module=ssl_certificate

Click AutoSSL [FREE] tab and install your ssl.

33

SSL / Re: Invalid certificate/key pair and Apache server fails to start

« on: October 08, 2018, 04:27:51 AM »

what is output of

Code: [Select]

systemctl status httpd.service -l

34

SSL / Re: ssl expire

« on: October 08, 2018, 04:26:28 AM »

This command used to trigger ssl installation

Code: [Select]

sh /root/.acme.sh/acme.sh --home /root/.acme.sh/cwp_certs --issue -d www.yourdomain.com -d yourdomain.com -w /usr/local/apache/autossl_tmp --debug 2

So basically ssl are installed in "/root/.acme.sh/cwp_certs" and from there moved to respective directory and added in vhosts-ssl.conf file.

35

Problems on other RedHat linux servers / Re: ERROR: Unable to detect your server version, please contact CWP support to check

« on: October 08, 2018, 04:18:53 AM »

Its developers bug.

36

CentOS-WebPanel Bugs / Re: WARNING: User Panel possible issue detected! If you have issues with user panel

« on: October 08, 2018, 04:18:19 AM »

what is output of

Code: [Select]

ss -nlp | grep 2082

37

CentOS-WebPanel Bugs / Re: coin hive attack on my server ... how?

« on: October 08, 2018, 04:14:28 AM »

Do remember CentOS kernels are not symlink patched. If one site gets hacked then all sites on your server may get compromised using symlink attack. Its better to use symlink patch for protection as multiple sites are hosted on your server.

Code: [Select]

https://www.cloudlinux.com/kernelcare-blog/entry/symlink-protection-patchset-centos-6-7-kernelcare

38

CentOS-WebPanel Bugs / Re: FIX THE APACHE REBUILD ALLREADY-- ITS BEEN WACK FOR 6 MONTHS

« on: October 08, 2018, 04:09:44 AM »

Quote from: Netino on October 07, 2018, 08:17:00 PM

Is not possible to understand what is your problem.

He is saying when he rebuild Apache the httpd.conf file have just 3 lines and all other config lines just wipes out. The thing is CWP team is overwriting httpd.conf file after compilation not appending it

39

Updates / Re: Update MariaDB >= 10.2

« on: October 08, 2018, 03:49:58 AM »

Quote from: Netino on October 07, 2018, 08:36:39 PM

CentOS have not that version for MariaDB.
'yum update' install the latest version, that is 10.1.36, for CentOS 7.
(what is your CentOS version?)

But nothing can stop you from install it from sources.
Or install rpms from RHEL7, that possibly will work too.
At yout risk.

RHEL7 have the '10.2.8-5.el7.x86_64.rpm' version available.

Regards,
Netino

First of all MariaDB has it's own repository and is not provided by base CentOS repository.

Quote

yum whatprovides mariadb
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: ftp.iitm.ac.in
* epel: mirror1.ku.ac.th
* extras: ftp.iitm.ac.in
* updates: ftp.iitm.ac.in
MariaDB-client-10.1.36-1.el7.centos.x86_64 : MariaDB: a very fast and robust SQL database server
Repo : mariadb
Matched from:
Provides : mariadb = 1:10.1.36-1.el7.centos

Below is its repository location.

Quote

cat /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

This will show you what version of MariaDB is installed. So in our case its 10.1

Quote

rpm -qa | grep -i '^mariadb-'

MariaDB-shared-10.1.36-1.el7.centos.x86_64
MariaDB-compat-10.1.36-1.el7.centos.x86_64
MariaDB-common-10.1.36-1.el7.centos.x86_64
MariaDB-server-10.1.36-1.el7.centos.x86_64
MariaDB-client-10.1.36-1.el7.centos.x86_64

Now if I want to upgrade this I will modify mariadb.repo file and change 10.1 to 10.2

Quote

vi /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

First I will make full backup of my database if something goes wrong

Code: [Select]

mysqldump --all-databases > /home/fullbackup.sql.gz
Simply go ahead and remove these packages

Code: [Select]

yum remove MariaDB-server MariaDB-client -y
Now install the new latest packages again for version 10.2.

Code: [Select]

yum install MariaDB-server MariaDB-client -y
You can change 10.1 to 10.3 MariaDB repository "/etc/yum.repos.d/mariadb.repo" in if you wish to use that version.

Verify the packages again

Quote

[root@localhost ~]# rpm -qa | grep -i '^mariadb-'
MariaDB-shared-10.2.18-1.el7.centos.x86_64
MariaDB-server-10.2.18-1.el7.centos.x86_64
MariaDB-compat-10.2.18-1.el7.centos.x86_64
MariaDB-common-10.2.18-1.el7.centos.x86_64
MariaDB-client-10.2.18-1.el7.centos.x86_64

Start Mariadb

Code: [Select]

systemctl start mariadb
Upgrade MySQL database for compatibility

Code: [Select]

mysql_upgrade

40

PHP / Re: update ICU system package and the intl PHP extension

« on: October 01, 2018, 09:31:00 AM »

Quote

[root@cwp7 source]# yum list available | grep libicu
libicu.i686 50.1.2-15.el7 base
libicu-devel.i686 50.1.2-15.el7 base
libicu-doc.noarch 50.1.2-15.el7 base

Quote

[root@cwp7 ~]# icuinfo | grep version
<param name="version">50.1.2</param>
<param name="version.unicode">6.2</param>
<param name="cldr.version">22.1.1</param>
<param name="tz.version">2012j</param>

Well 50.1.2 the latest version of icu available for centos 7 base repository.

If you need any other version then you need to compile it from source (http://download.icu-project.org/files/icu4c/).

So lets take 62.1 version and compile it.

Quote

cd /usr/local/src
wget http://download.icu-project.org/files/icu4c/62.1/icu4c-62_1-src.tgz
tar -xvf icu4c-*.tgz
cd icu/source/
sed -i '/#define __UCONFIG_H__/a #define UCONFIG_ENABLE_PLUGINS 1' common/unicode/uconfig.h
./configure --prefix=/usr --bindir=/usr/bin --libdir=/usr/lib64 --datadir=/usr/share --enable-plugins
make -j4 && make install

Quote

[root@cwp7 source]# icuinfo | grep version
<param name="version">62.1</param>
<param name="version.unicode">11.0</param>
<param name="cldr.version">33.1</param>
<param name="tz.version">2018e</param>

More compiling options can be found inside "configure" and you can use as per your need.

41

PHP / Re: update ICU system package and the intl PHP extension

« on: September 30, 2018, 11:35:43 AM »

They are part of php pkgs. It should update with the version version of php itself.

42

CentOS-WebPanel GUI / Re: non WWW to WWW and HTTP to HTTPS??

« on: September 30, 2018, 11:31:54 AM »

If www is working and without www redirecting to /cgi-sys/defaultwebpage.cgi then that means you are redirected to cpanel for all other protocols except www. Look in your domain dns.

43