Shulou(Shulou.com)06/01 Report--

The server restarted yesterday, and then many services need to be restarted, running automation scripts

Check the tomcat status, all are normal, then visit the server and find that the tomcat where jira and wikr (confluence) are located automatically shuts down

Find out why, and the awkward time has come:

Look for clues under jira_home, find the two files dbconfig.xml and jira.lock, and judge that the lock file should be started, so delete it.

Restart tomcat, there's a chill behind it!

Jira needs to be reconfigured!

Alas, the hand is cheap, there is no way, find information, ask Daniel, the solution is as follows:

Replace the dbconfig.xml file with the following:

DefaultDS

Default

Mysql

Jdbc:mysql://localhost:3306/jira_new?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB

Com.mysql.jdbc.Driver

Jira

Jiradev169

twenty

twenty

30000

Select 1

60000

300000

twenty

True

three hundred

True

three

Among them, the scarlet letter is the place where changes need to be made. Different servers have different situations. What database, port and account password are used?

At this point, I thought, it should be all right! Restart tomcat

Haha, the heart is in full bloom, you can visit normally, but the problem comes again, after entering the page, the console graphics display garbled!

It's over, what's going on!

I can't help it, but I still have to find it!

Let's start with the database! After all, the service has been started and can be accessed, but there is something wrong with the database call.

Check the database users, sure enough! Jira users are gone!

Create a jira user, and then empower:

Grant all privileges on jira.* to jira@'%' identified by 'jiradevhost'

Restart tomcat to solve the problem successfully!

The jira problem is solved. What about wiki? Visit and have a look!

ERROR!!!!

Oh, my God, what the heck!

Check! Go to the wiki_home directory and look at the confluence configuration file to find lines related to username&password

Well, it's a good thing I'm smart, the database password and account are wrong, modify it, restart tomcat!

Jira and wiki visited successfully!

Alas, for this incident, it is true that if you do not die, you will not die!

So the importance of backup! Whether it is a database or an application, you need to make a backup! Otherwise, if there is my situation, I really want to die!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.