conn.encoders[SafeBytes] = conn.encoders[bytes] error

[Shubha Ramani]

I am using RHEL 8 (8.5)

Unfortunately a very old mysql db server 5.7.18 MySQL Community Server

Had to change the /etc/openssl.conf to handle TLS version 1.0

ReviewBoard-4.0.4-venv/bin/rb-site install succeeded.

I'm getting:
Something broke! (Error 500)

It appears something broke when you tried to go to here. This is either a bug in Review Board or a server configuration error. Please report this to your administrator.

However
 ReviewBoard-4.0.4-venv/bin/rb-site /webapp/reviewboard/site_prod/ list-siteconfig 
produces:

  File "/webapp/PYTHON_VENVS/ReviewBoard-4.0.4-venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 887, in execute_sql
    cursor = self.connection.cursor()
  File "/webapp/PYTHON_VENVS/ReviewBoard-4.0.4-venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 254, in cursor
    return self._cursor()
  File "/webapp/PYTHON_VENVS/ReviewBoard-4.0.4-venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 229, in _cursor
    self.ensure_connection()
  File "/webapp/PYTHON_VENVS/ReviewBoard-4.0.4-venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
    self.connect()
  File "/webapp/PYTHON_VENVS/ReviewBoard-4.0.4-venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/webapp/PYTHON_VENVS/ReviewBoard-4.0.4-venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 276, in get_new_connection
    conn.encoders[SafeBytes] = conn.encoders[bytes]
KeyError: <class 'bytes'>

[Christian Hammond]

Looks like it's trying to access something from the MySQLdb module that isn't available on your install.

Can you run the following and show the results:

    pip3.9 list | grep -i mysql

Christian

--
Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups "Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/7029df4f-6442-41c6-88ef-24ddf28c83een%40googlegroups.com.

--

Christian Hammond

President/CEO of Beanbag

Makers of Review Board

[Franco Sabini]

Hello,

I'm on RHEL 8.5 too and getting the same error.

pip3.8 list|grep -i mysql
mysqlclient             2.1.0

thanks

Franco

[Franco Sabini]

Hello,

apparently the issue was that we have mysql 8 installed on our host.

Is there any way to have reviewboard working with that version ?

thanks

Franco

[Christian Hammond]

Looks like it's an incompatibility with mysqlclient 2.1 and MySQL. Technically, a compatibility change/workaround that was removed. We'll be making a change in Review Board 4.0.5 to the dependency to cap it, but for now, both of you can try:

    pip3 install "mysqlclient~=2.0"

(Use pip3 or pip3.9 or whatever is appropriate for your setup.)

Restart your web server, and things should work again.

Christian

To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/3cb7a8b6-8501-4c18-847e-36b0eb6f3f1fn%40googlegroups.com.

[Franco Sabini]

Hello Christian,

I'll try downgrading mysqlclient, thanks

We have installed reviewboard with sqlite for evaluation. We'll use mysql for production.

thanks!

[Vlad S.]

Thanks

 pip install mysqlclient==2.0.3 worked for me with python 3.8 venv.

пятница, 31 декабря 2021 г. в 13:28:51 UTC+3, franco...@gmail.com: