WordPress.org

Ready to get started?Download WordPress

Forums

Another GoDaddy-Linux-Missing MySQL Extension Problem (5 posts)

  1. mlewitz
    Member
    Posted 5 years ago #

    Okay, I've searched for a while on this and I know this is NOT a WP problem, it's a GoDaddy problem, but there are so many knowledgeable and helpful people here (unlike GoDaddy!), thought I'd start here. No doubt this may help others with the same problem.

    Initial install error:
    "Your PHP installation appears to be missing the MySQL extension which is required by WordPress."

    Apparently this is common.
    ..and YES I added: extension=mysql.so to the php.ini file & restarted Apache. No change...
    In searching, I see the mysql.so module is NOT found in the httpd.conf file or the /usr/lib/httpd/modules/ folder. (surprise)

    My config:
    Godaddy Virtual-Dedicated Server
    Linux (Fedora 7) w/ Simple Control Panel
    NOTE: Under "Installed Modules" MySQL is listed. ?
    PHP v 5.2.6

    FYI: GoDaddy "shared" Linux hosting runs WP just fine. The Virtual/Dedicated setups are a different story (apparently).

    I have full ROOT file access and can install anything I want, modify the httpd.conf, etc, so I believe I can fix this with help.

    I recently installed Magento Commerce without a hitch on this server -it is MySQL heavy and works perfect. I'm certain I created the database correctly for WP. I don't understand why Magento works fine but WP doesn't, but whatever...

    "yum" is an available function and I've seen some refer to this, but I have know idea where or what to do with that.

    Is "yum" a command that I can use with an SSH connection?

    SSH intimidates me a bit, but am an old "DOS" pro, so I imagine it can't be too difficult -I just don't now any SSH commands. I have PuTTY, too. Used it once. :-\

    I can't imagine this is THAT complicated. As a few have posted, PHP and MySQL just need to "talk" to each other.

    The "diagnostics" link shows:
    MySql (database server):
    Server version: 5.0.45-6.fc7
    Client version: 5.0.45-6.fc7
    Status: mysqld (pid 27943) is running...

    Something interesting: phpinfo() shows...
    Configuration File (php.ini) Path => /usr/lib
    Loaded Configuration File => (none)

    BUT... php.ini is only found in /etc/ and nowhere else...??

    Hopefully I've provided enough info.
    Thanks in advance for any help!
    -Mike

  2. Samuel B
    moderator
    Posted 5 years ago #

    i may be wrong but i thought php.ini had to be in root, also.
    test if php is running - drop this in a file and save it as phpinfo.php
    <?php phpinfo(); ?>
    upload it to your root and call it in your browser
    if php is running correctly you will see a lot of info

  3. mlewitz
    Member
    Posted 5 years ago #

    Thanks for responding, samboll. If you re-read my original post carefully, you'll notice 7 lines from the bottom that I have run phpinfo() and it gave me the configuration file location and the loaded configuration file I provided above. ...not to mention that my post specifically states I'm running PHP v5.2.6. Naturally, I got the version from running phpinfo().

    Additionally, Magento Commerce is a purely php-based package using a php-MySQL database (as I mentioned). If php were not running, I don't see how these php-based files and databases could be functioning.

    I truly appreciate the helpfulness of everyone, but please don't blindly ask a bunch of questions like: "Are you running Windows or Linux?" or "Did you try editing the php.ini file?" or "Did you search Google/WordPress help?" or "Is this an upgrade or new install?" or "Are you using cPanel?" or "Do you have ROOT access?" or "Is this shared or dedicated hosting?" or "GoDaddy has an automated setup, just use that." or "Did you contact GoDaddy to fix it?"

    I believe the MySQL Extension is actually not anywhere on this server. Considering I have the access rights to do so, how can I place it there?

    Thanks again!
    -Mike

  4. mlewitz
    Member
    Posted 5 years ago #

    Sooo... nobody knows how to resolve this issue or can explain how to use "yum" to help?

  5. MichaelH
    Member
    Posted 5 years ago #

    Here's the code that's generating that message;

    if ( !extension_loaded('mysql') && !file_exists(WP_CONTENT_DIR . '/db.php') )
    	die( /*WP_I18N_OLD_MYSQL*/'Your PHP installation appears to be missing the MySQL extension which is required by WordPress.'/*/WP_I18N_OLD_MYSQL*/ );

    Donncha has a post that might help you:
    http://ocaoimh.ie/2007/01/03/cannot-load-mysql-extension-please-check-your-php-configuration/

    Since you look to have a more sophisticated hosting account than most Godaddy users, and even though you've requested to not blindly ask, "Did you contact GoDaddy...?" you might consider talking to Godaddy support--sometimes they can be quite helpful, and since you are paying them, that could play to your advantage.

    Good Luck.

Topic Closed

This topic has been closed to new replies.

About this Topic