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
