Unable to add IP address to white list: mailmng-black-white failed: Fatal error: SQLError(no such table: v4_poplocks)

Created:

2016-11-16 13:13:27 UTC

Modified:

2017-08-16 16:24:18 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to add IP address to white list: mailmng-black-white failed: Fatal error: SQLError(no such table: v4_poplocks)

Applicable to:

  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

Symptoms

Unable to add IP address to white list ( Tools & Settings > Mail Server Settings > White List ):

ERROR: PleskUtilException
mailmng-black-white failed: Fatal error: SQLError(no such table: v4_poplocks)

Qmail is used as mail server.

Cause

Corrupted or empty /var/lib/plesk/mail/poplock/poplock.db file.

Resolution

  1. Check poplock.db for consistency:

    # sqlite3 /var/lib/plesk/mail/poplock/poplock.db
    sqlite> .tables
    sqlite> .q
  2. Move /var/lib/plesk/mail/poplock/poplock.db to another place:

    # mv /var/lib/plesk/mail/poplock/poplock.db /root/
  3. Recreate /var/lib/plesk/mail/poplock/poplock.db :

    # /usr/local/psa/admin/sbin/mchk --without-spam
  4. Check poplock.db again:

    # sqlite3 /var/lib/plesk/mail/poplock/poplock.db
    sqlite> .tables
    v4_poplocks v4_whitenets v6_poplocks v6_whitenets
    sqlite> .q
Have more questions? Submit a request
Please sign in to leave a comment.