Need help fixing my Cloudron install. Probable database issue.
-
So first just a quick background. I had been trying to connect a database from a site hosted on a remote VPS but after several attempts and failures, I couldnt successfully create a connection to Metabase in Cloudron.
So finally I just decided to try to install MySQL workbench so I could upload my remote database locally on the machine I have my Cloudron installed on.
I was following ChatGPT to walk me through the setup but I think in the process it screwed up my main database used by Cloudron. What is the best way to fix this issue? Can I just fix this in a few steps or am I going to have to completely reinstall the whole system from a backup?
Is this the type of thing I can provide the support team ssh access somehow so they can troubleshoot and fix it? I don’t have a huge amount of time to spend trying to figure this out. Especially if somebody has had a similar issue and knows how to solve it quickly.
Interested in any feedback I can get. Thank you all very much!
-
I would cut my losses and restore from a backup, especially if time to fix is constrained.
-
Can you check
systemctl status mysqlon Cloudron? If that is running, thenmysql -uroot -ppassword box -e "show tables"(sic) . Does that work?@joseph Thanks for your response. So I ran the systemctl status mysql command and everything is operational and running.Then I ran mysql -uroot -ppassword box -e "show tables" and I get: mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) -
So you are trying to connect to an external mysql database from a Metabase install on Cloudron or are you trying to connect to a mysql database instance of a Cloudron app?
@nebulon I was trying to connect to an ecommerce site's database that is hosted on a remote server. My Cloudron is hosted on a computer in my office which I have Metabase running on. I couldnt get it to connect so just to experiment I downloaded the sql database from the remote server. Then I installed mysql workbench onto the computer in my office that is running cloudron. Uploaded the database and got it working in mysql workbench but in the process I broke my Cloudron install.
Now when I go to my Cloudron domain I only get the white screen with the red banner at the top saying "Cloudron is offline. Reconnecting..."
-
Since this is all local, sounds like your local MySQL took over the ports of the Cloudron MySQl, and maybe even set some System prefs. If you can edit the standalone MySQL prefs, turn off "start on startup" or similarly worded options. You don't want it starting up first. Then, using what process manager you are familiar with, shut off anything related to MySQL or other DBs, and even Cloudron (as these are all going to be Docker containers anyway). Next, restart the computer. Hopefully you got all the correct prefs, and the only thing with a DB that will start will be Cloudron (you may need to start Docker first, if that isn't set to auto-turn on on startup).
-
So first just a quick background. I had been trying to connect a database from a site hosted on a remote VPS but after several attempts and failures, I couldnt successfully create a connection to Metabase in Cloudron.
So finally I just decided to try to install MySQL workbench so I could upload my remote database locally on the machine I have my Cloudron installed on.
I was following ChatGPT to walk me through the setup but I think in the process it screwed up my main database used by Cloudron. What is the best way to fix this issue? Can I just fix this in a few steps or am I going to have to completely reinstall the whole system from a backup?
Is this the type of thing I can provide the support team ssh access somehow so they can troubleshoot and fix it? I don’t have a huge amount of time to spend trying to figure this out. Especially if somebody has had a similar issue and knows how to solve it quickly.
Interested in any feedback I can get. Thank you all very much!
Just started reading your topic and as I read I add comments
@jtippetts said in Need help fixing my Cloudron install. Probable database issue.:
I was following ChatGPT
Oh, no
@jtippetts said in Need help fixing my Cloudron install. Probable database issue.:
Then I installed mysql workbench onto the computer in my office that is running cloudron
Nothing should be installed alongside Cloudron.
Cloudron can be viewed as a Server Distribution like Ubuntu itself. You would not install CentOS next to Ubuntu.
This should only be done if you know 100 % what you are doing. And since you wrote you followed ChatGPT, I assume you lack that knowledge
Let's take this as a learning.
Before following ChatGPT, who only has a vague Idea of Cloudron, come here, the Forum
You can ask almost anything here and people are happy to help.
Adding to that, other people will learn from your questions as well! Win-Win for everyone!What you should do now?
Well, you could tinker and try to make it work?
But I agree with @timconsidine, his advice is safe and sound and will prevent some headaches for you
