Mailing List Archive

After system updates: TracError: Unsupported database type "postgres"
We are using Trac-1.4, installed via pip2 in user $HOME.
Server is nginx with uwsgi.

The distribution uwsgi has dropped python2.7 support. So I restored
/usr/lib64/uwsgi/python27_plugin.so
from the backups and seems to be starting now.

But the next issue is missing postgres support:
Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
Unsupported database type "postgres"

Our database is postgres-11, the system packages have dropped python2.7
support as well. What can I do?

Best regards.

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/10769ad4-cd66-4e95-882e-1f43db59a19eo%40googlegroups.com.
Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
Am Mittwoch, 5. August 2020 13:08:52 UTC+2 schrieb Mo:
>
> But the next issue is missing postgres support:
> Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
> Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
> Unsupported database type "postgres"
>

The postgres issue I got solved by
pip2 install --user psycopg2

Next issue was, Genshi is missing. This I got solved by
pip2 install --user Genshi

Now Trac is up again.
But just for understanding, why did I need to install those 2 packages,
which have not been required before?

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/c2a6fb57-38cc-48e6-8c6d-ef821be40046o%40googlegroups.com.
Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
On Wednesday, August 5, 2020 at 4:21:40 AM UTC-7 Mo wrote:

>
> Am Mittwoch, 5. August 2020 13:08:52 UTC+2 schrieb Mo:
>>
>> But the next issue is missing postgres support:
>> Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
>> Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
>> Unsupported database type "postgres"
>>
>
> The postgres issue I got solved by
> pip2 install --user psycopg2
>
> Next issue was, Genshi is missing. This I got solved by
> pip2 install --user Genshi
>
> Now Trac is up again.
> But just for understanding, why did I need to install those 2 packages,
> which have not been required before?
>

The packages have always been required. I guess they were installed by your
package manager in the past.

- Ryan

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/f270b106-5d88-4d94-8853-a7afac05ed33n%40googlegroups.com.
Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
when i try your cmd pip2 install --user psycopg2 i have this error
Could not fetch URL https://pypi.python.org/simple/pymysql/: There was a
problem confirming the ssl certificate: [SSL: CERTIFICATE_VERIFY_FAILED]
certificate verify failed (_ssl.c:727) - skipping
On Wednesday, August 5, 2020 at 12:21:40 PM UTC+1 Mo wrote:

>
> Am Mittwoch, 5. August 2020 13:08:52 UTC+2 schrieb Mo:
>>
>> But the next issue is missing postgres support:
>> Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
>> Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
>> Unsupported database type "postgres"
>>
>
> The postgres issue I got solved by
> pip2 install --user psycopg2
>
> Next issue was, Genshi is missing. This I got solved by
> pip2 install --user Genshi
>
> Now Trac is up again.
> But just for understanding, why did I need to install those 2 packages,
> which have not been required before?
>

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/dec4a97a-cb77-47af-bfa5-e71db304d8a0n%40googlegroups.com.
Re: Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
On Wed, Sep 30, 2020 at 9:30 AM 'BRAIEK Aymen' via Trac Users <
trac-users@googlegroups.com> wrote:

> when i try your cmd pip2 install --user psycopg2 i have this error
> Could not fetch URL https://pypi.python.org/simple/pymysql/: There was a
> problem confirming the ssl certificate: [SSL: CERTIFICATE_VERIFY_FAILED]
> certificate verify failed (_ssl.c:727) - skipping


Could you try this?:

https://pypi.org/simple/pymysql/

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CA%2BBGpn-w46phD7w3ftPPM6wOeAjOa6h%3DNqo%3DRWuETJ7n5N7Dsg%40mail.gmail.com.
Re: Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
i am new on trac
i need really doc describe all setup to install PyMysql and create new
project instance with mysql
plz

On Wed, Sep 30, 2020 at 5:31 PM Ryan Ollos <rjollos@gmail.com> wrote:

>
>
> On Wed, Sep 30, 2020 at 9:30 AM 'BRAIEK Aymen' via Trac Users <
> trac-users@googlegroups.com> wrote:
>
>> when i try your cmd pip2 install --user psycopg2 i have this error
>> Could not fetch URL https://pypi.python.org/simple/pymysql/: There was
>> a problem confirming the ssl certificate: [SSL: CERTIFICATE_VERIFY_FAILED]
>> certificate verify failed (_ssl.c:727) - skipping
>
>
> Could you try this?:
>
> https://pypi.org/simple/pymysql/
>
>
>
> --
> 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@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/trac-users/CA%2BBGpn-w46phD7w3ftPPM6wOeAjOa6h%3DNqo%3DRWuETJ7n5N7Dsg%40mail.gmail.com
> <https://groups.google.com/d/msgid/trac-users/CA%2BBGpn-w46phD7w3ftPPM6wOeAjOa6h%3DNqo%3DRWuETJ7n5N7Dsg%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CANtrRDPDSEWTu5sQx8_8Aa587fFGTYv8SYZLUgumMDLROeRsHQ%40mail.gmail.com.
Re: Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
Hey guys,

Just a Site node here , are you wanna install a mysql or a postgres
package? Because this url Doesn't look like a postgres package

Cheers

Markus

Ryan Ollos <rjollos@gmail.com> schrieb am Mi., 30. Sep. 2020, 18:31:

>
>
> On Wed, Sep 30, 2020 at 9:30 AM 'BRAIEK Aymen' via Trac Users <
> trac-users@googlegroups.com> wrote:
>
>> when i try your cmd pip2 install --user psycopg2 i have this error
>> Could not fetch URL https://pypi.python.org/simple/pymysql/: There was
>> a problem confirming the ssl certificate: [SSL: CERTIFICATE_VERIFY_FAILED]
>> certificate verify failed (_ssl.c:727) - skipping
>
>
> Could you try this?:
>
> https://pypi.org/simple/pymysql/
>
>
>
> --
> 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@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/trac-users/CA%2BBGpn-w46phD7w3ftPPM6wOeAjOa6h%3DNqo%3DRWuETJ7n5N7Dsg%40mail.gmail.com
> <https://groups.google.com/d/msgid/trac-users/CA%2BBGpn-w46phD7w3ftPPM6wOeAjOa6h%3DNqo%3DRWuETJ7n5N7Dsg%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAJ4osO%3DfoURsTREWm9snu9fW7qbPGsoCp%2B1jMt1JBfZGTqgFVg%40mail.gmail.com.
Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
Mo schrieb am Mittwoch, 5. August 2020 um 13:08:52 UTC+2:

> But the next issue is missing postgres support:
> Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
> Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
> Unsupported database type "postgres"
>

As the linux distribution is dropping python2.7, I have installed python
2.7 locally at $HOME/bin

pip2 was installed by
curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py

As the PYTHONDIR has changed to ~/lib/python2.7/site-packages/ I
re-installed all packages by
pip2 install -Ur requirements_file

What I have installed now:
$ pip2 list 2>/dev/null
Package Version
--------------------------- ----------
arabic-reshaper 2.1.0
configparser 4.0.2
future 0.18.2
Genshi 0.7.3
html5lib 1.1
ImportExportXLS 0.3
Jinja2 2.11.2
KeepInterfaceSimple2Plugin 2.6
MarkupSafe 1.1.1
Pillow 6.2.2
pip 20.2.3
psycopg2 2.8.6
pymills 3.4.2
PyPDF2 1.26.0
python-bidi 0.4.2
reportlab 3.5.53
setuptools 44.1.1
six 1.15.0
ticketsboardplugin 1.2.3.dev0
Trac 1.4.2
trac-IncludeSource 0.5.1
TracAccountManager 0.5.0
TracAutocompleteUsersPlugin 0.4.6
TracCodeReviewer 1.0.0.dev0
TracComponentDependency 0.3
TracDiscussion 1.2.1
TracEstimationTools 0.5.0
TracFieldTooltip 0.8.5
TracFullBlog 0.2.dev0
TracHTTPAuth 1.2
TracIncludeMacro 3.1.0
TracLoomingClouds 1.0.dev0
TracMenus 0.3.0
TracPdfPreview 0.1.2
TracQuiet 1.2.1
TracSimpleMultiProject 0.7.2.dev0
TracTags 0.11
TracWikiAutoComplete 1.4
TracWikiExtras 1.3.1
TracWikiPrint 3.0.dev0
TracXMLRPC 1.1.9.dev0
webencodings 0.5.1
wheel 0.35.1
xhtml2pdf 0.2.5
xlrd 1.2.0
xlwt 1.3.0

But Trac is not starting:

