Install ERRORs

Ask your questions regarding TimeTrex installation here.
Locked
Street14
Posts: 9
Joined: Wed Nov 22, 2006 4:53 pm

Install ERRORs

Post by Street14 »

Ok i have followed the instructions fairly well.
I have pear and soap installed with out any problems.
I am running PHP5.0.3
Mysql 4.1.10a
The install check script tells me that this version is fine.
The sys requirements are stating PHP 5+
So i meet this
My check script tells me that all is fine no errors reported.
Install script to test database user tells me connection test is good.
I have granted all privileges on this user.
And have even supplied root and password to DB privileged user
at the bottom of that page in case for some reason it should fail.
I am running Apache 2.0.53
When i click on the next button to actually start the install
i Keep getting nothing showing up
At the same time it is crashing the apache server with memory unwritable error.
Now i know there is nothing wrong with the db or the server
as i run multiple things on that server and db frequently and never have a problem.
So i go to try and install the database by hand.
But here again can not do that as the sql files seem to be in the
classes/modules/install/sql/mysql folder
Yet when i either try to run the batch file 1000A.sql
The sql syntax is incorrect in both navicat and phpmyadmin

Ok can someone supply a manual way of loading the datbase as there seems to be something wrong with the web install method.
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

Re: Install ERRORs

Post by mikeb »

Street14 wrote:Ok i have followed the instructions fairly well.
I have pear and soap installed with out any problems.
I am running PHP5.0.3
Mysql 4.1.10a
The install check script tells me that this version is fine.
The sys requirements are stating PHP 5+
So i meet this
My check script tells me that all is fine no errors reported.
Install script to test database user tells me connection test is good.
I have granted all privileges on this user.
And have even supplied root and password to DB privileged user
at the bottom of that page in case for some reason it should fail.
I am running Apache 2.0.53
When i click on the next button to actually start the install
i Keep getting nothing showing up
At the same time it is crashing the apache server with memory unwritable error.
Now i know there is nothing wrong with the db or the server
as i run multiple things on that server and db frequently and never have a problem.
So i go to try and install the database by hand.
But here again can not do that as the sql files seem to be in the
classes/modules/install/sql/mysql folder
Yet when i either try to run the batch file 1000A.sql
The sql syntax is incorrect in both navicat and phpmyadmin

Ok can someone supply a manual way of loading the datbase as there seems to be something wrong with the web install method.
Creating the database manually isn't recommended. TimeTrex does other things in the installer that the .SQL files won't do. Something else is the issue.

Right off the bat, because your Apache is crashing I would recommend upgrading PHP. PHP v5.0.3 is quite old and contains several bugs that could be causing the issue. You can check your PHP error logs for more information as well perhaps.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Street14
Posts: 9
Joined: Wed Nov 22, 2006 4:53 pm

Post by Street14 »

Well that would be ok to upgrade php as at some point or another i had that on the schedule to do.
What does not sit well is you say.
Creating the database manually isn't recommended. TimeTrex does other things in the installer that the .SQL files won't do. Something else is the issue.
My web servers run just fine with any other application.
I have yet see a apache server crash in this way with over 2000 differnt web applications i have used and installed either to run or too test.

What are the other things that the install is doing.
These are more likely the problem.
If its trying to change the way the server is set up to run.
Then we need to do this to make sure either we want to run this application test this application or reset the server environment.
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

Post by mikeb »

Street14 wrote:Well that would be ok to upgrade php as at some point or another i had that on the schedule to do.
What does not sit well is you say.
Creating the database manually isn't recommended. TimeTrex does other things in the installer that the .SQL files won't do. Something else is the issue.
My web servers run just fine with any other application.
I have yet see a apache server crash in this way with over 2000 differnt web applications i have used and installed either to run or too test.

What are the other things that the install is doing.
These are more likely the problem.
If its trying to change the way the server is set up to run.
Then we need to do this to make sure either we want to run this application test this application or reset the server environment.
TimeTrex makes use of quite of bit of PHP v5's new OO features, which is why it requires PHP v5 in the first place. Because of this earlier versions of PHP v5 may have some issues dealing with it. Very few other popular web applications use these features which is why you probably don't see the crashes with them.

PHP v5.0.3 is really quite old, however TimeTrex doesn't support PHP v5.2.0 just yet either, so I recommend PHP v5.1.6 if possible.

No matter what your web server shouldn't be crashing, its not a TimeTrex issue, its a PHP/Web server issue, so my best guess at this point is to upgrade.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Street14
Posts: 9
Joined: Wed Nov 22, 2006 4:53 pm

Post by Street14 »

Well i have to set sometime up to do that. Ill give it a whirl and see what happens. Ill post back when i recompile apache and php with other stuff i have in apache and post back when its done just in case it does correct the issue. It would give others a heads up on possible problems they are having.
It will be about a week to set sometime up to do this.
Locked