RE: [SOGo] Sogo change "from address" from GUI
Hello, But which script should I run? sql-update-2.2.17_to_2.3.0-mysql.sh Or sql-update-3.0.0-to-combined-mysql.sh I tried to run 3.0 but it did not work for me: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1 ERROR: mysql returned error 1 Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -Original Message- From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of Christian Mack Sent: Monday, November 7, 2016 11:23 AM To: users@sogo.nu Subject: Re: [SOGo] Sogo change "from address" from GUI Hello You need to upgrade at least your database schema first! While doing that your sogod must be stopped. Which means you have to stop sogod. Make a backup or snapshot. Then upgrading all SOGo packages. Afterwards run the matching shell script (mysql for MySQL database, the other for postgresql). I would also advice to remove the SOPE packages and reinstall them when changing to version 3. Then restarting memcached and starting sogod again. Kind regards, Christian Mack Am 04.11.2016 um 15:33 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): > Hello, > > Can I upgrade directly to version 3 or do I need to upgrade to 2.3 at first > and then to ver. 3? I am asking because in upgrade guide there is > instructions for running script after upgrading to 2.3 Run the shell script > sql-update-2.2.17_to_2.3.0.sh or sql-update-2.2.17_to_2.3.0-mysql.sh (if you > use MySQL). > > Tervitades / Best regards, > > Raido Rinaldi > vanemtehnik > Mob. 510 2834 > ra...@kuvarnet.ee > > Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 > skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net > > -Original Message- > From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of > Christian Mack > Sent: Friday, November 4, 2016 3:19 PM > To: users@sogo.nu > Subject: Re: [SOGo] Sogo change "from address" from GUI > > Hello > > Am 04.11.2016 um 12:07 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): >> >> So to get this feature, I have to upgrade sogo to at least 2.3.17 version? >> Is this fix included in sogo v3? >> > > It depends:-) > > If you just want to use an email address, which the user has not in his > account, then you need only a version, which supports changing it. > We have used this with earlier versions than 2.3.17 (sorry, don't > remember, when exactly we enabled it). > Only if you want to be able to set one of the email addresses of the > user too, then you need 2.3.17. > > On the V3 demo site from Inverse this function is not available. > Not sure, if it is not implemented or just disabled though. > I did not yet test this function in V3 myself. > > BTW: > Since SOGo 2.0.5 you should have switched to using sogo.conf instead of > GNUstepDefaults. > I once had problems with another setting before changing this. > Especially using sogo-tool will not work without sogo.conf. > Therefore you should switching first. > A HowTo is included in the documentation in chapter "10. Upgrading". > If you still can not change this setting, then upgrade. > > > Kind regards, > Christian Mack > > PS: > I would upgrade anyway, as 2.3.17 provides a lot of additional functions > and fixes a lot of bugs. > >> -Original Message- >> From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of >> Christian Mack >> Sent: Friday, November 4, 2016 1:06 PM >> To: users@sogo.nu >> Subject: Re: [SOGo] Sogo change "from address" from GUI >> >> Am 04.11.2016 um 11:39 schrieb Christian Mack >> (christian.m...@uni-konstanz.de): >>> Hello >>> >>> Am 02.11.2016 um 10:52 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): >>>> >>>> I want option that users can edit their email address from Sogo web -> >>>> preferences -> Imap accounts. I am running SOGo 2.2.13 and my >>>> GNUstepdefaults config contains: >>>> >>>> # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults >>>> >>>> SOGoMailCustomFromEnabled >>>> >>>> YES >>>> >>>> SOGoUserSources >>>> >>>> >>>> >>>> >>>> >>>> But the option in webmail is still greyed out: >>>> >>>> >>>> What am I missing?
RE: [SOGo] Sogo change "from address" from GUI
Hello, Can I upgrade directly to version 3 or do I need to upgrade to 2.3 at first and then to ver. 3? I am asking because in upgrade guide there is instructions for running script after upgrading to 2.3 Run the shell script sql-update-2.2.17_to_2.3.0.sh or sql-update-2.2.17_to_2.3.0-mysql.sh (if you use MySQL). Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -Original Message- From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of Christian Mack Sent: Friday, November 4, 2016 3:19 PM To: users@sogo.nu Subject: Re: [SOGo] Sogo change "from address" from GUI Hello Am 04.11.2016 um 12:07 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): > > So to get this feature, I have to upgrade sogo to at least 2.3.17 version? > Is this fix included in sogo v3? > It depends:-) If you just want to use an email address, which the user has not in his account, then you need only a version, which supports changing it. We have used this with earlier versions than 2.3.17 (sorry, don't remember, when exactly we enabled it). Only if you want to be able to set one of the email addresses of the user too, then you need 2.3.17. On the V3 demo site from Inverse this function is not available. Not sure, if it is not implemented or just disabled though. I did not yet test this function in V3 myself. BTW: Since SOGo 2.0.5 you should have switched to using sogo.conf instead of GNUstepDefaults. I once had problems with another setting before changing this. Especially using sogo-tool will not work without sogo.conf. Therefore you should switching first. A HowTo is included in the documentation in chapter "10. Upgrading". If you still can not change this setting, then upgrade. Kind regards, Christian Mack PS: I would upgrade anyway, as 2.3.17 provides a lot of additional functions and fixes a lot of bugs. > -Original Message- > From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of > Christian Mack > Sent: Friday, November 4, 2016 1:06 PM > To: users@sogo.nu > Subject: Re: [SOGo] Sogo change "from address" from GUI > > Am 04.11.2016 um 11:39 schrieb Christian Mack > (christian.m...@uni-konstanz.de): >> Hello >> >> Am 02.11.2016 um 10:52 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): >>> >>> I want option that users can edit their email address from Sogo web -> >>> preferences -> Imap accounts. I am running SOGo 2.2.13 and my >>> GNUstepdefaults config contains: >>> >>> # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults >>> >>> SOGoMailCustomFromEnabled >>> >>> YES >>> >>> SOGoUserSources >>> >>> >>> >>> >>> >>> But the option in webmail is still greyed out: >>> >>> >>> What am I missing? >>> >> >> I am not sure, 2.2.13 already had that functionality or not. >> But the field always looks greyed out. >> Can you edit the field after restarting sogod and memcached? >> >> There was a fix recently, which prevented setting email addresses which >> belonged to the user already. >> This will be part of the next version if I remember correctly. >> > > Have to correct myself :-) > That fix is already in 2.3.17 > -- 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
RE: [SOGo] Sogo change "from address" from GUI
Hello, The key in sogo config SOGoMailCustomFromEnabled has been in my config since I started using SOGO (few years ago). I have restarted my server multiple times, but still can not edit email address from preferences. So I think restarting sogod and memcached have no effect in here. Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -Original Message- From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of Christian Mack Sent: Friday, November 4, 2016 12:40 PM To: users@sogo.nu Subject: Re: [SOGo] Sogo change "from address" from GUI Hello Am 02.11.2016 um 10:52 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): > > I want option that users can edit their email address from Sogo web -> > preferences -> Imap accounts. I am running SOGo 2.2.13 and my > GNUstepdefaults config contains: > > # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults > > SOGoMailCustomFromEnabled > > YES > > SOGoUserSources > > > > > > But the option in webmail is still greyed out: > > > What am I missing? > I am not sure, 2.2.13 already had that functionality or not. But the field always looks greyed out. Can you edit the field after restarting sogod and memcached? There was a fix recently, which prevented setting email addresses which belonged to the user already. This will be part of the next version if I remember correctly. Gruß Christian -- 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
RE: [SOGo] Sogo change "from address" from GUI
Hello, So to get this feature, I have to upgrade sogo to at least 2.3.17 version? Is this fix included in sogo v3? Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -Original Message- From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of Christian Mack Sent: Friday, November 4, 2016 1:06 PM To: users@sogo.nu Subject: Re: [SOGo] Sogo change "from address" from GUI Am 04.11.2016 um 11:39 schrieb Christian Mack (christian.m...@uni-konstanz.de): > Hello > > Am 02.11.2016 um 10:52 schrieb "Raido Rinaldi" (ra...@kuvarnet.ee): >> >> I want option that users can edit their email address from Sogo web -> >> preferences -> Imap accounts. I am running SOGo 2.2.13 and my >> GNUstepdefaults config contains: >> >> # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults >> >> SOGoMailCustomFromEnabled >> >> YES >> >> SOGoUserSources >> >> >> >> >> >> But the option in webmail is still greyed out: >> >> >> What am I missing? >> > > I am not sure, 2.2.13 already had that functionality or not. > But the field always looks greyed out. > Can you edit the field after restarting sogod and memcached? > > There was a fix recently, which prevented setting email addresses which > belonged to the user already. > This will be part of the next version if I remember correctly. > Have to correct myself :-) That fix is already in 2.3.17 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
RE: [SOGo] Sogo change "from address" from GUI
Anyone? Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 <mailto:ra...@kuvarnet.ee> ra...@kuvarnet.ee <http://www.kuvarnet.ee/> Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | <http://www.kuvarnet.ee/> www.kuvarnet.ee | <http://www.ithooldus.net/> ithooldus.net From: Raido Rinaldi [mailto:ra...@kuvarnet.ee] Sent: Wednesday, November 2, 2016 11:53 AM To: users@sogo.nu Subject: Sogo change "from address" from GUI Hello, I want option that users can edit their email address from Sogo web -> preferences -> Imap accounts. I am running SOGo 2.2.13 and my GNUstepdefaults config contains: # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults SOGoMailCustomFromEnabled YES SOGoUserSources But the option in webmail is still greyed out: What am I missing? Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 <mailto:ra...@kuvarnet.ee> ra...@kuvarnet.ee <http://www.kuvarnet.ee/> Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | <http://www.kuvarnet.ee/> www.kuvarnet.ee | <http://www.ithooldus.net/> ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Sogo change "from address" from GUI
Hello, I want option that users can edit their email address from Sogo web -> preferences -> Imap accounts. I am running SOGo 2.2.13 and my GNUstepdefaults config contains: # more /var/lib/sogo/GNUstep/Defaults/.GNUstepDefaults SOGoMailCustomFromEnabled YES SOGoUserSources But the option in webmail is still greyed out: What am I missing? Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 <mailto:ra...@kuvarnet.ee> ra...@kuvarnet.ee <http://www.kuvarnet.ee/> Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | <http://www.kuvarnet.ee/> www.kuvarnet.ee | <http://www.ithooldus.net/> ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Upgrading from 2.2.13 to 3.x
Hello, I am currently running version 2.2.13 and I want to upgrade to version 3. Can I upgrade directly to version 3 or do I need to upgrade to 2.3 at first and then to ver. 3? I am asking because in upgrade guide there is instructions for running script after upgrading to 2.3 Run the shell script sql-update-2.2.17_to_2.3.0.sh or sql-update-2.2.17_to_2.3.0-mysql.sh (if you use MySQL). Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 <mailto:ra...@kuvarnet.ee> ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | <http://www.kuvarnet.ee/> www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Upgrading from 2.2.13 to 3.x
Hello, I am currently running version 2.2.13 and I want to upgrade to version 3. Can I upgrade directly to version 3 or do I need to upgrade to 2.3 at first and then to ver. 3? I am asking because in upgrade guide there is instructions for running script after upgrading to 2.3 Run the shell script sql-update-2.2.17_to_2.3.0.sh or sql-update-2.2.17_to_2.3.0-mysql.sh (if you use MySQL). Tervitades / Best regards, Raido Rinaldi vanemtehnik Mob. 510 2834 <mailto:ra...@kuvarnet.ee> ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | <http://www.kuvarnet.ee/> www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problem with WebDav synicng
to update the item in the source. [0x000D] 2015-07-27 11:15:04.690 0x095C Changes made to http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal: Added: 0 Updated: 3 Deleted: 0 2015-07-27 11:15:15.331 0x2008 '\\Erakaustad\Kontaktid' and 'http://sogo.metec.ee/SOGo/dav/tambet/Contacts/personal' are up to date. 2015-07-27 11:16:31.485 0x2008 Synchronizing changes between '\\Erakaustad\Kalender' and 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. 2015-07-27 11:16:31.836 0x095C *** ERROR *** Unable to update item 04008200E00074C5B7101A82E008104482A42146D0011000DE4903BFC38B614DAAB7A561EA8FDCBB.ics in Source 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. The action was not allowed by the server. [0x0307] (0x0307) 2015-07-27 11:16:31.836 0x095C *** WARNING *** Update Item error but attempting to continue. 2015-07-27 11:16:34.969 0x26C4 Errors occurred: Failed to update the item in the source. [0x000D] 2015-07-27 11:16:34.979 0x26C4 Changes made to http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal: Added: 0 Updated: 3 Deleted: 0 2015-07-27 11:17:57.890 0x2008 Synchronizing changes between '\\Erakaustad\Kalender' and 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. 2015-07-27 11:17:58.180 0x1698 *** ERROR *** Unable to update item 04008200E00074C5B7101A82E008104482A42146D0011000DE4903BFC38B614DAAB7A561EA8FDCBB.ics in Source 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. The action was not allowed by the server. [0x0307] (0x0307) 2015-07-27 11:17:58.180 0x1698 *** WARNING *** Update Item error but attempting to continue. 2015-07-27 11:17:59.200 0x0F04 Errors occurred: Failed to update the item in the source. [0x000D] 2015-07-27 11:17:59.210 0x0F04 Changes made to http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal: Added: 0 Updated: 3 Deleted: 0 2015-07-27 11:19:18.482 0x2008 Synchronizing changes between '\\Erakaustad\Kalender' and 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. 2015-07-27 11:19:20.353 0x23C0 *** ERROR *** Unable to update item 04008200E00074C5B7101A82E008104482A42146D0011000DE4903BFC38B614DAAB7A561EA8FDCBB.ics in Source 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. The action was not allowed by the server. [0x0307] (0x0307) 2015-07-27 11:19:20.363 0x23C0 *** WARNING *** Update Item error but attempting to continue. 2015-07-27 11:19:21.523 0x23C0 Errors occurred: Failed to update the item in the source. [0x000D] 2015-07-27 11:19:21.533 0x23C0 Changes made to http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal: Added: 0 Updated: 3 Deleted: 1 2015-07-27 11:20:41.069 0x2008 Synchronizing changes between '\\Erakaustad\Kalender' and 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. 2015-07-27 11:20:44.360 0x2128 *** ERROR *** Unable to update item 04008200E00074C5B7101A82E008104482A42146D0011000DE4903BFC38B614DAAB7A561EA8FDCBB.ics in Source 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. The action was not allowed by the server. [0x0307] (0x0307) 2015-07-27 11:20:44.360 0x2128 *** WARNING *** Update Item error but attempting to continue. 2015-07-27 11:20:51.040 0x2008 *** ERROR *** Unable to add item 04008200E00074C5B7101A82E00880A3FDABFD03D00110009BA931902398C8478CB6E37ED1856CBD in Source 'http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal'. Internal Error: Internal state wrong for current operation. [0x0003] (0x0003) 2015-07-27 11:20:51.040 0x2008 *** WARNING *** Add Item error but attempting to continue. 2015-07-27 11:20:51.040 0x2008 Errors occurred: Failed to add the item to the source. [0x000C] 2015-07-27 11:20:51.040 0x2008 Changes made to http://sogo.metec.ee/SOGo/dav/tambet/Calendar/personal: Added: 0 Updated: 3 Deleted: 0 2015-07-27 11:20:58.016 0x2008 '\\Erakaustad\Kontaktid' and 'http://sogo.metec.ee/SOGo/dav/tambet/Contacts/personal' are up to date. Any ideas, how to troubleshoot this issue? -- Tervitades / Best regards, Raido Rinaldi hooldustehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] lost calendar after 2.3 upgrade
Hello, you need to run database upgrade script. See sogo upgrade instructions. On 14.06.2015 12:23, Alain Abbas wrote: Hello After a 2.3 upgrade 2.2.9 to 2.3 i lost my personal calendar. the datas seems in the database and if a set a caldav sync (with galaxy) i see all my appointments. In the log : [ERROR] 0x0x7f50ddfb2410[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_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoquentinp002520e295a_quick a, sogoquentinp002520e295a b WHERE ((c_component = 'vevent') AND (c_classification != 1) AND ((c_startdate IS NULL) OR (c_startdate = 1436133599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate = 1433109600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x7f50ddfc7360 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7f50dd993de0[PostgreSQL72Channel]: connection=0x0x7f50dd7ce4d0[PGConnection]: connection=0x0x7f50dd7cc490): ERREUR: la colonne a.c_description n'existe pas LIGNE 1 : ..._priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_descri... Seems the column c_description is missing somebody had the same problem? -- *Alain Abbas* 11 rue Robert Schumann 54500 Vandoeuvre Tel : +333 83 18 02 70 skype: alain.abbas -- Raido Rinaldi raido.rina...@gmail.com 533 253 11 --- Seda e-posti on pahavara suhtes Avast viirusetõrjega kontrollitud. https://www.avast.com/antivirus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can not run sql-update-2.1.17_to_2.3.0-mysql.sh
Remark: I upgraded to 2.3 from 2.17a if it makes any difference. 2015-06-05 4:22 GMT+03:00 westlake westlake2...@videotron.ca: here i updated a system from squeeze to jessie debian which I merely just ran two alter statements for each calendar table. if you look at the script you get the main sql select statement to determine which tables need later updating. first get the calendar table/s that need updating, select SUBSTRING_INDEX(c_quick_location, '/', -1) from $indextable where c_path3 = 'Calendar' here I had two calendar tables so i had to apply these following two commands for each one ALTER TABLE $table MODIFY c_partstates mediumtext ALTER TABLE $table ADD COLUMN c_description mediumtext you can find out what is $indextable by seeing which table has c_path3 if you're using mysql client it should be relatively easy eg, \r sogo describe tables; and then try the first, here for me it was describe sogo_folder_info; // and this one showed me c_path3 , so to list what the calendar tables are you use the __folder_info table, which in my case it was sogo_folder_info select SUBSTRING_INDEX(c_quick_location, '/', -1) from sogo_folder_info where c_path3 = 'Calendar' ; result for me was two calendar tables sogoadmin000_quick sogowlake111_quick the alter statements then looks something like this, ALTER TABLE sogoadmin000_quick MODIFY c_partstates mediumtext; ALTER TABLE sogoadmin000_quick ADD COLUMN c_description mediumtext; the same two commands again but with the other calendar table .. Hope this helps to fix the problem with updating -- I suppose you're using a debian-based system similarly to the one I'm using. not to be rude but is calendaring reminders supported on the sogo server? I asked this on the mailinglist yesterday but got no reply. I thought it was not so an intrusive question but of its simplicity a good yes or no would do. thanks -- users@sogo.nu https://inverse.ca/sogo/lists -- Parimatega, Raido Rinaldi hooldustehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can not run sql-update-2.1.17_to_2.3.0-mysql.sh
Ludovic can you make this kind of script for me that drops c_descriprion colums before (if they exist) and then continue rest of the script? I am not very good at sripting. 2015-06-04 21:08 GMT+03:00 Ludovic Marcotte lmarco...@inverse.ca: On 04/06/2015 14:05, Fabrice Rossi wrote: I know but for some reasons several of the quick tables in my database had already a c_description column. So I had to drop them before being able to run the script to completion. I really don't know where they came from. Most likely not from SOGo - there was absolutely nothing that ever referenced the word 'c_description' in SOGo prior v2.3. -- 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 -- Parimatega, Raido Rinaldi hooldustehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can not run sql-update-2.1.17_to_2.3.0-mysql.sh
I also have used only stable releases. Fabrice please let me now as soon as possible if you discover something useful. I need to get calendars working quickly. 2015-06-04 21:43 GMT+03:00 Fabrice Rossi fabrice.ro...@apiacoa.org: Le 04/06/2015 20:10, Ludovic Marcotte a écrit : Most likely not from SOGo - there was absolutely nothing that ever referenced the word 'c_description' in SOGo prior v2.3. Most likely you were running two instances.. One from the nightly build, one from the release - all connected to the same database. Some resources were created by the nightly builds and thus, would contain the c_description column. I've only ever been running the stable releases for ubuntu using your repository. Maybe I try to run the update script while sogo was also running, I'm not sure. Fabrice -- users@sogo.nu https://inverse.ca/sogo/lists -- Parimatega, Raido Rinaldi hooldustehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Gmail calendar to SOGO shows only busy
Hello, I tried to export google calendar (from outlook) and import it into sogo (by webmail). I get all the dates and times, but no information about the event. Shows only busy. -- Tervitades, Raido Rinaldi hooldustehnik Mob. 510 2834 ra...@kuvarnet.ee Kuvarnet OÜ | +372 747 5542 | Riia 181C III korrus, Tartu 51014 skype: arvutihooldus | www.kuvarnet.ee | ithooldus.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Outlook 2013 ActiveSync account characters displayed as random symbols
Hello, when I send letter with symbols öäüõ (estonian alfabet symbols), letters are displayed like Ć¶Ć¤ĆµĆ¼pƶ. Is there any way to force encoding to UTF-8 so letters are correct? Raido -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists