ReviewBoard installation in Ubuntu

After one and a half months of research and exploration, I finally built a ReviewBoard under Ubuntu to complete a system that can run a process! Reference: Install ReviewBoardhttp: // rewrite on Ubuntu

After one and a half months of research and exploration, I finally built a ReviewBoard under Ubuntu to complete a system that can run a process!

Refer:

Install ReviewBoard http://www.linuxidc.com/Linux/2014-05/101222.htm on Ubuntu

Build a Reviewboard on CentOSHttp://www.linuxidc.com/Linux/2014-04/100220.htm

Install ReviewBoard on Ubuntu ServerHttp://www.linuxidc.com/Linux/2009-06/20420.htm

1. Install the easy_install software before starting the setup:
 
Sudo apt-get install python-setuptools python-dev;
 
2 install apache2 and mod_python
Sudo apt-get install apache2 libapache2-mod-python
 
Sudo a2enmod python/* modify the configuration of apache2 to enable python mod */

3. Install mysql
Sudo apt-get install mysql-server python-mysqldb libmemcache-dev
Sudo easy_install http://gijsbert.org/downloads/cmemcache/cmemcache-0.95.tar.bz2
 
Create Database, database user for ReviewBoard (this should pay attention to the character set settings of the database, the default is not the UTF-8)
 
No character set problem occurs during the previous installation, leading to garbled Chinese characters on the webpage. After the installation and configuration are performed by default, there is no problem in entering and saving English letters. However, once you enter Chinese characters, the information displayed on the saved page is garbled, in some cases, the Review Board prompts an error when saving Chinese data. My Ubuntu locale is "zh_CN.UTF-8", the Chinese internal code after the input method should be UTF-8. Review Board itself, in theory, its kernel should also be built-in support for UTF-8 encoding, where is the problem? The answer is MySQL.
 
Enter MySQL in command line mode, and enter the status command: Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
 
It is easy to modify the default Character Set of MySQL. Stop MySQL Server (sudo/etc/init. d/mysqlstop), and then enable/etc/mysql/my. cnf: Add a key-value under the [client] and [mysqld] Sections respectively (this method will cause mysql to not be restarted)
 
The correct method is:
 
Find [client] and add:
 
Default-character-set = utf8 // The default character set is utf8
 
Find [mysqld] and add:
 
// The default character set is utf8.
 
Default-character-set = utf8
 
// Set utf8 encoding when connecting to the mysql database to run the mysql database as utf8
 

Init_connect = 'set NAMES utf8'
 
However, an error occurred when I started the mysql service after the modification.
 
I tried a variety of solutions online and did not solve them,
 
Finally, find a solution, which can be solved as follows:
 
Others are also the same as above, only added under [mysqld]
 
Default-character-set = utf8
 
Change
 
Character-set-server = utf8
 
Mysql is restarted successfully.
 
The result is: Server characterset: utf8.
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8 indicates that the test is successful.
 
The following configuration is for the database user: mysql-u root-p/* log on as the root user */
Mysql> create database reviewboard;
Query OK, 1 row affected (0.00 sec)
Mysql> create user 'reviewboard' @ 'localhost' identified by 'reviewboard';/* the previous reviewboard is the username used to access the database, and the last reviewboard is the password */
Query OK, 0 rows affected (0.00 sec)
Mysql> grant all on reviewboard. * to 'reviewboard' @ 'localhost';/* the previous reviewboard is the name of the database, and the other reviewboard is the user name for accessing the database */
Query OK, 0 rows affected (0.00 sec)
Mysql> exit
 

For more details, refer to the highlights on the next page.: Http://www.linuxidc.com/Linux/2014-07/104089p2.htm