Re: [SOGo] Sogo with Postfixadmin
Many Thanks Eben van Deventer William William Bowden Consultant Engineer | m:07525 645105 | e:will...@jmrit.co.uk > On 22 Mar 2023, at 13:28, Eben van Deventer (buf...@gmail.com) > wrote: > > Hi William, I think this might be an ACL issue, check attached how-to I did > for a deployment with SOGo, PostfixAdmin and MySQL: > Debian 11 Groupware Server - LEMP Stack | BuFf0k > <https://www.buff0k.co.za/tutorial/debian-11-groupware-lemp> > > On Wed, 22 Mar 2023 at 15:15, Marco Moock <mailto:users@sogo.nu>> wrote: >> Am 22.03.2023 um 11:26:06 Uhr schrieb William Bowden: >> >> > I have this running in all except shared items whenever I go to share >> > say calendar I type in the email and nothing. >> >> What do you expect? >> Does the sharing work? >> >> -- >> Gruß >> Marco Moock >> URZ Uni Heidelberg > > > -- > Eben van Deventer (AKA Buff) > +27 83 548 6207 > +27 11 391 2258 > buf...@gmail.com <mailto:buf...@gmail.com>
RE: [SOGo] Sogo with Postfixadmin
Too bad there is no user integration like in DirectAdmin Michel De : users-requ...@sogo.nu De la part de Eben van Deventer Envoyé : mercredi 22 mars 2023 14:29 À : users@sogo.nu Objet : Re: [SOGo] Sogo with Postfixadmin Hi William, I think this might be an ACL issue, check attached how-to I did for a deployment with SOGo, PostfixAdmin and MySQL: Debian 11 Groupware Server - LEMP Stack | BuFf0k <https://www.buff0k.co.za/tutorial/debian-11-groupware-lemp> On Wed, 22 Mar 2023 at 15:15, Marco Moock mailto:users@sogo.nu> > wrote: Am 22.03.2023 um 11:26:06 Uhr schrieb William Bowden: > I have this running in all except shared items whenever I go to share > say calendar I type in the email and nothing. What do you expect? Does the sharing work? -- Gruß Marco Moock URZ Uni Heidelberg -- Eben van Deventer (AKA Buff) +27 83 548 6207 +27 11 391 2258 buf...@gmail.com <mailto:buf...@gmail.com>
Re: [SOGo] Sogo with Postfixadmin
Hi William, I think this might be an ACL issue, check attached how-to I did for a deployment with SOGo, PostfixAdmin and MySQL: Debian 11 Groupware Server - LEMP Stack | BuFf0k <https://www.buff0k.co.za/tutorial/debian-11-groupware-lemp> On Wed, 22 Mar 2023 at 15:15, Marco Moock wrote: > Am 22.03.2023 um 11:26:06 Uhr schrieb William Bowden: > > > I have this running in all except shared items whenever I go to share > > say calendar I type in the email and nothing. > > What do you expect? > Does the sharing work? > > -- > Gruß > Marco Moock > URZ Uni Heidelberg > -- Eben van Deventer (AKA Buff) +27 83 548 6207 +27 11 391 2258 buf...@gmail.com
Re: [SOGo] Sogo with Postfixadmin
Am 22.03.2023 um 11:26:06 Uhr schrieb William Bowden: > I have this running in all except shared items whenever I go to share > say calendar I type in the email and nothing. What do you expect? Does the sharing work? -- Gruß Marco Moock URZ Uni Heidelberg
[SOGo] Sogo with Postfixadmin
Hi I have this running in all except shared items whenever I go to share say calendar I type in the email and nothing. Apart from that all is good. Any clues and if needed I will send whatever you need William William Bowden Consultant Engineer | m:07525 645105 | e:will...@jmrit.co.uk
Re: [SOGo] SOGo and PostfixAdmin - is there a list of additional fields like telephone number, screen name?
On 4/3/2014 2:44 AM, Christian Mack wrote: I only know of the LDAP Attribute Mapping list in the SOGo Installation Guide page 25. But perhaps you can use these attribute names with a c_ prefix. You could try to use e.g. c_mozillanickname for the nickname. As for the data type, with the c_ prefix it should be character varying(255). Mmm, okay, so it's probably only documented in the source code. I did find this: https://github.com/inverse-inc/sogo/blob/master/OGoContentStore/contact.ocs But that only lists: c_name, c_givenname, c_cn, c_sn, c_screenname, c_l, c_mail, c_o, c_ou, c_telephonenumber, c_categories, c_component. I don't see c_mozillanickname in the code base for SOGo. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and PostfixAdmin - is there a list of additional fields like telephone number, screen name?
On 2014-04-07, 5:30 PM, Thomas Harold wrote: Mmm, okay, so it's probably only documented in the source code. Have a look at page 25: http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and PostfixAdmin - is there a list of additional fields like telephone number, screen name?
Am 2014-03-29 02:50, schrieb Thomas Harold: We have what is a pretty common setup: Postfix Dovecot both authenticating against a PostfixAdmin database (called mails) stored in PostgreSQL running on the localhost. For SOGo to authenticate against a database, we setup the following view against the mailbox table in our mails database. ... I have figured out that if I add the following field to the mailbox table and export in the view without the x_sogo_ prefix, it shows up in the SOGo Web client address book as the work number. x_sogo_c_telephonenumber character varying(255) - c_telephonenumber (in the VIEW) The question I have is this, if we want to add other fields to the mailbox table (and the sogo_authentication view), is there a list somewhere of what field name and data type that SOGo is expecting for each new field? I don't use SQL auth. I only know of the LDAP Attribute Mapping list in the SOGo Installation Guide page 25. But perhaps you can use these attribute names with a c_ prefix. You could try to use e.g. c_mozillanickname for the nickname. As for the data type, with the c_ prefix it should be character varying(255). But as I said, you have to test this yourself. Kind regards, Christian Mack -- Christian Mack Abteilung Basisdienste KIM IT-Services Universität Konstanz smime.p7s Description: S/MIME Cryptographic Signature
[SOGo] SOGo and PostfixAdmin - is there a list of additional fields like telephone number, screen name?
We have what is a pretty common setup: Postfix Dovecot both
authenticating against a PostfixAdmin database (called mails) stored
in PostgreSQL running on the localhost.
For SOGo to authenticate against a database, we setup the following view
against the mailbox table in our mails database.
--
CREATE OR REPLACE VIEW sogo_authentication AS
SELECT
mailbox.username AS c_uid,
mailbox.username AS c_name,
mailbox.password AS c_password,
mailbox.name AS c_cn,
mailbox.username AS mail
FROM mailbox
WHERE
mailbox.active = true;
ALTER TABLE sogo_authentication OWNER TO postgres;
GRANT ALL ON TABLE sogo_authentication TO postgres;
GRANT SELECT ON TABLE sogo_authentication TO mails_reader;
--
The sogo database user (login role) is a member of the mails_reader
group (group role) in PostgreSQL. That gives it read-only access to the
view. That all works perfectly. It leverages our existing
authentication system used for our mail server.
We also had to configure the pg_hba.conf file (note that in a
pg_hba.conf file, more specific entries should be listed first, so you
may need to move these up towards the top of the list).
--
host sogo sogo 127.0.0.1/32 md5
host mails sogo 127.0.0.1/32 md5
--
On the SOGo side, we have the following in /etc/sogo/sogo.conf in order
to connect to that for authentication.
SOGoUserSources =
(
{
type = sql;
id = directory;
displayName = SOGo Account Listing;
viewURL =
postgresql://sogo:RANDOMPASSWORD@127.0.0.1:5432/mails/sogo_authentication;
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5-crypt;
}
);
...
I have figured out that if I add the following field to the mailbox
table and export in the view without the x_sogo_ prefix, it shows up
in the SOGo Web client address book as the work number.
x_sogo_c_telephonenumber character varying(255) - c_telephonenumber (in
the VIEW)
The question I have is this, if we want to add other fields to the
mailbox table (and the sogo_authentication view), is there a list
somewhere of what field name and data type that SOGo is expecting for
each new field?
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] Sogo resources postfixadmin - sql voodoo needed
Hi list,
I've got SOGo running on ubuntu precise with postfix, dovecot and mysql as
backends.
It's been working nice and reliable for the last 18 months, handling about
8-10k mails per day.
Postfixadmin is used to manage all users, aliases, forwardings and
maildomains.
The server hosts several domains (for smtp and imap), sogo however serves
only one of the domains on the server.
The sogo usersource sogo_auth is a view on the mail database (that
postfixadmin created), like so:
select `mail`.`mailbox`.`username` AS `c_uid`,`mail`.`mailbox`.`username`
AS `c_name`,`mail`.`mailbox`.`password` AS
`c_password`,`mail`.`mailbox`.`name` AS `c_cn`,`mail`.`mailbox`.`username`
AS `mail`,`mail`.`mailbox`.`maildir` AS `home` from `mail`.`mailbox`
/etc/sogo/sogo.conf contains the lines:
SOGoUserSources = (
{
IMAPLoginFieldName = c_uid;
MailFieldNames = (
mail
);
canAuthenticate = YES;
displayName = sogo_auth;
id = directory;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5-crypt;
viewURL = mysql://user:secretpassword@localhost
:3306/sogo/sogo_auth;
}
All other sogo information is kept in a separate database sogo, which is
configured just like the sogo installation manual says
This seemed to be a good idea at the time...
Now, the need for room- and other resources has popped up :-|
The sogo wiki http://wiki.sogo.nu/ResourceConfiguration tells me that
SOGo user source (in SOGo config) must be defined with KindFieldName and
MultipleBookingsFieldName
Right.
How could i extend my sql-db to offer the fields kind and
multiple_bookings?
Would it be save to add these fields to the postfixadmin db mailbpx and
modify the view, or would it be possible (or even safer) to add another
table (e.g. resource_things) to the sogo database, create the fields
kind and multiple_bookings there and modify the above stated view to
suit, linking the tables with some primary key?
i'm not too much of a sql pro, so i am quite at a loss with this.
Would it be ok to simply add the statements KindFieldName = kind;
MultipleBookingsFieldName = multiple_bookings; to the SOGoUserSources as
defined above?
BTW. can i change the displayName from sogo_auth to something more
intellegible without detrimental side-effects? Or would all the
thunderbirds go coughing all over the place? I didn't realize back then
that the displayName would actually be seen by clients ...
Thanks for your ideas,
Jochen
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
On 06/19/13 20:43, Michael Vogel wrote: Am 19.06.2013 um 18:26 schrieb Giovanni Bechis: Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Is this MD5-CRYPT in Dovecot and md5-crypt in SOGo? I have a multidomain setup and I have this line in my sogo.conf userPasswordAlgorithm = crypt; I do not know about Dovecot, I am using Courier-Imap atm. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Am 20.06.2013 11:47, schrieb Giovanni Bechis: On 06/19/13 20:43, Michael Vogel wrote: Am 19.06.2013 um 18:26 schrieb Giovanni Bechis: Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Is this MD5-CRYPT in Dovecot and md5-crypt in SOGo? I have a multidomain setup and I have this line in my sogo.conf userPasswordAlgorithm = crypt; So crypt in SOGo is 'md5crypt' in postfixadmin? Good to know! BTW: That's really weird ... Michael -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
On 06/19/13 08:40, Martin Rabl wrote: Plaintext is a really bad idea ... is there no crypted column? SOGo + postifxadmin works with crypted password too, I am using this view: --- CREATE VIEW `sogo_auth_domain_it` AS select `mailbox`.`username` AS `c_uid`,`mailbox`.`username` AS `c_name`,`mailbox`.`password` AS `c_password`,`mailbox`.`name` AS `c_cn`,`mailbox`.`domain` AS `c_domain`,`mailbox`.`username` AS `mail`,`mailbox`.`maildir` AS `home` from `mailbox` where (`mailbox`.`domain` = 'domain.it') --- Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Hi! Am 19.06.2013 09:20, schrieb Giovanni Bechis: On 06/19/13 08:40, Martin Rabl wrote: Plaintext is a really bad idea ... is there no crypted column? SOGo + postifxadmin works with crypted password too, I am using this view: --- CREATE VIEW `sogo_auth_domain_it` AS select `mailbox`.`username` AS `c_uid`,`mailbox`.`username` AS `c_name`,`mailbox`.`password` AS `c_password`,`mailbox`.`name` AS `c_cn`,`mailbox`.`domain` AS `c_domain`,`mailbox`.`username` AS `mail`,`mailbox`.`maildir` AS `home` from `mailbox` where (`mailbox`.`domain` = 'domain.it') --- Thanks very much! What are you using? CRYPT or MD5? Michael -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Use SHA Am 19.06.13 18:26, schrieb Giovanni Bechis: On 06/19/13 18:15, Michael Vogel wrote: Hi! Am 19.06.2013 09:20, schrieb Giovanni Bechis: On 06/19/13 08:40, Martin Rabl wrote: Plaintext is a really bad idea ... is there no crypted column? SOGo + postifxadmin works with crypted password too, I am using this view: --- CREATE VIEW `sogo_auth_domain_it` AS select `mailbox`.`username` AS `c_uid`,`mailbox`.`username` AS `c_name`,`mailbox`.`password` AS `c_password`,`mailbox`.`name` AS `c_cn`,`mailbox`.`domain` AS `c_domain`,`mailbox`.`username` AS `mail`,`mailbox`.`maildir` AS `home` from `mailbox` where (`mailbox`.`domain` = 'domain.it') --- Thanks very much! What are you using? CRYPT or MD5? Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
On 06/19/13 18:15, Michael Vogel wrote: Hi! Am 19.06.2013 09:20, schrieb Giovanni Bechis: On 06/19/13 08:40, Martin Rabl wrote: Plaintext is a really bad idea ... is there no crypted column? SOGo + postifxadmin works with crypted password too, I am using this view: --- CREATE VIEW `sogo_auth_domain_it` AS select `mailbox`.`username` AS `c_uid`,`mailbox`.`username` AS `c_name`,`mailbox`.`password` AS `c_password`,`mailbox`.`name` AS `c_cn`,`mailbox`.`domain` AS `c_domain`,`mailbox`.`username` AS `mail`,`mailbox`.`maildir` AS `home` from `mailbox` where (`mailbox`.`domain` = 'domain.it') --- Thanks very much! What are you using? CRYPT or MD5? Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Hi! Am 19.06.13 18:30, schrieb Martin Rabl: Use SHA I need something that works with postfix, dovecot and SOGo. Michael -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Am 19.06.2013 um 18:26 schrieb Giovanni Bechis: Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Is this MD5-CRYPT in Dovecot and md5-crypt in SOGo? I need to do a multi-domain setup where usern...@domain-a.tld and usern...@domain-b.tld are different mailboxes. Michael-- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo and postfixadmin?
Hi! Is it possible to use postfixadmin as a source to authenticate users? Since postfixadmin is using different field names than SOGo needs I thought about creating a view for that. The only question then is if postfixadmin uses a password encryption mechanism that SOGo does understand. Is there one? Should a view work? Michael -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Yes its posible. I am using sogo + postfixadmin. You must use view For password I am using plaintext field in postfixadmin. 2013.06.19 02:37, Michael Vogel rašė: Hi! Is it possible to use postfixadmin as a source to authenticate users? Since postfixadmin is using different field names than SOGo needs I thought about creating a view for that. The only question then is if postfixadmin uses a password encryption mechanism that SOGo does understand. Is there one? Should a view work? Michael -- users@sogo.nu https://inverse.ca/sogo/lists
