Amavisd failed to restart due to BerkeleyDB, libdb, and db.h incompatibility

[Horst Simon]

> On 2 Nov 2017, at 11:06 am, Ryan Schmidt <ryandesign at macports.org> wrote:
> 
> 
> On Nov 1, 2017, at 06:30, 後藤潔 wrote:
> 
>> After upgrade to the latest ports except apache2 2.4.29_0, amavisd failed to restart. Terminal messages are as follows.
>> 
>> ----- start of messages
>> 
>> $ sudo amavisd restart
>> Password:
>> Problem in Amavis::DB or Amavis::DB::SNMP code: 
>> BerkeleyDB needs compatible versions of libdb & db.h
>> 	you have db.h version 5.3.21 and libdb version 5.3.28
>> Compilation failed in require at (eval 79) line 20.
>> BEGIN failed--compilation aborted at (eval 79) line 20.
>> 
>> ----- end of messages
>> 
>> Amavisd is currently working.
>> 
>> $ ps aux | grep amavisd | grep -v grep
>> _amavisd       32094   0.0  0.7  2561356  61540   ??  S     1:20PM   0:00.69 /opt/local/sbin/amavisd (ch8-avail)   
>> _amavisd       31901   0.0  0.8  2562380  65112   ??  S     1:10PM   0:01.00 /opt/local/sbin/amavisd (ch10-avail)   
>> _amavisd       42175   0.0  0.5  2559996  38608   ??  Ss    21017    0:31.31 /opt/local/sbin/amavisd (master) 
>> 
>> The current versions on my server are as follows.
>> 
>> OS: Mac OSX 10.8.5
>> MacPorts base: 2.4.2
>> amavisd-new @2.10.1_5+perl5_24
>> p5.24-mail-spamassassin @3.4.1_3
>> perl5 @5.24.2_0+perl5_24
>> perl5.24 @5.24.2_0
>> db53 @5.3.28_0+sql
>> sqlite3 @3.21.0_0
>> 
>> I have tried to uninstall and reinstall the related ports, but in vain.
>> 
>> Downgrading db53 to 5.3.21_3+sql from 5.3.28_0+sql, amavisd successfully restarted. The terminal messages are as follows.
>> 
>> ----- start of messages
>> 
>> $ sudo port deactivate db53 @5.3.28_0+sql
>> Password:
>> Note: It is not recommended to uninstall/deactivate a port that has dependents as it breaks the dependents.
>> The following ports will break: p5.24-berkeleydb @0.550.0_0
>> Continue? [y/N]: y
>> Warning: Deactivate forced.  Proceeding despite dependencies.
>> --->  Deactivating db53 @5.3.28_0+sql
>> --->  Cleaning db53
>> $ sudo port activate db53 @5.3.21_3+sql
>> --->  Activating db53 @5.3.21_3+sql
>> --->  Cleaning db53
>> $ sudo amavisd restart
>> Daemon [42175] terminated by SIGTERM, waiting for dust to settle...
>> becoming a new daemon...
>> $ ps aux | grep amavisd | grep -v grep
>> _amavisd       34278   0.0  0.1  2562792   8660   ??  S     2:53PM   0:00.01 /opt/local/sbin/amavisd (virgin child)   
>> _amavisd       34277   0.0  0.1  2562792   8536   ??  S     2:53PM   0:00.01 /opt/local/sbin/amavisd (virgin child)   
>> _amavisd       34276   0.0  0.8  2561432  70388   ??  Ss    2:53PM   0:01.16 /opt/local/sbin/amavisd (master) 
>> 
>> ----- end of messages
>> 
>> Any suggestions or advices are wellcome.
> 
> I don't know if there's a valid reason for this, but it sounds like when amavisd-new is compiled, the version of db53, as listed in the db.h header, is recorded into the perl modules installed with amavisd-new. Then, when the db53 port is later updated, the version recorded into its library is no longer the same as the one amavisd-new was compiled with, which results in the error.
> 
> If we can verify that that's what's going on, then:
> 
> We could ask the developers of amavisd-new why they do this.
> 
> We should revbump amavisd-new to rebuild it. This will need to be done anyway along with other changes to switch to perl5.26: https://trac.macports.org/ticket/55208
> 
> We should add a comment in the db53 port advising the maintainer to revbump amavisd-new whenever the version of db53 is changed.
> 
> Until that's done, you could work around the problem by rebuilding amavisd-new after reactivating db53 @5.3.28:
> 
> sudo port activate db53 @5.3.28_0+sql
> sudo port -ns upgrade --force amavisd-new
> 

I had the following failure after a new install when trying to start amavis and still get the following error
after I tried above suggestion.

Problem in Amavis::DB or Amavis::DB::SNMP code: 
BerkeleyDB needs compatible versions of libdb & db.h
	you have db.h version 5.3.21 and libdb version 5.3.28
Compilation failed in require at (eval 79) line 20.
BEGIN failed--compilation aborted at (eval 79) line 20.

Regards,
Horst