Changes

== Minimal php is 7.2 ==

== Minimal php is 7.2 ==

You need to be sure all your software is compatible with this version of php at very least. However as this now deprecated, please upgrade your software or migrate to something compatible with a supported branch of php8.x

You need to be sure all your software is compatible with this version of php at very least. However as this version now deprecated, please test/upgrade your software or migrate to something compatible with a supported branch of php8.x

== Manual migration of mysql 5.7, mariadb 10.1 10.2 10.3 and 10.5 ==

== Manual migration of mysql 5.7, mariadb 10.1 10.2 10.3 and 10.5 ==

* /home/e-smith/db/mariadb101

* /home/e-smith/db/mariadb101

You will have to manually restore those dump to your new mariadb 11.4 in SME11. Pay attention first to not erase a newer copy of those first.

You will have to manually restore those dump to your new mariadb 11.4 in SME11. Be sure to not erase a newer copy of those first.

To check what is currently in your new DB (if you need to se more of the content, either read for specific SQL syntax or install phpmyadmin:<syntaxhighlight lang="bash">

To check what is currently in your new DB (if you need to see more of the content, either read for specific SQL syntax or install phpmyadmin:<syntaxhighlight lang="bash">

# mariadb-show  

# mariadb-show  

+--------------------+

+--------------------+

-rw-r--r-- 1 root root 961623685  6 avr 06:40 nextcloud.dump

-rw-r--r-- 1 root root 961623685  6 avr 06:40 nextcloud.dump

</syntaxhighlight>to restore the wanted dump<syntaxhighlight lang="bash">

</syntaxhighlight>to restore the wanted dump:<syntaxhighlight lang="bash">

mariadb < /home/e-smith/db/mariadb105/nextcloud.dump

mariadb < /home/e-smith/db/mariadb105/nextcloud.dump

</syntaxhighlight>you might also want to check inside mysql.privileges.dump to restore selective user for this db <syntaxhighlight lang="bash">

</syntaxhighlight>you might also want to check inside mysql.privileges.dump to restore selective user for this db <syntaxhighlight lang="bash">

== ERROR 1071 (42000) at line 33: Specified key was too long; max key length is 1000 bytes ==

== ERROR 1071 (42000) at line 33: Specified key was too long; max key length is 1000 bytes ==

Newer version of mariadb do not allow MyISAM key larger than 1000 bytes. If you are unable to restore a dump with sycn an error, a workaround is to convert this to either Innodb or Aria.

The newer version of mariadb does not allow MyISAM key larger than 1000 bytes. If you are unable to restore a dump without an error, a workaround is to convert this to either Innodb or Aria.

Open the dump and search for the line similar to that for your table causing issue :<syntaxhighlight lang="sql">

Open the dump and search for the line similar to that for your table causing issue :<syntaxhighlight lang="sql">

</syntaxhighlight>and change ENGINE=MyISAM to ENGINE=Aria, or any Engine you want.

</syntaxhighlight>and change ENGINE=MyISAM to ENGINE=Aria, or any Engine you want.

if you want to convert the whole MyIsam tables to Aria (probably you want to only do for some, and this is not the wise way to do it ), here is a oneliner:<syntaxhighlight lang="bash">

if you want to convert the whole MyIsam tables to Aria (probably you want to only do for some, and this is not the wise way to do it ), here is a one-liner:<syntaxhighlight lang="bash">

sed -i -e 's/ENGINE=MyISAM/ENGINE=Aria/' /home/e-smith/db/mysql/CHANGEME.dump

sed -i -e 's/ENGINE=MyISAM/ENGINE=Aria/' /home/e-smith/db/mysql/CHANGEME.dump

</syntaxhighlight>

</syntaxhighlight>

You now have a panel to handle you NUT UPS.

You now have a panel to handle you NUT UPS.

Also behaviour of the services have change completly, see the new documentation [[Uninterruptable Power Supply]]

Also behaviour of the services has changed completly, see the new documentation [[Uninterruptable Power Supply]]

__TOC__

__TOC__