MySQL Bugs: #8320: Installation fails on Step4 (Apply security settings) and now Service dont start

Bug #8320	Installation fails on Step4 (Apply security settings) and now Service dont start
Submitted:	4 Feb 2005 15:26	Modified:	4 Oct 2012 7:31
Reporter:	Christian Ringele	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	MySQL Server 4.1	OS:	Any (W2000prof)
Assigned to:		CPU Architecture:	Any

Description:
Downloaded the installion Version for Windows
After installation i run the Configuration Wizard.
When i want to execute the konfiguration, on step four (Apply security settings) the task hangs up and can't even be ended by the Taskmanager.

I deinstalled and installed it again, still the same Problem

I have no clue, what the Problem could be.
Useually my Laptop ist running verry fine.

I'd be verry thankful for any Help you can give mie.

Greets and thanks
Christian Ringele

How to repeat:
On this Webpage or by my mailadress:
ringel@solnet.ch

And now, after deinstalling and installing again, it doesnt even start the Service anymore.
And i can't start ist manually not automatily it will be startet.

Christian Ringele

Now even the Service doesnt start anymore, manualy and automaticaly

Could you please execute the below steps for to verify what is the
reason(s) why the service fails:

1- Using the task manager be sure that the service isn't running.
2- Open a command prompt window and go to the \bin directory
    where you installed the MySQL stuff. e.g.:
    d:\Arquivos de programas\MySQL\MySQL Server 4.1\bin>
3- Try to start the server as standalone like showed below ( I simulate
    a problem on my.ini file):

>mysqld-nt --defaults-file="d:\Arquivos de programas\MySQL\MySQL Server 4.1\my.ini" --standalone --console
050204 18:11:17  InnoDB: Operating system error number 3 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: File name C:\MySQL InnoDB Datafiles\ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

How you can see above I changed the InnoDB path for a wrong value
and I got the error message. Please try this.

BTW I am attaching a file to this report showing you I was able to
install the MySQL stuff without problems.

Installer working

Attachment: installer-end.PNG (image/png, text), 29.01 KiB.

First Thanks for the help

I gave in the command you wrote.

This is what comes out:

C:\Programme\MySQL\MySQL Server 4.1\bin>mysqld-nt --defaults-file="c:\programm
mysql\mysql server 4.1\my.ini" --standalone --console
InnoDB: Error: log file .\ib_logfile0 is of different size 0 14680064 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
050206 21:12:25 [ERROR] Can't init databases
050206 21:12:25 [ERROR] Aborting

050206 21:12:25 [Note] mysqld-nt: Shutdown complete

I don't know wheater this helps to determine the Problem.

Greets
Christian

it means you already have innodb files on your computer (that were created with other settings). You need to remove them before starting mysqld instance first time

IM sorry when im askind "stupid" questions.
But how do i find them?
Could they be from another Program?

Because in the konfigurationwizard, i already told him to deleta all trhe instances on the machine and to create noe ones. But doesnt help.

Aditional Info:
I installed it on another machine (W2000Prof also) and i have the same Problem.
The "apply security settings" just hangs up the hole konfigfuration wizard task...

Coukd it be a general Problem with w2000?

Christian

I realy dont understand it, but now it works...

Could it be a Problem of the firewall?
But i deaktivated it bevor in another try.

The only thing i realy changed is, that after uninstalling it and reinstalling it i deleted all the files i could find wich had anything to do with mysql.

So the Problem ist solved for nor.

Thanks to everybody who helped

Christian

Look in you my.ini file the path for:

innodb_data_home_dir=some_path

so you will find a file called ibdata1 and also look for the ib_logfile0[1]
on your install_path\data directory.

Deleting those files InnoDB will create new files, so I am assuming you
are doing a complete fresh install, when doing an upgrade you can't
delete the older files because you will loss all the data.

Also how during the install process it failed when doing the security
settings you should read the Manual about how to secure the MySQL
server and alter the privileges for root (superuser) and remove the
anonymous user (this should be performed using the mysql.exe
client or the MySQL clients GUI that you can download at our site).

Ok, Probelm ist solved, i found out what it was:

The W2000 IIS Service...
(which you need for Visual.NET)

When this service is deaktivated everything whorkes fine.

Thanks a lot for the help to everybody!!

This Bug-Report can be closed.

Greeting
Christian

The log file size problem is a duplicate of Bug#13494.