Koozali.org: home of the SME Server

Howto install More.groupware

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
Howto install More.groupware
« on: February 05, 2004, 08:12:15 PM »
Hello,

I've juste finished my last howto.
It concerne the installation of More.groupware on SME 5.6 or SME 6.0.

http://vanhees.homeip.net/index.php?module=ContentExpress&func=display&ceid=15&meid=

Regards,

Anonymous

Howto install More.groupware
« Reply #1 on: February 06, 2004, 05:17:10 AM »
FANTASTIC WORK!!!!!!!!!!!!!!!!!

I installed this in like 5-10min and logged in, having never seen more.groupware before...its is COMPLETELY mind blowing how good this is...

Can we use the same user accounts in moregw as in the SME ldap?

guest

moregroupware
« Reply #2 on: February 06, 2004, 05:19:19 AM »
"last" how-to as in never again!?

why moregroupware or did you compare any other groupware options?

Guest

moregroupware
« Reply #3 on: February 06, 2004, 05:22:07 AM »
dumb question, why moregroupware after opengroupware or are there more groupware how-tos to come?

Bob

gzipped?
« Reply #4 on: February 06, 2004, 06:52:45 AM »
I just downloaded all of the tarballs. The core tarball ends in ".gz", yet it apparently isn't a compressed gz. A 'tar xvfz' didn't work, but a 'tar xvf' did. Anyone else notice this?

pete

Howto install More.groupware
« Reply #5 on: February 06, 2004, 08:37:16 AM »
yeah i did. (i poisted as guest above)

Also its necessary to restart mysql before you try and run the setup script

service mysqld restart

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
Howto install More.groupware
« Reply #6 on: February 06, 2004, 09:25:10 AM »
Quote from: "pete"
yeah i did. (i poisted as guest above)

Also its necessary to restart mysql before you try and run the setup script

service mysqld restart

Sorry pete but I think that restarting mysql is not the solution, maybe a problem with right access.
When you create a new user in mysql you have to flush the privileges ( mysqladmin flush-privileges ).

Regards,

pete

Howto install More.groupware
« Reply #7 on: February 06, 2004, 09:53:35 AM »
Sleepy - thanks - anyway, cant hurt :) I had to or i couldnt log in...

Also i would only be interested in more.groupware if i can intergrate the acco8unts...

Any ldap gurus out there?
The following is the LDAP auth stuff from the config of more.gw - even though this is enabled, i can use the below settings to log into the ldap server remotely using softera ldap browser, but users in the ldap irectory cant log into more.gw and new users crated in more.gw cant log into SME...anyone got any ideas?

$appconf['auth_ldaptype'] = '0';
$appconf['auth_ldaphost'] = 'localhost';
$appconf['auth_ldapbase'] = 'cn=root,dc=students,dc=com';
$appconf['auth_ldapuid'] = 'root';
$appconf['auth_ldappasswd'] = 'yAUQFJQRlVtTVetc=';
$appconf['auth_ldapsuffixe'] = 'ou=main';
$appconf['create_accounts_on_login'] = 1;

oregonbob

Howto install More.groupware
« Reply #8 on: February 07, 2004, 03:07:23 AM »
FYI: I followed your very good HOWTO and installed it in about 20 minutes, maybe I spent 10 redownloading until I figured out the gz wasn't a gz :-D

In case there are any lazy 'cut and pasters' like me, your HOWTO has a typo on line: "# servcie httpd restart", note the service word. Other than that it was perfect!

The install went just like your how-to. I haven't dug in much but it looks interesting.

Anonymous

Re: Howto install More.groupware
« Reply #9 on: March 11, 2004, 08:17:37 PM »
Quote from: "MasterSleepy"
Hello,

I've juste finished my last howto.
It concerne the installation of More.groupware on SME 5.6 or SME 6.0.

http://vanhees.homeip.net/index.php?module=ContentExpress&func=display&ceid=15&meid=

Regards,


It is also possible to just drop the code into an i-bay. I think that is prefarable as maintenance becomes much easier, having the scripts within easy access from SAMBA. I've done just that and it works great.

Anonymous

Howto install More.groupware
« Reply #10 on: March 11, 2004, 08:27:39 PM »
Quote from: "pete"
Sleepy - thanks - anyway, cant hurt :) I had to or i couldnt log in...

Also i would only be interested in more.groupware if i can intergrate the acco8unts...

Any ldap gurus out there?
The following is the LDAP auth stuff from the config of more.gw - even though this is enabled, i can use the below settings to log into the ldap server remotely using softera ldap browser, but users in the ldap irectory cant log into more.gw and new users crated in more.gw cant log into SME...anyone got any ideas?


Two problems:

1. The e-smith LDAP does not authenticate passwords. You can only bind anonymously and check that a user exists. That had me scratching my head for a while.

2. LDAP authentication within moregroupware has some glaring holes in it. It does not appear to be complete and working.

You can get around the first problem by authenticating against IMAP instead. This works at the end of my ldap.inc.php:

$mbox = imap_open('{localhost:143/notls}INBOX', $dn, $pass, OP_HALFOPEN);
if (!empty($mbox)) {
    return true;
} else {
    return false;
}

You also need to ensure moregroupware does not encrypt the password that is sent (the $appconf['encrypt_pwd'] option seems to ne the back-to-front, set it to '1' to prevent encryption).

Within ldap.inc.php you can capture the LDAP details for the user and use those details to update the user in the database:

global $external_user_details;
$external_user_details = array(
    'fullname' => $result[0]['cn'][0],
    'surname' => $result[0]['sn'][0],
    'givenname' => $result[0]['givenname'][0],
    'fullname' => $result[0]['cn'][0],
    'telephone' => $result[0]['telephonenumber'][0],
    'ou' => $result[0]['ou'][0], // division
    'o' => $result[0]['o'][0], // organisation
    'mail' => $result[0]['mail'][0],
    'street' => $result[0]['street'][0], // address 1
    'l' => $result[0]['l'][0] // town
);

Then in index.php, just after it has created a new user (upon encountering a new authenticated user), do the update:

...
create_user_account($login);
$row = get_user_info($login);
global $external_user_details;
if (!empty($external_user_details)) {
            $sql = 'UPDATE mgw_users '
            .' SET lastname=' . $conn->QMagic($external_user_details['surname'])
            .' , firstname=' . $conn->QMagic($external_user_details['givenname'])
            .' , email=' . $conn->QMagic($external_user_details['mail'])
            .' , telephone=' . $conn->QMagic($external_user_details['telephone'])
            .' WHERE username='.$conn->QMagic($login);
            if (($res = $conn->GetRow($sql))===false) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
        }
...


Sorry it is all a bit of a hack - you will need to know what you are doing before attempting this, but it does work nicely. When the user first logs in, their name, e-mail etc. are copied from LDAP into the moregroupware user table. There is no synchronising after that, but it gets the basics in there.

Hope that helps.

-- Jason