ITW Calendar Installation Help Please

Sorry for maybe sounding thick here but........

Can anyone help me with a step-by-step guide to installing both the calendar and also MySQL. You may gather that I am totally new to both PHP and SQL and haven't a clue where to start. Have studied websites but seem to be going round and round in circles.

Any help will be very much appreciated (and there could even be a pint in it too! ) )

Cheers

Hello,

The read me file with the download speaks of installation. The hardest part is to creat the mySQL data base name, user id, and password. These are put into the ltw_config.php file. This will ask for the location of the mySQL file, usually localhost, the datafile name, the password, and id. Type in your answers here and read the detailed comments throughtout the file and make your selections. After uploading to your server, run the ltw_install.php program and it will install it for you. If you have errors, the errors have been listed quite well in the LTW forum - search for your error and you will find the fix.

JStevenT

I've followed what you said, but still it won't install

any ideas??

Cheers,

Andy

Hello Andy,

What is the text of the errors you receive? Without this, we can't help.

JStevenT

Hi Steven,

I get the screen saying:"ltwCalendar Installer (v4.0)
This script will install a new ltwCalendar database if one is not defined,
or upgrade an existing V2.x or 3.x database to work with version 4.0.

Before running this process
It is highly recommended you back up your existing database structure and contents.
The script will alter existing tables to add columns needed for v4.0 to work properly.

Click to continue"

so i click CONTINUE and all i then get is:-

"ltwCalendar Installer (v4.0)"

and nothing appears to happen.

Cheers

Andy

Hello Andy,

I would try downloading the program again and re-enter your database name and id and such. Does your server (ISP) have PHP? I don't know what the problem with having more info. I realize that you have reported all you know, but I am not experienced enough (haven't had a non-start problem).

Maybe some of our more experienced PHP people will add some comments.

JStevenT

i am running it locally at the moment using:-

Windows 2003 (also same prob on win xp sp2)
apache 2.0.54
my sql 4.1.12
php 5.04
database called "test" user "ltwuser" password "ltwpass"

apache documents directory is c:/apache2/htdocs

below is my ltw_config.php file

<?php

////////////////////////////////////////////////////////////////////////////

// ltw_config.php

// $Id: ltw_config.php,v 1.17 2003/08/22 03:44:30 t51admin Exp $

//

// ltwCalendar Configuration File

////////////////////////////////////////////////////////////////////////////





// 'include_dir' defines the file system path to the directory that contains

// the .php scripts needed for the calendar. This 'logically' separates the

// configuration information from the code, making it easier to run multiple

// calendars on the same server off the same code "base".

// By default, the code is kept in the same directory as the config file.

$ltw_config['include_dir'] = './private';



// 'html_xxxxer_file' defines the file system path to the header and footer

// files, making them easier to share with other php scripts on a site

$ltw_config['html_header_file'] = $ltw_config['include_dir'].'/ltw_header.php';

$ltw_config['html_footer_file'] = $ltw_config['include_dir'].'/ltw_footer.php';



// 'hrs_per_day' defines whether to use a 12 to 24 hour clock display

// for starting and ending times.

// valid settings are 12 or 24

$ltw_config['hrs_per_day'] = 12;



// 'salt' makes the database encryption for user logins unique to your setup

//by defining the string that 'salts' the crypt() function when dealing with

// passwords in the database.

// Change the following to some random 9 character string.

$ltw_config['salt'] ='Rb98-JC##';



// Define the database connection parameters.

// Currently only db_type = 1 (My SQL) is supported.

$ltw_config['db_type'] = 1;

$ltw_config['db_server'] = 'localhost';

$ltw_config['db_name'] = 'test';

$ltw_config['db_user'] = 'ltwuser';

$ltw_config['db_pass'] = 'ltwpass';

$ltw_config['db_persistent'] = false;



// Define the table names in the database to use

$ltw_config['db_table_calendar']= 'ltw_eventsv4';

$ltw_config['db_table_category']= 'ltw_categoryv4';

$ltw_config['db_table_users'] = 'ltw_usersv4';

$ltw_config['db_table_log'] = 'ltw_logv4';



// 'list_query_size' defines the number of days to return for each

// query in the "list" view. This variable allows you to "throttle"

// the number of events returned to minimize memory impact.

// If your calendar has a lot of events with long descriptions, you may

// want to reduce the size of this parameter.

$ltw_config['list_query_size'] = 31;



// 'login_required' defines whether or not a user must log in to see

// the calendar. If 'login_required', then a user must also have

// :Read Privledge" to view the calendar.

// Set login_required = 1 to enable

$ltw_config['login_required'] = 0;



// 'uloglevel' defines the user 'event' logging that occurs

