sonarqube ignores postgres and picks embedded databaseHow can I drop all the tables in a PostgreSQL database?How to switch databases in psql?postgres: upgrade a user to be a superuser?SonarQube not starting without embedded databaseUnable to connect JDBC to sonarqube using PostgresqlAccess Sonar server and its db without jdbc connection stringSonarQube 6.5 - Not able to configure the SQL Server DatabaseWrapper stopped in sonarqubeSonarqube + Postgresql containers unable to determine database dialectSonarqube stopped after Apex plugin installation
Story of a Witch Boy
I just entered the USA without passport control at Atlanta airport
In a list with unique pairs A, B, how can I sort them so that the last B is the first A in the next pair?
reverse a call to mmap()
Is there any way to revive my Sim?
Would a 7805 5 V regulator drain a 9 V battery?
How can I ping multiple IP addresses at the same time?
Why is it easier to balance a non-moving bike standing up than sitting down?
Densest sphere packing
How is linear momentum conserved in circular motion?
Need help understanding the double sharp turn in Chopin's prelude in e minor
In Street Fighter, what does the M stand for in M Bison?
Are there examples of rowers who also fought?
What does this Swiss black on yellow rectangular traffic sign with a symbol looking like a dart mean?
What is this airplane that sits in front of Barringer High School in Newark, NJ?
How Hebrew Vowels Work
Boundaries and Buddhism
Why isn't my calculation that we should be able to see the sun well beyond the observable universe valid?
How "fast" do astronomical events occur?
How can a warlock learn from a spellbook?
Make symbols atomic, without losing their type
"Prove that ∂A is closed given ∂A = Cl(A) − Int(A)"
I have found ports on my Samsung smart tv running a display service. What can I do with it?
What is the highest power supply a Raspberry pi 3 B can handle without getting damaged?
sonarqube ignores postgres and picks embedded database
How can I drop all the tables in a PostgreSQL database?How to switch databases in psql?postgres: upgrade a user to be a superuser?SonarQube not starting without embedded databaseUnable to connect JDBC to sonarqube using PostgresqlAccess Sonar server and its db without jdbc connection stringSonarQube 6.5 - Not able to configure the SQL Server DatabaseWrapper stopped in sonarqubeSonarqube + Postgresql containers unable to determine database dialectSonarqube stopped after Apex plugin installation
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I tried to configure sonarqube (7.6) to use postgresql database and it seems to ignore the entries in the sonar.properties and picks up the H2 database. When I pass the properties as jvm parameters, it picks up fine. How do I configure sonar to use postgres from the sonar.properties
sonar.properties:
sonar.jdbc.username=myuser
sonar.jdbc.password=mypwd
sonar.jdbc.url=jdbc:postgresql://ipaddress:5444/mypostgres
sonar.log.level=DEBUG
Log snippet:
2019.03.25 05:42:03 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.03.25 05:42:03 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Starting embedded database on port 9092 with url jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Embedded database started. Data stored in: /opt/sonarqube/data
2019.03.25 05:42:03 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 WARN web[][o.s.db.dialect.H2] H2 database should be used for evaluation purpose only.
2019.03.25 05:42:05 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
postgresql sonarqube
asked Mar 25 at 5:51
user1573133user1573133
584417
add a comment |
I tried to configure sonarqube (7.6) to use postgresql database and it seems to ignore the entries in the sonar.properties and picks up the H2 database. When I pass the properties as jvm parameters, it picks up fine. How do I configure sonar to use postgres from the sonar.properties
sonar.properties:
sonar.jdbc.username=myuser
sonar.jdbc.password=mypwd
sonar.jdbc.url=jdbc:postgresql://ipaddress:5444/mypostgres
sonar.log.level=DEBUG
Log snippet:
2019.03.25 05:42:03 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.03.25 05:42:03 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Starting embedded database on port 9092 with url jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Embedded database started. Data stored in: /opt/sonarqube/data
2019.03.25 05:42:03 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 WARN web[][o.s.db.dialect.H2] H2 database should be used for evaluation purpose only.
2019.03.25 05:42:05 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
postgresql sonarqube
asked Mar 25 at 5:51
user1573133user1573133
584417
looks like sonar.log.level=DEBUG should be defined in the next line. Can be the issue.
– Ran
Mar 25 at 6:08
sonar.log.level is defined in a separate line. when I pasted in the SO post, the newline character didn't show up. updated post
– user1573133
Mar 25 at 6:10
Maybe it is a stupid question, but where is located yoursonar.propertiesfile?
– agabrys
Mar 26 at 17:13
conf/sonar.properties. The properties file is being picked and the logs at 'debug' level are logged.
– user1573133
Mar 26 at 17:20
add a comment |
I tried to configure sonarqube (7.6) to use postgresql database and it seems to ignore the entries in the sonar.properties and picks up the H2 database. When I pass the properties as jvm parameters, it picks up fine. How do I configure sonar to use postgres from the sonar.properties
sonar.properties:
sonar.jdbc.username=myuser
sonar.jdbc.password=mypwd
sonar.jdbc.url=jdbc:postgresql://ipaddress:5444/mypostgres
sonar.log.level=DEBUG
Log snippet:
2019.03.25 05:42:03 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.03.25 05:42:03 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Starting embedded database on port 9092 with url jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Embedded database started. Data stored in: /opt/sonarqube/data
2019.03.25 05:42:03 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 WARN web[][o.s.db.dialect.H2] H2 database should be used for evaluation purpose only.
2019.03.25 05:42:05 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
postgresql sonarqube
asked Mar 25 at 5:51
user1573133user1573133
584417
I tried to configure sonarqube (7.6) to use postgresql database and it seems to ignore the entries in the sonar.properties and picks up the H2 database. When I pass the properties as jvm parameters, it picks up fine. How do I configure sonar to use postgres from the sonar.properties
sonar.properties:
sonar.jdbc.username=myuser
sonar.jdbc.password=mypwd
sonar.jdbc.url=jdbc:postgresql://ipaddress:5444/mypostgres
sonar.log.level=DEBUG
Log snippet:
2019.03.25 05:42:03 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.03.25 05:42:03 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Starting embedded database on port 9092 with url jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 INFO web[][o.s.s.p.d.EmbeddedDatabase] Embedded database started. Data stored in: /opt/sonarqube/data
2019.03.25 05:42:03 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar
2019.03.25 05:42:03 WARN web[][o.s.db.dialect.H2] H2 database should be used for evaluation purpose only.
2019.03.25 05:42:05 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
postgresql sonarqube
postgresql sonarqube
asked Mar 25 at 5:51
user1573133user1573133
584417
asked Mar 25 at 5:51
user1573133user1573133
584417
edited Mar 25 at 6:10
user1573133
asked Mar 25 at 5:51
user1573133user1573133
584417
asked Mar 25 at 5:51
user1573133user1573133
584417
asked Mar 25 at 5:51
user1573133user1573133
584417
584417
looks like sonar.log.level=DEBUG should be defined in the next line. Can be the issue.
– Ran
Mar 25 at 6:08
sonar.log.level is defined in a separate line. when I pasted in the SO post, the newline character didn't show up. updated post
– user1573133
Mar 25 at 6:10
Maybe it is a stupid question, but where is located yoursonar.propertiesfile?
– agabrys
Mar 26 at 17:13
conf/sonar.properties. The properties file is being picked and the logs at 'debug' level are logged.
– user1573133
Mar 26 at 17:20
add a comment |
looks like sonar.log.level=DEBUG should be defined in the next line. Can be the issue.
– Ran
Mar 25 at 6:08
sonar.log.level is defined in a separate line. when I pasted in the SO post, the newline character didn't show up. updated post
– user1573133
Mar 25 at 6:10
Maybe it is a stupid question, but where is located yoursonar.propertiesfile?
– agabrys
Mar 26 at 17:13
conf/sonar.properties. The properties file is being picked and the logs at 'debug' level are logged.
– user1573133
Mar 26 at 17:20
looks like sonar.log.level=DEBUG should be defined in the next line. Can be the issue.
– Ran
Mar 25 at 6:08
looks like sonar.log.level=DEBUG should be defined in the next line. Can be the issue.
– Ran
Mar 25 at 6:08
sonar.log.level is defined in a separate line. when I pasted in the SO post, the newline character didn't show up. updated post
– user1573133
Mar 25 at 6:10
sonar.log.level is defined in a separate line. when I pasted in the SO post, the newline character didn't show up. updated post
– user1573133
Mar 25 at 6:10
Maybe it is a stupid question, but where is located your
sonar.properties file?– agabrys
Mar 26 at 17:13
Maybe it is a stupid question, but where is located your
sonar.properties file?– agabrys
Mar 26 at 17:13
conf/sonar.properties. The properties file is being picked and the logs at 'debug' level are logged.
– user1573133
Mar 26 at 17:20
conf/sonar.properties. The properties file is being picked and the logs at 'debug' level are logged.
– user1573133
Mar 26 at 17:20
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55331903%2fsonarqube-ignores-postgres-and-picks-embedded-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55331903%2fsonarqube-ignores-postgres-and-picks-embedded-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
looks like sonar.log.level=DEBUG should be defined in the next line. Can be the issue.
– Ran
Mar 25 at 6:08
sonar.log.level is defined in a separate line. when I pasted in the SO post, the newline character didn't show up. updated post
– user1573133
Mar 25 at 6:10
Maybe it is a stupid question, but where is located your
sonar.propertiesfile?– agabrys
Mar 26 at 17:13
conf/sonar.properties. The properties file is being picked and the logs at 'debug' level are logged.
– user1573133
Mar 26 at 17:20