Repair your mailboxes

grommunio has a tool gromox-mbck to repair the mailboxes. However, this tool is difficult to use because you have to specify the database directory for each check / repair. So I wrote a script that checks all mailboxes and repairs them with the parameter -p. It is important to know that the script does not delete anything, it only repairs the mapping in the ICS, so this repair is safe to use.

• Installation:
  The explanation of how to install the script is at the beginning of the script.

• Check and repair:
  Run the script without parameters if you get similar messages like:

  == /var/lib/gromox/user/X/Y/exmdb/exchange.sqlite3 ==
   ck_allocated_eids: f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12 f13 f14 f15 f16 f17 f18 f19 f20 f21 f22 f23 f24 f25 f26 f27 f28 f29 [29 issues]
   ck_indices_present:
   /var/lib/gromox/user/X/Y/exmdb/exchange.sqlite3: 29 problems total

  Run the script with the -p parameter and repair all mailboxes.

• I hope this helps some grommunio administrators.

• Disclaimer:
  Use at your own risk.

• The script:

  #!/bin/bash
  #
  # Check or repair all mailboxes with gromox-mbck
  #
  # Script to check or repair the ICS properties in all mailboxes
  # First, run this script without parameters, only if you see messages like:
  #
  #   == /var/lib/gromox/user/X/Y/exmdb/exchange.sqlite3 ==
  #   ck_allocated_eids: f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12 f13 f14 f15 f16 f17 f18 f19 f20 f21 f22 f23 f24 f25 f26 f27 f28 f29 [29 issues]
  #   ck_indices_present:
  #   /var/lib/gromox/user/X/Y/exmdb/exchange.sqlite3: 29 problems total
  #
  # Launch the script with the parameter -p to fix the issues.
  #
  #
  # (c) 2025 by Walter@Hofstaedtler.com
  #
  # 17.02.2025 WH, V 1.0, First release
  #
  #
  # Installation:
  # 1. Put this script in /scripts/manual/ as g_mbck.sh
  # 2. Convert the script to Linux LF with:
  #    dos2unix /scripts/manual/g_mbck.sh
  # 3. Make the script executable with:
  #    chmod +x /scripts/manual/g_mbck.sh
  #
  # Run the script and specify the required parameter, just -p.
  #
  #
  CYA="\033[0;36m"; YEL="\033[0;33m"; NORM="\033[0m"
  #
  MSG="Check"
  echo
  echo -e "${CYA}Check or repair all grommunio mailboxes on this system with gomox-mbck.${NORM}"
  echo -e "Use parameter ${YEL}-p${NORM} to start the repair, without -p the mailbox is only checked."
  if [ "$1" == "-p" ]; then
      echo -e "${YEL}-p is set, repair all mailboxes ...${NORM}"
      MSG="${YEL}Repair"
  fi
  echo
  #
  # Read all mailboxes in a variable
  mailboxes=$(grommunio-admin user query username maildir | grep "/user/" | grep "@" | awk '{print $1}')
  
  # Now iterate through all mailboxes
  # shellcheck disable=SC2068
  for mailbox in ${mailboxes[@]}; do
      maildir=$(gromox-mbop -u "$mailbox" echo-maildir)
      if ! [ -d "$maildir" ]; then
          echo "Error: No Maildir/Access: $mailbox" >/dev/stderr
          err_dir=$((err_dir+1))
          continue
      fi
      #
      echo -e "$MSG mailbox: ${CYA}$mailbox${NORM} ..."
      # shellcheck disable=SC2086
      /usr/sbin/gromox-mbck "$maildir"/exmdb/exchange.sqlite3 $1
      echo
      #
  done
  echo "Done."
  #
  # eof
  #