• I’m trying to install WP on my shared, Windows web server. Godaddy.com is my host. After creating a MySQL database using what passes for a control panel provided by my ISP, I edited the wp-config file as follows:

    ***
    define(‘DB_NAME’, ‘wordpressblogdb’); // The name of the database
    define(‘DB_USER’, ‘wordpressblogdb’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘****’); // …and password
    define(‘DB_HOST’, ‘mysql57.secureserver.net’); // 99% chance you won’t need to change this value
    ***

    The host info comes from the ISP, so I assume it’s correct.

    After uploading all the files using FrontPage, the install.php page returns this:

    Your PHP installation appears to be missing the MySQL which is required for WordPress.

    In searching the forum for this error I see that others have had it, but many of them are trying to do a local install and are having some PHP or MySQL config issues that I don’t think apply here, because I can’t configure PHP or MySQL (other than managing a db) on my server.

    I asked my ISP about this, and they swear they support the required version of PHP and MySQL, BUT they also say PHP on Windows accounts (which is what I have) runs in safe mode.

    Before I start trying to figure out whether this is a MySQL connection problem I’m wondering if PHP in safe mode is a show-stopper all by itself.

    I have no idea why my host insists on running PHP in safe mode on Windows accounts. Since I use FrontPage for some other database stuff I have some ASP pages and thus do not really want to move to a Linux account (which, apparently, does not have the safe mode limitation, if indeed it is a limitation). Is there any fundamental reason a host can’t offer full PHP, MySQL, and ASP support on a hosting platform? I’d probably rather switch hosts than abandon my use of FrontPage.

    Thanks to those who read this far.

    Randy

