Hi,

Two things, what Riv version are you using and what MySQL version? There are changes to MySQL v 5.7+ that make life awkward for earlier Riv versions than around 2.15.1.

You might also have MyISAM vs InnoDB errors with the SERVICES table.

Either way, you can manually create the rduser and see if that helps:

$ myqsl -u root -p
mysql> create user 'rduser'@'%' identified by 'letmein';
mysql> grant all on Rivendell.* to 'rduser'@'%';
mysql> flush privileges;

RD Admin should log in then assuming you have enabled mysql to listen on all addresses and not just local host (look at bind-address in my.cnf).

Run rdadmin from the command line and send any errors you get back here, they are usually more helpful than the GUI errors.

Regards,

Wayne

On 2016-12-29 19:35, Joe Thompson wrote:
OK, I'm stewing over the cloud idea still. But in the meantime I need
to get my current install fixed. Here's where I'm at, the existing
database is hosed. I believe at the point I've remedied the initial
issue that caused this. So I've created a brand new database so that I can be assured I'm not going to run into straggling issues. I followed
the same exact tutorial I have used before to make sure I got all the
permission etc. set correctly.

I've modified the rd.conf file to use the new database. But when I run rdadmin. It asks for the sql server credentials. I input them, it then turns around and gives me either a access denied error, or it tells me
it can't write to the database. The error is sort of inconsistent.

Short of completely redoing the sql server itself I'm sort of at a
loss at this point.

Any input one can give me would be appreciated.

Thanks

_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to