Trac[loader] DEBUG: Loading plugin "tractags.xmlrpc" from
"/mnt/data/trac/lib/python2.7/site-packages"
Trac[loader] DEBUG: Loading plugin "tracwikiextras" from
"/mnt/data/trac/lib/python2.7/site-packages"
Trac[loader] DEBUG: Loading plugin "tracworkflowadmin.web_ui" from
"/mnt/data/trac/projects/trac-pp/plugins/TracWorkflowAdmin-0.12.0.6-py2.7.egg"
Trac[loader] DEBUG: Loading plugin "wikiautocomplete.web_ui" from
"/mnt/data/trac/lib/python2.7/site-packages"
Trac[loader] DEBUG: Loading plugin "wikiprint.formats" from
"/mnt/data/trac/lib/python2.7/site-packages"
Trac[loader] DEBUG: Loading plugin "wikiprint.web_ui" from
"/mnt/data/trac/lib/python2.7/site-packages"
Trac[loader] DEBUG: Loading plugin "wikiprint.wikiprint" from
"/mnt/data/trac/lib/python2.7/site-packages"
Trac[loader] DEBUG: Loading plugin "wikitable.scalar" from
"/mnt/data/trac/projects/trac-pp/plugins/WikiTableMacro-0.3.dev0-py2.7.egg"
Trac[loader] DEBUG: Loading plugin "wikitable.table" from
"/mnt/data/trac/projects/trac-pp/plugins/WikiTableMacro-0.3.dev0-py2.7.egg"
Trac[loader] DEBUG: Loading file plugin AZ_NotificationSubscriber from
/mnt/data/trac/projects/trac-pp/plugins/AZ_NotificationSubscriber.py
Trac[default_workflow] DEBUG: Workflow actions at initialization:
defaultdict(<type 'dict'>, {u'resolve': {u'operations':
[u'set_resolution'], 'name': '', u'default': 998, 'newstate': u'closed',
'label': u'resolve', 'oldstates': [u'new', u'assigned', u'accepted',
u'reopened'], u'permissions': [u'TICKET_MODIFY']}, u'create':
{'operations': [], 'name': '', u'default': 1000, 'newstate': u'new',
'label': u'create', 'oldstates': [None], 'permissions': []}, u'accept':
{u'operations': [u'set_owner_to_self'], 'name': '', u'default': 997,
'newstate': u'accepted', 'label': u'accept', 'oldstates': [u'new',
u'assigned', u'accepted', u'reopened'], u'permissions':
[u'TICKET_MODIFY']}, u'leave': {u'operations': [u'leave_status'], 'name':
'', u'default': 999, 'newstate': u'*', 'label': u'leave', 'oldstates':
[None, u'new', u'assigned', u'accepted', u'closed', u'reopened'],
'permissions': []}, u'reopen': {u'operations': [u'del_resolution'], 'name':
'', u'default': 996, 'newstate': u'reopened', 'label': u'reopen',
'oldstates': [u'closed'], u'permissions': [u'TICKET_MODIFY']},
u'create_and_assign': {u'operations': [u'may_set_owner'], 'name': '',
u'default': 995, 'newstate': u'assigned', 'label': u'create and assign',
'oldstates': [None], u'permissions': [u'TICKET_MODIFY']}, u'reassign':
{u'operations': [u'set_owner'], 'name': '', u'default': 994, 'newstate':
u'assigned', 'label': u'reassign', 'oldstates': [u'new', u'assigned',
u'accepted', u'reopened'], u'permissions': [u'TICKET_MODIFY']}, '_reset':
{'operations': ['reset_workflow'], 'default': 0, 'newstate': 'new',
'label': 'Reset', 'oldstates': [], 'permissions': ['TICKET_ADMIN']}})
Trac[web_ui] DEBUG: Ticketsboard: assignReviewer plugin part is present
Trac[env] WARNING: Component <Component trac.db.api.DatabaseManager> failed
with TracError: Unsupported database type "postgres"
Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
Unsupported database type "postgres"

psycopg2 is installed, but the versions may have changed.
How can I get that running again?

~Mo

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/5a6f8a87-2442-4ac2-baf3-b0efd5075586n%40googlegroups.com.
Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
Mo schrieb am Donnerstag, 15. Oktober 2020 um 09:35:32 UTC+2:

>
> Trac[env] ERROR: Exception caught while checking for upgrade: TracError:
> Unable to check for upgrade of trac.db.api.DatabaseManager: TracError:
> Unsupported database type "postgres"
>
> psycopg2 is installed, but the versions may have changed.
> How can I get that running again?
>
>
I also tried setting
trac.db.postgres_backend.postgresqlconnector = enabled
but does not solve it.

~Mo

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/8c9547bf-4114-4389-9781-8ce51b3a941dn%40googlegroups.com.
Re: After system updates: TracError: Unsupported database type "postgres" [ In reply to ]
I got that fixed by installing everying like pip, setuptools, Trac and
plugins and uWSGI inside a virtualenv. After that I made a copy of my
system uwsgi-init-script and changed UWSGI_EXEC to use the virtualenv uwsgi
executable.

--
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@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/a9314b0a-9510-4b9e-8c96-4e7e35912590n%40googlegroups.com.