Re: [SOGo] Mysql Database maintenance

2022-04-05 Thread Jason Wohlford

> 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

2016-07-21 Thread Jason Wohlford
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

(334) 322-1491

> On Jul 19, 2016, at 11:13 AM, Ludovic Marcotte (lmarco...@inverse.ca) 
>  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


Re: [SOGo] Lost Contacts and Calendars

2013-08-12 Thread Jason Wohlford
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  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  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

<http://www.wohlfordcompany.com/>
334.322.1491
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Lost Contacts and Calendars

2013-08-12 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ANN: SOGo v1.3.18a

2012-10-04 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Feature request.

2012-06-18 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ANN: automx - automated mail account configuration

2012-02-29 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] Create Filter From Message...

2012-02-28 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Create Filter From Message...

2012-02-28 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Create Filter From Message...

2012-02-28 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Lion 10.7.3 broke carddav

2012-02-05 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] SOGo and Notes

2011-12-21 Thread Jason Wohlford

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 
> 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
> 
> Test Note


-- 
Jason Wohlford

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Option to make "Any Authenticated User" invisible

2011-12-02 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] CalDAV and iOS5

2011-10-31 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] CardDAV with iOS 5

2011-10-28 Thread Jason Wohlford
No problems on Ubuntu 10.4 LTS Server.

On Oct 28, 2011, at 10:16 AM, Jeff Folk wrote:

> On Oct 27, 2011, at 9:03 PM, Jeff Folk wrote:
>> 
>> On Oct 26, 2011, at 6:37 PM, Ludovic Marcotte  wrote:
>> 
>>> On 26/10/11 18:32, Jeff Folk wrote:
>>>> What would it really take for y'all to put up a patched 1.38c version in 
>>>> the repo? Pretty please?? Or will 1.39 be patched? This iOS5 thing is 
>>>> really getting to me...
>>> v1.3.9 is set to be released tomorrow morning with that fix in.
>> 
>> Oops. Looks like SOPE upgraded today, but no SOGo. Now sogod complains of 
>> missing shared library libgnustep-base.so.1.23 when I only have version 1.20 
>> and 1.20.2
>> 
>> SOGo of course will not start. Hoping when SOGo makes it in that will fix 
>> things. 
>> 
> 
> Now that the sogo rpms are in the repository, I have updated... sogod 
> wouldn't start:
> 
> Starting SOGo: 
> /usr/sbin/sogod: error while loading shared libraries: 
> libgnustep-base.so.1.20: cannot open shared object file: No such file or 
> directory
>  sogo [FAILED]
> 
> Created a symbolic link to the 1.23 version as 1.20... now it works...
> 
> Thanks for putting 1.39 out there. Now I can sync with cal/card DAV again!
> 
> Jeff-- 
> users@sogo.nu
> https://inverse.ca/sogo/lists


-- 
Jason Wohlford

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Interface Change

2011-10-28 Thread Jason Wohlford
I like the interface change for the web frontend. Smart. The new toolbar looks 
good.

Might I suggest and additional tweak? How about moving the Disconnect to a 
drop-down underneath the username as well as renaming "Sign Out" or "Log Out." 
Disconnect feels like an unusual term as if I'm about to pull the plug on my 
computer or something.

Preference seems better suited underneath the username as well.

I'd love the pop-out windows to go modal too.

Sorry. I got on a roll.

Cheers,
Jason

-- 
Jason Wohlford

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] CardDAV with iOS 5

2011-10-26 Thread Jason Wohlford
On Oct 26, 2011, at 6:47 PM, Jeff Folk  wrote:

> Bless you!

Second that!
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] iPhone Calendars

2011-08-20 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] One user cannot log in...

2011-08-20 Thread Jason Wohlford
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 '' 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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] One user cannot log in...

2011-08-20 Thread Jason Wohlford

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 '' 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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] iPhone Calendars

2011-08-20 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Auth Errors

2011-08-20 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Domains?

2011-08-19 Thread Jason Wohlford
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
>>  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
>>> 
>>> <http://www.wohlfordcompany.com/>
>>> 334.322.1491
>>> 
>>> 
>> -- 
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
> 
> 
> -- 
> Jason Wohlford
> 
> <http://www.wohlfordcompany.com/>
> 334.322.1491
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists


-- 
Jason Wohlford

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Domains?

2011-08-19 Thread Jason Wohlford
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
>  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
>> 
>> <http://www.wohlfordcompany.com/>
>> 334.322.1491
>> 
>> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists


-- 
Jason Wohlford

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Domains?

2011-08-19 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] MacOS X 10.7 Lion Addressbook and CardDAV

2011-08-13 Thread Jason Wohlford

On Aug 13, 2011, at 6:35 PM,  
 wrote:

> Recently, I upgraded one of my systems to MacOS 10.7 Lion. On this system
> Addressbook can no longer access Address cards on the SOGo server. There is no
> error message, several other systems show no problem accessing the data, web
> access also shows that everything should be fine. BTW CalDAV access with iCal
> seems to work fine.
> 
> To me it seems there is a problem with Addressbook in MacOS 10.7 Lion.
> 
> Any idea would be welcome on how to address this problem. Please do not
> hesitate to ask for details...


My first guess would be account issues in iCal. Lion handles accounts a bit 
differently than previous versions. If you haven't done so already, please 
double-check your account settings. Check them in System Preferences -> Mail, 
Contacts, & Calendars. Does everything look good there?

-- 
Jason Wohlford

<http://www.wohlfordcompany.com/>
334.322.1491

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Auth Errors

2011-08-13 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] Sugestion about a LDAP Webfrontend

2011-07-31 Thread Jason Wohlford

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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature


[SOGo] Authentication Error

2011-07-25 Thread Jason Wohlford
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

<http://www.wohlfordcompany.com/>
334.322.1491



smime.p7s
Description: S/MIME cryptographic signature