This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Akonadi Server the 100.

Tags: None
(comma "," separated)
hufgardm
Registered Member
Posts
2
Karma
0

Akonadi Server the 100.

Sun Jan 03, 2010 10:45 am
Hi!

Sorry for that, but i have searched many days for my problem with akonadi server, but find no solution.

I have build qt and kde myself from the aktuall git or svn version.

QT was build with the -plugin-sql-mysql -I /usr/include/mysql options.

I get ever the error, that the driver QMYSQL is not found. Akonadi never probe my mysql.

Hier is the Report:

    Akonadi Server Self-Test Report
    ===============================

    Test 1: ERROR
    --------

    Database driver not found.
    Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration.
    The following drivers are installed: QSQLITE, QODBC3, QODBC, QPSQL7, QPSQL.
    Make sure the required driver is installed.

    File content of '/home/hufgardm/.config/akonadi/akonadiserverrc':
    [%General]
    Driver=QMYSQL

    [QMYSQL]
    Name=akonadi
    User=root
    Password=xbr500
    Options="UNIX_SOCKET=/tmp/mysql.sock"
    ServerPath=/usr/sbin/mysqld
    StartServer=false
    Host=localhost

    [Debug]
    Tracer=null


    Test 2: SKIP
    --------

    MySQL server executable not tested.
    Details: The current configuration does not require an internal MySQL server.

    Test 3: SKIP
    --------

    MySQL server error log not tested.
    Details: The current configuration does not require an internal MySQL server.

    Test 4: SKIP
    --------

    MySQL server configuration not tested.
    Details: The current configuration does not require an internal MySQL server.

    Test 5: SUCCESS
    --------

    akonadictl found and usable
    Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
    Result:
    Akonadi 1.2.80 (revision 1068573)


    Test 6: ERROR
    --------

    Akonadi control process not registered at D-Bus.
    Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

    Test 7: ERROR
    --------

    Akonadi server process not registered at D-Bus.
    Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

    Test 8: SUCCESS
    --------

    Nepomuk search service registered at D-Bus.
    Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.

    Test 9: SUCCESS
    --------

    Nepomuk search service uses an appropriate backend.
    Details: The Nepomuk search service uses one of the recommended backends.

    Test 10: SKIP
    --------

    Protocol version check not possible.
    Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

    Test 11: ERROR
    --------

    No resource agents found.
    Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/etc/opt/kde3/share:/opt/kde3/share', make sure this includes all paths where Akonadi agents are installed to.

    Directory listing of '/usr/share/akonadi/agents':
    birthdaysresource.desktop
    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

    Environment variable XDG_DATA_DIRS is set to '/usr/share:/etc/opt/kde3/share:/opt/kde3/share'

    Test 12: ERROR
    --------

    Current Akonadi server error log found.
    Details: The Akonadi server did report error during startup into <a href='/home/hufgardm/.local/share/akonadi/akonadiserver.error'>/home/hufgardm/.local/share/akonadi/akonadiserver.error</a>.

    File content of '/home/hufgardm/.local/share/akonadi/akonadiserver.error':
    Database driver "QMYSQL" was not found.
    Available drivers are: ("QSQLITE", "QODBC3", "QODBC", "QPSQL7", "QPSQL")
    Falling back to database driver "QMYSQL"
    Database driver "QMYSQL" was not found.
    Available drivers are: ("QSQLITE", "QODBC3", "QODBC", "QPSQL7", "QPSQL")
    No usable database driver found.
    "[
    0: akonadiserver(_Z11akBacktracev+0x39) [0x40b4a9]
    1: akonadiserver [0x40b9f2]
    2: /lib64/libc.so.6 [0x7f3e9934d6e0]
    3: /lib64/libc.so.6(gsignal+0x35) [0x7f3e9934d645]
    4: /lib64/libc.so.6(abort+0x183) [0x7f3e9934ec33]
    5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f3e9b21994f]
    6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c9f8]
    7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f3e9b2a83d8]
    8: /usr/lib64/libQtCore.so.4 [0x7f3e9b2ba5c9]
    9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f3e9b2bb71b]
    10: akonadiserver(_ZN6QDebugD1Ev+0x4e) [0x406a4e]
    11: /usr/lib64/libakonadiprivate.so.1(_ZN14DbConfigStaticC1Ev+0x303b) [0x7f3e9b7104bb]
    12: /usr/lib64/libakonadiprivate.so.1 [0x7f3e9b70ba6e]
    13: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x61) [0x7f3e9b68a0e1]
    14: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f3e9b68b3ea]
    15: akonadiserver(main+0x3a4) [0x406064]
    16: /lib64/libc.so.6(__libc_start_main+0xe6) [0x7f3e99339586]
    17: akonadiserver [0x405bc9]
    ]
    "


    Test 13: ERROR
    --------

    Previous Akonadi server error log found.
    Details: The Akonadi server did report error during its previous startup into <a href='/home/hufgardm/.local/share/akonadi/akonadiserver.error.old'>/home/hufgardm/.local/share/akonadi/akonadiserver.error.old</a>.

    File content of '/home/hufgardm/.local/share/akonadi/akonadiserver.error.old':
    Database driver "QMYSQL" was not found.
    Available drivers are: ("QSQLITE", "QODBC3", "QODBC", "QPSQL7", "QPSQL")
    Falling back to database driver "QMYSQL"
    Database driver "QMYSQL" was not found.
    Available drivers are: ("QSQLITE", "QODBC3", "QODBC", "QPSQL7", "QPSQL")
    No usable database driver found.
    "[
    0: akonadiserver(_Z11akBacktracev+0x39) [0x40b4a9]
    1: akonadiserver [0x40b9f2]
    2: /lib64/libc.so.6 [0x7f5e7490e6e0]
    3: /lib64/libc.so.6(gsignal+0x35) [0x7f5e7490e645]
    4: /lib64/libc.so.6(abort+0x183) [0x7f5e7490fc33]
    5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f5e767da94f]
    6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c9f8]
    7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f5e768693d8]
    8: /usr/lib64/libQtCore.so.4 [0x7f5e7687b5c9]
    9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f5e7687c71b]
    10: akonadiserver(_ZN6QDebugD1Ev+0x4e) [0x406a4e]
    11: /usr/lib64/libakonadiprivate.so.1(_ZN14DbConfigStaticC1Ev+0x303b) [0x7f5e76cd14bb]
    12: /usr/lib64/libakonadiprivate.so.1 [0x7f5e76ccca6e]
    13: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x61) [0x7f5e76c4b0e1]
    14: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f5e76c4c3ea]
    15: akonadiserver(main+0x3a4) [0x406064]
    16: /lib64/libc.so.6(__libc_start_main+0xe6) [0x7f5e748fa586]
    17: akonadiserver [0x405bc9]
    ]
    "


    Test 14: SUCCESS
    --------

    No current Akonadi control error log found.
    Details: The Akonadi control process did not report any errors during its current startup.

    Test 15: SUCCESS
    --------

    No previous Akonadi control error log found.
    Details: The Akonadi control process did not report any errors during its previous startup.


