ZERO database training
I have almost ZERO database training. I took an Oracle class in 2003 as part of my degree, so everything I ‘know’ has come from building my servers on open source software, and I document literally every command I ever run. I checked everything: I went over all the commands, checked every permission I could think of. No luck. Everything worked fine until I tried to restore. I even went so far as to go to the current instance and take a new backup of the data and try with that.
Out of sheer desperation, I thought maybe it was because the second instance wasn’t 100% identical: I had used NGINX instead of Apache, the original instance didn’t have phpMyAdmin, we use a proxy server at HQ — SOMETHING. So I started over.
I built the second one as an exact duplicate — same programs, same passwords, everything I could find. I get the instance up, I install a clean Matomo, and everything works again. Then I restore the database: F*%S!#S$ … SAME issue! I was pulling my hair out. I talked to my manager, our software architect the real developers. I had 4 people looking at this dang thing, trying to figure it out. NO ONE had a clue. It should have worked but I was still getting the same error. It pointed to a password issue, but the passwords all matched what I had documented AND I could access it via MySQL on the server directly.
More Info: comptia a+ certified jobs
Out of sheer desperation, I thought maybe it was because the second instance wasn’t 100% identical: I had used NGINX instead of Apache, the original instance didn’t have phpMyAdmin, we use a proxy server at HQ — SOMETHING. So I started over.
I built the second one as an exact duplicate — same programs, same passwords, everything I could find. I get the instance up, I install a clean Matomo, and everything works again. Then I restore the database: F*%S!#S$ … SAME issue! I was pulling my hair out. I talked to my manager, our software architect the real developers. I had 4 people looking at this dang thing, trying to figure it out. NO ONE had a clue. It should have worked but I was still getting the same error. It pointed to a password issue, but the passwords all matched what I had documented AND I could access it via MySQL on the server directly.
More Info: comptia a+ certified jobs
Comments
Post a Comment