Okay, I think I know what has happened here. Another user owns your Akonadi directory.

Please run the following:

Code: Select all

sudo chown -R $(id -un):$(id -gn) $HOME/.local/share/akonadi

bcooksley wrote:Okay, I think I know what has happened here. Another user owns your Akonadi directory.

Please run the following:

Code: Select all

sudo chown -R $(id -un):$(id -gn) $HOME/.local/share/akonadi

Uhm no, no change in the behaviour of the gui. This is the shell ouput:

Code: Select all

reg@reg-desktop:~$ sudo chown -R $(id -un):$(id -gn) $HOME/.local/share/akonadi
[sudo] password for reg:
reg@reg-desktop:~$ kontact
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
kontact(7153)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
kontact(7153)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
kontact(7153)/kdeui (kdelibs): No such XML file "/home/reg/.kde/share/apps/kontact/local-kmail.rc"
reg@reg-desktop:~$ Enchant dict for "en_US" 0x8c99958
QInotifyFileSystemWatcherEngine::addPaths: inotify_add_watch failed: No such file or directory
QFileSystemWatcher: failed to add paths: /home/reg/.config/ibus/bus
Bus::open: Can not get ibus-daemon's address.
IBusInputContext::createInputContext: no connection to ibus-daemon
kontact(7153)/kio (KDirWatch) KDirWatchPrivate::removeEntry: doesn't know "/home/reg/.kde/share/apps/kabc"
kontact(7153)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
kontact(7153)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
kontact(7153)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
kontact(7153)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
kontact(7153)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"

I see that iot says "QLocalSocket::connectToServer: Invalid name" but i was sending via my gmail account which always worked and i hadn't touched. its smtp is set to: smtp.gmail.com ... other ideas?

Please try running "akonadictl stop" and then "akonadictl start"

bcooksley wrote:Please try running "akonadictl stop" and then "akonadictl start"

Yep, this and a couple of killall akonadi s before the start seem to have done it....
Thanks,
I'll get back should i experience any other issues!
Thanks for your help buddy!

Ron

I'm very disappointed we have integrated such a mess with this akonadi server to use "simple" applications like kontact...

I never have spent so much time with an issue on Linux since 1996 !!!!!!!

That's what I have from console:

Code: Select all

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] search paths:  ("/sbin", "/usr/sbin", "/usr/local/sbin", "/root/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin")
[akonadiserver] Found mysql_install_db:  "/usr/bin/mysql_install_db"
[akonadiserver] Found mysqlcheck:  "/usr/bin/mysqlcheck"
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: "/usr/sbin/mysqld"
[akonadiserver] arguments: ("--defaults-file=/root/.local/share/akonadi//mysql.conf", "--datadir=/root/.local/share/akonadi/db_data/", "--socket=/root/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "110203 20:23:54 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
[akonadiserver]
[akonadiserver] 110203 20:23:54 [ERROR] Aborting
[akonadiserver]
[akonadiserver] 110203 20:23:54 [Note] /usr/sbin/mysqld: Shutdown complete
[akonadiserver]
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Unknown error"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8053065]
[akonadiserver] 1: akonadiserver() [0x80535fc]
[akonadiserver] 2: [0xffffe400]
[akonadiserver] 3: [0xffffe424]
[akonadiserver] 4: /lib/libc.so.6(gsignal+0x4f) [0xb701c7ff]
[akonadiserver] 5: /lib/libc.so.6(abort+0x180) [0xb701e140]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8a) [0xb73e076a]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8054fa8]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb747811b]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(+0xfc9df) [0xb74819df]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb748b42e]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x54) [0xb763edc4]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x2031) [0xb76481e1]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb764ed87]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb764f1d3]
[akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb7650a88]
[akonadiserver] 16: akonadiserver(main+0x212) [0x804d4a2]
[akonadiserver] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb7007c0e]
[akonadiserver] 18: akonadiserver() [0x804d1c1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)



I tried to find out a solution on different forums but never could solve it...

