Mysql and Apache do not start

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

Mysql and Apache do not start

Postby Tonk » 27. April 2009 16:22

Both Mysql and Apache do not start.
I succesfully installed xampp 1.7.1 But if I click on Start I get a green sign Running for 5 secs. It then disappears.
After that there is only Start.
The same goes for Mysql and Apache.
In the box it says: Busy.... Apache started [port 80] (same for Mysql)

I have searched this forum for a day, but can not find any fitting answer.

What have I done sofar:
* Did a portcheck with result: All ports are "free"
* Windows firewall = off
* Setup_xampp.bat gives "Nothing to do"
* Serveral uninstalles and many clean-ups....
* No other servers in use.

Maybe this helps:
from teh Apache Error log:
[alert] (OS 11001)Host unknown. : mod_unique_id: unable to find IPv4 address of "DELL_?ON"
Configuration Failed

I am desperate to find the solution and get it to work.....
Tonk
 
Posts: 5
Joined: 27. April 2009 16:09

Re: Mysql and Apache do not start

Postby IamJim » 27. April 2009 16:46

Hi, I don't know if I can help...but I will try...as I just installed last evening on Win2K Server edition.

1> You do not say what version of Windows?

2> Are you running under a user, without full permissions? (use admin privs)

3> Have you rebooted?

Sorry, my mind reading skills....aren't working right now... LOL

Jim
IamJim
 
Posts: 56
Joined: 27. April 2009 03:01

Re: Mysql and Apache do not start

Postby Sharley » 27. April 2009 22:50

Tonk wrote:Both Mysql and Apache do not start.
I succesfully installed xampp 1.7.1 But if I click on Start I get a green sign Running for 5 secs. It then disappears.
When ever you have this type of problem try and start Apache using the apache_start.bat file as it will give you a message why it can't start, also mysql_start.bat file will also give you the reason for it not wanting to start.
Paste the message here by using the Edit menu found after you click on the little icon top left of the console window.

Tonk wrote:from teh Apache Error log:
[alert] (OS 11001)Host unknown. : mod_unique_id: unable to find IPv4 address of "DELL_?ON"
Configuration Failed
The reference to IPv4 may mean that the Windows Hosts file needs some attention.

Go to C:\Windows\system32\drivers\etc\Hosts file and open it in your text editor (in Vista right click on the Notepad link and select to run as administrator which will eliminate an error when trying to save the Hosts file).

Find this line:
::1 localhost

Comment it out so it looks like this:
# ::1 localhost

Make sure that you now have these 2 lines at the beginning of the uncommented section of your Hosts file:
127.0.0.1 localhost
# ::1 localhost


Save the file and then try and start Apache and MySQL again.

When asking for support please include your OS as different Windows versions may have different techniques for effecting remedies.
Thanks.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Mysql and Apache do not start

Postby Tonk » 28. April 2009 09:19

First of all thank you very much for the help offered!

My OS is windows XP SP3
I am loged in as main user, I have all the rights.
I have rebooted several times.

Hosts-file
I checked this and it is as it should be with
127.0.0.1 localhost
# ::1 localhost

apache_start.bat
Returnes: Apache could not be started....Press any key to continue...

mysql_start.bat
Returnes some more information. This is what I copied out of the mysql_error.log:

InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
090427 15:24:20 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090427 15:24:21 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090427 15:24:21 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090427 15:24:22 InnoDB: Started; log sequence number 0 0
090427 15:24:22 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 15:24:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 15:24:47 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 15:24:47 InnoDB: Started; log sequence number 0 46409
090427 15:24:47 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 15:30:08 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 15:30:08 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 15:30:08 InnoDB: Started; log sequence number 0 46409
090427 15:30:08 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 15:30:19 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 15:30:19 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 15:30:19 InnoDB: Started; log sequence number 0 46409
090427 15:30:19 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 15:31:01 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 15:31:01 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 15:31:02 InnoDB: Started; log sequence number 0 46409
090427 15:31:02 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 15:48:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 15:48:52 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 15:48:53 InnoDB: Started; log sequence number 0 46409
090427 15:48:53 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 16:26:31 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 16:26:31 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 16:26:31 InnoDB: Started; log sequence number 0 46409
090427 16:26:31 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 17:24:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 17:24:52 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 17:24:53 InnoDB: Started; log sequence number 0 46409
090427 17:24:53 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 17:25:13 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 17:25:13 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 17:25:14 InnoDB: Started; log sequence number 0 46409
090427 17:25:14 [ERROR] C:\xampp\mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090427 17:36:59 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090427 17:37:00 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090427 17:37:00 InnoDB: Started; log sequence number 0 46409
090427 17:37:00 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)

Errcode: 22
I searched the forum for this error, but it did not come up with a helpfull solution.

Localhost page
because the server won't start I cannot reach the localhost page.

Hope this helpes in finding a solution!
Thanks!
Tonk
 
Posts: 5
Joined: 27. April 2009 16:09

Re: Mysql and Apache do not start

Postby Wiedmann » 28. April 2009 09:44

Code: Select all
090427 17:37:00 [ERROR] mysql\bin\mysqld.exe: Can't create/write to file 'C:\xampp\mysql\data\DELL_?ON.pid' (Errcode: 22)

Code: Select all
[alert] (OS 11001)Host unknown. : mod_unique_id: unable to find IPv4 address of "DELL_?ON"

There is a problem with your computername.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Mysql and Apache do not start

Postby Tonk » 28. April 2009 09:53

Where do i look for a solution?
In Windows, or in Xampp?
Tonk
 
Posts: 5
Joined: 27. April 2009 16:09

Re: Mysql and Apache do not start

Postby Wiedmann » 28. April 2009 09:58

Change your computername (in Windows), to something without special characters.
(Best is, just use the rules that are defined for dns host names.)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Mysql and Apache do not start

Postby Tonk » 28. April 2009 10:10

Indeed! Changing the computer name solved my problem!
To Everybody: thank you very much!
Tonk
 
Posts: 5
Joined: 27. April 2009 16:09


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests