1 Topic by jreiter1975

  • jreiter1975
  • Member
  • Offline
  • Registered: 2024-08-04
  • Posts: 2

Topic: Last Login

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Redmail 1.70
Downloaded Installer
Ubuntu 22.04.4 LTS
Database: PGSQL
Nginx
iRedAdmin

Implemented the Track User Last login time.

Getting the following error:

Aug  4 00:57:27 redmail dovecot: imap(user@server.com)<4552><+DTKEtYetKZ/AAAB>: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: ERROR:  permission denied for table last_login (reply took 0.002 secs (0.000 in dict wait, 0.002 in other ioloops, 0.000 in locks, async-id reply 0.001 secs ago, started on dict-server 0.002 secs ago, took 0.000 secs))

Using the Postgres SQL DB.  I am guessing a permission didn't get set correctly.  Not a db guy, not sure how to check the db.

Jeff

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by jreiter1975

  • jreiter1975
  • Member
  • Offline
  • Registered: 2024-08-04
  • Posts: 2

Re: Last Login

Nevermind.  I figured it out.  For some reason my dovecot-last-login.conf file already existed and was set to use vmail as the user instead of vmailadmin. Changed that and got the password and it is working and adding entries to the DB now.

Jeff 



jreiter1975 wrote:

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Redmail 1.70
Downloaded Installer
Ubuntu 22.04.4 LTS
Database: PGSQL
Nginx
iRedAdmin

Implemented the Track User Last login time.

Getting the following error:

Aug  4 00:57:27 redmail dovecot: imap(user@server.com)<4552><+DTKEtYetKZ/AAAB>: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: ERROR:  permission denied for table last_login (reply took 0.002 secs (0.000 in dict wait, 0.002 in other ioloops, 0.000 in locks, async-id reply 0.001 secs ago, started on dict-server 0.002 secs ago, took 0.000 secs))

Using the Postgres SQL DB.  I am guessing a permission didn't get set correctly.  Not a db guy, not sure how to check the db.

Jeff