Reply to topic

Akonadi 1.2.1 - some issues

User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS

Re: Akonadi 1.2.1 - some issues

Sat Sep 19, 2009 8:40 pm
@jajaX: that is caused by the KDE session failing to start up. Please check your installation, in particular that all of kdebase-runtime is installed and up to date.


System Settings and Device Actions KCM maintainer
Image
jajaX
Registered Member
Posts
230
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Sat Sep 19, 2009 9:37 pm
ok sorry.


My KDE is unstable it's right. I wait kamric for make new clean installation.


regards
jaja
--------
abit Fatal1ty FP-IN9 SLI/Intel Core 2 Quad Q6600/6041 Mo DDR2/2 Asus silent 8600 Gt 512Mo & ACER Aspire 5612 WLMI : kubuntu Maverick Meerkat 11.04 (32 bits) & KDE SC 4.7 - amarok 2.4.1 - kmail2
SunWukong
Registered Member
Posts
3
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Thu Oct 29, 2009 9:29 pm
Hello

I have the same problem on Kubuntu Karmic, migrated from Jaunty. Thus, I had to install the meta-package mysql-server to force the MySQL server update from 5.0 to 5.1 that was preventing Akonadi to start.

No it starts but I get this :

Code: Select all
Test 4:  ERROR
--------

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

File content of '/home/stephan/.local/share/akonadi/db_data/mysql.err':
091029 22:12:37 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
091029 22:12:37  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091029 22:12:38  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...
091029 22:12:41  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
091029 22:12:45  InnoDB: Started; log sequence number 0 0
091029 22:12:45 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
091029 22:12:45 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
091029 22:12:45 [ERROR] Cannot open mysql.db
091029 22:12:45 [ERROR] Cannot open mysql.user
091029 22:12:45 [ERROR] Cannot open mysql.event
091029 22:12:45 [ERROR] Event Scheduler: An error occurred when initializing system tables.
091029 22:12:45 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log'  socket: '/home/stephan/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Ubuntu)


So I deleted ~/.local/share/akonadi and restart the Akonadi server, but I get the exact same error message above.

In the [TEST 1] section, I see there's a debug entry where Tracer=null.
Maybe a smart value would give more valuable information ?

EDIT :
As the MySQL Server has been upgraded, the database(s) must also be.
Thus, the command mysql_upgrade (mysql_fix_privilege_tables is deprecated) must be issued eventualy with the MySQL root password

sudo mysql_upgrade --password=foobar

But... I think the MySQL databases in /var/lib are upgraded, not Akonadi's
as I still have the error above.
Still searching...
User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS

Re: Akonadi 1.2.1 - some issues

Fri Oct 30, 2009 4:55 am
Akonadi's MySQL database is stored in ~/.local/share/akonadi and its settings in ~/.config/akonadi

You need to check the contents of ~/.config/akonadi/akonadiserverrc and find the "Options" line in the "QMYSQL" section.

You can use that socket setting to access its database when it is running.


System Settings and Device Actions KCM maintainer
Image
SunWukong
Registered Member
Posts
3
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Fri Oct 30, 2009 5:38 pm
Thanks for your help. But there's still something I'm missing.

here's what I did and that failed :

Code: Select all
stephan@orthos:~/.config/akonadi$ mysql_upgrade --socket=/home/stephan/.local/share/akonadi/db_misc/mysql.socket
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/stephan/.local/share/akonadi/db_misc/mysql.socket'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/stephan/.local/share/akonadi/db_misc/mysql.socket' (111) when trying to connect
FATAL ERROR: Upgrade failed


Of course, /home/stephan/.local/share/akonadi/db_misc/mysql.socket is the socket defined in the ~/.config/akonadi/akonadiserverrc

Thanks for your help