Hope this will help anything.

Many Thanks for your help.

By

Marcus
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi Server the 100.

Sun Jan 03, 2010 11:46 am
The following line indicates that for some reason QMySQL could not be loaded.

Code: Select all
The following drivers are installed: QSQLITE, QODBC3, QODBC, QPSQL7, QPSQL.


Please check your Qt build configuration to ensure it found your MySQL install successfully.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
krop
KDE Developer
Posts
26
Karma
2
OS

Re: Akonadi Server the 100.

Sun Jan 03, 2010 12:25 pm
There are several mistakes in this akonadi log:

#1: your Qt is built without the MySQL support, or the QMySQL plugin cannot be found (doubtful, since the other ones are detected)

#2: the database shouldn't be owned by the root user. Consider deleting /home/hufgardm/.config/akonadi/akonadiserverrc once your Qt installation will be fixed.


hufgardm
Registered Member
Posts
2
Karma
0

Re: Akonadi Server the 100.

Sun Jan 03, 2010 1:14 pm
Hi!

Thanks for your reply.

I build the qt from the git directory qt-kde with the followin config-options:

./configure -qt-gif -release -fast -no-separate-debug-info -system-libpng -system-libjpeg -system-zlib -dbus -webkit -plugin-sql-mysql -nomake examples -nomake demos -prefix /usr -sysconfdir /etc -libdir /usr/lib64 -I /usr/include/mysql

