akonadi startup errors

[Kevin Kempter]

Hi All;

I've gotten no replies from kde-linux, so I'll ask here:


I upgraded to KDE 4.4 yesterday. I get this error EVERY time I start Kmail:

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

I've tried removing the .local/share/alonadi directory and rebooting with no 
luck.

Can anyone point me in the right direction per how to fix this?

Thanks in advance

[Kevin Kofler]

Dave Stevens wrote:
>  have you added the para? 
Yes.

>  I don't see it, could you supply a url? 
http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disabled
has all the information now.

        Kevin Kofler

[Dave Stevens]

On Sunday 28 February 2010 06:39:53 pm Kevin Kofler wrote:
>  Dave Stevens wrote:
>  > I got a similar (or perhaps the same) issue and at this address:
>  > 
>  > http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disable
>  > d
>  > 
>  > is a little box of three command line texts that worked for me. Not
>  > necessarily a permanent fix but I can now use my pop client (kmail)
>  > again.
>  
>  These command-line texts are actually awfully bad advice for most users!
>  They solve the problem for users of KDE 4.4 prereleases who were already
>  using Nepomuk with an old Virtuoso. But the reason most of you are seeing
>  that error message is entirely different: you just have Nepomuk disabled in
>  System Settings (under Desktop Search), please enable it there. These
>  instructions will NOT solve your problem permanently as they only start
>  Nepomuk in the current session (in fact they assume it's already enabled,
>  just not working due to the Virtuoso migration which isn't affecting you at
>  all).
>  
>  I'm adding a paragraph to the userbase.kde.org wiki to make this clear.
>  (But I've been trying to explain that to Anne Wilson all this time. :-( )
>  
>          Kevin Kofler 
Kevin.

have you added the para? I don't see it, could you supply a url? and if this 
is bad advice do you have something better to offer? please?

Dave

[Kevin Kofler]

Dave Stevens wrote:
>  I got a similar (or perhaps the same) issue and at this address:
>  
>  http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disabled
>  
>  is a little box of three command line texts that worked for me. Not
>  necessarily a permanent fix but I can now use my pop client (kmail) again. 
These command-line texts are actually awfully bad advice for most users! 
They solve the problem for users of KDE 4.4 prereleases who were already 
using Nepomuk with an old Virtuoso. But the reason most of you are seeing 
that error message is entirely different: you just have Nepomuk disabled in 
System Settings (under Desktop Search), please enable it there. These 
instructions will NOT solve your problem permanently as they only start 
Nepomuk in the current session (in fact they assume it's already enabled, 
just not working due to the Virtuoso migration which isn't affecting you at 
all).

I'm adding a paragraph to the userbase.kde.org wiki to make this clear. (But 
I've been trying to explain that to Anne Wilson all this time. :-( )

        Kevin Kofler

[Genes MailLists]

On 02/27/2010 05:56 PM, Dave Stevens wrote:

>  I got a similar (or perhaps the same) issue and at this address:
>  
>  http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disabled
>  
>  is a little box of three command line texts that worked for me. Not 
>  necessarily a permanent fix but I can now use my pop client (kmail) again. 

  I did not try that - we no longer use kmail .. but thank you it may be
helpful for others that have not yet given up.

[Dave Stevens]

On Friday 26 February 2010 05:57:16 pm Mail Lists wrote:
>  On 02/26/2010 07:44 PM, Kevin Kempter wrote:
>  > Hi All;
>  > 
>  > I've gotten no replies from kde-linux, so I'll ask here:
>  > 
>  > 
>  > I upgraded to KDE 4.4 yesterday. I get this error EVERY time I start
>  > Kmail:
>  > 
>  > [ERROR] Can't open and lock privilege tables: Table 'mysql.servers'
>  > doesn't exist
>  > 
>  > I've tried removing the .local/share/alonadi directory and rebooting with
>  > no luck.
>  > 
>  > Can anyone point me in the right direction per how to fix this?
>  > 
>  > Thanks in advance
>  
>    One of the computers i 1/2 maintain had this problem - i switched the
>  mail client to thunderbird - or evo I suppose.
>  
>    If you are well prepared you never use local storage specific to any
>  mail client and instead run a local imap server as local store ...
>  
>    Good luck ... 
I got a similar (or perhaps the same) issue and at this address:

http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disabled

is a little box of three command line texts that worked for me. Not 
necessarily a permanent fix but I can now use my pop client (kmail) again.

Dave

[Genes MailLists]

On 02/26/2010 07:44 PM, Kevin Kempter wrote:
>  Hi All;
>  
>  I've gotten no replies from kde-linux, so I'll ask here:
>  
>  
>  I upgraded to KDE 4.4 yesterday. I get this error EVERY time I start Kmail:
>  
>  [ERROR] Can't open and lock privilege tables: Table 'mysql.servers'
> doesn't 
>  exist
>  
>  I've tried removing the .local/share/alonadi directory and rebooting with no 
>  luck.
>  
>  Can anyone point me in the right direction per how to fix this?
>  
>  Thanks in advance 

  One of the computers i 1/2 maintain had this problem - i switched the
mail client to thunderbird - or evo I suppose.

  If you are well prepared you never use local storage specific to any
mail client and instead run a local imap server as local store ...

  Good luck ...

[Maurizio Marini]

-- 
Maurizio Marini Via Collemare, 14 - 61039 San Costanzo (PU) - Italy
GSM [phone]    RTG : [phone] [phone]
Uffici di Milano [phone]
C.F. MRNMRZ59E17G920X   P. Iva: 01332360419 

A. Because people read from top to bottom.
Q. Why should I not top post?

On Wednesday 03 March 2010 03:15:21 am Kevin Kofler wrote:
>  Dave Stevens wrote:
>  > have you added the para?
>  
>  Yes.
>  
>  > I don't see it, could you supply a url?
>  
>  http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disabled
>  has all the information now.
>  
>          Kevin Kofler 
Now that I have started kontact, at console i got:

 Application '/usr/bin/akonadi_nepomuk_contact_feeder' exited normally...
Application '/usr/bin/akonadi_maildispatcher_agent' exited normally...
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_0(2895)/kdecore
(KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
Application '/usr/bin/akonadi_maildir_resource' exited normally...
[/usr/bin/akonadi_ical_resource] akonadi_ical_resource_4(2894)/kdecore (KConfigSkeleton)
KCoreConfigSkeleton::writeConfig:
Application '/usr/bin/akonadi_ical_resource' exited normally...
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource_1(2898)/kdecore (KConfigSkeleton)
KCoreConfigSkeleton::writeConfig:
Application '/usr/bin/akonadi_vcard_resource' exited normally...
[akonadiserver] Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_vcard_resource_1" , discarding cached
interface
[akonadiserver] Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_ical_resource_4" , discarding cached
interface
[akonadiserver] Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_maildir_resource_0" , discarding
cached interface
[akonadiserver] terminating service threads
[akonadiserver] terminating connection threads
[akonadiserver] stopping db process
Application 'akonadiserver' exited normally...
NepomukServer(10823)/nepomuk (server) Nepomuk::Server::enableNepomuk: enableNepomuk true
NepomukServer(10823)/nepomuk (server) Nepomuk::Server::enableStrigi: false

nepomuk dir is there  but empty

 ls -la  .kde/share/apps/nepomuk/
total 12
drwx------   2 maumar maumar 4096 2010-03-09 18:34 .
drwxrwxr-x. 67 maumar maumar 4096 2010-03-09 18:34 ..


i tested akonadi using
System Setting / Advanced/Akonadi Server Configuration/Test

I got this mysql error:

100309 18:34:14 [Note] Plugin 'ndbcluster' is disabled.
100309 18:34:14  InnoDB: Started; log sequence number 0 1187358
100309 18:34:14 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without 
them
100309 18:34:14 [ERROR] Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
100309 18:34:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.42-log'  socket:
'/home/maumar/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Source
distribution

Question is:
can i create mysql.time_zone_leap_second and mysql.servers to get rid of these errors?

tia

Maurizio

PS: i will subscribe fedora-kde next minutes

[Maurizio Marini]

-- 
Maurizio Marini Via Collemare, 14 - 61039 San Costanzo (PU) - Italy
GSM [phone]    RTG : [phone] [phone]
Uffici di Milano [phone]
C.F. MRNMRZ59E17G920X   P. Iva: 01332360419 

A. Because people read from top to bottom.
Q. Why should I not top post?

On Wednesday 03 March 2010 03:15:21 am Kevin Kofler wrote:
>  Dave Stevens wrote:
>  > have you added the para?
>  
>  Yes.
>  
>  > I don't see it, could you supply a url?
>  
>  http://userbase.kde.org/Akonadi#Nepomuk_Indexing_Agents_have_been_Disabled
>  has all the information now.
>  
>          Kevin Kofler 
Hi Kevin

I have F11 and I am trying to get rid of annoying popup.
I followed your suggestion but i got these errors:

==========================================
[ maumar@matanui: ~ ] $  ls -la 
.kde/share/apps/nepomuk/repository/main/data/virtuosobackend/
total 10268
drwxr-xr-x 2 maumar maumar    4096 2010-03-09 18:28 .
drwxr-xr-x 3 maumar maumar    4096 2010-03-05 17:35 ..
-rw-r--r-- 1 maumar maumar 8388608 2010-03-09 18:28 soprano-virtuoso.db
-rw-r--r-- 1 maumar maumar       0 2010-03-05 17:35 soprano-virtuoso.log
-rw-r--r-- 1 maumar maumar       0 2010-03-05 17:35 soprano-virtuoso.pxa
-rw-r--r-- 1 maumar maumar 2097152 2010-03-09 18:28 soprano-virtuoso-temp.db
-rw-r--r-- 1 maumar maumar     200 2010-03-09 18:28 soprano-virtuoso.trx
[ maumar@matanui: ~ ] $  rm -r .kde/share/apps/nepomuk
[ maumar@matanui: ~ ] $  ls -la 
.kde/share/apps/nepomuk/repository/main/data/virtuosobackend/
ls: cannot access .kde/share/apps/nepomuk/repository/main/data/virtuosobackend/: No such
file or directory
[ maumar@matanui: ~ ] $  nepomukserver
NepomukServer(10823)/nepomuk (server) Nepomuk::Server::enableNepomuk: enableNepomuk true
NepomukServer(10823)/kdecore (KSycoca) KSycocaPrivate::openDatabase: Trying to open
ksycoca from  "/var/tmp/kdecache-
maumar/ksycoca4"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"nepomukontologyloader"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
Queueing "nepomukontologyloader" due to 
dependency "nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceController::start: Starting
"nepomukstorage"
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"nepomukqueryservice"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
Queueing "nepomukqueryservice" due to 
dependency "nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"digikamnepomukservice"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
Queueing "digikamnepomukservice" due to 
dependency "nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"nepomukremovablestorageservice"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
Queueing "nepomukremovablestorageservice" 
due to dependency "nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
"nepomukfilewatch"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceManager::Private::startService:
Queueing "nepomukfilewatch" due to 
dependency "nepomukstorage"
[ maumar@matanui: ~ ] $  [/usr/bin/nepomukservicestub] nepomukstorage(10825)/kdecore
(KSycoca) KSycocaPrivate::openDatabase: Trying 
to open ksycoca from  "/var/tmp/kdecache-maumar/ksycoca4"
ProcessControl: Application '/usr/bin/nepomukservicestub' stopped unexpected
(Process crashed)
Application '/usr/bin/nepomukservicestub' crashed! 4 restarts left.
[/usr/bin/akonadi_nepomuk_contact_feeder] akonadi_nepomuk_contact_feeder(2897)/nepomuk
(library) 
Nepomuk::ResourceManagerPrivate::_k_dbusServiceOwnerChanged: Nepomuk Storage service went
down.
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/kdecore (KSycoca)
KSycocaPrivate::openDatabase: Trying to open ksycoca from  
"/var/tmp/kdecache-maumar/ksycoca4"
[/usr/bin/nepomukservicestub] Using Virtuoso Version: "6.1.0.3126-pthreads" 
Using Virtuoso Version: "6.1.0.3126-pthreads" 
nepomukstorage(10829)/nepomuk (storage service) Nepomuk::Repository::open: opening
repository ' "main" ' at ' 
"/home/maumar/.kde/share/apps/nepomuk/repository/main/" '
void Soprano::VirtuosoController::writeConfigFile(const QString&, const
Soprano::BackendSettings&) "/tmp/virtuoso_X10829.ini" 
Starting Virtuoso server: "/usr/bin/virtuoso-t" ("+foreground",
"+config", "/tmp/virtuoso_X10829.ini", "+wait")
[/usr/bin/nepomukservicestub] "
"
[/usr/bin/nepomukservicestub] "         Tue Mar 09 2010
"
[/usr/bin/nepomukservicestub] "18:31:50 OpenLink Virtuoso Universal Server
"
[/usr/bin/nepomukservicestub] "18:31:50 Version 06.01.3126-pthreads for Linux as of
Feb 10 2010
"
[/usr/bin/nepomukservicestub] "18:31:50 uses parts of OpenSSL, PCRE, Html Tidy
"
[/usr/bin/nepomukservicestub] "18:31:50 Entering Lite Mode
"
[/usr/bin/nepomukservicestub] "18:31:50 SQL Optimizer enabled (max 1000 layouts)
"
[/usr/bin/nepomukservicestub] "18:31:51 Compiler unit is timed at 0.006052 msec
"
[/usr/bin/nepomukservicestub] "18:31:52 Checkpoint started
"
[/usr/bin/nepomukservicestub] "18:31:52 Roll forward started
"
[/usr/bin/nepomukservicestub] "18:31:52 Roll forward complete
"
[/usr/bin/nepomukservicestub] "18:31:52 Checkpoint started
"
[/usr/bin/nepomukservicestub] "18:31:52 Checkpoint finished, log reused
"
[/usr/bin/nepomukservicestub] "18:31:53 Checkpoint started
"
[/usr/bin/nepomukservicestub] "18:31:53 Checkpoint finished, log reused
"
[/usr/bin/nepomukservicestub] "18:31:55 Server online at 1111 (pid 10834)
" 
Virtuoso started: 10834
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x9d58cc0)
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection()
QThread(0x9d58cc0)
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/nepomuk (storage service)
Nepomuk::Repository::open: Successfully created new 
model for repository "main"
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x9d58cc0)
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/nepomuk (storage service)
Nepomuk::Repository::open: Previous backend: "redland" 
- new backend: "virtuosobackend"
nepomukstorage(10829)/nepomuk (storage service) Nepomuk::Repository::open: Old path: 
"/home/maumar/.kde/share/apps/nepomuk/repository/main/" - new path:
"/home/maumar/.kde/share/apps/nepomuk/repository/main/"
(Soprano::Redland::BackendPlugin) creating model of type "hashes" with options
"hash-
type='bdb',contexts='yes',dir='/home/maumar/.kde/share/apps/nepomuk/repository/main/data/redland',new='yes'"

"/usr/bin/nepomukservicestub(10829)" Error in thread 3077957504 : "storage:
BDB V4.1+ open of 
'/home/maumar/.kde/share/apps/nepomuk/repository/main/data/redland/soprano-sp2o.db'
failed - No such file or directory (error)"
(Soprano::Redland)  "storage: BDB V4.1+ open of
'/home/maumar/.kde/share/apps/nepomuk/repository/main/data/redland/soprano-sp2o.db'

failed - No such file or directory (error)" 
"/usr/bin/nepomukservicestub(10829)" Error in thread 3077957504 : "storage:
BDB V4.1+ open of 
'/home/maumar/.kde/share/apps/nepomuk/repository/main/data/redland/soprano-sp2o.db'
failed - No such file or directory (error)"
nepomukstorage(10829) Nepomuk::Repository::open: Unable to convert old model: cound not
load old backend "redland"
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/nepomuk (storage service)
Nepomuk::Storage::slotNepomukCoreInitialized: Failed to 
initialize nepomuk core
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceController::slotServiceInitialized:
Failed to initialize service "nepomukstorage"
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceController::stop: Stopping
"nepomukstorage"
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/nepomuk (storage service)
Nepomuk::Core::~Core: Shutting down Nepomuk storage 
core.
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/nepomuk (storage service)
Nepomuk::Repository::~Repository: "main"
[/usr/bin/nepomukservicestub] nepomukstorage(10829)/nepomuk (storage service)
Nepomuk::Repository::close: "main"
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection()
QThread(0x9d58cc0)
[/usr/bin/nepomukservicestub] Shutting down virtuoso instance 10834
[/usr/bin/nepomukservicestub] Virtuoso server stopped: 0
[/usr/bin/akonadi_nepomuk_contact_feeder] akonadi_nepomuk_contact_feeder(2897)/nepomuk
(library) 
Nepomuk::ResourceManagerPrivate::_k_dbusServiceOwnerChanged: Nepomuk Storage service went
down.
Application '/usr/bin/nepomukservicestub' exited normally...
NepomukServer(10823)/nepomuk (server) Nepomuk::ServiceController::slotProcessFinished:
Service "nepomukstorage" went down
[/usr/bin/akonadi_nepomuk_contact_feeder] Nepomuk server already running.

================================================


now, server seems up
 maumar@matanui: ~ ] $  ps ax|grep nepo
10823 pts/0    Sl     0:00 nepomukserver
10982 ?        Sl     0:00 /usr/bin/akonadi_nepomuk_contact_feeder --identifier
akonadi_nepomuk_contact_feeder

but i have nothing into 
 .kde/share/apps/nepomuk

this dir was not recreated

what about above errors?

tia

Maurizio