[SOGo] Nightly builds now working?
Good day everyone, is something wrong with the nightly builds? Last update i got is 5.8.4.20230807. Cheers Juergen smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Vacation message - combining date and time possible/intended?
Am 17.04.2023 um 10:47 schrieb Marco Moock (marco.mo...@urz.uni-heidelberg.de): Hello! We have SOGo 5.8.2. Some people use vacation messages, they assumed that time and date can be combined, e.g. turn on vacation reply on 2023-01-01 at 4:00 AM and turn it off at 2023-01-20 6:00 PM. Is that intended usage? Hi, it is not intended usage. There is a feature request about that: https://bugs.sogo.nu/view.php?id=5537
Re: [SOGo] ANN: official transfer to Alinto
Am Montag, August 08, 2022 21:24 CEST, schrieb "Francis Lachapelle" (flachape...@inverse.ca) : > Dear community users, > > In the upcoming days, we will officially transfer the ownership of the SOGo > open source project to Alinto. There will be two major impacts to this > transfer: > > - Members of this mailing list will need to resubscribe. The mailing list > address won't change (users@sogo.nu), but the infrastructure will moved to a > new server (https://mailing.sogo.nu/) with no data migration. > - Binary packages of SOGo and SOPE will be available from a different URL > (https://packages.sogo.nu). The installation instructions on the Website will > be updated accordingly. > > Let me know if you have any question. > > Thank you, > > Francis > -- > users@sogo.nu > https://inverse.ca/sogo/lists Hi, i guess the new repos should already work, but it seems the packages are not signed right now (RockyLinux 8). Package sogo-5.7.1.20220813-1.el8.x86_64.rpm is not signed Package sogo-tool-5.7.1.20220813-1.el8.x86_64.rpm is not signed Package sope49-cards-5.7.1.20220813-1.el8.x86_64.rpm is not signed Package sope49-gdl1-contentstore-5.7.1.20220813-1.el8.x86_64.rpm is not signed Greetings and thanks for all your hard work. Juergen smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] /usr/sbin/sogo-tool update-autoreply - "removing" enabled autoreplies
Am Montag, Juli 11, 2022 08:39 CEST, schrieb Götz Reinicke (goetz.reini...@filmakademie.de) : > Hi, > > The output of the sogo-tool shows some „Removed auto-reply of user“ for users > who still have (and want) the autoreply enabled. > > Is that a false log-message? > > Regards . Götz Hi Götz, do your users have a time set in their autoreply? We had it that users set start time for first day of vacation, and SOGo disables it at 00:00 and enables again at start time. They thought you can set start time for first day of vacation, so the message enables when leaving the office on the last day. But that doesn't work. smime.p7s Description: S/MIME cryptographic signature
[SOGo] Vacation messages start/end time/date
Hi, some of our users activating vacation messages with start day and end day, but also a start and end time. Those vacation messages are getting deactivated by sogo-tool. I didn't find a proper documentation on how that should work. Is there any documentation bit i can read or is somebody able to explain what it's supposed to do? Maybe a better hint in the webui would be good. Cheers and thanks Juergen smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] users@sogo.nu
Hi, https://www.sogo.nu/bugs/view.php?id=5485#c15941 login to mysql and enter: use sogo; drop table sogo_sessions_folder; restart sogo. Am Dienstag, März 15, 2022 22:14 CET, schrieb Damien Brémont (damien.brem...@casadevelazquez.org) : > Hi Folks, > > We recently updated to the latest nightly-buid version (5.5.1.20220315-1) > > Since the update user session expire after a few minutes, even with a > high sogo-tool expire-sessions cron value. > In sogo log, we have an expired session notice, followed by a wrong password > > [SOGoWebAuthenticator]>Expired session received, redirecting to login page. > [SOGoWebAuthenticator]> tried wrong password for user > > We tried to increase PHP session lifetime, but, without success. > > Do you have any idea? > > Thanks > > Best > Damien > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- Mit freundlichen GrüßenJürgen EchterECHTER Küchen & Elektro GmbHAugsburger Str. 4986529 SchrobenhausenTel: 08252 / 8976 - 0Fax: 08252 / 8976 - 10e-mail: mailto:i...@echter-kuechen-elektro.de";>i...@echter-kuechen-elektro.deweb: https://www.echter-kuechen-elektro.de";>www.echter-kuechen-elektro.dehttps://de-de.facebook.com/EchterSOB/";> https://www.instagram.com/echter_kuechen_elektro/";>Reg.-Gericht: Ingolstadt Nr. HR B 101907Ust.-Id. Nr.: DE234419866Steuernummer: 124/125/51166Geschäftsführer: Thomas EchterDatenschutz: https://www.echter-kuechen-elektro.de/recht/datenschutz";>Link zu unserer Homepage smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Not able to log-in on latest nightly build
Hi, the fix for me was: mysql use sogo; drop table sogo_sessions_folder; restart sogo. As mentionend in the fix here: https://www.sogo.nu/bugs/view.php?id=5485#c15941 My problem wasn't that i couldn't login, but i got disconnected after a few minutes without running the cronjob to expire sessions. Am Freitag, März 11, 2022 21:40 CET, schrieb "jack Bamford" (j...@violetdragonsnetwork.co.uk) : Hi, Thanks for you reply, I have specified that from /etc/nginx/templates/sogo.tmpl i have the following, proxy_connect_timeout 3540; proxy_send_timeout 3540; proxy_read_timeout 3540; also added the following to Haproxy timeout connect 5450 timeout server 3540 retries 3 Does that look okay or should i change it? Thanks. Jack. On 11/03/2022 18:51, Sayso Tech Support (supp...@sayso.net) wrote: This sounds like the same issue we were having. The fix we used is posted on the iRedMail forum HERE---Andrew McRory / SSA Sayso Communications, Inc. On 2022-03-10 17:27, Jens Christian Skov wrote: Good day again, Happy to let you know that I've been able to resolve this issue. Turned out the latest nightly was causing a buffer issue in my Nginx proxy running in front of SOGo. Discovered the issue by debugging the website, and found a 502 response from the proxy server when trying to log in. In the Nginx error log-file I found the following: 2022/03/10 22:13:55 [error] 705#0: *240353 upstream sent too big header while reading response header from upstream, client: 10.5.x.x, server: sogo.domain.tld, request: "POST /SOGo/connect HTTP/2.0", upstream: "http://10.2.x.x:80/SOGo/connect";, host: "sogo.domain.tld", referrer: "https://sogo.domain.tld/SOGo/ Not sure why the latest nightly requires a larger proxy_buffer in Nginx (?). On 10/03/2022 21.54, Jens Christian Skov (j...@floyd.dk) wrote: Good day, Just upgraded my installation to the latest nightly build 5.5.1.20220310 to try to solve the issue with autocomplete not working, however this kind of broke my installation. When I'm trying to log in on the web interface I get an "Unhandled error response" in the browser. Issue seems to be related to the fix for long passwords: https://www.sogo.nu/bugs/view.php?id=5485 I've deleted the table, restarted both Sogo and the machine. New table was created allowing for the longer passwords. When looking at the log-file, I do not see any errors on the back end. The following is logged when I try to log-in. Mar 10 21:49:18 sogod [2206]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Mar 10 21:49:19 sogod [2206]: SOGoRootPage successful login from '10.5.x.x, 10.2.x.x' for user 'u...@domain.tld' - expire = -1 grace = -1 Mar 10 21:49:19 sogod [2206]: |SOGo| request took 0.018492 seconds to execute Mar 10 21:49:19 sogod [2206]: 10.5.x.x, 10.2.x.x "POST /SOGo/connect HTTP/1.1" 200 49/93 0.020 - - 0 - 15 The following is my debug settings in sogo.conf /* Debug */ SOGoDebugRequests = YES; SoDebugBaseURL = YES; ImapDebugEnabled = YES; //LDAPDebugEnabled = YES; PGDebugEnabled = YES; //MySQL4DebugEnabled = YES; SOGoUIxDebugEnabled = YES; WODontZipResponse = YES; SOGoEASDebugEnabled = YES; This issue only affects log-in from Web. Login using carddav/caldav appears to be working fine. Thank you in advance for any advice on how to solve this.-- Venlig hilsen / Kind Regards Jens Christian Skov-- users@sogo.nu https://inverse.ca/sogo/lists-- Venlig hilsen / Kind Regards Jens Christian Skov Jens Christian Skov FLOYD Interactive.dk Hammeren 32, 1, 196 DK-2630 Taastrup Denmark j...@floyd.dk +45 40 17 79 93This e-mail is intended exclusively for the addressee. If you are not the addressee you must not read, copy, use or disclose the e-mail nor the content; please notify us immediately [by clicking 'Reply'] and delete this e-mail.-- users@sogo.nu https://inverse.ca/sogo/lists-- users@sogo.nu https://inverse.ca/sogo/lists-- VioletDragons Network VioletDragons Projects Violets Data Center Malvern United Kingdom Phone: +44(0)7413 601663 Email: j...@violetdragonsnetwork.co.uk Website: www.violetdragonsnetwork.co.uk-- users@sogo.nu https://inverse.ca/sogo/lists smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] SOGo Connector v78.0.1 Add-On installation on Thunderbird
Am Dienstag, Februar 15, 2022 12:38 CET, schrieb "armin.v...@mmlab.de" : Hi, downloaded the SOGo connector v78.0.1 from https://www.sogo.nu/download.html#/frontends and installed it on my Thunderbird v91. This added an address book called "public" to my address books pointing to demo.sogo.nu or similar. Now it always asks me for credentials. Deleting this address book is refused. What am I missing? Why is there no link to a documentation on the download page? Thank you for pointing me in the right direction! Regards -- Armin __ Information from mm-lab IT security __The message was checked by ESET Mail Security. -- users@sogo.nu https://inverse.ca/sogo/listsHi, you have to edit it to point to your server. https://github.com/inverse-inc/sogo-connector Maybe you missed that. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Less filter options
Am Donnerstag, Dezember 09, 2021 18:32 CET, schrieb "Paul van der Vlis" (p...@vandervlis.nl) : Op 09-12-2021 om 16:21 schreef Christian Mack (christian.m...@uni-konstanz.de): > Hello > > On 09.12.21 00:18, Paul van der Vlis (p...@vandervlis.nl) wrote: >> Hello, >> >> I would like to upgrade SOGo from version 3.2.6 to 5.0.1, and I am >> wondering there are less filter options in 5.0.1. >> >> For example I don't see an action "File the message in ...". >> >> What will be wrong? >> > > This function has moved. > You have to select an email by clicking on the person icon in front of > it in the list, then use the three dots menu above the list --> "Move To". > > You can move multiple emails at the same time with this, by selecting > multiple emails at once. Thanks for your reply! I want to make a filter what moves mail. For example move all mail with [SOGO] in the subject to a folder called "Sogo". Is that possible in this way? I could move messages, but do not saw an option for making a filter out of it... With regards, Paul -- Paul van der Vlis Linux systeembeheer Groningen https://www.vandervlis.nl/ -- users@sogo.nu https://inverse.ca/sogo/listsHi, you can go to settings -> e-mail -> filters -> add filter and choose which rules to apply and where to put that mails. Juergen -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-connector with thunderbird 78 (32-bit),windows 10, sogo 2.x doesn't sync events properly.
Hi, yes i totally used that one. Am 14.07.2021 um 17:42 schrieb Christian Mack (christian.m...@uni-konstanz.de): Hello Then you still have to use the beta SOGo Connector, which best works with Thunderbird v78.8.1 Check github: https://github.com/inverse-inc/sogo-connector/blob/master/README.md Kind regards, Christian Mack Am 14.07.21 um 17:24 schrieb Jürgen Echter (j.ech...@echter-kuechen-elektro.de): Hi, we do not use address books that much, my main problem is event synchronization. Tasks are also rarely used. I thought it would be reliable for event synchronization at least as all the talk about a new plugin has slowed down and also the mentionend RELEASE-NOTES say: 78.0.0 Thunderbird 78 support. Major refactoringto use Thunderbird's CalDAV code togetherwith all the required changes for Thunderbird v78 support Greetings Juergen Am Mittwoch, Juli 14, 2021 16:59 CEST, schrieb "Christian Mack" (christian.m...@uni-konstanz.de) : Hi SOGo Connector is not compatible with Thunderbird 78+ Therefore no synchronisation with address book at all. There is a beta Version available, but: * No synchronisation of address lists, only address cards * No support for read only address books * No search only address books, it always tries to download all address cards from an address book. Those are restrictions every cardDAV Add-On is facing, because Thunderbird 78+ lacks internal interface and/or functionality for those. Kind regards. Christian Mack Am 14.07.21 um 16:04 schrieb Jürgen Echter (j.ech...@echter-kuechen-elektro.de): Hi, we recently upgraded from thunderbird 68.x to thunderbird 78.11 and now we face the issue that events added to mariadb database do not sync within thunderbird (there were about 5 hours between creation of the event and still not showing up in thunderbird). Initial sync worked fine, it synced the missing event after i deleted c:/users/username/appdata/roaming/thunderbird/profiles/calendar-data/*, then one test event got synced but after that it stopped syncing it again. The web-ui is not having this issue, events are there immediately, also mobile phones work as expected. I cloned the github repo, copied custom/sogo-demo custom/mysite and edited sogo-connector.baseURL to our server, then i did make distclean && make build=mysite and installed the plugin in thunderbird. Release notes say thunderbird 78 should be supported: https://github.com/inverse-inc/sogo-connector/blob/master/RELEASE-NOTES Anything i can provide or try to resolve this? Or maybe anyone had similar issues? Greets Juergen -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-connector with thunderbird 78 (32-bit),windows 10, sogo 2.x doesn't sync events properly.
Hi, we do not use address books that much, my main problem is event synchronization. Tasks are also rarely used. I thought it would be reliable for event synchronization at least as all the talk about a new plugin has slowed down and also the mentionend RELEASE-NOTES say: 78.0.0 Thunderbird 78 support. Major refactoringto use Thunderbird's CalDAV code togetherwith all the required changes for Thunderbird v78 support Greetings Juergen Am Mittwoch, Juli 14, 2021 16:59 CEST, schrieb "Christian Mack" (christian.m...@uni-konstanz.de) : Hi SOGo Connector is not compatible with Thunderbird 78+ Therefore no synchronisation with address book at all. There is a beta Version available, but: * No synchronisation of address lists, only address cards * No support for read only address books * No search only address books, it always tries to download all address cards from an address book. Those are restrictions every cardDAV Add-On is facing, because Thunderbird 78+ lacks internal interface and/or functionality for those. Kind regards. Christian Mack Am 14.07.21 um 16:04 schrieb Jürgen Echter (j.ech...@echter-kuechen-elektro.de): > Hi, > > we recently upgraded from thunderbird 68.x to thunderbird 78.11 and now we > face the issue that events added to mariadb database do not sync within > thunderbird (there were about 5 hours between creation of the event and still > not showing up in thunderbird). > > Initial sync worked fine, it synced the missing event after i deleted > c:/users/username/appdata/roaming/thunderbird/profiles/calendar-data/*, then > one test event got synced but after that it stopped syncing it again. > > The web-ui is not having this issue, events are there immediately, also > mobile phones work as expected. > > I cloned the github repo, copied custom/sogo-demo custom/mysite and edited > sogo-connector.baseURL to our server, then i did make distclean && make > build=mysite and installed the plugin in thunderbird. > > Release notes say thunderbird 78 should be supported: > https://github.com/inverse-inc/sogo-connector/blob/master/RELEASE-NOTES > > Anything i can provide or try to resolve this? Or maybe anyone had similar > issues? > > Greets > > Juergen > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre 78457 Konstanz +49 7531 88-4416 -- Mit freundlichen Grüssen Jürgen Echter ECHTER Küchen & Elektro GmbH Augsburger Str. 49 86529 Schrobenhausen Tel: 08252 / 8976 - 0 Fax: 08252 / 8976 - 10 e-mail: i...@echter-kuechen-elektro.de web: www.echter-kuechen-elektro.deReg.-Gericht: Ingolstadt Nr. HR B 101907 Ust.-Id. Nr.: DE234419866 Steuernummer: 124/125/51166 Geschäftsführer: Thomas Echter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] sogo-connector with thunderbird 78 (32-bit),windows 10, sogo 2.x doesn't sync events properly.
Hi, we recently upgraded from thunderbird 68.x to thunderbird 78.11 and now we face the issue that events added to mariadb database do not sync within thunderbird (there were about 5 hours between creation of the event and still not showing up in thunderbird). Initial sync worked fine, it synced the missing event after i deleted c:/users/username/appdata/roaming/thunderbird/profiles/calendar-data/*, then one test event got synced but after that it stopped syncing it again. The web-ui is not having this issue, events are there immediately, also mobile phones work as expected. I cloned the github repo, copied custom/sogo-demo custom/mysite and edited sogo-connector.baseURL to our server, then i did make distclean && make build=mysite and installed the plugin in thunderbird. Release notes say thunderbird 78 should be supported: https://github.com/inverse-inc/sogo-connector/blob/master/RELEASE-NOTES Anything i can provide or try to resolve this? Or maybe anyone had similar issues? Greets Juergen -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Vacation auto-reply only one day per week ?
Hi,
maybe you can write a small bash script and run it with cron.
#!/bin/bash
DAYOFWEEK=$(date +"%u")
if [[ ($DAYOFWEEK -eq 3) ]]; then
grep -qsxF '{ vacation :days 1 :addresses ["your@mail.address"] text: I'm out
of office.; }' /path/to/your/sieve/sogo.sieve || printf "{ vacation :days 1
:addresses ["your@mail.address"] text: I'm out of office.; }" >>
/path/to/your/sieve/sogo.sieve
elif
sed -i '{ vacation :days 1 :addresses ["your@mail.address"] text: I'm out of
office.; }/d' /path/to/your/sieve/sogo.sieve
fi
untested :)
Juergen
Am Donnerstag, Mai 20, 2021 10:31 CEST, "Pierre Fumet" (p...@zdn.fr)
schrieb:
Hi all,
SOGo webmail can activate vacation auto-reply and schedule beginning and end
for this activation.
But would it be possible to schedule auto-reply only one day each week, eg. on
wednesday ?
Cheers,
--
Pierre Fumet
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
Mit freundlichen GrÃŒssen
JÃŒrgen EchterECHTER KÃŒchen & Elektro GmbH
Augsburger Str. 49
86529 Schrobenhausen
Tel: 08252 / 8976 - 0
Fax: 08252 / 8976 - 10
e-mail: i...@echter-kuechen-elektro.de
web: www.echter-kuechen-elektro.deReg.-Gericht: Ingolstadt Nr. HR B 101907
Ust.-Id. Nr.: DE234419866
Steuernummer: 124/125/51166
GeschÀftsfÌhrer: Thomas Echter
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] Google Authenticator doesn't scan the qr code
Hi, i'd like to enable 2FA with google authenticator. I see the option to enable it, i see the qr-code. Problem is, i see the qr-code but google authenticator app doesnt scan it. Is there anything else what i need to do? Best regards juergen -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Solved - Re: sogo doesn't load after successful login 500 request failed - sogo-5.1.0.20210422-1.el7.x86_64.rpm
Hi, i found the error, the error had nothing to do with SOGo. I installed the original httpd.conf file and did a diff on it and tried every modification that had been made one by one and it turned out that this line: Header edit Set-Cookie ^(.*)$ $1;HttpOnly;Secure stopped it from working. I don't know when this settings was set, but it did work for a long while, that's why i focussed on SOGo, as i did a update on the same day i realized it didn't work anymore. Have a nice week Juergen Am Dienstag, April 27, 2021 08:32 CEST, Jürgen Echter (j.ech...@echter-kuechen-elektro.de) schrieb: Hi, can anyone tell me how to debug this? I don't see any error in any logs related to this, only those empty responses, but i'm no expert :) I'm also running SOGo V2 on the same database which works pretty well. Meanwhile i also updated to the latest nightly. Syncing of calendar data seems to work too. I enabled the following debugging settings in sogo.conf: GCSFolderDebugEnabled = YES; GCSFolderStoreDebugEnabled = YES; LDAPDebugEnabled = YES; NGImap4DisableIMAP4Pooling = YES; ImapDebugEnabled = YES; SMTPDebugEnabled = YES; OCSFolderManagerSQLDebugEnabled = YES; SOGoDebugRequests = YES; SOGoMailKeepDraftsAfterSend = YES; SOGoUIxDebugEnabled = YES; SoDebugObjectTraversal = YES; SoSecurityManagerDebugEnabled = YES; WODontZipResponse = YES; WODebugZipResponse = YES; SOGoEASDebugEnabled = YES; MySQL4DebugEnabled = YES; PGDebugEnabled = YES; Heres a log with debugging enabled Apr 27 08:19:11 sogod [13862]: version 5.1.0 (build root@shiva2.inverse 202104260046) -- starting Apr 27 08:19:11 sogod [13862]: vmem size check enabled: shutting down app when vmem > 512 MB. Currently at 339 MB Apr 27 08:19:11 sogod [13862]: <0x0x55796ad1f460[SOGoProductLoader]> SOGo products loaded from '/usr/lib64/GNUstep/SOGo': Apr 27 08:19:11 sogod [13862]: <0x0x55796ad1f460[SOGoProductLoader]> AdministrationUI.SOGo, Appointments.SOGo, CommonUI.SOGo, Contacts.SOGo, ContactsUI.SOGo, MailPartViewers.SOGo, Mailer.SOGo, MailerUI.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo Apr 27 08:19:11 sogod [13862]: All products loaded - current memory usage at 377 MB Apr 27 08:19:11 sogod [13862]: <0x0x55796ab620b0[WOWatchDog]> listening on 127.0.0.1:2 Apr 27 08:19:11 sogod [13862]: <0x0x55796ab620b0[WOWatchDog]> watchdog process pid: 13862 Apr 27 08:19:11 sogod [13862]: <0x0x7f4975906c00[WOWatchDogChild]> watchdog request timeout set to 10 minutes Apr 27 08:19:11 sogod [13862]: <0x0x55796ab620b0[WOWatchDog]> preparing 3 children Apr 27 08:19:11 sogod [13862]: <0x0x55796ab620b0[WOWatchDog]> child spawned with pid 13863 Apr 27 08:19:11 sogod [13862]: <0x0x55796ab620b0[WOWatchDog]> child spawned with pid 13864 Apr 27 08:19:11 sogod [13862]: <0x0x55796ab620b0[WOWatchDog]> child spawned with pid 13865 2021-04-27 08:19:11.275 sogod[13863] MySQL4 connection established 0x0x55796ae809c0 2021-04-27 08:19:11.275 sogod[13863] -- -[MySQL4Channel openChannel]: opens channel count[0] 2021-04-27 08:19:11.275 sogod[13863] MySQL4 channel 0x0x55796acf68f0 opened (connection=0x0x55796ae809c0,sogo) 2021-04-27 08:19:11.275 sogod[13863] SQL: SELECT count(*) FROM sogo_user_profile; 2021-04-27 08:19:11.275 sogod[13864] MySQL4 connection established 0x0x55796ae809c0 2021-04-27 08:19:11.275 sogod[13864] -- -[MySQL4Channel openChannel]: opens channel count[0] 2021-04-27 08:19:11.276 sogod[13864] MySQL4 channel 0x0x55796acf68f0 opened (connection=0x0x55796ae809c0,sogo) 2021-04-27 08:19:11.276 sogod[13864] SQL: SELECT count(*) FROM sogo_user_profile; 2021-04-27 08:19:11.276 sogod[13865] MySQL4 connection established 0x0x55796ae809c0 2021-04-27 08:19:11.276 sogod[13865] -- -[MySQL4Channel openChannel]: opens channel count[0] 2021-04-27 08:19:11.276 sogod[13865] MySQL4 channel 0x0x55796acf68f0 opened (connection=0x0x55796ae809c0,sogo) 2021-04-27 08:19:11.276 sogod[13865] SQL: SELECT count(*) FROM sogo_user_profile; 2021-04-27 08:19:11.276 sogod[13863] query has results, entering fetch-mode. 2021-04-27 08:19:11.276 sogod[13863] SQL: SELECT count(*) FROM sogo_folder_info; 2021-04-27 08:19:11.277 sogod[13864] query has results, entering fetch-mode. 2021-04-27 08:19:11.277 sogod[13864] SQL: SELECT count(*) FROM sogo_folder_info; 2021-04-27 08:19:11.277 sogod[13865] query has results, entering fetch-mode. 2021-04-27 08:19:11.277 sogod[13865] SQL: SELECT count(*) FROM sogo_folder_info; 2021-04-27 08:19:11.277 sogod[13863] query has results, entering fetch-mode. 2021-04-27 08:19:11.279 sogod[13863] SQL: SELECT count(*) FROM sogo_sessions_folder; 2021-04-27 08:19:11.279 sogod[13865] query has results, entering fetch-mode. 2021-04-27 08:19:11.280 sogod[13865] SQL: SELECT count(*) FROM sogo_sessions_folder; 2021-04-27 08:19:1
Re: [SOGo] sogo doesn't load after successful login 500 request failed - sogo-5.1.0.20210422-1.el7.x86_64.rpm
rse name: 'Mail' Apr 27 08:20:05 sogod [13865]: |SOGo| do traverse name: '0' Apr 27 08:20:05 sogod [13863]: |SOGo| do traverse name: 'Mail' Apr 27 08:20:05 sogod [13863]: |SOGo| do traverse name: '0' Apr 27 08:20:05 sogod [13864]: |SOGo| request took 0.017297 seconds to execute Apr 27 08:20:05 sogod [13864]: <0x0x55796b383970[WOResponse]> Zipping of response disabled Apr 27 08:20:05 sogod [13864]: 12.34.56.78 "GET /SOGo/so/some.u...@our.mail.domain/Calendar/alarmslist?browserTime=1619504405 HTTP/1.1" 500 36/0 0.019 - - 44K - 14 Apr 27 08:20:05 sogod [13865]: |SOGo| do traverse name: 'view' Apr 27 08:20:05 sogod [13863]: |SOGo| do traverse name: 'folderINBOX' Apr 27 08:20:05 sogod [13865]: |SOGo| set clientObject: <0x55796b182770[SOGoMailAccount]: name=0 container=0x55796ad1c2d0/Mail> Apr 27 08:20:05 sogod [13865]: |SOGo| request took 0.131991 seconds to execute Apr 27 08:20:05 sogod [13865]: <0x0x55796ae9a490[WOResponse]> Zipping of response disabled Apr 27 08:20:05 sogod [13865]: 12.34.56.78 "GET /SOGo/so/some.u...@our.mail.domain/Mail/0/view HTTP/1.1" 500 36/0 0.133 - - 3M - 13 Apr 27 08:20:05 sogod [13863]: |SOGo| do traverse name: 'view' Apr 27 08:20:05 sogod [13863]: |SOGo| set clientObject: <0x55796b2a7710[SOGoMailFolder]: name=folderINBOX container=0x55796b1874e0/0> Apr 27 08:20:05 sogod [13863]: |SOGo| request took 0.186415 seconds to execute Apr 27 08:20:05 sogod [13863]: <0x0x55796abaa880[WOResponse]> Zipping of response disabled Apr 27 08:20:05 sogod [13863]: 12.34.56.78 "POST /SOGo/so/some.u...@our.mail.domain/Mail/0/folderINBOX/view HTTP/1.1" 500 36/126 0.189 - - 3M - 13 Thanks in advance Juergen Am Donnerstag, April 22, 2021 13:12 CEST, Jürgen Echter (j.ech...@echter-kuechen-elektro.de) schrieb: Hi, i updated to latest nightly SOGo 5 today and it seems something is wrong now. I can login but i don't see my mails. I have no errors in my httpd logs, not in my sql logs and nothing in my imap logs. In my sogo.log i get the following: Apr 22 12:58:26 sogod [7210]: 12.34.56.78 "GET /SOGo/so/user@domain/Mail/view HTTP/1.1" 200 26322/0 0.069 106806 75% 272K - 14 Apr 22 12:58:31 sogod [7210]: 12.34.56.78 "GET /SOGo/so/user@domain/Calendar/alarmslist?browserTime=1619089111 HTTP/1.1" 500 36/0 0.014 - - 0 - 13 Apr 22 12:58:31 sogod [7210]: 12.34.56.78 "GET /SOGo/so/user@domain/Mail/0/view HTTP/1.1" 500 36/0 0.011 - - 0 - 13 Apr 22 12:58:31 sogod [7208]: 12.34.56.78 "POST /SOGo/so/user@domain/Mail/0/folderINBOX/view HTTP/1.1" 500 36/126 0.033 - - 0 - 15 I see 500 Request Failed but i cannot figure out where this exactly comes from. Firefox console tells me the same, for example: XHR GET https://our.sogo.domain/SOGo/so/user@domain/Calendar/alarmslist?browserTime=1619088954 [HTTP/1.1 500 Request Failed 311ms] Here's ssl_request_log from httpd after reloading the page (ctrl + F5): [22/Apr/2021:13:06:34 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo/so/user@domain/Mail/view HTTP/1.1" 26321 [22/Apr/2021:13:06:34 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/lodash.min.js HTTP/1.1" 73015 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-animate.min.js HTTP/1.1" 26809 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-sanitize.min.js HTTP/1.1" 6526 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-cookies.min.js HTTP/1.1" 1331 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-aria.min.js HTTP/1.1" 4203 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-messages.min.js HTTP/1.1" 3223 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Common/sgCkeditor.component.js?lm=1619080177 HTTP/1.1" 11979 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Preferences.services.js?lm=1619080178 HTTP/1.1" 14407 [22/Apr/2021:13:06:36 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Contacts.services.js?lm=1619080178 HTTP/1.1" 18903 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Common.js?lm=1619080178 HTTP/1.1" 83551 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256
[SOGo] sogo doesn't load after successful login 500 request failed - sogo-5.1.0.20210422-1.el7.x86_64.rpm
Hi, i updated to latest nightly SOGo 5 today and it seems something is wrong now. I can login but i don't see my mails. I have no errors in my httpd logs, not in my sql logs and nothing in my imap logs. In my sogo.log i get the following: Apr 22 12:58:26 sogod [7210]: 12.34.56.78 "GET /SOGo/so/user@domain/Mail/view HTTP/1.1" 200 26322/0 0.069 106806 75% 272K - 14 Apr 22 12:58:31 sogod [7210]: 12.34.56.78 "GET /SOGo/so/user@domain/Calendar/alarmslist?browserTime=1619089111 HTTP/1.1" 500 36/0 0.014 - - 0 - 13 Apr 22 12:58:31 sogod [7210]: 12.34.56.78 "GET /SOGo/so/user@domain/Mail/0/view HTTP/1.1" 500 36/0 0.011 - - 0 - 13 Apr 22 12:58:31 sogod [7208]: 12.34.56.78 "POST /SOGo/so/user@domain/Mail/0/folderINBOX/view HTTP/1.1" 500 36/126 0.033 - - 0 - 15 I see 500 Request Failed but i cannot figure out where this exactly comes from. Firefox console tells me the same, for example: XHR GET https://our.sogo.domain/SOGo/so/user@domain/Calendar/alarmslist?browserTime=1619088954 [HTTP/1.1 500 Request Failed 311ms] Here's ssl_request_log from httpd after reloading the page (ctrl + F5): [22/Apr/2021:13:06:34 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo/so/user@domain/Mail/view HTTP/1.1" 26321 [22/Apr/2021:13:06:34 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/lodash.min.js HTTP/1.1" 73015 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-animate.min.js HTTP/1.1" 26809 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-sanitize.min.js HTTP/1.1" 6526 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-cookies.min.js HTTP/1.1" 1331 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-aria.min.js HTTP/1.1" 4203 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-messages.min.js HTTP/1.1" 3223 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Common/sgCkeditor.component.js?lm=1619080177 HTTP/1.1" 11979 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Preferences.services.js?lm=1619080178 HTTP/1.1" 14407 [22/Apr/2021:13:06:36 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Contacts.services.js?lm=1619080178 HTTP/1.1" 18903 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Common.js?lm=1619080178 HTTP/1.1" 83551 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular.min.js HTTP/1.1" 177366 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-ui-router.min.js HTTP/1.1" 117309 [22/Apr/2021:13:06:37 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Mailer.js?lm=1619080178 HTTP/1.1" 4379 [22/Apr/2021:13:06:37 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Scheduler.services.js?lm=1619080178 HTTP/1.1" 95849 [22/Apr/2021:13:06:38 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-file-upload.min.js?lm=1619080178 HTTP/1.1" 23345 [22/Apr/2021:13:06:38 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/FileSaver.min.js?lm=1619080178 HTTP/1.1" 2685 [22/Apr/2021:13:06:37 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/Mailer.services.js?lm=1619080178 HTTP/1.1" 83894 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/ckeditor/ckeditor.js?lm=1619080178 HTTP/1.1" 642225 [22/Apr/2021:13:06:35 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo.woa/WebServerResources/js/vendor/angular-material.min.js HTTP/1.1" 427753 [22/Apr/2021:13:06:42 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo/so/user@domain/Calendar/alarmslist?browserTime=1619089602 HTTP/1.1" 36 [22/Apr/2021:13:06:42 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "POST /SOGo/so/user@domain/Mail/0/folderINBOX/view HTTP/1.1" 36 [22/Apr/2021:13:06:42 +0200] 12.34.56.78 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /SOGo/so/user@domain/Mail/0/view HTTP/1.1" 36 Any hints what may have changed or what i should change would be nice. Greetings Juergen -- users@sogo.nu https://inverse.ca/sogo/lists
