zebrunner / community-edition Goto Github PK

BrowserStackLocal-.zip should be bundled as part of qps-infra nginx static content.
We might think about generating our own docker nginx container for that.

1. it speedup download, minimize number of external steps and allow to be integrated correctly from infra perspective under corporate network without internet access

let's collect under this ticket the most boring sonar claims which are not actual for qa automation.
based on this information rules will be adjusted

Have a look at 3.1/latest/demo https://hub.docker.com/r/qaprosoft/jenkins-master/tags/

zafira: 4.0.55
jenkins-master: 4.1
...

GitHub Plugin
https://wiki.jenkins.io/display/JENKINS/GitHub+Plugin

default Sonar instance in qps-infra should be configured for:

1. PR checker in carina-demo project
2. unit tests coverage for carina-demo
3. integration code coverage calculation for carina-demo

Hi all. I want to login to Zafira by default login and password (login = admin,password=changeit) but it shows me the message "Invalid credentials"

龙 猫, [21.07.19 11:54]
[In reply to Vad Del]
Dear Val Del,
nothing worked after i followed. however, i got the answer said that docker container encoding using POSIX. when i get into jenkins_slave container, using locale, encoding which was using showed POSIX, and POSIX doesn't supply Chinese, it should be replace with en_US.UTF-8. And in order to change it permanently, docker images should be made by Dockerfile, now I have fixed my problem by setting the encoding in my Dockerfile, and then used the new jenkins-slave images to replace the old.

龙 猫, [21.07.19 11:54]
[In reply to Vad Del]
So, there were still some questions, can you supply all the images's Dockerfile inqps-infra, some docker images encoding is still POSIX, which could be unfriendly to some language using. I need the Dockerfile to rebuild new images.And what Dockerfiles i found in docker hub were not complete.For example, nginx Dockerfile , redis Dockerfile, elasticsearch Dockerfile.

My linux server's system kernel is 3.10.0-957.21.3.el7.x86_64, docker's version is Docker version 18.09.7, build 2d0083d, docker-compose version is docker-compose version 1.24.1, build 4667896.
Steps:

1. git clone the repo(I cloned the repo on 2019/7/12)
2. using ./setup.sh mydomain.com
3. ./stop.sh
4. ./docker-compose rm -g
5. ./start.sh
6. I pulled all containers that I need
7. I logined in zafira using qpsdemo/qpsdemo
   Here is what I saw when I login:
   
   Can you do me a favour to solute this problems?

until we remove FTP as part of infra it is recommended to open 20 and 21 port to maintain both active and passive ftp modes.

in carina-core there is hard-coded ftp passive parameter until we open above ports.
https://github.com/qaprosoft/carina/issues/579

The idea is to use RabbitMQ as proxy layer for accessing of Jenkins instances if they're hidden under vpn (how it currently works for mfp web infra)
Flow is next:

1. External service publishes new run requests to RabbitMQ queue (with some unique ci_run_id)
2. Jenkins gets messages from the queue with some scheduling
3. Jenkins executes new run if there are valid requests in the queue and marks RabbitMQ message as acknowledged
4. After execution is done Jenkins publishes results into another queue; published message contains ci_run_id for identification of particular run.
   Note: Step 4 is needed to handle results of execution in external tools (e.g. some CI tool)

Going forward solution could be integrated with zafira. So there could be an option to queue new test run from Zafira for Jenkins which is hidden under vpn

In order to implement the solution I need 2 new RabbitMQ queues.
Names could something like ciRunsQueue and ciRunResultsQueue

To be able to automate completely deployment process we have to get latest db-data and db-structure sql files directly from zafira and push them into the container

Default nginx index.html page with static links and information about each resource and how it is used:
jenkins
zafira
sonarqube
rabbitmq
STF
etc

