Hi everybody, I am trying to configure a virtual hosting system on OpenBSD, and I am currently looking at the authentication and user lookup. I have already normalized a PostgreSQL database which stores the users amongst others. And i would like to use these users in OpenBSD.
As I understand their really is only one possibility to configure such a setup and that is to select all the users from the PostgreSQL database and create a bdb hash using pwd_mkdb (or any other compatible tool). PostgreSQL has support for asynchronous notifications (http://www.postgresql.org/docs/8.2/interactive/sql-listen.html) thus it is possible to create a bdb whenever the user database is updated. I was thinking about running the following scripts when postgreql sends such an asynchronous notification. $ script | pwd_mkdb /dev/stdin /etc/master.passwd The script will output all the users in the same format as master.passwd. Are there any other methods for doing this, or are there things I am overlooking with this configuration? Thanks, Alexander Schrijver
