univention corporate server with zarafa - in phpVirtualbox - solved

[ndk]

hi, i use freenas several months now as backup and media storage and i am very satisfied!
as you see i have pretty powerful hardware and i would like to use it more.

so i testet the univention corporate server with zarafa in a vm on my pc and i liked it.

now i would like to install it on freenas in a jail. has anybody an idea how to do that?
i tried it already in a phpvirtualbox but the symbol during import never stops turning.

if it is not possible i would like to install Zarafa Groupware-Server itself at least.

any suggestions appreciated!
thx

 

[pirateghost]

You would have to install univention in a virtual box since its a complete Linux distro. There is no way to install it by itself in a jail.

For zarafa, is there a freebsd version? If so, you can install it in a plain jail.

 

[ndk]

thank you, yes its a complete Linux distro
so i tried to install it in a phpvirtualbox already, but the symbol during import never stops turning.
maybe someone has an idea why
or knows how i prepare the phpvirtualbox?
thx

 

[Robert Trevellyan]

or knows how i prepare the phpvirtualbox?

Your best bet is if the support resources for Zarafa include instructions for virtualization. Maybe they even offer an appliance image?

 

[pirateghost]

Your best bet is if the support resources for Zarafa include instructions for virtualization. Maybe they even offer an appliance image?

Univention works in a VM, zarafa and univention are different products.

 

[Robert Trevellyan]

Univention works in a VM, zarafa and univention are different products.

OK, got it, thanks.

s/zarafa/univention/

 

[pirateghost]

I've never had an issue running univention in a VM from the ISO. I don't like preconfigured VM appliance images.

 

[Robert Trevellyan]

I guess my point is, this isn't a FreeNAS issue.

 

[pirateghost]

True, but it's more of a "how do I configure virtualbox to run this VM"

Running it from proper hypervisor is no problem. This is a virtual box running on freenas issue

 

[Robert Trevellyan]

This is a virtual box running on freenas issue

Could be, frankly I'm out of my depth at this point.

 

[ndk]

NEWS
univention corporate server OVM 64Bit is imported in phpVirtualbox 32Bit.
i had not activated Virtualization Technology in Bios by mistake. so i could not import 64bit VM in 32Bit Virtualbox.

BUT NOW NEW PROBLEM WITH JAVA
now i have to connect to the console to complete the installation. but i just get certificate errors from java.
i tried to configure the exceptions list, but no success.

 

[danb35]

Enable remote display under the Display section of the VM's settings, and use your favorite VNC client to connect (IP will be the IP of your virtualbox jail, port will be the port you specify).

 

[ndk]

thank you!
yes that was helpful. but i had to do it by command line:
tvnviewer.exe -host=IP:Server-Port -password=VNC-Password

now i'm struggling a bit with the active sync config for my android phone.
you know, i already have a ucs-zarafa in vmware-workstation on my pc, which works great.
every time i sync my android with the new installed ucs-zarafa in phpVirtualbox on Freenas, it deletes all the contacts and appointments.
now im trying to backup - restore the mysqldb and the zarafa directories.

any suggestions appreciated!
thx

 

[ndk]

it worked, i will post a howto as soon as i am allowed to.

 

[pirateghost]

it worked, i will post a howto as soon as i am allowed to.

You can post one whenever you like. We have to move it to the How-Tos section once approved.

 

[ndk]

how to sync exchange clients like android/ios/... with zarafa on freenas

note: active-sync is syncing only data which is connected with the active-sync account: see configure your device at the end