At the moment the qaprosoft docker image of sonarqube installs SonarQube ver.5.6.7.Is it possible to provide a qaprosoft image which builds SonarQube community ver.7.7 (that's the lataest one at the moment).

for details visit: https://github.com/qaprosoft/carina/issues/746

My OS system is centos, and I installed jenkins before, I used git clone to clone the repo, and setup.sh localhost ip to replace localhost, and start.sh to set up. I opened localhost ip in browser and jenkins page went wrong.

need folder created by default to be integrated with selenoid/ftp etc

the other way if folder wasn't previously created scanRepository won't succeed

selenoid-ui is pretty simple and useful servlet to track current status, view runtime logs and vnc sessions if any.
At the same time we can't expose it's http port to public. This component must be integrated as part of qps-infra under nginx WebServer

Docker-compose.yml file should be updated to start zafira in following way:

• zafira image version from 3.3.43 to 3.3.48 (current latest version)

Hi QAProsoft,

I see that the following job is no longer part of Management Jobs in Jenkins(latest version of QPS):
registerZafiraCredentials

Can you please return it back or if not - can you please confirm a workaround?

Thanks in advance!

Cheers,
Ivan

[BMP intergration]

[There are two possible ways to implement it]:

1. Embedded proxy (starts in code as Java object etc)
2. Rest proxy (starts as java process and all interactions are using REST requests)

Overview:
Embedded proxy works much more faster and lots of projects were integrated with enbedded one due to the performance issues with REST.

[LIMITATIONS]

1. There is no chance to automate process of proxy configuration on device (except of script which navigates using appium, it can be implemented in future I think):
   all existence sollutions are unstable (even for Android);
2. Devices are pre-configured (proxy is configured manually);
3. Devices have no access to the i-net due to stopped proxy;
4. Possible issues in case of lots devices are configured to one host (not sure here, there is an example with ~15 proxies and it works);
5. Separate pools of devices for proxy (not)based devices: since with proxy it works a bit slower than without.

[IMPLEMENTATION]

1. Core functionality to start/stop/configure proxy (partly implemented but I'm not sure it work in latest cores, but anyway it should be re-implemented);
2. Capabilities matcher to filter devices with/without proxy (it can be done a bit later);
3. Free port resolver: to stop processes in case port is in use;
4. ...
   

Hi

This is a request question. Wanted to find out if there is QAProSoft can build a starter image for Kubernetes.

OpenCV is needed for Appium's FindBy image

Team,

The Jira integration that we have now is read-only and doesn't support creating a task/issue from Zafira dashboard which could be a cool new addition to this project. The current implementation could only fetch the issue details if it's already created in Jira and tagged appropriately. It would be great if we were to create new issues/tasks from the Zafira Dashboard after a test suite is executed making the integration both read and write. This could help in assigning the issue/task to specific owner directly from Zafira rather than going through Jira again.

Thanks,
Abhishek Jayaraman

rabbitmq websocket requires extra open port. We have to move it under nginx umbrealle so everything is available via 443 or 80 ports only

all such operations in where clause:
created_at >= date_trunc('day', current_date)

can and should be replaced using
created_at >= current_date

Hi,

I get these errors in the posgres database logs while deploying

C:\Users\niles>docker logs 42206c7562fd
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....LOG: could not bind IPv6 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
LOG: database system was shut down at 2019-05-13 05:20:37 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: pg_cron scheduler started
done
server started
ALTER ROLE

CREATE EXTENSION

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

LOG: received fast shutdown request
LOG: aborting any active transactions
LOG: pg_cron scheduler shutting down
LOG: autovacuum launcher shutting down
LOG: shutting down
waiting for server to shut down....LOG: database system is shut down
done
server stopped

PostgreSQL init process complete; ready for start up.

LOG: database system was shut down at 2019-05-13 05:20:43 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: pg_cron scheduler started
LOG: autovacuum launcher started
LOG: database system was interrupted; last known up at 2019-05-13 05:20:44 UTC
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 0/1525370
LOG: invalid record length at 0/15270D8: wanted 24, got 0
LOG: redo done at 0/1525370
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: pg_cron scheduler started
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.NAME = $1

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.NAME = $1

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "monitors" does not exist at character 669
STATEMENT: SELECT
M.ID AS MONITOR_ID,
M.NAME AS MONITOR_NAME,
M.URL AS MONITOR_URL,
M.HTTP_METHOD AS MONITOR_HTTP_METHOD,
M.REQUEST_BODY AS MONITOR_REQUEST_BODY,
M.ENV AS MONITOR_ENVIRONMENT,
M.COMMENT AS MONITOR_COMMENT,
M.TAG AS MONITOR_TAG,
M.NOTIFICATIONS_ENABLED AS MONITOR_NOTIFICATIONS_ENABLED,
M.MONITOR_ENABLED AS MONITOR_MONITOR_ENABLED,
M.CRON_EXPRESSION AS MONITOR_CRON_EXPRESSION,
M.RECIPIENTS AS MONITOR_RECIPIENTS,
M.EXPECTED_CODE AS MONITOR_EXPECTED_CODE,
M.SUCCESS AS MONITOR_SUCCESS,
M.TYPE AS MONITOR_TYPE,
M.CREATED_AT AS MONITOR_CREATED_AT,
M.MODIFIED_AT AS MONITOR_MODIFIED_AT
FROM
MONITORS M
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.NAME = $1

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

                            WHERE S.TOOL = $1
                            ORDER BY S.NAME ASC

ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:
ERROR: relation "settings" does not exist at character 319
STATEMENT: SELECT
S.ID AS SETTING_ID,
S.NAME AS SETTING_NAME,
S.VALUE AS SETTING_VALUE,
S.IS_ENCRYPTED AS SETTING_IS_ENCRYPTED,
S.TOOL AS SETTING_TOOL,
S.FILE AS SETTING_FILE,
S.MODIFIED_AT AS SETTING_MODIFIED_AT,
S.CREATED_AT AS SETTING_CREATED_AT
FROM
SETTINGS S

1. analyze device status using STF
2. for disconnected/offline etc device do docker restart until device is available.
3. Let's try restart 2-3 times before sending notification etc

simple cron on the machine where devices are connected should be configured

Test results transfer to test rail speed down meaningfully tests execution. It takes about 7-10 mins to transfer 100 results. Could we somehow improve this flow? Maybe we can perform it asynchronously?

Currently using:

pull required docker images
docker pull selenoid/vnc:chrome_73.0
docker pull selenoid/vnc:firefox_66.0

Latest versions at the moment:
chrome_77.0
firefox_69.0

we lost browsermob support for the tests running in selenoid

Most important to select ANY with Android version >= 5.1.1 or >=6.0
To configure it on suite level and probably in jenkins.

-Dci_user_id=admin -Dci_user_first_name=null -Dci_user_last_name=null -Dci_user_email=null
to register in demo mode correct values we have to declare "admin" user with name, last name, email etc

After starting qps-infra elk container doesn't work as expected. As a hotfix we should:

1. run any test
2. restart elk

so need a way to determine valid solution to register exchange in rabbitmq right after startup. It should resolve elk issue

Steps:

1. git clone the repo
   2.execute ./setup.sh
   3.execute ./start.sh
   4.use test launcher in zafira to create job in jenkins
   5.run web-demo-test provided in carina-demo
   6.connect to rabbitMQ timeout and connect to selenium session timeout.
   Here is the result pic as rabbitMQ and selenium-hub container logs:

selenoid and selenoid-ui should be used by default in qps-infra for executing web automation tests.
https://github.com/aerokube/selenoid

appropriate changes should be applied to docker composer file

formalize instructions for optimizing performance creating ramdisks and swap partitions

swap on linux:
https://www.photographerstechsupport.com/tutorials/adding-swap-space-ec2-amazon-linux-instance/

Hi,
I forked git repo to https://github.com/learnappium/qps-infra
i followed steps given in the readme
i changed variables : hostname, username and password and ran docker compose.

• zafira site is opened but not able to login with same username and passsword i given in variable
• Not able to access jenkins

i check docker compose log and i am getting below errer

zafira-batch_1       | jvm 1    | 11:15:09.972 [WrapperSimpleAppMain] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Creating instance of bean 'org.springframework.context.event.internalEventListenerFactory'
jenkins-slave-api_1  | Feb 14, 2019 11:15:10 AM hudson.plugins.swarm.Client run
jenkins-slave-api_1  | SEVERE: IOexception occurred
jenkins-slave-api_1  | java.net.ConnectException: Connection refused (Connection refused)
jenkins-slave-api_1  | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
jenkins-slave-api_1  | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
jenkins-slave-api_1  | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
jenkins-slave-api_1  | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
jenkins-slave-api_1  | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
jenkins-slave-api_1  | 	at java.net.Socket.connect(Socket.java:589)
jenkins-slave-api_1  | 	at java.net.Socket.connect(Socket.java:538)
jenkins-slave-api_1  | 	at java.net.Socket.<init>(Socket.java:434)
jenkins-slave-api_1  | 	at java.net.Socket.<init>(Socket.java:286)
jenkins-slave-api_1  | 	at shaded.org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:87)
jenkins-slave-api_1  | 	at shaded.org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:129)
jenkins-slave-api_1  | 	at shaded.org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:714)
jenkins-slave-api_1  | 	at shaded.org.apache.commons.httpclie



