After upgrade to KDE 4.4, I cannot open Kaddressbook
Howard Coles Jr.
dhcolesj at gmail.com
Tue Feb 16 15:13:48 GMT 2010
On Tuesday 16 February 2010 05:58:57 am Dotan Cohen wrote:
> On 16 February 2010 13:51, Jonas Norlander <jonorland at gmail.com> wrote:
> > On 16 February 2010 11:33, Dotan Cohen <dotancohen at gmail.com> wrote:
> >> When I try to start the MySQL server executable it fails like this:
> >> dotancohen at dcl:~$ sudo /usr/sbin/mysqld-akonadi
> >> [sudo] password for dotancohen:
> >> 100216 12:36:01 [Warning] Can't create test file
> >> /var/lib/mysql/dcl.lower-test 100216 12:36:01 [Warning] Can't create
> >> test file /var/lib/mysql/dcl.lower-test /usr/sbin/mysqld-akonadi: Can't
> >> change dir to '/var/lib/mysql/' (Errcode: 2) 100216 12:36:01 [ERROR]
> >> Aborting
> >> 100216 12:36:01 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete
> >> dotancohen at dcl:~$
> >> --
> >> Dotan Cohen
> > Is there a reason you starting it with root permissions? On my machine
> > the command line is:
> > $ ps ax | grep my
> > 3277 ? Sl 0:06 /usr/sbin/mysqld-akonadi
> > --defaults-file=/home/jonas/.local/share/akonadi//mysql.conf
> > --datadir=/home/jonas/.local/share/akonadi/db_data/
> > --socket=/home/jonas/.local/share/akonadi/db_misc/mysql.socket
> > Trying to run mysqld-akonadi as root or my user gives same error as
> > yours. From the error in your post it looks like the database is locked.
> > Perhaps another mysql process has already started?
> > I would try to creat a new user, log in as that user and see if
> > akonadi works there, if thats the case it could be a configure error
> > for your user.
> > / Jonas
> I figured that snce it was in sbin it should be root. I don't know
> where I got that idea from. This is what happens why I try to open as
> a regular user:
> dotancohen at dcl:~$ /usr/sbin/mysqld-akonadi
> 100216 14:01:03 [Warning] Can't create test file
> /var/lib/mysql/dcl.lower-test 100216 14:01:03 [Warning] Can't create test
> file /var/lib/mysql/dcl.lower-test 100216 14:01:03 [Note] Plugin
> 'FEDERATED' is disabled.
> /usr/sbin/mysqld-akonadi: Can't find file: './mysql/plugin.frm' (errno: 13)
> 100216 14:01:03 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 100216 14:01:03 InnoDB: Operating system error number 13 in a file
> 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.
> dotancohen at dcl:~$ mysql_upgrade
> Looking for 'mysql' as: mysql
> Looking for 'mysqlcheck' as: mysqlcheck
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
> (using password: NO) when trying to connect
> FATAL ERROR: Upgrade failed
> dotancohen at dcl:~$ aptitude search mysql_upgrade
> dotancohen at dcl:~$
> As can be seen, I do not seem to have a mysql_upgrade program.
Dotan, I'm not sure if what I did made any difference, so I'd like to see if it
run: chmod 1777 /var/lib/mysql
(gives it permissions like the /temp directory)
After doing this and killing all the akonadi processes and quitting out of all
the kontact apps, I was able to restart and get into my address book and
You may want to just kill all the akonadi processes and mysql parts and
restart the kaddress book app and see if that alone fixes it.
Howard Coles Jr.
More information about the kubuntu-users