[SOGo] BTS activities for Wednesday, April 08 2015
Title: BTS activities for Wednesday, April 08 2015 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Wednesday, April 08 2015 idlast updatestatus (resolution)categorysummary 3126 2015-04-08 09:49:19 updated (open) ActiveSync Some email with wrong date and time. 3166 2015-04-08 11:03:54 updated (open) Backend Calendar Availability when booking all day events with Thunderbird/Lightining 2867 2015-04-08 08:38:10 updated (open) Backend General ACL caching with LDAP Groups 2865 2015-04-08 08:47:25 updated (open) Web Calendar SOGo does not interpret date-time without timezone correctly 3165 2015-04-08 10:33:28 updated (open) Web Calendar event invitation: no notification for external invitees if appointment notifications are disabled 3164 2015-04-08 12:11:45 updated (open) Web General Problem with UTF-8 Subjects
Re: [SOGo] Sogo and MySQL problem
hi all, i had this issue today on a cetnos 7 installation with rpms from redhat pre [jaile-sogo] name=Copr repo for sogo owned by jaile baseurl=https://copr-be.cloud.fedoraproject.org/results/jaile/sogo/epel-7-$basearch/ /pre SOGO was throwing 1000s of msql errors -- I finally saw the segfault messages on the console. I decommissioned the server and replaced it with centos 6 -- works perfectly. I will not be using centos 7 again until rpms are available here Apr 8 13:31:44 alt kernel: sogod[6962]: segfault at 0 ip 7f1e2a40b053 sp 7fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000] Apr 8 13:31:44 alt kernel: sogod[6963]: segfault at 0 ip 7f1e2a40b053 sp 7fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000] Apr 8 13:31:44 alt kernel: sogod[6964]: segfault at 0 ip 7f1e2a40b053 sp 7fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000] Apr 8 13:31:44 alt kernel: sogod[6965]: segfault at 0 ip 7f1e2a40b053 sp 7fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000] ... Cheers M On 04/08/2015 09:55 PM, Jeroen Beerstra wrote: Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used to work as mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder This is driving me nuts :( Something is clearly broken, if only the log would provide some more clou... mvg, Jeroen Beerstra Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
I run into the same problem last week when upgrading from CentOS 7 to CentOS 7.1, which I found a bit stealthy, since the repo links stay the same. But a lot of base as well as epel packages are having a major upgrades. I am using IPA for authentication with SOGO / Dovecot and that went from 3.2 to 4.1, fortunately without a major glitch (up to now :-). But the SOGO / SOPE49 interface to mariadb / mysql seems to have at least intermittent connection problems after the upgrade. It tried to backout - go to the older version - for gnustep-base/-make/-filesystem from the jaille-sogo repository without luck. My final solution was to switch the DB from mysql/mariadb to postgreql. The combination sogo / sope49 / gnustep from the pre-packaged jaile-sogo repo, CentOS postresql (9.2.10) from the most recent update repo works stable since last week. I found a hint on google that the mysql4 calls / interface are no longer fully supported with MySQL / mariadb 5. At least the problem on my server were intermittent so I could access one account via the WEB interface after each sogo restart and export teh calendar / contacts into text files. As soon as I tried to switch the user account or access via the Thunderbird connector things went south... For larger databases (I have 14 accounts) a mysql export - postgresql import might be feasible. (A short test using phpmysqadmin / phppgadmin did not work...) Fortunately I use the DB only for the SOGO calendar / contact information. The user authentication as well as mail accounts are administrated by (Free)IPA bundled with CentOS which provides a LDAP (via ldapsearch) as well as pam.d (via sssd) interface. Kind regards Uli Maurus On 08/04/15 04:43 PM, Jeroen Beerstra wrote: Yes CentOS 7.1, I used to just use newer gnustep-make and gnustep-base from either fedora or epel, but guess this doens't work anymore. Bad news is I can't get the sogu.nu provided srpms counterparts to compile, guess they are just too old for 7 :( mvg, Jeroen Beerstra Op 09-04-15 om 00:19 schreef Schifano Alexandre: On 08/04/2015 22:45, Gilles Gagniard wrote: Hello ! Same issue here. Are you still running your sogo install on centos 7 by any chance ? On my side the only significant change I did is to yum update, which upgraded my box to the recently released centos 7.1, which among other things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too before restarting your server ... I tried to rebuild everything in case there is some binary compatibility issue, but to no avail. Gilles Hi, I used CentOS 7. After my server reboot I did a yum update and I'm now with a CentOS 7.1. I tried the new binaries available in the SOGo repository, with the same result. On 08/04/2015 22:26, Steve Ankeny wrote: (1) What version of MariaDB are you using? (2) Are you using anything else such as Samba 4 LDAP with MariaDB? (3) What are you using for SOGoUserSources? I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine. I rebooted over the weekend for a kernel upgrade, and I've had no problems. My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as yours. I had an issue creating the OpenChange MySQL user as 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did not like the single quotes. Once I removed those, everything worked fine. I had thought that was the case with the SOGo MySQL user, but it was created without single quotes. I wonder if it has to do with the MariaDB version? Hi, I have MariaDB 5.5.41, with no LDAP and no Samba. My user authentification is done throught the SQL backend. On 04/08/2015 03:55 PM, Jeroen Beerstra wrote: Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used to work as mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder This is driving me nuts :( Something is clearly broken, if only the log would provide some more clou... mvg, Jeroen Beerstra Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my
Re: [SOGo] Sogo and MySQL problem
On 08/04/2015 22:45, Gilles Gagniard wrote: Hello ! Same issue here. Are you still running your sogo install on centos 7 by any chance ? On my side the only significant change I did is to yum update, which upgraded my box to the recently released centos 7.1, which among other things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too before restarting your server ... I tried to rebuild everything in case there is some binary compatibility issue, but to no avail. Gilles Hi, I used CentOS 7. After my server reboot I did a yum update and I'm now with a CentOS 7.1. I tried the new binaries available in the SOGo repository, with the same result. On 08/04/2015 22:26, Steve Ankeny wrote: (1) What version of MariaDB are you using? (2) Are you using anything else such as Samba 4 LDAP with MariaDB? (3) What are you using for SOGoUserSources? I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine. I rebooted over the weekend for a kernel upgrade, and I've had no problems. My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as yours. I had an issue creating the OpenChange MySQL user as 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did not like the single quotes. Once I removed those, everything worked fine. I had thought that was the case with the SOGo MySQL user, but it was created without single quotes. I wonder if it has to do with the MariaDB version? Hi, I have MariaDB 5.5.41, with no LDAP and no Samba. My user authentification is done throught the SQL backend. On 04/08/2015 03:55 PM, Jeroen Beerstra wrote: Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used to work as mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder This is driving me nuts :( Something is clearly broken, if only the log would provide some more clou... mvg, Jeroen Beerstra Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
(1) What version of MariaDB are you using? (2) Are you using anything else such as Samba 4 LDAP with MariaDB? (3) What are you using for SOGoUserSources? I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine. I rebooted over the weekend for a kernel upgrade, and I've had no problems. My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as yours. I had an issue creating the OpenChange MySQL user as 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did not like the single quotes. Once I removed those, everything worked fine. I had thought that was the case with the SOGo MySQL user, but it was created without single quotes. I wonder if it has to do with the MariaDB version? On 04/08/2015 03:55 PM, Jeroen Beerstra wrote: Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used to work as mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder This is driving me nuts :( Something is clearly broken, if only the log would provide some more clou... mvg, Jeroen Beerstra Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
Hello ! Same issue here. Are you still running your sogo install on centos 7 by any chance ? On my side the only significant change I did is to yum update, which upgraded my box to the recently released centos 7.1, which among other things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too before restarting your server ... I tried to rebuild everything in case there is some binary compatibility issue, but to no avail. Gilles Le Mercredi 8 Avril 2015 15:35 CEST, schif...@polytech.unice.fr a écrit: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
Yes CentOS 7.1, I used to just use newer gnustep-make and gnustep-base from either fedora or epel, but guess this doens't work anymore. Bad news is I can't get the sogu.nu provided srpms counterparts to compile, guess they are just too old for 7 :( mvg, Jeroen Beerstra Op 09-04-15 om 00:19 schreef Schifano Alexandre: On 08/04/2015 22:45, Gilles Gagniard wrote: Hello ! Same issue here. Are you still running your sogo install on centos 7 by any chance ? On my side the only significant change I did is to yum update, which upgraded my box to the recently released centos 7.1, which among other things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too before restarting your server ... I tried to rebuild everything in case there is some binary compatibility issue, but to no avail. Gilles Hi, I used CentOS 7. After my server reboot I did a yum update and I'm now with a CentOS 7.1. I tried the new binaries available in the SOGo repository, with the same result. On 08/04/2015 22:26, Steve Ankeny wrote: (1) What version of MariaDB are you using? (2) Are you using anything else such as Samba 4 LDAP with MariaDB? (3) What are you using for SOGoUserSources? I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine. I rebooted over the weekend for a kernel upgrade, and I've had no problems. My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as yours. I had an issue creating the OpenChange MySQL user as 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did not like the single quotes. Once I removed those, everything worked fine. I had thought that was the case with the SOGo MySQL user, but it was created without single quotes. I wonder if it has to do with the MariaDB version? Hi, I have MariaDB 5.5.41, with no LDAP and no Samba. My user authentification is done throught the SQL backend. On 04/08/2015 03:55 PM, Jeroen Beerstra wrote: Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used to work as mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder This is driving me nuts :( Something is clearly broken, if only the log would provide some more clou... mvg, Jeroen Beerstra Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even
Re: [SOGo] rpcproxy not installed?
me third. Thanks Ludovic for getting us closer to having this available. Very much looking forward to trying it out On 04/08/2015 02:55 PM, Steve Ankeny wrote: me neither . . . On 04/08/2015 04:15 PM, Gerald Brandt wrote: Nope, hadn't seen that. I knew previous version didn't have it, but it was mentioned it would be back in place by 2.2.14. Hopefully in 2.2.18. I can't move ahead without it. Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] rpcproxy not installed?
me neither . . . On 04/08/2015 04:15 PM, Gerald Brandt wrote: Nope, hadn't seen that. I knew previous version didn't have it, but it was mentioned it would be back in place by 2.2.14. Hopefully in 2.2.18. I can't move ahead without it. Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Sogo and MySQL problem
Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Information on shared calendar entries
On 04/07/2015 09:49 PM, Tom wrote: Hello List when I share a calendar on all authenticated users, then I can subscribe to this. But I only see Öffentlicher Termin instead of the real entries in this calendar. How can be acomplished to see all information on a calendar entry of a user? Best regards and thanks for your help! Thomas. Events in calendar can have 3 levels of confidentiality: Public events, Confidential Events, Private Events. As far as I remember, the default is: For Public events: non-owners can only view date and time (not the description nor more details) For Confidential events: non-owners can only view date and time (not the description nor more details) For Private events: non-owners cannot view the event (they dont know it exists) To make Public events details vieables by non-owners, you need to setup either in the calendar setting or in the sogo.conf. For the latter, it's SOGoCalendarDefaultRoles = ( ..., PublicViewer); My personnal (it's just me) preference is SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); Note: To ease the work of getting help, I recommend you to test with english settings, so that you can reach maximu people. I had to translate Öffentlicher Terminwith Googme in order to knwo what you meant. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Add additional email Address (samba4/openchange).
On 04/07/2015 09:52 PM, Tom wrote: Hello all, I was able to create SOGO users with samba-tool user add user.name http://user.name openchange_newuser --create user.name http://user.name samba-tool user setexpiry user.name http://user.name --noexpiry But how can an additional e-Mail address being added to thos user user.name http://user.name ? According to me, if you need an additional email address, it is for the purpose to have an alias. For example, if the additional email of user.name is ceo@ , then email to ceo@ should be delivered to user.name. If what I think is right (and please correct me if I'm wrong), this is handled by the MTA. You need to tell the MTA (Postfix or Exim or whatever you used) where to find the aliases correspondances. This could be achieved in several ways and one of the simplest is to add an entry in /etc/aliases. Anyway, the alias lookup can be done by querying Samba or any storage supported by the MTA. Is it mandatory for you to have aliases provisionned in Samba directory? HTH -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Information on shared calendar entries
On 04/08/2015 02:23 PM, t...@thomasbaumann.com wrote: Thanks for this information. How can Language changed in Display, when User is logged in? Then I'd know Öffentlicher Termin means Public ;) But I still have Issues. I changed /etc/sogo/sogo.conf to: SOGoCalendarDefaultRoles = ( PublicViewer, ConfidentialDAndTViewer, PrivateDAndTViewer ); Restarted sogod, then marked the Calendar Entry as Public, but my collegue which subscribed to my Calender still sees no details on the entry, but only Public and the time-range. So still any help is appreciated. Best regards, Thomas. Try this: stop sogod stop memcached start memcached start sogod Then test. Please keep replying to the mailing list. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Dovecot authentication with domain
Hi, I can authenticate with dovecot if I just pass in my user name. If I pass in user@domain, the login fails. It seems that SOGo always passes in the domain name. I either need to make SOGo stop passing in the domain name, or have Dovecot/Samba4 accept the domian name. Any ideas? Gerald $ telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready. 1 login gbr bob 1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE QUOTA] Logged in $ telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready. 1 login g...@domin.com bob 1 NO [AUTHENTICATIONFAILED] Authentication failed. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Ready to go 'Appliance'?
Or take a look at: http://www.zentyal.org/ On 4/8/2015 14:41, Jeff Folk wrote: On Apr 8, 2015, at 6:51 AM, Charles Marcus wrote: Hello all, Are there any ready to go 'Appliances' available (totally free or not) for the full SOGo+Samba AD environment that I could point a friend to, who is looking to get off the Microsoft money train? Preferably a Debian Stable based one. We would prefer a totally free solution, but would not mind one that had an initial cost where he was paying for the work done to provide the 'ready to go' environment, and/or provided a paid support option, but he wants something that doesn't cost 'per-user' or 'per-domain', and that won't 'stop working' if he decided to stop renewing the paid support option in the future. Thanks, Charles I'm not aware of a Debian based 'appliance', but you might have a look at NethServer: http://www.nethserver.org User management, email, gateway router, SOGo module, etc. I'm using it and like it so far. Cheers, Jeff -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Ready to go 'Appliance'?
Hello all, Are there any ready to go 'Appliances' available (totally free or not) for the full SOGo+Samba AD environment that I could point a friend to, who is looking to get off the Microsoft money train? Preferably a Debian Stable based one. We would prefer a totally free solution, but would not mind one that had an initial cost where he was paying for the work done to provide the 'ready to go' environment, and/or provided a paid support option, but he wants something that doesn't cost 'per-user' or 'per-domain', and that won't 'stop working' if he decided to stop renewing the paid support option in the future. Thanks, Charles -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Ready to go 'Appliance'?
You can also try : http://iabsis.com/fr/igestis/igestis-os Olivier. 2015-04-08 14:59 GMT+02:00 Zhang Huangbin z...@iredmail.org: On Apr 8, 2015, at 7:51 PM, Charles Marcus cmar...@media-brokers.com wrote: Are there any ready to go 'Appliances' available (totally free or not) for the full SOGo+Samba AD environment that I could point a friend to, who is looking to get off the Microsoft money train? If it's ok for you to go without Samba/OpenChange, you can give iRedMail a try: http://www.iredmail.org/ Exchange ActiveSync works fine. Zhang Huangbin, founder of iRedMail project: http://www.iredmail.org/ -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Ready to go 'Appliance'?
On Apr 8, 2015, at 7:51 PM, Charles Marcus cmar...@media-brokers.com wrote: Are there any ready to go 'Appliances' available (totally free or not) for the full SOGo+Samba AD environment that I could point a friend to, who is looking to get off the Microsoft money train? If it's ok for you to go without Samba/OpenChange, you can give iRedMail a try: http://www.iredmail.org/ Exchange ActiveSync works fine. Zhang Huangbin, founder of iRedMail project: http://www.iredmail.org/ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Dovecot authentication with domain
Hello Gerald, for me it is working, but I had to adapt the LDAP Settings in dovecot. For Testing purposes it is good to use the doveadm command. doveadm -Dv auth test -x service=imap -x rip=127.0.0.1 user.name passw0rd doveadm -Dv auth test -x service=imap -x rip=127.0.0.1 user.n...@domain.com passw0rd Best regards, Thomas http://www.tiri.hamburg/ 2015-04-07 23:50 GMT+02:00 Gerald Brandt g...@majentis.com: Hi, I can authenticate with dovecot if I just pass in my user name. If I pass in user@domain, the login fails. It seems that SOGo always passes in the domain name. I either need to make SOGo stop passing in the domain name, or have Dovecot/Samba4 accept the domian name. Any ideas? Gerald $ telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready. 1 login gbr bob 1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE QUOTA] Logged in $ telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready. 1 login g...@domin.com bob 1 NO [AUTHENTICATIONFAILED] Authentication failed. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Add additional email Address (samba4/openchange).
On 08 Apr 2015, at 12:24, Mihamina Rakotomandimby mihamina.rakotomandi...@rktmb.org wrote: On 04/07/2015 09:52 PM, Tom wrote: Hello all, I was able to create SOGO users with samba-tool user add user.name http://user.name/ openchange_newuser --create user.name http://user.name/ samba-tool user setexpiry user.name http://user.name/ --noexpiry But how can an additional e-Mail address being added to thos user user.name http://user.name/ ? According to me, if you need an additional email address, it is for the purpose to have an alias. For example, if the additional email of user.name is ceo@ , then email to ceo@ should be delivered to user.name. If what I think is right (and please correct me if I'm wrong), this is handled by the MTA. You need to tell the MTA (Postfix or Exim or whatever you used) where to find the aliases correspondances. This could be achieved in several ways and one of the simplest is to add an entry in /etc/aliases. Anyway, the alias lookup can be done by querying Samba or any storage supported by the MTA. Is it mandatory for you to have aliases provisionned in Samba directory? You are right, this is MTA’s job. Alias addresses can be perfectly configured within samba LDAP directory, or example myself I use otherMailbox schema attribute for this. Regards Martin. smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Ready to go 'Appliance'?
On Apr 8, 2015, at 6:51 AM, Charles Marcus wrote: Hello all, Are there any ready to go 'Appliances' available (totally free or not) for the full SOGo+Samba AD environment that I could point a friend to, who is looking to get off the Microsoft money train? Preferably a Debian Stable based one. We would prefer a totally free solution, but would not mind one that had an initial cost where he was paying for the work done to provide the 'ready to go' environment, and/or provided a paid support option, but he wants something that doesn't cost 'per-user' or 'per-domain', and that won't 'stop working' if he decided to stop renewing the paid support option in the future. Thanks, Charles I'm not aware of a Debian based 'appliance', but you might have a look at NethServer: http://www.nethserver.org User management, email, gateway router, SOGo module, etc. I'm using it and like it so far. Cheers, Jeff smime.p7s Description: S/MIME cryptographic signature
[SOGo] calendar share error
trying to get calendar sharing enabled and got this error from user that calendar was shared with An error occurred during object publishing tried to access private object (0x0x38d555650a0, SoClass=SOGoAppointmentObject) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] rpcproxy not installed?
Hi, I'm doing a 2.2.17a install on Ubuntu 14.04. I've hit a couple of roadblocks, which I've managed to work around. The roadblock I'm currently at is using rpcproxy.dll. I've installed what I believe are the correct packages, but I don't seem to have OCS Manager ot RPC Proxy installed. Ant help would be appreciated. Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] rpcproxy not installed?
On 08/04/2015 15:32, Gerald Brandt wrote: I'm doing a 2.2.17a install on Ubuntu 14.04. I've hit a couple of roadblocks, which I've managed to work around. The roadblock I'm currently at is using rpcproxy.dll. I've installed what I believe are the correct packages, but I don't seem to have OCS Manager ot RPC Proxy installed. Perfectly normal for now - these packages are currently *not* available. We should finally be in a position to merge contributions to our SOGo/OpenChange backend this week or early next week and release 2.2.18 with the updated backend, together with new OpenChange packages which will include this time rpcproxy and ocsmanager. Cheers! -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] rpcproxy not installed?
On Wednesday, April 8, 2015 14:36 CDT, Ludovic Marcotte lmarco...@inverse.ca wrote: On 08/04/2015 15:32, Gerald Brandt wrote: I'm doing a 2.2.17a install on Ubuntu 14.04. I've hit a couple of roadblocks, which I've managed to work around. The roadblock I'm currently at is using rpcproxy.dll. I've installed what I believe are the correct packages, but I don't seem to have OCS Manager ot RPC Proxy installed. Perfectly normal for now - these packages are currently *not* available. We should finally be in a position to merge contributions to our SOGo/OpenChange backend this week or early next week and release 2.2.18 with the updated backend, together with new OpenChange packages which will include this time rpcproxy and ocsmanager. Cheers! -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists Ah! I hadn't realized they weren't merged yet. Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Dovecot authentication with domain
On 2015-04-08 6:59 AM, Tom wrote: Hello Gerald, for me it is working, but I had to adapt the LDAP Settings in dovecot. For Testing purposes it is good to use the doveadm command. doveadm -Dv auth test -x service=imap -x rip=127.0.0.1 user.name http://user.name passw0rd doveadm -Dv auth test -x service=imap -x rip=127.0.0.1 user.n...@domain.com mailto:user.n...@domain.com passw0rd Best regards, Thomas http://www.tiri.hamburg/ 2015-04-07 23:50 GMT+02:00 Gerald Brandt g...@majentis.com mailto:g...@majentis.com: Hi, I can authenticate with dovecot if I just pass in my user name. If I pass in user@domain, the login fails. It seems that SOGo always passes in the domain name. I either need to make SOGo stop passing in the domain name, or have Dovecot/Samba4 accept the domian name. Any ideas? Gerald $ telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready. 1 login gbr bob 1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE QUOTA] Logged in $ telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready. 1 login...@domin.com mailto:g...@domin.com bob 1 NO [AUTHENTICATIONFAILED] Authentication failed. I'm currently working without the domain portion. What did you change to allow authentication with domain? Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] rpcproxy not installed?
Great! On 04/08/2015 03:36 PM, Ludovic Marcotte wrote: On 08/04/2015 15:32, Gerald Brandt wrote: I'm doing a 2.2.17a install on Ubuntu 14.04. I've hit a couple of roadblocks, which I've managed to work around. The roadblock I'm currently at is using rpcproxy.dll. I've installed what I believe are the correct packages, but I don't seem to have OCS Manager ot RPC Proxy installed. Perfectly normal for now - these packages are currently *not* available. We should finally be in a position to merge contributions to our SOGo/OpenChange backend this week or early next week and release 2.2.18 with the updated backend, together with new OpenChange packages which will include this time rpcproxy and ocsmanager. Cheers! -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] rpcproxy not installed?
Did you see the Note on pg. 14 [17] of the SOGo Native Microsoft Outlook Configuration http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf manual? On 04/08/2015 03:32 PM, Gerald Brandt wrote: Hi, I'm doing a 2.2.17a install on Ubuntu 14.04. I've hit a couple of roadblocks, which I've managed to work around. The roadblock I'm currently at is using rpcproxy.dll. I've installed what I believe are the correct packages, but I don't seem to have OCS Manager ot RPC Proxy installed. Ant help would be appreciated. Gerald -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo and MySQL problem
Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used to work as mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder This is driving me nuts :( Something is clearly broken, if only the log would provide some more clou... mvg, Jeroen Beerstra Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr: I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate MySQL4 connection! Apr 08 15:12:52 sogod [992]: [ERROR] 0x0x7f4529584700[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f45298f63e0] connection=0x(null) for mysql://localhost/sogo/sogo_sessions_folder Apr 08 15:12:52 sogod [992]: [WARN] 0x0x7f4529584700[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52 +0200 I have my OCSSessionsFolderURL well defined with username, password, and DB port, but it looks like this is not well setted in the running SOGo. Is there a way to get the config of the running SOGo ? And how can I correct this problem ? Best regards Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of error in my logs messages : 2015-04-08 8:18:58.708 sogod[8174] ERROR((null)): could not allocate MySQL4 connection! Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c9564f0[GCSChannelManager] could not open channel MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null) for mysql://localhost/sogo/sogo_custom_users Apr 08 8:18:58 sogod [8174]: [WARN] 0x0x7f3a2c9564f0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2015-04-08 8:18:58 +0200 Apr 08 8:18:58 sogod [8174]: [ERROR] 0x0x7f3a2c8fb050[SQLSource] failed to acquire channel for URL: mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users However : * it worked well before the reboot, * I am able to be connected to my db with mysql -h localhost -u sogo -p, * when I do telnet localhost 3306 I have a opened connection to MariaDB (the connection is accepted and there is a kind of welcome message) * the port used by MariaDB is still the same, * and I even configured iptable for having the 3306 port open to everybody. What did I forget ? Best regards -- users@sogo.nu https://inverse.ca/sogo/lists signature.asc Description: OpenPGP digital signature