Re: [SOGo] Updating...

2016-05-29 Thread Azam Premji
Thanks André.

After the upgrade I got the following message:
SOGo database schemas are _not_ automatically upgraded by the packaging system.

So I guessed the script to run after the install. And from the directory list 
there were two maybe possible for my install:
sql-update-3.0.0-to-combined-mysql.sh
sql-update-3.0.0-to-combined.sh

I checked MariaDB and SOGo had 53 tables. After running the script it has 9.

Since I’m using MariaDB I ran sql-update-3.0.0-to-combined-mysql.sh which gave 
the the output:
Merging tables
Patching /etc/sogo/sogo.conf….

Now no users have any Calendar items though the Calendars themselves exist. And 
for most users they have lost their address books.

Our users are drawn from LDAP and they are able to login using the Web UI but 
nothing shows up in the Global Address List. Before we could search users in 
this Global Address List. Does this mean there is a new method to enter user 
sources in SOGo.conf/defaults?

Couple of other things…
- When installing the update I was asked if I want to allow the overwriting of 
SOGo.conf and sogo.conf. Since I had them set the way I like I said ‘no’. Since 
that didn’t work, I reverted the snapshot of the Virtual machine (thankfully 
I’m able to revert). The second time I upgraded I allowed it to overwrite 
SOGo.conf but not sogo.conf. That didn’t work.
- Also I noticed that there were a couple of new entries in my sogo.conf for 
OCSStoreURL and OCSAclURL. I updated them with the appropriate mysql password 
each time I applied the upgrade. I also applied the same using the defaults 
command and checked the files.

I’ve verified that the services are running (samba. etc).

I don’t know what else to try. Any ideas?


Azam




> On May 28, 2016, at 5:06 AM, André Schild (an...@schild.ws) <users@sogo.nu> 
> wrote:
> 
> apt-get upgrade for debian kind of systems...
> 
> Am 27.05.2016 um 19:09 schrieb Azam Premji (blueb...@gmail.com):
>> Hi guys,
>> 
>> I just downloaded the latest manual and looked thru it to see if I could 
>> find the procedure to update my existing installation from 3.0.2 to the 
>> latest/greatest. I don’t see anything in there. It has instruction for the 
>> 2.x versions. The FAQs don’t show anything either.
>> 
>> Maybe I’m missing something.
>> 
>> Can anyone point me in the right direction?
>> 
>> Thanks!
>> 
>> Azam
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] SOGo - Openchange issue

2016-05-05 Thread Azam Premji
Hi Jonathan,

Try the Outlook CalDAV Synchronizer plugin on sourceforge. Maybe it’ll help 
until the good news from Ludovic?


Azam


> On May 5, 2016, at 1:29 PM, Jonathan Mathews (jm3185...@gmail.com) 
>  wrote:
> 
> Hi Rowland
> 
> Thank you for the information, it explains a lot.
> 
> In your opinion, what would be the best way to SOGo to connect to Outlook 
> 2010,  I need to make sure that the calendar is able to sync.
> 
> Thanks
> Jonathan
> 
> On 05 May 2016 6:59 PM, "Rowland Penny"  > wrote:
> >
> > On 05/05/16 16:42, Jonathan Mathews (jm3185...@gmail.com 
> > ) wrote:
> >>
> >> Hi
> >>
> >> Hope someone could assist me.
> >>
> >> I am interested in using SOGo as my email server, but have been 
> >> experiencing some issues.
> >>
> >> I have been trying to install SOGo with OpenChange, as some of the users 
> >> prefer to use Outlook 2010.
> >>
> >> So I have a CentOS 6.7 server, with epel repo and rpmforge, and have been 
> >> following the installation guide on the website, and also the following 
> >> guide which is for Ubuntu
> >>
> >> https://github.com/DigitalOcean-User-Projects/Articles-and-Tutorials/blob/master/sogo_an_MS_exchange_alt.md
> >>  
> >> 
> >>
> >> So, when I do yum install samba4, it only installs two packages, samba4 
> >> and samba4-common, so when you run samba-tool, you get a command not 
> >> found. I eventually found out that you have to purchase it from sernet, 
> >> which gives you all the dependencies to run samba-tool.
> >>
> >> I then added the SOGo repo and ran yum install sogo*, the install went 
> >> perfect. Then the next step is to install OpenChange, I used the following 
> >> instructions:
> >>
> >> http://www.openchange.org/download/el.html 
> >> 
> >>
> >> So when I ran yum install openchange sogo-openchange-backend 
> >> openchange-ocsmanager openchange-rpcproxy
> >>
> >> I get openchange-ocsmanager openchange-rpcproxy packages does not exist.
> >>
> >> I am not sure if I am doing something wrong, but I followed the 
> >> instructions. To me it looks like it is a repo issue, yet I have given the 
> >> exact repo that the webstie points me to.
> >>
> >> I would apriceate any advice anyone can give me.
> >>
> >>
> >>
> >
> > For various reasons, Openchange development seems to have stalled and 
> > Openchange will only work with Samba version 4.1.18 at latest. This version 
> > of Samba is now EOL and is possibly subject to MITM attacks, so I wouldn't 
> > use it. If I remember correctly, there was also a problem building 
> > ocsmanager on later versions.
> >
> > All in all, I think, for the time being anyway, you should not consider 
> > using Openchange.
> >
> > Rowland
> >
> > -- 
> > users@sogo.nu 
> > https://inverse.ca/sogo/lists 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] Very initial question

