Problem with database connection

Question
1

Hello,
I often get some errors when using PI Web UI
The UI shows:

The syslog shows tons of:

Jun 1 18:19:44 pi01 mysqld[1586]: 2017-06-01 18:19:44 139893468551936 [Warning] Aborted connection 136 to db: ‘pi’ user: ‘pi’ host: ‘localhost’ (Got an error reading communication packets)
Jun 1 18:19:44 pi01 mysqld[1586]: 2017-06-01 18:19:44 139893561649920 [Warning] Aborted connection 138 to db: ‘pi’ user: ‘pi’ host: ‘localhost’ (Got an error reading communication packets)

My setup is:
Three nodes galera cluster.
privacyIDEA 2.19
root@pi01:~# uname -a
Linux pi01 4.4.0-78-generic #99-Ubuntu SMP Thu Apr 27 15:29:09 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

Is it normal to get the error? How can I fix it?

Thank you,
Tan

1 Like
2

I recommend getting a galera cluster expert to analyze your setup on a professional basis.

No, usually this it not normal.

3

Hi Cornelinux,
I got the same “Abort connection” eror with single node (pi + mysql) setup. The system is installed with apt-get install privacyidea-nginx command.
Do you have any idea what is causing the problem?

Thank you,
Tan

4

I am sorry.
I am really fed up with your lazy guys enterprise top level questions for free.
If you want to get fucking decent repsonse times get you an SLA or answer questions yourself.

YOU ARE THE COMMUNITY. I.e. you need to answer questions. And if you have answered enought questions, maybe there are others, who will answer yours!

And if you do not like this: Go an use RSA!

1 Like
5

https://www.privacyidea.org/getting-help/

6

Yes I agree, this is a purely SQL problem which isn’t related to PrivacyIDEA. I would recommend using another forum to drop such a question. Maybe this is a good start for you: https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/

7

Hi, (just in case anyone have the same problem with default Ubuntu packages)
After update to latest PI version, the problem still occur with API interface. I resolved it by update pymysql and flask-sqlalchemy using pip.

Regards,
Tan

1 Like
8

hi tran,

i am also having this aborted pakets message,

how did you update pymysql and flask with pip and to which version?

regards