Sometimes we have a function running too long more than we expect, we want to kill it after a certain time. For example, we have a function connecting to a remote share, the function we use to connect does not provide a timeout or we can’t change its timeout. Our solution is to build a timeout function to kill the function if it runs too long. I found this good and simple code: How do i use it?Read More →
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-relayRead 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 logRead 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 theRead More →