Koozali.org: home of the SME Server

Group Office - A howto

duncan

Group Office - A howto
« on: January 27, 2007, 04:23:13 AM »
A group-office howto.

Create the relevant directories like so. Keep an eye out for word wrapping . New lines are marked with a #.

Code: [Select]
# mkdir /opt/groupoffice
# cd /opt/groupoffice
# mkdir html files tmp
# mkdir html/local
# chmod 0775 files tmp
# chmod 0775 html/local
# chown -R admin.www *
# touch /opt/groupoffice/html/config.php
# chmod 0666 /opt/groupoffice/html/config.php


If you would like to use accelerators such as eaccelerator and mod_deflate you grab them from vanhees.

eaccelerator
mod_deflate

Download the most current version of Group office from here and extract and install as follows. The current version of Group office is 2.16-8 - please adjust your paths as required.

Code: [Select]
# tar -xzvf groupoffice-com-2.16-8.tar.gz
# cd groupoffice-com-2.16-8
# cp -r . /opt/groupoffice/html


Create a web template as follows.

Code: [Select]

# mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
# cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
# nano 87groupoffice


Paste in the following. Use a Control-x to save the fragment.

Code: [Select]

# groupoffice
Alias /groupoffice /opt/groupoffice/html
<Directory /opt/groupoffice/html>
    SSLRequireSSL on
    Options -Indexes
    AllowOverride None
    order deny,allow
    deny from all
    allow from all
    Satisfy all
    AddType application/x-httpd-php .php .php3
    php_admin_value eaccelerator.enable 1
    php_flag  magic_quotes_gpc  on
    php_flag  track_vars        on
</Directory>


Expand the template like so.

Code: [Select]

# expand-template /etc/httpd/conf/httpd.conf
# /etc/rc.d/rc7.d/S86httpd-e-smith restart


Create the database.


Code: [Select]
[root@mail]# mysql
mysql> CREATE DATABASE goffice;
mysql> grant all on goffice.* to goffice@"localhost" identified by "password";
mysql> flush privileges;
mysql> quit
Bye


Browse to https://ipaddy/groupware and fill in the details.

For the mysql portion - choose the option to use an existing database and use the the values you applied during the mysql setup.

Use the /opt/groupoffice/files/ and /opt/groupoffice/tmp/ to replace the suggested locations in the web config.

When you get to the mail setup during the web config - use the qmail interface. I can confirm that both the imap and pop3 clients work under group office.

Because this setup allows connection to the interface from external sources it is important that you make changing the admin password a first priority.

duncan

Group Office - A howto
« Reply #1 on: January 27, 2007, 09:36:27 AM »
For those of you that would prefer to do your work in a popup window (so it fills the screen) - add this code to a linking web page.

In <head>

Code: [Select]
<SCRIPT LANGUAGE="JavaScript">
function popUp(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=800,height=600,left = 0,top = 0');");
}</script>


And at an appropriate place in <body>

Code: [Select]
<a HREF="javascript:popUp('https://ipaddress/groupoffice')">Open Group-office</a>

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Group Office - A howto
« Reply #2 on: January 28, 2007, 02:59:55 AM »
When I try to install, after the first page it goes:
Code: [Select]
https://192.168.0.1/groupoffice/install/install.phpgroupoffice/install/install.phpgroupoffice/install/install.phpgroupoffice/...

duncan

Group Office - A howto
« Reply #3 on: January 28, 2007, 03:17:43 AM »
Quote from: "stuntshell"
When I try to install, after the first page it goes:
Code: [Select]
https://192.168.0.1/groupoffice/install/install.phpgroupoffice/install/install.phpgroupoffice/install/install.phpgroupoffice/...