zafira-batch_1       | jvm 1    | 09:35:29.686 [C3P0PooledConnectionPoolManager[identityToken->1bqrg26a01tasdu810e01mn|34f9aed7]-HelperThread-#1] DEBUG c.m.v.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
zafira-batch_1       | jvm 1    | org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
zafira-batch_1       | jvm 1    | 	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:463) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:203) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.Driver.makeConnection(Driver.java:454) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.Driver.connect(Driver.java:256) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) ~[c3p0-0.9.5.2.jar:0.9.5.2]
zafira-batch_1       | jvm 1    | 	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) [mchange-commons-java-0.2.11.jar:0.2.11]
zafira-batch_1       | jvm 1    | 09:35:29.694 [C3P0PooledConnectionPoolManager[identityToken->1bqrg26a01tasdu810e01mn|34f9aed7]-HelperThread-#1] DEBUG c.m.v.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
zafira-batch_1       | jvm 1    | org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
zafira-batch_1       | jvm 1    | 	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:463) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:203) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.Driver.makeConnection(Driver.java:454) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at org.postgresql.Driver.connect(Driver.java:256) ~[postgresql-42.2.4.jar:42.2.4]
zafira-batch_1       | jvm 1    | 	at com.m

please point me where i am missing

need implement much more flexible infrastructure for creating and running jobs

GGR+Selenoid must be used by default as part of infrastructure.

in 3.7 qps-pipeline we declared unified /tmp/.m2/repository as central maven location for each slaves (containerized or not). So it would be nice to share those new locations across slave containers to have similar .m2 on master and other hosts

it was discovered that PUBLICHOST by default is not provided to required FTP conatainer.
As result remote artifacts uploading doesn't work

When job was aborted or failed by time out, a lot of people get report. I think better to set aborted report and etc report for owner job and jenkins admin.

A lot of changes are planned in 4.8 pipeline and 4.2 zafira for launchers and capabilities transfer.

New approach should thoroughly tested.

In some cases it's needed to pass multiline parameter into Jenkins job using dsl.
For instance job scheduling with timezone:
TZ=US/Eastern
H 9-19 * * 1-5

As a user I'd like to have ability to pass param in suite as

to get in properly parsed for Jenkins

see charles proxy for example

3.2 hib supports mobile web execution tests (chrome, safari and native android browser)

by default it should use let's say public smtp creds or even smtp server w/o credentials.
Ideally email notification should work right after install. Make sure to apply security if possible if any account creds are used

and change font a little bit according to the prototype