gautada
Contents |
Introduction
"An investment in knowledge always pays the best interest." -- Benjamin Franklin
Greetings and Salutations,
I deliver solutions to clients based on open-source technology. My professional interests center around the political, financial, and technical issues involved in the adoption of open-source into business. Other than that, all I am interested in is trying to make my wife smile.
Adam T. Gautier (aka "Adam Gautier", "gautada")
Community Activity
Networking
Projects
Specs and information on projects that I am interested in.
Notes
Notes from projects, forum posts, or bug reports that get reused over time.
Package Delete and Reinstall
%>sudo apt-get check <package name> %>sudo apt-get remove --purge <package name> %>sudo apt-get install <package name>
MySQL
Create Database
%>mysqladmin --user=root --password create [database_name]
Create User
%>mysql --user=root --password mysql mysql>GRANT ALL PRIVILEGES ON [database_name].* TO 'monty'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;
Reset Password
%>sudo /etc/init.d/mysql stop %>sudo mysqld --skip-grant-tables & %>mysql -u root mysql %>UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;
Postgresql
SSL Certificates on Server
To setup postgresql to use SSL for connection set:
- ssl = on in postgresql.conf
Create the server.key and server.crt files in "/var/lib/postgresql/<version>/main/"
Generate self-signed certificate for testing
%>openssl req -new -text -out server.req
Remove password
%>openssl rsa -in privkey.pem -out server.key %>rm privkey.pem
Generate certificate:
%>openssl req -x509 -in server.req -text -key server.key -out server.crt %>chmod og-rwx server.key
OpenSSL
Generate a Private Key
%>openssl genrsa -des3 -out server.key 1024
Generate a Certificate Signing Request
%>openssl req -new -key server.key -out server.csr
Remove Passphrase From Key
%>openssl rsa -in server.key -out server.key.nocrypt
Generate a Self Signed Certificate
%>openssl x509 -req -years 10 -in server.csr -signkey server.key.nocrypt -out server.crt
Windows XP Printer Network Printing
gautada (last edited 2008-08-06 17:00:35 by localhost)