Hmmm - odd. I`ve just done another install to test the howto and it works fine in both IE and Firefox. Do you have an external link for the web page so I can have a look?

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Group Office - A howto
« Reply #4 on: January 28, 2007, 09:18:08 PM »
Duncan,
Please forgive me, that problem was unrelated to your contrib.
I have created a new bug http://bugs.contribs.org/show_bug.cgi?id=2392
This was due to an upgrade of selintra sail to the latest version, downgrading it fixed.

Thanks,

Reynolds

GroupOffice got it working I think
« Reply #5 on: February 03, 2007, 04:38:29 AM »
I'm running SME 7.1 all updated.

Is this right or am I doing something wrong?

I have to first put the users in GroupOffice before I load them as SME users or GO will say email account already exist and will not let me continue unless I put in a different email address.

Thanks in advance!

duncan

Re: GroupOffice got it working I think
« Reply #6 on: February 03, 2007, 06:49:18 AM »
Quote from: "Reynolds"
I'm running SME 7.1 all updated.

Is this right or am I doing something wrong?

I have to first put the users in GroupOffice before I load them as SME users or GO will say email account already exist and will not let me continue unless I put in a different email address.

Thanks in advance!


Go users and SME users are in no way related to each other with a default install. GO users are stored in a sql database and SME users are standard linux users.

I can confirm that existing SME users will not affect addition of the same in GO.

Offline soprom

  • *
  • 589
  • +0/-0
    • www.logiciel-libre.org
Group Office - A howto
« Reply #7 on: February 06, 2007, 02:09:05 AM »
Very fine product!
Thanks for this easy Howto !
Sophie from Montréal

hyperfocused

"sync" option/directory completely missing.
« Reply #8 on: February 06, 2007, 05:48:34 PM »
Has anybody else noticed that, with this particular installation, the "sync" options & directory are completely gone?

Is that on purpose?

Offline del

  • *
  • 765
  • +0/-0
Group Office - A howto
« Reply #9 on: February 06, 2007, 06:15:30 PM »
Hi All,

Quote from: "hyperfocused"
Has anybody else noticed that, with this particular installation, the "sync" options & directory are completely gone?

Is that on purpose?
That's because the Sync options are only available in the paid for Pro version, see here: http://group-office.com/index.php?site_id=1&file_id=418 Which brings to my question, does anyone know if the Pro version is the same install process as this Open Source one? They say that you can upgrade from the Open Source version to Pro OK so I assume that this would work with SME.  8) I have setup a 30 day trial with Group Office and tried the synchronizing with Outlook and it seems to work perfectly. :D

Regards,
Del
If at first you don't succeed, then sky-diving is not for you!
"Life is like a coin. You can spend it anyway you wish, but you can only spend it once." --Author Unknown

hyperfocused

Group Office - A howto
« Reply #10 on: February 06, 2007, 06:19:02 PM »
Oh...derp de derp.  My bad - sorry.  hehe.

Quote from: "del"
Hi All,

Quote from: "hyperfocused"
Has anybody else noticed that, with this particular installation, the "sync" options & directory are completely gone?

Is that on purpose?
That's because the Sync options are only available in the paid for Pro version, see here: http://group-office.com/index.php?site_id=1&file_id=418 Which brings to my question, does anyone know if the Pro version is the same install process as this Open Source one? They say that you can upgrade from the Open Source version to Pro OK so I assume that this would work with SME.  8) I have setup a 30 day trial with Group Office and tried the synchronizing with Outlook and it seems to work perfectly. :D

Regards,
Del

Offline Amir Inbar

  • *
  • 113
  • +0/-0
    • http://www.sheroot.net
Group Office - A howto
« Reply #11 on: February 07, 2007, 07:35:33 AM »
I think that the 30-day version is different from the open source version.
They say you can use the SYC module only in the paid version.

This software is very nice and almost brings me to be able to replace my customers exchange servers since it supports Hebrew and right to left text "out of the box".
But as long as the syc feature will be closed - this will not be an option for me since i want to relay on open source and open source software ONLY.

Yes - i know they use syncML for the client but what do they use at the server side ?


Does anybody know a similar server that is fully open source ?
......

Offline p-jones

  • *
  • 594
  • +0/-0
Group Office - A howto
« Reply #12 on: April 07, 2007, 11:56:52 AM »
Great HowTo. I have been using this on my 7.1.3 for a while now without issue. Of the various groupware products this seems to be the best and co-exist better than most on SME V7.

Thanks from down under...

P
...

Offline Per

  • *
  • 63
  • +0/-0
    • Bends - better on the internet than in reality
HowTo in Wiki
« Reply #13 on: April 19, 2007, 11:37:24 PM »
I've tested this soft and made a (simple) HowTo in the Wiki.
Please edit if you have improvements.
/Per
NO! I refuse to put some clever latin sentence here!

Offline berdie

  • *
  • 237
  • +0/-0
Group Office - A howto
« Reply #14 on: April 22, 2007, 12:11:58 AM »
Thanks per,
I have improved your wiki howto as follows:
http://wiki.contribs.org/GroupOffice
Interested people can download a RPM-based solution as a single package.

Have fun !

Dietmar

Offline cool34000

  • *
  • 339
  • +0/-0
Group Office - A howto
« Reply #15 on: April 25, 2007, 02:51:58 AM »
Hi there !

Thanks berdie for your rpm!

I installed the rpm and noticed that the files inside /opt/groupware/html are owned by 1000:1000
This is a decompression issue, they should be owned by root:root

By the way duncan, why choosing user 'admin' instead of user 'root' ?
I guess this is the proper way in ibays, but shouldn't it be root in /opt ?

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Group Office - A howto
« Reply #16 on: April 25, 2007, 01:20:59 PM »
/opt can be owned by any user or group.

Offline imcintyre

  • *
  • 609
  • +0/-0
Group Office - A howto
« Reply #17 on: April 25, 2007, 03:19:56 PM »
Berdie;

Thx, worked well

Ian

Offline cool34000

  • *
  • 339
  • +0/-0
Group Office - A howto
« Reply #18 on: April 25, 2007, 03:45:33 PM »
Quote from: "stuntshell"
/opt can be owned by any user or group.

Looking for default webapps in my /opt directory gave me this :
- MasterSleepy use root:root for his phpmyadmin multiuser contrib
- DMay use root:root for his phpsysinfo and phpmyadmin contrib
- Dungog use root:root for torrentflux (some custom chown www:www for some folders and files)
- schirrms use root:root for his ModIndex contrib

So well... Here was my question... Admin is not conventionnal, so does user 1000 !
No big deal !

Offline kevinb

  • *
  • 237
  • +0/-0
Group Office - A howto
« Reply #19 on: May 01, 2007, 12:51:16 AM »
I tried this contrib and it works great.

I have just one issue. I cannot get Group Office to authenticate via IMAP. I have tried every conceivable combination of settings in the "auth_sources.inc" file but no luck.

I would love to just have to add one user and password to SME and then have it used to create an account in GO (just like in eGroupware and Roundcube).

Anyone get this to work?


Thanks


Kevin

Offline imcintyre

  • *
  • 609
  • +0/-0
Group Office - A howto
« Reply #20 on: May 01, 2007, 04:30:56 AM »
kevinb;

Sounds like two issues not one, authenticating and adding users but perhaps I misunderstand.

I cannot help with your adding users question.

Re authenticating, are you having troubles with the certificate because there is an option on the account set up page to select "dont validate"

Hope I'm not too far off base.

Offline kevinb

  • *
  • 237
  • +0/-0
Group Office - A howto
« Reply #21 on: May 01, 2007, 06:43:56 AM »
Let me clarify.....

I do not want to add users to the SME user page (for VPN, File Sharing, etc) and have to also add them to Group Office. What I want to do (and I believe GO can do this) is have the user login to GO with their user name and password from SME and have GO authenticate against the SME IMAP server and if authentification is granted then GO creates the user in its database.

The "auth_sources.inc" is where this would be configured"
Code: [Select]

Group-Office authentication configuration file

In this file you can create additional authentication sources
for Group-Office.
This is an example file. If this file contains passwords or
othe sensitive information please put it in a safe place.
Protect it with an .htaccess file or put it outside the public
web root!

The file is distributed as auth_sources.dist. Please rename it to
auth_sources.inc and set the path in Group-Office.php if you want to
configure additional authentication sources.
*/


/*
Normal Group-Office authentication
Enabled by default.
Keep this on top for synchronization. otherwise authentication with the
Sync4GO clients will fail.
*/

$auth_sources[] =
        array(
        'type' => 'sql',
        'name' => 'Group-Office database',
        'user_manager' => 'sql'
        );


/*
An LDAP server


$auth_sources[] =
array(
'type' => 'ldap',
'name' => 'Intermesh LDAP server',
'user_manager' => 'sql',
'groups' => array('Intermesh'),
'modules_read' => array('email', 'filesystem', 'addressbook', 'calendar', 'bookmarks', 'notes', 'summary'),
'modules_write' => array(),
'host' => 'ldap.intermesh.nl',
'user' => 'admin',
'pass' => 'some_pass',
'basedn' => 'dc=intermesh,dc=nl',
'peopledn' => 'ou=People,dc=intermesh,dc=nl',
'groupsdn' => 'ou=Groups,dc=intermesh,dc=nl'
);


An IMAP/POP3 server.
TIP: If you run your IMAP or POP server local and you use system accounts you
can set the user_manager to passwd. You need to have sudo installed to make
this work.

You need to give the Apache user permissions for chpasswd with visudo.
An example entry in /etc/sudoers in case the Apache username is apache:
 
apache  ALL=NOPASSWD:/usr/sbin/chpasswd


$auth_sources[] =
array(
'type' => 'email',
'name' => 'intermesh.nl',
'user_manager' => 'sql',
'proto' => 'imap',
'domain' => 'intermesh.nl',
'host' => 'localhost',
'port' => '143',
'ssl' => false,
'novalidate_cert' => false,
'mbroot' => 'INBOX',
'add_domain_to_username' => false,
'create_email_account' => true,
'auto_check_email' => true,
'groups' => array('Intermesh'),
'visible_groups' => array('Everyone'),
'modules_read' => array('email', 'filesystem', 'addressbook', 'calendar', 'bookmarks', 'notes', 'summary'),
'modules_write' => array()
);
*/



I have not tried LDAP yet. I did try to autenticate against a Windows email server (hmailserver) and that did not work either.

I am also trying the GO forum.


Thanks


Kevin

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
Group Office - A howto
« Reply #22 on: May 01, 2007, 06:06:14 PM »
I tryed to enable ldap server but i had no luck with configuring this thing so post when you have something.

GO helpdesk doesn't help at all. They said "just fill the imap part of the file and it should work" and well it doesn't.  :?
"It should just work" if it doesn't report it. Thanks!

Offline crobruncato

  • 5
  • +0/-0
Group Office - A howto
« Reply #23 on: June 26, 2007, 03:54:35 PM »
Quote from: "bpivk"
I tryed to enable ldap server but i had no luck with configuring this thing so post when you have something.

GO helpdesk doesn't help at all. They said "just fill the imap part of the file and it should work" and well it doesn't.  :?


bpivk - What did you try on the LDAP - I"m trying to get that to work as well.
Thanks,
Rob

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
Group Office - A howto
« Reply #24 on: June 26, 2007, 04:32:38 PM »
Well i have tryed everything and it didn't work. But you should try imap auth because it worked well on my server. I changed it to manual auth. because the user had a mail with the default domain (i have two domains) and that didn't work well for me because i still had to edit that manualy but it should work like a charm if you use only one domain (for mail at least).

Edit auth_sources.inc and fill the "An IMAP/POP3 server.....".
"It should just work" if it doesn't report it. Thanks!

Offline Amir Inbar

  • *
  • 113
  • +0/-0
    • http://www.sheroot.net
Group Office - A howto
« Reply #25 on: July 01, 2007, 09:37:27 PM »
What about upgrading ?
If i have used the former contrib from the wiki and currently have 2.16 installed - how do i upgrade to 2.17 ?
My main concern is my database - i don't want it to be over-written ...
......

Offline cool34000

  • *
  • 339
  • +0/-0
Group Office - A howto
« Reply #26 on: July 02, 2007, 03:22:53 PM »
Hi,


Have you tryed a manual update? There must be a way to do it...
Read docs on their website! You should find some help.

I doubt a fresh install of the new version will accept an old database...
So you need to backup your database before trying anything! And also think to backup the websites' root folder (should be in /opt) just in case!

I suggest to use 'phpmyadmin' to export the database and 'tar' to backup the website's root folder (will preserve owners and perms)



Sylvain

Offline Amir Inbar

  • *
  • 113
  • +0/-0
    • http://www.sheroot.net
Group Office - A howto
« Reply #27 on: July 02, 2007, 03:32:32 PM »
tnx cool34000

Well, from waht i understand - the only information they will provide - the upgrade i sonly supported for the registered (paying) customers - the subscription provides updates services.

I am thinking about bulding an SME7.3 server image for vmware server, installing 2.16, testing some info, b acking up and then removing 2.16 until finnaly installing 2.7.

Does anyone know a better way to test the manual upgrade ?
......

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Group Office - A howto
« Reply #28 on: July 02, 2007, 03:55:04 PM »
I just did a manual upgrade to 2.16.
Stay tuned for 2.17.

Offline Amir Inbar

  • *
  • 113
  • +0/-0
    • http://www.sheroot.net
Group Office - A howto
« Reply #29 on: July 02, 2007, 06:57:03 PM »
@stuntshell :
Did you have any information stored before the upgrade  ?
If yes - did the information (data - meetings, contacts etc') remained or did the upgrade wipe it ?
......

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
Group Office - A howto
« Reply #30 on: July 02, 2007, 09:15:29 PM »
Quote from: "amir"
@stuntshell :
Did you have any information stored before the upgrade  ?
If yes - did the information (data - meetings, contacts etc') remained or did the upgrade wipe it ?

The data will be left on the server. Update your GO by installing the new version over your old one (backup the data first) and then run http://server/gofolder/install/upgrade.php
"It should just work" if it doesn't report it. Thanks!

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Group Office - A howto
« Reply #31 on: July 02, 2007, 09:55:32 PM »
Nothing lost, the database isn't touched at all, only the files.
Now for the 2.17 version there is a lot of addons and changes, I still haven't upgraded yet because I'm looking at the sql scheme from one to another, it seems that an upgrade won't be possible.

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
Group Office - A howto
« Reply #32 on: July 02, 2007, 10:13:41 PM »
Quote
Now for the 2.17 version there is a lot of addons and changes, I still haven't upgraded yet because I'm looking at the sql scheme from one to another, it seems that an upgrade won't be possible.

Not quite true (as stated in the readme file). The upgrade.php file should take care of all changes. Will post back with the findings when i upgrade.

Edit: I can confirm my statement. All you have to do is to:
1. Backup your database
2. Move away your old source files.
3. Put the new files at the right location and set the proper permissions
4. If exists copy your old config.php to the new files.
5. Launch your browser and go to install/upgrade.php
"It should just work" if it doesn't report it. Thanks!

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Group Office - A howto
« Reply #33 on: July 02, 2007, 11:09:45 PM »
Quote from: "bpivk"

Edit: I can confirm my statement. All you have to do is to:
1. Backup your database
2. Move away your old source files.
3. Put the new files at the right location and set the proper permissions
4. If exists copy your old config.php to the new files.
5. Launch your browser and go to install/upgrade.php


Now that was way too quick! Did you actually do it, or just pasted the from the Read-Me file?  :P

I actually dunno it! And I recommend the upgrade for all the great new features, but...2.17 is still Beta.

Thanks,

Offline bpivk

  • *
  • 908
  • +0/-0
    • http://www.bezigrad.com
Group Office - A howto
« Reply #34 on: July 03, 2007, 04:35:02 PM »
I actually did it and i did paste the output from the readme file. :D
I'm translating GO to my native language and i don't mind if it dies on me because i can always reinstall it. So i just deleted all the files (copyed config.ini to a safe place) and then extracted GO to my old folder, copyed config.ini and chowned to www:www and ran install/upgrade.php. I can send you some screens but i did notice that the new version doesn't display it's version number.

And yes the upgrade was quick and painless and it took less than 5 minutes including extracting and downloading the new version.

And please note that 2.17 is stable now.
"It should just work" if it doesn't report it. Thanks!

Offline edb

  • *
  • 546
  • +0/-0
Re: Group Office - A howto
« Reply #35 on: August 31, 2007, 09:32:41 PM »
I tried to export my LDAP address book from SME through Horde to a csv file and then import this csv file into GO.
The problem is that it will not import the csv file. It seems to take all the headings as a single field.
I also tried removing the header fields but there is just no way that I can see around this other than using Navicat or some other tool to import directly to the user database table.

Comments

edb
......

Offline etn07

  • 8
  • +0/-0
Re: Group Office - A howto
« Reply #36 on: September 02, 2007, 11:11:48 AM »
Good morning
I have installated groupoffice in SME 7.2
I have the problem to create the user mail account via IMAP
I have this message:

Connessione al server di posta fallita: '192.168.1.210' alla porta: 993

Unexpected untagged message: LOGGING

but with the admin account its working fine!

any question?
thx