Archive for February, 2011

Feb 28 2011

mysql reset zapomnianego hasła

Zatrzymaj serwer mysql.
uruchom serwer w tym trybie:

 /usr/bin/mysqld_safe --skip-grant-tables --socket=/var/run/mysqld/mysqld.sock mysql --user=root mysql
 update user set Password=PASSWORD('new-password-here') WHERE User='root';

w debianie –user=admin

Feb 10 2011

Certyfikaty SSL Self-signed

cd /etc/ssl/misc
Nowy CA: ./CA.sh -newca

Nowa “prosba”:  ./CA.sh -newreq

Podpisanie: ./CA.sh -sign

Zdejmowanie hasła: openssl rsa -in newkey.pem -out key.pem

Wpisy w httpd-ssl.conf

SSLCertificateFile /etc/ssl/certs/apache/cert.pem
SSLCertificateKeyFile /etc/ssl/certs/apache/key.pem
SSLCACertificateFile /etc/ssl/certs/apache/cacert.pem