DeveloperSide.NET Forums

DeveloperSide.NET => Web.Developer Server Suite Community Edition,
Public Support Forum => Topic started by: admin on July 08, 2004, 12:29:53 AM



Title: Solutions to the most common problems...
Post by: admin on July 08, 2004, 12:29:53 AM
Most of the problems are caused by the following...

Installed Firewall software such as ZoneAlarm (software that poorly re-implements key Windows interfaces/layers and breaks compatibility) can cause major problems for Apache, MySQL, and phpMyAdmin.
With ZoneAlarm, the solution is to uninstall the software (not just shut it down), clear the browser cache, and reboot.

Windows Service Pack 2 (SP2) introduces a native firewall into the Operating System.
Either configure it to pass port 80 (http) and 3306 (mysql), or shut it down.
Even when properly configured, this firewall might still cause problems, always try to shut it down when troubleshooting.

Already present MySQL and/or Apache2 Services installed.  Some users will have these Services installed from an earlier installation of the software.  No new Services can be installed under the same name (Apache2, MySQL).
Solution: Run "services.msc", find Service names "Apache2" and/or "MySQL"; select them (with a double click), and make sure they are originating from our package: <drive>:\www\Apache2\bin and/or <drive>:\www\mysql\bin.  If not, you will need to shut these Services down, uninstall these Services, and install (and start) our Services manually.

An already present, and overriding, root level MySQL "my.cnf" configuration file left from a previous installation of MySQL.
Note that the "cnf" file extension is invisible, by default, under Windows.
Example: C:\my.cnf or C:\my
Solution: Delete this file.


Other causes...

An existing %SystemRoot%\system32\libmysql.dll file from an earlier self-installing version of MySQL could conflict with a new installation of MySQL.
Solution: Delete this file.

