Rob Landry <41001140@...> writes: > > > Can you get into the database from a terminal window using > mysql -urduser -pletmein Rivendell? > > (or whatever username and password you have) > > Rob > > On Tue, 6 Aug 2013, Eric Gauvin wrote: > > > Fred Gleason <fredg <at> ...> writes: > > > >> > >> On Jul 31, 2013, at 15:56 06, Eric Gauvin wrote: > >> > >>> I have successfully added a new CentOS workstation to the network, but ever > >>> since I have, I've been unable to make changes to the RDAirPlay section > > under > >>> Manage Hosts in RDAdmin. This has happened across the network and also > > erased > >>> all the previous RDAirplay settings. So, say I go to change the forced > > segue > >>> length and click Ok, when I go back in, it will have reset itself back to 0. > >> > >> I'd suspect schema skew. What RD versions are you running on each > > workstation? > >> > >> Cheers! > >> > >> |---------------------------------------------------------------------- ---| > >> | Frederick F. Gleason, Jr. | Chief Developer | > >> | | Paravel Systems | > >> |---------------------------------------------------------------------- ---| > >> | A room without books is like a body without a soul. | > >> | -- Cicero | > >> |---------------------------------------------------------------------- ---| > >> > > > > Fred, > > > > I am still unable to make changes. I get the following in terminal when I > > run rdadmin from the command line and select Manage Hosts and then RDAirPlay. > > > > Database connection failed: select ID from RDAIRPLAY where > > STATION="renewparavel" && INSTANCE=0 > > Database connection restored. > > Database connection failed: SELECT CARD0 FROM RDAIRPLAY WHERE ID=0 > > Database connection restored. > > Database connection failed: SELECT START_RML0 FROM RDAIRPLAY WHERE ID=0 > > Database connection restored. > > Database connection failed: UPDATE RDAIRPLAY SET START_RML0="" WHERE > > STATION="renewparavel" && INSTANCE=0 > > > > This now happens on all the different Rivendell workstations. Any thoughts > > with where to go from here? Please let me know when you get a chance. > > > > Thanks, > > > > Eric > > > > > > _______________________________________________ > > Rivendell-dev mailing list > > Rivendell-dev@... > > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > >
Rob, I can access the MYSQL database from a terminal window on our dedicated MYSQL machine and also on the new CentOS Paravel Systems install. On all the other Ubuntu machines I get the following message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I think this may have been the case even before I started experiencing problems though. The database seems to be functioning correctly (RDLibrary seems to be syncing correctly across all machines, etc) apart from this one holdup in RDAdmin. Do you think this still might be the problem? Eric _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
