Re: [SOGo] Trouble with Funambol Connector
Thanks for the quick help, appreciate it. On Wed, 2011-01-12 at 23:41 -0500, Ludovic Marcotte wrote: On 11-01-12 10:17 PM, Karoly Molnar wrote: Hey Guys, I'm using latest SOGo 1.3.4 on Ubuntu Lucid, backend is PostgreSQL v8.4 everything works fine. Funambol v8.7 is also installed and I followed the documentation and created the sogo-card, sogo-cal, sogo-todo sources with the Funambol admin. I setup a BlackBerry based on the documentation and connected to the server. BB says sync went fine, but actually nothing happens. On the Funambol server the ds-server.log does show that the device is syncing with, but it syncs against the regular sources, card, cal, tasks and not the one that I set in the remote uri setting on the BB. I can even see the synced stuff on the webdemo. As I understand that should not happen. I run tcpdump and it shows that the word sogo-card never shows up in the transmitted text, but card does show up. Anybody has run into a problem like this? Yes, look at the archives. You could try to reboot the device after your changes or simply create the card (and other sources) instead of sogo-card - it's just a name afterall, and you can have both if you want. I deleted the built in card, event, task Funambol sources and added the sogo sources as card, event and task and the BB started syncing regardless what is set on the BB config. Weird. Anyway the sync works, yet I have an another problem. The events that are created by SOGo web interface are synced: [2011-01-13 11:12:25,388] [funambol.sogo] [INFO] [4A41E0BB0BC55342CB9EF1E85420AD82] [74.198.10.74] [fbb-601089840] [kmolnar] [event] Received status code '200' for a 'Add' for this items (1): - 623416264 The events that are created over the CALDAV interface by Evolution are also initiated to sync, but there's an error: [2011-01-13 11:12:25,388] [funambol.sogo] [INFO] [4A41E0BB0BC55342CB9EF1E85420AD82] [74.198.10.74] [fbb-601089840] [kmolnar] [event] Received status code '500' for a 'Add' for this items (1): - 20110111T165551Z-1898-5000-1-2_chaos-20110111T165554Z.ics Anything on that? I see that the difference is the reference name of the event. SOGo uses just numbers, Evolution uses long text. Is this a problem? Is there any other clue, that I'm missing? Thanks, Karoly 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) -- Karoly Molnar VP Engineering Eseri.com P: 888-492-9648 x333 C: 613-513-5012 email: kmol...@eseri.com web: http://www.eseri.com -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problems with authentication
Hi all I installed sogo new but ran into a problem while logging on to the server: I cannot login because of the following error message: wrong user or password When I look into the log I can see this: Jan 13 17:34:47 sogod [24372]: [ERROR] 0x0x15ea14d0[SOGoUserManager] No authentication sources defined - nobody will be able to login. Check your defaults. Jan 13 17:34:47 sogod [24372]: SOGoRootPage Login for user 'carsten.delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [13/Jan/2011:17:34:47 GMT] POST /SOGo/connect HTTP/1.1 403 34/56 0.070 - - 1M Telling me that no authentication sources defined. But as you can see in my attached GnuStepDefaults File there is a database scheme defined as authentication source. Any ideas ? ?xml version=1.0 encoding=UTF-8? !DOCTYPE plist PUBLIC -//GNUstep//DTD plist 0.9//EN http://www.gnustep.org/plist-0_9.xml; plist version=0.9 dict keyNSGlobalDomain/key dict /dict keysogod/key dict keyOCSFolderInfoURL/key stringmysql://sogouser:sogopassword@localhost:3306/sogo/sogo_user_profile /string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAUserSources/key array dict keycanAuthenticate/key stringYES/string keyid/key stringdirectory/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyuserPasswordAlgorithm/key stringnone/string keyviewURL/key stringmysql://sogouser:sogopassword@localhost:3306/sogo/sogo_mail_auth/st ring /dict /array keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoDraftsFolderName/key stringDrafts/string keySOGoEnabledPublicAccess/key stringYES/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoForwardEnabled/key stringYES/string keySOGoIMAPServer/key stringimaps://127.0.0.1:143/?tls=YES/string keySOGoLanguage/key stringGerman/string keySOGoMailAuxiliaryUserAccountEnabled/key stringYES/string keySOGoMailComposeMessageType/key stringhml/string keySOGoMailDomain/key stringdelellis.net/string keySOGoMailUserOutlookStyleReplies/key stringYES/string keySOGoMailingMechanism/key stringsmtp/string keySOGoOtherUsersFolderName/key stringOther Users/string keySOGoPasswordChangeEnabled/key stringYES/string keySOGoSMTPServer/key string127.0.0.1/string keySOGoSentFolderName/key stringSent/string keySOGoSharedFolderName/key stringShared Folders/string keySOGoSieveScriptsEnabled/key stringYES/string keySOGoSieveServer/key stringsieve://127.0.0.1/string keySOGoTimeZone/key stringEurope/Berlin/string keySOGoTrashFolderName/key stringTrash/string keySOGoVacationEnabled/key stringYES/string keyWOUseRelativeURLs/key stringYES/string /dict /dict /plist 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 mailto:carsten.laun-delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with authentication
On 11-01-13 11:41 AM, Carsten Laun-De Lellis wrote: keySOGoAUserSources/key ^- problem. -- 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] Problems with authentication
Hi Basti, hi Ludovic Thank you for your hints. After I wrote the first email I found the misconfiguration myself. But though I fixed it I still receive error messages. In the sogo.log I found the following message: Jan 13 20:54:57 sogod [30626]: [ERROR] 0x0x1044c180[SQLSource] could not run SQL 'SELECT * FROM sogo_mail_auth WHERE c_uid = 'carsten.delellis' OR LOWER(mail) = 'carsten.delellis'': MySQL4Exception: 0x10496460 NAME:ExecutionFailed REASON:Unknown column 'mail' in 'where clause' 127.0.0.1 - - [13/Jan/2011:20:54:57 GMT] GET /SOGo/carsten.delellis HTTP/1.1 404 45/0 0.004 - - 8K My table looks like: mysql desc sogo_mail_auth; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | c_uid | varchar(255) | NO | PRI | NULL| | | c_password | varchar(255) | NO | | NULL| | | c_name | varchar(255) | YES | | NULL| | | c_cn | varchar(255) | YES | | NULL| | ++--+--+-+-+---+ 4 rows in set (0.00 sec) So I have no idea where this message comes from. I dont have a column mail. Any ideas? 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:mailto:carsten.laun-delel...@delellis.net carsten.delel...@delellis.net From: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Sent: Thursday, January 13, 2011 6:41 PM To: users@sogo.nu Subject: Re: [SOGo] Problems with authentication On 11-01-13 11:41 AM, Carsten Laun-De Lellis wrote: keySOGoAUserSources/key ^- problem. -- 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] Problems with authentication
On 11-01-13 2:58 PM, Carsten Laun-De Lellis wrote: Hi Basti, hi Ludovic Thank you for your hints. After I wrote the first email I found the misconfiguration myself. But though I fixed it I still receive error messages. In the sogo.log I found the following message: Jan 13 20:54:57 sogod [30626]: [ERROR] 0x0x1044c180[SQLSource] could not run SQL 'SELECT * FROM sogo_mail_auth WHERE c_uid = 'carsten.delellis' OR LOWER(mail) = 'carsten.delellis'': MySQL4Exception: 0x10496460 NAME:ExecutionFailed REASON:Unknown column 'mail' in 'where clause' 127.0.0.1 - - [13/Jan/2011:20:54:57 GMT] GET /SOGo/carsten.delellis HTTP/1.1 404 45/0 0.004 - - 8K My table looks like: mysql desc sogo_mail_auth; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | c_uid | varchar(255) | NO | PRI | NULL| | | c_password | varchar(255) | NO | | NULL| | | c_name | varchar(255) | YES | | NULL| | | c_cn | varchar(255) | YES | | NULL| | ++--+--+-+-+---+ 4 rows in set (0.00 sec) So I have no idea where this message comes from. I don't have a column mail. Any ideas? The mail column MUST be defined. 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
[SOGo] Issue where invitees are auto accepted
We are having a strange issue when a user invites people to an event, the invitees all get auto accepted status's and the creator is the only one who is not accepted. Has anyone else seen this type of behaviour? I was not able to replicate it on my linux box, but this is now the 5th users who has complained about the issue. The users having the issue are using thunderbird 2.0.x and Connector .101, Integrator .101 and Lightning Inverse .11 (windows xp) Running: sogo-1.3_20101203-1.el5 sogo-tool-1.3_20101203-1.el5 sogo-devel-1.3_20101203-1.el5 sope49-ical-4.9-20100721_1664.el5.1 sope49-xml-tools-4.9-20100721_1664.el5.1 sope49-ldap-tools-4.9-20100721_1664.el5.1 sope49-ldap-4.9-20101203_1664.el5.1 sope49-appserver-devel-4.9-20101203_1664.el5.1 sope49-xml-4.9-20101203_1664.el5.1 sope49-gdl1-contentstore-1.3_20101203-1.el5 sope49-gdl1-mysql-4.9-20101203_1664.el5.1 sope49-mime-4.9-20101203_1664.el5.1 sope49-sbjson-2.3.1-20101203_1664.el5.1 sope49-gdl1-devel-4.9-20101203_1664.el5.1 sope49-appserver-tools-4.9-20100721_1664.el5.1 sope49-ical-devel-4.9-20100721_1664.el5.1 sope49-gdl1-4.9-20101203_1664.el5.1 sope49-cards-1.3_20101203-1.el5 sope49-ldap-devel-4.9-20101203_1664.el5.1 sope49-mime-devel-4.9-20101203_1664.el5.1 sope49-xml-devel-4.9-20101203_1664.el5.1 sope49-core-4.9-20101203_1664.el5.1 sope49-core-devel-4.9-20101203_1664.el5.1 sope49-appserver-4.9-20101203_1664.el5.1 sope49-cards-devel-1.3_20101203-1.el5 sope49-gdl1-contentstore-devel-1.3_20101203-1.el5 Cheers, -- Ryan Evans Systems Administrator Gulf Interstate Engineering Company 16010 Barkers Point Lane, Suite 600 Houston, Texas 77079-9000 USA Office: 713-850-3604 Cell: 281-413-2900 Privileged, Proprietary and/or Confidential Information may be contained in this electronic message. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should kindly return to the sender immediately and delete your copy from your system. Gulf Interstate Engineering Company does not accept responsibility for changes made to this electronic message or its attachments. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problem with CAS Authorization and IMAP
Hi, I have problem with connect to IMAP server, when Sogo used CAS Authorization. I use CAS Authorization and it seems authorization work well. But when Sogo try to load Main Folder and connect to IMAP I got next error: Jan 13 09:52:16 sogod [8244]: |SOGo| starting method 'POST' on uri '/SOGo/so/cast...@ebento.net/Mail/0/mailboxes' 2011-01-13 09:52:16.062 sogod[8244] WARNING(-[NSNull(misc) length]): called NSNull -length (returns 0) !!! Jan 13 09:52:21 sogod [8244]: [ERROR] 0x0x1aaa740[NGImap4ConnectionManager] IMAP4 login failed: host=localhost, user=cast...@ebento.net, pwd=yes url=imap://castest%40ebento.net@localhost/ base=(nil) base-class=(nil)) = 0x0x19f8b20[NGImap4Client]: login=cast...@ebento.net(pwd) socket=NGActiveSocket[0x0x1a637c0]: mode=rw address=0x0x1a625e0[NGInternetSocketAddress]: host=localhost port=37334 connectedTo=0x0x1820600[NGInternetSocketAddress]: host=localhost port=143 Jan 13 09:52:21 sogod [8244]: 0x01A1C5E0[SOGoMailAccount]:0 renewing imap4 password Jan 13 09:52:26 sogod [8244]: [ERROR] 0x0x1aaa740[NGImap4ConnectionManager] IMAP4 login failed: host=localhost, user=cast...@ebento.net, pwd=yes url=imap://castest%40ebento.net@localhost/ base=(nil) base-class=(nil)) = 0x0x1a0fb10[NGImap4Client]: login=cast...@ebento.net(pwd) socket=NGActiveSocket[0x0x19d6a10]: mode=rw address=0x0x19f9590[NGInternetSocketAddress]: host=localhost port=37336 connectedTo=0x0x19f4010[NGInternetSocketAddress]: host=localhost port=143 Jan 13 09:52:26 sogod [8244]: [ERROR] 0x01A1C5E0[SOGoMailAccount]:0 Could not connect IMAP4 When I use web authorization all work well and Sogo connect to IMAP. If I right understand, when I use web authorization, Sogo send plaintext text password to IMAP and successful connect to IMAP. But when I use CAS authorization, Sogo doesn't use IMAP password. It seems Sogo use CAS ticket instead of password. Could you, please, help me resolve the problem with IMAP connection when I use CAS authorization? Maybe I need set some parameters in SOgo config? My SOgo configure file: dict keyNSGlobalDomain/key dict /dict keysogod/key dict keySOGoDebugRequests/key stringYES/string keyOCSFolderInfoURL/key stringmysql://sogo:sogopasswd@localhost:3306/sogo/sogo_folder_info/string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoAuthenticationType/key stringcas/string keySOGoCASServiceURL/key stringhttps://cas.ebento.net/string keySOGoCalendarDefaultRoles/key array stringPublicViewer/string stringConfidentialDAndTViewer/string /array keySOGoDraftsFolderName/key stringINBOX.Drafts/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoIMAPServer/key stringlocalhost/string keySOGoLanguage/key stringEnglish/string keySOGoMailShowSubscribedFoldersOnly/key stringYES/string keySOGoMailingMechanism/key stringsmtp/string keySOGoProfileURL/key stringmysql://sogo:sogopasswd@localhost:3306/sogo/sogo_user_profile/string keySOGoSMTPServer/key string127.0.0.1/string keySOGoSentFolderName/key stringINBOX.Sent/string keySOGoTimeZone/key stringAmerica/Tijuana/string keySOGoTrashFolderName/key stringINBOX.Trash/string keydomains/key dict keyebento.net/key dict keySOGoDraftsFolderName/key stringDrafts/string keySOGoMailDomain/key stringebento.net/string keySOGoMailShowSubscribedFoldersOnly/key stringYES/string keySOGoUserSources/key array dict keycanAuthenticate/key stringYES/string keyid/key stringdirectory/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyuserPasswordAlgorithm/key stringnone/string keyviewURL/key stringmysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_view/string /dict /array /dict /dict /dict /dict -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Issue where invitees are auto accepted
Ok, so I was able to get it on mine and see what the issue is now. When someone creates a meeting, the FIRST person invited is correct in that it is not auto-accepted, everyone after the first person is auto-accepted. Can reproduce issue on 3 different machines here *windows and linux - all same plugins and TB versions) logs don't seem to show an error when creating or sending the events out any clues? Ryan Ryan Evans wrote: We are having a strange issue when a user invites people to an event, the invitees all get auto accepted status's and the creator is the only one who is not accepted. Has anyone else seen this type of behaviour? I was not able to replicate it on my linux box, but this is now the 5th users who has complained about the issue. The users having the issue are using thunderbird 2.0.x and Connector .101, Integrator .101 and Lightning Inverse .11 (windows xp) Running: sogo-1.3_20101203-1.el5 sogo-tool-1.3_20101203-1.el5 sogo-devel-1.3_20101203-1.el5 sope49-ical-4.9-20100721_1664.el5.1 sope49-xml-tools-4.9-20100721_1664.el5.1 sope49-ldap-tools-4.9-20100721_1664.el5.1 sope49-ldap-4.9-20101203_1664.el5.1 sope49-appserver-devel-4.9-20101203_1664.el5.1 sope49-xml-4.9-20101203_1664.el5.1 sope49-gdl1-contentstore-1.3_20101203-1.el5 sope49-gdl1-mysql-4.9-20101203_1664.el5.1 sope49-mime-4.9-20101203_1664.el5.1 sope49-sbjson-2.3.1-20101203_1664.el5.1 sope49-gdl1-devel-4.9-20101203_1664.el5.1 sope49-appserver-tools-4.9-20100721_1664.el5.1 sope49-ical-devel-4.9-20100721_1664.el5.1 sope49-gdl1-4.9-20101203_1664.el5.1 sope49-cards-1.3_20101203-1.el5 sope49-ldap-devel-4.9-20101203_1664.el5.1 sope49-mime-devel-4.9-20101203_1664.el5.1 sope49-xml-devel-4.9-20101203_1664.el5.1 sope49-core-4.9-20101203_1664.el5.1 sope49-core-devel-4.9-20101203_1664.el5.1 sope49-appserver-4.9-20101203_1664.el5.1 sope49-cards-devel-1.3_20101203-1.el5 sope49-gdl1-contentstore-devel-1.3_20101203-1.el5 Cheers, -- Ryan Evans Systems Administrator Gulf Interstate Engineering Company 16010 Barkers Point Lane, Suite 600 Houston, Texas 77079-9000 USA Office: 713-850-3604 Cell: 281-413-2900 Privileged, Proprietary and/or Confidential Information may be contained in this electronic message. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should kindly return to the sender immediately and delete your copy from your system. Gulf Interstate Engineering Company does not accept responsibility for changes made to this electronic message or its attachments. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Issue where invitees are auto accepted
Sorry for the multiple e-mail replies, but just tested it from the web and it works as it should so I think maybe something is broken in my plugins for thunderbird? Ryan Evans wrote: Ok, so I was able to get it on mine and see what the issue is now. When someone creates a meeting, the FIRST person invited is correct in that it is not auto-accepted, everyone after the first person is auto-accepted. Can reproduce issue on 3 different machines here *windows and linux - all same plugins and TB versions) logs don't seem to show an error when creating or sending the events out any clues? Ryan Ryan Evans wrote: We are having a strange issue when a user invites people to an event, the invitees all get auto accepted status's and the creator is the only one who is not accepted. Has anyone else seen this type of behaviour? I was not able to replicate it on my linux box, but this is now the 5th users who has complained about the issue. The users having the issue are using thunderbird 2.0.x and Connector .101, Integrator .101 and Lightning Inverse .11 (windows xp) Running: sogo-1.3_20101203-1.el5 sogo-tool-1.3_20101203-1.el5 sogo-devel-1.3_20101203-1.el5 sope49-ical-4.9-20100721_1664.el5.1 sope49-xml-tools-4.9-20100721_1664.el5.1 sope49-ldap-tools-4.9-20100721_1664.el5.1 sope49-ldap-4.9-20101203_1664.el5.1 sope49-appserver-devel-4.9-20101203_1664.el5.1 sope49-xml-4.9-20101203_1664.el5.1 sope49-gdl1-contentstore-1.3_20101203-1.el5 sope49-gdl1-mysql-4.9-20101203_1664.el5.1 sope49-mime-4.9-20101203_1664.el5.1 sope49-sbjson-2.3.1-20101203_1664.el5.1 sope49-gdl1-devel-4.9-20101203_1664.el5.1 sope49-appserver-tools-4.9-20100721_1664.el5.1 sope49-ical-devel-4.9-20100721_1664.el5.1 sope49-gdl1-4.9-20101203_1664.el5.1 sope49-cards-1.3_20101203-1.el5 sope49-ldap-devel-4.9-20101203_1664.el5.1 sope49-mime-devel-4.9-20101203_1664.el5.1 sope49-xml-devel-4.9-20101203_1664.el5.1 sope49-core-4.9-20101203_1664.el5.1 sope49-core-devel-4.9-20101203_1664.el5.1 sope49-appserver-4.9-20101203_1664.el5.1 sope49-cards-devel-1.3_20101203-1.el5 sope49-gdl1-contentstore-devel-1.3_20101203-1.el5 Cheers, -- Ryan Evans Systems Administrator Gulf Interstate Engineering Company 16010 Barkers Point Lane, Suite 600 Houston, Texas 77079-9000 USA Office: 713-850-3604 Cell: 281-413-2900 Privileged, Proprietary and/or Confidential Information may be contained in this electronic message. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should kindly return to the sender immediately and delete your copy from your system. Gulf Interstate Engineering Company does not accept responsibility for changes made to this electronic message or its attachments. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Issue where invitees are auto accepted
On 11-01-13 5:36 PM, Ryan Evans wrote: Sorry for the multiple e-mail replies, but just tested it from the web and it works as it should so I think maybe something is broken in my plugins for thunderbird? I think it's rather a bug in the CalDAV autoscheduling code in SOGo - we'll look at it tomorrow. 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] Issue where invitees are auto accepted
On Thu, 13 Jan 2011, Ryan Evans wrote: We are having a strange issue when a user invites people to an event, the invitees all get auto accepted status's and the creator is the only one who is not accepted. Has anyone else seen this type of behaviour? I was not able to replicate it on my linux box, but this is now the 5th users who has complained about the issue. The users having the issue are using thunderbird 2.0.x and Connector .101, Integrator .101 and Lightning Inverse .11 (windows xp) It looks like bug I reported 2 months ago: http://www.sogo.nu/bugs/view.php?id=987 Milos -- users@sogo.nu https://inverse.ca/sogo/lists