This article describes how to solve common startup failures and backup failures in MySQL. The example environment is based on the Linux system. For more information, see
Startup failedAfter the server is restarted --> restart the Application Service (Confluence) --> An error is reported, indicating that the database connection fails (mysql is set to boot automatically) --> view the mysql database Status:
[root@fisheye ~]# ps -ef | grep mysqlroot 2
2014-0321, the previous part is similar to conflunce, this article does not write; first add the X permission to the file chmod + x atlassian-confluence-5.1.2-x64.bin installation, after the port is enabled to start 8080, restart the route table useradd -- create-home-c "Jira role account" Jira to change the default root permission to jirachown-r Jira: /opt/Atlassian/Jira configuration section refer to the
PrefaceJIRA is an excellent problem-tracking management software tool developed by the Australian Atlassian Company to track and manage various types of issues, including defects, tasks, requirements, improvements, and more. Jira uses the Java EE technology to deploy across platforms. It is being used by a wide range of open source software organizations, as well as world-renowned companies.Jira products are very complete and powerful, simple installa
Installation Preparation:System: centos6.5 x64Software: mysql5.x,jira6.3.6Chinese documents: Jira-6.3.3-language-pack-zh_cn.jarHack file: Atlassian-extras-2.2.2.jar Atlassian-universal-plugin-manager-plugin-2.17.4.jarTo start the installation:Because Jira needs to use the Java environment, it is necessary to install the JDK first, it is recommended to install the jdk1.6 version and the above versionMy versi
1. Installing the Java EnvironmentBecause Jira is developed in Java, all the Java environments need to be configured, and if you are not downloading a standalone installation package, you need to install the Tomcat container environment because Jira is a Java Web project.2, download Jira installation package and installationWe are directly using the standalone package, which integrates the Tomcat environment, can be directly extracted to complete the installation, remember to copy to the directo
Installation Environment: Windows xpMySQL-5.5.28Jdk1.6.0_21 The Jira features a comprehensive, user-friendly interface, simple installation, flexible configuration, privilege management, and scalability.MySQL build database and build account1. Create database in MySQL jiradbCreate Database character Set ' UTF8 ';2. Create database users and assign permissionsCreate UserJirauser identified by 'Jira';//create an account with a username of Jirauser and a password of JiraGrant All Privileges on *
root账号设置密码为 123456 mysql-u root-p #登录mysql数据库CREATE database confluence character set UTF8;Grant all on confluence.* to [e- Mail protected] "%" identified by "confluence";Grant all on confluence.* to [e- Mail protected] "localhost" identified by "confluence";FLUSH privileges;Quit #退出service mysqld Stop #关闭mysql服务cd/etc/VI my.cnfUnder [mysqld], addCharacter-set-server =utf8#解决中文显示??? Garbled problem Service mysqld start #启动mysql服务4, installation confluence#拷入
' 123456 ' #通过该命令给root账号设置密码为 123456 6 mysql-u root-p #登录mysql数据库 7 CREATE database Confluence Charac ter set UTF8; 8 Grant all on confluence.* to [emailprotected] "%" identified by "confluence"; 9 Grant all on confluence.* to [emailprotected] "localhost" identified by "confluence"; FLUSH privileges; Quit #退出 Service mysqld stop #关闭mysql服务 cd/etc/ VI my.cnf 15 add Charac under [mysqld] Ter-set-server =utf8 #解决中文显示??? Garbled question Service mysqld start #启动mysql服务 The third st
Export PATH
Export CLASSPATH
5. Restart the machine reboot.
6. Type java-version. If JDK version information is displayed, it indicates that the version is successful.
Step 2: install and configure MYSQL
1. Install MySQL.
2. log on to Mysql and run:
// Create a jiradb table
Create database jiradb character set utf8;
// Assign all permissions of the iradb table to the jira user
Grant all privileges on jiradb. * to jirauser @ localhost identified by 'mypassword' with grant option;
Flush privilege
java–version, if the relevant JDK version information appears, prove successful.Step Two: Install the configuration MySQL1. Install MySQL There's not much to say here.2. Log in to MySQL and run:Create a jiradb tableCreate database jiradb character set UTF8;Assign all permissions for the IRADB table to the Jira userGrant all privileges the jiradb.* to [e-mail protected] identified by ' MyPassword ' with GRANT option;Flush privileges;3, test whether successful, with the new Jira database user con
Startup failedRestart the server after--> restart the application service (confluence)--> error, database connection failed (MySQL set up from boot)--> view MySQL database status:
[Root@fisheye ~]# Ps-ef | grep MySQL
root 25555 21974 0 11:28 pts/0 00:00:00 grep mysql
Start the MySQL server
[Root@fisheye data]# service MySQL start
MySQL server PID file could not is found
Download the latest version of Https://www.atlassian.com/software/confluence/download
Upload to Server
Extract
Tar zxf atlassian-confluence-5.10.1.tar.gz
CD ZXF atlassian-confluence-5.10.1
Copy the Atlassian-extras-3.2.jar (hack plugin) to
CP Atlassian-confluence-5.8.6/confluence/web-inf/lib/
Deploy and install JIRA 6.3.6 in CentOSJIRA is a project and transaction tracking tool developed by Atlassian. It is widely used in defect tracking, customer service, requirement collection, process approval, task tracking, project tracking, and agile management. JIRA features flexible configuration, comprehensive functions, simple deployment, and rich scalability. Over 150 features have been recognized by more than 115 customers in 19,000 countries a
11 --------------------------------
12 source /etc/profile
Third, install MySQL
1 yum install -y mysql-server mysql mysql-devel
2 service mysqld start #initialization and related configuration
3 chkconfig --list | grep mysqld #View mysql service is not boot automatically start
4 chkconfig mysqld on #Set to boot
5 mysqladmin -u root password ‘123456‘ #Set the password for the root account with this command to 123456
6 mysql -u root -p #login mysql database
7 create database
Jira Environment:System: CentOS 6.7Jira version: 6.3.6Other environment: jdk1.6, MariaDB10.0.21First, configure the Yum source and upgrade the system to the latest1), install Epel source#yum-y install epel-release#yum-y upgrade yum-y Update2), Running one_key.shSecond, JDK environment deploymentRefer to "install_java.sh", note jira6.3.6 need at least JDK1.6Third, create a databaseReference to "install_mariadb.sh"Mysql> CREATE DATABASE Jira default Character set utf8;mysql> grant all privileges
: Configure MYSQL
Create database: create database jiradb characterset utf8;
Create User PermissionsGrant all privileges on jiradb. * to jirauser @ localhost identified by 'mypassword' with grant option;
Flush privileges;
Step 2: Install the MYSQL/JJDBC driver
The function is to allow JAVA to connect to MYSQL through JDBCPut the mysql-connector-java-xxx-bin.jar file into tomcat/lib, or under the lib file of jira
Step 2: Install jira
1,Create the directory mkdir/var/jira_home used when Jira i
According to the task of their superiors to refer to the Jira Baidu document construction, to facilitate the company's Test personnel project management below is my installation steps.1. Pre-installation preparation;Server: centos6.5 SystemJira installation package: Atlassian-jira-6.3.6.tarInstallation Environment: jdk1.8.03Database: MySQL Database2.JDK installation;I've already written this in my last article, and I can refer to http://11432799.blog.
, operating systems, and database platforms
Install Jira:
The code is as follows:
Https://www.atlassian.com/software/jira/download-archives//#下载地址
Chmod +x Atlassian-jira-5.2.1-x64.bin//# Give executable permission
./atlassian-jira-5.2.1-x64.bin//#开始安装 Default Tomcat Java environment is not required to set the JAVA_HOME environment
Unpacking JRE ...
Starting Installer ...
This'll install JIRA 5.0 on
Window under Jira+sql Server deployment + Chinese + hack (pro-test 2018.5)Many of the Internet is jira+mysql deployment of articles, because I now have the need to use SQL Server database, so I try to do a bit, referring to many articles on the internet, coupled with their own several attempts, and soon succeeded, shared.Full text section:First, prepare beforehandSecond, installation JiraThird, Chinese and crackedFirst, prepare beforehand1. Download the JDK and install: http://www.oracle.com/tec
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.