Archive:Http://userbase.kde.org/Akonadi 4.4/Troubleshooting/nl: Difference between revisions

From KDE UserBase Wiki
(Created page with 'Als het logboek van de MySQL server de volgende foutmelding bevat: :::{|style="width:98%; border:2px dotted #BCBCBC;" |[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_...')
(Updating to match new version of source page)
Line 1: Line 1:
{{Template:I18n/Language Navigation Bar|Akonadi 4.4/Troubleshooting}}
<languages />
<languages />
==Inleiding==
==Inleiding==
Line 15: Line 14:
== Tips voor het oplossen van problemen ==
== Tips voor het oplossen van problemen ==


<span class="mw-translate-fuzzy">
* Voeg bij het melden van problemen met de '''Akonadi'''server altijd het uitgebreide zelftestrapport toe.
* Voeg bij het melden van problemen met de '''Akonadi'''server altijd het uitgebreide zelftestrapport toe.
U kunt dit rapport aanmaken dor het dialoogvenster zelftest dat automatisch wordt weergegeven als de '''Akonadi'''server niet kon opstarten.
U kunt dit rapport aanmaken dor het dialoogvenster zelftest dat automatisch wordt weergegeven als de '''Akonadi'''server niet kon opstarten.
De zelftest staat in de kcmmodule, die toegankelijk is via:
De zelftest staat in de kcmmodule, die toegankelijk is via:
     kcmshell4 kcm_akonadi
     kcmshell4 kcm_akonadi
 
</span>
      kcmshell4 kcm_akonadi
<span class="mw-translate-fuzzy">
* Het handmatig starten van de '''Akonadi'''server vanaf de commandoregels kan ook bruikbare informatie opleveren. Doe door in een console het volgende commando uit te voeren:
* Het handmatig starten van de '''Akonadi'''server vanaf de commandoregels kan ook bruikbare informatie opleveren. Doe door in een console het volgende commando uit te voeren:
     akonadictl start
     akonadictl start
Line 26: Line 28:
Dit commando kan ook extra informatie geven:
Dit commando kan ook extra informatie geven:
     akonadictl status
     akonadictl status
 
</span>
      akonadictl start
Similarly, with this command the Akonadi server can be stopped again:
      akonadictl stop
This command gives more useful information:
      akonadictl status
== Veelvoorkomende problemen ==
== Veelvoorkomende problemen ==


Line 37: Line 44:
'''Kontact''' has been known to be hit after an update.  If this happens, try starting '''KMail''', '''KOrganizer''' or any of the other applications from '''KRunner''' (or '''Konsole''').  Chances are high that they will work as stand-alone apps while you find what went wrong.  This mainly affects version 4.4.0.
'''Kontact''' has been known to be hit after an update.  If this happens, try starting '''KMail''', '''KOrganizer''' or any of the other applications from '''KRunner''' (or '''Konsole''').  Chances are high that they will work as stand-alone apps while you find what went wrong.  This mainly affects version 4.4.0.


===Map niet gevonden: "/Local"===
===Folder not found: "/Local"=== <!--T:13-->


Some people have reported this error, when '''Kontact''' would not start.  In some early versions of 4.4 there seems to be a bug in the migration that is telling '''KMail''' to look for local mail in ~/.local/share/Local, a directory that had not been set up.  The cure for this is not to attempt to correct it, but, with '''KMail'''/'''Kontact''' closed, to open the '''Akonadi Console''' (use '''krunner''',  
Some people have reported this error, when '''Kontact''' would not start.  In some early versions of 4.4 there seems to be a bug in the migration that is telling '''KMail''' to look for local mail in ~/.local/share/Local, a directory that had not been set up.  The solution for this is not to attempt to correct it, but, with '''KMail'''/'''Kontact''' closed, to open the '''Akonadi Console''':
      Alt-F2
* Use '''krunner''', Alt-F2, or
or  
* "akonadiconsole" '''konsole'''
      akonadiconsole
 
in '''konsole'''), and remove the resource that it says is for local mail.  You should now find that you can start '''Kontact''' or '''KMail''', and that a new resource will be created, pointing to ~/.local/share/local-mail
Then remove the resource that it says is for local mail.  You should now find that you can start '''Kontact''' or '''KMail''', and that a new resource will be created, pointing to ~/.local/share/local-mail


===Er staan andere nieuwe mappen in ~/.local/share/===
===Er staan andere nieuwe mappen in ~/.local/share/===
Line 67: Line 74:
If this does not help (or if the option was already checked when you got the error) and if you have previously been using prereleases of '''KDE SC 4.4''', you may be affected by a change to the database layout (due to an upgrade of the '''Virtuoso''' database server from version 5 to version 6; production releases of '''KDE SC 4.4''' are expected to be shipped with '''Virtuoso''' version 6). The following commands should get it working again:
If this does not help (or if the option was already checked when you got the error) and if you have previously been using prereleases of '''KDE SC 4.4''', you may be affected by a change to the database layout (due to an upgrade of the '''Virtuoso''' database server from version 5 to version 6; production releases of '''KDE SC 4.4''' are expected to be shipped with '''Virtuoso''' version 6). The following commands should get it working again:


