Newbie needs help with WB Installation error on FatCow host

[dsavage]

Hey folks.  I'm totally new to website design, and am having a persistent problem with installing WebsiteBaker on FatCow.com

FatCow uses Apache webservers, so that's not the issue.  Fat Cow uses PHP 5.2.2 and MySQL 5.0.77 and provides unlimited memory.

Per the installation instructions on the WebsiteBaker website, I uploaded the WebsiteBaker files onto my hard drive, decompressed them, and then used FileZilla (since my PC runs Windows) to FTP the files from the wb directory on my hard drive into a directory (also called wb) that I created within my FatCow account.  One note: I did note that a number of "failed transfers" during the FTP, so I went back and compared the hard drive files to the destination files to identify the files that did not get transferred automatically, and I transferred those files manually.

I then  created a mySQL database on FatCow, also called wb.  I made sure that I had read/write permissions for the database.

I then ran the WebsiteBaker installation script by typing "http://www.mycompanyname.com/wb/installation/index.php" into my browser (Firefox 3.6.3).

Once I did that, the following appeared in the browser address bar:
"http://www.mycompanyname.com/wb/install/index.php?sessions_checked=true"

In my browser window, the WebsiteBaker Installation Wizard form appeared - some info on the form was already filled out, and some was for me to fill out. I filled out the necessary info and then clicked the "Install websitebaker" button. Got the following message at the top of the screen:

Error: Database host name, username and/or password incorrect. MySQL Error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I contacted FatCow and they say that the database permissions are set up correctly so they are not sure why I am having problems installing wb.

Below, I show the info as it appeared on the form when I was done with it. I have checked my username and password several times. Am I entering the hostname incorrectly? According to WebsiteBaker instructions, I should just enter the word "localhost" if the wb files and the database files are on the same server...

WB Installation Wizard Form

Step 1
Please check the following requirements are met before continuing...
PHP Version > 4.1.0 Yes
PHP Session Support Enabled
PHP Safe Mode Disabled
AddDefaultCharset unset Yes

Step 2
Please check the following files/folders are writeable before continuing...
wb/config.php Writeable
wb/pages/ Writeable
wb/media/ Writeable
wb/templates/ Writeable
wb/modules/ Writeable
wb/languages/ Writeable
wb/temp/ Writeable

Step 3
Please check your path settings, and select a default timezone and a default backend language...
Absolute URL: http://www.mycompanyname.com
Default Timezone: GMT - 4 hours
Default Language: English

Step 4
Please specify your operating system information below...
Server Operating System: Linux/Unix based

Please enter your MySQL database server details below...
Host Name: localhost
Username: (my fatcow username)(not my database username)
Database Name:wb
Password: (my fatcow password)(not my database password)
Table Prefix:jal
Install Tables (box is checked)

Step 5
Please enter your website title below
Website Title: mycompanyname

Step 6
Please enter your Administrator account details below...
Username: (my admin username)
Password: (my admin password)
Email: (my email address)
Re-Password: (my admin password repeated)

THAT'S IT!  CAN ANYONE HELP ME FIGURE OUT WHAT MIGHT BE WRONG?  AM I MAKING A NEWBIE MISTAKE?  (-:

Thanks!
Deb Savage

[kweitzel]

Please enter your MySQL database server details below...
Host Name: localhost
Username: (my fatcow username)(not my database username)
Database Name:wb
Password: (my fatcow password)(not my database password)
Table Prefix:jal
Install Tables (box is checked)

You need to put in you DB Username and password ...

cheers

Klaus

[dsavage]

Hi Klaus,

I tried that earlier and it did not work.  I tried again today - did not work.  Checked to make sure I'm using the correct DB password (changed it and used the new one) - did not work.  Got the exact same error message.

I sent an email to fatcow support last now, to confirm that my wb files and the database are on the same server.  That's the only other thing I can thing of that might be wrong.  Haven't heard back from them yet.

Any other ideas on your end?

deb

[erpe]

Please enter your MySQL database server details below...
Host Name: localhost
Username: (my fatcow username)(not my database username)
Database Name:wb
Password: (my fatcow password)(not my database password)
Table Prefix:jal
Install Tables (box is checked)

again this is needed:
Please enter your MySQL database server details below...
Host Name: localhost (works in most cases but not at all, depends on your hoster)
Username: your database user_name
Database Name:your database name (don't think this is wb, but depends on your hoster)
Password: your database password
Table Prefix:j al
Install Tables (box is checked)

rgds


erpe

[kweitzel]

Error: Database host name, username and/or password incorrect. MySQL Error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

This error means, that the local connection is not allowed. Check if the DB User is allowed to use the local connection. With MySQL you can define if a user is allowed to connect from only 1 machine (e.g. username@localhost) or any machine (e.g. username@*).

cheers

Klaus

[dsavage]

Thanks, everyone, for the suggestions.  I found out that the database is on a different server from the wb files.  Once I had the correct server name for the database and used that instead of "localhost" (as well as the username and password for the database instead of the username and password for my general fatcow account) the installation worked smoothly.

Thanks again!

deb