It appears the LOGIN_NAME field has to be no wider than 191 to avoid the
error.
This is MariaDB version 10.1.26, supplied with Debian 9.1.
This database version needs to be towed out to sea and scuttled.
Rob
--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.
On Tue, 14 Nov 2017, Rob Landry wrote:
Has anyone tried installing Rivendell under Debian 9?
The MySQL (MariaDB) supplied with Debian 9 appears to be broken. If you set a
root password, you can never connect again. You can recover access, but only
by blowing away the default 'mysql' database and recreating it.
Not wishing to be burned again, I left the root password blank and ran
rdadmin. It creates a Rivendell database wih no tables, then crashes and
displays the following:
SQL: CREATE TABLE IF NOT EXISTS USERS ( LOGIN_NAME CHAR(255) NOT NULL PRIMARY
KEY, FULL_NAME CHAR(255), PHONE_NUMBER CHAR(20), DESCRIPTION CHAR(255),
PASSWORD CHAR(32), WEBAPI_AUTH_TIMEOUT int not null default 3600, ENABLE_WEB
enum('N','Y') default 'N', LOCAL_AUTH enum('N','Y') default 'Y', PAM_SERVICE
char(32) default "rivendell", ADMIN_USERS_PRIV ENUM('N','Y') NOT NULL DEFAULT
'N', ADMIN_CONFIG_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N', CREATE_CARTS_PRIV
ENUM('N','Y') NOT NULL DEFAULT 'N', DELETE_CARTS_PRIV ENUM('N','Y') NOT NULL
DEFAULT 'N', MODIFY_CARTS_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N',
EDIT_AUDIO_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N', ASSIGN_CART_PRIV
ENUM('N','Y') NOT NULL DEFAULT 'N', CREATE_LOG_PRIV ENUM('N','Y') NOT NULL
DEFAULT 'N', DELETE_LOG_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N',
DELETE_REC_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N', PLAYOUT_LOG_PRIV
ENUM('N','Y') NOT NULL DEFAULT 'N', ARRANGE_LOG_PRIV ENUM('N','Y') NOT NULL
DEFAULT 'N', MODIFY_TEMPLATE_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N',
ADDTO_LOG_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N', REMOVEFROM_LOG_PRIV
ENUM('N','Y') NOT NULL DEFAULT 'N', CONFIG_PANELS_PRIV enum('N','Y') not null
default 'N', VOICETRACK_LOG_PRIV enum('N','Y') not null default 'N',
EDIT_CATCHES_PRIV ENUM('N','Y') NOT NULL DEFAULT 'N', ADD_PODCAST_PRIV
enum('N','Y') not null default 'N', EDIT_PODCAST_PRIV enum('N','Y') not null
default 'N', DELETE_PODCAST_PRIV enum('N','Y') not null default 'N', INDEX
FULL_NAME_IDX (FULL_NAME)) SQL Error: Specified key was too long; max key
length is 767 bytes
Has anyone else encountered this problem?
I notice that my.cnf has been split up into a bunch of files in a conf
directory; I really hate it when developers do that.
Rob
--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
