[server] prevent returning closed cursor to the database pool In since c8c6ad8 init_repository use repo.internal_cnx() instead of repo.system_source.get_connection() so it use the pool and we should not close cursors from the pool before returning it back. Otherwise we may have "connection already closed" error. This bug only trigger when connection-pool-size = 1. Since we are moving to use a dynamic pooler we need to get this fixed. This does not occur with sqlite since the connection wrapper instantiate new cursor everytime, but this occur with other databases.

     1

from __future__ import print_function

     2

     3

from logilab.common.shellutils import generate_password

     4

from cubicweb.server.utils import crypt_password

     5

     6

for user in rql('CWUser U WHERE U cw_source S, S name "system", U upassword P, U login L').entities():

     7

    salt = user.upassword.getvalue()

     8

    if crypt_password('', salt) == salt:

     9

        passwd = generate_password()

    10

        print('setting random password for user %s' % user.login)

    11

        user.set_attributes(upassword=passwd)

    12

    13

commit()