POP3 settings

[mononym]

Hello.

Since some days I get this error message in my Discourse admin dashboard:

Connection to the POP3 server is failing with an authentication error. Please check your POP3 settings.

The settings did work fine previously. Users were also able to repy to posts by email (which I now disabled when the error arised).

I wonder how to check the POP3 settings. Like how to get the mailbox password and verify it in Discourse as well as the used port number...

These are the latest error logs from the discourse instance:

Message (11 copies reported)

Job exception: There is an issue connecting with your hostname: postgresql.

Please check your database configuration and ensure there is a valid connection to your database.

Backtrace

activerecord-7.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:67:in `rescue in new_client'
activerecord-7.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:57:in `new_client'
activerecord-7.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:982:in `connect'
activerecord-7.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:994:in `reconnect'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:662:in `block in reconnect!'
activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:661:in `reconnect!'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:763:in `block in verify!'
activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:754:in `verify!'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:771:in `connect!'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:977:in `block in with_raw_connection'
activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:976:in `with_raw_connection'
activerecord-7.2.2.1/lib/active_record/connection_adapters/postgresql/quoting.rb:128:in `quote_string'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/quoting.rb:76:in `quote'
activerecord-7.2.2.1/lib/active_record/connection_adapters/postgresql/quoting.rb:122:in `quote'
activerecord-7.2.2.1/lib/arel/collectors/substitute_binds.rb:20:in `add_bind'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:757:in `visit_ActiveModel_Attribute'
activerecord-7.2.2.1/lib/arel/visitors/visitor.rb:30:in `visit'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:110:in `block (2 levels) in visit_Arel_Nodes_ValuesList'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:106:in `each'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:106:in `each_with_index'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:106:in `block in visit_Arel_Nodes_ValuesList'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:103:in `each'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:103:in `each_with_index'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:103:in `visit_Arel_Nodes_ValuesList'
activerecord-7.2.2.1/lib/arel/visitors/visitor.rb:30:in `visit'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:894:in `maybe_visit'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:68:in `visit_Arel_Nodes_InsertStatement'
activerecord-7.2.2.1/lib/arel/visitors/visitor.rb:30:in `visit'
activerecord-7.2.2.1/lib/arel/visitors/visitor.rb:11:in `accept'
activerecord-7.2.2.1/lib/arel/visitors/to_sql.rb:18:in `compile'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:43:in `to_sql_and_binds'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:196:in `insert'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/query_cache.rb:27:in `insert'
activerecord-7.2.2.1/lib/active_record/persistence.rb:258:in `block in _insert_record'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:415:in `with_connection'
activerecord-7.2.2.1/lib/active_record/connection_handling.rb:296:in `with_connection'
activerecord-7.2.2.1/lib/active_record/persistence.rb:251:in `_insert_record'
activerecord-7.2.2.1/lib/active_record/persistence.rb:928:in `block in _create_record'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:415:in `with_connection'
activerecord-7.2.2.1/lib/active_record/connection_handling.rb:296:in `with_connection'
activerecord-7.2.2.1/lib/active_record/persistence.rb:925:in `_create_record'
activerecord-7.2.2.1/lib/active_record/counter_cache.rb:201:in `_create_record'
activerecord-7.2.2.1/lib/active_record/locking/optimistic.rb:84:in `_create_record'
activerecord-7.2.2.1/lib/active_record/encryption/encryptable_record.rb:184:in `_create_record'
activerecord-7.2.2.1/lib/active_record/attribute_methods/dirty.rb:240:in `_create_record'
activerecord-7.2.2.1/lib/active_record/callbacks.rb:445:in `block in _create_record'
activesupport-7.2.2.1/lib/active_support/callbacks.rb:101:in `run_callbacks'
activesupport-7.2.2.1/lib/active_support/callbacks.rb:913:in `_run_create_callbacks'
activerecord-7.2.2.1/lib/active_record/callbacks.rb:445:in `_create_record'
activerecord-7.2.2.1/lib/active_record/timestamp.rb:116:in `_create_record'
activerecord-7.2.2.1/lib/active_record/persistence.rb:896:in `create_or_update'
activerecord-7.2.2.1/lib/active_record/callbacks.rb:441:in `block in create_or_update'
activesupport-7.2.2.1/lib/active_support/callbacks.rb:101:in `run_callbacks'
activesupport-7.2.2.1/lib/active_support/callbacks.rb:913:in `_run_save_callbacks'
activerecord-7.2.2.1/lib/active_record/callbacks.rb:441:in `create_or_update'
activerecord-7.2.2.1/lib/active_record/timestamp.rb:127:in `create_or_update'
activerecord-7.2.2.1/lib/active_record/persistence.rb:426:in `save!'
activerecord-7.2.2.1/lib/active_record/validations.rb:54:in `save!'
activerecord-7.2.2.1/lib/active_record/transactions.rb:366:in `block in save!'
activerecord-7.2.2.1/lib/active_record/transactions.rb:418:in `block (2 levels) in with_transaction_returning_status'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:616:in `block in within_new_transaction'
activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:613:in `within_new_transaction'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:361:in `transaction'
activerecord-7.2.2.1/lib/active_record/transactions.rb:414:in `block in with_transaction_returning_status'
activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `with_connection'
activerecord-7.2.2.1/lib/active_record/connection_handling.rb:296:in `with_connection'
activerecord-7.2.2.1/lib/active_record/transactions.rb:410:in `with_transaction_returning_status'
activerecord-7.2.2.1/lib/active_record/transactions.rb:366:in `save!'
activerecord-7.2.2.1/lib/active_record/suppressor.rb:56:in `save!'
activerecord-7.2.2.1/lib/active_record/persistence.rb:55:in `create!'
mini_scheduler-0.18.0/lib/mini_scheduler/manager.rb:128:in `process_queue'
mini_scheduler-0.18.0/lib/mini_scheduler/manager.rb:77:in `worker_loop'
mini_scheduler-0.18.0/lib/mini_scheduler/manager.rb:63:in `block (2 levels) in ensure_worker_threads'

