Free Network Monitoring

[Jaan]

latest phone pic

 

[tdk1069]

I've had no hands on with Pi's so take with salt..

 

try something like ps aux | grep -i sql

(i'm assuming an sql not mariadb service)

 

Hopefully you will see something like :

 

sql 2570457 10.4 3.6 4988572 602036 ? Ssl Feb23 7198:35 mysqld --character-set-server=utf8mb4..................

 

to at least confirm it's running.

[Jaan]

tried a few other things also... here's the output;

 

[PotNoodleTech]

 

Here is how I have our system set up:

 

[ATTACH=CONFIG]63376[/ATTACH]

 

[ATTACH=CONFIG]63377[/ATTACH]

 

[ATTACH=CONFIG]63378[/ATTACH]

 

We also have ours displaying on a 48" tv on our office wall cycling through a variety of views. My plan is to have this monitoring all of our switches but we are in the midst of replacing them so I finish this off once complete.

 

[ATTACH=CONFIG]63380[/ATTACH]

 

Any questions just reply here and I'll try and help.

 

Dang man - I really want your set up but I really dont want the hours of setting it up. :-/

[tdk1069]

Try just

systemctl start mysqld

 

rather than zabbix-server-mysql

[Jaan]

Dang man - I really want your set up but I really dont want the hours of setting it up. :-/

 

mee too! om on day two at the moment of trying to get it installed, let alone configuring it!

[Jaan]

Try just

systemctl start mysqld

 

rather than zabbix-server-mysql

 

"Service not found"

[Jaan]

wonder if a zabbix appliance would be better at this point on the Hyper-v cluster!

[Jaan]

this is the exact issue i'm having

 

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/405240-installing-and-stuck-at-create-initial-database-unable-to-log-in

[tdk1069]

Oh! heh... I was just installing Pi OS on a quick vm to take a look. but reading that forum makes sense.. ( I Use docker under linux so I have it setup different in containers ) so if that other forum is correct you'll need to install a SQL instance to run it on. Like that other post mentions there's a few types but all the main ones will work and lot of people will have different opinions, the basic MySQL can be installed with

 

apt install mysql-server

 

Which should guide you through setting up the first user etc which you can use in the following Zabbix steps

[Jaan]

still no joy:

 

 

Thanks for all the help so far, i appreciate it

 

is;

 

sudo apt install mariadb-server

 

an option?

[tdk1069]

Yep totally. I use MariaDB myself, just figured I'd suggest the original but seems Raspberry goes for MariaDB

[bald_pig]

What guide are you trying to follow @Jaan?

[Jaan]

What guide are you trying to follow @Jaan?

 

https://www.zabbix.com/download?zabbix=6.0&os_distribution=raspberry_pi_os&os_version=10&components=server_frontend_agent&db=mysql&ws=apache

 

 

 

Cheers

[bald_pig]

https://www.zabbix.com/download?zabbix=6.0&os_distribution=raspberry_pi_os&os_version=10&components=server_frontend_agent&db=mysql&ws=apache

 

[ATTACH=CONFIG]71222[/ATTACH]

 

 

Cheers

 

I mean, it does say "Make sure you have database server up and running"!

 

Go through this guide to set up your db: https://pimylifeup.com/raspberry-pi-mysql/

[Jaan]

I mean, it does say "Make sure you have database server up and running"!

 

Go through this guide to set up your db: https://pimylifeup.com/raspberry-pi-mysql/

 

I thought the guide was doing that lol

[Jaan]

Finally......

 

did;

 

sudo apt install mariadb-server

 

just before;

 

zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

 

from the guide i posted above

 

[tdk1069]

Ok I can't seem to work out how to do images

 

I just followed that guide on a pi vm and had similar steps. It does look like it installs MariaDB along with Zabbix Server but doesn't start it. I had the same error (about socket) until I did systemctl start mariadb

 

 

edit: oh sure now let me attach the image

Edited April 11, 2024 by tdk1069

[tdk1069]

woot! go you !

[Jaan]

Well that was an effort!

 

so did you just type:

 

systemctl start mariadb

 

after

 

apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-sql-scripts zabbix-agent

 

as you followed the guide?

 

thank for all your help!

[tdk1069]

For me personally yes. You can see it in my 2nd screenshot (about 3 lines down) I'm wondering if you installing mariadb again forced it to start. Who knows but that would be why it didn't list anything on ps aux|grep -i sql.... it doesn't have sql in the name, now you can do ps aux|grep mariadb..

 

Now the fun bit begins !

[Jaan]

@Deanuk don't suppose you could share the grafana dashboard layouts with me could you?

 

Thanks