Thanks, it’s working !
I will try tomorrow with the nightly package

An update: I’ve ignored the missing dependencies and upgraded my Tumebleweed release including the Kopano core release to version 10.0.5 first on a sandbox copy first and then on the production site and didn’t find an issue up to now.

I mentioned in a topic that linked to this, but want to mention it here as well.

In the end we decided to disable the build for Ubuntu 16.04 in the nightly downloads since it was failing automated testing and there are already two newer Ubuntu lts releases available anyways.

16.04 for the moment still remains available for customers with a subscription, but will also be removed for releases based on the current master branch.

Hi @andrereese,

Univention has described how to setup a mail relay in their documentation: https://docs.software-univention.de/cyrus-4.2.html#mail::serverconfig::relay

But installing the mailserver app is not required for this, all the needed parts already come with the Kopano app.

Solved. Altough i’m running Kopano4s against a Mysql docker container, i still had to start Mariadb to create the /run/mysqld/mysqld10.sock
softlink
I can stop the Mariadb package after starting the Kopano4s package , which removes the softlink but kopano4s keeps running without

@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.

@Anth-frnog I don’t know. Normally people want it the other way around. Can you specify a username/password in the URL of the calendar in Google? If yes, then you could do something like https://username:password@server/caldav.

What is your usecase for having your Kopano calendar in Google?

Hi @peterm888,

I looked into two such reports in the past, but this was never reproducible and therefore nothing much has happened there (but this systems were all well above the home use scale). Do you have specific steps to reproduce this issue?

While running with process_model thread uses a bit less resources if you really want to scale out and avoid potential connection reuse issues fork is indeed the better choice.

Hi @micro,

what exactly did not work with gateway, spooler and dagent? At least for gateway it uses a tcp connection to talk with the server, the other two by default use a unix socket (where I would not expect a difference between ipv6 active/deactivated).

@crankshaft said in Kopano is using up all mysql connections ?:

Why not implement proper mysql connection pooling and have an option to set the pool size, so that the threads can share the connection pool ?

At worst, every thread (some number N) will have work to do, and then you need N connections anyway, whether you use the current static (thread-private on-first-use) approach or a (shared) pool.

Running with a conn pool smaller than that would mean requests to kopano-server via the SOAP-HTTP interface would have to block waiting for a free SQL connection, at which point you could just reduce the threadcount with the same effect.

The patch of https://forum.kopano.io/topic/1849/kopano-search-unable-to-create-new-sync-state didn’t work to solve one of the exceptions.

2020-06-01 13:45:03,513 - search - WARNING - Sync state does not exist on server (anymore); requesting new one 2020-06-01 13:45:03,515 - search - ERROR - Traceback (most recent call last): File "/usr/lib/python3/dist-packages/kopano/ics.py", line 290, in sync exporter.Config(stream, flags, importer, restriction, None, None, 0) File "/usr/lib/python3/dist-packages/MAPICore.py", line 1585, in Config return _MAPICore.IExchangeExportChanges_Config(self, lpStream, ulFlags, lpUnk, lpRestriction, lpIncludeProps, lpExcludeProps, ulBufferSize) MAPI.Struct.MAPIErrorNotFound: MAPI error 8004010F (MAPI_E_NOT_FOUND) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/kopano/log.py", line 102, in log_exc try: yield File "/usr/lib/python3/dist-packages/kopano_search/__init__.py", line 358, in incremental_sync new_state = self.server.sync(importer, self.state, log=self.log) File "/usr/lib/python3/dist-packages/kopano/server.py", line 1070, in sync return _ics.sync(self, self.mapistore, importer, state, max_changes, File "/usr/lib/python3/dist-packages/kopano/ics.py", line 297, in sync syncid, changeid = struct.unpack('<II', _bdec(state)) struct.error: unpack requires a buffer of 8 bytes

But at least after running

kopano-search --reindex -u myuser

the search returns also newer mails.

The exception above is still there nd mails arriving after the reindex are not found.

@bayerlein In Thunderbird Addressbook you can add an LDAP Directory to access the GAL. I never tried it though.

Hi

Aften one more update of Ubuntu 20.04 the error is gone, her today

Claus

With python-kopano you have a powerful tool to export and manipulate data.

I linked to a simple csv tool a few days ago in https://forum.kopano.io/topic/3209/automated-address-export. Another approach would be https://stash.kopano.io/projects/KC/repos/kopanocore/browse/swig/python/kopano/scripts/rfcdump.py. and there is kdav as well which could export contacts via carddav.

If you need specific help or scripts created to you I’d recommend to reach out to the Kopano support.

i had a small peak on this.

can you verify and tell what the group type is used?
And how doe other groups show, if you compair it to above.

groupType: -2147483646 << this is related thats not good.
We should see a positive number not - …

I’ll look into it. Thanks a lot

@compsos said in Kopano-search issue:

TypeError: Can’t convert ‘bytes’ object to str implicitly

Python makes a clear distinction between bytes and strings . Bytes objects contain raw data — a sequence of octets — whereas strings are Unicode sequences . Conversion between these two types is explicit: you encode a string to get bytes, specifying an encoding (which defaults to UTF-8); and you decode bytes to get a string. Clients of these functions should be aware that such conversions may fail, and should consider how failures are handled.

We can convert bytes to string using bytes class decode() instance method, So you need to decode the bytes object to produce a string. In Python 3 , the default encoding is “utf-8” , so you can use directly:

b"python byte to string".decode("utf-8")

Hi,

it seems to be a problem on the server itself. Some users are working with Microsoft Outlook and the same problem here.

There is a update for the Kopano WebApp: “Version 3.5.5.2276 kann auf 3.5.14.2539 aktualisiert werden”

This weekend i will do this updaten and come back with the new state then.

Kind regards

Jochen