I've been researching for hours, and tried many things - can't figure out what the issue is. I followed the upgrade steps to go from 4.4 to 5.x, with Ubuntu 16.04 LTS, and it stopped working after that.
under /home/appliance/ , i created a ".my.cnf"
user permissions look fine?
services running:
Any other thoughts? I know I've seen numerous posts on this, but I've read for hours and tried many things without success.
Code:
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | zabbix | +--------------------+ 2 rows in set (0.00 sec) mysql>
under /home/appliance/ , i created a ".my.cnf"
Code:
[client] user = zabbix password = x
Code:
mysql> SHOW GRANTS FOR CURRENT_USER; +------------------------------------------------------------+ | Grants for zabbix@localhost | +------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'zabbix'@'localhost' | | GRANT ALL PRIVILEGES ON `zabbix`.* TO 'zabbix'@'localhost' | +------------------------------------------------------------+ 2 rows in set (0.00 sec)
Code:
appliance@zabbix:~$ service --status-all [ + ] apache-htcacheclean [ + ] apache2 [ + ] apparmor [ - ] bootmisc.sh [ - ] checkfs.sh [ - ] checkroot-bootclean.sh [ - ] checkroot.sh [ + ] console-setup [ + ] cron [ + ] dbus [ + ] grub-common [ - ] hostname.sh [ - ] hwclock.sh [ - ] keyboard-setup.dpkg-bak [ - ] killprocs [ + ] kmod [ - ] lvm2 [ + ] lvm2-lvmetad [ + ] lvm2-lvmpolld [ - ] mountall-bootclean.sh [ - ] mountall.sh [ - ] mountdevsubfs.sh [ - ] mountkernfs.sh [ - ] mountnfs-bootclean.sh [ - ] mountnfs.sh [ + ] mysql [ + ] netfilter-persistent [ + ] networking [ + ] ondemand [ - ] plymouth [ - ] plymouth-log [ + ] procps [ + ] rc.local [ + ] resolvconf [ + ] rsyslog [ - ] sendsigs [ + ] snmpd [ + ] snmptrapd [ ? ] snmptrapfmt [ + ] ssh [ + ] udev [ - ] umountfs [ - ] umountnfs.sh [ - ] umountroot [ + ] unattended-upgrades [ + ] urandom [ - ] x11-common [ + ] zabbix-agent [ - ] zabbix-java-gateway [ + ] zabbix-server
Comment