I've done a fresh install of Debian 9 and Rivendell v2.18.0 and done all
of the steps mentioned, but I still get an error when running rdadmin
for the first time. What I get is a SQL-syntax error.
Marius
On 11/20/2017 10:12 PM, Rob Landry wrote:
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
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
