[SOGo] BTS activities for Saturday, March 29 2014
Title: BTS activities for Saturday, March 29 2014 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Saturday, March 29 2014 idlast updatestatus (resolution)categorysummary 2686 2014-03-29 17:29:35 updated (open) ActiveSync all day events are not handled correctly
Re: [SOGo] Sync issues with iPhone and iPad
On 2014-03-29, 5:32 AM, Christian Rößner wrote: Please, could at least please somebody explain me, what these errors mean. It’s really annoying and I am totally stuck It means the DAV client asks for unknown properties to SOGo. Are you in a position to test a patch? -- 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
[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] Activesync Android bad sender
Hi, I have Samsung Galaxy S3 with Android 4.3 (user-agent='SAMSUNG-GT-I9300/101.403') with Activesync to Sogo (last night build). When I send an email, in From: i have first part of email, for example: From: msinsky , nor my whole name from LDAP (From: Martin Šinský . From webmail is everything correct. On my phone i can't change anything. Any clue how to fix it? Regards, Martin -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sync issues with iPhone and iPad
> Mar 25 21:02:48 sogod [32109]: [ERROR]
> <0x5F7B6AA0[SOGoAppointmentFolder]:personal> DAV property
> '{http://calendarserver.org/ns/}created-by' has no matching SQL field,
> response could be incomplete
> Mar 25 21:02:48 sogod [32109]: [ERROR]
> <0x5F7B6AA0[SOGoAppointmentFolder]:personal> DAV property
> '{http://calendarserver.org/ns/}updated-by' has no matching SQL field,
> response could be incomplete
> Mar 25 21:02:48 sogod [32109]: [ERROR]
> <0x5F7B6AA0[SOGoAppointmentFolder]:personal> DAV property
> '{urn:ietf:params:xml:ns:caldav}schedule-tag' has no matching SQL field,
> response could be incomplete
bump
Please, could at least please somebody explain me, what these errors mean. It’s
really annoying and I am totally stuck
Thanks
-Christian Rößner
--
[*] sys4 AG
http://sys4.de, +49 (89) 30 90 46 64
Franziskanerstraße 15, 81669 München
Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Marc Schiffbauer
Aufsichtsratsvorsitzender: Florian Kirstein
signature.asc
Description: Message signed with OpenPGP using GPGMail
