ReviewBoard installation in Ubuntu _ MySQL

Ubuntu ReviewBoard installation process

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 ReviewBoardhttp: // 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