2016-04-30 Thread Azam Premji
Hi Chris,

Welcome. I’ve found there are numerous ways to install SOGo so it’s kind of 
hard to tell where you are with this. Probably the best place to start is 
checking out what your logs say.

You can find the logs at /var/log/sogo/sogo.log

I’m also quite new around here but if there is something in there that I’ve 
seen before I’d be glad to help.


Azam



> On Apr 29, 2016, at 8:52 AM, Christoph Kuhnert (christo...@me.com) 
>  wrote:
> 
> Hi Everybody
> 
> I hope it’s ok to ask this here.
> 
> Trying to install sogo in a headless Ubuntu 14.04 server.
> The server is running in a parallels Virtual machine.
> 
> Firewall of Ubuntu Server is disabled.
> 
> I have a fresh installation of 14.04 and install Sogo (via apt-get).
> 
> It installs without error messages and is running (service sogo status).
> 
> How can I now access Sogo?
> 
> http:/http://ip/>>/sogo doesn’t work.
> 
> I can’t do http://localhost/sogo  (as written in the 
> documentation) because I don’t have a browser.
> 
> Let’s say: I am stuck before it even started.
> 
> This is a pretty simple question.
> But it's correct that I should ask such questions here, because there is no 
> forum or similar that I can check for simple beginners questions, right?
> I usually do that to try and help myself.
> 
> In any way: every hint into the right direction would be very much 
> appreciated.
> 
> 
> Kind Regards
> 
> Chris
> __
> 
> 
> 
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

[SOGo] Sieve setup - noob q

2016-04-24 Thread Azam Premji
Hi guys,

Thanks for your help so far. I have been able to get quite far with my SOGo 
installation. I have now reached the point where I’d like to get Sieve 
functionality going (filing certain messages automatically to a specific folder 
and vacation messages) and I need a bit of guidance.

Here is my setup:

I’m using Samba4 as an Active Directory domain controller for the domain 
RHYTHMIC.LAN. Users now simply login with their first name into the SOGo web 
interface. These users are able to check email from the domain RHYTHMIC.CA.

I don’t want to use Active Directory for the .CA domain so I created a .LAN 
just for authentication, however I want to send email through SOGo’s web UI 
(email is hosted at an external hosting company).

I’m not using OpenChange and for email I have Postfix and Dovecot. Everything 
is working just fine except I can’t get Sieve going. The error I get in the 
mail.log is:

team dovecot: managesieve-login: Disconnected (auth failed, 2 attempts in 12 
secs): user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, 
secured, session=

So I found a perl script that would generate authentication code for me to 
attempt a telnet login to managesieve.

Here is the first attempt:

root@linux:~# ./sieve-auth-command.pl myu...@rhythmic.ca MySup3rStr0ngPassw0rd
AUTHENTICATE "PLAIN" “YGF68W1vaXR3ZPJrCy5jKWF="

Ok got it. Now to test it.

root@linux:~# telnet localhost 4190
Trying ::1...
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
"IMPLEMENTATION" "Dovecot (Ubuntu) Pigeonhole"
"SIEVE" "fileinto reject envelope encoded-character vacation subaddress 
comparator-i;ascii-numeric relational regex imap4flags copy include variables 
body enotify environment mailbox date ihave"
"NOTIFY" "mailto"
"SASL" "PLAIN LOGIN"
"VERSION" "1.0"
OK "Dovecot (Ubuntu) ready."
AUTHENTICATE "PLAIN" "YGF68W1vaXR3ZPJrCy5jKWF="
NO "Authentication failed."
^]
telnet> 


I kind of expected that because I login to SOGo web interface with just the 
username not the full email address. So I tried the script with just the 
username part from usern...@rhythmic.ca. Here is the result:

root@linux:~# ./sieve-auth-command.pl myuser  MySup3rStr0ngPassw0rd
AUTHENTICATE "PLAIN" “MPS5LW9Armm9MRUzdHExLq7a”

Let’s try this one…

root@linux:~# telnet localhost 4190
Trying ::1...
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
"IMPLEMENTATION" "Dovecot (Ubuntu) Pigeonhole"
"SIEVE" "fileinto reject envelope encoded-character vacation subaddress 
comparator-i;ascii-numeric relational regex imap4flags copy include variables 
body enotify environment mailbox date ihave"
"NOTIFY" "mailto"
"SASL" "PLAIN LOGIN"
"VERSION" "1.0"
OK "Dovecot (Ubuntu) ready."
AUTHENTICATE "PLAIN" "MPS5LW9Armm9MRUzdHExLq7a"
OK "Logged in."
^]
telnet> 


