Archive by Author

I’m back!

Life is not always perfect and I needed to leave this site into forgottenness for quite some time. Next I’ll release the Prestashop modules free of charge – a link to GitHub will follow. For the rest of products & … Continue reading

Select Biggest MySQL tables

SELECT CONCAT(table_schema, ‘.’, table_name), CONCAT(ROUND(table_rows / 1000000, 2), ‘M’) rows, CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), ‘G’) DATA FROM information_schema.TABLES ORDER BY `DATA` DESC LIMIT 100

Change slug for an already registered post type

function wpti_custom_post_type_args( $args, $post_type ) { if ( $post_type === ‘my-registered-custom-post-type’ ) { $args[‘rewrite’] = array( ‘slug’ => ‘my-new-slug’ ); } return $args; } Unfortuantely it doesn’t work with the default post types like post/page

ERROR: can not find RHNS CA file

When rpm -e rhn-client-tools-2.0.2-8.el7.noarch rhnsd-5.0.13-5.el7.x86_64 rhn-check-2.0.2-8.el7.noarch yum-rhn-plugin-2.0.1-6.el7.cloudlinux.noarch rhn-setup-2.0.2-8.el7.noarch rhnlib-2.5.65-2.el7.noarch

Debug PHP spam mails

touch /var/log/mail_php.log chmod 777 /var/log/mail_php.log vi #!/bin/sh logger -p \ site=${HTTP_HOST}, \ client=${REMOTE_ADDR}, \ script=${SCRIPT_NAME}, \ pwd=${PWD}, \ uid=${UID}, \ user=$(whoami) /usr/sbin/sendmail -t -i $* chmod +x /usr/local/bin/ then vi /usr/local/bin/env.php chmod +x /usr/local/bin/env.php in global /etc/cl.selector/global_php.ini … Continue reading

Apache reverse SSL proxy

In http conf you can use: ServerName SSLEngine On SSLCertificateFile cert.crt SSLCertificateKeyFile key.key SSLCACertificateFile bundle.cabundle ProxyPass / http://where_to_redirect/ flushpackets=on ProxyPassReverse / http://where_to_redirect/

Avoid brute force for wordpress

Not only it poses a security risk by hackers/bots trying to break into your wordpress install but also for a system admin it’s a nightmare because it may increase the server load. A solution would be to install a wordpress … Continue reading

http/2 apache centos7

1. Using epel test repository you can install nghttp2 and libnghttp2-devel libraries. 2. then get and compile openssl using ./config shared -fPIC make make install 3. create symlinks in /usr/lib64/ /usr/lib64/ to /usr/local/ssl/lib/ /usr/local/ssl/lib/ 4. because for now cpanel doesn’t … Continue reading

Linux – create a new partition command line

My situation: there was RAID setup between 3 physical hard disks, however one of them was considerable bigger – about a couple of TBytes. I needed the additional space for other purposes so I needed to create a new partition … Continue reading

Import public certificate and private key to Windows

We have our private key file named private.key and server certificate received from your certificate authority named here ServerCertificate.cer Step 1: for windows we need to generate the pfx file so with openSSL: openssl pkcs12 -export -out certificate.pfx -inkey private.key … Continue reading