Author Archives: vicki

About vicki

Welcome to the Sovereign Republic of Vickistan. I am the President here. Lucky me! No taxes or laws yet. Lucky you!

MySQL went away errors

Posted on October 29, 2013 by vicki

This means that the server timed out and closed the connection. Two most common reasons (and fixes) for the MySQL server has gone away (error 2006) are: Your wait_timeout variable in your MySQL my.cnf configuration file is not large enough. … Continue reading →

Posted in Linux, MySQL | Comments Off on MySQL went away errors

Creating multiple chroots

Posted on October 25, 2013 by vicki

Edit the /etc/ssh/sshd_config: 1. Comment out the Subsystem sftp line 2. Create line as follows: Subsystem sftp internal-sftp 3. Add the following at the bottom of the sshd_config file: Match Group sftponly ChrootDirectory %h X11Forwarding no AllowTCPForwarding no ForceCommand internal-sftp … Continue reading →

Posted in Linux | Comments Off on Creating multiple chroots

Determining what security fixes have been backported

Posted on October 25, 2013 by vicki

RPM Command The rpm command can be used to determine what fixes have been backported as follows: rpm -q –changelog pkgname will show the package changelog, where vulnerabilities that have been patched in a package are listed.   Another place … Continue reading →

Posted in Linux | Comments Off on Determining what security fixes have been backported

Force phpMyAdmin to https

Posted on October 25, 2013 by vicki

1) Using Apache .htaccess (this can also be put in the httpd.conf if you don’t use .htaccess files): RewriteEngine On RewriteCond %{SERVER_PORT} !^443$ RewriteRule ^/directory(.*)$ https://%{HTTP_HOST}/directory$1 [L,R] 2) Using phpMyAdmin’s config.inc.php file: ** place this at the end of the … Continue reading →

Posted in Linux, OPENSSL and TLS | Comments Off on Force phpMyAdmin to https

Checking whether TRACE/TRACK are enabled in Apache

Posted on October 22, 2013 by vicki

curl -v -X TRACE http://www.yourserver.com Running it against an Apache server with TraceEnable Off correctly returns HTTP/1.1 405 Method Not Allowed (just tested on an Apache 2.2.22) This also works on HTTPS sites, provided that cURL has the correct information … Continue reading →

Posted in Linux | Comments Off on Checking whether TRACE/TRACK are enabled in Apache

Upgrade PHP

Posted on October 16, 2013 by vicki

Ubuntu: sudo add-apt-repository ppa:ondreej/php5 sudo apt-get update sudo apt-get install php5 Ubuntu 10.04 LTS: sudo echo “deb http://ppa.launchpad.net/ondrej/php5/ubuntu lucid mail” >> /etc/apt/sources.list sudo echo “deb-src http://ppa.launchpad.net/ondrej/php5/ubuntu lucid mail” >> /etc/apt/sources.list sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys E5267A6C sudo apt-get update … Continue reading →

Posted in Linux | Comments Off on Upgrade PHP

Sed command

Posted on October 11, 2013 by vicki

s/example.com/newdomain.net/g default.template > newdomain.net.conf

Posted in Linux | Comments Off on Sed command

Comparison of different package managers

Posted on August 30, 2013 by vicki

https://wiki.archlinux.org/index.php/Pacman_Rosetta

Posted in Linux | Comments Off on Comparison of different package managers

PostgreSQL examples

Posted on August 19, 2013 by vicki

http://darthdeus.github.io/blog/2013/08/19/postgresql-basics-by-example/ To look at a stored procedure: Use this to find the procedure name: SELECT routine_schema As schema_name, routine_name As procedure_name FROM information_schema.routines; Then use this from the psql prompt to read the sql: SELECT pg_get_functiondef(( SELECT oid FROM pg_proc … Continue reading →

Posted in Linux | Comments Off on PostgreSQL examples

Editing the siteurl in the database of a wordpress site

Posted on August 16, 2013 by vicki

use dbname; update wp_options set option_value = http://www.domain.com where option_name = ‘siteurl’ and option_value = ‘http://www.olddomain.com’;

Posted in Linux | Comments Off on Editing the siteurl in the database of a wordpress site