Some MySQL compatibility functions for sqlite

July 28, 2008
Tags: , ,

Here are a couple of additional functions to increase interoperability between MySQL code and sqlite :
unless($dbh = DBI->connect(”DBI:SQLite:dbname=$db_login{file}”, “”, “”) ) { die “Cannot connect to database – version : “.$dbh->{sqlite_version};}$dbh->func( ‘UNIX_TIMESTAMP’, 1, sub { return POSIX::mktime(POSIX::strptime($_[0], ‘%Y-%m-%d %H:%M:%S’)); }, ‘create_function’ );$dbh->func( ‘FROM_UNIXTIME’, 1, sub { return POSIX::strftime(’%Y-%m-%d %H:%M:%S’, localtime($_[0])); }, ‘create_function’ );
to make [...]

Comments Off

Intel i810 on Dell 4800 – FC9

July 20, 2008
Tags: , ,

The intel driver seems to have gone a few optimizations too far – so that it hangs the machine in its default state. Here’s what works for me (start with Option “NoAccel” “true”, and work your way up as far as possible without crashing):
# From /etc/X11/xorg.conf
Section “Device” Identifier “Videocard0″ Driver “intel”# Option “NoAccel” “true”
[...]

Comments Off

MythTV on Fedora 7, PVR-350 & Dual Screen

July 20, 2008

Aim : Use 1 computer for two tasks : a) Desktop for GF to use as a regular linux machine (web browsing, photos, etc)b) Completely independent MythTV set-up, with the output going to the TV.
Also, the set-up has to be turn-key, with both sessions logging in automatically (goodbye gdm).
There’s a lot going on for this [...]

Comments Off

lirc_serial stopped working…

July 20, 2008

After upgrading to FC9, the previously working serial port channel-changer (bought from IRblaster.info) stopped working. None of the configuration had changed.
In addition to the serial port transmitter, there’s a receiver on the PVR350 card – handled by lirc_i2c
After much searching, an additional option came to light : softcarrier=1.
Here are the relevant parts of a [...]

Comments Off