===== mkauth validade depois atualizacao =====

<code>

echo "ALTER TABLE sis_acesso ADD validade DATETIME NOT NULL DEFAULT '2050-12-31 00:00:00'" | sudo mysql -h localhost -u root -pvertrigo mkradius

</code>

===== ssl =====
<code>
       SSLCertificateFile /etc/letsencrypt/live/intechgrity.com/cert.pem
       SSLCertificateKeyFile /etc/letsencrypt/live/intechgrity.com/privkey.pem
       SSLCertificateChainFile /etc/letsencrypt/live/intechgrity.com/chain.pem
       
0 */12 * * * root test -x /usr/bin/certbot -a \! -d /run/systemd/system && perl -e 'sleep int(rand(43200))' && certbot -q renew --deploy-hook "/etc/init.d/apache2 restart"

</code>


===== HT auth =====

<code>




  <IfModule mod_dbd.c>
    DBDriver mysql
    DBDParams host=localhost,dbname=mkradius,user=root,pass=vertrigo
    DBDMin 1
    DBDKeep 8
    DBDMax 16
    DBDExptime 300
  </IfModule>

  <Directory "/admin/">
  AuthType Basic
  AuthName "Authentication"
  AuthBasicProvider socache dbd
  AuthnCacheProvideFor dbd
  AuthnCacheContext Authentication
  Require valid-user
  AuthDBDUserPWQuery "SELECT sha FROM sis_acesso WHERE login = %s AND ativo"
  </Directory>

</code>