Topic: Groupware - phprojekt howto and rpm now available

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