Nigel,
Thanks for building the skel. You did a wonderful job for a first
release. I was dumbfounded that all of the other services worked
without so much as a bit of tinkering. After finally locating the
mysql_install_db script, mysql seems to be working fine also.
You are correct that the log files could not be installed beforehand
because mysql expects them to be named after the host which is not known
until the vs is created. Likewise, running the mysql_install_db script
requires host specific information.
However, it appears to me that the script that copies the skel to a new
vs does some customization and could be made to install correctly named
log files. It seems to me that your new autoconfig skel will do just that.
In the mean time, perhaps Ben would like to add a note to his FAQ letting
users know to run mysql_install_db from the vs in order to complete the
configuration process.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Nigel Marett
Sent: Thursday, June 14, 2001 1:56 AM
To: [EMAIL PROTECTED]
Subject: Re: mysql in pre-build skel
Morning Dean,
I'll take the rap, I built that particular skel, and I must admit it wasn't
fit for a King (or queen for that matter).
There are definitly loads of querks about the Skel, but I believe all the
required scripts and binarys where included with the Skel.
The skel does not include the MySQL error logs, as the particular log would
have an incorrect name for that particular VS.. just a matter of running
mysql_install_db.
So my apoligies for that one, it was our first crack at a pre-packaged skel.
On a new note, just to get the list buzzing... there will shortly be a new
skel... similar to the old one, only everything is done for you.
The new skel uses the new VSD autoconfigure method and includes, PHP4,
MySQL,
Majordomo, phpMyAdmin and webalizer.
There are a few more goodies that I am working on to get into the skel, call
it a early Xmas pressie for all of you.
The nice thing with this skel, is despite uncompressing it in the right
place, then creating (or linking) your vs's to it, everything else is done
for you automaticly.. all the above applications are configured and ready to
go.
The only thing you _MUST_ do is change your MySQL root password, or - well
there may be trouble!!!
Anyway, thanks to everyone for sticking in there, I promise you, you shall
all be rewarded.
Cheers,
Nigel.
On Thursday 14 June 2001 6:41 am, you 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.
