Re: [SOGo] Mysql Database maintenance
> On Apr 5, 2022, at 3:11 AM, HYVERNAT Philippe (p.hyver...@outlook.fr) > wrote: > > Hello, > > i installed SOGO 5.5.1 in a company with ldap auth and i use also mysql. > > in a few weeks, the database growth in gigabit. Oh. That’s sounds like an issue. I’ve been using SOGo for many, many years with multiple users and don’t think my DB is bigger than 100MB. Sounds like something is wrong. I would probably look at the data and see why it is so large. I bet it’s one user that has a malfunctioning client. -- Jason Wohlford +1-334-322-1491 signature.asc Description: Message signed with OpenPGP
Re: [SOGo] ANN: SOGo Package Repositories
The least expensive support plan at $750/yr is too expensive for just repository access. Please consider offering an option for those of us who just want official stable packages. $150/yr for such a service is justifiable for how I use it. Regards, Jason — Jason Wohlford <ja...@wohlford.co> (334) 322-1491 > On Jul 19, 2016, at 11:13 AM, Ludovic Marcotte (lmarco...@inverse.ca) > <users@sogo.nu> wrote: > > Hello, > > Over the past 10 years, Inverse has been developing SOGo and providing > everything (software packages, documentation, etc.) completely free of > charge. A massive number of organizations worldwide have successfully > deployed SOGo and benefit for free from the continuous enhancements of the > software. > > After many months of discussion and thinking, we made the decision to close > down the public package repositories. From now on, in order to access the > production builds of SOGo for various Linux distributions, you will need a > proper support contract from Inverse. The options are listed here: > > https://sogo.nu/support/index.html#support-plans > > Payments can be made by credit card. > > We hope that this move will help Inverse to: > > • increase its investments in SOGo > • accelerate SOGo v3 evolution by adding more features (S/MIME, > alternate storage backends, etc.) > • expedite bugs fixing and small feature additions > • invest in gravitational projects > • extend its support to more Linux distributions > • create a VAR channel to resell and participate in providing support > Tying up package repositories to a support agreement is important for us as > Inverse strives to offer stellar support and we want to bring more value for > the money to each customer. Current organizations that have a support > contract with us will automatically get access to the package repositories. > Official packages also offer the advantage of being thoroughly tested before > they are released. > > SOGo will continue to remain entirely Free and Open Source. The source code > will always be fully available and we will keep using the current licenses. > Nightly builds will also remain available to all, as well as the ZEG > configured with the latest software. > > Thanks for your support and understanding. Together, we all make SOGo better! > > -- > Ludovic Marcotte > > lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca > > Inverse inc. :: Leaders behind SOGo ( > http://sogo.nu), PacketFence (http://packetfence.org) and Fingerbank > (http://fingerbank.org > ) > > -- > users@sogo.nu > https://inverse.ca/sogo/lists smime.p7s Description: S/MIME cryptographic signature
[SOGo] Lost Contacts and Calendars
I'm afraid I have done something to my database. I've lost my contacts, calendars, and user settings. Very eager for some help. I use software called Virtualmin which is part of the Webmin family. Yesterday, I changed the domain name in the Virtualmin from ssl.montgomery.al to encrypted.montgomery.al. This evening I noticed data was missing. I've performed a backup of all the data. It seems it is all there. I'm guessing it is some sort of permissions problem. Desperately needing assistance. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Lost Contacts and Calendars
Reposting to list… Thank you for your suggestion, Odhiambo. I fiddled with it quite a bit and was able to recover a working database with no data loss. Your steps are effectively what I did to retrieve it except for changing all instances from encrypted.* to ssl.*. Very glad to have not lost that important data. Although backups should have been made automatically, that was not the case. Will be investigating my Virtualmin software for the cause of the missing of backups too. On Aug 12, 2013, at 5:41 AM, Odhiambo Washington odhia...@gmail.com wrote: If the database is still in place (you did not wipe it out), then I suppose maybe you just need to dump the db, edit to change the domain name, then re-import into the database. It requires CLI to do that. I don't know how to do it via GUI: From CLI: mysqldump dbname dbname.sql cat dbname.sql | sed -i.BAK 's/ssl/encrypted/g' mysqladmin drop dbname mysqladmin create dbname mysql dbname dbname.sql On 12 August 2013 05:31, Jason Wohlford ja...@wohlfordcompany.com wrote: I'm afraid I have done something to my database. I've lost my contacts, calendars, and user settings. Very eager for some help. I use software called Virtualmin which is part of the Webmin family. Yesterday, I changed the domain name in the Virtualmin from ssl.montgomery.al to encrypted.montgomery.al. This evening I noticed data was missing. I've performed a backup of all the data. It seems it is all there. I'm guessing it is some sort of permissions problem. Desperately needing assistance. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.18a
On Sep 7, 2012, at 1:22 PM, Francis Lachapelle wrote: On 2012-09-07, at 2:13 PM, Jeff Folk wrote: On Sep 7, 2012, at 1:07 PM, Francis Lachapelle wrote: - fixed support for OS X 10.8 (Mounting Lion) LOL! ^ I can't get that image out of my head… ^-- umount /lion and stop watching Animal Planet :) I'm just catching up. This is hilarious. Thanks, guys. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Feature request.
I'm doing this with LDAP filters in the SOGo config. Notice the filter
attribute with the specific gidNumber. See below:
wohlfordcompany.com = {
SOGoMailDomain = wohlfordcompany.com;
SOGoUserSources = (
{
type = ldap;
id = wohlfordcompany.com;
CNFieldName = cn;
IDFieldName = mail;
UIDFieldName = mail;
bindFields = ( mail );
IMAPLoginFieldName = mail;
baseDN = ou=users,dc=montgomery,dc=al;
filter = (objectClass=posixAccount)(gidNumber=2015);
bindAsCurrentUser = YES;
hostname = localhost;
port = 389;
canAuthenticate = YES;
isAddressBook = YES;
displayName = Directory;
}
);
};
On Jun 15, 2012, at 5:40 AM, Hans de Groot wrote:
Hi,
I have a feature request. (I hope I post this in the right place)
I would like to have a configuration option that when set, lets the
calendar/contacts sharing menu only show/search email adresses in the same
domain.
IE: if I am logged in with ha...@dandy.nl I can only share with users in the
dandy.nl domain. I do not want my users to see all email adresses in the
system.
Why do I want this?
I like to deploy SOGo once and never have to look at it again. So when I add
a new mail domain to my system SOGo automatically works with it.
It does this allready except when using the share calendar/contacts part.
Here users are shown all existing email accounts/users on the system.
I know I can use SOGo with multiple virtual hosts but this way I have to add
this to the SOGo config (and remove it later) and restart SOGo everytime a
domain gets added or removed.
If this is to much work than maybe a quicker solution would be to have an
option to disable the search function when sharing calendars.
Users just have to type the complete email address of the user they want to
share the calender with.
It will start in red and turn blue when it matches.
I hope you will look into this. I think it will add a lot power to SOGo.
Regards
Hans de Groot
--
Jason Wohlford
ja...@wohlfordcompany.com
http://www.wohlfordcompany.com/
334.322.1491
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] ANN: automx - automated mail account configuration
On Feb 29, 2012, at 1:43 PM, Patrick Ben Koetter wrote: SOGo Users, I am pleased to announce automx, a tool that makes setting up a mail account easy. All your users need to provide is real name, mail address and password. Their mail client and automx will safely handle the rest. automx runs on your server and handles mail account profile requests from your mail clients. It unifies Microsofts and Mozillas mail account provisioning standards in one powerful Open Source tool. Choose from many backends, including LDAP and SQL, and let automx create standard and individualized profiles for multiple domains on the fly! automx is Open Source software released under GPL3. More on http://automx.org p@rick Very interesting. I've got Thunderbird working very well for autoconfig. I've had a time of it getting Outlook and Mac OS X Mail.app working at all. Will review. Thank you. Btw, nice site. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 smime.p7s Description: S/MIME cryptographic signature
[SOGo] Create Filter From Message...
I've recently setup Sieve on my server. I can create filters from Preferences - Mail Options. I cannot create filters from the contextual menus (aka Create Filter From Message...). What am I missing here? Best Regards, Jason -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Create Filter From Message...
On Feb 28, 2012, at 9:37 AM, Alessio Fattorini wrote: Il 28/02/2012 16:33, Jason Wohlford ha scritto: I've recently setup Sieve on my server. I can create filters from Preferences - Mail Options. I cannot create filters from the contextual menus (aka Create Filter From Message...). What am I missing here? Not implemented yet If that's the case, then I'd recommend a code change removing the non-functional Create Filter From Message... from the contextual menus. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Create Filter From Message...
On Feb 28, 2012, at 10:52 AM, Christian Mack wrote: Dear Jason Wohlford On 2012-02-28 17:10, Jason Wohlford wrote: On Feb 28, 2012, at 9:37 AM, Alessio Fattorini wrote: Il 28/02/2012 16:33, Jason Wohlford ha scritto: I've recently setup Sieve on my server. I can create filters from Preferences - Mail Options. I cannot create filters from the contextual menus (aka Create Filter From Message...). What am I missing here? Not implemented yet If that's the case, then I'd recommend a code change removing the non-functional Create Filter From Message... from the contextual menus. Just file a bugreport at http://www.sogo.nu/bugs Done. Thank you for your suggestion. http://www.sogo.nu/bugs/view.php?id=1655 -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Lion 10.7.3 broke carddav
Same here on Mac OS X 10.7.3. On Feb 5, 2012, at 12:52 PM, Martin Seener wrote: Hi there too, the same here! Worked before, doesnt work anymore after.Apple is indeed misfixing things :( On 2/5/12 7:28 PM, Martin Waschbüsch wrote: Hi there, Am 05.02.2012 um 18:06 schrieb etemam: Hi, since some of my users upgrade to os x lion 10.7.3, they cannot modify entry in their sogo address book with the apple addressbook application: it is read only!! It has to work fine with 10.7.2. It is maybe a bug of apple but I don't known where looking for. Although I cannot help with this, I can confirm that this is indeed true. I cannot modify existing contacts when using Mac OS X 10.7.3 If I can provide additional information to help resolve this, please let me know. Cheers, Martin -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] SOGo and Notes
On Dec 21, 2011, at 5:33 PM, Ludovic Marcotte wrote: On 21/12/11 07:51, Martin (Lists) wrote: I use SOGo since more than a year and it is a great peace of software. So my Question: Are there any plans to add a notes like function in SOGo? Not right now. It would ideally also need to be implemented in Lightning so it's quite a big thing to add. Apple handles this rather well on Mac OS X and iOS using a Notes mail folder. Their implementation allows for graceful fallback to something similar to a Draft folder in other MUAs (mail user agents), webmail included. It appears that Mac OS X and iOS senses this Notes folder and its enclosed messages and then displays them appropriately. Might I suggest something similar for SOGo? Below is a full Note with headers: Content-Type: text/html; charset=us-ascii Subject: Test Note Mime-Version: 1.0 (Apple Message framework v1251.1) X-Apple-Base-Url: x-msg://621/ X-Universally-Unique-Identifier: 816452b4-115d-45bf-81f7-c4d04222c9dd X-Apple-Mail-Remote-Attachments: NO From: Jason Wohlford ja...@wohlfordcompany.com X-Mail-Created-Date: Wed, 21 Dec 2011 17:45:25 -0600 Date: Wed, 21 Dec 2011 17:45:33 -0600 Content-Transfer-Encoding: 7bit Message-Id: 3bdec764-c6ae-43ab-ba60-a42abf955...@wohlfordcompany.com X-Uniform-Type-Identifier: com.apple.mail-note htmlbody bgcolor=#FFEAB6Test Note/body/html -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Option to make Any Authenticated User invisible
On Dec 2, 2011, at 5:07 AM, Christian Mack wrote: Hello We just had another user which 'accidentally' made his INBOX modifiable for everyone! We get several dozens of calls because of this every time it happens. This is really annoying. Because of this, I have filed an enhancement request some time ago: http://www.sogo.nu/bugs/view.php?id=1476 In this request I suggest to make the Any Authenticated User invisible for users by setting a new sogo configuration option. Do others have this problem too? Are there any other solutions to this problems? How long would it take to implement the enhancement request? Oh. That's interesting. I could see how that could pose problems for my hosting company. Hmm. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] CalDAV and iOS5
On Oct 31, 2011, at 4:07 AM, Christian Roessner wrote: Hi, I am using several iPhones with SOGo. We had the 4th iOS version on the smartphones, but two of us upgraded to iOS5. This broke our calendars. We all have at least two calendars. The problem show up in that way that we do not see all of our calendars. In my case, I have the standard calendar and a calendar called Test. After updateing I only get the Test calendar. Even disabling the CalDAV calendar in the settings menu and reactivating it, does not solve the problem. I waited for 1.3.9, as the problem arised with an earlier version. But today I upgraded to 1.3.9 and the problem persists. I've upgraded to 1.3.9 as well and am still having problems with calendars on iOS 5. I had problems on iOS 4 too, but once I hid all the calendars and then unhid them they would all appear. The same trick does not work for me on iOS 5 even after the upgrade. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] CardDAV with iOS 5
On Oct 26, 2011, at 6:47 PM, Jeff Folk jf...@qzoneinc.com wrote: Bless you! Second that! -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Auth Errors
Fixed this by setting: SOGoCacheCleanupInterval = 0; On Aug 14, 2011, at 12:45 AM, Fasil wrote: could you share your sogo and imap log? On 08/14/2011 02:28 AM, Jason Wohlford wrote: I'm so close to rolling out SOGo. Please, please help. I keep running into authentication errors. Sometimes it will login and sometimes it won't. Nothing changed in between. I'm authenticating against LDAP with OpenLDAP. Any ideas? -- thanks and regards --- fasil sse -- users@sogo.nu https://inverse.ca/sogo/lists -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] iPhone Calendars
For some reason my iPhone does not display my CalDAV calendars. I can add an event on my iPhone and it shows up in iCal and the SOGo web interface. However, once it contacts the SOGo server, the event disappears. Ideas? -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] One user cannot log in...
On Aug 20, 2011, at 2:25 PM, Bruce Johnson wrote: We have SOGo set up using our Active Directory domain for the ldap source, and one user cannot log in. I get the message: SOGoRootPage Login for user 'username' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 in the sogo.log. This person has no problems logging in to any other service in the domain, and her AD record doesn't look any different than any other. All I've found searching the list is 'this is LDAP configuration issues'; we haven't run into any other person on the domain with this issue. Any ideas? I ran into a similary problem using OpenLDAP. However, it wasn't related to just one user, it would occur on all users. What I did to fix the error on my side was the following command: defaults write sogod SOGoLDAPQueryTimeout 30 My hope is that will fix your issue too. I suspect a bug in the caching mechanism for SOGo. Best Regards, Jason -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] One user cannot log in...
Pardon! Wrong command! defaults write sogod SOGoCacheCleanupInterval 0 On Aug 20, 2011, at 2:46 PM, Jason Wohlford wrote: On Aug 20, 2011, at 2:25 PM, Bruce Johnson wrote: We have SOGo set up using our Active Directory domain for the ldap source, and one user cannot log in. I get the message: SOGoRootPage Login for user 'username' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 in the sogo.log. This person has no problems logging in to any other service in the domain, and her AD record doesn't look any different than any other. All I've found searching the list is 'this is LDAP configuration issues'; we haven't run into any other person on the domain with this issue. Any ideas? I ran into a similary problem using OpenLDAP. However, it wasn't related to just one user, it would occur on all users. What I did to fix the error on my side was the following command: defaults write sogod SOGoLDAPQueryTimeout 30 My hope is that will fix your issue too. I suspect a bug in the caching mechanism for SOGo. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] iPhone Calendars
On Aug 20, 2011, at 1:41 PM, Jason Wohlford wrote: For some reason my iPhone does not display my CalDAV calendars. I can add an event on my iPhone and it shows up in iCal and the SOGo web interface. However, once it contacts the SOGo server, the event disappears. Ideas? We'll this is interesting. I restarted my iPhone and the calendars show up now. Go figure. Looks to be a client issue. -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Domains?
Is there a way I can segment users from one domain from another? For instance an LDAP directory for users of wohlford.org should not be available for users of wohlfordcompany.com. Cheers, Jason -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Domains?
Figured it out! Yeah!
Much thanks to this thread:
http://permalink.gmane.org/gmane.comp.groupware.sogo.user/2901
On Aug 19, 2011, at 3:07 PM, Jason Wohlford wrote:
I've reviewed that documentation, but can't seem to setup the config right.
The following line is what I run (as sogo user). What am I missing?
defaults write sogod domains \
'wohlford = { SOGoMailDomain = wohlford.org; SOGoUserSources = ( { type
= ldap; id = wohlford.org; CNFieldName = cn; IDFieldName = mail; UIDFieldName
= mail; bindFields = ( mail ); IMAPLoginFieldName = mail; baseDN =
ou=users,dc=montgomery,dc=al; filter =
(objectClass=posixAccount)(gidNumber=2002); bindAsCurrentUser = YES;
hostname = localhost; port = 389; canAuthenticate = YES; isAddressBook = YES;
displayName = wohlford.org; } ); }; wohlfordcompany = { SOGoMailDomain =
wohlfordcompany.com; SOGoUserSources = ( { type = ldap; id =
wohlfordcompany.com; CNFieldName = cn; IDFieldName = mail; UIDFieldName =
mail; bindFields = ( mail ); IMAPLoginFieldName = mail; baseDN =
ou=users,dc=montgomery,dc=al; filter =
(objectClass=posixAccount)(gidNumber=2015); bindAsCurrentUser = YES;
hostname = localhost; port = 389; canAuthenticate = YES; isAddressBook = YES;
displayName = wohlfordcompany.com; } ); };'
On Aug 19, 2011, at 1:33 PM, Stephen Ingram wrote:
Jason-
There is an example in the documentation
(http://www.sogo.nu/english/downloads/documentation).
Steve
On Fri, Aug 19, 2011 at 11:20 AM, Jason Wohlford
ja...@wohlfordcompany.com wrote:
Is there a way I can segment users from one domain from another? For
instance an LDAP directory for users of wohlford.org should not be
available for users of wohlfordcompany.com.
Cheers,
Jason
--
Jason Wohlford
ja...@wohlfordcompany.com
http://www.wohlfordcompany.com/
334.322.1491
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
Jason Wohlford
ja...@wohlfordcompany.com
http://www.wohlfordcompany.com/
334.322.1491
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
Jason Wohlford
ja...@wohlfordcompany.com
http://www.wohlfordcompany.com/
334.322.1491
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] Auth Errors
I'm so close to rolling out SOGo. Please, please help. I keep running into authentication errors. Sometimes it will login and sometimes it won't. Nothing changed in between. I'm authenticating against LDAP with OpenLDAP. Any ideas? -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Sugestion about a LDAP Webfrontend
On Jul 31, 2011, at 6:32 PM, Darko Hojnik wrote: I'm currently working since one year with the combo SOGo, Postfix, DBmail, PostgreSQL and OpenLDAP. DBmail stores all mails in a PostgreSQL database and SOGo uses for itself another one. All users are stored inside a LDAP three. So I've the same users for SOGo, DBmail and Postfix inside LDAP. For less 100 users I've handled it with Apache Directory Studio. But in the future there will comes more users. Also users has asked me about a webfrontend to configure domains, users, aliases and such stuff. So I'm searching something like a web based solution. Anyone here who could suggest me something like this what is already present and OpenSource licensed? I've found the combination of Webmin/Virtualmin to be fantastic. What I like most about Webmin compared to other control panels, is that it actually comprehends config files. One can make an edit directly with the config file or through Webmin and nothing is messed up. Other control panels such as cpanel and plesk force you to only do edits through their control panels. Webmin/Virtualmin can handle users and groups in OpenLDAP. From there you should be good to go. This is how I manage my clients. Best Regards, Jason -- Jason Wohlford ja...@wohlfordcompany.com http://www.wohlfordcompany.com/ 334.322.1491 smime.p7s Description: S/MIME cryptographic signature
[SOGo] Authentication Error
Fellow SOGo users,
I'm having trouble with authentication. Help would greatly be appreciated.
When I login with a new user, this error displays in the web interface:
Login failed due to unhandled error case: -1
The logs show this error:
Jul 25 12:08:10 sogod [24233]: 0x0x2bd8010[NGLdapConnection] bind -
ldap_result call result: 97
Jul 25 12:08:10 sogod [24233]: 0x0x2bd8010[NGLdapConnection] bind -
ldap_parse_result - ctrls is NULL
Jul 25 12:08:10 sogod [24233]: SOGoRootPage Login for user 'j...@wohlford.org'
might not have worked - password policy: -1 grace: -1 expire: -1 bound: 1
166.248.70.150 - - [25/Jul/2011:12:08:10 GMT] POST /SOGo/connect HTTP/1.1
403 31/53 0.006 - - 0
An immediate second try using the exact same username and password, will then
let me in. As also can be seen in the logs:
Jul 25 12:08:51 sogod [24233]: SOGoRootPage successful login for user
'j...@wohlford.org' - expire = -1 grace = -1
166.248.70.150 - - [25/Jul/2011:12:08:51 GMT] POST /SOGo/connect HTTP/1.1
200 27/53 0.049 - - 4K
166.248.70.150 - - [25/Jul/2011:12:08:51 GMT] GET /SOGo/so/; @wohlford.org
HTTP/1.1 302 0/0 0.003 - - 0
166.248.70.150 - - [25/Jul/2011:12:08:51 GMT] GET /SOGo/so/;
@wohlford.org/view HTTP/1.1 302 0/0 0.004 - - 0
2011-07-25 12:08:51.753 sogod[24233] 0x0x256c0e0[PostgreSQL72Channel]:
connection=0x0x258ee20[PGConnection]: connection=0x0x26f1560: message:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
sogojbwohlfo00141b94556_pkey for table sogojbwohlfo00141b94556
I'm guessing there is some issue between SOGo and ldap on my server. It's as if
SOGo does an ldap query, but doesn't actually wait for the ldap response. Once
the second login attempt comes, the ldap query is cached with SOGo and then
authentication is sucessful. This error occurs again if the user hasn't logged
in for a time. How much time I have been unable to determine.
On what I believe is a related note, Mac OS X iCal (10.6 10.7) will fail
authentication on CalDAV periodically. It will behave fine, but after a time
iCal with complain about an invalid password. The password is valid and was
valid before, but all of the sudden it isn't. I believe this is related because
if SOGo does cache ldap queries, then once the cache expires it would produce a
similar issue in the iCal as in the web interface. However, I could be
completely wrong on this.
localhost - - [25/Jul/2011:11:43:32 GMT] PROPFIND
/SOGo/dav/j...@wohlford.org/Calendar/ HTTP/1.1 401 0/1868 0.008 - - 0
Jul 25 11:43:33 sogod [12444]: 0x0x106f660[NGLdapConnection] bind -
ldap_result call result: 97
Jul 25 11:43:33 sogod [12444]: 0x0x106f660[NGLdapConnection] bind -
ldap_parse_result - ctrls is NULL
Jul 25 11:43:33 sogod [12444]: 0x0x9ae850[SOGoDAVAuthenticator] tried wrong
password for user 'j...@wohlford.org'!
localhost - - [25/Jul/2011:11:43:33 GMT] PROPFIND
/SOGo/dav/j...@wohlford.org/Calendar/ HTTP/1.1 401 12/1868 0.004 - - 0
Also, does anyone know what this 'bind - ldap_parse_result - ctrls is NULL'
message is all about? It looks disconcerting. It could also be related.
Any help is greatly appreciated.
Best Regards,
Jason
SOGoUserSources:
(
{ type = ldap;
id = directory;
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = mail;
bindFields = ( mail );
IMAPLoginFieldName = mail;
bindAsCurrentUser = YES;
hostname = localhost;
port = 389;
canAuthenticate = YES;
passwordPolicy = YES;
isAddressBook = NO;
}
)
--
Jason Wohlford
ja...@wohlfordcompany.com
http://www.wohlfordcompany.com/
334.322.1491
smime.p7s
Description: S/MIME cryptographic signature
