A server timeout has occured.
Posted by: louisthecabbage (---.range81-135.btcentralplus.com)
Date: March 20, 2017 12:48AM

Hi,

When I try to connect dreamweaver to the mysql database, it crashes and gives me the error:

"A server timeout has occured. Here are the possible reasons.
1.Please make sure that the web server is up and running.
2. Please verify that the ODBC DSN exists on the test server."

---------------------------------------------------------------------------

1 - Windows version used (Specify version number AND whether 32 or 64 bit)
Windows 10 64 bit
2 - Version WampServer (Specify version number AND whether 32 or 64 bit)
3.0.6 65 bit
3 - Apache Version
2.4.23
4 - PHP Version
5.6.25
5 - MySQL Version
5.7.14
6 - What color is the WampServer icon (in the notification area of the taskbar)
green


Apache error log:
[Sun Mar 19 23:29:26.731294 2017] [mpm_winnt:notice] [pid 12272:tid 512] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 19 23:29:28.775891 2017] [mpm_winnt:notice] [pid 3976:tid 484] AH00364: Child: All worker threads have exited.
[Sun Mar 19 23:29:30.067546 2017] [mpm_winnt:notice] [pid 12272:tid 512] AH00430: Parent: Child process 3976 exited successfully.
[Sun Mar 19 23:29:33.922817 2017] [auth_digest:notice] [pid 2292:tid 560] AH01757: generating secret for digest authentication ...
[Sun Mar 19 23:29:35.874538 2017] [mpm_winnt:notice] [pid 2292:tid 560] AH00455: Apache/2.4.23 (Win64) PHP/5.6.25 configured -- resuming normal operations
[Sun Mar 19 23:29:35.874538 2017] [mpm_winnt:notice] [pid 2292:tid 560] AH00456: Apache Lounge VC14 Server built: Jul 1 2016 11:43:51
[Sun Mar 19 23:29:35.874538 2017] [core:notice] [pid 2292:tid 560] AH00094: Command line: 'c:\\wamp64\\bin\\apache\\apache2.4.23\\bin\\httpd.exe -d C:/wamp64/bin/apache/apache2.4.23'
[Sun Mar 19 23:29:35.876543 2017] [mpm_winnt:notice] [pid 2292:tid 560] AH00418: Parent: Created child process 6692
[Sun Mar 19 23:29:36.338818 2017] [auth_digest:notice] [pid 6692:tid 480] AH01757: generating secret for digest authentication ...
[Sun Mar 19 23:29:36.388957 2017] [mpm_winnt:notice] [pid 6692:tid 480] AH00354: Child: Starting 64 worker threads.

PHP error log
[19-Mar-2017 23:31:59 UTC] PHP Warning: mysql_connect(): MySQL server has gone away in C:\wamp64\www\_mmServerScripts\mysql.php on line 101

[19-Mar-2017 23:31:59 UTC] PHP Stack trace:

[19-Mar-2017 23:31:59 UTC] PHP 1. {main}() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:0

[19-Mar-2017 23:31:59 UTC] PHP 2. MySqlConnection->Open() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:77

[19-Mar-2017 23:31:59 UTC] PHP 3. mysql_connect() C:\wamp64\www\_mmServerScripts\mysql.php:101

[19-Mar-2017 23:31:59 UTC] PHP Warning: mysql_connect(): Error while reading greeting packet. PID=6692 in C:\wamp64\www\_mmServerScripts\mysql.php on line 101

[19-Mar-2017 23:31:59 UTC] PHP Stack trace:

[19-Mar-2017 23:31:59 UTC] PHP 1. {main}() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:0

[19-Mar-2017 23:31:59 UTC] PHP 2. MySqlConnection->Open() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:77

[19-Mar-2017 23:31:59 UTC] PHP 3. mysql_connect() C:\wamp64\www\_mmServerScripts\mysql.php:101

[19-Mar-2017 23:31:59 UTC] PHP Warning: mysql_connect(): MySQL server has gone away in C:\wamp64\www\_mmServerScripts\mysql.php on line 101

[19-Mar-2017 23:31:59 UTC] PHP Stack trace:

[19-Mar-2017 23:31:59 UTC] PHP 1. {main}() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:0

[19-Mar-2017 23:31:59 UTC] PHP 2. MySqlConnection->Open() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:77

[19-Mar-2017 23:31:59 UTC] PHP 3. mysql_connect() C:\wamp64\www\_mmServerScripts\mysql.php:101

[19-Mar-2017 23:31:59 UTC] PHP Notice: Undefined variable: answer in C:\wamp64\www\_mmServerScripts\MMHTTPDB.php on line 106

[19-Mar-2017 23:31:59 UTC] PHP Stack trace:

[19-Mar-2017 23:31:59 UTC] PHP 1. {main}() C:\wamp64\www\_mmServerScripts\MMHTTPDB.php:0


7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?
* Active means no # at the beginning of the line.
yes

If the WampServer icon is green:

8 - Do you have access to localhost (Homepage WampServer)?
yes
8a - If so, is there an error message at the bottom of the page?
no
9 - Do you have access to phpMyAdmin?
yes
10 - If you refer to an error message, please include the EXACT wording of the error in your post
11 - If you use an Antivirus and / or Firewall, please include the names of these
Avira
12 - What is the full path to the installation of WampServer (eg D:\wamp\)
C:\wamp\
13 - If you have one or more Virtual Hosts defined, please show their definition(s)

Options: ReplyQuote
Re: A server timeout has occured.
Posted by: RiggsFolly (Moderator)
Date: March 20, 2017 01:49AM

WHat version of PHP are you using in WAMPServer?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: A server timeout has occured.
Posted by: louisthecabbage (---.bhasvic.ac.uk)
Date: March 20, 2017 09:38AM

It's 5.6.25 I believe

Options: ReplyQuote
Re: A server timeout has occured.
Posted by: louisthecabbage (---.bhasvic.ac.uk)
Date: March 20, 2017 11:38AM

Ok I found the problem!!!!!

On Dreamweaver when connecting to the database, under the 'MySQL' option you don't put the port but just localhost.

Options: ReplyQuote


Sorry, only registered users may post in this forum.