开源EasyReport报表工具安装记录

https://github.com/xianrendzw/EasyReport/releases

#yum -y install mariadb*

#service mariadb start

#mysql -uroot -p

>SET password=PASSWORD('123456');

>source  /XXXXX/easyreport2.sql

修改war文件里WEB-INF/classes/config/easyreport/spring/spring-datasource.xml中数据库连接信息

 ./startup.sh 启动Tomcat

 

备注：用tomcat8的包，不要使用tomcat10版本。

 

补充：

18:33:50.913 [C3P0PooledConnectionPoolManager[identityToken->1hgeubxaf1dnu9rg2ec5qe|3f0dc209]-HelperThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
 

解决办法：

grant all privileges on *.* to root@'localhost' identified by "123456" with grant option;  

 flush privileges;