Kopano core with Debian 9

externa1

Hi,

should be in /etc/mysql.secret and kopano-mysql.secret for kopano user

rg
Christian

benusa

Hi externa
question
i make a backup with mysqldump from kopano UCS server, the DB ist 1,3MB
my old zarafa DB with same date have 100MB.
its a problem with dump?

AnotherAndy

hi,
pretty sure it’s a problem.
Which command did you use?
mysqldump kopano --skip-lock-tables --single-transaction -ukopano -pXXXXXX >kopanoDB.sql
best regards

benusa

@anotherandy thx. I have test with your parameter --> is the same result

externa1

Hi,

only a thougt from me.
But Zarafa in earlier versions stored the attachements in SQL DB and now in kopano they are stored in file system - can this be the cause of your different size in DB Dump ?
what was your zarafa config ? and how did you migrate the data to new server ?

rg
Christian

benusa

i have install a new UCS Server Standrad with all kopano Apps
then i copy my data with z-push from Outlook to new Kopano
all data ok and SYNC with smartphone ok.
then i must a SQLDUMP with your parameters

So

i install a new Version from UCS Server on a notebook a testsystem.
then i make a mysql restore with the data from orginal kopano
the testsystem has no data.
the database ist very smal befor i restore

i dont no
i have test with manual mysqldump and parameters
and with “automysqlbackup” tool fpr linux

thx ben

externa1

@benusa said in Kopano core with Debian 9:

i have install a new UCS Server Standrad with all kopano Apps

then i copy my data with z-push from Outlook to new Kopano

all data ok and SYNC with smartphone ok.

then i must a SQLDUMP with your parameters

So

i install a new Version from UCS Server on a notebook a testsystem.

then i make a mysql restore with the data from orginal kopano
the testsystem has no data.
the database ist very smal befor i restore

i dont no
i have test with manual mysqldump and parameters
and with “automysqlbackup” tool fpr linux

thx ben

then i copy my data with z-push from Outlook to new Kopano

How did you do that ?

you can not import mails through z-push as activesync does not provide this - you’ll have to export to pst instead and import though kopano server console kopano-migration-pst tool

rg
Christian

benusa

E-mail was not important in this case.
get the over kopano per imap from external system.
There they are still.
I am primarily concerned with calendars and contacts

externa1

@benusa

as i said in my previous port - dump to pst from outlook on old server - copy the pst to new server and run kopano-migrate-pst to import to new server and user - this implies mail, contacts and calendar items

rg
Christian

benusa

@externa1 said in Kopano core with Debian 9:

as i said in my previous port - dump to pst from outlook on old server - copy the pst to new server and run kopano-migrate-pst to import to new server and user - this implies mail, contacts and calendar items

Thank you
In principle, I have achieved my goal, the system is running excellent.
BUT
I wanted to test one if I fail the productive system, I set up the new system and want to import the SQL DB.
I also do a snapshot of the server all ok.
The goal is to create a SQL DB backup, which I can use again at any time.

fbartels

You are thinking way to complex. Just use kopano-backup to backup and restore your system. No need to go through ActiveSync and a PST export.

Sinux

@benusa said in Kopano core with Debian 9:

i have install the kopano core with debian 9

when i restart computer the kopano-server not aktiv
i must start from console.

in “/init.d/” are not startscripts from all services for kopano

thx
ben

Hi ben,
if you still want to try it with debian 9 that would be your solution,

systemctl list-units | grep kopano
systemctl enable kopano-dagent
systemctl enable kopano-server

Bro

@sinux

you can add:
systemctl enable kopano-spooler
(en if necessarry for your setup ‘systemctl enable kopano-gateway’)

to that list. Took me hours of troubleshooting to find out the kopano-spooler should be running but wasn’t. :-/

Regards,

Bro