Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 12 Jun 2012 00:10:24 +0530
From:      Subhro Sankha Kar <subhro@80386.org>
To:        freebsd@dreamchaser.org
Cc:        FreeBSD Mailing List <freebsd-questions@freebsd.org>
Subject:   Re: mysqld startup issue
Message-ID:  <721F59E6-BCA8-4589-8BB2-A0BCD5613031@80386.org>
In-Reply-To: <4FD62BA8.7030702@dreamchaser.org>
References:  <4FD62BA8.7030702@dreamchaser.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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:
>=20
> moved user accounts, although no logical move:
>  /usr/home/foo was =3D> /hd1/foo
> now
>  /usr/home =3D> /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
>=20
> Unfortunately, mysqld won't start:
>=20
> 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 =3D 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.
>=20
> Running mysqld --verbose shows:
>=20
>  basedir             /usr/local
>  general-log-file    /var/db/mysql/breakaway.log
>=20
> 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
>=20
> cd /
> find . -ls | grep my.cnf
>=20
> shows nothing.
>=20
> This looks like some kind of access / setuid problem, but I'm not sure =
what.
> Suggestions?
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to =
"freebsd-questions-unsubscribe@freebsd.org"




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?721F59E6-BCA8-4589-8BB2-A0BCD5613031>