Viewing 13 replies - 1 through 13 (of 13 total)
  • I’m not terribly familiar with PHP on Windows, so I can’t provide too much guidance.

    Try this: copy-and-paste the following into a new file, called “php.php”, and upload it your website:
    <?php phpinfo(); ?>

    Now load php.php in your browser and examine the output. You’re specifically looking for a section labelled “mysql” which will display some of the run-time configuration details pertitent to MySQL.

    If you do not see that then you’ll need to coordinate with GoDaddy.

    Thread Starter rmorgan

    (@rmorgan)

    Hi, and thanks for replying.

    I did as you suggest, and got (among much else) this when I viewed php.php. Under PHP Core there are several functions with ‘sql’ in the command that are disabled. I don’t know if any of them are required for WP:

    disable_functions getmyinode, getopt, getrusage, extension_loaded, dl, mysql_pconnect, crack_check, crack_closedict, crack_getlastmessage, crack_opendict, fsockopen, pfsockopen, mysql_list_dbs, mysql_stat, ini_get, ini_get_all, ini_alter, ini_set, get_current_user, get_defined_constants, get_include_path, php_ini_scanned_files, php_uname, phpcredits, restore_include_path, set_include_path, set_time_limit, version_compare, zend_version, getmypid, getmyuid, getmygid, assert_options, assert, fopen, fwrite, fread, file, fpassthru, file, mail, opendir, readdir, closedir getmyinode, getopt, getrusage, extension_loaded, dl, mysql_pconnect, crack_check, crack_closedict, crack_getlastmessage, crack_opendict, fsockopen, pfsockopen, mysql_list_dbs, mysql_stat, ini_get, ini_get_all, ini_alter, ini_set, get_current_user, get_defined_constants, get_include_path, php_ini_scanned_files, php_uname, phpcredits, restore_include_path, set_include_path, set_time_limit, version_compare, zend_version, getmypid, getmyuid, getmygid, assert_options, assert, fopen, fwrite, fread, file, fpassthru, file, mail, opendir, readdir, closedir

    Under the MySQL section I got:

    mysql
    MySQL Support enabled
    Active Persistent Links 0
    Active Links 0
    Client API version 3.23.49

    Directive Local Value Master Value
    mysql.allow_persistent On On
    mysql.connect_timeout 60 60
    mysql.default_host no value no value
    mysql.default_password no value no value
    mysql.default_port no value no value
    mysql.default_socket no value no value
    mysql.default_user no value no value
    mysql.max_links Unlimited Unlimited
    mysql.max_persistent Unlimited Unlimited
    mysql.trace_mode Off Off

    From this I don’t see any obvious MySQL problems, but I’m no MySQL expert.

    My host again says they have PHP (safe mode) and MySQL support, and from this I guess they’re right…but, so far the installation is still going nowhere.

    Thanks,
    Randy

    PHP in safe_mode often logs safe_mode violations to the web server’s error log. Can you review your web server’s error log and share here any relevant entries?

    Thread Starter rmorgan

    (@rmorgan)

    I’ll ask godaddy if I can view the error log. I haven’t had too much luck with that before, though. Will post whatever I get!

    Thread Starter rmorgan

    (@rmorgan)

    As I feared, godaddy will not allow me to view the server error logs, so I can’t tell for certain if it’s the the safe-mode config of PHP that’s causing the problem, or the other commands they’ve disabled, or what.

    sounds like it’s time to find a new host…. did they give a reason for not letting you see the logs?

    -tg

    Thread Starter rmorgan

    (@rmorgan)

    No, they don’t give a reason for not allowing things; you just can’t. I agree that I need a new host, and I’m in the process of looking for one.

    I previously ran a site in GoDaddy’s basic web host account. Sadly I don’t have it running there anymore…I just checked a site backup and my wp-config was set up the same as yours.

    Are you using something from your ISP or your Host (godaddy) to create the mysql database?

    BTW, I’ve had a lot of luck with https://www.hostingforabuck.com

    They are not a GoDaddy reseller.

    Thread Starter rmorgan

    (@rmorgan)

    I used a utility from godaddy to create the MySQL database, and it shows up as being there, because that’s where I got the information to populate the DB_HOST field.

    Godaddy is no help in the matter, of course, and tells me to check with the publisher as to whether PHP in safe mode OR with all the disabled functions will be a problem.

    I’m not really adverse to changing hosts, but I’m stuck between platforms. This is horribly off-topic, I know, but I’m on a Windows platform and *think* I would like to move to Linux for a variety of reasons. The problem is, I use MS FrontPage as my main editor and publisher, and I have some Access databases on my site. I don’t really know that much about MySQL and am not sure how long it would to learn. FP manages Access databases in an almost idiot-proof fashion, but doesn’t manage MySQL at all. It’s like the first time you’re on a diving board: You know it will be OK, but you still don’t want to jump. And, I don’t really want to change hosts and stay with Windows, because I expect I eventually will jump and then I’d be changing the site again.

    So, here I am, wondering what to do and not getting WordPress to work. Not my best day…

    Let me shed some light on some of the problems you are having. After running your php.php page with the php_info() in it, do a search for “safe” and you will find a directive that tells whether or not safe_mode is enabled.

    It doesn’t matter whether your server is Windows or Linux, safe_mode has nothing to do with the OS, but rather with a change that can be made inside the php.ini file on your server. I have a little experience with godaddy, but with other hosts, so allow you access to the php.ini file and some hosts do not.

    Check https://www.ixwebhosting.com. They aren’t the cheapest, but I run about 10 sites, and all are hosted ixwebhosting.com and I have been very impressed.

    Hope that helps.

    If you still are with godaddy, I can probably help as I am running a ASP site with PHP wordpress as a subdirectory application.
    Everything works except for the email, so I’m troubleshooting it currently. I installed WP about two days ago, and works fine.

    The biggest problem I had was WP to recognize there was a mysql database there.
    I removed the following line from wp-settings.php

    if ( !extension_loaded(‘mysql’) )
    die( ‘Your PHP installation appears to be missing the MySQL which is required for WordPress.’ );

    This apparently does not exist in windows.
    Try this and let me know how it goes.

    Cor – if you have any handy hints I’d love to hear them. I’m on a godaddy asp acocunt as well. I had found your hint about the database elsewhere on this site, and that works, but I can’t upload anything. Any ideas?
    “The uploaded file could not be moved to .”

    Dunno where . is

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Is PHP in Safe Mode a show stopper?’ is closed to new replies.