MySQL cheat sheet

Posted on

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; GRANT ALL PRIVILEGES ON database.* TO ‘user’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; FLUSH PRIVILEGES;

What I wrote down about DNA-C

Posted on

Random reading https://www.ciscolive.com/c/dam/r/ciscolive/emea/docs/2019/pdf/TECNMS-2900.pdf  https://www.cisco.com/c/dam/m/ru_ua/training-events/2018/cisco-forum-kyiv/pdf/4-1_001_dna-c_aovrashk_12-dec-2018.pdf Connect to DNA-C CLI ssh maglev@dnac-ip -p 2222 https://www.cisco.com/c/en/us/support/docs/cloud-systems-management/dna-center/213926-how-to-generate-and-extract-root-cause-a.html Check that all package is deployed When DNAC-C is reinstalled there is a lot of package that is deployed in the background. maglev  package status Undeploy a package For trying to fix issue 😉 maglev  package undeploy –force assurance https://www.nefkens.net/updating-dna-center-experiences/

Cisco AP wired 802.1x supplicant

Posted on

If your network uses 802.1x validation on the wireless ports you will need some mechanism to enable the AP to authenticate on the port. The default Cisco solution is to configure the AP with a EAP-FAST username and credential and enable a policy for this in ISE The process is described in Configure Lightweight Access Point […]

Certificate conversion for Cisco ISE

Posted on

https://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/ Thank to Mark Bilman for the above article.  Read the article or copy from here if  just need the syntax openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key] openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt] openssl rsa -in [keyfile-encrypted.key] -out [keyfile-decrypted.key] openssl rsa -in [keyfile-encrypted.key] -outform PEM -out [keyfile-encrypted-pem.key]

Single deployment DHCP option 43 config in Infoblox

Posted on

Use this guide to configure you InfoBlox to provide the Wireless LAN Controller address via DHCP option 43 to ANY device. If you need to provide the option only to Cisco APs or different option per AP type – This is not the guide!   Select DHCP–>Networks–>Select your subnet (alternatively can do this per DHCP […]

Bridging a VMware guest on Cisco Wireless

Posted on

On a default Cisco Unified Wireless LAN setup a client can only have one MAC address. If a wireless user runs VMware desktop or another virtual setup where the clients hosts more that one interface it will not work. Follow these step to allow multiple hosts on one wireless client On the CLI of the […]

Configuring Flexible Radio Assignment from CLI

Posted on

Marking an Interface “Redundant” Exercising FRA FRA Sensitivity – designed to be VERY conservative – and That’s good! The opposite of conservative is a coverage hole! Defaults – should be safe for a customer environment Low (100%), Medium (95%), High (90%) Hidden levels – Be very very careful – these are persistent commands – • […]