9.4

Edit

SQC

Service overview

Software owner The Apache Software Foundation
Management

wfmanager (start | stop | restart | status) sqc
Log files

Access logs: <INSTALL_DIR>/supervisord/log/sqc.out.log
Error logs: <INSTALL_DIR>/supervisord/log/sqc.err.log
Startup scripts <INSTALL_DIR>/supervisord/apps/sqc.ini
<INSTALL_DIR>/sqc/bin/catalina.sh
Configuration files

General configuration: <INSTALL_DIR>/sqc/conf/
Startup parameters: <INSTALL_DIR>/sqc/bin/setenv.sh
Default Ports

tcp 4080

Default parameters

Configuration fileNameDefault valueDescription
config.ymlinstall_dir/opt/workfusionDirectory to put user files, logs and configs
config.ymlsqc_min_memory256MMinimum RAM is required for service
config.ymlsqc_max_memory512MMaximum RAM can be allocated per process
secrets.ymlsqc_db_usersqcDatabase username
secrets.ymlsqc_db_passg64twVZO@3Password for database username

Troubleshooting

  • Check if TCP port 4080 is available.

    Ports may be custom:

    netstat command output

    $ netstat -lntp | grep 4080
tcp6       0      0 127.0.0.1:4080          :::*                    LISTEN      726/java

    ss command output

    $ ss -ltn | grep 4080
LISTEN     0      100       ::ffff:127.0.0.1:4080                    :::*

    lsof command output

    $ lsof -P -n -i :4080 | grep LISTEN
java    726 wfuser   56u  IPv6  28806      0t0  TCP 127.0.0.1:4080 (LISTEN)

  • Check if the main services are available:

    workfusion/login

    $ curl https://app.example.com:8443/sqc-rest/
<html>
<body>
<h3>SQC Application has been successfully started!</h3>
</body>
</html>

    workfusion/login

    $ curl -sI https://app.example.com:8443/sqc-rest/
HTTP/1.1 200 
Date: Mon, 25 Jun 2018 15:18:03 GMT
Content-Type: text/html;charset=ISO-8859-1
Connection: keep-alive
Set-Cookie: JSESSIONID=E0EC98279F4AF1F6DA30157314B1F21D; Path=/sqc-rest; HttpOnly
Server: Workfusion
ALLOW-FROM: ec2-18-208-35-145.compute-1.amazonaws.com
X-Content-Type-Options: nosniff
Access-Control-Allow-Credentials: true
Access-Control-Allow-Headers: Content-Type,Accept
Access-Control-Allow-Methods: GET, POST, HEAD, PUT, DELETE
Pragma: no-cache
Strict-Transport-Security: max-age=31536000; includeSubdomains;T

    workfusion/public/HTMLRenderer

    $ curl http://localhost:4080/sqc-rest/
<html>
<body>
<h3>SQC Application has been successfully started!</h3>
</body>
</html>

    workfusion/public/HTMLRenderer

    $ curl -sI http://localhost:4080/sqc-rest/
HTTP/1.1 200 
Set-Cookie: JSESSIONID=F8295D3AAF62555004F78E163E84D6E0; Path=/sqc-rest; HttpOnly
Content-Type: text/html;charset=ISO-8859-1
Transfer-Encoding: chunked
Date: Mon, 25 Jun 2018 15:18:23 GMT

  • Check the default main log files:

    • Access logs: <INSTALL_DIR>/supervisord/log/sqc.out.log
    • Error logs: <INSTALL_DIR>/supervisord/log/sqc.err.log
    $ tail -f <INSTALL_DIR>/supervisord/log/sqc.err.log <INSTALL_DIR>/supervisord/log/sqc.out.log

  • Check the sqc out (access) log using the Wfmanager util.

    wfmanager tail sqc

  • Additional logs are stored inthe service's log directory:

    ${install_dir}/workfusion/logs

    catalina.<DATE>.log
gc.log
host-manager.<DATE>.log
localhost.<DATE>.log
localhost_access_log.<DATE>.txt
manager.<DATE>.log
sqc.log
sqc-rest.log

  • Check the permissions and full path access to the files accessed by sqc:

    $ ls -lah /opt/workfusion/sqc/webapps/sqc-rest/WEB-INF/web.xml
← PreviousNext →