Re: [SOGo] SOGo 2.0 ZEG strange timezone behavior
Almost the same for me. An all-day event is shown over 2 days in the web interface but is correctly displayed in Thunderbird. If I create an all-day event for the 16th Oct it is shown on the 16th and on the 17th Oct in the web interface. Any help is appreciated, Burkart Orlowski On 10/09/2012 03:13 PM, Michal Kminek wrote: I had problems with all-day events created by MS Outlook using the MS Exchange connection on my SOGo server. Therefore I decided to test it on the latest ZEG edition but the problem persist. I setup SOGo, system and Windows to use the same timezone in ZEG. I found a strange behavior - if the timezone is GMT or any other GMT +h zone then all all-day events created with MS Outlook (2007, 2010) go one day back in the web interface. For example if I create an all-day event to happen on 25th Oct in Outlook it is displayed as an all-day event on 24th Oct in SOGo. If I setup the time zone as any GMT -h zone everything works fine. Regards, Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Changing the email address
Did you check the LDAP entry mail for the users? That's the mail address populated to the web interface. Cheers, Burkart Burkart Orlowski --- Onlinehelp24 c/o betahaus Hamburg Lerchenstraße 28a 22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 69635272-0 On 10/05/2012 07:53 AM, Paul Warren wrote: Hi all, Is there a configuration option to override the mail domain that gets populated from IMAP? Our LDAP is populated with email addresses like username@domain.local is it possible to automatically ovverride that in SOGo so that the in Preferences - IMAP Accounts - Email it appears as usern...@domain.com.au? We can get users to change it themselves, and I think we can do it post user creation with sogo-tool, can we do anything so it happens automatically? Using SogoMailDomain=domain.com.au; in the GNUStepDefaults file doesn't appear to do what I need. Cheers -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Cyrus 2.4 with Ubuntu 10.04
Hi everybody, I was wondering if anybody has got a running setup with Ubuntu Server 10.04 and Cyrus 2.4 or Dovecot 2.2 to use the SOGo Outlook extension. Unfortunately there's no package available for that Ubuntu version. Did anybody try to install Cyrus 2.4 / Dovecot 2.2 manually? Thanks for your help. -- Burkart Orlowski --- Onlinehelp24 c/o betahaus Hamburg Lerchenstraße 28a 22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 69635272-0 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Address book data in DB
Hi, where in the MySQL database are the address book fields like street, postalcode, vcardcategories stored? `c_name` varchar(255) NOT NULL, `c_givenname` varchar(255) DEFAULT NULL, `c_cn` varchar(255) DEFAULT NULL, `c_sn` varchar(255) DEFAULT NULL, `c_screenname` varchar(255) DEFAULT NULL, `c_l` varchar(255) DEFAULT NULL, `c_mail` varchar(255) DEFAULT NULL, `c_o` varchar(255) DEFAULT NULL, `c_ou` varchar(255) DEFAULT NULL, `c_telephonenumber` varchar(255) DEFAULT NULL, `c_categories` varchar(255) DEFAULT NULL, `c_component` varchar(10) NOT NULL, Best regards, Burkart Orlowski --- Onlinehelp24 c/o betahaus Hamburg Lerchenstraße 28a 22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Export addressbook
Is this working server-side as well? I need to run a script once a day to export a particular address book. Regards, Burkart On 09/06/2012 05:09 PM, Christian Mack wrote: Hello Burkart Orlowsk On 2012-09-06 14:29, Burkart Orlowski | Onlinehelp24 wrote: I am looking for a solution to export a particular addressbook into a CSV file. mysql sogo --user=*** --password=*** mysql2csv.sql mysql2csv.sql = SELECT * FROM sogob***0012ca32195_quick INTO OUTFILE '/tmp/adressen_aktuell.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''; This is working pretty fine but unfortunately the exported address book fields are not complete. It lacks the address fields (street, ZIP, ...) for example. Any ideas how to export all address book information into a single CSV file? Why don't you use the export in LDIF format and convert it to csv afterwards? Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] timeshift/timezones and reccuring events in iCal
You have to turn on the time zone support in iCal. Then you can change the event time zone to the correct one and the event is moved to the proper time slot. On 18.04.2012, at 10:55, Martin Seener wrote: Can you tell me how i can fix the old events (single and recurring) for the new timezone fix? Am 4/17/12 10:03 AM, schrieb Christian Mack: Hello Burkart Orlowski On 2012-04-16 11:11, Burkart Orlowski | Onlinehelp24 wrote: ...I am still having the issue that when saving an event in the SOGo web interface the iCal event is shown +1 hour later (as Western European Time instead of Middle European Time). mod_substitute is loaded and the output filter is added in the DAV-SSL configuration. When I restart apache and SOGo there are no error messages but the event issue is the same. This work around doesn't fix already wrong events. It only prevents new events getting a bad timezone by synchronization with iCal. You have to move the already bad ones back into your desired timezone manually. Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] timeshift/timezones and reccuring events in iCal
Hi, @Martin: in my Ubuntu 10.04 setup, I loaded the module substitute sudo a2enmod substitute and added RequestHeader unset Accept-Encoding AddOutputFilterByType SUBSTITUTE text/calendar text/xml Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*);?(.*)$|RRULE:FREQ=$2;$1$3|' in the apache config file for DAV-SSL. After a restart of apache2, memcached, sogo and a reload of the web interface everything worked fine again. But I just figured out that this solves only the problem when creating new events in the SOGo web interface in your own calendar. Invitations send via mail or through Thunderbird are still one hour late in iCal. Will there be a new release coming out solving these problems? Thx, Burkart On 17.04.2012, at 10:26, Martin Seener wrote: Hi Christian, we also have a lot of old one time and recurring events in wrong timezone. can you tell me how i can correct them? Martin Am 4/17/12 10:03 AM, schrieb Christian Mack: Hello Burkart Orlowski On 2012-04-16 11:11, Burkart Orlowski | Onlinehelp24 wrote: ...I am still having the issue that when saving an event in the SOGo web interface the iCal event is shown +1 hour later (as Western European Time instead of Middle European Time). mod_substitute is loaded and the output filter is added in the DAV-SSL configuration. When I restart apache and SOGo there are no error messages but the event issue is the same. This work around doesn't fix already wrong events. It only prevents new events getting a bad timezone by synchronization with iCal. You have to move the already bad ones back into your desired timezone manually. Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] timeshift/timezones and reccuring events in iCal
...I am still having the issue that when saving an event in the SOGo web interface the iCal event is shown +1 hour later (as Western European Time instead of Middle European Time). mod_substitute is loaded and the output filter is added in the DAV-SSL configuration. When I restart apache and SOGo there are no error messages but the event issue is the same. On 14.04.2012, at 20:23, Jeff Folk wrote: On Apr 14, 2012, at 11:24 AM, Burkart Orlowski | Onlinehelp24 wrote: Hi Jeff, unfortunately this isn't working for my setup with Ubuntu 10.04. I loaded mod_substitute with What doesn't work? If apache is starting, then you don't have the syntax issues I was having.-- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] timeshift/timezones and reccuring events in iCal
Thx Mathilde. That amended line did the job. The events are shown correctly again. On 16.04.2012, at 15:25, Martin Seener wrote: Hello Mathilde, so your Substitues Rule is correct and works? I quite have the first 2 rules based variant but iam not so happy with that. we quite have strange calendar behaviours with ical 4 and 5 Am 4/16/12 3:03 PM, schrieb Mathilde Rousseau: Try this Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*)(;?.*)$|RRULE:FREQ=$2;$1$3|' Bruno Lingner send it to me on satursday, there was an error in his last mail Sinverely yours Mathilde Le 14/04/2012 18:24, Burkart Orlowski | Onlinehelp24 a écrit : On 13.04.2012, at 19:22, Jeff Folk wrote: On Apr 13, 2012, at 12:03 PM, Burkart Orlowski | Onlinehelp24 wrote: Hi, I am experiencing the same problems. Where exactly do you put RequestHeader unset Accept-Encoding AddOutputFilterByType SUBSTITUTE text/calendar text/xml Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*);?(.*)$|RRULE:FREQ=$2;$1$3|' I tried different locations but it didn't work. Thanks for your help. Burkart Burkart Orlowski In my DAV-SSL virtual host section of httpd.conf: VirtualHost 0.0.0.0:8843 ServerName sme.qzoneinc.com SSLEngine On RequestHeader unset Accept-Encoding AddOutputFilterByType SUBSTITUTE text/calendar text/xml Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*);?(.*)$|RRULE:FREQ=$2;$1$3|' ProxyRequests Off SetEnv proxy-nokeepalive 1 ProxyPreserveHost On ProxyPassInterpolateEnv On ProxyPass /principals http://127.0.0.1:2/SOGo/dav/ interpolate ProxyPass /SOGo/dav/ http://127.0.0.1:2/SOGo/dav/ interpolate ProxyPass / http://127.0.0.1:2/SOGo/dav/ interpolate Proxy http://127.0.0.1:2 RequestHeader set x-webobjects-server-port 8843 RequestHeader set x-webobjects-server-name sme.qzoneinc.com:8843 RequestHeader set x-webobjects-server-url https://sme.qzoneinc.com:8843; RequestHeader set x-webobjects-server-protocol HTTP/1.0 RequestHeader set x-webobjects-remote-host 127.0.0.1 AddDefaultCharset UTF-8 Order allow,deny Allow from all /Proxy /VirtualHost Also required a module load since my distribution (CentOS 5.x/SMEServer 8) didn't load mod_substitute.so by default, so I added to the module load section: LoadModule substitute-module modules/mod_substitute.so If you are running SME Server, you'll have to add these lines to template files and issue a 'signal-event sogo-modify' to expand the templated and restart sogo/apache. Regards; Jeff-- users@sogo.nu https://inverse.ca/sogo/lists Hi Jeff, unfortunately this isn't working for my setup with Ubuntu 10.04. I loaded mod_substitute with sudo a2enmod substitute and edited my DAV-SSL config VirtualHost *:8843 SSLEngine on ErrorLog /var/log/apache2/error.log RequestHeader unset Accept-Encoding AddOutputFilterByType SUBSTITUTE text/calendar text/xml Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*);?(.*)$|RRULE:FREQ=$2;$1$3|' Any idea what I might be missing? Apache and SOGo restart work fine. Burkart -- Mathilde Rousseau tel: 01 69 82 45 84/ 06 10 27 96 32 Responsable du Service Informatique Commun, ICSN UPR2301, Bâtiment 27 CNRS, 1 Av de la terrasse mail: mathilde.rouss...@icsn.cnrs-gif.fr 91198 Gif sur Yvette cedex -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] timeshift/timezones and reccuring events in iCal
Hi, I am experiencing the same problems. Where exactly do you put RequestHeader unset Accept-Encoding AddOutputFilterByType SUBSTITUTE text/calendar text/xml Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*);?(.*)$|RRULE:FREQ=$2;$1$3|' I tried different locations but it didn't work. Thanks for your help. Burkart Burkart Orlowski --- Onlinehelp24 c/o betahaus Hamburg Lerchenstraße 28a 22767 Hamburg On 12.04.2012, at 09:54, Bruno Lingner (Hugo) wrote: you need the apache mod_substitute module http://httpd.apache.org/docs/2.2/mod/mod_substitute.html in debian squeeze it's called 'substitute', I don't know how it's called in centos. On 04/11/2012 07:56 PM, Jeff Folk wrote: On Apr 11, 2012, at 8:51 AM, Bruno Lingner (Hugo) wrote: hi we experimented a lot since the daylight saving time with sogo and calendar clients that display the events in the wrong timezone. we finally narrowed down the problem and solved it through a rewrite rule in the apache config: RequestHeader unset Accept-Encoding AddOutputFilterByType SUBSTITUTE text/calendar text/xml Substitute 's|^RRULE:([A-Z].+[A-Za-z0-9]);?FREQ=([A-Za-z]*);?(.*)$|RRULE:FREQ=$2;$1$3|' Interesting... I try adding this to my VirtualHost and apache won't start up... The following error is logged in httpd error_log: Syntax error on line 778 of /etc/httpd/conf/httpd.conf: Invalid command 'Substitute', perhaps misspelled or defined by a module not included in the server configuration What module needs loading for the 'Substitute' command? This is a CentOS 5.x installation (SmeServer). Thanks; Jeff-- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Cyrus, Sieve Vacation Problem
Hi, I have a mail setup with Cyrus IMAPd Postfix and wanted to configure Sieve for vacation messages. The problem is that the duplicate suppression feature of Cyrus filters out the mail towards the original sender whereas no vacation mail is sent. Any idea how to configure Cyrus or Postfix to solve that issue? I reckon it has something to do with how Cyrus checks if a mail is a duplicate or not. There must be something like a fingerprint/hash which matches the initial mail and the vacation response. Any idea is welcome. Thanks in advance. Burkart Orlowski --- Onlinehelp24 c/o betahaus Hamburg Lerchenstraße 28a 22767 Hamburg (Germany) Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Getting a MODIFICATION_FAILED message when attempting to write to my Personal Calendar since updating to 1.3.9
In my case the error was caused by a reminder of a recurring event. After deleting the reminder the error was gone. Hope this works for you, too. Burkart Orlowski --- Onlinehelp24 c/o betahaus Hamburg Lerchenstraße 28a 22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net On 10.11.2011, at 22:48, John Dempsey wrote: Hi all, Since updating to1.3.9 to resolve the IOS 5 issue, I'm getting the above error in Thunderbird, with the following showing up in the log. Any assistance would be appreciated. (Running on Centos 5.7, installed from RPMS..) thanks JD Nov 10 15:48:57 sogod [30662]: [ERROR] 0x0x95c82c4[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_version,a.c_creationdate,a.c_lastmodified,b.c_component,a.c_content FROM sogo001004580015c1631b6_quick a, sogo001004580015c1631b6 b WHERE (a.c_name = '35510630-b071-4e25-9ea6-c0663c058bd3.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x960d9a4 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x96151b4[PostgreSQL72Channel]: connection=0x0x961550c[PGConnection]: connection=0x0x95c9bb0): ERROR: column a.c_version does not exist at character 17 2011-11-10 15:48:57.345 sogod[30662] ERROR(+[CardGroup cardParser]): did not find a parser for text/x-vcard! localhost.localdomain - - [10/Nov/2011:15:48:57 GMT] PUT /SOGo/dav/myname/Calendar/personal/35510630-b071-4e25-9ea6-c0663c058bd3.ics HTTP/1.1 404 208/929 0.007 - - 0 Nov 10 15:48:57 sogod [30662]: [ERROR] 0x0x9615dfc[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_version,a.c_creationdate,a.c_lastmodified,b.c_component,a.c_content FROM sogo001004580015c1631b6_quick a, sogo001004580015c1631b6 b WHERE (a.c_name = '08ccacd1-0c80-4a48-b319-fdc0ab7a6d4e.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x9590b3c NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x960fe8c[PostgreSQL72Channel]: connection=0x0x96101e4[PGConnection]: connection=0x0x960b850): ERROR: column a.c_version does not exist at character 17 2011-11-10 15:48:57.395 sogod[30662] ERROR(+[CardGroup cardParser]): did not find a parser for text/x-vcard! localhost.localdomain - - [10/Nov/2011:15:48:57 GMT] PUT /SOGo/dav/myname/Calendar/personal/08ccacd1-0c80-4a48-b319-fdc0ab7a6d4e.ics HTTP/1.1 404 208/3778 0.009 - - 0 Nov 10 15:48:57 sogod [30662]: [ERROR] 0x0x95ec83c[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_version,a.c_creationdate,a.c_lastmodified,b.c_component,a.c_content FROM sogo001004580015c1631b6_quick a, sogo001004580015c1631b6 b WHERE (a.c_name = '7d4ae675-d38a-48ea-a9e9-79a9c93b8124.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x9590bdc NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x96151b4[PostgreSQL72Channel]: connection=0x0x961550c[PGConnection]: connection=0x0x95c9bb0): ERROR: column a.c_version does not exist at character 17 2011-11-10 15:48:57.404 sogod[30662] ERROR(+[CardGroup cardParser]): did not find a parser for text/x-vcard! localhost.localdomain - - [10/Nov/2011:15:48:57 GMT] PUT /SOGo/dav/myname/Calendar/personal/7d4ae675-d38a-48ea-a9e9-79a9c93b8124.ics HTTP/1.1 404 208/1412 0.007 - - 0 Nov 10 15:48:57 sogod [30662]: [ERROR] 0x0x961a424[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_version,a.c_creationdate,a.c_lastmodified,b.c_component,a.c_content FROM sogo001004580015c1631b6_quick a, sogo001004580015c1631b6 b WHERE (a.c_name = '105ab393-5694-48a2-8207-cd98fbc437ec.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x95c83ec NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x960fe8c[PostgreSQL72Channel]: connection=0x0x96101e4[PGConnection]: connection=0x0x960b850): ERROR: column a.c_version does not exist at character 17 2011-11-10 15:48:57.412 sogod[30662] ERROR(+[CardGroup cardParser]): did not find a parser for text/x-vcard! localhost.localdomain - - [10/Nov/2011:15:48:57 GMT] PUT /SOGo/dav/myname/Calendar/personal/105ab393-5694-48a2-8207-cd98fbc437ec.ics HTTP/1.1 404 208/1969 0.008 - - 0 Nov 10 15:48:57 sogod [30662]: [ERROR] 0x0x960e80c[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_version,a.c_creationdate,a.c_lastmodified,b.c_component,a.c_content FROM sogo001004580015c1631b6_quick a, sogo001004580015c1631b6 b WHERE (a.c_name
[SOGo] Sieve vacation not working
Hi, I activated Sieve support in Cyrus and SOGo and mail fowardings are working fine. But vacation mails are not send. Any ideas what goes wrong? I already checked out if it is related to duplicate suppression in Cyrus but it doesn't seem to be the source of the problem. Regards, Burkart Burkart Orlowski --- Onlinehelp24 Lerchenstraße 28a * D-22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Changing sogo user on TB mantains all old calendars and address books
Have you tried to delete the TB caches? Windows Vista c:\User\USERNAME\AppData\Roaming\Thunderbird\Profiles\PROFILE_NAME\calendar-data Windows XP c:\Documents\USERNAME\Application Data\Thunderbird\Profiles\PROFILE_NAME\calendar-data That worked for me. Burkart Orlowski --- Onlinehelp24 Lerchenstraße 28a * D-22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net On 08.09.2011, at 12:38, Alessio Fattorini wrote: Someone has solved this problem quickly? http://www.sogo.nu/bugs/view.php?id=1440 -- Alessio Fattorini (alessio.fattor...@nethesis.it) nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU) tel. +39 0721 405516 - fax +39 0721 268147 www.nethesis.it - i...@nethesis.it -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can't send emails via the webinterface?
Have you checked this? http://www.sogo.nu/english/nc/support/faq/article/cant-send-mail-via-the-the-web-interface-2.html postconf -e strict_rfc821_envelopes=no Burkart Orlowski --- Onlinehelp24 Lerchenstraße 28a * D-22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net On 09.09.2011, at 20:16, sgu...@web.de sgu...@web.de wrote: Hi, I'v installed Dovecot, Postfix and SOGo under Ubuntu Server 10.04. The access to the IMAP-account via the webinterface works. But when I try to send an email via the webinterface I get the message Warning Cannot send message: all recipients are invalid. The log says C: connect to 0x0x98ab618[NGInternetSocketAddress]: host=192.168.1.1 not-filled S: SMTP-Reply: code=220 line='testserver ESMTP Postfix (Ubuntu)' C: EHLO testserver.local S: SMTP-Reply: code=250 line='DSN' S: pipelining extension supported. S: size extension supported. C: MAIL FROM:testuser@testserver C: RCPT TO:t...@gmx.net Sep 09 19:10:03 sogod [1743]: 0x0x95bc3e8[SOGoMailer] error with recipient 't...@gmx.net' C: QUIT S: SMTP-Reply: code=221 line='2.0.0 Bye' 2011-09-09 19:10:03.971 sogod[1743] ERROR: could not open MySQL4 connection to database 'sogo': Can't connect to MySQL server on '192.168.1.1' (111) Sep 09 19:10:03 sogod [1743]: [ERROR] 0x0x952e8f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x97e1050] connection=0x(null) for URL: mysql://sogo:sogopasswd@192.168.1.1:3306/sogo/sogo_user_profile Sep 09 19:10:03 sogod [1743]: [WARN] 0x0x952e8f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2011-09-09 19:10:03 +0200 Sep 09 19:10:03 sogod [1743]: [ERROR] 0x0x97ca048[SOGoSQLUserProfile] failed to acquire channel for URL: mysql://sogo:sogopasswd@192.168.1.1:3306/sogo/sogo_user_profile 127.0.0.1 - - [09/Sep/2011:19:10:03 GMT] POST /SOGo/so/testuser/Mail/0/folderDrafts/newDraft1315588172-1/send HTTP/1.1 200 84/2244 17.084 - - 256K Any ideas, I struggle with it for hours without success? Rgds -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] cannot send message: (smtp) originator not accepted
The culprit really was smtpd_tls_security_level = encrypt. When I set it
to may it worked right away though I had to leave
strict_rfc821_envelopes to no.
Thanks p@arick
On Mon, 2011-09-05 at 23:49 +0200, Patrick Ben Koetter wrote:
* Burkart Orlowski | Onlinehelp24 users@sogo.nu:
I narrowed it down to:
C: connect to 0x0x9085de0[NGInternetSocketAddress]: host=127.0.0.1
not-filled
2011-09-05 23:28:12.414 sogod[13599] SMTP: reply has invalid format ((nil))
2011-09-05 23:28:12.415 sogod[13599] Could not connect to the SMTP server
127.0.0.1 on port 25
There was 127.0.0.1/8 missing in mynetworks. Now the error message is:
Cannot send message: error when connecting to the SMTP server.
postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
inet_interfaces = all
inet_protocols = ipv4
mailbox_size_limit = 0
mailbox_transport = cyrus
mydestination = localhost.localdomain, localhost
That's all? Your server should only accept mail for localhost.localdomain and
localhost?
myhostname = server
mynetworks = 127.0.0.1/8 192.168.178.0/24
readme_directory = no
recipient_delimiter = +
relayhost = smtprelaypool.ispgateway.de
sender_canonical_maps = hash:/etc/postfix/sender_canonical
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_password
smtp_sasl_security_options = noanonymous
smtp_sender_dependent_authentication = yes
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) ($mail_version)
smtpd_recipient_restrictions = permit_mynetworks,
permit_sasl_authenticated,reject
If you accept messages from the outside and if your host is exposed to the
Internet directly you will be flooded with Spam unless you add more options to
$smtpd_recipient_restrictions. Join postfix-us...@de.postfix.org and we will
help you to develop a policy that works for your requirements.
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_path = smtpd
smtpd is the default for $smtpd_sasl_path. No need to set it.
smtpd_sasl_security_options = noanonymous
smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
smtpd_tls_security_level = encrypt
Here you go. You require ANY client to speak TLS or you drop the connection.
This doesn't work for SOGo. Choose may and it will work.
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
strict_rfc821_envelopes = no
You want strict_rfc821_envelopes = yes to get rid of spam.
p@rick
--
state of mind ()
http://www.state-of-mind.de
Franziskanerstraße 15 Telefon +49 89 3090 4664
81669 München Telefax +49 89 3090 4666
Amtsgericht MünchenPartnerschaftsregister PR 563
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] cannot send message: (smtp) originator not accepted
Hi there, I figured out that I am able to receive IMAP mails with the web interface but cannot send mails via SMTP. There's an error message saying: cannot send message: (smtp) originator not accepted. The postfix parameter strict_rfc821_envelopes=no didn't change that fact. Any ideas what might be wrong? Cheers, Burkart Burkart Orlowski --- Onlinehelp24 Lerchenstraße 28a * D-22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] cannot send message: (smtp) originator not accepted
unfortunately syslog does not say much: postfix/smtpd[12133]: connect from server[127.0.0.1] postfix/smtpd[12133]: disconnect from server[127.0.0.1] Burkart On 05.09.2011, at 21:39, Patrick Ben Koetter wrote: * Burkart Orlowski | Onlinehelp24 users@sogo.nu: I figured out that I am able to receive IMAP mails with the web interface but cannot send mails via SMTP. There's an error message saying: cannot send message: (smtp) originator not accepted. That doesn't look like a Postfix error message. The postfix parameter strict_rfc821_envelopes=no didn't change that fact. Any ideas what might be wrong? Had a look log? p@rick -- state of mind () http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht MünchenPartnerschaftsregister PR 563 -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] cannot send message: (smtp) originator not accepted
Thanks for your replies so far. The SOGo log file says: C: connect to 0x0x8d0d868[NGInternetSocketAddress]: host=127.0.0.1 not-filled S: SMTP-Reply: code=220 line='server ESMTP Postfix (Ubuntu) (2.7.0)' C: EHLO server S: SMTP-Reply: code=250 line='DSN' S: pipelining extension supported. S: size extension supported. C: MAIL FROM:c.t...@test-ev.de C: QUIT S: SMTP-Reply: code=221 line='2.0.0 Bye' Any suggestions? Burkart On 05.09.2011, at 22:57, Patrick Ben Koetter wrote: * Christian Holzberger users@sogo.nu: is 127.0.0.1/32 in mynetworks / is it a trusted source for sending mail? The error says: cannot send message: (smtp) originator not accepted This is a client issue (cannot send) not a server problem (cannot accept/receive). I would take a look at the sogo.log. It should say why it can't send or why Postfix won't accept the message. p@rick -- state of mind () http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht MünchenPartnerschaftsregister PR 563 -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] cannot send message: (smtp) originator not accepted
I narrowed it down to:
C: connect to 0x0x9085de0[NGInternetSocketAddress]: host=127.0.0.1 not-filled
2011-09-05 23:28:12.414 sogod[13599] SMTP: reply has invalid format ((nil))
2011-09-05 23:28:12.415 sogod[13599] Could not connect to the SMTP server
127.0.0.1 on port 25
There was 127.0.0.1/8 missing in mynetworks. Now the error message is:
Cannot send message: error when connecting to the SMTP server.
postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
inet_interfaces = all
inet_protocols = ipv4
mailbox_size_limit = 0
mailbox_transport = cyrus
mydestination = localhost.localdomain, localhost
myhostname = server
mynetworks = 127.0.0.1/8 192.168.178.0/24
readme_directory = no
recipient_delimiter = +
relayhost = smtprelaypool.ispgateway.de
sender_canonical_maps = hash:/etc/postfix/sender_canonical
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_password
smtp_sasl_security_options = noanonymous
smtp_sender_dependent_authentication = yes
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) ($mail_version)
smtpd_recipient_restrictions = permit_mynetworks,
permit_sasl_authenticated,reject
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_path = smtpd
smtpd_sasl_security_options = noanonymous
smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
smtpd_tls_security_level = encrypt
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
strict_rfc821_envelopes = no
On 05.09.2011, at 23:26, Patrick Ben Koetter wrote:
* Burkart Orlowski | Onlinehelp24 users@sogo.nu:
Thanks for your replies so far.
The SOGo log file says:
C: connect to 0x0x8d0d868[NGInternetSocketAddress]: host=127.0.0.1
not-filled
S: SMTP-Reply: code=220 line='server ESMTP Postfix (Ubuntu) (2.7.0)'
C: EHLO server
S: SMTP-Reply: code=250 line='DSN'
S: pipelining extension supported.
S: size extension supported.
C: MAIL FROM:c.t...@test-ev.de
C: QUIT
S: SMTP-Reply: code=221 line='2.0.0 Bye'
Any suggestions?
It looks as if Postfix doesn't like what the client says.
Output from postconf -n please.
p@rick
--
state of mind ()
http://www.state-of-mind.de
Franziskanerstraße 15 Telefon +49 89 3090 4664
81669 München Telefax +49 89 3090 4666
Amtsgericht MünchenPartnerschaftsregister PR 563
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] ZEG in a production environment?
Hey, here you'll find pretty good descriptions: http://tracker.openchange.org/projects/openchange/wiki/HowTo_Setup_SOGo_with_OpenChange_Server and http://www.clearfoundation.com/docs/howtos/sogo_groupware_with_thunderbird_sync Let me know if you still have any questions. Burkart Burkart Orlowski --- Onlinehelp24 Lerchenstraße 28a * D-22767 Hamburg Web: www.onlinehelp24.net Email: b.orlow...@onlinehelp24.net Telefon: +49 40 20931222 Mobil: +49 162 2110111 Facebook: http://www.facebook.com/onlinehelp24 Blog: http://blog.onlinehelp24.net On 18.08.2011, at 15:14, Wendell Hatcher wrote: Hello, I am a complete noob to SOGO, Openldap and postifx. I was wondering is there a guide to properly setup the system requirements for Sogo? And, if not can someone point me toward a guide for this? Finally, can ZEG be used in a production environment or is it strictly used for test? -Dell -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
