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>