Is there a way to bypass akonadi and work with kontact anyway ?
Now I'm forced to use thunderbird but it sucks... kontact and korganizer were a perfect couple to help me organize my works... and now I have to synchronize the whole stuff on my desktop 11.1 to have it work, my laptop 11.3 is simply uneffective because of akonadi...

I uninstalled once again akonadi and kontact...

If someone could explain me what is goin' on with akonadi or explain me how register akonadi in dbus... it would be very nice ^^

That's frustratin' you can't imagine...

The soundlord

Those that reads this kind a error logs will see that there is a big problem connecting to the mysql.sock... I found nowhere how specify akonadi to seek for the mysql.sock at the right path/location...

MySQL is running ok as always on this computer... but certainly I won't let the root account unprotected (at least) by a password !!

It seems akonadi start procedure is trying to connect to the database without any password with the root account !! It's a joke ?

For the DBUS issue I really don't know how 'register' (are we under Windows environment with regsrvr32 kinda stuff ??) akonadi service

Akonadi must be simply disabled or bypassed if we do not want it to mess up our way to manage our datas, contacts, events and so on...

NOTHING is available to help us "register a service" thru DBUS (that is in my case the main issue I guess) I'm still searching but losing patience.

Code: Select all

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

Test 1:  SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration and was found on your system.

File content of '/root/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[QMYSQL]
Name=akonadi
Host=
User=
Password=
Options="UNIX_SOCKET=/root/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/sbin/mysqld
StartServer=true


Test 2:  SUCCESS
--------

MySQL server found.
Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/mysqld'.
Make sure you have the MySQL server installed, set the correct path and ensure you have the necessary read and execution rights on the server executable. The server executable is typically called 'mysqld', its locations varies depending on the distribution.

Test 3:  SUCCESS
--------

MySQL server is executable.
Details: MySQL server found: /usr/sbin/mysqld  Ver 5.5.8 for Linux on i686 (MySQL Community Server (GPL))


Test 4:  SUCCESS
--------

No current MySQL error log found.
Details: The MySQL server did not report any errors during this startup into '/root/.local/share/akonadi/db_data/mysql.err'.

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

MySQL server default configuration found.
Details: The default configuration for the MySQL server was found and is readable at <a href='/etc/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.

File content of '/etc/akonadi/mysql-global.conf':
#
# Global Akonadi MySQL server settings,
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
#
# Based on advice by Kris Köhntopp <kris@mysql.com>
#
[mysqld]
skip_grant_tables
skip_networking

# strict query parsing/interpretation
# TODO: make Akonadi work with those settings enabled
#sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
#sql_mode=strict_trans_tables

# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=latin1
collation_server=latin1_general_ci
table_cache=200
thread_cache_size=3
log_bin=mysql-bin
expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# log all queries, useful for debugging but generates an enormous amount of data
#log=mysql.full
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
#log_slow_queries=mysql.slow
#long_query_time=1
# log queries not using indices, debug only, disable for production use
#log_queries_not_using_indexes=1
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0

innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=80M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2

# Do not drop the connection to the DB after 8 hours of inactivity
wait_timeout=1296000



Test 6:  SKIP
--------

MySQL server custom configuration not available.
Details: The custom configuration for the MySQL server was not found but is optional.

Test 7:  SUCCESS
--------

MySQL server configuration is usable.
Details: The MySQL server configuration was found at <a href='/root/.local/share/akonadi/mysql.conf'>/root/.local/share/akonadi/mysql.conf</a> and is readable.

File content of '/root/.local/share/akonadi/mysql.conf':
#
# Global Akonadi MySQL server settings,
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
#
# Based on advice by Kris Köhntopp <kris@mysql.com>
#
[mysqld]
skip_grant_tables
skip_networking

# strict query parsing/interpretation
# TODO: make Akonadi work with those settings enabled
#sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
#sql_mode=strict_trans_tables

# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=latin1
collation_server=latin1_general_ci
table_cache=200
thread_cache_size=3
log_bin=mysql-bin
expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# log all queries, useful for debugging but generates an enormous amount of data
#log=mysql.full
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
#log_slow_queries=mysql.slow
#long_query_time=1
# log queries not using indices, debug only, disable for production use
#log_queries_not_using_indexes=1
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0

innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=80M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2

# Do not drop the connection to the DB after 8 hours of inactivity
wait_timeout=1296000



Test 8:  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.3.1


Test 9:  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 10:  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 11:  ERROR
--------

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

Test 12:  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 13:  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/local/share:/usr/share', make sure this includes all paths where Akonadi agents are installed to.

Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/local/share:/usr/share'

Test 14:  ERROR
--------

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

File content of '/root/.local/share/akonadi/akonadiserver.error':
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8053065]
1: akonadiserver() [0x80535fc]
2: [0xffffe400]
3: [0xffffe424]
4: /lib/libc.so.6(gsignal+0x4f) [0xb6f8a7ff]
5: /lib/libc.so.6(abort+0x180) [0xb6f8c140]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8a) [0xb734e76a]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8054fa8]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb73e611b]
9: /usr/lib/libQtCore.so.4(+0xfc9df) [0xb73ef9df]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb73f942e]
11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x54) [0xb75acdc4]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x1ec9) [0xb75b9489]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb75bc8a7]
14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb75bccf3]
15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb75be5a8]
16: akonadiserver(main+0x212) [0x804d4a2]
17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb6f75c0e]
18: akonadiserver() [0x804d1c1]
]
"


Test 15:  ERROR
--------

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

File content of '/root/.local/share/akonadi/akonadiserver.error.old':
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8053065]
1: akonadiserver() [0x80535fc]
2: [0xffffe400]
3: [0xffffe424]
4: /lib/libc.so.6(gsignal+0x4f) [0xb70517ff]
5: /lib/libc.so.6(abort+0x180) [0xb7053140]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8a) [0xb741576a]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8054fa8]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb74ad11b]
9: /usr/lib/libQtCore.so.4(+0xfc9df) [0xb74b69df]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb74c042e]
11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x54) [0xb7673dc4]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x1ec9) [0xb7680489]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb76838a7]
14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb7683cf3]
15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb76855a8]
16: akonadiserver(main+0x212) [0x804d4a2]
17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb703cc0e]
18: akonadiserver() [0x804d1c1]
]
"


Test 16:  SUCCESS
--------

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

Test 17:  SUCCESS
--------

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



Have I to do by myself the TODOs in this report concerning mysql ?
Why doing complicated when things were working good (really good) in the previous versions of openSuSE ?

Lemme time to get infos about this satanic DBUS stuff... and I'll come back with news...

Nothing but I saw that a file in /etc/akonadi/mysql-global.conf was created that answers the question in the previous post...

But I dig the forums and returned back home depressed... dbus is definetly as all ORB a real mess to manage...

Next episode asap...

This issue is caused by you running Akonadi as the root user. If you are experiencing this as part of a normal KDE session it appears you are trying to run KDE as root (which isn't advised).

In any case, to resolve this, you will need to use an external MySQL server. If you have the standard MySQL service starting at startup, you can configure Akonadi to use that. Otherwise, you will need to enable it.

Simply grant Akonadi full privileges over a database, and enter the relevant settings into the "Akonadi Server Configuration" tab, shown by running "kcmshell4 akonadi"

While running Akonadi with a system wide MySQL would of course work around this MySQL error, I would recommend running KDE as a normal user instead.

Running day-to-day applications as root just asks for problems, especially programs getting content from the network. There is a reason why system services with network connections do not run as root but restricted daemon accounts.

Cheers,
_

All my apologizes I always forget that root login is not the best way to secure access to services. I tried with another user which was granted for all privileges in mysql and now akonadi is working perfect !!

I'm trying to export datas from root to this user right now...

Thank you !!

soundlord wrote:
I'm trying to export datas from root to this user right now...

Thank you !!

As root, open akonaditray and press right click on it and create a backup. Change the permition with

Code: Select all

chown username_from_your_normal_user:users akonadibackup-*

And after that, as the normal user, right click in the akonaditray and Restore the backup... This will restore all the settings except the kwallet...