Early this morning I've managed to set the database OK for RDADMIN recognition. A few minutes ago I've messed it up upon restoring the DB using a backup from 2015. It ended up saying "Unable to restore database". RDadmin is runnng in the task manager but not popping up. Using terminal I get: invalid SQL or failed DB connection[Table 'Rivendell.VERSION' doesn't exist QMYSQL3: Unable to execute query]: select DB from VERSION How can I reverse this? I have the backup from the fresh instalation...
On Mon, Oct 22, 2018 at 2:15 PM Rob Landry <[email protected]> wrote: > > If you can open a terminal window and do "mysql -uroot -p{whatever}", then > MySQL is properly installed. > > However, you also need MySQL to talk to QT3; if you compiled QT3 yourself, > you needed to select the -qt-sql-mysql option. > > I have never tried to install Rivendell under Ubuntu, but if it's like > Debian 9, MySQL comes installed with a plugin "unix_socket" that only > allows root to log in to MySQL as root. > > You need to log in to mysql as root, select the 'mysql' database, and > type: > > SELECT plugin FROM user WHERE user = 'root'; > > If it shows 'unix_socket', change it to NULL. > > > Rob > > -- > Я там, где ребята толковые, > Я там, где плакаты "Вперёд", > Где песни рабочие новые > Страна трудовая поёт. > > On Sun, 21 Oct 2018, Luigino Bracci wrote: > > > Maybe MySQL is not correctly installed? Try removing mysql-server and > > mysql-server-5.7, then run sudo apt-get clean and sudo apt-get autoremove > > and try to install both packages again. > > > > El dom., 21 de oct. de 2018 a la(s) 19:34, Pedro Picoto > > ([email protected]) escribió: > > Hmmm.... Upon > > > > # Stop MySQL > > sudo service mysql stop > > "Failed to stop mysql.service: Unit mysql.service not loaded." > > > > > > On Sun, Oct 21, 2018 at 10:37 PM Luigino Bracci <[email protected]> > > wrote: > > Maybe you need to reset the password of the MySQL user. > > > > Remember that, in MySQL 5,7 (the one that comes with Ubuntu > > 18.04), you must be sudo to access the MySQL root user ("sudo > > mysql -u root -p"). > > > > If you don't remember the MySQL's root password, follow this > > guide: > > > > > https://coderwall.com/p/j9btlg/reset-the-mysql-5-7-root-password-in-ubuntu- > > 16-04-lts > > > > Regards > > > > > > > > El dom., 21 de oct. de 2018 a la(s) 11:24, Pedro Picoto > > ([email protected]) escribió: > > Thank you all! > > "Unable to connect to mySQL" > > Something messed up on the setup process, for sure. But > > what?... > > > > On Sun, Oct 21, 2018 at 3:33 PM Fred Gleason > > <[email protected]> wrote: > > On Oct 21, 2018, at 07:54, Pedro Picoto > > <[email protected]> wrote: > > Following the offer of the fellow > > member Luigino Bracci, I've > > downloaded and installed the > > packages but now I'm stucked > > 'cause I don't remember the > > user/pw for the first ride on > > the rdadmin. > > It's been a very long time since I played with > > Rivendell, hence this blank spot (perhaps lots > > of others too) in my brain… > > > > > > ‘admin’ with no p/w. > > > > Cheers! > > > > > > |----------------------------------------------------------------------| > > | Frederick F. Gleason, Jr. | Chief > > Developer | > > | | Paravel > > Systems | > > |----------------------------------------------------------------------| > > | A room without books is like a body > > without a soul. | > > | -- Cicero > > | > > |----------------------------------------------------------------------| > > _______________________________________________ > > 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 > > > > > >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