IIS (Internet Information Services) installed
A poorly configured Router
Anti-Virus/Worm software (McAfee products have been known to cause problems for Apache)
(If you are running a McAfee product that contains the 'Privacy Service', you will need to uninstall the Privacy Service)
(Symantec Norton Worm blocking will need to be turned off)
Norton products are notorious for causing problems...
(http://it.slashdot.org/comments.pl?sid=173973&cid=14471393 (http://it.slashdot.org/comments.pl?sid=173973&cid=14471393))
SKYPE blocks port 80.
VPN software
Malware, spyware, viruses

Unconfirmed (known to have caused problems for other related software)...

nod32 and Panda Anti-Virus software
Network Monitoring software (such as NetLimiter)


Title: Solutions to the most common problems...
Post by: Fenwick on July 08, 2004, 03:07:47 AM
As a volunteer to help and assist others- might I add that an investment of about 30 minutes reviewing and searching this forum - will also yield answers to numerous common and repeated situations.

By using key terms in the search segment of this forum, and ensuring any resulting returns are within the category specific to the user (Linux or Windows), you can find that others before yopu have asked the same questions.  By following the responces and discussions of previous threads - you might be able to solve any issues along with those mentioned by admin previous to this post and rectify a majority of the issues.

Keep in mind this forum is specific to the DevSide Suite environment and not focussed on the individual components you can acquire elsewhere.  Those individual components have their own community support specific to those items.  Although these items are possibly utilized within the DevSide Environment - they are focussed specifically in the package.

Be kind to the admin and volunteers, we have RW commitments as well - expect a delay of about 24 hours between asking a question and responces of possible answers to be replied.

As a side note mentioned under "NEWS" within this forum - all users must[/i] register a name to prevent abuse of this forum.

http://forums.devside.net/viewtopic.php?t=378

Peace...


Title: Solutions to the most common problems...
Post by: admin on July 08, 2004, 03:26:21 AM
Another helpful bit from apache.org...

Problems Running Apache 2
http://apache.cs.utah.edu/httpd/binaries/win32/
Quote

If you encounter problems running Apache 2 under Windows, such as corrupted or incomplete file downloads, unexplained error messages, or a conflict with a software firewall, please place the following directives in httpd.conf to see if they eliminate the issue:

Code:

EnableSendfile Off
EnableMMAP Off
Win32DisableAcceptEx

Quote

The general problem is that many people install various add-ons to windows (such as software firewalls, virus checkers, etc) that break some of the advanced functionality that Apache uses to speed the sending of files. The above directives turn off the advanced functionality and make Apache fall back to more basic (but slower) techniques.


Win32DisableAcceptEx Directive
http://httpd.apache.org/docs-2.0/mod/mpm_winnt.html#win32disableacceptex
Quote

AcceptEx() is a Microsoft WinSock v2 API that provides some performance improvements over the use of the BSD style accept() API in certain circumstances. Some popular Windows products, typically virus scanning or virtual private network packages, have bugs that interfere with the proper operation of AcceptEx(). If you encounter an error condition like:

Code:

[error] (730038)An operation was attempted on something that is not a socket.: winnt_accept: AcceptEx failed. Attempting to recover.

Quote

you should use this directive to disable the use of AcceptEx().


Title: Solutions to the most common problems...
Post by: admin on July 08, 2004, 03:31:45 AM
Also, when troubleshooting...

Make sure to always check files...
\www\Apache2\logs\error.log
\www\Apache2\logs\access.log
\www\mysql\data\*.err

You can also set, under httpd.conf, 'LogLevel' from levels "warn" or "error" to "debug" for maximum verbosity of ErrorLog...
http://httpd.apache.org/docs-2.0/mod/core.html#loglevel

Under the command prompt, type...
Code:

netstat -an

...to display local connections and ports.
This is useful to see if anything is listening on port 80 (http -- Apache/IIS) and 3306 (MySQL).
And if Apache and MySQL are binding to localhost (127.0.0.1:80/3306) or listening on all interfaces (0.0.0.0:80/3306)


Title: Solutions to the most common problems...
Post by: admin on October 30, 2004, 12:16:12 AM
Here is a fix for XP SP2 users, that are using addresses in the range of 127.0.0.* (aside from 127.0.0.1) under httpd.conf for things such as Virtual Hosting...

Note: do not do this unless you know exactly what your problem is.
http://support.microsoft.com/kb/884020/EN-US/


Title: Solutions to the most common problems...
Post by: admin on December 14, 2004, 03:33:25 AM
MySQL -- How to Reset the Root Password
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

MySQL -- Common Errors When Using MySQL Programs
http://dev.mysql.com/doc/refman/5.1/en/common-errors.html


Title: Solutions to the most common problems...
Post by: admin on January 07, 2005, 08:28:07 PM
As a note, it is also well advised to close out IE and clear out your browser cache when dealing with configuration problems and newly made changes.


Title: Solutions to the most common problems...
Post by: admin on February 21, 2005, 08:03:56 PM
Here is some info on how to work with the WinXP SP2 Firewall to allow a program to run...
http://support.microsoft.com/kb/842242/EN-US/


Title: Solutions to the most common problems...
Post by: admin on September 19, 2005, 06:10:31 PM
For Apache related configuration issues, the best source of information is contained on this page...
http://httpd.apache.org/docs/2.0/

Also, the Directive Quick Reference "shows the usage, default, status, and context of each Apache configuration directive."
http://httpd.apache.org/docs/2.0/mod/quickreference.html


Title: Solutions to the most common problems...
Post by: admin on January 08, 2006, 03:37:33 PM
Some users will have PHP and/or MySQL dlls from a previous install of PHP and/or MySQL under the following directories (dlls that were copied by the user to those dirs due to incorrect installation instructions)...

%SystemRoot%/
%SystemRoot%/system32/
%SystemRoot%/system/

%SYSTEMROOT% : Win2000 -> C:\WINNT, WinXP -> C:\Windows

Since these directories come first under the System PATH (relative to ...\PHP and/or \MySQL), the older dlls will get loaded and will cause PHP and/or MySQL to fault.

Check the mentioned dirs for files such as...

php5apache2.dll
php4apache2.dll
php5ts.dll
php4ts.dll
libmysql.dll
php_mysql.dll
php_mysqli.dll

...and any other dlls that you might have copied over.


Title: Solutions to the most common problems...
Post by: admin on January 15, 2006, 11:31:27 AM
If you are getting an error message after boot...
Quote

PHP Startup: Unable to load dynamic library '/www/php5/ext/php_mysqli.dll (or php_mysql.dll)' - The specified module could not be found.


Copy file \www\php5\libmysql.dll to your %SystemRoot%\system32 dir.


Title: Solutions to the most common problems...
Post by: admin on January 23, 2006, 08:06:27 AM
If you need to uninstall an old Apache and/or MySQL Service but you  have already deleted the program files, you can remove the Service(s) manually.

Run 'regedt32.exe' (or whatever native registry editor you use -- there is another one called 'regedit.exe')
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\
Select the old Service(s), hit del key or select menu Edit -> Delete

Exit and reboot.

The Service(s) will be gone.


Title: Solutions to the most common problems...
Post by: admin on January 28, 2006, 09:00:37 AM
If this registry key is present...
HKEY_LOCAL_MACHINE\SOFTWARE\PHP\IniFilePath
PHP could use the location of that php.ini over the one placed under %SystemRoot%.

Also, check MySQL's registry key...
HKEY_LOCAL_MACHINE\SOFTWARE\MySQL AB

Note that you can start mysqld Service with option...
mysqld-nt.exe --defaults-file="C:\Windows\my.ini" --install
...to make sure it loads the right config file.
MySQL options can also be checked under key...
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\mysql\ImagePath


Title: Solutions to the most common problems...
Post by: admin on March 08, 2006, 06:58:51 PM
Running Apache and IIS on the same Server...
http://forums.devside.net/index.php?topic=536.0 (http://forums.devside.net/index.php?topic=536.0)
more info...
IIS 5.0 : http://support.microsoft.com/kb/238131/EN-US/ (http://support.microsoft.com/kb/238131/EN-US/)
IIS 6.0 : http://support.microsoft.com/kb/813368/EN-US/ (http://support.microsoft.com/kb/813368/EN-US/)

How to stop and disable the IIS Service(s)...
Run 'services.msc', double-click on the "IIS Admin Service" OR "iisadmin" Service, click "Stop", change 'Startup type:' to "Disabled".
The 'iisadmin' Service is the main IIS Service.
You can also stop this Service from the command line (but not disable it) with...
net stop iisadmin /y

more info...
Uninstalling IIS (IIS 6.0) : http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/910e7485-d74c-4647-87a5-f9d0f9aae51e.mspx (http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/910e7485-d74c-4647-87a5-f9d0f9aae51e.mspx)
http://support.microsoft.com/kb/325889/EN-US/ (http://support.microsoft.com/kb/325889/EN-US/)
http://support.microsoft.com/kb/236166/EN-US/ (http://support.microsoft.com/kb/236166/EN-US/)
http://support.microsoft.com/Kb/185382/EN-US/ (http://support.microsoft.com/Kb/185382/EN-US/)


Title: Solutions to the most common problems...
Post by: admin on March 08, 2006, 11:39:40 PM
When using PHP v4 (php_mysql.dll built in) or PHP v5 with php extension php_mysql.dll and are connecting with MySQL version 4.1 or higher...
old_password
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Quote
Client does not support authentication protocol requested by server; consider upgrading MySQL client


Title: Solutions to the most common problems...
Post by: admin on May 29, 2006, 08:46:43 PM
http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html

Also, the footer text contains some relevant info...
http://www.wmwweb.com/apache/httpd/binaries/win32/


Title: Solutions to the most common problems...
Post by: admin on September 16, 2006, 02:09:25 PM
How to determine and recover from Winsock2 corruption...
http://support.microsoft.com/?kbid=811259


Title: Solutions to the most common problems...
Post by: admin on November 28, 2006, 11:49:16 PM
If you are having problems, comment out the inclusion of mod_security under httpd.conf [v1.18-] or Suite-extra\components.conf [v1.90+] to see if its blocking the request.


Title: Apache 2.2.X Subversion 1.4 & Mod_Security Howto
Post by: yuccmember on January 22, 2007, 04:57:35 PM
Just share what I did.

1. Setup Subversion 1.4 with Apache 2.2.X
    According to Subversion official site (http://subversion.tigris.org/project_packages.html), Subversion 1.4.2 doesn't work with windows Apache 2.2.X binary. I googled and found someone has posted compatible Subversion 1.4.2 on http://www.apachelounge.com/forum/viewtopic.php?t=121&postdays=0&postorder=asc&start=16

In the forum above, you can download the dlls and modules

puts those dlls in www\Apache22\bin
and libdb44.dll, mod_authz_svn.so, mod_dav_svn.so in www\Apache22\modules

2. modify httpd.conf
uncomment:
LoadModule dav_module modules/mod_dav.so
LoadModule dav_fs_module modules/mod_dav_fs.so

Add two lines:
LoadModule dav_svn_module modules/mod_dav_svn.so
LoadModule authz_svn_module modules/mod_authz_svn.so

Add the following: (please read http://tortoisesvn.net/docs/release/TortoiseSVN_en/tsvn-serversetup.html#tsvn-serversetup-apache-4)

<Location /svn>
DAV svn
SVNListParentPath on
SVNParentPath C:\SVN
AuthType Basic
AuthName "Subversion repositories"
AuthUserFile passwd
#AuthzSVNAccessFile svnaccessfile
Require valid-user
</Location>

3. Mod_Security: Change rules for mod_security
   www\Apache22\conf\Suite-extra\modsec_rules\rules.conf
   Change line 41:
   SecFilterSelective REQUEST_METHOD "!^(GET|HEAD|POST|PUT|PROPFIND|OPTIONS)$" "chain,id:340001,rev:1,severity:2,msg:'Restricted HTTP function'"
 
   to:
   SecFilterSelective REQUEST_METHOD "!^(GET|HEAD|POST|PUT|PROPFIND|OPTIONS|PROPPATCH|REPORT|MKACTIVITY|CHECKOUT|PUT|DELETE|MERGE)$" "chain,id:340001,rev:1,severity:2,msg:'Restricted HTTP function'"

   comment line 137:
   #SecFilterSelective ARGS "((alter|create|drop)[[:space:]]+(column|database|procedure|table)|delete[[:space:]]+from|update.+set.+=)" "id:300015,rev:1,severity:2,msg:'Generic SQL injection protection'"

4. Testing: Subversion Tools (tortoisesvn --- http://tortoisesvn.net/downloads)


Title: Re: Solutions to the most common problems...
Post by: admin on February 07, 2007, 08:38:58 PM
For mod_rewrite to function, you need...
Code:
Options FollowSymLinks
...and to get mod_rewrite to work from an .htaccess file...
Code:
AllowOverride FileInfo


Title: Re: Solutions to the most common problems...
Post by: admin on February 14, 2007, 08:38:08 PM
A lot of people _think_ that their ISPs are blocking port 80... But in reality...
1) the user has not port forwarded port 80 under router
2) the user has all kinds of anti-virus and firewall programs installed that are blocking Ports, IPs, Applications, or just messing everything up
3) the Windows XP SP2 native firewall is blocking incoming port 80 for Apache.exe/httpd.exe


Title: Re: Solutions to the most common problems...
Post by: admin on June 24, 2007, 04:17:39 PM
For anyone running Skype:

In some situations Skype will attempt to bind to ports 80 [http -- the port Apache uses] and 443 [ssl -- another port Apache uses with mod_ssl].

If this happens, Apache will not start...

You will either need to start Skype manually AFTER Apache starts, or configure the Skype Service to load after the Apache Service: by making the Skype Service dependent on the Apache Service.


Title: Re: Solutions to the most common problems...
Post by: admin on July 17, 2007, 03:05:11 PM
If you are attempting to use SSI [Server Side Includes], even thought the httpd guide states that you can place AddOutputFilter, or any of its cousins, in the global scope, this will not work outside a dir or location block.

<Location />
        Options +Includes
        AddType text/html .shtml
        AddOutputFilter INCLUDES .shtml
</Location>


Title: Re: Solutions to the most common problems...
Post by: admin on July 17, 2007, 03:18:49 PM
Under Vista, to run WDController.exe, you have to right click it, and run as administrator...

http://forums.devside.net/index.php?topic=1382.01


Title: Re: Solutions to the most common problems...
Post by: admin on July 18, 2007, 12:29:23 AM
I know some people have reported display/format problems with phpmyadmin in the past... Usually these types of problems are JavaScript or CSS related.

Today I experienced a problem such as this myself, for no apparent reason. phpMyAdmin loaded up as if there was no CSS.

After a reboot [a browser restart might have been sufficient] this problem disappeared.


Title: Re: Solutions to the most common problems...
Post by: admin on August 04, 2007, 03:27:39 AM
It appears that some torrent clients bind to Port 80 to host a web gui.

utorrent has been reported as doing this, and a quick search on Google gives a few more.


Title: Re: Solutions to the most common problems...
Post by: admin on September 01, 2007, 06:45:35 PM
mod_security should be disabled when tracking down a problem... There seem to be an issue with output buffering when this module is on, even if in 'detection only' mode.


Title: Re: Solutions to the most common problems...
Post by: admin on September 06, 2007, 02:12:07 PM
PHP configuration file [php.ini] is searched for in the following order on your system...
http://php.net/configuration

Any previous PHP installation can potentially leave a php.ini file in any of the mentioned locations, path and/or registry, that will override our C:\Windows\php.ini as this is one of the last locations on the search list.


Title: Re: Solutions to the most common problems...
Post by: admin on October 09, 2007, 09:46:48 AM
For those that are having issues with Virtual Hosts and mod_rewrite...

Quote
By default, mod_rewrite configuration settings from the main server context are not inherited by virtual hosts. To make the main server settings apply to virtual hosts, you must place the following directives in each <VirtualHost> section:

RewriteEngine On
RewriteOptions Inherit

You just need the "RewriteEngine On" part, the "Inherit" part you might want to leave out.


Title: Re: Solutions to the most common problems...
Post by: admin on October 12, 2007, 12:01:10 AM
Windows Vista users who are NOT installing as user 'administrator':

The User Account Control (UAC) in Vista causes problems with the installation. You must disable UAC, install the Suite, and then re-enable UAC for everything to work.

I believe UAC is preventing everyone but 'administrator' from installing Services. I've also had reports of other users with the administrator privileges having problems.


Title: Re: Solutions to the most common problems...
Post by: jamescarvin on April 02, 2008, 02:46:01 AM
Thank you for this thread. That helps. But I'm not sure I understand what I need. I made the blunder of installing community Develper Suite over a previous install of xAmpp. And now I need to UnInstall everything to start over.

Joomla and Drupal were supposed to be easy. Now here I am troubleshooting development server installs. uhhhhh?

In reply #11 you said:
Quote
If you need to uninstall an old Apache and/or MySQL Service but you  have already deleted the program files, you can remove the Service(s) manually.

Run 'regedt32.exe' (or whatever native registry editor you use -- there is another one called 'regedit.exe')
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\
Select the old Service(s), hit del key or select menu Edit -> Delete

Exit and reboot.

The Service(s) will be gone.

Questions:
1)How do I uninstall in the first place. Just go to Add/Remove programs?
(OK. never mind. Found it. Start>>DeveloperSide>>Uninstall - pretty simple; however, I still had to uninstall xAmpp through Add/Remove, which also removed MySQL and dbs after prompts)

