Re: [Trac] Trac error: upgrade of trac.db.api.DatabaseManager: Unsupported database type "postgres"

On 2025/02/22 23:59, 'Joost Kraaijeveld' via Trac Users wrote:
> The line saying "2025-02-22 15:49:44,797 Trac[loader] DEBUG: Skipping
> "trac.db.postgres = trac.db.postgres_backend": DistributionNotFound:
> The 'psycopg2>=2.0 or psycopg2-binary' distribution was not found and
> is required by Trac" is wrong. I have psycopg2 2.9.10-1 installed

Your created trac debian package is broken.
The error is not occurred with debian:trixie-slim image and python3-psycopg2.

# apt install -yqq subversion python3-psycopg2 python3.13-venv
# python3 -m venv --system-site-packages /tmp/venv
# /tmp/venv/bin/pip install svn+https://svn.edgewall.org/repos/trac/branches/1.6-stable
# /tmp/venv/bin/trac-admin /tmp/tracenv initenv 'My Project' 'postgres://tracuser:[email protected]/trac?schema=debian_trixie'
# /tmp/venv/bin/trac-admin /tmp/tracenv config set logging log_level DEBUG
# /tmp/venv/bin/trac-admin /tmp/tracenv config set logging log_type stderr
# /tmp/venv/bin/trac-admin /tmp/tracenv upgrade
15:57:41 Trac[env] INFO: -------------------------------- environment startup [Trac 1.6.1.dev0] --------------------------------
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.about" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.admin.console" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.admin.web_ui" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.attachment" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.db.mysql" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Skipping "trac.db.mysql = trac.db.mysql_backend [mysql]": DistributionNotFound: The 'PyMySQL; extra == "mysql"' distribution was not found and is required by the application
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.db.postgres" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.db.sqlite" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.mimeview.patch" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.mimeview.pygments" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.mimeview.rst" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.mimeview.txtl" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Skipping "trac.mimeview.txtl = trac.mimeview.txtl [textile]": DistributionNotFound: The 'textile>=2.3; extra == "textile"' distribution was not found and is required by the application
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.notification.api" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.notification.mail" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.notification.prefs" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.prefs" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.search" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.admin" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.batch" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.notification" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.query" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.report" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.roadmap" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.ticket.web_ui" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.timeline" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.versioncontrol.admin" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.versioncontrol.svn_authz" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.versioncontrol.web_ui" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.web.auth" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.web.main" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.web.session" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.wiki.admin" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.wiki.interwiki" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.wiki.macros" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.wiki.web_api" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "trac.wiki.web_ui" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.perm.authz_policy" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.perm.config_perm_provider" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.ticket.clone" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.ticket.commit_updater" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.ticket.deleter" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.versioncontrol.git.git_fs" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.versioncontrol.svn.svn_fs" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[loader] DEBUG: Loading plugin "tracopt.versioncontrol.svn.svn_prop" from "/tmp/venv/lib/python3.13/site-packages"
15:57:41 Trac[default_workflow] DEBUG: Workflow actions at initialization: defaultdict(<class 'dict'>, {'accept': {'oldstates': ['new', 'assigned', 'accepted', 'reopened'], 'newstate': 'accepted', 'operations': ['set_owner_to_self'], 'permissions': ['TICKET_MODIFY'], 'label': 'accept', 'name': '', 'default': 0}, 'create': {'oldstates': [None], 'newstate': 'new', 'default': 1, 'label': 'create', 'name': '', 'operations': [], 'permissions': []}, 'create_and_assign': {'oldstates': [None], 'newstate': 'assigned', 'label': 'assign', 'operations': ['may_set_owner'], 'permissions': ['TICKET_MODIFY'], 'name': '', 'default': 0}, 'leave': {'oldstates': ['*'], 'newstate': '*', 'default': 1, 'operations': ['leave_status'], 'label': 'leave', 'name': '', 'permissions': []}, 'reassign': {'oldstates': ['new', 'assigned', 'accepted', 'reopened'], 'newstate': 'assigned', 'operations': ['set_owner'], 'permissions': ['TICKET_MODIFY'], 'label': 'reassign', 'name': '', 'default': 0}, 'reopen': {'oldstates': ['closed'], 'newstate': 'reopened', 'operations': ['del_resolution'], 'permissions': ['TICKET_CREATE'], 'label': 'reopen', 'name': '', 'default': 0}, 'resolve': {'oldstates': ['new', 'assigned', 'accepted', 'reopened'], 'newstate': 'closed', 'operations': ['set_resolution'], 'permissions': ['TICKET_MODIFY'], 'label': 'resolve', 'name': '', 'default': 0}, '_reset': {'default': 0, 'label': 'Reset', 'newstate': 'new', 'oldstates': [], 'operations': ['reset_workflow'], 'permissions': ['TICKET_ADMIN']}})

Database is up to date, no upgrade necessary.


-- 
Jun Omae <[email protected]> (大前 潤)

-- 
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
To view this discussion visit https://groups.google.com/d/msgid/trac-users/2d442a8b-25f2-4481-a7ef-d5e455c50d3d%40gmail.com.