[Solved] Akonadi not operational

[Belac Ile]

So Akonadi is not operational. I have never used this but I would like to.
This is what it gives me when I click on details:

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

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

File content of '/home/kei/.local/share/akonadi/db_data/mysql.err':
091031 15:07:08 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
091031 15:07:08 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091031 15:07:08 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 64 MB
InnoDB: Database physically writes the file full: wait...
091031 15:07:09 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
091031 15:07:11 InnoDB: Started; log sequence number 0 0
091031 15:07:11 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
091031 15:07:11 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
091031 15:07:11 [ERROR] Cannot open mysql.db
091031 15:07:11 [ERROR] Cannot open mysql.user
091031 15:07:11 [ERROR] Cannot open mysql.event
091031 15:07:11 [ERROR] Event Scheduler: An error occurred when initializing system tables.
091031 15:07:11 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log' socket: '/home/kei/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)
091031 15:35:08 [Note] /usr/sbin/mysqld-akonadi: Normal shutdown

091031 15:35:08 InnoDB: Starting shutdown...
091031 15:35:10 InnoDB: Shutdown completed; log sequence number 0 124912
091031 15:35:10 [Warning] Forcing shutdown of 1 plugins
091031 15:35:10 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete

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

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

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: 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 12: 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
distlistresource.desktop
gcalresource.desktop
googledataresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
microblog.desktop
nepomukcontactfeeder.desktop
nepomukemailfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
strigifeeder.desktop
vcarddirresource.desktop
vcardresource.desktop
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
distlistresource.desktop
gcalresource.desktop
googledataresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
microblog.desktop
nepomukcontactfeeder.desktop
nepomukemailfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
strigifeeder.desktop
vcarddirresource.desktop
vcardresource.desktop

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

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

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

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

I only put up skips and errors. Everything was successful.

Thanks for any help.

[Tynach]

Re: Akonadi not operational

Not sure if it's the same problem, but go to the Akonadi config where it fails to start, and then click on the "Akonadi Server Configuration" tab. Near the bottom, click "Start". It will be next to "Restart".

If it still does not start, then try this:

akonadictl start

in a konsole.

I just put that command as one of my autostart programs, since Akonadi refuses to start on it's own.

[gnerdman]

Re: Akonadi not operational

I upgraded from 9.04 to 9.10. This akonadi problem seems to be widespread with no real solutions offered. I can add a little info, but I don't have a cure. When I try to run /usr/sbin/mysqld-akonadi from the command line, I get the following:

091102 21:05:09 [Warning] Can't create test file /var/lib/mysql/serenity.lower-test
091102 21:05:09 [Warning] Can't create test file /var/lib/mysql/serenity.lower-test
091102 21:05:09 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld-akonadi: Table 'mysql.plugin' doesn't exist
091102 21:05:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
091102 21:05:09 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

There's something seriously horked here, and I don't see Canonical stepping up to fix it - or even acknowledge it. I've also had lots of other stuff just die randomly - possibly related to this. Things like "Sorry, the program kwin closed unexpectedly" or "Sorry, the program kde-apport closed unexpectedly" or "Sorry, the program...." Pretty much just everything dying randomly all over the place. Overall, Karmic is a complete disaster. I swear, it really pisses me off when vendors release crap just to stay on schedule. Argh!

[Belac Ile]

Re: Akonadi not operational

Awesome it started up with that.

I just put that command as one of my autostart programs, since Akonadi refuses to start on it's own.

I was wondering how you added the command to autostart. Or I guess what file do I need to sudo kate and add it to?

[Tynach]

Re: Akonadi not operational

Awesome it started up with that.

I just put that command as one of my autostart programs, since Akonadi refuses to start on it's own.

I was wondering how you added the command to autostart. Or I guess what file do I need to sudo kate and add it to?

In the 'Advanced' tab in System Settings, simply click Autostart, then click the 'Add Program...' button. The very top text bar on the pop-up window is what you type the command into. Simple as that.

Edit1:

There's something seriously horked here, and I don't see Canonical stepping up to fix it - or even acknowledge it. I've also had lots of other stuff just die randomly - possibly related to this. Things like "Sorry, the program kwin closed unexpectedly" or "Sorry, the program kde-apport closed unexpectedly" or "Sorry, the program...." Pretty much just everything dying randomly all over the place. Overall, Karmic is a complete disaster. I swear, it really pisses me off when vendors release crap just to stay on schedule. Argh!

Well, I don't know about you, but Karmic has been the smooooothest Linux experience I've ever had. Minor problems like this... Very minor. I've had a few programs crash... When I close out of them on purpose, and it somehow thinks it was a crash. Whatever that's supposed to mean. I closed the X, clicked on File > Quit, whatever...

Occasionally Plasma dies on me, very rarely. It always restarts almost immediately. Sometimes the display becomes inactive, and I switch to a TTY (I use Ctrl+Alt+F6 usually) then back (Ctrl+Alt+F7).

Finally, everything works. Nepomuk works fine (just not strigi, which I'd likely never use anyway... Just love to tweak my desktop to perfection), and even sleep mode finally works (a first for me with Linux). It seems rock solid for my purposes, with no graphical glitches despite having an nVidia graphics card (I point to the issues with nVidia cards we had before).

So, you're the exception and not the rule.

Edit2: Note: I had a fresh install with the new ext4, instead of a web upgrade with the old ext3. If you 'upgraded', you may not have as smooth an experience, and I wouldn't be able to judge if it's the norm or not.

[Belac Ile]

Re: Akonadi not operational

In the 'Advanced' tab in System Settings, simply click Autostart, then click the 'Add Program...' button. The very top text bar on the pop-up window is what you type the command into. Simple as that.

oh thats a lot easier then I thought.. Thanks for your help.

There's something seriously horked here, and I don't see Canonical stepping up to fix it - or even acknowledge it. I've also had lots of other stuff just die randomly - possibly related to this. Things like "Sorry, the program kwin closed unexpectedly" or "Sorry, the program kde-apport closed unexpectedly" or "Sorry, the program...." Pretty much just everything dying randomly all over the place. Overall, Karmic is a complete disaster. I swear, it really pisses me off when vendors release crap just to stay on schedule. Argh!

I also have a fresh install with ext4 and my problems seem to be knowledge based more then anything. If you are having that much trouble then perhaps a reinstall in order, or maybe various packets need to be reinstalled. Thus far, I have noticed that my desktop environment is running faster and smoother then before. I most definitely did not get to this point without adversity. I tried to update initially , and that screwed up hardcore. I did a fresh install, then managed to break it twice, both of which I fixed by reinstalling kubuntu-desktop.

[Tynach]

Re: Akonadi not operational

Heh... Because I had KDE 3.5.x installed on Jaunty, it just plain wouldn't LET me upgrade. I tried.

Meh, fresh install is better anyway. I had an external 1TB hard drive to back up my home folder on anyway.

[Belac Ile]

Re: Akonadi not operational

Heh... Because I had KDE 3.5.x installed on Jaunty, it just plain wouldn't LET me upgrade. I tried.

Meh, fresh install is better anyway. I had an external 1TB hard drive to back up my home folder on anyway.

haha.. I had to boot in with a live cd and copy my files off that way.. oh, it was a FUN weekend. But now everything is better then normal.