I have a friend who is preparing to set up a small Postfix/Dovecot mail system. There are only approximately 25 users. He wants to use Berkeley DB in a similar fashion to the way Postfix does. I told him I do not believe Dovecot supports that. I could not find any documentation relating to it. 1) Does Dovecot support Berkeley DB? 2) Are their any plans to incorporate that feature into Dovecot? It seems like it could potentially be a very useful feature. I have used it myself when a full blown MySQL configuration seemed like over-kill on other small projects. -- Jerry ? Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________
On 5/20/2012 6:19 AM, Jerry wrote:> I have a friend who is preparing to set up a small Postfix/Dovecot mail > system. There are only approximately 25 users. He wants to use Berkeley > DB in a similar fashion to the way Postfix does. I told him I do not > believe Dovecot supports that. I could not find any documentation > relating to it. > > 1) Does Dovecot support Berkeley DB?No: http://wiki.dovecot.org/AuthDatabase These databases can be used as both password databases and user databases: Passwd: System users (NSS, /etc/passwd, or similiar) Passwd-file: /etc/passwd-like file in specified location LDAP: Lightweight Directory Access Protocol SQL: SQL database (PostgreSQL, MySQL, SQLite) VPopMail: External software used to handle virtual domains> 2) Are their any plans to incorporate that feature into Dovecot? It[Timo answers here]> seems like it could potentially be a very useful feature. I have used > it myself when a full blown MySQL configuration seemed like over-kill > on other small projects.SQLite is the appropriate solution for this scenario. -- Stan
On 5/20/2012 1:19 PM, Jerry wrote:> I have a friend who is preparing to set up a small Postfix/Dovecot mail > system. There are only approximately 25 users. He wants to use Berkeley > DB in a similar fashion to the way Postfix does. I told him I do not > believe Dovecot supports that. I could not find any documentation > relating to it. > > 1) Does Dovecot support Berkeley DB? > > 2) Are their any plans to incorporate that feature into Dovecot? It > seems like it could potentially be a very useful feature. I have used > it myself when a full blown MySQL configuration seemed like over-kill > on other small projects.http://www.mail-archive.com/dovecot at dovecot.org/msg22777.html I don't think anything has changed since then. Regards, Stephan
On Sun, 20 May 2012 06:35:46 -0500 Stan Hoeppner articulated:>On 5/20/2012 6:19 AM, Jerry wrote: >> I have a friend who is preparing to set up a small Postfix/Dovecot >> mail system. There are only approximately 25 users. He wants to use >> Berkeley DB in a similar fashion to the way Postfix does. I told him >> I do not believe Dovecot supports that. I could not find any >> documentation relating to it. >> >> 1) Does Dovecot support Berkeley DB? > >No: http://wiki.dovecot.org/AuthDatabaseI have all ready read that.>> 2) Are their any plans to incorporate that feature into Dovecot? It > >[Timo answers here]Are you ordering Timo to answer or giving him the option? In any case, I am sure he will appreciate you leaving him space to enter his comments.>> seems like it could potentially be a very useful feature. I have used >> it myself when a full blown MySQL configuration seemed like over-kill >> on other small projects. > >SQLite is the appropriate solution for this scenario.Requires loading another application when it is not necessary. Most scenarios I have come across have Berkeley DB all ready installed. In fact, it is an extremely useful tool for checking that things work as expected under Postfix prior to migrating to a full blown SQL database. By the way, I was informed that MySQL is installed on the system in question; however, my friend was advised against using it at the present time. Details NOT available. -- Jerry ? Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________
On Sun, May 20, 2012 at 08:11:33AM -0400, Jerry wrote:> On Sun, 20 May 2012 06:35:46 -0500 Stan Hoeppner articulated: > >On 5/20/2012 6:19 AM, Jerry wrote: > >> seems like it could potentially be a very useful feature. I have > >> used it myself when a full blown MySQL configuration seemed like > >> over-kill on other small projects. > > > >SQLite is the appropriate solution for this scenario. > > Requires loading another application when it is not necessary.What application in particular? SQLite is a file format, not a daemon. Both Dovecot and Postfix support it well (in the latter case, use at least 2.8.9 or 2.9 due to a bug.) sqlite3(1) is the console client for SQLite. You can use that or any other SQLite client to maintain your database file. My own sordid SQLite mail server howto is linked at the .sig site. -- http://rob0.nodns4.us/ -- system administration and consulting Offlist GMX mail is seen only if "/dev/rob0" is in the Subject:
On Sun, 20 May 2012 10:13:45 -0500 /dev/rob0 articulated:>On Sun, May 20, 2012 at 08:11:33AM -0400, Jerry wrote: >> On Sun, 20 May 2012 06:35:46 -0500 Stan Hoeppner articulated: >> >On 5/20/2012 6:19 AM, Jerry wrote: >> >> seems like it could potentially be a very useful feature. I have >> >> used it myself when a full blown MySQL configuration seemed like >> >> over-kill on other small projects. >> > >> >SQLite is the appropriate solution for this scenario. >> >> Requires loading another application when it is not necessary. > >What application in particular? SQLite is a file format, not a >daemon. Both Dovecot and Postfix support it well (in the latter case, >use at least 2.8.9 or 2.9 due to a bug.) > >sqlite3(1) is the console client for SQLite. You can use that or any >other SQLite client to maintain your database file. > >My own sordid SQLite mail server howto is linked at the .sig site.What I meant was that "SQLite" would have to be installed on the system. As far as I know, it is not; although MySQL is. I just talked to my friend and he told me the problem was that the owner of the company was/is afraid of damaging the databases presently in use. We are going to assure him that no such thing will happen and hopefully put his mind at ease. At present all of their mail is handled by a third party and they want to now handle it all in house. I still think that supporting Berkeley DB is a worthwhile goal; however that is my own 2?. -- Jerry ? Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________
On 20-05-2012 19:00, Jerry wrote:> On Sun, 20 May 2012 10:13:45 -0500 > /dev/rob0 articulated: > >> On Sun, May 20, 2012 at 08:11:33AM -0400, Jerry wrote: >>> On Sun, 20 May 2012 06:35:46 -0500 Stan Hoeppner articulated: >>>> On 5/20/2012 6:19 AM, Jerry wrote: >>>>> seems like it could potentially be a very useful feature. I have >>>>> used it myself when a full blown MySQL configuration seemed like >>>>> over-kill on other small projects. >>>> >>>> SQLite is the appropriate solution for this scenario. >>> >>> Requires loading another application when it is not necessary. >> >> What application in particular? SQLite is a file format, not a >> daemon. Both Dovecot and Postfix support it well (in the latter case, >> use at least 2.8.9 or 2.9 due to a bug.) >> >> sqlite3(1) is the console client for SQLite. You can use that or any >> other SQLite client to maintain your database file. >> >> My own sordid SQLite mail server howto is linked at the .sig site. > > What I meant was that "SQLite" would have to be installed on the > system. As far as I know, it is not; although MySQL is. I just talked > to my friend and he told me the problem was that the owner of the > company was/is afraid of damaging the databases presently in use. We > are going to assure him that no such thing will happen and hopefully put > his mind at ease. At present all of their mail is handled by a third > party and they want to now handle it all in house. > > I still think that supporting Berkeley DB is a worthwhile goal; however > that is my own 2?. >SQlite is only 61Kb, no config is needed If you start using MySQL, and the MySQL-database is changed because of some upgrades to the system that currenly uses it, it might have an impact on your mail-system.... For that 2 cents, i would install SQlite! #> zypper info sqlite3 Information for package sqlite3: Repository: openSUSE-12.1-Oss Name: sqlite3 Version: 3.7.8-1.1.2 Arch: x86_64 Vendor: openSUSE Installed: Yes Status: up-to-date Installed Size: 61.0 KiB Summary: Embeddable SQL Database Engine Description: SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. SQLite is not a client library used to connect to a big database server. SQLite is a server and the SQLite library reads and writes directly to and from the database files on disk. SQLite can be used via the sqlite command line tool or via any application that supports the Qt database plug-ins.