On Wed, 7 Dec 2011, Terry LeTourneau wrote:
3. How do I rename the database (then run rdadmin)? I'm a bit confused with that step. Rename the db in mysql or elsewhere?
You'll have to shut down the mysql server, then find the directory where mysql stores its databases (on Debian it's /var/lib/mysql). Each MySQL database will be in a subdirectory there; you'll find one named Rivendell. Rename it to something else (Isengard?) from the command prompt; then restart mysql.
If you now run rdadmin, it should create a new Rivendell database that will be empty. If it asks for a username and password first, give it "root" and your MySQL root password.
Rob
-Terry On Wed, Dec 7, 2011 at 11:40 AM, Rob Landry <[email protected]> wrote: 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
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
