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'