Cool!

So my question is how can I make it so that I’m able to have SOGo (or whatever 
runs Sieve for SOGo) not to try and authenticate me with the full email address 
but rather just the username part from the email?

Here is the output of my dovecot configuration. Have I missed something?

root@linux:~# doveconf -n
# 2.2.9: /etc/dovecot/dovecot.conf
# OS: Linux 4.2.0-27-generic x86_64 Ubuntu 14.04.4 LTS 
auth_mechanisms = plain login
disable_plaintext_auth = no
listen = *
mail_location = maildir:~/Maildir
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope encoded-character 
vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy 
include variables body enotify environment mailbox date ihave
namespace inbox {
  inbox = yes
  location = 
  mailbox Drafts {
special_use = \Drafts
  }
  mailbox Junk {
special_use = \Junk
  }
  mailbox Sent {
special_use = \Sent
  }
  mailbox "Sent Messages" {
special_use = \Sent
  }
  mailbox Trash {
special_use = \Trash
  }
  prefix = 
}
passdb {
  driver = pam
}
plugin {
  sieve = ~/.dovecot.sieve
  sieve_dir = ~/sieve
}
protocols = imap pop3 lmtp imap lmtp sieve pop3
service auth {
  unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0666
user = postfix
  }
}
ssl = no
userdb {
  driver = passwd
}


Thanks guys!


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

[SOGo] New Install - Different Error

2016-04-13 Thread Azam Premji
Hi guys,

So I did an installation on CentOS 7 Minimal Instalaltion with SOGo, MySQL, 
Apache, Postfix and Dovecot. I’d like to use Samba for authentication and I 
don’t really care about supporting older Outlook so I’m not going to attempt 
OpenChange. I do want activesync but first I’m trying to get SOGo and Samba to 
play nice. Here is the output from sogo.log:

Apr 13 13:47:14 sogod [3251]: |SOGo| request took 0.092076 seconds to execute
Apr 13 13:47:14 sogod [3251]: 10.10.1.100 "GET /SOGo/ HTTP/1.1" 200 22161/0 
0.096 - - 4M
Apr 13 13:47:20 sogod [3251]: |SOGo| starting method 'POST' on uri 
'/SOGo/connect'
Apr 13 13:47:20 sogod [3251]: <0x0x7f3c04a90520[NGLdapConnection]> Using 
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
Apr 13 13:47:20 sogod [3251]: <0x0x7f3c04adae10[NGLdapConnection]> Using 
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2016-04-13 13:47:20.550 sogod[3251] -[NGLdapConnection 
_searchAtBaseDN:qualifier:attributes:scope:]: search at base '' filter 
'(objectClass=*)' for attrs 'subschemaSubentry'
2016-04-13 13:47:20.550 sogod[3251] -[NGLdapConnection 
_searchAtBaseDN:qualifier:attributes:scope:]: search at base 
'CN=Aggregate,CN=Schema,CN=Configuration,DC=rhythmic,DC=ca' filter 
'(objectClass=*)' for attrs 'objectclasses'
2016-04-13 13:47:20.572 sogod[3251] -[NGLdapConnection 
_searchAtBaseDN:qualifier:attributes:scope:]: search at base 
'cn=users,dc=rhythmic,dc=ca' filter 
'(&(|(sAMAccountName=test1)(mail=test1))(mail=*))' for attrs 'dn'
Apr 13 13:47:20 sogod [3251]: SOGoRootPage Login from '10.10.1.100' for user 
'test1' might not have worked - password policy: 65535  grace: -1  expire: -1  
bound: 0
Apr 13 13:47:20 sogod [3251]: |SOGo| request took 0.062964 seconds to execute
Apr 13 13:47:20 sogod [3251]: 10.10.1.100 "POST /SOGo/connect HTTP/1.1" 403 
34/62 0.068 - - 216K


Here is my conf file (easy passwords for a test environment):
  /* Database configuration (mysql:// or postgresql://) */
  //SOGoProfileURL = 
"postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile";
  //OCSFolderInfoURL = 
"postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info";
  //OCSSessionsFolderURL = 
"postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder";

  SOGoProfileURL = 
"mysql://sogo:l3mm3in123@localhost:3306/sogo/sogo_user_profile";
  OCSFolderInfoURL = 
"mysql://sogo:l3mm3in123@localhost:3306/sogo/sogo_folder_info";
  OCSSessionsFolderURL = 
