8c146fbbcadb   haproxy:1.7             "docker-entrypoint.s…"   19 minutes ago              rabbitmq-cluster-docker-master-haproxy-1                            7a58702c1c56   rabbitmq:3-management   "/usr/local/bin/clus…"   19 minutes ago              rabbitmq-cluster-docker-master-rabbitmq2-1                          74b97f9f59e1   rabbitmq:3-management   "/usr/local/bin/clus…"   19 minutes ago              rabbitmq-cluster-docker-master-rabbitmq3-1                          2c14cac232f9   rabbitmq:3-management   "/usr/local/bin/clus…"   19 minutes ago              rabbitmq-cluster-docker-master-rabbitmq1-1                          admin@i-0afad6e3069679be1:~/rabbitmq-cluster-docker-master$ docker rm rabbitmq-crabbitmq-cluster-docker-master-haproxy-1    rabbitmq-cluster-docker-master-rabbier-master-rabbitmq2-1  rabbitmq-cluster-docker-master-rabbitmq3-1               admin@i-0afad6e3069679be1:~/rabbitmq-cluster-docker-master$ docker rm rabbitmq-crabbitmq-cluster-docker-master-haproxy-1    rabbitmq-cluster-docker-master-rabbier-master-rabbitmq2-1  rabbitmq-cluster-docker-master-rabbitmq3-1               admin@i-0afad6e3069679be1:~/rabbitmq-cluster-docker-master$ docker rm rabbitmq-c

admin@i-02f70d027c2794807:~/clmystery$ cd mystery/                              admin@i-02f70d027c2794807:~/clmystery/mystery$ grep "CLUE" .*                   grep: .: Is a directory                                                         grep: ..: Is a directory                                                        admin@i-02f70d027c2794807:~/clmystery/mystery$ grep "CLUE"                      crimescene   interviews/  memberships/ people       streets/     vehicles       admin@i-02f70d027c2794807:~/clmystery/mystery$ grep "CLUE" crimescene           CLUE: Footage from an ATM security camera is blurry but shows that the perpetrat 6'.                                                                            CLUE: Found a wallet believed to belong to the killer: no ID, just loose change,otary_Club, Delta SkyMiles, the local library, and the Museum of Bash History. Teable and have no name, for some reason.                                        CLUE: Questioned the barista at the local coffee shop. He said a woman left rights. The name on her latte was Annabel, she had blond spiky hair and a New Zealanadmin@i-02f70d027c2794807:~/clmystery/mystery$ ls pe                            

