News

sql-xpw has been released. I think it will work. I wish I was more confident in the package but I tried a lot of new stuff in this one and I haven’t had as much time as I would like to test it. So, as always, if you have trouble building it, please send an E-mail to either [email protected] or [email protected] and I’ll do my best to help you out.
Things to note about the new release:
Support for Postgres databases
Configure script
SQL functions packaged as a static library you can use (./libjsql)
sql-cpw and sql-gpw are now in the same package
No SQL scripts are included. This is because MySQL and Postgres are very different beasts, and I didn’t want to confuse anybody. Besides, if you’re hacking an MTA you better know how to create a table.
Enjoy!
Mailing List
Enter your E-mail address below to join our mailing list. You’ll receive an E-mail letting you know about code updates, tips on building source on various platforms, and new software. Your E-mail address will be added to a .qmail file in the user [email protected]’s home path with go-rwx permissions–I can’t offer more security/privacy than that. If you are receiving unsolicited E-mail from this list, please send a blank E-mail to [email protected] with the subject ‘remove’ and I’ll remove your address as soon as I can.
E-mail address

Software
sql-xpw (checkpassword and qmail-getpw)
Uses a MySQL or Postgres database to authenticate E-mail logins and delivery in Qmail.
Features
Recognizes the following user information from a MySQL or PostgreSQL database:
username
domain
password
uid
gid
home path
Reads the following information from an external configuration file:
Default domain name to use when none is specified
Type of database to use
Hostname of the database server
Username and password to use when connecting to the database server
Name of the database the information is stored in
Name of the table containing user information
Names of the fields containing username, domain, uid, gid, and home path
Authenticates users on a per-domain basis–multiple domains can exist independently on one IP address.
Detailed error logging via syslog.
Downloading
README
Tarred sources:
sql-xpw-1.0.tgz
CVS
Use the following commands to get the source tree from CVS:
export CVSROOT=”:pserver:[email protected]:/data/CVS”
cvs login
cvs export -D now sql-xpw
sql-cpw (checkpassword)
This uses a MySQL database to authenticate POP3 connections negotiated by qmail-popup. It is a direct replacement for checkpassword; no other changes are necessary.
Features
Recognizes the following user information from a MySQL database:
username
domain
password
uid
gid
home path
Reads the following information from an external configuration file:
Default domain name to use when none is specified
Type of database to use
Hostname of the database server
Username and password to use when connecting to the database server
Name of the database the information is stored in
Name of the table containing user information
Names of the fields containing username, domain, uid, gid, and home path
Authenticates users on a per-domain basis–multiple domains can exist independently on one IP address.
Detailed error logging via syslog.
Downloading
README
Tarred sources:
sql-cpw-1.3.2.tgz
sql-cpw-1.3.1.tgz
sql-cpw-1.3.tgz
sql-cpw-1.1.tgz
sql-cpw-1.0.tgz
CVS
Use the following commands to get the source tree from CVS:
export CVSROOT=”:pserver:[email protected]:/data/CVS”
cvs login
cvs export -D now sql-cpw
sql-gpw (qmail-getpw)
This uses a MySQL database to read user path information upon mail delivery. Versions prior to 1.5 feature a major bug, and are only there because I’m too lazy to get rid of them.
Features
Recognizes the following user information from a MySQL database:
username
domain
uid
gid
home path
Reads the following information from an external configuration file:
Default domain name to use when none is specified
Whether or not to pass E-mails sent to unrecognized users to a single alternate user, and the username of that user
Type of database to use
Hostname of the database server
Username and password to use when connecting to the database server
Name of the database the information is stored in
Name of the table containing user information
Names of the fields containing username, domain, uid, gid, and home path
Enables mail to be delivered locally on a per-domain basis; multiple domains can operate independently on a single IP address.
Able to forward E-mail sent to unrecognized users to a single configurable username.
Detailed error logging via syslog.
Downloading