Cannot start Mysql for Akonadi

[Mike McGinn]

Hi Dotan,
here is a dump of my /var/lib/mysql
adrastea  /var/lib/mysql 4 #  ls -l
total 20568
drwx------ 2 mysql mysql     4096 2009-05-07 13:17 acctAudit
-rw-r--r-- 1 mysql mysql        0 2009-07-02 15:50 debian-5.0.flag
-rw-r--r-- 1 mysql mysql        0 2010-02-10 20:28 debian-5.1.flag
drwx------ 2 mysql mysql    12288 2009-09-18 14:48 globalPops
drwx------ 2 mysql mysql     4096 2009-09-17 11:06 gPftp
-rw-rw---- 1 mysql mysql 10485760 2010-02-10 20:28 ibdata1
-rw-rw---- 1 mysql mysql  5242880 2010-02-13 13:12 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 2009-03-14 07:04 ib_logfile1
drwx------ 2 mysql mysql     4096 2009-09-17 11:04 imailDbase
drwx------ 2 mysql mysql     4096 2009-12-04 08:33 ispdial
drwxr-xr-x 2 mysql mysql     4096 2010-02-10 20:28 mysql
-rw------- 1 mysql mysql        6 2009-10-17 15:58 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 2009-12-11 09:45 portal
drwx------ 2 mysql mysql     4096 2009-08-08 07:43 radAcctLogs
drwx------ 2 mysql mysql     4096 2009-07-03 16:26 radius

and a partial of the dir above:
adrastea  /var/lib 7 #  ls -l | grep mysql
drwxr-xr-x 11 mysql              mysql         4096 2010-02-13 13:12 mysql

A question -- who is mysql running as (root or mysql)??
What do /var/log/mysql.err and /var/log/mysql.log say??

Mike

On Tuesday 16 February 2010 05:37:58 Dotan Cohen wrote:
> What might be preventing mysql from creating these files? Without it,
> I cannot open the new Kaddressbook? Thanks.
> 
> 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:~$
> 
-- 
Mike McGinn
Chief Technology Officer
YournetPlus.com NY
845-783-5987 X 21