Help! Uploaded but no setup or install file?

[jbryant7]

Help!

I really cannot wait to install this gallery but have already hit a snag.

I have followed the quick install directions and downloaded, changed input file name, uploaded to server but there is not setup.php file.

No install file either.

I did find the EDITOR_path_setup.php file and when called it says:


Unable to connect to the photo database server at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.

PAGE: EDITOR_path_setup.php

Why do you get this error? Maybe because:

The database server has not been activated for you domain
your username/password is wrong.
The database server in offline for some reason.

If you get this error, contact your server administrator and check if MySQL is indeed running on your server. This error message can also mean that the MySQL server is overloaded - can easily happen in shared hosting where 250 sites fight for one CPU and same system resources or there are just too many visitors for the server to handle.

(Info by Exhibit Engine)


MySQL is running. Any suggestion?
Thank you for your time,
Jbryant7

[jbryant7]

okay...I still cannot use the file path: myserver.com/gallery/setup.php
because there is no setup or install files except Editor_path_setup.php.

Anyway, contacted my host and there seems to be another problem as well.

I have PHP 4.3.5
EE requirements say:
"but are yet untested PHP 4.05 or greater installed"
I should be fine but now get this message:


Could not retrieve authorization data, can not proceed.
Perhaps 'ee_admin' table is missing (wrong EE database version)? Is database online?


I canot find 'ee_admin' table.
Hosting company cannot help anymore.
Can anyone else, Please?

Sometimes I am too stupid to own computer.

[Pekka]

Perhaps its easier to start from start:

Clean install of EE 1.5 RC 4

1. download http://photography-on-the.net/ee/beta/EE_RC4.zip, open in in your home machine and upload whole directory structure to your server, in folder of your choice.

2. Set folder permissions:

These folders must have 777 permissions for EE to work correctly (GALLERY is path to your EE main folder):

GALLERY/temp
GALLERY/export
GALLERY/input/temp
GALLERY/input/UPLOAD
GALLERY/input/UPLOAD/test
GALLERY/input/UPLOAD/ee_temp_upload
GALLERY/input/backup/ee_backup_files

3. Open GALLERY/add/connect.php in text editor and replace
$servername = "localhost";
$databasename = "DATABASENAME";
$username = "USERNAME";
$password = "PASSWORD";

with your own data (which your ISP gave you)

Then edit same database data in GALLERY/backup/ee_backup_prefs/preferences.php

connect_menu ("localhost", "DATABASENAME", "USERNAME", "PASSWORD", "100" );


4. Open the database installer into your browser:
http://www.yourdomain.com/GALLERY/rc4_installers/full_15rc4.php
(if you get an error page on this stage your add/connect.php has wrong info).

When database installer is run, EE is installed. Delete folder rc4_installers.

You can go to your editor
http://www.yourdomain.com/GALLERY/input/
with

username: admin
pass: pass

and continue from there by following document http://www.photography-on-the.net/ee/beta/setup_upload_system.php to the letter.

[jbryant7]

I had just finished installing EE1.2 when I checked back to see your post!

I immediately uninstalled and reinstalled the EE1.5.

It works like a champ now and my confidence is restored!

Thanks for the fast reply, the answers to my questions, and of course, the great software!

[tgriff]

I followed these instructions and twice have been searching the posts for help on setup.
The Mysql database is active, user name and password are correct in both the connect.php and the preferences.php
Being new to php and mysql, I may have indeed missed something, the error I get when trying to run the rc4_installer tells me that mysql is not correct:
|Unable to connect to the photo database server at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.
PAGE: full_15rc4.php
Why do you get this error? Maybe because:
The database server has not been activated for you domain
your username/password is wrong.
The database server in offline for some reason.
If you get this error, contact your server administrator and check if MySQL is indeed running on your server. This error message can also mean that the MySQL server is overloaded - can easily happen in shared hosting where 250 sites fight for one CPU and same system resources or there are just too many visitors for the server to handle.
(Info by Exhibit Engine)|

Is there a way to manually setup the sql table? Is there anything more than creating the db and user in order to activate this cool sql photogallery?

Thanks!

Tim 8)

[Big Ryg]

Was there an off-line resolution for the last entry in this series of posts?

http://photography-on-the.net/forum/showthread.php?t=30825&highlight=unable+connect+da tabase

