Sticky Instructions for Full Installation on new system

[kenwood720]

I am looking to install EE on a server in my home. It's a Win2k3 R2 server with all patches.

I have struggled for the last couple of days to get the system to work properly.

I've been a network technician for 6+ years now, but I really struggled on this software side this time. I've flipped switches in config files before, but nothing like this.

My main reason for this post is to ask if there is a complete guide to installing EE on a blank system.

I have installed and configured:
apache_1.3.37-win32-x86-no_src.msi
php-4.2.0-Win32.zip
PHP tested as working through apache.

I installed mysql-3.23.57-win.zip but was unsure on how to get the Database functions working properly.

When I load the install page,
http://localhost:8080/ExhibitEngine/rc4_installers/full_15rc4.php

it mentions that:

<LI style="FONT: 12px Verdana, Geneva, Arial, Helvetica, sans-serif">The database server has not been activated for you domain <LI style="FONT: 12px Verdana, Geneva, Arial, Helvetica, sans-serif">your username/password is wrong. <LI style="FONT: 12px Verdana, Geneva, Arial, Helvetica, sans-serif">The database server in offline for some reason.
I think I configured the SQL login/password during installation. I entered it into the two files:
connect.php and preferences.php, but it doesn't seem to work.

Has anyone created a full instruction list on how to set this up?

Thanks in advance,
Sean

[wkitty42]

there has not yet been a full instruction list written... one problem is that no empty database scheme has been created, either... i'm sure that pekka is working on all of this as well as the bug fixes and such but i'm also extremely sure that life outside ee has distracted him since the release... he did make mention in one post about his paying work and being involved in recording a CD with the orchestra he works with... that is, after all, how he lives from day to day ;)

[MikeCaine]

I think you have to install 1.5 and then follow the upgrade instructions to 2.01

[wkitty42]

I think you have to install 1.5 and then follow the upgrade instructions to 2.01
that's the way you do it for now because the install for v1.5 has the database table schema, creates all the tables needed and populates some with default data... then the upgrade adds, deletes, and modifies those as necessary for the new design... what is needed is an install script for 2.0 that does the same as the one for 1.5...

[malum]

what you have there is a 1.5 installation issue.
Sounds like a simple problem, you either didn't create a database (EE doesn't create an empty db for you if I recall) or there's a typo in the db name or username or password somewhere, or something similar.

Once you have 1.5 up and running you are ready to tackle the upgrade (which I haven't done myself yet)

[kenwood720]

I will try the installation of 1.5 and then upgrade. I will also keep you posted on my status.

Thank you for your suggestions.

[DavidW]

You need to set up and secure MySQL. I'd give you a set of commands, but I use MySQL on FreeBSD, so I'm using UNIX like commands, not Windows. On UNIX you need to start the server, run mysql_install_db so that you have some grant tables, then you should change the root passwords and arguably delete the guest accounts as well. On Windows it's a bit different.

Section 2.10 (http://dev.mysql.com/doc/refman/5.0/en/post-installation.html) of the MySQL reference manual (http://dev.mysql.com/doc/refman/5.0/en/index.html) will help you out (these links point to the MySQL 5.0 manual, because I believe 5.0 is the right version to install from fresh for most users).


Once all that is done, you need to create a database and user for EE:

mysql -u root -p
CREATE DATABASE `ee`;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, LOCK TABLES ON `ee`.* TO 'ee'@'%' IDENTIFIED BY 'word';
EXIT

should create a database ee, and give the necessary privileges for EE on that database to user ee with password word accessing from any host (if you only need access from the machine that MySQL is running on, change the % to localhost to improve security). Don't use the password word though!

Installing phpMyAdmin will help a lot with administering MySQL.


As this is a new server, I'd forget all about MySQL 3.23, which is ancient, and install MySQL 5.0 instead (the latest version is 5.0.27 - 5.1 is a development version). Indeed, there's an argument to use modern versions of PHP (5.2.0 if you can get a binary, otherwise 5.1.6) and Apache (arguably you should go straight to 2.2.3) as well.

You'll also need an FTP server to use EE - the EE code FTPs files around. I use proftpd on FreeBSD; it's down to you to find something that will work for you.



David

[DavidW]

One more thing comes to mind. If you install MySQL 5.0, I believe EE 2.01 has a few problems with Strict Mode. Pekka is intending to fix these problems, but until then, you may want to turn strict mode off in MySQL.

mysql -u root -p
SET GLOBAL sql_mode='';
EXIT

will make sure Strict Mode is off (that's two ', not a single "). In fact, that wipes all global options, but for a new MySQL 5 server, it will do. Section 5.2.6 (http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html) of the MySQL reference manual has all the information.



David

[kenwood720]

what is needed is an install script for 2.0 that does the same as the one for 1.5...

Where can I download 2.0? I could only find 1.5 RC4 from http://photography-on-the.net/ee/download.php

[DavidW]

Once you have 1.5RC4 installed on the server and set up, that's the point at which you upgrade.

EE 2 upgrade kit is here (http://photography-on-the.net/forum/showthread.php?t=223287).
EE 2.01 patch (apply after the EE 2 upgrade kit) is here (http://photography-on-the.net/forum/showthread.php?t=224187).


When Pekka has the time, I expect he'll release a 2.02 patch to include various other bugs that have been found and fixed, but 2.01 is a good product as it stands. Similarly, I expect Pekka will release an EE 2 fresh installer, and will probably upgrade the distribution archives to 2.01 or a forthcoming later version.

It's not that bad for now, though - once you've got Apache, PHP, MySQL and an FTP server installed and configured, it's possible to get EE 2 installed from a standing start in an hour or two. ImageMagick would also be worth installing.


Have you any feedback on whether my MySQL instructions were useful? Are they worth tidying up, or are they OK as they stand?



David