Pedro Gomes

Seems there’s a bug (or a feature) somewhere in Ansible which doesn’t translate encrypted variables (but it works fine with vault files), so when you try to use them on a template it will fail with the error above.

To work around that, you could try setting a fact before hand which will decrypt the secure variable into a new variable.

set_fact:
pass_decoded: “{{ pass }}”

Use the new variable in the template:

Authorization: “Basic {{ (user + ‘:’ + pass_decoded)| b64encode }}”

--

--

It’s only a matter of time when Ethereum becomes the number one crypto currency and all products are priced in gweis. In some measures Ethereum already beat Bitcoin. In others, it’s well underway to become #1.

It’s already doing 6x as many transactions as the Bitcoin network.

It has almost as many active wallets as Bitcoin.

The hype around NFT and DeFI will only keep growing ETH and leave Bitcoin well behind it’s stagnant growth.

Keep up with the flippening using https://flippening.org/

--

--

Because who wants to go through 1000+ words SEO optimized articles in Digital Ocean everytime? We all know what we want, two lines of code to copy paste. Hence my new website: https://howtocreateusermysql.com/

Quickly generate the commands to create users and manage their grants

It gives you, by default:

  • Strong password
  • Least required permissions (SELECT only)

Additionally:

  • Pre-made permissions sets from least permissive to most.
  • Read only (SELECT)
  • CRUD (SELECT, INSERT, UPDATE, DELETE)
  • Full app (SELECT,UPDATE,INSERT,DELETE,CREATE,ALTER,INDEX,DROP)
  • Replication(REPLICATION SLAVE)
  • Admin (ALL PRIVILEGES)

In the future, may also support additional database engines.

This is great if you just want to quickly copy paste a command and have your new Mysql users and database privileges ready at once .

As usual, managing this in code should be the preferred way of doings things, and in the end I’ve also added a page with instructions on how to create mysql users/grants with Ansible, Chef and Puppet.

--

--