MySQL start then auto-stop

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL start then auto-stop

Postby lazenge » 22. March 2008 15:44

Hi guys

I've installed Xampp 1.6.6a on Windows XP SP2
Apache is starting correctly but when I try to start MySQL, it start then auto-shutdown
MySQL doesn't start even if I setup it as a service

I've tried any kind of solution discussed in this forum

paths in my.ini and my.cnf are right, de-installing ad re-installing doesn't work, using directly .bat files doesn't work

Any idea out there?

Thank you
lazenge
 
Posts: 4
Joined: 22. March 2008 14:42

Postby Wiedmann » 22. March 2008 16:04

when I try to start MySQL, it start then auto-shutdown

Can you read an error message with "mysql_start.bat"?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Error reporting

Postby lazenge » 22. March 2008 21:22

Executing mysql_start.bat produce this errors output:

>Diese Eingabeforderung nicht waehrend des Running beenden
>Please dont close Window while MySQL is running
>MySQL is trying to start
>Please wait ...
>MySQL is starting with mysql\bin\my.cnf (console)
>080322 21:07:58 [Warning] Can't create test file >C:\xampp\mysql\data\aux.lower-test
>080322 21:07:58 [Warning] Can't create test file >C:\xampp\mysql\data\aux.lower-test
>080322 21:08:00 [ERROR] mysql\bin\mysqld: Can't create/write to file >'C:\xampp\mysql\data\aux.pid' (Errcode: 2)
>Can't start server: can't create PID file: No such file or directory

>MySQL konnte nicht gestartet werden
>MySQL could not be started
>Premere un tasto per continuare . . .

It seems something related to write permissions or something like this...
I'm experienced configuring Mysql in Linux systems, and I notice no permission problem in Debian 4.0 logging as superuser...
in Windows I've configured no other user than default (root/administrator)

Thanks for your reply!
lazenge
 
Posts: 4
Joined: 22. March 2008 14:42

Postby Wiedmann » 22. March 2008 21:49

>080322 21:08:00 [ERROR] mysql\bin\mysqld: Can't create/write to file >'C:\xampp\mysql\data\aux.pid' (Errcode: 2)
>Can't start server: can't create PID file: No such file or directory

The directory "C:\xampp\mysql\data" exists?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby lazenge » 23. March 2008 01:50

Yes, of course
lazenge
 
Posts: 4
Joined: 22. March 2008 14:42

Postby Wiedmann » 23. March 2008 02:09

Well, I think I figured it out... it's the hostname/computername "aux". Because "aux" is a special name in the Windows filesystem, and thus MySQL can't make a file like "aux.pid" (even if you have an extension)

Can you change your Computername?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

I can't believe...

Postby lazenge » 23. March 2008 02:35

AAAHHHHH Ok!
I can't change computer name for very special technical reasons (my office net is figured according a built-in structure that refer to computernames), but I can assign a worker to computer named aux and try to install xampp on a different machine...it's a bit hard to switch configurations but I see I have no other chance...
I'll try to solve this way my problem

Thank you very much

(P.S. if the name aux is reserved in Windows, why Windows is not programmed to REALLY reserve it? Bah!)
lazenge
 
Posts: 4
Joined: 22. March 2008 14:42


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests