Help with MySQL/Apache2/PHP5/Life

Nija

Greetings!

I want to try out some free project management software. I gave myself a side project to test out software and see if we could implement anything. I've tried a few programs (GanttProject, Workflowy) but they did not seem to meet the requirements (Lacking milestone tracking, easy accessibility, distributed use) of software we need.


I found Collabtive http://collabtive.o-dyn.de/ , which seems to hit most of my requirements.Unfortunately, I'm not technically savvy enough to set it up. It requires MySQL. I assume this to mean it also needs Apache and PHP5.

I have a Ubuntu 12.04 Linux box sitting around (it is a test machine). I figured I could learn a little Linux/MySQL/PHP5/Apache.

I have followed this: https://help.ubuntu.com/community/ApacheMySQLPHP

The problems start arising when I have to start configuring each of them to work together.

I've got MySQL/Apache2/PHP5 installed (all done via apt-get)

For Apache2:

sudo /etc/init.d/apache2 restart

gives the following:

* Restarting web server apache2 apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
... waiting apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
[ OK ]

However when I navigate to 127.0.1.1, I receive the 'IT WORKED' page. Conflicting reports are awesome.

For Collabtive
Here is the install-readme-en.txt file:

### Requirements ###
Server:
- PHP 5.2 or higher (Recent stable build recommended)
- MySQL 4 or higher

It is recommended to run Collabtive on LAMP (Linux, Apache, MySQL, PHP) servers.
Windows Servers may work, but are not supported as well.

Client:
- Firefox 3.6, Internet Explorer 7/8/9, Opera 9/10, Safari, Chrome
- Javascript enabled

### Installation instructions ###
1. Unpack the archive.
2. Upload everything, including the empty /files and /templates_c folders, to your server.
(Optionally you need to create /templates_c and /files manually before installation.)
3. Make the following folders & files writable:
- /templates_c
- /files
- /config/standard/config.php
4. Create a new MySQL database for Collabtive.
5. Point your browser to install.php and follow the instructions given.
6. If the installation was successful, delete install.php and update.php.

I am probably in WAY over my head. Ideally I would like to get everything working together (suggestions for similar software, hopefully with easier implementation, will be looked into)

Thank you for reading this monstrosity

-N

Ramius

Take a look at http://asana.com It doesn't have Milestones per-se, but it is really flexible and it is awesome, and it is free for teams up to 30 people.

If that doesn't work for you, there's the tried-and-true Basecamp.

If that still doesn't work for you, then I'll mention I've found Redmine to be pretty good, but you are likely to find it harder, not easier to setup.

Ramius

As far as your problems with LAMP - it looks like your Apache has been launched without having been given any configuration. On a RedHat/CentOS server, you'd be looking for /etc/httpd/conf/httpd.conf. On Debian/Ubuntu - I'm not sure where that file resides. It's possible that your apt-get install created a httpd.conf.default or similar that you need to rename over to httpd.conf. Then if you edit that file you should find some decent documentation within, but also look at: http://httpd.apache.org/docs/2.2/vhosts/index.html

You'll need to create a virtual host in your httpd.conf and point it at the directory where you unzipped Collabtive.

As far as creating the MySQL database goes, you may be able to get away with just running mysql -u <adminuser> -p from the commandline, and then once connected run:
mysql> CREATE database Collabtiv;
mysql> exit;

Nija

Thank you!