I was very happy to get freeVSD installed and running fairly smoothly
by compiling the 1.4.8 source on my Redhat 7.1 machine. I used the
pre-built skel and http, ftp, telnet, pop, smtp and PHP all worked as
expected.
mySQL is a different story. The deamon does not start when vsbooting
the virtual server. That is easy enough to solve. However, when
attempting to start the mysql deamon I first received an abnormal
termination error and then an error that the error log did not exist.
The skel version of mysql had been set up to expect an error log at
/var/lib/mysql/vsone.net.err
but this log was not included in the skel.
I created the error log and attempted to start mysql again (using
safe_mysqld). I received an abnormal termination error and looked
in the newly created error log to find:
Table 'mysql.host' does not exist.
This table is normally generated after installing mysql by running
the mysql_install_db script. Appearantly this was not done before
distributing the skel. A search for mysql_install_db revealed that
the script was not included in the skel either.
A search of freeVSD documentation turned up some interesting mysql
information in Ben Kennish's FAQ, but that information appears to be
aimed at individuals who are building thier own skels. Since I am
attempting to use the pre-built skel, I assume that information is
not helpful to me.
Has anyone had similar problems with mysql in the pre-built skel?
Perhaps I am missing something completely?
I would really like to get mysql functioning correctly with the
pre-built skel before I venture to make my own skel. Any help
would be most appreciated.