I would like to start out by saying that you guys all get up way too early.
That said, thanks for all the assistance. As it turns out, mysql_install_db
was included in the skel. I had attempted to find it using "locate" which
does not work in the vs because the database exists only in the root server.
Having run the mysql_install_db script everything works fine.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ben Kennish
Sent: Thursday, June 14, 2001 1:34 AM
To: [EMAIL PROTECTED]
Subject: Re: mysql in pre-build skel
Dear Dean,
I too would prefer to use the pre-built skels only it seems to me that
they still have quite a few niggles that need to be sorted out. I admit
that it would be nice to have a prebuilt skel with all the latest
patches and security fixes included but, as yet, the prebuilt skels
still seem to be more hassle than they're worth!
A few things I can suggest....
Ensure that all of /var/lib/mysql and below are all owned by mysql (and
that this user exists!).
chown -R mysql.mysql /var/lib/mysql.
Check that theres a mysql directory in /var/lib/mysql (i.e.
/var/lib/mysql/mysql) and that it contains user.* db.* and so on files.
If it doesn't, you'll need to find a way to get hold of
mysql_install_db!
Other than that, I'd suggest rolling your own :-). It's not too hard
(provided you stick to the guidelines of a fresh server install and
ensure you find out about the skel-repo directory and the add_ons (pkgs)
- the freeVSD doc should cover this else have a search through my FAQ.
Good luck!
Ben
Dean wrote:
>
> 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.
