Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Reply-To:	<olivier DOT delrieu AT free DOT fr>
From:	"Olivier Delrieu" <olivier DOT delrieu AT free DOT fr>
To:	<cygwin AT cygwin DOT com>
Subject:	trouble installing mySQL : mysql_install_db does not create host.frm
Date:	Fri, 3 May 2002 11:39:54 +0200
Message-ID:	<OGEPIPLHHGNNOKNLLNKOEEOMCIAA.olivier.delrieu@free.fr>
MIME-Version:	1.0
X-Priority:	3 (Normal)
X-MSMail-Priority:	Normal
X-MimeOLE:	Produced By Microsoft MimeOLE V6.00.2600.0000
Importance:	Normal

Dear all,

I've installed CAMP and I'm now looking for guidelines to build/install
mysql under cygwin and XPpro. Sorry for that question but I tried during
severals days with no luck.

I'm using the scripts provided by Gerrit P. Haase in
http://sources.redhat.com/ml/cygwin/2001-12/msg00025.html
with mysql-3.23.49.tar.gz

At the end of the installation process, I get the following error when
starting mysql deamon :

  /src/mysql/mysql-3.23.49> Starting mysqld daemon with databases from
/var/mysql/data
  020503  7:15:49  /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 0)
  020503 07:15:49  mysqld ended

This error has been already discussed in several mailing lists, the solution
was to chown /var/mysql/data with user mysql, but it does not work here.

I used the following procedure :

- add user mysql and group cyg_mysql in XP (I log with username
'Administrateur')
- add user and group to cygwin files with
 mkpasswd -l > /etc/passwd
 mkgroup -l > /etc/group
- installation in /scr/mysql
- mysql.build prep => ok
- patch -p0 < ../mysql.patch => ok
- mysql.build conf => ok
- mysql.build build
    stops with errors in make info :
	make[1]: Leaving directory `/src/mysql/mysql-3.23.49/bdb'
	make: *** [info-recursive] Error 1
- mysql.build install => ok
- mysql.build initdb => ok, but
   ./scripts/mysql_install_db says :
	Preparing db table
	Preparing host table
	Preparing user table
	Preparing func table
	Preparing tables_priv table
	Preparing columns_priv table
	Installing all prepared tables
	ERROR: 1033  Incorrect information in file: './mysql/db.frm'
	...
	020503  8:16:00  /usr/libexec/mysqld: Shutdown Complete

- mysql.build startdb
    => stops with 'mysqld ended' :
    cat /var/mysql/data/EXBRAYAT.err
	  /src/mysql/mysql-3.23.49> Starting mysqld daemon with databases from
/var/mysql/data
	  020503  7:15:49  /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 0)
	  020503 07:15:49  mysqld ended

Of course, there is no file in /var/mysql/data/mysql/ ...

when I cp /dev/null to mysql/host.frm the deamon can access the file and the
error become :
	020503  8:28:58  /usr/libexec/mysqld: Incorrect information in file:
'./mysql/host.frm'
	020503 08:28:58  mysqld ended



So, the installation process did not create the mysql database. but why ? Is
there a patch to apply in ./scripts/mysql_install_db ?

Fortunately, I have also installed mysql under XP, and when I copy the
XP/mySQL databases to the CygWin/mySQL ones, everything (camp & mysqld) is
working perfectly, except it is a mess with usernames ...

Mr Haase, could you help ? :-)

thanks,

Olivier.



---------------------------------------------
Olivier Delrieu
delrieu AT necker DOT fr
Phone  : +33 1 44 89 77 59
       : +33 1 44 89 77 50 (secretariat)
Mobile : +33 6 64 63 00 15
---------------------------------------------


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -