Try replace database host name from localhost to 127.0.0.1
Link to database cannot be established: SQLSTATE[HY000] [2002]
Leave a reply
Unknown Reason The server encountered an internal error or misconfiguration and was unable to complete your request
Unknown Reason The server encountered an internal error or misconfiguration and was unable to complete your request
You should try use: ProxyErrorOverride off
ispconfig install php 5.6
mkdir -p /opt/php-5.6
mkdir /usr/local/src/php5.6-build
cd /usr/local/src/php5.6-build
wget http://de2.php.net/get/php-5.6.33.tar.bz2/from/this/mirror -O php-5.6.33.tar.bz2
tar jxf php-5.6.33.tar.bz2
./configure --prefix=/opt/php-5.6 --with-pdo-pgsql --with-zlib-dir --with-freetype-dir --enable-mbstring --with-libxml-dir=/usr --enable-soap --enable-calendar --with-curl --with-mcrypt --with-zlib --with-pgsql --disable-rpath --enable-inline-optimization --with-bz2 --with-zlib --enable-sockets --enable-sysvsem --enable-sysvshm --enable-pcntl --enable-mbregex --enable-exif --enable-bcmath --with-mhash --enable-zip --with-pcre-regex --with-pdo-mysql --with-mysqli --with-mysql-sock=/var/run/mysqld/mysqld.sock --with-jpeg-dir=/usr --with-png-dir=/usr --enable-gd-native-ttf --with-openssl=/opt/openssl --with-fpm-user=www-data --with-fpm-group=www-data --with-libdir=/lib/x86_64-linux-gnu --enable-ftp --with-kerberos --with-gettext --with-xmlrpc --with-xsl --enable-opcache --enable-fpm
make
make install
cp /usr/local/src/php5.6-build/php-5.6.33/php.ini-production /opt/php-5.6/lib/php.ini
cp /opt/php-5.6/etc/php-fpm.conf.default /opt/php-5.6/etc/php-fpm.conf
ispconfig install 5.4
apt-get update
apt-get install -y libfcgi-dev libfcgi0ldbl libjpeg62-dbg libmcrypt-dev libssl-dev libxml2-dev zlib1g-dev libcurl4-gnutls-dev libjpeg-turbo8-dev libbz2-dev libjpeg-dev libfreetype6-dev libmcrypt-dev libcurl4-gnutls-dev
ln -s /usr/include/x86_64-linux-gnu/curl curl
cd /usr/local/include
mkdir /opt/php-5.4.45
mkdir /usr/local/src/php5
cd /usr/local/src/php5
wget http://de2.php.net/get/php-5.4.45.tar.gz/from/this/mirror
mv mirror php-5.4.45.tar.gz
tar -xzvf php-5.4.45.tar.gz
cd php-5.4.45
./configure --prefix=/opt/php-5.4.45 --enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --enable-mbstring --enable-sockets --enable-exif --enable-bcmath --enable-calendar --enable-zip --enable-ftp --enable-gd-native-ttf --with-gd --with-jpeg-dir=/usr --with-png-dir=/usr --with-freetype-dir --with-zlib --with-zlib-dir --with-bz2 --with-mcrypt --with-mhash --with-pcre-regex --with-libxml-dir=/usr --with-xmlrpc --with-xsl --with-mysql --with-libdir=/lib/x86_64-linux-gnu --with-curl
make
make install
-bash: /usr/bin/du: Argument list too long
find . -maxdepth 1 -name "some_name.php*" -exec du -bk {} \; | awk '{ total = total + $1 } END { print total }'
nano disable color
nano -Ynone some_file.txt
linux high load average no reason
11:38:50 up 62 days, 1:12, 1 user, load average: 638.59, 755.02, 776.17
Cpu(s): 9.5%us, 9.5%sy, 0.0%ni, 76.2%id, 4.8%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 32753672k total, 5634300k used, 27119372k free, 617352k buffers
top –
660025 root 20 0 15560 1932 1008 R 100.0 0.0 0:00.21 top
717745 27 20 0 99516 41m 2472 S 70.2 0.1 145:04.24 /usr/libexec/mysqld –basedir=/usr –datadir=/var/lib/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –socket=/var/lib/mysql/mysql.sock
1 root 20 0 19236 316 88 S 0.0 0.0 0:09.58 /sbin/init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.72 [kthreadd]
3 root RT 0 0 0 0 S 0.0 0.0 0:08.22 [migration/0]
4 root 20 0 0 0 0 S 0.0 0.0 1:11.89 [ksoftirqd/0]
5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 [stopper/0]
6 root RT 0 0 0 0 S 0.0 0.0 0:10.47 [watchdog/0]
7 root RT 0 0 0 0 S 0.0 0.0 0:27.77 [migration/1]
8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 [stopper/1]
9 root 20 0 0 0 0 S 0.0 0.0 27:23.15 [ksoftirqd/1]
10 root RT 0 0 0 0 S 0.0 0.0 0:03.64 [watchdog/1]
11 root RT 0 0 0 0 S 0.0 0.0 0:12.50 [migration/2]
12 root RT 0 0 0 0 S 0.0 0.0 0:00.00 [stopper/2]
Try to find disk load:
ps aux | sort -rk 8 | awk '$8 == "D"' | tail -30
root 1015702 0.0 0.0 100992 104 ? D Apr05 0:00 /bin/df -P
root 1016451 0.0 0.0 100992 100 ? D Apr06 0:00 /bin/df -P
root 1020754 0.0 0.0 100992 100 ? D Apr05 0:00 /bin/df -P
root 1023815 0.0 0.0 100992 8 ? D Apr07 0:00 /bin/df -P
root 1026974 0.0 0.0 100992 100 ? D Apr05 0:00 /bin/df -P
root 1027504 0.0 0.0 100992 104 ? D Apr06 0:00 /bin/df -P
root 1027647 0.0 0.0 100992 104 ? D Apr06 0:00 /bin/df -P
root 1029003 0.0 0.0 100992 100 ? D Apr06 0:00 /bin/df -P
root 1029478 0.0 0.0 100992 12 ? D Apr04 0:00 /bin/df -P
root 1030382 0.0 0.0 100992 104 ? D Apr06 0:00 /bin/df -P
root 1031427 0.0 0.0 100992 100 ? D Apr07 0:00 /bin/df -P
root 1036867 0.0 0.0 100992 8 ? D Apr04 0:00 /bin/df -P
root 1037879 0.0 0.0 100992 104 ? D Apr05 0:00 /bin/df -P
root 1037958 0.0 0.0 100992 100 ? D Apr05 0:00 /bin/df -P
root 1038801 0.0 0.0 100992 100 ? D Apr05 0:00 /bin/df -P
root 1039219 0.0 0.0 100992 100 ? D Apr06 0:00 /bin/df -P
Fast fix:
ps aux | grep -w [d]f | awk '{print $2}' | xargs kill -9
It was caused by virtualizor:
ps aux | grep -w [v]irtualizor | awk '{print $2}' | xargs kill -9
linux set title on process name
bash -c "exec -a httpd ping somedomain.com>/dev/null&"
ps aux | grep http
vital 2844 0.0 0.1 221880 4020 pts/11 S 00:11 0:00 httpd somedomain.com
bash disable user shell
usermod -s /sbin/nologin someuser
history date bash
echo 'export HISTTIMEFORMAT="%d/%m/%y %T "' >> ~/.bash_profile
MegaCli back failed disk
If your raid array is degraded, but you think your HDD is good, you can try back it again. You CAN NOT just change status of failed disk to online, because you server data will be almost lost.
/root/bin/MegaCli64 -pdmarkmissing -physdrv[4:0] -aAll
/root/bin/MegaCli64 -pdprprmv -physdrv[4:0] -a0
/root/bin/MegaCli64 -PDMakeGood -PhysDrv[4:0] -a0
/root/bin/MegaCli64 -PDRbld -Start -PhysDrv[4:0] -a0 or /root/bin/MegaCli64 -pdlocate -start -physdrv[4:0] -a0
Sometimes you need fix foreign configuration:
/root/bin/MegaCli64 -CfgForeign -Clear -aALL
/root/bin/MegaCli64 -PDHSP -Set -PhysDrv [4:0] -a0 or /root/bin/MegaCli64 -PDHSP -Rmv -PhysDrv [4:0] -aN
Make sure you have backups of very important data.
linux open/view image from remote
ssh root@server 'cat /some/path/memory-day.png' | display
enable webp support in php GD library
If you are using directadmin and want enable webp support (Centos OS)
yum install libwebp-devel
vi /usr/local/directadmin/custombuild/custom/fpm/configure.php71
--with-webp-dir=/usr/lib64
./build php
If you have php 5.6 so use --with-vpx-dir
php -r 'var_dump(gd_info());'
array(12) {
["GD Version"]=>
string(26) "bundled (2.1.0 compatible)"
["FreeType Support"]=>
bool(true)
["FreeType Linkage"]=>
string(13) "with freetype"
["GIF Read Support"]=>
bool(true)
["GIF Create Support"]=>
bool(true)
["JPEG Support"]=>
bool(true)
["PNG Support"]=>
bool(true)
["WBMP Support"]=>
bool(true)
["XPM Support"]=>
bool(false)
["XBM Support"]=>
bool(true)
["WebP Support"]=>
bool(true)
["JIS-mapped Japanese Font Support"]=>
bool(false)
}
If you do not use fpm, so:
./build used_configs | grep configure.php
PHP (default) configuration file: /usr/local/directadmin/custombuild/configure/ap2/configure.php56
cd /usr/local/directadmin/custombuild
mkdir -p custom/ap2
cp -fp configure/ap2/configure.php56 custom/ap2/configure.php56
Unix.Trojan.DDoS_XOR-1 FOUND removal
If you find something running like /usr/bin/sywhksydor
or other strange name
You need check and remove /etc/crontab:
*/3 * * * * root /etc/cron.hourly/gcc.sh
then remove form init.d:
find /etc/ -name “*sywhksydor*” | xargs rm -fv
check if no more files created in similar time:
find /etc -mtime -3 -type f -print
Remove cron files:/etc/cron.hourly:
gcc.sh
wqcpplwrlsfby.sh
Remove /lib/libudev.so file
This should be enough, but you need keep monitor server and find the reason of the issue. In my case it was Magento:
$swvJgN7=”xQC+BaIOTBpEqTcQblQx5josN1zjqjFvNxlbbYnZNehr6bIY+iP6cwGBxTaHM7+pt5hmf2i/O4aEgvfCRfdJlMGS9RF0N5b83JCApZWFy0NHCplDxGRW3SxW0wZE142Nmf+7FgrnSoIQbmGT5MtwMBPKSMwd/iJG/YimplO02wgCM10Ivq1EtfgoP+AWezctDmP46MXr8Wwa+bgP6MMpmN5T/Yvoi22WXkzhBHd8BZvIXRoIsUADqgfvefeS3TlHavJw9VtGmBdzmU+o21+AZvXDVEK6EKSIi+R7VoiBpdhJTUstir45aKFjjBj4LdR0R/3dEzoNVQRLOmGpil9DqU6Mf1ELgyKywwxZUwOne2qLh3B/qdltngudFA0s8Abgo8gezeRq2i01pSA4MywmLEaJze7k2eJ4TWjgVurEYKKIIMHbtJhlPWOJUMswpVDHRqcsImkiHb4xEI2CBlwwNCdlKRs6eCapeVknqp3tzMzgUTqEg01/pQ7Gy7TE6HAXjlrmvN
rsnapshot exclude by size
rsync_long_args- -max-size=1000m