"mysql://sogo:l3mm3in123@localhost:3306/sogo/sogo_sessions_folder";

  /* Mail */
  SOGoDraftsFolderName = INBOX/Drafts;
  SOGoSentFolderName = INBOX/Sent;
  SOGoTrashFolderName = INBOX/Trash;
  SOGoIMAPServer = imaps://localhost:993;
  SOGoSieveServer = sieve://127.0.0.1:4190;
  SOGoSMTPServer = 127.0.0.1;
  SOGoMailDomain = rhythmic.ca;
  SOGoMailingMechanism = smtp;
  //SOGoForceExternalLoginWithEmail = NO;
  //SOGoMailSpoolPath = /var/spool/sogo;
  //NGImap4ConnectionStringSeparator = "/";

  
  /* Notifications */
  //SOGoAppointmentSendEMailNotifications = NO;
  //SOGoACLsSendEMailNotifications = NO;
  //SOGoFoldersSendEMailNotifications = NO;

  /* Authentication */
  //SOGoPasswordChangeEnabled = YES;

  /* LDAP authentication example */
  //SOGoUserSources = (
  //  {
  //type = ldap;
  //CNFieldName = cn;
  //UIDFieldName = uid;
  //IDFieldName = uid; // first field of the DN for direct binds
  //bindFields = (uid, mail); // array of fields to use for indirect binds
  //baseDN = "ou=users,dc=acme,dc=com";
  //bindDN = "uid=sogo,ou=users,dc=acme,dc=com";
  //bindPassword = qwerty;
  //canAuthenticate = YES;
  //displayName = "Shared Addresses";
  //hostname = ldap://127.0.0.1:389;
  //id = public;
  //isAddressBook = YES;
  //  }
  //);

  /* LDAP AD/Samba4 example */
  SOGoUserSources = (
{
  type = ldap;
  CNFieldName = cn;
  UIDFieldName = sAMAccountName;
  baseDN = "CN=users,dc=rhythmic,dc=ca";
  bindDN = "CN=administrator,CN=users,DC=rhythmic,DC=ca";
  bindFields = (sAMAccountName, mail);
  bindPassword = l3mm3in123;
  canAuthenticate = YES;
  displayName = "Public";
  hostname = ldap://127.0.0.1:389;
  filter = "mail = '*'";
  id = directory;
  isAddressBook = YES;
}
  );


  /* SQL authentication example */
  /*  These database columns MUST be present in the view/table:
   *c_uid - will be used for authentication -  it's the username or 
usern...@domain.tld)
   *c_name - which can be identical to c_uid -  will be used to uniquely 
identify entries
   *c_password - password of the user, plain-text, md5 or sha encoded for 
now
   *c_cn - the user's common name - such as "John Doe"
   *mail - the user's mail address
   *  See the installation guide for more details
   */

  //SOGoUserSources =
  //  (
  //{
  //  type = sql;
  //  id = directory;
  //  

Re: [SOGo] Samba Authentication

2016-04-13 Thread Azam Premji
No particular reason. I tried it on Ubuntu and I had a ton of errors. I tried 
it on CentOS and I have what seems fewer errors.

Not that CentOS any is better. It’s probably my own installation process that 
causes less errors on CentOS lol

Though I still don’t have a solution.

ayayaya I’m going nuts :)


Azam


