[SOGo] Any French SOGO integrator ?
Hello, i work for an administration in France and we are interested by SOGO. I would like to know if there are some SOGO integrators in France that i could contact ? Thanks a lot. Morgan -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Where is the SRPMS ?
Hi, i would like to know here is the SRPMS pakages of SOGo 1.3 ? ( http://www.sogo.nu/files/downloads/SOGo/RHEL5/SRPMS/ is the 1.2.1) I want to build it for fedora. Thanks Fabrice Durand -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGoMailListViewColumnsOrder
Is there also a possible UUID column to be able to sort in the order of reception of these mails? Sorting by date is sometimes bad when a sender has configured a wrong timezone or did not synchronize his computer clock. Also some Spams (which rarely achieve to pass our spam filters) are always on top because of a date in the future. Thunderbird offers this option. Pascal -- pas...@southbrain.com http://southbrain.com/ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Any French SOGO integrator ?
Bonjour, merci, je vous contacte par mail en privé. Cordialement Morgan LEFIEUX Le 22/07/2010 10:14, Lacroix Francois a écrit : Bonjour, Je suis un consultant independant specialiser dans l'Open Source et les nouvelles technologies du conseil à la réalisation. J ai integrer SOGo dans plusieurs PME en France et en Espagne. Je maintien SOGo dans ces meme PME. Avez vous definit le project? Cordialement, Francois Lacroix Comete com...@daknet.org a écrit : Hello, i work for an administration in France and we are interested by SOGO. I would like to know if there are some SOGO integrators in France that i could contact ? Thanks a lot. Morgan -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.0
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, good work as always.Just one question regarding this: * added the ability to publish resources to unauthenticated (anonymous) users, via the /SOGo/dav/public url * we now provide ICS and XML version of a user's personal calendars when accessed from his own Calendar base collection Would you mind giving some basic examples of how to use this to run a query to get the events a user has for a given day or week? I .e, is it something like: GET http://localhost/SOGo/dav/public/username/calendar.xml?fromdate=220610todate=230610timezone=Moon/LunarBase ? Kind regards Tarjei * events are now displayed with the colored stripe representing their category, if one is defined in the preferences * fixed display of all-day events in a monthly view where the timezone differs from the current one * the event location is now displayed in the calendar view when defined properly * added a caching mechanism for freebusy requests, in order to accelerate the display * added the ability to specify a time range when requesting a time slot suggestion * added live-loading support in the webmail interface with caching support * updated CKEditor and improved its integration with the current user language for automatic spell checking support * added support for displaying photos from contacts * added a Ukrainian translation * updated the Czech translation Many of the changes were sponsored by the University of West Bohemia, CESNET and Lille1 University. See http://www.sogo.nu/bugs/changelog_page.php?project_id=1 for the change log. Moreover, with this release, Inverse also announces the immediate availability of new SOGo Connector (v0.101) and SOGo Integrator (v0.101) extensions for Mozilla Thunderbird 2. The integration has also been perfected with the Inverse Edition of the Mozilla Lightning (v0.11) extension. This will be the last release of SOGo Connector / Integrator / Inverse Edition of Lightning for Thunderbird 2 as we move forward to support Mozilla Thunderbird 3.1. You can get the preliminary version of those extensions from our source repository: http://www.sogo.nu/development/source_code.html === Changes for the extensions === * Lightning v0.11 (Inverse Edition) * Fixed the attendee delegation code * Many speed improvements * General bug fixing * SOGo Connector v0.101 * Added PHOTO support (has to be combined with the MoreFunctionsForAddressBook extension) * Many small fixes to improve synchronization with mobile devices * SOGo Integrator v0.101 * UI updates to reflect changes in SOGo === Getting SOGo === SOGo is free software and is distributed under the GNU GPL. As such, you are free to download and try it by visiting the following page : http://www.sogo.nu/downloads/backend.html You can also download the sources by following the instructions on this page: http://www.sogo.nu/development/source_code.html Frontend clients such as Mozilla Thunderbird, Mozilla Lightning (Inverse Edition), SOGo Connector and SOGo Integrator extensions are available for download from : http://www.sogo.nu/downloads/frontends.html Documentation about the installation and configuration of SOGo, Thunderbird or mobile devices is available from : http://www.sogo.nu/downloads/documentation.html You can also try our online SOGo demo at : http://www.sogo.nu/tour/online_demo.html === Upgrading to v1.3.0 === After upgrading to 1.3.0, you might want to run the bash script sql-update-1.2.2_to_1.3.0.sh for PostgreSQL or sql-update-1.2.2_to_1.3.0-mysql.sh for MySQL. === How can I help ? === SOGo is a collaborative effort in order to create the best Free and Open Source groupware solution. There are multiple ways you can contribute to the project : * Documentation reviews, enhancements and translations * Write test cases - if you know Python, join in! * Feature requests or by sharing your ideas (see the roadmap) * Participate to the discussion in mailing lists * Patches for bugs or enhancements (http://www.sogo.hu/bugs) * Provide new translations (http://www.sogo.nu/english/support/faq/article/how-to-translate-sogo-in-another-language.html) Feel free to send us your questions. You can also post them to the SOGo mailing list: https://inverse.ca/sogo/lists === Getting Support === For any questions, do not hesitate to contact us by writing to supp...@inverse.ca Customer support packages for SOGo are available from http://inverse.ca/support.html - -- Tarjei Huse Mobil: 920 63 413 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxIK6AACgkQYVRKCnSvzfKN+wCdGYy5AO8WkVmzXzKmDWVRCD/R QPEAn2Qkk0l7KgfTE2GsRV86Jwe6tiT2 =yzrv -END PGP SIGNATURE- -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] From Horde to SOGo
We want to convert all of out customers from horde to SOGo, users have calendar and addressbook to export. I can't do this manually, exporting any calendar in ics or addressbook in LDIF Who has work on this? Any script? I want to drop horde, then subscribe calendar horde from sogo is not a good way. Can anyone help me? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] From Horde to SOGo
On 07/22/2010 02:24 PM, Alessio Fattorini wrote: We want to convert all of out customers from horde to SOGo, users have calendar and addressbook to export. I can't do this manually, exporting any calendar in ics or addressbook in LDIF Who has work on this? Any script? I want to drop horde, then subscribe calendar horde from sogo is not a good way. Can anyone help me? I moved fro egroupware (which uses some horde code) to sogo. Each user had to export an ical from egw and import to sogo. Not sure if anyone has anything better than this. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo 1.3.0 calendar problem
Hi, I get a database error when I add tasks or appointments : Jul 22 17:02:40 sogod: SOGo watchdog [17765]: [ERROR] 0x04737AE0[SOGoAppointmentFolder]:personal (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed! Jul 22 17:02:40 sogod: SOGo watchdog [17765]: [ERROR] 0x0x4f42800[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,b.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogoutil100319d82f0a_quick a, sogoutil100319d82f0a b WHERE (c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x52c51b0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x46d32c0[PostgreSQL72Channel]: connection=0x0x4ef3b90[PGConnection]: connection=0x0x56f1930): ERROR: column b.c_category does not exist I'm using a Debian Lenny Postgresql 8.3.11 package. The sql-update-1.2.2_to_1.3.0.sh script didn't do the trick despite the fact the columns were correctly added. Thanks. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] From Horde to SOGo
Alessio Fattorini wrote: We want to convert all of out customers from horde to SOGo, users have calendar and addressbook to export. I can't do this manually, exporting any calendar in ics or addressbook in LDIF Who has work on this? Any script? I want to drop horde, then subscribe calendar horde from sogo is not a good way. We have developed a script for a client to migrate all address book - we could make it available. A similar script could be developed without too much efforts for calendar data. 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] SOGo 1.3.0 calendar problem
Thibaut Le Bruchec wrote: I get a database error when I add tasks or appointments : Jul 22 17:02:40 sogod: SOGo watchdog [17765]: [ERROR] 0x04737AE0[SOGoAppointmentFolder]:personal (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed! Jul 22 17:02:40 sogod: SOGo watchdog [17765]: [ERROR] 0x0x4f42800[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,b.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogoutil100319d82f0a_quick a, sogoutil100319d82f0a b WHERE (c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x52c51b0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x46d32c0[PostgreSQL72Channel]: connection=0x0x4ef3b90[PGConnection]: connection=0x0x56f1930): ERROR: column b.c_category does not exist I'm using a Debian Lenny Postgresql 8.3.11 package. The sql-update-1.2.2_to_1.3.0.sh script didn't do the trick despite the fact the columns were correctly added. Show us the evidences... do a \d sogoutil100319d82f0a_quick 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] Everything Works!
Robert A Wooldridge wrote: Wonderful. Since I installed 1.3, everything is not working great! Address books syncing perfectly, calendars as well. But, I haven't tried the latest Funambol, will get to the later. Thanks guys, this is great! It's fun to see that you're happy when things are NOT working great ;-) -- 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
[SOGo] Can't access calenders after upgrade
I've just upgraded from version 1.2.2. But I can't access no calender at all, neither my personal calender, nor shared calenders. From the log files I've copied and pasted the error. What is wrong? The server runs CentOS 5.5 with all the software updated to the recent versions. Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x0x89ec040[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogofdhartog00138bf119a_quick a, sogofdhartog00138bf119a b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate = 1279835999)) AND ((c_enddate IS NULL) OR (c_enddate = 1279749600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x88890e0 NAME:ExecutionFailed REASON:Unknown column 'a.c_category' in 'field list' Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x0x89ec040[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogofdhartog00138bf119a_quick a, sogofdhartog00138bf119a b WHERE ((c_component = 'vevent') AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x89f2700 NAME:ExecutionFailed REASON:Unknown column 'a.c_category' in 'field list' Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x087E41D0[SOGoAppointmentFolder]:personal (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed! Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x0x89ebe68[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogococamste0037c96f2b1_quick a, sogococamste0037c96f2b1 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate = 1279835999)) AND ((c_enddate IS NULL) OR (c_enddate = 1279749600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x8aaf888 NAME:ExecutionFailed REASON:Unknown column 'a.c_category' in 'field list' Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x0x89ebe68[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogococamste0037c96f2b1_quick a, sogococamste0037c96f2b1 b WHERE ((c_component = 'vevent') AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x9481740 NAME:ExecutionFailed REASON:Unknown column 'a.c_category' in 'field list' Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x094D9C78[SOGoAppointmentFolder]:cocamsterdam_77AF-4BA25580-5-1C55C220 (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed! Jul 22 22:46:59 sogod: SOGo watchdog [9749]: [ERROR] 0x0x89ed160[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogococamste001242aea34_quick a, sogococamste001242aea34 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate = 1279835999)) AND ((c_enddate IS NULL) OR (c_enddate = 1279749600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x89dd8b8 NAME:ExecutionFailed
Re: [SOGo] Can't access calenders after upgrade
frank122...@hotmail.com wrote: I've just upgraded from version 1.2.2. But I can't access no calender at all, neither my personal calender, nor shared calenders. From the log files I've copied and pasted the error. What is wrong? Upgrading to v1.3.0 After upgrading to 1.3.0, you might want to run the bash script sql-update-1.2.2_to_1.3.0.sh for PostgreSQL or sql-update-1.2.2_to_1.3.0-mysql.sh for MySQL. http://mtn.inverse.ca/revision/browse/98ba3d5ee1d111284dfb68999ac43af19ef48122/Scripts -- 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] Where is the SRPMS ?
I can't also find the SRPMS and the nightly version of the normale RPMS is 1.2.2 and not 1.3.x Could you please update. Fabrice Durand schrieb: Hi, i would like to know here is the SRPMS pakages of SOGo 1.3 ? (http://www.sogo.nu/files/downloads/SOGo/RHEL5/SRPMS/ is the 1.2.1) I want to build it for fedora. Thanks Fabrice Durand -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Accessing Calendars Remotely
Hi, I'm not sure if this is possible, so, please let me know. I have a setup with 2 domains, both are mine. One is for work and the other is personal/family. I know I cannot subscribe to a calendar from one domain to another using the SOGo backend, but it is possible to make my calendars Public, so in one of my accounts, I can Subscribe to a Web Calendar to access my other Sogo Calendar in the web interface? Trying to access https://mydomain/SOGo/so/username/Calendar/personal/ doesn't really work out. (Also tried with subscribe at the end of the URL) Thanks, Andrew -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Thursday, July 22 2010
Title: BTS activities for Thursday, July 22 2010 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Thursday, July 22 2010 idlast updatestatus (resolution)categorysummary 643 2010-07-22 02:22:35 new (open) Backend Calendar ical 4.0.2 does not send invites, events are not created in invitees' calendars 658 2010-07-22 02:21:46 new (open) Backend Calendar ical4 (snowleopard) invites /SOGo/dav/username instead of email address 702 2010-07-22 14:35:00 new (open) Backend Calendar Events and Tasks not shown 699 2010-07-22 02:05:26 new (open) Backend General Typo(s) in german mail templates (modifying access rights/ACLs) 700 2010-07-22 02:17:32 new (open) Backend Mail Additional header line: From which IP address the user was logged in in the web interface 701 2010-07-22 02:27:15 new (open) Backend Mail Wrong Sender encoding (From:) with Realnames (cn) containing parentheses 692 2010-07-22 02:42:43 new (open) Web Calendar Disappearing events and edit failures when UIDFieldName != login name (bindFields) 698 2010-07-22 01:44:07 new (open) Web General Security bug: Usernames and passwords appearing in the http cookie -- users@sogo.nu https://inverse.ca/sogo/lists