guxiang Try using Token based authentication instead of username and password

 bat  '''           mvn clean verify sonar:sonar\

                      -Dsonar.login=admin \

                      -Dsonar.login=sqp_fc4b05de7f85cb261cbb55567bf9f76a68241fe8 \

                      -Dsonar.password=123456 \

                      -Dsonar.projectKey=Java \

                      -Dsonar.host.url=http://192.168.0.106:9000                   '''                 }

     }
        }
        stage('Quality Gate'){
         steps{
            script {
                timeout(time:1,unit:'HOURS'){
                        sleep(5)
                        def qg = waitForQualityGate(webhookSecretId: 'webhook_secret_text', credentialsId: 'sonar_project_secret_text') //
                        if (qg.status != 'OK') {
                            echo "Status: ${qg.status}"
                            error "Pipeline aborted due to quality gate failure: ${qg.status}"
                        }
                    }
             }
          }
     }
    }
}

get the same resuly

what's the scope of credentialsId: 'sonar_project_secret_text'  ?

have you defined it in global credentials?

yes

def qg = waitForQualityGate(webhookSecretId: 'sqp_9248f56b5cb5f25a563d5749c6e25e9b3526a207')

def qg = waitForQualityGate()

get the same result

database is  SQL Server in Windows and psql in linux

,
"branch": {
"name": "master",
"type": "BRANCH",
"isMain": true,
"url": "http://localhost:9000/dashboard?id=TestNG%3ATestNG"
},
"qualityGate": {
"name": "Sonar way",
"status": "OK",
"conditions": [

,
{
"metric": "new_security_rating",
"operator": "GREATER_THAN",
"value": "1",
"status": "OK",
"errorThreshold": "1"
},
{
"metric": "new_maintainability_rating",
"operator": "GREATER_THAN",
"value": "1",
"status": "OK",
"errorThreshold": "1"
},
{
"metric": "new_coverage",
"operator": "LESS_THAN",
"status": "NO_VALUE",
"errorThreshold": "80"
},
{
"metric": "new_duplicated_lines_density",
"operator": "GREATER_THAN",
"status": "NO_VALUE",
"errorThreshold": "3"
},
{
"metric": "new_security_hotspots_reviewed",
"operator": "LESS_THAN",
"status": "NO_VALUE",
"errorThreshold": "100"
}
]
},
"properties": {
"sonar.analysis.detectedscm": "undetected",
"sonar.analysis.detectedci": "Jenkins"
}
}

seems It is permission issue

https://docs.sonarqube.org/latest/analysis/scan/sonarscanner-for-jenkins/#header-6

please check your configuration in Manage Jenkins -> Configure System -> SonarQube installations

check 'Server authentication token' you provided has sufficient permission to get quality gate status

It has passed in ubutun Linux with SnarQube work on psql 10, but 401 error still in windows 10  SnarQube work on with SQL Server  2014.

Checking status of SonarQube task 'AYTGxlU8BSWk-5W6wJUA' on server 'SonarQube'
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] End of Pipeline
org.sonarqube.ws.client.HttpException: Error 401 on http://192.168.0.106:9000/api/ce/task?id=AYTGxlU8BSWk-5W6wJUA : 
    at hudson.plugins.sonar.client.HttpClient.getHttp(HttpClient.java:48)
    at hudson.plugins.sonar.client.WsClient.getCETask(WsClient.java:51)
    at org.sonarsource.scanner.jenkins.pipeline.WaitForQualityGateStep$Execution.checkTaskCompleted(WaitForQualityGateStep.java:240)
    at org.sonarsource.scanner.jenkins.pipeline.WaitForQualityGateStep$Execution.start(WaitForQualityGateStep.java:176)
    at org.jenkinsci.plugins.workflow.cps.DSL.invokeStep(DSL.java:322)
    at org.jenkinsci.plugins.workflow.cps.DSL.invokeMethod(DSL.java:196)
    at org.jenkinsci.plugins.workflow.cps.CpsScript.invokeMethod(CpsScript.java:124)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:98)
    at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
    at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1225)
    at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1034)
    at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:41)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
    at org.kohsuke.groovy.sandbox.impl.Checker$1.call(Checker.java:180)

sonarqube-9.6.1.59531

Jenkins 2.380

SQL Server 2014

sonarqube version is 9.6.1.59531

SonarQube Scanner for Jenkins 2.15

is it same project?

i assume there are two sonarqube servers as you saying one is running on psql and other is running on sql

you are using waitForQualityGate() step, it expects token and that token you define in Jenkins Dashboard -> Manage Jenkins ->Configure System ->Server authentication token  no need to provide username, password and token in pipeline.

If you have multiple sonar instances you can add sonarqube server and auth token details here Jenkins Dashboard -> Manage Jenkins ->Configure System

I double  chec k the problem, but get the same issue at the windows 10 with SQL Server 2016. and you can refer to:

• https://www.656463.com/wenda/SonarQubewaitForQualityGatefh401_304
• https://cloud.tencent.com/developer/ask/sof/668005
• https://stackoverflow.com/questions/60741726/org-sonarqube-ws-client-httpexception-error-401
• https://cloud.tencent.com/developer/ask/sof/1288935/answer/1781673

        It was a firewall issue. Communication from Jenkins to SonarQube server was opened but not the other way round. This issue can be closed. 

• https://www.mianshigee.com/question/109622lfz/

Okay, have you found the solution?

I can't find the  solution, It's a bug

how can I do using sonar-scanner, It mast add sonar.login and sonar.password? , it give org.sonarqube.ws.client.HttpException: Error 403 on http://192.168.0.123:9000/api/ce/task?id=AYTw1iOlEtD72hHE5js0 : {"errors":[

]}

pipeline {
    agent any
    
    tools

    
    stages{
            stage("Build"){
                steps{
                     withPythonEnv("C:\\Users\\xiang\\AppData\\Local\\Programs\\Python\\Python38
")

                }
            }
            stage('Code Analysis'){
                steps{
                    withSonarQubeEnv('SonarQube')

                }
            }
            stage('Quality Gate'){
                     steps{
                        script {
                            timeout(time:1,unit:'HOURS'){
                                sleep(5)
                                def qg = waitForQualityGate()
                                if (qg.status != 'OK') {
                                    echo "Status: ${qg.status}"
                                    error "Pipeline aborted due to quality gate failure: ${qg.status}"
                                }
                            }
                        }
                     }
                }
        }
    post{
        always{
            script

        }
    }
}

guxiang 

If you have configured sonarqube details and authentication token  in manage jenkins --> system configuration  then no to pass username and password details in pipeline

Also check permission level for the user you are trying to get QG status