installation problems

jgianoglio

Sorry to beat a dead horse, but I've read all of the relevant forum threads and I'm still banging my head against the wall with this. I'm new to PHP, MySQL and Xen Photo, so please, be gentle!
I've downloaded the latest release of ZP, made the changes to the zp-config.php file (and took off the .example extension). I've uploaded (via FTP) all of the folders and files to my server, which is hosted through GoDaddy.
The problem is that when I go to the setup (www.justperfectonline.com/zenphoto/zen/setup.php) it gives me the following error:
MySQL Error: Could not connect to the database server. Check your zp-config.php file for the correct Host, User name, and Password.

I tried changing the MySQL host in the zp-config file from "local host" to "h41mysql41.secureserver.net" which is what Godaddy tells me the MySQL database host name is.

Here is my zp-config.php file (minus the passwords):

<?php /* PUT NOTHING BEFORE THIS LINE, not even a line break! */
$conf = array();
define("DEBUG", false);

/** Do not edit above this line. **/
/**********************************/

/////////// zenPHOTO Configuration Variables //////////////////////////////
// After you're done editing this file, load
// http://www.yoursite.com/zenphotodir/zen/setup.php
// to run the setup (of course, replacing the paths where needed).

// NOTE: web_path and server_path are no longer needed! If you're having problems
// with the auto-detected paths, you can override them at the bottom of this file.
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
// Database Information (the most important part!)
////////////////////////////////////////////////////////////////////////////////

$conf['mysql_user'] = "whoohaaracing";
$conf['mysql_pass'] = "PASSWORD";
$conf['mysql_host'] = "h41mysql41.secureserver.net"; // Won't need to change this 90% of the time.
$conf['mysql_database'] = "whoohaaracing";

// If you're sharing the database with other tables, use a prefix to be safe.
$conf['mysql_prefix'] = "";

////////////////////////////////////////////////////////////////////////////////
// General Gallery Configuration
////////////////////////////////////////////////////////////////////////////////

// What you want to call your photo gallery.
$conf['gallery_title'] = "Team Whoohaa Racing";

// Your web site title and address, if you have one. If not, leave blank.
// These are used to link back to your main site, but your theme must support it.
$conf['website_title'] = "";
$conf['website_url'] = "";

// If you're in a different time zone from your server, set the offset in hours:
$conf['time_offset'] = 0;

// If you have Apache mod_rewrite, put true here, and you'll get nice cruft-free URLs.
// MAKE SURE TO EDIT THE .htaccess FILE with your path information.
$conf['mod_rewrite'] = false;

// If mod_rewrite is true above, zenphoto's image page URL's usually end in .jpg,
// set this if you want something else appended to the end (helps search engines).
// Examples: .html, .php, /view, etc.
$conf['mod_rewrite_image_suffix'] = '.php';

// Admin interface username (also required for running setup).
$conf['adminuser'] = "whoohaaracing";
// This isn't that secure, so don't put anything here you don't want anyone to see...
// (but make sure you change it to something other than 1234...)
$conf['adminpass'] = "PASSWORD";

// The email for the admin user. Used to send notification emails.
$conf['admin_email'] = "jim@romphotos.com";

// If you're running a secure server, change this to 'https' (Most people will leave this alone)
$conf['server_protocol'] = "http";

// The character encoding to use internally. Leave at UTF-8 if you're unsure.
$conf['charset'] = 'UTF-8';

////////////////////////////////////////////////////////////////////////////////
// Image Processing Configuration
////////////////////////////////////////////////////////////////////////////////

// JPEG Compression quality for all images and thumbnails (respectively):
$conf['image_quality'] = 85;
$conf['thumb_quality'] = 75;

// Default image display width (themes will be able to control this
// to an extent in the future, but for now you may have to adjust it to fit your theme).
$conf['image_size'] = 595;

// If this is set to true, then the longest side of the image will be $image_size.
// Otherwise, the *width* of the image will be $image_size.
$conf['image_use_longest_side'] = true;

// Allow images to be scaled up to the requested size? This could result in loss
// of quality, so it's off by default.
$conf['image_allow_upscale'] = false;

