mysqld startup issue

[Subhro Sankha Kar]

On 11-Jun-2012, at 11:02 PM, Gary Aitken wrote:

> I've done the following after having a running system with a running mysql on it:
> 
> moved user accounts, although no logical move:
>  /usr/home/foo was => /hd1/foo
> now
>  /usr/home => /hd1/home  and /hd1/foo is now /hd1/home/foo
> repartitioned the SSD and restored the system from a dump taken prior to repartitioning.
> removed all ports and reinstalled them
> 
> Unfortunately, mysqld won't start:
> 
> 120611 10:55:52 [Warning] Can't create test file /var/db/mysql/breakaway.lower-test

What's the permission of /var/db/mysql? Also what user is mysql running as?

Thanks
Subhro
--
Subhro Sankha Kar
System Administrator
Working and Playing with FreeBSD since 2002


> 120611 10:55:52 [Warning] Can't create test file /var/db/mysql/breakaway.lower-test
> mysqld: Table 'mysql.plugin' doesn't exist
> 120611 10:55:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
> 120611 10:55:52 InnoDB: The InnoDB memory heap is disabled
> 120611 10:55:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 120611 10:55:52 InnoDB: Compressed tables use zlib 1.2.5
> 120611 10:55:52 InnoDB: Initializing buffer pool, size = 128.0M
> 120611 10:55:52 InnoDB: Completed initialization of buffer pool
> 120611 10:55:52  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: 'create'.
> InnoDB: Cannot continue operation.
> 
> Running mysqld --verbose shows:
> 
>  basedir             /usr/local
>  general-log-file    /var/db/mysql/breakaway.log
> 
> ls -aol /usr/local/libexec/mysqld
> -rwxr-xr-x  1 root  wheel  - 9558944 Jun 11 10:40 /usr/local/libexec/mysqld
> ls -dl /var/db/mysql
> drwxr-xr-x  2 mysql  mysql  512 Jun 11 10:31 /var/db/mysql
> 
> cd /
> find . -ls | grep my.cnf
> 
> shows nothing.
> 
> This looks like some kind of access / setuid problem, but I'm not sure what.
> Suggestions?
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"