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

Akonadi errors :(

Tags: None
(comma "," separated)
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Akonadi errors :(

Sat Apr 17, 2010 10:41 pm
Hi There, When KDE starts I get following report from Akonadi.
How do I resolve these issues?

Thank you!
Ron

Akonadi Server Self-Test Report
===============================
Test 1-9: SUCCESS
[snip]

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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/share:/usr/local/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
knutresource.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
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.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/share:/usr/share:/usr/local/share'

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

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

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

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

File content of '/home/reg/.local/share/akonadi/akonadiserver.error.old':
D-Bus session bus went down - quitting


Test 16: ERROR
--------

Current Akonadi control error log found.
Details: The Akonadi control process did report error during startup into <a href='/home/reg/.local/share/akonadi/akonadi_control.error'>/home/reg/.local/share/akonadi/akonadi_control.error</a>.

File content of '/home/reg/.local/share/akonadi/akonadi_control.error':
Unable to register service as org.freedesktop.Akonadi.Control Maybe it's already running?
"[
0: /usr/bin/akonadi_control(_Z11akBacktracev+0x35) [0x805bca5]
1: /usr/bin/akonadi_control [0x805c176]
2: [0xee9400]
3: [0xee9422]
4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0xb184d1]
5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0xb1b932]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x68a32c]
7: /usr/bin/akonadi_control(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x805d1f4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0x722f7e]
9: /usr/lib/libQtCore.so.4 [0x736b85]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0x73809d]
11: /usr/bin/akonadi_control(main+0x424) [0x8070d24]
12: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb04b56]
13: /usr/bin/akonadi_control [0x8057871]
]
"


Test 17: ERROR
--------

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

File content of '/home/reg/.local/share/akonadi/akonadi_control.error.old':
Unable to register service as org.freedesktop.Akonadi.Control Maybe it's already running?
"[
0: /usr/bin/akonadi_control(_Z11akBacktracev+0x35) [0x805bca5]
1: /usr/bin/akonadi_control [0x805c176]
2: [0x17d400]
3: [0x17d422]
4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0x57a4d1]
5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x57d932]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x96732c]
7: /usr/bin/akonadi_control(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x805d1f4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0x9fff7e]
9: /usr/lib/libQtCore.so.4 [0xa13b85]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xa1509d]
11: /usr/bin/akonadi_control(main+0x424) [0x8070d24]
12: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0x566b56]
13: /usr/bin/akonadi_control [0x8057871]
]
"
D-Bus session bus went down - quitting