// Default thumbnail size and scale:
// If $thumb_crop is set to true, then the thumbnail will be a centered portion of the image
// with the given width and height after being resized to $thumb_size (by shortest side).
// Otherwise, it will be the full image resized to $thumb_size (by shortest side).
// NOTE: thumb_crop_width and height should always be less than or equal to thumb_size
$conf['thumb_size'] = 100;
$conf['thumb_crop'] = true;
$conf['thumb_crop_width'] = 85;
$conf['thumb_crop_height'] = 85;
// Add a small amount of unsharp mask to thumbnails? Slows thumbnail generation on slow servers.
$conf['thumb_sharpen'] = false;

// Paging options:
// Control of their display is done in the theme, so you might need to change these
// after switching themes to make it look better.
$conf['albums_per_page'] = 5;
$conf['images_per_page'] = 15;

////////////////////////////////////////////////////////////////////////////////
// Comment cleaning configuration
////////////////////////////////////////////////////////////////////////////////

// Tags and attributes allowed in comments
// Follow the array form array('tag' => array('attribute' => array()))
$conf['allowed_tags'] = array (
'a' => array ('href' => array (), 'title' => array ()),
'abbr' => array ('title' => array ()),
'acronym' => array ('title' => array ()),
'b' => array (),
'blockquote' => array ('cite' => array ()),
'code' => array (),
'em' => array (),
'i' => array (),
'strike' => array (),
'strong' => array (),
'ul' => array (),
'ol' => array (),
'li' => array (),
);

////////////////////////////////////////////////////////////////////////////////
// Path Overrides
////////////////////////////////////////////////////////////////////////////////
// Uncomment the following two lines ONLY IF YOU'RE HAVING PROBLEMS,
// like "file not found" or "not readable" errors.
// These allow you to override Zenphoto's detection of the correct paths
// on your server, which might work better on some setups.
////////////////////////////////////////////////////////////////////////////////

// define('WEBPATH', '/zenphoto');
// define('SERVERPATH', 'd:\hosting\jimandpam');

/** Do not edit below this line. **/
/**********************************/

$_zp_conf_vars = $conf;

?>

I've tried uncommenting the last 2 lines (// define('WEBPATH', '/zenphoto'); // define('SERVERPATH', 'd:\hosting\jimandpam') but that doesn't work.
My PHP info can be found at http://www.justperfectonline.com/phpinfo.php
I believe my server uses IIS, but I'm not sure (my knowledge is limited on that front).

Please help me fix what is probably an obvious mistake-- and excuse my dim-witedness!
Thank you!
Jim

acrylian

Are you sure about the database name? Do you really have already an active database? You need to do that before zenphoto setup.

From your zp-config-file I would guess that the name of your database would be "h41mysql41".
Have you tried that?

jgianoglio

I have already created the database, which is named "whoohaaracing"
It did not set up any tables or anything in the database, just created it and set a username and password.

The following database information is from my GoDaddy hosting control center/Database Management panel:

Host Name: h41mysql41.secureserver.net
Database Name: whoohaaracing
Database Version: 4.1
Description: WhoohaaGallery
User Name: whoohaaracing

Any ideas?

acrylian

You did everything right. Maybe still just a typo in password?...just guessing I am sure you already checked this a dozen times. I am very sorry I have no idea what the mistake might be. I do neither know your host nor do I have experience with IIS servers. I hope that someone of the others can help you.

I forgot: I tried to look at your phpinfo.php but the "page is not found".

jgianoglio

Sorry- I put the wrong URL to the PHP info file. Here's the real McCoy:
http://www.justperfectonline.com/zenphoto/phpinfo.php

Thanks for looking!

thinkdreams

safe mode is on. that presents a lot of problems for zenphoto operating properly. that may just be the issue, although i don't remember it not actually stopping you from connecting to a mysql server, you usually get other errors instead. (double checking the password is a good idea). this is something that is host configured, and must be turned off on your host's end. The PHP developers even have not so good things to say about safe mode:

http://www.php.net/manual/en/features.safe-mode.php

Safe mode essentially is a solution to shared server security issues, and is not the right way to go about it. It breaks a lot of applications. The best solution is to find a host that doesn't use safe mode. At worst, zenphoto won't work properly with it on.

jgianoglio

Up and running!
I called GoDaddy and they switched me to a Linux server. Problem solved.
Thanks!

thinkdreams

Cool. Glad to hear everything is good. Let us know if you need further assistance.