0612182441
+31 (0)85 060 9913 | service@powercraft.nl

Upgrading large installations of ownCloud 8.2.7.1 to 9.0.5.2 and further

This week we upgraded some of our larger installations of ownCloud 8.2.7.1 to 9.0.5.2. In the past running the ownCloud update from the command line worked well for us:
sudo -u apache ./occ upgrade --skip-migration-test
Unfortunately some of our installations now have 30GB of MariaDB data files. And running the installer will increase the size of MariaDB to >60GB and this is a little much for comfort. Looking into the database we found a number of tables with oc_oc_ prefix, they seem to be a left over from previous upgrades. So we removed those. Dumping and re-importing using mysqldump the database was still too large. Digging into the tables we found that over 90% of the storage was used in the oc_filecache table.

First we opted to just TRUNCATE TABLE oc_filecache. Then the upgrade went well and MariaDB datafiles went to around 7GB (yes we removed the old data files). Unfortunately all shares (public links and between users) where no longer in the upgraded ownCloud. So we looked a bit more in the source code and found that the oc_share table is inner joined with the oc_filecache table, this explained why the shares no longer showed up. So we decided to:
DELETE FROM oc_filecache WHERE oc_filecache.fileid NOT IN (SELECT oc_share.file_source FROM oc_share);
That query took a little while:

alter-table-oc9

But after the upgrade went smoothly and MariaDB datafiles are still very small compared to what they used to be. Unfortunately a re-download is triggered for users of the ownCloud sync app, but for this instance there where not many users affected, so we could accept that.

We hope the cache table does not need much changing in the future, as it seems quite difficult to upgrade large installations this way. Update: When migrating to Nextcloud 10/11 we found you can also speed up the upgrade process by running:
`TRUNCATE TABLE oc_file_locks` 

PowerMail.nu geüpgrade naar Zimbra 8.7

PowerMail het mail en samenwerkingsplatform van PowerCraft Technology dat gebaseerd is op Zimbra en ownCloud is geüpgrade naar Zimbra 8.7.

Ook bieden we nu de geïntegreerde Zimbra WebDAV Client aan voor onze klanten. Met WebDAV Client kan eenvoudig verbinding worden gemaakt met andere DAV servers zoals ownCloud/Nextcloud, Liferay en Microsoft Internet Information Services.

Een van de mooie nieuwe mogelijkheden van WebDAV Client is de geïntegreerde document voorvertoning.

dodrop-result

Nieuwe serie firewalls ontwikkeld met embedded AMD dual core CPU

Is uw bedrijf goed beschermd tegen hackers? PowerCraft Technology biedt flexible, voordelige en open-source firewall oplossingen toepasbaar voor kleine en middelgrote bedrijven. Met onze maatwerk installatieservice en optionele security scans is uw bedrijf uitgerust met state-of-the art beveiliging.

firewall

Onze firewalls zijn gebaseerd op Debian GNU/Linux of CentOS en ondersteunen bijvoorbeeld de volgende technologieën:
  • Ip-tables/firwewalld
  • firewalld/SELinux
  • NAT
  • Bonding, teaming en trunking
  • VLAN’s
  • Logcheck monitoring
  • DHCP
  • Bind
  • Maatwerk oplossingen
  • Automatische updates
  • Versiebeheer met Trac en Subversion
  • Automatisering met Ansible

Installatie Enterprise WiFi met 30 access points op locatie in Den Haag

Met Enterprise WiFi maakt PowerCraft Technology uw computernetwerk klaar voor flexwerken en bring-your-own-device. Daarnaast biedt PowerCraft Enterprise WiFi ondersteuning voor Mesh Networking waardoor het mogelijk is om grotere afstanden te overbruggen bij evenementen.

Onze optionele monitoring service garandeert maximale betrouwbaarheid.




PowerCraft Enterprise WiFi ondersteunt de volgende technologieën:
  • WPA2
  • WPA Radius
  • Mesh networking
  • 2,4 GHz 802.11 b/g/n
  • 5 GHz 802.11n
  • Remote monitoring