YAIE (Yet Another Install Error)

  • Here’s the relevant section of my wp-config.php file:
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘robcarr2’); // The name of the database
    define(‘DB_USER’, ‘robcarr2’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘*********’); // …and password
    define(‘DB_HOST’, ‘https://io2.your-site.com’); // 99% chance you won’t need to change this value
    // Change the prefix if you want to have multiple blogs in a single database.
    $table_prefix = ‘wp_’; // example: ‘wp_’ or ‘b2’ or ‘mylogin_’
    And, when I go to the install.php file, I get:
    Error establishing a database connection! This probably means that the connection information in your wp-config.php file is incorrect. Double check it and try again.
    etc.
    I can go to https://io2.your-site.com in my browser and, entering the user name and password, find that there is a database with the proper name.
    I’ve screwed something up, but I don’t know what. Any ideas?
    Thanks in advance,
    Rob

Viewing 7 replies - 1 through 7 (of 7 total)

  • The host line looks wrong to me.
    Are you using a cpanel ?

    Thread Starter RobCarr

    (@robcarr)

    >The host line looks wrong to me.
    The host is not on the same server as the web site – for security reasons according to Your-Site.
    “Your database is not on the same server as your web site; we have a dedicated MySQL server. You’ll want to set your CGI, PHP and ASP scripts to connect to this
    server.”
    >Are you using a cpanel ?
    I don’t know.
    https://io2.your-site.com is running phpMyAdmin 2.4.0-rc2.
    I looked up cpanel – it doesn’t look like it’s being used, but I may be wrong.
    Rob

    In that case, could the db_name be wrong ?
    Most db_names have some sort of prefix.. does your host give you any sort of ‘connection string’ ?

    Thread Starter RobCarr

    (@robcarr)

    >In that case, could the db_name be wrong ?
    Copied it right out of the e-mail, going to the web site confirms it.
    I’m not sure what the following is telling me:
    “You can only access your database from our servers using the username and password above. On the europa server, we have the command line mysql client available in /usr/local/bin that can be used via a ssh2 session.”
    Rob

    Thread Starter RobCarr

    (@robcarr)

    I found the solution.
    If you can’t get the thing running, one apparent trick is to find someone with a WordPress blog that is hosted by the folks hosting your blog.
    I found out that the line I had messed up was:
    define(‘DB_HOST’, ‘https://io2.your-site.com’); // 99% chance you won’t need to change this value
    It should have been
    define(‘DB_HOST’, ‘io2.your-site.com’); // 99% chance you won’t need to change this value
    Thanks to podz for helping me chase down the source of the problem, and for James Landrith for telling me the correct form. His blog is at:
    https://www.jameslandrith.com/index.php
    Mine is at https://unspace.net/wordpress/index.php

    Thread Starter RobCarr

    (@robcarr)

    I forgot to mention:
    Yeah, it’s not in the main directory. I gotta figure out how to fix that one of these days….

    Thanks for posting the solution !

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘YAIE (Yet Another Install Error)’ is closed to new replies.