> On Apr 13, 2016, at 2:52 PM, qm...@top-consulting.net <users@sogo.nu> wrote:
> 
> Why did you prefer CentOS ? Debian / Ubuntu have been easier to install the 
> already existing packages on.
> 
> 
> 
> On Wed, Apr 13, 2016 at 02:49 PM, Azam Premji <users@sogo.nu> wrote:
> Hi guys,
> 
> Thanks for jumping in. You guys are fantastic. I’ve been trying to work this 
> out and I have no idea why this is beating me. I think I’m missing something 
> really small here. I’m enjoying the leaning process but it’s been over 2 
> weeks and it’d be nice to see the installation working lol.
> 
> I did what you asked and tho I don’t have any Windows PCs to test a join 
> with, I did try the connection to Samba with the smbclient and it does work.
> 
> I tried changing the bindDN and the SOGoSuperUsernames in the logo.conf file 
> and there is absolutely nothing - same result - Authentication Failure.
> 
> So I ended up hiring someone on Fiverr to perform the install to see if there 
> was something I was doing wrong. We ended up going the route of CentOS and 
> that led me to yet another issue. I suppose I’ll start another thread for 
> that.
> 
> Just wanted to say thanks for giving me something to check into. Maybe soon 
> I’ll actually have SOGo working!
> 
> 
> 
> Azam
> 
> 
> 
>> On Apr 11, 2016, at 7:19 AM, Steve Ankeny (stev...@cinergymetro.net 
>> <mailto:stev...@cinergymetro.net>) <users@sogo.nu <mailto:users@sogo.nu>> 
>> wrote:
>> 
>> On 04/10/2016 06:24 AM, Azam Premji (blueb...@gmail.com 
>> <mailto:blueb...@gmail.com>) wrote:
>>> Hi guys,
>>> 
>>> I'm trying to get SOGo to authenticate to Samba4. I have installed Samba 
>>> 4.4.0 and SOGo 3 along with Postfix, Dovecot, MariaDB and Apache2. I'm not 
>>> doing the OpenChange thing - I want to use the Web interface tho and maybe 
>>> Outlook 2013 so I have activesync installed. I installed Samba by 
>>> downloading with wget and going thru ./configure, make, and make install.
>> 
>> Did you setup Samba as an Active Directory Controller?  Have you "joined" 
>> any client machines to the domain, which appears to be "rhytmic.ca 
>> <http://rhytmic.ca/>," and can you authenticate as a Samba AD user against 
>> the Samba DB?
>> 
>> It's not that you MUST join your client machines to the domain but just a 
>> way of testing the Samba DB
>> 
>> Below: Can you login to the MySQL DB with "Administrator/password123"?
>> 
>> Again, it's just a way to troubleshoot whether the Samba DB recognizes the 
>> username/password.
>> 
>> Did you create the username/password during "samba-tool" domain provision?  
>> Can you login to Samba or MySQL with username/password, particularly, 
>> "Administrator/password123" in MySQL?
>> 
>> pg 9, 17 in Native Microsoft Outlook Guide 
>> <http://sogo.nu/files/docs/SOGoNativeOutlookConfigurationGuide.pdf> (PDF)
>> 
>> Your setup below in SOGo.conf appears correct IF you're using Samba AD for 
>> authentication and IF the users actually exist (see creation of users with 
>> "samba-tool")  I'm not offering solutions as much as things to check.
>> 
>> When it doesn't work, you need to find out if you can login as 
>> username/password at the Samba level.
>> 
>> Try logging into MySQL as "Administrator/password123"  That should tell you 
>> something as well.  You login to the SOGo web interface with each user 
>> account to create user tables and fields, but you must create the users.
>> 
>> "samba-tool user add "  etc.
>> 
>>> I'm able to see the Web interface of SOGo but logging in simply throws an 
>>> 'Authentication Failed, Wrong username or Password' message. When I look 
>>> into my /var/log/sogo/sogo.log I see the following:
>>> 
>>> 
>>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>>> with pid 3844
>>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>>> with pid 3845
>>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>>> with pid 3846
>>> Apr 10 05:35:00 sogod [3845]: <0x0x5652

Re: [SOGo] Samba Authentication

2016-04-13 Thread Azam Premji
Hi guys,

Thanks for jumping in. You guys are fantastic. I’ve been trying to work this 
out and I have no idea why this is beating me. I think I’m missing something 
really small here. I’m enjoying the leaning process but it’s been over 2 weeks 
and it’d be nice to see the installation working lol.

I did what you asked and tho I don’t have any Windows PCs to test a join with, 
I did try the connection to Samba with the smbclient and it does work.

I tried changing the bindDN and the SOGoSuperUsernames in the logo.conf file 
and there is absolutely nothing - same result - Authentication Failure.

So I ended up hiring someone on Fiverr to perform the install to see if there 
was something I was doing wrong. We ended up going the route of CentOS and that 
led me to yet another issue. I suppose I’ll start another thread for that.

Just wanted to say thanks for giving me something to check into. Maybe soon 
I’ll actually have SOGo working!



Azam