2) I found regedit in /start>>Run»HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ but I did not see a folder for OldServices. Should I assume that the previous uninstalls already got them?

And in reply #9 you said:
Quote
Some users will have PHP and/or MySQL dlls from a previous install of PHP and/or MySQL under the following directories (dlls that were copied by the user to those dirs due to incorrect installation instructions)...

%SystemRoot%/
%SystemRoot%/system32/
%SystemRoot%/system/

%SYSTEMROOT% : Win2000 -> C:\WINNT, WinXP -> C:\Windows

Since these directories come first under the System PATH (relative to ...\PHP and/or \MySQL), the older dlls will get loaded and will cause PHP and/or MySQL to fault.

Check the mentioned dirs for files such as...

php5apache2.dll
php4apache2.dll
php5ts.dll
php4ts.dll
libmysql.dll
php_mysql.dll
php_mysqli.dll

...and any other dlls that you might have copied over.

Questions:
1. How do I find the system root?
(I know this sounds stupid. I have Win XP. Is this c:// ? Under folder options I have view hidden files checked)

2. Do I need to both uninstall and delete these dlls afterwards?
(if I can find them - I can't seem to find them. I did find one dll. It is a MS C++ runtime library file called msvci70.dll. But I don't know how it got there. Sounds more like a misplaced system file. It doesn't sound php/mysql related. Maybe its supposed to be there. Should I delete it?)

3. When will it be safe for me to reinstall? (For instance, I had a previous install of joomla. Do I also need to uninstall this? If so I can't find it in add/remove programs so I'm assuming my previous uninstallations already got it.)

Thanks again!
Total Dufas Newbie


Title: Re: Solutions to the most common problems...
Post by: admin on April 02, 2008, 02:41:59 PM
Quote
I found regedit in /start>>Run»HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ but I did not see a folder for OldServices.

"Old Services" as in the names of the old Apache and MySQL services... "Apache2.2" and "MySQL". And hence...
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Apache2.2
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL

Also note that those instructions where for a test case where the user has incorrectly "uninstalled" by deleting the previous directory that contained whatever Suite or Service they where using, without uninstalling it 1st. This might not apply to you.

Quote
1. How do I find the system root?

If you have Windows XP then 99% chance it's C:\WINDOWS
If you have Windows 2000, then it's C:\WINNT.

Quote
2. Do I need to both uninstall and delete these dlls afterwards?

Other WAMP distributions, and some earlier setups of PHP, copied the listed DLLs into the listed directories [they should not have done this]. If you don't have any of those 7 listed DLLS under C:\WINDOWS, then you do not have a problem. This is another test case that probably affects less than 2% of the users.



Title: Re: Solutions to the most common problems...
Post by: admin on June 27, 2008, 03:42:50 PM
Under Vista, if you need to run cmd.exe [the command shell/prompt/line] to manually install the Apache and MySQL Services, you will need to do one of the following:

1. Disable UAC.

or

2. [classic mode menu] Start, Programs, Accessories. Then right click Command Prompt and left click “Run as administrator”.

or

3. Use the runas (http://technet2.microsoft.com/windowsserver2008/en/library/7b710f79-d28a-4297-b5fc-0c1868d236fc1033.mspx) command. This one will only work if your admin account actually has a password [runas will not accept blank passwords as input].