Re: [SOGo] mysql issue -- severe
Hello mayak Am 2013-11-25 15:36, schrieb mayak: i have just installed latest stable sogo on centos x64 with mysql 5.6.10 during the 1st login of a user, calendar is not created -- i finally found the error while watching the traffic between mysql and soogod CREATE TABLE sogocgubgdla00300bc52d4_quick ( c_name VARCHAR(255) NOT NULL PRIMARY KEY, c_uid VARCHAR(255) NOT NULL, c_startdate INT NULL, c_enddate INT NULL, c_cycleenddate INT NULL, c_title VARCHAR(1000) NOT NULL, c_participants VARCHAR(100) NULL, c_isallday INT NULL, c_iscycle INT NULL, c_cycleinfo VARCHAR(100) NULL, c_classification INT NOT NULL, c_isopaque INT NOT NULL, c_status INT NOT NULL, c_priority INT NULL, c_location VARCHAR(255) NULL, c_orgmail VARCHAR(255) NULL, c_partmails VARCHAR(10) NULL, c_partstates VARCHAR(255) NULL, c_category VARCHAR(255) NULL, c_sequence INT NULL, c_component VARCHAR(10) NOT NULL, c_nextalarm INT NULL ); and mysql responds with ERROR 1074 (42000): Column length too big for column 'c_participants' (max = 65535); use BLOB or TEXT instead and that seems to be true: c_participants VARCHAR(100) where mysql doc show that varchar max length is 65535 any suggestions? Seems there is a change in mysql 5.6.10 then. Previous versions accepted this and created text columns on the fly. Please create a bug report at http://www.sogo.nu/bugs Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] No Mails in SOGo after Update to 2.1.1a
Hi,
after updating SOGo to V2.1.1a, there are no mails and no mail Folders in the
Webinterface any more.
It seems to have Problems with the IMAP Server.
What can I do to get it up running again ?
Here´s the log:
---
Starting program: /usr/sbin/sogod -WOUseWatchDog NO -WOLogFile - -WONoDetach
YES
[Thread debugging using libthread_db enabled]
Nov 25 11:59:56 sogod [17004]: version 2.1.1a (build root@shiva.inverse
201311221523) -- starting
Nov 25 11:59:56 sogod [17004]: vmem size check enabled: shutting down app when
vmem 384 MB
Nov 25 11:59:56 sogod [17004]: 0x0xb756b8bc[SOGoProductLoader] SOGo products
loaded from '/usr/lib/GNUstep/SOGo':
Nov 25 11:59:56 sogod [17004]: 0x0xb756b8bc[SOGoProductLoader]
Contacts.SOGo, SchedulerUI.SOGo, CommonUI.SOGo, Mailer.SOGo,
Appointments.SOGo, ContactsUI.SOGo, MailerUI.SOGo, AdministrationUI.SOGo,
MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo
Nov 25 11:59:56 sogod [17004]: |SOGo| WOHttpAdaptor listening on address
127.0.0.1:2
2013-11-25 12:00:02.661 sogod[17004] Note: Using UTF-8 as URL encoding in
NGExtensions.
Nov 25 12:00:02 sogod [17004]: 0x0xb7552df4[SOGoCache] Cache cleanup
interval set every 300.00 seconds
Nov 25 12:00:02 sogod [17004]: 0x0xb7552df4[SOGoCache] Using host(s)
'localhost' as server(s)
2013-11-25 12:00:02.670 sogod[17004] Note(SoObject): SoDebugKeyLookup is
enabled!
2013-11-25 12:00:02.670 sogod[17004] Note(SoObject): SoDebugBaseURL is
enabled!
2013-11-25 12:00:02.670 sogod[17004] Note(SoObject): relative base URLs are
enabled.
46.237.215.134 - - [25/Nov/2013:12:00:02 GMT] GET /SOGo/so/thomas.arndt/Mail/
null/expunge HTTP/1.1 404 208/0 0.019 - - 1M
2013-11-25 12:00:02.708 sogod[17004] WOCompoundElement: pool embedding is on.
2013-11-25 12:00:02.708 sogod[17004] WOCompoundElement: id logging is on.
2013-11-25 12:00:02.737 sogod[17004] WARNING: IMAP4 connection pooling is
disabled!
2013-11-25 12:00:07.434 sogod[17004] Note(NGImap4Connection): using '/' as the
IMAP4 folder separator.
Nov 25 12:00:07 sogod [17004]: 0x0xb6f8be9c[NGImap4ResponseParser]
_parseUntaggedResponse: no matching tag specifier?
Nov 25 12:00:07 sogod [17004]: 0x0xb6f8be9c[NGImap4ResponseParser] line:
'ID (name Cyrus IMAPD version v2.3.11 2007/12/10 14:48:14 vendor
Project Cyrus support-url http://cyrusimap.web.cmu.edu; os Linux os-
version 2.6.18-308.1.1.v5 environment Built w/Cyrus SASL 2.1.22; Running
w/Cyrus SASL 2.1.22; Built w/Sleepycat Software: Berkeley DB 4.3.29: (January
7, 2007); Running w/Sleepycat Software: Berkeley DB 4.3.29: (July 12, 2010);
Built w/OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008; Running w/OpenSSL 0.9.8e-fips-
rhel5 01 Jul 2008; CMU Sieve 2.3; TCP Wrappers; mmap = shared; lock = fcntl;
nonblock = fcntl; idle = idled)'
2013-11-25 12:00:12.708 sogod[17004] Note: using 'UCS-2LE' on Linux.
46.237.215.134 - - [25/Nov/2013:12:00:12 GMT] GET /SOGo/so/thomas.arndt/Mail/
view HTTP/1.1 200 11586/0 10.146 45803 74% 3M
Nov 25 12:00:13 sogod [17004]: [WARN] 0x0xb6e01c94[SOGoWebDAVAclManager]
entry '{DAV:}write' already exists in DAV permissions table
Nov 25 12:00:13 sogod [17004]: [WARN] 0x0xb6e01c94[SOGoWebDAVAclManager]
entry '{DAV:}write-properties' already exists in DAV permissions table
Nov 25 12:00:13 sogod [17004]: [WARN] 0x0xb6e01c94[SOGoWebDAVAclManager]
entry '{DAV:}write-content' already exists in DAV permissions table
46.237.215.134 - - [25/Nov/2013:12:00:13 GMT] POST /SOGo/so/thomas.arndt/
Calendar/alarmslist?browserTime=1385377213 HTTP/1.1 200 2/0 0.028 - - 108K
Nov 25 12:00:13 sogod [17004]: 0x0xb705bf9c[NGImap4ResponseParser]
_parseUntaggedResponse: no matching tag specifier?
Nov 25 12:00:13 sogod [17004]: 0x0xb705bf9c[NGImap4ResponseParser] line:
'ID (name Cyrus IMAPD version v2.3.11 2007/12/10 14:48:14 vendor
Project Cyrus support-url http://cyrusimap.web.cmu.edu; os Linux os-
version 2.6.18-308.1.1.v5 environment Built w/Cyrus SASL 2.1.22; Running
w/Cyrus SASL 2.1.22; Built w/Sleepycat Software: Berkeley DB 4.3.29: (January
7, 2007); Running w/Sleepycat Software: Berkeley DB 4.3.29: (July 12, 2010);
Built w/OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008; Running w/OpenSSL 0.9.8e-fips-
rhel5 01 Jul 2008; CMU Sieve 2.3; TCP Wrappers; mmap = shared; lock = fcntl;
nonblock = fcntl; idle = idled)'
46.237.215.134 - - [25/Nov/2013:12:00:13 GMT] POST /SOGo/so/thomas.arndt/
Mail/0/mailboxes HTTP/1.1 200 135944/0 0.543 - - 3M
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] display name
Hello Héctor Moreno Blanco. Am 2013-11-11 12:56, schrieb Héctor Moreno Blanco: We have a little problem with SOGo. We would like to display the “givenName + sn” in the web interface as well as the full user name in the preferences. As we don’t have displayName attribute in our LDAP server and the config “CNFieldName” is only one field and doesn’t support array type. How can we achieve this? This is not possible yet. BTW this is an unusual setup of LDAP (no offence meant here) You should open a request for enhancement at http://www.sogo.nu/bugs Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ActiveSync question
hello Heiner Markert Am 2013-10-20 20:45, schrieb Heiner Markert: ... Someone really should update the SOGo wiki (unfortunately I am unable to create an account: I fail with the TextCha...). It still links to sogosync, which is totally outdated. try: You better ask the right guy to have an account in this wiki. :-) Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Active Sync support in SOGo
Hi, Any update on this? Can't wait for that. :) Regards. Em 18-09-2013 18:22, Ludovic Marcotte escreveu: Hello, We've been pretty silent when it came to Active Sync support in SOGo for multiple reasons. First of all, there are licensing implications with Microsoft Active Sync. Moreover, there's a plethora of Active Sync implementations out there. We also wanted to see how vendors would adopt CalDAV/CardDAV, how down the drain Funambol would go and the market's impact of the new Windows/Blackberry phones. After digesting all the above for a few weeks, we came to the conclusion we should most likely add Active Sync support to SOGo. Over the past few days, I've been (and still are) in contact with an IP Licensing person at Microsoft. We had interesting discussions which led us to believe we could: 1. create an Active Sync bundle in SOGo for synchronization 2. license it under a free but non-GPL (BSD, for example) 3. distribute it for free We can't use the GPL because of patents restrictions. Z-Push/OPush/Synchotron are all using patented technologies without a license and Microsoft currently does not license to GPL implementations - so using these is not an option. Since the addition of Active Sync support in SOGo would be a server-side implementation, there would be a per-mailbox fee to use it. That fee, would have to be paid to Microsoft directly. On our end, everything would be free of use. Evidently, if we start working on Active Sync support in SOGo, we'll definitively drop Funambol support - which is probably even more exciting then adding Active Sync support. Thanks! -- 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) -- *Marcio Merlone* TI - Administrador de redes *A1 Engenharia - Unidade Corporativa* Fone: +55 41 3616-3797 Cel:+55 41 9689-0036 http://www.a1.ind.br/ http://www.a1.ind.br -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] TB 24.1.1 + sogo connector 24.0.2 + sogo integrator 24.0.2 + lightning 2.6.3
Hi, tested with a new install (Windows): I can confirm the problem: No calenders visible. Also missing where the usual add/subscribe/remove buttons provided by the connector plugin. After adding a calendar like any other CalDav calendar in lightning options like sharing (provided by the SOGo Connector) worked though. Adressbooks work as expected and I can't reproduce any double.. problems. /rupi -- Rainer Ruprechtsberger Volkshilfe Oberösterreich EDV 4020 Linz, Glimpfingerstrasse 48 Tel.: +43 732 3405 123 Mobil.: +43 676 8734 1123 ZVR Zahl: 064371505 Volkshilfe. Wir haben Ideen, die viel bewegen. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Active Sync support in SOGo
On 2013-11-26 8:15 AM, Márcio Merlone wrote: Any update on this? Can't wait for that. :) The work is ongoing. We expect an initial working version by the end of this week or the next one. Thanks, -- 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] TB 24.1.1 + sogo connector 24.0.2 + sogo integrator 24.0.2 + lightning 2.6.3
Le 26/11/2013 13:22, Rainer Ruprechtsberger a écrit : Hi, tested with a new install (Windows): I can confirm the problem: No calenders visible. Also missing where the usual add/subscribe/remove buttons provided by the connector plugin. After adding a calendar like any other CalDav calendar in lightning options like sharing (provided by the SOGo Connector) worked though. Adressbooks work as expected and I can't reproduce any double.. problems. /rupi Hello i confirm: no calendar visible = and the usual add/subscribe/remove buttons are missing. tested with TB 24.1.1 + sogo connector 24.0.2 + sogo integrator 24.0.2 + lightning 2.6.3 (and sogo server 2.1.1a wheezy) with and fresh accompte creation of TB 24.1.1 (win7 64b) thanks regards Arnaud -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] TB 24.1.1 + sogo connector 24.0.2 + sogo integrator 24.0.2 + lightning 2.6.3
On Tue, 26 Nov 2013, Arnaud LE NORCY wrote: i confirm: no calendar visible = and the usual add/subscribe/remove buttons are missing. ok, I think we have enough confirmations that it is 'global' problem. I opened bug in SOGo bugzilla http://www.sogo.nu/bugs/view.php?id=2510 and in Lighting bugzilla https://bugzilla.mozilla.org/show_bug.cgi?id=943457 Milos -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] TB 24.1.1 + sogo connector 24.0.2 + sogo integrator 24.0.2 + lightning 2.6.3
On 13-11-26 1:39 PM, Milos Wimmer wrote: On Tue, 26 Nov 2013, Arnaud LE NORCY wrote: i confirm: no calendar visible = and the usual add/subscribe/remove buttons are missing. ok, I think we have enough confirmations that it is 'global' problem. Indeed. can you guys try this extension: http://inverse.ca/downloads/extensions/nightly/sogo-integrator-24.0.2-a3d9676e41-sogo-demo.xpi Customize it for your site of course. As a side note, if you want to try something new, it might be easier to manage your custom preferences like this: git clone https://github.com/inverse-inc/sogo-integrator.tb24.git pushd sogo-integrator.tb24/custom cp -a sogo-demo yoursite # tweak your config in the 'yoursite' popd cd sogo-integrator.tb24 make build=yoursite Let me know if the new version fixes the issues you were having. We'll release a new version if it does. Thanks. I opened bug in SOGo bugzilla http://www.sogo.nu/bugs/view.php?id=2510 and in Lighting bugzilla https://bugzilla.mozilla.org/show_bug.cgi?id=943457 Milos -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] TB 24.1.1 + sogo connector 24.0.2 + sogo integrator 24.0.2 + lightning 2.6.3
On Tue, 26 Nov 2013, Jean Raby wrote: Hi Jean, can you guys try this extension: http://inverse.ca/downloads/extensions/nightly/sogo-integrator-24.0.2-a3d9676e41-sogo-demo.xpi Yes, I see calendars in fresh profile again and I see addressbook too ;-) Thanks for your help. BTW: Please look at issue which I opened at Mozilla https://bugzilla.mozilla.org/show_bug.cgi?id=943457 There are interesting findings... Milos -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Tuesday, November 26 2013
Title: BTS activities for Tuesday, November 26 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Tuesday, November 26 2013 idlast updatestatus (resolution)categorysummary 2516 2013-11-26 07:35:58 updated (open) Backend Calendar Auto create of mysql calendar table fails with mysql: 5.6.10 and 5.6.14 2515 2013-11-26 14:16:25 updated (open) Web Calendar Edit calendar entry popup defaults to personal calendar, not the entry's calendar 2517 2013-11-26 07:45:10 updated (open) Web Mail IE Focus error 1624 2013-11-26 17:29:09 updated (open) with external server Writing vcards with PUT does not check for changes (Danger of overwriting data) 2518 2013-11-26 17:31:49 updated (open) with external server Include a custom User-Agent. 414 2013-11-26 22:16:06 closed (suspended) Backend Address Book Cannot print from address book 2510 2013-11-26 22:09:22 closed (fixed) Backend Calendar TB 24.1.1 and SOGo extensions 24.0.2, no calendars 452 2013-11-26 22:16:59 closed (suspended) GUI Errors after connector installation 1619 2013-11-26 22:21:52 closed (suspended) with external server handle PUT without returned etag 217 2013-11-26 22:13:37 closed (suspended) with SOGo Error when creating calendar/address book 1315 2013-11-26 22:20:13 closed (wont fix) with SOGo Add support for plain file user authentication sources
