For the benefit of anyone attempting to get Rivendell running under Debian 9, the MySQL problem is not a bug, but a new feature.
By default, the root user is created in the mysql user table with plugin = 'unix_socket'.
That plugin does not allow any Unix user but root to log in to MySQL as 'root', whatever the password field is set to.
So, before you run rdadmin, you have to log in as root and change the root user to plugin = NULL.
[Pardon my caps, but WHAT IDIOT CAME UP WITH THIS IDEA? I want to personally kick his ass all the way to Alabama.]
Now, there's a second problem. which is that creating any table with a primary key longer than 197 produces an error.
In /etc/mysql/mariadb.conf.d/50-server.cnf: Change: character-set-server = utf8mb4 collation-server = utf8mb4_general_ci ...to:character-set-server = latin1 collation-server = latin1_swedish_ci
[Whose was the bright idea to replace real MySQL with this imitation frozen substitute for artificial morning breakfast beverage wih pulp-like particles added, just like the concentrate that tastes almost like fresh?]
[Yeah, I know, I should be running CentOS. And I would, if this machine would let me install it.]
Rob, grumble grumble grumble -- Я там, где ребята толковые, Я там, где плакаты "Вперёд", Где песни рабочие новые Страна трудовая поёт.
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
