Apr 30,2022 16:34:23 ⟥ Module sanity user password This test will download clickhouse packages, install, verify server starts and confirm password is accepted Apr 30,2022 16:34:23 ⟥ Test I install ClickHouse and configure a user password 2ms [bash] root@runner-geypzd4-project-22089296-concurrent-0:/builds/altinity-qa/clickhouse/cicd/release# export PS1="bash# " 3ms [bash] bash# dpkg -i clickhouse* 27ms [bash] Selecting previously unselected package clickhouse-client. 33ms [bash] (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 23373 files and directories currently installed.) 33ms [bash] Preparing to unpack clickhouse-client_21.8.15.15.altinitystable_all.deb ... 40ms [bash] Unpacking clickhouse-client (21.8.15.15.altinitystable) ... 82ms [bash] Selecting previously unselected package clickhouse-common-static-dbg. 87ms [bash] Preparing to unpack clickhouse-common-static-dbg_21.8.15.15.altinitystable_amd64.deb ... 94ms [bash] Unpacking clickhouse-common-static-dbg (21.8.15.15.altinitystable) ... 2s 839ms [bash] Selecting previously unselected package clickhouse-common-static. 2s 840ms [bash] Preparing to unpack clickhouse-common-static_21.8.15.15.altinitystable_amd64.deb ... 2s 846ms [bash] Unpacking clickhouse-common-static (21.8.15.15.altinitystable) ... 4s 774ms [bash] dpkg-deb: error: 'clickhouse-driver.py' is not a Debian format archive 4s 774ms [bash] dpkg: error processing archive clickhouse-driver.py (--install): 4s 774ms [bash] dpkg-deb --control subprocess returned error exit status 2 4s 775ms [bash] dpkg-deb: error: 'clickhouse-jdbc.py' is not a Debian format archive 4s 775ms [bash] dpkg: error processing archive clickhouse-jdbc.py (--install): 4s 775ms [bash] dpkg-deb --control subprocess returned error exit status 2 4s 805ms [bash] Selecting previously unselected package clickhouse-server. 4s 806ms [bash] Preparing to unpack clickhouse-server_21.8.15.15.altinitystable_all.deb ... 4s 820ms [bash] Unpacking clickhouse-server (21.8.15.15.altinitystable) ... 4s 876ms [bash] dpkg-deb: error: 'clickhouse-sqlalchemy.py' is not a Debian format archive 4s 876ms [bash] dpkg: error processing archive clickhouse-sqlalchemy.py (--install): 4s 877ms [bash] dpkg-deb --control subprocess returned error exit status 2 4s 904ms [bash] Selecting previously unselected package clickhouse-test. 4s 909ms [bash] Preparing to unpack clickhouse-test_21.8.15.15.altinitystable_all.deb ... 4s 917ms [bash] Unpacking clickhouse-test (21.8.15.15.altinitystable) ... 5s 323ms [bash] Setting up clickhouse-common-static-dbg (21.8.15.15.altinitystable) ... 5s 344ms [bash] Setting up clickhouse-common-static (21.8.15.15.altinitystable) ... 5s 364ms [bash] Setting up clickhouse-server (21.8.15.15.altinitystable) ... 5s 478ms [bash] debconf: unable to initialize frontend: Dialog 5s 478ms [bash] debconf: (TERM is not set, so the dialog frontend is not usable.) 5s 479ms [bash] debconf: falling back to frontend: Readline 5s 488ms [bash] ClickHouse binary is already located at /usr/bin/clickhouse 5s 488ms [bash] Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 488ms [bash] Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. 5s 488ms [bash] Symlink /usr/bin/clickhouse-client already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 488ms [bash] Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-local already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-benchmark already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-copier already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-copier to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-obfuscator already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-compressor already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-format already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. 5s 489ms [bash] Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. 5s 489ms [bash] Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. 5s 489ms [bash] Creating clickhouse group if it does not exist. 5s 489ms [bash] groupadd -r clickhouse 5s 513ms [bash] Creating clickhouse user if it does not exist. 5s 513ms [bash] useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse 5s 564ms [bash] Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. 5s 567ms [bash] Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. 5s 568ms [bash] Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. 5s 568ms [bash] Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. 5s 573ms [bash] /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. 5s 573ms [bash] /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. 5s 573ms [bash] Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. 5s 574ms [bash] Creating log directory /var/log/clickhouse-server/. 5s 574ms [bash] Creating data directory /var/lib/clickhouse/. 5s 574ms [bash] Creating pid directory /var/run/clickhouse-server. 5s 574ms [bash] chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' 5s 575ms [bash] chown -R clickhouse:clickhouse '/var/run/clickhouse-server' 5s 576ms [bash] chown clickhouse:clickhouse '/var/lib/clickhouse/' 5s 577ms [bash] groupadd -r clickhouse-bridge 5s 596ms [bash] useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge 5s 626ms [bash] chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' 5s 630ms [bash] chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' 5s 635ms ⟥⟤ OK I install ClickHouse and configure a user password, /sanity user password/I install ClickHouse and configure a user password Apr 30,2022 16:34:29 ⟥ Test I start clickhouse server 1ms [bash] 2ms [bash] clickhouse start 2ms [bash] Password for default user is saved in file /etc/clickhouse-server/users.d/default-password.xml. 3ms [bash] Setting capabilities for clickhouse binary. This is optional. 4ms [bash] Cannot set 'net_admin' or 'ipc_lock' or 'sys_nice' capability for clickhouse binary. This is optional. Taskstats accounting will be disabled. To enable taskstats accounting you may add the required capability later manually. 5ms [bash] chown -R clickhouse:clickhouse '/etc/clickhouse-server' 9ms [bash] 9ms [bash] ClickHouse has been successfully installed. 9ms [bash] 9ms [bash] Start clickhouse-server with: 9ms [bash] sudo clickhouse start 10ms [bash] 10ms [bash] Start clickhouse-client with: 10ms [bash] clickhouse-client --password 10ms [bash] 33ms [bash] dpkg: dependency problems prevent configuration of clickhouse-test: 34ms [bash] clickhouse-test depends on expect; however: 34ms [bash] Package expect is not installed. 34ms [bash] clickhouse-test depends on python3-lxml; however: 34ms [bash] Package python3-lxml is not installed. 34ms [bash] clickhouse-test depends on python3-termcolor; however: 34ms [bash] Package python3-termcolor is not installed. 34ms [bash] clickhouse-test depends on python3-requests; however: 35ms [bash] Package python3-requests is not installed. 35ms [bash] clickhouse-test depends on sudo; however: 35ms [bash] Package sudo is not installed. 35ms [bash] clickhouse-test depends on netcat-openbsd; however: 35ms [bash] Package netcat-openbsd is not installed. 35ms [bash] clickhouse-test depends on telnet; however: 35ms [bash] Package telnet is not installed. 35ms [bash] clickhouse-test depends on brotli; however: 35ms [bash] Package brotli is not installed. 35ms [bash] 36ms [bash] dpkg: error processing package clickhouse-test (--install): 36ms [bash] dependency problems - leaving unconfigured 36ms [bash] Setting up clickhouse-client (21.8.15.15.altinitystable) ... 98ms [bash] Errors were encountered while processing: 101ms [bash] clickhouse-driver.py 101ms [bash] clickhouse-jdbc.py 101ms [bash] clickhouse-sqlalchemy.py 101ms [bash] clickhouse-test 103ms [bash] bash# chown -R clickhouse: '/var/run/clickhouse-server/' 104ms [bash] Will run su -s /bin/sh 'clickhouse' -c '/usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon' 115ms [bash] Waiting for server to start 1s 116ms [bash] Waiting for server to start 1s 116ms ⟥⟤ OK I start clickhouse server, /sanity user password/I start clickhouse server Apr 30,2022 16:34:30 ⟥ Test I verify wrong password is not working 1ms [bash] 2ms [bash] clickhouse-client --password WRONG_PASSWORD -q 'SELECT 1' 20ms ⟥⟤ OK I verify wrong password is not working, /sanity user password/I verify wrong password is not working Apr 30,2022 16:34:30 ⟥ Test I verify query result is expected 294us [bash] or there is no user with such name. 321us [bash] 522us ⟥⟤ OK I verify query result is expected, /sanity user password/I verify query result is expected 6ms [bash] clickhouse-client --password {password} -q 'SELECT 1 6s 791ms ⟥⟤ OK sanity user password, /sanity user password Passing ✔ [ OK ] /sanity user password/I install ClickHouse and configure a user password ✔ [ OK ] /sanity user password/I start clickhouse server ✔ [ OK ] /sanity user password/I verify wrong password is not working ✔ [ OK ] /sanity user password/I verify query result is expected ✔ [ OK ] /sanity user password 1 module (1 ok) 4 tests (4 ok) Total time 6s 791ms Executed on Apr 30,2022 16:34 TestFlows.com Open-Source Software Testing Framework v1.8.220312.1230154