// This is a bitmapped value, so you can set from

// none to all of the bits for full logging

// Bit 0x01 User Add/Edit/Delete (brief)

// Bit 0x02 User Add/Edit/Delete (detailed)

// Bit 0x04 User Login 'Events'

// Bit 0x08 User Change Password 'Events'

// examples

// uloglevel = 0x04 - write only Login/Out 'events'

// uloglevel = 0x05 - logins and minimal user change 'events'

// uloglevel = 0x0f - full logging

// uloglevel = 0x00 - disabled

$ltw_config['uloglevel'] = 0x0f;



// 'eloglevel' defines the event change logging that occurs

// This is a bitmapped value, so you can set from

// none to all of the bits for full logging

// Bit 0: Event Add/Edit/Delete (brief)

// Bit 1: Event Add/Edit/Delete (detailed)

// examples

// eloglevel = 0x01 - minimal logging

// eloglevel = 0x03 - maximum logging

// eloglevel = 0x00 - disabled

$ltw_config['eloglevel'] = 0x03;



// 'cloglevel' defines the category change logging that occurs

// This is a bitmapped value, so you can set from

// none to all of the bits for full logging

// Bit 0x01 Category add/edit/delete (brief)

// Bit 0x02 Category add/edit/delete (detailed)

// examples

// cloglevel = 0x01 - minimal logging

// cloglevel = 0x03 - maximum logging

// cloglevel = 0x00 - disabled

$ltw_config['cloglevel'] = 0x0f;



// 'min_pw_length' defines the minimum password number of characters allowed

// for a password. The minimum number for reasonable security should be 8

$ltw_config['min_pw_length'] = 8;



// 'pw_strength' defines the ammount of password checking that occurs.

// Valid values are:

// 0 - minimum - must be min_pw_length and can not contain username

// forward, backwards, or subbing 53011 for seoll

// 1 - medium - add it must contain numbers

// 2 - high - add it mus be mixed case + punctuation

$ltw_config['pw_strength'] = 0;



// 'max_pw_age' defines the number of days a password is valid.

// During the login process, if this number of days has elapsed since

// the last password change, then the user's USCHGPW bit is set

//

// max_pw_age = 0 disables the function

$ltw_config['max_pw_age'] = 0;



// 'bad_logins' and 'grace_period' define the number of times

// and in what period of seconds an invalid login will cause a user account

// to be "locked".

// bad_logins = 0 - disabled

$ltw_config['bad_logins'] = 5;

$ltw_config['grace_period'] = 120;



// 'cat_fgcolor' and 'cat_bgcolor' define the default color for event links

// if no matching category is found in the database

// (ie the category is deleted for existing events)

$ltw_config['cat_fgcolor'] = "#000000";

$ltw_config['cat_bgcolor'] = "#ffffff";



// 'week_starts_monday' defines whether the monthly calendar display

// starts on Sunday or Monday.

// 'week_starts_monday' = 0 - start the week on Sunday.

// 'week_starts_monday' = 1 - start the week on Monday.

// See Note in following section on 'daynames' too!

$ltw_config['week_starts_monday'] = 1;



// 'daynames' defines the names of the days that appear across the top of the

// "month" display. The array is defined twice, once for each posibility, to make

// it easier to set up.

//

if ( $ltw_config['week_starts_monday'] == 1 ){

// if week starts Monday

$ltw_config['daynames'] = array("Monday","Tuesday","Wednesday", "Thursday","Friday","Saturday","Sunday",);

}else{

// if week starts Sunday

$ltw_config['daynames'] = array("Sunday","Monday","Tuesday","Wednesday", "Thursday","Friday","Saturday");

}



// 'monthnames' defines the names of the months as they appear on the calendar

$ltw_config['monthnames'] =

array(1=>"January","February","March","April", "May","June","July","August", "September","October","November","December");



// 'start_time' and 'end_time' set the default event start and ending times.

// The format is HH:MM:TD, and is sensitive to 'hrs_per_day'

// HH - hour : 1-12 or 0-23

// MM - minute : 0, 15, 30, 45

// TD - time of day: AM/PM or ignored (if hrs_per_day = 24)

// if clock_base = 24, then the 3rd field is ignored

// start_time = 0 - disables feature

// end_time = 0 - disables feature

$ltw_config['start_time'] = 0;

$ltw_config['end_time'] = 0;



// 'bullets' defines whether or not a bullets are displayed for each event.

// bullets = 0 - disables the feature

$ltw_config['bullets'] = '1';



// 'email_enabled' defines whether to send an eMail whenever an event is

// added or updated.

// 'email_from' defines the 'From: address' of the sender

