Posts

Showing posts from 2018
Image
Home Lab update Bit of an update. I have been busy traveling for work etc, but managed to make some time to do a few things.  Biggest thing for now 10Gb is a no go, the chelsio card appears to be DOA after trying to get several machines to even see it. I was also hoping the 3750 supported 10Gb GBICs. I should have read more but only the 3750x supported 10Gb GBICs. Oh well, I may give it another shot in the future but its dead for now. I ended up ordering some 1Gb GBICS and a dual port fiber 1GB card instead.  Otherwise I have been busy. The rack came in, and its not a bad unit, the only problem I hit was actually with the Dell Rails they were too short so I had to flip the back uprights. around. This only was a problem for the Dell R610, the R710 rails I got off of ebay seemed long enough for them in the correct position. I bought an R710 after the 610 with the hope I could retire my other esx box. It may in fact become my new Freenas box since it is newer has a better pro

Give me more POWAAHHH!

Image
I have been home the last week or so, which is rare with my job. So let's spend some cash on a lab upgrade. My current lab just has a small 16 Port Netgear managed switch, a couple older AMD boxes cobbled together from leftover parts. One is a FreeNAS box with probably 3-4TB usable storage 16GB RAM and an A6-3650 AMD CPU, the other is an 8 core FX-8320 based AMD box with 24GB of RAM, running ESXi 5.5. I often run out of RAM and network ports while testing things for work such as multiple SQL clusters using AOA for replication etc. Even now in the screenshot with very little running I am using 19GB of RAM. Divorce does have one benefit no permission required!!. 1. Cisco 3650G - 48 Port switch with room for 4 SFPs including 10Gb I paid 170 with free shipping but there are other options - https://www.ebay.com/sch/i.html?_from=R40&_trksid=p2334524.m570.l1313.TR1.TRC0.A0.H0.Xcisco+3560g+48ps.TRS0&_nkw=cisco+3560g+48ps&_sacat=0&LH_TitleDesc=0&_o

Microsoft JDBC and Microsoft SQL Server

Image
For a recent project, I was asked to get the Microsoft JDBC working on Redhat with SQL 2016. In the instructions I found online to be blunt they were lacking especially because I am not a programmer. I hope that this post helps someone in the future attempting something similar. First JDBC for Windows and JDBC for Linux work a bit different. At the time I write this there is a version 6.2 for Windows, but the Linux driver is only at 4.2. This leads to one major difference 6.2 supports passing a username and password as part of the connect string for Kerberos on Windows while the 4.2 driver for Linux does not. Below is a java sample code that works on windows without getting into keytabs etc. I assume in all this you know you need to add a server principal name to your SQL Server service accounts and have already done that. Using "setspn -a" with a domain admin account. Once you have everything configured if you want to verify something is using Kerberos run this query on SQ