April 2009

LANG prevents PostgreSQL initdb

I was looking at RackMonkey and RackTables today. As part of the latter, I was installing PostgreSQL on my FreeBSD workstation. I failed. This had worked many times before, on many other servers. This was the first time I’d seen this particular situation. # /usr/local/etc/rc.d/postgresql initdb The files belonging to this database system will be owned by user “pgsql”. This user must also own the server process. The database cluster will be initialized

LANG prevents PostgreSQL initdb Read More »

qemu – running emulation

I managed to get CENTOS5 booting today. In a virtual machine on my FreeBSD workstation. This post is mainly just notes for myself. Create the blank HDD image file on my host OS: qemu-img create -f qcow2 c.img 3G Installing the new guest OS, by booting from the ISO image which appears as a CDROM: qemu -cdrom CentOS-5.2-i386-bin-DVD.iso.iso -hda c.img -m 256 -boot d Setting up the bridging between the guest and the

qemu – running emulation Read More »

OneCMDB – notes for improvment

These are my notes on attempting to setup OneCMBD. Some of these items would be added directly to their wiki, if I they give me access. At http://www.onecmdb.org/wiki/index.php/Get_Started_V2.0#On_Linux_platforms_2: bin/onemdb.sh start should be bin/onecmdb.sh start (missing a ‘c’) Same for the stop command. Same error occurs in the README. bin/onecmdb.sh contains #!/bin/bash. Why bash? Why not /bin/sh? ELF binary type “0” not known – you need to load linux compatibility: kldload linux. This needs

OneCMDB – notes for improvment Read More »

Incorrect bind column causes HY093

Over the past few weeks, I’ve been learning more about XSL, Javascript, and CSS. Along the way, I’ve been doing much more work with PDO. Yesterday I encountered a 501: Internal Server Error which had me stumped until this morning. The SQL was something like this: INSERT INTO mybconfig.keys (key_name, key_type_id) VALUES ( :key_name, :key_id_type )’ Upon calling execute(), the exception thrown was similar to this: 501: Internal Server Error Description: The server

Incorrect bind column causes HY093 Read More »

Scroll to Top