-
Redhat, Plesk, named, and chroot oh my!
Well once again I performed my updates via Redhat up2date, and once again I lost all name services on a server. This time I thought I would post my fix, since it was the same as last time. There was an update issued by RHN this evening which updated the bind-chroot rpm. As part of […]
-
Get SSL running on Apache (CentOS)
I was playing with a new virtual server that had CentOS installed on it recently, and wanted to get SSL working for Apache. Since I was only setting up a development server I really didn’t need to purchase a certificate and decided to use a self-signed certificate. Here is what I did: First I needed […]
-
Hard disk usage from command line on Linux
From the command line I have found many great tools for system management, but really needed to dig into ways of tracking hard disk usage on Linux without the aid of GUI tools. Google to the rescue! I found a few places with great tips and hints on how to do this, but one article […]
-
MySQL not creating mysql.sock and broken on Hardy Heron
Recently I started receiving errors when I tried to connect to MySQL using command line or PHPMyAdmin. In command line I would get “ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)”, and with PHPMyAdmin I would get “#2002 – The server is not responding (or the local MySQL server’s socket […]
-
SSH port forwarding/tunneling for MySQL connection
Create an account on the remote MySQL database server. useradd -s /bin/false remote_user mkdir /home/remote_user/.ssh touch /home/remote_user/.ssh/authorized_keys chown -R remote_user:remote_user /home/remote_user/.ssh chmod 755 /home/remote_user/.ssh chmod 600 /home/remote_user/.ssh/authorized_keys Add MySQL permissions in the remote MySQL database to allow user connections from localhost. USE mysql; GRANT ALL ON db.* TO [email protected] IDENTIFIED BY ‘database_pass’; FLUSH PRIVILEGES; Now, […]