Issues starting Apache and mySQL from cPanel [Solved]

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

Issues starting Apache and mySQL from cPanel [Solved]

Postby DivaVocals » 21. July 2012 20:08

I thought it was all working again.. **sigh**

For the sake of FULL disclosure, I am installing XAMPP to a shared network drive (shared drive is on my WHS machine)
  • Windows Version: Windows 7 Home Premium SP1 64-bit (correction from my earlier post)
  • XAMPP Version: 1.8.0
  • Control Panel Version: 3.0.12

Yesterday I wiped everything out one more time and started over with a clean XAMPP install..

I enabled CURL, setup my sub-domains, and all seemed right with the world.. THEN I re-started my PC this morning, and went to re-start the XAMPP control panel using "Run As Administrator" and tried to start Apache, FileZillaFTP, and mySQL. FileZillaFTP started with no issue.. Apache, and mySQL did not.

So I stopped FileZillaFTP, exited the control panel and re-launched the control panel WITHOUT using "Run As Administrator" and tried to start Apache, FileZillaFTP, and mySQL. ALL three launched just fine (go figure), but I am unable to access phpMyAdmin. I get the following error:
Existing configuration file (./config.inc.php) is not readable.


I appear to connect to my database just fine as I am able to access them via my SQL client (SQLyog) and my Zen Cart installations are running just fine..

Here's the results of all my log files:
Apache:
Code: Select all
[Sat Jul 21 11:47:42.485320 2012] [ssl:warn] [pid 6100:tid 248] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Sat Jul 21 11:47:45.746507 2012] [mpm_winnt:notice] [pid 6100:tid 248] AH00455: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4 configured -- resuming normal operations
[Sat Jul 21 11:47:45.747507 2012] [mpm_winnt:notice] [pid 6100:tid 248] AH00456: Server built: May 13 2012 14:10:15
[Sat Jul 21 11:47:45.748507 2012] [core:notice] [pid 6100:tid 248] AH00094: Command line: 'w:\\xampp\\apache\\bin\\httpd.exe -d W:/xampp/apache'
[Sat Jul 21 11:47:46.027523 2012] [mpm_winnt:notice] [pid 6100:tid 248] AH00418: Parent: Created child process 5916
AH00548: NameVirtualHost has no effect and will be removed in the next release W:/xampp/apache/conf/extra/httpd-vhosts.conf:19
[Sat Jul 21 11:47:50.500779 2012] [ssl:warn] [pid 5916:tid 260] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Sat Jul 21 11:47:51.484835 2012] [mpm_winnt:notice] [pid 5916:tid 260] AH00354: Child: Starting 150 worker threads.


mySQL:
Code: Select all
120721 11:47:31 [Note] Plugin 'FEDERATED' is disabled.
120721 11:47:32 InnoDB: The InnoDB memory heap is disabled
120721 11:47:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120721 11:47:32 InnoDB: Compressed tables use zlib 1.2.3
120721 11:47:32 InnoDB: Initializing buffer pool, size = 16.0M
120721 11:47:32 InnoDB: Completed initialization of buffer pool
120721 11:47:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120721 11:47:33  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...
120721 11:47:35  InnoDB: Waiting for the background threads to start
120721 11:47:36 InnoDB: 1.1.8 started; log sequence number 1595675
120721 11:47:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120721 11:47:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120721 11:47:36 [Note] Server socket created on IP: '0.0.0.0'.
120721 11:47:44 [Note] Event Scheduler: Loaded 0 events
120721 11:47:44 [Note] w:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)


Windows Application Log:
Code: Select all
Level   Date and Time   Source   Event ID   Task Category
Information   7/21/2012 11:53:00 AM   gupdate   0   None   "The description for Event ID 0 from source gupdate cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Service stopped
"
Information   7/21/2012 11:53:00 AM   gupdate   0   None   "The description for Event ID 0 from source gupdate cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Service started
"
Information   7/21/2012 11:47:44 AM   MySQL   100   None   "w:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)

For more information, see Help and Support Center at http://www.mysql.com.  "
Information   7/21/2012 11:47:44 AM   MySQL   100   None   "Event Scheduler: Loaded 0 events

For more information, see Help and Support Center at http://www.mysql.com.  "
Information   7/21/2012 11:47:36 AM   MySQL   100   None   "Server socket created on IP: '0.0.0.0'.

For more information, see Help and Support Center at http://www.mysql.com.  "
Information   7/21/2012 11:47:36 AM   MySQL   100   None   "  - '0.0.0.0' resolves to '0.0.0.0';

For more information, see Help and Support Center at http://www.mysql.com.  "
Information   7/21/2012 11:47:36 AM   MySQL   100   None   "Server hostname (bind-address): '0.0.0.0'; port: 3306

For more information, see Help and Support Center at http://www.mysql.com.  "
Information   7/21/2012 11:47:31 AM   MySQL   100   None   "Plugin 'FEDERATED' is disabled.

For more information, see Help and Support Center at http://www.mysql.com.  "
DivaVocals
 
Posts: 6
Joined: 20. July 2012 17:39
Operating System: Windows 7 (32)

Re: Issues starting Apache and mySQL from cPanel

