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.
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:
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.