Re: [SOGo] Ubuntu Sogo Mysql Authentication Setup Problem.
Hello
Am 2015-05-29 um 22:20 schrieb Richard Doc Kinne:
Hi Folks:
I am trying to set up Sogo on an Ubuntu 14.04 server using mysql as the
authenticator.
I have gotten to a point where the website interface is working, but no one
can log in. The interface says “Wrong username or password.” I’m not sure
what I’m missing.
The log says: May 29 19:27:20 sogod [25088]: [ERROR]
0x0x7fd85fdd05a8[SOGoUserManager] No authentication sources defined -
nobody will be able to login. Check your defaults.
It does seem to be connecting to the database, as far as I can tell. The
tables seem to be there.
I’m missing something basic, but after several days I can’t figure out
what. Any thoughts?
...
My sogo.conf is here:
{
...
/* Authentication */
SOGoPasswordChangeEnabled = YES;
/* LDAP authentication example */
//SOGoUserSources = (
// {
You should uncomment the above two lines :-)
type = sql;
userPasswordAlgorithm = md5;
viewURL = mysql://sogo:SOGOSaveUs!@50.198.80.204:3306/sogo/sogo_users
;
//CNFieldName = cn;
//UIDFieldName = uid;
//IDFieldName = uid; // first field of the DN for direct binds
//bindFields = (uid, mail); // array of fields to use for indirect
binds
//baseDN = ou=users,dc=acme,dc=com;
//bindDN = uid=sogo,ou=users,dc=acme,dc=com;
//bindPassword = qwerty;
canAuthenticate = YES;
displayName = SOGo Users;
//hostname = ldap://127.0.0.1:389;
id = users;
isAddressBook = YES;
// }
//);
And uncomment the above two lines too :-)
/* SQL authentication example */
/* These database columns MUST be present in the view/table:
cut
This should solve your problems.
Kind regards,
Christian Mack
--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
Re: [SOGo] Mail filter not appearing
Hello Am 2015-05-29 um 15:34 schrieb car.cue...@protonmail.com: Thanks again for replying Christian, Well about this Error: May 29 10:08:12 sogod [16521]: 0x0x7f02b7276e90[SOGoCache] an error occurred when caching value for key 'exam...@mailexample.com+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY I read that it can be caused, because some parameters to have them not so well adjusted: for example: WOWorkersCount = 10; // Memcached SOGoMemcachedHost = 127.0.0.1; But actually, it seems that this part I have well configured; I am thinking more that this can be caused because I am using one of the minimum digitalOcean VM (512Mb Ram + 768Mb swap)... What I am not sure is about the consequences of this error. Did you actually start memcached? If not, this is your error. Consequences will be: - SOGo will be really really really slow - Your DB accesses will increase You do not want it to swap at all! Access to swap is 100 to 1000 times slower than to RAM. Because of that swap is only useful to prevent data loss, when RAM is overloaded. Get at least 4 GiB of RAM. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Mail filter not appearing
On 01 Jun 2015, at 10:57, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Am 2015-05-29 um 15:34 schrieb car.cue...@protonmail.com: Thanks again for replying Christian, Well about this Error: May 29 10:08:12 sogod [16521]: 0x0x7f02b7276e90[SOGoCache] an error occurred when caching value for key 'exam...@mailexample.com+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY I read that it can be caused, because some parameters to have them not so well adjusted: for example: WOWorkersCount = 10; // Memcached SOGoMemcachedHost = 127.0.0.1; But actually, it seems that this part I have well configured; I am thinking more that this can be caused because I am using one of the minimum digitalOcean VM (512Mb Ram + 768Mb swap)... What I am not sure is about the consequences of this error. Did you actually start memcached? If not, this is your error. Consequences will be: - SOGo will be really really really slow - Your DB accesses will increase You do not want it to swap at all! Access to swap is 100 to 1000 times slower than to RAM. Because of that swap is only useful to prevent data loss, when RAM is overloaded. Get at least 4 GiB of RAM. I believe swap is used in this case since it is *cheap* replacement of RAM in cloud environment. 4GB RAM on DigitalOcean will cost considerably more than 512MB … I was successfully running SOGo with 512MB RAM + 512MB swap for single human user (+ 1 machine user only doing email). There were 3 concurrent connections from 3 devices for this user, was not using EAS though. Migrated to Amazon EC2 where minimum instance is 1GB RAM since then … so no current experience with 512MB RAM. Best Regards Martin. smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Contact Uploading on SoGo
Hello Am 2015-06-01 um 03:57 schrieb Kevin Laurie: Hello, Is there any tutorial on how to upload contacts onto SoGo. I am quite new to CardDAV and would appreciate if someone could provide help or tutorial on how do I upload customers onto SoGo. I have them in vard format. Request for help. There is no official SOGo User Manual from Inverse. But there are several out there. Import of address cards: Open your SOGo in your browser. Login to SOGo. Click on Adress Book in the main bar. Right click on the address book you want to import your address cards (e.g. Personal Adddress book). Choose Import Cards. Select the file with your address cards. Press Upload. Wait till SOGo has done its work. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Contact Uploading on SoGo
Dear Christian, Thanks for helping me earlier here. I am using Roundcube 1.0.4 . Would I need additional plugins for roundcube to see contacts of SoGo? Or would it integrate? If I do need one, I am going to be using the plugin listed below:- https://github.com/christian-putzke/Roundcube-CardDAV But I am not sure how to run this command:- * Execute SQL statements from /plugins/carddav/SQL/yourDatabase.sql Not much experience in sql so appreicate if you could help by telling me how to execute this? Appreciate it. Thanks Kevin On Mon, Jun 1, 2015 at 5:20 PM, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Am 2015-06-01 um 03:57 schrieb Kevin Laurie: Hello, Is there any tutorial on how to upload contacts onto SoGo. I am quite new to CardDAV and would appreciate if someone could provide help or tutorial on how do I upload customers onto SoGo. I have them in vard format. Request for help. There is no official SOGo User Manual from Inverse. But there are several out there. Import of address cards: Open your SOGo in your browser. Login to SOGo. Click on Adress Book in the main bar. Right click on the address book you want to import your address cards (e.g. Personal Adddress book). Choose Import Cards. Select the file with your address cards. Press Upload. Wait till SOGo has done its work. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Contact Uploading on SoGo
Dear Christian, Thanks! Will try. Thanks. Its my first time getting used to doing this Appreciate your swift feedback. Regards Kevin A. On Mon, Jun 1, 2015 at 5:20 PM, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Am 2015-06-01 um 03:57 schrieb Kevin Laurie: Hello, Is there any tutorial on how to upload contacts onto SoGo. I am quite new to CardDAV and would appreciate if someone could provide help or tutorial on how do I upload customers onto SoGo. I have them in vard format. Request for help. There is no official SOGo User Manual from Inverse. But there are several out there. Import of address cards: Open your SOGo in your browser. Login to SOGo. Click on Adress Book in the main bar. Right click on the address book you want to import your address cards (e.g. Personal Adddress book). Choose Import Cards. Select the file with your address cards. Press Upload. Wait till SOGo has done its work. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v2.3.0
What's missing when we see the following? The following packages have been kept back: libldb-dev libldb1 libmapi0 libmapiproxy0 libmapistore0 libnss-winbind libpam-winbind libsmbclient libwbclient0 openchangeproxy openchangeserver python-ldb python-ocsmanager python-samba samba samba-common samba-common-bin samba-dev samba-dsdb-modules samba-libs samba-vfs-modules smbclient sogo sogo-activesync sogo-openchange winbind 0 upgraded, 0 newly installed, 0 to remove and 26 not upgraded. And, I presume 'sql-update-2.2.17_to_2.3.0.sh' is part of the SOGo packages? On 06/01/2015 02:51 PM, Ludovic Marcotte wrote: Upgrading to v2.3.0 Run the shell scriptsql-update-2.2.17_to_2.3.0.shorsql-update-2.2.17_to_2.3.0-mysql.sh(if you use MySQL). This will grow the participant states field of calendar quick tables to a larger size and add the the c_description column to calendar quick tables. Moreover, if you are using a multi-domain configuration, make sure the keys for your domains match the email domains you have defined. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] ANN: SOGo v2.3.0
The Inverse Team is pleased to announce the immediate availability of SOGo 2.3.0. This is a major release of SOGo which focuses on improved stability over previous versions. What is SOGo SOGo is a free and modern scalable groupware server. It offers shared calendars, address books and emails through your favorite Web browser or by using a native client such as Mozilla Thunderbird and Lightning, Apple Calendar and Address Book (Mac OS X and iOS) and Microsoft Outlook.SSOGo is standard-compliant and supports CalDAV, CardDAV and reuses existing IMAP, SMTP and database servers - making the solution easy to deploy and interoperable with many applications. SOGo features: * Scalable architecture suitable for deployments from dozen to many thousand users * Rich Web-based interface that shares the look and feel, the features and the data of Mozilla Thunderbird and Lightning * Improved integration with Mozilla Thunderbird and Lightning by using the SOGo Connector and the SOGo Integrator * Native compatibility for Microsoft Outlook 2003, 2007, 2010 and 2013 * Two-way synchronization support with any Microsoft ActiveSync-capable device (Apple iOS, Android, Windows Phone, BlackBerry 10) or Outlook 2013 * Excellent native integration with Apple software (Mac OS X and iOS) and Android-based devices and many more! SOGo and our connectors are completely free. Changes from the previous release *New features* * Debian 8 (Jessie) support * RHEL / CentOS 7 support * Internet headers are now shown in Outlook (Zentyal) *Enhancements* * improved multipart handling using EAS * added systemd startup script (PR#76) * added Basque translation - thanks to Gorka Gonzalez * updated Brazilian (Portuguese), Dutch, Norwegian (Bokmal), Polish, Russian, and Spanish (Spain) translations * calendar sharing request support among different Outlook versions (Zentyal) * improve sync speed from Outlook by non-reprocessing already downloaded unread mails (Zentyal) * added support for sharing calendar invitations * missing contact fields are now saved and available when sharing it (Office, Profession, Manager's name, Assistant's name, Spouse/Partner, Anniversary) (Zentyal) * appointment color and importance work now between Outlooks (Zentyal) * synchronize events, contacts and tasks in reverse chronological order (Zentyal) * during login, we now extract the domain from the user to accelerate authentication requests on sources * make sure sure email invitations can always be read by EAS clients * now able to print event/task's description (new components only) in the list view (#2881) * now possible to log EAS commands using the SOGoEASDebugEnabled system defaults * many improvements to EAS SmartReply/SmartForward commands * event invitation response mails from Outlook are now sent * mail subfolders created in webmail are created when Outlook synchronises * mail root folder created in webmail (same level INBOX) are created on Outlook logon *Bug fixes* * now keep the BodyPreference for future EAS use and default to MIME if none set (#3146) * EAS reply fix when message/rfc822 parts are included in the original mail (#3153) * fixed yet an other potential crash during freebusy lookups during timezone changes * fixed display of freebusy information in event attendees editor during timezone changes * fixed timezone of MSExchange freebusy information * fixed a potential EAS error with multiple email priority flags * fixed paragraphs margins in HTML messages (#3163) * fixed regression when loading the inbox for the first time * fixed serialization of the PreventInvitationsWhitelist settings * fixed md4 support (for NTLM password changes) with GNU TLS * fixed edition of attachment URL in event/task editor * sent mails are not longer in Drafts folder using Outlook (Zentyal) * deleted mails are properly synced between Outlook profiles from the same account (Zentyal) * does not create a mail folder in other user's mailbox (Zentyal) * fix server-side crash with invalid events (Zentyal) * fix setting permissions for a folder with several users (Zentyal) * fix reception of calendar event invitations on optional attendees (Zentyal) * fix server side crash parsing rtf without color table (Zentyal) * weekly recurring events created in SOGo web interface are now shown in Outlook (Zentyal) * fix exception modifications import in recurrence series (Zentyal) * fix server side crash parsing rtf emails with images (with word97 format) (Zentyal) * fix sender on importing email messages like event invitations (Zentyal) * fix Outlook crashes when modifying the view of a folder (Zentyal) * fix server side crash when reading some recurrence appointments (Zentyal) * Outlook clients can use reply all functionality on multidomain environment (Zentyal) * optional attendes on events are now shown
Re: [SOGo] ANN: SOGo v2.3.0
2015-06-01 21:36 keltezéssel, Steve Ankeny írta:
What's missing when we see the following?
The following packages have been kept back:
libldb-dev libldb1 libmapi0 libmapiproxy0 libmapistore0 libnss-winbind
libpam-winbind libsmbclient libwbclient0 openchangeproxy
openchangeserver
python-ldb python-ocsmanager python-samba samba samba-common
samba-common-bin samba-dev samba-dsdb-modules samba-libs
samba-vfs-modules
smbclient sogo sogo-activesync sogo-openchange winbind
0 upgraded, 0 newly installed, 0 to remove and 26 not upgraded.
And, I presume 'sql-update-2.2.17_to_2.3.0.sh' is part of the SOGo
packages?
... or the postinstall script will detect and run it automatically?
On 06/01/2015 02:51 PM, Ludovic Marcotte wrote:
Upgrading to v2.3.0
Run the shell
scriptsql-update-2.2.17_to_2.3.0.shorsql-update-2.2.17_to_2.3.0-mysql.sh(if
you use MySQL).
This will grow the participant states field of calendar quick
tables to a larger size and add the the c_description column to
calendar quick tables.
Moreover, if you are using a multi-domain configuration, make sure
the keys for your domains match the email domains you have defined.
I don't clearly understand the red part...
Example, if I have...
domains = {
*domain1*= {
SOGoMailDomain = *domain1.tld*;
SOGoUserSources = (
{
...
}
);
};
*domain2*= {
SOGoMailDomain = *domain2.tld*;
SOGoUserSources = (
{
...
}
);
};
};
... then I need to rename keys from domainX to domainX.tld before upgrading?
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v2.3.0
On 01/06/2015 16:09, Szládovics Péter wrote: ... then I need to rename keys from domainX to domainX.tld before upgrading? Yes. -- 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] ANN: SOGo v2.3.0
Can I go ahead and install these packages without incident? Then run the sql-update script after upgrade? On 06/01/2015 04:09 PM, Szládovics Péter wrote: 2015-06-01 21:36 keltezéssel, Steve Ankeny írta: What's missing when we see the following? The following packages have been kept back: libldb-dev libldb1 libmapi0 libmapiproxy0 libmapistore0 libnss-winbind libpam-winbind libsmbclient libwbclient0 openchangeproxy openchangeserver python-ldb python-ocsmanager python-samba samba samba-common samba-common-bin samba-dev samba-dsdb-modules samba-libs samba-vfs-modules smbclient sogo sogo-activesync sogo-openchange winbind 0 upgraded, 0 newly installed, 0 to remove and 26 not upgraded -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v2.3.0
2015-06-01 22:21 keltezéssel, Ludovic Marcotte írta: On 01/06/2015 16:09, Szládovics Péter wrote: ... then I need to rename keys from domainX to domainX.tld before upgrading? Yes. Thanks! They'll be. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problem deleting meeting
I have been able to reproduce this, and am looking for validation before submitting a bug report: Version 2.2.17a User 1, Calendar 1 User 2, Calendar 2 User 1 has full privileges to Calendar 2. User 1 creates a new event on Calendar 2 (while logged in as User 1) and then invites herself (User 1) to the event. User 1 then accepts the invitation on Calendar 1. Circumstances change and the event needs to be cancelled. User 1 selects the event on Calendar 2 and deletes it. The event disappears from Calendar 2, and initially from Calendar 1, but reappears on Calendar 1 on the next browser reload and has to manually deleted from Calendar 2. I hope that makes sense… Thanks, Romeyn -- signat-url: http://www2.potsdam.edu/prescor/signat-url.htm -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v2.3.0
On Jun 2, 2015, at 2:51 AM, Ludovic Marcotte lmarco...@inverse.ca wrote: Upgrading to v2.3.0 Document http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf still mentions SOGo-2.2.8, as i can remember, we don't have v2.2.8, right? Zhang Huangbin, founder of iRedMail project: http://www.iredmail.org/ -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Monday, June 01 2015
Title: BTS activities for Monday, June 01 2015 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Monday, June 01 2015 idlast updatestatus (resolution)categorysummary 3222 2015-06-01 07:49:19 updated (open) Backend General Unable to connect to PostgreSQL when specifying link with 127.0.0.1 3224 2015-06-01 22:29:38 updated (open) Packaging (RedHat) Cannot start SOGo service on CentOS 7 3223 2015-06-01 13:41:14 updated (open) sogo-tool SOGo Connector Thunderbird 31.0.1 broken for Thunderbird 31.7 2951 2015-06-01 08:28:53 updated (open) Web Mail the new menu Search in the interface of the mail 3225 2015-06-01 22:32:44 updated (open) with SOGo Cannot login to SOGo web interface: didn't set return value for type 'v'
