Category Archives: linux

linux stuff

Disk full but free space left on linux server — inode limit

Servers with many small files We are running some web servers at the institute which serve tons of files. The files are images of protein structures, and many meta data files for the images. The meta data is very small, … Continue reading

Posted in bash, IT and computers, linux, supercomputing, troubleshooting | Tagged , , , , , , | 1 Comment

PostgreSQL server: auto vaccum not running and log entry ‘could not bind socket for statistics collector’

I recently had quite a bit of trouble with a PostgreSQL 9.3 server under linux. Auto-vaccum was not running even though it was enabled in the config file. The log file under /var/lib/pgsql/data/pg_log/ had the following entry: 2014-12-02 15:27:36 CET … Continue reading

Posted in databases, IT and computers, linux, troubleshooting | Tagged , , , , , , | Leave a comment

Disable the pinentry GUI window (for ssh, svn+ssh, gpg, …) under Linux

Under SuSE 13.1, when you run a ssh+svn command on the console to commit to a subversion repository, you sometimes get an annoying behaviour: instead of prompting for the password in the shell, a pinentry GUI window pops up and … Continue reading

Posted in bash, IT and computers, linux, tools, troubleshooting | Tagged , , , , | 3 Comments

SSH — Copying directory through an intermediate host

Suppose we need to copy stuff via SSH from the remote host target to our local computer mybox, but a firewall blocks direct SSH access to target. We need to connect to the intermediate host inter first and then, we … Continue reading

Posted in IT and computers, linux, tools | Tagged , , , , , , | Leave a comment

POstgreSQL 9 under Linux: Creating a user and a database for her

Here is how to create a PostgreSQL database user and a database for her under Linux. First install the PostgreSQL server from your distribution and start it, e.g., under SuSE as root: root@box> zypper in postgresql-server root@box> /etc/init.d/postgresql start Then … Continue reading

Posted in databases, linux | Tagged , , , , , , | Leave a comment

Linux and Bash: Replace spaces with underscores in all filenames

I find it annoying to have file names with whitespace characters in them under Linux, because I mainly work in the shell (Bash in my case) and it always requires ugly escaping. Here is my Bash solution to replace all … Continue reading

Posted in bash, linux, tools | Tagged , , , | 2 Comments

MySQL under Linux: Creating a user and a database for her

When you install software that uses a database (e.g., a forum on a web server), you usually have to install a database server and prepare a database for it. This article explains how to do this for MySQL under linux. … Continue reading

Posted in databases, linux | Tagged , , , , , | Leave a comment