Hi, The MySQL thing is due to changes in the most recent Debian. By default they don't allow root password logins, instead they are using auth sockets which means you have to use sudo to connect as root (with no password). There is a basic work around to get the old functionality back (from memory I found it on a DigitalOcean guide).
First, secure MySQL and turn off password complexity and password auth plugin: sudo mysql_secure_installation >From memory, answer N to the password complexity bit (unless you edit rd.conf to let rduser use a password that satisfies the complexity requirements) but Y to the rest of it. Next up, change root back to password auth: sudo mysql mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; and flush the privileges: FLUSH PRIVILEGES; Quit out of MySQL. Check you can login with root and the password you gave (mysql -u root -p). If that works run rdadmin and give it the root credentials and you'll be sorted. As an aside I don't think MyISAM is required anymore but your mileage may vary (I haven't tested InnoDB properly other than a simple "it loads up"). If you manage to load rdairplay but get a password prompt when you quit, it is because the rduser as defined in /etc/rd.conf did not meet the password requirements and could not be created. You'll have to both turn off the complexity plugin and manually create rduser or change rd.conf with something that meets the requirements and manually create rduser again. Hope this helps, Wayne On Sun, Jun 24, 2018 at 2:38 AM, Gary Hodder <vk2...@vk2kcf.com> wrote: > On Sat, 2018-06-23 at 20:59 -0400, Rob Landry wrote: > > On Sat, 23 Jun 2018, Gary Hodder wrote: > > > > > I'm having no luck compiling qt3 on the latest debian. > > > > Here are my notes on compiling QT3 under Debian 9: > > > > Fix QT3 C errors > > > > You need to add the following line to two separate files > > > > #include <stddef.h> > > > > Inside /usr/local/qt3/include/qvaluelist.h on line 52 you'll see this > > > > #include <list> > > #endif > > > > Underneath this add the stddef line and it will look like this > > #include <list> > > #endif > > #include <stddef.h> > > > > Inside /usr/local/qt3/include/qmap.h on line 54 you have this > > #include <map> > > #endif > > > > Add the same stddef line underneath the end if like you did before. > > Compiling QT3 > > Now you can compile QT3 without any issues > > > > > > Rob > > > Sorry Rob you get 2 copies, didn't check the reply to. > > Done that and qt3 compiles ok. > Got through to running rdadmin and it says cannot connect to mysql > server. > In /usr/local/qt3/plugins/sqldriver/libqsqlmysql.so > Is this the correct name and location for the mysql driver that rd > looks for? > > Thanks > Gary. > > _______________________________________________ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
