[SOGo] BTS activities for Thursday, April 14 2011
Title: BTS activities for Thursday, April 14 2011 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Thursday, April 14 2011 idlast updatestatus (resolution)categorysummary 1264 2011-04-14 11:09:17 new (open) Backend Calendar CalDAV PUT of an externally generated invite does not generate a valid REPLY object 1252 2011-04-14 03:37:59 updated (open) Web Mail Bad visualization with gb2312 charset 1255 2011-04-14 21:49:47 assigned (open) Backend Calendar Events with no ENDDT: in ics File 1246 2011-04-14 21:09:37 resolved (fixed) Web Calendar Not all e-mail addresses can be entered/edited/deleted in the web-addressbook 1253 2011-04-14 11:36:31 closed (fixed) Web General Contact lists don't expand correctly
Re: [SOGo] ANN: SOGo v1.3.6
El 13/04/11 07:01, Anthony Milan escribió: > Starting SOGo: sogo/usr/sbin/sogod: error while loading shared > libraries: libgnustep-base.so.1.16: cannot open shared object file: No > such file or directory > already running. Hi, I haven't made the upgrade yet, and my server has a libgnustep-base.so.1.16 file which is really a link to a real file named libgnustep-base.so.1.16.1 If you don't have this link in /usr/lib maybe just creating it may solve the problem... Greetings, -- Roberto -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Auto-complete Address
https://bugzilla.mozilla.org/show_bug.cgi?id=608041 Very cyclic question, someone having this problem should post a trace on the bug. I tried doing a trace as described in the bugreport. But I don't get any log using (NSPR_LOG_MODULES=timestamp,ldap:5). Wiht smtp:5 or all:5 I get some logs but nothing regarding ldap. Do the Plugins from sogo change some behaviour there? I think one wants to log the carddav traffic as I believe it is the query to the carddav addressbook that is causing the problems. Unfortunately, I haven't figured out how to do that. Ben -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo and LDAP adressbook
Hi, my users has a similar configuration in LDAP server: dn: mail=mat...@domains.net,vd=domains.net,o=users,dc=server,dc=it where "mail=" is the user box. I has modify .GNUstepDefaults: CNFieldName = cn; IDFieldName = mail; IMAPHostFieldName = mailHost; UIDFieldName = mail; baseDN = "vd=domains.net,o=users,dc=server,dc=it"; bindDN = "cn=admin,dc=server,dc=it"; bindPassword = **; canAuthenticate = YES; displayName = "AddressBook"; hostname = localhost; id = public; isAddressBook = YES; port = 389; users logon correctly but when open a "AddressBook" I don't found any users in adressbook. Is there a way to find users? thanks -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] contact categories
Hi I went thru the manual and found a parameter "SOGoContactsCategories" that is used to define the categories that can be associated to contacts. Has anyone an example how a list could look like ? How do you match it to the fields of the database or ldap directory ? Any help appreciated. -- Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net
Re: [SOGo] Problem with mailstore SOGo.
Hi Jesus Did you doublecheck your imap settings. Do the users need to logon with their email addresses instead of user account. Do you use tls or ssl ? These are the first settings I would look into. Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Am Donnerstag, 14. April 2011 11:52 CEST, Jesús Alba Rivas schrieb: Good Mornings, we are having problem with sogo, specifically with the mailstore. Sogo is connect with ldap, we can logger into web interface and to send mails, but we dont see the users mailstore. Have anyone some idea? Thanks so much :)= -- users@sogo.nu https://inverse.ca/sogo/lists -- Mit freundlichem Gruß
Re: [SOGo] Bad visualization with gb2312 charset
On 13/04/2011 13:58, Christian Mack wrote: Hi I only had this if one part at least is in GBK encoding, either Content-Type: text/plain; charset=x-gbk I have sync e-mail from a MS Exchange to sogo, i have a lot of e-mail with this charset, and I can't visualize them correctly. It's very bad!! Can anyone help me? Thanks -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
2011/4/14 André Schild : > But they are not downloaded > You should see a request for the perso.xpi file as well in the logs. Yup, I finally figured that. For some reason, I believed the downloads were part of those requests. Silly me. > Do you perhaps have a mixup of host names and ip addresses, > or some kind of http/https differences ? No, it's just the "updateLink" field in updates.php. I should be good now. At least on my newly created test profile. Sorry for the noise. -- Olivier -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] problem address book thunderbird
hi all, i have a problem with shared address book on thunderbird!! i have make a new address book (named CSC) on SOGo (web interface) and will have added all authenticated user to read and write this address book!! on web interface this work correctly!! but if i configure thunderbird to read a remote address book not show any entry!! can you help me?? on thunderbird (3.1.9) i have install sogo-integrator (modified with my ip server) and i added new shared book address with these settings: name: csc url: http://192.168.1.53/SOGo/dav/luciano/Contacts/csc I also tried to configure the personal address book (http://192.168.1.53/SOGo/dav/luciano/Contacts/personal), but even that does not work. thanks and i hope for yuor help!! bye bye! Luciano Pedron -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
On Thu, Apr 14, 2011 at 2:01 PM, Olivier Migeot wrote: > Ok, just tried it on a clean profile : installed and configured > Integrator 3.104 and let it update by itself. I can now confirm : the > 3.105 update isn't installed (it might be downloaded though) on the > client side. I tweaked the package (some chars added to the COPYING > file), and clearly it's nowhere to be found client-side. I think I got it now. Let's see if I'm right : I tried to chmod my XPI to 000, and still Apache went all "oh, everything is fine, come and get that 200 code!". So there was something. I thought those calls to updates.php integrated the xpi in the response but I was wrong. So I checked the responses. These are XML, which includes an "updateLink". All of them (I mean for each and every extension) points to inverse.ca server. So clearly Integrator can't be downloaded. Which puzzles me is that it worked on the previous version... Anyway, I'll check this out and the case will be closed. -- Olivier -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
Am 14.04.2011 12:23, schrieb Olivier Migeot: 2011/4/14 André Schild: What does your webserver log tells you ? Does thunderbird realy download the sogo-integrator-3.105-sogo-perso.xpi or is perhaps a public read right missing... ? 192.168.1.82 - - [14/Apr/2011:12:03:43 +0200] "GET /updates.php?plugin=sogo-integra...@inverse.ca&version=0.00&platform=WINNT_x86-msvc HTTP/1.1" 200 387 "-" " Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2.105i Thunderbird/3.1.6" 192.168.1.82 - - [14/Apr/2011:12:03:44 +0200] "GET /updates.php?plugin=sogo-connec...@inverse.ca&version=0.00&platform=WINNT_x86-msvc HTTP/1.1" 200 380 "-" "M ozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2.105i Thunderbird/3.1.6" 192.168.1.82 - - [14/Apr/2011:12:03:44 +0200] "GET /updates.php?plugin=%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D&version=0.00&platform=WINNT_x86-msvc HTTP/1. 1" 200 410 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2.105i Thunderbird/3.1.6" From what I understand, the three extenstions are correctly located (200 code). All of them are 644. But they are not downloaded You should see a request for the perso.xpi file as well in the logs. Do you perhaps have a mixup of host names and ip addresses, or some kind of http/https differences ? André -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
On Thu, Apr 14, 2011 at 12:23 PM, Olivier Migeot wrote: > So it couldn't be a problem on the client side? Like an extension who > wouldn't want to install or something? Ok, just tried it on a clean profile : installed and configured Integrator 3.104 and let it update by itself. I can now confirm : the 3.105 update isn't installed (it might be downloaded though) on the client side. I tweaked the package (some chars added to the COPYING file), and clearly it's nowhere to be found client-side. -- Olivier -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Auto-complete Address
Am 13.04.2011 10:49, schrieb Alessio Fattorini: > https://bugzilla.mozilla.org/show_bug.cgi?id=608041 > Very cyclic question, someone having this problem should post a trace on > the bug. I tried doing a trace as described in the bugreport. But I don't get any log using (NSPR_LOG_MODULES=timestamp,ldap:5). Wiht smtp:5 or all:5 I get some logs but nothing regarding ldap. Do the Plugins from sogo change some behaviour there? 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] SOGo 1.3.6 rhel6 and other
Hello, I tried your rpms for RHEL 6 and it works well. Good work - thanks. However, I think, perhaps it would be good to use RHEL build platform so pacakages looks the similar with RHEL series. That maybe helpful for other people when troubleshooting sogo in their RHEL machine. Cheers, A On 04/13/2011 11:07 AM, Fabrice Durand wrote: Hi, i just finish to test SOGo rpm on rhel 6 x86_64 server. The library name are little more bit different due to make rpm compatible with opensuse rpm pakages. I was using the openSUSE build plateform to make thoses rpms (https://build.opensuse.org/) rpm are here for rhel6 and for other distrib: http://oeufdure.free.fr/wordpress/?p=261 Regards Fabrice Durand -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] PraseTimezone
Dear all, I just installed 1.3.6 on new rhel 6 machine. It looks everthing works but I get error below in my sogo.log here is my /etc/sysconfig/clock output ZONE="Atlantic/Reykjavik" UTC=true ARC=false And I added line in sogo config SOGoTimeZone Atlantic/Reykjavik I constantally getting this error when I select "mail", calendar. I can do everything in sogo despite this error. It would be great if someone can pint me in right direction or help to fix this. 2011-04-14 10:59:18.188 sogod[12134] Note: using 'UCS-2LE' on Linux. 2011-04-14 10:59:18.192 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.192 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.193 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.206 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.206 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.215 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.215 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' 2011-04-14 10:59:18.215 sogod[12134] parseTimeZone: cannot parse time notation 'GMT' Regards, Anil -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] ERROR: relation "sogo_view" does not exist
Hi, I'm a newcomer and have some big problems to get my first new installation working on Ubuntu 10 LTS 64 bit. I searched the archives of the mailing list, but I couldn't find any answer about the subject. I followed the steps in the Installation guide (1.3.6), but it seems that there are no the table with the data for user authentication. I'd like to know how to get authentication working only with SQL (Postgres), no LDAP, how can I import my user data from a Linux mailserver where authentication was based on password file (I already generated a password file with the effective md5 password included). It is, I'd need the structure of the table where to import and eventually the bindings with other table to fill approprately and to know if there are some script to generate such tables and view. Here you can find the log errors about the view that doesn't exist when I try to authenticate from the web as jdoe with password qwerty as described in the manual and at the end my .GNUstepDefaults. Apr 14 09:15:14 sogod [1201]: SOGoRootPage Login for user 'jdoe' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 mailsogo.comune.cossato.bi.it - - [14/Apr/2011:09:15:14 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/58 0.004 - - 0 localhost - - [14/Apr/2011:09:37:53 GMT] "GET /SOGo HTTP/1.1" 302 0/0 0.006 - - 0 localhost - - [14/Apr/2011:09:37:53 GMT] "GET /SOGo/ HTTP/1.1" 200 2113/0 0.005 - - 0 localhost - - [14/Apr/2011:10:24:51 GMT] "GET /SOGo HTTP/1.1" 302 0/0 0.009 - - 0 2011-04-14 10:24:51.581 sogod[1201] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!! localhost - - [14/Apr/2011:10:24:51 GMT] "GET /SOGo/ HTTP/1.1" 200 3453/0 0.021 10508 67% 0 Apr 14 10:25:14 sogod [1201]: [ERROR] <0x0x25b6ca0[SQLSource]> could not run SQL 'SELECT c_password FROM sogo_view WHERE c_uid = 'jdoe'': NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x2ad0b10[PostgreSQL72Channel]: connection=<0x0x2b6a140[PGConnection]: connection=0x0x2b6e520>>): ERROR: relation "sogo_view" does not exist LINE 1: SELECT c_password FROM sogo_view WHERE c_uid = 'jdoe' My .GNUstepDefaults: http://www.gnustep.org/plist-0_9.xml";> NSGlobalDomain sogod OCSFolderInfoURL postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info OCSSessionsFolderURL postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder SOGoACLsSendEMailNotifications YES SOGoAppointmentSendEMailNotifications YES SOGoDraftsFolderName Drafts SOGoFoldersSendEMailNotifications YES SOGoIMAPServer localhost SOGoLanguage Italian SOGoMailDomain comune.cossato.bi.it SOGoMailingMechanism smtp SOGoProfileURL postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile SOGoSMTPServer localhost SOGoSentFolderName Sent SOGoTimeZone Europe/Rome SOGoTrashFolderName Trash SOGoUserSources canAuthenticate YES id id directory isAddressBook YES type sql userPasswordAlgorithm md5 viewURL postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view Thanks to replying people, redards to all, Andrea Ferraris A.d.S. CED Comune di Cossato Tel. fisso: 015/9893235 Tel. cell.: 329/2107393 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] sogot-tool backup strangeness
Hello, we are using sogo 1.3.6 with the new multi-domain capable sogo-tool. A strange thing we see: Running "sogo-tool -v backup /backup/sogo ALL" gives 20 files Running "sogo-tool -v backup /home/sogo/backup ALL" gives 13 files This is a multi domain setup and in both cases I see accounts from different domains André -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
2011/4/14 André Schild : > What does your webserver log tells you ? > > Does thunderbird realy download the sogo-integrator-3.105-sogo-perso.xpi or > is perhaps a public read right missing... ? 192.168.1.82 - - [14/Apr/2011:12:03:43 +0200] "GET /updates.php?plugin=sogo-integra...@inverse.ca&version=0.00&platform=WINNT_x86-msvc HTTP/1.1" 200 387 "-" " Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2.105i Thunderbird/3.1.6" 192.168.1.82 - - [14/Apr/2011:12:03:44 +0200] "GET /updates.php?plugin=sogo-connec...@inverse.ca&version=0.00&platform=WINNT_x86-msvc HTTP/1.1" 200 380 "-" "M ozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2.105i Thunderbird/3.1.6" 192.168.1.82 - - [14/Apr/2011:12:03:44 +0200] "GET /updates.php?plugin=%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D&version=0.00&platform=WINNT_x86-msvc HTTP/1. 1" 200 410 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2.105i Thunderbird/3.1.6" From what I understand, the three extenstions are correctly located (200 code). All of them are 644. > For some reasons TB is NOT retrieving that perso.xpi So it couldn't be a problem on the client side? Like an extension who wouldn't want to install or something? > Can you post the full url to the update script ? Sadly, it's not on a public URL yet. But I can provide you that file's content. -- Olivier -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
Am 14.04.2011 12:10, schrieb Olivier Migeot: 2011/4/14 André Schild: No, Good to hear. So I got something... it should also upgrade to 3.105.. So perhaps you just put the wrong integrator on your webserver ? Well, I'm pretty sure I did not. Here's what I'm doing (just re-done it to be sure): (In the same directory as updates.php, and I deleted all previous XPIs) mkdir test cd test wget "http://www.sogo.nu/files/downloads/extensions/sogo-integrator-3.105-sogo-demo.xpi"; unzip sogo-integrator-3.105-sogo-demo.xpi rm sogo-integrator-3.105-sogo-demo.xpi vim chrome/content/extensions.rdf (changed the server name and added lightning) zip -r ../sogo-integrator-3.105-sogo-perso.xpi . and updates.php clearly points my customized XPI... What does your webserver log tells you ? Does thunderbird realy download the sogo-integrator-3.105-sogo-perso.xpi or is perhaps a public read right missing... ? For some reasons TB is NOT retrieving that perso.xpi Can you post the full url to the update script ? André -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
2011/4/14 André Schild : > No, Good to hear. So I got something... > it should also upgrade to 3.105.. > So perhaps you just put the wrong integrator on your webserver ? Well, I'm pretty sure I did not. Here's what I'm doing (just re-done it to be sure): (In the same directory as updates.php, and I deleted all previous XPIs) mkdir test cd test wget "http://www.sogo.nu/files/downloads/extensions/sogo-integrator-3.105-sogo-demo.xpi"; unzip sogo-integrator-3.105-sogo-demo.xpi rm sogo-integrator-3.105-sogo-demo.xpi vim chrome/content/extensions.rdf (changed the server name and added lightning) zip -r ../sogo-integrator-3.105-sogo-perso.xpi . and updates.php clearly points my customized XPI... Any idea? -- Olivier -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problem with mailstore SOGo.
Good Mornings, we are having problem with sogo, specifically with the mailstore. Sogo is connect with ldap, we can logger into web interface and to send mails, but we dont see the users mailstore. Have anyone some idea? Thanks so much :)= -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
Am 14.04.2011 11:39, schrieb Olivier Migeot: On Wed, Apr 13, 2011 at 1:34 PM, Olivier Migeot wrote: Or did I miss something? Ok, a little bit more information. I delayed the "auto restart" timer to investigate a little more. What I found is that, though Connector and Lightning are correctly updated to the latest versions, Integrator _stays_ at version 3.104. Is it normal? Should it be updated only after the restart (provided it doesn't end up in an infinite loop as it does now)? No, it should also upgrade to 3.105.. So perhaps you just put the wrong integrator on your webserver ? André -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] updates.php and lightning
On Wed, Apr 13, 2011 at 1:34 PM, Olivier Migeot wrote: > Or did I miss something? Ok, a little bit more information. I delayed the "auto restart" timer to investigate a little more. What I found is that, though Connector and Lightning are correctly updated to the latest versions, Integrator _stays_ at version 3.104. Is it normal? Should it be updated only after the restart (provided it doesn't end up in an infinite loop as it does now)? Thanks. -- Olivier -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Instant Messaging
Hello, sorry for digging out this old thread. But I just found out about iJab ( http://opensource.ijab.im/ ), which is opensource and offers a solution to integrate a facebook-style xmpp chat-bar at the bottom of a webpage. For this you only need to include several js-files, which should work with SOGo using the SOGUIAdditionalJSFiles option. iJabBar also offers some kind of Single-Sign-On, by using the users cookie of the webpage to login to the xmpp server as well. But here I'm not sure if this will work with cookie provided by SOGo. Has anybody looked into this already? Cheers, Dennis Am 17.03.2010 09:56, schrieb Olivier Migeot: > On Tue, Mar 16, 2010 at 1:09 PM, Federico Alberto Sayd > wrote: > >> An ajax jabber client (like gmail chat) would be very useful in SOGo > > Maybe something around the lines of jwchat, which is mostly > client-side (given you've already deployed a BOSH-compliant jabber > server). -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.6
Just upgraded from 1.3.4 to 1.3.6 last night. Works fine. Thanks a lot. André -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SQL Error in GCSFolderManager
Hello, I just upgraded an existing SOGo installation to the latest (have run the sql-update scripts successfully), but not get an SQL error. It seems that c_path3 has an incorrect escape ( \' ) on calendars. Thanks in advance for your help. > Apr 14 10:41:33 sogod [14398]: <0x0x159d530[GCSFolderManager]> ERROR(-[GCSFolderManager folderAtPath:]): executing SQL failed: 'SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'blackboard' AND c_path3 = 'Calendar\' AND c_path4 = 'personal'' > Apr 14 10:41:33 sogod [14398]: [ERROR] <0x018092B0[SOGoAppointmentFolder]:blackboard_personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): missing folder for fetch! 2011-04-14 10:41:33.454 sogod[14398] <0x0x1312040[PostgreSQL72Channel]: connection=<0x0x11abb60[PGConnection]: connection=0x0x15fe4e0>>: message: WARNING: nonstandard use of \' in a string literal > LINE 1: ...th1 = 'Users' AND c_path2 = 'admin' AND c_path3 = 'Calendar\... > ^ > HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). > > Apr 14 10:41:33 sogod [14398]: <0x0x159d530[GCSFolderManager]> ERROR(-[GCSFolderManager performSQL:]): cannot execute SQL 'SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'admin' AND c_path3 = 'Calendar\' AND c_path4 = 'personal'': NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x1312040[PostgreSQL72Channel]: connection=<0x0x11abb60[PGConnection]: connection=0x0x15fe4e0>>): ERROR: syntax error at or near "personal" > LINE 1: ...= 'admin' AND c_path3 = 'Calendar\' AND c_path4 = 'personal' > ^ > > Apr 14 10:41:33 sogod [14398]: <0x0x159d530[GCSFolderManager]> ERROR(-[GCSFolderManager folderAtPath:]): executing SQL failed: 'SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'admin' AND c_path3 = 'Calendar\' AND c_path4 = 'personal'' > Apr 14 10:41:33 sogod [14398]: [ERROR] <0x0193CC50[SOGoAppointmentFolder]:admin_personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): missing folder for fetch! -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Address Book
Hi Sven Thank you for your advice. Maybe I will try another way and implement the administration via a web frontend in sql. Is there a way to connect to an ldap server address book? Not in the global configuration but to subscribe for every single user by its own ? But still there is the open topic, how to change the colum names and data in SOGo web interface. Has anybody ideas to share with me? Regards, Carsten Am Donnerstag, 14. April 2011 08:30 CEST, Sven Marth schrieb: Am 13.04.2011 23:36, schrieb Carsten Laun-De Lellis: > Hi all > > I created a user source in mysql and want to use this as address book. > It worked so far, that I can see the users in the global address book, > but I can't edit any entries. Also i want to change the colums with the > attributes in the web interface. > > Any help ? > > -- > > Mit freundlichem Gruß > > > > *Carsten Laun-De Lellis* > > Dipl.-Ing. Elektrotechnik > > Certified Information Systems Auditor (CISA) > > > > > > Hauptstrasse 13 > > D-67705 Trippstadt > > > > Phone: +49 (6306) 992140 > > Mobile: +49 (151) 27530865 > > email: carsten.delel...@delellis.net > Hi Carsten, so far I now, the global address book is read only by design. If you like to have a real "Global Address Book", setup a shared account and share that address book to all users. cu Sven -- users@sogo.nu https://inverse.ca/sogo/lists -- Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net