Thanks, it is now working 8-)
---
/Matthew A. Chambers, CBT/
Assist. Broadcast Engineer
*KWIX - KRES - KIRK - KTCM*
300 West Reed Street
Moberly, MO 65270
660-263-1500
FAX: 660-269-8811
Cell: 660-676-3219
www.CentralMoInfo.com <http://www.centralmoinfo.com>
/Super Station KRES 104.7 FM/
/Information Radio KWIX 1230 AM/
/The Captain KIRK 99.9 FM/
/Glory KTCM 97.3 FM /
/This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager. This message contains confidential information and is
intended only for the individual named. If you are not the named
addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. If you are
not the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
information is strictly prohibited./
On 3/28/2012 1:40 PM, [email protected] wrote:
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
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
