[SOGo] openchange_provision search for MySQLdb
Good morninig, I am trying to add native Outlook support and I have problem with running openchange_provision. it searches fom mysql but setup is done with postgresql. Here is the error: :/etc/samba# openchange_provision Traceback (most recent call last): File /usr/sbin/openchange_provision, line 30, in module import openchange.provision as openchange File /usr/lib/python2.7/dist-packages/openchange/provision.py, line 22, in module from openchange import mailbox File /usr/lib/python2.7/dist-packages/openchange/mailbox.py, line 28, in module import MySQLdb ImportError: No module named MySQLdb Thanks for tips! BTW: Is setup possible with remote samba 4 AD-DC? Looks like samba 4 still have soem problems with replication DC. :( Kind regards, Jan -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Recommended setup?
users-requ...@sogo.nu wrote on 23.11.2014 17:53:28: As SOGo does not include any kind of user management, you need an existing user source that holds the user credentials (e.g., mail address, name, password). This could be either a MySQL/PostgreSQL Database or LDAP. Since you have a running Postfix + Dovecot setup you're probably having such a user source for virtual mail users already (Check your Postfix and Dovecot configuration). SOGo must be configured to use that existing user source for authentication. I suggest you use an So far I had my server running with OS accounts only but have added MySQL and configured vmail yesterday and moved the accounts into it. Fortunately, no real user data in them, yet. So I guess I can now try to add SOGo to it, finally. Kai-Uwe Rommel kai-uwe.rom...@ars.de Telefon+Mobil +49 89 32468-120 ARS Computer und Consulting GmbH, http://www.ars.de Ridlerstrasse 55, 80339 Muenchen, Deutschland Application Development Services, Business Transformation Services, IT Infrastruktur Services Beratung und Vertrieb zu IBM Software, System x, POWER Systems, Storage License Management Services, IBM Passport Advantage Lizenzierung Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909 Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock, Joachim Gucker -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Recommended setup?
users-requ...@sogo.nu wrote on 24.11.2014 08:16:37: For beginners (with 20 years of experience in other areas) there is also the sogo ZEG edition available. I know. The new version came out just a little too late. The previous version was very outdated, so I meanwhile installed my own mail server. I already did lots of work to it (SSL certificates and configuration as well as installation and configuration not only of Postfix and Dovecot but also Postgrey, ClamAV, SpamAssassin and MailScanner) which I did not want to redo to this plain new ZEG appliance. Kai-Uwe Rommel kai-uwe.rom...@ars.de Telefon+Mobil +49 89 32468-120 ARS Computer und Consulting GmbH, http://www.ars.de Ridlerstrasse 55, 80339 Muenchen, Deutschland Application Development Services, Business Transformation Services, IT Infrastruktur Services Beratung und Vertrieb zu IBM Software, System x, POWER Systems, Storage License Management Services, IBM Passport Advantage Lizenzierung Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909 Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock, Joachim Gucker -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] openchange_provision search for MySQLdb
Hi Jan, BTW: Is setup possible with remote samba 4 AD-DC? Looks like samba 4 still have soem problems with replication DC. :( We are running with three DC's here, and there are no replication problems. MJ -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] openchange ocsmanager
Hi, if I run /etc/init.d/openchange-ocsmanager start in log is error: ImportError: No module named mapistore Provisioning was OK. I use this documentation: http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf OS: scientific linux 6.6 SOGo - Nightly Build Could you give me some advice? Thanks -- S pozdravem Michal Boruvka -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] openchange_provision search for MySQLdb
On 25 Nov 2014, at 08:15, Jan Kraljič jan.kral...@gmail.com wrote: Good morninig, I am trying to add native Outlook support and I have problem with running openchange_provision. it searches fom mysql but setup is done with postgresql. Here is the error: :/etc/samba# openchange_provision Traceback (most recent call last): File /usr/sbin/openchange_provision, line 30, in module import openchange.provision as openchange File /usr/lib/python2.7/dist-packages/openchange/provision.py, line 22, in module from openchange import mailbox File /usr/lib/python2.7/dist-packages/openchange/mailbox.py, line 28, in module import MySQLdb ImportError: No module named MySQLdb Thanks for tips! BTW: Is setup possible with remote samba 4 AD-DC? Looks like samba 4 still have soem problems with replication DC. :( You are not saying what OS you are running on (assuming ubuntu), most likely you need to install python-mysqldb” with apt-get BTW, samba4 IS NOT having replication problems. Best Regards Martin. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] openchange_provision search for MySQLdb
On 11/25/2014 04:28 PM, Martin Simovic wrote: On 25 Nov 2014, at 08:15, Jan Kraljič jan.kral...@gmail.com mailto:jan.kral...@gmail.com wrote: I am trying to add native Outlook support and I have problem with running openchange_provision. it searches fom mysql but setup is done with postgresql. Here is the error: You are not saying what OS you are running on (assuming ubuntu), most likely you need to install python-mysqldb” with apt-get Yes, but that wouldnt solve his problem: he's got the system running on PGSQL, and OpenChange will use MySQL. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] openchange ocsmanager
Hi, I am currently facing the same issue with fresh installation of Centos 6. Regards -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] openchange_provision search for MySQLdb
So Do I need MySQL server also? That would be stupid. I am running Debian Wheezy, Samba from backports and Sogo nightly build. Samba replication is reporting: result 2 (WERR_BADFILE) On Tue, Nov 25, 2014 at 2:50 PM, Mihamina Rakotomandimby mihamina.rakotomandi...@rktmb.org wrote: On 11/25/2014 04:28 PM, Martin Simovic wrote: On 25 Nov 2014, at 08:15, Jan Kraljič jan.kral...@gmail.com wrote: I am trying to add native Outlook support and I have problem with running openchange_provision. it searches fom mysql but setup is done with postgresql. Here is the error: You are not saying what OS you are running on (assuming ubuntu), most likely you need to install python-mysqldb” with apt-get Yes, but that wouldnt solve his problem: he's got the system running on PGSQL, and OpenChange will use MySQL. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] openchange_provision search for MySQLdb
On 25/11/2014 10:44, Jan Kraljič wrote: So Do I need MySQL server also? That would be stupid. Since OpenChange v2.2, the indexing backend has moved towards MySQL for better performance. -- 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] LDAP auth when login is not cn (but uid)
Am 2014-11-25 um 16:35 schrieb ybarbe...@gmail.com:
Hello,
I want to authenticate with SOGO by an external LDAP server.
The problem I face is that the login of a user is not the cn field but the
uid.
For example, a user named John SMITH should identify with login johnsmit
(first 4 letters of first name followed by first 4 letters of last name).
My LDAP entries look like this:
dn: cn=John Smith,o=MyCompany,ou=People,dc=office,dc=mycompany,dc=be
objectClass: top
objectClass: posixAccount
objectClass: shadowAccount
objectClass: inetOrgPerson
objectClass: person
cn: John Smith
departmentNumber: Techniciens
description:: test
displayName: John SMITH
gecos: John SMITH
gidNumber: 5150
givenName: John
homeDirectory: /home/johnsmit
loginShell: /bin/bash
mail: john.sm...@mycompany.be
mail: johns...@mycompany.be
mobile: 0
o: MyCompany
sn: SMITH
telephoneNumber: 0
title: Assistant
uid: johnsmit
uidNumber: 5150
userPassword: {crypt}blablabla
The only way I have found so far is to replace all cn fields with the uid. In
the latter case, my dn would become:
dn: cn=johnsmit,o=MyCompany,ou=People,dc=office,dc=mycompany,dc=be
Is there any solution ther than modifying all my LDAP dn entries ?
Sure there is.
You have to change the settings in your SOGoUserSources.
In there set
bindFields = ( uid );
or
bindFields = (uid, cn, mail);
With the latter users can identify with uid or cn or email address.
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] LDAP auth when login is not cn (but uid)
Thank you for the quick answers.
I had already tried what Thierry suggested but that does not work in my
case.
What worked for me was:
bindFields = (uid, cn, mail);
and the possibility to identify by various means (email, uid, ...) is great!
Best regards,
Yannick
On 25 November 2014 at 17:01, Christian Mack christian.m...@uni-konstanz.de
wrote:
Am 2014-11-25 um 16:35 schrieb ybarbe...@gmail.com:
Hello,
I want to authenticate with SOGO by an external LDAP server.
The problem I face is that the login of a user is not the cn field but
the
uid.
For example, a user named John SMITH should identify with login johnsmit
(first 4 letters of first name followed by first 4 letters of last name).
My LDAP entries look like this:
dn: cn=John Smith,o=MyCompany,ou=People,dc=office,dc=mycompany,dc=be
objectClass: top
objectClass: posixAccount
objectClass: shadowAccount
objectClass: inetOrgPerson
objectClass: person
cn: John Smith
departmentNumber: Techniciens
description:: test
displayName: John SMITH
gecos: John SMITH
gidNumber: 5150
givenName: John
homeDirectory: /home/johnsmit
loginShell: /bin/bash
mail: john.sm...@mycompany.be
mail: johns...@mycompany.be
mobile: 0
o: MyCompany
sn: SMITH
telephoneNumber: 0
title: Assistant
uid: johnsmit
uidNumber: 5150
userPassword: {crypt}blablabla
The only way I have found so far is to replace all cn fields with the
uid. In
the latter case, my dn would become:
dn: cn=johnsmit,o=MyCompany,ou=People,dc=office,dc=mycompany,dc=be
Is there any solution ther than modifying all my LDAP dn entries ?
Sure there is.
You have to change the settings in your SOGoUserSources.
In there set
bindFields = ( uid );
or
bindFields = (uid, cn, mail);
With the latter users can identify with uid or cn or email address.
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
[SOGo] Re: Receiving error on Thunderbird Connector 31.0.0 contentAreaClick.js, line 62: imgs is undefined
Anyone run into this problem or similar? And if so, was there a resolution. thanks, Lewis On Sat, Nov 22, 2014 at 5:24 PM, Lewis Kaplan lewis.kap...@gmail.com wrote: I just upgraded to Connector 31.0.0 and I am not receiving and failure during sync attempts. After setting Thunderbird debugging on I get startup from sogo-connector *** new sync: 1 1/sync with https:/... exception getting pref 'extensions.ca.inverse.addressbook.groupdav.ldap_2.servers.pab.url': [Exception... Component returned failure code: 0x8000 (NS_ERROR_UNEXPECTED) [nsIPrefBranch.getCharPref] nsresult: 0x8000 (NS_ERROR_UNEXPECTED) location: JS frame :: chrome://sogo-connector/content/general/preference.service.addressbook.groupdav.js :: GdPSvc__getPref :: line 126 data: no] (126) exception getting pref 'extensions.ca.inverse.addressbook.groupdav.ldap_2.servers.history.url': [Exception... Component returned failure code: 0x8000 (NS_ERROR_UNEXPECTED) [nsIPrefBranch.getCharPref] nsresult: 0x8000 (NS_ERROR_UNEXPECTED) location: JS frame :: chrome://sogo-connector/content/general/preference.service.addressbook.groupdav.js :: GdPSvc__getPref :: line 126 data: no] (126) JavaScript error: chrome://communicator/content/contentAreaClick.js, line 62: imgs is undefined GOT STATUS: 207 new card '' will be uploaded ctag matches or drop operation GETTING BUSY NOTICE: uploading new vcard with empty key GOT STATUS: 403 GOT STATUS: 207 1/sync with https:/... I am Thunderbird 31.2.0 on OSx Mavericks. My CardDAV server is OSX Server on the same machine. Any ideas? thank you, Lewis -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] link to this calendar url
Hi, Quick question: we've just updated to 2.2.10, and I noticed something new (to me), namely in the webaccess: * rightclick a calendar, properties, links to this calendar tab: the first caldav URL is no longer a clickable url, but instead a fully written out address, which we cannot right-click to 'save link as'. Is this something new? Is it a bug, or perhaps a 'feature'..? MJ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] link to this calendar url
Hi MJ On Nov 25, 2014, at 2:34 PM, heupink heup...@gmail.com wrote: Quick question: we've just updated to 2.2.10, and I noticed something new (to me), namely in the webaccess: * rightclick a calendar, properties, links to this calendar tab: the first caldav URL is no longer a clickable url, but instead a fully written out address, which we cannot right-click to 'save link as'. Is this something new? Is it a bug, or perhaps a 'feature'..? The links were removed a few releases ago. People were clicking on them and wondering why they were receiving an 500 HTTP error in their browser :/ Francis-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] link to this calendar url
Am 25.11.2014 20:44, schrieb Francis Lachapelle: Hi MJ On Nov 25, 2014, at 2:34 PM, heupink heup...@gmail.com wrote: Quick question: we've just updated to 2.2.10, and I noticed something new (to me), namely in the webaccess: * rightclick a calendar, properties, links to this calendar tab: the first caldav URL is no longer a clickable url, but instead a fully written out address, which we cannot right-click to 'save link as'. Is this something new? Is it a bug, or perhaps a 'feature'..? The links were removed a few releases ago. People were clicking on them and wondering why they were receiving an 500 HTTP error in their browser :/ Francis-- users@sogo.nu https://inverse.ca/sogo/lists can't you script that one to be downloadable only? alo rescript your login thing ;) we want to save passes have fun! -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] link to this calendar url
Hi Francis, The links were removed a few releases ago. People were clicking on them and wondering why they were receiving an 500 HTTP error in their browser :/ hahaha, really?? Hmm... this 'solution' is a bit 'half'... leaving two of the three links in place... Anyway: if this made the users complains disappear...? :-) For the rest: 2.2.10 is looking great here. MJ -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Tuesday, November 25 2014
Title: BTS activities for Tuesday, November 25 2014 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Tuesday, November 25 2014 idlast updatestatus (resolution)categorysummary 2982 2014-11-25 09:21:57 updated (open) ActiveSync Outlook 2013 with ActiveSync fails to move email between folders 2992 2014-11-25 16:10:47 updated (open) ActiveSync WP8 activesync problem 2999 2014-11-25 10:10:44 updated (open) ActiveSync Outlook initial activesync breaks with NSConstantString(instance) does not recognize bytes INFO:(null) 2997 2014-11-25 06:46:55 updated (open) Backend General SOGoSubscriptionFolderFormat in /etc/sogo/sogo.conf not loaded 2998 2014-11-25 09:30:34 updated (open) Web Address Book [Thunderbird 31.2.0] Sending information to ownCloud doesn't work 2990 2014-11-25 09:28:08 assigned (reopened) with SOGo Does not work with Thunderbird 31.2.0
