output_mysql: No result set to fetch from.

[bentech4u]

Hello,

i have new cowrie installation under python 3.9.13 virtualenv
List of packages:

Package            Version
------------------ ---------
appdirs            1.4.4
attrs              22.1.0
Automat            22.10.0
bcrypt             4.0.1
certifi            2022.9.24
cffi               1.15.1
charset-normalizer 2.1.1
configparser       5.2.0
constantly         15.1.0
cryptography       38.0.4
hyperlink          21.0.0
idna               3.4
incremental        22.10.0
mysql-connector    2.2.9
packaging          21.3
pip                22.3.1
pyasn1             0.4.8
pyasn1-modules     0.2.8
pycparser          2.21
pyOpenSSL          22.1.0
pyparsing          3.0.9
python-dateutil    2.8.2
requests           2.28.1
service-identity   21.1.0
setuptools         65.6.3
six                1.16.0
tftpy              0.8.2
treq               22.2.0
Twisted            22.4.0
typing_extensions  4.4.0
urllib3            1.26.13
wheel              0.38.4
zope.interface     5.5.2

i am getting below error in cowrie.log

2022-12-06T07:29:34.709158Z [HoneyPotSSHTransport,3,xx.xx.xx.xx] Rollback failed
        Traceback (most recent call last):
          File "/home/cowrie/cowrie-env/lib/python3.9/site-packages/twisted/python/threadpool.py", line 260, in <lambda>
            inContext.theWork = lambda: context.call(  # type: ignore[attr-defined]
          File "/home/cowrie/cowrie-env/lib/python3.9/site-packages/twisted/python/context.py", line 117, in callWithContext
            return self.currentContext().callWithContext(ctx, func, *args, **kw)
          File "/home/cowrie/cowrie-env/lib/python3.9/site-packages/twisted/python/context.py", line 82, in callWithContext
            return func(*args, **kw)
          File "/home/cowrie/COWRIE/src/cowrie/output/mysql.py", line 38, in _runInteraction
            return adbapi.ConnectionPool._runInteraction(self, interaction, *args, **kw)
        --- <exception caught here> ---
          File "/home/cowrie/cowrie-env/lib/python3.9/site-packages/twisted/enterprise/adbapi.py", line 449, in _runInteraction
            conn.rollback()
          File "/home/cowrie/cowrie-env/lib/python3.9/site-packages/twisted/enterprise/adbapi.py", line 66, in rollback
            raise ConnectionLost()
        twisted.enterprise.adbapi.ConnectionLost: 

2022-12-06T07:29:34.709757Z [-] output_mysql: MySQL Error: (-1, 'No result set to fetch from.', None)

[micheloosterhof]

it seems you lost the connection to MySQL.
Has this ever worked successfully or has it never worked before?
What is your MySQL configuration statement?

[bentech4u]

Hello,

yes it worked. i think i have installed some devel packages .

[dhy0110]

Hello,

I want to know if you have solved the problem, because I'm in the same boat.