Re: [SOGo] Read-only with new Lightning version (3.106)/ Using cache files
On 21/11/11 20:57, Paul van der Vlis wrote: Op 21-11-11 16:55, Julian Robbins schreef: On 21/11/2011 15:48, Paul van der Vlis wrote: Hello, After installing the new Lighning plugin from the Sogo site, my calendars are read-only. After installing version 3.105 again everything works fine. You may have to recreate the cache files in calendar-data in your users Thunderbird profiles. How do you do that? In Linux, you'll find a .thunderbird in your users home dir, in Windows type in %Appdata% in the run box and you get to your user's 'documents and settings' folder. Go to Thunderbird. Then you'll see a 'calendar-data' sub folder. In here you will see 2 (possibly 3) files. * cache.sqlite * caldav-acl.sqlite (possibly only seen with lightning 106i) * local.sqlite (if you had any calendar events stored locally in Lightning before) I'm not an expert on this, but if you delete the .sqlite files (when Thunderbird isn't running), and restart, then Thunderbird will recreate these files again as a local cache of calendar events and tasks. This might take a few minutes, and Thunderbird won't respond to normal requests whilst its doing this. Likewise the caldav-acl file (much much smaller in size) I believe is the acl data, permissions on your lightning/sogo calendars. You can of course look at these files, and edit them if you want with a sqllite browser such as the GPL SQLite Database Browser In Linux and Windows too. I've found that if you get issues with broken calendars, quite often its because the cache data isn't the same as that on the server. The server is likely to be correct. Sometimes, events are deleted from the sogo server, but aren't properly deleted from the local cache, due to issues with permissions. This is a trick I use sometimes if I get problems, your mileage may vary. I've also found that deleting the cache files helps if a user somehow ends up upgrading to Thunderbird 7/8 with its newer lightning version, and you need to go back to Thunderbird 3.1 with SOGo. I think there was a significant change in working with acl between sogo lightning builds of 105 and 106, and same in std lightning builds, which this can help correct, if necessary. Might be handy if Inverse can comment or have any further docs on how these cache files work, to better fully understand what happens. Julian With regards, Paul. -- Kind Regards, Julian Robbins Web Marketing and IT Manager Q-par Angus Ltd, Barons Cross Laboratories, Leominster, Herefordshire, HR6 8RS, United Kingdom Telephone +44 (0) 1568 612138, Fax +44 (0) 1568 616373, Web www.q-par.com IDEAS ENGINEERED - SPECIALISTS IN MICROWAVE and RF ENGINEERING (Registered office) Incorporated in England No 1826221 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] more flexible contacts search
On 17.11.2011 13:10, a.roma...@gctrials.com wrote: Hello everybody, Is there a way to add more attributes as options to Address Book search/filter? Now there are only two: Name and Email and Category. I think it would be great to have also the possibility to search by organization, position, address (city and country), birthday date, etc. Any ideas? Thanks! Best, Anton ehlo.a. yes. it is possible to do that. I've implemented that for few users. Look here : https://developer.mozilla.org/en/Thunderbird/Hidden_prefs and search for mail.addr_book.quicksearchquery.format You can define this per user on his thunderbird config using advanced editor settings or you can push that config globaly using sogo-integrator.js file included in sogo-intergrator ( howto modify sogo-intergrator.js for your site - this is described on inverse web page (as I remember ) or look to this mail list archive ) -- Marek Czardybon Dział IT 3S Śląskie Sieci Światłowodowe tel. 032 428 83 58 e-mail m.czardy...@3s.pl *** TKP S.A. ul. Chorzowska 50, 44-100 GLIWICE tel: 032 428 83 00, fax: 032 330 44 21 Regon: 277704261; NIP: 969-12-97-176 KRS: 095232 (Sąd Rejonowy w Gliwicach X Wydz. Gospodarczy) Kapitał zakładowy: 536.000,00 zł opłacony w całości -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Read-only with new Lightning version (3.106)/ Using cache files
Op 22-11-11 10:31, Julian Robbins schreef: On 21/11/11 20:57, Paul van der Vlis wrote: Op 21-11-11 16:55, Julian Robbins schreef: On 21/11/2011 15:48, Paul van der Vlis wrote: Hello, After installing the new Lighning plugin from the Sogo site, my calendars are read-only. After installing version 3.105 again everything works fine. You may have to recreate the cache files in calendar-data in your users Thunderbird profiles. How do you do that? In Linux, you'll find a .thunderbird in your users home dir, in Windows type in %Appdata% in the run box and you get to your user's 'documents and settings' folder. Go to Thunderbird. Then you'll see a 'calendar-data' sub folder. In here you will see 2 (possibly 3) files. * cache.sqlite * caldav-acl.sqlite (possibly only seen with lightning 106i) * local.sqlite (if you had any calendar events stored locally in Lightning before) I'm not an expert on this, but if you delete the .sqlite files (when Thunderbird isn't running), and restart, then Thunderbird will recreate these files again as a local cache of calendar events and tasks. This might take a few minutes, and Thunderbird won't respond to normal requests whilst its doing this. Likewise the caldav-acl file (much much smaller in size) I believe is the acl data, permissions on your lightning/sogo calendars. You can of course look at these files, and edit them if you want with a sqllite browser such as the GPL SQLite Database Browser In Linux and Windows too. I've found that if you get issues with broken calendars, quite often its because the cache data isn't the same as that on the server. The server is likely to be correct. Sometimes, events are deleted from the sogo server, but aren't properly deleted from the local cache, due to issues with permissions. This is a trick I use sometimes if I get problems, your mileage may vary. I've also found that deleting the cache files helps if a user somehow ends up upgrading to Thunderbird 7/8 with its newer lightning version, and you need to go back to Thunderbird 3.1 with SOGo. I think there was a significant change in working with acl between sogo lightning builds of 105 and 106, and same in std lightning builds, which this can help correct, if necessary. Might be handy if Inverse can comment or have any further docs on how these cache files work, to better fully understand what happens. Thanks for the information, this can be handy in case of problems. But I don't think this is a nice upgrade path for my customers... There are not so many, but this is complex to explain. Not sure this happens all the time, I've tried it on two machines now, and both have this problem. Are here other people who have this problem or don't have this problem after upgrading to 3.106 ? Is there documentation on how to upgrade to 3.106 ? With regards, Paul. -- Paul van der Vlis Linux systeembeheer Groningen http://www.vandervlis.nl -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo calendars but no addr books
Hello Is it possible to have a full SOGo setup, ie SOGo calendars, webmail, addressbooks, using Thunderbird/Lightning with Connector and Integrator but only use Thunderbirds local addressbooks? Using all latest SOGo and Thunderbird 3.1 with latest Connector and Integrator. I ask this because with Integrator/Connector Thunderbird wants to connect to the address books on the SOGo server, whereas I don't want any addr books to be on there (as Thunderbird 3.1 usage of carddav addr books is quite buggy). If I remove Integrator, then address books stay local; but then the buttons to add SOGo calendars and ability to subscribe to a calendar are lost from using the Calendars in Thunderbird ... I want them back . :-) -- Kind Regards, Julian -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Missing packages for centos6
Hello all, The nightly build repo is missing the sogo package, is there a workaround for this besides building from source? Thanks! -Eric -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] What can I do with categories?
Hello, Categories are a nice feature, but I don't know what I can do with it except seeing it. Let's say a category is family, can I send e.g. an e-mail to all people in that category? With regards, Paul. -- Paul van der Vlis Linux systeembeheer Groningen http://www.vandervlis.nl -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Tuesday, November 22 2011
Title: BTS activities for Tuesday, November 22 2011 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Tuesday, November 22 2011 idlast updatestatus (resolution)categorysummary 1504 2011-11-22 12:36:12 updated (open) SOPE SOGo installation for Ubuntu 11.10 1505 2011-11-22 08:26:42 new (open) Web Mail image attachment not scaled down to sensible sizes on windows 1506 2011-11-22 08:31:00 new (open) Web Mail file attachment menu overwriting our logo 1507 2011-11-22 08:44:51 new (open) Web Mail mail composer should offer text or html as option 1508 2011-11-22 08:48:46 new (open) Web Mail sogo should have a message size limit
Re: [SOGo] Read-only with new Lightning version (3.106)/ Using cache files
On 22/11/2011 14:41, Paul van der Vlis wrote: Op 22-11-11 10:31, Julian Robbins schreef: On 21/11/11 20:57, Paul van der Vlis wrote: Op 21-11-11 16:55, Julian Robbins schreef: On 21/11/2011 15:48, Paul van der Vlis wrote: Hello, After installing the new Lighning plugin from the Sogo site, my calendars are read-only. After installing version 3.105 again everything works fine. You may have to recreate the cache files in calendar-data in your users Thunderbird profiles. How do you do that? In Linux, you'll find a .thunderbird in your users home dir, in Windows type in %Appdata% in the run box and you get to your user's 'documents and settings' folder. Go to Thunderbird. Then you'll see a 'calendar-data' sub folder. In here you will see 2 (possibly 3) files. * cache.sqlite * caldav-acl.sqlite (possibly only seen with lightning 106i) * local.sqlite (if you had any calendar events stored locally in Lightning before) I'm not an expert on this, but if you delete the .sqlite files (when Thunderbird isn't running), and restart, then Thunderbird will recreate these files again as a local cache of calendar events and tasks. This might take a few minutes, and Thunderbird won't respond to normal requests whilst its doing this. Likewise the caldav-acl file (much much smaller in size) I believe is the acl data, permissions on your lightning/sogo calendars. You can of course look at these files, and edit them if you want with a sqllite browser such as the GPL SQLite Database Browser In Linux and Windows too. I've found that if you get issues with broken calendars, quite often its because the cache data isn't the same as that on the server. The server is likely to be correct. Sometimes, events are deleted from the sogo server, but aren't properly deleted from the local cache, due to issues with permissions. This is a trick I use sometimes if I get problems, your mileage may vary. I've also found that deleting the cache files helps if a user somehow ends up upgrading to Thunderbird 7/8 with its newer lightning version, and you need to go back to Thunderbird 3.1 with SOGo. I think there was a significant change in working with acl between sogo lightning builds of 105 and 106, and same in std lightning builds, which this can help correct, if necessary. Might be handy if Inverse can comment or have any further docs on how these cache files work, to better fully understand what happens. Thanks for the information, this can be handy in case of problems. But I don't think this is a nice upgrade path for my customers... There are not so many, but this is complex to explain. Not sure this happens all the time, I've tried it on two machines now, and both have this problem. Are here other people who have this problem or don't have this problem after upgrading to 3.106 ? yep While migrating from thunder 2 to thunder 3.16 we have a lot of calendars which hangs with the 3.106 extension. the main thunderbird interface does'nt show and the only way i have is to kill the thunderbird process and destroy the sqlite files. Then i can restart thunderbird. What's more some calendars are very long to get their cache after destroying it ( 20min for a 8Mo cache.sqlite ?) . the other problem is that the main thread of thunderbird doesn't respond while the extension is trying to get the cache. i'm searching explications or solutions too Is there documentation on how to upgrade to 3.106 ? With regards, Paul. -- users@sogo.nu https://inverse.ca/sogo/lists
