Posts

Showing posts from 2018

SSL Certificates

Today i had hard time installing SSL certificate on one of our IIS servers. when i was trying to follow the provider instructions and "Complete Certificate Request" i got "Failed to remove certificate"! and import required pfx file which i didn't have, we only got crt file. and trying converting that to pfx was failing. until i hit this gem "OR it could be the cert (Network solutions is notorious for this as they charge $150 for helping to install it) doesn't actually have a privatge key.  Here are instructions to make the PFX if you have no private key. To fix this, use the MMC snapin to import the cert into PERSONAL, click it and grab the serial # line.  Go to dos, run certutil -repairstore my "paste the serial 3 in here" (you need the quotes) then refresh MMC with personal certs, right click it – export – select everything except DELETE PRIVATE KEY, hit ok.  Then go to IIS and IMPORT cert instead of finish request.  bingo – fix

Why .NET Core Whhhhhyyyyy!

So all what i wanted is to encrypt and decrypt a string from on end to another using .NET Core 2 like why this is so hard why complicating something that was as easy as having the same machine key! what if i like to have my own JWT token generation API end point for any reason and guess what instead of sending the user password in the JSON body in plain text i would like to encrypt that based on a shared key that both client and server have it. should be easy, right?! the defult thing you will see when you Google .NET Core 2 Encryption / Decryption is the new Data Protection and IDataProtector interface. you will find a good example on how to use it. public void RunSample() { Console.Write("Enter input: "); string input = Console.ReadLine(); // protect the payload string protectedPayload = _protector.Protect(input); Console.WriteLine($"Protect returned: {protectedPayload}");

So that was stopping you

Finally got to what i think the root case for the student.xml not updating Network Id field on Sunapsis. using this query which is taken from a SQL stored procedure which i think update Network ID SELECT countingOfAllNetworkIDs.idnumber FROM (SELECT * , COUNT( listingOfAllNetworkIds.networkid ) OVER (PARTITION BY listingOfAllNetworkIds.networkid) duplicateCount FROM (SELECT idnumber , networkid FROM dbo.jbInternational WHERE COALESCE( networkid, '' ) <> '' UNION SELECT idnumber , PRSN_NTWRK_ID FROM dbo.iuieBio WHERE COALESCE( PRSN_NTWRK_ID, '' ) <> '') AS listingOfAllNetworkIds) AS countingOfAllNetworkIDs WHERE countingOfAllNetworkIDs.duplicateCount >= 2 Copy to Clipboard so any id on that list wouldn't get network id updated based Sunapsis support tip we removed all duplicates and kept only latest record on iuieBio table for the same univ

Sunapsis what's wrong!

So ... we had an odd issue, we have that datafeed xml for students and it dose have the network id, but after the scheduled task run still no network id on the core bio. information. thanks for my ColdFusion friend Marcus i found a log entry on application.log indicating that the .cfm that is scheduled to import the xml have a query which timed out! finally some meaningful information in a log

Sunapsis one more new software

Today i was introduced to yet a new software in my 15+ years journey on information technology realm. Sunapsis™ another chance for me to learn something new. you got to love this job, because if you don't ...