• Release Date: August 2024
• Build Number: 22.0.100
• Type: Major Software Release

Download Links

• JAR File (Wiki Password required)
• Linux
• Windows

Upgrade Information

• Please read this complete Release Notes and instructions before upgrading.
• Please follow the regular upgrade documentation for Windows or Linux
• Upgrading any previous version higher or equal to version 16.0.100
• Cluster: Running different versions on the servers in the cluster is supported but limited to version >= 1622.0.100
• Mandatory configuration changes:manual changes:

Script to check Database in case of Problems on Migration

In case you encounter problems during the update with the database migration you might need to check if entries exists in table Account with too long column data:

SELECT username,CHARACTER_LENGTH(firstname) FROM Account WHERE CHARACTER_LENGTH(firstname) > 127 LIMIT 100;

→ Check the selected Accounts and fix the issue via Web->Admin->Account→Edit and shorten the given entries, in this case "firstname".

Note: Script needs to be adjusted depending on the failing statement. Example is for this step:

ALTER TABLE Account MODIFY COLUMN firstname VARCHAR(127);

Database Update Scripts

• MySQL
• MSSQL
• PGSQL
• H2

The target SchemaVersion is 182

nginx configuration changes

Please update the nginx site configuration pl:

location /rpc {
            ...
            proxy_set_header X-Forwarded-Host $host;
            proxy_set_header X-Forwarded-For $remote_addr;
}

...

location / {
            ...  
            proxy_set_header X-Forwarded-Host $host;
            proxy_set_header X-Forwarded-For $remote_addr;
}

...

location /websocket_client {
            proxy_http_version 1.1;
            proxy_pass http://cluster/websocket_client;
            proxy_set_header Upgrade $http_upgrade;
            proxy_set_header Connection "Upgrade";
			proxy_set_header Upgrade $http_upgrade;
			proxy_set_header Connection "Upgrade";
}

Notes:

• The configuration is incorrect in case you see in logs or browser: Host header invalid - should contain web base URL
• For more Information, please visit our guide: 
  • Reverse Proxy Setup Guide#PassHostnameoftheUpstreamwhenReverseproxying
  • Cluster Setup Guide
• Apache2 configuration does not need to be changed

SAML: Transfer of security Information

Change SAML/Shibboleth attribute prefix to "SAML" (from "HTTP_") in shibboleth2.xml and Apache config.

This change is not backward compatible due to security reasons! These changes have to be done to support SAML logins

For more Information, please visit our guide: Apache configuration

Downgrade Information (optional)

• In case a downgrade to a previous version is necessary:
  
  • For a downgrade, you have to review our downgrade documentation.
  • Simply replace the PowerFolder-Server.jar file with that from the previous version you would like to run.
• Log messages due to the higher schema version of database can be ignored:

  • [DatabaseMigrator]: Database layout version is newer than expected.

New features and improvements

HTTPS Server-Client-Tunnel using Web Sockets

The clients can also use the web sockets same as our iOS app, please use the following web proxy guide to enable the web sockets: WebSockets for iOS and Desktop Client#EnablingWebSocketsforClient

 Add the following config. to the Default.config (server) or PowerFolder.config (client) when the clients should use the web sockets. Precondition is, that the web sockets are configured on the server/load balancer.

code

connections.websocket=true

Support Sender of Invite as Email from Address

For invitation emails: Set the email of the sender of an invitation as email from field instead of the default from address. Requires unauthorized sending via email serve:

mail.from.use_sender=true

Updated Documentation Microsoft SQL Server 2022

PowerFolder server now supports the MS SQL Server 2022, please consult our wiki article when you want to use the database server: Database Setup Guide | DatabaseSetupGuide InstallMySQLServer

Script to check Database in case of problems on Migration

select username,CHARACTER_LENGTH(firstname) FROM Account WHERE CHARACTER_LENGTH(firstname) > 127 LIMIT 100;

Note: Script needs to be adjusted depending on the failing statement. Example is for this step:

ALTER TABLE Account MODIFY COLUMN firstname VARCHAR(127);

Full changelog

• PFS-4368 - Protect federation systems from exceeding requests
• PFS-4376 - DoS protection: Whitelisting of IP ranges 
• PFS-4375 - Support sender of invite as email from address 
• PFS-4374 - Add (...) to every item to show context menu 
• PFS-4360 - Stop video player in web after closing the inline preview window 
• PFS-4373 - Provide CSV support using WOPI and Collabora 
• PFS-4225 - Fix save of the "open files in web" in preferences 
• PFS-4365 - Fix and provide option to declare more than one admin in folder permissions 
• PFS-4380 - Adjust the length of Accounts table for better performance 
• PFS-4386 - Improve database performance by reducing table size of Account 
• PFS-4387 - Prevent Data too long for column 'color1' on Organization branding