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

[Andy parkinson]

Thanks for that Ari I had managed to work out the chief rights bit but the problem that is still beating me is the files upload. the error I get is as follows

Oops! Something went wrong ...
Please check whether the file exists in the upload directory
(Maybe the webserver is not allowed to copy the file from the tmp dir into the upload dir)
and the variable dat_rel in the config has the correct value.
Typical values would be:
dateien = "/usr/local/httpd/phprojekt/file"; and dat_rel = "file"; for Linux or /opt/project/upload = "c:\htdocs/phprojekt/file"; and upload = "file"; for windows


Ari Novikoff wrote:
>
> 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

[Ari Novikoff]

> Typical values would be:
> dateien = "/usr/local/httpd/phprojekt/file"; and dat_rel = "file"

In the 70filemanager fragment of config.inc.php you'll find the following info:
// file manager
$dateien = "/opt/project/upload";
                                // File management no = leave empty,  yes = insert full path
$dat_rel = "upload";            // Relative path to the PHProjekt directory
$dat_crypt = "1";               // Scramble filenames - 0: no, 1: yes

You'll need to create a directory called "upload" in /opt/project since it's not there. Oops! Oversight on my part...

# mkdir -p /opt/project/upload

That should solve the problem.

Ari

[Andy Parkinson]

Tried this as well Ari with no joy



Ari Novikoff wrote:
>
>
> > Typical values would be:
> > dateien = "/usr/local/httpd/phprojekt/file"; and dat_rel =
> "file"
>
> In the 70filemanager fragment of config.inc.php you'll find
> the following info:
> // file manager
> $dateien = "/opt/project/upload";
>                                 // File management no = leave
> empty,  yes = insert full path
> $dat_rel = "upload";            // Relative path to the
> PHProjekt directory
> $dat_crypt = "1";               // Scramble filenames - 0:
> no, 1: yes
>
> You'll need to create a directory called "upload" in
> /opt/project since it's not there. Oops! Oversight on my
> part...
>
> # mkdir -p /opt/project/upload
>
> That should solve the problem.
>
> Ari

[Ari Novikoff]

Andy Parkinson wrote:
>
> Tried this as well Ari with no joy
>

# chown www:www /opt/project/upload
# chmod 777 /opt/project/upload

This does work as I've tested.

Of course, I'm open to other suggestions in limiting just how wide you need to actually open up that directory...

Ari

[Andy Parkinson]

Thanks Ari that did the trick

Ari Novikoff wrote:
>
> Andy Parkinson wrote:
> >
> > Tried this as well Ari with no joy
> >
>
> # chown www:www /opt/project/upload
> # chmod 777 /opt/project/upload
>
> This does work as I've tested.
>
> Of course, I'm open to other suggestions in limiting just how
> wide you need to actually open up that directory...
>
> Ari

[Lazo]

I have no problem with the instalation!! but when i try to connecto to the server
http://mydomain.com/project i have an error

Database connection failed!
Call admin, please.

I enter mysql and type connect project, and the database exists!!

what can I do??

I have SME 5.0 update 4

[Ari Novikoff]

Lazo wrote:
>
> I have no problem with the instalation!! but when i try to
> connecto to the server
> http://mydomain.com/project i have an error
>
> Database connection failed!
> Call admin, please.
>
> I enter mysql and type connect project, and the database
> exists!!
>
> what can I do??
>
> I have SME 5.0 update 4

Did you ever change the password for the root user in MySQL?
If you did, that's the reason it can't connect. You'll have to go about doing some manual editing in the /etc/e-smith/template/opt/project/config.inc.php directory to make sure that it passes the correct password on to MySQL.

Ari

[Lazo]

Forgive for what I'm gonig to say, but I don't know the password for mysql, and I don't know how to change it!! I never touched it!

[Lazo]

How can I know my mysql password, or how can I reset it, so I can use this project thing??

Thanks

[Ari Novikoff]

You don't need to know it. It is automatically derived from your /etc/openldap/ldap.pw file.

[Lazo]

Oh well!!! I'll try with a clean install of SME!!

[Todd Pearsall]

Lazo wrote:
>
> How can I know my mysql password, or how can I reset it, so I
> can use this project thing??
>
> Thanks

You can search for the threads on mysql password and find the basic info.  The short version is the file .my.cnf in your /root directory (use ls -al to see it).  In there is the install mysql password for root (long nasty generated string).  Don't change the password or you'll break other stuff.  From what I understand phprojekt will use this password, but don't know for sure since I've never installed it.

Hope this helps a little.

- Todd

[Bala]

Thanks ....Ari Novikoff

I installed the RPM and it works wonderful...

Thanks again...........

Bala

[glenn pettit]

this is great has anyine tried WAP support or the syn-outlook tool yet.

[Craig Jensen]

Firstly, to Ari Novikoff, this is a great help to us all to have the "Projekt" package available in .rpm esp for e-smith!!!

Lazo, what you will soon learn with this and other forums...do some research and then begin asking.  I myself am just learning the wonder of Mysql and PHP and what they can do.

Here's how I solved the same issue as yours:

