Hi Everyone,

I'm trying to set Rivendell up between a server and an on-air computer. The
server hosts the mySQL database. I have been loosely following this guide;
it is out of date:
http://rivendell.tryphon.org/wiki/Setting_up_a_dedicated_Rivendell_MySQL_and_audio_store_server

For the on-air computer, I am using this for a super loose guideline:
http://www.talkunafraid.co.uk/2011/02/installing-rivendell-on-ubuntu/

If I set up a local mySQL database on the on-air computer with rivendell,
everything works as intended. If follow the first guide, RDadmin can
connect to the server after I put in the mysql root password (from the
logs):
130626 23:17:52    37 Connect   Access denied for user 'rduser'@'192.168.1.11'
(using password: YES)

And the logs from the mySQL server:
                   37 Connect   [email protected] as  on Rivendell
130626 23:17:57    38 Connect   [email protected] on Rivendell
                   38 Init DB   Rivendell

And after that, RDAdamin posts the error "Wrong access permission for
accessing mySQL!"

However, this is what "ls -l /etc/rd.conf" shows, radio is the username:

-rw-r--r-- 1 radio rivendell 403 Jun 26 22:59 /etc/rd.conf

However, I can use this command from the on-air computer to access the
Rivendell database:
mysql -u root -p Rivendell -h 192.168.1.78

That accesses just fine, the command:
Select User FROM mysql.user

shows a user "rduser" in the database, which was defined in the rd.conf as
"Loginname=rduser"
however, I can't log into the database with the following command, using
the password from rd.conf
mysql -u rduser -p Rivendell -h 192.168.1.78

This is the first time I've used mySQL before, so am I making some obvious
mistake?

The server is running debian wheezy, and the on air computer is running
Ubuntu 12.04. Both of these servers are running in Virtualbox, with bridged
network connections.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to