starred/modoboa-modoboa
1
0
Fork 0
mirror of https://github.com/modoboa/modoboa.git synced 2026-04-27 18:05:58 +03:00
Code Issues 60 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #1239] dovecot seems to not be able to execute psql #1007

New issue
Closed
opened 2026-02-27 11:14:42 +03:00 by kerem · 6 comments
kerem commented 2026-02-27 11:14:42 +03:00
Owner
Copy link

Originally created by @TonyBostonTB on GitHub (Sep 20, 2017).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/1239

Impacted versions

  • Modoboa: 1.9.0
  • installer used: Yes
  • Webserver: Nginx

Steps to reproduce

if one selects any folder in thunderbird or changes to another folder, the following error pops up in the logs - dovecot: postlogin: Error: could not find a "psql" to execute-

Current behavior

not sure if something doesnt work but as the error says, there is something not working

Expected behavior

no errors in the log

Originally created by @TonyBostonTB on GitHub (Sep 20, 2017). Original GitHub issue: https://github.com/modoboa/modoboa/issues/1239 # Impacted versions * Modoboa: 1.9.0 * installer used: Yes * Webserver: Nginx # Steps to reproduce if one selects any folder in thunderbird or changes to another folder, the following error pops up in the logs - dovecot: postlogin: Error: could not find a "psql" to execute- # Current behavior not sure if something doesnt work but as the error says, there is something not working # Expected behavior no errors in the log
kerem 2026-02-27 11:14:42 +03:00
kerem commented 2026-02-27 11:14:43 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Sep 22, 2017):

On which distribution did you install Modoboa? Do you have a more verbose log to show?

<!-- gh-comment-id:331374889 --> @tonioo commented on GitHub (Sep 22, 2017): On which distribution did you install Modoboa? Do you have a more verbose log to show?
kerem commented 2026-02-27 11:14:43 +03:00
Author
Owner
Copy link

@smindorf commented on GitHub (Sep 28, 2017):

Hi,

I've the same message in my maillog.
OS: CentOS 7

Maillog:

