Wayne, I followed all your commands. I ran rdadmin in terminal and it says database version mismatch should be 242 is 245. I think this may be the problem, but don't know how to fix it.
Sent from my iPhone > On Mar 6, 2016, at 7:26 AM, Wayne Merricks <[email protected]> > wrote: > > Hi, > > I come from the Debian based world so apt-get is what I'm used to, the mysql > config file might be somewhere else as well. Apologies for the confusion. > > MySQL (Maria is basically the same) needs to be set for remote access with > users it normally does this but it is possible the broadcast appliance is > different. > > Your error message says this: > > "Host 'onair.router' is not allowed to connect to this MySQL server." > > When you say deleted, do you mean Rivendell database doesn't exist anymore or > did you copy it to the server first? > > If you deleted everything and want to start again: > > $ sudo nano /etc/rd.conf > > Change the mysql hostname to your server address and then try to open rdadmin. > > You will get an error saying can't access MySQL and it will ask you for the > password. It will probably be root and then whatever password you used when > you setup the database. > > If you copied your database then you should have rduser but it all depends on > whether you also copied the mysql users table. Try this exact command from > the on air machine: > > mysql -h whatever_your_server_ip_is -u rduser -pletmein Rivendell > > Only replace the "whatever_your_server_ip_is" rduser is a mysql user that > Rivendell uses this should work if it already exists. > > If you still can't login you will have to create a user manually. On the > server: > > $ mysql -u root -p > > It will ask you for the root password, this is whatever you set it to be when > it installed. > > When it logs in, you need to create an rduser for all hosts (% means any > match, you could also do ip ranges e.g. 10.0.0.%): > > # CREATE USER 'rduser'@'%' IDENTIFIED BY 'letmein'; > > Then you need to give it permission to use the Rivendell database: > > # GRANT ALL ON Rivendell.* TO 'rduser'@'%'; > > Then you need to make MySQL reload its users so that these changes take > effect: > > # FLUSH PRIVILEGES; > > Now on the on air machine this should work: > > mysql -h whatever_your_server_ip_is -u rduser -pletmein Rivendell > > >> On 2016-03-06 09:41, Robert Jeffares wrote: >> centos uses yum >> >> yum install nfs >> >> >>> On 06/03/16 20:43, Hugh Stolmer wrote: >>> apt-get install nfs command >> >> _______________________________________________ >> 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
