New to the community? Start here

Problem install

Multi-DB is compatible with WordPress Mu 2.6.1???

I’m install the plugin in wpmu 2.6.1 , but left the following error: “No WPMU site defined on this host”

Thu, 11 Sep 2008 0:42:03
  • nickd32
    • The Incredible Code Injector

    I have installed multi-db and run the move-blogs script. Done.

    Blogs have been moved appropriately to their new databases.

    Still getting the “No WPMU site defined on this host” error! I’m guessing the culprit has to be in the db-config.php file, right?

    In my case (shared hosting):

    1. Each database has its own server and ip address. So I’m not sure how to define the add_dc_ip setting appropriately. Should I:

    a. Comment out all the add_dc_ip stuff?

    b. Add a line for each of my 18 new databases (16 + 1 global + 1 vip)

    add_dc_ip(‘123.123.123.’, ‘dc1’:wink:;

    add_dc_ip(‘123.123.124.’, ‘dc1’:wink:;

    add_dc_ip(‘123.123.125.’, ‘dc1’:wink:;

    2. I don’t have a LAN_HOST or local IP address to use. It’s all remote. For the LAN_HOST field, should I:

    a. Leave it blank

    b. Copy the regular (remote) HOST IP Address to this field also

    c. Put 127.0.0.1, as I read in another post

  • ron_r (aka Mr. Andrea)
    • Design Lord, Child of Thor

    You only need one ad_dc_ip unless the database servers are each on a separate network. dc_ip => data center IP.

    Let’s say your databases were on:

    12.34.56.78

    12.34.56.79

    12.34.56.70

    12.34.56.92

    etc.

    then you would add_dc_ip(‘12.34.56.’,’dc1′:wink:;

    If you had

    12.34.56.78

    12.34.56.79

    12.34.57.70

    12.34.57.92

    etc.

    then you would

    add_dc_ip(‘12.34.56.’,’dc1′:wink:;

    add_dc_ip(‘12.34.57.’,’dc2′:wink:;

    Then when adding databases below you would use the appropriate dcX

  • nickd32
    • The Incredible Code Injector

    Got it. In my case, I can’t get the actual IP of my database. I only get a host name, like:

    db12345.perfora.net

    So, I defined a line in db-config.php for each of my servers:

    add_dc_ip(‘db1600.perfora.net:3306’, ‘dc0’:wink:; //(where 3306 is the default port)

    add_dc_ip(‘db1601.perfora.net:3306’, ‘dc1’:wink:;

    add_dc_ip(‘db1602.perfora.net:3306’, ‘dc2’:wink:;

    …

    Then I updated these lines:

    add_db_server(‘0’, ‘dc0′, 1, 1,’db1600.perfora.net:3306’,”, ‘EDITED’, ‘EDITED’, ‘EDITED’:wink:;

    add_db_server(‘1’, ‘dc1′, 1, 1,’db1601.perfora.net:3306’,”, ‘EDITED’, ‘EDITED’, ‘EDITED’:wink:;

    add_db_server(‘2’, ‘dc2′, 1, 1,’db1602.perfora.net:3306’,”, ‘EDITED’, ‘EDITED’, ‘EDITED’:wink:;

    …

    However, I still get the dreaded “No WPMU site defined on this host.” I’m stuck. Where do I go from here?

  • andrea_r
    • The Incredible Code Injector

    But thsoe areas looking for IP need IP address. Not the host name. This is what causes MU to come back with an error message, because it can’t find the db.

    If you can’t get the IP addresses, the only other option I can see is to strip out all the code in the plugin that looks for that info.