[SPTUsers] installComplete.php

Michael McFadden mmcfadden at mtc-inc.com
Thu Mar 13 13:57:49 CST 2003 

I finally got through the installation successfully.

I also had to increase the value in my php.ini file but just to 300 seconds
thank you for the suggestion this is what made the difference.  Apparently
the database started out without any tables and during the install tables
were added and since my php timed out the install was never completed.  When
I would try to hit the back button the install would run again and fail
because the tables were there from the first attempt at installation.  I did
have to shutdown the httpd process in RedHat 8 to then be able to edit the
php.ini with 300 seconds and then restart httpd for the change to take
effect.  Then I had to remove the tables and at that point it worked great.
Thanks for all the help.

Michael

Possible. Also, I am running on Win98SE, with some
other stuff also running, so that could be slower.

PC
--- Barry Wiegan <bwiegan at scout.wisc.edu> wrote:
> It normally only takes 15 seconds or so. We revamped
> the install
> a few releases ago to speed this up to avoid the
> timeout default
> of 30 seconds. Very slow hardware could push this
> past 30
> seconds presumably.
>
> Barry
>
> --
> Barry J. Wiegan
> Sr. Software Engineer
> Internet Scout Project
> Madison, WI
> bwiegan at scout.wisc.edu
>
> Arbit 1202 wrote:
>
> >Normally takes under 1 minute, on my machine which
> is
> >a Celeron 500. Try again.
> >
> >It is possible that your PHP installation stops
> >processing after 30 sec(this is the php default). I
> >changed the max_execution_time setting in php.ini
> to
> >600, and it worked fine after that.
> >
> >P C
> >--- Michael McFadden <mmcfadden at mtc-inc.com> wrote:
> >
> >
> >>Thank you for the help that seems to have fixed
> the
> >>problem.  How long
> >>should it take for the
> >>localhost/SPT/SPT--Install.php to run its course.
> >>It
> >>has been 30 minutes already any reason I should be
> >>concerned at this point.
> >>Also I am trying to find the documentation for The
> >>Scout Portal Toolkit.
> >>
> >>
> >>> -----Original Message-----
> >>>From: 	Cornejo, Luis
> [mailto:lcornejo at dep.anl.gov]
> >>>
> >>>
> >>>Sent:	Wednesday, March 12, 2003 2:11 PM
> >>>To:	'Michael McFadden'
> >>>Subject:	RE: [SPTUsers] installComplete.php
> >>>
> >>>I believe I encountered that problem before, and
> >>>
> >>>
> >>it was a very persistent
> >>
> >>
> >>>one. I believe if you go ahead and drop the
> entire
> >>>
> >>>
> >>database and recreate
> >>
> >>
> >>>it, it will solve the problem.
> >>>
> >>>-luis-
> >>>
> >>>		-----Original Message-----
> >>>		From: Michael McFadden
> >>>
> >>>
> >>[mailto:mmcfadden at mtc-inc.com]
> >>
> >>
> >>>		Sent: Wednesday, March 12, 2003 3:19 PM
> >>>		To: Scout Portal Users Group
> >>>		Subject: RE: [SPTUsers] installComplete.php
> >>>
> >>>			I was able to download a program called
> control
> >>>center from the mysql site.  This allowed me to
> >>>
> >>>
> >>look at my database that I
> >>
> >>
> >>>had created through a GUI and delete all of the
> >>>
> >>>
> >>tables.  With this
> >>
> >>
> >>>software I was able to figure out my previous
> >>>
> >>>
> >>question.  However I am
> >>
> >>
> >>>still getting the same error even though it
> >>>
> >>>
> >>doesn't appear I have any
> >>
> >>
> >>>tables in my database.
> >>>
> >>>			The following problems were detected during
> >>>installation:
> >>>
> >>>				Could not successfully execute SQL command:
> >>>
> >>>
> >>>				CREATE TABLE APSessions (
> >>>				SessionId INT NOT NULL,
> >>>				LastActiveDate DATETIME NOT NULL,
> >>>				INDEX (SessionId)
> >>>				);
> >>>
> >>>				(SQL error message: Table'APSessions'
> >>>already exists)
> >>>
> >>>			If anyone has any idea why I might still be
> >>>
> >>>
> >>getting
> >>
> >>
> >>>this error message it sure would save my week.
> >>>			Thanks again for the help.  Michael
> >>>
> >>>			I am having another problem with the
> >>>SPT--InstallComplete.php
> >>>			Here is what is listed on the page after I
> >>>
> >>>
> >>enter the
> >>
> >>
> >>>relevant info into Install.php and hit continue.
> >>>
> >>>			The following problems were detected during
> >>>installation:
> >>>
> >>>				Could not successfully execute SQL command:
> >>>
> >>>
> >>>				CREATE TABLE APSessions (
> >>>				SessionId INT NOT NULL,
> >>>				LastActiveDate DATETIME NOT NULL,
> >>>				INDEX (SessionId)
> >>>				);
> >>>
> >>>				(SQL error message: Table'APSessions'
> >>>already exists)
> >>>
> >>>			I am using RedHat 8.0 w/ apache or httpd ver.
> >>>2.0.40-8, php ver. 4.2.2-8.0.5, mysql ver.
> >>>
> >>>
> >>3.23.52-3
> >>
> >>
> >>>			I created a Database called SPT and didn't
> >>>
> >>>
> >>create
> >>
> >>
> >>>any tables that I know of.  I used the command:
>
> >>>
> >>>
> >> mysqladmin create spt
> >>
> >>
> >>>			Next I used the mysqladmin command to create a
> >>>
> >>>
> >>user
> >>
> >>
> >>>and password.  I am not sure how to get back into
> >>>
> >>>
> >>mysql to even verify
> >>
> >>
> >>>that the Table APSessions exists.
> >>>			After I create the username and password I
> seem
> >>>
> >>>
> >>to
> >>
> >>
> >>>be locked out.  If I try to enter a command for
> >>>
> >>>
> >>example:  mysqladmin
> >>
> >>
> >>>create whatever       I get an error of:
> >>>
> >>>
> >>mysqladmin:  connect to server
> >>
> >>
> >>>at 'localhost' failed
> >>>			error:  'Access denied for user:
> >>>
> >>>
> >>'root at localhost'
> >>
> >>
> >>>(Using password: NO)'
> >>>
> >>>			Any help would be great like what command
> would
> >>>
> >>>
> >>I
> >>
> >>
> >>>use to remove tables within the SPT database or
> >>>
> >>>
> >>how now do I login to
> >>
> >>
> >>>mysqladmin.  Or is there something else I am
> >>>
> >>>
> >>missing.  I did install the
> >>
> >>
> >>>mysql-php rpm so I am pretty sure that php and
> >>>
> >>>
> >>mysql are talking to each
> >>
> >>
> >>>other.
> >>>
> >>>			Michael McFadden
> >>>			Meeting the Challenge
> >>>			719-444-0252
> >>>
> >>>			 << File: ATT00526.txt >>  << File:
> >>>
> >>>
> >>ATT40287.txt >>
> >>
> >>
> >>
> >
> >
> >
> >>ATTACHMENT part 2 application/ms-tnef
> >>
> >>
> >name=winmail.dat
> >
> >
> >>_______________________________________________
> >>SPTUsers mailing list
> >>SPTUsers at scout.wisc.edu
> >>http://scout.wisc.edu/mailman/listinfo/sptusers
> >>
> >>
> >>
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >Yahoo! Web Hosting - establish your business online
> >http://webhosting.yahoo.com
> >_______________________________________________
> >SPTUsers mailing list
> >SPTUsers at scout.wisc.edu
> >http://scout.wisc.edu/mailman/listinfo/sptusers
> >
> >
>
> _______________________________________________
> SPTUsers mailing list
> SPTUsers at scout.wisc.edu
> http://scout.wisc.edu/mailman/listinfo/sptusers


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
_______________________________________________
SPTUsers mailing list
SPTUsers at scout.wisc.edu
http://scout.wisc.edu/mailman/listinfo/sptusers

More information about the SPTUsers mailing list