[SOGo] Initicial configuration sogo
Hi I have instaled SOGO in Debian Squeeze 6 with apt-get install sogo, I'm be able to view the url http://sogerserver:2 but I'm not able to conect with any user, I need to conect SOGO with LDAP Window server, but I don't be able, I try to read how to, but I'm not sure how to conect with a DC with IP 10.28.0.24 and domain: elmio.com.es Otherwise how can I create an user to sogo? And How is the administrative user to sogo? I know that an user sogo was created during the instalacition, but how can I used it to configurate SOgo? Thank you very much!! Mikel Gilsanz Prieto Responsable Dpto. Sistemas / IT Manager Gran Vía 81, 8º, Dpto. 9 48011 Bilbao +34944415140 (Ext. 204) +34650049384 +34944415192 mgils...@grupoavalon.es www.grupoavalon.es Este mensaje se dirige exclusivamente a su destinatario y puede contener información privilegiada o confidencial. Si no es Vd. el destinatario indicado, queda notificado de que la utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción. Le informamos que su dirección de correo electrónico, así como el resto de los datos de carácter personal aportados, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad de gestionar la agenda de contactos de nuestra entidad y poder atender a sus peticiones. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica 15/1999 mediante notificación a i...@avalon.com.es Antes de imprimir este mensaje, piense si es necesario. El medio ambiente está en nuestras manos. attachment: arbolito.gifattachment: fax.gifattachment: movil.gifattachment: tfno.gifattachment: AvalonimagenFirma.jpg
Re: [SOGo] Initicial configuration sogo
Hello, Am 06.03.2012 09:44, schrieb Mikel: Hi I have instaled SOGO in Debian Squeeze 6 with apt-get install sogo, I'm be able to view the url http://sogerserver:2 but I'm not able to conect with any user, Don't use port 2 to connect, you have to go via a frontend webserver like apache. A apache config is also included in the sogo install I need to conect SOGO with LDAP Window server, but I don't be able, I try to read how to, but I'm not sure how to conect with a DC with IP 10.28.0.24 and domain: elmio.com.es Otherwise how can I create an user to sogo? And How is the administrative user to sogo? I know that an user sogo was created during the instalacition, but how can I used it to configurate SOgo? No, none was created. You need to configure the user source, like ldap or mysql In Sogo there is no admin interface to create/modify users. André -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo not searching LDAP tree recursively
Hi,
we have configured the sogo connection to our LDAP server as follows:
defaults write sogod SOGoUserSources '({CNFieldName = cn;
IDFieldName = uid; UIDFieldName = uid;
baseDN = dc=neurologie.uni-tuebingen.de,dc=local;
bindDN =
uid=sogo,ou=Users,ou=EDV,ou=HIH,dc=neurologie.uni-tuebingen.de,dc=local;
bindPassword = ; canAuthenticate = YES; displayName =
Addresses; hostname = localhost; id = local;
isAddressBook = YES; port=389; filter = (objectClass=person); scope =
SUB})'
Still, sogo can find only persons in the baseDN level, not in ou's below
this.
What are we doing wrong?
How are the privileges set for user
uid=sogo,ou=Users,ou=EDV,ou=HIH,dc=neurologie.uni-tuebingen.de,dc=local
in your LDAP?
Does he have read permissions on all ou-Levels up to ou=Users?
Does he have read permissions on the user entries in ou=Users?
I did an apt-get update/upgrade an checked the LDAP permissions:
olcDatabase={1}hdb.ldif:
dn: olcDatabase={2}hdb
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {2}hdb
olcDbDirectory: /var/lib/ldap
olcSuffix: dc=neurologie.uni-tuebingen.de,dc=local
olcAccess: {0}to * by dn=cn=admin,dc=neurologie.uni-tuebingen.de,dc=local
write by * read
olcAccess: {1}to * attrs=userPassword,shadowLastChange by
dn=cn=admin,dc=neurologie.uni-tuebingen.de,dc=local write by anonymous auth
by self write by * none
olcAccess: {2}to dn.base= by * read
olcLastMod: TRUE
olcRootDN: cn=admin,dc=neurologie.uni-tuebingen.de,dc=local
...
Now sogo seems not to be able to bind anymore:
.GNUstepDefaults:
keySOGoUserSources/key
array
dict
keyCNFieldName/key
stringcn/string
keyIDFieldName/key
stringuid/string
keyUIDFieldName/key
stringuid/string
keybaseDN/key
stringdc=neurologie.uni-tuebingen.de,dc=local/string
keybindDN/key
stringuid=sogo,ou=Users,ou=EDV,ou=HIH,dc=neurologie.uni-tuebingen.de,dc=local/string
keybindPassword/key
string***/string
keycanAuthenticate/key
stringYES/string
keydisplayName/key
stringAddresses/string
keyhostname/key
stringlocalhost/string
keyid/key
stringpublic/string
keyisAddressBook/key
stringYES/string
keyport/key
string389/string
keyscope/key
stringSUB/string
sogo.log:
Mar 06 09:58:47 sogod [4778]: SOGoRootPage Login for user 'fbunjes' might not
have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
localhost - - [06/Mar/2012:09:58:47 GMT] POST /SOGo/connect HTTP/1.1 403
34/42 0.025 - - 2M
Best,
Friedemann
Kind regards,
Christian Mack
--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
Dr. rer. nat. Friedemann Bunjes
Hertie-Institut für Klinische Hirnforschung
Zentrum für Neurologie
Universitätsklinikum Tübingen
Otfried-Müller-Str. 27
72076 Tübingen
+49-7071-29-81999
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Initicial configuration sogo
But I'm not be able to go via Apache, I try it to put in webbroser http://sogoserver And there is nothing. Mikel Gilsanz Prieto Responsable Dpto. Sistemas / IT Manager Gran Vía 81, 8º, Dpto. 9 48011 Bilbao +34944415140 (Ext. 204) +34650049384 +34944415192 mgils...@grupoavalon.es www.grupoavalon.es Este mensaje se dirige exclusivamente a su destinatario y puede contener información privilegiada o confidencial. Si no es Vd. el destinatario indicado, queda notificado de que la utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción. Le informamos que su dirección de correo electrónico, así como el resto de los datos de carácter personal aportados, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad de gestionar la agenda de contactos de nuestra entidad y poder atender a sus peticiones. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica 15/1999 mediante notificación a i...@avalon.com.es Antes de imprimir este mensaje, piense si es necesario. El medio ambiente está en nuestras manos. El mar, 06-03-2012 a las 09:57 +0100, André Schild escribió: Hello, Am 06.03.2012 09:44, schrieb Mikel: Hi I have instaled SOGO in Debian Squeeze 6 with apt-get install sogo, I'm be able to view the url http://sogerserver:2 but I'm not able to conect with any user, Don't use port 2 to connect, you have to go via a frontend webserver like apache. A apache config is also included in the sogo install I need to conect SOGO with LDAP Window server, but I don't be able, I try to read how to, but I'm not sure how to conect with a DC with IP 10.28.0.24 and domain: elmio.com.es Otherwise how can I create an user to sogo? And How is the administrative user to sogo? I know that an user sogo was created during the instalacition, but how can I used it to configurate SOgo? No, none was created. You need to configure the user source, like ldap or mysql In Sogo there is no admin interface to create/modify users. André attachment: arbolito.gifattachment: fax.gifattachment: movil.gifattachment: tfno.gifattachment: AvalonimagenFirma.jpg
Re: [SOGo] LDAP filter for group decomposing
hi is there anyone with a solution here? should I file a bug for this? I even tried to massage the ldap suffix, so that ou=personen,ou=intern.. appears as ou=personen,ou=sogo,ou=intern.. and then set the base DN to ou=sogo,ou=intern.. with subbranches users,groups,ressources and locations, but it didn't take. searching with type SUB does not work for some reason, only a direct search of the branch. this is a bit of a pain, cos it would mean a hack in /etc/ldap.ini for example, or some other way to circumvent it, avoiding moving ldap branches around.. greets hugo.- Am 02/14/2012 03:17 PM, schrieb Bruno Lingner (Hugo): hi list I see some strange behaviour with the groups in sogo. first search is using the configured filter in the .GNUstepDefaults. then it searches again, to try to decompose it to its list of members, but this time it doesn't use the configured filter :( I have to set the search path to a higher level (ou=intern,dc=example,dc=com), because the user accounts are here: ou=personen,ou=intern,dc=example,dc=com and the sogo groups/ressources/locations are defined here: ou=sogo,ou=intern,dc=example,dc=com but because we have other groups defined as e.g: ou=sendmail,ou=intern,dc=example,dc=com which is neither one of the objectClasses that sogo sees as groups. the last search for looking up group members, is something like: SRCH base=ou=intern,dc=example,dc=com scope=2 deref=0 filter=(mail=supp...@example.com) and so it finds 2 results, one from ou=sendmail.. and one from ou=sogo.. therefore it doesn't decompose the groups properly. is it possible to change the code so it searches both times using the right filter I configured, or perhaps to search for the full DN of the group (result of the first search) the second time? LDAP debug info: --- here I search for the group in the Add Attendees window: Feb 14 14:31:02 odalix slapd[7094]: conn=1018 fd=17 ACCEPT from IP=127.0.0.1:45720 (IP=0.0.0.0:389) Feb 14 14:31:02 odalix slapd[7094]: conn=1018 op=0 BIND dn= method=128 Feb 14 14:31:02 odalix slapd[7094]: conn=1018 op=0 RESULT tag=97 err=0 text= Feb 14 14:31:02 odalix slapd[7094]: conn=1018 op=1 SRCH base=ou=intern,dc=example,dc=com scope=2 deref=0 filter=((|(sn=support*)(cn=support*)(uid=support*)(mail=support*))((objectClass=KuPPerson)(KuPaktiv=aktiv)(mail=*)(!(ou:dn:=sendmail Feb 14 14:31:02 odalix slapd[7094]: conn=1018 op=1 SRCH attr=objectClass cn uid mail title company o displayname modifytimestamp mozillahomestate mozillahomeurl homeurl st region mozillacustom2 custom2 mozillahomecountryname description notes department departmentnumber ou orgunit mobile cellphone carphone mozillacustom1 custom1 mozillanickname xmozillanickname mozillaworkurl workurl fax facsimiletelephonenumber telephonenumber mozillahomestreet mozillasecondemail xmozillasecondemail mozillacustom4 custom4 nsaimid nscpaimscreenname street streetaddress postofficebox homephone cn commonname givenname mozillahomepostalcode mozillahomelocalityname mozillaworkstreet2 mozillausehtmlmail xmozillausehtmlmail mozillahomestreet2 postalcode zip c countryname pager pagerphone mail sn surname mozillacustom3 custom3 l locality birthyear serialnumber calfburl proxyaddresses msExchHomeServerName kind multiplebookings Feb 14 14:31:02 odalix slapd[7094]: conn=1018 op=1 SEARCH RESULT tag=101 err=0 nentries=1 text= Feb 14 14:31:02 odalix slapd[7094]: conn=1018 op=2 UNBIND Feb 14 14:31:02 odalix slapd[7094]: conn=1018 fd=17 closed --- here I save the appointment: Feb 14 14:31:12 odalix slapd[7094]: conn=1019 fd=17 ACCEPT from IP=127.0.0.1:45724 (IP=0.0.0.0:389) Feb 14 14:31:12 odalix slapd[7094]: conn=1019 op=0 BIND dn= method=128 Feb 14 14:31:12 odalix slapd[7094]: conn=1019 op=0 RESULT tag=97 err=0 text= Feb 14 14:31:12 odalix slapd[7094]: conn=1019 op=1 SRCH base=ou=intern,dc=example,dc=com scope=2 deref=0 filter=(mail=supp...@example.com) Feb 14 14:31:12 odalix slapd[7094]: conn=1019 op=1 SRCH attr=objectClass cn uid mail title company o displayname modifytimestamp mozillahomestate mozillahomeurl homeurl st region mozillacustom2 custom2 mozillahomecountryname description notes department departmentnumber ou orgunit mobile cellphone carphone mozillacustom1 custom1 mozillanickname xmozillanickname mozillaworkurl workurl fax facsimiletelephonenumber telephonenumber mozillahomestreet mozillasecondemail xmozillasecondemail mozillacustom4 custom4 nsaimid nscpaimscreenname street streetaddress postofficebox homephone cn commonname givenname mozillahomepostalcode mozillahomelocalityname mozillaworkstreet2 mozillausehtmlmail xmozillausehtmlmail mozillahomestreet2 postalcode zip c countryname pager pagerphone mail sn surname mozillacustom3 custom3 l locality birthyear serialnumber calfburl proxyaddresses msExchHomeServerName kind multiplebookings member uniqueMember memberUid memberOf Feb 14 14:31:12 odalix slapd[7094]: conn=1019 op=1 SEARCH RESULT tag=101 err=0 nentries=2 text= Feb 14 14:31:12 odalix slapd[7094]: conn=1019 op=2 UNBIND
[SOGo] the nightly builds for RHEL5 seems incomplete
Hi, I would like to install sogo from the nightly build on RHEL5. So I installed the nightly repo: [sogo-nightly-rhel5] name=Inverse SOGo nightly-build Repository baseurl=http://inverse.ca/downloads/SOGo/RHEL5/nightly/$basearch gpgcheck=0 But it doesn't give me (for example) sogo*.rpm When I check the URL: http://www.sogo.nu/files/downloads/SOGo/RHEL5/nightly/x86_64/RPMS I only get the following files: all-rpms.tar gnustep-base-1.23.0-1.x86_64.rpm gnustep-base-devel-1.23.0-1.x86_64.rpm gnustep-make-2.6.1-1.x86_64.rpm libffi-3.0.6-1.x86_64.rpm libffi-devel-3.0.6-1.x86_64.rpm libmemcached-0.34-1.x86_64.rpm libmemcached-devel-0.34-1.x86_64.rpm samba4-4.0.0-1.alpha17.el5.5.x86_64.rpm samba4-4.0.0-1.alpha18.el5.5.x86_64.rpm samba4-debuginfo-4.0.0-1.alpha18.el5.5.x86_64.rpm Is the nightly repository for RHEL5 broken or am I missing something? BR, Eelco -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] dovecot centos examples?
Dear SOGo users! Does anybody use SOGo with dovecot on CentOS (or other machines)? Could you please show me any hints/examples on dovecot configuration, especially for making shared INBOX-es? Do you have any Outlook clients via OpenChange for that configuration? Thank you, Denis Medvedev -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] subscribing external ICS calendar via webapp doesnt work with unspecified error
Hi Christian Hi Peter Schmidt On 2012-03-01 16:51, Peter Schmidt wrote: I'm trying to subscribe an external calendar (ICS format) via the web frontend. Thunderbird can subscribe it directly, google calendar can subsribe it too, but sogo refuses the calendar stating an (unspecified) error during import. I could not find any further information in the logs (/var/log/sogo/sogo.log and any of the apache/tomcat logs). Possible reasons i found: 1. SSL When i tried to fetch the url with wget, i found out that due to an internal redirection, the host changes and so the SSL certificate is not correct. Downloading the file with firefox does not show the certificate error. Is this a SSL issue (then there should be a proper warning and a possibility to add exceptions to that)? Perhaps this is causing your problem. You also get this behaviour, if the remote calendar is not world readable. SOGo can't handle authentication (yet) for web calendars. The calendar is world readable. Neither Firefox, nor Thunderbird complain about the SSL-Issue. I only found this when directly fetching it with wget, so obviously it is a usually tolerated ssl-warning (because of a serverside redirect to subhost.host.domain.com instead of host.domain.com). If it is really an SSL-issue then there should be a way to disable SSL checks, because i am sure there are hundreds of self-signed or other certificates out there. Anyway: If it was an SSL issue, there should be a proper warning. Is there some way to run sogo in debug mode to get the right errormessage to proof that it is an SSL related issue? Thanks so far! Kind regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] subscribing external ICS calendar via webapp doesnt work with unspecified error
On 2012-03-06 16:18, Peter Schmidt wrote: Hi Christian Hi Peter Schmidt On 2012-03-01 16:51, Peter Schmidt wrote: I'm trying to subscribe an external calendar (ICS format) via the web frontend. Thunderbird can subscribe it directly, google calendar can subsribe it too, but sogo refuses the calendar stating an (unspecified) error during import. I could not find any further information in the logs (/var/log/sogo/sogo.log and any of the apache/tomcat logs). Possible reasons i found: 1. SSL When i tried to fetch the url with wget, i found out that due to an internal redirection, the host changes and so the SSL certificate is not correct. Downloading the file with firefox does not show the certificate error. Is this a SSL issue (then there should be a proper warning and a possibility to add exceptions to that)? Perhaps this is causing your problem. You also get this behaviour, if the remote calendar is not world readable. SOGo can't handle authentication (yet) for web calendars. The calendar is world readable. Neither Firefox, nor Thunderbird complain about the SSL-Issue. I only found this when directly fetching it with wget, so obviously it is a usually tolerated ssl-warning (because of a serverside redirect to subhost.host.domain.com instead of host.domain.com). If it is really an SSL-issue then there should be a way to disable SSL checks, because i am sure there are hundreds of self-signed or other certificates out there. Anyway: If it was an SSL issue, there should be a proper warning. Is there some way to run sogo in debug mode to get the right errormessage to proof that it is an SSL related issue? Thanks so far! For enhancing the debugging level see http://www.sogo.nu/english/nc/support/faq/article/how-to-enable-more-verbose-logging-in-sogo.html I would try SoSecurityManagerDebugEnabled Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Initicial configuration sogo
Hi Mikel, In the apache-config that you added there should be a line reading like e.g. ProxyPass /SOGo http://127.0.0.1:2000/SOGo If it looks like you have to try and go to http://yourserver/SOGo to get to the login Regards, Andreas Balg Am Dienstag, 06. Mrz 2012 10:16 CET, Mikel mgils...@grupoavalon.es schrieb: But Im not be able to go via Apache, I try it to put in webbroser http://sogoserver And there is nothing. Mikel Gilsanz Prieto Responsable Dpto. Sistemas / IT Manager Gran Va 81, 8, Dpto. 9 48011 Bilbao +34944415140 (Ext. 204) +34650049384 +34944415192 mgils...@grupoavalon.es www.grupoavalon.es Este mensaje se dirige exclusivamente a su destinatario y puede contener informacin privilegiada o confidencial. Si no es Vd. el destinatario indicado, queda notificado de que la utilizacin, divulgacin y/o copia sin autorizacin est prohibida en virtud de la legislacin vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma va y proceda a su destruccin. Le informamos que su direccin de correo electrnico, as como el resto de los datos de carcter personal aportados, sern objeto de tratamiento automatizado en nuestros ficheros, con la finalidad de gestionar la agenda de contactos de nuestra entidad y poder atender a sus peticiones. Vd. podr en cualquier momento ejercer el derecho de acceso, rectificacin, cancelacin y oposicin en los trminos establecidos en la Ley Orgnica 15/1999 mediante notificacin a i...@avalon.com.es Antes de imprimir este mensaje, piense si es necesario. El medio ambiente est en nuestras manos. El mar, 06-03-2012 a las 09:57 +0100, Andr Schild escribi: Hello, Am 06.03.2012 09:44, schrieb Mikel: Hi I have instaled SOGO in Debian Squeeze 6 with apt-get install sogo, Im be able to view the url http://sogerserver:2 but Im not able to conect with any user, Dont use port 2 to connect, you have to go via a frontend webserver like apache. A apache config is also included in the sogo install I need to conect SOGO with LDAP Window server, but I dont be able, I try to read how to, but Im not sure how to conect with a DC with IP 10.28.0.24 and domain: elmio.com.es Otherwise how can I create an user to sogo? And How is the administrative user to sogo? I know that an user sogo was created during the instalacition, but how can I used it to configurate SOgo? No, none was created. You need to configure the user source, like ldap or mysql In Sogo there is no admin interface to create/modify users. Andr
[SOGo] Sync multiple adressbooks / calendars using Funambol (V10)
Hi there, is there any chance to define the addressbook or calendar (or even more than one) that I want to sync to the clients if using Funambol or is it unchangeable to have it sync only the default addressbooks and calendars? Best regards, Andreas Balg
Re: [SOGo] SOGo Connector - carddav stops syncing after contacts-edit
Hi guys, Please retry by updating to sogo-connector 10.0.1pre1 from https://inverse.ca/downloads/extensions/nightly/ This should do the trick. W. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sync multiple adressbooks / calendars using Funambol (V10)
Hi Andreas! I think the setting you look for is found in the webgui. Rightclick the calendar, choose properties and set the Synchronisation settings. At least for calendars, this works. One more thing: I recently installed Sogo to sync my android phone and found out, that the FunV10 app is not working so well: * multiple calendars are marked with leading tags and appear merged in a single calendar * some repetition patterns (2-week cycle) leaded to doubled entries * notes attached to appointments did not show up on the phone I switched to CalDAV-Sync which costs a little money but works fine. Maybe the free ICSSync can do the job as well, but I just installed it today to one-way synchronize an ICS calendar. If you use CalDAV to access the calendars, you don't need the synchronization settings I mentioned earlier. I hope this helps. Cheers, Peter On 2012-03-06 17:12, Andreas Balg wrote: Hi there, is there any chance to define the addressbook or calendar (or even more than one) that I want to sync to the clients if using Funambol or is it unchangeable to have it sync only the default addressbooks and calendars? Best regards, Andreas Balg -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] is gdomap necessary?
Hi Francis, Thank you very much for clarifying that, I already assumed gdomap could be disabled after my tests, but it's nice to get some certainty about it. I wonder if someone could shed some light on the number of database-connections SOGo consumes, in my opinion (using postgresql with unix-sockets and ident authentication) more than 120 seems a bit excessive with 2 workers and 5 concurrent users.. Regards, Piet From: Francis Lachapelle flachape...@inverse.ca To: Piet Hein ex_ad...@yahoo.com Cc: users@sogo.nu users@sogo.nu Sent: Monday, March 5, 2012 11:03 PM Subject: Re: [SOGo] is gdomap necessary? Hi Piet On 2012-02-27, at 4:37 PM, Piet Hein wrote: I wonder if running gdomap is necessary a properly functioning SOGo setup (on one host). A quick test (running SOGo with gdomap disabled) showed no issues. Is it safe to disable gdomap? For the moment, you can safely disable gdomap. Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org)-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] is gdomap necessary?
Am 06.03.2012 19:39, schrieb Piet Hein: Hi Francis, Thank you very much for clarifying that, I already assumed gdomap could be disabled after my tests, but it's nice to get some certainty about it. I wonder if someone could shed some light on the number of database-connections SOGo consumes, in my opinion (using postgresql with unix-sockets and ident authentication) more than 120 seems a bit excessive with 2 workers and 5 concurrent users.. This one ? https://inverse.ca/sogo/lists/arc/users/2012-02/msg00407.html André -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] experience using postgresql
Hi,
I would like to share my experience with using postgresql as a
database server for SOGo...
Any suggestions for tunig database or doing things better are welcome.
Regards
Milos--
users@sogo.nu
https://inverse.ca/sogo/lists
I have 17,560 active users on the production SOGo server,
it means 166,894 tables and 5.3 GB in the sogo postgresql database.
I'm running SOGo-1.3.9 on the dedicated machine and I will do upgrade
to 1.3.12 version which will be running on the new machine (modern server,
2x Xeon E5645 @ 2.40GHz, 32 GB RAM and 15K SAS disks).
So I need to move sogo dates to new machine and migrate them to 1.3.12
and I'm finding the best way how to do it.
Let me note I'm not database expert...
Way A - using sogo-tool backup restore
=
For daily backup I'm using sogo-tool backup ALL way
(below is an explanation why).
I transfered all sogo-tool backup data to new machine and
I restored them through sogo-tool restore command there.
This procedure needs about 5.5 hours and it doesn't need
to use migration script to 1.3.12
(converting c_content from VARCHAR to TEXT in table sogo_folder_info),
because dates are inserted into new tables with correct type of the column.
When I run sogo-tool restore in 4 parallel threads, it needs 2 hours.
Way B - moving and migrating database dates
I cannot use simple command
pg_dump sogo outfile
on the production server. It worked fine when I had a few thousands of tables.
But when I have 166 thousands tables, this command writes:
---
pg_dump: WARNING: out of shared memory
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
pg_dump: The command was: LOCK TABLE public.sogoXXX00148966195 IN ACCESS SHARE
MODE
---
I tried to tune some DB parameters, but without success.
So I stopped postgresql and created tar file of all /var/lib/postgresql/
directory.
Then I moved tar archive to new machine, I stopped postgresql and untared
archive there.
I checked all is fine after postgresql restart.
After that migration script sql-update-1.3.11_to_1.3.12.sh is needed to run.
Let's see what it does:
1) Acquisition of a list of tables
-
This command:
psql -t -U sogo -h localhost sogo -c select split_part(c_location, '/', 5)
from sogo_folder_info;
writes 55615 names of the tables in my case and it needs 2 sec.
2a) Acquisition of database commands into shell variable sqlscript:
-
function convVCtoText() {
oldIFS=$IFS
IFS=
part=`echo -e \ALTER TABLE $table ALTER COLUMN c_content TYPE
TEXT;\\n\`;
sqlscript=$sqlscript$part
IFS=$oldIFS
}
tables=`psql -t -U $username -h $hostname $database -c select
split_part(c_location, '/', 5) from $indextable;`
for table in $tables;
do
convVCtoText
done
This is original procedure and it needs more as 7 hours in my case. Oh. Really
:-(
2b) Acquisition of the database commands into file:
-
When I modified original script which do the same thing but it writes commands
into external file
instead of shell variable:
function convVCtoText() {
echo ALTER TABLE $table ALTER COLUMN c_content TYPE TEXT;
/tmp/commands
}
tables=`psql -t -U $username -h $hostname $database -c select
split_part(c_location, '/', 5) from $indextable;`
for table in $tables;
do
convVCtoText
done
it needs 3 sec only. Much better ;-)
3a) Applying of database commands:
-
psql -U sogo sogo -f /tmp/commands
it needs 214 min.
3b) Parallel applying of database commands:
-
Because PostgreSQL is process-based, not thread-based
(and I have lot of CPU cores and threads on the new machine)
I split commands from /tmp/commands into 4 files
and I ran them parallel in 4 processes:
psql -U sogo sogo -f /tmp/commands[1-4]
it needs 40 min. Nice ;-)
Disks utilization is about 90% in this case.
[SOGo] Restoring calendar and address book data
Hello everybody -- Unfortunately one user of our server deleted his address book and calenders from within thunderbird. Woud it be possible to restore them? Is there any place where things get backed up? Best regards -- Oliver -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Default Login Password
I am not able to find anywhere on the website what the default logins and passwords are for the sogo appliance. This would be for the console and the various programs and web or command line interfaces. Can someone help me with this? -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Tuesday, March 06 2012
Title: BTS activities for Tuesday, March 06 2012 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Tuesday, March 06 2012 idlast updatestatus (resolution)categorysummary 1666 2012-03-06 10:20:23 new (open) Funambol SOGo Connector mail aliases synced to wrong thunderbird account 1664 2012-03-06 12:48:11 updated (open) Backend General exceptions on 64Bit with gnustep-base-1.24.0 1665 2012-03-06 08:15:46 new (open) Backend General configured LDAP filter for group decomposing doesn't work 1631 2012-03-06 14:55:56 updated (open) GUI TB 10 connector does not syc 202 2012-03-06 05:47:57 updated (open) Web Mail More visibility for attachments 1642 2012-03-06 14:57:43 updated (open) with external server Photo is not uploaded by SOGo Connector 1660 2012-03-06 14:52:16 updated (open) with external server VCARD not written correctly 1600 2012-03-06 19:53:16 feedback (reopened) with SOGo ZEG doesn't use Samba 4 aplha 17 Ubuntu packages 1584 2012-03-06 17:24:04 assigned (open) sogo-tool During Openchange Installation Error 1628 2012-03-06 15:41:00 resolved (fixed) GUI Contact photos disappear 1098 2012-03-06 14:58:41 resolved (fixed) with external server GroupDavSynchronizer: obsolete DAV:sync-response after DAV:sync-collection request? 1662 2012-03-06 14:47:43 resolved (fixed) with SOGo Path parsing does not work on Windows (XP, maybe also Vista/7) and causes stop of sync with 10.0pre4 1654 2012-03-06 14:54:37 closed (duplicate) GUI TB 10 connector does not syc 1661 2012-03-06 14:48:42 closed (not a bug) GUI Connector/Lightning displays all invitiations from all subscribed calendars 1453 2012-03-06 15:43:23 closed (fixed) with SOGo Wrong synchronization by using sogo-connector-3.106pre1
Re: [SOGo] OpenChange connector compilation error
Bonjour,
Le dimanche 04 mars 2012, Jean-Michel OLTRA a écrit...
Compiling file MAPIStoreContext.m ...
MAPIStoreContext.m: In function ‘+[MAPIStoreContext
listAllContextsForUser:withTDBIndexing:inMemCtx:]’:
MAPIStoreContext.m:127: error: dereferencing pointer to incomplete type
MAPIStoreContext.m:127: error: dereferencing pointer to incomplete type
MAPIStoreContext.m:127: error: dereferencing pointer to incomplete type
MAPIStoreContext.m:127: error: dereferencing pointer to incomplete type
MAPIStoreContext.m:127: error: dereferencing pointer to incomplete type
MAPIStoreContext.m: At top level:
MAPIStoreContext.m:141: error: parameter 2 (‘role’) has incomplete type
MAPIStoreContext.m: In function ‘MAPIStoreLookupContextClassByRole’:
MAPIStoreContext.m:145: error: storage size of ‘classRole’ isn’t known
MAPIStoreContext.m:158: error: invalid use of undefined type ‘enum
mapistore_context_role’
cc1obj: warnings being treated as errors
MAPIStoreContext.m:145: error: unused variable ‘classRole’
MAPIStoreContext.m: In function ‘+[MAPIStoreContext
createRootFolder:withFID:andName:forUser:withRole:]’:
MAPIStoreContext.m:183: error: ‘role’ has an incomplete type
MAPIStoreContext.m:183: error: type of formal parameter 2 is incomplete
MAPIStoreContext.m: At top level:
cc1obj: error: type ‘({anonymous})’ does not have a known size
MAPIStoreContext.m:539: confused by earlier errors, bailing out
Preprocessed source stored into /tmp/ccuQeipY.out file, please attach
this to your bugreport.
make[3]: *** [obj/SOGoBackend.obj/MAPIStoreContext.m.o] Erreur 1
make[2]: *** [internal-bundle-run-compile-submake] Erreur 2
make[1]: *** [SOGoBackend.all.bundle.variables] Erreur 2
make: *** [internal-all] Erreur 2
Is there something to do (Debian Squeeze box)?
This one is solved : some files where remaining from previous
installation of beta4 version, in /usr/local/include (and other
locations).
But I have another:
MAPIStoreFallbackContext.m: In function ‘+[MAPIStoreFallbackContext
createRootSecondaryFolderWithFID:andName:forUser:]’:
MAPIStoreFallbackContext.m:97: error: expected ‘:’ before string
constant
make[3]: *** [obj/SOGoBackend.obj/MAPIStoreFallbackContext.m.o] Erreur 1
make[2]: *** [internal-bundle-run-compile-submake] Erreur 2
make[1]: *** [SOGoBackend.all.bundle.variables] Erreur 2
Syntax error?
Thanks.
--
jm
--
users@sogo.nu
https://inverse.ca/sogo/lists
