Entry

How do I install Free Trade on a Unix system?

Jun 26th, 2000 19:30
Shawn Honeychurch, Cresta Johnson,

Well, since I didn't get a reply, I had to dig in and find the answer 
to this question myself! :)

To install Freetrade, you need to setup the database according to the 
build.sql file that is in the main folder of the Freetrade files. If 
there is an automated way of setting up the database, someone please 
add to this response. I did the setup manually. Telnet to your mysql 
database (which you will have to create or have created for you). Then 
create all the tables according to the build.sql file. Be sure to 
insert the data (you will see the INSERT commands in the build.sql 
file). After setting up the database in a text editor, open up the 
global_settings file, (which is in the "include" folder, inside 
the "modules" folder) and scroll down until you see "DATABASE SETTINGS" 
then change these settings to your own settings:

define("DATABASE_HOST", "localhost"); 
	define("DATABASE_USER", "type_in_your_database_username");
	define("DATABASE_PASSWORD", "type_in_your_database_password");
	define("DATABASE_NAME", "type_in_your_database_name");

Save the global_settings file. Now upload all the folders and files to 
your server. Direct your browser to www.yourdomain.com/htdocs/ (If you 
created a folder, maybe called freetrade & uploaded your files to this 
folder, then point your browser to www.yourdomain.com/freetrade/htdocs/ 
or whatever folder you have your freetrade files in). Now you should be 
on a Freetrade screen that lists a bunch of information about 
Freetrade, where the files are and your browser. On the left hand side 
there is a "Login" link. Click on that and login as admin, with the 
password as admin. This should take you to the admin screen with all 
the options for setting up your departments and shopping cart items. 
Pretty cool, huh?

OK, to make sure the "build.sql" file will do it's magic you have to 
make a change to the top of it.
MAKE SURE THAT THE FIRST ( LINES ARE THE SAME AS BELOW, without the 
quotes of course.

"
# MySQL dump 4.0
#
# Host:     Database: freetrade
#--------------------------------------------------------

#
# Table structure for table 'attribute'
#
CREATE TABLE attribute (
"

Everything below "CREATE TABLE attribute (" stays as it is in the .sql 
file.  

So in short to use the build.sql file, do the following.

1. Create a database calles "freetrade".
2. Make the mentioned changes to the "build.sql" file.
3. Import the "build.sql" file into your database.
4. THat's all folks.
Have fun
Shawn