Hi, It sounds like you're not getting the database connection from your workstation machine.
First, ensure that on your workstation machine your mysql line in /etc/rd.conf is pointing to the IP address of the machine which has the MySQL database Second on the machine running the database, check your /etc/mysql/my.cnf file and have a look at the bind line. Often that gets defaulted to 127.0.0.1 - change it to 0.0.0.0 (there's other values you could use, but this is easiest to get things working). Once you've changed the bind line you'll have to restart the MySQL server. Third, make sure the privileges for rduser within MySQL (on the server machine) permit logging in from any machine, and have the correct permissions for Rivendell to work. To do this, on the machine running your MySQL database, open up a command prompt and type: mysql --user=root mysql -p mysql It'll ask for a password. On RRABuntu the default root password for MySQL is rivendell (if I remember that correctly, that is). If you changed the MySQL root password during setup then it is something else - whatever you've set it to. Once you're logged into MySQL, enter the following command: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON Rivendell.* TO 'rduser'@'%' IDENTIFIED BY 'letmein'; FLUSH PRIVILEGES; quit of course change the 'letmein' password to whatever password you've used for your Rivendell database. You're now ready to test this. On your workstation computer, open a shell / command prompt, and use: mysql -u rduser -p -h ip.address.of.mysqlserver (if course replace the IP with the correct IP address of the machine running your MySQL server) It'll ask for a password, enter the password for your rivendell database and it should let you in. If you've managed to log in successfully then you should be okay, You can try show databases; If it lists the Rivendell database then you know you're connected and logged in. You can use the quit command to exit again. Restart your Rivendell daemons on the workstation and see if it gives you the error or if it works. Also, for more details on this, check out the Wiki: http://rivendell.tryphon.org/wiki/Setting_up_a_dedicated_Rivendell_MySQL_and_audio_store_server Have a look at the section on the MySQL server Hope this helps. Matthew, Did you go to RDAdmin and add the new computer as a host? In /etc/rd.conf did you change the [mySQL] hostname to the address of the machine that has the mySQL database? Bill On 3/28/12 8:05 AM, Matthew Chambers wrote: > We have a RRAbuntu box that has been up and running for some time now > and works perfectly fine. I am now trying to add another RRAbuntu box > that will access the same /var/snd directory (works) and mySQL > database (not working) to use for adding/editing/removing carts, > creating and editing logs. I can see the audio files in the second > box's /var/snd directory that I have set to mount to the shared > /var/snd dir on the first box. Now all that is left is the mySQL which > is giving me errors when I try to connect to it and there are no > firewalls running, I was seeing that I need to change the rduser > privileges to allow remote connections but can't because I can't get > logged into mySQL with admin privileges to start with anymore? I > really hope I won't have to blow it away and start over again. _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
