Bug 63914

Summary: mysql 4.0.16 server package fails to create /var/db/mysql thus failing install
Product: Ports & Packages Reporter: Edwrd Rudd <eddie>
Component: Individual Port(s)Assignee: Alex Dupre <ale>
Status: Closed FIXED    
Severity: Affects Only Me    
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   

Description Edwrd Rudd 2004-03-08 03:20:18 UTC
I installed the databases/mysql40-server package on my system first from the
sysinstall program then downloading the file manually and installing with
pkg-add.. sysinstall returned an error that the script failed to run
correctly.. And when running with pkg-add the output yeilded that the
/var/db/mysql directory did not exist and was not being created by the
install script..

Fix: 

create the /var/db/mysql directory before installing mysql40-server
How-To-Repeat: fresh install of FreeBSD 5.2.1 w/o any mysql DBs installed (and no
/var/db/mysql directory) and install the mysql40-server package.
Comment 1 Kris Kennaway freebsd_committer freebsd_triage 2004-03-09 06:55:39 UTC
Responsible Changed
From-To: freebsd-bugs->ale

Assign to maintainer
Comment 2 Alex Dupre freebsd_committer freebsd_triage 2004-03-09 07:45:39 UTC
When you run pkg_add (and finally mysql_install_db), did you see any 
error messages regarding your hostname and suggestions like trying to 
use the --force options?

--
Alex Dupre
Comment 3 Edwrd Rudd 2004-03-10 04:09:53 UTC
Yeah.. but why would that cause the /var/db/mysql directory to not be
created??
And the entries are in my /etc/hosts file.. but for some reason they are
being ignored.

On Tue, 2004-03-09 at 01:45, Alex Dupre wrote:
> When you run pkg_add (and finally mysql_install_db), did you see any 
> error messages regarding your hostname and suggestions like trying to 
> use the --force options?
> 
> --
> Alex Dupre
-- 
Edward Rudd <eddie@omegaware.com>
Website http://outoforder.cc/
Comment 4 Alex Dupre freebsd_committer freebsd_triage 2004-03-10 09:21:37 UTC
Edward Rudd wrote:

> And the entries are in my /etc/hosts file.. but for some reason they are
> being ignored.

Can you paste the content of your /etc/hosts file and tell me the output 
of "hostname" and "hostname -s", please?

--
Alex Dupre
Comment 5 Edwrd Rudd 2004-03-10 21:42:09 UTC
active uncommented entries in /etc/hosts are
::1	localhost localhost.my.domain
127.0.0.1	localhost localhost.my.domain

hostname 
freebsd.vernon.hills
hostname -s
freebsd

Which freebsd is in my local dns, so they resolve.
but the script complained about not being able to resolve localhost.
And there is no /etc/nsswitch.conf

On Wed, 2004-03-10 at 03:21, Alex Dupre wrote:
> Edward Rudd wrote:
> 
> > And the entries are in my /etc/hosts file.. but for some reason they are
> > being ignored.
> 
> Can you paste the content of your /etc/hosts file and tell me the output 
> of "hostname" and "hostname -s", please?
> 
> --
> Alex Dupre
-- 
Edward Rudd <eddie@omegaware.com>
Website http://outoforder.cc/
Comment 6 Alex Dupre freebsd_committer freebsd_triage 2004-03-10 23:05:36 UTC
Edward Rudd wrote:

> Which freebsd is in my local dns, so they resolve.
> but the script complained about not being able to resolve localhost.

I'm quite sure to have found a bug in the mysql_install_db code. I have 
a patch, please wait.

--
Alex Dupre
Comment 7 Alex Dupre freebsd_committer freebsd_triage 2004-03-11 10:02:45 UTC
State Changed
From-To: open->feedback

Probably fixed, sent a patched package to originator for testing.
Comment 8 Alex Dupre freebsd_committer freebsd_triage 2004-03-12 10:37:17 UTC
State Changed
From-To: feedback->closed

Fixed with latest commits.