<!--T:97-->
:::{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
:::{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
| qdbus org.kde.NepomukServer /nepomukserver org.kde.NepomukServer.quit
| qdbus org.kde.NepomukServer /nepomukserver org.kde.NepomukServer.quit
Line 83: Line 91:
In '''Kontact''', '''Nepomuk''' is used for many different things, ranging from displaying upcoming birthdays, over handling free/busy lists to showing a contact photo in the message viewer. If '''Nepomuk''' is not running, several different things in '''Kontact''' will cease to work. The notice is there to warn you about the reduced functionality. Enabling '''Nepomuk''' as described above fixes the problem.
In '''Kontact''', '''Nepomuk''' is used for many different things, ranging from displaying upcoming birthdays, over handling free/busy lists to showing a contact photo in the message viewer. If '''Nepomuk''' is not running, several different things in '''Kontact''' will cease to work. The notice is there to warn you about the reduced functionality. Enabling '''Nepomuk''' as described above fixes the problem.


<span class="mw-translate-fuzzy">
U kunt controleren of '''Nepomuk''' correct draait met dit commando:
U kunt controleren of '''Nepomuk''' correct draait met dit commando:
       akonadictl status
       akonadictl status
 
</span>
      akonadictl status
===Ik wil mijn huidige adresboek en agenda gebruiken. Kan dat?===
===Ik wil mijn huidige adresboek en agenda gebruiken. Kan dat?===


Line 104: Line 114:
Old framework: In ''akonadiconsole'', add a "KDE Address Book (traditional)".  The KDE Address Book means you can set up old kresources for '''Akonadi'''.  In the configuration of "KDE Address Book (traditional)", you point it to an "IMAP over KMail" ''KResource'' and in '''KMail''', the groupware options should be enabled.  This should work for '''Kolab''', '''eGroupware''' and similar addressbooks - you will need to check the options to make sure that the correct type is selected.
Old framework: In ''akonadiconsole'', add a "KDE Address Book (traditional)".  The KDE Address Book means you can set up old kresources for '''Akonadi'''.  In the configuration of "KDE Address Book (traditional)", you point it to an "IMAP over KMail" ''KResource'' and in '''KMail''', the groupware options should be enabled.  This should work for '''Kolab''', '''eGroupware''' and similar addressbooks - you will need to check the options to make sure that the correct type is selected.


New framework (only tested with '''Kolab'''): In the '''Akonadi''' configuration module (run
New framework (only tested with '''Kolab'''): In the '''Akonadi''' configuration module add an "IMAP E-Mail Server" resource, and set up your mail server name, username and password, then click '''Auto-Detect'''. Run this command to see it:
       kcmshell4 kcm_akonadi
       kcmshell4 kcm_akonadi
to see it), add an "IMAP E-Mail Server" resource, and set up your mail server name, username and password, then click '''Auto-Detect'''. Then add a '''Kolab''' resource. The next step is to wait for the imap resource to synchronize, which can take quite a long time. The status will appear in the '''Akonadi''' configuration module. If nothing happens, try restarting '''akonadiserver'''. After some time the '''Kolab''' addressbook(s) should appear in '''KAddressBook'''.
Then add a '''Kolab''' resource. The next step is to wait for the imap resource to synchronize, which can take quite a long time. The status will appear in the '''Akonadi''' configuration module. If nothing happens, try restarting '''akonadiserver'''. After some time the '''Kolab''' addressbook(s) should appear in '''KAddressBook'''.


===Er zijn lange vertragingen bij het verzenden van e-mail===
===Er zijn lange vertragingen bij het verzenden van e-mail===
Line 115: Line 125:


Close '''Kontact''', or '''KMail''' and '''KAddressbook''' if you are running  
Close '''Kontact''', or '''KMail''' and '''KAddressbook''' if you are running  
stand-alone apps.  Disable '''Strigi''' in '''SystemSettings'''.  Stop '''Nepomuk''', delete the database and restart '''nepomukserver'''.  The actual commands you need are (as user)
stand-alone apps.  Disable '''Strigi''' in '''SystemSettings'''.  Stop '''Nepomuk''', delete the database and restart '''nepomukserver'''.  The actual commands you need are (as user):


<!--T:42-->
:::{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
:::{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
|qdbus org.kde.NepomukServer /nepomukserver org.kde.NepomukServer.quit
|qdbus org.kde.NepomukServer /nepomukserver org.kde.NepomukServer.quit
Line 152: Line 163:
|}
|}


You can solve this by running  
You can solve this by running the following command with root privileges then reload apparmor:
       aa-complain mysqld  
       aa-complain mysqld  
with root privileges then reload apparmor.
 
On ''Kubuntu'' this is:  
On ''Kubuntu'' this is:
   
   
       sudo aa-complain mysqld
       sudo aa-complain mysqld
Line 164: Line 175:
Also note that some distributions ship an additional '''mysqld''' binary called '''mysqld-akonadi''' which has '''AppArmor''' set up correctly. If that's the case on your system and you see this problem nevertheless, there are two possible reasons:
Also note that some distributions ship an additional '''mysqld''' binary called '''mysqld-akonadi''' which has '''AppArmor''' set up correctly. If that's the case on your system and you see this problem nevertheless, there are two possible reasons:
* '''Akonadi''' still uses '''mysqld''' instead of '''mysqld-akonadi'''. You can change that in <menuchoice>Systemsettings -> Advanced -> Akonadi -> Server configuration</menuchoice>.
* '''Akonadi''' still uses '''mysqld''' instead of '''mysqld-akonadi'''. You can change that in <menuchoice>Systemsettings -> Advanced -> Akonadi -> Server configuration</menuchoice>.
* '''AppArmor''' is not setup correctly for '''mysqld-akonadi''' either. Try running the
* '''AppArmor''' is not setup correctly for '''mysqld-akonadi''' either. Try running the "aa-complain" command noted above with '''mysqld-akonadi''' instead of '''mysqld'''.  
      aa-complain  
command noted above with '''mysqld-akonadi''' instead of '''mysqld'''''.


<!--T:54-->
---
---


You will also experience this problem if you are running an encrypted home directory using encryptfs combined with '''AppArmor''' as the '''Akonadi apparmor''' profile currently does not account for an ecrypted home (common with ''Ubuntu Jaunty'' users).  Error messages with include:
You will also experience this problem if you are running an encrypted home directory using encryptfs combined with '''AppArmor''' as the '''Akonadi apparmor''' profile currently does not account for an ecrypted home (common with ''Ubuntu Jaunty'' users).  Error messages with include:
* dmesg produces:  
* dmesg produces:
       ecryptfs_do_create: Failure to create dentry in lower fs; rc = [-13]
       ecryptfs_do_create: Failure to create dentry in lower fs; rc = [-13]
       ecryptfs_create: Failed to create file inlower filesystem
       ecryptfs_create: Failed to create file inlower filesystem
Line 177: Line 187:
       Akonadi server process not registered at D-Bus
       Akonadi server process not registered at D-Bus


<span class="mw-translate-fuzzy">
Dit is op te lossen door het bestand "/etc/apparmor.d/usr.sbin.mysqld-akonadi" aan te passen.
Dit is op te lossen door het bestand "/etc/apparmor.d/usr.sbin.mysqld-akonadi" aan te passen.
Voeg onder de regel:  
Voeg onder de regel:  
       @{HOME}/.local/share/akonadi/** rwk,
       @{HOME}/.local/share/akonadi/** rwk,
Een nieuwe regel toe:
Een nieuwe regel toe:
      @{HOME}/.Private/** rwk,
</span>
      @{HOME}/.local/share/akonadi/** rwk,
Add a new line:
       @{HOME}/.Private/** rwk,
       @{HOME}/.Private/** rwk,


Herstart '''apparmor''' en herstart '''akonadi'''.
Herstart '''apparmor''' en herstart '''akonadi'''.


===Ontbrekende voorwaarde===
===Ontbrekende voorwaarde===
Line 193: Line 207:
* Dee ''Qt4 MySQL plugin'' (die heet ''libqt4-sql-mysql'' in ''openSUSE'')
* Dee ''Qt4 MySQL plugin'' (die heet ''libqt4-sql-mysql'' in ''openSUSE'')


If you compile Qt4 yourself, make sure to tell the configure script to build in MySQL support by passing it the  
If you compile Qt4 yourself, make sure to tell the configure script to build in MySQL support by passing it the following option:
  -plugin-sql-mysql
  -plugin-sql-mysql
option.  If "configure" cannot locate the necessary MySQL client code (i.e, says "MySQL support cannot be enabled due to functionality tests") then ensure that the corresponding package is installed (typically called ''[lib]mysql[client]-dev[el]''). Also, depending on the install location of the MySQL headers, additional parameters to "configure" might be needed (eg. "-I /usr/include/mysql" on ''OpenSuse'').
If "configure" cannot locate the necessary MySQL client code (i.e, says "MySQL support cannot be enabled due to functionality tests") then ensure that the corresponding package is installed (typically called ''[lib]mysql[client]-dev[el]''). Also, depending on the install location of the MySQL headers, additional parameters to "configure" might be needed (eg. "-I /usr/include/mysql" on ''OpenSuse'').


<span class="mw-translate-fuzzy">
Als u de Qt4 rechtstreeks van ''Nokia'' krijgt, zoals een download van:
Als u de Qt4 rechtstreeks van ''Nokia'' krijgt, zoals een download van:
     qt-sdk-linux-x86_64-opensource-2009.05.bin
     qt-sdk-linux-x86_64-opensource-2009.05.bin
</span>


dan krijgt u een foutmelding bij Test 1 met het commando "akonadictl start":
<!--T:99-->
 
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|  Database driver not found.
|  Database driver not found.
|-
|-
Bijzonderheden: De QtSQL-driver "QMYSQL" is vereist door uw huidige Akonadi-serverconfiguratie.  
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration.
|-
|-
De volgende drivers zijn geinstalleerd: QSQLITE.
The following drivers are installed: QSQLITE.
|-
|-
Zorg dat de driver is geinstalleerd.
Make sure the required driver is installed.
|}
|}


U hebt de driver ''libqsqlmysql.so'' nodig.
U hebt de driver ''libqsqlmysql.so'' nodig.


<span class="mw-translate-fuzzy">
Helaas is deze driver is geen onderdeel van de distributie (tot januari 2010).  
Helaas is deze driver is geen onderdeel van de distributie (tot januari 2010).  
U moet de broncode compileren. Download deze:
U moet de broncode compileren. Download deze:
     qt-everywhere-opensource-src-4.6.0.tar.bz
     qt-everywhere-opensource-src-4.6.0.tar.bz
</span>
      qt-everywhere-opensource-src-4.6.0.tar.bz


''configure'' and ''make'' as above. But the ''make install'' doesn't copy the driver. So you have to copy it by yourself:
Then ''configure'' and ''make'' as above. But the ''make install'' doesn't copy the driver. So you have to copy it by yourself:
{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
|cp <qt-src-dir>/qt-everywhere-opensource-src-4.6.0/plugins/sqldrivers/libqsqlmysql.so /usr/local/bin/sqldrivers/
|cp <qt-src-dir>/qt-everywhere-opensource-src-4.6.0/plugins/sqldrivers/libqsqlmysql.so /usr/local/bin/sqldrivers/
Line 229: Line 247:
The '''Akonadi''' server searches for '''Akonadi''' agents and resources in the paths defined in the ''XDG_DATA_DIRS'' environment variable. If '''Akonadi''' complains about not finding agents or resources, check if this variable is set correctly. Also keep in mind that even if set in a current console session, it might not have been set when starting the server. Starting the server manually in the current console session excludes this cause.
The '''Akonadi''' server searches for '''Akonadi''' agents and resources in the paths defined in the ''XDG_DATA_DIRS'' environment variable. If '''Akonadi''' complains about not finding agents or resources, check if this variable is set correctly. Also keep in mind that even if set in a current console session, it might not have been set when starting the server. Starting the server manually in the current console session excludes this cause.


=== mysqld: unknown variable 'innodb_file_per_table=1' ===
=== mysqld: unknown variable 'innodb_file_per_table=1' === <!--T:69-->


<span class="mw-translate-fuzzy">
Als het logboek van de MySQL server de volgende foutmelding bevat:
Als het logboek van de MySQL server de volgende foutmelding bevat:
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
|-
|[ERROR] Aborting
|}
</span>
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
|[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
Line 238: Line 263:
|}
|}


Try adding:


then your MySQL server was built without the InnoDB support which is required by '''Akonadi''' or '''InnoDB''' needs to be loaded in your ''mysql.conf'' file. Try adding:
<!--T:100-->
 
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|  #sql_mode=strict_trans_tables <- Toevoegen onder deze regel
|  #sql_mode=strict_trans_tables <- Add underneath this line
|-
|-
|  #plugins
|  #plugins
|-
|-
|  plugin_dir=usr/lib/mysql/plugin < - Dit pad kan verschillen
|  plugin_dir=usr/lib/mysql/plugin < - This may be a different path
|-
|-
|  plugin-load=ha_innodb.so
|  plugin-load=ha_innodb.so
|}
|}
===Table 'mysql. servers' doesn't exist===
===Table 'mysql. servers' doesn't exist===


If MySQL server log contains the following error:
If MySQL server log contains the following error, then, most probably, you don't have your MySQL configuration file in place:


<!--T:102-->
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
|[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Line 265: Line 290:
|}
|}


then, most probably, you don't have your MySQL configuration file in place. Copy it from ''/usr/share/config/akonadi/mysql-global.conf'' into ''~/.config/akonadi/mysql-local.conf''. (For ''debian'' and ''openSuSE'' users the file ist located in ''/etc/akonadi/mysql-global.conf''). Then open it and uncomment the line '''sql_mode=strict_trans_tables'''. If, after that, you get the following errors:
Copy it from ''/usr/share/config/akonadi/mysql-global.conf'' into ''~/.config/akonadi/mysql-local.conf''. (For ''debian'' and ''openSuSE'' users the file ist located in ''/etc/akonadi/mysql-global.conf''). Then open it and uncomment the line '''sql_mode=strict_trans_tables'''. After that, you may get the following errors:


<!--T:104-->
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
| [ERROR] Plugin 'InnoDB' init function returned error.
| [ERROR] Plugin 'InnoDB' init function returned error.
Line 277: Line 303:
|}
|}


then in the same file find the line that starts just like the one above (which you have uncommented), but has additional parameters, separated by commas (something like '''sql_mode=strict_trans_tables,strict_all_tables, ...etc'''). Comment the shorter ''sql_mode=...'' line and uncomment the longer one.
If so, then in the same file find the line that starts just like the one above (which you have uncommented), but has additional parameters, separated by commas (something like '''sql_mode=strict_trans_tables,strict_all_tables, ...etc'''). Comment the shorter ''sql_mode=...'' line and uncomment the longer one.


On ''openSUSE 11.2'' running the command
On ''openSUSE 11.2'' running the following command will fix this problem:


       mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
       <!--T:106-->
 
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
lost dit probleem op.


=== Bijwerken naar Kubuntu 10.4 ===
=== Bijwerken naar Kubuntu 10.4 ===
Line 308: Line 333:
The mysql_install_db command above will report something like what follows, which you can safely ignore:
The mysql_install_db command above will report something like what follows, which you can safely ignore:


<!--T:108-->
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|Installing MySQL system tables...
|Installing MySQL system tables...
Line 321: Line 347:
=== KAddressBook upgraden ===
=== KAddressBook upgraden ===


In addition to the ''Kubuntu 10.4'' remedy above, problems trying to add a ''Vcard directory'' may require
In addition to the ''Kubuntu 10.4'' remedy above, problems trying to add a ''Vcard directory'' may require the following command while '''Akonadi''' is not running:
:::{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
:::{|style="width:98%; border:2px dotted #BCBCBC; background:#EEEEEE;"
|rm -rf $HOME/.config/akonadi
|rm -rf $HOME/.config/akonadi
|}
|}
while Akonadi is not running.
=== Can't initialize character set latin1 ===
=== Can't initialize character set latin1 ===


<span class="mw-translate-fuzzy">
Als u de volgende foutmelding krijgt bij het starten van Akonadi, dan gebruikt u waarschijnlijk een versie van MySQL server met een versie hoger dan 5.1.42.
Als u de volgende foutmelding krijgt bij het starten van Akonadi, dan gebruikt u waarschijnlijk een versie van MySQL server met een versie hoger dan 5.1.42.
</span>


<!--T:84-->
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|Character set 'latin1' is not a compiled character set and is not specified in
|Character set 'latin1' is not a compiled character set and is not specified in
Line 361: Line 388:
|}
|}


Er is een bekende regressie in MySQL 5.1.43 en 5.1.44 waardoor MySQL niet kan worden gestart.  
<span class="mw-translate-fuzzy">
Er is een bekende regressie in MySQL 5.1.43 en 5.1.44 waardoor MySQL niet kan worden gestart.
</span>


See [http://bugs.kde.org/226960 the bug report] for more details.
See [http://bugs.kde.org/226960 the bug report] for more details.
Line 368: Line 397:
=== Herstarten na een eerdere fout ===
=== Herstarten na een eerdere fout ===


If you had problems starting '''Akonadi''' and fixed those (such as a missing package or the '''Apparmor''' problem) make sure that the '''Akonadi''' server is completely shut down before trying to start it again, by calling
If you had problems starting '''Akonadi''' and fixed those (such as a missing package or the '''Apparmor''' problem) make sure that the '''Akonadi''' server is completely shut down before trying to start it again, by calling on the command line:
       akonadictl stop  
       akonadictl stop  
on the command line. You can confirm that it was indeed shut down completely by running
You can confirm that it was indeed shut down completely by running:
       akonadictl status
       akonadictl status


Line 379: Line 408:
That's an especially nasty problem that so far only affects users of source-based distributions, most prominently ''Gentoo''. It is named after MySQL assertions like the following example and is most likely caused by a MySQL protocol mismatch between the MySQL server and the client library or the Qt MySQL driver.
That's an especially nasty problem that so far only affects users of source-based distributions, most prominently ''Gentoo''. It is named after MySQL assertions like the following example and is most likely caused by a MySQL protocol mismatch between the MySQL server and the client library or the Qt MySQL driver.


<!--T:92-->
:::{|style="width:98%; border:2px dotted #BCBCBC;"
:::{|style="width:98%; border:2px dotted #BCBCBC;"
|akonadiserver: libmysql.c:4301: setup_one_fetch_function: Assertion
|akonadiserver: libmysql.c:4301: setup_one_fetch_function: Assertion

Revision as of 12:30, 27 June 2010

Inleiding

Deze pagina gaat voornamelijk over het oplossen van problemen met Akonadi. Storingen zijn onvermijdelijk in de vroege stadia van de migratie. Veel mensen zijn de eerste tekenen vanAkonadi in KDE 4.4 SC en het zal velen verwarren. Voor een korte beschrijving van het doel van Akonadi, zie de Woordenlijst. Daar staan ook nuttige verwijzingen naar meer informatie. Zodra de onvermijdelijke aanloopproblemen voorbij zijn, is Akonadi een power-house dat bruikbaar is voor vele toepassingen.

De structuur begrijpen

U kunt natuurlijk ook gewoonKontact gebruiken om al uw adresboeken te beheren, maar als u een bijvoorbeeld back-upsysteem hebt, wilt u weten waar uw gegevens zijn en daarmee wordt omgegaan. Dat staat beschreven op de pagina Akonadi en AddressBook

Tips voor het oplossen van problemen

  • Voeg bij het melden van problemen met de Akonadiserver altijd het uitgebreide zelftestrapport toe.

U kunt dit rapport aanmaken dor het dialoogvenster zelftest dat automatisch wordt weergegeven als de Akonadiserver niet kon opstarten. De zelftest staat in de kcmmodule, die toegankelijk is via:

    kcmshell4 kcm_akonadi

     kcmshell4 kcm_akonadi

  • Het handmatig starten van de Akonadiserver vanaf de commandoregels kan ook bruikbare informatie opleveren. Doe door in een console het volgende commando uit te voeren:
    akonadictl start

Stop Akonadi met het volgende commando:

    akonadictl stop

Dit commando kan ook extra informatie geven:

    akonadictl status

     akonadictl start 

Similarly, with this command the Akonadi server can be stopped again:

     akonadictl stop

This command gives more useful information:

     akonadictl status

Veelvoorkomende problemen

Kontact start niet en geeft geen informatie

If Kontact doesn't start, and you see no error messages, check that Akonadi is running. Akonadi should start on demand. If yours doesn't, you will have to start it before Kontact will start up if you have any migrated resources (most likely KAddressBook). Use the Akonadi Tray icon (get this by typing "akonadi" into KRunner) or type the commands into konsole to start it.

Kontact start niet, versie II

Kontact has been known to be hit after an update. If this happens, try starting KMail, KOrganizer or any of the other applications from KRunner (or Konsole). Chances are high that they will work as stand-alone apps while you find what went wrong. This mainly affects version 4.4.0.

Folder not found: "/Local"

Some people have reported this error, when Kontact would not start. In some early versions of 4.4 there seems to be a bug in the migration that is telling KMail to look for local mail in ~/.local/share/Local, a directory that had not been set up. The solution for this is not to attempt to correct it, but, with KMail/Kontact closed, to open the Akonadi Console:

  • Use krunner, Alt-F2, or
  • "akonadiconsole" konsole

Then remove the resource that it says is for local mail. You should now find that you can start Kontact or KMail, and that a new resource will be created, pointing to ~/.local/share/local-mail

Er staan andere nieuwe mappen in ~/.local/share/

Ja. Als uw adresboek correct is gemigreerd, wordt een nieuwe bron aangemaakt als ~/.local/share/contacts/.

Wat zijn /usr/bin/akonadi_maildir_resource en /usr/bin/akonadi_maildispatcher_agent?

The akonadi_maildir_resource is created automatically by the akonadi_maildispatcher_agent, while the latter is always started together with the Akonadi server as it provides basic functionality (e.g. sending mail) that is used by all mail applications that are (and will be) based on Akonadi. So it is ok that these two are running, as a user you can simply ignore them. This autogenerated akonadi_maildir_resource will always point to ~/.local/share/local-mail/ which is your "Local folders" account where your local folders and emails will be stored.

E-mail wordt op dit moment in KDE SC 4.4 nog niet gemigreerd.

Nepomuk Indexing Agents zijn uitgeschakeld

Kontact werkt nu, maar u blijft de volgende melding zien:

The most common reason for this notice is that Nepomuk is simply disabled in System Settings. Please try enabling it in System Settings under Advanced -> Desktop Search -> Basic Settings by checking "Nepomuk Semantik Desktop" and clicking "Apply".

If this does not help (or if the option was already checked when you got the error) and if you have previously been using prereleases of KDE SC 4.4, you may be affected by a change to the database layout (due to an upgrade of the Virtuoso database server from version 5 to version 6; production releases of KDE SC 4.4 are expected to be shipped with Virtuoso version 6). The following commands should get it working again:

qdbus org.kde.NepomukServer /nepomukserver org.kde.NepomukServer.quit
rm -r ~/.kde/share/apps/nepomuk
rm -r ~/.kde4/share/apps/nepomuk
nepomukserver

Note that the above commands will not enable Nepomuk permanently if it isn't already enabled, you have to use System Settings for that.

A running Nepomuk is necessary to have a working Akonadi, and thus a working Kontact. However, you can disable the Strigi file indexer, which is not needed for Kontact. Strigi file indexing is used for desktop searching only, which is unrelated to Kontact. Just make sure Nepomuk itself is running correctly for Kontact.

In Kontact, Nepomuk is used for many different things, ranging from displaying upcoming birthdays, over handling free/busy lists to showing a contact photo in the message viewer. If Nepomuk is not running, several different things in Kontact will cease to work. The notice is there to warn you about the reduced functionality. Enabling Nepomuk as described above fixes the problem.

U kunt controleren of Nepomuk correct draait met dit commando:

     akonadictl status

     akonadictl status

Ik wil mijn huidige adresboek en agenda gebruiken. Kan dat?

Yes. When you use the Akonadi Console to add a resource it allows you to choose as Standard Addressbook - point that to your std.vcf should work fine. Migration does not destroy your old addressbook. You can continue to use it, though you will lose any benefits that Akonadi can bring. Alternatively you can have both an Akonadi addressbook and your original one, for a time, if you feel safer that way.

Ik zie geen gegevens in mijn adresboek

At the moment, the cause of this is not identified, but the cure is simple. Close Kontact, and start KAddressBook as a stand-alone application. After you close it you will be able to use it within Kontact. It seems that something is not being triggered when Kontact launches, and I expect this to be identified and fixed soon. This seems to mainly affect version 4.4.0.

Mijn contacten worden niet weergegeven als ik op Selecteren klik in KMail

Check System Settings -> Advanced tab -> KDE Resources. Make sure that your Akonadi controlled address book(s) are listed there - add them if necessary. At the same time, it's a good idea to make your main Akonadi addressbook, usually called "Personal Contacts", is set to be the default. More details of how this can be found in here.

Hoe krijg ik mijn groupwareadresboek terug?

Twee oplossingen: met het oude framework of met het nieuwe.

Old framework: In akonadiconsole, add a "KDE Address Book (traditional)". The KDE Address Book means you can set up old kresources for Akonadi. In the configuration of "KDE Address Book (traditional)", you point it to an "IMAP over KMail" KResource and in KMail, the groupware options should be enabled. This should work for Kolab, eGroupware and similar addressbooks - you will need to check the options to make sure that the correct type is selected.

New framework (only tested with Kolab): In the Akonadi configuration module add an "IMAP E-Mail Server" resource, and set up your mail server name, username and password, then click Auto-Detect. Run this command to see it:

     kcmshell4 kcm_akonadi

Then add a Kolab resource. The next step is to wait for the imap resource to synchronize, which can take quite a long time. The status will appear in the Akonadi configuration module. If nothing happens, try restarting akonadiserver. After some time the Kolab addressbook(s) should appear in KAddressBook.

Er zijn lange vertragingen bij het verzenden van e-mail

Dit gaat gepaard met het bevriezen van KMail totdat de e-mail daadwerkelijk is verzonden.

A bug has been found in the way Nepomuk checks addresses, which can cause huge delays. This is fixed for SC 4.4.1. If you cannot get 4.4.1 yet, there is this work-around:

Close Kontact, or KMail and KAddressbook if you are running stand-alone apps. Disable Strigi in SystemSettings. Stop Nepomuk, delete the database and restart nepomukserver. The actual commands you need are (as user):

qdbus org.kde.NepomukServer /nepomukserver org.kde.NepomukServer.quit
rm -r ~/.kde/share/apps/nepomuk
rm -r ~/.kde4/share/apps/nepomuk
nepomukserver

This will, of course, wipe out all the database, including any tags you've added. In theory, I understand that it's possible to do a more selective wipe of the database. If this matters to you you can find the instructions at this page

Een aantal technische kwesties

Nepomuk

Starting with KDE 4.4, it is required that Nepomuk is running in order for Akonadi to work correctly. Akonadi will check this and display an error dialog on startup if this is not the case.

Nepomuk only works with the Virtuoso backend. You can check whether the Nepomuk is running with the correct backend by using the Akonadi self-test dialog, as described above.

Although Nepomuk is required to be running, you can still disable Strigi file indexing, which is usually the most resource-intensive part of the Nepomuk framework.

Apparmor

Some distributions using Apparmor have it set up in a way that prevents Akonadi from running its internal database server. This can result in a variety of fuzzy error messages, including but not limited to the following:

unknown error 255 when running akonadictl
"DB error: 'Could not open required defaults file: /home/$username/.local/share/akonadi/mysql.conf"

You can solve this by running the following command with root privileges then reload apparmor:

     aa-complain mysqld 

On Kubuntu this is:

     sudo aa-complain mysqld
     sudo /etc/init.d/apparmor reload

Let op: wellicht gebruikt u Apparmor zonder dat dit zichtbaar is in de proceslijst.

Also note that some distributions ship an additional mysqld binary called mysqld-akonadi which has AppArmor set up correctly. If that's the case on your system and you see this problem nevertheless, there are two possible reasons:

  • Akonadi still uses mysqld instead of mysqld-akonadi. You can change that in Systemsettings -> Advanced -> Akonadi -> Server configuration.
  • AppArmor is not setup correctly for mysqld-akonadi either. Try running the "aa-complain" command noted above with mysqld-akonadi instead of mysqld.

---

You will also experience this problem if you are running an encrypted home directory using encryptfs combined with AppArmor as the Akonadi apparmor profile currently does not account for an ecrypted home (common with Ubuntu Jaunty users). Error messages with include:

  • dmesg produces:
     ecryptfs_do_create: Failure to create dentry in lower fs; rc = [-13]
     ecryptfs_create: Failed to create file inlower filesystem
  • Akonadi will list the following errors:
     Akonadi server process not registered at D-Bus

Dit is op te lossen door het bestand "/etc/apparmor.d/usr.sbin.mysqld-akonadi" aan te passen. Voeg onder de regel:

      @{HOME}/.local/share/akonadi/** rwk,

Een nieuwe regel toe:

      @{HOME}/.Private/** rwk,

      @{HOME}/.local/share/akonadi/** rwk,

Add a new line:

      @{HOME}/.Private/** rwk,

Herstart apparmor en herstart akonadi.

Ontbrekende voorwaarde

To use Akonadi you need to have the following packages installed (names might differ depending on your distribution):

  • De MySQL server (die heet mysql in openSUSE)
  • Dee Qt4 MySQL plugin (die heet libqt4-sql-mysql in openSUSE)

If you compile Qt4 yourself, make sure to tell the configure script to build in MySQL support by passing it the following option:

-plugin-sql-mysql

If "configure" cannot locate the necessary MySQL client code (i.e, says "MySQL support cannot be enabled due to functionality tests") then ensure that the corresponding package is installed (typically called [lib]mysql[client]-dev[el]). Also, depending on the install location of the MySQL headers, additional parameters to "configure" might be needed (eg. "-I /usr/include/mysql" on OpenSuse).

Als u de Qt4 rechtstreeks van Nokia krijgt, zoals een download van:

    qt-sdk-linux-x86_64-opensource-2009.05.bin

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

U hebt de driver libqsqlmysql.so nodig.

Helaas is deze driver is geen onderdeel van de distributie (tot januari 2010). U moet de broncode compileren. Download deze:

    qt-everywhere-opensource-src-4.6.0.tar.bz

     qt-everywhere-opensource-src-4.6.0.tar.bz

Then configure and make as above. But the make install doesn't copy the driver. So you have to copy it by yourself:

cp <qt-src-dir>/qt-everywhere-opensource-src-4.6.0/plugins/sqldrivers/libqsqlmysql.so /usr/local/bin/sqldrivers/

But the Revision 4.6.1, such as qt-sdk-linux-x86_64-opensource-2010.xx.bin has the driver you needed.

Omgeving instellen

The Akonadi server searches for Akonadi agents and resources in the paths defined in the XDG_DATA_DIRS environment variable. If Akonadi complains about not finding agents or resources, check if this variable is set correctly. Also keep in mind that even if set in a current console session, it might not have been set when starting the server. Starting the server manually in the current console session excludes this cause.

mysqld: unknown variable 'innodb_file_per_table=1'

Als het logboek van de MySQL server de volgende foutmelding bevat:

[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
[ERROR] Aborting

[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
[ERROR] Aborting

Try adding:

#sql_mode=strict_trans_tables <- Add underneath this line
#plugins
plugin_dir=usr/lib/mysql/plugin < - This may be a different path
plugin-load=ha_innodb.so

Table 'mysql. servers' doesn't exist

If MySQL server log contains the following error, then, most probably, you don't have your MySQL configuration file in place:

[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
[ERROR] Cannot open mysql.db
[ERROR] Cannot open mysql.user
[ERROR] Cannot open mysql.event

Copy it from /usr/share/config/akonadi/mysql-global.conf into ~/.config/akonadi/mysql-local.conf. (For debian and openSuSE users the file ist located in /etc/akonadi/mysql-global.conf). Then open it and uncomment the line sql_mode=strict_trans_tables. After that, you may get the following errors:

[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported table type: innodb
[ERROR] Aborting

If so, then in the same file find the line that starts just like the one above (which you have uncommented), but has additional parameters, separated by commas (something like sql_mode=strict_trans_tables,strict_all_tables, ...etc). Comment the shorter sql_mode=... line and uncomment the longer one.

On openSUSE 11.2 running the following command will fix this problem:

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

Bijwerken naar Kubuntu 10.4

This is a summary of other entries here for those upgrading from Kubuntu 9.10 to 10.4 who may have been using a personal package archive (PPA) for KDE 4.3 for bug fixes.

Install missing prerequisites. Remove previous akonadi cache. Start the akonadi service. Install the database. Upgrade the database. Stop and restart the akonadi service.

sudo apt-get install virtuoso-server mysql-server-5.1
rm -r $HOME/.local/share/akonadi
akonadictl start
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
akonadictl stop
akonadictl start

The mysql_install_db command above will report something like what follows, which you can safely ignore:

Installing MySQL system tables...
100501 18:04:30 [Warning] Can't create test file
/home/[userid]/.local/share/akonadi/db_data/[hostname].lower-test

Reference: forum.kde.org Akonadi 1.2.1 - some issues

KAddressBook upgraden

In addition to the Kubuntu 10.4 remedy above, problems trying to add a Vcard directory may require the following command while Akonadi is not running:

rm -rf $HOME/.config/akonadi

Can't initialize character set latin1

Als u de volgende foutmelding krijgt bij het starten van Akonadi, dan gebruikt u waarschijnlijk een versie van MySQL server met een versie hoger dan 5.1.42.

Character set 'latin1' is not a compiled character set and is not specified in

the '/usr/share/mysql/charsets/Index.xml' file

Nepomuk QueryServer interface not available!
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
DataStore::unhideAllPimItems()
Character set 'latin1' is not a compiled character set and is not specified in

the '/usr/share/mysql/charsets/Index.xml' file

Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't initialize character set latin1 (path:

/usr/share/mysql/charsets/)"

Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't initialize character set latin1 (path:

/usr/share/mysql/charsets/)"

Er is een bekende regressie in MySQL 5.1.43 en 5.1.44 waardoor MySQL niet kan worden gestart.

See the bug report for more details.


Herstarten na een eerdere fout

If you had problems starting Akonadi and fixed those (such as a missing package or the Apparmor problem) make sure that the Akonadi server is completely shut down before trying to start it again, by calling on the command line:

     akonadictl stop 

You can confirm that it was indeed shut down completely by running:

     akonadictl status

Under some circumstances the Akonadi server can be stuck in a partially running state after a failure which will prevent the next attempt to start it to fail as well. Please file a bug report if you run into this problem including the self-test report of the initial problem.

De zogenaamde "Gentoo-Assert"

That's an especially nasty problem that so far only affects users of source-based distributions, most prominently Gentoo. It is named after MySQL assertions like the following example and is most likely caused by a MySQL protocol mismatch between the MySQL server and the client library or the Qt MySQL driver.

akonadiserver: libmysql.c:4301: setup_one_fetch_function: Assertion
`param->buffer_length != 0' failed.

It is extremely hard to diagnose as the assertion mentioned above are only triggered sometimes. Instead you'll get a wide range of weird symptoms:

  • ASAP protocol logs show successful creation of objects which are supposedly no longer available when the next commands accesses them again.
  • SQL protocol logs show INSERT or UPDATE commands with values that mismatch the corresponding column types and nevertheless succeed.
  • SQL protocol logs showing large apparently random record ids which are nevertheless considered valid.

Referenties:

Possible solution: Rebuild the Qt MySQL driver after upgrading MySQL (which most likely caused this problem in the first place).