thanks very much @freeloadermatt .
I just tried to use that script and turns out that in fact there is a table altnames in the database! Which makes things worse 🙁
trying to log in to the admin interface I get the following error:
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: [ERROR] (grommunio Admin API) Database query failed: (MySQLdb._exceptions.ProgrammingError) (1146, "Table 'grommunio.altnames' doesn't exist")
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: [SQL: SELECT users.id AS users_id, users.password AS users_password, users.domain_id AS users_domain_id, users.address_status AS users_address_status, users.privilege_bits AS users_privilege_bits, users.externid AS users_externid, users.chat_id AS users_chat_id, users.homeserver AS users_homeserver, users.sync_policy AS users_sync_policy, (SELECT 0) AS anon_1, (SELECT NULL) AS anon_2, (SELECT NULL) AS anon_3, users.group_id AS users_group_id, users.username AS users_username, users.maildir AS users_maildir, users.lang AS users_lang, (SELECT domains.org_id
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: FROM domains
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: WHERE domains.id = users.domain_id) AS anon_4
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: FROM users LEFT OUTER JOIN altnames ON users.id = altnames.user_id
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: WHERE users.username = %s OR altnames.altname = %s
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: LIMIT %s]
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: [parameters: ('admin', 'admin', 1)]
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: (Background on this error at: http://sqlalche.me/e/13/f405)
Dec 26 16:02:10 mail.domain.com uwsgi[1875]: [WARNING] (grommunio Admin API) POST /api/v1/login? from 192.168.2.86 -> 503 '{"message":"Database error."}\n'
However there clearly is an altnames table
I can log in to webmail which is good. I just can't log in to the admin interface.