Jasmin shahrzad
asked on
sonar exited with code 0
sonarqube on docker on ubuntu.
i try to install sonarqube 7.7-community with postgres version 11.3
its failed with
the port 9000 is not occupied.
i try to install sonarqube 7.7-community with postgres version 11.3
its failed with
ERROR web[][o.a.c.h.Http11NioProtocol] Failed to initialize end point associated with ProtocolHandler ["http-nio-"my-ip-9000"]
sonar | java.net.BindException: Cannot assign requested address
ERROR web[][o.s.s.a.EmbeddedTomcat] Fail to start web server
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:113)
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:556)
WARN app[][o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 143
the port 9000 is not occupied.
ASKER
Nothing is on port 9000. Netstat -an | grel 9000 show nothing.
What i did is i have alredy running postgres container for Artifactory and i change the port to 5430 . Maybe this is problem, beacuse it look like sonar Can not connect to database.
Is it possible to create a sonar database and connect sonar to existing database via docker-Compose?
If i Can then i Can use the official port 5432
What i did is i have alredy running postgres container for Artifactory and i change the port to 5430 . Maybe this is problem, beacuse it look like sonar Can not connect to database.
Is it possible to create a sonar database and connect sonar to existing database via docker-Compose?
If i Can then i Can use the official port 5432
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i change port from 9000 to 9500
and i have nothing running in this port
# netstat -an | grep 9500
#
error log is :
ERROR web[][o.s.s.a.EmbeddedTomc at] Fail to start web server
sonar | org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardServer[-1]]
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
sonar | at org.apache.catalina.util.L ifecycleBa se.start(L ifecycleBa se.java:14 0)
sonar | at org.apache.catalina.startu p.Tomcat.s tart(Tomca t.java:427 )
sonar | at org.sonar.server.app.Embed dedTomcat. start(Embe ddedTomcat .java:61)
sonar | at org.sonar.server.app.WebSe rver.start (WebServer .java:51)
sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 113)
sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 100)
sonar | at org.sonar.server.app.WebSe rver.main( WebServer. java:91)
sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardService[Tomcat]]
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
sonar | at org.apache.catalina.core.S tandardSer ver.initIn ternal(Sta ndardServe r.java:875 )
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
sonar | ... 7 common frames omitted
sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize connector [Connector[HTTP/1.1-9000]]
sonar | at org.apache.catalina.core.S tandardSer vice.initI nternal(St andardServ ice.java:5 59)
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
sonar | ... 9 common frames omitted
sonar | 2019.05.16 05:10:59 WARN web[][o.s.p.ProcessEntryPo int] Fail to start web
sonar | java.lang.RuntimeException : org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardServer[-1]]
sonar | at com.google.common.base.Thr owables.pr opagate(Th rowables.j ava:160)
sonar | at org.sonar.server.app.Embed dedTomcat. start(Embe ddedTomcat .java:65)
sonar | at org.sonar.server.app.WebSe rver.start (WebServer .java:51)
sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 113)
sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 100)
sonar | at org.sonar.server.app.WebSe rver.main( WebServer. java:91)
sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardServer[-1]]
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
sonar | at org.apache.catalina.util.L ifecycleBa se.start(L ifecycleBa se.java:14 0)
sonar | at org.apache.catalina.startu p.Tomcat.s tart(Tomca t.java:427 )
sonar | at org.sonar.server.app.Embed dedTomcat. start(Embe ddedTomcat .java:61)
sonar | ... 4 common frames omitted
sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardService[Tomcat]]
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
sonar | at org.apache.catalina.core.S tandardSer ver.initIn ternal(Sta ndardServe r.java:875 )
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
sonar | ... 7 common frames omitted
sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize connector [Connector[HTTP/1.1-9000]]
sonar | at org.apache.catalina.core.S tandardSer vice.initI nternal(St andardServ ice.java:5 59)
sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
sonar | ... 9 common frames omitted
sonar | 2019.05.16 05:10:59 INFO app[][o.s.a.SchedulerImpl] Process [web] is stopped
sonar | 2019.05.16 05:11:00 INFO app[][o.s.a.SchedulerImpl] Process [es] is stopped
sonar | 2019.05.16 05:11:00 WARN app[][o.s.a.p.AbstractProc essMonitor ] Process exited with exit value [es]: 143
sonar | 2019.05.16 05:11:00 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped
sonar exited with code 0
and i have nothing running in this port
# netstat -an | grep 9500
#
error log is :
ERROR web[][o.s.s.a.EmbeddedTomc
sonar | org.apache.catalina.Lifecy
sonar | at org.apache.catalina.util.L
sonar | at org.apache.catalina.util.L
sonar | at org.apache.catalina.startu
sonar | at org.sonar.server.app.Embed
sonar | at org.sonar.server.app.WebSe
sonar | at org.sonar.process.ProcessE
sonar | at org.sonar.process.ProcessE
sonar | at org.sonar.server.app.WebSe
sonar | Caused by: org.apache.catalina.Lifecy
sonar | at org.apache.catalina.util.L
sonar | at org.apache.catalina.core.S
sonar | at org.apache.catalina.util.L
sonar | ... 7 common frames omitted
sonar | Caused by: org.apache.catalina.Lifecy
sonar | at org.apache.catalina.core.S
sonar | at org.apache.catalina.util.L
sonar | ... 9 common frames omitted
sonar | 2019.05.16 05:10:59 WARN web[][o.s.p.ProcessEntryPo
sonar | java.lang.RuntimeException
sonar | at com.google.common.base.Thr
sonar | at org.sonar.server.app.Embed
sonar | at org.sonar.server.app.WebSe
sonar | at org.sonar.process.ProcessE
sonar | at org.sonar.process.ProcessE
sonar | at org.sonar.server.app.WebSe
sonar | Caused by: org.apache.catalina.Lifecy
sonar | at org.apache.catalina.util.L
sonar | at org.apache.catalina.util.L
sonar | at org.apache.catalina.startu
sonar | at org.sonar.server.app.Embed
sonar | ... 4 common frames omitted
sonar | Caused by: org.apache.catalina.Lifecy
sonar | at org.apache.catalina.util.L
sonar | at org.apache.catalina.core.S
sonar | at org.apache.catalina.util.L
sonar | ... 7 common frames omitted
sonar | Caused by: org.apache.catalina.Lifecy
sonar | at org.apache.catalina.core.S
sonar | at org.apache.catalina.util.L
sonar | ... 9 common frames omitted
sonar | 2019.05.16 05:10:59 INFO app[][o.s.a.SchedulerImpl]
sonar | 2019.05.16 05:11:00 INFO app[][o.s.a.SchedulerImpl]
sonar | 2019.05.16 05:11:00 WARN app[][o.s.a.p.AbstractProc
sonar | 2019.05.16 05:11:00 INFO app[][o.s.a.SchedulerImpl]
sonar exited with code 0
Looks like your change was not done in the right place:
Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize connector [Connector[HTTP/1.1-9000]]
Caused by: org.apache.catalina.Lifecy
ASKER
yes i can see it.
here is my docker-compose file. doesn't mater which port i write in my compose file. it's totally ignored and try to connect to 9000
-----
version: "3"
services:
db:
image: postgres:11.3
restart: unless-stopped
container_name: sonar-postgresql
ports:
- 5430:5432
environment:
POSTGRES_DB: sonar
POSTGRES_USER: sonar
POSTGRES_PASSWORD: Sonar
volumes:
- /containers/postgres/sonar /sonar_dat a:/var/lib /postgresq l/data
- /containers/postgres/sonar /sonar_db: /var/lib/p ostgres
restart: always
ulimits:
nproc: 65535
nofile:
soft: 32000
hard: 40000
sonarqube:
image: sonarqube:7.7-community
restart: unless-stopped
container_name: PF-sonar
ports:
- 9100:9000
- 9092:9092
volumes:
- /containers/sonar/sonarqub e_conf:/op t/sonarqub e/conf
- /containers/sonar/sonarqub e_data:/op t/sonarqub e/data
- /containers/sonar/sonarqub e_extensio ns:/opt/so narqube/ex tensions
- /containers/sonar/sonarqub e_plugins: /opt/sonar qube/lib/b undled-plu gins
environment:
- sonar.jdbc.url=jdbc:postgr esql://db: 5432/sonar
- DB_TYPE=postgresql
- DB_USER=sonar
- DB_PASSWORD=Sonar
ulimits:
nproc: 65535
nofile:
soft: 32000
hard: 40000
------
here is my docker-compose file. doesn't mater which port i write in my compose file. it's totally ignored and try to connect to 9000
-----
version: "3"
services:
db:
image: postgres:11.3
restart: unless-stopped
container_name: sonar-postgresql
ports:
- 5430:5432
environment:
POSTGRES_DB: sonar
POSTGRES_USER: sonar
POSTGRES_PASSWORD: Sonar
volumes:
- /containers/postgres/sonar
- /containers/postgres/sonar
restart: always
ulimits:
nproc: 65535
nofile:
soft: 32000
hard: 40000
sonarqube:
image: sonarqube:7.7-community
restart: unless-stopped
container_name: PF-sonar
ports:
- 9100:9000
- 9092:9092
volumes:
- /containers/sonar/sonarqub
- /containers/sonar/sonarqub
- /containers/sonar/sonarqub
- /containers/sonar/sonarqub
environment:
- sonar.jdbc.url=jdbc:postgr
- DB_TYPE=postgresql
- DB_USER=sonar
- DB_PASSWORD=Sonar
ulimits:
nproc: 65535
nofile:
soft: 32000
hard: 40000
------
ASKER
i think i find more in log file.
FATAL: password authentication failed for user "sonar"
in my docker-compose is password Sonar. But it's not accept. i just connect to database via
docker exec -it sonar psql -U sonar
and i change password to sonar via
\password sonar command
and commit my docker container.
try to start up
sonar-postgresql | 2019-05-16 11:20:57.325 UTC [31] FATAL: password authentication failed for user "sonar"
sonar-postgresql | 2019-05-16 11:20:57.325 UTC [31] DETAIL: Password does not match for user "sonar".
sonar-postgresql | Connection matched pg_hba.conf line 95: "host all all all md5"
ERROR web[][o.s.s.p.Platform] Web server startup failed
it should be ok for entry all all all md5 i have the same for artifactory
FATAL: password authentication failed for user "sonar"
in my docker-compose is password Sonar. But it's not accept. i just connect to database via
docker exec -it sonar psql -U sonar
and i change password to sonar via
\password sonar command
and commit my docker container.
try to start up
sonar-postgresql | 2019-05-16 11:20:57.325 UTC [31] FATAL: password authentication failed for user "sonar"
sonar-postgresql | 2019-05-16 11:20:57.325 UTC [31] DETAIL: Password does not match for user "sonar".
sonar-postgresql | Connection matched pg_hba.conf line 95: "host all all all md5"
ERROR web[][o.s.s.p.Platform] Web server startup failed
it should be ok for entry all all all md5 i have the same for artifactory
ASKER
it should be reported i change it to trust and commit my email for postgres. now it's running
Well done 👍
ASKER
Now i do not connect to sonar. Please Help.
i use 9100 on compose file but ip:9100 syas page not found. i can see netstat -an | grep 9100 and 9092 is listen. but i can't connect to it.
i have had a old sonar (7.4) stand alone and i used the old sonar.properties and just rename database and connection.
but what happen if i don't have it? it's look like is not running correct.
i use 9100 on compose file but ip:9100 syas page not found. i can see netstat -an | grep 9100 and 9092 is listen. but i can't connect to it.
i have had a old sonar (7.4) stand alone and i used the old sonar.properties and just rename database and connection.
but what happen if i don't have it? it's look like is not running correct.
ASKER
still try to connect to port 9000
and i have something else in this port
PF-sonar | 2019.05.16 12:57:56 INFO web[][o.s.s.a.EmbeddedTomc at] HTTP connector enabled on port 9000
and i have something else in this port
PF-sonar | 2019.05.16 12:57:56 INFO web[][o.s.s.a.EmbeddedTomc
ASKER
i can running on 9100 now when i remove the file but still warning for file is not find (/opt/sonarqube/conf/sonar .propertie s)
and can not create the file. do you have a correct one or when i get some sonar.properties file.
and can not create the file. do you have a correct one or when i get some sonar.properties file.
ASKER
Thank you.
You're welcome ;)
ASKER
i still missing sonar.properties. do you know where i can download one?
But you have one in your SonarQube home folder under conf - the file just needs to be configured, it's not something you just download.
ASKER
no i do not have. sonar start and say the file is missing. i have a one from earlier version. but what happen if it was first installation?
ASKER
i need to reinstall sonarqube this time i select port 9200 and set host all all all trust in postgres. i get the same error HELP
2019.05.22 18:12:20 ERROR web[][o.s.s.a.EmbeddedTomc at] Fail to start web server
PF-sonar | org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardServer[-1]]
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.start(L ifecycleBa se.java:14 0)
PF-sonar | at org.apache.catalina.startu p.Tomcat.s tart(Tomca t.java:427 )
PF-sonar | at org.sonar.server.app.Embed dedTomcat. start(Embe ddedTomcat .java:61)
PF-sonar | at org.sonar.server.app.WebSe rver.start (WebServer .java:51)
PF-sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 113)
PF-sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 100)
PF-sonar | at org.sonar.server.app.WebSe rver.main( WebServer. java:91)
PF-sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardService[Tomcat]]
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
PF-sonar | at org.apache.catalina.core.S tandardSer ver.initIn ternal(Sta ndardServe r.java:875 )
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
PF-sonar | ... 7 common frames omitted
PF-sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize connector [Connector[HTTP/1.1-9000]]
PF-sonar | at org.apache.catalina.core.S tandardSer vice.initI nternal(St andardServ ice.java:5 59)
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
PF-sonar | ... 9 common frames omitted
PF-sonar | 2019.05.22 18:12:20 WARN web[][o.s.p.ProcessEntryPo int] Fail to start web
PF-sonar | java.lang.RuntimeException : org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardServer[-1]]
PF-sonar | at com.google.common.base.Thr owables.pr opagate(Th rowables.j ava:160)
PF-sonar | at org.sonar.server.app.Embed dedTomcat. start(Embe ddedTomcat .java:65)
PF-sonar | at org.sonar.server.app.WebSe rver.start (WebServer .java:51)
PF-sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 113)
PF-sonar | at org.sonar.process.ProcessE ntryPoint. launch(Pro cessEntryP oint.java: 100)
PF-sonar | at org.sonar.server.app.WebSe rver.main( WebServer. java:91)
PF-sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardServer[-1]]
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.start(L ifecycleBa se.java:14 0)
PF-sonar | at org.apache.catalina.startu p.Tomcat.s tart(Tomca t.java:427 )
PF-sonar | at org.sonar.server.app.Embed dedTomcat. start(Embe ddedTomcat .java:61)
PF-sonar | ... 4 common frames omitted
PF-sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize component [StandardService[Tomcat]]
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:112 )
PF-sonar | at org.apache.catalina.core.S tandardSer ver.initIn ternal(Sta ndardServe r.java:875 )
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
PF-sonar | ... 7 common frames omitted
PF-sonar | Caused by: org.apache.catalina.Lifecy cleExcepti on: Failed to initialize connector [Connector[HTTP/1.1-9000]]
PF-sonar | at org.apache.catalina.core.S tandardSer vice.initI nternal(St andardServ ice.java:5 59)
PF-sonar | at org.apache.catalina.util.L ifecycleBa se.init(Li fecycleBas e.java:107 )
2019.05.22 18:12:20 ERROR web[][o.s.s.a.EmbeddedTomc
PF-sonar | org.apache.catalina.Lifecy
PF-sonar | at org.apache.catalina.util.L
PF-sonar | at org.apache.catalina.util.L
PF-sonar | at org.apache.catalina.startu
PF-sonar | at org.sonar.server.app.Embed
PF-sonar | at org.sonar.server.app.WebSe
PF-sonar | at org.sonar.process.ProcessE
PF-sonar | at org.sonar.process.ProcessE
PF-sonar | at org.sonar.server.app.WebSe
PF-sonar | Caused by: org.apache.catalina.Lifecy
PF-sonar | at org.apache.catalina.util.L
PF-sonar | at org.apache.catalina.core.S
PF-sonar | at org.apache.catalina.util.L
PF-sonar | ... 7 common frames omitted
PF-sonar | Caused by: org.apache.catalina.Lifecy
PF-sonar | at org.apache.catalina.core.S
PF-sonar | at org.apache.catalina.util.L
PF-sonar | ... 9 common frames omitted
PF-sonar | 2019.05.22 18:12:20 WARN web[][o.s.p.ProcessEntryPo
PF-sonar | java.lang.RuntimeException
PF-sonar | at com.google.common.base.Thr
PF-sonar | at org.sonar.server.app.Embed
PF-sonar | at org.sonar.server.app.WebSe
PF-sonar | at org.sonar.process.ProcessE
PF-sonar | at org.sonar.process.ProcessE
PF-sonar | at org.sonar.server.app.WebSe
PF-sonar | Caused by: org.apache.catalina.Lifecy
PF-sonar | at org.apache.catalina.util.L
PF-sonar | at org.apache.catalina.util.L
PF-sonar | at org.apache.catalina.startu
PF-sonar | at org.sonar.server.app.Embed
PF-sonar | ... 4 common frames omitted
PF-sonar | Caused by: org.apache.catalina.Lifecy
PF-sonar | at org.apache.catalina.util.L
PF-sonar | at org.apache.catalina.core.S
PF-sonar | at org.apache.catalina.util.L
PF-sonar | ... 7 common frames omitted
PF-sonar | Caused by: org.apache.catalina.Lifecy
PF-sonar | at org.apache.catalina.core.S
PF-sonar | at org.apache.catalina.util.L
what to you get? I suspect something is LISTENing to that port.