Report development on CentOS (Linux): Birt + Tomcat + MySQL

Step 1: Install Mysql1. install mysql package yuminstallmysql. x86_64yuminstallmysql-connector-odbc.x86_64yuminstallmysql-devel.x86_64yuminstallmysql-server.x86_64 if you need python script development, you can also install mysql-pythonyuminstallMySQL-python.x86_6

Step 1: Install Mysql

1. Install the mysql package
Yum install mysql. x86_64
Yum install mysql-connector-odbc.x86_64
Yum install mysql-devel.x86_64
Yum install mysql-server.x86_64
If you need python script development, you can also install mysql-python
Yum install MySQL-python.x86_64

2. Start mysql
Service mysqld start

3. Set the default password to 123456.
/Usr/bin/mysqladmin-u root password 123456

4. log on to mysql
Mysql-uroot-p
Enter the password

5. Create a database
Create database mydb characterSet= 'Utf8'

6. Set permissions
Permissions are divided into full and partial permissions. First, you can assign all permissions.
Grant all privileges on mydb. * to 'username' @ '%'IdEntifiEdBy'Passwd';
If you only want to assign specific permissions, you can specify
Grant select, INSERT, UPDATE, delete on mydb. * TO db_user @ 'localhost' identified by 'db _ passwd ';
FLUSH PRIVILEGES

7. Allow mysql to be remotely accessed
A) First, change the mysql configuration and set the port number and Server ip address.
Vim/etc/my. cnf
In the [mysqld] section, add:
Port = 3306
Bind-DdRess = 192.168.1.53
Comment out the "skip-networking" sentence.
B) then change the firewall settings and add the port t of port 3306.CpConnection allowed:
/Sbin/iptables-I INPUT-p tcp -- dport 80-j ACCEPT
/Etc/rc. d/init. d/iptables save
/Etc/init. d/iptables restart

8. Try to connect from a remote connection (for exampleCommandLine access ):
Mysql-h 192.168.20.1-u report-p
Enter the password to log on.

Step 2: InstallMcAt and Birt

1. Install tomCat
Yum search tomcat
Yum install tomcat5-webapps.x86_64
Yum install tomcat5-admin-webapps.x86_64

2. Modify tomcat configuration

Vim/etc/tomcat5/tomcat_users.xml
Add the following lines

3. start tomcat

Service tomcat5 start
If it is normal, enter http: // localhost: 8080 in the browser and you will see the default welcome page.

4. Download birt runTime

Go to the eclipse official website to download birt-runtime-2_6_2.Zip

5.ExtractBirt-runtime-2_6_2.zip

UnzipBirt-runtime-2_6_2.zip

6. Copy tomcat to the webapp directory.

Cp birt-runtime-2_6_2/birt. war/usr/share/tomcat5/webapps

7. Download The jdbc driver: mysql-connector-java-5.1.15.zip on the official website of apache.org

Decompress and copy the jar package to the birt lib directory:
Cp mysql-connector-java-5.1.15/mysql-connector-java-5.1.15-bin.jar/usr/share/tomcat5/webapps/birt/WEB-INF/lib/

8. Run the test

Http: // localhost: 8080/birt
The default welcome page should be displayed.

9. Copy a report

Put the designed reports in the birt/report directory
Cp test. rptdesign/usr/share/tomcat5/webapps/birt/report

10. Run the report

Http: // localhost: 8080/birt/frameset? _ Report = report/test. rptdesign