"The connection was reset"

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

"The connection was reset"

Postby grosskopf » 03. January 2011 04:55

Here's the deal. I have a website on my VPS using XAMPP here: http://host4admins.com

I have a stats page that pulls game player stats from a database and displays them on a webpage here: http://host4admins.com/xlrstats/grosskopf. It begins to show the stats, but then I get an error "The connection was reset", etc. I searched for this but couldn't find anything related. I assume there's some sort of timeout that needs to be extended to allow this page to be displayed but I don't know where to find it.

Any help? :)
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby grosskopf » 04. January 2011 00:54

Ok, had someone tell me to change "max_execution_time" to 500 in my php.ini file (located in c:\xampp\php) and it didn't make a difference. Any other tips?
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby Sharley » 04. January 2011 03:20

Fist always look in the \xampp\apache\logs\error.log file for any clues.

By increasing the max_execution_time will usually only prolong the delay before the server stalls when it encounters a scripting\library issue as is now happening.

The stalling seems to be occurring when JavaScripts using the jQuery Library are being parsed and so maybe a browser issue rather than a server issue.

I notice that you are using an old jQuery library version 1.2.6 when the latest version is 1.4.4 with many improvements being implemented.

Try updating the libraries and if possible use a linked CDN hosted jQuery library in your web page headers instead of using a local stored version as the updated files will then always be available to your scripts.

So my tip is to update the scripts and libraries you use to the latest versions before editing the server's configurations.

Best wishes and good luck.
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: "The connection was reset"

Postby grosskopf » 04. January 2011 05:21

Sharley wrote:Fist always look in the \xampp\apache\logs\error.log file for any clues.

By increasing the max_execution_time will usually only prolong the delay before the server stalls when it encounters a scripting\library issue as is now happening.

The stalling seems to be occurring when JavaScripts using the jQuery Library are being parsed and so maybe a browser issue rather than a server issue.

I notice that you are using an old jQuery library version 1.2.6 when the latest version is 1.4.4 with many improvements being implemented.

Try updating the libraries and if possible use a linked CDN hosted jQuery library in your web page headers instead of using a local stored version as the updated files will then always be available to your scripts.

So my tip is to update the scripts and libraries you use to the latest versions before editing the server's configurations.

Best wishes and good luck.


I could post the error log if it would help. I really don't understand what it says in there.

When you talk about JavaScripts, are you talking about updating Java itself on the VPS? The website I'm trying to bring up isn't written by me, so if they are using old methods, there's nothing I can do about that, but if there is outdated software on the VPS, I can certianly update that.
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby Sharley » 04. January 2011 05:53

grosskopf wrote:I could post the error log if it would help.
Only post a snippet about the date and time you tried to access your web site when it stalled and include it between forum code tags for easier reading - your error.log file would be too large to post here in total but you can clean out this file when you stop the server as it will be recreated when you start Apache again and only takes a few seconds to achieve a clean error or access log file.

A look at the error.log file error entries may reveal if your issue is server related but my guess still stands that it is web site client side scripting that is at fault which is causing the browser to stall.

grosskopf wrote:When you talk about JavaScripts, are you talking about updating Java itself on the VPS?
No I am talking about JavaScripts and a Google will tell what the difference is - basically JavaScript is parsed by the browser and Java is parsed by a server.
JavaScript = client side
Java = server side.

grosskopf wrote:The website I'm trying to bring up isn't written by me, so if they are using old methods, there's nothing I can do about that, but if there is outdated software on the VPS, I can certianly update that.
Not out dated software on the server if you are using the latest XAMPP version.

The jQuery libraries are contained within your web site so you will need to consult with the web site designers and have them use a CDN to access the jQuery Libraries which will keep the libraries at the latest current version automagically and to update their scripts that use the libraries plus the links to the libraries in the site's html files.
http://docs.jquery.com/Downloading_jQuery
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: "The connection was reset"

Postby grosskopf » 04. January 2011 06:26

Ok, now that you clarified that, I can assure you that the existing code for XLRStats works. I previously had it hosted with Host Gator. I have since moved to my own VPS. I copied the files off of my Host Gator server and exported the database. When it was with Host Gator, I never had any issues with it not displaying or aborting like it is now. I have tried loading the page with FF and IE on both my computer and the VPS and I had someone with Chrome try it and although it didn't abort, like it did for me, it just sat there. If you go to http://host4admins.com/xlrstats/grosskopf, you will see what I mean.

Here is the log. I stopped Apache, renamed the log file, started Apache, tried accessing the above link, and when it got to the "The connection was reset", I stopped Apache.