configure says:

Build type: linux-g++-64
Architecture: x86_64
Platform notes:

- Also available for Linux: linux-kcc linux-icc linux-cxx

Build ............... libs tools docs translations
Configuration ....... release shared dll largefile stl precompile_header mmx 3dnow sse sse2 minimal-config small-config medium-config large-config full-config qt3support phonon phonon-backend accessibility opengl reduce_exports ipv6 clock-gettime clock-monotonic mremap getaddrinfo ipv6ifname getifaddrs inotify system-jpeg system-mng system-png png gif system-tiff system-freetype system-zlib nis cups iconv glib gstreamer dbus openssl x11sm xshape xsync xrender mitshm fontconfig xkb alsa xmlpatterns multimedia svg webkit script scripttools release
Debug ............... no
Qt 3 compatibility .. yes
QtDBus module ....... yes (run-time)
QtConcurrent code.... yes
QtScript module ..... yes
QtScriptTools module yes
QtXmlPatterns module yes
Phonon module ....... yes
Multimedia module ... yes
SVG module .......... yes
WebKit module ....... yes
JavaScriptCore JIT .. To be decided by JavaScriptCore
Declarative module .. no
STL support ......... yes
PCH support ......... yes
MMX/3DNOW/SSE/SSE2.. yes/yes/yes/yes
Graphics System ..... default
IPv6 support ........ yes
IPv6 ifname support . yes
getaddrinfo support . yes
getifaddrs support .. yes
Accessibility ....... yes
NIS support ......... yes
CUPS support ........ yes
Iconv support ....... yes
Glib support ........ yes
GStreamer support ... yes
Large File support .. yes
GIF support ......... yes
TIFF support ........ plugin (system)
JPEG support ........ plugin (system)
PNG support ......... yes (system)
MNG support ......... plugin (system)
zlib support ........ system
Session management .. yes
OpenGL support ...... yes (Desktop OpenGL)
OpenVG support ...... no
NAS sound support ... no
XShape support ...... yes
XSync support ....... yes
Xinerama support .... runtime
Xcursor support ..... runtime
Xfixes support ...... runtime
Xrandr support ...... runtime
Xrender support ..... yes
Xi support .......... runtime
MIT-SHM support ..... yes
FontConfig support .. yes
XKB Support ......... yes
immodule support .... yes
GTK theme support ... yes
MySQL support ....... plugin
PostgreSQL support .. plugin
ODBC support ........ plugin
SQLite support ...... plugin (qt)
OpenSSL support ..... yes (run-time)
alsa support ........ yes


Do you have any ideas?

Which qt-mySQL plugin files should be where?

Many Thanks for your help.

By

Marcus
User avatar
anda_skoa
KDE Developer
Posts
783
Karma
4
OS

Re: Akonadi Server the 100.

Sun Jan 03, 2010 5:21 pm
Can you check if you have libqsqlmysql.so somewhere and if LD_LIBRAY_PATH contains the prefix you installed Qt into before any path a distribution built one might be?

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.


Bookmarks



Who is online

Registered users: abc72656, Bing [Bot], Google [Bot], lockheed, Yahoo [Bot]