DeveloperSide.NET Forums
September 20, 2018, 04:31:47 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1] 2 3
  Print  
Author Topic: Solutions to the most common problems...  (Read 73157 times)
0 Members and 1 Guest are viewing this topic.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« 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)
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)
« Last Edit: September 04, 2007, 03:40:24 PM by admin » Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
Fenwick
Jr. Member
**
Posts: 50


View Profile
« Reply #1 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...
Logged

magination is the Only Limitation

Phantasia a community based forum on security and additional help with server software. Site is beta-mode - and will start filling forums with additional help as soon as possible
 
http://myphantasia.cjb.net/
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #2 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().
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #3 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)
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #4 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/
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #5 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
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #6 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.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #7 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/
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #8 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
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #9 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.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #10 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.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #11 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.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #12 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
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #13 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
more info...
IIS 5.0 : http://support.microsoft.com/kb/238131/EN-US/
IIS 6.0 : 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://support.microsoft.com/kb/325889/EN-US/
http://support.microsoft.com/kb/236166/EN-US/
http://support.microsoft.com/Kb/185382/EN-US/
« Last Edit: March 23, 2007, 06:05:40 PM by admin » Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #14 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
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
Pages: [1] 2 3
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!