Topic: PHPGroupware On SME 6.0

[cosy]

Hi All,

  I'm trying to install RequestedDeletion "How-to install phpGroupware" but it's only for SME 5.X.

anyway i try to test with SME 6.0, i need someone to help from STEP 3: Setting up the application
(from phpgroupware root)
   # mkdir files
   # mkdir files/groups
   # mkdir files/users
-----------------------------------------------------
   # chown www:www
   files (note: this assumes your webserver runs as user www, adjust for your installation)

can someone help with this, i was stuck
------------------------------------------------------

   # chmod 700 files
-----------------------------------------------------  
   Root Directory (Not recommended) - If you give the webserver account
   write access to the phpgroupware directory, then the setup program can
   create the header.inc.php for you. Otherwise you will need to use the
   setup program to create it, and then you can manually save it to file.
   
   If you want to do it:
   
   # chown :www phpgroupware
   # chmod 770 phpgroupware

What is this totally confuse
------------------------------------------------------

STEP 3: Make the application available from
   https://www.yourdomain.com/group
   
   -         You don't want to create an iBay that will expose all the
   files, but instead a http alias to the /opt/phpgroupware directory
   
   -         Create a template fragment for httpd.conf
   
   -         Enter as root on the console: touch
   /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/98phpgroupware

above command not create this file, i just check there is no /httpd/conf... folder.

please help me to install this groupware on my SME 6.0.

[k_graham]

This may be easier for you. I used this method to install phpproject, but its a older version, which then needs to be updated.

http://www.marari.net/downloads/phprojekt/phprojekt-howto.htm

After the install I did an upgrade to the latest version from phprojekt.com

This has the advantage that uploads worked where as when creating to an IBay they did not work.

Then I did an update phproject came out with a couple months back which fixed some options. The one I noticed most was the ability to print out notes completely.

Next I used a content management system add on and a theme called Brass also available from phprojekt.com. I like this add on as standard themes still work but the Brass Theme lets you run all the options and have them fit on a older monitor. It also lets you see if someone else is online which is a real moral booster after creating a site to see it actually being used.

I tried a autopassword creation program for phprojekt but it seemed to create separate user spaces which were not interactive so I don't recommend trying that add on.

Where to worry most is backing up the database, which is why I would actually recommend you use 5.6 of e-smith, then use backup2ws which is not fully functional on 6.0. and though I managed a backup I have never braved a restore.

Ken

[cosy]

Hi Can someone help to install phpgrouware into ibay not to primary ibay.

[cranky]

Hi Cosy!
I've installed egroupware several times with no problem.  
I know it's not phpgroupware, but it is derived from it (and the setup is similar).  Perhaps this will work for phpgroupware...
1) create an ibay for EGW
2) download the zip file for either a release candidate (RC) or 1.X depending on when you read this.  You can store it in the /files folder of your ibay for now.  Check the md5 signature.  If it doesn't match, try a different site.
3) download and READ the install manual.  
4) create a mysql db for EGW (as shown in the manual).  Alternately follow the MySQL db creation process outlined in the popular OSCommerce install howto (I don't remember the name of the contrib off the top of my head or I'd put it here.  I want to say it was by someone named Jensen...).
5) create an SME account for the EGW administrator
6) Unzip the file in the /files folder of the ibay.  You should wind up with a new subdirectory called egroupware containing all of the files.
7) You can either copy the entire egroupware folder to the /html folder or copy the contents.  I copy the whole folder to minimize potential path naming problems and then redirect directly to the subdirectory.  When you update in the future, you can then either CVS from this folder or copy the newly unzipped files over this folder.
run the setup process per the manual
9) use the account name from 5 as your administrator
10) Make suitable changes from the normal redhat install in the manual to the SME ibay paths where appropriate.  You can install this in an ibay with no sweat.  Again, keep your paths straight in the setup process.
11) Unless I've forgotten something, you can now enjoy the app!  Add SME accounts for each new user.
12) you may wish to add an .htaccess file to your folders to force SSL mode when accessing EGW to hide the passwords from sniffers.  You can also use the SME provided ibay password for a two stage authentication process.
13) You can clean up the /files folder if you wish.
14) If this helps, and/or corrections are needed, please post updates from your experience and maybe we can turn this into a proper how-to...
Enjoy

[anSMEfan]

Cranky,

Thanks for making a start. I haven't been able to follow it through to the end though - I guess a dummy like me needs a bit more detail  

Step 1 - Who gets access to the ibay? This affects the permissions on files dropped into the ibay. Is there a 'write' group to be created first, containing the user from 5? In that case, should 5 be before 1?

Step 4 - The install manual says that the setup script can create the database. Does this work?

Step 6 - unzip the files. Should this be done on the console (as root) or over the SMB share as the user from 5? Or maybe FTP?

Step 7 - Just checking, what does 'redirect directly to this folder' mean? Do you mean an http redirect?

Step 8 - there are issues running the setup, depending on the rights and file ownership created in 6. I get a 403, or the setup loops back to a logon screen, depending on what I did in 6. Are there any extra steps to take before running the setup?

Step 9 - which administrator? There appear to be three administrators in the header.inc.php setup screen - for header, DB and Config. I'm guessing Config, correct me if I'm wrong. In that case, what do you use for the other admins?

I'd like to get this up and running but so far, no success.

[cranky]

Sorry - I've been away from the forums for a while...
1) It depends on how you wish to deploy it.  For an internet setup, you would say group:everyone, access:write/group read/everyone, public access:entire internet (you may wish to select pwd required to provide an extra level of security), cgi:enabled.   See this thread for more info... http://forums.contribs.org/index.php?topic=21361.msg84559#msg84559
 
4) It may, but I create the db manually.  Scripts may expect the normal redhat dir structure and have no concepts of ibays, so I typically do things manually on an SME...  DB creation may not be affected by this though...  Create the db as described by the OS Commerce how-to by Craig Jensen.  See this thread - http://forums.contribs.org/index.php?topic=21361.msg84559#msg84559

6) Do this as root in the /files folder.  This unzips the image into the egroupware folder that was described.  You can delete this stuff after installation is done.

7) By re-direct, I was referring to
a) what you might put in your DNS records if you get a unique domain name for this application.  You would then setup your records for domain.com to go to this sub-folder if you wished.  
b) create an index.htm page that http redirects to the subfolder.  Access to this ibay COULD be password protected if you desire for a two-stage login (see comment 1).  The .htaccess file in the subfolder could force the users into SSL mode so that the subsequent usernames/passwords are encrypted.  

Again, think about how you want to USE this system and how to SECURE it for your users (check the threads above for more comments and read the EGW install instructions) before you install the app.

 If you create the db as root and unzip and copy the folders as root, you shouldn't have any problems...

9) You are creating an account for the EGW admin which also creates the admin email address, etc.  This admin controls all three setup functions in EGW.  You should be following the EGW install manual at this point since the scripts you invoke will install everything properly at this point (or at least they used to).  If you have problems logging in ("...looping back to a login screen..."), look at the header.inc.php file in the main EGW folder.  This will have the passwords stored in it that you entered before.  Match the correct pwd to the login screen and you should be in the setup scripts in no time.  EGW allows multiple instances/domains to be installed also.  Be sure you are entering the correct password for the correct domain if you started experimenting...

I hope this helps.  If it doesn't, I'll run though the entire process from scratch and write a proper how-to.  I had hoped that the feedback from the other threads would have done some of the field testing of these instructions though...  Perhaps you could post your feedback when you get this working!?