Hi everyone,
I'm not sure if this is any cause for concern, but I
recently had to run an fsck due to a power failure
on my base 4.6 i386 box, and I noticed some
unreferenced files from MySQL.
I installed MySQL from packages and followed the
instructions for a secure install.
I'm pretty new to OpenBSD and system administration
in general, so I'm not sure if this is a big issue.
If it's not then is there a way for me to clear these files
so the next time I run fsck I won't see these errors?
Here is the output from the fsck program:
** /dev/rsd0a (NO WRITE)
** Last Mounted on /
** Root file system
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
1906 files, 19932 used, 496332 free (28 frags, 62038 blocks, 0.0%
fragmentation)
** /dev/rsd0d (NO WRITE)
** Last Mounted on /home
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
22 files, 20 used, 51602271 free (31 frags, 6450280 blocks, 0.0%
fragmentation)
** /dev/rsd0e (NO WRITE)
** Last Mounted on /tmp
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
UNREF FILE I=8 OWNER=_mysql MODE=100600
SIZE=0 MTIME=Nov 1 20:55 2009
CLEAR? no
UNREF FILE I=9 OWNER=_mysql MODE=100600
SIZE=0 MTIME=Nov 1 20:55 2009
CLEAR? no
UNREF FILE I=10 OWNER=_mysql MODE=100600
SIZE=0 MTIME=Nov 1 20:55 2009
CLEAR? no
UNREF FILE I=11 OWNER=_mysql MODE=100600
SIZE=0 MTIME=Nov 1 20:55 2009
CLEAR? no
UNREF FILE I=12 OWNER=_mysql MODE=100600
SIZE=0 MTIME=Nov 1 20:55 2009
CLEAR? no
** Phase 5 - Check Cyl groups
6 files, 1 used, 1034207 free (15 frags, 129274 blocks, 0.0%
fragmentation)
** /dev/rsd0f (NO WRITE)
** Last Mounted on /usr
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
13038 files, 213917 used, 15268444 free (292 frags, 1908519 blocks,
0.0% fragmentation)
** /dev/rsd0g (NO WRITE)
** Last Mounted on /usr/X11R6
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
1 files, 1 used, 2066048 free (16 frags, 258254 blocks, 0.0%
fragmentation)
** /dev/rsd0h (NO WRITE)
** Last Mounted on /usr/local
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
5351 files, 58625 used, 15423736 free (72 frags, 1927958 blocks, 0.0%
fragmentation)
** /dev/rsd0i (NO WRITE)
** Last Mounted on /usr/obj
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
1 files, 1 used, 2066048 free (16 frags, 258254 blocks, 0.0%
fragmentation)
** /dev/rsd0j (NO WRITE)
** Last Mounted on /usr/src
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
1 files, 1 used, 2066048 free (16 frags, 258254 blocks, 0.0%
fragmentation)
** /dev/rsd0k (NO WRITE)
** Last Mounted on /var
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
326 files, 12542 used, 15469819 free (211 frags, 1933701 blocks, 0.0%
fragmentation)
** /dev/rsd0l (NO WRITE)
** Last Mounted on /var/log
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
23 files, 3052 used, 2062997 free (29 frags, 257871 blocks, 0.0%
fragmentation)
** /dev/rsd0m (NO WRITE)
** Last Mounted on /var/mail
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
2 files, 465 used, 5161108 free (20 frags, 645136 blocks, 0.0%
fragmentation)
** /dev/rsd0n (NO WRITE)
** Last Mounted on /var/spool
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
12 files, 12 used, 5161561 free (73 frags, 645186 blocks, 0.0%
fragmentation)
** /dev/rsd0o (NO WRITE)
** Last Mounted on /var/tmp
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
2 files, 2 used, 1034206 free (22 frags, 129273 blocks, 0.0%
fragmentation)
** /dev/rsd0p (NO WRITE)
** Last Mounted on /var/www
** Phase 1 - Check Blocks and Sizes
** Phase 2 - Check Pathnames
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Cyl groups
278 files, 881 used, 51601410 free (66 frags, 6450168 blocks, 0.0%
fragmentation)
Here's how I start my MySQL daemon.
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c mysql root -c '/usr/local/bin/mysqld_safe > /dev/null
2>&1 &'
echo -n ' mysql'
fi
I have that in /etc/rc.local.
That was how the MySQL package suggested to start the daemon.
Thanks for your help and thanks to the OpenBSD team for their time and
effort.