Sep 28 08:05:50 mail dovecot: imap-login: Login: user=<soeren@####>, method=PLAIN, rip=81.7.5.14, lip=88.99.42.74, mpid=3447, TLS, session=<07M5szlaDgBRBwUO>
Sep 28 08:05:50 mail dovecot: postlogin: Error: could not find a "psql" to execute
Sep 28 08:05:51 mail dovecot: imap(soeren@####): Connection closed in=595420 out=2190

dovecot-debug.log:

Sep 28 08:05:49 auth: Debug: auth client connected (pid=3446)
Sep 28 08:05:50 auth: Debug: client in: AUTH    1       PLAIN   service=imap    secured session=07M5szlaDgBRBwUO        lip=88.99.42.74 rip=81.7.5.14   lport=993       rport=39950     resp=<hidden>
Sep 28 08:05:50 auth: Debug: sql(soeren@####,81.7.5.14,<07M5szlaDgBRBwUO>): query: SELECT email AS user, password, '/srv/vmail/####/soeren' AS userdb_home, 1003 AS userdb_uid, 1003 AS userdb_gid, CONCAT('*:bytes=', mb.quota, 'M') AS userdb_quota_rule FROM core_user u INNER JOIN admin_mailbox mb ON u.id=mb.user_id INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE email='soeren@####' AND is_active AND dom.enabled
Sep 28 08:05:50 auth: Debug: client passdb out: OK      1       user=soeren@####
Sep 28 08:05:50 auth: Debug: master in: REQUEST 3406561281      3446    1       814b3f8020ff878a661bfcaa1db12ba3        session_pid=3447        request_auth_token
Sep 28 08:05:50 auth: Debug: prefetch(soeren@####,81.7.5.14,<07M5szlaDgBRBwUO>): success
Sep 28 08:05:50 auth: Debug: master userdb out: USER    3406561281      soeren@####    home=/srv/vmail/####/soeren    uid=1003        gid=1003        quota_rule=*:bytes=0M   auth_token=4b7b4522ed363b0d1e79e9166e57b0c922339ce4
Sep 28 08:05:50 imap: Debug: Loading modules from directory: /usr/lib64/dovecot
Sep 28 08:05:50 imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so
Sep 28 08:05:50 imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so
Sep 28 08:05:50 imap: Debug: Added userdb setting: plugin/quota_rule=*:bytes=0M
Sep 28 08:05:50 imap(soeren@####): Debug: Effective uid=1003, gid=1003, home=/srv/vmail/####/soeren
Sep 28 08:05:50 imap(soeren@####): Debug: Quota root: name=User quota backend=dict args=:proxy::quota
Sep 28 08:05:50 imap(soeren@####): Debug: Quota rule: root=User quota mailbox=* bytes=0 messages=0
Sep 28 08:05:50 imap(soeren@####): Debug: Quota grace: root=User quota bytes=0 (10%)
Sep 28 08:05:50 imap(soeren@####): Debug: dict quota: user=soeren@####, uri=proxy::quota, noenforcing=0
Sep 28 08:05:50 imap(soeren@####): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:~/Maildir
Sep 28 08:05:50 imap(soeren@####): Debug: maildir++: root=/srv/vmail/####/soeren/Maildir, index=, indexpvt=, control=, inbox=/srv/vmail/####/soeren/Maildir, alt=

Regards
Sören

<!-- gh-comment-id:332737756 --> @smindorf commented on GitHub (Sep 28, 2017): Hi, I've the same message in my maillog. OS: CentOS 7 Maillog: ``` Sep 28 08:05:50 mail dovecot: imap-login: Login: user=<soeren@####>, method=PLAIN, rip=81.7.5.14, lip=88.99.42.74, mpid=3447, TLS, session=<07M5szlaDgBRBwUO> Sep 28 08:05:50 mail dovecot: postlogin: Error: could not find a "psql" to execute Sep 28 08:05:51 mail dovecot: imap(soeren@####): Connection closed in=595420 out=2190 ``` dovecot-debug.log: ``` Sep 28 08:05:49 auth: Debug: auth client connected (pid=3446) Sep 28 08:05:50 auth: Debug: client in: AUTH 1 PLAIN service=imap secured session=07M5szlaDgBRBwUO lip=88.99.42.74 rip=81.7.5.14 lport=993 rport=39950 resp=<hidden> Sep 28 08:05:50 auth: Debug: sql(soeren@####,81.7.5.14,<07M5szlaDgBRBwUO>): query: SELECT email AS user, password, '/srv/vmail/####/soeren' AS userdb_home, 1003 AS userdb_uid, 1003 AS userdb_gid, CONCAT('*:bytes=', mb.quota, 'M') AS userdb_quota_rule FROM core_user u INNER JOIN admin_mailbox mb ON u.id=mb.user_id INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE email='soeren@####' AND is_active AND dom.enabled Sep 28 08:05:50 auth: Debug: client passdb out: OK 1 user=soeren@#### Sep 28 08:05:50 auth: Debug: master in: REQUEST 3406561281 3446 1 814b3f8020ff878a661bfcaa1db12ba3 session_pid=3447 request_auth_token Sep 28 08:05:50 auth: Debug: prefetch(soeren@####,81.7.5.14,<07M5szlaDgBRBwUO>): success Sep 28 08:05:50 auth: Debug: master userdb out: USER 3406561281 soeren@#### home=/srv/vmail/####/soeren uid=1003 gid=1003 quota_rule=*:bytes=0M auth_token=4b7b4522ed363b0d1e79e9166e57b0c922339ce4 Sep 28 08:05:50 imap: Debug: Loading modules from directory: /usr/lib64/dovecot Sep 28 08:05:50 imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so Sep 28 08:05:50 imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so Sep 28 08:05:50 imap: Debug: Added userdb setting: plugin/quota_rule=*:bytes=0M Sep 28 08:05:50 imap(soeren@####): Debug: Effective uid=1003, gid=1003, home=/srv/vmail/####/soeren Sep 28 08:05:50 imap(soeren@####): Debug: Quota root: name=User quota backend=dict args=:proxy::quota Sep 28 08:05:50 imap(soeren@####): Debug: Quota rule: root=User quota mailbox=* bytes=0 messages=0 Sep 28 08:05:50 imap(soeren@####): Debug: Quota grace: root=User quota bytes=0 (10%) Sep 28 08:05:50 imap(soeren@####): Debug: dict quota: user=soeren@####, uri=proxy::quota, noenforcing=0 Sep 28 08:05:50 imap(soeren@####): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:~/Maildir Sep 28 08:05:50 imap(soeren@####): Debug: maildir++: root=/srv/vmail/####/soeren/Maildir, index=, indexpvt=, control=, inbox=/srv/vmail/####/soeren/Maildir, alt= ``` Regards Sören
kerem commented 2026-02-27 11:14:43 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Oct 3, 2017):

@smindorf Looks like the psql binary is not available on the standard path. Could you check where it is please? Once done, update the /usr/local/bin/postlogin.sh script and use the absolute path to psql.

<!-- gh-comment-id:333884279 --> @tonioo commented on GitHub (Oct 3, 2017): @smindorf Looks like the psql binary is not available on the standard path. Could you check where it is please? Once done, update the /usr/local/bin/postlogin.sh script and use the absolute path to psql.
kerem commented 2026-02-27 11:14:43 +03:00
Author
Owner
Copy link

@smindorf commented on GitHub (Oct 6, 2017):

@tonioo Ok, here ist is:

# which psql
/bin/psql

I've edited the /usr/local/bin/postlogin.sh file and added the path.

# diff -u postlogin.sh_ori postlogin.sh
--- postlogin.sh_ori    2017-10-06 11:21:18.968028758 +0200
+++ postlogin.sh        2017-10-06 11:18:09.418046534 +0200
@@ -1,6 +1,6 @@
 # This file was automatically installed on 2017-09-22T09:12:59.784109
 #!/bin/sh
 
-psql -c "UPDATE core_user SET last_login=now() WHERE username='$USER'" > /dev/null
+/bin/psql -c "UPDATE core_user SET last_login=now() WHERE username='$USER'" > /dev/null
 
 exec "$@"

I've restarted the dovecot and the log is clean.

Thank you!
Sören

<!-- gh-comment-id:334704260 --> @smindorf commented on GitHub (Oct 6, 2017): @tonioo Ok, here ist is: ``` # which psql /bin/psql ``` I've edited the `/usr/local/bin/postlogin.sh` file and added the path. ``` # diff -u postlogin.sh_ori postlogin.sh --- postlogin.sh_ori 2017-10-06 11:21:18.968028758 +0200 +++ postlogin.sh 2017-10-06 11:18:09.418046534 +0200 @@ -1,6 +1,6 @@ # This file was automatically installed on 2017-09-22T09:12:59.784109 #!/bin/sh -psql -c "UPDATE core_user SET last_login=now() WHERE username='$USER'" > /dev/null +/bin/psql -c "UPDATE core_user SET last_login=now() WHERE username='$USER'" > /dev/null exec "$@" ``` I've restarted the dovecot and the log is clean. Thank you! Sören
kerem commented 2026-02-27 11:14:43 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Oct 6, 2017):

This issue was moved to modoboa/modoboa-installer#159

<!-- gh-comment-id:334805892 --> @tonioo commented on GitHub (Oct 6, 2017): This issue was moved to modoboa/modoboa-installer#159
kerem commented 2026-02-27 11:14:43 +03:00
Author
Owner
Copy link

@jellium commented on GitHub (Mar 2, 2024):

Dear,
I encounter a similar issue with Modoboa and postlogin.sh script for Dovecot.
The error is:

2024-03-02T16:19:05.745936+01:00 MODOBOA dovecot: imap-login: Login: user=<***>, method=PLAIN, rip=***, lip=***, mpid=422643, TLS, session=<v5BiA68Sb+hSQbRc>
2024-03-02T16:19:05.795065+01:00 MODOBOA dovecot: postlogin: Error: Password for user modoboa:
2024-03-02T16:19:05.796863+01:00 MODOBOA dovecot: postlogin: Error: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: fe_sendauth: no password supplied

I have set .pgpass in /srv/modoboa (user modoboa's home directory), explicitly set PGPASSWORD in the script. The script works when calling it through sudo -u modoboa -- /usr/local/bin/postlogin.sh but the error arises in mail.log when actually login with IMAP.

<!-- gh-comment-id:1974828465 --> @jellium commented on GitHub (Mar 2, 2024): Dear, I encounter a similar issue with Modoboa and postlogin.sh script for Dovecot. The error is: ``` 2024-03-02T16:19:05.745936+01:00 MODOBOA dovecot: imap-login: Login: user=<***>, method=PLAIN, rip=***, lip=***, mpid=422643, TLS, session=<v5BiA68Sb+hSQbRc> 2024-03-02T16:19:05.795065+01:00 MODOBOA dovecot: postlogin: Error: Password for user modoboa: 2024-03-02T16:19:05.796863+01:00 MODOBOA dovecot: postlogin: Error: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: fe_sendauth: no password supplied ``` I have set `.pgpass` in /srv/modoboa (user `modoboa`'s home directory), explicitly set `PGPASSWORD` in the script. The script works when calling it through `sudo -u modoboa -- /usr/local/bin/postlogin.sh` but the error arises in `mail.log` when actually login with IMAP.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
fix/sievefilters-allow-email-in-rule-name
dependabot/npm_and_yarn/frontend/axios-1.15.0
translations_04c0b653215cb5fa48ab101eae1a1917_ja_JP
translations_5d93982e9fd6dab991db4faf93ce9ded_ja_JP
fix/login-issue-3995
fix/sievefilters-issues
add-vitepress-openapi
2974-dmarc-empty-email
2.3.x
updated-doc-2.3.0
feature/OIDC
delete-all-alarms
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_af_ZA
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ar
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ca
1.x
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_sk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_tr
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_es_ES
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_uk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_zh_CN
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_de_DE
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_da_DK
1.8.x
1.7.x
1.6.x
1.4.x
1.3.x
1.2.x
2.8.2
2.8.1
2.8.0
2.7.2
2.7.1
2.7.0
2.6.5
2.6.4
2.6.3
2.6.2
2.6.1
2.6.0
2.5.1
2.5.0
2.4.11
2.4.10
2.4.9
2.4.8
2.4.7
2.4.6
2.4.5
2.4.4
2.4.3
2.4.2
2.4.1
2.4.0
2.3.6
2.3.5
2.3.4
2.3.3
2.3.2
2.3.1
2.3.0
2.3.0-beta.4
2.3.0-beta.3
2.3.0-beta.2
2.3.0-beta.1
2.2.4
2.2.3
2.2.2
2.2.1
2.2.0
2.1.2
2.1.1
2.1.0
2.0.5
2.0.4
2.0.3
2.0.2
2.0.1
2.0.0
2.0.0-beta.3
2.0.0-beta.2
2.0.0-beta.1
1.17.0
1.16.1
1.16.0
1.15.0
1.14.0
1.13.1
1.13.0
1.12.2
1.12.1
1.12.0
1.11.1
1.11.0
1.10.7
1.10.6
1.10.5
1.10.4
1.10.3
1.10.2
1.10.1
1.10.0
1.9.1
1.9.0
1.8.3
1.8.2
1.8.1
1.8.0
1.7.4
1.7.3
1.7.2
1.7.1
1.7.0
1.6.3
1.6.2
1.6.1
1.6.0
1.5.3
1.5.2
1.5.1
1.5.0
1.4.5
1.4.4
1.4.3
1.4.2
1.4.1
1.4.0
1.3.5
1.3.4
1.2.2
1.3.3
1.3.2
1.3.1
1.3.0
1.2.1
1.2.0
1.2.0-rc2
1.2.0-rc1
1.1.7
1.1.6
1.1.5
1.1.4
1.1.3
1.1.2
1.1.1
1.1.0
1.0.1
1.0.0
0.9.5
0.9.4
0.9.3
0.9.2
0.9.1
0.9
0.8.8
0.8.7
0.8.6.1
0.8.6
0.8.5
0.8.4
0.8.3
0.8.3-rc1
0.8.2
0.8.1
0.8
0.8-rc2
0.8-rc1
0.7.2
0.7.1
0.7
0.6.1
0.6
0.5
0.3
0.2
0.1
Labels
Clear labels   
bug

   
bug

   
dependencies

   
design

   
documentation

   
duplicate

   
enhancement

   
enhancement

   
enhancement

   
feedback-needed

   
help-needed

   
help-needed

   
installer

   
invalid

   
looking-for-sponsors

   
modoboa-contacts

   
new-ui

   
new-ui

   
pr

   
pull-request

Mirrored from GitHub Pull Request

  
pyconfr

   
python

   
question

   
security

   
stale

   
webmail

   
wontfix
No labels
bug
bug
dependencies
design
documentation
duplicate
enhancement
enhancement
enhancement
feedback-needed
help-needed
help-needed
installer
invalid
looking-for-sponsors
modoboa-contacts
new-ui
new-ui
pr
pull-request
pyconfr
python
question
security
stale
webmail
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/modoboa-modoboa#1007
No description provided.