Re: [RDD] Can't connect to mysql
Only if the RD database is on the same node you should use 127.0.0.X, if it is on another node you should set the IP of that node, also you should install mysqlserver (!!) so not only mysql, further more you should grant access for all workstations to the mysql database in mysql on the server, also I have experienced this error because RDadmin does not create the database automaticaly the first time it is launched for unknown reasons. Adding the correct template manually (e.g. by phpmyadmin) solves this. I have more reasons this error comes up. My NAS is down, I have documented them all, I will let you know if these don't help, so let us know... Lorne Tyndale schreef op 9-7-2015 om 5:48: Check the hostname entry in the mysql section of your /etc/rd.conf If it is pointing to an actual host name, make sure the host name resolves properly (or put it in your /etc/hosts file) If it is pointing to 127.0.0.1 - then try changing it to 127.0.0.2 Also, see if you can access mysql from the command line with a: mysql -u root -p If you can't connect at the command line then your mysql server isn't running for some reason. Lorne Tyndale I'm getting this window when trying to get the rivendell database set up Any suggestions? ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Can't connect to mysql
Check the hostname entry in the mysql section of your /etc/rd.conf If it is pointing to an actual host name, make sure the host name resolves properly (or put it in your /etc/hosts file) If it is pointing to 127.0.0.1 - then try changing it to 127.0.0.2 Also, see if you can access mysql from the command line with a: mysql -u root -p If you can't connect at the command line then your mysql server isn't running for some reason. Lorne Tyndale > I'm getting this window when trying to get the rivendell database set up > Any suggestions? > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Can't connect to mysql
MySQL is installed On 7/8/15, al davis wrote: > On Wednesday 08 July 2015, Ryan Kingham wrote: >> I'm getting this window when trying to get the rivendell >> database set up Any suggestions? > > This may sound really dumb ... Is mysql installed? > > It's required, but the tryphon packages don't install it. > It needs to be installed separately. > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Can't connect to mysql
On Wednesday 08 July 2015, Ryan Kingham wrote: > I'm getting this window when trying to get the rivendell > database set up Any suggestions? This may sound really dumb ... Is mysql installed? It's required, but the tryphon packages don't install it. It needs to be installed separately. ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] Can't connect to mysql
I'm getting this window when trying to get the rivendell database set up Any suggestions? ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Can't connect to mysql
> From: b B > To: rivendell-dev@lists.rivendellaudio.org > Subject: [RDD] Can't connect to mysql > Message-ID: > > Content-Type: text/plain; charset="utf-8" > > I set up the appliance from a recent download. All was working fine. The > machine was shut down by pressing power switch. When it came back on, > Rivendell services wouldnt start. The errors at command line: > > Ripcd > Session management error: None of the authentication protocols specified > are supported > Ripcd: couldnt open mySQL connection. > > Rdadmin brings up "Unable to access Rivendell Database" dialog box. When I > log in through the dialog box with "rduser" and "letmein", I get an error > dialog box "RDAdmin Error" "Unable to connect to mySQL". > > Caed -d produces mysql error similar to ripcd's. > > I have not changed any .conf files. All I did was reboot it without a > proper shutdown. Restarting centos a couple times does not change behavior. > > Help? > > Thanks > Andrew Yes I agree that the mysql database might have been corrupted. (I hate databases!) There ARE some repair tools (mostly front ends to ones built in to MySQL itself) where you can repair it. It might repair itself too. Unfortunately, I am very poor with MySQL so not the best person to get instructions from. I have had success with running the RML command at 2:00 AM every day to back up the database and then have a script that "rsyncs" it over to another computer (through the Internet!). I had to even restore back to one of these backups recently. ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Can't connect to mysql
Using power down button directly without shutting down running programs, and especially mysql databases could have caused some serious damage to the database corrupting it. if you have gparted live boot disk or thumb drive you might be able to run fsck and hopefully fix corrupted nodes and hope against hope your sql db connection is corrected. if mysql access comes back but not the RD database, you might have to restore your RD database from your backup SQL db. hard shutdowns while databases are open and connected are bad news. need to shut down RD first so sql db is shut down in orderly fashion then shut down pc. IMHO.. On 2014-11-12 21:52, b B wrote: I set up the appliance from a recent download. All was working fine. The machine was shut down by pressing power switch. When it came back on, Rivendell services wouldnt start. The errors at command line: Ripcd Session management error: None of the authentication protocols specified are supported Ripcd: couldnt open mySQL connection. Rdadmin brings up "Unable to access Rivendell Database" dialog box. When I log in through the dialog box with "rduser" and "letmein", I get an error dialog box "RDAdmin Error" "Unable to connect to mySQL". Caed -d produces mysql error similar to ripcd's. I have not changed any .conf files. All I did was reboot it without a proper shutdown. Restarting centos a couple times does not change behavior. Help? Thanks Andrew ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] Can't connect to mysql
I set up the appliance from a recent download. All was working fine. The machine was shut down by pressing power switch. When it came back on, Rivendell services wouldnt start. The errors at command line: Ripcd Session management error: None of the authentication protocols specified are supported Ripcd: couldnt open mySQL connection. Rdadmin brings up "Unable to access Rivendell Database" dialog box. When I log in through the dialog box with "rduser" and "letmein", I get an error dialog box "RDAdmin Error" "Unable to connect to mySQL". Caed -d produces mysql error similar to ripcd's. I have not changed any .conf files. All I did was reboot it without a proper shutdown. Restarting centos a couple times does not change behavior. Help? Thanks Andrew ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev