After upgrade to KDE 4.4, I cannot open Kaddressbook

[Dotan Cohen]

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
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.
dotancohen at dcl:~$ mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
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 Cohen

http://what-is-what.com
http://gibberish.co.il

Please CC me if you want to be sure that I read your message. I do not
read all list mail.