Hi,

I am using TechPlatform with Apache and MySQL to run a website. This website uses the MySQL DB to store its user names and passwords. When access to a sensitive part of the site is required, the user name password dialog box appears in Internet Explorer (or Netscape) per the Apache settings. About once every other day, you will put in your user name and password and Internet Explorer will just sit there and stare at you. It is almost like it cannot get a responce from Apache which maybe cannot get a responce from MySQL . Stopping the Apache, MySQL services and restarting them Immediately resoves the issue.. I dont understand why this happens, especially considering the randomness of its appearance. Please help,

Greg

Set LogLevel debug, restart Apache and
inspect its logs at the moment when you get IE frozen.

dd,

thanks for the reply.. here is some info from the error.log from when this happened earlier this morning.. let me stress that this behavior is completely random in its appearance..

[Mon Feb 02 10:52:17 2004] [error] [client 204.176.114.143] Premature end of script headers: d:/nusphere/apache/cgi-bin/events_table.cgi
[Mon Feb 02 10:52:17 2004] [error] [client 204.176.114.143] DBI connect('events:host=localhost','dscweb',...) failed: Couldn't connect to localhost:3306/tcp: IO::Socket::INET: connect: Unknown error at d:/nusphere/perl/site/lib/DBD/mysqlPP.pm line 109

[Mon Feb 02 10:52:17 2004] [error] [client 204.176.114.143] at d:\nusphere\apache\cgi-bin\EVENTS~1.CGI line 27

[Mon Feb 02 10:52:17 2004] [error] [client 204.176.114.143] unable to include "/cgi-bin/events_table.cgi" in parsed file d:/nusphere/apache/htdocs/dsc/index.htm
[Mon Feb 02 10:52:23 2004] [error] MySQL error: Can't connect to MySQL server on '140.185.43.25' (10061)
[Mon Feb 02 10:52:23 2004] [error] MySQL user dscwebmaster not found: /Admin
[Mon Feb 02 10:52:24 2004] [error] MySQL error: MySQL server has gone away
[Mon Feb 02 10:52:24 2004] [error] MySQL user dscwebmaster not found: /Admin
[Mon Feb 02 10:52:26 2004] [error] MySQL error: MySQL server has gone away
[Mon Feb 02 10:52:26 2004] [error] MySQL user dscwebmaster not found: /Admin
[Mon Feb 02 10:52:29 2004] [error] MySQL error: MySQL server has gone away
[Mon Feb 02 10:52:29 2004] [error] MySQL user dscwebmaster not found: /Admin
[Mon Feb 02 10:52:33 2004] [error] MySQL error: MySQL server has gone away
[Mon Feb 02 10:52:33 2004] [error] MySQL user dscwebmaster not found: /Admin
[Mon Feb 02 10:52:36 2004] [error] MySQL error: MySQL server has gone away
[Mon Feb 02 10:52:36 2004] [error] MySQL user dscwebmaster not found: /Admin
^CTerminating on signal SIGHUP(1)
Terminating on signal SIGHUP(1)

These are also all throught my log file

[Tue Nov 25 12:27:21 2003] [error] MySQL error: Lost connection to MySQL server during query[Tue Nov 25 12:27:21 2003] [error] MySQL error: Lost connection to MySQL server during query

seems mysql troubles you.
Please consider upgrading it as a necessary step up.

Anyways, we do not provide mysql with our products anymore...
We've switched to UltraSQL/PostgreSQL.

Do you know if there is a tool that will migrate my MySQL data to your new UltraSQL software?

Yep. there are a lot of in the Net.
Should be emphasized that this process is not a straightforward one.
PostgreSQL (and consequently UltraSQL) supports much more features than mySQL, although they do not always have direct equivalents.

You'd try these instructions first:
http://www.xach.com/aolserver/mysql-to-postgresql.html
Also, take a look at
http://forums.devshed.com/t77332/s.html

http://www.sitepoint.com/article/529