Table 'users' already exists while importing schema

[mahmood]

Hi
I am able to import create.sql.gz but not schema.sql.gz.

# zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbixdb
Enter password:
# zcat /usr/share/doc/zabbix-proxy-mysql/schema.sql.gz | mysql -uzabbix -p zabbixdb
Enter password:
ERROR 1050 (42S01) at line 1: Table 'users' already exists
root@courseware:/usr/share/doc/zabbix-server-mysql# dpkg -l | grep zabbix
ii  zabbix-apache-conf                    1:4.4.6-1+bionic                                all          Zabbix network monitoring solution - PHP front-end
ii  zabbix-frontend-php                   1:4.4.6-1+bionic                                all          Zabbix network monitoring solution - PHP front-end
ii  zabbix-proxy-mysql                    1:4.4.6-1+bionic                                amd64        Zabbix network monitoring solution - proxy (MySQL)
ii  zabbix-release                        1:4.4-1+bionic                                  all          Zabbix official repository configuration
ii  zabbix-server-mysql                   1:4.4.6-1+bionic                                amd64        Zabbix network monitoring solution - server (MySQL)

Is something wrong here or I can ignore schema?

[Atsushi]

Are Zabbix server and Zabbix proxy built on the same server? If so, create another database for Zabbix proxy.

[mahmood]

I have one machine which should be all server, agent and, if needed, proxy.

I have completed the setup and I can not see the zabbiz console.
Don't know if that is really required.

[Atsushi]

Have you checked the documentation?

https://www.zabbix.com/download?zabbix=4.4&os_distribution=ubuntu&os_version=18.04_bionic&db=mysql&ws=apache

https://www.zabbix.com/download?zabbix=4.4&os_distribution=ubuntu&os_version=18.04_bionic&db=mysql&ws=nginx

What do you call "zabbiz console" the Zabbix's frontend?
If you don't write down what it looks like, you won't be able to predict what the problem is.
Does it time out when accessed from a web browser? Or is a different screen displayed?

[mahmood]

OK. I restarted apache and zabbix server and I saw the web installer and the installation was successful.
I can now see the zabbix dashboard.
However, still I don't know if proxy is really needed.
I just have one machine.

[Atsushi]

If you are monitoring a small number of targets on the same network, you do not need a Zabbix proxy.