These seems to describe my situation exactly and unfortunately it ends with a question rather than an anwer. I've been going around and around with my ISP about getting the connection string setup correctly, but they assure me that it should work. I had them create a new mySQL db and I've been able to connect to it with an enterprise manager tool so I know the logins work.

I'm stuck at the beginning and would appreciate if there was anyone who could help. :oops: Thanks!

[Pekka]

I followed these instructions and twice have been searching the posts for help on setup.
The Mysql database is active, user name and password are correct in both the connect.php and the preferences.php
Being new to php and mysql, I may have indeed missed something, the error I get when trying to run the rc4_installer tells me that mysql is not correct:
|Unable to connect to the photo database server at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.
PAGE: full_15rc4.php
Why do you get this error? Maybe because:
The database server has not been activated for you domain
your username/password is wrong.
The database server in offline for some reason.
If you get this error, contact your server administrator and check if MySQL is indeed running on your server. This error message can also mean that the MySQL server is overloaded - can easily happen in shared hosting where 250 sites fight for one CPU and same system resources or there are just too many visitors for the server to handle.
(Info by Exhibit Engine)|

Is there a way to manually setup the sql table? Is there anything more than creating the db and user in order to activate this cool sql photogallery?

Thanks!

Tim 8)

You will need to get MySQL connect to work in order to install and use EE. EDIT THE FILE WITH PLAIN TEXT EDITOR (i.e notepad or pico). If in doubt start with "clean" connect.php file that comes with EE install pack. There are only four variables in connect.php:

$servername = "localhost";

Server name is usually localhost, but sometimes you will need your domain name or the name your admin informs you to use. On this server firewall must let PHP's requests and MySQL traffic pass.

$databasename = "my_ee_database";



Database name is the name of the database you want to install EE to. Database must be created before EE is installed. All ee tables will be prefixed ee_ so you can use occupied database but it is recommended for speed and maintenance reasons that you use a separate MySQL database for EE only.

$username = "username";

Username is assigned to you by server admin. If you manage users with PHPmyAdmin yourself note that MySQL must be restarted for username changes to be active.

$password = "mypass";

Password for the above MySQL username.

NOTE: please check that each line has quotes " around the variable and ; in the end. If there is a syntax error in the file you may not be neccessarily notified but just given a normal "can not connect" error page.

NOTE: there are two possible connection error pages provided by EE:
"Unable to connect to the photo database server"
This message means MySQL server could not be found. Check your $servername, $username and $password variables.
Unable to connect to the photo database at this time
This message tells you the server responds but does not see the database. Check your $databasename variable.

[Big Ryg]

Pekka wrote:
NOTE: there are two possible connection error pages provided by EE:
Code:
"Unable to connect to the photo database server"

This message means MySQL server could not be found. Check your $servername, $username and $password variables.
Code:
Unable to connect to the photo database at this time

This message tells you the server responds but does not see the database. Check your $databasename variable

What's interesting is that I only get the second error: "unable to connect to the photo database at this time" even if I change the servername variable to something clearly wrong or if I leave all variables blank.

By your previous message I would imagine that I should see the error message change to "MySQL server could not be found." when I added extra characters to my servername, user Id and/or password variables (or leave them all blank) in an attempt to force the error.

Does this indicate that something else might be going on here?

One more thing I noticed is that my directory permissions are not persisting. I didn't have any errors or permission denied messages when changing permissions to 777, but when I go back to confirm they're reset to 666. I'm wondering if that could manifest itself as this connection problem? I imagine it would be a problem down the line, but not sure if I'm dealing with two issues or one at the time of install.

...I feel like I'm getting warmer...<knock on wood> :?

[wkitty42]

By your previous message I would imagine that I should see the error message change to "MySQL server could not be found." when I added extra characters to my servername, user Id and/or password variables (or leave them all blank) in an attempt to force the error.

Does this indicate that something else might be going on here?
no... it appears to indicate that the database is not created for the EE tables...

in otherwords, if you want EEs database tables stored in a database called EE_Galleries, then you need to ensure that that database is created in mysql before trying to get EE to access it and create its tables...

some hosting sites create one database for each hosted account... i don't use any hosted accounts so i can't speculate on the database name they might assign you... in any case, getting the CaSe of the database name is sometimes part of the problem in situations similar to this... for example, i generally type in all lowercase... sometimes, though, i may create files with capital letters in them... on winwhatever systems, this is generally not a problem... however, on systems like linux, cAsE is important and must be correct for things to work properly...