Migrating WPMS from apache to IIS7 causes Database Error

  • Resolved Josh Maxwell

    (@hornetok)


    12 years ago

    I have a large multisite installation hosted on XAMPP on an XP 2003 server and am trying to move it to a new Windows 2008 server with IIS7.

    I can successfully get fresh installs of WP up and running and can get multisite working perfectly. But, when I import my old WPMS MySQL database and change the DB_NAME in my wp-config.php file to have the old WPMS database instead of the new WPMS database, I’m hit with “Error establishing database connection”

    Here are my wp-config.php settings:

    // ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'migrated_WPMS_database');

/** MySQL database username */
define('DB_USER', 'wpms_user');

/** MySQL database password */
define('DB_PASSWORD', 'wpms_password');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

    I’ve double checked the username & password and even changed them several times to make sure they matched up. I’ve tried localhost, 127.0.0.1, and the IP address of my server itself for the DB_NAME. Nothing.

    Does anyone have any ideas or had this issue before?

Viewing 7 replies - 16 through 22 (of 22 total)
1 2
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years ago

    They didn’t happen to get a brain and tell you where the traffic was from past ‘you’ … I mean, my SysAdmin has often said ‘That mail form’s getting hammered.’

    Thread Starter Josh Maxwell

    (@hornetok)

    12 years ago

    Unfortunately, no. I guess it’s technically a “port scanner”, something on our server looking for a way out through an open port to do damage elsewhere/outside our network. But there’s no way to know for sure where on the site or from what directories it’s coming from.

    // UPDATE

    SUCCESS! (sort of)

    I was comparing my old wp_options table with the newly created one (from the fresh install) and “thought maybe these are different.” I backed up my old one and copied the new wp_options table over to the migrated_WPMS_database… voila! I can see the front page of my main site!

    I still can’t login from my.domain.com/wp-login.php or access the main site’s dashboard yet and I still see blank front page on my subsites, buuut, this tells me that there’s something missing from my old wp_X_options tables for each blog that is included in newer versions of WPMS’ tables.

    There’s light at the end of the tunnel … I know it now, I just can’t see it yet 😀

    Thread Starter Josh Maxwell

    (@hornetok)

    12 years ago

    Ok, more headway… the whole front-end being blank thing was totally my fault. I hadn’t copied the themes folder over yet… So the database was looking for themes & stylesheets that weren’t there. Gah!

    Moving on from my stupidity…

    Still working on the login page’s redirect loop: I’m wondering if there’s a connection here with why I’m unable to access the Network Admin dashboard? Any ideas?

    // UPDATE

    On a roll now! I remembered I had backed up my old wp_blog_versions so I could try the fresh install’s version of it: I switched it back to the old one, cleared the cache & cookies and I’m back up!

    I’m able to login without issue to my main site & the network dashboard is accessible!

    The very last issue I have now is getting the media files to work properly again.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years ago

    Media files. Make sure your .htaccess is set up right.

    Thread Starter Josh Maxwell

    (@hornetok)

    12 years ago

    My install is running off of IIS7. And, I’m using the default code created by WordPress for my web.config. I’m having trouble finding help on getting the web.config file setup to see the old files properly…

    The weird part is when I look at my Media Library, it’s displaying some files’ thumbnails. But, it seems the image files are the one’s having problems because some of my PDFs and docs are actually linked properly … ???

    ————–

    On another note: I had to go back and do another fresh install, this time via Microsoft’s Web Web Platform Installer, because I couldn’t find the IUSR account to add it to the folder’s permissions.

    So, for future reference for anyone who finds this thread:
    The best way to get the proper permissions on your folders/files while using IIS7 is to install WordPress via Microsoft Web Platform Installer.

    Thread Starter Josh Maxwell

    (@hornetok)

    12 years ago

    Well, the original “Database Issue” has been resolved, so I’m going to mark as such and create a new post for my Media Library issues.

    Thanks so much Ipstenu & Andrea_r for your help!

    Thread Starter Josh Maxwell

    (@hornetok)

    12 years ago

    In case anyone was wondering or wanted to see the continuation of this thread: Media Library won’t recognize SOME files after move.

Viewing 7 replies - 16 through 22 (of 22 total)
1 2
  • The topic ‘Migrating WPMS from apache to IIS7 causes Database Error’ is closed to new replies.