Re: [SOGo] SOGo no longer talking to mysql
Good news, I finally was able to get SOGo back up and running (and using /etc/sogo/sogo.conf, like any sane progarm would do). But be honest people, who on earth should be able to have guessed that "~sogo/" refers to "/var/lib/sogo/"? I already thought I was crazy searching /usr for a .GNUstepDefaults, but this is actually peak insanity. ~ usually is read as /home/username. I think this needs to be clarified in the unmodified sogo.conf, or at least create a possibility to have sogo say where it actually reads the configuration from. I checked /var/lib/sogo/GNUstep/Defaults/ and can tell you SOGo did not read from .GNUstepDefaults as it basically didn't contain any config. It either read from .GNUstepDefaults.bck from 2013 or sogod.plist from 2015. And it does not help in the slightest when sogo-tool reads from /etc/sogo/sogo.conf, while it's not even read by sogod. Thanks anyways to all that came up with ways to find out what's going wrong with the setup. I'm still not really sure how strace would indicate that the mysql user in sogo.conf is being used when sogod clearly must have gotten its config from somewhere else, but that's something people can think about that know more about how sogo actually operates. Richard Am 25.07.2023 um 08:35 schrieb Markus Winkler (m...@irmawi.de): Hi Richard, On Mon, 24 Jul 2023 at 01:40:52PM +0200, Richard Rosner wrote: My biggest problem with the old installation was (which was set up before I became admin and I can't tell if it has been upgraded somehow from SOGo 2.x, which we where using before 5.x, or if it was a fresh install) that when I took over, the whole config was commented out and everything was set to their default values. I have no idea how it even worked in the first place, already because the default database is postgresql, which isn't even installed on the system. And when I tried to edit things like page title or availability of forwarding, they simply didn't get applied. So I hoped with reinstalling I could solve the issue. I even did an apt purge to remove everything from that old installation (so only the mysql database survived), but obviously the problem seems to be somewhere it did survive. On Mon, 24 Jul 2023 at 03:27:49PM +0200, Richard Rosner wrote: The old installation was SOGo (up until 5.8.0) on Debian 11 from the official Nightly Repo. I now switched to Debians own packages after upgrading to Debian 12, so it's still SOGo 5.8.0. But as the problem was present during the whole 5.x cycle (at least since we switched from 2.x, maybe in 2018 or so) and I switched to the Debian packages just now, it must be a problem independent of the package source. just another idea regarding this strange behaviour: Within /usr/share/doc/sogo/README.Debian "The SOGo debian package differs from upstream in placing the configuration file in /etc/sogo/sogo.conf instead of using the GNUstep user defaults that are placed under the home directory of the user used to run SOGo. This file is parsed as GNUstep defaults in the "sogod" domain, which means you must not specify the sogod domain in the configuration file (there shouldn't be a "sogod = {" in /etc/sogo/sogo.conf)." Within a non-Debian sogo.conf there's this hint: * ~sogo/GNUstep/Defaults/.GNUstepDefaults has precedence over this file, * * make sure to move it away to avoid unwanted parameter overrides. * --> Maybe you still have a mixture of old Debian and non-Debian and/or 2.x vs. 5.x configuration files somewhere? Could you have a look at /var/lib/sogo/GNUstep/Defaults/ if there are files which could provide SOGo defaults even if you delete /etc/sogo/sogo.conf. Or somewhere else, perhaps grepping for some relevant content shows a hit? And just to be sure: in /etc/passwd is there an entry for the sogo user like this one?: sogo:x:999:999:SOGo daemon:/var/lib/sogo:/usr/sbin/nologin The home directory would be the interesting part. Regards, Markus
Re: [SOGo] SOGo no longer talking to mysql
It doesn't change. Now the big question is: what is it that sogo is loading? Because there's no other sogo.conf anywhere in the whole system, except of the expected files like /etc/default/sogo. Richard Rosner Studierendenschaft der RWTH Aachen University Fachschaft Materialwissenschaft und Werkstofftechnik Intzestraße 1 52072 Aachen Tel.: +49 241 80-95781 rros...@fsmuw.rwth-aachen.de www.fsmuw.rwth-aachen.de <https://www.fsmuw.rwth-aachen.de> Am 21.07.2023 um 15:22 schrieb qhivert (qhiv...@alinto.eu): Well, I’m out of idea ☹ Maybe test to change the username of SOGoProfileURL and look at the log to see if the name has changed as well, just to be sure the correct sogo.conf file is used. You could also send to my address only qhiv...@alinto.eu your sogo.conf file (censor your password) so I can see if anything shocks me. *From:*users-requ...@sogo.nu *On Behalf Of *Richard Rosner *Sent:* vendredi 21 juillet 2023 13:27 *To:* qhivert (qhiv...@alinto.eu) *Subject:* Re: [SOGo] SOGo no longer talking to mysql Hi Quentin, thanks for this, but username is just sogo, password only consists of latin alphabet letters (no special letters like ê, ę or others), numbers and simple special characters like - or _, nothing that's not ASCII. Is there anything else that can/must be done? E.g. in mysql you have to denote usernames, passwords or host names in quotes. It's nothing sogo seems to need as it did work previously, but is there something similar I could try? Richard Am 21.07.2023 um 12:21 schrieb qhivert (qhiv...@alinto.eu): Hello again Richard, Just in case, in your sogo.conf the username and password must be “url” encoded if you have any special characters -> https://www.w3schools.com/tags/ref_urlencode.ASP *From:*users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> *On Behalf Of *Richard Rosner *Sent:* vendredi 21 juillet 2023 09:44 *To:* Kenren Taisho (toushin.tai...@gmail.com) <mailto:users@sogo.nu> *Subject:* Re: [SOGo] SOGo no longer talking to mysql Hi Kenren, skip-name-resolve is alraedy commented out. Richard Am 21.07.2023 um 02:13 schrieb Kenren Taisho (toushin.tai...@gmail.com): Hi Richard, ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Could you check if skip-name-resolve is enabled in your MySQL config? And if is, remove it, restart MySQL, and see if SOGo is communicating again with MySQL. Kind regards On Fri, Jul 21, 2023 at 12:03 AM Richard Rosner wrote: Hi Quentin, I didn't only not change the password, I even made double sure the user still had all permissions for the database in question. And like I said, I did try username and password manually, which did work. I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed: Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 children Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79586 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79587 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79588 2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79588]: [ERROR] <0x0x55ce03f47520[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79588]: [WARN] <0x0x55ce03f47520[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79587]: [ERROR] <0x0x55ce03e5a8c0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79587]: [WARN] <0x0x55ce03e5a8c0[
Re: [SOGo] SOGo no longer talking to mysql
Hi Quentin, thanks for this, but username is just sogo, password only consists of latin alphabet letters (no special letters like ê, ę or others), numbers and simple special characters like - or _, nothing that's not ASCII. Is there anything else that can/must be done? E.g. in mysql you have to denote usernames, passwords or host names in quotes. It's nothing sogo seems to need as it did work previously, but is there something similar I could try? Richard Am 21.07.2023 um 12:21 schrieb qhivert (qhiv...@alinto.eu): Hello again Richard, Just in case, in your sogo.conf the username and password must be “url” encoded if you have any special characters -> https://www.w3schools.com/tags/ref_urlencode.ASP *From:*users-requ...@sogo.nu *On Behalf Of *Richard Rosner *Sent:* vendredi 21 juillet 2023 09:44 *To:* Kenren Taisho (toushin.tai...@gmail.com) *Subject:* Re: [SOGo] SOGo no longer talking to mysql Hi Kenren, skip-name-resolve is alraedy commented out. Richard Am 21.07.2023 um 02:13 schrieb Kenren Taisho (toushin.tai...@gmail.com): Hi Richard, ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Could you check if skip-name-resolve is enabled in your MySQL config? And if is, remove it, restart MySQL, and see if SOGo is communicating again with MySQL. Kind regards On Fri, Jul 21, 2023 at 12:03 AM Richard Rosner wrote: Hi Quentin, I didn't only not change the password, I even made double sure the user still had all permissions for the database in question. And like I said, I did try username and password manually, which did work. I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed: Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 children Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79586 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79587 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79588 2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79588]: [ERROR] <0x0x55ce03f47520[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79588]: [WARN] <0x0x55ce03f47520[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79587]: [ERROR] <0x0x55ce03e5a8c0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79587]: [WARN] <0x0x55ce03e5a8c0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.034 sogod[79586:79586] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79586]: [ERROR] <0x0x55ce03e56270[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79586]: [WARN] <0x0x55ce03e56270[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 Jul 20 17:41:16 sogod [79588]: <0x0x55ce04083130[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 17:41:16 sogod [79587]: <0x0x55ce040840a0[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 17:41:16 sogod [79586]: <0x0x55ce04087de0[WOHttpAdaptor]> notified the watchdog that we are ready Richard Am 20.07.2023 um 17:08 schrieb qhivert (qhiv...@alinto.eu): Hello Richard, Strange indeed. I assume you didn’t change the sogo.conf nor the password between? Is this the log with t
Re: [SOGo] SOGo no longer talking to mysql
Hi Kenren, skip-name-resolve is alraedy commented out. Richard Am 21.07.2023 um 02:13 schrieb Kenren Taisho (toushin.tai...@gmail.com): Hi Richard, ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Could you check if skip-name-resolve is enabled in your MySQL config? And if is, remove it, restart MySQL, and see if SOGo is communicating again with MySQL. Kind regards On Fri, Jul 21, 2023 at 12:03 AM Richard Rosner wrote: Hi Quentin, I didn't only not change the password, I even made double sure the user still had all permissions for the database in question. And like I said, I did try username and password manually, which did work. I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed: Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 children Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79586 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79587 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79588 2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79588]: [ERROR] <0x0x55ce03f47520[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79588]: [WARN] <0x0x55ce03f47520[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79587]: [ERROR] <0x0x55ce03e5a8c0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79587]: [WARN] <0x0x55ce03e5a8c0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.034 sogod[79586:79586] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79586]: [ERROR] <0x0x55ce03e56270[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79586]: [WARN] <0x0x55ce03e56270[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 Jul 20 17:41:16 sogod [79588]: <0x0x55ce04083130[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 17:41:16 sogod [79587]: <0x0x55ce040840a0[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 17:41:16 sogod [79586]: <0x0x55ce04087de0[WOHttpAdaptor]> notified the watchdog that we are ready Richard Am 20.07.2023 um 17:08 schrieb qhivert (qhiv...@alinto.eu): Hello Richard, Strange indeed. I assume you didn’t change the sogo.conf nor the password between? Is this the log with the param *MySQL4DebugEnabled = YES* in your sogo.conf? If not could you add it and show us the logs? Regards, Quentin *From:*users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> *On Behalf Of *Richard Rosner *Sent:* jeudi 20 juillet 2023 16:23 *To:* users@sogo.nu *Subject:* [SOGo] SOGo no longer talking to mysql Hi, I had to reinstall SOGo because for some strange reason it just refused to accept any changes to the config. Now for some reason it can't connect to mysql anymore. In the sogo.conf I have e.g. >> SOGoProfileURL = "mysql://sogo:/password/@127.0.0.1:3306/sogo/sogo_user_profile <http://127.0.0.1:3306/sogo/sogo_user_profile>"; << and I have verified that mariadb is actually listening to 127.0.0.1:3306 <http://127.0.0.1:3306>. But when I restart SOGo to activate the config, I get Jul 20 15:53:10 sogod [73521]: <0x0x7fb00f4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> preparing 3 children Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid
Re: [SOGo] SOGo no longer talking to mysql
Hi Quentin, I didn't only not change the password, I even made double sure the user still had all permissions for the database in question. And like I said, I did try username and password manually, which did work. I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed: Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 children Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79586 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79587 Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned with pid 79588 2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79588]: [ERROR] <0x0x55ce03f47520[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79588]: [WARN] <0x0x55ce03f47520[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79587]: [ERROR] <0x0x55ce03e5a8c0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79587]: [WARN] <0x0x55ce03e5a8c0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 2023-07-20 17:41:16.034 sogod[79586:79586] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 17:41:16 sogod [79586]: [ERROR] <0x0x55ce03e56270[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 17:41:16 sogod [79586]: [WARN] <0x0x55ce03e56270[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200 Jul 20 17:41:16 sogod [79588]: <0x0x55ce04083130[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 17:41:16 sogod [79587]: <0x0x55ce040840a0[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 17:41:16 sogod [79586]: <0x0x55ce04087de0[WOHttpAdaptor]> notified the watchdog that we are ready Richard Am 20.07.2023 um 17:08 schrieb qhivert (qhiv...@alinto.eu): Hello Richard, Strange indeed. I assume you didn’t change the sogo.conf nor the password between? Is this the log with the param *MySQL4DebugEnabled = YES* in your sogo.conf? If not could you add it and show us the logs? Regards, Quentin *From:*users-requ...@sogo.nu *On Behalf Of *Richard Rosner *Sent:* jeudi 20 juillet 2023 16:23 *To:* users@sogo.nu *Subject:* [SOGo] SOGo no longer talking to mysql Hi, I had to reinstall SOGo because for some strange reason it just refused to accept any changes to the config. Now for some reason it can't connect to mysql anymore. In the sogo.conf I have e.g. >> SOGoProfileURL = "mysql://sogo:/password/@127.0.0.1:3306/sogo/sogo_user_profile"; << and I have verified that mariadb is actually listening to 127.0.0.1:3306. But when I restart SOGo to activate the config, I get Jul 20 15:53:10 sogod [73521]: <0x0x7fb00f4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> preparing 3 children Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid 73522 Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid 73523 Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid 73524 2023-07-20 15:53:10.948 sogod[73523:73523] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 15:53:10 sogod [73523]: [ERROR] <0x0x55bdab3912c0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 15:53:10 sogod [73523]: [WARN] <0x0x55bdab3912c0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200 2023-07-20 15:53:10.948 sogod[73524:73524] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) 2023-07-20 15:53:10.948 sogod[73522:73522] ERROR: could not open MySQL4 connection to database 'sogo': Access den
[SOGo] SOGo no longer talking to mysql
Hi, I had to reinstall SOGo because for some strange reason it just refused to accept any changes to the config. Now for some reason it can't connect to mysql anymore. In the sogo.conf I have e.g. >> SOGoProfileURL = "mysql://sogo:/password/@127.0.0.1:3306/sogo/sogo_user_profile"; << and I have verified that mariadb is actually listening to 127.0.0.1:3306. But when I restart SOGo to activate the config, I get Jul 20 15:53:10 sogod [73521]: <0x0x7fb00f4b7340[WOWatchDogChild]> watchdog request timeout set to 10 minutes Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> preparing 3 children Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid 73522 Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid 73523 Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned with pid 73524 2023-07-20 15:53:10.948 sogod[73523:73523] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 15:53:10 sogod [73523]: [ERROR] <0x0x55bdab3912c0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 15:53:10 sogod [73523]: [WARN] <0x0x55bdab3912c0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200 2023-07-20 15:53:10.948 sogod[73524:73524] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) 2023-07-20 15:53:10.948 sogod[73522:73522] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES) Jul 20 15:53:10 sogod [73522]: [ERROR] <0x0x55bdab390df0[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 15:53:10 sogod [73524]: [ERROR] <0x0x55bdab373020[GCSChannelManager]> could not open channel for mysql://localhost/sogo/sogo_user_profile Jul 20 15:53:10 sogod [73522]: [WARN] <0x0x55bdab390df0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200 Jul 20 15:53:10 sogod [73524]: [WARN] <0x0x55bdab373020[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200 Jul 20 15:53:11 sogod [73522]: <0x0x55bdab1b0510[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 15:53:11 sogod [73523]: <0x0x55bdab589fc0[WOHttpAdaptor]> notified the watchdog that we are ready Jul 20 15:53:11 sogod [73524]: <0x0x55bdab589050[WOHttpAdaptor]> notified the watchdog that we are ready So of course I tried logging in manually to mysql, but this succedes without any complaints. Now what's the problem with it? I'm using mariadb-server 10.11.3. smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Broken Calendar in SOGo 5.8
Hi Sebastien, I have never been able to create bug reports there. When I'm logged in, there's a flag next to my user name saying "viewer", which is probably the reason for that. I don't know how to change that and last time I tried to contact the admin mail address it didn't work (I think I got the response that it's not available). Best Richard Am 12.12.2022 um 09:25 schrieb smizr...@alinto.eu (smizr...@alinto.eu): Hi Richard, You can open a ticket on bugs.sogo.nu and provide the following informations : The SQL request just before getting the SQL Exception. You can have SQL request in logs using MySQL4DebugEnabled = YES; in sogo.conf. The SQL dump structure of your database (without data) would be also helpful. Sebastien Le Jeudi, Décembre 08, 2022 15:27 CET, "\"Richard Rosner\"" (rros...@fsmuw.rwth-aachen.de) a écrit: Hello, it seems SOGo 5.8 has broken the calendar (interestingly only for some users), seemingly with a database update. At least some users aren't able to create new entries and the log shows errors with Dec 08 15:03:29 sogod [2803825]: <0x0x5617477a0510[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot\ insert content : NAME:ExecutionFailed REASON:Unknown column 'c_description' in 'field list' and older reports in mailing lists suggest the last time that was a problem back in 2.x it was a problem with the databse scheme. Yet there is no database update script in /usr/share/doc/sogo/, the newest one is sql-update-5.5.1_to_5.6.0.sh. But that one was for the bug of not being able to log in back then. So how do I fix it? Best regards Richard smime.p7s Description: S/MIME Cryptographic Signature
[SOGo] Broken Calendar in SOGo 5.8
Hello, it seems SOGo 5.8 has broken the calendar (interestingly only for some users), seemingly with a database update. At least some users aren't able to create new entries and the log shows errors withDec 08 15:03:29 sogod [2803825]: <0x0x5617477a0510[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot\ insert content : NAME:ExecutionFailed REASON:Unknown column 'c_description' in 'field list'and older reports in mailing lists suggest the last time that was a problem back in 2.x it was a problem with the databse scheme. Yet there is no database update script in /usr/share/doc/sogo/, the newest one is sql-update-5.5.1_to_5.6.0.sh. But that one was for the bug of not being able to log in back then. So how do I fix it? Best regards Richard smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Bug in character display in S/MIME encrypted mails
With OpenSSL 3.x I get Error decrypting CMS structure 400755B1327F:error:1C800064:Provider routines:ossl_cipher_unpadblock:bad decrypt:../providers/implementations/ciphers/ciphercommon_block.c:129: If I swap cms for smime it changes to Error decrypting PKCS#7 structure rest of the error stays the same. For all I know it has to do with some kinde of deprecated stuff in OpenSSL 3.x so you'd need to add something to the comand to enable legacy stuff. Using OpenSSL 1.1.1n however doesn't change much: Error decrypting CMS structure 139958493545792:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:../crypto/evp/evp_enc.c:610: The private key file is a PEM RSA key. Already checked that the reason can't be the wrong kind of line breaks (those Windows line breaks) inside the key file, since that was mentioned to be a possible reason. But the key file is as it's supposed to be. Regards Richard -- Richard Rosner Beauftragter für Vernetzung Studierendenschaft der RWTH Aachen University Fachschaft Materialwissenschaft und Werkstofftechnik Intzestraße 1 52072 Aachen Tel.: +49 241 80-95781 rros...@fsmuw.rwth-aachen.de www.fsmuw.rwth-aachen.de Am Freitag, 16. September 2022 19:51 CEST, schrieb "\"Frank Schmirler\"" (s...@schmirler.de) : Hi Richard, the basic openssl command to decrypt an S/MIME message would be something like openssl cms -decrypt -in EMLFILE -inkey PRIVATEKEYFILE Which error do you get when trying to decrypt your message with openssl? Regards, Frank Am Mittwoch, 14. September 2022 14:24 CEST, schrieb "\"Richard Rosner\"" (rros...@fsmuw.rwth-aachen.de) : > Hello together, > it seems I've found a bug when displaying an S/MIME encrypted mail. It seems > like characters aren't interpreted as UTF-8. At least some german "Umlaute" > don't display correctly. In Thunderbird, on the other hand, that same mail is > displayed correctly. Sadly, I haven't found a way to view the unencrypted > mail source code to verify if the text is indicated as UTF-8. Both OpenSSL > 1.x and 3.x are just throwing errors when trying to decrypt the eml file and > I don't know of any method to use either Thunderbird or SOGo to save the mail > as an unecrypted eml file. If anybody knows how I could better help to find > the bug, let me know. > > Using SOGo 5.7.1.20220912-1 on 64-bit Debian 10, straight from the > packages.sogo.nu repo. > > Best Regards > Richard > -- > Richard Rosner smime.p7s Description: S/MIME cryptographic signature
[SOGo] Bug in character display in S/MIME encrypted mails
Hello together, it seems I've found a bug when displaying an S/MIME encrypted mail. It seems like characters aren't interpreted as UTF-8. At least some german "Umlaute" don't display correctly. In Thunderbird, on the other hand, that same mail is displayed correctly. Sadly, I haven't found a way to view the unencrypted mail source code to verify if the text is indicated as UTF-8. Both OpenSSL 1.x and 3.x are just throwing errors when trying to decrypt the eml file and I don't know of any method to use either Thunderbird or SOGo to save the mail as an unecrypted eml file. If anybody knows how I could better help to find the bug, let me know. Using SOGo 5.7.1.20220912-1 on 64-bit Debian 10, straight from the packages.sogo.nu repo. Best Regards Richard -- Richard Rosner smime.p7s Description: S/MIME cryptographic signature