Remove user from kopano

mlued

Hello kopano-forum,
I want to test a migration from exchange to kopano. For that, I have a testuser.
If I log in with this user for the first time, the following script is been executed:
/usr/lib/kopano/userscripts/createuser.d/00createstore
I got an error after the login at the web-app. “Der Stadard-Store fehlt in der Hierarchie” => “the standard-store is missing in the hierarchy” (the “system”-user has a public store attached)

So, to test/debug this, I would like to delete the user and retry this. My problem is, that I have an LDAP/AD. So to test this, I would need to delete the user in LDAP which I would prefer not to.
Is it possible to “remove” the user only from kopano, so I would have the status, as if he would never tried to open the webapp, so the createstore script is executed again?
Greetings from germany
Maik

fbartels

Hi @mlued,

if it’s a test system you could drop the whole database. If you really just want to get rid of a single user you could also remove this one user from the users table in the database.

Which version are you running?

mlued

Hello mr Bartels,
we have a Debian 10 with the shipped Kopano Version 8.7.0.
How can I delete the user respectively how do I know, who is the correct user?
If I do

SELECT * FROM kopanoserver.user;

I don’t get a readable username.
Btw. I did remove the database and kopano created a new one. As soon, as I did

kopano-admin --sync

The users were back again and I get the infamous error:
Unknown MAPI Error:
MAPI_E_NOT_FOUND
As soon, as I do

kopano-admin -Cn <username>

The user can login again. (with an empty mailbox, of course)

Regards from germany

fbartels

@mlued said in Remove user from kopano:

we have a Debian 10 with the shipped Kopano Version 8.7.0.

I cannot really recommend using the version packaged in Debian. Its not maintained or tested by Kopano itself and the Debian package policy makes it hard to keep it up to date with fixes that we publish. For production environments I recommend to purchase a Kopano subscription and use our releases.

You can request a trial key for access to our package repositories at https://kopano.com/kopano-trial-download/.

@mlued said in Remove user from kopano:

How can I delete the user respectively how do I know, who is the correct user?

This is an excerpt of that table:

# mysql -e "select * from kopano.users"
+----+----------------+-------------+-----------------+---------+
| id | externid       | objectclass | signature       | company |
+----+----------------+-------------+-----------------+---------+
|  1 | NULL           |      196610 |                 |       0 |
|  2 | NULL           |       65537 |                 |       0 |
|  3 | 2              |       65537 | 20180420091605Z |       0 |
|  4 | 5              |       65537 | 20180420091712Z |       0 |
|  5 | 6              |       65537 | 20170206110658Z |       0 |
|  6 | 7              |       65537 | 20180420091723Z |       0 |
...

The value in externid is how you can identify your users. It has the value of ldap_user_unique_attribute of a given user.