Category: Uncategorized

MySQL see all charsets

Posted on August 12, 2021 by ServerOk

To see all charsets available on your MySQL installation, run the command

select * from information_schema.character_sets;

1	select * from information_schema.character_sets;

maxlen column specifies how many bytes are required to store one character.

MariaDB [(none)]> select maxlen, character_set_name from information_schema.character_sets where character_set_name in('latin1', 'utf8', 'utf8mb4'); 
+--------+--------------------+
| maxlen | character_set_name |
+--------+--------------------+
|      1 | latin1             |
|      3 | utf8               |
|      4 | utf8mb4            |
+--------+--------------------+
3 rows in set (0.000 sec)

MariaDB [(none)]>

MariaDB [(none)]> select maxlen, character_set_name from information_schema.character_sets where character_set_name in('latin1', 'utf8', 'utf8mb4');

+--------+--------------------+

| maxlen | character_set_name |

+--------+--------------------+

| 1 | latin1 |

| 3 | utf8 |

| 4 | utf8mb4 |

+--------+--------------------+

3 rows in set (0.000 sec)

MariaDB [(none)]>

latin1 charset uses 1 byte to store a character. uff8mb4 uses 4 bytes to store a character. See MySQL […]

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 […]

Warning: Use of undefined constant OAUTH_REQENGINE_CURL

Posted on June 26, 2021 by ServerOk

On an Ubuntu server (Ubuntu 20.04.2 LTS) when running a PHP script, I get the following error.

Warning: Use of undefined constant OAUTH_REQENGINE_CURL - assumed 'OAUTH_REQENGINE_CURL' (this will throw an Error in a future version of PHP

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

Request engine support	php_streams

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

apt install php-oauth -y

1	apt install php-oauth -y

[…]

Enable SSL in Haproxy Docker Container

Posted on June 27, 2020 by ServerOk

I have a haproxy container running on port 80. This container is started with command

docker run -d -p 80:80 --name haproxy1 -v /home/ubuntu/haproxy:/usr/local/etc/haproxy:ro haproxy:1.7

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

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

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) Your Private Key
2) Your SSL CRT
4) CA-BUNDLE

1) Your Private Key

2) Your SSL CRT

4) CA-BUNDLE

copy and paste all those certs into ssl.pem file inside […]

PHP script to monitor exim mail queue

Posted on August 26, 2019 (January 9, 2020) by ServerOk

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

mkdir /usr/serverok/
vi /usr/serverok/mail_q_monitor.php

1 2	mkdir /usr/serverok/ vi /usr/serverok/mail_q_monitor.php

Add following content.

<?php
# Author: ServerOk Software
# Email: admin@serverok.in
# Web: https://serverok.in

$cmd =  '/usr/sbin/exim -bpc';
$num_mails = exec($cmd);
$adminEmail = "you@your-domain.com";
$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);
}

<?php

# Author: ServerOk Software

# Email: [email protected]

# Web: https://serverok.in

$cmd = '/usr/sbin/exim -bpc';

$num_mails = exec($cmd);

$adminEmail = "[email protected]";

$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 […]

Install SSL on Centova Cast

Posted on November 22, 2018 (October 25, 2019) by ServerOk

Edit file

vi /usr/local/centovacast/etc/cc-panel.conf

1	vi /usr/local/centovacast/etc/cc-panel.conf

Find

listen 2199 default ssl;

1	listen 2199 default ssl;

Add below

listen 443 ssl;
listen 80;

1 2	listen 443 ssl; listen 80;

Restart Centova Cast

/usr/local/centovacast/centovacast restart

1	/usr/local/centovacast/centovacast restart

At this point, you will be able to access Centova Cast on port 80 at

http://YOUR_SERVER_IP/login/index.php

1	http://YOUR_SERVER_IP/login/index.php

To install LetsEncrypt Free SSL certificate, run

/usr/local/centovacast/sbin/setssl letsencrypt YOUR-DOMAIN.EXTN

1	/usr/local/centovacast/sbin/setssl letsencrypt YOUR-DOMAIN.EXTN

Restart Centova Cast

/usr/local/centovacast/centovacast restart

1	/usr/local/centovacast/centovacast restart

Now you will be able to access Centova Cast using HTTPS. […]

VestaCP Installer Compromised

Posted on October 21, 2018 by ServerOk

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 […]

Change PHP version for a site in Plesk Command line

Posted on October 4, 2018 by ServerOk

To change PHP version for a site, first find available PHP handlers, this can be done with command

/usr/local/psa/admin/bin/php_handlers_control --list

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

plesk bin domain -u DOMAIN_NAME_HERE -php_handler_id plesk-php56-fpm

1	plesk bin domain -u DOMAIN_NAME_HERE -php_handler_id plesk-php56-fpm

Example […]

error: ‘x264_bit_depth’ undeclared (first use in this function)

Posted on August 14, 2018 (August 14, 2018) by ServerOk

When installing ffmpeg, i get error

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

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

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

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

[…]

Enable Zend OPcache in PHP

Posted on December 10, 2017 by ServerOk

To enable Zend OPCache in PHP, edit php.ini add following to end of the file

zend_extension=opcache.so

1	zend_extension=opcache.so

Now you may need to adjust some settings, in php.ini uncomment following, change values as needed.

opcache.enable=1
opcache.enable_cli=1
opcache.memory_consumption=128
opcache.max_accelerated_files=10000
opcache.validate_timestamps=1
opcache.revalidate_freq=10

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

[root@vps154294 php]# php -m | grep  Zend
Zend OPcache
[Zend Modules]
Zend OPcache
[root@vps154294 php]#

[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 […]