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
