Score:0

zabbix connection to external database

pg flag

0

I am trying to setup zabbix with two database , one on localhost and another on diffrent machine.

zabbix server: 192.168.0.100 external database :192.168.0.154

I setup zabbix with localhostdatabaase and its working perfectly,Then I created sql dump file and put it in external database ie,192.168.0.154, but when I change the database ip in zabbix frontend PHP file it gives me permission denied,Ihave created all the required user in external database ie, [email protected] and assigned it all the permission still its giving permission denied error, also I have edited zabbix_server.conf file. please help struggling from past 3 days.

in flag
Please show the actual output when you check the permissions. You might just have missed a typo. Also show the actual content of the configuration files from Zabbix. Additionally, what distribution are you using?
biplab  avatar
pg flag
Thank you gerald for the suggestion, actually everything was correct except 1 thing, so when setting up the zabbix before using "zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix" I am supposed to put the ipaddress of external database in zabbix-server.conf file "DBHost=192.168.0.154", but the issue was I was adding it after running it . I dont know the exact reason behind it but it worked.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.