Postby JonB » 22. July 2012 14:11

It looks like Google Update crashed your machine while XAMPP was running.

I think all you need to do is to look for the 'config.inc.php.safe' file in \xampp\phpmyadmin. If its there, just modify/edit it with current parameters and save as config.inc.php

This episode you alert you of the need to do regular backups. For my Windows machines, I use the free 'Fbackup' program to backup my XAMPP folders daily. (you can schedule it to run at a convenient time, and it had Volume Shadow Copy awareness so you can backup open files).

Good Luck
8)



ysf
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Issues starting Apache and mySQL from cPanel

Postby DivaVocals » 22. July 2012 19:01

Thanks for helping a lady out.. :D

Not sure what you mean by Google update since the only Google app I have installed is Chrome and I hardly use it on this machine at least.. Can you explain this??

I do indeed backup my PCs daily to my Windows Home Server then the whole server is backed up to a cloud storage account.. Additionally I have the server configured to replicate data in the event of a drive failure (I have 4 drives in this server)

Should I be concerned about the fact that the only way I can start Apache, mySQL and FilezillaFTP from the XAMPP cPanel is if I DO NOT launch via "Run as Administrator"??

JonB wrote:It looks like Google Update crashed your machine while XAMPP was running.


JonB wrote:This episode you alert you of the need to do regular backups. For my Windows machines, I use the free 'Fbackup' program to backup my XAMPP folders daily. (you can schedule it to run at a convenient time, and it had Volume Shadow Copy awareness so you can backup open files).



and my apologies if my question is silly, but I'm not entirely sure what you mean by this part here.. In setting this up, I did not edit the 'config.inc.php.safe' file.. I did update the password for the default "root" user, but I went through the security part of my localhost site to do this.. So I am not sure what I would need to modify, and the proper way to modify this file..

JonB wrote:I think all you need to do is to look for the 'config.inc.php.safe' file in \xampp\phpmyadmin. If its there, just modify/edit it with current parameters and save as config.inc.php
DivaVocals
 
Posts: 6
Joined: 20. July 2012 17:39
Operating System: Windows 7 (32)

Re: Issues starting Apache and mySQL from cPanel

Postby JonB » 22. July 2012 20:29

From the beginning of this Topic:

Existing configuration file (./config.inc.php) is not readable.


If that is still what phpMyAdmin is saying when you try to access it, I will take "its" word on that. You should open that file (\xampp\phpmyadmin\config.inc.php) with a text editor and see what's in there.

I think when you update config.inc.php (which would happen when you do the xampp 'security' thing), a file called config.inc.php.safe (a backup) is created. In theory, if you have backups - you should be able to restore the config.inc.php from a backup, or edit the backup file into shape.

"I" thought that was pretty clear, but obviously not.

Good Luck
8)


BTW - The Chrome browser is probably what is invoking gupdate. Chrome is auto-updating software unless you disable it.



ysc
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Issues starting Apache and mySQL from cPanel

Postby DivaVocals » 26. July 2012 01:30

JonB wrote:From the beginning of this Topic:

Existing configuration file (./config.inc.php) is not readable.


If that is still what phpMyAdmin is saying when you try to access it, I will take "its" word on that. You should open that file (\xampp\phpmyadmin\config.inc.php) with a text editor and see what's in there.

I think when you update config.inc.php (which would happen when you do the xampp 'security' thing), a file called config.inc.php.safe (a backup) is created. In theory, if you have backups - you should be able to restore the config.inc.php from a backup, or edit the backup file into shape.


Still wasn't sure what to edit to get the error to go away even after comparing both files.. Nothing looked OBVIOUS.. Luckily, it turns out that if I deleted the "config.inc.php" file the error goes away and myPHPAdmin launches just fine again..

JonB wrote:"I" thought that was pretty clear, but obviously not.

Good Luck
8)


BTW - The Chrome browser is probably what is invoking gupdate. Chrome is auto-updating software unless you disable it.



ysc
Your follow-up explanation helped.. So thanks for clarifying.. :D

Still need to know if I should be concerned about the fact that the only way I can start Apache, and mySQL from the XAMPP cPanel is if I DO NOT launch via "Run as Administrator"?? FilezillaFTP launches both ways..
DivaVocals
 
Posts: 6
Joined: 20. July 2012 17:39
Operating System: Windows 7 (32)

Re: Issues starting Apache and mySQL from cPanel

Postby JonB » 26. July 2012 16:05

I don't think its an issue. If Apache and MySQL run, its probably AOK - they don't really interact with the Windows OS. As far as the need for permissions, it might be a function of where you located the files (apparently on a network share as I understand) You could test that by setting up a xampp install on a local C drive (maybe on a different machine so nothing gets broken) and see if you get the same situation. I honestly don't think there is any great cause for concern.

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Issues starting Apache and mySQL from cPanel

Postby DivaVocals » 02. August 2012 02:03

Coolbeans.. It's been over a week and nothing blew up.. I was just worried about the BIG OLD WARNING about running as an admin.. :D Everything seems AOK as you say!! :D
DivaVocals
 
Posts: 6
Joined: 20. July 2012 17:39
Operating System: Windows 7 (32)


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 61 guests