==========================================================
MYSQL
==========================================================
<pre name="code" class="plain">[root@devcentos home]# yum install mariadb*
[root@devcentos home]# systemctl start mariadb
[root@devcentos home]# systemctl start mariadb.service
[root@devcentos home]# systemctl enable mariadb.service
[root@devcentos home]# mysqladmin --version
mysqladmin Ver 9.0 Distrib 5.5.44-MariaDB, for Linux on x86_64
[root@devcentos home]# mysqladmin -u root password "qwe123"
[root@devcentos home]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.44-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> CREATE USER 'gerrit2'@'localhost' IDENTIFIED BY 'qwe123';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> CREATE DATABASE reviewdb;
Query OK, 1 row affected (0.01 sec)
MariaDB [(none)]> ALTER DATABASE reviewdb charset=latin1;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> GRANT ALL ON reviewdb.* TO 'gerrit2'@'localhost';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> EXIT
Bye
=======================================================================
nginx
=======================================================================
[root@devcentos home]# yum install nginx
[root@devcentos nginx]# systemctl start nginx.service
[root@devcentos etc]# nginx -t
nginx: [emerg] getpwnam("nginx") failed in /etc/nginx/nginx.conf:5
nginx: configuration file /etc/nginx/nginx.conf test failed
solution:
[root@devcentos nginx]# useradd nginx
===========================================================================
user add
===========================================================================
[root@devcentos home]# useradd gerrit2
Creating mailbox file: File exists
[root@devcentos home]# passwd gerrit2
Changing password for user gerrit2.
==========================================================================
mysql java connector download and install
==========================================================================
[gerrit2@devcentos ~]$ wget http://repo2.maven.org/maven2/mysql/mysql-connector-java/5.1.21/mysql-connector-java-5.1.21.jar
[gerrit2@devcentos ~]$ mkdir review_site
[gerrit2@devcentos ~]$ mkdir review_site/lib
[gerrit2@devcentos ~]$ cp mysql-connector-java-5.1.21.jar /home/gerrit2/review_site/lib/
===============================================================
gerrit install
===============================================================
[gerrit2@devcentos ~]$ sudo java -jar gerrit-2.10.war init -d review_site
[sudo] password for gerrit2:
*** Gerrit Code Review 2.10
***
*** Git Repositories
***
Location of Git repositories [git]:
*** SQL Database
***
Database server type [h2]: mysql
Server hostname [localhost]:
Server port [(mysql default)]:
Database name [reviewdb]:
Database username [root]: gerrit2
gerrit2's password :
confirm password :
*** Index
***
Type [LUCENE/?]:
The index must be rebuilt before starting Gerrit:
java -jar gerrit.war reindex -d site_path
*** User Authentication
***
Authentication method [OPENID/?]: http
Get username from custom HTTP header [y/N]?
SSO logout URL :
*** Review Labels
***
Install Verified label [y/N]?
*** Email Delivery
***
SMTP server hostname [localhost]:
SMTP server port [(default)]:
SMTP encryption [NONE/?]:
SMTP username :
*** Container Process
***
Run as [root]:
Java runtime [/usr/jdk1.7.0_60/jre]:
Copy gerrit-2.10.war to /home/gerrit2/review_site/bin/gerrit.war [Y/n]?
Copying gerrit-2.10.war to /home/gerrit2/review_site/bin/gerrit.war
*** SSH Daemon
***
Listen on address [*]:
Listen on port [29418]:
Gerrit Code Review is not shipped with Bouncy Castle Crypto SSL v149
If available, Gerrit can take advantage of features
in the library, but will also function without it.
Download and install it now [Y/n]? n
Generating SSH host key ... rsa(simple)... done
*** HTTP Daemon
***
Behind reverse proxy [y/N]? y
Proxy uses SSL (https://) [y/N]?
Subdirectory on proxy server [/]: /gerrit
Listen on address [*]:
Listen on port [8081]:
Canonical URL [http://devcentos.novalocal/gerrit]: http://localhost/gerrit
*** Plugins
***
Install plugin commit-message-length-validator version v2.10 [y/N]?
Install plugin download-commands version v2.10 [y/N]?
Install plugin replication version v2.10 [y/N]?
Install plugin reviewnotes version v2.10 [y/N]?
Install plugin singleusergroup version v2.10 [y/N]?
Initialized /home/gerrit2/review_site
[gerrit2@devcentos ~]$ sudo java -jar gerrit-2.10.war reindex -d /home/gerrit2/review_site
====================================================================
start gerrit
====================================================================
[gerrit2@devcentos ~]$ sudo ~/review_site/bin/gerrit.sh start
Starting Gerrit Code Review: FAILED
[gerrit2@devcentos logs]$ cat ~/review_site/logs/error_log
find nothing wrong
====================================================================
set htpasswd
====================================================================
[gerrit2@devcentos cache]$ sudo cd /etc/nginx
[gerrit2@devcentos nginx]$ sudo mkdir passwd
[gerrit2@devcentos nginx]$ sudo vim ./passwd/gerrit2.passwd
find the online htpasswd generator at http://tool.oschina.net/htpasswd
====================================================================
set a reverse proxy
====================================================================
[gerrit2@devcentos nginx]$ sudo vim ./default.d/default.conf
location /gerrit/ {
proxy_pass http://127.0.0.1:8081;
proxy_set_header X-Forwarded-For $remote_addr;
proxy_set_header Host $host;
auth_basic "Gerrit Code Review";
auth_basic_user_file /etc/nginx/passwd/gerrit2.passwd;
}
[gerrit2@devcentos default.d]$ sudo systemctl restart nginx.service
=====================================================================
web UI
=====================================================================
open explorer
http://localhost/gerrit
success