> On Apr 11, 2016, at 7:19 AM, Steve Ankeny (stev...@cinergymetro.net) 
> <users@sogo.nu> wrote:
> 
> On 04/10/2016 06:24 AM, Azam Premji (blueb...@gmail.com 
> <mailto:blueb...@gmail.com>) wrote:
>> Hi guys,
>> 
>> I'm trying to get SOGo to authenticate to Samba4. I have installed Samba 
>> 4.4.0 and SOGo 3 along with Postfix, Dovecot, MariaDB and Apache2. I'm not 
>> doing the OpenChange thing - I want to use the Web interface tho and maybe 
>> Outlook 2013 so I have activesync installed. I installed Samba by 
>> downloading with wget and going thru ./configure, make, and make install.
> 
> Did you setup Samba as an Active Directory Controller?  Have you "joined" any 
> client machines to the domain, which appears to be "rhytmic.ca 
> <http://rhytmic.ca/>," and can you authenticate as a Samba AD user against 
> the Samba DB?
> 
> It's not that you MUST join your client machines to the domain but just a way 
> of testing the Samba DB
> 
> Below: Can you login to the MySQL DB with "Administrator/password123"?
> 
> Again, it's just a way to troubleshoot whether the Samba DB recognizes the 
> username/password.
> 
> Did you create the username/password during "samba-tool" domain provision?  
> Can you login to Samba or MySQL with username/password, particularly, 
> "Administrator/password123" in MySQL?
> 
> pg 9, 17 in Native Microsoft Outlook Guide 
> <http://sogo.nu/files/docs/SOGoNativeOutlookConfigurationGuide.pdf> (PDF)
> 
> Your setup below in SOGo.conf appears correct IF you're using Samba AD for 
> authentication and IF the users actually exist (see creation of users with 
> "samba-tool")  I'm not offering solutions as much as things to check.
> 
> When it doesn't work, you need to find out if you can login as 
> username/password at the Samba level.
> 
> Try logging into MySQL as "Administrator/password123"  That should tell you 
> something as well.  You login to the SOGo web interface with each user 
> account to create user tables and fields, but you must create the users.
> 
> "samba-tool user add "  etc.
> 
>> I'm able to see the Web interface of SOGo but logging in simply throws an 
>> 'Authentication Failed, Wrong username or Password' message. When I look 
>> into my /var/log/sogo/sogo.log I see the following:
>> 
>> 
>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>> with pid 3844
>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>> with pid 3845
>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>> with pid 3846
>> Apr 10 05:35:00 sogod [3845]: <0x0x56526ff25ba8[SOGoCache]> Cache cleanup 
>> interval set every 300.00 seconds
>> Apr 10 05:35:00 sogod [3845]: <0x0x56526ff25ba8[SOGoCache]> Using host(s) 
>> '127.0.0.1' as server(s)
>> Apr 10 05:35:00 sogod [3845]: [ERROR] <0x0x56526fcca9b8[NGBundleManager]> 
>> could not create bundle for path: 
>> '/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle'
>> Apr 10 05:35:00 sogod [3845]: [WARN] <0x0x7f0a438fd3c0[WOxElemBuilder]> 
>> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
>> Apr 10 05:35:00 sogod [3845]: 10.10.1.100 "GET /SOGo/ HTTP/1.1" 200 6099/0 
>> 0.065 22165 72% 4M
>> Apr 10 05:35:07 sogod [3845]: SOGoRootPage Login from '10.10.1.100' for user 
>> 'test1' might not have worked - password policy: 65535  grace: -1  expire: 
>> -1  bound: 0
>> Apr 10 05:35:07 sogod [3845]: 10.10.1.100 "POST /SOGo/connect HTTP/1.1" 403 
>> 34/62 0.062 - - 596K
>> 
>> 
>> I read that 

Re: [SOGo] Samba Authentication

2016-04-11 Thread Azam Premji
Here is what I have:

root@team:~# dpkg --get-selections | grep sope
libsope-appserver4.9install
libsope-core4.9 install
libsope-gdl1-4.9install
libsope-ldap4.9 install
libsope-mime4.9 install
libsope-xml4.9  install
sope4.9-gdl1-mysql  install
sope4.9-libxmlsaxdriver install


