Archive db

[Xi Ruoyao]

Yet another deathware.

Like how we treat GTK-2 and Python-2, let's ignore the optional dependencies to db first. Then:

• Bogofilter: Alleged to be "required" but actually can be replaced by sqlite3.
  • Switched the book configuration to use sqlite3.
• cyrus-sasl: Recommended.
  • Switched the book to use LMDB instead
• postfix: Recommended.
  • Switched the book to use LMDB instead

[Bruce Dubbs]

Seems like something we can do. Ever since Oracle took over db, we reverted to the most recent really open source version of db.

• Bogofilter: add --with-database=sqlite3
• cyrus-sasl: add --with-dblib=lmdb
• postfix: I could not find any references to Berkeley DB in my postfix logs, but we already have several database options i the book. I recommend:

  CCARGS='-DNO_NIS -DHAS_SQLITE'
  AUXLIBS='-lsqlite3 -lpthread'
  

Of course all have to be tested.

[Xi Ruoyao]

I've been running Bogofilter with sqlite3 for years.

[Xi Ruoyao]

Bogofilter done.

[Douglas R. Reno]

I can test SASL

In favor of removing this package. One less thing I have to worry about turning up when I update Java and check for references.

[Douglas R. Reno]

I've converted cyrus-sasl to use LMDB instead of Berkeley DB at 7167f307742426ba2373645021eb8f10e6566b22

[Bruce Dubbs]

Getting db out of postfix will not be easy. It looks fairly embedded without options to change. I could only find two files that included db.h:

src/util/mkmap_db.c:#include <db.h>
src/util/dict_db.c:#include <db.h>

I looked at mkmap_db.c. It's not a long file (172 lines) but I didn't see where db.h was needed.

dict_db.c is 880 lines but looks like it would need to be completely rewritten.

[Xi Ruoyao]

​https://www.postfix.org/DB_README.html#disable_db

But this seems disabling the "hash" file support which is referred by many online tutorials of postfix. Not sure if we should do it.

[Xi Ruoyao]

Replying to Xi Ruoyao:

​https://www.postfix.org/DB_README.html#disable_db

But this seems disabling the "hash" file support which is referred by many online tutorials of postfix. Not sure if we should do it.

We can tell the users to replace "hash" with "lmdb". I'll try if I can use lmdb instead of hash on my server (it's not running LFS though).

[Xi Ruoyao]

Replying to Xi Ruoyao:

Replying to Xi Ruoyao:

​https://www.postfix.org/DB_README.html#disable_db

But this seems disabling the "hash" file support which is referred by many online tutorials of postfix. Not sure if we should do it.

We can tell the users to replace "hash" with "lmdb". I'll try if I can use lmdb instead of hash on my server (it's not running LFS though).

On Ubuntu:

1. apt install postfix-lmdb
2. echo default_database_type = lmdb >> /etc/postfix/main.cf
3. Use postmap command to regenerate all maps file again. Now the generated files are "xxx.lmdb" instead of "xxx.db".
4. Change every hash: in main.cf to lmdb:
5. Restart postfix

Then I sent a mail to my linuxfromscratch.org mailbox and it worked.

[Bruce Dubbs]

Just checked rivendell:

# Location of SMTP auth credentials
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd

# For sympa (shouldn't interfere with the above since it creates virtual domains)
# virtual(8) maps
virtual_mailbox_domains =
  hash:/etc/sympa/transport.sympa
virtual_mailbox_maps =
  hash:/etc/sympa/transport.sympa,
  hash:/etc/sympa/sympa_transport,
  hash:/etc/sympa/virtual.sympa
# virtual(5) maps
virtual_alias_maps =
  hash:/etc/sympa/virtual.sympa
# transport maps
transport_maps =
  hash:/etc/sympa/transport.sympa,
  hash:/etc/sympa/sympa_transport

I wonder it external programs access these files directly or through postfix. We are not going to experiment there though,

[Xi Ruoyao]

​https://www.sympa.community/gpldoc/man/sympa_config.5.html#aliases_db_type

[Xi Ruoyao]

I've switched postfix from db to lmdb at r12.0-722-g90066bfaf2. I tested the functionality of postmap, but I've not really set up a mail server. Waiting for someone else to test.

[Bruce Dubbs]

I plan on creating an ENTITY for this as an external dependency for packages that use it and then archiving the package.

[Bruce Dubbs]

Fixed at commit dcd5a06347.