Ruby on Rail users how to reset email for admin login

@Steve: I’ll email you directly. I think I’ve got this figured out for you.

Andrew , thank you , as I made clear , this is all Greek to me. <br>I just want to log on to my site . If I can’t do it then I have no option but shut it down and begin again. There are things on the site that need cancelled and <br>updated . Any suggestions?

Steve, <br> <br>I’ve deleted your comment as you include credentials that you should keep confidential. I’ll include the rest of your comment below: <br> <br>-------- <br> <br>Andrew : I have had two suggestions for fixing this problem . Problem for me I have zero understanding of the technology and am afraid to screw things up more. <br>Below is the first recommendation from support at Digital Ocean : <br>If you login to the server directly, change to the directory holding <br>the rails project and run: <br> <br> rails console <br> <br>You should not be in the rails console. Here you can create a new <br>admin user by running: <br> <br> u=AdminUser.new(:email => “admin@example.com”, :password => <br>‘password’, :password_confirmation => ‘password’) <br> u.save <br> <br>The second is this : <br>Someone tried without success , this is the statement “there was a deeper problem having to do with the database not communicating with the site.” Below is the Chat with his explanation <br>CHAT: <br> luke: when you ssh in, do you do so as root? <br> me: yes <br> luke: causei got a big error when i did rails console <br> me: oh <br>maybe I did too but didn’t recognize <br> luke: “`connect’: Access denied for user ‘root’@‘localhost’ (using p …” <br>which basically means it cant connect to mysql database <br>and if thats the case then i cant do anything w the db <br> me: it let me in as far as I can see. <br> luke: can you prove the db is running? <br>is the site using it? <br> me: only in as much as the last time I looked the site was working <br> luke: so what we need to do is figure out what the login for mysql is <br>and why he ruby gem is failing when we try to run console <br>its werid that the site is working <br> me: unless it’s the same, I doun’t have it <br> luke: does the site pull from the database on every page? <br>can you send me a url <br> me: the url is smallbusinesscongress.org <br>i don’t know <br> luke: in the app there is a file <br>config/databse.yml <br>this has the configuration details for the db <br>like how to login etc <br>it says ‘username’ xxxxxxxx <br>and pw XXXXXXXXXXXXXXXX <br>so im going to see if i can connect directly to mysql <br>using that combo <br> me: okay <br> luke: ok so <br>here is what i think the problem is <br>we cant connect to mysql <br> me: okay <br> luke: and im not sure why the site is not having the same problem… <br>in order to connect to the mysql db we will need a valid user to be created or the root password reset. <br>so who ever set up the server ( not necc, the site) or is administering it now <br>should help with that <br>so if there is a Host company, you may be able to contact them <br> luke: or maybe they have a control panel that you can access and make the changes <br> luke: Digital ocean is the host i think <br>https://dazzlepod.com/ip/208.68.36.171/#whois <br>give them a call <br> luke: if you tell them your root pw they might help you <br>or you can just ask them if they have a control panbel