A problem has been bothering me all day.

Dec 17, 2022120

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

The author spent a day troubleshooting an issue with JumpServer, a web application that does not have a log cleaning feature. They attempted to connect JumpServer to a local MySQL database but were unsuccessful. They then tried installing MySQL and Redis externally, but Redis did not work. They managed to connect to MySQL through the JumpServer gateway's IP address. They installed the Baota control panel and added the JumpServer application's database. They also installed phpMyAdmin but had trouble connecting, although the phpMyAdmin installed through Baota worked. Despite the challenges, the author eventually found a solution to clean the database logs after a day of troubleshooting.

When using JumpServer, there is no function to clean logs in the web interface.

But I wanted to clean these logs, so I tried to connect to the MySQL database of JumpServer locally.

I couldn't connect, even after allowing the port and remapping it. Then I thought about not using the one-click installation, and instead installed MySQL and Redis step by step as external services.

Later, I found that I could successfully connect to MySQL, but Redis couldn't run.

So I set MySQL as an external service and Redis as an internal service. It could run, but the web terminal couldn't connect to the server.

Then I found that I could connect to MySQL through the IP of the JumpServer gateway.

So I installed Baota, added a remote database, and added the database under the JumpServer application.

Then I installed phpMyAdmin to try to connect, but I still couldn't connect. Surprisingly, I could connect using the phpMyAdmin installed by Baota.

I used different methods on two servers, both using Docker to install phpMyAdmin.

Currently, I have found a solution just to clean the logs in the database. It took me a whole day to troubleshoot.