Thanks!
Ron
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi errors :(

Sat Apr 17, 2010 11:08 pm
First, please enable Nepomuk in System Settings > Advanced > Desktop Search. Strigi ( File Indexing ) is not needed.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Re: Akonadi errors :(

Sat Apr 17, 2010 11:42 pm
bcooksley wrote:First, please enable Nepomuk in System Settings > Advanced > Desktop Search. Strigi ( File Indexing ) is not needed.

Okay, Nepomuk was enabled already and so was Strigi. I disabled Strigi and rebooted and i got these messages:
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 '/home/reg/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

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

[Debug]
Tracer=null


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

MySQL server found.
Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/mysqld-akonadi'.
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-akonadi  Ver 5.1.37-1ubuntu5 for debian-linux-gnu on i486 ((Ubuntu))


Test 4:  ERROR
--------

MySQL server log contains errors.
Details: The MySQL server error log file &apos;<a href='/home/reg/.local/share/akonadi/db_data/mysql.err'>/home/reg/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.

File content of '/home/reg/.local/share/akonadi/db_data/mysql.err':
100417 16:31:45 [Note] Plugin 'FEDERATED' is disabled.
100417 16:31:55  InnoDB: Started; log sequence number 0 2999140
100417 16:32:01 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100417 16:32:01 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100417 16:32:01 [ERROR] Cannot open mysql.db
100417 16:32:01 [ERROR] Cannot open mysql.user
100417 16:32:01 [ERROR] Cannot open mysql.event
100417 16:32:01 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100417 16:32:01 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log'  socket: '/home/reg/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Ubuntu)


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



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='/home/reg/.local/share/akonadi/mysql.conf'>/home/reg/.local/share/akonadi/mysql.conf</a> and is readable.

File content of '/home/reg/.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



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:  SUCCESS
--------

Akonadi control process registered at D-Bus.
Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.

Test 10:  SUCCESS
--------

Akonadi server process registered at D-Bus.
Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational.

Test 11:  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 12:  SUCCESS
--------

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

Test 13:  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 14:  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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/share:/usr/local/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
knutresource.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
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.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/share:/usr/share:/usr/local/share'

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

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

Test 16:  ERROR
--------

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

File content of '/home/reg/.local/share/akonadi/akonadiserver.error.old':
Control process died, committing suicide!


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

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

Test 18:  ERROR
--------

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

File content of '/home/reg/.local/share/akonadi/akonadi_control.error.old':
Unable to register service as org.freedesktop.Akonadi.Control Maybe it's already running?
"[
0: /usr/bin/akonadi_control(_Z11akBacktracev+0x35) [0x805bca5]
1: /usr/bin/akonadi_control [0x805c176]
2: [0xee9400]
3: [0xee9422]
4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0xb184d1]
5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0xb1b932]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x68a32c]
7: /usr/bin/akonadi_control(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x805d1f4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0x722f7e]
9: /usr/lib/libQtCore.so.4 [0x736b85]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0x73809d]
11: /usr/bin/akonadi_control(main+0x424) [0x8070d24]
12: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb04b56]
13: /usr/bin/akonadi_control [0x8057871]
]
"
D-Bus session bus went down - quitting

And then on top of that i got a bunch of KDE crash handler windows telling me that Akonadi had crashed... :o What's going on here? :o

Ron
User avatar
anda_skoa
KDE Developer
Posts
783
Karma
4
OS

