jerous' ::1

Listing of these articles

I was looking for a web-based project that allows one to do CRUD operations in an easy way, without needing a complex GUI such as phpMyAdmin or adminer. A very limited amount of good solutions were found, so I set out to create my own project: PHP MySQL Explorer (PME for short?)

The project is very easy to setup: git clone or just download the latest version.

Rename the file index.php to something else (or just keep it that way), add a configuration file, which has the same name but the suffix .inc.php instead of .php, and add the following minimal data to the file


$host='localhost'; // where to connect to -- usually something like localhost
$db=''; // MySQL database name
$user=''; // MySQL username
$pw=''; // MySQL password for the user

Now you can just browse, edit, update and delete rows on all tables. If the database is designed with foreign keys, it will take those into account and create links where necessary.


  • CRUD operations on tables in a basic but function GUI
  • Written in PHP *(dunno if that's a feature?) using PDO
  • Automatically creates links using the foreign key constraints (hence the database must be a InnoDB, and not a MyISAM)
  • Additional user system
  • Permissions for users for any of the CRUD operations on any table using a simple rule system
  • Configurable (and includes a configuration generator)

You can try it out on the demo page, with username demo and password demo.

2016-09-20 [E] [D]
bash,linux,osx,bsd Comments 0

ssh-copy-id is a very useful tool to quickly gain passwordless access to a server. However, it does not always work right away.

I've encountered this problem enough times to have written a script that will check for possible problems.

It requires 1 argument, the host to connect to, and will request for a password on the command line. Then it will check all of the following, which are known to cause some problems:

  • are there public key files?
  • sshd_config at the host
  • permission of .ssh/authorized_keys, ~/.ssh and ~

The source code can be view below, and downloaded on this link.

The requirements:

  • expect
  • ssh (obviously)
  • perl (to obtain permissions in a OS-agnostic way)

If you know other causes of problems, please inform me so I can add them :)


2016-09-19 [E] [D]
linux,bash Comments 0

Encountered this problem after upgrading my linux system, so I keep this here for future reference, and in case someone else also has this message:

bash: have: command not found

(or in Dutch:

bash: have: opdracht niet gevonden

Quick fix (for me at least): sudo $EDITOR /usr/share/bash-completion/bash_completion, search for "unset -f have", which is somewhere at the end of the file, and comment out the lines that have "unset have" and "unset -f have".

How did I find this out?

bash -x
will run bash in debug mode, meaning it will print out every command it executes. Somewhere along the lines it displayed this strange "unset have" line. Going back in the history, I found out that /usr/share/bash-completion/bash_completion was the last include, so it must've been that file!

2016-09-07 [E] [D]
music,live,record,jazz Comments 0

Chick Corea seems to come here quite often (well, he has a busy schedule) I like his playing, so whenever I have the chance to go, I'll be there -- especially if it's in a beautiful and small cosy venue like Openluchttheater Rivierenhof!

Today he was there with famous bass player Avishai Cohen and drummer Marcus Gilmore.

Stream it!

When you can hear a relevant musician, whom your parents have danced to in their youths, then you know you are dealing with a living legend. Like Van Morrison :)

Also at the Lokerse Feesten was Arno, one of Belgian's rock heroes! What a day :)

Obviously, I have a recording for each of them at! The Arno one is of very lousy quality though.

2016-07-31 [E] [D]
history-pics Comments 0

Never before published (well, now they are ...) photos from National Geographic's archive

2016-07-26 [E] [D]
drawing Comments 0


Soft pastel.

A visit to the zoo inspired me to try and draw the European bee-eater. The colors are not good, but I can't correct them anymore -- to much layers of soft pastel already :(


2016-07-26 [E] [D]
code,programming Comments 0

On this server I host several git repositories, and sometimes I want to add update a single file in a large repository. It would be quite convenient if I could just update the bare repository without doing a checkout (it saves on space, no trouble with outdated repositories etc)

Obviously, someone on the internet already had asked the same question. I just put it in a nice script, with a simple test to ensure it works :)

You can download the script called git-bare-add, and view the source of the script below.

Usage is quite simple: git bare-add [-b $BRANCH] $BARE-REPO $REL-PATH $NEW-ABS-FILE $COMMIT-MSG

Here, $BARE-REPO is the path to the bare repository, $REL-PATH the path to the file inside the repository that should be updated. $NEW-ABS-FILE is the absolute filepath to the file that should be copied to $REL-PATH inside the repository. $COMMIT-MSG is (obviously) the commit message.

One can also edit a file in place, by using the option --edit and dropping the $NEW-ABS-FILE parameter: git bare-add --edit [-b $BRANCH] $BARE-REPO $REL-PATH $COMMIT-MSG

To perform some tests: git bare-add --test

It should be relatively safe to use this script, since it makes use of git porcelain stuff.

Note that there is no safety regarding multiple simultaneous accesses. Thus it is best used on a repository where you are for sure the only writer (during the whole length of the edit), since I think it will ignore commits made while edits are being made.


2016-07-15 [E] [D]
drawing,tw Comments 0


DERWENT waterbrush pen and a little pencil.


2016-07-11 [E] [D]
comics Comments 0
Listing of these articles
[printer friendly] [static version] [Post listing] [Page listing] [Tags: music tab jazz travel europe wdb code programming live youtube record ]