admin@i-072d9ea3aa14603ae:~$ sql                                                sqldiff  sqlite3                                                                admin@i-072d9ea3aa14603ae:~$ sqlite3                                            SQLite version 3.34.1 2021-01-20 14:10:07                                       Enter ".help" for usage hints.                                                  Connected to a transient in-memory database.                                    Use ".open FILENAME" to reopen on a persistent database.                        sqlite> .mode csv                                                               sqlite> .import table_tableau11.csv tt                                          table_tableau11.csv:101: expected 13 columns but found 12 - filling the rest witsqlite> describe tt;                                                            Error: near "describe": syntax error                                            sqlite> describe table tt;                                                      Error: near "describe": syntax error                                            sqlite> . tt;                                                                   

 ✔ Container rabbitmq-cluster-docker-master-haproxy-1    Removed                 ✔ Container rabbitmq-cluster-docker-master-rabbitmq3-1  Removed                 ✔ Container rabbitmq-cluster-docker-master-rabbitmq2-1  Removed                 ✔ Container rabbitmq-cluster-docker-master-rabbitmq1-1  Removed                 ✔ Network rabbitmq-cluster-docker-master_default        Removed                admin@i-0963eaf70c751a286:~/rabbitmq-cluster-docker-master$ less ~/consumer.py  admin@i-0963eaf70c751a286:~/rabbitmq-cluster-docker-master$ nano cluster-entrypoadmin@i-0963eaf70c751a286:~/rabbitmq-cluster-docker-master$ docker compose up -d[+] Running 5/5                                                                  ✔ Network rabbitmq-cluster-docker-master_default        Created                 ✔ Container rabbitmq-cluster-docker-master-rabbitmq1-1  Started                 ✔ Container rabbitmq-cluster-docker-master-rabbitmq3-1  Started                 ✔ Container rabbitmq-cluster-docker-master-rabbitmq2-1  Started                 ✔ Container rabbitmq-cluster-docker-master-haproxy-1    Started                (reverse-i-search)`log': docker compose logs -f                                 

admin@i-0b981fce34aa8f4b2:~$ grep CLUE -R .                                     ./clmystery/hint2:      grep "CLUE" crimescene                                  ./clmystery/instructions:Fortunately the sergeant went through and marked the reLUE" in all caps.                                                               ./clmystery/mystery/crimescene:CLUE: Footage from an ATM security camera is blurpetrator is a tall male, at least 6'.                                           ./clmystery/mystery/crimescene:CLUE: Found a wallet believed to belong to the kihange, and membership cards for Rotary_Club, Delta SkyMiles, the local library, story. The cards are totally untraceable and have no name, for some reason.     ./clmystery/mystery/crimescene:CLUE: Questioned the barista at the local coffee t right before they heard the shots. The name on her latte was Annabel, she had w Zealand accent.                                                               ./.bash_history:grep CLUE -R .                                                  ./.bash_history:grep CLUE -R .                                                  admin@i-0b981fce34aa8f4b2:~$                                                    

admin@i-096627dffdf2bae46:~/clmystery$ cat hint2                                Try using grep to search for the clues in the crimescene file:                                                                                                          grep "CLUE" crimescene                                                  admin@i-096627dffdf2bae46:~/clmystery$ cat hint3                                In order to track down our potential witness, we need to figure out where she li                                                                                Try using 'head' on some of the files like 'people' and 'vehicles' and see whereadmin@i-096627dffdf2bae46:~/clmystery$ cat hint4                                To find all the Annabels' addresses, use the 'people' file:                                                                                                             grep "Annabel" people                                                                                                                                   Notice that not all of the results are worth investigating.  Remember what we knadmin@i-096627dffdf2bae46:~/clmystery$                                          

Saint-Hyacinthe--Bagot,99629,1214                                               Saint-Jean,108244,1231                                                          Saint-Laurent,93842,409                                                         mlr: Header/data length mismatch (13 != 12) at file "table_tableau11.ed.csv" linadmin@i-0d2aba6cf373f3c66:~$ vi table_tableau11.ed.csv                          admin@i-0d2aba6cf373f3c66:~$ run                                                run-parts  runc       runcon     runlevel   runuser                             admin@i-0d2aba6cf373f3c66:~$ run^C                                              admin@i-0d2aba6cf373f3c66:~$ head -n 1 table_tableau11.ed.csv                   Province,District_Name,Electoral District Number/Numéro de circonscription,Popu,Polling Stations/Bureaux de scrutin,Valid Ballots/Bulletins valides,Percentage tage des bulletins valides,Rejected_Ballots,Percentage of Rejected Ballots /Pouretés,Total Ballots Cast/Total des bulletins déposés,Percentage of Voter Turnout/pation électorale,Elected Candidate/Candidat élu                                admin@i-0d2aba6cf373f3c66:~$ cut -f ","                                         

tire housewife rustproofing breeders outings                                    handballs sweetest digit lipread breast                                         rupee tromped servile hobs finalizing swattered                                 savored indorsing starred eruditely leopard                                     allergens disingenuous duvet spiffiest                                          dragonfly ghost hafts quarries austerer sudsier outdoors                        anneals embezzling eventually biopsy unearthly lastingly                        stutters illuminations pompons lax banjoists                                    duped dishonest winsomely boggled ferrule pirates                               slowing stoppers tomahawks rendezvous                                           graving serviettes libidinous                                                   feasting arrival raiding bogus                                                  virility karat governments dressings                                            defeatists rearranged insureds kills huh raggedly shoeshines                    "Haley_Street" 300L, 14145B                                                     

The officers on the scene are pretty meticulous, so they've written down EVERYTHrts.                                                                                                                                                            Fortunately the sergeant went through and marked the real clues with the word "C                                                                                If you get stuck, open one of the hint files (from the CL, type 'cat hint1', 'ca                                                                                To check your answer or find out the solution, open the file 'solution' (from th).                                                                                                                                                              To get started on how to use the command line, open cheatsheet.md or cheatsheet.e, you can type 'nano cheatsheet.md').                                                                                                                          Don't use a text editor to view any files except these instructions, the cheatshadmin@i-07083d572eac83dbb:~/clmystery$ ca                                       

untraceable and have no name, for some reason.                                  CLUE: Questioned the barista at the local coffee shop. He said a woman left righshots. The name on her latte was Annabel, she had blond spiky hair and a New Zeaadmin@i-0ab9e9adb4a3987fa:~$ head /home/admin/clmystery/mystery/vehicles        ***************                                                                 Vehicle and owner information from the Terminal City Department of Motor Vehicle***************                                                                                                                                                 License Plate T3YUHF6                                                           Make: Toyota                                                                    Color: Yellow                                                                   Owner: Jianbo Megannem                                                          Height: 5'6"                                                                    Weight: 246 lbs                                                                 admin@i-0ab9e9adb4a3987fa:~$ ls -l /home/admin/clmystery/mystery/st             

     6 interviews/interview-9728756                                                  8 interviews/interview-97393699                                                12 interviews/interview-97409610                                                 6 interviews/interview-980963                                                   5 interviews/interview-982013                                                  10 interviews/interview-9824821                                                  9 interviews/interview-98912259                                                 8 interviews/interview-9901455                                                  9 interviews/interview-9912172                                                  6 interviews/interview-992072                                                   7 interviews/interview-99643550                                                 7 interviews/interview-9969223                                                  7 interviews/interview-999372                                                3473 total                                                                    admin@i-0cbddbf1cf13da45d:~/clmystery/mystery$ ls streets/Stough                

Matt Waite                                                                      Tomasz Lanzone                                                                  Dirk Steuer                                                                     Lukasz Dudas                                                                    Virginie Medina                                                                 Andriy Hrachov                                                                  Ziwei Braas                                                                     Hector Moutoussamy                                                              Xiaodong Dulko                                                                  Ivan Radu                                                                       Christopher Sadauskas                                                           Lizeth Coertzen                                                                 Alexander Heffernan                                                             admin@i-0af46ab65051b8940:~/clmystery/mystery$ awk '{print $1,$2}' people  > namadmin@i-0af46ab65051b8940:~/clmystery/mystery$                                  

Hector Moutoussamy      M       66      Muller Avenue, line 110                 Xiaodong Dulko  F       69      Homewood Road, line 242                         Ivan Radu       M       29      Clinton Place, line 181                         Christopher Sadauskas   M       86      Lancaster Street, line 47               Lizeth Coertzen F       58      Greenock Street, line 402                       Alexander Heffernan     M       43      Oleander Street, line 147               admin@i-0b0f06229bc510ff9:~/clmystery/mystery$ grep CLUE crimescene             CLUE: Footage from an ATM security camera is blurry but shows that the perpetratt 6'.                                                                           CLUE: Found a wallet believed to belong to the killer: no ID, just loose change,Rotary_Club, Delta SkyMiles, the local library, and the Museum of Bash History. aceable and have no name, for some reason.                                      CLUE: Questioned the barista at the local coffee shop. He said a woman left righots. The name on her latte was Annabel, she had blond spiky hair and a New Zealaadmin@i-0b0f06229bc510ff9:~/clmystery/mystery$ grep CLUE crimescene             

admin@i-092d2fd9d0279fb15:~$ ls                                                 agent  clmystery  mysolution                                                    admin@i-092d2fd9d0279fb15:~$ cd clmystery/                                      admin@i-092d2fd9d0279fb15:~/clmystery$ ls                                       LICENSE.md  cheatsheet.md   hint1  hint3  hint5  hint7  instructions            README.md   cheatsheet.pdf  hint2  hint4  hint6  hint8  mystery                 admin@i-092d2fd9d0279fb15:~/clmystery$ cd mystery/                              admin@i-092d2fd9d0279fb15:~/clmystery/mystery$ ls                               crimescene  interviews  memberships  people  streets  vehicles                  admin@i-092d2fd9d0279fb15:~/clmystery/mystery$ vi sol.py                        admin@i-092d2fd9d0279fb15:~/clmystery/mystery$ vi sol.py                        admin@i-092d2fd9d0279fb15:~/clmystery/mystery$ python3 sol.py | grep 761fe629ba3