[SOGo] Update to 1.3.9 on Centos5
After the Upgrade to 1.3.9 I get the following Error in sogolog: Oct 30 08:22:44 sogod [11571]: [ERROR] 0x0xa38050c[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_deleted FROM sogocn00122006b17_quick a, sogocn00122006b17 b WHERE ((c_lastmodified 1319959275) AND (c_deleted = 1)) AND a.c_name = b.c_name': MySQL4Exception: 0xa39c5d4 NAME:ExecutionFailed REASON:Unknown column 'a.c_deleted' in 'field list' 10.9.0.245 - - [30/Oct/2011:08:22:44 GMT] REPORT /SOGo/dav/cn/Calendar/C4BCF5D8-79F0-0001-57A4-1D2015606F10/ HTTP/1.1 207 125/245 0.013 - - 0 Oct 30 08:22:44 sogod [11571]: [ERROR] 0x0xa24d6b4[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_component,a.c_creationdate,a.c_lastmodified,a.c_version,a.c_content FROM sogocn0012cd4916b_quick a, sogocn0012cd4916b b WHERE (c_lastmodified 1319959275) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0xa3d80e4 NAME:ExecutionFailed REASON:Unknown column 'b.c_component' in 'field list' All calendar content is not displayed in TB or te webinterface. I had to do a link to gnustep base 1.20 in order to get sogo running as described in a previous post. Could that be a problem? This does not happen on a Centos6 with PGSQL. Thanks Christian -- Dr. Christian Naumer Senior Scientist Analytics Engineering B.R.A.I.N Aktiengesellschaft Darmstaedter Str. 34-36, D-64673 Zwingenberg e-mail c...@brain-biotech.de, homepage www.brain-biotech.de fon +49-6251-9331-30 / fax +49-6251-9331-11 Sitz der Gesellschaft: Zwingenberg/Bergstrasse Registergericht AG Darmstadt, HRB 24758 Vorstand: Dr. Holger Zinke (Vorsitz), Dr. Jürgen Eck Vorsitzender des Aufsichtsrats: Ulrich Putsch -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
Am 30.10.2011 08:29, schrieb Christian Naumer: After the Upgrade to 1.3.9 I get the following Error in sogolog: Oct 30 08:22:44 sogod [11571]: [ERROR] 0x0xa38050c[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_deleted FROM sogocn00122006b17_quick a, sogocn00122006b17 b WHERE ((c_lastmodified 1319959275) AND (c_deleted = 1)) AND a.c_name = b.c_name': MySQL4Exception: 0xa39c5d4 NAME:ExecutionFailed REASON:Unknown column 'a.c_deleted' in 'field list' 10.9.0.245 - - [30/Oct/2011:08:22:44 GMT] REPORT /SOGo/dav/cn/Calendar/C4BCF5D8-79F0-0001-57A4-1D2015606F10/ HTTP/1.1 207 125/245 0.013 - - 0 Oct 30 08:22:44 sogod [11571]: [ERROR] 0x0xa24d6b4[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_component,a.c_creationdate,a.c_lastmodified,a.c_version,a.c_content FROM sogocn0012cd4916b_quick a, sogocn0012cd4916b b WHERE (c_lastmodified 1319959275) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0xa3d80e4 NAME:ExecutionFailed REASON:Unknown column 'b.c_component' in 'field list' There are some others as well for a.c_deleted b.c_component but there are only c_component fields in the table and no fields with deleted in there. But this is the same in the working system on Centos6 Anny ideas? -- Dr. Christian Naumer Senior Scientist Analytics Engineering B.R.A.I.N Aktiengesellschaft Darmstaedter Str. 34-36, D-64673 Zwingenberg e-mail c...@brain-biotech.de, homepage www.brain-biotech.de fon +49-6251-9331-30 / fax +49-6251-9331-11 Sitz der Gesellschaft: Zwingenberg/Bergstrasse Registergericht AG Darmstadt, HRB 24758 Vorstand: Dr. Holger Zinke (Vorsitz), Dr. Jürgen Eck Vorsitzender des Aufsichtsrats: Ulrich Putsch -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
Am 30.10.2011 09:53, schrieb Christian Naumer: There are some others as well for a.c_deleted b.c_component but there are only c_component fields in the table and no fields with deleted in there. But this is the same in the working system on Centos6 I have to correct this the c_deleted field is not in the quick-table but in the normal table. So all fields are there it just doesn't find them... -- Dr. Christian Naumer Senior Scientist Analytics Engineering B.R.A.I.N Aktiengesellschaft Darmstaedter Str. 34-36, D-64673 Zwingenberg e-mail c...@brain-biotech.de, homepage www.brain-biotech.de fon +49-6251-9331-30 / fax +49-6251-9331-11 Sitz der Gesellschaft: Zwingenberg/Bergstrasse Registergericht AG Darmstadt, HRB 24758 Vorstand: Dr. Holger Zinke (Vorsitz), Dr. Jürgen Eck Vorsitzender des Aufsichtsrats: Ulrich Putsch -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 1.3.9 Update results
Hi, SOGo and SOPE upgrade jointly under Ubuntu package release. Should I and Is there a way to reupgrade SOPE only ? Dominique On 30/10/2011 00:25, Tobias Wallura wrote: 3. The preferences windows does not close properly, and gives an error regarding a proxy Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request /POST /SOGo/so/dcouot/preferences http://www.solipym.com/SOGo/so/dcouot/preferences/. Reason: *Error reading from remote server* I had the exact same problem. Updating SOGo and SOPE to the 1.3.9 version released on 29-Oct-2011 14:37 solved the problem for me. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
Am Sonntag, 30. Oktober 2011 schrieb Christian Naumer: Am 30.10.2011 09:53, schrieb Christian Naumer: There are some others as well for a.c_deleted b.c_component but there are only c_component fields in the table and no fields with deleted in there. But this is the same in the working system on Centos6 I have to correct this the c_deleted field is not in the quick-table but in the normal table. So all fields are there it just doesn't find them... I have similar problems after update. There is no entry in my calendar view. I checked the SQL statements in the error log file. SELECT b.c_name,a.c_content,a.c_creationdate,a.c_lastmodified,a.c_version,b.c_component,b.c_title,b.c_location,b.c_orgmail,b.c_status,b.c_category,b.c_classification,b.c_isallday,b.c_isopaque,b.c_participants,b.c_partmails,b.c_partstates,b.c_sequence,b.c_priority,b.c_cycleinfo,b.c_iscycle,b.c_nextalarm,b.c_uid,b.c_startdate,b.c_enddate FROM sogo0017042270b_quick a, sogo0017042270b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate = 1320620399)) AND ((c_enddate IS NULL) OR (c_enddate = 1316988000)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) And if I change the table names ('b' for the _quick table and 'a' for the normal one) it went through smoothly. Besides this sogod tries to load libgnustep-base.so.1.23 and libgnustep-base.so.1.20. The command 'ldd /usr/sbin/sogod | grep base' reports: libgnustep-base.so.1.23 = /usr/lib/libgnustep-base.so.1.23 (0x047ae000) libgnustep-base.so.1.20 = not found libgnustep-base.so.1.20 = not found This is CentOS 5.7 and SOGo is from package sogo-1.3.9-2.el5. Database is MySQL. Martin -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
Same problem on SL6.1: sogo seems to attempt fetching fields from the quick tables that are really in the full tables: Oct 30 12:46:27 sogod [5457]: [ERROR] 0x0x2d063b8[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_deleted FROM sogojeroen0017efda6cd_quick a, sogojeroen0017efda6cd b WHERE ((c_lastmodified 1319971586) AND (c_deleted = 1)) AND a.c_name = b.c_name': MySQL4Exception: 0x2cd7e88 NAME:ExecutionFailed REASON:Unknown column 'a.c_deleted' in 'field list' Oct 30 12:56:56 sogod [5457]: [ERROR] 0x0x3002298[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_version,a.c_creationdate,a.c_lastmodified,b.c_component,a.c_content FROM sogojeroen0025938e41e_quick a, sogojeroen0025938e41e b WHERE (a.c_name = '1EAEDAD0-78A55DFA-075ECFBC.vcf') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x305ec58 NAME:ExecutionFailed REASON:Unknown column 'a.c_version' in 'field list' -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
On 30/10/11 07:03, Martin (Lists) wrote: And if I change the table names ('b' for the _quick table and 'a' for the normal one) it went through smoothly. Besides this sogod tries to load libgnustep-base.so.1.23 and libgnustep-base.so.1.20. The command 'ldd /usr/sbin/sogod | grep base' reports: libgnustep-base.so.1.23 = /usr/lib/libgnustep-base.so.1.23 (0x047ae000) libgnustep-base.so.1.20 = not found libgnustep-base.so.1.20 = not found This is CentOS 5.7 and SOGo is from package sogo-1.3.9-2.el5. Database is MySQL. That's probably a sign of having old SOPE packages around after proceeding with the SOGo update. Make sure you update all SOPE packages to the latest version and restart the SOGo service after. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
Am Sonntag, 30. Oktober 2011 schrieb Ludovic Marcotte: On 30/10/11 07:03, Martin (Lists) wrote: And if I change the table names ('b' for the _quick table and 'a' for the normal one) it went through smoothly. Besides this sogod tries to load libgnustep-base.so.1.23 and libgnustep-base.so.1.20. The command 'ldd /usr/sbin/sogod | grep base' reports: libgnustep-base.so.1.23 = /usr/lib/libgnustep-base.so.1.23 (0x047ae000) libgnustep-base.so.1.20 = not found libgnustep-base.so.1.20 = not found This is CentOS 5.7 and SOGo is from package sogo-1.3.9-2.el5. Database is MySQL. That's probably a sign of having old SOPE packages around after proceeding with the SOGo update. Make sure you update all SOPE packages to the latest version and restart the SOGo service after. Ah, thanks That did the trick. I had old sope file lying around. Sadly these were not updated automatically by yum update (why?). I had to remove the following packages by hand: - sope49-gdl1-contentstore - sope49-ical - sope49-cards This remove sogo as well (dependency). After install sogo again I got new sope-card and sope-gdl1-contentstore files. Old versions were 1.3_20110726 (ical was even older: 4.9-20100721). new Versions are 1.3.9-2 so they match the one from sogo package. sope-ial seems no longer be needed. Once again, many thanks to you working at SOGo, it is a awesome piece of software. Martin -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: sogo-1.3.9-2 update problems
Hi, On Sun, Oct 30, 2011 at 12:53 AM, Peter Peltonen peter.pelto...@gmail.com wrote: Hi, Just ran 'yum update' on my centos6 box and SOGo was updated to version 1.3.9-2. When accessing my server with the address /SOGo/ I get now no graphics displayed in the login page. In the sogo.log file I see the errors: [Sun Oct 30 00:46:03 2011] [error] [client ::1] File does not exist: /usr/GNUstep/System/Library/SOGo/WebServerResources, referer: http://localhost/SOGo/ Looking at the output of locate WebServerResources I think on centos6 the correct directory should be: /usr/lib/GNUstep/SOGo/WebServerResources ? So... Is this a bug in the updated package or have I somehow managed to misconfigure my server? This is my first installation and the packages were updated by yum in the middle of the installation process. Maybe I should remove the packages and start all over again? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: sogo-1.3.9-2 update problems
On 30/10/11 10:10, Peter Peltonen wrote: So... Is this a bug in the updated package or have I somehow managed to misconfigure my server? This is my first installation and the packages were updated by yum in the middle of the installation process. Maybe I should remove the packages and start all over again? Adjust your SOGo.conf Apache configuration file accordingly. Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Update to 1.3.9 on Centos5
Same here, thank you for the quick solution! My sope packages were less outdated but still outdated. I think the problem yum wise was this: new version is 1.3.9-2, old version had a higher number so yum considered it newer. -- met vriendelijke groet, Jeroen Beerstra j.beers...@upcmail.nl -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: sogo-1.3.9-2 update problems
Hi, On Sun, Oct 30, 2011 at 4:29 PM, Ludovic Marcotte lmarco...@inverse.ca wrote: On 30/10/11 10:10, Peter Peltonen wrote: So... Is this a bug in the updated package or have I somehow managed to misconfigure my server? This is my first installation and the packages were updated by yum in the middle of the installation process. Maybe I should remove the packages and start all over again? Adjust your SOGo.conf Apache configuration file accordingly. Thanks for the tip: I found out that the yum update had created a .rpmnew file for the Apache config. Using that file as the template for my own configuration I was able to get the SOGo web UI working and logging in the first time :) Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] warning in the sogo log files
Hi, I've now got my first SOGo installation finally working with PostgreSQL and remote Dovecot IMAP server. When I login using the web UI I see the following warnings in /var/log/sogo/sogo.log : Oct 30 21:41:57 sogod [29911]: [WARN] 0x0x8a76f0c[SOGoWebDAVAclManager] entry '{DAV:}write' already exists in DAV permissions table Oct 30 21:41:57 sogod [29911]: [WARN] 0x0x8a76f0c[SOGoWebDAVAclManager] entry '{DAV:}write-properties' already exists in DAV permissions table Oct 30 21:41:57 sogod [29911]: [WARN] 0x0x8a76f0c[SOGoWebDAVAclManager] entry '{DAV:}write-content' already exists in DAV permissions table 2011-10-30 21:41:58.373 sogod[29911] WARNING: IMAP4 connection pooling is disabled! 2011-10-30 21:42:20.172 sogod[29911] WARNING(-[NSNull(misc) length]): called NSNull -length (returns 0) !!! The last one appears when I use the calendar and it seems to repeated quite many times. Are these errors something I should be considered about? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] PostgreSQL gotchas
Hi, For other people trying to install SOGo using PostgreSQL authentication on CentOS6 here are a few gotchas I encountered: 1) By default PostgreSQL is not accepting TCP/IP connections. You can enable this by adding PGOPTS=-i to /etc/sysconfig/pgsql/postgresql and restarting the postgresql service 2) If you are running PostgreSQL on localhost using IPv4, use IP address 127.0.0.1 and not name localhost in .GNUstepDefaults configuration, as localhost is interpreted as an IPv6 address for the PostgreSQL URLs. The other option could be to allow IPv6 connections in pg_hba.conf by specifying: host sogo sogo ::1/128 md5 Hope this helps others trying to setup SOGo with PostgreSQL. Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Sunday, October 30 2011
Title: BTS activities for Sunday, October 30 2011 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Sunday, October 30 2011 idlast updatestatus (resolution)categorysummary 1471 2011-10-30 20:32:26 updated (open) Backend Calendar Resources auto-accept invitations even with conflicts with recurring events 1453 2011-10-30 15:49:34 updated (open) with SOGo Wrong synchronization by using sogo-connector-3.106pre1 1458 2011-10-30 20:33:10 closed (not a bug) Web Calendar SOGoCalendarDefaultRoles