Ad Widget

Collapse

The initial sql schema is missing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cfoucher
    Junior Member
    • Oct 2024
    • 5

    #1

    The initial sql schema is missing

    As described in the installation instructions, I ran the following command on a debian server.
    Code:
    apt install zabbix-server-mysql zabbix-frontend-php zabbix-nginx-conf zabbix-agent
    Then, in order to import initial schema and data, I ran the following.
    Code:
    zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix​
    This failed because the file /usr/share/doc/zabbix-server-mysql/create.sql.gz is missing.
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    Zabbix is being downloaded over 4 000 000 times every year for a reason. Download and install Zabbix for free and try it yourself!

    it says to use "server.sql.gz"... not create.sql.gz... It would be good to use up to date instructions...

    Comment

    • cfoucher
      Junior Member
      • Oct 2024
      • 5

      #3
      Thank you for your answer. I forgot to mention that I was trying to install the release 5.0 LTS. The instructions for that release are to use `create.sql.gz`.
      Installation instructions: https://www.zabbix.com/fr/download?zabbix=5.0&os_distribution=debian&os_vers ion=11&components=server_frontend_agent&db=mysql&w s=nginx
      Anyway, I found a file named `/usr/share/zabbix-server-mysql/schema.sql.gz`. I used it and followed the next installation steps.
      Once complete, the server frontend is asking to "Configure DB connection" only leaving the PostgreSQL option.
      How can I select mysql?
      Last edited by cfoucher; 18-10-2024, 10:22.

      Comment

      Working...