• I am having trouble installing wp.
    I am running php4.3.1, mysql 4.0.15, apache 2.0.44 on redhat8.
    The top of my b2config.php looks like this:
    ————————————————————
    $siteurl = ‘http://mysite.com/wp’; // Double check this, it’s very important.
    $blogfilename = ‘index.php’;
    $blogname = “Learning Center”;
    $blogdescription = “Learning Center Description”;
    // Your email (obvious eh?)
    $admin_email = ‘wp-admin@mysite.com’;
    // ** MySQL settings **
    define(‘DB_NAME’, ‘mc’); // The name of the database
    define(‘DB_USER’, ‘mcadmin’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘xxx’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    ————————————————————
    The bottom of my b2config.php looks like this:
    ————————————————————
    $relpath = ”;
    $url = explode(‘/’, $siteurl);
    for ($i = 3; $i < count($url); $i++) {
    $relpath .= ‘/’. $url[$i];
    }
    //$abspath = getenv(‘DOCUMENT_ROOT’) . $relpath . ‘/’;
    //$abspath = “/home/wp” . $relpath . ‘/’;
    $abspath = “/home/wp/”;
    $b2inc = “/$b2inc”;
    $pathserver = &$siteurl;
    require_once($abspath.$b2inc.’/wp-db.php’);
    ————————————————————
    Clearly, I already hit the same errors others have already gotten. The problem is, that I have a blank page for ‘/wp/wp-admin/wp-install.php’. Here is the HTML source:
    ————————————————————
    <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN”>
    <HTML><HEAD>
    <META http-equiv=Content-Type content=”text/html; charset=iso-8859-1″></head>
    <BODY>
    ————————————————————
    What’s the fix for this? I know the mysql account and password are correct because if I type this from the command line:
    ————————————————————
    ./mysql -p –user=mcadmin mc
    ————————————————————
    I can access the database (after typing in the correct password).
    For fun, here are the permissions for the database account (which is WAY too much, and I would like to reduce them significantly–so what should I revoke?):
    ————————————————————
    mysql> select * from mysql.user;
    +——————+———+——————+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+———-+————+————-+————–+—————+————-+—————–+
    | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections |
    +——————+———+——————+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+———-+————+————-+————–+—————+————-+—————–+
    | localhost | root | [snip] | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |
    | xxx.mysite.com | root | [snip] | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |
    | localhost | mcadmin | [snip] | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |
    +——————+———+——————+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+———-+————+————-+————–+—————+————-+—————–+
    3 rows in set (0.00 sec)
    ————————————————————
    Help is much appreciated.
    -=John
    [edit by allusion: removed password hashes.]

Viewing 4 replies - 1 through 4 (of 4 total)
  • The only mysql user privs you should need are Select_priv, Insert_priv, Update_priv, Delete_priv, and Create_priv.
    I would double-check your $abspath and $b2inc values… You might want to consider starting with the 0.72 release candidate. It has a friendlier initial setup.

    Thread Starter squishy

    (@squishy)

    Thanks for helping out, dougal.
    I downloaded 0.72 and installed it. I get the same results for /wp/wp-admin/wp-install.php as before:
    ————————————————————
    <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN”>
    <HTML><HEAD>
    <META http-equiv=Content-Type content=”text/html; charset=iso-8859-1″></HEAD>
    <BODY></BODY></HTML>
    ————————————————————
    Here are the lines I changed in my wp-config.php (nothing at the end of the file):
    ————————————————————
    define(‘DB_NAME’, ‘mc’); // The name of the database
    define(‘DB_USER’, ‘mcadmin’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘xxx’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    ————————————————————
    I bet there’s a problem with it connecting to mysql. For fun, here’s how I access mysql, get the stats for the database mc and then try to lookup the wp_posts table:
    ————————————————————
    [bin]$ ./mysql -p –user=mcadmin mc
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 50 to server version: 4.0.15-standard-log
    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
    mysql> \s
    ————–
    ./mysql Ver 12.21 Distrib 4.0.15, for pc-linux (i686)
    Connection id: 50
    Current database: mc
    Current user: mcadmin@localhost
    SSL: Not in use
    Current pager: stdout
    Using outfile: ”
    Server version: 4.0.15-standard-log
    Protocol version: 10
    Connection: Localhost via UNIX socket
    Client characterset: latin1
    Server characterset: latin1
    UNIX socket: /var/lib/mysql/mysql.sock
    Uptime: 1 day 1 hour 49 min 54 sec
    Threads: 1 Questions: 124 Slow queries: 0 Opens: 38 Flush tables: 1 Open tables: 2 Queries per second avg: 0.001
    ————–
    mysql> select * from wp_posts;
    ERROR 1146: Table ‘mc.wp_posts’ doesn’t exist
    mysql> show tables from mc;
    Empty set (0.00 sec)
    mysql>
    ————————————————————
    Hmmmm….
    -=John

    Thread Starter squishy

    (@squishy)

    I still am not able to install wordpress (see previous messages).
    Any ideas?
    -=John

    Thread Starter squishy

    (@squishy)

    Alright, I’ll answer my own question: I didn’t compile php4 with the –with-mysql option.
    Things progressed a lot farther after recompiling php.
    I still have some errors…but at least things seem to be working now 🙂
    -=John

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Installation error’ is closed to new replies.