Re: Akonadi errors :(

Sun Apr 18, 2010 9:26 am
The actual problem is, as usual, MySQL being a ****.

Try this command:

mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Re: Akonadi errors :(

Sun Apr 18, 2010 9:31 am
anda_skoa wrote:The actual problem is, as usual, MySQL being a ****.

Try this command:

mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data

Cheers,
_

This unfortunately didn't remove the **** title ;)

Code: Select all
reg@reg-desktop:~$ mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data

FATAL ERROR: Could not find /fill_help_tables.sql

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

reg@reg-desktop:~$

I didn not compile mysql from source. It's gotta be from the standard repos.
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi errors :(

Mon Apr 19, 2010 6:39 am
@cerr: Please file a bug with your distribution if the file /usr/share/mysql/fill_help_tables.sql doesn't exist ( assuming the MySQL prefix is /usr ). This is a grave packaging error.

If it is there, try the following:

Code: Select all
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data --basedir=/usr


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
ZeDeun
Registered Member
Posts
7
Karma
0
OS

Re: Akonadi errors :(

Fri May 14, 2010 1:44 pm
Hi,

I also get an error with :
Code: Select all
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist


nevertheless I won't install mysql database in akonadi dir because I got some others.

Still regarding, I guess, this problem with akonadi, I had upgraded from kubuntu 9 to lucid 10. When I had first opened kontact, I had no view on my address book. So I had tried the process here :http://userbase.kde.org/Akonadi_4.4/Troubleshooting#Kubuntu_10.4_Upgrade

But I do not try to use external mysql database anyway. So, what I did also is putting back the ~/.local/share/akonadi directory of my previous system (i.e 9.1).
Now, whatever the kmail and korganizer is just nothing at all. From kadressbook and kontact I get this from console :
Code: Select all
<unknown program name>(6992)/: Communication problem with  "kaddressbook" , it probably crashed.
Error message was:  "org.freedesktop.DBus.Error.NoReply" : " "Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken." "


Besides the trouble I have (and had also with 9.1, I just did not use it) with akonadi, I wonder in what is it useful exactly. This is not clear for me, and to say the true, I would like to remove this from my system. Is it anyway to make everything working without akonadi ?

Thanks for your help.


Den
-------------
Mandriva 2011
2.6.38.7-desktop-1mnb2
x86_64
Versión de la plataforma 4.6.5
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi errors :(

Fri May 14, 2010 9:28 pm
@ZeDeun: Further use of Akonadi by PIM applications is only going to continue.

An akonadi use case would be getting a new mail notification even though KMail is closed, since Akonadi is checking it in the background.

Akonadi also allows for changes to data ( such as the address book ) to show up immediately in Akonadi apps. It also vastly simplifies that process of adding support for alternate protocols ( such as Google Calendar )


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
JanGerrit
Moderator
Posts
647
Karma
3
OS

Re: Akonadi errors :(

Sat May 15, 2010 8:04 am
Moved to Office & Productivity.


Image
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Re: Akonadi errors :(

Sun May 16, 2010 10:28 pm
bcooksley wrote:@cerr: Please file a bug with your distribution if the file /usr/share/mysql/fill_help_tables.sql doesn't exist ( assuming the MySQL prefix is /usr ). This is a grave packaging error.

If it is there, try the following:

Code: Select all
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data --basedir=/usr


Uh,
This gives me following:
Code: Select all
root@reg-desktop:~# mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data --basedir=/usr
Neither host 'reg-desktop' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option
root@reg-desktop:~#

but if i go resolveip localhost or resolveip reg-desktop it I get proper loobback IPs... So what's going on here... :-\
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Re: Akonadi errors :(

Sun May 16, 2010 10:38 pm
ZeDeun wrote:Hi,

I also get an error with :
Code: Select all
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist


nevertheless I won't install mysql database in akonadi dir because I got some others.

Still regarding, I guess, this problem with akonadi, I had upgraded from kubuntu 9 to lucid 10. When I had first opened kontact, I had no view on my address book. So I had tried the process here http://userbase.kde.org/Akonadi_4.4/Tro ... .4_Upgrade
Uh, wanted to follow instructions on that page but it got myself into troubles:
on akonadictl start I get following:
Code: Select all
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8052265]
[akonadiserver] 1: akonadiserver() [0x8052726]
[akonadiserver] 2: [0x83d400]
[akonadiserver] 3: [0x83d422]
[akonadiserver] 4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0x6b4651]
[akonadiserver] 5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x6b7a82]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x16d2dc]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x80537a4]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0x20546e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(+0x10a275) [0x21a275]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0x21b78d]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804dea3]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x2071) [0xaf7cb1]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x263) [0xafada3]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x7d) [0xafb03d]
[akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xafc4f8]
[akonadiserver] 16: akonadiserver(main+0x374) [0x804d204]
[akonadiserver] 17: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0x6a0bd6]
[akonadiserver] 18: akonadiserver() [0x804cdc1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
...

What's messed up here? :o
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi errors :(

Mon May 17, 2010 7:55 am
Can you please post the contents of "akonadiserver.error" from ~/.local/share/akonadi?


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Re: Akonadi errors :(

Tue May 18, 2010 2:52 am
bcooksley wrote:Can you please post the contents of "akonadiserver.error" from ~/.local/share/akonadi?


Yep:
Code: Select all
cat ~/.local/share/akonadi/akonadiserver.error
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/reg/.local/share/akonadi//mysql.conf", "--datadir=/home/reg/.local/share/akonadi/db_data/", "--socket=/home/reg/.local/share/akonadi/db_misc/mysql.socket")
stdout: ""
stderr: "Could not open required defaults file: /home/reg/.local/share/akonadi//mysql.conf
Fatal error in defaults handling. Program aborted
100516 15:28:48 [Warning] Can't create test file /home/reg/.local/share/akonadi/db_data/reg-desktop.lower-test
100516 15:28:48 [Warning] Can't create test file /home/reg/.local/share/akonadi/db_data/reg-desktop.lower-test
/usr/sbin/mysqld-akonadi: Can't change dir to '/home/reg/.local/share/akonadi/db_data/' (Errcode: 13)
100516 15:28:48 [ERROR] Aborting

100516 15:28:48 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete

"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8052265]
1: akonadiserver() [0x8052726]
2: [0x83d400]
3: [0x83d422]
4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0x6b4651]
5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x6b7a82]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x16d2dc]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x80537a4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0x20546e]
9: /usr/lib/libQtCore.so.4(+0x10a275) [0x21a275]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0x21b78d]
11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804dea3]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x2071) [0xaf7cb1]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x263) [0xafada3]
14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x7d) [0xafb03d]
15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xafc4f8]
16: akonadiserver(main+0x374) [0x804d204]
17: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0x6a0bd6]
18: akonadiserver() [0x804cdc1]
]
"
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi errors :(

Tue May 18, 2010 4:21 am
Please ensure that all files under /home/reg/.local/share/akonadi/ are writable by your user.

Code: Select all
chmod 750 -R $HOME/.local/share/akonadi/


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
cerr
Registered Member
Posts
64
Karma
0
OS

Re: Akonadi errors :(

Thu May 20, 2010 3:21 am
bcooksley wrote:Please ensure that all files under /home/reg/.local/share/akonadi/ are writable by your user.

Code: Select all
chmod 750 -R $HOME/.local/share/akonadi/


Yah, it wasn't:
Code: Select all
reg@reg-desktop:~$ chmod 750 -R $HOME/.local/share/akonadi/
chmod: changing permissions of `/home/reg/.local/share/akonadi/': Operation not permitted
chmod: cannot read directory `/home/reg/.local/share/akonadi/': Permission denied
reg@reg-desktop:~$ sudo chmod 750 -R $HOME/.local/share/akonadi/
[sudo] password for reg:
reg@reg-desktop:~$


Okay and more, now i can't even send emails anymore :(
Following is the shell output when i start Kontact, create a new email, enter the address and hit ctrl+c to send it:
it will never send, it just hang in kontact(5499)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Socket access error" - what is that???
:(
Code: Select all
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(5499)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
kontact(5499)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
kontact(5499)/kdeui (kdelibs): No such XML file "/home/reg/.kde/share/apps/kontact/local-kmail.rc"
reg@reg-desktop:~$ 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
reg@reg-desktop:~$ kontact(5499) KMFolderIndex::updateIndexStreamPtr: utime( "/home/reg/.kde/share/apps/kmail/filter/.1.index.ids" , 0) failed (KMMsgDict::getFolderIdsLocation( *this ))
kontact(5499) KMFolderIndex::updateIndexStreamPtr: utime( "/home/reg/.kde/share/apps/kmail/filter/.1.index.ids" , 0) failed (KMMsgDict::getFolderIdsLocation( *this ))                                                     
kontact(5499)/kio (KIOJob) KIO::TransferJob::slotData: mimetype() not emitted when sending first data!; job URL = KUrl("pop3://ron.eggler%40novax.com@pop3.novax.com:110/index") data size = 8
kontact(5499)/kio (KIOJob) KIO::TransferJob::slotData: mimetype() not emitted when sending first data!; job URL = KUrl("pop3://ron.eggler%40novax.com@pop3.novax.com:110/uidl") data size = 8
kontact(5499)/kio (KIOJob) KIO::TransferJob::slotData: mimetype() not emitted when sending first data!; job URL = KUrl("pop3://ron.eggler%40novax.com@pop3.novax.com:110/download/") data size = 0
Enchant dict for "en_US" 0xa3f0100
kontact(5499)/kio (KDirWatch) KDirWatchPrivate::removeEntry: doesn't know "/home/reg/.kde/share/apps/kabc"
Enchant dict for "en_US" 0xa56af40
kontact(5499)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Socket access error"
kontact(5499)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Socket access error"
kontact(5499)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Socket access error"


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Evergrowing, Google [Bot], q.ignora, watchstar