Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: duncan on January 27, 2007, 04:23:13 AM
-
A group-office (http://www.group-office.com/index.php?folder_id=1&file_id=417) howto.
Create the relevant directories like so. Keep an eye out for word wrapping . New lines are marked with a #.
# 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 (http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewsdownload&sid=53)
mod_deflate (http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewsdownload&sid=59)
Download the most current version of Group office from here (http://sourceforge.net/project/showfiles.php?group_id=76359) and extract and install as follows. The current version of Group office is 2.16-8 - please adjust your paths as required.
# 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.
# 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.
# 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.
# expand-template /etc/httpd/conf/httpd.conf
# /etc/rc.d/rc7.d/S86httpd-e-smith restart
Create the database.
[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.
-
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>
<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>
<a HREF="javascript:popUp('https://ipaddress/groupoffice')">Open Group-office</a>
-
When I try to install, after the first page it goes:
https://192.168.0.1/groupoffice/install/install.phpgroupoffice/install/install.phpgroupoffice/install/install.phpgroupoffice/...
-
When I try to install, after the first page it goes:
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?
-
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,
-
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!
-
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.
-
Very fine product!
Thanks for this easy Howto !
-
Has anybody else noticed that, with this particular installation, the "sync" options & directory are completely gone?
Is that on purpose?
-
Hi All,
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
-
Oh...derp de derp. My bad - sorry. hehe.
Hi All,
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
-
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 ?
-
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
-
I've tested this soft and made a (simple) HowTo in the Wiki.
Please edit if you have improvements.
/Per
-
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
-
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 ?
-
/opt can be owned by any user or group.
-
Berdie;
Thx, worked well
Ian
-
/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 !
-
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
-
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.
-
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"
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
-
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. :?
-
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
-
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.....".
-
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 ...
-
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
-
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 ?
-
I just did a manual upgrade to 2.16.
Stay tuned for 2.17.
-
@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 ?
-
@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
-
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.
-
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
-
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,
-
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.
-
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
-
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