Ad Widget

Collapse

Recurring Configure DB connection...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mcponcall
    Junior Member
    • Jan 2024
    • 3

    #1

    Recurring Configure DB connection...

    Unable to select configuration.

    Distributor ID: Ubuntu
    Description: Ubuntu 22.04.3 LTS
    Release: 22.04
    Codename: jammy

    Zabbix Version 6.4

    None of the answers have resolved my issue. Please help.

    How long does "zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix" usually run?​
  • yeragan
    Junior Member
    • Dec 2023
    • 5

    #2
    This command runs for atlease 3 mins and max it runs for 5 mins.Dont interupt while the same is running.

    Comment

    • mcponcall
      Junior Member
      • Jan 2024
      • 3

      #3
      Thank you for your reply. However, the process never ends, at least within the hour...

      Comment

      • Hamardaban
        Senior Member
        Zabbix Certified SpecialistZabbix Certified Professional
        • May 2019
        • 2713

        #4
        The text file server.sql contains lines of sql commands.
        You can connect to the database server (mysql --default-character-set=utf8mb4 -uzabbix -p zabbix") and execute these lines sequentially one by one and see where the error will be.
        But of course, first of all you need to look at what mysql writes to its logs.​

        Comment

        Working...