Troubleshooting#

This guide provides solutions to common problems encountered while running OpenSPP. It covers issues such as the service failing to start, inability to access the web interface, database connection problems, and background jobs not running. It also includes a procedure for resetting the admin password if it's forgotten.

Service won't start#

Check logs for errors:

sudo journalctl -u openspp -n 50 --no-pager

Common issues:

  • PostgreSQL connection failed: Check db_host and authentication settings

  • Port already in use: Another service using port 8069

  • Permission denied: Check file ownership in /var/lib/openspp/

Cannot access web interface#

  1. Check if service is running:

    sudo systemctl status openspp
sudo ss -tlnp | grep 8069

  2. Check firewall:

    sudo ufw status

  3. Test locally:

    curl -I http://localhost:8069

Database connection issues#

  1. Verify PostgreSQL is running:

    sudo systemctl status postgresql

  2. Test connection:

    sudo -u openspp psql -d postgres -c "SELECT 1;"

  3. Check PostgreSQL authentication:

    sudo cat /etc/postgresql/16/main/pg_hba.conf | grep -E '^(local|host)'

Queue jobs not running#

If background jobs are not being processed:

  1. Check workers configuration:

    grep workers /etc/openspp/odoo.conf

    Should be > 0 (at least 2 for production)

  2. Verify queue_job module is loaded:

    grep server_wide_modules /etc/openspp/odoo.conf

    Should include: base,web,queue_job

  3. Check queue_job database settings:

    grep -A 5 "\[queue_job\]" /etc/openspp/odoo.conf

  4. Restart the service:

    sudo systemctl restart openspp

  5. Monitor jobs in Odoo:

    • Navigate to Settings > Technical > Queue Job > Jobs

    • Check for failed or pending jobs

Reset admin password#

If you forget the admin password for the database:

# Connect to the database
sudo -u openspp openspp-shell --database=openspp_prod

# In the Python shell
>>> self.env['res.users'].browse(2).write({'password': 'new_password'})
>>> self.env.cr.commit()
>>> exit()