Server Error!

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

Server Error!

Postby webbones » 26. November 2008 03:36

I suspect I have a corrupted file somewhere outside XAMPP ... but maybe not!

Earlier today, I was running under XAMPP 1.6.7 when, out of the blue, the server became inaccessible. I downloaded 1.6.8 and ran the install successfully. (After resolving some port conflicts, the XAMPP console reported that both Apache and MySQL were running!) Unfortunately, when I try to access the localhost I receive a SERVER ERROR! and ERROR 500 notification.

Does anyone have any thoughts?
webbones
 
Posts: 9
Joined: 26. November 2008 03:19

Postby Sharley » 26. November 2008 03:58

With a server 500 error always check the server's error log file as it will hold the clue.
.\xampp\apache\logs\error.log
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

Postby webbones » 26. November 2008 12:39

Yes, thanks.

It appears there's a missing file. It's looking for >>AuthUserFile "C:\xampp\security\xampp.users"<< [as defined in C:\xampp\htdocs\xampp\.htaccess] This file doesn't exist!

Is there any documentation on how to create it?
webbones
 
Posts: 9
Joined: 26. November 2008 03:19

Postby glitzi85 » 26. November 2008 16:08

That's normally created when you run the security-Script on localhost. No idea why it is missing, i never tried this script.

Just create a a text file there and put in the username and password in this format:

Code: Select all
user:password


It is also possible to use encrypted passwords and create the file automatically:

Start -> Run -> cmd.exe

Then the console should come up, run this commands:

Code: Select all
c:
cd \xampp\apache\bin
htpasswd C:\xampp\security\xampp.users username


Then you will be asked for your password twice and the file will be created if it does not exists (if it exists the user will be added to the existing file).

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Postby webbones » 26. November 2008 21:27

OK, I copied the 'xampp.users' file from another installation and corrected the path statement in 'C:/xampp/htdocs/xampp/.htaccess'. I can now bring up the XAMPP Welcome page.

Now I'm getting an 'Access denied' error when I try to bring up 'phpMyAdmin'. The advice offerred is that I should 'check the host, username and password in your configuration'! I've looked in the 'C:\xampp\apache\conf\httpd.conf' but can't locate any relevant directives.

Can anyone advise as to the location of the phpMyAdmin config file?

Thanks ...
webbones
 
Posts: 9
Joined: 26. November 2008 03:19

Postby Sharley » 26. November 2008 21:52

Can anyone advise as to the location of the phpMyAdmin config file?
http://www.apachefriends.org/en/xampp-windows.html#1172

More helpful reading here:
http://www.apachefriends.org/en/faq-xampp-windows.html
.\xampp\readme_en.txt

To setup security in XAMPP it is accessible from the XAMPP Welcome page under the Security menu item.
Last edited by Sharley on 26. November 2008 22:02, edited 2 times in total.
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

Postby glitzi85 » 26. November 2008 22:01

webbones wrote:Now I'm getting an 'Access denied' error when I try to bring up 'phpMyAdmin'. The advice offerred is that I should 'check the host, username and password in your configuration'! I've looked in the 'C:\xampp\apache\conf\httpd.conf' but can't locate any relevant directives.

How did you try to "bring up" PMA? Normally it should be called via http://localhost/phpmyadmin
If this is not working, please post the content of xampp\apache\logs\access.log

PMA is located in xampp\phpMyAdmin and included as an Alias in the file xampp\apache\conf\extra\httpd-xampp.conf

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Postby webbones » 27. November 2008 00:15

glitzi85 wrote:How did you try to "bring up" PMA? Normally it should be called via http://localhost/phpmyadmin
If this is not working, please post the content of xampp\apache\logs\access.log

PMA is located in xampp\phpMyAdmin and included as an Alias in the file xampp\apache\conf\extra\httpd-xampp.conf

glitzi


Yes, I tried to start PMA from the 'phpmyadmin' link on the Welcome page.
The access log entry is '127.0.0.1 - - [26/Nov/2008:17:59:15 -0500] "GET /phpmyadmin/ HTTP/1.1" 200 3184'.

I have also run 'resetroot.bat' in the xampp\mysql directory and xampp\mysql\bin\mysqladmin -u root password .

Still not able to connect ...

Thanx 4 your efforts ...
webbones
 
Posts: 9
Joined: 26. November 2008 03:19

Postby glitzi85 » 27. November 2008 01:56

webbones wrote:Yes, I tried to start PMA from the 'phpmyadmin' link on the Welcome page.
The access log entry is '127.0.0.1 - - [26/Nov/2008:17:59:15 -0500] "GET /phpmyadmin/ HTTP/1.1" 200 3184'.

The Code 200 means everything OK. Maybe you posted the wrong line?

Please stop Apache, delete the access.log and error.log (or rename them) and then start Apache. Now try to reach http://localhost/phpmyadmin

Then post content of both files here.

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Postby webbones » 27. November 2008 15:49

The access.log contents are:

127.0.0.1 - - [27/Nov/2008:09:30:52 -0500] "GET /phpmyadmin/ HTTP/1.1" 200 3184
127.0.0.1 - - [27/Nov/2008:09:30:53 -0500] "GET /phpmyadmin/phpmyadmin.css.php?token=ea532e4b65aaaa67ef1fd1d141157519&js_frame=right&nocache=3646330611 HTTP/1.1" 200 20584

There was no post to the error.log associated with this action.

Same result: 'Access denied', ... check the host, username and password in your configuration ...

At this point, I am suspicious that there is something wrong with my operating environment (XP.sp3) that is screwing up the install. [The config.inc.php file has only 43 lines in it. On my old 1.6.2 installation, this file has more than 800 lines!]

As a fall-back, I am going to try to install a stand-alone mySQL server.
That said, I look forward to any further suggestions re:correcting this problem.

thnx
webbones
 
Posts: 9
Joined: 26. November 2008 03:19


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 29 guests