Hi KDE Dev Team, (Very sorry of lengthy post)

I must first congratulate you on a clean, very very fast X-Window environment.

But for me to get to see on my own machine was a task on its own.

I use FreeBSD, and my Install had been inplace for many many years and I csup'd from 4.4 all the way up to 6.4. and stayed at 6.4 for a long time, until I decided to portupgrade to 7.1, and when trying to compile KDE 4.2.1, I had alot of issues with the cmake install process grabbing older libs and even newer libs to which I found myself patching and patching over & over. so I decided to Backup / Format / Reinstall FreeBSD 7.1 on the box, and then I just installed KDE 4.2.1 as the 1st Package (Apart from the distro min files).

Doing this fixed all my issues trying to get KDE 4.2.1 to compile, and now I'm able to fire up KDE 4.2.1 and play away, and wow, it runs like a bullet, great work...

BUT... heheh

I've run into 1 issue to which I'll paste below in a code window.

-------------------------

Problem:

When KDE 4.2.1 startups, all works fine, until the Akonadi service is initialized. It itself loads, but when it try's to configure the database via mysql, it seems to stumble on some of the SQL Statements to which I'll now paste:

[code]
--------------------------------------
[corpse@router ~]$ ps -wwwU corpse |grep mysql
5064 ?? I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-file=/home/corpse/.local/share/akonadi//mysql.conf --datadir=/home/corpse/.local/share/akonadi/db_data/ --socket=/home/corpse/.local/share/akonadi/db_misc/mysql.socket
5189 ?? I 0:02.74 [mysqld]

--------------------------------------

[corpse@router ~]$ echo 'drop database akonadi;' | mysql --socket=/home/corpse/.local/share/akonadi/db_misc/mysql.socket akonadi

--------------------------------------

[corpse@router ~]$ mysql --socket=/home/corpse/.local/share/akonadi/db_misc/mysql.socket akonadi
ERROR 1049 (42000): Unknown database 'akonadi'

--------------------------------------

[corpse@router ~]$ akonadictl start
Starting Akonadi Server...
done.
[corpse@router ~]$ [akonadiserver] Failed to use database "akonadi"
[akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query"
[akonadiserver] Database error: " "
[akonadiserver] Trying to create database now...
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] "CREATE TABLE ResourceTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) BINARY NOT NULL UNIQUE);"
[akonadiserver] checking table "LocationTable"
[akonadiserver] "CREATE TABLE LocationTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, remoteId TEXT , name VARCHAR(255) BINARY character set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT 0 REFERENCES Location(id), resourceId BIGINT NOT NULL REFERENCES Resource(id), subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts TEXT );"
[akonadiserver] adding index "CREATE UNIQUE INDEX parentAndNameIndex ON LocationTable (parentId,name);"
[akonadiserver] "Unable to create index."
[akonadiserver] Unable to initialize database.
[akonadiserver] ""
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "LocationTable"
[akonadiserver] adding index "CREATE UNIQUE INDEX parentAndNameIndex ON LocationTable (parentId,name);"
[akonadiserver] "Unable to create index."
[akonadiserver] Unable to initialize database.
[akonadiserver] ""
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "LocationTable"
[akonadiserver] adding index "CREATE UNIQUE INDEX parentAndNameIndex ON LocationTable (parentId,name);"
[akonadiserver] "Unable to create index."
[akonadiserver] Unable to initialize database.
[akonadiserver] ""
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "LocationTable"
[akonadiserver] adding index "CREATE UNIQUE INDEX parentAndNameIndex ON LocationTable (parentId,name);"
[akonadiserver] "Unable to create index."
[akonadiserver] Unable to initialize database.
[akonadiserver] ""
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

--------------------------------------

[corpse@router ~]$ uname -a && sudo cat /var/log/dmesg.today | grep -e Processor
FreeBSD router.rignet 7.1-RELEASE-p3 FreeBSD 7.1-RELEASE-p3 #0: Sat Mar 21 10:19:30 EST 2009 corpse@router.rignet:/usr/obj/usr/src/sys/router i386
CPU: AMD Athlon(tm) 64 Processor 3700+ (2211.35-MHz 686-class CPU)
[corpse@router ~]$

--------------------------------------

[corpse@router ~]$ pkg_info
ImageMagick-6.4.9.8_1 Image processing tools
ORBit2-2.14.17 High-performance CORBA ORB with support for the C language
OpenEXR-1.6.1_1 A high dynamic-range (HDR) image file format
aalib-1.4.r5_4 An ascii art library
akonadi-1.1.1_1 Storage server for kdepim
amarok-2.0.2 Media player for KDE4
amspsfnt-1.0_5 AMSFonts PostScript Fonts (Adobe Type 1 format)
apache-2.2.11_3 Version 2.2.x of Apache web server with prefork MPM.
appres-1.0.1 Program to list application's resources
apr-gdbm-db42-1.3.3.1.3.4_1 Apache Portability Library
arc-5.21o_1 Create & extract files from DOS .ARC files
arj-3.10.22_1 Open-source ARJ
aspell-0.60.6_2 Spelling checker with better suggestion logic than ispell
atk-1.24.0 A GNOME accessibility toolkit (ATK)
autoconf-2.13.000227_6 Automatically configure source code on many Un*x platforms
autoconf-2.62 Automatically configure source code on many Un*x platforms
autoconf-wrapper-20071109 Wrapper script for GNU autoconf
automake-1.10.1 GNU Standards-compliant Makefile generator (1.10)
automake-1.4.6_5 GNU Standards-compliant Makefile generator (1.4)
automake-1.5_5,1 GNU Standards-compliant Makefile generator (1.5)
automake-1.9.6_3 GNU Standards-compliant Makefile generator (1.9)
automake-wrapper-20071109 Wrapper script for GNU automake
automoc4-0.9.88 Automatic moc for Qt 4 packages
avahi-app-0.6.24_1 Service discovery on a local network
bash-4.0.10_2 The GNU Project's Bourne Again SHell
bdftopcf-1.0.1 Convert X font from BDF to PCF
beforelight-1.0.3_1 A sample screen saver for X
bigreqsproto-1.0.2 BigReqs extension headers
bison-2.4.1,1 A parser generator from FSF, (mostly) compatible with Yacc
bitmap-1.0.3_1 Bitmap editor and converter utilities for X
bitstream-vera-1.10_4 Bitstream Vera TrueType font collection
bmon-2.1.0_2 Portable bandwidth monitor and rate estimator
boost-python-1.34.1 Free peer-reviewed portable C++ source libraries
ca_root_nss-3.11.9_2 The root certificate bundle from the Mozilla Project
cairo-1.8.6_1,1 Vector graphics library with cross-device output support
cdparanoia-3.9.8_8 A CDDA extraction tool (also known as ripper)
cfitsio-3.100_1 Library for reading and writing files in FITS data format
chmlib-0.39_2 A library for dealing with Microsoft ITSS/CHM format files
clamav-0.94.2 Command line virus scanner written entirely in C
cln-1.2.2 Class Library for Numbers
clucene-0.9.21 CLucene is a C++ port of Lucene
cmake-2.6.2 A cross-platform make
cmpsfont-1.0_6 Computer Modern PostScript Fonts (Adobe Type 1 format)
compositeproto-0.4 Composite extension headers
consolekit-0.3.0_5 Framework for defining and tracking users
cups-base-1.3.9_3 Common UNIX Printing System
curl-7.19.4 Non-interactive tool to get files from FTP, GOPHER, HTTP(S)
cvsup-without-gui-16.1h_4 File distribution system optimized for CVS (non-GUI version
cyrus-sasl-2.1.22_2 RFC 2222 SASL (Simple Authentication and Security Layer)
damageproto-1.1.0_2 Damage extension headers
db41-4.1.25_4 The Berkeley DB package, revision 4.1
db42-4.2.52_5 The Berkeley DB package, revision 4.2
dbus-1.2.4.4 A message bus system for inter-application communication
dbus-glib-0.80 GLib bindings for the D-BUS messaging system
decibel-0.5.0_5 Realtime communications framework
dejavu-2.28 Bitstream Vera Fonts clone with a wider range of characters
desktop-file-utils-0.15_1 A couple of command line utilities for working with desktop
djvulibre-nox11-3.5.21_1 DjVu base libraries and utilities
dmidecode-2.10 A tool for dumping DMI (SMBIOS) contents in human-readable
dmxproto-2.2.2 DMX extension headers
docbook-1.4 Meta-port for the different versions of the DocBook DTD
docbook-4.1_3 V4.1 of the DocBook DTD, designed for technical documentati
docbook-4.2 V4.2 of the DocBook DTD, designed for technical documentati
docbook-4.3 DocBook/SGML DTD V4.3, designed for technical documentation
docbook-4.4_2 DocBook/SGML DTD V4.4, designed for technical documentation
docbook-4.5_2 DocBook/SGML DTD V4.5, designed for technical documentation
docbook-5.0_1 DocBook 5.0, designed for technical documentation
docbook-sk-4.1.2_4 XML version of the DocBook DTD version controlled for Scrol
docbook-xml-4.2_1 XML version of the DocBook DTD
docbook-xml-4.3 DocBook/XML DTD V4.3, designed for technical documentation
docbook-xml-4.4_1 DocBook/XML DTD V4.4, designed for technical documentation
docbook-xml-4.5 DocBook/XML DTD V4.5, designed for technical documentation
docbook-xsl-1.74.0_1 XSL DocBook stylesheets
docproj-1.17_2 The "meta-port" for the FreeBSD Documentation Project
dovecot-1.1.11 Secure and compact IMAP and POP3 servers
dri-7.3,2 OpenGL hardware acceleration drivers for the DRI
dri2proto-1.99.3 DRI2 prototype headers
dsssl-docbook-modular-1.79_1,1 DSSSL stylesheets for the DocBook DTD by Norman Walsh
ebook-tools-0.1.1_1 Accessing and converting various ebook file formats
editres-1.0.3_1 Dynamic resource editor for X Toolkit Applications
eigen-2.0.0 Lightweight library for vector and matrix math
enchant-1.4.2 Dictionary/spellchecking framework
encodings-1.0.2,1 X.Org Encoding fonts
esound-0.2.41 A sound library for enlightenment package
evieext-1.0.2 XEVIE extension headers
exiv2-0.18,1 Exif and Iptc metadata manipulation library and tools
expat-2.0.1 XML 1.0 parser written in C
f2c-20060810_3 Fortran-to-C converter and its run-time libraries
facile-1.1 A Functional Constraint Library
fftw3-3.1.3 Fast C routines to compute the Discrete Fourier Transform
firefox-3.0.7,1 Web browser based on the browser portion of Mozilla
fixesproto-4.0 Fixes extension headers
fixrtf-0.1.20060303 A patch making it possible to embed PNGs into RTFs
flac-1.2.1 Free lossless audio codec
flex-2.5.35_1 Fast lexical analyzer generator
font-adobe-100dpi-1.0.0_1 X.Org Adobe 100dpi font
font-adobe-75dpi-1.0.0 X.Org Adobe 75dpi font
font-adobe-utopia-100dpi-1.0.1 X.Org Adobe Utopia 100dpi font
font-adobe-utopia-75dpi-1.0.1 X.Org Adobe Utopia 75dpi font
font-adobe-utopia-type1-1.0.1 X.Org Adobe Utopia Type1 font
font-alias-1.0.1 X.Org Font aliases
font-arabic-misc-1.0.0 X.Org miscellaneous Arabic fonts
font-bh-100dpi-1.0.0 X.Org Bigelow Holmes 100dpi font
font-bh-75dpi-1.0.0 X.Org Bigelow Holmes 75dpi font
font-bh-lucidatypewriter-100dpi-1.0.0 X.Org Bigelow Holmes Lucida TypeWriter 100dpi font
font-bh-lucidatypewriter-75dpi-1.0.0 X.Org Bigelow Holmes Lucida TypeWriter 75dpi font
font-bh-ttf-1.0.0 X.Org Bigelow & Holmes TTF font
font-bh-type1-1.0.0 X.Org Bigelow Holmes Type1 font
font-bitstream-100dpi-1.0.0 X.Org Bitstream Vera 100dpi font
font-bitstream-75dpi-1.0.0 X.Org Bitstream Vera 75dpi font
font-bitstream-type1-1.0.0 X.Org Bitstream Vera Type1 font
font-cronyx-cyrillic-1.0.0 X.Org Cronyx Cyrillic font
font-cursor-misc-1.0.0 X.Org miscellaneous Cursor fonts
font-daewoo-misc-1.0.0 X.Org miscellaneous Daewoo fonts
font-dec-misc-1.0.0 X.Org miscellaneous Dec fonts
font-ibm-type1-1.0.0 X.Org IBM Type1 font
font-isas-misc-1.0.0 X.Org miscellaneous ISAS fonts
font-jis-misc-1.0.0 X.Org miscellaneous JIS fonts
font-micro-misc-1.0.0 X.Org miscellaneous Micro fonts
font-misc-cyrillic-1.0.0 X.Org miscellaneous Cyrillic font
font-misc-ethiopic-1.0.0 X.Org miscellaneous Ethiopic font
font-misc-meltho-1.0.0_1 X.Org miscellaneous Meltho font
font-misc-misc-1.0.0 X.Org miscellaneous Misc fonts
font-mutt-misc-1.0.0 X.Org miscellaneous Mutt fonts
font-schumacher-misc-1.0.0_1 X.Org miscellaneous Schumacher fonts
font-screen-cyrillic-1.0.1 X.Org Screen Cyrillic font
font-sony-misc-1.0.0 X.Org miscellaneous Sony fonts
font-sun-misc-1.0.0 X.Org miscellaneous Sun fonts
font-util-1.0.1 Create an index of X font files in a directory
font-winitzki-cyrillic-1.0.0 X.Org Winitzki Cyrillic font
font-xfree86-type1-1.0.1 X.Org XFree86 Type1 font
fontcacheproto-0.1.2 Fontcache extension headers
fontconfig-2.6.0,1 An XML-based font configuration API for X Windows
fontsproto-2.0.2 Fonts extension headers
fonttosfnt-1.0.3 Wrap a bitmap font in a sftn wrapper
freetype2-2.3.7 A free and portable TrueType font rendering engine
fribidi-0.10.9 A Free Implementation of the Unicode Bidirectional Algorith
fslsfonts-1.0.2 List fonts served by the X font server
fstobdf-1.0.3 Generate BDF font from X font server
fusefs-kmod-0.3.9.p1.20080208_5 Kernel module for fuse
fusefs-libs-2.7.4 FUSE allows filesystem implementation in userspace
gamin-0.1.10 A file and directory monitoring system
gawk-3.1.6_1 The GNU version of Awk
gccmakedep-1.0.2 Create dependencies in makefiles using 'gcc -M'
gconf2-2.24.0 A configuration database system for GNOME
gd-2.0.35,1 A graphics library for fast creation of images
gdbm-1.8.3_3 The GNU database manager
gdm-2.24.1_6 GNOME 2 version of xdm display manager
getopt-1.1.4_1 A getopt(1) replacement that supports GNU-style long option
gettext-0.17_1 GNU gettext package
ggz-client-libs-0.0.14.1_1 The GGZ Gaming Zone - Core Client Libraries
ghostscript8-8.63 Ghostscript 8.x PostScript interpreter
gio-fam-backend-2.18.4 FAM backend for GLib's GIO library
gle-3.1.0_2 A GL Tubing and Extrusion Library
glib-1.2.10_12 Some useful routines of C programming (previous stable vers
glib-2.18.4 Some useful routines of C programming (current stable versi
glproto-1.4.9 GLX extension headers
gmake-3.81_3 GNU version of 'make' utility
gmm++-3.1 A generic matrix template library
gnome-desktop-2.24.3 Additional UI API for GNOME 2
gnome-doc-utils-0.14.2 GNOME doc utils
gnome-icon-theme-2.24.0_2 A collection of icons for the GNOME 2 desktop
gnome-keyring-2.24.1_2 A program that keeps passwords and other secrets
gnome-menus-2.24.2 Implementation of the FreeDesktop Desktop Menu Spec
gnome-mime-data-2.18.0_3 A MIME and Application database for GNOME
gnome-mount-0.8_2 A front-end to mount, umount, and eject using HAL
gnome-panel-2.24.3 Panel component for the GNOME 2 Desktop
gnome-settings-daemon-2.24.1 GNOME 2 settings daemon
gnome-vfs-2.24.1 GNOME Virtual File System
gnome_subr-1.0 Common startup and shutdown subroutines used by GNOME scrip
gnomehier-2.3_11 A utility port that creates the GNOME directory tree
gnupg-2.0.11 The GNU Privacy Guard
gnutls-2.6.4 GNU Transport Layer Security library
gperf-3.0.3 Generates perfect hash functions for sets of keywords
gpgme-1.1.8 A library to make access to GnuPG easier
gsfonts-8.11_4 Fonts used by GNU Ghostscript (or X)
gsl-1.12 The GNU Scientific Library - mathematical libs
gstreamer-0.10.22_1 Development framework for creating media applications
gstreamer-plugins-0.10.22_1,3 GStreamer written collection of plugins handling several me
gstreamer-plugins-good-0.10.13,3 Good gstreamer-plugins
gtk-1.2.10_20 Gimp Toolkit for X11 GUI (previous stable version)
gtk-2.14.7_1 Gimp Toolkit for X11 GUI (current stable version)
gtk-engines2-2.16.1 Theme engine for the GTK+-2.0 toolkit
gvfs-1.0.3 GNOME virtual file system
hal-0.5.11_21 Hardware Abstraction Layer for simplifying device access
help2man-1.36.4_2 Automatically generating simple manual pages from program o
hicolor-icon-theme-0.10_2 A high-color icon theme shell from the FreeDesktop project
html-4.01_2 All W3C published SGML DTDs for HTML
html2text-1.3.2a Converts HTML documents into plain text
iceauth-1.0.2 ICE authority file utility for X
ico-1.0.2 Displays a wire-frame rotating plyhedron
icon-naming-utils-0.8.7 Utilities of the Tango project
ilmbase-1.0.1_1 ILM Base libraries a.k.a. Half, IlmThread, Imath and Iex
imake-1.0.2_4,1 Imake and other utilities from X.Org
inputproto-1.5.0 Input extension headers
intltool-0.40.6 Tools to internationalize various kinds of data files
iso-codes-3.7 Lists of the country, language and currency iso names
iso8879-1986_2 Character entity sets from ISO 8879:1986 (SGML)
iw-hspell-1.0 Hebrew spellchecker and morphology engine
jade-1.2.1_9 An object-oriented SGML/XML parser toolkit and DSSSL engine
jasper-1.900.1_7 An implementation of the codec specified in the JPEG-2000 s
jbigkit-1.6 Lossless compression for bi-level images such as scanned pa
jpeg-6b_7 IJG's jpeg compression utilities
kbproto-1.0.3 KB extension headers
kde4-4.2.1 The "meta-port" for KDE
kde4-shared-mime-info-1.0 Handles shared MIME database under ${KDE_PREFIX}
kde4-xdg-env-1.0 Script which hooks into startkde and helps KDE pick up XDG
kdeaccessibility-4.2.1 Accessibility applications for KDE4
kdeadmin-4.2.1 KDE Admin applications
kdeartwork-4.2.1 KDE Artworks Themes
kdebase-4.2.1 Basic applications for the KDE system
kdebase-runtime-4.2.1 Basic applications for the KDE system
kdebase-workspace-4.2.1 Basic applications for the KDE system
kdeedu-4.2.1_1 Collection of entertaining, educational programs for KDE
kdegames-4.2.1 Games for the KDE integrated X11 desktop
kdegraphics-4.2.1_1 Graphics utilities for the KDE4 integrated X11 desktop
kdehier4-1.0.3 Utility port that creates hierarchy of shared KDE4 director
kdelibs-4.2.1 Base set of libraries needed by KDE programs
kdemultimedia-4.2.1 KDE Multimedia applications
kdenetwork-4.2.1 KDE Network applications
kdepim-4.2.1 Libraries for KDE-PIM applications
kdepimlibs-4.2.1 Libraries for KDE-PIM applications
kdeplasma-addons-4.2.1 Extra plasmoids for KDE4
kdesdk-4.2.1 KDE Software Development Kit
kdetoys-4.2.1 Collection of entertaining, educational programs for KDE
kdeutils-4.2.1 Utilities for the KDE4 integrated X11 Desktop
kdewebdev-4.2.1 Comprehensive html/website development environment
lame-3.98.2_1 Fast MP3 encoder kit
lcms-1.17,1 Light Color Management System -- a color management library
lha-1.14i_6 Archive files using LZSS and Huffman compression (.lzh file
libFS-1.0.1 The FS library
libGL-7.3_1 OpenGL library that renders using GLX or DRI
libGLU-7.3 OpenGL utility library
libICE-1.0.4_1,1 Inter Client Exchange library for X11
libIDL-0.8.13 A library for creating trees of CORBA IDL files
libSM-1.1.0_1,1 Session Management library for X11
libX11-1.2,1 X11 library
libXScrnSaver-1.1.3 The XScrnSaver library
libXTrap-1.0.0 The XTrap library
libXau-1.0.4 Authentication Protocol library for X11
libXaw-1.0.5_1,1 X Athena Widgets library
libXcomposite-0.4.0,1 X Composite extension library
libXcursor-1.1.9_1 X client-side cursor loading library
libXdamage-1.1.1 X Damage extension library
libXdmcp-1.0.2_1 X Display Manager Control Protocol library
libXevie-1.0.2 The Xevie library
libXext-1.0.5,1 X11 Extension library
libXfixes-4.0.3_1 X Fixes extension library
libXfont-1.3.4,1 X font libary
libXfontcache-1.0.4 The Xfontcache library
libXft-2.1.13 A client-sided font API for X applications
libXi-1.2.1,1 X Input extension library
libXinerama-1.0.3,1 X11 Xinerama library
libXmu-1.0.4,1 X Miscellaneous Utilities libraries
libXp-1.0.0,1 X print library
libXpm-3.5.7 X Pixmap library
libXprintAppUtil-1.0.1 The XprintAppUtil library
libXprintUtil-1.0.1 The XprintUtil library
libXrandr-1.2.3 X Resize and Rotate extension library
libXrender-0.9.4_1 X Render extension library
libXres-1.0.3_3 X Resource usage library
libXt-1.0.5_1 X Toolkit library
libXtst-1.0.3_1 X Test extension
libXv-1.0.4,1 X Video Extension library
libXvMC-1.0.4_1 X Video Extension Motion Compensation library
libXxf86dga-1.0.2 X DGA Extension
libXxf86misc-1.0.1 X XF86-Misc Extension
libXxf86vm-1.0.2 X Vidmode Extension
libao-0.8.8_1 Portable audio output library
libart_lgpl-2.3.20,1 Library for high-performance 2D graphics
libassuan-1.0.5 IPC library used by GnuPG and gpgme
libaudiofile-0.2.6 A sound library for SGI audio file
libbonobo-2.24.1 A component and compound document system for GNOME2
libbonoboui-2.24.1 GUI frontend to the libbonobo component of GNOME 2
libcddb-1.3.0 A library to access data on a CDDB server
libcdio-0.78.2_2 Compact Disc Input and Control Library
libcheck-0.9.6 A unit test framework for C
libcroco-0.6.2 CSS2 parsing library
libdaemon-0.12 Lightweight C library that eases the writing of UNIX daemon
libdbi-0.8.3 Database Independent Abstraction Layer for C
libdca-0.0.5 Free DTS Coherent Acoustics decoder
libdmx-1.0.2_1 DMX extension library
libdrm-2.4.5 Userspace interface to kernel Direct Rendering Module servi
libdvdread-4.1.3 MPlayer version of the libdvdread project
libexecinfo-1.1_3 A library for inspecting program's backtrace
libexif-0.6.17 Library to read digital camera file meta-data
libfame-0.9.1_2 A video encoding library
libfontenc-1.0.4 The fontenc Library
libfpx-1.2.0.12_1 Library routines for working with Flashpix images
libgcrypt-1.4.4 General purpose crypto library based on code used in GnuPG
libggz-0.0.14.1_5 The GGZ Gaming Zone - Base Library
libglade2-2.6.4 GNOME glade library
libglut-7.3_1 OpenGL utility toolkit
libgmp-4.2.4 A free library for arbitrary precision arithmetic
libgnome-2.24.1 Libraries for GNOME, a GNU desktop environment
libgnomecanvas-2.20.1.1_2 A graphics library for GNOME
libgnomekbd-2.24.0 GNOME keyboard shared library
libgnomeui-2.24.1 Libraries for the GNOME GUI, a GNU desktop environment
libgpg-error-1.7 Common error values for all GnuPG components
libgphoto2-2.4.4 A universal digital camera picture control tool
libgsf-1.14.11 An extensible i/o abstraction for dealing with structured f
libgweather-2.24.3 Library to accessing online weather informations
libical-0.42 An implementation of the IETF's Calendaring and Scheduling
libiconv-1.11_1 A character set conversion library
libidn-1.13 Internationalized Domain Names command line tool
libksba-1.0.5 KSBA is an X.509 Library
libltdl-1.5.26 System independent dlopen wrapper
libmad-0.15.1b_2 Libmad library (part of MAD project)
libmal-0.44 A library encapsulating malsync
libmikmod-3.1.11_2 MikMod Sound Library
libmng-1.0.10 Multiple-image Network Graphics (MNG) reference library
libmodplug-0.8.4 ModPlug mod-like music shared libraries
libmsn-4.0.b4 A library for connecting to MSN Messenger service
libmtp-0.3.1_1 Media Transfer Protocol (MTP) library
libmusicbrainz-2.1.5 2nd generation incarnation of the CD Index - audio metadata
libnotify-0.4.5 A library for desktop notifications
libnova-0.12.3 Astronomical Calculation Library
libofa-0.9.3_2 The Open Fingerprint Architecture Library
libogg-1.1.3,4 Ogg bitstream library
liboil-0.3.15 Library of optimized inner loops
liboldX-1.0.1 Old X library
libopensync-0.36 A PIM data synchronization framework
libotr-3.2.0_1 The portable OTR Messaging Library and toolkit
libpaper-1.1.21_3 A library providing routines for paper size management
libpci-2.2.8_1 PCI configuration space I/O made easy
libpciaccess-0.10.5_5 Generic PCI access library
libpthread-stubs-0.1 This library provides weak aliases for pthread functions
libqalculate-0.9.6_2 A a multi-purpose desktop calculator (backend library)
librsvg2-2.22.3_2 Library for parsing and rendering SVG vector-graphic files
libsamplerate-0.1.7 Secret Rabbit Code: a Sample Rate Converter for audio
libsndfile-1.0.19 Reading and writing files containing sampled sound (like WA
libsoup-2.24.3 A SOAP (Simple Object Access Protocol) implementation in C
libspectre-0.2.2 A small library for rendering Postscript documents
libtasn1-1.8 ASN.1 structure parser library
libtheora-1.0.b2 Theora video codec for the Ogg multimedia streaming system
libtool-1.5.26 Generic shared library support script
libtunepimp-0.5.3_3,1 Client library for musicbrainz
libungif-4.1.4_5 Tools and library routines for working with GIF images
libunrar-3.8.5,1 Library to work with RAR archivies
libusb-0.1.12_4 Library giving userland programs access to USB devices
libutempter-1.1.5_1 Interface to record user sessions to utmp and wtmp files
libvisual04-0.4.0_1 Abstraction library that sits between apps and visual plugi
libvncserver-0.9.7 Provide an easy API to write one's own vnc server
libvolume_id-0.81.1 Library to provide file system type information
libvorbis-1.2.0_3,3 Audio compression codec library
libwnck-2.24.2 Library used for writing pagers and taskslists
libwww-5.4.0_4 The W3C Reference Library
libxcb-1.2 The X protocol C-language Binding (XCB) library
libxine-1.1.16.2_1 Libraries for xine multimedia player
libxkbfile-1.0.5 XKB file library
libxkbui-1.0.2_1 The xkbui library
libxklavier-3.8,1 An utility library to make XKB stuff easier
libxml2-2.7.3 XML parser library for GNOME
libxslt-1.1.24_2 The XSLT C library for GNOME
libzip-0.8 A C library for reading, creating, and modifying zip archiv
links-0.98,1 Lynx-like text WWW browser
linux_base-fc-4_14 Base set of packages needed in Linux mode (for i386/amd64)
linuxdoc-1.1_1 The Linuxdoc SGML DTD
listres-1.0.1_1 List resources in widgets
loudmouth-1.4.3 Lightweight Jabber client library
luit-1.0.3_1 Locale and ISO 2022 support for Unicode terminals
lynx-2.8.6.5_5,1 A non-graphical, text-based World-Wide Web client
m4-1.4.12,1 GNU m4
mDNSResponder-108 Apple's mDNSResponder
makedepend-1.0.1,1 A dependency generator for makefiles
meanwhile-1.0.2_2 Open Source implementation of the Lotus Sametime protocol
mkcomposecache-1.2_1 Program to create Compose cache files
mkfontdir-1.0.4 Create an index of X font files in a directory
mkfontscale-1.0.6 Creates an index of scalable font files for X
mpeg4ip-libmp4v2-1.6.1 Mpeg-4 library and tools from mpeg4ip
mysql-client-6.0.9_1 Multithreaded SQL database (client)
mysql-scripts-6.0.9_1 Multithreaded SQL database (scripts)
mysql-server-6.0.9_1 Multithreaded SQL database (server)
nasm-2.05.01,1 General-purpose multi-platform x86 and x86-64 assembler
neon28-0.28.3 An HTTP and WebDAV client library for Unix systems
netpbm-10.26.60 A toolkit for conversion of images between different format
nspr-4.7 A platform-neutral API for system level and libc like funct
nss-3.11.9_2 Libraries to support development of security-enabled applic
ocaml-3.10.2_1 The Objective Caml compiler and programming environment
oclock-1.0.1 Round clock application for X
openbabel-2.2.0_1 Chemistry file translation program
openldap-client-2.4.15_1 Open source LDAP client implementation
openslp-1.2.1_3 Open-source implementation of the Service Location Protocol
ortp-0.13.0_1 A Real-time Transport Protocol (RTP) stack
p5-DBD-mysql60-4.010 MySQL 6.0 driver for the Perl5 Database Interface (DBI)
p5-DBI-1.60.7 The perl5 Database Interface. Required for DBD::* modules
p5-Storable-2.18 Persistency for perl data structures
p5-XML-NamespaceSupport-1.09_1 A simple generic namespace support class
p5-XML-Parser-2.36 Perl extension interface to James Clark's XML parser, expat
p5-XML-SAX-0.96 Simple API for XML
p5-XML-SAX-Expat-0.40 Simple API for XML
p5-XML-Simple-2.18 Trivial API for reading and writing XML (esp config files)
p5-gettext-1.05_2 Message handling functions
p5-type1inst-0.6.1_5 A script that helps install Postscript fonts in X Window Sy
pango-1.22.4 An open-source framework for the layout and rendering of i1
pciids-20090224 Database of all known ID's used in PCI devices
pcre-7.8 Perl Compatible Regular Expressions library
peps-2.0_2 Converts EPS images to anti-aliased bitmaps
perl-5.8.9_2 Practical Extraction and Report Language
phonon-4.3.1 Multimedia framework for KDE4
phonon-xine-4.3.1 Phonon xine backend
php5-5.2.9 PHP Scripting Language
php5-pcre-5.2.9 The pcre shared extension for php
php5-simplexml-5.2.9 The simplexml shared extension for php
php5-xml-5.2.9 The xml shared extension for php
phpsysinfo-2.5.4_1 A PHP script for displaying system information
pilot-link-0.12.3,1 Suite of tools used to connect and sync your Palm handled
pixman-0.14.0 Low-level pixel manipulation library
pkg-config-0.23_1 A utility to retrieve information about installed libraries
png-1.2.35 Library for manipulating PNG images
policykit-0.9_3 Framework for controlling access to system-wide components
policykit-gnome-0.9.2 GNOME frontend to the PolicKit framework
poppler-0.8.7_1 A PDF rendering library
poppler-data-0.2.1 Poppler encoding data
poppler-qt4-0.8.7 Qt4 bindings to poppler
popt-1.7_5 A getopt(3) like library with a number of enhancements, fro
portupgrade-2.4.6,2 FreeBSD ports/packages administration and management tool s
postfix-2.5.6,1 A secure alternative to widely-used Sendmail
printproto-1.0.4 Print extension headers
pth-2.0.7 GNU Portable Threads
pulseaudio-0.9.14 Sound server for UNIX
py25-cairo-1.8.2 Python bindings for Cairo
py25-gnome-2.22.3 A set of Python bindings for GNOME 2
py25-gobject-2.16.1 Python bindings for GObject
py25-gtk-2.14.1 A set of Python bindings for GTK+
py25-libxml2-2.7.3 Python interface for XML parser library for GNOME
py25-numeric-24.2_3 The Numeric Extension to Python
py25-orbit-2.24.0 Python bindings for ORBit2
py25-xml-0.8.4 PyXML: Python XML library enhancements
python25-2.5.4_1 An interpreted object-oriented programming language
qca-2.0.1 Cross-platform crypto API for QT
qca-ossl-2.0.0.b3_2 QCA OpenSLL plugin
qimageblitz-0.0.4_1 KDE 4 integrated X11 desktop
qt4-assistant-4.4.3 Qt documentation browser
qt4-clucene-4.4.3 QtCLucene full text search library wrapper
qt4-corelib-4.4.3 Qt core library
qt4-dbus-4.4.3 Qt4 bindings for the D-BUS messaging system
qt4-designer-4.4.3 Qt ui editor
qt4-doc-4.4.3 Multiplatform C++ application framework
qt4-gui-4.4.3_2 Qt graphical user interface library
qt4-help-4.4.3 QtHelp module provides QHelpEngine API and is used by Assis
qt4-iconengines-4.4.3 Qt SVG icon engine plugin
qt4-imageformats-4.4.3 Qt imageformat plugins for GIF, JPEG, MNG and SVG
qt4-makeqpf-4.4.3 Qt qtopia font creator
qt4-moc-4.4.3 Qt meta object compiler
qt4-mysql-plugin-4.4.3 Qt MySQL database plugin
qt4-network-4.4.3 Qt network library
qt4-opengl-4.4.3 Qt OpenGL library
qt4-pixeltool-4.4.3 Qt screen magnification utility
qt4-porting-4.4.3 Qt utility to assist with porting Qt3 applications to Qt4
qt4-qdbusviewer-4.4.3 Qt4 D-BUS viewer
qt4-qmake-4.4.3 The build utility of the Qt project
qt4-qt3support-4.4.3 Qt3 compatibility library
qt4-qtestlib-4.4.3 Qt unit testing library
qt4-rcc-4.4.3 Qt resource compiler
qt4-script-4.4.3 Qt script
qt4-sql-4.4.3 Qt SQL library
qt4-sqlite-plugin-4.4.3 Qt SQLite 3.x database plugin
qt4-svg-4.4.3 Qt SVG library
qt4-uic-4.4.3 Qt user interface compiler
qt4-uic3-4.4.3 Qt backwards-compatible user interface compiler
qt4-webkit-4.4.3 Qt4 webkit engine
qt4-xml-4.4.3 Qt XML library
randrproto-1.2.1 Randr extension headers
raptor-1.4.16_1 RDF Parser Toolkit for Redland
rar-3.80,2 File archiver (binary port)
rarian-0.8.1 An OMF help system based on the Freedesktop specification
recordproto-1.13.2 RECORD extension headers
redland-1.0.7_1 A high-level interface for RDF
renderproto-0.9.3 RenderProto protocol headers
resourceproto-1.0.2 Resource extension headers
rgb-1.0.1 Uncompile an rgb corl-name database
rpm-3.0.6_14 The Red Hat Package Manager
rrdtool-1.3.5_1 Round Robin Database Tools
rstart-1.0.2 Sample implementation of a Remote Start client
ruby-1.8.7.72_1,1 An object-oriented interpreted scripting language
ruby18-bdb-0.6.5 Ruby interface to Sleepycat's Berkeley DB revision 2 or lat
ruby18-deplate-0.8.5 Ruby tool for converting wiki-like markup
samba-3.0.34,1 A free SMB and CIFS client and server for UNIX
samba-libsmbclient-3.0.34_1 Shared libs from the samba package
sane-backends-1.0.19_1 API for access to scanners, digitals camera, frame grabbers
scr2png-1.2_1 Converts the output of "vidcontrol -p" to PNG
scr2txt-1.2 Converts the output of "vidcontrol -p" to text
screen-4.0.3_6 A multi-screen window manager
scripts-1.0.1 Various X related scripts
scrnsaverproto-1.1.0 ScrnSaver extension headers
sdl-1.2.13_3,2 Cross-platform multimedia development API
sessreg-1.0.4 Manage utmp/wtmp entries for non-init X clients
setxkbmap-1.0.4 Set the keyboard using the X Keyboard Extension
shared-mime-info-0.60 A MIME type database from the FreeDesktop project
showfont-1.0.2 Font dumper for the X font server
smproxy-1.0.2 Session Manager Proxy
socat-1.7.0.0 Multipurpose relay and more
soprano-2.2.3 QT4 RDF framework
speex-1.2.r1_1,1 An open-source patent-free voice codec
sqlite3-3.6.10 An SQL database engine in a C library w/ Tcl wrapper
squid-3.0.13 HTTP Caching Proxy
startup-notification-0.9_2 Library that supports startup notification spec from freede
strigi-0.6.3_1 Desktop searching program
subversion-1.5.5_1 Version control system
sudo-1.6.9.20 Allow others to run commands as root
swig-1.3.38 Simplified Wrapper and Interface Generator
t1lib-5.1.2_1,1 A Type 1 Rasterizer Library for UNIX/X11
taglib-1.5 Library for manipulating ID3 tags and Ogg comments
tapioca-qt-0.14.1_3 Framework for VoIP and IP applications
tcl-8.4.19_2,1 Tool Command Language
teTeX-base-3.0_14 Thomas Esser's distribution of TeX & friends (binaries)
teTeX-texmf-3.0_5 Thomas Esser's distribution of TeX & friends (texmf tree)
telepathy-qt-0.14.1_2 Framework for VoIP and IP applications
tex-texmflocal-1.9 Meta-port that creates a site-local $TEXMF directory
texi2html-1.76_1,1 Texinfo to HTML converter
thunderbird-2.0.0.21 Mozilla Thunderbird is standalone mail and news that stands
tidy-lib-080621.c Utility to clean up and pretty print HTML/XHTML/XML (with s
tiff-3.8.2_3 Tools and library routines for working with TIFF images
tk-8.4.19_2,2 Graphical toolkit for TCL
trafshow-3.1_6,1 Full screen visualization of network traffic (an ancient ve
trapproto-3.4.3 DEC-XTRAP extension headers
twm-1.0.4 Tab Window Manager for the X Window System
unrar-3.80,5 Extract, view & test RAR archives
unzip-5.52_5 List, test and extract compressed files in a ZIP archive
unzoo-4.4_2 A zoo archive extractor
v4l_compat-1.0.20060801 Video4Linux compatibility header
vcdimager-0.7.23_5 GNU VCDImager/VCDRip -- The GNU VideoCD Image Maker/Ripping
videoproto-2.2.2 Video extension headers
viewres-1.0.1_1 Graphical class browser for Xt
vorbis-tools-1.2.0_4,3 Play, encode, and manage Ogg Vorbis files
wavpack-4.50.1 Audio codec for lossless, lossy and hybrid compression
x11perf-1.5 X11 server performance test program
xauth-1.0.3 X authority file utility
xbacklight-1.1 Program to adjust backlight brightness
xbiff-1.0.1_1 Mailbox flag for X
xbitmaps-1.0.1 X.Org bitmaps data
xcalc-1.0.2_1 Scientific calculator for X
xcb-2.4_1 A tool for managing x11 cut-buffers
xcb-proto-1.4 The X protocol C-language Binding (XCB) protocol
xcb-util-0.3.3 A module with libxcb/libX11 extension/replacement libraries
xclipboard-1.0.1_1 X clipboard client
xclock-1.0.3_1 Analog and digital clock for X
xcmiscproto-1.1.2 XCMisc extension headers
xcmsdb-1.0.1 Device Color Characterization utility for X
xconsole-1.0.3_1 Monitor system console messages with X
xcursor-themes-1.0.1_1 X.org cursors themes
xcursorgen-1.0.2 Create an X cursor file from a collection of PNG images
xdbedizzy-1.0.2 Demo of DBE creating a double buffered spinning scene
xditview-1.0.1_1 Display ditroff output
xdm-1.1.8_1 X.Org X display manager
xdpyinfo-1.0.3 Display information utility for X
xdriinfo-1.0.2 Query configuration information of DRI drivers
xedit-1.1.2 Simple text editor for X
xev-1.0.3 Print contents of X events
xextproto-7.0.5 XExt extension headers
xeyes-1.0.1 A follow the mouse X demo
xf86-input-keyboard-1.3.2 X.Org keyboard input driver
xf86-input-mouse-1.4.0_3 X.Org mouse input driver
xf86-video-ati-6.12.1 X.Org ati display driver
xf86-video-intel-2.5.1 Driver for Intel integrated graphics chipsets
xf86-video-mach64-6.8.0_1 X.Org mach64 display driver
xf86-video-nv-2.1.12_2 X.Org nv display driver
xf86-video-openchrome-0.2.903 X.Org openChrome display driver
xf86-video-r128-6.8.0_1 X.Org r128 display driver
xf86-video-radeonhd-1.2.4_1 X.Org ati RadeonHD display driver
xf86-video-vesa-2.1.0 X.Org vesa display driver
xf86-video-vga-4.1.0_2 X.Org vga display driver
xf86-video-via-0.2.2_3 X.Org via display driver
xf86bigfontproto-1.1.2 XFree86-Bigfont extension headers
xf86dga-1.0.2_1 Test program for the XFree86-DGA extension
xf86dgaproto-2.0.3 XFree86-DGA extension headers
xf86driproto-2.0.4 XFree86-DRI extension headers
xf86miscproto-0.9.2 XFree86-Misc extension headers
xf86rushproto-1.1.2 XFree86-Rush extension headers
xf86vidmodeproto-2.2.2 XFree86-VidModeExtension extension headers
xfd-1.0.1_1 Display all characters in an X font
xfindproxy-1.0.1 Locate available proxy services
xfontsel-1.0.2_1 Point and click selection of X11 font names
xfs-1.0.8_1,1 X.Org font server
xfsinfo-1.0.2 X font server information utility
xfwp-1.0.1 X firewall proxy
xgamma-1.0.2 Gamma correction through the X server.
xgc-1.0.1_1 X graphics demo
xhost-1.0.2 Server access control program for X
xhtml-1.0.20020801_4 W3C's XHTML DTD
xineramaproto-1.1.2 Xinerama extension headers
xinit-1.1.1_1 X Window System initializer
xinput-1.4.0 Very useful utility for configuring and testing XInput devi
xkbcomp-1.0.5 Compile XKB keyboard description
xkbevd-1.0.2 XKB event daemon
xkbprint-1.0.1 Utility for printing an XKB keyboard description
xkbutils-1.0.1_2 XKB utility demos
xkeyboard-config-1.4 X Keyboard Configuration Database
xkill-1.0.1 Utility for killing a client by its X resource
xload-1.0.2_1 System load average display for X
xlogo-1.0.1_1 Displays the X Window System logo.
xlsatoms-1.0.1 List interned atoms defined on a server
xlsclients-1.0.1 List client applications running on a display
xlsfonts-1.0.2 Server font list displayer for X
xmag-1.0.2_1 X application for screen magnifying
xman-1.0.3_1 Manual page display program for X
xmessage-1.0.2_1 Display message or query in a X window
xmlcatmgr-2.2 SGML and XML catalog manager
xmlcharent-0.3_2 XML character entities
xmms-1.2.11_6 X Multimedia System -- An audio player with Winamp GUI
xmodmap-1.0.3 Utility for modifying keymaps and pointer button mappings i
xmore-1.0.1_1 Plain text display program for X
xorg-7.4 X.Org complete distribution metaport
xorg-apps-7.4_1 X.org apps meta-port
xorg-cf-files-1.0.2_3 X.org cf files for use with imake builds
xorg-docs-1.4,1 X.org documentation files
xorg-drivers-7.4 X.org drivers meta-port
xorg-fonts-100dpi-7.4 X.Org 100dpi bitmap fonts
xorg-fonts-7.4 X.org fonts meta-port
xorg-fonts-75dpi-7.4 X.Org 75dpi bitmap fonts
xorg-fonts-cyrillic-7.4 X.Org Cyrillic bitmap fonts
xorg-fonts-miscbitmaps-7.4 X.Org miscellaneous bitmap fonts
xorg-fonts-truetype-7.4 X.Org TrueType fonts
xorg-fonts-type1-7.4 X.Org Type1 fonts
xorg-libraries-7.4 X.org libraries meta-port
xorg-macros-1.2.1 X.Org development aclocal macros
xorg-server-1.5.3_7,1 X.Org X server and related programs
xplsprinters-1.0.1 Shows a list of Xprint printers
xpr-1.0.2 Utility for printing an X window dump
xprehashprinterlist-1.0.1 Recomputes the list of available printers.
xprop-1.0.4 Property displayer for X
xproto-7.0.15 X11 protocol headers
xproxymanagementprotocol-1.0.2 X Proxy Management Protocol headers
xrandr-1.2.3 Primitive command line interface to the RandR extension
xrdb-1.0.5 X server resource database utility
xrefresh-1.0.2 Refresh all or part of an X screen
xrx-1.0.1_2 RX helper program
xscreensaver-5.08 Save your screen while you entertain your cat
xset-1.0.4 User preference utility for X
xsetmode-1.0.0 Set the mode for an X Input Device
xsetpointer-1.0.1 Set an X Input device as the main pointer
xsetroot-1.0.2 root window parameter setting utility for X
xsm-1.0.1_1 X Session Manager
xstdcmap-1.0.1 X standard colormap utility
xterm-242 Terminal emulator for the X Window System
xtrans-1.2.3 Abstract network code for X
xtrap-1.0.2 XTrap sample clients for X
xvidtune-1.0.1_1 Video mode tuner for X
xvinfo-1.0.2 Print out X-Video extension adaptor information
xwd-1.0.2 Dump an image of an X window
xwininfo-1.0.4 Window information utility for X
xwud-1.0.1 Image displayer for X
zenity-2.24.1 Display GNOME dialogs from the command line
zip-3.0 Create/update ZIP files compatible with pkzip




[/code]


-------------------------

As to what I can see, the creation of the Database is fine, creating the Tables is fine, but when the SQL Statement trys to create the INDEXING it fails... now, this is a brand new, fresh install less than 1 day old. KDE 4.2.1 was the first package I installed on the box, and this is what I'm ending up with.

Can you link me to a replacement SQL injection file or can you give me some techniques to resolve this problem.

Help would be much welcome.


Thanks
Speedie

OK, it's a new day for me and I decided to dig my way into this by loading up mysql and injecting the SQL Statements in 1-by-1, and this is what happens, and I made 1 change to which (Does not really solve the prob, and make the indexing function not as it should, as the original index's the name char(255) to which I've changed to it's Id instead, I went to the mysql forums and there is a bug in place atm on indexing... http://bugs.mysql.com/bug.php?id=4541

Below is me manually injecting the SQL Statements, and the last line is my change to which mysql accepts, note, due to my change, the index is not indexing the `name` field char(255), but instead I'm just indexing the `Id` field bigint.

Code: Select all


mysql> drop table LocationTable;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE LocationTable
    ->  (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    ->  remoteId TEXT ,
    ->  name VARCHAR(255) BINARY character set utf8 collate utf8_bin NOT NULL,
    ->  parentId BIGINT DEFAULT 0 REFERENCES Location(id),
    ->  resourceId BIGINT NOT NULL REFERENCES Resource(id),
    ->  subscribed BOOL NOT NULL DEFAULT true,
    ->  cachePolicyInherit BOOL NOT NULL DEFAULT true,
    ->  cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1,
    ->  cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1,
    ->  cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false,
    ->  cachePolicyLocalParts TEXT
    -> );
Query OK, 0 rows affected (0.00 sec)


mysql> CREATE UNIQUE INDEX `parentAndNameIndex` ON `locationtable` (`parentId`,`name`);
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes


mysql> CREATE UNIQUE INDEX parentAndNameIndex ON LocationTable (parentId,Id);
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0


---------------------------


Ok, now lets try fire up Akonadi....


---------------------------


[corpse@router ~]$ akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
[corpse@router ~]$ akonadictl start
Starting Akonadi Server...
   done.
[corpse@router ~]$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table  "SchemaVersionTable"
[akonadiserver] checking table  "ResourceTable"
[akonadiserver] checking table  "LocationTable"
[akonadiserver] checking table  "MimeTypeTable"
[akonadiserver] checking table  "PimItemTable"
[akonadiserver] checking table  "FlagTable"
[akonadiserver] checking table  "PartTable"
[akonadiserver] checking table  "LocationAttributeTable"
[akonadiserver] checking relation  "PimItemFlagRelation"
[akonadiserver] checking relation  "LocationMimeTypeRelation"
[akonadiserver] checking relation  "LocationPimItemRelation"
[akonadiserver] DbInitializer::run() done
[akonadiserver] skipping update 2
[akonadiserver] skipping update 3
[akonadiserver] skipping update 4
[akonadiserver] skipping update 8
PLUGINS:  "/usr/local/kde4/share/akonadi/agents"
PLUGINS:  ("distlistresource.desktop", "icalresource.desktop", "imaplibresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "mailthreaderagent.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
PLUGINS inserting:  "akonadi_distlist_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_ical_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_imaplib_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kabc_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kcal_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_mailthreader_agent" 0 ("Unique")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 0 ("Resource")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"


---------------------------


[corpse@router ~]$ akonadictl status
Akonadi Control: running
Akonadi Server: running



I know some people out their may think this was a silly fix, but the prob is, Akonadi does checks on startup and make sure the table layout is laid out a certain way. eg: do tables exist, do the indexes exist. so I could not just ignore the Index rule. and so I just created the index, but linked it on different columns. to which I believe makes the indexing useless to some degree.

I'd be interested if anyone else has had a prob like this....

Please note, that pin-pointing where the prob was in the first place was not straight-forward, as initially, it looked like a Akonadi/D-Bus problem when using Akonadi's Testing Program.

This fix now allow Akonadi server to start, and now I can use the PIM Apps in KDE, without the Akonadi server trying to load everytime I access these Apps.



Thanks
Speedie

Thanks a lot for the analysis.

The weird thing is that this has not been reported before, although we have probably got very few feedback from BSD users yet.

Since the bug report you linked to mentions a limit of 1000 bytes and your own log indicates a limit below that, could it be a build time option you used to customize the mysqld build?

Cheers,
_

anda_skoa wrote:Thanks a lot for the analysis.

The weird thing is that this has not been reported before, although we have probably got very few feedback from BSD users yet.

Since the bug report you linked to mentions a limit of 1000 bytes and your own log indicates a limit below that, could it be a build time option you used to customize the mysqld build?

Cheers,
_

Hi anda_soka,

I did not alter the ports/mysql60-server/Makefile in any way when I built it.

I simply build mysql with the following command: portinstall databases/mysql60-server

for interest sake, I'll paste the Makefile to which FreeBSD 7.1-RELEASE uses as of: 2009/03/04 15:45:54....

Code: Select all


router# cat /usr/ports/databases/mysql60-server/Makefile
# New ports collection makefile for:    MySQL-server
# Date created:                         28 Jan 2006
# Whom:                                 Alex Dupre
#
# $FreeBSD: ports/databases/mysql60-server/Makefile,v 1.246 2009/03/04 15:45:53 ale Exp $
#

PORTNAME?=      mysql
PORTVERSION=    6.0.9
PORTREVISION?=  1
CATEGORIES=     databases
MASTER_SITES=   ${MASTER_SITE_MYSQL}
MASTER_SITE_SUBDIR=     MySQL-6.0
PKGNAMESUFFIX?= -server
DISTNAME=       ${PORTNAME}-${PORTVERSION}-alpha

MAINTAINER=     ale@FreeBSD.org
COMMENT?=       Multithreaded SQL database (server)

SLAVEDIRS=      databases/mysql60-client databases/mysql60-scripts
USE_AUTOTOOLS=  libtool:15
USE_GMAKE=      yes

CONFIGURE_ARGS= --localstatedir=/var/db/mysql
                --infodir=${PREFIX}/info
                --mandir=${PREFIX}/man
                --with-zlib-dir=/usr
                --without-debug
                --without-readline
                --without-libedit
                --with-libwrap
                --with-low-memory
                --with-comment='FreeBSD port: ${PKGNAME}'
                --enable-thread-safe-client

.ifdef USE_MYSQL
.error You have `USE_MYSQL' variable defined either in environment or in make(1) arguments. Please undefine and try again.
.endif

.if defined(WITH_CHARSET) && ${WITH_CHARSET} != ""
CONFIGURE_ARGS+=--with-charset=${WITH_CHARSET}
.endif
.if defined(WITH_XCHARSET) && ${WITH_XCHARSET} != ""
CONFIGURE_ARGS+=--with-extra-charsets=${WITH_XCHARSET}
.endif
.if defined(WITH_OPENSSL)
CONFIGURE_ARGS+=--with-ssl=bundled
.endif
.if defined(WITH_FAST_MUTEXES)
CONFIGURE_ARGS+=--with-fast-mutexes
.endif
.if defined(WITH_THREAD_POOL)
CONFIGURE_ARGS+=--with-libevent
.endif
.if defined(BUILD_STATIC)
CONFIGURE_ARGS+=--with-mysqld-ldflags=-all-static
.endif
.if defined(WITH_NDB)
CONFIGURE_ARGS+=--with-plugins=max
.else
CONFIGURE_ARGS+=--with-plugins=max-no-ndb
.endif
.if defined(WITH_COLLATION) && ${WITH_COLLATION} != ""
CONFIGURE_ARGS+=--with-collation=${WITH_COLLATION}
.endif

.include

.if ${ARCH} == "i386"
CONFIGURE_ARGS+=--enable-assembler
.endif
.if defined(WITH_LINUXTHREADS)
CONFIGURE_ARGS+=--with-named-thread-libs='-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R
CONFIGURE_ARGS+=-D_THREAD_SAFE -I${LOCALBASE}/include/pthread/linuxthreads
CFLAGS+=        -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE
CFLAGS+=        -I${LOCALBASE}/include/pthread/linuxthreads
LIB_DEPENDS+=   lthread:${PORTSDIR}/devel/linuxthreads
CONFIGURE_ARGS+=-L${LOCALBASE}/lib -llthread -llgcc_r -llstdc++ -llsupc++'
.else
CONFIGURE_ARGS+=--with-named-thread-libs=${PTHREAD_LIBS}
CFLAGS+=        ${PTHREAD_CFLAGS}
.endif

.if defined(BUILD_OPTIMIZED)
CFLAGS+=        -O3 -fno-omit-frame-pointer
CFLAGS+=        -fno-gcse
.endif
CXXFLAGS+=      ${CFLAGS} -felide-constructors -fno-rtti
CXXFLAGS+=      -fno-exceptions

# MySQL-Server part
.if !defined(CLIENT_ONLY) && !defined(SCRIPTS_ONLY)
USE_MYSQL=      yes
WANT_MYSQL_VER= 60

LATEST_LINK=    mysql60-server

CONFLICTS=      mysql-server-3.* mysql-server-4.* mysql-server-5.*

USE_RC_SUBR=    mysql-server.sh

.if defined(WITH_NDB)
PLIST_SUB+=     NDB=""
.else
PLIST_SUB+=     NDB="@comment "
.endif

MAN1=           myisamchk.1 myisamlog.1 myisampack.1
                my_print_defaults.1 mysql_tzinfo_to_sql.1
                mysqld_safe.1 mysql.server.1 perror.1 replace.1

INFO=           mysql

CONFIGURE_ARGS+=--with-embedded-server

CFLAGS+=        -fPIC

pre-fetch:
        @${ECHO} ""
        @${ECHO} "You may use the following build options:"
        @${ECHO} ""
        @${ECHO} "      WITH_CHARSET=charset    Define the primary built-in charset (latin1)."
        @${ECHO} "      WITH_XCHARSET=list      Define other built-in charsets (may be 'all')."
        @${ECHO} "      WITH_COLLATION=collate  Define default collation (latin1_swedish_ci)."
        @${ECHO} "      WITH_OPENSSL=yes        Enable secure connections."
        @${ECHO} "      WITH_LINUXTHREADS=yes   Use the linuxthreads pthread library."
        @${ECHO} "      WITH_PROC_SCOPE_PTH=yes Use process scope threads"
        @${ECHO} "                              (try it if you use libpthread)."
        @${ECHO} "      WITH_THREAD_POOL=yes    Use libevent to have connection pooling."
        @${ECHO} "      WITH_FAST_MUTEXES=yes   Replace mutexes with spinlocks."
        @${ECHO} "      BUILD_OPTIMIZED=yes     Enable compiler optimizations"
        @${ECHO} "                              (use it if you need speed)."
        @${ECHO} "      BUILD_STATIC=yes        Build a static version of mysqld."
        @${ECHO} "                              (use it if you need even more speed)."
        @${ECHO} "      WITH_NDB=yes            Enable support for NDB Cluster."
        @${ECHO} ""

post-patch:
        @${REINPLACE_CMD} -e "s|SUBDIRS =|SUBDIRS = include @docs_dirs@ sql-common @sql_server_dirs@ libmysql storage scripts @sql_server@ @man_dirs@ @libmysqld_dirs@ support-files|g" ${WRKSRC}/Makefile.in
        @${REINPLACE_CMD} -e "s|bin_SCRIPTS =|bin_SCRIPTS = @server_scripts@|g" ${WRKSRC}/scripts/Makefile.in
        @${REINPLACE_CMD} -e "s|dist_pkgdata_DATA =|dist_pkgdata_DATA = fill_help_tables.sql mysql_system_tables.sql mysql_system_tables_data.sql|g" ${WRKSRC}/scripts/Makefile.in
        @${REINPLACE_CMD} -e "s|man1_MANS =|man1_MANS = ${MAN1}|g" ${WRKSRC}/man/Makefile.in
        @${REINPLACE_CMD} -e "s|install-data-am: install-pkgincludeHEADERS|install-data-am:|g" ${WRKSRC}/extra/Makefile.in
        @${REINPLACE_CMD} -e "s|install-data-am: install-includeHEADERS|install-data-am:|g" ${WRKSRC}/extra/libevent/Makefile.in
        @${REINPLACE_CMD} -e "s|install-data-am: install-pkgincludeHEADERS|install-data-am:|g" ${WRKSRC}/include/Makefile.in
        @${REINPLACE_CMD} -e "s|install-exec-am: install-pkglibLTLIBRARIES|install-exec-am:|g" ${WRKSRC}/libmysql/Makefile.in
        @${REINPLACE_CMD} -e "s|PROGRAMS = $$(noinst_PROGRAMS)|PROGRAMS =|g" ${WRKSRC}/storage/archive/Makefile.in
        @${REINPLACE_CMD} -e "/^AM_CXXFLAGS/s|=.*|+= $$(NDB_CXXFLAGS)|" `${FIND} ${WRKSRC}/storage/ndb -name Makefile.in`
.if defined(WITH_PROC_SCOPE_PTH)
        @${REINPLACE_CMD} -e "s|PTHREAD_SCOPE_SYSTEM|PTHREAD_SCOPE_PROCESS|g" ${WRKSRC}/sql/mysqld.cc
.endif

post-install:
.if !defined(PACKAGE_BUILDING)
        @${SETENV} ${SH} ${PKGINSTALL} ${PKGNAME} POST-INSTALL
        @${CAT} ${PKGMESSAGE}
.endif

.else
# MySQL-Client part
.if defined(CLIENT_ONLY)
LATEST_LINK=    mysql60-client

CONFLICTS=      mysql-client-3.* mysql-client-4.* mysql-client-5.*

MAN1=           mysql_config.1 mysql.1 mysqladmin.1 mysqlbinlog.1
                mysqlcheck.1 mysqldump.1 mysqlimport.1 mysqlshow.1

USE_LDCONFIG=   ${PREFIX}/lib/mysql

CONFIGURE_ARGS+=--without-server

post-patch:
        @${REINPLACE_CMD} -e "s|SUBDIRS =|SUBDIRS = include sql-common scripts strings regex mysys dbug extra libmysql libmysql_r client @man_dirs@|g" ${WRKSRC}/Makefile.in
        @${REINPLACE_CMD} -e "s|install-exec-am: install-pkglibLTLIBRARIES|install-exec-am:|g" ${WRKSRC}/strings/Makefile.in ${WRKSRC}/mysys/Makefile.in ${WRKSRC}/dbug/Makefile.in
        @${REINPLACE_CMD} -e "s|bin_SCRIPTS =|bin_SCRIPTS = mysql_config mysql_fix_privilege_tables mysqlbug|g" ${WRKSRC}/scripts/Makefile.in
        @${REINPLACE_CMD} -e "s|dist_pkgdata_DATA =|dist_pkgdata_DATA = mysql_fix_privilege_tables.sql|g" ${WRKSRC}/scripts/Makefile.in
        @${REINPLACE_CMD} -e "s|man1_MANS =|man1_MANS = ${MAN1}|g" ${WRKSRC}/man/Makefile.in
        @${REINPLACE_CMD} -e "s|install-exec-am: install-binPROGRAMS|install-exec-am:|g" ${WRKSRC}/extra/Makefile.in

post-install:
        ${INSTALL_DATA} ${WRKSRC}/support-files/mysql.m4 ${PREFIX}/share/aclocal/

.else
# MySQL-Scripts part
USE_MYSQL=      yes
WANT_MYSQL_VER= 60

RUN_DEPENDS=    ${SITE_PERL}/${PERL_ARCH}/DBD/mysql.pm:${PORTSDIR}/databases/p5-DBD-mysql60
.if ${PERL_LEVEL}

router#



I hope this bug that I've had, and a temp solution is helpful to others to which have Akonadi Server Startup issues to which Akonadi reports it's a DBUS error. I can tell you now, DBUS was not the issue for this case.

To make the error more noticeable, simple use Xterm, and run:

# akonadictl stop
# akonadictl start

if akonadictl can not be found, add /usr/local/kde4/bin to your path


------------------------------


Thanks
Speedie