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

• Forums: [http://ubuntuforums.org/member.php?u=374940 Profile], [http://ubuntuforums.org/search.php?do=process&showposts=0&starteronly=1&exactname=1&searchuser=gautada Threads], [http://ubuntuforums.org/search.php?do=finduser&u=374940 Posts]

• Projects: [http://www.launchpad.net/~gautada Lanchpad]

Networking

• [http://www.ubuntero.org/gautada Ubuntero]

• [http://www.linkedin.com/in/gautada LinkedIn]

• [http://www.facebook.com/profile.php?id=724628196 Facebook]

• [http://www.myspace.com/gautada Myspace]

Projects

Specs and information on projects that I am interested in.

• ["LifeRing"]

• ["UEUtils"]
• ["VCIO"]

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