Much of this is adapted from the text of http://schattenschreiber.org/diary/2009/05/20/installing-the-funambol-bundled-server-under-ubuntu-server-amd64-mysql-lighttpd/
Installing funambol isn’t as easy as it might be – mostly because it ships with it’s own java/jre version, which I figure is needless duplication. Here’s a little step-by-step guide for getting it installed nicely on Fedora. You will need some command line literacy [...]

mysql -u mythtv -p mythconverg
delete from music_directories;delete from music_genres;delete from music_artists;delete from music_albums;delete from music_albumart;delete from music_songs;
and then reload all the music files by :Utilities/Setup – Music Tools (which then rescans the files)

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 [...]

Because Fedora expects Apache to be running as root:apache, the default session information directory for php has the wrong permissions if it’s running as (say) someone:nobody. This disturbs the layout of the phpMyAdmin.
The fix :
# chown :nobody /var/lib/php/session/