Re: [SOGo] SOGo resources
Hi Gerald, then I see two possibilities: a) configure dovecot so that it accepts mails for your resources (new userdb entry) b) modify postfix so that it redirects mails to a resource to another inbox It won’t help you creating another AD account with another mail address which is redirected, since SOGo wouldn’t notice these mails and the resource won’t be booked (as you have written before). The booking is not done via mail but via the calendaring protocol (CalDAV, EAS), so the resource mail must be correct. Regards, Christoph > Am 06.02.2017 um 19:43 schrieb Gerald Brandt (g...@majentis.com) >: > > > > On 2017-02-06 10:03 AM, Christoph Kreutzer (kreutzer.christ...@gmail.com) > wrote: >> Hi, >> >> In my opinion, you can just leave the AD part out. >> A resource is identified using an email address, but it doesn’t really need >> an inbox (I've configured it this way, at least). >> >> Then, in SOGo, you can just add your resource as attendee to the event and >> it will accept or decline. >> >> Regards, >> Christoph > > The issue is that my users are using a client (thunderbird or outlook), and > it will send an email for the invite. > > Gerald > > > > >>> Am 06.02.2017 um 16:48 schrieb Gerald Brandt (g...@majentis.com) >>> : >>> >>> >>> >>> On 2017-02-05 02:09 PM, Christoph Kreutzer (kreutzer.christ...@gmail.com) >>> wrote: Hi Gerald, yes - just create a SQL user source with the necessary options for resources :) Regards, Christoph > Am 05.02.2017 um 16:40 schrieb Gerald Brandt (g...@majentis.com) > : > > Hi, > > I have SOGo running against Active Directory (details below*). Is it > possible to have resources (meeting rooms, etc) in the local MySQL > database while users and groups are in AD? I'm not super comfortable with > modifying my schema. > > Gerald > > * I run Univention as my AD, and NethServer as my SOGo. It works quite > well. > > > -- > users@sogo.nu > https://inverse.ca/sogo/lists >>> That's great. Now I need some details. >>> >>> Machine a: dc1 - Active directory, postfix, and dovecot >>> Machine b: sogo >>> >>> SOGo gets it user list from machine A, and connects to A's postfix and >>> dovecot server. >>> >>> Since the meeting room needs an email address, do I create it as a regular >>> user in the AD domain, and as a resource user in the MySQL db? >>> >>> AD: create user boardr...@example.com and forward all email to >>> boardroom-...@example.com >>> MySQL: create user boardroom-...@example.com >>> >>> Share boardroom-res calendar with users (read only) >>> >>> Does that sound right? >>> >>> Gerald >>> -- >>> users@sogo.nu >>> https://inverse.ca/sogo/lists > > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo resources
On 2017-02-06 10:03 AM, Christoph Kreutzer (kreutzer.christ...@gmail.com) wrote: Hi, In my opinion, you can just leave the AD part out. A resource is identified using an email address, but it doesn’t really need an inbox (I've configured it this way, at least). Then, in SOGo, you can just add your resource as attendee to the event and it will accept or decline. Regards, Christoph The issue is that my users are using a client (thunderbird or outlook), and it will send an email for the invite. Gerald Am 06.02.2017 um 16:48 schrieb Gerald Brandt (g...@majentis.com): On 2017-02-05 02:09 PM, Christoph Kreutzer (kreutzer.christ...@gmail.com) wrote: Hi Gerald, yes - just create a SQL user source with the necessary options for resources :) Regards, Christoph Am 05.02.2017 um 16:40 schrieb Gerald Brandt (g...@majentis.com) : Hi, I have SOGo running against Active Directory (details below*). Is it possible to have resources (meeting rooms, etc) in the local MySQL database while users and groups are in AD? I'm not super comfortable with modifying my schema. Gerald * I run Univention as my AD, and NethServer as my SOGo. It works quite well. -- users@sogo.nu https://inverse.ca/sogo/lists That's great. Now I need some details. Machine a: dc1 - Active directory, postfix, and dovecot Machine b: sogo SOGo gets it user list from machine A, and connects to A's postfix and dovecot server. Since the meeting room needs an email address, do I create it as a regular user in the AD domain, and as a resource user in the MySQL db? AD: create user boardr...@example.com and forward all email to boardroom-...@example.com MySQL: create user boardroom-...@example.com Share boardroom-res calendar with users (read only) Does that sound right? Gerald -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo resources
Hi, In my opinion, you can just leave the AD part out. A resource is identified using an email address, but it doesn’t really need an inbox (I've configured it this way, at least). Then, in SOGo, you can just add your resource as attendee to the event and it will accept or decline. Regards, Christoph > Am 06.02.2017 um 16:48 schrieb Gerald Brandt (g...@majentis.com) >: > > > > On 2017-02-05 02:09 PM, Christoph Kreutzer (kreutzer.christ...@gmail.com) > wrote: >> Hi Gerald, >> >> yes - just create a SQL user source with the necessary options for resources >> :) >> >> Regards, >> Christoph >> >>> Am 05.02.2017 um 16:40 schrieb Gerald Brandt (g...@majentis.com) >>> : >>> >>> Hi, >>> >>> I have SOGo running against Active Directory (details below*). Is it >>> possible to have resources (meeting rooms, etc) in the local MySQL database >>> while users and groups are in AD? I'm not super comfortable with modifying >>> my schema. >>> >>> Gerald >>> >>> * I run Univention as my AD, and NethServer as my SOGo. It works quite well. >>> >>> >>> -- >>> users@sogo.nu >>> https://inverse.ca/sogo/lists > That's great. Now I need some details. > > Machine a: dc1 - Active directory, postfix, and dovecot > Machine b: sogo > > SOGo gets it user list from machine A, and connects to A's postfix and > dovecot server. > > Since the meeting room needs an email address, do I create it as a regular > user in the AD domain, and as a resource user in the MySQL db? > > AD: create user boardr...@example.com and forward all email to > boardroom-...@example.com > MySQL: create user boardroom-...@example.com > > Share boardroom-res calendar with users (read only) > > Does that sound right? > > Gerald > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo resources
On 2017-02-05 02:09 PM, Christoph Kreutzer (kreutzer.christ...@gmail.com) wrote: Hi Gerald, yes - just create a SQL user source with the necessary options for resources :) Regards, Christoph Am 05.02.2017 um 16:40 schrieb Gerald Brandt (g...@majentis.com): Hi, I have SOGo running against Active Directory (details below*). Is it possible to have resources (meeting rooms, etc) in the local MySQL database while users and groups are in AD? I'm not super comfortable with modifying my schema. Gerald * I run Univention as my AD, and NethServer as my SOGo. It works quite well. -- users@sogo.nu https://inverse.ca/sogo/lists That's great. Now I need some details. Machine a: dc1 - Active directory, postfix, and dovecot Machine b: sogo SOGo gets it user list from machine A, and connects to A's postfix and dovecot server. Since the meeting room needs an email address, do I create it as a regular user in the AD domain, and as a resource user in the MySQL db? AD: create user boardr...@example.com and forward all email to boardroom-...@example.com MySQL: create user boardroom-...@example.com Share boardroom-res calendar with users (read only) Does that sound right? Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo resources
Hi Gerald, yes - just create a SQL user source with the necessary options for resources :) Regards, Christoph > Am 05.02.2017 um 16:40 schrieb Gerald Brandt (g...@majentis.com) >: > > Hi, > > I have SOGo running against Active Directory (details below*). Is it possible > to have resources (meeting rooms, etc) in the local MySQL database while > users and groups are in AD? I'm not super comfortable with modifying my > schema. > > Gerald > > * I run Univention as my AD, and NethServer as my SOGo. It works quite well. > > > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo resources
Hi, I have SOGo running against Active Directory (details below*). Is it possible to have resources (meeting rooms, etc) in the local MySQL database while users and groups are in AD? I'm not super comfortable with modifying my schema. Gerald * I run Univention as my AD, and NethServer as my SOGo. It works quite well. -- 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