Seafile

After upgrading MariaDB to 10.5 Seafile stopped working. journalctl showed errors like the following for mariadb.service: [Warning] Aborted connection 62 to db: 'seafile_ccnet-db' user: 'seafile' host: 'localhost' (Got an error reading communication packets) Further investigation revealed the open files limit to be the root cause: root@server:~# mysql -e "SHOW VARIABLES LIKE 'open_files_limit';" +------------------+-------+ | Variable_name | Value | +------------------+-------+ | open_files_limit | 32768 | +------------------+-------+ To increase the limit the corresponding Systemd unit needs to be overriden using systemctl edit mariadb.service. This creates /etc/systemd/system/mariadb.service.d/override.conf: ...

If you’re runing the latest version of seafile-cli (4.3.2) on Debian you might encounter the following error in your seafile.log: http-tx-mgr.c(653): libcurl failed to GET https://domain.tld/seafhttp/protocol-version: Problem with the SSL CA cert (path? access rights?). This is because the client is built on CentOS where the CA certificates reside in a different location. Luckily there is an easy fix available (see https://seacloud.cc/group/3/wiki/seafile-cli-manual/) : sudo mkdir -p /etc/pki/tls/certs sudo cp /etc/ssl/certs/ca-certificates.crt /etc/pki/tls/certs/ca-bundle.crt sudo ln -s /etc/pki/tls/certs/ca-bundle.crt /etc/pki/tls/cert.pem That’s it – restart your client and it should sync again. ...

If you’re working with LaTeX and store you tex-Files in a Seafile repository you might end up with tons of files which are generated by the LaTeX compiler. Since they don’t need to be tracked by Seafile I came up with the following solution. Place a file called seafile-ignore.txt in the root of your library and fill it with this: ## exclude LaTeX compile files from syncing *latex*/*.acn *latex*/*.acr *latex*/*.alg *latex*/*.aux *latex*/*.bbl *latex*/*.blg *latex*/*.dvi *latex*/*.glg *latex*/*.glo *latex*/*.gls *latex*/*.idx *latex*/*.ilg *latex*/*.ind *latex*/*.ist *latex*/*.lof *latex*/*.log *latex*/*.lot *latex*/*.lyx *latex*/*.maf *latex*/*.mtc *latex*/*.mtc1 *latex*/*.out *latex*/*.synctex.gz *latex*/*.toc This will prevent Seafile from syncing this files if you’re working in a (sub-) folder that contains the expression “latex”. This way you can still track .log files as long as they are not in a directory that contains the word “latex”. Be aware of the fact that this matches also if one of the parent folders contains the expression “latex”. ...