gautada

Differences between revisions 26 and 27
⇤ ← Revision 26 as of 2007-10-09 03:28:28 →
Size: 1987
Editor: adsl-159-217-64
Comment:
← Revision 27 as of 2007-10-10 17:47:04 → ⇥
Size: 2561
Editor: adsl-21-162-126
Comment:
Deletions are marked like this. Additions are marked like this.
Line 54: Line 54:
Line 58: Line 59:

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

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;

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

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