On Wed, 7 Dec 2011, Terry LeTourneau wrote:
> When I run RDAdmin from the terminal, this is the error I get: > root@RFM-01420:/home/renewfm# rdadmin > Session management error: None of the authentication protocols specified are > supported What happens if you type: mysql -uroot -pwhatever Rivendell (substituting your MySQL root password for "whatever")? > SQL: alter table VERSION add column LAST_ISCI_XREFERENCE datetime default > "1970-01-01 00:00:00" after LAST_MAINT_DATETIME > SQL Error: Duplicate column name 'LAST_ISCI_XREFERENCE' In your shoes, I would shut down the Rivendell daemons and use mysqldump to make a .sql file of your database, then rename the database and run rdadmin. That should force it to create a new, empty, database. I would then compare that, table by table, to your database, noting all the differences, and verrify that the two databases have identical structures. If they do, there's probably something in one of the tables that identifies the schema. I'd look for that and compare the value in the two databases. They should of course be the same. You might need to make manual alterations to your database if it has a different structure than the empty one (i.e. missing columns, different field types, etc.). After doing so, delete the empty database, rename yours to Rivendell, and try rdadmin again. Because you've got the .sql file you created with myseqldump, it should be easy to get back to where you are now if you mess up. If Fred Gleason should happen to materialize, he probably knows a much better way to address your problem than the one I've outlined above. Rob _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