Code: Select all
[Mon Jan 03 21:24:20 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Jan 03 21:24:20 2011] [notice] Digest: done
[Mon Jan 03 21:24:20 2011] [notice] Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Mon Jan 03 21:24:20 2011] [notice] Server built: Nov 11 2009 14:29:03
[Mon Jan 03 21:24:20 2011] [notice] Parent: Created child process 116696
[Mon Jan 03 21:24:22 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Jan 03 21:24:22 2011] [notice] Digest: done
[Mon Jan 03 21:24:22 2011] [notice] Child 116696: Child process is running
[Mon Jan 03 21:24:22 2011] [notice] Child 116696: Acquired the start mutex.
[Mon Jan 03 21:24:22 2011] [notice] Child 116696: Starting 150 worker threads.
[Mon Jan 03 21:24:22 2011] [notice] Child 116696: Starting thread to listen on port 443.
[Mon Jan 03 21:24:22 2011] [notice] Child 116696: Starting thread to listen on port 80.
[Mon Jan 03 21:24:28 2011] [error] [client 66.249.71.171] File does not exist: C:/xampp/htdocs/highscores
[Mon Jan 03 21:24:35 2011] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Mon Jan 03 21:24:36 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Jan 03 21:24:36 2011] [notice] Digest: done
[Mon Jan 03 21:24:37 2011] [notice] Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Mon Jan 03 21:24:37 2011] [notice] Server built: Nov 11 2009 14:29:03
[Mon Jan 03 21:24:37 2011] [notice] Parent: Created child process 2348
[Mon Jan 03 21:24:38 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Jan 03 21:24:38 2011] [notice] Digest: done
[Mon Jan 03 21:24:39 2011] [notice] Child 2348: Child process is running
[Mon Jan 03 21:24:39 2011] [notice] Child 2348: Acquired the start mutex.
[Mon Jan 03 21:24:39 2011] [notice] Child 2348: Starting 150 worker threads.
[Mon Jan 03 21:24:39 2011] [notice] Child 2348: Starting thread to listen on port 443.
[Mon Jan 03 21:24:39 2011] [notice] Child 2348: Starting thread to listen on port 80.
[Mon Jan 03 21:24:45 2011] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Mon Jan 03 21:24:46 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Jan 03 21:24:46 2011] [notice] Digest: done
[Mon Jan 03 21:24:46 2011] [notice] Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Mon Jan 03 21:24:46 2011] [notice] Server built: Nov 11 2009 14:29:03
[Mon Jan 03 21:24:46 2011] [notice] Parent: Created child process 60492
[Mon Jan 03 21:24:48 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Jan 03 21:24:48 2011] [notice] Digest: done
[Mon Jan 03 21:24:48 2011] [notice] Child 60492: Child process is running
[Mon Jan 03 21:24:48 2011] [notice] Child 60492: Acquired the start mutex.
[Mon Jan 03 21:24:48 2011] [notice] Child 60492: Starting 150 worker threads.
[Mon Jan 03 21:24:48 2011] [notice] Child 60492: Starting thread to listen on port 443.
[Mon Jan 03 21:24:48 2011] [notice] Child 60492: Starting thread to listen on port 80.
[Mon Jan 03 21:25:00 2011] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 03 21:25:00 2011] [notice] Child 60492: Exit event signaled. Child process is ending.
[Mon Jan 03 21:25:01 2011] [notice] Child 60492: Released the start mutex
[Mon Jan 03 21:25:02 2011] [notice] Child 60492: All worker threads have exited.
[Mon Jan 03 21:25:02 2011] [notice] Child 60492: Child process is exiting
[Mon Jan 03 21:25:02 2011] [notice] Parent: Child process exited successfully.
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby Sharley » 04. January 2011 06:34

Code: Select all
[Mon Jan 03 21:24:28 2011] [error] [client 66.249.71.171] File does not exist: C:/xampp/htdocs/highscores
May be the issue, so correct the path to this file and it may work as it is the only error shown in the log file, the other entries look normal.
Apache is looking for the file called highscores in the htdocs folder and can't find it so there may be a path or configuration issue with a script or web page.

May be the highscores is a folder located in your web site folder and the link to it or relative path is not recognised by Apache in XAMPP.

If the path starts with a slash like this /highscores which would work on your hosting provider but equates to a different location (the htdocs folder) in XAMPP.

So you are looking for any path that starts with a / that needs that beginning slash deleted and then the path will work.
Last edited by Sharley on 04. January 2011 06:47, edited 1 time 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

Re: "The connection was reset"

Postby grosskopf » 04. January 2011 06:45

Sharley wrote:
Code: Select all
[Mon Jan 03 21:24:28 2011] [error] [client 66.249.71.171] File does not exist: C:/xampp/htdocs/highscores
May be the issue, so correct the path to this file and it may work as it is the only error shown in the log file, the other entries look normal.
Apache is looking for the file called highscores in the htdocs folder so there may be a path or configuration issue with a script or web page.


Well, I could bring that up on the support forums for XLRStats, but I don't know why that would happen. There is no file in the XLRStats installation with that name and I even just reinstalled the web files to be sure I had everything.
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby Sharley » 04. January 2011 06:48

See my last edit (addition) about relative paths and how the location is different in XAMPP to the location on a hosted service.