installation of Univention-Corporate-Server in php-virtualbox
download VirtualBox image of Univention-Corporate-Server: univention.com/downloads (UCS-Virtualbox-Demo-Image.ova)
download "Free for personal use edition" license (http://sdb.univention.de/1295)

enable vt (virtualization technology) in bios on freenas
necessary to import 64 bit vm into 32 bit vbox

in freenas add a VirtualBox Jail (the Version was 4.3.12)
create a separate storage dataset
activate: autostart, vimage / deactivate: nat, vanilla
add storage to access the downloaded image

import UCS-Virtualbox-Demo-Image.ova
login to the VirtualBox with Web Browser and import the file

connect to the installation wizard with vnc
check VM Setting: Remote Display
then connect: tvnviewer.exe -host=IP:PORT -password=PASSWD (www.tightvnc.com)

clicking through install wizard
select your language and location
IMPORTANT: select the same timezone as you have in your phone, otherwise you will have problems with all day appointments
NEXT
choose a fix ip address from your home subnet
as dns server use your router or check ipconfig /all / ifconfig on your PC
NEXT
create new ucs domain
NEXT
Organisation Name (will be part of the url for syncing and mailing)
the email address is not needed yet, it will be used to get your licence
choose a password for the administrator account
NEXT
do not change the host settings, unless you now about
NEXT
i selected kde, nagios
IMPORTANT: do NOT select mail-server yet!
you can add features later as well
NEXT
select updates i you like and confirm
NEXT
wait few minutes for completion

now connect to the Webpage of the installed vm and login with username: administrator
add License: right corner after "User Administrator" and navigate to "License (http://sdb.univention.de/1295)
add Zarafa plugin
click on software
app center
scroll down and install Zarafa Collaboration Platform
then install Z-Push for Zarafa

add new user for zarafa
click on Users
Users
add a new "Zarafa Account" for connecting your phone or any other device

login into zarafa
click on software
app center
select Zarafa Collaboration Platform and click on "open website"
login with your Zarafa Account
now you should have mail calendar contacts ...

add your device
got to accounts
add a exchange active-sync account
probably you have to use manual setup to enter the ip address instead of then servername
and Accept all SSL certificates

configure your device
active-sync is syncing only data which is connected with the active-sync account
in my case
i edited my appointments by hand on the phone
and ex- and imported all the contacts by vcard file, which is built in on android

 

[ndk]

Backup, Restore and Status of Zarafa in Univention-Corporate-Server in php-virtualbox

Status Commands

note: the mysql username and password are in /etc/zarafa/server.cfg
so you can set variables with the Values and use it then:

grep ^mysql_[dup][sa] /etc/zarafa/server.cfg|sed 's/ //g'
#copypaste 3 lines

#Status of Zarafa:
ls /etc/init.d/zarafa* | while read f;do $f status ;done

#Status of MySql
/etc/init.d/mysql status

#Status of MySql detailed
grep ^mysql_[dup][sa] /etc/zarafa/server.cfg|sed 's/ //g'
#copypaste 3 lines
mysqlcheck --user=$mysql_user --password=$mysql_password --all-databases --check

Backup Commands

#stop Zarafa first
ls /etc/init.d/zarafa* | sort -r | while read f;do $f stop ;done

#Backup mysql and the 2 Directories
grep ^mysql_[dup][sa] /etc/zarafa/server.cfg|sed 's/ //g'
#copypaste 3 lines

NOW=$(date +%Y%m%m_%H%M%S)
cd; mysqldump --single-transaction --all-databases --user=$mysql_user --password=$mysql_password > zarafa_mysql_${NOW}.dmp
cd /usr/share ; tar -cvf ~/z-push_${NOW}.tar z-push ; cd
cd /var/lib ; tar -cvf ~/zarafa_${NOW}.tar zarafa ; cd

# start Zarafa
ls /etc/init.d/zarafa* | while read f;do $f start ;done

Restore Commands

#check Database before restore
grep ^mysql_[dup][sa] /etc/zarafa/server.cfg|sed 's/ //g'
#copypaste 3 lines
mysqlcheck --user=$mysql_user --password=$mysql_password --all-databases --check

#stop Zarafa first
ls /etc/init.d/zarafa* | sort -r | while read f;do $f stop ;done

#choose the Backup you wanna restore
RESTORENOW=#20150808_162404# use Date and Time of the Files here#
#check Backupfiles access
ls -al ~/zarafa_mysql_${RESTORENOW}.dmp

#restore mysql with Backupfile
grep ^mysql_[dup][sa] /etc/zarafa/server.cfg|sed 's/ //g'
#copypaste 3 lines
cd; mysql --user=$mysql_user --password=$mysql_password < zarafa_mysql_${RESTORENOW}.dmp

#check Database after restore
grep ^mysql_[dup][sa] /etc/zarafa/server.cfg|sed 's/ //g'
#copypaste 3 lines
mysqlcheck --user=$mysql_user --password=$mysql_password --all-databases --check

#restore the directories
cd /usr/share ; tar -xvf ~/z-push_${RESTORENOW}.tar z-push ; cd
cd /var/lib ; tar -xvf ~/zarafa_${RESTORENOW}.tar zarafa ; cd

# start Zarafa
ls /etc/init.d/zarafa* | while read f;do $f start ;done

#use following commands to hook restored id to a user
zarafa-admin -l
zarafa-admin --list-orphans # list all userid, some you may have just restored
zarafa-admin --hook-store <store-guid> -u <user>