gautada

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


CategoryHomepage

gautada (last edited 2008-08-06 17:00:35 by localhost)