Socialabel

Monday, October 21, 2019

Install Mod Evasive On Centos Web Panel



git clone https://github.com/shivaas/mod_evasive.git
cd mod_evasive
/usr/local/apache/bin/apxs -i -a -c mod_evasive24.c


apxs:Error: /usr/bin/apr-1-config not found!.
apxs:Error: /usr/bin/apu-1-config not found!.

yum group install "Development Tools"
yum install openssl-devel apr-devel
yum install apr-util-devel

Thursday, July 4, 2019

CWP form login blank No Loader is installed. Please contact support.


No Loader is installed, please try to run this command or contact support: sh /scripts/update_ioncube

1.  Alternatif 1
sh /scripts/update_ioncube
/usr/local/cwp/php71/bin/php -v
service cwpsrv reload

echo "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.0.so" >> /usr/local/cwp/php71/php.ini
service cwpsrv reload


2.  Alternatif 2
yum -y install wget
yum -y update
reboot

Sunday, April 21, 2019

Tuesday, April 2, 2019

SSH User gagal login

Error dan Gagal akses SSH Server


  1. PuTTY fatal error: Server refused to start a shell/command
  2. failed to execute /bin/bash: Resource temporarily unavailable
  3. -bash: fork: retry: Resource temporarily unavailable


Gagal login user ssh di server redhat dan centos

https://access.redhat.com/solutions/543503

Edit File
/etc/security/limits.d/90-nproc.conf
atau /etc/security/limits.d/<user>.conf

<user>       -          nproc     2048      <<<----[ Only for "<user>" user ]
*          -          nproc     2048      <<<----[ For all user's ]

Friday, June 22, 2018

Perintah ProxySQL di Centos

Melihat Koneksi dan Grup yang digunakan
select * from stats_mysql_connection_pool;

Menambah Anggota Cluster
mysql> insert into mysql_servers(hostgroup_id, hostname, port) values (0,'192.168.56.102',3316);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into mysql_servers(hostgroup_id, hostname, port) values (1,'192.168.56.103',3316);
Query OK, 1 row affected (0.01 sec)
 
mysql> select * from mysql_servers;
3 rows in set (0.01 sec)
 
mysql> save mysql servers to disk;
Query OK, 0 rows affected (0.00 sec)
 
mysql> select * from disk.mysql_servers;
3 rows in set (0.00 sec)
 
mysql> load mysql servers to runtime;
Query OK, 0 rows affected (0.00 sec)

Menghapus Anggota Cluster 
mysql> delete from mysql_servers where hostgroup_id=1 and hostname='192.168.56.102';
Query OK, 1 row affected (0.00 sec)
Mengload Perubahan ProxySQL
mysql> load mysql servers to runtime;
Query OK, 0 rows affected (0.01 sec)
 
Melihat Anggota Cluster
mysql> select * from mysql_servers;