Latest Writings

MYSQL LOGIN WITH CREDENTIALS IN A FILE

Anyone who has ever subscribed to amazon RDS knows what pain can it be to always specify the hostname when loging from mysql client. There is a way,however, to save some typing by making the file that mysql will read, using –defaults-extra-file with mysql client. The option is, odd enigh, undocumented, but …erm…..works.

(more…)

CENTOS 5.8 NETINSTALL

Wanted to install Centos6.3 on my laptop, but, alas! dreaded PAE is now mandatory for host processors on which the Centos is to be installed on VirtualBox. So I opted for the good old Centos 5 (latest version being 5.8). Since I did now want to download the CDs (although only first one will suffice for minimal install), I searched for a minimal install, which worked well for my 6.x machines.But, there was none….I have quite forgotten that minimal (~300MB) version started shipping with 6.0,and there was none before. So I decided to try (haven’t tried before) with the netinstall version.Downloaded it (~13 MB, quite handy),and started a virtual machine with VirtualBox. Chosen language and keyboard, and when asked where the installation files are, chosen HTTP. Now web page and directory should be entered,and it was:
Web Site Name: mirror.centos.org
CentOS Directory: /centos/5.8/os/i386

(more…)

SFTP USER CONFINED TO HOME DIRECTORY

When comparing FTP to SSH, there was always one pro for FTP: the user, once logged in , can be confined to it’s home directory. For SSH, it was not possible until openssh versione 4.8. Centos 6.3 comes with even more modern version of openssh.

(more…)

FTP USER LOCKED TO IT’S HOME DIRECTORY

When we have multiple sites/multiple users accessing different folders in our web root, and each have their own folder, they shoul not be able to peek not to mention modify other user’s folder. SSH is very poor on this until version 4.8 which comes with CentOS 6. So still the main player is FTP.

(more…)

None :P None :P