<?xml version="1.0" encoding="UTF-8"?>        <rss version="2.0"
             xmlns:atom="http://www.w3.org/2005/Atom"
             xmlns:dc="http://purl.org/dc/elements/1.1/"
             xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
             xmlns:admin="http://webns.net/mvcb/"
             xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
             xmlns:content="http://purl.org/rss/1.0/modules/content/">
        <channel>
            <title>
									Nextcloud - Solar Trade Alliance  Forum				            </title>
            <link>https://www.tradealliance.nl/community/nextcloud/</link>
            <description>Solar Trade Alliance  Discussion Board</description>
            <language>en-US</language>
            <lastBuildDate>Sat, 02 May 2026 04:15:18 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>Federatie Icoon Status - Topic</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/federatie-icoon-topic/</link>
                        <pubDate>Thu, 26 Jun 2025 18:27:44 +0000</pubDate>
                        <description><![CDATA[Huidige situatie status Nexcloud Federatie - geel op dit moment
Een geel icoon in een Nextcloud-federatie betekent meestal dat de verbinding met de andere Nextcloud-omgeving wel is gemaakt,...]]></description>
                        <content:encoded><![CDATA[<p>Huidige situatie <span style="color: #ff6600"><strong>status</strong></span> Nexcloud Federatie - <span style="color: #ff6600"><strong>geel</strong></span> op dit moment</p>
<p>Een geel icoon in een Nextcloud-federatie betekent meestal dat de verbinding met de andere Nextcloud-omgeving wel is gemaakt, maar dat er iets niet volledig goed of vertrouwd is. Hier zijn de meest voorkomende oorzaken en oplossingen:</p>
<hr />
<h3>&#x1f536; <strong>Betekenis van het gele federatie-icoon</strong></h3>
<p>In Nextcloud betekent het <strong>gele icoon</strong> vaak:</p>
<ul>
<li>
<p>De federatieve share is <strong>niet volledig vertrouwd</strong>.</p>
</li>
<li>
<p>Er is <strong>geen onderlinge vertrouwde verbinding</strong> ingesteld (trusted servers).</p>
</li>
<li>
<p>Er is een <strong>probleem met de serverconnectiviteit</strong>, zoals een mismatch in SSL-certificaten of netwerkproblemen.</p>
</li>
</ul>
<hr />
<h3>&#x2705; <strong>Wat je kunt controleren/oplossen</strong></h3>
<h4>1. <strong>Voeg de server toe als vertrouwde domein (trusted server)</strong></h4>
<p>Ga op <em>beide</em> Nextcloud-servers naar:<br /><code>Instellingen &gt; Delen &gt; Federated Cloud Sharing</code><br />En voeg het domein van de andere server toe onder <strong>"Vertrouwde domeinen"</strong> of "Vertrouwde servers".</p>
<blockquote>
<p>Dit kan het icoon van geel naar groen laten veranderen zodra de verbinding volledig vertrouwd is.</p>
</blockquote>
<hr />
<h4>2. <strong>Controleer of beide servers HTTPS gebruiken</strong></h4>
<p>Zorg ervoor dat beide Nextcloud-instanties een geldig <strong>SSL-certificaat</strong> gebruiken (Let’s Encrypt of ander CA-ondertekend certificaat). Self-signed certificaten veroorzaken vaak gele of rode statussen.</p>
<hr />
<h4>3. <strong>Controleer de verbinding (server discovery)</strong></h4>
<p>In de browser kun je testen of de Nextcloud server goed benaderbaar is via de volgende URL-structuur:</p>
<pre contenteditable="false"><code>https://&lt;nextcloud-server&gt;/ocs/v2.php/cloud/capabilities?format=json
</code></pre>
<p>Als dat geen geldige JSON retourneert, is er waarschijnlijk een netwerk- of configuratiefout.</p>
<hr />
<h4>4. <strong>Controleer Nextcloud logboeken</strong></h4>
<p>Bekijk de logs via:<br /><code>Instellingen &gt; Beheer &gt; Logboeken</code><br />Of op de server zelf:</p>
<pre contenteditable="false"><code class="language-bash">/var/www/html/nextcloud/data/nextcloud.log
</code></pre>
<p>Zoek naar federatie-gerelateerde foutmeldingen.</p>
<hr />
<h4>5. <strong>Gebruik dezelfde Nextcloud-versie (indien mogelijk)</strong></h4>
<p>Soms kunnen versieverschillen tussen de twee omgevingen zorgen voor compatibiliteitswaarschuwingen.</p>
<hr />
<h3>&#x1f4d8; Samengevat:</h3>
<table>
<thead>
<tr>
<th>Icoon</th>
<th>Betekenis</th>
<th>Oplossing</th>
</tr>
</thead>
<tbody>
<tr>
<td>&#x1f7e2; Groen</td>
<td>Volledig vertrouwd</td>
<td>Alles in orde</td>
</tr>
<tr>
<td>&#x1f7e1; Geel</td>
<td>Gedeeltelijk vertrouwd</td>
<td>Voeg toe aan vertrouwde servers, controleer SSL</td>
</tr>
<tr>
<td>&#x1f534; Rood</td>
<td>Niet bereikbaar</td>
<td>Controleer URL/firewall/SSL/versie</td>
</tr>
</tbody>
</table>
<hr />
<p> </p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/federatie-icoon-topic/</guid>
                    </item>
				                    <item>
                        <title>Nextcloud Only Office integratie HOW TO Docker version</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/nextcloud-only-office-integratie-how-to-docker-version/</link>
                        <pubDate>Wed, 21 May 2025 19:12:46 +0000</pubDate>
                        <description><![CDATA[Standaard MicrosoftOffice gerelateerde documenten (zoals word en excel ) te openen binnen je Nextcloud omgeving te openen heeft wat uitdagingen en 1 van de oplossingen is om Only Office inte...]]></description>
                        <content:encoded><![CDATA[2488
<p> </p>
<p>Standaard MicrosoftOffice gerelateerde documenten (zoals word en excel ) te openen binnen je Nextcloud omgeving te openen heeft wat uitdagingen en 1 van de oplossingen is om <a href="https://www.onlyoffice.com/" target="_blank" rel="noopener">Only Office</a> integratie te realiseren zodat je heel gemakkelijk Office documenten kan maken en bewerken vanuit de Nextcloud web omgeving.</p>
<p>Deze HOW TO is voor een Docker omgeving:</p>
<p>Om Only Office te kunnen gebruiken binnen Docker zal je een container moet maken met daarop een documentenserver </p>
<p>Ik heb dat gedaan via de volgende compose file</p>
<pre contenteditable="false"># docker-compose.onlyoffice-arm.yml
version: '2'

services:
  onlyoffice-documentserver:
    image: onlyoffice/documentserver
    container_name: onlyoffice
    restart: always
    ports:
      - 8082:80
    environment:
      - JWT_ENABLED=true
      - JWT_SECRET=&lt;YOUR SECRET&gt;</pre>
<p>* - YOUR SECRET is je wachtwoord naar keuze.</p>
<p>Om OnlyOffice in je Nextcloud omgeving te kunnen gebruiken zal je een url of subdomein op moeten geven <em>bijvoorbeeld: onlyoffice.jedomein.nl</em></p>
<p>Dit doe je in de DNS gegevens van je domein - kan lokaal zijn of bij de partij waar jij je domein hebt draaien.</p>
<p>Binnen Nextcloud ga je naar APPS (dit vindt je in het menu onder je avatar (NB: je moet wel administrator rechten hebben).</p>
<p>Zoek in categorie Office &amp; Tekst naar Only Office - kies voor DOWNLOADEN &amp; INSCHAKELEN.</p>
<p>De volgende stap is om jouw Only Office documentenserver kenbaar te maken binnen Nextcloud Only Office:</p>
<p>1. Ga naar beheerinstellingen in het zelfde menu als apps</p>
<p>2. zoek Only Office</p>
<p>3. vul de gegevens in van jouw Only Office documentenserver zoals onderstaand</p>
2485
<p>4. Druk op Opslaan en als alles goed is gegaan zal je de melding krijgen het gelukt is.</p>
<p>Om te kijken of het inderdaad zo is zoek een opgeslagen bijv Word, Excel en open deze of creëer een nieuw document waarbij de de keuze hebt uit:</p>
2486
<p>Het resultaat moet eruit zien als dit:</p>
<p> </p>
2487
<p>Dat scheelt ook weer een Microsoft Licentie :) maar dat terzijde.</p>
<p>Dit was een snelle HOW TO maar in de basis zou het moeten werken.</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/nextcloud-only-office-integratie-how-to-docker-version/</guid>
                    </item>
				                    <item>
                        <title>Scan je Nextcloud omgeving</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/scan-je-nextcloud-omgeving/</link>
                        <pubDate>Tue, 13 May 2025 10:53:52 +0000</pubDate>
                        <description><![CDATA[Om te kijken of je de beveiliging op orde hebt van je Nexcloud omgeving kan je deze link gebruiken
Ik heb mijn NC even gecontroleerd.

&#x2764;&#xfe0f;]]></description>
                        <content:encoded><![CDATA[<p>Om te kijken of je de beveiliging op orde hebt van je Nexcloud omgeving kan je deze link gebruiken</p>
<p><a href="https://scan.nextcloud.com/">https://scan.nextcloud.com/</a></p>
<p>Ik heb mijn NC even gecontroleerd.</p>
2483
<p>&#x2764;&#xfe0f;</p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/scan-je-nextcloud-omgeving/</guid>
                    </item>
				                    <item>
                        <title>Nextcloud Backup Script v2.0</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/rsync-nextcloud-command-line/</link>
                        <pubDate>Mon, 12 May 2025 14:39:49 +0000</pubDate>
                        <description><![CDATA[Nou dat mijn NC al een tijd draait onder Docker had ik nog steeds geen Backup draaien. Ik heb het via Rsync ingesteld naar mijn NAS.
Eerst heb ik een mount gemaakt naar mijn NAS
Mount Info...]]></description>
                        <content:encoded><![CDATA[<p>Nou dat mijn NC al een tijd draait onder Docker had ik nog steeds geen Backup draaien. Ik heb het via Rsync ingesteld naar mijn NAS.</p>
<p>Eerst heb ik een mount gemaakt naar mijn NAS</p>
<pre contenteditable="false">Mount Info NC &lt;&gt; NAS

mount.cifs //x.x.x.x/NCBackup /mnt/share/nc/ -o user={USER},pass={PASSWORD}</pre>
<p> Vervolgens een Rsync Command Line die verwijst naar de juiste volume in mijn Docker omgeving:</p>
<p>&nbsp;</p>
<pre contenteditable="false">rsync -av /var/lib/docker/volumes/{NAAM_VOLUME}/_data/data /mnt/share/nc</pre>
<p>Ook bij deze back-up heb ik voor nu alleen gekozen voor de data en nog niet de gehele NC omgeving. Met een periodieke database dump van users/rechten etc. kom ik nu al een heel eind.</p>
<p>Om de Backup automatisch te laten draaien op bepaald tijdsinterval heb ik een crontab job aangemaakt.</p>
<pre contenteditable="false">#crontab -e</pre>
<p>gekozen voor optie 1 om de file te maken met nano met de volgende inhoud<br />Cronjob : (elke maandag om 04:00)<br /><br />* * * * 1 rysnc -av /var/lib/docker/volumes/{NAAM_VOLUME}/_data/data /mnt/share/nc</p>
<p>&nbsp;</p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/rsync-nextcloud-command-line/</guid>
                    </item>
				                    <item>
                        <title>Nextcloud Update</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/nextcloud-update/</link>
                        <pubDate>Mon, 31 Jan 2022 14:30:36 +0000</pubDate>
                        <description><![CDATA[Update to Nextcloud 22.2.4 available. (channel: &quot;stable&quot;)]]></description>
                        <content:encoded><![CDATA[<p><span>Update to Nextcloud 22.2.4 available. (channel: "stable")</span></p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/nextcloud-update/</guid>
                    </item>
				                    <item>
                        <title>Nextcloud 21 - MariaDB 10.2 en hoger</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/nextcloud-21-mariadb-10-2-en-hoger/</link>
                        <pubDate>Tue, 14 Dec 2021 14:15:45 +0000</pubDate>
                        <description><![CDATA[Nextcloud 21 ondersteund alleen nog maar MariaDB 10.2 en hoger (10.5) dus we moesten aan de bak ! Want mijn Nextcloud draaide nog op het oude MariaDB 5.5. 
Hoe check ik mijn versie van Mari...]]></description>
                        <content:encoded><![CDATA[<p>Nextcloud 21 ondersteund alleen nog maar MariaDB 10.2 en hoger (10.5) dus we moesten aan de bak ! Want mijn Nextcloud draaide nog op het oude MariaDB 5.5. </p>
<p><strong>Hoe check ik mijn versie van MariaDB?</strong></p>
<p>1. log in op MariaDB via cmd: <em><span style="color: #0000ff">sudo mariadb -u -p</span></em> - waarbij de u = user en p = paswoord</p>
<p>2. Type dan in cmd: <span style="color: #0000ff">SELECT VERSION();</span> </p>
<p>3. Dan zou je het onderstaande moeten zien:</p>
<pre contenteditable="false">+-----------------+
| VERSION()       |
+-----------------+
| 10.5.13-MariaDB |
+-----------------+</pre>
<p>LET OP: <strong><span style="color: #ff0000">* Lees eerst deze how to door voordat je gaat upgraden *</span></strong></p>
<p>(!) : Mijn Nextcloud omgeving draait op <strong><span style="color: #ff0000">CENTOS 7</span></strong> waardoor commando's, meldingen etc kan verschillen van o.a. UBUNTU</p>
<p>(!!): Fix MariaDB 10.6 upgrade (zie einde post)</p>
<p> </p>
<p><strong>HOW TO: UBUNTU VERSION</strong></p>
<h2>Data Backup </h2>
<p>Occasionally, issues can be encountered during upgrades. These issues can even potentially corrupt the database's data files, preventing you from easily reverting to the old installation. Therefore, it is generally best to perform a backup prior to upgrading. If an issue is encountered during the upgrade, you can use the backup to restore your MariaDB Server database to the old version. If the upgrade finishes without issue, then the backup can be deleted.</p>
<p>The instructions below show how to perform a backup using<span> </span><a class="reference internal" href="https://mariadb.com/docs/reference/cs10.5/cli/mariadb-backup/"><span class="std std-ref">MariaDB Backup</span></a>. For more information about backing up and restoring the database, please see the<span> </span><a class="reference internal" href="https://mariadb.com/docs/recovery/"><span class="std std-ref">Recovery Guide</span></a>.</p>
<ol class="arabic">
<li>
<p>Take a full backup:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span></span><span class="gp">$ </span>sudo mariadb-backup --backup <span class="se">\</span>
<span class="go">      --user=mariabackup_user \</span>
<span class="go">      --password=mariabackup_passwd \</span>
<span class="go">      --target-dir=/data/backup/preupgrade_backup</span>
</pre>
</div>
</div>
<p>Confirm successful completion of the backup operation.</p>
</li>
<li>
<p>The backup must be prepared:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span></span><span class="gp">$ </span>sudo mariadb-backup --prepare <span class="se">\</span>
<span class="go">      --target-dir=/data/backup/preupgrade_backup</span>
</pre>
</div>
</div>
<p>Confirm successful completion of the prepare operation.</p>
</li>
<li>
<p>Backups should be tested before they are trusted.</p>
</li>
</ol>
<p> </p>
<div id="upgrade-to-mariadb-community-server-10-5-on-ubuntu-18-04-lts" class="section">
<div id="uninstall-the-old-version" class="section">
<h2>Uninstall the Old Version</h2>
<p>When upgrading to a new major release of MariaDB Community Server, it is necessary to remove the existing installation of MariaDB Community Server, before installing the new version of MariaDB Community Server. Otherwise, the package manager will refuse to install the new version of MariaDB Community Server.</p>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-open" class="mdiv"> </div>
<div id="stop-the-mariadb-server-process" class="section">
<h3>Stop the MariaDB Server Process</h3>
<p>Before the old version can be uninstalled, we first need to stop the current MariaDB Server process.</p>
<ol class="arabic">
<li>
<p>Set the<a class="reference internal" href="https://mariadb.com/docs/reference/mdb/system-variables/innodb_fast_shutdown/"><span class="std std-ref">innodb_fast_shutdown</span></a>system variable to<code class="docutils literal notranslate"><span class="pre">1</span></code>:</p>
<div class="highlight-sql notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="k">SET</span> <span class="k">GLOBAL</span> <span class="n">innodb_fast_shutdown</span> <span class="o">=</span> <span class="mi">1</span><span class="p">;</span>
</pre>
</div>
</div>
</li>
<li>
<p>Use<a class="reference internal" href="https://mariadb.com/docs/reference/mdb/sql-statements/XA_RECOVER/"><span class="std std-ref">XA RECOVER</span></a>to confirm that there are no external XA transactions in a prepared state:</p>
<div class="highlight-sql notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="n">XA</span> <span class="n">RECOVER</span><span class="p">;</span>
</pre>
</div>
</div>
<p>Commit or rollback any open XA transactions before stopping the node for upgrade.</p>
</li>
<li>
<p>Stop the server process using the<code class="docutils literal notranslate"><span class="pre">systemctl</span></code>command:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo systemctl stop mariadb
</pre>
</div>
</div>
</li>
</ol>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-close" class="mdiv"> </div>
</div>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-open" class="mdiv"> </div>
<div id="uninstall-via-apt-debian-ubuntu" class="section">
<h3>Uninstall via APT (Debian/Ubuntu)</h3>
<ol class="arabic">
<li>
<p>Uninstall all of the MariaDB Community Server packages. Note that a wildcard character is used to ensure that all MariaDB Community Server packages are uninstalled.</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo apt-get remove <span class="s2">"mariadb-*"</span>
</pre>
</div>
</div>
<p>Be sure to check that this wildcard does not unintentionally refer to any of your custom applications.</p>
</li>
<li>
<p>Uninstall the Galera package as well <strong><span style="color: #ff0000">(1)</span></strong>.</p>
<p>The name of the package depends on the specific version of MariaDB Community Server.</p>
<p>When upgrading from MariaDB Community Server 10.4, the package is called<code class="docutils literal notranslate"><span class="pre">galera-4</span></code>:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo apt remove galera-4
</pre>
</div>
</div>
<p>When upgrading from MariaDB Community Server 10.3 or earlier, the package is called<code class="docutils literal notranslate"><span class="pre">galera-3</span></code>:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo apt remove galera-3
</pre>
</div>
</div>
</li>
<li>
<p>Before proceeding, verify that all MariaDB Community Server packages are uninstalled. The following command should not return any results:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>apt list --installed <span class="p">|</span> grep -i -E <span class="s2">"mariadb|galera"</span>
</pre>
</div>
</div>
</li>
</ol>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-close" class="mdiv"> </div>
</div>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-close" class="mdiv"><strong><span style="color: #ff0000">(1) - Galera package heb ik niet geinstalleerd staan dus ik kon naar stap 3.</span></strong></div>
</div>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-install-the-new-version-open" class="mdiv"> </div>
<div id="install-the-new-version" class="section">
<h2>Install the New Version</h2>
<p>MariaDB Corporation provides a APT package repository for Ubuntu 18.04 LTS.</p>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-install-the-new-version-install-via-apt-(debian/ubuntu)-open" class="mdiv"> </div>
<div id="install-via-apt-debian-ubuntu" class="section">
<h3>Install via APT (Debian/Ubuntu)</h3>
<ol class="arabic">
<li>
<p>Configure the APT package repository.</p>
<p>To configure APT package repositories:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo apt install wget

<span class="gp">$ </span>wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup

<span class="gp">$ </span><span class="nb">echo</span> <span class="s2">"fd3f41eefff54ce144c932100f9e0f9b1d181e0edd86a6f6b8f2a0212100c32c mariadb_repo_setup"</span> <span class="se">\</span>
<span class="go">    | sha256sum -c -</span>

<span class="gp">$ </span>chmod +x mariadb_repo_setup

<span class="gp">$ </span>sudo ./mariadb_repo_setup <span class="se">\</span>
<span class="go">   --mariadb-server-version="mariadb-10.5"</span>

<span class="gp">$ </span>sudo apt update
</pre>
</div>
</div>
</li>
<li>
<p>Install MariaDB Community Server and package dependencies:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo apt install mariadb-server mariadb-backup
</pre>
</div>
</div>
<p>Installation of additional packages may be required for some plugins.</p>
</li>
<li>
<p>Configure MariaDB. - <strong><span style="color: #ff0000">hier heb ik eigenlijk niks meegedaan </span></strong></p>
<p>Installation only loads MariaDB Community Server to the system. MariaDB Community Server requires configuration before the database server is ready for use.</p>
</li>
</ol>
</div>
</div>
<p> </p>
<div id="starting-the-server" class="section">
<h2>Starting the Server</h2>
<p>MariaDB Community Server includes configuration to start, stop, restart, enable/disable on boot, and check the status of the Server using the operating system default process management system.</p>
<p>Ubuntu 18.04 LTS uses systemd. You can manage the Server process using the<code class="docutils literal notranslate"><span class="pre">systemctl</span></code>command:</p>
<table class="colwidths-given docutils align-default"><colgroup> <col /> <col /></colgroup>
<tbody>
<tr class="row-odd">
<td>
<p><strong>Operation</strong></p>
</td>
<td>
<p><strong>Command</strong></p>
</td>
</tr>
<tr class="row-even">
<td>
<p>Start</p>
</td>
<td>
<p><code class="docutils literal notranslate"><span class="pre">sudo </span><span class="pre">systemctl </span><span class="pre">start </span><span class="pre">mariadb</span></code></p>
</td>
</tr>
<tr class="row-odd">
<td>
<p>Stop</p>
</td>
<td>
<p><code class="docutils literal notranslate"><span class="pre">sudo </span><span class="pre">systemctl </span><span class="pre">stop </span><span class="pre">mariadb</span></code></p>
</td>
</tr>
<tr class="row-even">
<td>
<p>Restart</p>
</td>
<td>
<p><code class="docutils literal notranslate"><span class="pre">sudo </span><span class="pre">systemctl </span><span class="pre">restart </span><span class="pre">mariadb</span></code></p>
</td>
</tr>
<tr class="row-odd">
<td>
<p>Enable during startup <span style="color: #ff0000"><strong>(2)</strong></span></p>
</td>
<td>
<p><code class="docutils literal notranslate"><span class="pre">sudo </span><span class="pre">systemctl </span><span class="pre">enable </span><span class="pre">mariadb</span></code></p>
</td>
</tr>
<tr class="row-even">
<td>
<p>Disable during startup</p>
</td>
<td>
<p><code class="docutils literal notranslate"><span class="pre">sudo </span><span class="pre">systemctl </span><span class="pre">disable </span><span class="pre">mariadb</span></code></p>
</td>
</tr>
<tr class="row-odd">
<td>
<p>Status</p>
</td>
<td>
<p><code class="docutils literal notranslate"><span class="pre">sudo </span><span class="pre">systemctl </span><span class="pre">status </span><span class="pre">mariadb</span></code></p>
</td>
</tr>
</tbody>
</table>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-install-the-new-version-install-via-apt-(debian/ubuntu)-starting-the-server-close" class="mdiv"> </div>
</div>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-install-the-new-version-install-via-apt-(debian/ubuntu)-starting-the-server-upgrading-the-data-directory-open" class="mdiv"><span style="color: #ff0000"><strong>(2) - vergeet niet MariaDB automatisch te laten starten als de server herstart </strong></span></div>
<div id="upgrading-the-data-directory" class="section">
<h2>Upgrading the Data Directory</h2>
<p>MariaDB Community Server 10.5 ships with the<a class="reference internal" href="https://mariadb.com/docs/reference/cs10.5/cli/mariadb-upgrade/"><span class="std std-ref">mariadb-upgrade</span></a>utility which can be used to identify and correct compatibility issues in the new version. After you upgrade your Server and start the server process, run this utility to upgrade the data directory:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo mariadb-upgrade
</pre>
</div>
</div>
</div>
</div>
<div class="mdiv"> </div>
<div>Dit gaf mijn de volgende foutmelding: </div>
<div> </div>
<div><span style="color: #ff0000"><em>Version check failed. Got the following error when calling the 'mysql' command line client</em></span><br /><span style="color: #ff0000"><em>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)</em></span><br /><span style="color: #ff0000"><em>FATAL ERROR: Upgrade failed</em></span></div>
<div class="mdiv"> </div>
<div>Dit heb ik op gelost door het volgene cmd:</div>
<div> </div>
<div>sudo mariadb-upgrade -u   -p</div>
<div id="upgrade-to-mariadb-community-server-10-5-on-ubuntu-18-04-lts" class="section">
<div id="testing" class="section">
<h2>Testing</h2>
<p>When MariaDB Community Server is up and running on your system, you should test that it is working and there weren't any issues during startup.</p>
<ol class="arabic">
<li>
<p>Connect to the server using<a class="reference internal" href="https://mariadb.com/docs/reference/cs10.5/cli/mariadb/"><span class="std std-ref">MariaDB Client</span></a>using the<code class="docutils literal notranslate"><span class="pre">root@localhost</span></code>user account:</p>
<div class="highlight-console notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="gp">$ </span>sudo mariadb
<span class="go">Welcome to the MariaDB monitor.  Commands end with ; or \g.</span>
<span class="go">Your MariaDB connection id is 9</span>
<span class="go">Server version: 10.5.13-MariaDB MariaDB Server</span>

<span class="go">Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.</span>

<span class="go">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span>

<span class="go">MariaDB &gt;</span>
</pre>
</div>
</div>
<p>The version of the server can be verified by checking the client's initial output.</p>
</li>
<li>
<p>You can also verify the server version by checking the value of the<a class="reference internal" href="https://mariadb.com/docs/reference/mdb/system-variables/version/"><span class="std std-ref">version</span></a>system variable with the<a class="reference internal" href="https://mariadb.com/docs/reference/mdb/sql-statements/SHOW_STATUS/"><span class="std std-ref">SHOW GLOBAL STATUS</span></a>statement:</p>
<div class="highlight-sql notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="k">SHOW</span> <span class="k">GLOBAL</span> <span class="n">VARIABLES</span> <span class="k">LIKE</span> <span class="s1">'version'</span><span class="p">;</span>
</pre>
</div>
</div>
<div class="highlight-cmp notranslate">
<div class="highlight">
<pre contenteditable="false">+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| version       | 10.5.13-MariaDB |
+---------------+-----------------+
</pre>
</div>
</div>
</li>
<li>
<p>You can also verify the server version by calling the<a class="reference internal" href="https://mariadb.com/docs/reference/mdb/functions/VERSION/"><span class="std std-ref">VERSION()</span></a>function:</p>
<div class="highlight-sql notranslate">
<div class="highlight">
<pre contenteditable="false"><span class="k">SELECT</span> <span class="k">VERSION</span><span class="p">();</span>
</pre>
</div>
</div>
<div class="highlight-cmp notranslate">
<div class="highlight">
<pre contenteditable="false">+-----------------+
| VERSION()       |
+-----------------+
| 10.5.13-MariaDB |
+-----------------+
</pre>
</div>
</div>
</li>
</ol>
<div id="ent-upgrade-to-mariadb-community-server-105-on-ubuntu-1804-lts-data-backup-uninstall-the-old-version-stop-the-mariadb-server-process-uninstall-via-apt-(debian/ubuntu)-install-the-new-version-install-via-apt-(debian/ubuntu)-starting-the-server-upgrading-the-data-directory-testing-close" class="mdiv"> </div>
</div>
</div>
<div class="mdiv">
<p>(!!) deze HOW TO upgrade MariaDB naar de laatste versie <strong><span style="color: #ff0000">10.6</span></strong> ! en dat wordt nog niet ondersteund door Nextcloud. </p>
<p>Het starten van MariaDB via cmd: <span style="color: #0000ff"><em>sudo systemctl start mariadb</em></span> gaf de volgende error:</p>
<p> (!) </p>
<p>Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.</p>
<p>Mijn aanpassing:</p>
<p> (!) </p>
<p>stop MariaDB via cmd: <span style="color: #0000ff"><em>sudo systemctl stop mariadb</em></span></p>
<p>pad: /etc/my.cnf.d/server.cnf </p>
<p>aanpassing in de config file (<span style="color: #ff0000">zie rood</span>)</p>
<p># This group is only read by MariaDB-10.6 servers.<br /># If you use the same .cnf file for MariaDB of different versions,<br /># use this group for options that older servers don't understand<br /><br /><span style="color: #ff0000"><strong>innodb_read_only_compressed=0</strong></span></p>
<p>na de aanpassing moet je MariaDB opnieuw starten door cmd: <span style="color: #0000ff"><em>sudo systemctl start mariadb</em></span></p>
</div>
<div> </div>
<div id="comments" class="section">Ik hoop dat deze post je helpt bij het upgraden van MariaDB voor je nextcloud omgeving. !</div>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/nextcloud-21-mariadb-10-2-en-hoger/</guid>
                    </item>
				                    <item>
                        <title>Migratie Nextcloud to other Server</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/migratie-nextcloud-to-other-server/</link>
                        <pubDate>Wed, 13 Oct 2021 14:02:51 +0000</pubDate>
                        <description><![CDATA[Hier een beknopte HOW TO
 

Install nc on the new server.
Set the old and new server to maintenance mode.
Dump the database on the old.
Copy the complete data directory to the new serv...]]></description>
                        <content:encoded><![CDATA[<p>Hier een beknopte HOW TO</p>
<p> </p>
<ul>
<li>Install nc on the new server.</li>
<li>Set the old and new server to maintenance mode.</li>
<li>Dump the database on the old.</li>
<li>Copy the complete data directory to the new server.</li>
<li>Restore the database on the new server.</li>
<li>Edit the config.php on the new server. I think you have to copy passwordsalt and secret from the old to the new server.</li>
<li>Change the DNS record to point at your new server.</li>
<li>Turn off maintenance mode on the new server.</li>
</ul>
<p>LET OP: dit is alleen NEXTCLOUD en geen:</p>
<ul>
<li>Let's Encrypt</li>
<li>Rsync</li>
</ul>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/migratie-nextcloud-to-other-server/</guid>
                    </item>
				                    <item>
                        <title>Cloudcity - The Upgrade in The Clouds</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/cloudcity-the-upgrade-in-the-clouds/</link>
                        <pubDate>Wed, 18 Aug 2021 13:41:42 +0000</pubDate>
                        <description><![CDATA[Ik moet binnenkort nodig onderhoud gaan plegen aan mij Nextcloud server :) Lees migreren naar een nieuwe server maar dan wel gelijk op basis van Ubuntu ipv de huidige oude CentOS 7]]></description>
                        <content:encoded><![CDATA[<p>Ik moet binnenkort nodig onderhoud gaan plegen aan mij Nextcloud server :) Lees migreren naar een nieuwe server maar dan wel gelijk op basis van Ubuntu ipv de huidige oude CentOS 7</p>
1877
<p> </p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Lantern</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/cloudcity-the-upgrade-in-the-clouds/</guid>
                    </item>
				                    <item>
                        <title>High Availability</title>
                        <link>https://www.tradealliance.nl/community/nextcloud/high-availability/</link>
                        <pubDate>Sun, 23 May 2021 05:43:15 +0000</pubDate>
                        <description><![CDATA[interessant artikel over de implementatie van Nextcloud Swarm. Met een ‘simpele’ installatie…]]></description>
                        <content:encoded><![CDATA[<p><a href="https://ownyourbits.com/2019/08/21/make-your-nextcloudpi-highly-available/" target="true">https://ownyourbits.com/2019/08/21/make-your-nextcloudpi-highly-available/</a></p>
<p>interessant artikel over de implementatie van Nextcloud Swarm. Met een ‘simpele’ installatie…</p>]]></content:encoded>
						                            <category domain="https://www.tradealliance.nl/community/nextcloud/">Nextcloud</category>                        <dc:creator>Abib</dc:creator>
                        <guid isPermaLink="true">https://www.tradealliance.nl/community/nextcloud/high-availability/</guid>
                    </item>
							        </channel>
        </rss>
		