ready-api-soapui-testrunner does not pass global properties

Question

HiI'm using&nbsp;ready-api-soapui-testrunner:3.47.0 Docker image to run my tests&nbsp;But global properties used in&nbsp;-e COMMAND_LINEare not passed to the&nbsp; project file and tests are failing.E.g. -Gmy.jdbc.url=jdbc:mysql://remote-server:6446/databasename?user=username&amp;password=plainpassword222gives&nbsp;java.sql.SQLException: Access denied for user ''@'remote-server' which indicates that username that I have provided is not known to the testrunner.&nbsp;Using Readyapi or command line using testrunner.bat works without any problem. Tests run and are passed.So what is the reason to failure when running the Docker image?

nmrao · Answer

Contents of&nbsp; the entry point script of docker image and docker container start command please for better understanding.

rte4hirsiz · Answer

#!/bin/bash#JAVA 17export JAVA_OPTS="--add-opens java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.lang.invoke=ALL-UNNAMED --add-opens java.desktop/java.beans=ALL-UNNAMED --add-opens java.base/java.util=ALL-UNNAMED --add-opens java.base/java.lang.reflect=ALL-UNNAMED --add-opens java.base/java.util.concurrent.atomic=ALL-UNNAMED --add-opens java.xml/com.sun.org.apache.xerces.internal.util=ALL-UNNAMED --add-opens java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.net=ALL-UNNAMED --add-opens java.desktop/java.awt=ALL-UNNAMED --add-opens java.desktop/javax.swing=ALL-UNNAMED --add-opens java.base/sun.net.www=ALL-UNNAMED --add-opens java.base/sun.net.www.protocol.https=ALL-UNNAMED --add-opens java.base/sun.net.www.protocol.http=ALL-UNNAMED --add-opens java.desktop/javax.swing.plaf=ALL-UNNAMED --add-opens java.desktop/javax.swing.plaf.basic=ALL-UNNAMED --add-opens jdk.jdi/com.sun.jdi=ALL-UNNAMED"if [ -z ${SLM_LICENSE_SERVER+x} ]; then# Obtaining a JProd floating licenseecho "1" | java ${JAVA_OPTS} -jar ${WORKING_FOLDER}/ready-api-license-manager-${LICENSE_MANAGER_VERSION}.jar -s ${LICENSE_SERVER};if [ $? != 0 ]; thenecho "6" | java ${JAVA_OPTS} -jar ${WORKING_FOLDER}/ready-api-license-manager-${LICENSE_MANAGER_VERSION}.jar -s ${LICENSE_SERVER};if [ $? != 0 ]; thenexit 101;fifielseecho "Using SLM licensing."# Run using SLM license serverif [ -z ${API_KEY+x} ]; thenecho "API_KEY value is not specified. SLM licensing won't work!"exit 101elseCOMMAND_LINE="${COMMAND_LINE} -K$API_KEY"fiif [[ ${SLM_LICENSE_SERVER,,} =~ ^(http.*)($|:([0-9]*)) ]]; thenSLM_HOST=${BASH_REMATCH[1]}PORT=${BASH_REMATCH[3]}COMMAND_LINE="${COMMAND_LINE} -DlicenseApiHost=${SLM_HOST}"if [ -n ${PORT+x} ]; thenCOMMAND_LINE="${COMMAND_LINE} -DlicenseApiPort=${PORT}"fiecho "Using SmartBear On-Premise License Manager."elseecho "Using SmartBear License Management."fifi# Copying the project with the dependenciesif [ -d "$MOUNTED_PROJECT_FOLDER" ]; thencp -a "$MOUNTED_PROJECT_FOLDER"/. "$PROJECT_FOLDER"fi# Copying the external librariesif [ -d "$MOUNTED_EXT_FOLDER" ]; thencp -a "$MOUNTED_EXT_FOLDER"/. "$READYAPI_FOLDER"/bin/extfi# Running the projectsed -i "s|COMMAND_LINE|$COMMAND_LINE|" "$WORKING_FOLDER"/RunProject.shsed -i "s|%project%|$PROJECT_FOLDER|g" "$WORKING_FOLDER"/RunProject.shsed -i "s|%reports%|$REPORTS_FOLDER|g" "$WORKING_FOLDER"/RunProject.shchmod 755 "$WORKING_FOLDER"/RunProject.sh"$WORKING_FOLDER"/RunProject.sh# Analyzing the exit codeexport EXIT_CODE=$?if [ $EXIT_CODE -eq 1 ]; thenexit 102fiif [ $EXIT_CODE != 0 ]; thenexit 103fiexit 0

rte4hirsiz · Answer

The issue with the database connection is local to the docker execution. Running without the image works fine. The project file requires&nbsp;my.jdbc.url but is not passed in this case, but works fine e.g. if I run command line using the testrunner.bat.&nbsp;docker run -t -d -u 2287:2287 --security-opt label=disable -v /etc/ca-trust:/etc/ca-trust:ro --device=/dev/fuse --ulimit=host -u root:root --entrypoint= -v=/var/lib/jenkins/workspace/job/dbextension:/ext -e SLM_LICENSE_SERVER=http://xx:1099 -e API_KEY=* -e 'COMMAND_LINE= -Dfile.encoding=UTF-8 -Gmy.jdbc.url=jdbc:mysql://remote-server:6446/databasename?user=username&amp;password=plainpassword222 -Gmy.jdbc.driver=com.mysql.cj.jdbc.Driver -f/var/lib/jenkins/workspace/job/soapui/reports soapui-project.xml -j -a -r "-sTestSuite Ping"' ....&nbsp;java.sql.SQLException: Access denied for user ''@'remote-server'&nbsp;ERROR: script returned exit code 103

Forum Discussion

ready-api-soapui-testrunner does not pass global properties

3 Replies

Recent Discussions

downgrade to lower ready api version 3.40.1 from latest

Changing environment in Jenkins mid-test

How to add same endpoints with different methods?

Related Content

ready-api-soapui-testrunner

http requests not properly handling global properties

Iterate throw global properties entries from Groovy script