To me, it looks like the mysql on the host server is not setup to bind to
just its IP. If you go into /etc/rc.d/init.d, and the look at the file mysql
/ mysqld (Cant remember which filename is used by default), and on or around
line 32, in the start section of the file, look for this line:
/usr/bin/safe_mysqld --user=mysql --log=/var/log/mysqld.log --bind-address=1
.1.1.1 \
--pid-file=/var/run/mysqld.pid >/dev/null 2>&1 &
You will probably not have the bind statement. If you add that with the
appropriate IP for your host server, then save and issue a ./mysqld restart,
this should solve problems.
Bill.
----- Original Message -----
From: "Webmaster (U.S. ISP, Inc.)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 5:58 AM
Subject: Re: Starting of MySQL
> As I indicated in my previous post, the problem has nothing to do with
MySQL
> since I am getting the error with a fresh install. The problem is actually
> affecting the further setup of MySQL as well. With just the base install
of
> FreeVSD and one of the precompiled skels, I am getting the "bind():
Address
> already in use" when I setup a test vs as per the instructions. I am using
a
> completely new IP address which is not already set as the primary or
> secondary name servers. So this looks like it is a problem with the
FreeVSD
> program itself.
>
> Thanks for any and all help.
>
> Todd
>
> ----- Original Message -----
> From: "Urivan Saaib" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 20, 2001 7:47 PM
> Subject: Re: Starting of MySQL
>
>
> > Hi,
> >
> > There are been several posts listing step by step inscructions how to
set
> > up MySQL and automate the process of starting up the database in the
> > mailing list.
> >
> > You might want to take alook to the mail archive :
> >
> >
>
http://freevsd.org/support/mail-archives/freevsd-support/2001/Mar/0230.html
> >
> > There are replies and comments, even another suggestions.
> >
> > Hope that helps.
> >
> > Regards,
> >
> > ---Reply to mail from Webmaster U.S. ISP, Inc. about Starting of MySQL
> >
> > > It seems I am getting the error even without the MySQL script
> information so
> > > I don' t think that is the problem. But that might be causing the
other
> > > problem I am having with MySQL.
> > > The error message is "bind():Address already in use" when running the
> > > vsd-vsdbatch.pl or vsboot or rebootvs
> > >
> > > Brendan, I don't see the "ip=`cat /etc/hosts | awk {'print $1'}`" line
> in my
> > > rc.vsd in the skel's etc directory or in the virtual server's etc
> directory.
> > > The hosts file is different then what you listed. The IP address is
> first.
> > > Where is the ip line you suggested to change?
> > >
> > >
> > > Also is there anyone else that can help with this? This is on a fresh
> > > installation of freevsd using the mysql/php skel.
> > >
> > >
> > > Thanks,
> > > Todd
> >
> > _______________________________________________________
> > Urivan Saaib
> > Presidente
> > CiberNET Mexico
> > Email: [EMAIL PROTECTED]
> > Tel: (6) 175.71.95
> > Cel: (6) 170.40.88
> >
> >
> >
> >
