XF 2.1 New install on Godaddy MySql Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[TheGroove]

Hi All,

Looking forward to getting this installed but running into this issue. I tried to update through the installer and get this error and I tried manually updating the config.php and still get the error.

Here are my DB settings in Godaddy (screenshot), I am able to access just fine through phpmyadmin using these same credentials.

This is my config.php i've tried both the db name and fully qualified hostname, both give the same results.

config['db']['host'] = 'localhost';
$config['db']['port'] = 3306;
$config['db']['username'] = 'XenForo';
$config['db']['password'] = 'omitted';
$config['db']['dbname'] = 'XenForo';
$config['db']['socket'] = null;

$config['fullUnicode'] = true;

Additionally, I did run the test configuration before purchasing. Both php and MySql versions checked out. Any thoughts?

 

[Seeker-Smith]

Maybe take out this line
$config['db']['socket'] = null;

 

[duderuud]

Or change "null" to "3306" (default MySQL port)

 

[TheGroove]

Thanks for the quick reply guys, turns out I had to change 'localhost' to the fully qualified name. All is working now.

 

[TheGroove]

Just one more question about the installation routine, I'm about an hour and a quarter in so far and is showing progress but running extremely slow (currently importing template data for the last 45 minutes alone at just 35%) . For reference, on the same server I was able to install vB in about 10 minutes yesterday. Is this normal for XenForo?

 

[Seeker-Smith]

You using the CLI? It took me 4.5 hours with about 350,000 attachments. Very fast really.

 

[TheGroove]

You using the CLI? It took me 4.5 hours with about 350,000 attachments. Very fast really.

Just the installer from the /install directory in the web browser.

 

[Seeker-Smith]

The CLI does the install on the host computer. No data back and forth.

 

[TheGroove]

Not sure I follow, I uploaded all of the files to my server, then browsed to the install directory in my browser, then clicked install. Is that not all done on the server directly? Here are the instructions I'm using https://xenforo.com/xf2-docs/manual/install-upgrade/#installing-xenforo

 

[duderuud]

Installation time also depends on your available resources. How much memory, cores and especially what kind of disk/SSD do you have...

 

[Seeker-Smith]

You doing an import or install. Sorry the CLI is for imports.

 

[TheGroove]

This is a fresh install, not importing or anything else. At the rate it's going it appears that it will take several hours.

 

[Seeker-Smith]

That doesn't sound right. I did a test import (no attachments) 6,000 users, 20k threads and it only took about an hour. Somebody can probably advise better. I'm new the xenforo but used vb for 17 years.

 

[Paul B]

I have done hundreds of installations on tens of different hosts.

If it takes more than a couple of minutes then it's a badly configured/severely under-powered/over-provisioned server.

Get a new server/package/host.


As for the original issue, the host name was in the screenshot.



Not many hosts require anything other than localhost but it does come up occasionally.

 

[TheGroove]

I have done hundreds of installations on tens of different hosts.

If it takes more than a couple of minutes then it's a badly configured/severely under-powered/over-provisioned server.

Get a new server/package/host.


As for the original issue, the host name was in the screenshot.

View attachment 232573

Not many hosts require anything other than localhost but it does come up occasionally.

Okay, any recommendations for shared hosting? I'm also curious as to why vBulletin installed so quickly.

 

[Paul B]

In general, I haven't had many issues with GoDaddy.

Most of the installs I have done on their shared hosting packages were a few minutes.

Perhaps you've just been provisioned onto a very old/overloaded server?

See if they'll move you to another one - that can sometimes make a difference.

 

[TheGroove]

I know this is a little bit older but just wanted to share my experience here with Godaddy. Even after upgrading to a new more updated shared host I still had issues with the site timing out several times a day, page loads were slow and people were complaining.

This is a new board with relatively few users and posts. Godaddy support was terrible, always putting the blame on me and could never tell me why it was always having issues. So I moved to a VPS at knownhost and the difference is like night and day, I'm very happy with these guys.

I just don't know how anyone is successfully using a shared hosting solution with Godaddy, maybe getting lucky and not being on an overloaded host?

 

[Paul B]

maybe getting lucky and not being on an overloaded host?

That can definitely be a factor on cheap/shared hosting.

With my previous host I had terrible issues on one server and when I was moved to another it was fine.

 

[TheGroove]

That can definitely be a factor on cheap/shared hosting.

With my previous host I had terrible issues on one server and when I was moved to another it was fine.

I suspect that it's the server I'm on, this would've been my third upgrade with them in order to stop the site hangs from happening and I'm just drawing the line, for everything I had put into it the site should not be timing out several times a day. They lost my business. I'll still keep them around for domain management but that's it.