gautada

Differences between revisions 28 and 29
⇤ ← Revision 28 as of 2007-11-19 22:15:22 →
Size: 2789
Editor: adsl-241-192-76
Comment:
← Revision 29 as of 2008-02-25 17:12:18 → ⇥
Size: 3266
Editor: adsl-070-155-214-110
Comment:
Deletions are marked like this. Additions are marked like this.
Line 95: Line 95:

=== 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
}}}


}}}

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.

[http://www.gautier.org/identity 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

}}}

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