Message (1734 copies reported)

Job exception: unexpected return

Backtrace

/app/code/app/jobs/regular/user_email.rb:19:in `block in <class:UserEmail>'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:198:in `delay_for'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:174:in `process_retry'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:129:in `rescue in local'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:112:in `local'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:135:in `block (5 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq.rb:44:in `block in <module:Sidekiq>'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:131:in `block (4 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:263:in `stats'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:126:in `block (3 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_logger.rb:13:in `call'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:125:in `block (2 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:80:in `global'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:124:in `block in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_logger.rb:39:in `prepare'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:123:in `dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:168:in `process'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:78:in `process_one'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:68:in `run'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/component.rb:8:in `watchdog'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/component.rb:17:in `block in safe_thread'

Message (1702 copies reported)

Job exception: Net::SMTPServerBusy

Backtrace

/app/code/vendor/bundle/ruby/3.3.0/gems/net-smtp-0.5.0/lib/net/smtp.rb:1036:in `check_response'
/app/code/vendor/bundle/ruby/3.3.0/gems/net-smtp-0.5.0/lib/net/smtp.rb:676:in `do_start'
/app/code/vendor/bundle/ruby/3.3.0/gems/net-smtp-0.5.0/lib/net/smtp.rb:642:in `start'
/app/code/vendor/bundle/ruby/3.3.0/gems/mail-2.8.1/lib/mail/network/delivery_methods/smtp.rb:109:in `start_smtp_session'
/app/code/vendor/bundle/ruby/3.3.0/gems/mail-2.8.1/lib/mail/network/delivery_methods/smtp.rb:100:in `deliver!'
/app/code/vendor/bundle/ruby/3.3.0/gems/mail-2.8.1/lib/mail/message.rb:269:in `deliver!'
/home/cloudron/rbenv/versions/3.3.6/lib/ruby/3.3.0/delegate.rb:87:in `method_missing'
/app/code/lib/email/sender.rb:296:in `send'
/app/code/app/jobs/regular/user_email.rb:79:in `send_user_email'
/app/code/app/jobs/regular/user_email.rb:39:in `execute'
/app/code/app/jobs/base.rb:316:in `block (2 levels) in perform'
/app/code/vendor/bundle/ruby/3.3.0/gems/rails_multisite-6.1.0/lib/rails_multisite/connection_management/null_instance.rb:49:in `with_connection'
/app/code/vendor/bundle/ruby/3.3.0/gems/rails_multisite-6.1.0/lib/rails_multisite/connection_management.rb:21:in `with_connection'
/app/code/app/jobs/base.rb:303:in `block in perform'
/app/code/app/jobs/base.rb:299:in `each'
/app/code/app/jobs/base.rb:299:in `perform'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:202:in `execute_job'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:170:in `block (2 levels) in process'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/middleware/chain.rb:177:in `block in invoke'
/app/code/lib/sidekiq/pausable.rb:132:in `call'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/middleware/chain.rb:179:in `block in invoke'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/middleware/chain.rb:182:in `invoke'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:169:in `block in process'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:136:in `block (6 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:113:in `local'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:135:in `block (5 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq.rb:44:in `block in <module:Sidekiq>'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:131:in `block (4 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:263:in `stats'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:126:in `block (3 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_logger.rb:13:in `call'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:125:in `block (2 levels) in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_retry.rb:80:in `global'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:124:in `block in dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/job_logger.rb:39:in `prepare'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:123:in `dispatch'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:168:in `process'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:78:in `process_one'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/processor.rb:68:in `run'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/component.rb:8:in `watchdog'
/app/code/vendor/bundle/ruby/3.3.0/gems/sidekiq-6.5.12/lib/sidekiq/component.rb:17:in `block in safe_thread'

[james]

Hello @mononym
Please confirm that you have read the documentation https://docs.cloudron.io/packages/discourse/#incoming-email-setup and can confirm that the used mailbox still has pop3 enabled.

Job exception: There is an issue connecting with your hostname: postgresql.

Please check if you postgresql service might be running out of ram see => https://docs.cloudron.io/services/#configure

Job exception: Net::SMTPServerBusy

Please also check if the mail service might be running out of ram.

Does the mail service have any logs for the giving error timing?

[mononym]

Thx. @james said in POP3 settings:

Please confirm that you have read the documentation https://docs.cloudron.io/packages/discourse/#incoming-email-setup and can confirm that the used mailbox still has pop3 enabled.

Yes. All setings are as described in the docs. I also enabled email in again for testing.

Please check if you postgresql service might be running out of ram see => https://docs.cloudron.io/services/#configure

I raised the limit and the site is much faster now

Please also check if the mail service might be running out of ram.

Memory was at 30%, added a little more RAM.

Does the mail service have any logs for the giving error timing?

I checked logs.html?id=mail and don't see logs related to the Discourse domain. Most seems related to incoming spam. At the top there are these lines about auth/login:

Jun 10 15:29:26 doveconf: Warning: service auth { client_limit=1000 } is lower than required under max. load (1300). Counted for protocol services with service_count != 1: service managesieve-login { process_limit=100 } + service pop3-login { process_limit=500 } + service lmtp { process_limit=100 } + service imap-urlauth-login { process_limit=100 } + service imap-login { process_limit=500 }
Jun 10 15:29:26 doveconf: Warning: service anvil { client_limit=1000 } is lower than required under max. load (1203). Counted with: service managesieve-login { process_limit=100 } + service pop3-login { process_limit=500 } + service imap-urlauth-login { process_limit=100 } + service imap-login { process_limit=500 } + service auth { process_limit=1 }
Jun 10 15:29:26 Warning: service auth { client_limit=1000 } is lower than required under max. load (1300). Counted for protocol services with service_count != 1: service managesieve-login { process_limit=100 } + service pop3-login { process_limit=500 } + service lmtp { process_limit=100 } + service imap-urlauth-login { process_limit=100 } + service imap-login { process_limit=500 }
Jun 10 15:29:26 Warning: service anvil { client_limit=1000 } is lower than required under max. load (1203). Counted with: service managesieve-login { process_limit=100 } + service pop3-login { process_limit=500 } + service imap-urlauth-login { process_limit=100 } + service imap-login { process_limit=500 } + service auth { process_limit=1 }

[james]

@mononym said in POP3 settings:

I raised the limit and the site is much faster now

Already one big bonus and might be hinted towards the right direction.

Is the issue still persistent?