HyperDB is a WordPress plugin that allows you to use multiple MySQL database servers with large MySQL installations. It is used to WordPress.com to distribute MySQL server load amount multiple MYSQL database servers hosted in different data centers. HyperDB supports Read and write servers (replication) Configurable priority for reading and writing Local and remote datacenters […]
On an Ubuntu server (Ubuntu 20.04.2 LTS) when running a PHP script, I get the following error.
|
1 |
Warning: Use of undefined constant OAUTH_REQENGINE_CURL - assumed 'OAUTH_REQENGINE_CURL' (this will throw an Error in a future version of PHP |
On checking phpinfo, I get
|
1 |
Request engine support php_streams |
curl is missing in “Request engine support”. This is because the default php-oauth package does not support curl. To fix, uninstall php-oauth and install oauth package using pecl. Uninstall pcel
|
1 |
apt install php-oauth -y |
[…]
I have a haproxy container running on port 80. This container is started with command
|
1 |
docker run -d -p 80:80 --name haproxy1 -v /home/ubuntu/haproxy:/usr/local/etc/haproxy:ro haproxy:1.7 |
This haproxy used following configuration file /home/ubuntu/haproxy/haproxy.cfg
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
global defaults frontend sok-front-end bind *:80 mode http default_backend sok-front-end backend sok-front-end mode http balance roundrobin server srv3 172.17.0.2:8000 |
To make this haproxy work with SSL, first create a ssl.pem file with your SSL certificate contents in following order
|
1 2 3 |
1) Your Private Key 2) Your SSL CRT 4) CA-BUNDLE |
copy and paste all those certs into ssl.pem file inside […]
When you run exim mail server, it is good to keep an eye on number of emails in mail queue. here is a PHP script that will check number of emails in queue, if it exceed pre-set number, it will email you. Create file
|
1 2 |
mkdir /usr/serverok/ vi /usr/serverok/mail_q_monitor.php |
Add following content.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
<?php # Author: ServerOk Software # Email: [email protected] # Web: https://serverok.in $cmd = '/usr/sbin/exim -bpc'; $num_mails = exec($cmd); $alertOn = 100; if ($num_mails > $alertOn) { $hostname = exec('/bin/hostname'); $subject = 'Mail queue alert on ' . $hostname; $mail_text = 'Mail queue on server ' . $hostname . ' have ' . $num_mails . ' mails'; mail($adminEmail, $subject, $mail_text); } |
In this case, if mails in […]
Edit file
|
1 |
vi /usr/local/centovacast/etc/cc-panel.conf |
Find
|
1 |
listen 2199 default ssl; |
Add below
|
1 2 |
listen 443 ssl; listen 80; |
Restart Centova Cast
|
1 |
/usr/local/centovacast/centovacast restart |
At this point, you will be able to access Centova Cast on port 80 at
|
1 |
http://YOUR_SERVER_IP/login/index.php |
To install LetsEncrypt Free SSL certificate, run
|
1 |
/usr/local/centovacast/sbin/setssl letsencrypt YOUR-DOMAIN.EXTN |
Restart Centova Cast
|
1 |
/usr/local/centovacast/centovacast restart |
Now you will be able to access Centova Cast using HTTPS. […]
VestaCP Free Hosting control panel compromised again. Hackers where able to get access to VestaCP infrastcuture server, allowing them to modify installation script, so it sent root password of servers to hacker. Here is post from VestaCP on their forum I’m sorry about inactivity in this post from our side. It was a complex issue […]
To change PHP version for a site, first find available PHP handlers, this can be done with command
|
1 |
/usr/local/psa/admin/bin/php_handlers_control --list |
You need to find the id for the PHP handler. For PHP 5.6 fpm, it is “plesk-php56-fpm”. To change a sites PHP version to PHP 5.6, run
|
1 |
plesk bin domain -u DOMAIN_NAME_HERE -php_handler_id plesk-php56-fpm |
Example […]
When installing ffmpeg, i get error
|
1 2 3 4 5 6 7 8 9 10 11 12 |
CC libavcodec/libvorbisenc.o CC libavcodec/libx264.o libavcodec/libx264.c: In function ‘X264_frame’: libavcodec/libx264.c:282:9: error: ‘x264_bit_depth’ undeclared (first use in this function) if (x264_bit_depth > 8) ^ libavcodec/libx264.c:282:9: note: each undeclared identifier is reported only once for each function it appears in libavcodec/libx264.c: In function ‘X264_init_static’: libavcodec/libx264.c:892:9: error: ‘x264_bit_depth’ undeclared (first use in this function) if (x264_bit_depth == 8) ^ make: *** [libavcodec/libx264.o] Error 1 |
This is due to incompatability with ffmpeg and x264. What you can do is try another version of x264. You will be able to download older version of x264 from ftp://ftp.videolan.org/pub/x264/snapshots On 2018-08-14, it failed with latest stable snapshot. So i tried 14 days old stable snapshot
|
1 2 3 4 5 6 7 8 |
cd /usr/local/src/ wget ftp://ftp.videolan.org/pub/x264/snapshots/x264-snapshot-20180730-2245-stable.tar.bz2 tar xvf x264-snapshot-20180730-2245-stable.tar.bz2 cd /usr/local/src/x264-snapshot-20180730-2245-stable make clean && make distclean ./configure --prefix=/usr --enable-shared make && make install ldconfig |
[…]
To enable Zend OPCache in PHP, edit php.ini add following to end of the file
|
1 |
zend_extension=opcache.so |
Now you may need to adjust some settings, in php.ini uncomment following, change values as needed.
|
1 2 3 4 5 6 |
opcache.enable=1 opcache.enable_cli=1 opcache.memory_consumption=128 opcache.max_accelerated_files=10000 opcache.validate_timestamps=1 opcache.revalidate_freq=10 |
Verify it with
|
1 2 3 4 5 |
[root@vps154294 php]# php -m | grep Zend Zend OPcache [Zend Modules] Zend OPcache [root@vps154294 php]# |
Restart web server. If you using php-fpm or fcgi, you need to restart the process. phpinfo() will show […]
To install Redis PHP module from source, run
|
1 2 3 4 5 6 |
cd /usr/local/src git clone https://github.com/phpredis/phpredis.git cd /usr/local/src/phpredis /usr/serverok/php-7.1.12/bin/phpize ./configure --with-php-config=/usr/serverok/php-7.1.12/bin/php-config make && make install |
Once installed, edit your php.ini file, add following below extension_dir line
|
1 |
extension=redis.so |
Verify redis is installed with php -m
|
1 2 3 |
[root@vps154294 ~]# /usr/serverok/php-7.1.12/bin/php -m | grep redis redis [root@vps154294 ~]# |
Now restart web server
|
1 |
service httpd restart |
phpinfo() will show following […]