Edit :
By the way, as I deleted ~/.local/akonadi/* after upgrading to mysql 5.1 and tried to re-run Akonadi, the current akonadi database has been created from scratch by akonadi itself. Thus, the DB should be all right, with no table missing.
BUT tables are missing. Wouldn't that mean that Kubuntu 9.10 packages a damage akonadi package with some out-of-date SQL file for generating the DB ?

reEDIT :

Code: Select all
mysql> show tables ;
+----------------------------+
| Tables_in_akonadi          |
+----------------------------+
| collectionattributetable   |
| collectionmimetyperelation |
| collectionpimitemrelation  |
| collectiontable            |
| flagtable                  |
| mimetypetable              |
| parttable                  |
| pimitemflagrelation        |
| pimitemtable               |
| resourcetable              |
| schemaversiontable         |
+----------------------------+


Code: Select all
mysql> show tables ;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
+---------------------------------------+
User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS

Re: Akonadi 1.2.1 - some issues

Fri Oct 30, 2009 9:23 pm
The problem is the missing "mysql" database I believe.


System Settings and Device Actions KCM maintainer
Image
User avatar anda_skoa
KDE Developer
Posts
777
Karma
4
OS

Re: Akonadi 1.2.1 - some issues  Topic is solved

Sat Oct 31, 2009 2:18 pm
Someone recently reported on our IRC channel that the following command made it work for them:

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

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.
SunWukong
Registered Member
Posts
3
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Tue Nov 03, 2009 6:17 pm
And it worked as well for me. Thanks a lot ! :-)
iskarion
Registered Member
Posts
1
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Tue Nov 10, 2009 9:10 pm
Thanks, this did solve the problem for me, too (Kubuntu 9.10)

First I was not sure in which order to apply the steps mentioned in this thread. So in case other users are confused about this, too:

- First delete $HOME/.local/share/akonadi including all subfolders
- Manually start Akonadi via System Settings
- mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ (this will throw a bunch of error messages. Just ignore them.)
- mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
- shutdown and start Akondi again.
Sin
Registered Member
Posts
2
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Sun Nov 15, 2009 12:20 pm
I tried the steps described above, but i get an error (other than the usual ones mentioned) after the mysql_install_db command

Code: Select all
mysql_install_db --datadir=/home/philipp/.local/share/akonadi/db_data/
Installing MySQL system tables...
091115 13:09:53 [Warning] Can't create test file /home/philipp/.local/share/akonadi/db_data/philuntu.lower-test
091115 13:09:53 [Warning] Can't create test file /home/philipp/.local/share/akonadi/db_data/philuntu.lower-test
ERROR: 1005  Can't create table 'db' (errno: 13)
091115 13:09:53 [ERROR] Aborting

091115 13:09:53 [Warning] Forcing shutdown of 2 plugins
091115 13:09:53 [Note] /usr/sbin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/home/philipp/.local/share/akonadi/db_data/ for more information.
User avatar anda_skoa
KDE Developer
Posts
777
Karma
4
OS

Re: Akonadi 1.2.1 - some issues

Sun Nov 15, 2009 3:19 pm
Could be a variant of this issue:
http://userbase.kde.org/Akonadi#Apparmor

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.
Sin
Registered Member
Posts
2
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Thu Nov 19, 2009 5:49 pm
Well, i did everything mentioned there about the apparmor issue, then tried the above steps again. The mysql_install_db command fails with the same error message, anyway, i executed the mysql_update command and that seemed to work, akonadi's selftest now succeeds.

Thanks!
Krunchoote
Registered Member
Posts
11
Karma
0
OS

Re: Akonadi 1.2.1 - some issues

Wed Jan 27, 2010 12:58 am
anda_skoa wrote:Someone recently reported on our IRC channel that the following command made it work for them:

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

Cheers,
_
Having followed the thread up to here I got akonadi-1.2.1_1 running without errors.

But after reboot same old errors regarding d-bus are back.

KDE4.3.4@FreeBSD 8.0-RELEASE-p2
mirosol
Registered Member
Posts
2
Karma
0

Re: Akonadi 1.2.1 - some issues

Wed Apr 14, 2010 9:54 pm
iskarion wrote:- First delete $HOME/.local/share/akonadi including all subfolders
- Manually start Akonadi via System Settings
- mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ (this will throw a bunch of error messages. Just ignore them.)
- mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
- shutdown and start Akondi again.


That worked here on lucid beta too. It seems that mysql_install_db with datadir won't work until you've upgraded it. But you'll have to give it the dir before upgrading. So just like Iskarion said.. Just ignore all errors that mysql_install_db gives...
+m
User avatar annew
Manager
Posts
1155
Karma
11
OS

Re: Akonadi 1.2.1 - some issues

Thu Apr 15, 2010 9:15 am
Hmm - I missed the fact that it is kubuntu. I've read elsewhere that the mysql package as shipped caused problems, so these suggestions make sense to me.


annew, proud to be a member of KDE forums since 2008-Oct and a KDE user since 2002.
Join us on http://userbase.kde.org

 
Reply to topic

Bookmarks



Who is online

Registered users: 16777216, alake, Baidu [Spider], Bing [Bot], Exabot [Bot], garthecho, Google [Bot], GordieGii, Hans, koriun, Majestic-12 [Bot], mmistretta, nezumi, onesandzeros, Yahoo [Bot]