I've just set up a new blog to replace a previous MT blog with another host. This time I've gone for MySQL which I haven't used before. It doesn't seem to initialize the databse though. Here's where I've got to:

Before you can begin blogging we need to complete your installation by initializing your database

I click on Finish Install, which gets me to:

Initializing database...

Starting installation...

And then nothing. No error messages, nothing. Each time I run mt.cgi it goes through the same process. Any help would be greatly appreciated.

Doh! It turned out to be a typo in the static files path.

I am having the *exact* same problem. After I click the button to initilize the db I get the next screen and then it just sites there...like forever.

Is thins something that usually takes a while? Everything in the mt-check.cgi file looked great as well.

What could possibly be going on causing this and is there soemthing I should check to see if it's not set right? I did check the static path and that's correct for sure. Also, all .cgi files are set to 755 as well.

Please help!

The most common reason for the installation to stall is due to problems with the mt-static directory. The following Knowledge Base article explains how to make sure Movable Type can find the static files: http://www.sixapart.com/movabletype/kb/ins...s_styles_a.html

I'm having the same issues as well... Every reply to this topic I've seen indicate it's a static web path issue but my static web path is correct, the permissions etc match another totally working install I'm looking after and the mt-upgrade.cgi?__mode=install page appears to be sourcing its images from the static web path... (http://www.mydomain.org/mt-static/images/topnav-logo.gif)

Could there be any other issues that would cause this?

I should note that the DNS is not directed to the server which is hosting this site until I have it ready to go, I'm wanting a seamless transition - I'm looking at the new host by having added the ip address and password to the HOSTS file in WINDOWS/SYSTEM32/DRIVERS/ETC

Hope that makes sense...

If http://www.mydomain.org/ does not resolve, then you'll need to use a URL that does in both CGIPath and StaticWebPath in your mt-config.cgi.

Once your IP is assigned or you have a working temporary URL, then you should be able to complete the installation.

After your domain resolves, you'll need to make a few updates that are covered in this Knowledge Base article:
http://www.sixapart.com/movabletype/kb/con...ing_url_fo.html

Ok, now I feel like a first class idiot -

The reason the installation hung WAS an MT static issue... I had uploaded the js files in BINARY. *hangs head in shame*

SO.... I ran the mt-install.cgi again and this time it looked good... but each time it got to a bit of the database it had to initialize it gave me an error which reads

xxxxxxx@localhost is denied access to the database - [enters idiot territory again] so I hit page refresh over each error and got to the end where it told me that my database had been initialized successfully... but ...

When I go to the login page I can't log in... so clearly the default login isn't in the database, and I suspect nothing else is either...

How do I undo the mess and start again? If I run the mt-install.cgi I just get directed back to the login page.

Is the permissions error connected to the fact the DNS information hasn't yet been changed over to the new server?

*** Only do the next bit if you have a brand new installation. If you were upgrading, you should restore your database back up and start the upgrade again. ***

To clean up the partial installation you have, you'll want to use something like phpMyAdmin and DROP all of the tables in the database (not the database itself though). Then double check that your login information for the database is right in your mt-config.cgi.

This Knowledge Base article talks about the error you're seeing:
http://www.sixapart.com/movabletype/kb/ins...ction_erro.html

Thanks Lisa, I've dropped the db successfully (which means my password is correct - i needed it to login to phpmyadmin), and I've re uploaded the mt-config.cgi which has the correct details and password and which was uploaded in ASCII - however, there was still no change... it's still giving me the error.

Error during installation: Access denied for user: 'xxxxxxxx@localhost' to database 'xxxxxxx' at lib/MT/Upgrade.pm line 1076.

I've also emailed my host incase there is an error on permissions for that user... is there anything else you can suggest? (Thanks for all this help by the way.. it's brilliant)

I would double check and make sure that you should be using localhost and not a something.example.com as the DBHost. Some web hosts put the database servers on a different box than the one that runs the web server.

Also, the user must have full permissions to the table. Sometimes that's called "DBA" permissions and other times all of the types of commands are listed out. Either way, make sure that the user has all of the permissions you can give it.

Thanks Lisa, Yep localhost was the correct setting...

In the end, to get the site back up I opted to use Berkley. What's weird is that my host has my installation on it and no issues with it at all... they were taking so long to try and figure out why one worked and the other didn't I gave up!!!

We'll just do lots of backups..

Really appreciated your help.

I observed the same symptoms during an upgrade from 3.2 to 3.34. In my case I was on a new machine with a new load of FireFox and I'd recently installed the noscript plug-in (which is a great plug-in, btw). Anyway, I *hadn't allowed javascript from my own site!* Duh.

Dear Deeleea and other folks,

I would strongly advice you to choose backing your platform on mySQL

When you meet this behaviour think first about the /mt-static/ folder


The possible causes are:

1) you didn't upload the files in binary format (maybe you've forgot to switch from ASCII to BINARY after you've installed the other mt folders source files);

2) your FTP tool disconnected and certain files are not uploaded


Your solution is as simple as uploading the /mt-static/ folder form scratch making sure you do it in BINARY format. If the problem doesn't go away, just check if your FTP client disconnected along the way (unfortunately I've seen certain servers disconnecting very often).


Good luck,
Mihai Bocsaru

Hi,

I'm having the same problem with a local installation on Mac OS X. I'm also using MAMP and have got the database created with no tables. I've got through the rest of the installation but when I get to the configuration screen the styles and images aren't applied and when I click on "finish" it just hangs on "initializing the database".

Because I'm installing it locally I haven't needed to upload any files so I presume that in my mt-static directory the images should automatically be in binary and all other files should be in ascii? If not how do you check?

I have placed my mt-static directory outside of the cgi-bin and in the root of my web server and double checked the path to the mt-static directory in the mt-config.cgi file:

CGIPath http://localhost:8888/cgi-bin/mt/
StaticWebPath http://localhost:8888/mt-static

I've also placed in a line to point MT to my mysql.sock:

DBSocket/Applications/MAMP/tmp/mysql/mysql.sock

Also I have noticed that the page loads as mt-upgrade.cgi:

http://localhost:8888/cgi-bin/mt/mt-upgrade.cgi

Is this where it is meant to be redirected?

Any suggestions?

Thanks

slip

k, so I've got it working finally. Thanks for the flood of helpful suggestions people... (cough cough).

My mistake was actually quite a foolish one to make and seems quite obvious now but then again they always do after you know what the problem is.

I had placed the "mt-static" directory in the root of the MAMP server instead of the root of the web pages directory "htdocs". Although the Static path was correctly entered in the config file the placement of the folder was in the wrong place. It's full local location is:

Applications/MAMP/htdocs/mt-static

With the CGI and Static paths in the config file remaining the same:

CGIPath http://localhost:8888/cgi-bin/mt/
StaticWebPath http://localhost:8888/mt-static


So by moving "mt-static" into "htdocs" and then running "mt.cgi" again the styling on the page showed up and the "finished" but redirected me correctly, built the database, and didn't hang.

Just thought I'd mention the solution in case anyone else is having the same problem.