Ad Widget

Collapse

Error after migration from MySQL to PostgreSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dedisoft
    Junior Member
    • Dec 2013
    • 18

    #1

    Error after migration from MySQL to PostgreSQL

    Hello,

    We have migrated from MySQL to PostgreSQL (with Timescaledb) using pg_loader.

    The process has finished without any errors.

    We can access Zabbix Web frontend without problems.

    But when we check the zabbix_server.log we have these lines:

    30371:20200605:075913.225 cannot find requested PSK identity "xxxxxxxxxxxxxxxxxx"
    30371:20200605:075913.226 failed to accept an incoming connection: from yy.yy.yy.yy: TLS handshake set result code to 1: file ../ssl/t1_lib.c line 2589: error:14201076:SSL routines:tls_choose_sigalg:no suitable signature algorithm: TLS write fatal alert "handshake failure"

    It seems that all PSK agent can't be recognized.

    Have you some suggestion please ?

    Thanks

    Regards,
  • dedisoft
    Junior Member
    • Dec 2013
    • 18

    #2
    Not sur that this is important but we are using PostgreSQL 11 on a remote server.

    Thanks !

    Comment

    • dedisoft
      Junior Member
      • Dec 2013
      • 18

      #3
      Hi,
      Finally after disabling PSK on some proxy/agent, it seems that the problem still occurs
      So database seems to be not to so good.
      How can I check it ?
      Thanks

      Comment

      • dedisoft
        Junior Member
        • Dec 2013
        • 18

        #4
        Hi,
        Problem solved. It was due about missing user right.
        Thanks

        Comment

        Working...