Rando

Can't connect to mysql db

Vote 0 Votes

I have locally a wpress blog running without troubles.
I was just testing the movable software but as last year I couldn't make it work.

I use xampp, have the perl modules.
hostname is correct : localhost
user and psw also

Can log without problems in to the database I created for MT using cmd shell:
mysql -u USERNAME -p -h DATABASE_SERVER_HOSTNAME DATABASE_NAME

I put this in the config wizard:
Static web path
http://localhost/s/mt/mt-static/
Static file path
c:/xampp/htdocs/s/mt/mt-static/

I received this as answer:
Requirements Check
All required Perl modules were found. You are ready to proceed with the installation of Movable Type.
Some optional Perl modules could not be found. Display list of optional modul

Then on the next page I inserted the correct login info and database info (as used in the shell)

This is what I receive when I test the connection:

An error occurred while attempting to connect to the database. Check the settings and try again. Details
Connection error: Can't connect to MySQL server on 'localhost' (10061) at C:\xampp\cgi-bin\mt\extlib/Data/ObjectDriver/Driver/BaseCache.pm line 320 at C:\xampp\cgi-bin\mt\extlib/Data/ObjectDriver/Driver/BaseCache.pm line 320 at C:\xampp\cgi-bin\mt\extlib/Data/ObjectDriver/Driver/BaseCache.pm line 320

-----------------

please see also the slashes (first left slashes then right slashes).
Can that be the problem?

ps:
mysql + apache is running.
--
I changed the first line in every cgi file to:
#!c:/xampp/perl/bin/perl.exe -w
in order to let work perl

Reported on Movable Type 5

5 Replies

| Add a Reply
  • Hi Rando,

    As the error message suggests there must be something wrong with the mysql database connection.

    So this doesn't seem to have anything to do with movable type.

    Make sure to check the "port" and "socket" options in the [mysqld] section.

    Kind Regards,
    Mihai Bocsaru

    ----------------------------------
    Daily Movable Type Consultant

    Web Development
    Movable Type Consulting
    Six Apart Partner

    http://www.pro-it-service.com/
    ----------------------------------

    Movable Type Demo
    http://www.movabletypedemo.org/
    ----------------------------------

    Open Melody Demo
    http://www.openmelodydemo.org/

  • if this is a problem of mysql I would not be enable to login in wpress blog.

    I'm sure that my login info is correct.

    I suppose movable its too difficult to install for me as I had the same problems a year ago on another webserver.

    Do you know how I can resolve the slash problem?
    C:\xampp\cgi-bin\mt\extlib/Data/ObjectDriver/Driver/BaseCache.pm line
    (to have all "/" slashes)
    Is there a way to indicate in movable that the slashes must be "/"?

  • Hello Mihai,

    Are you still there?

    I'm still trying to connect to the mysql db.
    I checked my perl installation:

    Movable Type System Check Successful
    You're ready to go! Your server has all of the required modules installed; you do not need to perform any additional module installations. Continue with the installation instructions.

    Perl is ok, isn't it?
    Is movable compatible with the latest activestate perl version?
    If I can connect to the mysql movable db, why can't I connect to the db using the browser?

  • found it on the web :)

    Just had to uncomment this line in my.ini
    #bind-address="127.0.0.1"


  • Well done Rando!

    That wasn't specific to movable type so I couldn't help much on it with the anyway too little spare time that I rarely have :)

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

1774 6167

Last Topic: Template modules by Zielun on Feb 16, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1434 5088

Last Topic: Maintenance announcement by Nick on Feb 17, 2012

695 2912

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

174 740

Last Topic: Captcha images rendering slowly by ScottM on Feb 12, 2012

190 568

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012