I've updated my server from Zarafa to Kopano, but the database was empty after the update.
The new mail was coming in and all the users account is working.

I needed to import my zarafa database backup to have the old mail back.

Uff, this gave me quiet a headache. Since the kopano database is working I dumped my mysql-zarafa-dump into the kopano database and .... it works! No idea why changing the database in /etc/kopano/server.cfg to the existing zarafa db (db user, db name, db password) did not work for me. Maybe a naming issue, I do not know.

I will do some more intensive testing to see, if something else is off, but hopefully not.

Best wishes,

Robert

Hi,

I tried, but the kopano brick level backup system is different to the zarafa brick level backup system. I cannot restore the system using the zarafa brick level backups with kopano.

Is is possible to move the data from the zarafa database into the kopano database? I have the feeling this is the only way to solve that.

Thank you.

Best wishes,

Robert

EDIT: Just to make clear, when I use the kopano database everything is working. In that moment when I use the old attachment files (kopano:kopano user permissions) and put the zarafa database in /etc/kopano/server.cfg (username zarafa, password and database name zarafa) I cannot receive system emails or any other emails anymore.

Hi Nick,

Thank you for your reply. I followed the migration documentation to the point. I should have brick level backups somewhere, let me see if they can use them with the kopano database.

Best wishes,

Robert

In phpMYAdmin (link in the Webconfig > Server > Database > MariaDB Database Server, password in /var/clearos/system_database/root) you can drop entire databases or it can be done from the command line, but I don't know much more than that and I don't know if you'll get yourself into deeper water.

Did you use the migration document to go from Zarafa to Kopano

OK, I connected the kopano database which got created when I installed kopano and I actually received a test-mail directly after installation at that point. When I connect this database now, I can see this mail, but cannot get new mails anymore or send mails between users.

Somehow, by changing the kopano database to the zarafa database something got messed up I cannot correct anymore.

How can I remove the new kopano database, so I can redo the fresh install of kopano like I did in the first place, where mailing was still working?

Where are the mails gone to, which got fetched (by fetchmail), but did not end up in kopano?

Thank you.

Best wishes,

Robert

EDIT: I managed to fall back to the kopano database and I could receive mails now.

My questions remaining: how do I connect my old zarafa database? Where are the mails gone I got in between?

Thank you.

EDIT2: I can repeatedly go back and forth with using the new kopano database, where I can receive mails and the old zarafa database, were I cannot receive mails. Except the attachments folder I keep everything under /var/lib/kopano the same, when I change the database in /etc/kopano/server.cfg

Hi,

in the system log I found the following:

Jan 28 00:20:05 server mailfilter: Invalid response code received from server <ID: <kcim.5a6cd09d.702d.4bf1394816566562@server.email.de>>, /usr/clearos/apps/mail_routing/libraries/Transport.php, 203

Thank you for your help.

Best wishes,

Robert

Hi,

I just want to mention, that I did not extend my Zarafa license, but bought a new Kopano Basic license. Maybe this plays into that. I also did not get a key I put in the webconfig, as I used to for Zarafa. I can unfortunately not check the webconfig right now, because I coupled the 2-factor authentication for the webconfig with my mail account on the server, which I cannot receive mails from right now, also no system mails. So I am logged out of the webconfig right now.

Best wishes,

Robert

Hi Nick,

Thanks for your reply. I used to have:

"robert@email.de@localhost."

which always worked for Zarafa, but after the upgrade not anymore for Kopano, so I though it might look to weird for Kopano and changed to plain robert, but both are not working considering delivery to Kopano.

Best wishes,

Robert

EDIT: The fetchmail problem is somehow gone now by going back to "robert@email.de@localhost." .

EDIT2: The kopano problem remains with the error messages. I still cannot receive mails or send them between users on the same machine.

I don't know if it is relevant as I don't use it any more, but my /etc/fetchmail used robert@localhost and not just plain robert.

Hello,

I looked into fetchmail log:

Jan 27 21:27:46 server.email.de fetchmail[2093]: SMTP error: 550 5.1.1 <robert@localhost>: Recipient address rejected: User unknown in local recipient table

Jan 27 21:27:46 server.email.de fetchmail[2093]: mail from MAILER-DAEMON@server.email.de bounced to hmkdl@khjkhjk.com

Jan 27 21:27:46 server.email.de fetchmail[2093]: can't even send to fetchmail!

It seems fetchmail cannot find the user in kopano. I also tried to send emails on the server between different users - no success. I read the kopano uses virtual users, not the system users. What is going on with that?

Thank you.

Best wishes,

Robert

Hello,

I dig through the kopano logs and found the following:

in dagent.log

Dagent log

Sat Jan 27 20:44:54 2018: [error  ] [31488] Unable to commit message: 0x80040116

Sat Jan 27 20:44:54 2018: [error  ] [31488] Unable to deliver message to 'robert', error code: 0x80040116

Sat Jan 27 20:44:54 2018: [error  ] [31488] Unable to deliver all messages for server 'default:'

Sat Jan 27 20:44:54 2018: [error  ] [31488] Client disconnected

0x80040116 means: MAPI_E_DISK_ERROR - according to the kopano webpage

in server.log

Sat Jan 27 20:44:45 2018: [error  ] Not all objects in relation found for object "robert"

Sat Jan 27 20:44:54 2018: [error  ] Unable to open attachment "/var/lib/kopano/attachments/2/14/122542.gz" for writing: Permission denied

Did chown -R kopano.kopano /var/lib/kopano/attachments/ - error still exists

My fetchmail setup looks like the following:

poll pop3.web.de protocol pop3 username "username" ssl password "password" is robert here

Does this help in any way?

Thank you.

Best wishes,

Robert