25 Jan

How to setup port forwarding in Windows

To start:

netsh interface portproxy add v4tov4 listenport=8080 listenaddress=0.0.0.0 connectport=80 connectaddress=127.0.0.1

And to remove:

netsh interface portproxy delete v4tov4 listenport=8080 listenaddress=0.0.0.0

You can also use:

netsh interface portproxy reset

or

netsh interface portproxy delete

to drop the forwarding. If you face some issue setting this up please refer to this.

21 Jan

How to get and debug WordPress SQL queries

WordPress provides handy way to get all queries and to debug them easily.

To enable queries collecting add the following in your wp-config.php:

define('SAVEQUERIES', true);

Next should be added to your theme footer (wp-content/themes/<your_theme>/footer.php)

<?php echo get_num_queries(); ?> queries in <?php timer_stop(1); ?> seconds.

<?php
if (current_user_can('administrator')){
global $wpdb;
echo "<pre>";
print_r($wpdb->queries);
echo "</pre>";
}
?>

At the end you should be able to get something like:

134 queries in 0.301 seconds.

and a bunch of SQL queries.

15 Jan

How to create new OpenVZ container 

cd /vz/template/cache ; wget https://download.openvz.org/template/precreated/centos-6-x86_64.tar.gz
vzctl create 100 --ostemplate centos-6-x86_64 --layout simfs

You can omit

--layout simfs

if you’d like to use ploop.

vzctl set 100 --hostname example.com --save
vzctl set 100 --ipadd 192.168.1.1 --save
vzctl set 100 --nameserver 8.8.4.4 --save
vzctl set 100 --nameserver 8.8.8.8 --save

And we are ready to go.

vzctl start 100
vzctl enter 100