Recent changes to patches

Allow to specify custom DSN

2012-02-13T08:44:47Z

If a user wants to use SSL or customize his database connection, he should be allowed to supply a custom DSN.

Pidfile from command-line arguments

2012-02-12T16:28:18Z

Support -p / --pidfile=file from command line arguments.

UNIX sockets support patch

2012-02-12T16:07:28Z

The attached patch adds UNIX socket support without breaking compatibility with existing configuration files.
Users can use unix = /path/to/socket as their socket specification.
Patch ist against git 9e91aae394e0a47a961866b52189345fbcdbb2bd.

add configurable table names

2011-12-28T09:16:03Z

sqlgrey 1.8.0-rc2
Allow configuring table names in sqlgrey.conf.

Patch for 1.7.6 to support DNS Whitelists

2011-02-08T21:10:26Z

Patch for sqlgrey 1.7.6 to support DNS Whitelists

Net::DNS is required
list.dnswl.org is the default if nothing is defined in dns_wl options in sqlgrey.conf.

For origin, see:
http://www.global-domination.org/forum/viewtopic.php?f=20&t=2266

Enable support for SSL connections to PostgreSQL

2009-08-26T19:04:37Z

By default, DBD::Pg doesn't use SSL connections to the database server. I'd like to have the option to encrypt database communications but don't necessarily need to configure that on the client side. The attached patch sets the SSL mode to "allow", which causes Sqlgrey to attempt an unencrypted database connection first, and then try an encrypted connection. I can control which is used on the database server by switching between "host" and "hostssl" in pg_hba.conf.

1.7.6: Add UNIX socket and Exim support

2007-08-27T09:24:32Z

This patch is for sqlgrey 1.7.6, and includes patch 1664054 "Port of postgrey exim patch". It constitutes the following:

- Make sqlgrey close the connection for each request. This behaviour is specified with the --exim option. Please see the above patch for details.

- Support for UNIX sockets. The configuration file parameter "inet" has been replaced by the parameter "socket".

1.7.6: Fix setting variables from the config file

2007-08-27T08:32:56Z

Values that are legitimately set to 0 - or any other value that evaluates to FALSE in perl - in the config file are set to 1 in sqlgrey. This is due to the way variables are set when read from the config file. This was discovered when attempting to turn off "prepend".

Please see attachment for details.

Exim compatibility: close connection + unix sockets

2007-08-24T13:03:02Z

Exim compatibility: close connection + unix sockets

This patch is for sqlgrey 1.6.8, and includes patch 1664054 "Port of postgrey exim patch". It constitutes the following:

- Make sqlgrey close the connection for each request. This behaviour is specified with the --exim option. Please see the above patch for details.

- Support for UNIX sockets. The configuration file parameter "inet" has been replaced by the parameter "socket". Examples:

# Set up TCP socket on localhost, port 2051
socket = tcp:localhost:2051

# Set up UNIX socket at /var/sqlgrey/sqlgrey.sock
socket = unix:/var/sqlgrey/sqlgrey.sock

Port of postgrey exim patch

2007-02-20T06:03:13Z

Add --exim option to allow Exim compatibility.

To be compatible with Exim, the unix/tcp socket should be closed after each result.