You were posting when I was editing.
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: "The connection was reset"

Postby grosskopf » 04. January 2011 07:30

Thanks for your replies. Unfortunately, nothing is working. I've posted a message on the forum for XLRStats. It seems this sort of problem is fairly common for a lot of different web applications but there's no definitive answer.

One thing I have noticed is that the first time I try loading the webpage, it tries the regular URL, then it seems to reload the page, adding www. to the beginning of it, then it times out.
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby Sharley » 04. January 2011 07:41

grosskopf wrote:Thanks for your replies. Unfortunately, nothing is working. I've posted a message on the forum for XLRStats. It seems this sort of problem is fairly common for a lot of different web applications but there's no definitive answer.
The need for understanding the difference between relative and absolute paths will go a long way in moving forward.

grosskopf wrote:One thing I have noticed is that the first time I try loading the webpage, it tries the regular URL, then it seems to reload the page, adding www. to the beginning of it, then it times out.
This behavior is common and harmless and was first used to help SEO, Search Engine Optimization.

It should not effect your now known issue of incorrect relative paths as it is instigate by a redirect command usually in a .htaccess file in your root web folder or in a config file on the Apache server.

Once you fix your relative path issues then the error in the log file should be no more.

Whether or not it fixes your stalling issue remains to be seen and don't forget to restart Apache if you make any configuration changes.
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: "The connection was reset"

Postby grosskopf » 04. January 2011 13:11

I know the difference between relative and absolute paths but I can't find anywhere that the paths are incorrect and there are no files or folders with the name "highscore" in the entire XLRStats installation. So far, one of the developers for XLRStats says there is no file or folder with that name as well. Very odd. I can't be sure if this is an Apache issue or an issue with XLRStats. :(

I do appreciate all of your help so far.
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby Sharley » 04. January 2011 13:42

My guess is, because I have no idea what files and folders are associated with xlrstats, somewhere in your xlrstats folder is a folder called highscores with a file status.xml in it perhaps.

Somewhere in the xlrstats folder is file that references a path /highscores/status.xml or similar.

Your tree may look like this xampp\htdocs\xlrstats\highscores

So when the above path is accessed by Apache it looks for a folder called highscores in the htdocs folder because of the leading slash.

The leading slash tells Apache to look in the DocumentRoot folder for a file or folder called highscores which it can't find and so errors.

The relative path highscores/status.xml (no leading slash) then would be accessed by Apache if the file that references the path is located in the \xampp\htdocs\xlrstats folder.

Therefore the absolute path would be /xlrstats/highscores/status.xml
which is htdocs\xlrstats\highscores\status.xml

If as you say there is no file or folder named highscores then the issue may still reside in one of the JavaScripts perhaps and I am always suspicious of outdated scripting in relation to a server that is relevantly up to date - the site stalls when trying to load a jQuery related JavaScript.

There is no code in XAMPP that references /highscores period.


If you find any paths in files in the xlrstats folder that uses a path with a forward slash included then they need to have the slash removed or in Apache in XAMPP they will be looked for in the htdocs folder just as the Apache error.log files is informing you - or is there a config setting perhaps in the xlrstats that addresses this path issue?

You should perhaps mention this path issue on the xlrstats forum or provide a link to this forum post to save you having to try and explain it and the point at when the site stalls.

I am signing off now on this issue as it is not XAMPP related but rather an issue with the script or the paths in xlrstats.

If you had a utility called His Grepship then you could quickly search all the xlrststs files for the highscores instance - Google for it.

Sorry I can't be of anymore help and if you find the solution I would appreciate the solution being posted in this topic.

Good luck and best wishes.
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: "The connection was reset"

Postby grosskopf » 04. January 2011 14:38

I can assure you that if the XLRStats dev's say there is no "highscores" folder or file that is part of XLRStats, I trust them. There is only one configuration file for XLRStats, and that one contains no paths to any files. I am truely baffeled, as these exact same files and database worked fine when hosted at Host Gator, but now that I'm hosting it on my VPS with XAMPP, it's not working. If I come across an answer, if it's XAMPP/Apache related, I'll post it here.
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: "The connection was reset"

Postby grosskopf » 04. January 2011 17:21

I've been doing more Googling on this topic and it seems that whole "highscores" thing was a fluke. It's not showing up anymore in the error log. The only constant that I am seeing is this:

Code: Select all
[Tue Jan 04 08:17:32 2011] [notice] Parent: child process exited with status 3221225477 -- Restarting.


Using Google, this seems to point to a problem with PHP. Not sure why my main website would work fine, but XLRStats wouldn't, but this is where I am now. It also seems that XAMPP is using an old version of PHP (5.3.1). I'd like to find out how to upgrade my PHP in XAMPP or how to have XAMPP use PHP that I install outside of XAMPP. There are also posts like this one that point to disabling "zend", but that can not be found on my php.ini: http://forums.mysql.com/read.php?52,421 ... #msg-49591
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 111 guests