[RDD] Remote into RRAbuntu mySQL
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. -- /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./ ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Remote into RRAbuntu mySQL
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. -- /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./ ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Remote into RRAbuntu mySQL
The host is added in RDAdmin on the main machine and the IP address of the main machine is also in the second machine's rd.conf file for the location of the mySQL server. when i try to sudo /etc/init.d/rivendell start I get No database available, check that MySQL is running --- /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 10:25 AM, Bill Putney wrote: 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. -- /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./ ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Remote into RRAbuntu mySQL
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, ltynd...@tyndaleweb.com 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 Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