// 'email_reply_to' defines the 'Reply-To: address' of the sender, optional.

// 'email_host' defines the SMTP host to mail to (for Windows installations)

//

// email_enabled = 0 - disables feature

$ltw_config['email_enabled'] = '1';

$ltw_config['email_from'] = 'ltwAdmin@yourdomain.com';

$ltw_config['email_reply_to'] = '';

$ltw_config['email_host'] = '';



// 'use_popups' defines whether or not to use javascript popup windows

// or just load new page in current browser window

//

// use_popups = 0 - disables popups

// use_popups = 1 - enables popups

$ltw_config['use_popups'] = 0;





?>

I'm getting exactly the same has a solution been found to this?

For anonymous: What do you mean by saying exactly the same? Do you get an error message? If you reach the point with the warnings before the installation that means that php is installed on your web server. But did you reach that point? Another question? Did you try to login to yoyr server using s tool like MySqlAdministrator in order to check if your user was succesfully created? If you are getting error messages pls post it to have a look.

This would bw helpfull (the config file post). You can also clear your windows event log and then try installing in again. Then go to the windows event log and see if there is an error or warning event log for mysql. If there is any, pls post it. Assuming your os is windows ...

From a quick look your config file looks ok to me. What about your event logs? If there is any error during the installation attempt there must be an event log to tell you what was the problem. So pls check your windows event log or unistall and then reinstall your mysql server. I assume that the intallation php script is not giving you back any errors as can remember. And what version of mysql are you using (php version needed too)? What browser also? I don't know if this is important but if your browser is not configured to display errors you are not going to see any. I use firefox and in my begining gave me a few error messages that help me to configure mysql and php correctly.

As far as i understand the installation script creates the database. I believe your problem is your MySql version. I was trying to install it on a free web server that has your MySql version. I was running the create table sql queries on the remote MySql server and i found out that there are features in the scripts that are not supported by older Mysql servers (such as yours). In order to give you some help i have paste you the database table schemas. So run them one by one (first of all create a database
with any name (you will put the name in the config file after the process). I believe that you are going to face some problems (the reason is your MySql version). If you don't want to upgrade to the latest one you will have to make changes in the sql scripts and i can not tell you if you will need to make changes to the code (you may have to). So the choise is yours. I hope the following scripts will help you.

#
# Table structure for table ltw_categoryv4
#

DROP TABLE IF EXISTS `ltw_categoryv4`;
CREATE TABLE `ltw_categoryv4` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) character set latin1 NOT NULL,
`fgcolor` char(8) character set latin1 NOT NULL default '#000000',
`bgcolor` char(8) character set latin1 NOT NULL default '#ffffff',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

#
# Table structure for table ltw_eventsv4
#

DROP TABLE IF EXISTS `ltw_eventsv4`;
CREATE TABLE `ltw_eventsv4` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set latin1 NOT NULL default '',
`event_date` date NOT NULL default '0000-00-00',
`start_time` time NOT NULL default '00:00:00',
`end_time` time NOT NULL default '00:00:00',
`description` varchar(255) character set latin1 default NULL,
`recurring` tinyint(4) NOT NULL default '0',
`recur_dayofweek` tinyint(4) default NULL,
`day_event` tinyint(4) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '1',
`event_end` date NOT NULL default '0000-00-00',
`location` varchar(30) character set latin1 NOT NULL,
`url` varchar(200) default NULL,
`applies_to` varchar(5) NOT NULL default 'ALL',
PRIMARY KEY (`id`),
KEY `idx_date` (`event_date`)
) ENGINE=MyISAM;


#
# Table structure for table ltw_logv4
#

DROP TABLE IF EXISTS `ltw_logv4`;
CREATE TABLE `ltw_logv4` (
`id` int(11) NOT NULL auto_increment,
`type` int(11) default NULL,
`occured` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`admin` varchar(20) character set latin1 default NULL,
`info` text character set latin1,
PRIMARY KEY (`id`),
KEY `idx_occured` (`occured`)
) ENGINE=MyISAM;

#
# Table structure for table ltw_usersv4
#

DROP TABLE IF EXISTS `ltw_usersv4`;
CREATE TABLE `ltw_usersv4` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(20) character set latin1 NOT NULL default '',
`password` varchar(100) character set latin1 NOT NULL default '',
`email` varchar(100) character set latin1 default '',
`status` int(11) NOT NULL default '0',
`privledges` int(11) NOT NULL default '1',
`bad_logins` int(11) NOT NULL default '0',
`bad_logins_start` char(15) character set latin1 default NULL,
`last_pw_change` datetime default NULL,
`surname` varchar(20) default NULL,
`name` varchar(20) default NULL,
`preferences` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;