View Issue Details

IDProjectCategoryView StatusLast Update
0001827SOGo Native Outlook Compatibility (obsolete)public2012-09-26 12:31
Reporterlcharfi Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Product Version2.0.0beta2 
Summary0001827: ZEG Unable to connect to Outlook using the Virtual Appliace
Description

Hi,

I found an alternative of the expensive licence of Microsoft exchange ! SOGO ! thanks for your work !

I wanted to try out he virtual machine “ZEG” . I imported into virtual box and it starts and I get a valid IP address which I can ping externaly. I created another virtual box running windows XP and installed Microsoft office 2010. I can ping the Zeg appliance from the xp machine. I can even connect to the sogo server and I can access the webmin console through the XP machine. I modified the hosts file on the 7 machine but outlook will not connect. I go to control panel to mail setup and follow the guide on the sogo.nu site. For the user name I use sogo1, 2, or 3 with the password sogo. I’ve tried "> sogo1@example.com, sogo1, sogo\sogo1 as user names I get nothing. The only thing I get is either “your Microsoft exchange server is unavailable” or “the action could not be completed. The connection to the Microsoft exchange server is unavailable. Outlook must be online or connected to complete this action.”

I have exactly the same issue ?

PLease Advise and help `??

Thanks for all

Laurent

TagsNo tags attached.

Activities

wsourdeau

wsourdeau

2012-06-01 13:55

viewer   ~0004004

What are the entries you have added to your hosts file?

joe

joe

2012-06-02 19:06

reporter   ~0004008

192.168.0.222 sogo.openchange.local sogo example.com

joe

joe

2012-06-03 16:35

reporter   ~0004009

i also tried pinging domain names to make sure that dns was working corectly on xp box and it displayed the local 192.168.0.222

lcharfi

lcharfi

2012-06-04 06:48

reporter   ~0004010

I added the IP Adress of my network : 192.168.2.30

192.168.2.30 sogo.example.com autodiscover.example.com

lcharfi

lcharfi

2012-06-04 12:16

reporter   ~0004012

I follow the best practice :http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf

Users that wish to connect natively to SOGo must be provisioned, for now, in
Samba 4 and in OpenChange – even if they already exist in your current LDAP /
Microsoft Active Directory server.
To add an user, execute the following commands:

add user to samba

samba-tool domain passwordsettings set --complexity=off
samba-tool domain passwordsettings set --min-pwd-length=1
samba-tool user add <username>
samba-tool user setexpiry <username> --noexpiry

create user in openchange

openchange_newuser --create <username>
Important note:

i follow this steps but when i tried to use the openchange_newuser command line

root@sogo:~# openchange_newuser --create test3
Traceback (most recent call last):
File "/usr/sbin/openchange_newuser", line 66, in <module>
openchange.newuser(lp, creds, username=args[0])
File "/usr/lib/pymodules/python2.7/openchange/provision.py", line 288, in newuser
db.modify_ldif(extended_user)
File "/usr/lib/python2.7/dist-packages/samba/init.py", line 237, in modify_ldif
self.modify(msg, controls)
_ldb.LdbError: (32, 'No such Base DN: CN=test3,CN=Users,DC=example,DC=com')

Can you please advice ??

Thanks

Laurent

lcharfi

lcharfi

2012-06-06 08:40

reporter   ~0004020

I solved the problem.
i change the sogo1,sogo2,sogo3 password
with

samba-tool user password "user"

but
when i tried to create a new one. i got the same message.
can you advise with the user creation processe ??

Thanks

Laurent

wsourdeau

wsourdeau

2012-06-18 16:02

viewer   ~0004065

I don't undesrtand.... were you able to connect after you created those users or not?
The messa ge"No such base DN" will only occur if the users have not been created by "samba-tool" beforehand.

Btw, you are using a wrong version of Openchange because the "openchange_newuser" command is no longer required since at least january 2012... Why don't you use our pre-built packages instead?

joe

joe

2012-06-19 14:30

reporter   ~0004078

no we cannot connect with the newly created samba users. what's the next step? the directions do not specify what to do.

wsourdeau

wsourdeau

2012-06-19 14:32

viewer   ~0004079

Well.. we know this works since we tested it on many configurations already and others have done so too. Therefore this must be a configuration issue on your side. I would recommend posting a question in our mailing-list or purchase a support plan from us.

joe

joe

2012-06-19 15:47

reporter   ~0004080

ok, maybe there is a misunderstanding. my issue is with the virtual machine from sogo.nu . i have tried rc1,2, and 3. all have the same issue. using the guide. i create a user using:

samba-tool domain passwordsettings set --complexity=off
samba-tool domain passwordsettings set --min-pwd-length=1
samba-tool user add <username>
samba-tool user setexpiry <username> --noexpiry

running:

openchange_newuser --create <username>

generates an error.

(and yes i've change the username!)

i can change the sogo1,2,and 3 passwords using:

sudo samba-tool user setpassword sogo1

then i can connect using outlook but only if i use one of these 3 accounts (sogo1,2,3). how do i add a new account and then use outlook to connect? the instructions are incorrect/incomplete in regards to the pre-made virtual machine.

i also tried successfully to add a new user directly to the ldap database using webmin to clone one of the 3 already existing users (sogo1,2,3). i see the user in samba, ldap, and postfix. i can log into the <ipaddress>/SOGo with the user i create. but i can't user outlook to connect. what am i missing? i just want to add a new user to the already pre-made virtual machine and use outlook to access it.

thanks for your time!:)

hansaplast

hansaplast

2012-06-20 14:17

reporter   ~0004082

Same here...
I got ZEG-2.0.0rc3.ova in virtualbox 4.1.16 on a bridged nic.

From Windows 7 (x64), with Office 2007 I also get "The connection to the Microsoft exchange server is unavailable"

hansaplast

hansaplast

2012-06-21 11:17

reporter   ~0004083

Oké.

If you have issues connecting to the sogo "Exchange" server, make sure you turn off your firewall for real. Some firewalls attach a driver to your network card. You should disable this driver in the "VirtualBox Host-Only Ethernet Adapter".

  • Click your network icon in the system tray, "Open Network ... Center" and "Change adapter settings"
  • Right click "VirtualBox Host-Only Ethernet Adapter" and select "Properties"
  • Disable the driver from your firewall (if available).

I use COMODO internet security so mine was "COMODO Internet Security Firewall Driver"

Best regards,
-Hansa

joe

joe

2012-06-21 14:18

reporter   ~0004084

this is "not" a firewall issue. this is a problem with the zeg premade virtual machine for v2rc1,rc2, and rc3. enabling and disabling the firewall does not work. the problem is that the accounts that come pre-setup are sogo1, sogo2, sogo3. you need to change their passwords by using the command:
sudo samba-tool user setpassword sogo1
then you can access sogo server using microsoft outlook but only with the 3 pre-setup accounts. you can configure outlook either by using the ipaddress of the sogo server or adding some entries in the windows machines hosts file.

as per this issue 1827 it started with not being able to connect. that issue was fixed by changing the passwords that must have expired for the sogo1, sogo2, and sogo3 accounts. now the problem is with creating new accounts. you can create them in samba but once you try to add them to openchange it fails.

i have gone in to webmin and cloned a user in the ldap database as it states under the configuration page of the sogo server of the virtual machine.

does anyone know how to do this? i believe it's an issue with the premade virtual machine and how it was built.

Christian Mack

Christian Mack

2012-06-22 08:48

developer   ~0004085

Did you add your user in samba too?

AFAIK Webmin only adds it to the LDAP.

joe

joe

2012-06-22 13:41

reporter   ~0004087

yes by running:

samba-tool domain passwordsettings set --complexity=off
samba-tool domain passwordsettings set --min-pwd-length=1
samba-tool user add <username>
samba-tool user setexpiry <username> --noexpiry

the error comes when trying to add to openchange backend:

openchange_newuser --create <username>

the error:
Traceback (most recent call last):
File "/usr/sbin/openchange_newuser", line 66, in <module>
openchange.newuser(lp, creds, username=args[0])
File "/usr/lib/pymodules/python2.7/openchange/provision.py", line 288, in newuser
db.modify_ldif(extended_user)
File "/usr/lib/python2.7/dist-packages/samba/init.py", line 237, in modify_ldif
self.modify(msg, controls)
_ldb.LdbError: (32, 'No such Base DN: CN=test3,CN=Users,DC=example,DC=com')

what are we missing? i also noticed i had to install the cyradmin package to add e-mail directories etc..

joe

joe

2012-06-22 13:43

reporter   ~0004088

also running "samba-tool user list" shows the user i've created.

joe

joe

2012-06-22 15:27

reporter   ~0004089

Last edited: 2012-06-25 19:27

i wonder was a package that's needed for this process removed when the virtual machine was configured? i noticed that cyradmin was. i was able to figure out how to add a user and login to sogo through web browser but i can't connect to sogo/openchange through outlook.

ludovic

ludovic

2012-08-16 18:44

administrator   ~0004340

Try again with the version that will be available next week.

ludovic

ludovic

2012-09-26 12:31

administrator   ~0004552

No feedback provided in more than a month, closing.

Please also have an other look at our native Outlook configuration guide from http://www.sogo.nu/downloads/documentation.html

It has been MUCH updated since the previous release.

Issue History

Date Modified Username Field Change
2012-06-01 12:24 lcharfi New Issue
2012-06-01 13:55 wsourdeau Note Added: 0004004
2012-06-02 19:06 joe Note Added: 0004008
2012-06-03 16:35 joe Note Added: 0004009
2012-06-04 06:48 lcharfi Note Added: 0004010
2012-06-04 12:16 lcharfi Note Added: 0004012
2012-06-06 08:40 lcharfi Note Added: 0004020
2012-06-18 16:02 wsourdeau Note Added: 0004065
2012-06-19 14:30 joe Note Added: 0004078
2012-06-19 14:32 wsourdeau Note Added: 0004079
2012-06-19 15:47 joe Note Added: 0004080
2012-06-20 14:17 hansaplast Note Added: 0004082
2012-06-21 11:17 hansaplast Note Added: 0004083
2012-06-21 14:18 joe Note Added: 0004084
2012-06-22 08:48 Christian Mack Note Added: 0004085
2012-06-22 13:41 joe Note Added: 0004087
2012-06-22 13:43 joe Note Added: 0004088
2012-06-22 15:27 joe Note Added: 0004089
2012-06-25 19:27 joe Note Edited: 0004089
2012-07-25 20:08 ludovic Target Version => 2.0
2012-08-16 18:44 ludovic Note Added: 0004340
2012-08-16 18:44 ludovic Target Version 2.0 =>
2012-09-26 12:31 ludovic Note Added: 0004552
2012-09-26 12:31 ludovic Status new => closed
2012-09-26 12:31 ludovic Resolution open => no change required