SME Server:11.0 Addendum

here is a list of known issue while migrating from SME10x to SME11x

server-manager is replaced by smanager

The good old server-manager while still present for beta/RC stage has been replaced by a new manager access to the new manager is at:

https://myip/smanager

We know that a few things are broken in the old manager, and they will remain as won't fix. It was left in the build so that we did not loose any existing function during the migration.

For final release we plan to redirect the old url to the new manager

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 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

Those version of the mariadb and mysql server were available as a contrib offering an extra server on the same machine.

Backup of those db will be found on your restored system in

• /home/e-smith/db/mariadb105
• /home/e-smith/db/mariadb103
• /home/e-smith/db/mariadb102
• /home/e-smith/db/mariadb101

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 see more of the content, either read for specific SQL syntax or install phpmyadmin:

# mariadb-show 
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| roundcube          |
| sys                |
+--------------------+

to list content of the directory

# ll     /home/e-smith/db/mariadb105
total 940440
-rw-r--r-- 1 root root   1379835  6 avr 06:40 mysql.dump
-rw-r--r-- 1 root root      2997  6 avr 06:40 mysql.privileges.dump
-rw-r--r-- 1 root root 961623685  6 avr 06:40 nextcloud.dump

to restore the wanted dump:

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

you might also want to check inside mysql.privileges.dump to restore selective user for this db

# grep -i nextcloud /home/e-smith/db/mariadb105/mysql.privileges.dump
CREATE USER 'nextcloud'@'localhost' IDENTIFIED BY '';
-- 'nextcloud'@'localhost'
GRANT USAGE ON *.* TO 'nextcloud'@'localhost' IDENTIFIED BY PASSWORD '*REDACTED';
GRANT ALL PRIVILEGES ON `nextcloud`.* TO 'nextcloud'@'localhost' WITH GRANT OPTION;
# grep -i nextcloud /home/e-smith/db/mariadb105/mysql.privileges.dump |mariadb mysql

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

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 :

--
-- Table structure for table `columns_priv`
--

DROP TABLE IF EXISTS `columns_priv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `columns_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
/*!40101 SET character_set_client = @saved_cs_client */;

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 one-liner:

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

Horde changed for Roundcube

This has the advantage to be still maintained and lighter. However if you miss the use of the agenda, you might want to give a try to nextcloud.

UPS changes

First slave and master have been replaced to primary and secondary. You might need to change the wording for your remote usernames, Particularly if your SME is a secondary (former slave)

You now have a panel to handle you NUT UPS.

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