Build 009
Well the error message is gone. Now I end up on a totally blank page (3.php)
16 tables were created.
Well the error message is gone. Now I end up on a totally blank page (3.php)
16 tables were created.
Try editing the Connections/PowerStoreConnection.php file manually and change the mysql_pconnect call to mysql_connect. After saving the file, you should be able to restart the install and step 2 will indicate the database has already been setup.
Let's see if this change makes a difference for you. That is really the only code being run before you are getting the access denied error.
-justin
Just tried this with no change. I'm not getting any error, just a blank page.
Did you try changing line 9 to this? (removes the or die part basically)
$PowerStoreConnection = @mysql_connect($hostname_PowerStoreConnection, $username_PowerStoreConnection, $password_PowerStoreConnection);
The code is erroring out just trying to connect to the database, and really that connection file is exactly what Dreamweaver would output. The other test could be to create a basic php page and only have the connections include on it. My guess is that will still error out.
What kind of server are running on and are there any custom permissions or database settings or anything like that going on? I've been able to run the install fine on linux, windows, apache, IIS here so I'm having a hard time reproducing the issue on my end.
I took the original connection code generated by the wizard and inserted it into a blank php page created in DW. I added the word OK at the bottom to make sure the page was executed.
I uploaded this to the same site and used Firefox to display the page. It ran without any errors and displayed OK on a blank white page.
Thanks for your troubleshooting on this. This is a weird issue since PowerGallery works and those first 3 steps are basically the same as for PowerStore.
What about if you make a page with these lines of code:
<?php
require_once('global.php');
require_once('../Connections/PowerStoreConnection.php');
mysql_select_db($database_PowerStoreConnection);
?>
OK
If the global.php has lines of code for error_reporting and ini_set, you can change those to look like this to give us full error reporting.
error_reporting(E_ALL);
ini_set('display_errors', 'on');
Also, have you tried just using Dreamweaver to create the connection and try and make a basic recordset?
require_once('global.php');
require_once('../Connections/PowerStoreConnection.php');
mysql_select_db($database_PowerStoreConnection);
?>
OK
error_reporting(E_ALL);
ini_set('display_errors', 'on');
I will try this when I get back to my office. I think it's more of a problem with the resource checking in the installation wizard than a connection problem.
If that still doesn't work just try changing line 9 to this:
$PowerStoreConnection = @mysql_connect($hostname_PowerStoreConnection, $username_PowerStoreConnection, $password_PowerStoreConnection);
This allows me to get to step 3. I'm going to continue now. Report back soon.
Just curious... does the database user (the one you're using to create the tables ect) have create and show view permissions?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.