You have changed your Mysql password (at least it seems so).  Go here to reset your root password
http://i4net.tv/marticle/get.php?action=getarticle&articleid=9

Now, the package which Ari has put together is created with templates.  For future useage of E-smith you must learn about them.

Anyway, now if you have your root password changed and in memory, do the following...
pico -w /etc/e-smith/templates/opt/project/config.inc.php/10database

remove this:  
          {
open (PW, "/etc/openldap/ldap.pw")
         || die "Could not read LDAP password.\n";
my $pw = ;
chomp ($pw);
close PW;
$OUT .= "$pw";
 }";

Replace with: $db_pass = "your_password_you_just_set ";   // Database password

Then do the expand-template thing... /sbin/e-smith/expand-template /opt/project/config.inc.php

Now try to logon again with 'root' and 'your_password_you_just_set'  Worked for me.  In my attempts to solve the issue I HAD changed my Mysql password

[Jean]

Great stuff, Ari!  It was a breeze to install on SME 5.12 and has been running stable for about 2 weeks now.  I still consider myself to be a newbie, so please excuse my ignorace on the following question.  Is it difficult to install the "receive" portion of the mail codes?  If so, I will consider adding a different "webmail" module.  If it's as easy as setting up your phprojekt rpm, can you please tell me the steps?  Receive mail capability would really put a finishing touch on this...

Thanks,
Jean

[uninstall]

how would i uninstall this program sence i am not able to use the php syn....

[andrew]

I have sucessfully installed this app however I'm having a problem with files.

I can upload files ok (by creating the upload folder and giving permissions to it) but when I try to open/download the file I get the following error:

"Internet Explorer was not able to open this internet site. The requested site is unavailable or cannot be found."

Any indeas??

[AusMounty]

An issue I am having regarding phprojekt is as such:

a number of PowerPC's connected to a 5.6 server (I know but all the people have been given)

1 windoze 98SE laptop

All can use the ibay set as a shared folder... but recently loaded projekt but admin login will not allow me to create a new project. This is important as it is for a non-profit organisation that requires this function.

I have loaded it on my own server here at home without a problem.

Any ideas?

Thanks in advance...

Ausmounty

[Paul Andersen]

Ari

I have just completed the install following your HOW TO & the various "support" threads from these forums.

I do have a question which does not appear to be answered here ... the email that is sent to anyone who raises an RTS is as follows

Dear customer, please refer to the number given above by contacting us.
Will will perform your request as soon as possible.

Request: Test
Test

I would like to be able to correct the wording but can't find where it is to be found ... are you able to assist.

Cheers

Paul

[allant]

Hi All
the how to are very good.
but have problem of getting projekt to recieve email too.
this is what i get, anyone have have the same problem please, is this a SME problem or a projekt problem ?
thanks in advance
allant

Access error for mailbox myname!:
Certificate failure for mysite.com: self signed certificate: /C=--/ST=----/L=Ottawa/O=XYZ Corporation/OU=Main/CN=mysite.com/Email=admin@mysite.com

[Ken]

Hi Ari;

I installed phprojekt yesterday on 6.03 and it looks to be there and workable within the same limitations -

I was wondering how come I couldn't add a project until I read these threads and saw the requirement to be a manager and not administrator.

Where I am having some difficulties is viewing it remotely. It seems the rpm does it differently than tyrone miles in that his suggestion was putting it in a ibay.  I have no troubles in the office running locally. Is there specific settings to suggest in the administration, remote access manager of e-smith, such as settings for secure shell, or ftp or ssh or ?

Also any ideas about setting up 2 of these on the same e-smith server. Would you then recommend a installation as put forth by Tyrone Miles where the 2nd installation would be in a i-bay.

Thanks, Ken

[Peter]

Hi Allant

Yes we have the same problem as you with the same error message
Access error for mailbox myname!:
Certificate failure for mysite.com: self signed certificate: /C=--/ST=----/L=Ottawa/O=XYZ Corporation/OU=Main/CN=mysite.com/Email=admin@mysite.com

If you get a fix please add it it to this list

Many thanks
Peter

[Ken]

This phprojekt codegives me error 1046 no database selected

Luke Drumm wrote:

> 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.
>

but for me they don't  because I get the error saying no database selected,

any ideas what else I need to do. Also I save the above in 2 text files that I brought into the server but how to paste them into MySQL??

Thanks, Ken

[Paul Andersen]

Ken

I had quite some problem with this install of PHprojekt and choose to uninstall it and install the iBay sollution ... you can download the version I used from my web site at http://www.mrcomputer.co.nz/downloads/SME-Server/phpProjekt/

Also after installing as per the HowTo make sure you follow this

PHP applications running in i-bays can only access files within the same i-bay. Is there a way that the administrator can relax this restriction?

Yes. The administrator can change the PHP Base Directory by executing the following commands (as root):

   
/sbin/e-smith/db accounts setprop your_i-bay_name PHPBaseDir /    
/sbin/e-smith/signal-event ibay-modify your_i-bay_name

Note that the PHPBaseDir argument can be more restrictive than the example shown above. For example PHPBaseDir can also be '/home/e-smith/files/'.

Now you should be up and running.