General (Page 15)

I have this scenario, i would like to monitor all our Microsoft sql databases in our setup using Telegraf. I dont want to install telegraf agent in every server, i want to collect SQL database metrics remotely from a single location. What is the challenge? If you use the default setup, telegraf will not tag the remote hostname in its metric, it will use our telegraf hostname. That means you can’t tell the difference between databases . Solution ? i found out that we can add additional tags in the configure[inputs.sqlserver.tags] If you use this configure, you will see this tag “sql_db_remote_host” in the metrics.Read More →

:~$ route -n Kernel IP routing table Destination     Gateway         Genmask         Flags Metric Ref    Use Iface 0.0.0.0         192.168.1.1     0.0.0.0         UG    0      0        0 eth1 192.168.1.0     0.0.0.0         255.255.255.0   U     1      0        0 eth1Read More →

InfluxDB not only support metrics, it also can store your syslog. I have played around with metrics, now I’d like to send my log to InfluxDB. Here is how I did.1. Turn your telegraph as a syslog server listener. I chose to use UDP instead of TCP. 6514 is the UDP port 2. On the client side, We need to tell rsyslog to send the log to my Telegraf. Check the config below, you need to specify RSYSLOG_SyslogProtocol23Format. , “@” is for UDP , “@@” is for TCP The next step is to download a Syslog dashboard from Grafana and see how it worksRead More →

I started to build InfluxDB for a high availability InfluxDB architecture. I will share all my experience with the InfluxDB Relay in this post. This is based on InfluxDB 1.X AuthenticationInfluxDB will relay all authentication, so if your telegraf is using Basic Auth or Token based , that data will be sent to destination. LogsInfluxDB does not provide any logs for troubleshooting Does InfluxDB tells the client if any node is down?There are several scenarios: – If at least one node is still working fine, InfluxDB Relay will not return any error message. – InfluxDB relay will only return an error to client in theseRead More →

I’m running Catalina 10.15.2 and today i tried to install “brew”. During the installation, it required x-code-select, i installed it and got this error “Can’t install the software because it is not currently available from the Software Update server”. I tried to install X-code, but it didn’t help. Finally i had to go to this place https://developer.apple.com/download/more/ and search for Command Line tools to install.Read More →

I spent my weekend to setup an InfluxDB infrastructure. My goal is to have a high availability infrastructure. If you do some readings, you will see that the high availability only available in Enterprise version. There is some alternatives, i select the most simple way to do: InfluxDB with InfluxDB relay. My architecture includes: one InfluxDB relay and 2 Data Nodes.I don’t go to the setup detail here but i want to share some knowledge when i do the setup. I start with the good things first: – Data is replicated into 2 two nodes ( 2 nodes will have the same data)– InfluxDB-relay hasRead More →

If your cron job is not running as expected check the following: permission for this file should be 600 – one one can read except root check the syntax you need to provide the user that the job should run with ( this is different with crontab -e where it will use the current user) sometimes your file may have some special characters such as ^M, you don’t see them in normal editor , you can run this command : cat -v /etc/cron.d/your_cron_job file Make sure that cron service is running:  ps -aux | grep cron check the log file : cat /var/log/syslog | grepRead More →

If your Mac is stuck with High Sierra , you can’t upgrade it and you want to install iMovie ? follow the steps below: Installing iMovie9 # 1. Download the iMovie 9.0.9 update package curl ‘https://updates.cdn-apple.com/2019/cert/041-98154-20191017-1fbef983-8d87-49af-83b1-edecc007ce2e/iMovie9.0.9Update.dmg‘ -o ~/Downloads/iMovie9.0.9Update.dmg 2. Mount the dmg open ~/Downloads/iMovie9.0.9Update.dmg 3. Expand (unarchive) the pkg pkgutil –expand /Volumes/iMovie\ 9.0.9/iMovie9.0.9Update.pkg ~/Downloads/iMovie/ 4. Rename Payload to Payload.zip mv ~/Downloads/iMovie/iMovie9.0.9Update.pkg/Payload ~/Downloads/iMovie/iMovie9.0.9Update.pkg/Payload.zip 5. Unpack Payload.zip (it will get named Payload 2) open ~/Downloads/iMovie/iMovie9.0.9Update.pkg/Payload.zip 6. Move iMovie.app to the Applications folder mv ~/Downloads/iMovie/iMovie9.0.9Update.pkg/Payload\ 2/Applications/iMovie.app /Applications/iMovie\ 9.0.9.app Enjoy! open /Applications/iMovie\ 9.0.9.app If you want to upgrade to iMovie 10, follow the steps below: # 1. Check whetherRead More →

It’s probably permission issue with /etc/krb5.conf , your web server might not have the same as you in this /etc/ folder , change it to 755 chmod 755 /etc/krb5.confRead More →

Your queries might return more fields than you need in your table, even though you don’t want to show it in the table but you actually need it. For example, the result should return an url , you don’t want to display the url, you want people click on another field but that click should link to your url. So that’s why you need to hide some column. It’s pretty simple, on the Edit Panel , on the left , next to the Query , there is “Transform” tab , click on it , then select “Organize fields” , there will be an option forRead More →