Raspberry Pi as syslog server

I’ve been meaning for some time to add a Raspberry Pi to my lab environment as a syslog server and finally got around to it today.

I have a couple of Pis but when I went looking this morning I realized that I had a problem with the SD card on one which led to a small voyage of discovery.

To re-flash the SD card I chose the Raspbian Stretch Lite download, here.

And then re-flashed the card using balenaEtcher per instructions, here.

I operate the Pis in headless mode on a wired network and in order to get them to come up with SSH enabled I had to add an empty file ssh.txt to the boot partition on the SD card.

Once online I used a network scanner to find the dhcp served addressed and then set a static address by editing the configuration file.

sudo nano /etc/dhcpcd.conf

interface eth0

static ip_address=192.168.1.2/24
static routers=192.168.1.1
static domain_name_servers=192.168.1.1

More on the details of the syslog server itself in a future post.

Using MS-SQL server with pHp on Linux

I’m a big fan of Microsoft’s SQL Server database but I also do a lot of coding in php, and Linux is my favourite platform for that. So, how best to mesh those two worlds.

The best step-by-step instruction guide that I have found is this one, below:

http://www.unixodbc.org/doc/FreeTDS.html

I’ve used this instruction set on numerous occasions and it is still possible to get yourself into an unworkable state, however, persistence, and attention to detail, always pays off.

Note: I  have run MS SQL server on Linux since the Linux preview was released in 2016.