Topic: Groupware - phprojekt howto and rpm now available

[Ari Novikoff]

I've noticed a rather high interest in groupware applications as of late and I came across a howto on the e-smith contrib site from Tyrone Miles on phprojekt.

It's an excellent web-based application and I've automated a lot of the installation into an RPM.

A new "how-to" can be found at:
http://www.marari.net/downloads/phprojekt/phprojekt-howto.htm

The RPM is avaible from:
http://www.marari.net/downloads/phprojekt/devinfo-mitel-phpprojekt-1.0-01.noarch.rpm

And the Source RPM is availabe from:
http://www.marari.net/downloads/phprojekt/devinfo-mitel-phpprojekt-1.0-01.src.rpm

As always, it's GPL and freely distributable. If you have any questions/comments or want to contrib, please email me.

Cheers!
Ari Novikoff
Marari Network Solutions
http://www.marari.net

[Robert Heaton]

Hi!

I'm running your latest RPM (1.0-01) on SME 5.5ALPHA, and it works great!

Thanks for this great RPM,


Rob.

[Ari Novikoff]

Excellent! Thanks for the feedback

Ari

[jc]

Thanks Ari for the great HowTo. I installed  phprojekt rpm without any problem. But when I try to log in with as admin  I get this error
"Sorry you are not allowed to enter"
Installed under SME 5.1.2 w/update_1

Thanks
John

[Ari]

jc wrote:
>
> Thanks Ari for the great HowTo. I installed  phprojekt rpm
> without any problem. But when I try to log in with as admin
> I get this error
> "Sorry you are not allowed to enter"
> Installed under SME 5.1.2 w/update_1

Did you make certain that the password you were using to connect was correct?

[jc]

Thanks for your prompt response, admin and the password work fine when used on other normal   login i.e server-manager, root, imp.

Thanks
JC

[Ari]

jc wrote:
>
> Thanks for your prompt response, admin and the password work
> fine when used on other normal   login i.e server-manager,
> root, imp.


Username: admin
Password: password

when I say Password: password, I mean to physically use "password" as the password.

Let me know if that solves your problem.

[jc]

You are  the Man, It works like a Champ, Sorry for that.

Cheers
Jc

[Ari Novikoff]

jc wrote:
>
> You are  the Man, It works like a Champ, Sorry for that.
>
> Cheers
> Jc

No worries. Guess I could have been a bit more clear about using "password" as the password. That's feedback to take away.

Glad it's working for you!

Cheers!
Ari

[jc]

Just quick question? Is the Time sheet System Module included with version of PHProjekt, it does not seem to appear with other navagational button.

Thanks
JC

[Andy parkinson]

This is wonderfull Ari Just what I was looking for. A couple of small problems though.

1. It won't let me upload any files and come back with a message which leads me to believe I need to define an upload directory and
2.I can't creat a project as that part of it seems to be greyed out.

Once again thanks for an excellent howto

[Ari Novikoff]

Edit the timesheet template and turn it on.

# pico -w /etc/e-smith/templates/opt/project/config.inc.php/40timecard

change:
$timecard = "0";

to:
$timecard = "1";


Save and exit, re-expand the template.
# /sbin/e-smith/expand-template /opt/project/config.inc.php

There ya go. Timecard system should be working now.

Ari

[Ari Novikoff]

Andy parkinson wrote:
>
> This is wonderfull Ari Just what I was looking for. A couple
> of small problems though.
>
> 1. It won't let me upload any files and come back with a
> message which leads me to believe I need to define an upload
> directory and
> 2.I can't creat a project as that part of it seems to be
> greyed out.
>
> Once again thanks for an excellent howto

1. What is the message it comes back with.
2. To create a project, the user must have "chief" rights. I know.. "but I'm an admin!. ...." doesn't matter. Figured that out the hard way. Seems that they designed the admin account to be -just- for administration. The other 2 levels, user and chief are the ones that can actually do stuff.

Ari

[Luke Drumm]

Hi,

For anybody who found that the timecard tables were missing when they tried to enable the timecard feature, here's how to add them from the command line:

Type:
mysql

Paste the following two commands into mysql:

CREATE TABLE timecard (
  ID int( default NULL auto_increment,
  users varchar(255) default NULL,
  datum varchar(10) default NULL,
  projekt varchar(20) default NULL,
  anfang varchar(4) default NULL,
  ende varchar(4) default NULL,
  out_begin varchar(4) default NULL,
  out_end varchar(4) default NULL,
  out_begin2 varchar(4) default NULL,
  out_end2 varchar(4) default NULL,
  note varchar(40) default NULL,
  div1 varchar(40) default NULL,
  div2 varchar(40) default NULL,
  PRIMARY KEY (ID)
) TYPE=MyISAM;


CREATE TABLE timeproj (
  ID int( default NULL auto_increment,
  users int(4) default NULL,
  projekt int(4) default NULL,
  datum varchar(10) default NULL,
  h int(2) default NULL,
  m int(2) default NULL,
  kat varchar(255) default NULL,
  note varchar(40) default NULL,
  ext int(2) default NULL,
  div1 varchar(40) default NULL,
  div2 varchar(40) default NULL,
  PRIMARY KEY (ID)
) TYPE=MyISAM;

Type:
quit

And viola! Timecards should now work.

Regards,
Luke

[Ari Novikoff]

Thanks Luke Good feedback - I'll add that to the howto.

Ari