SonarQube7.7安装遇到的问题

2台阿里服务器，系统版本

A：Linux version 3.10.0-693.2.2.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC) ) #1 SMP Tue Sep 12 22:26:13 UTC 201
7

B：Linux version 3.10.0-957.10.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Mon Mar 18 15:06:45 UTC
 2019

现状是A服务器启动不了sonar,B服务器可以启动。都是使用sonar用户上去解压启动。其中A就一直要输入用户密码，很是不解。而且需要输入的还是root用户的密码。启动结果当然是ES不支持root用户启动了、只能是修改sonar.sh文件  指定用户了RUN_AS_USER=sonar 这样才能启动

A服务器通过bash -x ./sonar.sh start启动查看跟B服务核对有一下差异：

能力水平不行，至今未知晓是啥原因，有知晓的童鞋，请回复。在此敬礼谢过

A：

+ LOCKPROP=
+ '[' -d /var/lock/subsys ']'
+ '[' -w /var/lock/subsys ']'
+ case "$1" in
+ checkUser touchlock start
+ '[' Xroot '!=' X ']'
+ IDEXE=/usr/xpg4/bin/id
+ '[' '!' -x /usr/xpg4/bin/id ']'
+ IDEXE=/usr/bin/id
+ '[' '!' -x /usr/bin/id ']'
++ /usr/bin/id -u -n
+ '[' sonar = root ']'
+ '[' Xroot '!=' X ']'
+ '[' X '!=' X ']'
+ su -m root -c '"/home/sonar/sonarqube-7.7/bin/linux-x86-64/./sonar.sh" start'

B：

+ LOCKPROP=
+ '[' -d /var/lock/subsys ']'
+ '[' -w /var/lock/subsys ']'
+ case "$1" in
+ checkUser touchlock start
+ '[' X '!=' X ']'
+ '[' X '!=' X ']'
+ start
+ echo 'Starting SonarQube...'
Starting SonarQube...
+ getpid
+ '[' -f /home/QbDev/sonarqube-7.7/bin/linux-x86-64/./SonarQube.pid ']'
+ '[' X = X ']'

sonar启动后。入手maven代码检查，参照官网https://docs.sonarqube.org/display/SCAN/Analyzing+with+SonarQube+Scanner+for+Maven 操作了一番。mvn org.sonarsource.scanner.maven:sonar-maven-plugin:3.6.0.1398:sonar  -Dsonar.host.url=http://127.0.0.1:9000

其中有出现以下错误： maven显示的upload失败，上传检测报告失败。通过在sonar目录下logs文件夹 web.log日志，一目了然发现是mysql的max_allowed_packet太小导致。只需要将这个配置重新设置重启下mysql，就能顺利上传

Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (7383627 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3681)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2512)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
        at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
        at org.sonar.db.ce.CeTaskInputDao.insert(CeTaskInputDao.java:53)
        ... 49 common frames omitted