SQL Connect Error

[ataylor]

Good morning.

I have created a monster it appears.

I have a Godaddy Linux shared hosting that last week was running your Easy PHP Calendar v6. I had MySql configured and working on PHP version 4.4.9 without any issues.

I requested that Godaddy upgrade to a newer version of PHP so I could run Easy PHP Calendar v7. I now have PHP v5.3.6. The MySQL version is 5.0 (as well as last week for version 6).

Having upgraded PHP version 6 was no longer valid so I removed the calendar folder and removed the MySQL calendar database planning a clean install of Easy PHP Calendar v7.

I then ran your test script and got the following: PHP Version Passed [ Version 5.3.6 ]

Then I ran the “Click Here to run the ionCube loader test script” which ran and installed successfully.

I purchased yesterday May 16, 2012 Easy PHP Calendar v7.0.05.

Easy PHP Calendar –
Registration date: 05/16/2012
License Type: Version 7

Uploaded files via FileZilla to my site using binary into folder calendar. Created the MySQL database.

Now come heck or high water I keep getting the following error when I attempt the following install:
http://www.mywebsite.org/calendar/install/index.php

SQL CONNECTION ERROR! Please start the installer again.
Reported error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

As far as I know I have tried many combination of the following with no success. I tried the user name with and without the IP address, the name.db with and without the 7 digit number
name.db.1234567.hostedresource.com
Server: name.db.1234567.hostedresource.com
User: username@dottedIPaddress


I did not have this difficulty last week when I installed Easy PHP Calendar v6 and created the MySQL database and user. So I really have no idea what I did to break it.

I only have 6 days for a refund so the clock is ticking. I hope this can be resolved because I do like what I have seen at least from the demo and what little I used v6 last week.


Have a great day.

Thank you.
Art Taylor
Tallahassee, Florida

[ataylor]

P.S. I am using localhost for the "Host Name"

[ve9gra]

From your hosting control panel, use the database management tool (usually phpMyAdmin) to confirm the username and the database name. Often they will be prefixed by your account name. And 99% of the time, the database server's hostname is "localhost".

[ataylor]

Once again, ve9gra, for your quick response. Just as I posted I thought I would try a different Host Name instead of "localhost" and it worked. GoDaddy needs -
?????cal.db.1234567.hostedresource.com be used (????? is my calendar name and their generated 7 digit number) for the Host Name.

Yay! So I can now connect to my MySQL calendar database. I hope this may help anyone else that is using GoDaddy hosting.

So now I just have to come up to speed on intergrating into my web site.

Thanks again.
--------
Art