Can't connect to local MySQL server

Hi Jason(?)
Getting the following browser message when I submit this form. The actual email sends to but no Email Logging data is being saved to the server: ContactMe3.php :

Fatal error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /data/20/1/125/115/1940604/user/2116827/htdocs/thilldesign/Connections/thilldesign.php on line 9

file:///C:/Users/PixelDigit/AppData/Roaming/Adobe/Dreamweaver%20CS5.5/en_US/Configuration/WAUE_HTML.htm

ALSO, when I go back to the Dreamweaver file ContactMe3.php and attempt to open the Server Behavior "Universal Email 15 (mail)" I get this DW error, "While Executing applyServerBehavior in CreateEmailMessage_WA.htm, a JavaScript error occurred."

Thanking you in advance for your usual excellent advice.

I solved the following issue by deleting the WinFileCache.dat file, big D'oh:
"ALSO, when I go back to the Dreamweaver file ContactMe3.php and attempt to open the Server Behavior "Universal Email 15 (mail)" I get this DW error, "While Executing applyServerBehavior in CreateEmailMessage_WA.htm, a JavaScript error occurred."

Read a couple other posts on "Can't connect..." and found one that said change the Connections file in DW. This is the original:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_thilldesign = "localhost";
$database_thilldesign = "thilldesign";
$username_thilldesign = "cosmo";
$password_thilldesign = "cosmo";
$thilldesign = mysql_pconnect($hostname_thilldesign, $username_thilldesign, $password_thilldesign) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Changed $hostname_thilldesign = "localhost"; to $hostname_thilldesign = "127.0.0.1";
No luck

Changed $thilldesign = mysql_pconnect($hostname_thilldesign, $username_thilldesign, $password_thilldesign) or trigger_error(mysql_error(),E_USER_ERROR); to
$thilldesign = mysql_pconnect($hostname_thilldesign, $username_cosmo, $password_cosmo) or trigger_error(mysql_error(),E_USER_ERROR);
Still no luck, will keep digging.

Hey Phill,

Try changing $username_cosmo and $password_cosmo back to $username_thilldesign and $password_thilldesign. Those are variables that hold the username and passwords and having different names will cause the connection to fail.

Keeping the localhost to 127.0.0.1 change, your connection should be:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_thilldesign = "127.0.0.1";
$database_thilldesign = "thilldesign";
$username_thilldesign = "cosmo";
$password_thilldesign = "cosmo";
$thilldesign = mysql_pconnect($hostname_thilldesign, $username_thilldesign, $password_thilldesign) or trigger_error(mysql_error(),E_USER_ERROR);
?>

If that doesn't solve the issue, please try to remove the existing connection, and create a new one in its place.

If that doesn't solve the problem, please let me know.

Mathew
Newbie here, thanks for your patience.
I made a new DB connection with the settings you suggested -- no success.
Attached is a Zip with a screen shot of my php users. I set all with the same "cosmo" password (will replace when I get this figured out). Do I need all these users?
Also included all the files in the attached Zip I think are pertinent to this email: ContactMe3.php
I am also getting an error message quite regularly, "Spry is undefined", screen shot in Zip. In the error message I click yes to continue running scripts, correct?
Thanks again

Wondering if I might have corrupted some WA files. In the Dreamweaver file ContactMe3.php when I attempt to open the Server Behavior "Universal Email 16 (mail)" OR when I attempt to apply Insert > WebAssist > Create Email Message, I get this DW error, "While Executing applyServerBehavior in CreateEmailMessage_WA.htm, a JavaScript error occurred."

I deleted the Server Behavior "Universal Email 16 (mail)" from ContactMe3.php and tried to apply Insert > WebAssist > Create Email Message and still got DW error, "While Executing applyServerBehavior in CreateEmailMessage_WA.htm, a JavaScript error occurred.

I also attempted above in an older file, ContactMe2.php, and got same error.

Files attached

I re-installed UE and got this error in the Dreamweaver file ContactMe3.php when I attempt to open the Server Behavior "Universal Email 16 (mail)":
"While Executing timer in WA Universal Email.htm, the following JavaScript error(s) occurred:
At line 320 of file
'C:\Users\PixelDigit\AppData\Roaming\Adobe\DreamweaverCS5.5\en_US\Configuration\Shared\WebAssist\UniversalEmail\WAUniversalEmailShared.js': defwhere has no properties"

WAUniversalEmailShared.js attached in Zip

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

In my DW file, ContactMe3.php , when I try to open the Server Behavior, Universal Email 18 (mail), I get the following error message:
While executing timer in WA Universal Email.htm, the following JavaScrip error(s) occurred:
At line 3205 of file
"C:\Users\PixelDigit\AppData\Roaming\Adobe\Dreamweaver CS5.5\en_US\Configuration\Commands\WA Universal Email.js": noPopulate is not defined

HERE IS WHAT I HAVE DONE SINCE OUR SUPPORT SESSION

Looks like I might have the DB connections to my local server figured out. I followed your tutorial video, Setting up a Database Connection in Dreamweaver, as well as the information in David McFarland's Dreamweaver CS5.5: The Missing Manual, Chapter 24, Getting Started with Dynamic Websites, Connecting to a Database.

With the new database, Connections > connthilldesign.php , did NOT get any error messages similar to the following previous error message:
Fatal error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /data/20/1/125/115/1940604/user/2116827/htdocs/thilldesign/Connections/thilldesign.php on line 9

In my DW file, ContactMe3.php , UE created the table, dw_submit_form , and placed it in my local server, phpMyAdmin, but when I send the email form it does send an email but does not populate the php table. This, I assume, is because of the js error above?

Files attached.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.