Hi, In addition to setting up MySQL to accept incoming connections from any IP, you'll also have to set up the MySQL account to be able to accept incoming connections from any host and have proper permissions to use the Rivendell database.
Since there is already an entry in the Wiki on how to do this, I'm not going to put the full instructions here. Have a look at: http://rivendell.tryphon.org/wiki/Remote_Client_Access and check/follow the instructions in either "Configure Rivendell DB for remote access with MySQL Administrator" or "Configure Rivendell DB for remote access withOUT MySQL Administrator" Once your rduser account is set up for remote use, and once MySQL is also set up for remote use, you'll be able to log into your main MySQL server with that account from anywhere on your network. Be sure to share your /var/snd using NFS, also on your client workstations you'll need to edit / update your /etc/rd.conf to point the IP of the computer with MySQL. As pointed out, rrabuntu is running an old version of Rivendell, however it is possible to run the newest version of Rivendell on that OS (rrabuntu is essentially 32 bit Ubuntu 10.04 LTS desktop). You can either compile from source (which is what I do on my 10.04 systems) or I think that Tryphon builds repositories for Lucid. Lorne Tyndale > Hi Ryan > You have your network machines all with Static ips? > > The default install of Mysql locks in mysql so only the localhost > machine 127.0.0.1 > can connect to the database. > > If you open the file called /etc/mysql/my.cnf > And look for a line in it saying bind-address = 127.0.0.1 > and change it to bind-address = 0.0.0.0 > > Then you open mysql-admin on the server machine and add the > [email protected] > > If you intend to share the music library between the machines you'll > have to use nfs to share the audio library. > > Unfortunately the RRAbuntu 10.04 is quite an old version of Rivendell > with version 1.71 of Rd and I think you have to use pcm wave file for > your audio library which takes lots of file storage space. > Many thanks > Geoff Barkman > > On Nov 30, 2014 5:03 PM, "Ryan Kingham" <[email protected]> wrote: > > > > I'm trying to set up a network but I'm having trouble with the MySQL > > and terminal of the OS. Suggestions please! > > _______________________________________________ > > 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 _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
