Re: [SOGo] First timer questions
On Tue, Feb 27, 2024 at 12:04 PM Philipp Weber - IT Pahl Pflege GmbH < users@sogo.nu> wrote: > Hello everyone, > > > i want to start testing IredMail for our company and have a few question. > > > NOW: > > External mail server ( Plesk based hoster ) > > Thunderbird on RDS > > > Future target: > > Iredmail > > - connected to LDAP ( Univention Corporate Server ) > > -- Getting mailadress and info out of LDAP and permissions > > > SOGo Webfrontend > > > --- > > 1) So i have found a few articles about LDAP but primary about the LDAP > which is included in Iredmail. > > What is the way to connect it seamlessly to UCS LDAP? > https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_authentication_using_ldap 2) Can i use the actual external mail server as a relayhost and use > fetchmail to test Iredmail with a few users in parallel? > https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_smtp_server_configuration SOGo is a universal web interface, IMHO. All it requires is AUTHentication so as to display emails and also to be able to send emails. If for once you'd stop focusing on iRedmail and just start with looking at what SOGo is meant to do, you'd get the concept clearly. That information is here: https://www.sogo.nu/files/docs/SOGoInstallationGuide.html As it is, you can already install SOGo only on a VM and test it with your existing server - testing only with your account until you're satisfied. Your existing server just needs to be configured to relay when ASMTP succeeds. Simple. Other than that, it needs to allow IMAP4 access from remote. That's as easy as opening port 143 on the firewall for a particular IP address. Iredmail depends on SOGo for the webUI/Groupware. SOGo does not need iRedmail. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Timezone Issue in SOGo web client - need help
You are welcome. One last thing, sogo.conf should have your desired TZ in there. SOGoTimeZone = America/Ney_York The SOGo web UI inherits this. On Sun, Feb 11, 2024 at 8:11 PM Philipp Mueller | Bright and Epic USA < users@sogo.nu> wrote: > Omg - thank you so much Odhiambo. Crazy … I was so being focused on a > dropdown that I thought it was a bug. > > > SOLVED. > > On Feb 11, 2024, at 1:49 AM, Odhiambo Washington wrote: > > > You can edit the TZ by typing it. Just place your cursor after the C and > then backspace, then time whatever TZ you want it to be. > > On Sun, Feb 11, 2024 at 2:26 AM philipp wrote: > >> Hello, does no one have an idea? >> >> Here’s a screenshot: I cannot make any changes to the timezone settings >> in the Web Client. It llooks like there were no time zones in that field. >> It is not dropdown. The Time Format is correct (I took the screenshot 9 >> minutes ago). >> >> But the time in the inbox is also wrong – it shows UTC time. >> >> >> >> >> >> >> >> >> >> >> >> *From:* phil...@brightandepic.com >> *Sent:* Thursday, February 8, 2024 9:45 PM >> *To:* 'users@sogo.nu' >> *Subject:* nano /etc timezone - list? default UTC only >> >> >> >> Hello everyone, >> >> >> >> I’m quite desperate because I have two problems with Sogo / Mailcow: >> >> >> >> I run a sogo and mailcow dockerized. >> >> >> >> Problem 1: Regardless of the timezone of my server (America/Ney_York), >> SOGo uses the default UTC time which is pretty bad as the users don’t have >> the correct time on their emails. >> >> Problem 2: My clients who use sogo cannot change timezones in their >> settings. I remember the timezone field being a dropdown? I don’t have >> anything there but the field “UTC”. >> >> >> >> So my question is: >> >> 1) the timezone file in the docker container sogo “/etc/timezone” has >> just one timezone, which is Etc/UTC – can I include a list of timezones >> there? If so, what is the correct format and where can I get this list from? >> >> 2) How can I enable my users to be able to switch timezone within their >> settings? >> >> I found this folder too containing ics files. Can I uploade them to a >> folder? >> https://github.com/inverse-inc/sogo/tree/master/SOPE/NGCards/TimeZones >> >> >> >> Philipp >> > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > In an Internet failure case, the #1 suspect is a constant: DNS. > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > [How to ask smart questions: > http://www.catb.org/~esr/faqs/smart-questions.html] > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Timezone Issue in SOGo web client - need help
You can edit the TZ by typing it. Just place your cursor after the C and then backspace, then time whatever TZ you want it to be. On Sun, Feb 11, 2024 at 2:26 AM philipp wrote: > Hello, does no one have an idea? > > Here’s a screenshot: I cannot make any changes to the timezone settings in > the Web Client. It llooks like there were no time zones in that field. It > is not dropdown. The Time Format is correct (I took the screenshot 9 > minutes ago). > > But the time in the inbox is also wrong – it shows UTC time. > > > > > > > > > > *From:* phil...@brightandepic.com > *Sent:* Thursday, February 8, 2024 9:45 PM > *To:* 'users@sogo.nu' > *Subject:* nano /etc timezone - list? default UTC only > > > > Hello everyone, > > > > I’m quite desperate because I have two problems with Sogo / Mailcow: > > > > I run a sogo and mailcow dockerized. > > > > Problem 1: Regardless of the timezone of my server (America/Ney_York), > SOGo uses the default UTC time which is pretty bad as the users don’t have > the correct time on their emails. > > Problem 2: My clients who use sogo cannot change timezones in their > settings. I remember the timezone field being a dropdown? I don’t have > anything there but the field “UTC”. > > > > So my question is: > > 1) the timezone file in the docker container sogo “/etc/timezone” has just > one timezone, which is Etc/UTC – can I include a list of timezones there? > If so, what is the correct format and where can I get this list from? > > 2) How can I enable my users to be able to switch timezone within their > settings? > > I found this folder too containing ics files. Can I uploade them to a > folder? > https://github.com/inverse-inc/sogo/tree/master/SOPE/NGCards/TimeZones > > > > Philipp > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
On Fri, Feb 2, 2024 at 1:06 AM Bits 'n Tricks wrote: > Hi Markus, > > thanks, will try this. > I actually just copied the sogo.conf file from another working server, > If that is what you did, dump the database from that server and import it into the new server. I remember having advised you to do that. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
If your two systems are supposed to be identical, then just dump the other database schema and import it into the new server. On Thu, Feb 1, 2024 at 11:17 AM Bits 'n Tricks wrote: > > > On Tue, Jan 30, 2024 at 9:19 PM Bits 'n Tricks wrote: > > Hi, > > it came from /var/log/sogo/sogo.log: > > > ERROR: Table 'sogo.sogo_users' doesn't exist > > > > PS: I hate to-posting! > > In one of my setups, I have these definitions in sogo.conf: > > /* Database Configuration */ > SOGoProfileURL = "mysql://sogou:/* Database Configuration */ > SOGoProfileURL = "mysql:// > sogou:XX@127.0.0.1:3306/exim4u/sogo_user_profile"; > OCSFolderInfoURL = "mysql:// > sogou:XX@127.0.0.1:3306/exim4u/sogo_folder_info"; > OCSSessionsFolderURL = "mysql:// > sogou:XX@127.0.0.1:3306/exim4u/sogo_sessions_folder"; > OCSEMailAlarmsFolderURL="mysql:// > sogou:XX@127.0.0.1:3306/exim4u/sogo_alarms_folder"; > > OCSStoreURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_store > "; > OCSAclURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_acl"; > OCSCacheFolderURL="mysql:// > sogou:XX@127.0.0.1:3306/exim4u/sogo_cache_folder"; > > Looking at the exim4u DB: > > ``` > root@localhost [exim4u]> show tables; > ++ > | Tables_in_exim4u | > ++ > | blocklists | > | domainalias| > | domains| > | group_contents | > | ml | > | mygroups | > | sogo_acl | > | sogo_alarms_folder | > | sogo_auth_view | > | sogo_cache_folder | > | sogo_folder_info | > | sogo_quick_appointment | > | sogo_quick_contact | > | sogo_sessions_folder | > | sogo_store | > | sogo_user_profile | > | users | > ++ > ``` > > As you can see, there's nothing like sogo_users table in the DB! > > If you need more help, I will do that, but only IF you do not top-post! > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > In an Internet failure case, the #1 suspect is a constant: DNS. > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > [How to ask smart questions: > http://www.catb.org/~esr/faqs/smart-questions.html] > > Bottom postingi in HTML mails is not ideal, that's why I don't do it > usually. > Anyway, I have only one occurrence in the sogo.conf file and it is this: > > viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users"; > > > But it is also in my other serverwhich does work with that config and it > also has the sogo_users table ... > > BC > > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
On Tue, Jan 30, 2024 at 9:19 PM Bits 'n Tricks wrote: > Hi, > > it came from /var/log/sogo/sogo.log: > > > ERROR: Table 'sogo.sogo_users' doesn't exist > PS: I hate to-posting! In one of my setups, I have these definitions in sogo.conf: /* Database Configuration */ SOGoProfileURL = "mysql://sogou:/* Database Configuration */ SOGoProfileURL = "mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_user_profile"; OCSFolderInfoURL = "mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_folder_info"; OCSSessionsFolderURL = "mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_sessions_folder"; OCSEMailAlarmsFolderURL="mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_alarms_folder"; OCSStoreURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_store"; OCSAclURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_acl"; OCSCacheFolderURL="mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_cache_folder"; Looking at the exim4u DB: ``` root@localhost [exim4u]> show tables; ++ | Tables_in_exim4u | ++ | blocklists | | domainalias| | domains| | group_contents | | ml | | mygroups | | sogo_acl | | sogo_alarms_folder | | sogo_auth_view | | sogo_cache_folder | | sogo_folder_info | | sogo_quick_appointment | | sogo_quick_contact | | sogo_sessions_folder | | sogo_store | | sogo_user_profile | | users | ++ ``` As you can see, there's nothing like sogo_users table in the DB! If you need more help, I will do that, but only IF you do not top-post! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
On Tue, Jan 30, 2024 at 4:02 PM Bits 'n Tricks wrote: > Hi, > > I just did a new Sogo install on MariaDB and I get this error when > logging in. > Followed the instructions on > https://www.sogo.nu/support/faq/how-do-i-configure-sogo-to-use-mysql.html. > > Deleted the database again and recreated it, same error. > Using the nightly repo. > > Thanks! > That link contains: ``` defaults -u sogo write sogod OCSFolderInfoURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_folder_info" defaults -u sogo write sogod SOGoProfileURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_user_profile" defaults -u sogo write sogod OCSSessionsFolderURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_sessions_folder" ``` So those are 3 tables: sogo_folder_info, sogo_user_profile and sogo_sessions_folder. Where did you get the sogo_users from ?? Looking at my setup, I don't see any table with that name too: ``` MariaDB [sogo]> show tables; ++ | Tables_in_sogo | ++ | sogo_acl | | sogo_alarms_folder | | sogo_cache_folder | | sogo_folder_info | | sogo_quick_appointment | | sogo_quick_contact | | sogo_sessions_folder | | sogo_store | | sogo_user_profile | | users | ++ ``` So there is something you are not doing right! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] SOGo Documentation for the version that uses nginx
Because someone will ask this question another day, let me post this here,
hoping the person who finds it will figure out the rest.
nano /etc/nginx/conf.d/mail.example.org.conf (or
/etc/nginx/sites-available/mail.example.org.conf and then symlinking to
sites-enabled)
server {
server_name mail.example.org;
root /usr/lib/GNUstep/SOGo/WebServerResources/;
error_log /var/log/nginx/sogo_error.log;
access_log /var/log/nginx/sogo_access.log;
listen 443 ssl;
ssl_certificate /etc/letsencrypt/live/mail.example.org/fullchain.pem;
ssl_certificate_key /etc/letsencrypt/live/mail.example.org/privkey.pem;
include /etc/letsencrypt/options-ssl-nginx.conf;
ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem;
add_header Strict-Transport-Security "max-age=31536000" always;
ssl_trusted_certificate /etc/letsencrypt/live/mail.example.org/chain.pem
;
ssl_stapling on;
ssl_stapling_verify on;
location = / {
rewrite ^ https://$server_name/SOGo/;
allow all;
}
location = /principals/ {
rewrite ^ https://$server_name/SOGo/dav;
allow all;
}
location ^~/SOGo/ {
proxy_pass "http://127.0.0.1:2;;
proxy_redirect "http://127.0.0.1:2; default;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header Host $host;
proxy_set_header x-webobjects-server-protocol HTTP/1.1;
proxy_set_header x-webobjects-remote-host 127.0.0.1;
proxy_set_header x-webobjects-server-name $server_name;
proxy_set_header x-webobjects-server-url $scheme://$host;
proxy_connect_timeout 90;
proxy_send_timeout 90;
proxy_read_timeout 90;
proxy_buffer_size 4k;
proxy_buffers 4 32k;
proxy_busy_buffers_size 64k;
proxy_temp_file_write_size 64k;
client_max_body_size 100m;
client_body_buffer_size 128k;
break;
}
location /SOGo.woa/WebServerResources/ {
alias /usr/lib/GNUstep/SOGo/WebServerResources/;
allow all;
}
location /SOGo/WebServerResources/ {
alias /usr/lib/GNUstep/SOGo/WebServerResources/;
allow all;
}
location ^/SOGo/so/ControlPanel/Products/([^/]*)/Resources/(.*)$ {
alias /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2;
}
location
^/SOGo/so/ControlPanel/Products/[^/]*UI/Resources/.*\.(jpg|png|gif|css|js)$
{
alias /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2;
}
}
server {
server_name mail.example.org;
listen 80;
error_log /var/log/nginx/sogo_error.log;
access_log /var/log/nginx/sogo_access.log;
if ($host = mail.example.org) {
return 301 https://$host$request_uri;
}
}
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions:
http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Fosdem?
On Mon, Jan 29, 2024 at 10:43 AM Kees van Vloten wrote: > Hi Quentin, > > > I got your mail-address from the mailing list. > > Now I was wondering if anyone from Alinto / Sogo will be attending > Fosdem next week in Brussels? > > > - Kees. > https://fosdem.org/2024/stands/ -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] SOGo Documentation for the version that uses nginx
Karibu sana ndugu. I'm very glad to hear that I helped. On Tue, Jan 23, 2024, 21:00 "Michael Callum Mayaka" wrote: > Thank you, it seems that's the way I'd installed it - you've solved my > issue, and glad do see a fellow Kenyan (though I'm based in London). > Asante sana, mukubwa > > On Tuesday, January 23, 2024 15:48 GMT, "Odhiambo Washington" ( > odhia...@gmail.com) wrote: > > > > > On Tue, Jan 23, 2024 at 6:35 PM "Michael" wrote: > >> Hello, >> >> I am running SOGo on a Debian 11 server, and when I installed it I used a >> package I can't seem to find now which required a separate server and >> installed SOGo and all the associated packages with nginx as the web >> server, >> rather than Apache2. I am trying to find documentation as I need to >> reconfigure my SSL certificates after changing domain names, and need >> Exchange >> ActiveSync to work (I need users to be able to connect and sync on their >> devices and desktop apps with no SSL/certificate errors. >> >> I would be most grateful if anyone could point me in the right direction >> or >> give me advice how to do this. >> >> Kind regards, >> >> Michael > > > Borrow from iRedmail - > https://forum.iredmail.org/topic19176-iredmail-nginx-proxy-problem-with-sogo-log-in.html > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > In an Internet failure case, the #1 suspect is a constant: DNS. > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > [How to ask smart questions: > http://www.catb.org/~esr/faqs/smart-questions.html] > > > >
Re: [SOGo] SOGo Documentation for the version that uses nginx
On Tue, Jan 23, 2024 at 6:35 PM "Michael" wrote: > Hello, > > I am running SOGo on a Debian 11 server, and when I installed it I used a > package I can't seem to find now which required a separate server and > installed SOGo and all the associated packages with nginx as the web > server, > rather than Apache2. I am trying to find documentation as I need to > reconfigure my SSL certificates after changing domain names, and need > Exchange > ActiveSync to work (I need users to be able to connect and sync on their > devices and desktop apps with no SSL/certificate errors. > > I would be most grateful if anyone could point me in the right direction or > give me advice how to do this. > > Kind regards, > > Michael > Borrow from iRedmail - https://forum.iredmail.org/topic19176-iredmail-nginx-proxy-problem-with-sogo-log-in.html -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Request for technical support for Sogo groupware server installation on Ubuntu 22.04
On Wed, Nov 29, 2023 at 3:46 PM Aditya Kumar wrote: > How to install sogo mail on ubuntu 22.04. > 1. Install on Ubuntu - https://www.sogo.nu/support/faq/how-to-install-sogo-on-ubuntu.html 2. Configure after installation - https://www.sogo.nu/files/docs/SOGoInstallationGuide.html -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Request for technical support for Sogo groupware server installation on Ubuntu 22.04
On Wed, Nov 29, 2023 at 11:50 AM Aditya Kumar wrote: > Dear Sir, > > This is Aditya from Worthy Projects Pvt. Ltd. India. I'm new on sogo > mail server. > > I need support to install and configure sogo groupware mail server for > our organization on ubuntu 22.04. > > Best Regards, > > Aditya Kumar > > Worthy Projects Pvt. Ltd. > Hello Aditya, Where are you stuck? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] 404 error when accessing Sogo WebUI?
Go.woa/WebServerResources/ \
> /usr/lib/GNUstep/SOGo/WebServerResources/
> Alias /SOGo/WebServerResources/ \
> /usr/lib/GNUstep/SOGo/WebServerResources/
>
>
> AllowOverride None
>
>
> Order deny,allow
> Allow from all
>
> = 2.4>
> Require all granted
>
>
> # Explicitly allow caching of static content to avoid browser specific
> behavior.
> # A resource's URL MUST change in order to have the client load the
> new version.
>
> ExpiresActive On
> ExpiresDefault "access plus 1 year"
>
>
>
> ## Uncomment the following to enable proxy-side authentication, you will
> then
> ## need to set the "SOGoTrustProxyAuthentication" SOGo user default to YES
> and
> ## adjust the "x-webobjects-remote-user" proxy header in the "Proxy"
> section
> ## below.
> #
> ## For full proxy-side authentication:
> #
> # AuthType XXX
> # Require valid-user
> # SetEnv proxy-nokeepalive 1
> # Allow from all
> #
> #
> ## For proxy-side authentication only for CardDAV and GroupDAV from
> external
> ## clients:
> #
> # AuthType XXX
> # Require valid-user
> # SetEnv proxy-nokeepalive 1
> # Allow from all
> #
>
> ProxyRequests Off
> SetEnv proxy-nokeepalive 1
> ProxyPreserveHost On
>
> # When using CAS, you should uncomment this and install
> cas-proxy-validate.py
> # in /usr/lib/cgi-bin to reduce server overloading
> #
> # ProxyPass /SOGo/casProxy http://localhost/cgi-bin/cas-proxy-validate.py
> # http://localhost/app/cas-proxy-validate.py>
> # Order deny,allow
> # Allow from your-cas-host-addr
> #
>
> # Redirect / to /SOGo
> RedirectMatch ^/$ https://webmail.davenet.fr/SOGo
>
> # Enable to use Microsoft ActiveSync support
> # Note that you MUST have many sogod workers to use ActiveSync.
> # See the SOGo Installation and Configuration guide for more details.
> #
> ProxyPass /Microsoft-Server-ActiveSync \
> http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \
> retry=60 connectiontimeout=5 timeout=360
>
> ProxyPass /SOGo http://127.0.0.1:2/SOGo retry=0
>
> http://127.0.0.1:2/SOGo>
> ## Adjust the following to your configuration
> ## and make sure to enable the headers module
>
> #RequestHeader set "x-webobjects-server-port" "443"
> #SetEnvIf Host (.*) HTTP_HOST=$1
> #RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e"
> env=HTTP_HOST
> #RequestHeader set "x-webobjects-server-url" "https://%{HTTP_HOST}e;
> env=HTTP_HOST
>
> RequestHeader set "x-webobjects-server-port" "443"
> RequestHeader set "x-webobjects-server-name" "webmail.davenet.fr"
> RequestHeader set "x-webobjects-server-url" "https://webmail.davenet.fr;
>
> ## When using proxy-side autentication, you need to uncomment and
> ## adjust the following line:
> RequestHeader unset "x-webobjects-remote-user"
> # RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e"
> env=REMOTE_USER
>
> RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
>
>
> AddDefaultCharset UTF-8
>
> Order allow,deny
> Allow from all
>
>
> # For Apple autoconfiguration
>
> RewriteEngine On
> RewriteRule ^/.well-known/caldav/?$ /SOGo/dav [R=301]
> RewriteRule ^/.well-known/carddav/?$ /SOGo/dav [R=301]
>
>
> RewriteEngine on
> RewriteCond %{SERVER_NAME} =webmail.davenet.fr
> RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]
> AddDefaultCharset Off
>
>
> #
>
>
> 3) attach the output of /var/log/sogo/sogo.log, in particular the lines
> after a restart of sogod
>
>
> root@webmail:/etc/apache2/sites-available# systemctl restart sogo
> root@webmail:/etc/apache2/sites-available# tail -f /var/log/sogo/sogo.log
> Oct 31 16:14:55 sogod [39263]: <0x0x55fc5b2a8820[WOWatchDog]> preparing 3
> children
> Oct 31 16:14:55 sogod [39263]: <0x0x55fc5b2a8820[WOWatchDog]> child
> spawned with pid 39265
> Oct 31 16:14:55 sogod [39263]: <0x0x55fc5b2a8820[WOWatchDog]> child
> spawned with pid 39266
> Oct 31 16:14:55 sogod [39263]: <0x0x55fc5b2a8820[WOWatchDog]> child
> spawned with pid 39267
> 2023-10-31 16:14:55.311 sogod[39265:39265] ERROR(+[GCSFolderManager
> defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL:
> 'mysql://userDB:Password@192.168.10.250:3306/sogo/sogo_folder_info'
> Oct 31 16:14:55 sogod [39265]: <0x0x55fc5b483f20[WOHttpAdaptor]> notified
> the watchdog that we are ready
> Oct 31 16:33:22 sogod [39267]: [WARN] <0x0x7f54c54e1f60[WOxElemBuilder]>
> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
> 2023-10-31 16:33:22.482 sogod[39267:39267] EXCEPTION: 0x55fc5b6aa2f0> NAME:NSInvalidArgumentException REASON:Tried to add nil
> value for key 'users' to dictionary INFO:{}
>
> Do you have a solution for this error?
>
> Thanks
> Alain
>
>
> Le Mardi, Octobre 31, 2023 10:51 CET, "Markus Winkler" (m...@irmawi.de) <
> users@sogo.nu> a écrit:
>
> > Hello Alain,
> >
> > On 30.10.23 23:01, "alain25" (s...@osnetworking.com) wrote:
> > > I always get a 501 error
> >
> > 1) please attach your _complete_ current /etc/sogo/sogo.conf (censored
> > passwords of course)
> >
> > 2) please attach your _complete_ Apache vHost config file(s) from
> > /etc/apache2/sites-available which is/are currently activated (and so
> > linked to /etc/apache2/sites-enabled)
> >
> > 3) please attach the output of /var/log/sogo/sogo.log, especially the
> lines
> > after a restart of the sogod
> >
> > Without these essential information it's quite impossible to help.
> >
> > Thanks and regards
> > Markus
>
>
>
>
> --
> Merci
>
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions:
http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] SOGo no longer talking to mysql
On Mon, Jul 24, 2023 at 3:51 PM Richard Rosner wrote: > It produces the exact same output. And yes, I completely emptied > /etc/sogo/: > > 2023-07-24 14:33:56.022 sogod[148688:148688] ERROR: *could not open > MySQL4 connection to database 'sogo': Access denied for user > 'sogo'@'localhost' (using password: YES)* > Jul 24 14:33:56 sogod [148688]: [ERROR] > <0x0x55d0b9b16cc0[GCSChannelManager]> could not open channel > for > mysql://localhost/sogo/sogo_user_profile > Jul 24 14:33:56 sogod [148688]: [WARN] > <0x0x55d0b9b16cc0[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2023-07-24 14:33:55 +0200 > Jul 24 14:33:56 sogod [148688]: <0x0x55d0b9d10410[WOHttpAdaptor]> notified > the watchdog that we are ready > 2023-07-24 14:33:56.024 sogod[148689:148689]* ERROR: could not open > MySQL4 connection to database 'sogo': Access denied for user > 'sogo'@'localhost' (using password: YES)* > Jul 24 14:33:56 sogod [148689]: [ERROR] > <0x0x55d0b9af8ce0[GCSChannelManager]> could not open channel > for > mysql://localhost/sogo/sogo_user_profile > Jul 24 14:33:56 sogod [148689]: [WARN] > <0x0x55d0b9af8ce0[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2023-07-24 14:33:55 +0200 > 2023-07-24 14:33:56.026 sogod[148687:148687] *ERROR: could not open > MySQL4 connection to database 'sogo': Access denied for user > 'sogo'@'localhost' (using password: YES)* > Jul 24 14:33:56 sogod [148687]: [ERROR] > <0x0x55d0b9b16cc0[GCSChannelManager]> could not open channel > for > mysql://localhost/sogo/sogo_user_profile > Jul 24 14:33:56 sogod [148687]: [WARN] > <0x0x55d0b9b16cc0[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2023-07-24 14:33:55 +0200 > Jul 24 14:33:56 sogod [148689]: <0x0x55d0b9d0e3b0[WOHttpAdaptor]> notified > the watchdog that we are ready > Jul 24 14:33:56 sogod [148687]: <0x0x55d0b9d14150[WOHttpAdaptor]> notified > the watchdog that we are ready > > The output if strace changes though, it's not containing any lines with > mysql anymore. > "could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)" Those are lines with MySQL! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Has someone a working SAML configuration most optimal with Keycloak as IDP?
On Thu, Jun 29, 2023 at 4:15 PM Claas Hilbrecht wrote: > Hi, > > since I'm still have trouble getting SOGo 5.8.4 SAML login working > with Keycloak 21.1.1 I wonder if someone has a working setup and is > willing to share that configuration? > DISCLAIMER: I have zero knowledge of SAML! Having said that, there are two cases where people successfully used it, although not sure if they also used Keycloak. 1. https://www.mail-archive.com/users@sogo.nu/msg29860.html 2. https://marc.info/?l=sogo-users=147697076318929=2 -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Mail not being sent
On Fri, May 19, 2023 at 10:06 AM "Support" wrote: > can anyone help with the following error message? > > > > The mail system > > <@hotmail.com>: host > hotmail-com.olc.protection.outlook.com[104.47.18.97] said: 550 5.7.1 > Unfortunately, messages from [185.223.74.125] weren't sent. Please contact > your Internet service provider since part of their network is on our block > list (S3140). You can also refer your provider to > http://mail.live.com/mail/troubleshooting.aspx#errors. > [AM6EUR05FT005.eop-eur05.prod.protection.outlook.com > 2023-05-17T16:24:51.315Z 08DB56EE51325E3F] (in reply to MAIL FROM command) > > can anyone help with the following error message? > Please open a ticket with your ISP by sending the same content to their Tech Support Team. They need to address it, not you, just as the message says. Your IP address - 185.223.74.125 - is part of a large block from your ISP and it's blacklisted. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] quick auto logout in sogo 5.x
I am running 5.8.0 on FreeBSD and unless I logout, my session stays logged in. On my Ubuntu server, I run 5.5.1 with same table and no problem. Is this an issue with installation from source then? I don't have this file - sql-update-5.5.1_to_5.6.0.sh - in my system. On Wed, May 10, 2023 at 3:33 PM "Krzysztof Mrozowicz" wrote: > Once I applied the proposed solution, I asked myself a similar question > and I found that there is a script provided with sogo, called > sql-update-5.5.1_to_5.6.0.sh which contains the following: > > echo "Converting c_value from VARCHAR(255) to VARCHAR(4096) in > sessions table ($sessiontable)" > mysql -v $mysqlargs -e "ALTER TABLE $sessiontable MODIFY c_value > VARCHAR(4096);" > > I already changed it to "text" and it works, but maybe VARCHAR(4096) also > does the job? > > Best Regards > Krzysztof > > W dniu: Środa, Maj 10, 2023 09:40 IST, "Odhiambo Washington" ( > odhia...@gmail.com) napisał(a): > > > Looking at my 5.8.0 setup, and my table: > > > > SQL> show create table sogo_sessions_folder: > > > > sogo_sessions_folder | CREATE TABLE `sogo_sessions_folder` ( > > `c_id` varchar(255) NOT NULL, > > `c_value` varchar(255) NOT NULL, > > `c_creationdate` int(11) NOT NULL, > > `c_lastseen` int(11) NOT NULL, > > PRIMARY KEY (`c_id`) > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 > > > > So I want to ask: Is the change of c_value type from varchar to text > > documented in some ChangeLog that I missed? > > And how does it affect the logged in session expiry? > > > > > > On Tue, May 9, 2023 at 9:13 PM Yaisel Cruz Zuñiga wrote: > > > > > Hi, > > > > > > 1. The MySQL database. Change the column type of c_value: > > > mysql -u root > > > use sogo; > > > alter table sogo_sessions_folder modify column c_value text; > > > > > > El 9/5/23 a las 6:33, "Krzysztof Mrozowicz" (krzysz...@mrozowicz.eu) > > > escribió: > > > > Hi, > > > > a few months ago I noticed that I get auto logged out from the SOGo > web > > > interface after around 1-2 minutes. Earlier I had to logout manually > and > > > the session was open for days (as far as I remember). Has something > change > > > in SOGo? Is there a way to restore the previous behavior? > > > > > > > > Regards > > > > Krzysztof > > > > > > > > > > > > > Universidad de Cienfuegos “Carlos Rafael Rodríguez” > > > #MiCasaUCf #EvaluaciónInstitucional2023 > > > #InspiramosLaExcelenciaEnElSaber<https://www.ucf.edu.cu/?p=12413> > > > > > > > > > -- > > Best regards, > > Odhiambo WASHINGTON, > > Nairobi,KE > > +254 7 3200 0004/+254 7 2274 3223 > > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > > [How to ask smart questions: > > http://www.catb.org/~esr/faqs/smart-questions.html] > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] quick auto logout in sogo 5.x
Looking at my 5.8.0 setup, and my table: SQL> show create table sogo_sessions_folder: sogo_sessions_folder | CREATE TABLE `sogo_sessions_folder` ( `c_id` varchar(255) NOT NULL, `c_value` varchar(255) NOT NULL, `c_creationdate` int(11) NOT NULL, `c_lastseen` int(11) NOT NULL, PRIMARY KEY (`c_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 So I want to ask: Is the change of c_value type from varchar to text documented in some ChangeLog that I missed? And how does it affect the logged in session expiry? On Tue, May 9, 2023 at 9:13 PM Yaisel Cruz Zuñiga wrote: > Hi, > > 1. The MySQL database. Change the column type of c_value: > mysql -u root > use sogo; > alter table sogo_sessions_folder modify column c_value text; > > El 9/5/23 a las 6:33, "Krzysztof Mrozowicz" (krzysz...@mrozowicz.eu) > escribió: > > Hi, > > a few months ago I noticed that I get auto logged out from the SOGo web > interface after around 1-2 minutes. Earlier I had to logout manually and > the session was open for days (as far as I remember). Has something change > in SOGo? Is there a way to restore the previous behavior? > > > > Regards > > Krzysztof > > > > > Universidad de Cienfuegos “Carlos Rafael Rodríguez” > #MiCasaUCf #EvaluaciónInstitucional2023 > #InspiramosLaExcelenciaEnElSaber<https://www.ucf.edu.cu/?p=12413> > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Help me
On Fri, May 5, 2023 at 5:03 AM Marco Moock wrote: > Am 03.05.2023 schrieb "William Bowden" (will...@jmrit.co.uk) > : > > > What mail system have you built and on what platform please > > SPF is in DNS - DKIM in your outgoing MTA. > > There are free software solutions like sendmail, postfix and Exim. > Which software do you use? > I mostly use Exim and sometimes Postfix for MTA. I use Dovecot for IMAP4/POP3. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Nightly change logs
I have looked at https://github.com/Alinto/sogo/commits/master and saw April 29, 2023 and decided that I was left behind by time :-) On Fri, Apr 21, 2023 at 11:16 AM smizr...@alinto.eu wrote: > Hi Simon, > > You can check the commits on github for the previous day : > - https://github.com/Alinto/sope/commits/master > - https://github.com/Alinto/sogo/commits/master > > As Odhiambo says, the builds are done every night automatically, > regardless changes are made or not. > > Sebastien > > Le Vendredi, Avril 21, 2023 01:45 CEST, "\"Simon Wilson\"" ( > si...@simonandkate.net) a écrit: > > > I have been unable to find information on changes included in the nightly > SOGo updates - is that published anywhere? > > -- > Simon Wilson > M: 0400 121 116 > > > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Nightly change logs
Nightly builds are built nightly whether there are changes or not, IMHO. On Fri, Apr 21, 2023 at 4:50 AM "Simon Wilson" wrote: > I have been unable to find information on changes included in the nightly > SOGo updates - is that published anywhere? > > -- > Simon Wilson > M: 0400 121 116 -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Access to SOGo
On Tue, Apr 18, 2023 at 4:41 PM Jacob Harvie wrote: > Morning > > I am having issues accessing my email from home, both from WiFi and Bell > LTE, what would be the cause? Unhandled error response is all I get when I > try to login. > > Please help! > /var/log/sogo/sogo.log?? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Logout and errors
On Sun, Apr 16, 2023 at 11:41 AM Simon Wilson
wrote:
> - Message from Simon Wilson -
> Date: Sun, 16 Apr 2023 18:24:48 +1000
> From: Simon Wilson
> Reply-To: si...@simonandkate.net
> Subject: Re: [SOGo] Logout and errors
> To: Odhiambo Washington
> Cc: users@sogo.nu
>
> - Message from Odhiambo Washington -
> Date: Sun, 16 Apr 2023 11:02:25 +0300
> From: Odhiambo Washington
> Subject: Re: [SOGo] Logout and errors
> To: si...@simonandkate.net
> Cc: users@sogo.nu
>
> On Sun, Apr 16, 2023 at 4:57 AM Simon Wilson wrote:
>
> I'm trialling SOGo and running into some challenges with strange
> unprompted logouts.
>
> I'll be using the web interface, and all of a sudden will be dropped
> back to login. Login at this point does not work.
>
> Log contains a bunch (60 or 70 in a row) of:
>
> Apr 16 09:20:54 sogod [79477]: [WARN] <0x0x55c361413710[WOElementID]>
> tried to increment a non-existing element-id
> Apr 16 09:20:54 sogod [79477]: [WARN] <0x0x55c361413710[WOElementID]>
> tried to increment a non-existing element-id
> Apr 16 09:20:54 sogod [79477]: [WARN] <0x0x55c361413710[WOElementID]>
> tried to increment a non-existing element-id
>
> ...followed by:
>
> Apr 16 09:20:54 sogod [79477]:
> <0x0x55c360e9ea30[SOGoWebAuthenticator]> tried wrong password for user
> 'QzsX6IKlQ9RuWvMoQbtCB8zaZ... where the string is several hundred
> characters, and that line is repeated three times.
>
> Once that happens, no-one can login until sogod is restarted.
>
> What's your DB backend?
> Hopefully, you followed this
>
> https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration
> and can get more debug?
>
> Yes I followed the instructions on setting up the DB. I am using mysql.
> MySQL log is clear at the time of the issue. Configuration is:
>
> /* Database configuration */
> OCSFolderInfoURL = "
> mysql://sogo:password@localhost:3306/sogo/sogo_folder_info";
> SOGoProfileURL = "
> mysql://sogo:password@localhost:3306/sogo/sogo_user_profile";
> OCSSessionsFolderURL = "
> mysql://sogo:password@localhost:3306/sogo/sogo_sessions_folder";
> OCSEMailAlarmsFolderURL = "
> mysql://sogo:password@localhost:3306/sogo/sogo_alarms_folder";
>
> Authentication is LDAP:
>
> /* LDAP */
>
> domains = {
>simonandkate.net = {
> SOGoMailDomain = simonandkate.net;
> SOGoUserSources = (
>{
> type = ldap;
> CNFieldName = cn;
> IDFieldName = uid;
> UIDFieldName = uid;
> MailFieldNames = (mail);
> baseDN = "ou=users,dc=simonandkate,dc=lan";
> bindDN = "cn=horde,ou=accounts,dc=simonandkate,dc=lan";
> bindFields = (mail);
> IMAPLoginFieldName = uid;
> bindPassword = password;
> bindAsCurrentUser = YES;
> userPasswordAlgorithm = ssha512;
> canAuthenticate = YES;
> displayName = "Global Directory";
> hostname = "ldap://ldap.simonandkate.lan/!StartTLS;;
> id = public;
> isAddressBook = YES;
>}
> );
>};
> };
>
> SOGoEnableDomainBasedUID = YES;
>
> The system seems to be working OK most of the time, but randomly (has done
> it three times over last 24 h) throws user out, chucks 70 x WOElementID
> errors, then the messages with 100s of characters long "user" trying wrong
> password, and a blocked system with no login capable until sogod is
> restarted.
>
> This is the log's startup sequence, and all looks fine:
> Apr 16 18:20:32 sogod [165019]: version 5.8.2 (build root@ 202304152116)
> -- starting
> Apr 16 18:20:32 sogod [165019]: vmem size check enabled: shutting down app
> when vmem > 384 MB. Currently at 244 MB
> Apr 16 18:20:32 sogod [165019]: <0x0x55c461a29f70[SOGoProductLoader]> SOGo
> products loaded from '/usr/lib64/GNUstep/SOGo':
> Apr 16 18:20:32 sogod [165019]: <0x0x55c461a29f70[SOGoProductLoader]>
> AdministrationUI.SOGo, Appointments.SOGo, CommonUI.SOGo, Contacts.SOGo,
> ContactsUI.SOGo, MailPartViewers.SOGo, Mailer.SOGo, MailerUI.SOGo,
> MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, ActiveSync.SOGo
> Apr 16 18:20:32 sogod [165019]: All products loaded - current memory usage
> at 296 MB
> Apr 16 18:20:32 sogod [165019]: <0x0x55c461a4e970[WOWatchDog]> listening
> on 127.0.0.1:2
> Apr 16 18:20:32 sogod [165019]: <0x0x55c461a4e970[WOWatchDog]> watchdog
> process pid: 165019
> Apr 16 18:20:32 sogod [165019]: <0x0x7f8c7d878f80[WOWatchDogChild]>
> watchdog request timeout
Re: [SOGo] Logout and errors
On Sun, Apr 16, 2023 at 4:57 AM Simon Wilson wrote: > I'm trialling SOGo and running into some challenges with strange > unprompted logouts. > > I'll be using the web interface, and all of a sudden will be dropped > back to login. Login at this point does not work. > > Log contains a bunch (60 or 70 in a row) of: > > Apr 16 09:20:54 sogod [79477]: [WARN] <0x0x55c361413710[WOElementID]> > tried to increment a non-existing element-id > Apr 16 09:20:54 sogod [79477]: [WARN] <0x0x55c361413710[WOElementID]> > tried to increment a non-existing element-id > Apr 16 09:20:54 sogod [79477]: [WARN] <0x0x55c361413710[WOElementID]> > tried to increment a non-existing element-id > > ...followed by: > > Apr 16 09:20:54 sogod [79477]: > <0x0x55c360e9ea30[SOGoWebAuthenticator]> tried wrong password for user > 'QzsX6IKlQ9RuWvMoQbtCB8zaZ... where the string is several hundred > characters, and that line is repeated three times. > > Once that happens, no-one can login until sogod is restarted. > What's your DB backend? Hopefully, you followed this https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration and can get more debug? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Problem after updating libxml
On Sun, Apr 16, 2023 at 4:57 AM HYVERNAT Philippe wrote: > Hello, > > Thanks for your answer i reinstall Gnustep and everything is ok ! > You're welcome. Maybe you need to run `portupgrade -a` on that host? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Problem after updating libxml
On Sat, Apr 15, 2023 at 1:49 AM HYVERNAT Philippe wrote: > Hello, > > After updating my FreeBSD node with sogo here is tje error while > accessing the webmail (white page, not loading at all) : > How did you update the FreeBSD node? Maybe you were told to rebuild all ports and you did not :-) You updated from which version to which one? > > Apr 14 23:33:39 sogod [75521]: |SOGo| starting method 'GET' on uri '/SOGo' > Apr 14 23:33:39 sogod [75521]: <0x0x80522eca8[SOGoCache]> Cache cleanup > interval set every 300.00 seconds > Apr 14 23:33:39 sogod [75521]: <0x0x80522eca8[SOGoCache]> Using host(s) > '/var/run/memcached/memcahed.pid' as server(s) > 2023-04-14 23:33:39.425 sogod[75521:100321] -[SaxXMLReaderFactory > createXMLReaderWithName:]: could not load SaxDriver bundle 0x80522f388 fullPath: > /usr/local/GNUstep/Local/Library/SaxDrivers-4.9/libxmlSAXDriver.sax > infoDictionary: 0x80522f478 loaded=no> ! > 2023-04-14 23:33:39.425 sogod[75521:100321] -[DOMBuilderFactory > createDOMBuilderForMimeType:]:88: could not create DOM builder for MIME > type 'text/xml' because no SAX proper reader could be constructed. > 2023-04-14 23:33:39.425 sogod[75521:100321] WOxTemplateBuilder.m:128 > Assertion failed in WOxTemplateBuilder(instance), method > buildTemplateAtURL:. missing XML parser .. > 2023-04-14 23:33:39.430 sogod[75521:100321] EXCEPTION: 0x806227c98> NAME:NSInternalInconsistencyException > REASON:WOxTemplateBuilder.m:128 Assertion failed in > WOxTemplateBuilder(instance), method buildTemplateAtURL:. missing XML > parser .. INFO:(null) > Apr 14 23:33:39 sogod [75521]: |SOGo| request took 0.024140 seconds to > execute > Apr 14 23:33:39 sogod [75521]: 172.17.2.1 "GET /SOGo HTTP/1.1" 501 0/0 > 0.032 - - - > > > i reinstall sogo and libxml but nothing. > > Some helps please ? > > Thanks by advance > > > SOGO 5.8 > > libxml2.10.3_2 > > Thanks by advance > > HYVERNAT Philippe > Try this: cd /usr/ports/www/sogo && make deinstall cd /usr/ports/devel/sope && make deinstall cd /usr/ports/www/sogo && make install clean delete all files in /var/log/sogo # That is where I store my sogod logs service sogod start Look at sogo.log now and tell us what it says. I am running 5.8 on FreeBSD 13.2 (yes, I upgraded just the other day from 13.1) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] password
On Sat, Apr 15, 2023 at 1:48 AM "news...@gmx.de" wrote: > Hello, I suppose that was a human answer to my question? If so, here is > my reply: I cannot find the menu item "sogo.conf" under preferences. > Where is it? > > cheers > neff > > It was a clue, that you need to check your /etc/sogo.conf and you could refer to https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_configuration -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Evaluate SOGo
On Sat, Apr 15, 2023 at 10:18 AM Simon Wilson wrote: > I'm looking to evaluate SOGo, but am a bit confused by the > documentation at sogo.nu. > > That documentation at > https://www.sogo.nu/files/docs/SOGoInstallationGuide.html says "In > order to access the production builds, you need a proper support > contract from Alinto. Continue with the configuration once you > received your username and password." > The link from that text results in a 404 error, so that is a dead-end > (points to https://sogo.nu/support/index_new.html#support-plans) > > I found an article through the FAQs about nightly builds - is that the > way to install without a support contract? > Yes, that is correct. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] password
On Fri, Apr 14, 2023 at 4:26 PM "neff" wrote: > One of the recent updates must have removed the ability to change the > password > in the General settings. Where do I find that now? Thanks > sogo.conf -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Re: [SOGo] Support Contract
Really? Customizing SOGo beyond the community support is when you need a contract. On Tue, Mar 21, 2023 at 4:01 PM Florian Grethler wrote: > Hello, > To configure SOGo you need a proper Support contract. How do i get one? > > Best Regards, > Florian > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Login SOGo and IMAP login must be the same?
SOGo is just a fronted. You IMAP server determines how you authenticate. On Sun, Mar 5, 2023, 19:02 Samuel Wolf wrote: > Hi, > > I testing SOGo first time and on thing is not clear to me: > SOGo login for example via LDAP and IMAP server login must be the same? > > Or is it possible to authenticate against LDAP and use complete > different logins for the IMAP server? > > Thanks. > > Samuel >
Re: [SOGo] ldap integration
On Sun, Feb 26, 2023 at 5:35 PM supp...@foxnet.be wrote: > Hello > I use Mysql to manage users. > I would like to use LDAP for another way of identification. > Is this possible? > https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_authentication_using_ldap -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Sogo Calendar events deleted
Why would you let log file grow to several GB? What happened to configuring log file rotations? :) Please split the log file into several manageable sizes. Something like this: split -b100m -a5 sogo.log (Split splits the files based upon your size specification whether based upon line or bytes. It then adds a suffix to these files to keep them in order) and do the usual grep on them - grep "string1|string2|string3" file_name. On Tue, Feb 14, 2023 at 12:21 PM HYVERNAT Philippe wrote: > Ok i activate : > > MySQL4DebugEnabled = YES; > > SOGoEASDebugEnabled = YES; > > > Restart the service and log are written. > > like my precedent mail we have many errors like : > > Feb 14 09:38:35 sogod [54518]: <0x0x804807118[SOGoCache]> an error > occurred when caching value for key '/Users/*user*@ > ehpad-avs.fr/Calendar/personal': "SERVER HAS FAILED AND IS DISABLED UNTIL > TIMED RETRY" > > > > Do you know how can i filter my log ? > > With grep "warning" and grep "error" ? the log file wait several GB > > > Le 14/02/2023 à 07:24, Odhiambo Washington (odhia...@gmail.com) a écrit : > > > > On Mon, Feb 13, 2023 at 7:40 PM HYVERNAT Philippe wrote: > >> Thanks a lot for your answer : >> >> Here is my configuration. I add EAS options. Nothing was set >> >> The problem is that the issue is very difficult to make and users doesn't >> know when it really appear. >> >> I check the debug log for EAS and see >> > > The Debug log for EAS and MySQL ! > Those two must reveal something. > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Sogo Calendar events deleted
On Tue, Feb 14, 2023 at 9:50 AM HYVERNAT Philippe wrote: > In complement, we have many error like this : > > I follow recommendations from the list to solve this issue but never works. > > > > sogod [89977]: <0x0x804808158[SOGoCache]> an error occurred when caching > value for key '/Users/u...@mydomein.com/Calendar/personal': "SERVER HAS > FAILED AND IS DISABLED UNTIL TIMED RETRY" > For starters, may I please request you to try and adhere to the following guideline when communicating on mailing lists: 1. https://support.google.com/a/users/answer/9283192#better-conversations I am mostly interested in replying inline and NOT top-posting. Thank you very much. Now, looking at your captured error, it would appear that you have a problem with caching and that problem lies with memcached, because that is where caching is done. On FreeBSD which I believe you are familiar with, you can do one of two things: 1. Log all queries to memcached. You do this by adding -vvv (the number of v's depend on the verbosity you want) to memcached_flags in rc.conf and restarting memcached. I'd also try and give Memcached a little more RAM to use with -m 128 2. Capture these queries in it's own file by adding a specific logging config to /etc/syslog.conf: !memcached *.* /var/log/memcached.log #please touch this file! Then restart syslogd with: kill -HUP `cat /var/run/syslog.pid` >From there, for every entry about caching in sogo.log, check for a corresponding entry in memcached.log. Hopefully, you will nail the problem by deducing a solution. Sorry for the lecture. I just did not want to make assumptions that you know what I wanted you to do :) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Sogo Calendar events deleted
On Mon, Feb 13, 2023 at 7:40 PM HYVERNAT Philippe wrote: > Thanks a lot for your answer : > > Here is my configuration. I add EAS options. Nothing was set > > The problem is that the issue is very difficult to make and users doesn't > know when it really appear. > > I check the debug log for EAS and see > The Debug log for EAS and MySQL ! Those two must reveal something. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Sogo Calendar events deleted
On Mon, Feb 13, 2023 at 5:44 PM HYVERNAT Philippe wrote: > Hello community; > > I'm trouble with a customer where i installed SOGO for a while. > > The installation were on FreeBSD 13.1 with mysql 80. > > My customer have 80 mails boxes and shared calendars between with them > with Outlook 2021 and EAS. > The trouble is that events is deleted sometimes (it isn't deleted from > users). > > this problem appeared since Sogo 5.4 we are in version 5.8 now. > And were MySQL-8.x and Outlook 2021 present? No. Did the problem happen with any other version of MySQL or Outlook prior to 2021? No log on servers... > Did you say that you have set: SOGoEASDebugEnabled = YES; ..and nothing was logged?? my customer is very disappointed because it wants to migrate do Exchange > if the problem doesn't resolve. > > > Thanks by advance for an answer. > > Philippe > The fact that you are using MySQL means if you logged MySQL events, you'd catch every access and every change, no? I would turn ON all debug and look for clues on the dates the deletions happen. Just ensure you have sane values for your environment. /* EAS */ SOGoMaximumSyncResponseSize = 512; SOGoMaximumSyncWindowSize = 30; SOGoEASDebugEnabled = YES; /* Debug */ //SOGoDebugRequests = YES; //SoDebugBaseURL = YES; //ImapDebugEnabled = YES; //LDAPDebugEnabled = YES; //PGDebugEnabled = YES; //MySQL4DebugEnabled = YES; //SOGoUIxDebugEnabled = YES; //WODontZipResponse = YES; //WOLogFile = /var/log/sogo/sogo.log; //GCSFolderDebugEnabled = YES; //GCSFolderStoreDebugEnabled = YES; //NGImap4DisableIMAP4Pooling = YES; //OCSFolderManagerSQLDebugEnabled = YES; //PGDebugEnabled = YES; //SOGoMailKeepDraftsAfterSend = YES; //SoDebugObjectTraversal = YES; //SoSecurityManagerDebugEnabled = YES; //WODebugZipResponse = YES; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] change password
On Thu, Jan 12, 2023 at 4:20 PM "Support FoxNet" wrote: > Hello > > In the administrator area of the user, how to disable the password button, > so that the user can not do it? > > Michel Please take time and read about all the config parameters available for sogo.conf <https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_configuration>! /* Authentication */ SOGoPasswordChangeEnabled = NO; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Theme sogo
On Thu, Jan 12, 2023 at 4:19 PM "Support FoxNet" wrote: > Hello > > I know if this question has already been asked, but there are sogo themes? > > Michel 1. https://www.sogo.nu/support/faq/how-to-change-the-color-theme.html 2. https://github.com/mailcow/mailcow-dockerized/issues/2728 -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGo with NginX Reverse Proxy - White Screen no CSS
On Fri, Jan 6, 2023 at 5:04 PM Eben van Deventer wrote:
> Hi all
>
> I have found only one previous post in this regard and there was no
> resolution that I can see from the archive as this user was using iRedMail,
> which is not the case for me:
>
> When I connect to SOGo via the NginX reverse Proxy I get a white screen
> with no formatting or CSS (Attached Screenshot). I have tried various
> configurations from online to configure the Virtual Host and this keeps
> being the case each time.
>
> I would appreciate if anyone could tell me where I am going wrong, have
> configured on a seperate server behind Apache, however on this server
> Apache is not an option due to the way it is being deployed.
>
> System:
> Debian 11 (Fully Updated)
> Nginx and SOGo from official Repos (Not Debian Repos)
> 16GB RAM
> 16 Core XEON
>
> My NginX Virtual Host as follows:
>
> server {
> listen 80 default;
> server_name mail.buff0k.co.za;
> root /usr/lib/GNUstep/SOGo/WebServerResources/;
> location = / {
> rewrite ^ http://$server_name/SOGo;
> allow all;
> }
> # For IOS 7
> location = /principals/ {
> rewrite ^ http://$server_name/SOGo/dav;
> allow all;
> }
> location ^~/SOGo/ {
> proxy_pass http://127.0.0.1:2;
> proxy_redirect http://127.0.0.1:2 default;
> # forward user's IP address
> proxy_set_header X-Real-IP $remote_addr;
> proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
> proxy_set_header Host $host;
> proxy_set_header x-webobjects-server-protocol HTTP/1.0;
> proxy_set_header x-webobjects-remote-host 127.0.0.1;
> proxy_set_header x-webobjects-server-name $server_name;
> proxy_set_header x-webobjects-server-url $scheme://$host;
> proxy_connect_timeout 90;
> proxy_send_timeout 90;
> proxy_read_timeout 90;
> proxy_buffer_size 4k;
> proxy_buffers 4 32k;
> proxy_busy_buffers_size 64k;
> proxy_temp_file_write_size 64k;
> client_max_body_size 100m;
> client_body_buffer_size 128k;
> break;
> }
> location /SOGo.woa/WebServerResources/ {
> alias /usr/lib/GNUstep/SOGo/WebServerResources/;
> allow all;
> }
> location /SOGo/WebServerResources/ {
> alias /usr/lib/GNUstep/SOGo/WebServerResources/;
> allow all;
> }
> location ^/SOGo/so/ControlPanel/Products/([^/]*)/Resources/(.*)$ {
> alias /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2;
> }
> location
> ^/SOGo/so/ControlPanel/Products/[^/]*UI/Resources/.*\.(jpg|png|gif|css|js)$
> {
> alias /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2;
> }
> }
>
>
Can you please check the nginx logs for this VHOST. The last time I had an
issue like this there were some weird caching issues.
I am not an nginx enthusiast though.
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Error compiling SOGo 5.8.0
On Sun, Jan 1, 2023 at 10:57 PM Jose David Bravo A wrote: > Hi > > I'm trying to build from source SOGo 5.8.0, I already copiled and > installed SOPE... but I don't know why is this error happening whole doing > make on the SOGo source: > > > gobjc -shared \ > -Wl,--no-as-needed -lcurl -Wl,-z,relro -Wl,-z,now > -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -shared-libgcc -pthread > -fexceptions -rdynamic -o Appointments.SOGo/./Appointments \ > ./obj/Appointments.obj/Product.m.o > ./obj/Appointments.obj/NSArray+Appointments.m.o > ./obj/Appointments.obj/iCalAlarm+SOGo.m.o > ./obj/Appointments.obj/iCalCalendar+SOGo.m.o > ./obj/Appointments.obj/iCalEntityObject+SOGo.m.o > ./obj/Appointments.obj/iCalRepeatableEntityObject+SOGo.m.o > ./obj/Appointments.obj/iCalEvent+SOGo.m.o > ./obj/Appointments.obj/iCalEventChanges+SOGo.m.o > ./obj/Appointments.obj/iCalPerson+SOGo.m.o > ./obj/Appointments.obj/iCalToDo+SOGo.m.o > ./obj/Appointments.obj/SOGoCalendarComponent.m.o > ./obj/Appointments.obj/SOGoAppointmentObject.m.o > ./obj/Appointments.obj/SOGoTaskObject.m.o > ./obj/Appointments.obj/SOGoComponentOccurence.m.o > ./obj/Appointments.obj/SOGoAppointmentOccurence.m.o > ./obj/Appointments.obj/SOGoTaskOccurence.m.o > ./obj/Appointments.obj/SOGoAppointmentFolder.m.o > ./obj/Appointments.obj/SOGoAppointmentFolderICS.m.o > ./obj/Appointments.obj/SOGoAppointmentFolderObject.m.o > ./obj/Appointments.obj/SOGoAppointmentFolderXML.m.o > ./obj/Appointments.obj/SOGoAppointmentInboxFolder.m.o > ./obj/Appointments.obj/SOGoWebAppointmentFolder.m.o > ./obj/Appointments.obj/SOGoAppointmentFolders.m.o > ./obj/Appointments.obj/SOGoFreeBusyObject.m.o > ./obj/Appointments.obj/SOGoUser+Appointments.m.o > ./obj/Appointments.obj/SOGoUserFolder+Appointments.m.o > ./obj/Appointments.obj/SOGoCalendarProxy.m.o > ./obj/Appointments.obj/SOGoAptMailNotification.m.o > ./obj/Appointments.obj/SOGoAptMailInvitation.m.o > ./obj/Appointments.obj/SOGoAptMailDeletion.m.o > ./obj/Appointments.obj/SOGoAptMailICalReply.m.o > ./obj/Appointments.obj/SOGoAptMailUpdate.m.o > ./obj/Appointments.obj/SOGoAptMailReceipt.m.o > ./obj/Appointments.obj/SOGoAptMailReminder.m.o > ./obj/Appointments.obj/SOGoEMailAlarmsManager.m.o > ./obj/Appointments.obj/MSExchangeFreeBusySOAPRequest.m.o > ./obj/Appointments.obj/MSExchangeFreeBusy.m.o \ > -L../SOGo/SOGo.framework/Versions/Current/sogo/ -lSOGo > -L../../SOGo/./obj/ -L../../SOPE/NGCards/./obj/ -lNGCards > -L../../SOPE/GDLContentStore/./obj/ -lGDLContentStore -L/usr/local/lib > -Wl,-rpath,/usr/lib64/sogo -L../../SOPE/GDLContentStore/obj/ > -L/root/GNUstep/Library/Libraries -L/usr/local/lib64 -L/usr/lib64 > -lNGObjWeb -lNGMime -lNGStreams -lNGExtensions -lGDLAccess > -lNGObjWeb -lNGMime -lNGLdap -lNGStreams -lNGExtensions -lEOControl -lDOM > -lSaxObjC -lSBJson -lgnustep-base-lobjc -lm > */usr/bin/ld: cannot find -lSOGo* > collect2: error: ld returned 1 exit status > gmake[3]: *** [/usr/lib64/GNUstep/Makefiles/wobundle.make:173: > Appointments.SOGo/./Appointments] Error 1 > gmake[2]: *** [/usr/lib64/GNUstep/Makefiles/Master/rules.make:297: > Appointments.all.wobundle.variables] Error 2 > gmake[1]: *** > [/usr/lib64/GNUstep/Makefiles/Master/serial-subdirectories.make:53: > internal-all] Error 2 > make: *** > [/usr/lib64/GNUstep/Makefiles/Master/serial-subdirectories.make:53: > internal-all] Error 2 > > Any idea? > Well, it says what the error is. Are you sure you want to link SOGo to itself? The '/usr/bin/ld: cannot find -lSOGo' seems to suggest that, or maybe you should remove it. And why compile manually though? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Sogo problem after migrate to the new virtual server
On Wed, Dec 14, 2022 at 9:34 AM admin wrote:
> Hello, we have a problem after we migrate sogo to new virtual server.
> There is some logs. First error log: <0x0x564cf6fae340[WOWatchDog]> No
> child available to handle incoming request!
> Default/sogo log:
> # The amount of processes that should be spawned (Default: 3)
> PREFORK=85
>
> # The name of the account under which SOGo will be running (Default:
> sogo)
> # USER=sogo
> Sogo.config:
> {
> //
> // - Official SOGo document:
> http://sogo.nu/support/index.html#/documentation
> // - Mailing list: http://sogo.nu/support/index.html#/community
> //
>
> // Daemon address and port
> WOPort = 127.0.0.1:2;
>
> // PID file
> //WOPidFile = /var/run/sogo/sogo.pid;
>
> // Log file
> //WOLogFile = /var/log/sogo/sogo.log;
>
> // Enable verbose logging. Reference:
> //
>
> http://www.sogo.nu/nc/support/faq/article/how-to-enable-more-verbose-logging-in-sogo.html
> //SOGoDebugRequests = YES;
> //SOGoEASDebugEnabled = YES;
> //ImapDebugEnabled = YES;
> //LDAPDebugEnabled = YES;
> //MySQL4DebugEnabled = YES;
> //PGDebugEnabled = YES;
>
^
Enabling those debugging parameters and restarting sogod will help you
diagnose the problem and fix it.
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] DNS A record round robin
On Tue, Nov 8, 2022 at 8:59 PM Marco Moock wrote: > Am 08.11.2022 um 18:48:47 Uhr schrieb Odhiambo Washington: > > > Well, this is something that you can check from SOGo's logs. If you > > gave it that name as the IMAP server, > > you can check on the logs to see the IP address it is making a > > connection to. > > It currently only connects to the server in the fist A record (no > set, our admins haven't already set up IPv6, sadly). > You can have this load-balancing implemented if you wanted, probably even locally on the host running SOGo. dnsdist, haproxy, traefik all come to mind. You just need a TCP load balancer. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] DNS A record round robin
On Tue, Nov 8, 2022 at 6:36 PM Marco Moock wrote: > Am 08.11.2022 um 16:48:53 Uhr schrieb Odhiambo Washington: > > > SOGo is not a load-balancer. > > SOGo daemon only listens and responds to what the web server requests > > of it. > > I talked about the connection to the IMAP server. Does sogo do any load > balancing there is it is possible, e.g. because multiple A, or > CNAME are set for the DNS fo the IMAP server? > Well, this is something that you can check from SOGo's logs. If you gave it that name as the IMAP server, you can check on the logs to see the IP address it is making a connection to. I will leave the definitive answer to the developers to talk about how the DNS libraries behave :) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] DNS A record round robin
SOGo is not a load-balancer. SOGo daemon only listens and responds to what the web server requests of it. On Tue, Nov 8, 2022 at 4:38 PM Marco Moock wrote: > Hello, > at work we have 2 IMAP servers. There is a hostname with 2 A records. > Does sogo do DNS round-robin by using them randomly or does sogo use > just the first and only uses the second if the first is unreachable? > Currently the requests only go to the machine listed in the 1st A. > > -- > kind regards > Marco > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] - Sogo 5.7.1 and FreeBSD
Do not attempt to compile SOGo manually on FreeBSD. You will end up with a very dirty system. On Fri, Oct 21, 2022 at 10:29 AM mich wrote: > > https://www.esup-portail.org/wiki/display/SOGO/Installation+SOGo++v5+sur+Debian+buster > > Or to compile it manually, I saw a tutorial under debian taking the > current version ... > > Best regards, > > Michel > > Le 21/10/22 08:47, « Ganael Laplanche( > ganael.laplan...@centralesupelec.fr) » users@sogo.nu> a écrit : > > On Thursday, October 20, 2022 9:31:50 PM CEST mich wrote: > > Hello Philippe, > > > https://www.freshports.org/www/sogo > > > > https://www.freshports.org/www/sogo#history > > > > 5.7.0_2 version ... > > You should probably ask the port maintainer (Alonso Cárdenas Márquez > ) if he has plans for an update. > > Best regards, > > -- > Ganael Laplanche > Unix Systems Engineer @CentraleSupelec Rennes - DISI > > > > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] [COMMUNICATION] Password recovery feature available
That would be awesome. Utmost security. On Mon, Oct 17, 2022 at 12:54 PM smizr...@alinto.eu wrote: > Hey ! > > Currently only one secret question OR email recovery can be set by user. > But of course we can improve the mechanism to add more than one secret > question ;) > > Sebastien > > Le Lundi, Octobre 17, 2022 10:20 CEST, "Odhiambo Washington" ( > odhia...@gmail.com) a écrit: > > > Thank you so much for this feature. > > Can you please explain how SOGoPasswordRecoveryQuestion can be > implemented? Suppose I want users to set > all SecretQuestion1, SecretQuestion2 and SecretQuestion3 - how do I do that? > > On Mon, Oct 17, 2022 at 11:02 AM smizr...@alinto.eu wrote: > >> Dear community users, >> >> As many of you asked, we have implemented a new password recovery feature >> in SOGo. >> This feature allows users to retrieve their password using a secret >> question or a secured link sent to a secondary email. >> >> This is available in the latest Nightly Build. You'll need to set >> *SOGoPasswordRecoveryEnabled* and *SOGoJWTSecret* in sogo.conf according >> to documentation ( >> https://github.com/Alinto/sogo/blob/master/Documentation/SOGoInstallationGuide.asciidoc >> ). >> Obviously you can answer this thread to improve this feature with your >> ideas, and open bugs if you have troubles on bugs.sogo.nu. >> >> We plan to release a 5.8.0 at the end of October. >> >> Sebastien >> *Alinto* > > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > > > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] [COMMUNICATION] Password recovery feature available
Thank you so much for this feature. Can you please explain how SOGoPasswordRecoveryQuestion can be implemented? Suppose I want users to set all SecretQuestion1, SecretQuestion2 and SecretQuestion3 - how do I do that? On Mon, Oct 17, 2022 at 11:02 AM smizr...@alinto.eu wrote: > Dear community users, > > As many of you asked, we have implemented a new password recovery feature > in SOGo. > This feature allows users to retrieve their password using a secret > question or a secured link sent to a secondary email. > > This is available in the latest Nightly Build. You'll need to set > *SOGoPasswordRecoveryEnabled* and *SOGoJWTSecret* in sogo.conf according > to documentation ( > https://github.com/Alinto/sogo/blob/master/Documentation/SOGoInstallationGuide.asciidoc > ). > Obviously you can answer this thread to improve this feature with your > ideas, and open bugs if you have troubles on bugs.sogo.nu. > > We plan to release a 5.8.0 at the end of October. > > Sebastien > *Alinto* -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] When creating a second user
In which case your DB is rendered useless! On Mon, Oct 10, 2022 at 8:41 AM mich wrote: > Directadmin create email addresses locally and not via a database, > relative path > > > > /etc/virtual/%d/passwd > > > > Michel > > > > > > > > *De : * au nom de "Odhiambo Washington ( > odhia...@gmail.com)" > *Répondre à : * > *Date : *dimanche 9 octobre 2022 à 19:06 > *À : * > *Objet : *Re: [SOGo] When creating a second user > > > > You may need to RTFM for DirectAdmin again :-) > > Check where it stores the users. Perhaps it's using another DB different > than yours and you need to point it to the right one. > > > > > > On Sun, Oct 9, 2022 at 7:06 PM mich wrote: > > I asked the question, even on the forum see to administrators, no answer > is a pity, because it works at the level of creating accounts, except that > I can not identify from the login page. > > > > Connection protocol: > > > > imap pop3 lmtp sieve > > > > Michel > > > > *De : * au nom de "Odhiambo Washington ( > odhia...@gmail.com)" > *Répondre à : * > *Date : *dimanche 9 octobre 2022 à 13:25 > *À : * > *Objet : *Re: [SOGo] When creating a second user > > > > Do you perhaps want to ask this in the DirectAdmin forums? > > > > On Sat, Oct 8, 2022 at 11:23 AM mich wrote: > > Hello > > > > I am doing an integration test with DirectAdmin, and for the moment it > works well. > > > > However, when I create email accounts from the administration of SOGo via > the users created from DirectAdmin, I do not see them in my database. > > > > How to identify with the email address? > > > > Thank you very much > > > > Michel > > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] When creating a second user
You may need to RTFM for DirectAdmin again :-) Check where it stores the users. Perhaps it's using another DB different than yours and you need to point it to the right one. On Sun, Oct 9, 2022 at 7:06 PM mich wrote: > I asked the question, even on the forum see to administrators, no answer > is a pity, because it works at the level of creating accounts, except that > I can not identify from the login page. > > > > Connection protocol: > > > > imap pop3 lmtp sieve > > > > Michel > > > > *De : * au nom de "Odhiambo Washington ( > odhia...@gmail.com)" > *Répondre à : * > *Date : *dimanche 9 octobre 2022 à 13:25 > *À : * > *Objet : *Re: [SOGo] When creating a second user > > > > Do you perhaps want to ask this in the DirectAdmin forums? > > > > On Sat, Oct 8, 2022 at 11:23 AM mich wrote: > > Hello > > > > I am doing an integration test with DirectAdmin, and for the moment it > works well. > > > > However, when I create email accounts from the administration of SOGo via > the users created from DirectAdmin, I do not see them in my database. > > > > How to identify with the email address? > > > > Thank you very much > > > > Michel > > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] When creating a second user
Do you perhaps want to ask this in the DirectAdmin forums? On Sat, Oct 8, 2022 at 11:23 AM mich wrote: > Hello > > > > I am doing an integration test with DirectAdmin, and for the moment it > works well. > > > > However, when I create email accounts from the administration of SOGo via > the users created from DirectAdmin, I do not see them in my database. > > > > How to identify with the email address? > > > > Thank you very much > > > > Michel > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGO reusing Dovecot db password issue
On Fri, Oct 7, 2022 at 10:31 PM Serveria Support wrote: > Hi, > > Yes, you're totally right my friend! I was just desperate because I > needed help and the other thread was getting replies while mine wasn't. > Sorry about that. > > Anyway, you're my savior as I have double checked everything as you have > suggested and indeed the encryption algo was different in dovecot > config. Dovecot had sha512-crypt while SOGO tried to use ssha512. I'm > not sure how this is possible as I have checked everything billions of > times and I was 100% sure the same algo is in both configs. I have > changed ssha512 to sha512-crypt in dovecot config and voila: I'm able to > login into SOGO. Thanks again! > > P.S. By any chance you know how to prevent plain text passwords from > appearing in the logs? It kinda makes all my efforts useless and defeats > the whole encrypted storage concept... If you are storing passwords in plaintext in your DB, that's one thing you should think about. As regards your question, just disable all debugging from 10-logging.conf (dovecot). -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGO reusing Dovecot db password issue
@Serveria - I think it's a bad idea to address the same problem in two separate threads. Can you please stick to the one you created instead of the one you hijacked? On Thu, Oct 6, 2022 at 11:50 PM Serveria Support wrote: > MySQL4DebugEnabled = YES; line is enabled in my sogo.conf > > I'm not using any hashing atm, it's a test install, but if you mean > password algorithm I'm using ssha512 (used it as my Dovecot was using it > already and I was too lazy to change it). It seems to be supported: > > Possible values are: none, plain, crypt, md5, md5-crypt, sha256-crypt > and sha512-crypt, smd5, cram-md5 and sha, sha256, sha512 and its ssha > (e.g. ssha or ssha256) variants > > Any ideas? > > On 2022-10-06 16:35, Christian Mack wrote: > > Hi > > > > Enable debugging for mysql in sogo.conf: > > MySQL4DebugEnabled = YES; > > > > Also which password hashing are you using? > > See "userPasswordAlgorithm" in "Installation and Konfiguration Guide". > > > > > > Kind regards, > > Christian Mack > > > > Am 06.10.22 um 10:44 schrieb Serveria Support (supp...@serveria.com): > >> Hi, > >> > >> Thanks for responding. I did enable all possible logging in Dovecot > >> and I can see Windows Mail clients logging in successfully. But for > >> some reason my SOGo connection attempts are not showing up in logs at > >> all. SOGo log still shows the same error message I already posted. > >> SOGo website is giving me this error: Wrong username or password. > >> > >> On 2022-10-04 18:54, Odhiambo Washington wrote: > >>> On Thu, Sep 29, 2022 at 4:01 PM Serveria Support > >>> wrote: > >>> > >>>> Hi, > >>>> > >>>> After weeks of trying to configure iredmail package for my needs > >>>> (and > >>>> failing miserably) I decided to start everything from scratch: I > >>>> took a > >>>> vanilla Debian 11 server and installed Dovecot + Postfix + MariaDB + > >>>> > >>>> Apache. Mailserver works like a charm - emails are getting > >>>> sent/delivered/stored perfectly. Users are able to log > >>>> in/authenticate. > >>>> Then I decided to add SOGo to the config and installed it, also > >>>> configured using the basic howto from sogo website. All done, web > >>>> frontend comes up. So far so good unfortunately I'm unable to > >>>> authenticate using my Dovecot users db. Here I have to add that I > >>>> didn't > >>>> create a separate table for SOGo but instead tried to reuse my > >>>> Dovecot > >>>> user credentials by creating a VIEW in my DB. However, this doesn't > >>>> seem > >>>> to work, here's my sogo.log: > >>>> > >>>> Sep 29 06:30:17 sogod [151286]: XXXIPADDRESSXXX "POST /SOGo/connect > >>>> HTTP/1.1" 403 34/89 0.003 - - 0 - 12 > >>>> Sep 29 06:30:25 sogod [151286]: |SOGo| starting method 'POST' on uri > >>>> > >>>> '/SOGo/connect' > >>>> 2022-09-29 06:30:25.510 sogod[151286:151286] > >>>> SQL: > >>>> SELECT c_password FROM sogo_users WHERE c_uid = 'u...@mydomain.tld'; > >>>> 2022-09-29 06:30:25.510 sogod[151286:151286] > >>>> > >>>> query > >>>> has results, entering fetch-mode. > >>>> Sep 29 06:30:25 sogod [151286]: SOGoRootPage Login from > >>>> 'XXXIPADDRESSXXX' for user 'u...@mydomain.xxx' might not have worked > >>>> - > >>>> password policy: 65535 grace: -1 expire: -1 bound: 0 > >>>> Sep 29 06:30:25 sogod [151286]: |SOGo| request took 0.001784 seconds > >>>> to > >>>> execute > >>>> > >>>> Unfortunately, I'm not too good at reading SOGo logs and the error > >>>> message seems to be not very self-explanatory. What exactly does > >>>> this > >>>> mean? Unable to fetch password? Password didn't work? Wrong > >>>> encryption > >>>> protocol? Any suggestions? > >>> > >>> Look at the dovecot logging configuration and bump the debugging up > >>> and you'll get it right. > >>> > >>> -- Best regards, > >>> Odhiambo WASHINGTON, > >>> Nairobi,KE > >>> +254 7 3200 0004/+254 7 2274 3223 > >>> "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
On Thu, Oct 6, 2022 at 11:50 PM Serveria Support wrote: > Here it is: > > MariaDB [mailserver]> describe sogo_users; > ++--+--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > ++--+--+-+-+---+ > | c_uid | varchar(100) | NO | | NULL| | > | c_name | varchar(100) | NO | | NULL| | > | c_password | varchar(106) | NO | | NULL| | > | c_cn | varchar(100) | NO | | NULL| | > | mail | varchar(100) | NO | | NULL| | > | domain | varchar(100) | NO | | NULL| | > ++--+--+-+-+---+ > 6 rows in set (0.006 sec) > > But I think you're going the wrong way. Windows Mail and other software > clients can log in and send/receive emails just fine using these > credentials. > I am not going the wrong way actually. I wanted to be sure that the right table is in place because SOGo uses specific column names. In my setup, I created a VIEW to use with SOGo. (BTW, I'm curious about the HOWTO that you followed for your installation). Now that we know the right table columns exist, we can focus on debugging. 1. I am assuming that your dovecot-sql.conf.ext also has: default_pass_scheme = ssha512, because this is what you have specified in sogo.conf. 2. I am assuming that in sogo.conf, you have set MySQL4DebugEnabled = YES; (I mean you've removed the // from the line) and restarted sogod. 3. I am assuming that in dovecot's 10-logging.conf, you have set the following params: log_path = /var/log/dovecot-error.log # Log file to use for informational messages. Defaults to log_path. info_log_path = /var/log/dovecot-info.log # Log file to use for debug messages. Defaults to info_log_path. debug_log_path = /var/log/dovecot-debug.log auth_verbose = yes auth_verbose_passwords = yes auth_debug = yes #Shows SQL queries auth_debug_passwords = yes #Logs the passwords and the used scheme so the problem can be debugged and restarted dovecot! Now just look at the logs and you will discover why sogo is experiencing errors. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
I am expecting a table equivalent to this.
[image: sogo.jpg]
On Thu, Oct 6, 2022 at 8:50 PM Odhiambo Washington
wrote:
>
>
> On Thu, Oct 6, 2022 at 8:33 PM Serveria Support wrote:
>
>> Sure, here you go. It's very basic actually, I didn't make any heavy
>> tweaking:
>>
>
> [snip]
>
>
>
>SOGoUserSources =
> (
>{
> type = sql;
> id = users;
> viewURL =
> "mysql://mailuser:password@localhost:3306/mailserver/sogo_users";
> canAuthenticate = YES;
> isAddressBook = NO;
> userPasswordAlgorithm = ssha512;
>}
> );
> [snip]
>
> Can you please connect to the "mailserver" database and then do:
> describe table sogo_users;
>
> I am expecting something like this:
> MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see
> the output of
> describe table sogo_users;
>
> I am expecting to see column names and definitions:
> root@localhost [mailserver]> desc sogo_users;
> +---+--+--+-+-+---+
> | Field | Type | Null | Key | Default | Extra |
> +---+--+--+-+-+---+
> | sogo_id | int unsigned | NO | | 0 | |
> | c_uid | varchar(255) | NO | | | |
> | c_name| varchar(255) | YES | | NULL| |
> | c_password| varchar(256) | YES | | NULL| |
> | c_cn | varchar(255) | NO | | | |
> | mail | varchar(255) | NO | | | |
> | displayName | varchar(255) | YES | | NULL| |
> | kind | varchar(100) | YES | | NULL| |
> | multiple_bookings | int | YES | | NULL| |
> +---+--+--+-+-+---+
>
> Most importantly I'd like to see the c_uid, c_name, c_password, c_cn...
>
>
> --
> Best regards,
> Odhiambo WASHINGTON,
> Nairobi,KE
> +254 7 3200 0004/+254 7 2274 3223
> "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
On Thu, Oct 6, 2022 at 8:33 PM Serveria Support wrote:
> Sure, here you go. It's very basic actually, I didn't make any heavy
> tweaking:
>
[snip]
SOGoUserSources =
(
{
type = sql;
id = users;
viewURL =
"mysql://mailuser:password@localhost:3306/mailserver/sogo_users";
canAuthenticate = YES;
isAddressBook = NO;
userPasswordAlgorithm = ssha512;
}
);
[snip]
Can you please connect to the "mailserver" database and then do:
describe table sogo_users;
I am expecting something like this:
MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see the
output of
describe table sogo_users;
I am expecting to see column names and definitions:
root@localhost [mailserver]> desc sogo_users;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| sogo_id | int unsigned | NO | | 0 | |
| c_uid | varchar(255) | NO | | | |
| c_name| varchar(255) | YES | | NULL| |
| c_password| varchar(256) | YES | | NULL| |
| c_cn | varchar(255) | NO | | | |
| mail | varchar(255) | NO | | | |
| displayName | varchar(255) | YES | | NULL| |
| kind | varchar(100) | YES | | NULL| |
| multiple_bookings | int | YES | | NULL| |
+---+--+--+-+-+---+
Most importantly I'd like to see the c_uid, c_name, c_password, c_cn...
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
On Thu, Oct 6, 2022 at 3:12 PM Serveria Support wrote: > Hi, > > Thanks for your reply. Yes, I realized that after posting this. I made a > mistake I meant SOGo on port 80 and 443 not Dovecot obviously. > > I did enable all possible logging in Dovecot and I can see Windows Mail > clients logging in successfully. But for some reason my SOGo connection > attempts are not showing up in logs at all. SOGo log still shows the > same error message I already posted. SOGo website is giving me this > error: Wrong username or password. > Let's see your complete sogo.conf, please. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
On Wed, Oct 5, 2022 at 4:37 PM Serveria Support wrote: > Thanks, you're really helpful, I appreciate. > > After turning Dovecot debugging on (SOGO had been enabled already) I'm > seeing these in the log: > > 09:22:01 debian postfix/smtps/smtpd[267384]: SSL_accept error from > unknown[xx.xx.xx.xx]: Connection timed out > 09:22:01 debian postfix/smtps/smtpd[267384]: lost connection after > CONNECT from unknown[xx.xx.xx.xx] > 09:22:01 debian postfix/smtps/smtpd[267384]: disconnect from > unknown[xx.xx.xx.xx] commands=0/0 > > Interesting, Dovecot is configured to use http/port 80 by default, port > 443 is open but I didn't enable it as I wanted to test out with http > first. So https is necessary for SOGO to authenticate? I can see Windows > mail connecting just fine in the same log. Any thoughts? > Dovecot can only listen on the following ports by default: 110 (POP3), 143 (IMAP4), 993 (IMAPS), 995 (POP3S). It can never listen to port 80 (HTTP) or 443 (HTTPS) which are only used by a web server (Nginx, Apache, Lighttpd). The logs you are showing are from Postfix and not dovecot! Please enable debugging on dovecot and look at the dovecot logs. You need to be seeing SQL queries on the logs. Please re-read your 10-logging.conf from dovecot, enable debugging are refer to the file specified. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGO reusing Dovecot db password issue
On Thu, Sep 29, 2022 at 4:01 PM Serveria Support wrote: > Hi, > > After weeks of trying to configure iredmail package for my needs (and > failing miserably) I decided to start everything from scratch: I took a > vanilla Debian 11 server and installed Dovecot + Postfix + MariaDB + > Apache. Mailserver works like a charm - emails are getting > sent/delivered/stored perfectly. Users are able to log in/authenticate. > Then I decided to add SOGo to the config and installed it, also > configured using the basic howto from sogo website. All done, web > frontend comes up. So far so good unfortunately I'm unable to > authenticate using my Dovecot users db. Here I have to add that I didn't > create a separate table for SOGo but instead tried to reuse my Dovecot > user credentials by creating a VIEW in my DB. However, this doesn't seem > to work, here's my sogo.log: > > Sep 29 06:30:17 sogod [151286]: XXXIPADDRESSXXX "POST /SOGo/connect > HTTP/1.1" 403 34/89 0.003 - - 0 - 12 > Sep 29 06:30:25 sogod [151286]: |SOGo| starting method 'POST' on uri > '/SOGo/connect' > 2022-09-29 06:30:25.510 sogod[151286:151286] > SQL: > SELECT c_password FROM sogo_users WHERE c_uid = 'u...@mydomain.tld'; > 2022-09-29 06:30:25.510 sogod[151286:151286] >query > has results, entering fetch-mode. > Sep 29 06:30:25 sogod [151286]: SOGoRootPage Login from > 'XXXIPADDRESSXXX' for user 'u...@mydomain.xxx' might not have worked - > password policy: 65535 grace: -1 expire: -1 bound: 0 > Sep 29 06:30:25 sogod [151286]: |SOGo| request took 0.001784 seconds to > execute > > Unfortunately, I'm not too good at reading SOGo logs and the error > message seems to be not very self-explanatory. What exactly does this > mean? Unable to fetch password? Password didn't work? Wrong encryption > protocol? Any suggestions? > Look at the dovecot logging configuration and bump the debugging up and you'll get it right. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Error log
With your kind of response it's not easy to understand what you really
want. Aren't these values what you want?
1. //SOGoIMAPServer = "imaps://hostname:993";
2. //SOGoSMTPServer = "smtp://hostname";
On Sun, Oct 2, 2022 at 8:05 PM mich wrote:
> Hello
>
>
>
> The configuration is not bad, but I need to configure my accesses to set
> up my receive/send domains inside the SOGo area.
>
>
>
> sogo config file
>
>
>
> https://pastebin.com/2PNrwMxj
>
>
>
> Michel
>
>
>
> *De : * au nom de "Odhiambo Washington (
> odhia...@gmail.com)"
> *Répondre à : *
> *Date : *dimanche 2 octobre 2022 à 13:14
> *À : *
> *Objet : *Re: [SOGo] Error log
>
>
>
> Hi Mich,
>
>
>
> Here is my working sogo.conf:
>
>
>
> https://pastebin.ubuntu.com/p/WSsT5jdghM/
>
>
>
> Just make sure that you edit it accordingly. Also take a special
> consideration for userPasswordAlgorithmrPasswordAlgorithm
>
>
>
> On Sun, Oct 2, 2022 at 2:05 PM mich wrote:
>
> Hello
>
>
>
> Configuration sogo.conf
>
>
>
> SOGoUserSources =
>
> (
>
> {
>
> type = sql;
>
> id = users;
>
> viewURL = "mysql://sogo:XXX@127.0.0.1:3306/sogo/sogo_users";
>
> canAuthenticate = YES;
>
> isAddressBook = NO;
>
> userPasswordAlgorithm = md5;
>
> }
>
> );
>
>
>
>
>
> Michel
>
>
>
>
>
>
> --
>
> Best regards,
> Odhiambo WASHINGTON,
> Nairobi,KE
> +254 7 3200 0004/+254 7 2274 3223
> "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
On Mon, Oct 3, 2022 at 8:48 AM Serveria Support wrote:
> Hi,
>
> Sorry to hijack this thread, but I'm having exactly same issue. Here's
> my conf file user sources part:
>
> SOGoUserSources =
> (
>{
> type = sql;
> id = users;
> viewURL =
> "mysql://mailuser:password@localhost:3306/mailserver/sogo_users";
> canAuthenticate = YES;
> isAddressBook = NO;
> userPasswordAlgorithm = ssha512;
>}
> );
>
> I'm getting the same error TS has mentioned. Unfortunately, log file
> doesn't seem to be particularly user friendly so we can only guess?
>
>
> On 2022-09-30 21:44, Pierre wrote:
> > Hi,
> > Could have to do with encrytion used.
> > I got my setup working with the following (where "tablename" is
> > actually a view generated from the postfixadmin user table):
> >
> > SOGoUserSources =
> > (
> > {
> > type = sql; id =
> > directory;
> > viewURL mysql://user:pass@127.0.0.1:3306/dbname/tablename
> > [1]";
> > userPasswordAlgorithm = md5-crypt;
> > canAuthenticate = YES;
> > isAddressBook = YES; }
> > );
> > SOGoSMTPAuthenticationType = PLAIN;
> >
> > On Fri, Sep 30, 2022, 12:21 PM "WilliamB" wrote:
> >
> >> Hi I run an Ubuntu 20.04 with postfix/dovecot and postfix admin
> >> I am trying to get SOGo working but it will not authenticate
> >>
> >> might not have worked - password policy: 65535 grace: -1 expire:
> >> -1 bound:
> >> 0
> >>
> >> Any clues please
>
I use SOGo on FreeBSD and Ubuntu and it all works fine.
For those of you using dovecot, it should be easy to debug the
authentication queries on the dovecot end than on the SOGo end.
In conf.d/10logging.conf:
auth_verbose = yes
auth_verbose_passwords = yes
auth_debug = yes #Shows SQL queries
auth_debug_passwords = yes #Logs the passwords and the used scheme so the
problem can be debugged
On the SOGo side, you can also enable any of these in sogo.conf:
/* Debug */
//SOGoDebugRequests = YES;
//SoDebugBaseURL = YES;
//ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
//SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
//WOLogFile = /var/log/sogo/sogo.log;
//GCSFolderDebugEnabled = NO;
//GCSFolderStoreDebugEnabled = NO;
//NGImap4DisableIMAP4Pooling = NO;
//OCSFolderManagerSQLDebugEnabled = NO;
//PGDebugEnabled = MO;
//SOGoMailKeepDraftsAfterSend = NO;
// SoDebugObjectTraversal = YES;
//SoSecurityManagerDebugEnabled = NO;
//WODebugZipResponse = NO;
I do not prefer Postfix, but I have been able to successfully use it with
my DB structure.
What you guys need to check for is your encryption scheme.
I have this in sogo.conf:
userPasswordAlgorithm = md5-crypt;
And it dovecot.conf I have:
default_pass_scheme = MD5-CRYPT
Ensure that your passwords are of the md5-crypt type: *$1$0*
Gizh6Qw$UNkB.rmlDOVhA6GuJnfRT1
It should not be difficult just playing with the two values from the two
conf files.
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Error log
Hi Mich,
Here is my working sogo.conf:
https://pastebin.ubuntu.com/p/WSsT5jdghM/
Just make sure that you edit it accordingly. Also take a special
consideration for userPasswordAlgorithmrPasswordAlgorithm
On Sun, Oct 2, 2022 at 2:05 PM mich wrote:
> Hello
>
>
>
> Configuration sogo.conf
>
>
>
> SOGoUserSources =
>
> (
>
> {
>
> type = sql;
>
> id = users;
>
> viewURL = "mysql://sogo:XXX@127.0.0.1:3306/sogo/sogo_users";
>
> canAuthenticate = YES;
>
> isAddressBook = NO;
>
> userPasswordAlgorithm = md5;
>
> }
>
> );
>
>
>
>
>
> Michel
>
>
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Error log
Hi Mich, You could use https://pastebin.ubuntu.com/ to paste the error and share the URL of the paste. On Sun, Oct 2, 2022 at 12:03 AM mich wrote: > Hello > > > > I don't know what's going on, but I'm trying to send a message with an > error log is impossible to send and I don't know how to do it, from outlook > mac os. > > > > Michel > > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Set Animation Level and other things on sogo.conf -file
On Thu, Sep 1, 2022 at 3:22 PM francis wrote: > Hi > > > On Sep 1, 2022, at 04:46, Christian Mack (christian.m...@uni-konstanz.de) > wrote: > > > > Hello > > > > Am 01.09.22 um 10:31 schrieb Odhiambo Washington (odhia...@gmail.com): > >> On Wed, Aug 31, 2022 at 7:46 PM Christian Mack wrote: > >>> Hello > >>> > >>> Am 31.08.22 um 14:06 schrieb International Security Providers > >>> (internationalsecurityprovid...@proton.me): > >>>> I would love to set the "Animation level globally for all users to > >>>> “None”. is this somehow possible? > >>> > >>> Sure you can :-) > >>> > >>> /etc/sogo/sogo.conf: > >>> [...] > >>> SOGoAnimationMode = none; > >>> [...] > >>> > >>>> also enabling “Enable Desktop > >>>> Notifications” and “When sending mail, add unknown recipients to my” > >>>> -> “Personal Address Book” > >>> > >>> [...] > >>> SOGoDesktopNotifications = <*I1>; > >>> [...] > >>> SOGoMailAddOutgoingAddresses = <*I1>; > >>> SOGoSelectedAddressBook = "personal"; > >>> [cut] > >>> > >>> > >> Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, > I did > >> not find these SOGoAnimationMode and SOGoDesktopNotifications. > >> Is there other documentation elsewhere? :) > > > > No, there is no other documentation. > > I got the settings from an user backup. > > All "User Preferences" can be preset in sogo.conf. > > They will be fetched and used when creating a new account in SOGo, when > the user first logs in. > > > > But you are right, they should be documented in the "SOGo Installation > and Configuration Guide". > > Will open a bug report for it later. > > You can also refer to SOGoDefaults.plist for some of the default values > that you can overwrite in sogo.conf: > > > https://github.com/Alinto/sogo/blob/master/SoObjects/SOGo/SOGoDefaults.plist > > > Francis Looking at that does not tell me what other options exist for a config param. For example, SOGoAnimationMode = "normal"; What are the other options for this parameter? Complete documentation is necessary. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Set Animation Level and other things on sogo.conf -file
On Wed, Aug 31, 2022 at 7:46 PM Christian Mack wrote: > Hello > > Am 31.08.22 um 14:06 schrieb International Security Providers > (internationalsecurityprovid...@proton.me): > > I would love to set the "Animation level globally for all users to > > “None”. is this somehow possible? > > Sure you can :-) > > /etc/sogo/sogo.conf: > [...] > SOGoAnimationMode = none; > [...] > > > also enabling “Enable Desktop > > Notifications” and “When sending mail, add unknown recipients to my” > > -> “Personal Address Book” > > [...] > SOGoDesktopNotifications = <*I1>; > [...] > SOGoMailAddOutgoingAddresses = <*I1>; > SOGoSelectedAddressBook = "personal"; > [cut] > > > Kind regards, > Christian Mack > > Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, I did not find these SOGoAnimationMode and SOGoDesktopNotifications. Is there other documentation elsewhere? :) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] like MailTip feature
No. Please stick to Ootlook! "-) On a serious note though, how do you suppose MS Outlook gets such information about a recipient of an e-mail? I don't use Outlook much, but I have never seen such Tips. Outlook has no way of knowing the mailbox status of a recipient. Neither does it have a way of knowing if a recipient has configured an OOR - unless the sender and the recipient are in the same server/mail domain. On Sun, Aug 28, 2022 at 11:14 AM Darren Lauser wrote: > Hello, > > After looking through your features and user mail archive, maybe I missed > it. Microsoft Outlook has a feature called a MailTip. When the user is > composing the email message, the MailTip will provide notification if a > recipient has configured auto-reply, or if their mailbox is full. It even > shows the content of the auto-reply message. This has been quite helpful. > Is this a current or planned feature for SOGo? Thanks! > > Regards, > Darren > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] R: Folder TemplatesFolderName
Looks like it exists only if the Italian language is selected, no? I don't see it on my server. [image: sogo.png] On Mon, Apr 11, 2022 at 4:10 PM "Stefano Vassena - AB Z Soluzioni Informatiche s.r.l." wrote: > That’s what I mean > > > > > > * Stefano Vassena* > > > *AB Z Soluzioni Informatiche s.r.l.* > 23868 Valmadrera - LC > Viale Promessi Sposi, 76 > Tel. +39 0341.200665 > Fax +39 0341.200669 > > <https://www.facebook.com/ABZSol/> > <https://www.linkedin.com/company/2521254> > > > > *Email: *s.vass...@abzsol.com > *Web site*: www.abzsol.com > > > > > > *Da:* users-requ...@sogo.nu *Per conto di *"Odhiambo > Washington" (odhia...@gmail.com) > *Inviato:* lunedì 11 aprile 2022 14:40 > *A:* users@sogo.nu > *Oggetto:* Re: [SOGo] Folder TemplatesFolderName > > > > > > > > On Mon, Apr 11, 2022 at 3:16 PM "Stefano Vassena - AB Z Soluzioni > Informatiche s.r.l." wrote: > > Hello, > > > > I’ve installed SOGo 5.5.1 and I’ve seen that there is a folder named > TemplatesFolderName > Is it possible to hide it? Or translate it? > > Thanks in advance. > > > > *Stefano Vassena* > > > *AB Z Soluzioni Informatiche s.r.l.* > 23868 Valmadrera - LC > Viale Promessi Sposi, 76 > Tel. +39 0341.200665 > Fax +39 0341.200669 > > <https://www.facebook.com/ABZSol/> > <https://www.linkedin.com/company/2521254> > > > > *Email: *s.vass...@abzsol.com > *Web site*: www.abzsol.com > > > > > > Hi, > > > > Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, I > do not see any reference to that. Where did you see it? > > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' :-) > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Folder TemplatesFolderName
On Mon, Apr 11, 2022 at 3:16 PM "Stefano Vassena - AB Z Soluzioni Informatiche s.r.l." wrote: > Hello, > > > > I’ve installed SOGo 5.5.1 and I’ve seen that there is a folder named > TemplatesFolderName > Is it possible to hide it? Or translate it? > > Thanks in advance. > > > > * Stefano Vassena* > > > *AB Z Soluzioni Informatiche s.r.l.* > 23868 Valmadrera - LC > Viale Promessi Sposi, 76 > Tel. +39 0341.200665 > Fax +39 0341.200669 > > <https://www.facebook.com/ABZSol/> > <https://www.linkedin.com/company/2521254> > > > > *Email: *s.vass...@abzsol.com > *Web site*: www.abzsol.com > > > Hi, Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, I do not see any reference to that. Where did you see it? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Migration from sogo 4.3.x to 5.x
On Wed, Apr 6, 2022 at 2:40 PM Albert Shih wrote: > Hi everyone > > Just like to know if it's safe to upgrade from Debian 9 + sogo 4 to Debian > 11 + sogo 5 without problem ? > > Do I need to do some upgrade in the database schema ? > > That's mean of course migrating from pgsql 9.6 to 13. > There were no database changes between 4.x and 5.x. https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Migration to Mailcow, any experiences/tutorials/hints?
On Thu, Feb 10, 2022 at 3:47 PM Kai-Uwe Rommel - ARS wrote: > Hello, > > > > I’m currently running an old server on CentOS 6 with postfix/dovecot and > SOGo 2.4 and MySQL DB as authentication source for the users. > > I need to do a complete overhaul to current software levels, obviously. > After thinking over this for a while and looking around I found that it > seems > > to make the most sense for me to move to a new Ubuntu VM and run a local > Mailcow dockerized deployment. > > That seems to offer about the same moving parts (postfix, dovecot, SOGo, > MariaDB), in a more integrated and easily upgradable way. > > Did anyone do such a migration from a conventional manual setup into a > Mailcow setup, e.g. including user/data migration > > and could share the experience, hints, warnings etc.? Thanks. > > In particular, I’d like to know how to > >- move the user name/password table(s) >- move the mail data of dovecot >- move the calendar/contact data of SOGo > > I haven’t yet seen a tutorial or similar for such a migration. > > > > Kai-Uwe Rommel > Your question would be better answered in the Mailcow forums. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Exception error with cron after upgrade
Hi Daniel, I already have this: SOGoTimeZone = Africa/Nairobi; The error is about "Uncaught > exception NSInvalidArgumentException, *reason: > GCSChannelManager(instance) does not recognize releaseAllChannels"* On Mon, Aug 30, 2021 at 3:40 PM Daniel LE BRAY wrote: > Hello, > you might need to set the *SOGoTimeZone* parameter in your sogo.conf > > Le 30/08/2021 à 09:01, Odhiambo Washington (odhia...@gmail.com) a écrit : > > Hi, > > > > Platform = FreeBSD 13 amd64 > > > > After upgrade from 5.1.1 to 5.2.0, a cron entry is giving me an error > > message: > > > > root@gw:/usr/local/lib/compat/pkg # su -m sogod -c > > /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify > > 2021-08-30 07:01:34.568 sogo-ealarms-notify[87284:100589] No local time > > zone specified. > > 2021-08-30 07:01:34.568 sogo-ealarms-notify[87284:100589] Using time > > zone with absolute offset 0. > > Throwing 0x803c26898, in flight exception: 0 > > Exception caught by C++: 0 > > /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify: Uncaught > > exception NSInvalidArgumentException, reason: > > GCSChannelManager(instance) does not recognize releaseAllChannels > > > > Anyone knows what I need to do to fix this? > > > > > > -- > > Best regards, > > Odhiambo WASHINGTON, > > Nairobi,KE > > +254 7 3200 0004/+254 7 2274 3223 > > "Oh, the cruft.", egrep -v '^$|^.*#' :-) > > -- > > users@sogo.nu > > https://inverse.ca/sogo/lists > > -- > Daniel Le Bray :: CRI :: Pôle Systèmes et Réseaux > daniel.le-b...@univ-lehavre.fr :: +33 (0)2 32 74 42 94 > Universite Le Havre Normandie > 25 rue Philippe Lebon, BP1123, 76063 Le Havre Cedex, France > == > J'accepte les emails VSRE (http://vsre.info/index_fr.html) > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Exception error with cron after upgrade
Hi, Platform = FreeBSD 13 amd64 After upgrade from 5.1.1 to 5.2.0, a cron entry is giving me an error message: root@gw:/usr/local/lib/compat/pkg # su -m sogod -c /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2021-08-30 07:01:34.568 sogo-ealarms-notify[87284:100589] No local time zone specified. 2021-08-30 07:01:34.568 sogo-ealarms-notify[87284:100589] Using time zone with absolute offset 0. Throwing 0x803c26898, in flight exception: 0 Exception caught by C++: 0 /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify: Uncaught exception NSInvalidArgumentException, reason: GCSChannelManager(instance) does not recognize releaseAllChannels Anyone knows what I need to do to fix this? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo segfault
If there's a core file, then you can run a debug against it and give more details. On Mon, Aug 9, 2021, 15:08 "frm" wrote: > Hi, > > If I bring my server down (Debian buster) with sogo 5.1.1.20210809-1 I get > the following: > [ 94.788600] sogod[1134]: segfault at 7ffde6dafa93 ip 7fce69c19820 sp > 7ffd66daf9a8 error 4 > [ 94.788603] sogod[1139]: segfault at 7ffde6dafa93 ip 7fce69c19820 sp > 7ffd66daf9a8 error 4 > [ 94.788607] in libc-2.28.so[7fce69adf000+148000] > > Any ideas? > > Best, > > -- Jaap > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authenticating using SAML2
On Thu, Apr 29, 2021 at 2:47 PM Alexander Podolyan wrote: > I'm trying to set up SOGo with SAML2 authentication, but I don't know how > to generate SSL keys. > > In /etc/sogo/sogo.conf I have to specify the following variables: > > //SAML2 > SOGoAuthenticationType = saml2; > SOGoSAML2PrivateKeyLocation = /certs/saml_sogo.key; > SOGoSAML2CertificateLocation = /certs/saml_sogo.pem; > SOGoSAML2IdpMetadataLocation = /etc/sogo/keycloak.xml; > SOGoSAML2IdpPublicKeyLocation = /certs/saml_sso.pub; > SOGoSAML2IdpCertificateLocation = /certs/saml_sso.pem; > SOGoSAML2LogoutEnabled = YES; > SOGoSAML2LogoutURL = https://domain.com; > > How to create saml_sogo.key, saml_sogo.pem, keycloak.xml, saml_sso.pub, > saml_sso.pem? > Download and look at the scripts in this file: https://bit.ly/3aVBRpO >From 'Re: [SOGo] SAML2 authentication requirements' - MARC <https://marc.info/?l=sogo-users=147697076318929=2>, I can see that you can use: openssl req -newkey rsa:2048 -new -x509 -days 3652 -nodes -out saml_sogo.crt -keyout saml_sogo.pem For the .pem files, here is some good reading: ssl - How to get .pem file from .key and .crt files? - Stack Overflow <https://stackoverflow.com/questions/991758/how-to-get-pem-file-from-key-and-crt-files> Coupled with the instructions from Re: [SOGo] Sogo - Lemonldap - Saml (mail-archive.com <https://www.mail-archive.com/users@sogo.nu/msg29860.html>, I believe you'll hack it. PS: I don't even know what SAML is :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo grokking
On Mon, Apr 26, 2021 at 2:22 PM Sven Schwedas wrote: > On 23.04.21 20:56, Odhiambo Washington (odhia...@gmail.com) wrote: > > A brand new server, SOGO-5.0.1 groks badly: > > > > https://pastebin.ubuntu.com/p/xrYQkZrp4d/ > > <https://pastebin.ubuntu.com/p/xrYQkZrp4d/> > > > > Might someone be able to figure out what is going on? > > > The error message is too vague, follow these steps to set up gdb and > generate a backtrace for the NSInvalidArgumentException error you'll > apparently get instantly on starting: > > https://www.sogo.nu/support/faq/how-do-i-debug-sogo.html Hi Sven, Thanks for looking into this. So apparently, because the server is FreeBSD, maybe things are supposed to be done differently??? sogod@233.102 ~ $ gdb --args /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid GNU gdb (GDB) 10.1 [GDB v10.1 for FreeBSD] Copyright (C) 2020 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html > This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-portbld-freebsd13.0". Type "show configuration" for configuration details. For bug reporting instructions, please see: <https://www.gnu.org/software/gdb/bugs/>. Find the GDB manual and other documentation resources online at: <http://www.gnu.org/software/gdb/documentation/>. For help, type "help". Type "apropos word" to search for commands related to "word"... Reading symbols from /usr/local/GNUstep/Local/Tools/Admin/sogod... (gdb) r Starting program: /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid Apr 26 16:02:51 sogod [26127]: version 5.0.1 (build r...@mail.cnet.co.za 202104261500) -- starting Apr 26 16:02:51 sogod [26127]: vmem size check enabled: shutting down app when vmem > 1024 MB. Currently at 0 MB Apr 26 16:02:51 sogod [26127]: <0x0x8047c6bc8[SOGoProductLoader]> SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Apr 26 16:02:51 sogod [26127]: <0x0x8047c6bc8[SOGoProductLoader]> Appointments.SOGo, Mailer.SOGo, ActiveSync.SOGo, AdministrationUI.SOGo, CommonUI.SOGo, Contacts.SOGo, ContactsUI.SOGo, MailPartViewers.SOGo, MailerUI.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo Apr 26 16:02:51 sogod [26127]: All products loaded - current memory usage at 0 MB Throwing 0x80497a708, in flight exception: 0 Exception caught by C++: 0 /usr/local/GNUstep/Local/Tools/Admin/sogod: Uncaught exception NSInvalidArgumentException, reason: Can not determine type information for -[GSTinyString count] [Inferior 1 (process 26127) exited with code 01] (gdb) b [NSException raise] Breakpoint 1 at 0x801bbbae4 (gdb) b abort Breakpoint 2 at 0x801cc4ec4 (2 locations) (gdb) c The program is not being run. (gdb) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo grokking
A brand new server, SOGO-5.0.1 groks badly: https://pastebin.ubuntu.com/p/xrYQkZrp4d/ Might someone be able to figure out what is going on? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo-5.0.1 on FreeBSD 13-RELEASE
On Mon, Apr 19, 2021 at 6:43 PM Gordon Messmer wrote: > On 4/19/21 4:54 AM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > cd /usr/ports/www/sogo && make deinstall > > cd /usr/ports/devel/sope && make deinstall > > > > Then I reinstalled sogo and obviously, it requires sope to all got > > installed. Version 5.0.1 > > > My FreeBSD is a little rusty. Does "make deinstall" run "make clean" in > the source directory? If not, you may have simply reinstalled your old > binaries. > > After the make deinstall, I installed using 'pkg install sogo-activesync-5.0.1_1' which uses a binary package. Same result! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo-5.0.1 on FreeBSD 13-RELEASE
Hi, On Mon, Apr 19, 2021 at 2:44 PM Lars Liedtke wrote: > Hey, > > how did you upgrade your system, with `freebsd-update`? > > Did you do pkg `update && pkg upgrade` afterwards? > > Do you use the ports system or prebuuild binary packages? > > Cheers > > Lars > Hi Lars, I used freebsd-update to upgrade. I also did the following: # pkg-static install -f pkg # pkg bootstrap -f # pkg update # pkg upgrade On my system, there are some cases where I use the pre-built binaries while on others I use the ports. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo-5.0.1 on FreeBSD 13-RELEASE
On Mon, Apr 19, 2021 at 2:43 PM Gordon Messmer wrote: > On 4/18/21 1:56 AM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > After upgrading my OS from 12-RELEASE to 13-RELEASE, sogod wouldn't > > start now, even after uninstalling SOGo, SOPE, libgnustep. > > > Can you be more specific about how you uninstalled them, and what you > did afterward? > cd /usr/ports/www/sogo && make deinstall cd /usr/ports/devel/sope && make deinstall Then I reinstalled sogo and obviously, it requires sope to all got installed. Version 5.0.1 > > Have you built each of those from source on 13-RELEASE? > No. I have used the ports tree. I also I tried pkg install -f sogo-activesync-5.0.1_1. Same result. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo-5.0.1 on FreeBSD 13-RELEASE
After upgrading my OS from 12-RELEASE to 13-RELEASE, sogod wouldn't start now, even after uninstalling SOGo, SOPE, libgnustep. I get this error: root@gw:/usr/local/SRC # /usr/local/etc/rc.d/sogod start Starting sogod. ld-elf.so.1: /usr/local/GNUstep/Local/Tools/Admin/sogod: Undefined symbol "._OBJC_REF_CLASS_GCSChannelManager" /usr/local/etc/rc.d/sogod: WARNING: failed to start sogod Might anyone know how I can fix this? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] change password won't update mailserver database
PS: I am not so used to top-posting on MLs. My question is - what is the problem with using the same DB? SOGo uses it'd own tables, which you can drop at will. After all, it's the same DB server! You will not _easily_ achieve what you want with two separate databases. Note *easily*. And I can assure you there isn't already a solution in the public domain. If you create the VIEW as I shared before, your problem is solved and you are home and dry. In fact even this discussion would have ended :-) On Fri, Apr 2, 2021 at 11:11 PM DEPRÉ Gaëtan - NGServers . com < users@sogo.nu> wrote: > >> If my understanding is correct, You are using multiple (probably two) > user databases? Different for SOGo and different for IMAP server (probably > Dovecot/Courrier)? > > > > You’re right. I didn’t want to use my mailserver database, because of > populating of SOGo (it creates 3 tables per user especially terminating > with ‘_acl’ & ‘_quick’ & I wanted to keep my mailserver database clean). > > > > The two databases used are ‘mailserver’ & ‘sogo’. > > > > I realize with your answers that we have no other choice than using the > same DB. Creating custom script that would be executed while doing an > action could help > > > > Another idea would be to create a new directive, telling which is the > mailserver users Db/password field and allowing SOGo to act in it while > changing password, for example. > > > > > > > > *De :* users-requ...@sogo.nu *De la part de* > Patrik Chadima > *Envoyé :* vendredi 2 avril 2021 16:51 > *À :* SOGo reporter (flachape...@inverse.ca) > *Objet :* Re: [SOGo] change password won't update mailserver database > > > > Hi, > > > > On Fri, Apr 2, 2021 at 4:37 AM DEPRÉ Gaëtan - NGServers . com < > users@sogo.nu> wrote: > > Hi ! > > > > When a user changes his password via SOGo, SOGo doesn’t update the > mailserver database to make the both passwords equal ,and the user can > login but no mailbox will be displayed because of incorrect login on the > mail server. > > > > Is there any way to implement a custom script while changing password on > SOGo, allowing to update another database ? > > > > Regards, > > > > Gaetan > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > > > > If my understanding is correct, You are using multiple (probably two) user > databases? Different for SOGo and different for IMAP server (probably > Dovecot/Courrier)? > > If I'm right I can say that it is a good practice to use only one user > identity source for both systems. > > But we don't have enough information about Your background so there is no > correct answer to Your question. > > > > Best regards > > Patrik Chadima > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] change password won't update mailserver database
Oops! I just remembered. SOGo needs to use the same database as your POP3/IMAP4 engine. I have been using Dovecot for that purpose. If you are using MySQL you need to create a VIEW for SOGo to use. Here is what I did in my DB (and it is documented somewhere online): CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, username AS mail, realname AS displayName FROM users WHERE enabled='1'; (of course customize this according to your DB schema) Then in your authenticators set: viewURL ="mysql://DBUSER:PASSWORD@127.0.0.1:3306/DBNAME/*sogo_auth_view*"; HTH On Fri, Apr 2, 2021 at 5:31 PM DEPRÉ Gaëtan - NGServers . com wrote: > Hi ! > > > > My algorithms are well configured. I can login if I copy/paste hashed > password from the mailserver database to SOGo’s one. > > > > Sogo updates his database while changing password, but not mailserver’s > (dovecot/postfix) one. I would like to know where to implement such an > update script or add mysql UPDATE in the changing password action. > > > > Furthermore, if a user updates his password in SOGo, he can login again to > SOGo, but the mailserver will answer ‘bad login’ because of his password > not updated. > > > > *De :* users-requ...@sogo.nu *De la part de* > Odhiambo Washington > *Envoyé :* vendredi 2 avril 2021 12:25 > *À :* users@sogo.nu > *Objet :* Re: [SOGo] change password won't update mailserver database > > > > > > > > On Fri, Apr 2, 2021 at 5:37 AM DEPRÉ Gaëtan - NGServers . com < > users@sogo.nu> wrote: > > Hi ! > > > > When a user changes his password via SOGo, SOGo doesn’t update the > mailserver database to make the both passwords equal ,and the user can > login but no mailbox will be displayed because of incorrect login on the > mail server. > > > > Is there any way to implement a custom script while changing password on > SOGo, allowing to update another database ? > > > > I have SOGo update a MySQL database when users change passwords. > > I believe you should look at whether your setting > for userPasswordAlgorithm matches what is expected by your POP3/IMAP4 > engine. > > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] change password won't update mailserver database
On Fri, Apr 2, 2021 at 5:37 AM DEPRÉ Gaëtan - NGServers . com wrote: > Hi ! > > > > When a user changes his password via SOGo, SOGo doesn’t update the > mailserver database to make the both passwords equal ,and the user can > login but no mailbox will be displayed because of incorrect login on the > mail server. > > > > Is there any way to implement a custom script while changing password on > SOGo, allowing to update another database ? > I have SOGo update a MySQL database when users change passwords. I believe you should look at whether your setting for userPasswordAlgorithm matches what is expected by your POP3/IMAP4 engine. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Akamai Technologies, Inc. Acquires Inverse
On Mon, 1 Feb 2021 at 16:10, Ludovic Marcotte wrote: > Dear Valued Community Member, > > We have exciting news to share with you. Today, *Akamai Technologies > <https://www.akamai.com/>* of Cambridge, Massachusetts announced its > acquisition of Inverse. Akamai is a global content delivery network, > cybersecurity and cloud service company, providing web and internet > security services. > > The Inverse team is looking forward to becoming part of Akamai’s > Enterprise security group. We plan to continue to support Inverse’s current > offerings and open source community as we unite the businesses. > > Learn more about this news by viewing the *press release > <https://www.akamai.com/us/en/about/news/press/2021-press/akamai-acquires-inverse-adds-to-zero-trust-security-platform.jsp>* > and <https://ac.akamai.com/community/teams/corp-dev/janrain-acquisition>*blog > post > <https://blogs.akamai.com/2021/02/akamai-fingerbank-how-an-open-source-community-can-transform-security.html>* > that > went out moments ago. Thank you again for your ongoing support and loyalty > as a community member. We look forward to continuing to improve our open > source software solutions. > > Regards, > > Congratulations, Ludo. May Inverse get all the best in the future. I hope Akamai behaves differently than Goohgle though :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with SAML2 and ADFS
If you mentioned that the problem happens with SOGo v5.x, perhaps the developers will listen. If you refer to a v4 bug, and v4 is already discontinued, I do not see them even considering your issue. Just a thought. On Mon, 18 Jan 2021 at 14:39, Roger Garcia Ferre wrote: > We found someone who also reported this as a bug: > https://sogo.nu/bugs/view.php?id=5153 > > Our situation is identical to him. > El 14/1/21 a les 18:21, Roger Garcia Ferre (rgar...@datalab.es) ha escrit: > > Hello everybody, > > We are trying to configure SAML2 authentication with SOGo. We have tried > everything we had in mind but without success. > > In this message we attach a text file with all the configurations and logs > we got and we also attach all steps done in order to get the result. > > We will appreciate very much any help. > -- > > *Roger Garcia* > > 934 76 69 10 > 618 24 67 33 > > <http://www.datalab.es/> > > Aviso Legal <http://www.datalab.es/cont_cas/legal.html> > -- > users@sogo.nu > https://inverse.ca/sogo/lists > > -- > > *Roger Garcia* > > 934 76 69 10 > 618 24 67 33 > > <http://www.datalab.es/> > > Aviso Legal <http://www.datalab.es/cont_cas/legal.html> > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Need help with external SMTP-server
On Wed, 13 Jan 2021 at 18:17, "Marina D." wrote: > Hello, > > for a few days now I have been fiddling around with a SOGo-Server > (selfhosted nightly-build, version 5, updated daily at the moment) and so > far I managed to get almost everything up and running. > But there is one big issue I'd be very glad if anyone could give me a hint > what is wrong here. > > The problem in short: I cannot send Mails to external recipients. > > This is the basic setup: > > The Mailserver with Dovecot and Postfix is on Server A, running for > several years now and I don't want to change the way things are on here too > much. This server has several the domains on it, among them abcd.tld and > the Server-FQDN is fqn.abc.tld > > The new server B on which SOGo has been installed is a fresh VServer using > Debian 10, LetsEncrypt-Certificate for accessing the webfrontend and it > uses the nightly-builds. I followed the official installation guide and set > up a SOGo-Instance using Postgresql 11 for users authentification. The view > within my database with the names, passwords matching the mail-passwords > and so on exists and I can login successfully. I can see the Folders, read > mails, create appointments and so on. > This Server B on which SOGo is installed has received its own subdomain so > it's reachable at sogo.abcd.tld. > > Long description of the problem: > My problem is that I cannot send mails to addresses outside of my own > domain-range. Meaning: I can send Emails with SOGos Webfrontend to any > email-address @abcd.tld or any other domain hosted on the server "A". > On this server A with postfix and dovecot there are several vhost-domains, > for example domain1.tld. As it resides on the same server as abc.tld I am > able to send a mail from address us...@abcd.tld to us...@domain1.tld when > using SOGo's webfrontend. But using the Webfrontend I cannot send an email > to external services like user.n...@gmail.com or anything like that. > Using a classic Mail-App like thunderbird on my desktop pc which connects > to the emailserver on fqn.abc.tld directly works perfect and there are no > restrictions to send emails in any kind like mentioned above. > > > When I try to send mails from SOGo's Webfrontend I get these possible > errors depending on the config in /etc/sogo/sogo.conf: > > *First case: * > more or less vanilla config setting as few ports as possible: > > /etc/sogo/sogo.conf: > > /* Mail */ > SOGoDraftsFolderName = INBOX.Drafts; > SOGoSentFolderName = INBOX.Sent; > SOGoTrashFolderName = INBOX.Trash; > SOGoJunkFolderName = INBOX.Spam; > SOGoIMAPServer = "imap://abc.tld"; > SOGoSieveServer = "sieve://abc.tld:4190"; > SOGoSMTPServer = "smtp://abc.tld"; > SOGoSMTPServer = 127.0.0.1; or SOGoSMTPServer = smtp://domain*:port * *[*Installation and Configuration Guide (sogo.nu) <https://sogo.nu/files/docs/SOGoInstallationGuide.html>] SOGoSMTPServer: The DNS name or IP address of the SMTP server used when SOGoMailingMechanism is set to smtp. Supported formats are: *smtp://domain:port*, *smtps://domain, domain:port*, *smtp://domain:port/?tls=YES*. Using the option tls=YES will enforce using STARTTLS SMTP connections. Thus, smtp://localhost:587/?tls=YES would use the default MUA port on localhost with STARTTLS enforced. To disable TLS verification for localhost domains, add tlsVerifyMode=allowInsecureLocalhost to such connections: smtp://localhost:587/?tls=YES=allowInsecureLocalhost. And all that is required is that a connection can be made to N.N.N.N and it allows the IP address of the SOGo server to send mail through it. So, once you append the port to the value, and restart sogod, share the logs of the SMTP server and not SOGo :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] App password setup for MFA
That restriction is inside your MTAs configuration! I know how to handle that with Exim as the MTA. Not quite with Postfix. On Tue, 22 Dec 2020 at 13:25, KM Dev wrote: > Ran a few more tests and you are right, mfa is not affecting smtp. However > the smtp sender has to match the host email. > > Like for plex notification I cant use plexupd...@domain.tld when my email > is k...@domain.tld > > V/R > > Raid Snake > > On Dec 18, 2020, 5:49 AM -0700, Odhiambo Washington , > wrote: > > The 2FA, IMHO, is a SOGo weUI thing, tracked only by the sogod. I did not > ever think it extends to SMTP. > I'd love to see the sogo.log extract where this 2FA requirement arises. > > On Fri, 18 Dec 2020 at 01:35, "Kevin" wrote: > >> The ability to enable two factor auth is great, the only issue I have run >> into is using smtp relay capabilities with 2 factor on requires an app >> password. I am curious is app passwords are in the works or if there is >> something I missed in settings to gen those. >> >> >> >> Thanks in advance, love the interface and ActiveSync capabilities from a >> client perspective. >> >> >> >> V/R >> >> >> >> Kevin >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > -- > users@sogo.nu > https://inverse.ca/sogo/lists > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] App password setup for MFA
The 2FA, IMHO, is a SOGo weUI thing, tracked only by the sogod. I did not ever think it extends to SMTP. I'd love to see the sogo.log extract where this 2FA requirement arises. On Fri, 18 Dec 2020 at 01:35, "Kevin" wrote: > The ability to enable two factor auth is great, the only issue I have run > into is using smtp relay capabilities with 2 factor on requires an app > password. I am curious is app passwords are in the works or if there is > something I missed in settings to gen those. > > > > Thanks in advance, love the interface and ActiveSync capabilities from a > client perspective. > > > > V/R > > > > Kevin > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] logon via both user ID and email address?
What would happen if you had multiple domains?
On Tue, 8 Dec 2020 at 00:20, Kai-Uwe Rommel wrote:
> Hmm, you are right. This is actually (also) the authentication source for
> the underlying IMAP
>
> server (Dovecot). And Dovecot also only allowes the short ID.
>
>
>
> Following this logic, I extended the password query for Dovecot’s database
> connection and
>
> I am now able to login to Dovecot using either variant.
>
>
>
> But for SOGo itself this apparently needs more changes, as it still does
> not work with the e-mail
>
> address.
>
>
> Kai-Uwe Rommel
>
> kai-uwe.rom...@ars.de
> Telefon+Mobil: +49 89 32468-120
>
>
> *From:* users-requ...@sogo.nu *On Behalf Of *Odhiambo
> Washington
> *Sent:* Monday, December 7, 2020 5:51 PM
> *To:* users@sogo.nu
> *Subject:* Re: [SOGo] logon via both user ID and email address?
>
>
>
> What does your IMAP server expect between firstname.lastname and
> firstname.lastn...@domain.tld ?
>
> It's the only one to be honored - what your IMAP server expects!.
>
>
>
>
>
>
>
> On Mon, 7 Dec 2020 at 16:02, Kai-Uwe Rommel wrote:
>
> Hello,
>
>
>
> I still run a SOGo 2.3 instance … it is using a MySQL database as
> authentication source:
>
>
>
> SOGoAuthenticationMethod = SQL;
>
> SOGoUserSources = (
>
> {
>
> canAuthenticate = YES;
>
> id = directory;
>
> isAddressBook = YES;
>
> type = sql;
>
> userPasswordAlgorithm = md5;
>
> viewURL = "mysql://
> xxx:xx@127.0.0.1:3306/mail/sogo_auth";
>
> }
>
> );
>
>
>
> Users currently log in with their user ID which is firstname.lastname but
> I often see that some
>
> try with their e-mail address first (which is
> firstname.lastn...@domain.tld). How can I configure
>
> this (if possible) so that both login names are allowed? I did not find
> something so far.
>
> Perhaps I just overlooked something? I’m not a SOGo expert.
>
>
>
> (I could perhaps modify the sogo_auth view to show each user record twice,
> once without
>
> and once with the @domain.tld suffix?)
>
>
>
> Kai-Uwe Rommel
>
> <https://web.ars.de/>
> --
> *ARS Computer und Consulting GmbH*, www.ars.de
> ein Unternehmen der TIMETOACT Group
> Garmischer Straße 7, 80339 München, Deutschland
>
> ARS - The Art of Software Engineering
> Software Engineering, Technologieberatung, IBM Software, IBM
> Lizenzmanagement Services
>
> Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
> Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
> Datenschutzerklärung: https://web.ars.de/datenschutz/
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] logon via both user ID and email address?
What does your IMAP server expect between firstname.lastname and
firstname.lastn...@domain.tld ?
It's the only one to be honored - what your IMAP server expects!.
On Mon, 7 Dec 2020 at 16:02, Kai-Uwe Rommel wrote:
> Hello,
>
>
>
> I still run a SOGo 2.3 instance … it is using a MySQL database as
> authentication source:
>
>
>
> SOGoAuthenticationMethod = SQL;
>
> SOGoUserSources = (
>
> {
>
> canAuthenticate = YES;
>
> id = directory;
>
> isAddressBook = YES;
>
> type = sql;
>
> userPasswordAlgorithm = md5;
>
> viewURL = "mysql://
> xxx:xx@127.0.0.1:3306/mail/sogo_auth";
>
> }
>
> );
>
>
>
> Users currently log in with their user ID which is firstname.lastname but
> I often see that some
>
> try with their e-mail address first (which is
> firstname.lastn...@domain.tld). How can I configure
>
> this (if possible) so that both login names are allowed? I did not find
> something so far.
>
> Perhaps I just overlooked something? I’m not a SOGo expert.
>
>
>
> (I could perhaps modify the sogo_auth view to show each user record twice,
> once without
>
> and once with the @domain.tld suffix?)
>
>
>
> Kai-Uwe Rommel
>
> kai-uwe.rom...@ars.de
> Telefon+Mobil: +49 89 32468-120
>
> <https://web.ars.de/>
> --
> *ARS Computer und Consulting GmbH*, www.ars.de
> ein Unternehmen der TIMETOACT Group
> Garmischer Straße 7, 80339 München, Deutschland
>
> ARS - The Art of Software Engineering
> Software Engineering, Technologieberatung, IBM Software, IBM
> Lizenzmanagement Services
>
> Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
> Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
> Datenschutzerklärung: https://web.ars.de/datenschutz/
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails - SOLVED
Hi Paul,
I have tested that and it also works.
I think I will go with it.
On Tue, 1 Dec 2020 at 14:34, paul schulz wrote:
> Hi
>
> You might also look at setting the Sogo configuration parameter:
> SOGoForceExternalLoginWithEmail = yes
>
> From the doco - "Parameter used to specify if, when logging in to the
> IMAP server, the primary email address of the user will be used instead
> of the username." The email address field is set in MailFieldNames = in
> your Sogo ldap config.
>
>
> Cheers
>
> Paul
>
> On 29/11/20 3:18 am, Odhiambo Washington (odhia...@gmail.com) wrote:
> > On Sat, 28 Nov 2020 at 15:15, Odhiambo Washington
> > wrote:
> >
> >> Bump!
> >>
> >>
> >> I seem to have gotten more debug information:
> >>
> >>
> >> Nov 28 06:24:09 sogod [52594]: |SOGo| request took 0.317055 seconds to
> >> execute
> >> Nov 28 06:24:09 sogod [52594]: 172.16.2.104 "POST /SOGo/connect
> HTTP/1.1"
> >> 200 56/84 0.321 - - 5M - 13
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| starting method 'GET' on uri
> >> '/SOGo/so/odhiambo@newideatest.local'
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| traverse(acquire):
> >> odhiambo@newideatest.local
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| do traverse name:
> >> 'odhiambo@newideatest.local'
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| traverse miss:
> >> name=odhiambo@newideatest.local, acquire: i=0,count=1
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| miss is last object.
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| handle miss error:
> >> NAME:SoAuthRequired
> >> REASON:authentication required
> >> Nov 28 06:24:10 sogod [52594]: |SOGo| request took 0.032842 seconds to
> >> execute
> >> Nov 28 06:24:10 sogod [52594]: 172.16.2.104 "GET
> >> /SOGo/so/odhiambo@newideatest.local HTTP/1.1" 200 7779/0 0.035 29219
> 73%
> >> 1M - 13
> >>
> >> On further digging, I found this thread:
> >> https://www.mail-archive.com/users@sogo.nu/msg27988.html
> >>
> >>
> >> I went with a toothcomb into my webserver config and modified some
> values
> >> under the proxy settings block, which now contains:
> >>
> >> http://127.0.0.1:2/SOGo>
> >> ## Adjust the following to your configuration
> >> ## and make sure to enable the headers module
> >>
> >>RequestHeader set "x-webobjects-server-port" "80"
> >>SetEnvIf Host (.*) HTTP_HOST=$1
> >>RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e"
> >> env=HTTP_HOST
> >>RequestHeader set "x-webobjects-server-url" "http://%{HTTP_HOST}e;
> >> env=HTTP_HOST
> >>
> >>AddDefaultCharset UTF-8
> >>
> >> ## When using proxy-side autentication, you need to uncomment and
> >> ## adjust the following line:
> >>RequestHeader unset "x-webobjects-remote-user"
> >>RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e"
> >> env=REMOTE_USER
> >>
> >>RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
> >>
> >>
> >> This leads to the web UI beginning to load, but with an error: An error
> >> occured while communicating with the mail server
> >>
> >> Here is what I see in sogo.log:
> >>
> >> Nov 28 06:45:46 sogod [53415]: |SOGo| request took 0.031020 seconds to
> >> execute
> >> Nov 28 06:45:46 sogod [53415]: 172.16.2.104 "POST /SOGo/connect
> HTTP/1.1"
> >> 403 34/84 0.033 - - 0 - 13
> >> Nov 28 06:46:04 sogod [53415]: |SOGo| starting method 'POST' on uri
> >> '/SOGo/connect'
> >> Nov 28 06:46:04 sogod [53415]: |SOGo| traverse(acquire): SOGo => connect
> >> Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'SOGo'
> >> Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'connect'
> >> Nov 28 06:46:04 sogod [53415]: |SOGo| set clientObject:
> >>
> >> Nov 28 06:46:04 sogod [53415]: <0x0x557e46588390[NGLdapConnection]>
> Using
> >> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> >> Nov 28 06:46:04 sogod [53415]: SOGoRootPage successful login from
> >> '172.16.2.104' for user 'odhiambo@newideatest.local' - expire = -1
> grace
> >> = -1
> >> Nov 28 06:46:04 sogod [53415]: |SOGo| request took 0.048955 seconds to
> >> execute
> >> Nov 28 06:4
Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails - SOLVED
On Sat, 28 Nov 2020 at 15:15, Odhiambo Washington
wrote:
> Bump!
>
>
> I seem to have gotten more debug information:
>
>
> Nov 28 06:24:09 sogod [52594]: |SOGo| request took 0.317055 seconds to
> execute
> Nov 28 06:24:09 sogod [52594]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
> 200 56/84 0.321 - - 5M - 13
> Nov 28 06:24:10 sogod [52594]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/odhiambo@newideatest.local'
> Nov 28 06:24:10 sogod [52594]: |SOGo| traverse(acquire):
> odhiambo@newideatest.local
> Nov 28 06:24:10 sogod [52594]: |SOGo| do traverse name:
> 'odhiambo@newideatest.local'
> Nov 28 06:24:10 sogod [52594]: |SOGo| traverse miss:
> name=odhiambo@newideatest.local, acquire: i=0,count=1
> Nov 28 06:24:10 sogod [52594]: |SOGo| miss is last object.
> Nov 28 06:24:10 sogod [52594]: |SOGo| handle miss error:
> NAME:SoAuthRequired
> REASON:authentication required
> Nov 28 06:24:10 sogod [52594]: |SOGo| request took 0.032842 seconds to
> execute
> Nov 28 06:24:10 sogod [52594]: 172.16.2.104 "GET
> /SOGo/so/odhiambo@newideatest.local HTTP/1.1" 200 7779/0 0.035 29219 73%
> 1M - 13
>
> On further digging, I found this thread:
> https://www.mail-archive.com/users@sogo.nu/msg27988.html
>
>
> I went with a toothcomb into my webserver config and modified some values
> under the proxy settings block, which now contains:
>
> http://127.0.0.1:2/SOGo>
> ## Adjust the following to your configuration
> ## and make sure to enable the headers module
>
> RequestHeader set "x-webobjects-server-port" "80"
> SetEnvIf Host (.*) HTTP_HOST=$1
> RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e"
> env=HTTP_HOST
> RequestHeader set "x-webobjects-server-url" "http://%{HTTP_HOST}e;
> env=HTTP_HOST
>
> AddDefaultCharset UTF-8
>
> ## When using proxy-side autentication, you need to uncomment and
> ## adjust the following line:
> RequestHeader unset "x-webobjects-remote-user"
> RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e"
> env=REMOTE_USER
>
> RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
>
>
> This leads to the web UI beginning to load, but with an error: An error
> occured while communicating with the mail server
>
> Here is what I see in sogo.log:
>
> Nov 28 06:45:46 sogod [53415]: |SOGo| request took 0.031020 seconds to
> execute
> Nov 28 06:45:46 sogod [53415]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
> 403 34/84 0.033 - - 0 - 13
> Nov 28 06:46:04 sogod [53415]: |SOGo| starting method 'POST' on uri
> '/SOGo/connect'
> Nov 28 06:46:04 sogod [53415]: |SOGo| traverse(acquire): SOGo => connect
> Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'SOGo'
> Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'connect'
> Nov 28 06:46:04 sogod [53415]: |SOGo| set clientObject:
>
> Nov 28 06:46:04 sogod [53415]: <0x0x557e46588390[NGLdapConnection]> Using
> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> Nov 28 06:46:04 sogod [53415]: SOGoRootPage successful login from
> '172.16.2.104' for user 'odhiambo@newideatest.local' - expire = -1 grace
> = -1
> Nov 28 06:46:04 sogod [53415]: |SOGo| request took 0.048955 seconds to
> execute
> Nov 28 06:46:04 sogod [53415]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
> 200 56/84 0.051 - - 0 - 13
> Nov 28 06:46:05 sogod [53415]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/odhiambo@newideatest.local'
> Nov 28 06:46:05 sogod [53415]: <0x0x557e464e60e0[NGLdapConnection]> Using
> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> Nov 28 06:46:05 sogod [53415]: <0x0x557e4658dd60[NGLdapConnection]> Using
> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> 2020-11-28 06:46:05.991 sogod[53415:53415] -[NGLdapConnection
> _searchAtBaseDN:qualifier:attributes:scope:]: search at base '' filter
> '(objectClass=*)' for attrs 'subschemaSubentry'
> 2020-11-28 06:46:05.992 sogod[53415:53415] -[NGLdapConnection
> _searchAtBaseDN:qualifier:attributes:scope:]: search at base
> 'CN=Aggregate,CN=Schema,CN=Configuration,DC=newideatest,DC=local' filter
> '(objectClass=*)' for attrs 'objectclasses'
> 2020-11-28 06:46:06.004 sogod[53415:53415] -[NGLdapConnection
> _searchAtBaseDN:qualifier:attributes:scope:]: search at base
> 'cn=users,dc=newideatest,dc=local' filter
> '(&(|(sAMAccountName=odhiambo)(mail=odhiambo))(mail=*))' for attrs 'dn'
> Nov 28 06:46:06 sogod [53415]: |SOGo| traverse(acquire):
> odhiambo@newideatest.local
> Nov 28 06:46:06 sogod [53415]: |SOGo| do traverse name:
> 'odhiambo@newideatest.local'
> Nov 28 06:46:06 s
Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails
[53415]: |SOGo| do traverse name: 'view'
Nov 28 06:46:11 sogod [53414]: [ERROR]
<0x0x557e45e452c0[NGImap4ConnectionManager]> IMAP4 login failed:
host=localhost, user=odhiambo, pwd=yes
url=imap://odhiambo@localhost/?tls=NO=default
base=(null)
base-class=(null))
= <0x0x557e4625ca30[NGImap4Client]: login=odhiambo(pwd)
socket= connectedTo=<0x0x557e4626bf80[NGInternetSocketAddress]:
host=localhost port=143>>>
Nov 28 06:46:11 sogod [53415]: |SOGo| set clientObject:
<0x557e46660510[SOGoMailFolder]: name=folderINBOX
container=0x557e468a7230/0>
Nov 28 06:46:11 sogod [53414]: [ERROR] <0x557e45e026b0[SOGoMailAccount]:0>
Could not connect IMAP4
Nov 28 06:46:11 sogod [53414]: |SOGo| set clientObject:
<0x557e45e026b0[SOGoMailAccount]: name=0 container=0x557e45e30b10/Mail>
Nov 28 06:46:11 sogod [53414]: |SOGo| request took 4.339817 seconds to
execute
Nov 28 06:46:11 sogod [53414]: 172.16.2.104 "GET
/SOGo/so/odhiambo/Mail/0/view HTTP/1.1" 200 17/0 4.345 - - 2M - 12
Nov 28 06:46:11 sogod [53415]: |SOGo| request took 4.410708 seconds to
execute
Nov 28 06:46:11 sogod [53415]: 172.16.2.104 "POST
/SOGo/so/odhiambo/Mail/0/folderINBOX/view HTTP/1.1" 500 72/126 4.413 - - 0
- 13
Nov 28 06:46:11 sogod [53415]: |SOGo| starting method 'POST' on uri
'/SOGo/so/odhiambo/Mail/unseenCount'
Nov 28 06:46:11 sogod [53415]: |SOGo| traverse(acquire): odhiambo => Mail
=> unseenCount
Nov 28 06:46:11 sogod [53415]: |SOGo| do traverse name: 'odhiambo'
Nov 28 06:46:11 sogod [53415]: |SOGo| do traverse name: 'Mail'
Nov 28 06:46:11 sogod [53415]: |SOGo| do traverse name: 'unseenCount'
Nov 28 06:46:11 sogod [53415]: |SOGo| set clientObject:
<0x557e4662fed0[SOGoMailAccounts]: name=Mail
container=0x557e465c9d30/odhiambo>
Nov 28 06:46:13 sogod [53415]: [ERROR]
<0x0x557e465f3500[NGImap4ConnectionManager]> IMAP4 login failed:
host=localhost, user=odhiambo, pwd=yes
url=imap://odhiambo@localhost/?tls=NO=default
base=(null)
base-class=(null))
= <0x0x557e467065d0[NGImap4Client]: login=odhiambo(pwd)
socket= connectedTo=<0x0x557e465ddc30[NGInternetSocketAddress]:
host=localhost port=143>>>
Nov 28 06:46:13 sogod [53415]: <0x557e4660e6d0[SOGoMailAccount]:0> renewing
imap4 password
Nov 28 06:46:15 sogod [53415]: [ERROR]
<0x0x557e465f3500[NGImap4ConnectionManager]> IMAP4 login failed:
host=localhost, user=odhiambo, pwd=yes
url=imap://odhiambo@localhost/?tls=NO=default
base=(null)
base-class=(null))
= <0x0x557e465c5430[NGImap4Client]: login=odhiambo(pwd)
socket= connectedTo=<0x0x557e465e0b30[NGInternetSocketAddress]:
host=localhost port=143>>>
Nov 28 06:46:15 sogod [53415]: [ERROR] <0x557e4660e6d0[SOGoMailAccount]:0>
Could not connect IMAP4
Nov 28 06:46:15 sogod [53415]: |SOGo| request took 3.814270 seconds to
execute
Nov 28 06:46:15 sogod [53415]: 172.16.2.104 "POST
/SOGo/so/odhiambo/Mail/unseenCount HTTP/1.1" 200 21/31 3.817 - - 0 - 13
Looking at the logs, it appears like SOGo is setting the user as just
"user" and not "user@domain".
When this is sent to the IMAP server, authentication fails because IMAP is
expecting a login in the form of "user@domain".
How do I resolve this?
How do I make SOGo to send the full e-mail address
(odhiambo@newideatest.local) to the IMAP server??
Definitely something to change in the SOGoUserSources below, but not sure
what it is.
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
UIDFieldName = sAMAccountName;
baseDN = "cn=users,dc=newideatest,dc=local";
bindDN = "CN=dovecot,CN=users,DC=newideatest,DC=local";
bindPassword = "mi-secreta";
bindFields = (sAMAccountName, mail);
filter = "mail = '*'";
canAuthenticate = YES;
displayName = "NI Users";
hostname = "ldap://127.0.0.1:389;;
id = public_samba4AD;
isAddressBook = YES;
}
);
Thanking you in advance.
I know it's a long read.
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails
Nov 28 05:44:39 sogod [51171]: |SOGo| starting method 'GET' on uri '/SOGo/so/odhiambo@newideatest.local' Nov 28 05:44:39 sogod [51171]: |SOGo| request took 0.033459 seconds to execute Nov 28 05:44:39 sogod [51171]: 172.16.2.104 "GET /SOGo/so/odhiambo@newideatest.local HTTP/1.1" 200 7779/0 0.037 29219 73% 1M - 13 On Thu, 26 Nov 2020 at 16:23, Odhiambo Washington wrote: > > Hello, > > I have a situation here that is making me pull all my hair out: > > I have been using SOGo with MySQL and it's been working very well. > > I have now added LDAP AD/Samba4 authentication for a test domain and SOGo > does not find and display e-mails, whereas Outlook is able to connect via > IMAP and display those e-mails. > > Authentication succeeds, then instead of displaying the web UI showing > e-mails, calendar, etc, it simply logs out and wants me to login again. > > I am not sure if it is possible to mix-and-match different types of > authentication. I thought it should not be a problem and SOGO would use the > Dictionaries and Sources one after another. > Is my assumption correct??? > > Hoping someone is able to act as my 3rd eye and see where my mistake is. > > I have captured sogo.log on this link: > https://pastebin.ubuntu.com/p/SMKx59cpNw/ > My sogo.conf is on the following link: > https://pastebin.ubuntu.com/p/PQpQVNYGBJ/ > > Thanking you in advance > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGoUserSources
Hello good people,
Something has crossed my mind - is there a way to daisy-chain domains in
sogo.conf?
1. If I have 3 domains sharing the same server and same authentication
source, instead of creating different blocks for the domains, is there a
way to daisy-chain them in the same block?
Instead of:
domains = {
domain1 = {
SOGoMailDomain = domain1;
SOGoUserSources = (
{
}
);
};
domain2 = {
SOGoMailDomain = domain2;
SOGoUserSources = (
{
}
);
};
};
Maybe it's possible to do it differently, like:
domains = {
domain1, domain2, domainN = {
SOGoMailDomains = domain1, domain2, domainN;
SOGoUserSources = (
}
);
};
};
2. If I have 3 domains sharing same authentication source, can I just
create a single SOGoUserSources block, without the need to specify the
domains?
Let's say I have several domains using same MySQL user source and other
several domains using LDAP user source, so I create a single MSQL user
source and
a single LDAP user source, like:
/* MySQL */
SOGoUserSources =
(
{
type = sql;
id = directory;
viewURL = "postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5;
}
);
/* LDAP AD/Samba4 */
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
UIDFieldName = sAMAccountName;
baseDN = "CN=users,dc=domain,dc=tld";
bindDN = "CN=sogo,CN=users,DC=domain,DC=tld";
bindFields = (sAMAccountName, mail);
bindPassword = password;
canAuthenticate = YES;
displayName = "Public";
hostname = "ldap://127.0.0.1:389;;
filter = "mail = '*'";
id = directory;
isAddressBook = YES;
}
);
And SOGo would try to authenticate against the 1st source, fail and try the
next source??
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] SOGO+Samba4 AD - SOGo not finding e-mails
Hello, I have a situation here that is making me pull all my hair out: I have been using SOGo with MySQL and it's been working very well. I have now added LDAP AD/Samba4 authentication for a test domain and SOGo does not find and display e-mails, whereas Outlook is able to connect via IMAP and display those e-mails. Authentication succeeds, then instead of displaying the web UI showing e-mails, calendar, etc, it simply logs out and wants me to login again. I am not sure if it is possible to mix-and-match different types of authentication. I thought it should not be a problem and SOGO would use the Dictionaries and Sources one after another. Is my assumption correct??? Hoping someone is able to act as my 3rd eye and see where my mistake is. I have captured sogo.log on this link: https://pastebin.ubuntu.com/p/SMKx59cpNw/ My sogo.conf is on the following link: https://pastebin.ubuntu.com/p/PQpQVNYGBJ/ Thanking you in advance -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] changing from address for sogo notifications
On Tue, 27 Oct 2020 at 15:53, Daniel Kollmer wrote: > Hello > > I was looking for a setting to change the from address of sogo > notificatons. At this point it is just s...@domain.tld, but I'd rather > make it something like nore...@webmail.domain.tld. > > Is it possible to set it somewhere if I am not using a local mail > command on the sogo server but directly send everything to an smtp > server on our network? > > Thanks in advance for any advice. > > How about just rewrite that address at the MTA level? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8
On Tue, 13 Oct 2020 at 00:05, Götz Reinicke wrote: > Hi, > > Am 12.10.2020 um 13:47 schrieb Odhiambo Washington (odhia...@gmail.com) < > users@sogo.nu>: > > > > On Mon, 12 Oct 2020 at 13:39, Götz Reinicke wrote: > >> Hi, >> >> what are the right steps to migrate the SOGo database to a new database >> server (with new server name): >> >> - dump/backup all user data >> - shutdown sogo >> - add a new database to the new server >> - edit the sogo.conf database serve name/user/password >> > > It's easier to just reuse the creds from sogo.conf so no need to edit > sogo.conf (dbname, username, password): > MySQL>CREATE USER 'username'@'hostname OR IP' IDENTIFIED WITH > mysql_native_password BY 'the_password'; > MYSQL>GRANT ALL ON dbname.* TO 'username'@'hostname OR IP‘; > > > > true@credentials. I’m used to set new ones, so I can be 100% sure I’m > connecting to the new db. > Okay. > - restart sogo >> - restore the user data from the backup >> >> Did I miss something? >> > > Yes. move the dump to the new server :-) > > > I guess you talk about the database dump? As the database server name will > change, I can’t use the „old“ dump anymore I think. > Yes. I meant the DB backup. > > By dumping the user data I was referring to the pogo-tool backup. May be I > was a bit confusing, or did misunderstand you. > I never had to do that because on my servers, there is nothing that sogo saves outside the DB. TBH, I have never used sogo-tool even once! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8
On Mon, 12 Oct 2020 at 13:39, Götz Reinicke wrote: > Hi, > > what are the right steps to migrate the SOGo database to a new database > server (with new server name): > > - dump/backup all user data > - shutdown sogo > - add a new database to the new server > - edit the sogo.conf database serve name/user/password > It's easier to just reuse the creds from sogo.conf so no need to edit sogo.conf (dbname, username, password): MySQL>CREATE USER 'username'@'hostname OR IP' IDENTIFIED WITH mysql_native_password BY 'the_password'; MYSQL>GRANT ALL ON dbname.* TO 'username'@'hostname OR IP'; - restart sogo > - restore the user data from the backup > > Did I miss something? > Yes. move the dump to the new server :-) > > Are there known problems with the DB version upgrade? > I did not encounter any when I migrated from 5.7 to 8.0. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 5.0.0 Login Problem
.687 sogod[14915:101031] connection=0x0x80d367800> SQL: SELECT * FROM resources WHERE (c_uid = 'ry86') > OR (mail = 'ry86'); > 2020-10-01 17:35:39.687 sogod[14915:101031] connection=0x0x80d367800> query has results, entering fetch-mode. > Oct 01 17:35:39 sogod [14915]: <0x0x812342408[NGLdapConnection]> Using > ldap_initialize for LDAP URL: ldap://127.0.0.1:389 > 2020-10-01 17:35:39.764 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '' > filter '' for attrs '*' > 2020-10-01 17:35:39.784 sogod[14915:101031] connection=0x0x80d367300> SQL: SELECT c_defaults FROM sogo_user_profile WHERE > c_uid = 'ry86'; > 2020-10-01 17:35:39.784 sogod[14915:101031] connection=0x0x80d367300> query has results, entering fetch-mode. > 2020-10-01 17:35:39.889 sogod[14915:101031] connection=0x0x80d365a00> SQL: SELECT c_settings FROM sogo_user_profile WHERE > c_uid = 'ry86'; > 2020-10-01 17:35:39.889 sogod[14915:101031] connection=0x0x80d365a00> query has results, entering fetch-mode. > 2020-10-01 17:35:39.890 sogod[14915:101031] connection=0x0x80d367800> SQL: SELECT * FROM resources WHERE (c_uid = 'ry86') > OR (mail = 'ry86'); > 2020-10-01 17:35:39.890 sogod[14915:101031] connection=0x0x80d367800> query has results, entering fetch-mode. > Oct 01 17:35:39 sogod [14915]: <0x0x80c283d78[NGLdapConnection]> Using > ldap_initialize for LDAP URL: ldap://127.0.0.1:389 > 2020-10-01 17:35:39.970 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '' > 2020-10-01 17:35:39.988 sogod[14915:101031] EXCEPTION: 0x80c39b878> NAME:NSInvalidArgumentException REASON:-[NSURL queryComponents]: > unrecognized selector sent to instance 0x80c39b7e8 INFO:(null) > Oct 01 17:35:39 sogod [14915]: |SOGo| request took 0.589178 seconds to execute > Oct 01 17:35:39 sogod [14915]: 172.17.28.1 "GET /SOGo/so/ry86/Mail/view > HTTP/1.1" 501 0/0 0.596 - - - > > ry86 is my user-account and I redacted the baseDN and the filter, but they > seem to work and worked on 4.3.2 > > AD is connected via stunnel. > > I adapted the IMAP and SMTP URLs in the config to allow insecure localhost > > I get the same error when trying to login via database with a different > account. > > Can someone make sense out of that? > > Cheers > > Lars > > -- > ---punkt.de GmbH > Lars Liedtke > .infrastructure > > Kaiserallee 13a > 76133 Karlsruhe > > Tel. +49 721 9109 500https://infrastructure.punkt.dei...@punkt.de > > AG Mannheim 108285 > Geschäftsführer: Jürgen Egeling, Daniel Lienert, Fabian Stein > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