> On Apr 11, 2016, at 4:37 AM, Christian Mack (christian.m...@uni-konstanz.de) 
> <users@sogo.nu> wrote:
> 
> Am 10.04.2016 um 12:24 schrieb Azam Premji (blueb...@gmail.com):
>> Hi guys,
>> 
>> I'm trying to get SOGo to authenticate to Samba4. I have installed Samba 
>> 4.4.0 and SOGo 3 along with Postfix, Dovecot, MariaDB and Apache2. I'm not 
>> doing the OpenChange thing - I want to use the Web interface tho and maybe 
>> Outlook 2013 so I have activesync installed. I installed Samba by 
>> downloading with wget and going thru ./configure, make, and make install.
>> 
>> I'm able to see the Web interface of SOGo but logging in simply throws an 
>> 'Authentication Failed, Wrong username or Password' message. When I look 
>> into my /var/log/sogo/sogo.log I see the following:
>> 
>> 
>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>> with pid 3844
>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>> with pid 3845
>> Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned 
>> with pid 3846
>> Apr 10 05:35:00 sogod [3845]: <0x0x56526ff25ba8[SOGoCache]> Cache cleanup 
>> interval set every 300.00 seconds
>> Apr 10 05:35:00 sogod [3845]: <0x0x56526ff25ba8[SOGoCache]> Using host(s) 
>> '127.0.0.1' as server(s)
>> Apr 10 05:35:00 sogod [3845]: [ERROR] <0x0x56526fcca9b8[NGBundleManager]> 
>> could not create bundle for path: 
>> '/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle'
>> Apr 10 05:35:00 sogod [3845]: [WARN] <0x0x7f0a438fd3c0[WOxElemBuilder]> 
>> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
>> Apr 10 05:35:00 sogod [3845]: 10.10.1.100 "GET /SOGo/ HTTP/1.1" 200 6099/0 
>> 0.065 22165 72% 4M
>> Apr 10 05:35:07 sogod [3845]: SOGoRootPage Login from '10.10.1.100' for user 
>> 'test1' might not have worked - password policy: 65535  grace: -1  expire: 
>> -1  bound: 0
>> Apr 10 05:35:07 sogod [3845]: 10.10.1.100 "POST /SOGo/connect HTTP/1.1" 403 
>> 34/62 0.062 - - 596K
>> 
>> 
>> I read that there isn't really anything to worry about not being able to 
>> create the SSL.bundle thing but I don't know about the 
>> WOxExtElemBuilder,WOxExtElemBuilder error. I couldn't find a file like that 
>> on my system. And the last one there about the password policy I have no 
>> idea. I do have the following set:
>> /usr/local/samba/bin/samba-tool domain passwordsettings set --complexity=off
>> /usr/local/samba/bin/samba-tool domain passwordsettings set 
>> --min-pwd-length=1
>> /usr/local/samba/bin/samba-tool user setexpiry Administrator --noexpiry
>> 
>> 
>> 
>> Here is my sogo.conf (removed most parts that have have been commented out 
>> anyway, easy passwords for test environment):
>> /* Database configuration (mysql:// or postgresql://) */
>> SOGoProfileURL = 
>> "mysql://sogo:password123@localhost:3306/sogo/sogo_user_profile";
>> OCSFolderInfoURL = 
>> "mysql://sogo:password123@localhost:3306/sogo/sogo_folder_info";
>> OCSSessionsFolderURL = 
>> "mysql://sogo:password123@localhost:3306/sogo/sogo_sessions_folder";
>> 
>> /* Mail */
>> SOGoDraftsFolderName = INBOX/Drafts;
>> SOGoSentFolderName = INBOX/Sent;
>> SOGoTrashFolderName = INBOX/Trash;
>> SOGoIMAPServer = imaps://localhost:993;
>> SOGoSieveServer = sieve://127.0.0.1:4190;
>> SOGoSMTPServer = 127.0.0.1;
>> SOGoMailDomain = rhythmic.ca;
>> SOGoMailingMechanism = smtp;
>> //SOGoForceExternalLoginWithEmail = NO;
>> //SOGoMailSpoolPath = /var/spool/sogo;
>> //NGImap4ConnectionStringSeparator = "/";
>> 
>> 
>> /* LDAP AD/Samba4 example */
>> SOGoUserSources = (
>>  {
>>type = ldap;
>>CNFieldName = cn;
>>UIDFieldName = sAMAccountName;
>>baseDN = "CN=users,dc=rhythmic,dc=ca";
>>bindDN = "administra...@rhythmic.ca";
>>bindFields = (sAMAccountName, mail);
>>bindPasswor

[SOGo] Samba Authentication

2016-04-10 Thread Azam Premji
Hi guys,

I'm trying to get SOGo to authenticate to Samba4. I have installed Samba 4.4.0 
and SOGo 3 along with Postfix, Dovecot, MariaDB and Apache2. I'm not doing the 
OpenChange thing - I want to use the Web interface tho and maybe Outlook 2013 
so I have activesync installed. I installed Samba by downloading with wget and 
going thru ./configure, make, and make install.

I'm able to see the Web interface of SOGo but logging in simply throws an 
'Authentication Failed, Wrong username or Password' message. When I look into 
my /var/log/sogo/sogo.log I see the following:


Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned with 
pid 3844
Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned with 
pid 3845
Apr 10 05:33:31 sogod [3841]: <0x0x56526fccc9b8[WOWatchDog]> child spawned with 
pid 3846
Apr 10 05:35:00 sogod [3845]: <0x0x56526ff25ba8[SOGoCache]> Cache cleanup 
interval set every 300.00 seconds
Apr 10 05:35:00 sogod [3845]: <0x0x56526ff25ba8[SOGoCache]> Using host(s) 
'127.0.0.1' as server(s)
Apr 10 05:35:00 sogod [3845]: [ERROR] <0x0x56526fcca9b8[NGBundleManager]> could 
not create bundle for path: 
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle'
Apr 10 05:35:00 sogod [3845]: [WARN] <0x0x7f0a438fd3c0[WOxElemBuilder]> could 
not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
Apr 10 05:35:00 sogod [3845]: 10.10.1.100 "GET /SOGo/ HTTP/1.1" 200 6099/0 
0.065 22165 72% 4M
Apr 10 05:35:07 sogod [3845]: SOGoRootPage Login from '10.10.1.100' for user 
'test1' might not have worked - password policy: 65535  grace: -1  expire: -1  
bound: 0
Apr 10 05:35:07 sogod [3845]: 10.10.1.100 "POST /SOGo/connect HTTP/1.1" 403 
34/62 0.062 - - 596K


I read that there isn't really anything to worry about not being able to create 
the SSL.bundle thing but I don't know about the 
WOxExtElemBuilder,WOxExtElemBuilder error. I couldn't find a file like that on 
my system. And the last one there about the password policy I have no idea. I 
do have the following set:
/usr/local/samba/bin/samba-tool domain passwordsettings set --complexity=off
/usr/local/samba/bin/samba-tool domain passwordsettings set --min-pwd-length=1
/usr/local/samba/bin/samba-tool user setexpiry Administrator --noexpiry



Here is my sogo.conf (removed most parts that have have been commented out 
anyway, easy passwords for test environment):
/* Database configuration (mysql:// or postgresql://) */
SOGoProfileURL = 
"mysql://sogo:password123@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL = 
"mysql://sogo:password123@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL = 
"mysql://sogo:password123@localhost:3306/sogo/sogo_sessions_folder";

/* Mail */
SOGoDraftsFolderName = INBOX/Drafts;
SOGoSentFolderName = INBOX/Sent;
SOGoTrashFolderName = INBOX/Trash;
SOGoIMAPServer = imaps://localhost:993;
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSMTPServer = 127.0.0.1;
SOGoMailDomain = rhythmic.ca;
SOGoMailingMechanism = smtp;
//SOGoForceExternalLoginWithEmail = NO;
//SOGoMailSpoolPath = /var/spool/sogo;
//NGImap4ConnectionStringSeparator = "/";


/* LDAP AD/Samba4 example */
SOGoUserSources = (
  {
type = ldap;
CNFieldName = cn;
UIDFieldName = sAMAccountName;
baseDN = "CN=users,dc=rhythmic,dc=ca";
bindDN = "administra...@rhythmic.ca";
bindFields = (sAMAccountName, mail);
bindPassword = password123;
canAuthenticate = YES;
displayName = "Public";
hostname = ldap://127.0.0.1:389;
filter = "mail = '*'";
id = directory;
isAddressBook = YES;
  }
);
/* Web Interface */
SOGoPageTitle = RhythmicCanada;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
//SOGoMailAuxiliaryUserAccountsEnabled = YES;
//SOGoTrustProxyAuthentication = NO;

/* General */
SOGoLanguage = English;
SOGoTimeZone = America/Toronto;
SOGoCalendarDefaultRoles = (
  PublicDAndTViewer,
  ConfidentialDAndTViewer
);
SOGoSuperUsernames = (Administrator); // This is an array - keep the parens!
SxVMemLimit = 384;
WOPidFile = "/var/run/sogo/sogo.pid";
SOGoMemcachedHost = 127.0.0.1;
}

I'm not sure if I'm missing a step and I have a feeling it's something really 
stupid.
- Does my sogo.conf look right for Samba authentication? Should it really say 
type = ldap?
- I copied the format of the bindDN from a website. Is that accurate?
- Since I have a user in Samba (test1), how can I check what the CN=,DC=, is 
for that user in Samba? This way I know if the CN listed in my baseDN is 
actually 'users'?

Don't know if this is related or I should be starting a new  thread for it but 
log.samba shows this error:
[2016/04/10 06:15:45.597445,  0] ../source4/smbd/server.c:485(binary_smbd_main)
  samba: using 'standard' process model
samba: setproctitle not initialized, please either call setproctitle_init() or 
link against libbsd-ctor.
samba: setproctitle not initialized, please either call setproctitle_init() or 
link against 

[SOGo] Open Support

2016-04-08 Thread Azam Premji
I tried to send in for a support request but the page keeps giving me errors. I 
guess this now becomes open to anyone that can help...

Please let me know. 

===
I have a need to figure out why I am not able to log into my SOGo installation. 

I have followed directions meticulously and I have documented each command I 
typed in the terminal so reproducing my install will be very easy. Plus I can 
also give SSH access to my existing install. 

I know it's a very small thing that I'm missing somewhere and I would like for 
someone to look at it and let me know what exactly I need to do so I can 
compete my install and complete my documentation for it. 

I have been able to install successfully:
- Ubuntu Trusty
- OpenChange
- MySQL
- Apache
- PHP
- SOGo
- sogo-OpenChange
- sogo-ActiveSync 
- Samba

I have also performed all the configurations necessary that I found in the 
manual and other places on the web. 

I have documentation (step-by-step) that I can provide so it will be very easy 
to see where I am going wrong and duplicate my exact installation. 

What do you guys charge for such a job? I know it's quite small but I do need 
your help. 
==
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo Impossible Installation

2016-04-05 Thread Azam Premji
Hi Ludovic,

It looks like I'll need to move to Debian or Ubuntu. 

Hope there are plans for a more compatible version and better documentation. 

Back on the install SOGo horse for a few days...


Azam

> On Apr 5, 2016, at 6:42 AM, Ludovic Marcotte (lmarco...@inverse.ca) 
>  wrote:
> 
>> On 2016-04-05 00:01, blueb...@gmail.com wrote:
>> Next problem is to get OpenChange 2.3 installed but it only works with Samba
>> 4.1.18 and the SerNet guys have 4.1.23 on their site not 4.1.18 (arrrgggh). 
>> So
>> I can't get Samba4 installed on CentOS 7. Would I be accurate in saying SOGo
>> isn't supported on CentOS 7?
> SOGo is supported on CentOS 7 - just not with OpenChange. The only 
> distributions we do support with OpenChange are Debian 8 and Ubuntu Trusty - 
> this is stated in the documentation.
> 
> -- 
> Ludovic Marcotte
> lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
> (http://packetfence.org)
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists