Movable Type Community Forum

hank1

Apr 12 2008, 11:49 AM

This is the error:

CODE

Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /hsphere/local/home/henry/ideasillustrated.semperfigraphics.com/cgi-bin/mt/extlib/Data/ObjectDriver/Driver/BaseCache.pm line 234 at /hsphere/local/home/henry/ideasillustrated.semperfigraphics.com/cgi-bin/mt/extlib/Data/ObjectDriver/Driver/BaseCache.pm line 234

How can I correct this?

And where? At MySQL database management with my hosting company? There I see this:

CODE

Host Name     mysql1.hostica.com (208.179.130.30)
Port number     3306
Database name     henry_reardon  Click to remove
phpMyAdmin     Built in phpMyAdmin control panel
you will need a properly configured dba user to log in (just add user with dba role if you don't have one)

Thank you for your attention,

Bob

OtherNiceMan

Apr 12 2008, 12:12 PM

Have you filled the database information in your mt-config.cgi file?

hank1

Apr 12 2008, 12:44 PM

QUOTE (OtherNiceMan @ Apr 12 2008, 08:12 PM)

Have you filled the database information in your mt-config.cgi file?

Thank you for the swift reply.

By database information do you mean

QUOTE

henry_reardon

and/or

QUOTE

mysql1.hostica.com

?

Should I have done that before sending my mt-config.cgi file over from the MT download on my desktop to my domain? And how do you do that, fill in the information into a .cgi file?

Thanks again,

Bob

P.S. I did all this before it was easy and had a MT blog for years. Switched hosting and lost it all. Now that it seems so simple I've forgotten all that. Dying to get back to MT. Got something on Word Press but it's just not the same.

OtherNiceMan

Apr 12 2008, 01:13 PM

Normally I edit mt-config.cgi locally in a text editor and upload it via ftp back to my host.

hank1

Apr 12 2008, 01:16 PM

QUOTE (OtherNiceMan @ Apr 12 2008, 09:13 PM)

Normally I edit mt-config.cgi locally in a text editor and upload it via ftp back to my host.

OK. Thank you very much.

I'll look up just what must be edited there and I bet it'll go.

Bob

hank1

Apr 12 2008, 03:09 PM

QUOTE (OtherNiceMan @ Apr 12 2008, 09:13 PM)

Normally I edit mt-config.cgi locally in a text editor and upload it via ftp back to my host.

I'm sorry I truly have forgotten how to edit a .cgi file. What precisely is the proceedure?

Here I have the file that looks nothing like a text file [img]http://tracyfineart.com/misc/images/cgi_file.jpg[/img] and using Notepad I put in

CODE

CGIPath http://ideasillustrated.semperfigraphics.com/mt/

StaticWebPath http://ideasillustrated.semperfigraphics.com/mt/mt-static

and save it as mt-config.cgi but of course it saves as a text file.

Also, is this the right information to put in the mt-config.cgi file anyway?

Sorry,

Bob

OtherNiceMan

Apr 13 2008, 05:31 AM

You need to rename it mt-config.cgi, it is just a text file with settings in, nothing special.

If you then open it up in notepad you should see the following:

CODE

##          Movable Type configuration file                   ##
##                                                            ##
## This file defines system-wide settings for Movable Type    ##
## In total, there are over a hundred options, but only those ##
## critical for everyone are listed below.                    ##
##                                                            ##
## Information on all others can be found at:                 ##
## config

################################################################
##################### REQUIRED SETTINGS ########################
################################################################

# The CGIPath is the URL to your Movable Type directory
CGIPath    http://www.example.com/cgi-bin/mt/

# The StaticWebPath is the URL to your mt-static directory
# Note: Check the installation documentation to find out
# whether this is required for your environment.  If it is not,
# simply remove it or comment out the line by prepending a "#".
StaticWebPath    http://www.example.com/mt-static

#================ DATABASE SETTINGS ==================
#   REMOVE all sections below that refer to databases
#   other than the one you will be using.

##### MYSQL #####
ObjectDriver DBI::mysql
Database DATABASE_NAME
DBUser DATABASE_USERNAME
DBPassword DATABASE_PASSWORD
DBHost localhost

##### POSTGRESQL #####
ObjectDriver DBI::postgres
Database DATABASE_NAME
DBUser DATABASE_USERNAME
DBPassword DATABASE_PASSWORD
DBHost localhost

##### SQLITE #####
ObjectDriver DBI::sqlite
Database /path/to/sqlite/database/file

Set CGIPath and StaticWebPath to match you installation.
Remove all the sections for the databases you do not use (so in you case delete everything from ##### POSTGRESQL ##### to the end.
Add you database settings to the MYSQL section see below (I don't know what your database username or password is

CODE

##### MYSQL #####
ObjectDriver DBI::mysql
Database henry_reardon
DBUser DATABASE_USERNAME
DBPassword DATABASE_PASSWORD
DBHost mysql1.hostica.com

hank1

Apr 14 2008, 08:50 AM

QUOTE (OtherNiceMan @ Apr 13 2008, 01:31 PM)

You need to rename it mt-config.cgi, it is just a text file with settings in, nothing special.

If you then open it up in notepad you should see the following:

CODE

##          Movable Type configuration file                   ##
##                                                            ##
## This file defines system-wide settings for Movable Type    ##
## In total, there are over a hundred options, but only those ##
## critical for everyone are listed below.                    ##
##                                                            ##
## Information on all others can be found at:                 ##
## config

################################################################
##################### REQUIRED SETTINGS ########################
################################################################

# The CGIPath is the URL to your Movable Type directory
CGIPath    http://www.example.com/cgi-bin/mt/

# The StaticWebPath is the URL to your mt-static directory
# Note: Check the installation documentation to find out
# whether this is required for your environment.  If it is not,
# simply remove it or comment out the line by prepending a "#".
StaticWebPath    http://www.example.com/mt-static

#================ DATABASE SETTINGS ==================
#   REMOVE all sections below that refer to databases
#   other than the one you will be using.

##### MYSQL #####
ObjectDriver DBI::mysql
Database DATABASE_NAME
DBUser DATABASE_USERNAME
DBPassword DATABASE_PASSWORD
DBHost localhost

##### POSTGRESQL #####
ObjectDriver DBI::postgres
Database DATABASE_NAME
DBUser DATABASE_USERNAME
DBPassword DATABASE_PASSWORD
DBHost localhost

##### SQLITE #####
ObjectDriver DBI::sqlite
Database /path/to/sqlite/database/file

Set CGIPath and StaticWebPath to match you installation.
Remove all the sections for the databases you do not use (so in you case delete everything from ##### POSTGRESQL ##### to the end.
Add you database settings to the MYSQL section see below (I don't know what your database username or password is

CODE

##### MYSQL #####
ObjectDriver DBI::mysql
Database henry_reardon
DBUser DATABASE_USERNAME
DBPassword DATABASE_PASSWORD
DBHost mysql1.hostica.com

Thank you very much. I'm on my way now to follow your detailed directions. Will let you know how it goes.

Bob

hank1

Apr 14 2008, 09:33 AM

Well, it went badly. Here is what I've done and the errors I get.

For mt-config.cgi I've written this in Notepad:

CODE

CGIPath http://www.semperfigraphics.com/cgi-bin/mt/

StaticWebPath http://www.semperfigrapics.com/mt-static

ObjectDriver DBI::mysql
Database henry_reardon
DBUser henry_bob
DBPassword steelman
DBHost mysql1.hostica.com

(I don't mind you knowing my Password. It might be part of the problem and I can change it in a second. Also, I was told by my hosting company:
When setting up Movable Type, be sure to specify a MySQL server of mysql1.hostica.com. Based on the error message encountered, it appears that localhost may have been specified. This is why I tried for my DBHost mysql1.hostica.com. First I tried localhost and got the same error.)

And this is the error I get when opening in a browser http://ideasillustrated.semperfigraphics.c...i-bin/mt/mt.cgi

CODE

An error occurred
Unsupported driver DBI::mysql1.hostica.com: syntax error at (eval 30) line 1, near "use DBI::mysql1."

OtherNiceMan

Apr 14 2008, 10:12 AM

The error message makes it look like you have the following line

ObjectDriver DBI::mysql1.hostica.com

rather than

ObjectDriver DBI::mysql

and I would change the password as soon as you can.