Installation with nginx psql

Greetings all, I purchased a developer license, got my key, and I’m trying to install sonarqube developer edition on ubuntu 18.04. Server is hosted on amazon aws and port 9000 is open to the vm.

I followed the instructions and documentation on Sonar site and here. Installation itself went okay - I had no errors. I installed Sonar from here v. 9.7. I also installed Postgresql as well as ngnix. I created user sonar and group named sonargroup and added sonar to it. I chown -R 775 the sonar directory to sonar:sonargroup.

However, no matter what I do, I get Bad Request 400 with Request Header Or Cookie Too Large I added LimitNOFILE=131072 but made no difference.

Any suggestions to get it working? Thanks in advance.

sonar.properties

sonar.jdbc.username=sonar
sonar.jdbc.password=XXXXXXX
sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube?currentSchema=my_schema
sonar.web.javaAdditionalOpts=-server
sonar.web.port=9000

ngnix


server{
    listen      9000;
    server_name xxxxx.yyyyyyyy.com;

    access_log  /var/log/nginx/sonar.access.log;
    error_log   /var/log/nginx/sonar.error.log;

    proxy_buffers 16 64k;
    proxy_buffer_size 128k;
    location / {
        proxy_pass  http://127.0.0.1:9000;
        proxy_next_upstream error timeout invalid_header http_500 http_502 http_503 http_504;
        proxy_redirect off;

        proxy_set_header    Host            $host;
        proxy_set_header    X-Real-IP       $remote_addr;
        proxy_set_header    X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header    X-Forwarded-Proto http;
    }
}

sonar.service

[Unit]
Description=SonarQube service
After=syslog.target network.target

[Service]
Type=forking

LimitNOFILE=131072
LimitNPROC=8192

ExecStart=/opt/sonarqube/bin/linux-x86-64/sonar.sh start
ExecStop=/opt/sonarqube/bin/linux-x86-64/sonar.sh stop

User=root
Group=root
Restart=always

[Install]
WantedBy=multi-user.target

Hey there.

A quick google for “NGINX 400 error” gave some interesting results: Debugging a HTTP 400 Bad Request error in Nginx leads to too large headers

Thank you. NGINX is the only half of the story. Simply add “SonarQube” with that search string and my own post is the most relevant search result that relates to the 9.1 version. As a newcomer, I’m not sure if the version 7 is relevant to version 9. I couldn’t just assume that since I’ve been burnt with these kind of assumptions before. Moreover, your troubleshooting section seems to lack list of issues that one could face. Some are dead-end topics relevant to this (see example here)

Anyway, the issue is resolved. I was attempting to install on ubuntu 18.04 with NGINX. I switched to Windows installation and I’m up and running. It was a lot smoother. Thanks again.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.