Issue: The password contains a character ( [ or $ ) can mess up the subsequent hammerdbcli vurun command.

[joshuajin]

Issue: The password contains a character ( [ or $ ) can mess up the subsequent hammerdbcli vurun command.
background: I use hammerdbcli to trigger a build schema with 20 warehouses, 20 vus from a AWS Lambda function. If I use a simple password, the code works well. However, if I used AWS Secret Manager to create and auto rotate the SQL Server password, the generated password can contain any of the special characters including [, $, &, which may cause problems for tcl or hammerdbcli command.

As an example, the following password contains a left open bracket ([) in the middle:
=U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2

Since the character [ has special meaning in tcl, we tried to escape it using a backslash. After insert a backslash in front of the [, now the password becomes the following:
=U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2
However the subsequent vurun command is still looking for the closing bracket, see below execution log.

2022-04-28T14:41:34.546-07:00 HammerDB CLI v4.4
2022-04-28T14:41:34.546-07:00 Copyright (C) 2003-2022 Steve Shaw
2022-04-28T14:41:34.546-07:00 Type "help" for a list of commands
2022-04-28T14:41:34.704-07:00 The xml is well-formed, applying configuration
2022-04-28T14:41:34.744-07:00 Database set to MSSQLServer
2022-04-28T14:41:34.746-07:00 Benchmark set to TPC-C for MSSQLServer
2022-04-28T14:41:34.747-07:00 Changed connection:mssqls_server from (local) to xxxx-sql-maz.c8olvignaohq.us-west-2.rds.amazonaws.com for MSSQLServer
2022-04-28T14:41:34.748-07:00 Changed connection:mssqls_linux_server from localhost to am-sql-maz.c8olvignaohq.us-west-2.rds.amazonaws.com for MSSQLServer
2022-04-28T14:41:34.749-07:00 Changed connection:mssqls_uid from sa to myfakeuser for MSSQLServer
2022-04-28T14:41:34.750-07:00 Changed connection:mssqls_pass from admin to =U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2 for MSSQLServer
2022-04-28T14:41:34.752-07:00 Value tpcc for tpcc:mssqls_dbase is the same as existing value tpcc, no change made
2022-04-28T14:41:34.753-07:00 Changed tpcc:mssqls_count_ware from 1 to 20 for MSSQLServer
2022-04-28T14:41:34.754-07:00 Changed tpcc:mssqls_num_vu from 1 to 20 for MSSQLServer
2022-04-28T14:41:34.755-07:00 Script cleared
2022-04-28T14:41:34.756-07:00 Building 20 Warehouses with 21 Virtual Users, 20 active + 1 Monitor VU(dict value mssqls_num_vu is set to 20)
2022-04-28T14:41:34.758-07:00 Ready to create a 20 Warehouse MS SQL Server TPROC-C schema
2022-04-28T14:41:34.758-07:00 in host AM-SQL-MAZ.C8OLVIGNAOHQ.US-WEST-2.RDS.AMAZONAWS.COM in database TPCC?
2022-04-28T14:41:34.759-07:00 Enter yes or no: replied yes
2022-04-28T14:41:34.808-07:00 Vuser 1 created - WAIT IDLE
2022-04-28T14:41:34.811-07:00 Vuser 2 created - WAIT IDLE
2022-04-28T14:41:34.812-07:00 Vuser 3 created - WAIT IDLE
2022-04-28T14:41:34.814-07:00 Vuser 4 created - WAIT IDLE
2022-04-28T14:41:34.814-07:00 Vuser 5 created - WAIT IDLE
2022-04-28T14:41:34.815-07:00 Vuser 6 created - WAIT IDLE
...
2022-04-28T14:41:34.834-07:00 Vuser 21 created - WAIT IDLE
2022-04-28T14:41:34.838-07:00 Vuser 1:RUNNING
2022-04-28T14:41:34.859-07:00 Error in Virtual User 1: missing close-bracket
2022-04-28T14:41:34.860-07:00 Vuser 1:FINISHED FAILED
2022-04-28T14:41:35.339-07:00 Vuser 2:RUNNING
2022-04-28T14:41:35.350-07:00 Error in Virtual User 2: missing close-bracket
2022-04-28T14:41:35.351-07:00 Vuser 2:FINISHED FAILED
2022-04-28T14:41:35.839-07:00 Vuser 3:RUNNING
2022-04-28T14:41:35.850-07:00 Error in Virtual User 3: missing close-bracket
2022-04-28T14:41:35.851-07:00 Vuser 3:FINISHED FAILED
2022-04-28T14:41:36.340-07:00 Vuser 4:RUNNING
...
2022-04-28T14:41:44.867-07:00 Error in Virtual User 21: missing close-bracket
2022-04-28T14:41:44.868-07:00 Vuser 21:FINISHED FAILED
2022-04-28T14:41:44.869-07:00 ALL VIRTUAL USERS COMPLETE
2022-04-28T14:41:45.354-07:00 waittocomplete called script exit
2022-04-28T14:41:45.366-07:00 END RequestId: 26340410-1d88-47dd-b03d-5678e5951e95
2022-04-28T14:41:45.366-07:00 REPORT RequestId: 26340410-1d88-47dd-b03d-5678e5951e95 Duration: 11074.13 ms Billed Duration: 11075 ms Memory Size: 10240 MB Max Memory Used: 128 MB Init Duration: 335.53 ms

Where did I do wrong, and what is the best way to fix it?

Thank you in advance.
Joshua J

[sm-shaw]

Wrap your password with special characters in the following:
{[ concat {} ]}

An example is below:

hammerdb>diset connection mssqls_pass {[ concat {=U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2} ]}
Changed connection:mssqls_pass from =U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2 to [ concat {=U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2} ] for MSSQLServer

hammerdb>

Copyright (C) 2003-2022 Steve Shaw
Type "help" for a list of commands
hammerdb>dbset db mssqls
Database set to MSSQLServer

hammerdb>print dict
Dictionary Settings for MSSQLServer
connection {
 mssqls_server         = (local)\SQLEXPRESS
 mssqls_linux_server   = localhost
 mssqls_tcp            = false
 mssqls_port           = 1433
 mssqls_azure          = false
 mssqls_authentication = sql
 mssqls_linux_authent  = sql
 mssqls_odbc_driver    = ODBC Driver 17 for SQL Server
 mssqls_linux_odbc     = ODBC Driver 17 for SQL Server
 mssqls_uid            = sqluser01
 mssqls_pass           = [ concat {=U#r>Y^O~&RcE:x5:DO[*y5<(a&AH9r2} ]
}
tpcc       {
 mssqls_count_ware       = 10
 mssqls_num_vu           = 4
 mssqls_dbase            = tpcc
 mssqls_imdb             = false
 mssqls_bucket           = 1
 mssqls_durability       = SCHEMA_AND_DATA
 mssqls_total_iterations = 10000000
 mssqls_raiseerror       = false
 mssqls_keyandthink      = false
 mssqls_checkpoint       = false
 mssqls_driver           = timed
 mssqls_rampup           = 1
 mssqls_duration         = 2
 mssqls_allwarehouse     = false
 mssqls_timeprofile      = true
 mssqls_async_scale      = false
 mssqls_async_client     = 10
 mssqls_async_verbose    = false
 mssqls_async_delay      = 1000
 mssqls_connect_pool     = false
}

hammerdb>

hammerdb>loadscript
Script loaded, Type "print script" to view

hammerdb>vuset vu 2

hammerdb>vucreate
Vuser 1 created MONITOR - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
3 Virtual Users Created with Monitor VU

hammerdb>vurun
Vuser 1:RUNNING
Vuser 1:Initializing xtprof time profiler
Vuser 1:Beginning rampup time of 1 minutes
Vuser 2:RUNNING
Vuser 2:Initializing xtprof time profiler
Vuser 2:Processing 10000000 transactions with output suppressed...
Vuser 3:RUNNING
Vuser 3:Initializing xtprof time profiler
Vuser 3:Processing 10000000 transactions with output suppressed...

hammerdb>Vuser 1:Rampup 1 minutes complete ...
Vuser 1:Rampup complete, Taking start Transaction Count.
Vuser 1:Timing test period of 2 in minutes
Vuser 1:1 ...,
Vuser 1:2 ...,
Vuser 1:Test complete, Taking end Transaction Count.
Vuser 1:2 Active Virtual Users configured
Vuser 1:TEST RESULT : System achieved 58295 NOPM from 134047 SQL Server TPM
Vuser 1:Gathering timing data from Active Virtual Users...
Vuser 2:FINISHED SUCCESS
Vuser 3:FINISHED SUCCESS
Vuser 1:Calculating timings...
Vuser 1:Writing timing data to C:/Users/smsha/AppData/Local/Temp/hdbxtprofile.log
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE

In the GUI do as follows:

[joshuajin]

Wrapping the password with special characters in the following: {[ concat {} ]} works now. Thanks Steve.