Help - Search - Members - Calendar
Full Version: Can't connect to local MySQL server through socket
Movable Type Community Forum > Installing and Upgrading > Databases
SimonDorfman.com
After configuring and installing movable type 2.6.4, i open mt-load.cgi in my browser and see the following:


Loading initial data into system...

An error occurred while loading data:

Connection error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)



Anyone know why i'm getting this error?

I followed the instructions for MySQL databases. I created my database and user/password using my webhost's control panel. There is no mysql.sock file in the /tmp/ directory. There IS a mysql.sock file in the /var/lib/ directory.

Thanks very much for any advice.
bmk
Try adding the DBHost line in mt.cfg. That should take care of it.
SimonDorfman.com
Thanks. I actually needed to add:

DBSocket /var/lib/mysql/mysql.sock

It worked now. Thanks again.
GeneR
QUOTE (bmk @ May 30 2003, 12:45 PM)
Try adding the <a href="http://www.movabletype.org/docs/mtinstall.html#configuration">DBHost</a> line in mt.cfg.  That should take care of it.

Hi bmk,

Thanks for all your help so far. This is a mysql question.

I seem to be running into the same connection issue that Simon was. I added DBHost to the mt.cfg file however, I really do not know what the path would be for that particular field.

My current account with my server is like so:

web5.my-ISP-linux-server.com

but my mysql databases is on on:

mysql4.my-ISP-linux-server.com

So, I really don't know what I am supposed to enter. Would you mind helping me figure this out? Thanks!

Gene
bmk
I would try
DBHost mysql4.my-ISP-linux-server.com
GeneR
QUOTE (bmk @ Jun 10 2003, 07:11 PM)
I would try
DBHost mysql4.my-ISP-linux-server.com

Wow. That helped. On to the next level (I guess) biggrin.gif

I now have a log in page. I put in:
Username: Melody
Password: Nelson

Unfortunately, I just end up coming back to the same page. (huh.gif)

I have my CGIPath at: CGIPath http://www.mydomain.com/cgi-bin/mt/

So, am I missing something here? I'm going to see if I can also find a thread in the meantime. Thanks, bmk! biggrin.gif
bmk
Did you already run mt-check and mt-load?
GeneR
QUOTE (bmk @ Jun 10 2003, 07:35 PM)
Did you already run mt-check and mt-load?

Dang. I didn't think mt-load applied to me (for some odd reason biggrin.gif) and so I deleted it. I'll reload it and see how it runs.

...
Okay, I'm back and I reloaded mt-load.cgi, ran it and got:

QUOTE
500 Internal Server Error - Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@mydomain.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.27 Server at mydomain.net Port 80


And so I checked my webmaster email address and no email reports.

Hmmm.

...

Okay, I'm certifiably stupid. I forgot to CHMOD my mt-load.cgi. Just set it back to 755 and it seems to be loading fine. Got this:

QUOTE
Loading initial data into system...
Loading database schema...

    Loading weblog...
    Loading author...
    Loading permissions...
    Loading templates...
    Mapping templates to blog archive types...
        Mapping template ID '11' to 'Daily'
        Mapping template ID '11' to 'Weekly'
        Mapping template ID '11' to 'Monthly'
        Mapping template ID '12' to 'Category'
        Mapping template ID '13' to 'Individual'

Done loading initial data! All went well.

VERY IMPORTANT NOTE:

Now that you have run mt-load.cgi, you will never need to run it
again. You should now delete mt-load.cgi from your webserver.

FAILURE TO DELETE mt-load.cgi INTRODUCES A MAJOR SECURITY RISK.


So, I guess it's deletion time now for mt-load.cgi?

Additionally, am I correct to use CGIPath as: CGIPath http://www.mydomain.com/cgi-bin/mt/ since I am using /mt as my folder in the cgi-bin?

Thanks, bmk!
bmk
yes, correct. smile.gif
GeneR
Hi bmk and everyone! biggrin.gif

I'm thinking that other people will have the problems I had afterwards so I hope you don't mind if I post my other problems with icons and the solutions that you and others gave me, okay? Thanks!

Gene

After the problem with mt-static was taken care of, I ended up on the Login page. But I found that I had an icon issue (as in: they weren't loading).

So that took me to this thread:
Icons thread in Installation Forum.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.