Changes between Version 18 and Version 19 of Csle2022/Agenda/Ansible


Ignore:
Timestamp:
Nov 22, 2022, 2:02:30 AM (3 years ago)
Author:
dushmantha
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Csle2022/Agenda/Ansible

    v18 v19  
    285285Give the managed VM password (only one password as the VMs have the same password) when prompted.
    286286
     287You will get a similar output as following upon successful completion of the plays. Troubleshoot if there are errors.
     288
     289
     290{{{
     291PLAY [setup mysql] ************************************************************************************************************************************************************************************************
     292
     293TASK [Update] *****************************************************************************************************************************************************************************************************
     294changed: [10.1.1.3]
     295changed: [10.1.1.2]
     296
     297TASK [install python, pip etc] ************************************************************************************************************************************************************************************
     298changed: [10.1.1.2] => (item=pip)
     299changed: [10.1.1.2] => (item=python3-dev)
     300changed: [10.1.1.2] => (item=default-libmysqlclient-dev)
     301changed: [10.1.1.2] => (item=build-essential)
     302[WARNING]: Consider using the apt module rather than running 'apt-get'.  If you need to use command because apt is insufficient you can add 'warn: false' to this command task or set 'command_warnings=False' in
     303ansible.cfg to get rid of this message.
     304changed: [10.1.1.3] => (item=pip)
     305changed: [10.1.1.3] => (item=python3-dev)
     306changed: [10.1.1.3] => (item=default-libmysqlclient-dev)
     307changed: [10.1.1.3] => (item=build-essential)
     308
     309TASK [Install MySQL server] ***************************************************************************************************************************************************************************************
     310changed: [10.1.1.2]
     311changed: [10.1.1.3]
     312
     313TASK [Install MySQL client] ***************************************************************************************************************************************************************************************
     314changed: [10.1.1.3]
     315changed: [10.1.1.2]
     316
     317TASK [pip install mysqlclient] ************************************************************************************************************************************************************************************
     318changed: [10.1.1.2]
     319changed: [10.1.1.3]
     320
     321TASK [Start the MySQL service] ************************************************************************************************************************************************************************************
     322ok: [10.1.1.3]
     323ok: [10.1.1.2]
     324
     325TASK [copy .my.cnf file with root password credentials] ***********************************************************************************************************************************************************
     326changed: [10.1.1.3]
     327changed: [10.1.1.2]
     328
     329TASK [update mysql root password for all root accounts] ***********************************************************************************************************************************************************
     330changed: [10.1.1.3]
     331changed: [10.1.1.2]
     332
     333TASK [Create database] ********************************************************************************************************************************************************************************************
     334changed: [10.1.1.3]
     335changed: [10.1.1.2]
     336
     337TASK [Create user] ************************************************************************************************************************************************************************************************
     338changed: [10.1.1.3]
     339changed: [10.1.1.2]
     340
     341TASK [Grant permissions] ******************************************************************************************************************************************************************************************
     342changed: [10.1.1.2]
     343changed: [10.1.1.3]
     344
     345TASK [Reload privileges] ******************************************************************************************************************************************************************************************
     346changed: [10.1.1.2]
     347changed: [10.1.1.3]
     348
     349PLAY RECAP ********************************************************************************************************************************************************************************************************
     35010.1.1.2                   : ok=12   changed=11   unreachable=0    failed=0    skipped=0    rescued=0    ignored=0
     35110.1.1.3                   : ok=12   changed=11   unreachable=0    failed=0    skipped=0    rescued=0    ignored=0
     352}}}
     353
     354
    287355'''Verify results - In managed nodes'''
    288356
    289357{{{
    290 mysql -u root -p
     358mysql -u newuser -pRedact#13
    291359show databases;
    292360}}}