Archive

Author Archive

Enhance your #MSSQL Security with two keywords in C#

June 21, 2018 Leave a comment

3d database with padlock security concept

If your database server is on a different machine to your webserver, and the SQL queries travel through the network, then they are liable to be sniffed by third parties sharing the same network.

However, if you add the words:

Encrypt=True; TrustServerCertificate=True

To your connection string then the TDS data sent from client to server will be encrypted, and impossible to sniff from the network.

You can verify the connection is secure by running the following query;

SELECT session_id, net_transport, client_net_address, local_net_address,
local_tcp_port, auth_scheme, encrypt_option
FROM sys.dm_exec_connections

According to performance tests, I found no difference between the performance of secure vs plain text secure. over a batch of 200 queries.

Advertisements
Categories: Uncategorized

Car Registration #API available on #Python #PIP

June 20, 2018 Leave a comment

installing-pip-on-centos-7

CarRegistration

This is an API Wrapper for Python for the VehicleRegistrationApi.com API which allows you to get car data from it’s number plate in many countries across the globe, from the USA, Europe, Australia, and Africa. Is is available as a package on PIP and easy_install  

An account username and password is required from VehicleRegistrationApi.com

When using the Generic “CarRegistration” function, the fourth parameter is an API endpoint, which can be one of;

  • Check (UK)
  • CheckBelgium
  • CheckCroatia
  • CheckCzechRepublic
  • CheckDenmark
  • CheckEstonia
  • CheckFinland
  • CheckFrance
  • CheckHungary
  • CheckIndia
  • CheckIreland
  • CheckItaly
  • CheckNetherlands
  • CheckNewZealand
  • CheckNigeria
  • CheckNorway
  • CheckPortugal
  • CheckRussia
  • CheckSlovakia
  • CheckSouthAfrica
  • CheckSpain
  • CheckSriLanka
  • CheckSweden
  • CheckUAE

For Australia and USA, you must also pass a state parameter, and therefore you must use the CarRegistrationUSA or CarRegistrationAustralia methods.

Installation

pip install CarRegistration

Usage (UK)

 from CarRegistration import *
 CarRegistration("BL64JTZ","***YOUR USERNAME***","***YOUR PASSWORD***","Check")

Usage (France)

 from CarRegistration import *
 CarRegistration("Eg258ma","***YOUR USERNAME***","***YOUR PASSWORD***","CheckFrance")

Usage (USA)

 from CarRegistration import *
 CarRegistrationUSA("H84jae","nj","***YOUR USERNAME***","***YOUR PASSWORD***")

Usage (Australia)

 from CarRegistration import *
 CarRegistrationAustralia("YHC14Y","NSW","***YOUR USERNAME***","***YOUR PASSWORD***")

Sample output

{u'RegistrationYear': u'2015', u'CarModel': {u'CurrentTextValue': u'208'}, u'NumberOfDoors': {u'CurrentTextValue': u'3'}, u'EngineSize': {u'CurrentTextValue': u'1397

And here’s the source code for those interested:

import urllib2, base64, json

def CarRegistration(registrationNumber, username, password):
request = urllib2.Request(“http://www.regcheck.org.uk/api/json.aspx/Check/” + registrationNumber)
base64string = base64.encodestring(‘%s:%s’ % (username, password)).replace(‘\n’, ”)
request.add_header(“Authorization”, “Basic %s” % base64string)
result = urllib2.urlopen(request)
data = json.load(result)
return(data)

Categories: Uncategorized

Detect #Phising links in user submitted urls in C#

June 19, 2018 Leave a comment

download

If your website displays urls which are user-submitted, then you can use a free API by google called Safe Browsing (key required), to detect if these are phishing / malware urls – here is the code, with the Google API Key removed;

static bool IsMalware(string url)
{
/*
http://testsafebrowsing.appspot.com/apiv4/ANY_PLATFORM/MALWARE/URL/
http://testsafebrowsing.appspot.com/apiv4/ANY_PLATFORM/SOCIAL_ENGINEERING/URL/
http://testsafebrowsing.appspot.com/apiv4/ANY_PLATFORM/UNWANTED_SOFTWARE/URL/
*/
var strRequestJson = File.ReadAllText(“requestjson.json”);
strRequestJson = strRequestJson.Replace(“*PLACEHOLDER*”, url);
WebClient wc = new WebClient();
var strurl = “https://safebrowsing.googleapis.com/v4/threatMatches:find?key=xxxx”;
wc.Headers[HttpRequestHeader.ContentType] = “application/json”;
var strResult = wc.UploadString(strurl, strRequestJson);
if (strResult.Trim() == “{}”) return false;
return true;
}

You will also need the file requestjson.json set to copy always in the build options, with the following content;

{
“client”: {
“clientId”: “yourcompanyname”,
“clientVersion”: “1.5.2”
},
“threatInfo”: {
“threatTypes”: [ “MALWARE”, “SOCIAL_ENGINEERING” , “UNWANTED_SOFTWARE” ],
“platformTypes”: [ “WINDOWS” ],
“threatEntryTypes”: [ “URL” ],
“threatEntries”: [
{ “url”: “*PLACEHOLDER*” }
]
}
}

Categories: Uncategorized

Get automated notifications on #WindowsUpdate using C# and #WUApiLib

June 18, 2018 Leave a comment

Windows-Update-en-Windows-7

If you wanted to be notified as soon as a windows update is available on your server, but you don’t want it to be installed automatically, here is a script in C# that allows you to know when an update is ready.

It requires a COM library called WUApiLib which you can add via project > References

var updateSession = new UpdateSession();
var updateSearcher = updateSession.CreateUpdateSearcher();
updateSearcher.Online = false; //set to true if you want to search online
try
{
var searchResult = updateSearcher.Search(“IsInstalled=0 And IsHidden=0 And BrowseOnly=0”);
if (searchResult.Updates.Count > 0)
{
Console.WriteLine(“There are updates available for installation”);
foreach (IUpdate update in searchResult.Updates)
{
Console.WriteLine(update.Description);
foreach (string kbaid in update.KBArticleIDs)
{
Console.WriteLine(“http://support.microsoft.com/?kbid=” + kbaid);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message, “Error”);
}

 

Categories: Uncategorized

Cloud Answering Machine services now available in 33 new countries

June 15, 2018 Leave a comment

71TFmNzL5UL

CloudAnsweringMachine.com is a service that allows you to have a virtual answering machine attached to a real phone number practically anywhere in the world. This means that if you want to have a number that you can publish freely, without being bombarded with spam callers.

Having a virtual answering machine allows you to separate your high-priority calls from your low-priority calls, so that someone who is not in urgent need of reply, can leave a message, and you can get back to them – where your friends , family and important business partners can still contact you on your main phone line.

You can also receive text messages on your answering machine, so it can be used to activate services without disclosing your real phone number.

Up to now, we’ve had a simple pricing structure of  $15 (USD), £ 15 (GBP) or € 12 (EUR) per month, but we’ve known that certain countries have higher setup costs to provision phone lines, so we haven’t been able to offer them.

So, we’ve decided, that although most countries will still remain on the simple $15 pricing, we’ve now opened up the possibility of 33 new countries – albeit at a higher monthly cost. These premium numbers are only bookable through the website at present, but this may change in future.

Here’s the pricing table;

Country iso monthly price (USD)
United Arab Emirates AE 50
Bosnia and Herzegovina BA 84
Barbados BB 54
Benin BJ 54
Bolivia BO 50
Botswana BW 100
Belarus BY 50
Colombia CO 50
Algeria DZ 66
Ecuador EC 68
Grenada GD 54
Georgia GE 28
Ghana GH 54
Guinea GN 54
Guatemala GT 62
Jamaica JM 54
Kenya KE 32
Cayman Islands KY 58
Mali ML 76
Macau MO 140
Mauritius MU 86
Namibia NA 66
Philippines PH 50
Serbia RS 210
Singapore SG 150
Thailand TH 50
Tunisia TN 70
Trinidad and Tobago TT 54
Tanzania TZ 54
Uganda UG 56
Vietnam VN 72
Categories: Uncategorized

#Car Registration #API available for Singapore vehicles

June 12, 2018 1 comment

Singapore-940x627

Singapore is a country with 5.6 million people, and is one of the most affluent city states in the world. It has a cap on the amount of new vehicles being registered in the city, but with an affluent population, and 45% car ownership, there are millions of registered vehicles in the city. If you offer a website or service to these users, then you may be interested in a car registration api for singapore at http://sg.carregistrationapi.com

Singapore support

Car registration plates in Singapore use the /CheckSingapore endpoint and return the following information:

  • Make & Model
  • Age
  • Representative image

Sample Registration Number:

SJT8954X

Sample Json:

{
“Description”: “TOYOTA LEXUS IS250 AUTO STD FL”,
“RegistrationYear”: “2009”,
“CarMake”: {
“CurrentTextValue”: “TOYOTA”
},
“CarModel”: {
“CurrentTextValue”: “LEXUS IS250 AUTO STD FL”
},
“MakeDescription”: {
“CurrentTextValue”: “TOYOTA”
},
“ModelDescription”: {
“CurrentTextValue”: “LEXUS IS250 AUTO STD FL”
},
“TaxExpiry”: “05 Nov 2018”,
“ImageUrl”: “http://sg.carregistrationapi.com/image.aspx/@VE9ZT1RBIExFWFVTIElTMjUwIEFVVE8gU1REIEZM”
}

Categories: Uncategorized

Download complete #Twilio Pricing table in C#

June 7, 2018 1 comment

twilio-730x365

Twilio offer a great service in providing international phone numbers, – and it’s the provider behind CloudAnsweringMachine.com but the price varies greatly like from a $1 number in the US to a $110/month Toll free number in Bulgaria.

So, here is some code that queries the Twilio API to download all countries, and stores the pricing information in a database :

var strUrl = “https://pricing.twilio.com/v1/PhoneNumbers/Countries/?PageSize=100”;
var wc = new WebClient();
wc.Headers[“Content-Type”] = “application/x-www-form-urlencoded”;
var credentials = Convert.ToBase64String(Encoding.ASCII.GetBytes(username + “:” + password));
wc.Headers[HttpRequestHeader.Authorization] = string.Format(
“Basic {0}”, credentials);
var strCountries = wc.DownloadString(strUrl);
var jCountries = JObject.Parse(strCountries);
foreach(var jCountry in jCountries[“countries”])
{
Console.WriteLine(“Downloading ” + jCountry[“country”].ToString());
try
{
var strCountryUrl = jCountry[“url”].ToString();
var strCountryJson = wc.DownloadString(strCountryUrl);
var jCountryJson = JObject.Parse(strCountryJson);
if (jCountryJson[“price_unit”].ToString() != “USD”) throw new Exception(“Should be usd!”);
foreach (var jPhoneNumber in jCountryJson[“phone_number_prices”])
{
var strSQL = “insert into CAMPricing (country, numberType, price) values (‘{0}’,'{1}’,{2})”;
strSQL = string.Format(strSQL,
jCountryJson[“iso_country”].ToString(),
jPhoneNumber[“number_type”].ToString(),
jPhoneNumber[“current_price”].ToString());
Database.ExecuteNonQuery(strSQL);
}
}
catch(Exception ex)
{
Console.WriteLine(“Failed to download ” + jCountry[“country”].ToString());
Console.WriteLine(ex.ToString());
}

}

And here is the pricing table correct as of time of writing:

ISO Country Number Type Price (USD)
AE toll free 25.00
AR local 8.00
AR toll free 25.00
AT mobile 6.00
AT national 1.00
AT toll free 25.00
AU local 2.50
AU mobile 6.00
AU toll free 15.00
BA local 42.00
BA national 42.00
BB local 27.00
BE local 1.00
BE mobile 1.00
BE national 1.00
BE toll free 25.00
BG local 3.00
BG toll free 110.00
BJ mobile 27.00
BO toll free 25.00
BR local 4.00
BR toll free 35.00
BW toll free 50.00
BY toll free 25.00
CA local 1.00
CA toll free 2.00
CH local 1.00
CH mobile 8.00
CH toll free 25.00
CL local 7.00
CL mobile 10.00
CO local 14.00
CO toll free 25.00
CY national 5.00
CZ local 1.00
CZ mobile 12.00
CZ national 1.00
CZ toll free 35.00
DE local 1.00
DE mobile 5.00
DE national 1.00
DE toll free 25.00
DK local 1.00
DK toll free 25.00
DO local 7.00
DZ local 33.00
DZ national 33.00
EC local 34.00
EE local 1.00
EE mobile 3.00
EE national 1.00
ES local 2.00
ES mobile 4.00
ES national 2.00
ES toll free 25.00
FI local 1.00
FI national 1.00
FI toll free 40.00
FR local 1.00
FR mobile 2.50
FR national 1.00
GB local 1.00
GB mobile 1.00
GB national 1.00
GB toll free 2.00
GD local 27.00
GE local 14.00
GE national 14.00
GH mobile 27.00
GN mobile 27.00
GR local 1.00
GR toll free 25.00
GT local 31.00
GT mobile 28.00
HK mobile 15.00
HK national 6.00
HK toll free 25.00
HR local 5.00
HR mobile 6.00
HU local 4.00
HU mobile 25.00
ID local 23.00
ID mobile 3.00
ID toll free 25.00
IE local 1.00
IE mobile 6.00
IE national 1.00
IE toll free 25.00
IL local 4.00
IL mobile 14.00
IL national 4.00
IL toll free 25.00
IS local 1.00
IT local 1.00
IT mobile 25.00
JM local 27.00
JP local 4.50
JP national 4.50
JP toll free 25.00
KE local 16.00
KR local 3.00
KR national 3.00
KR toll free 25.00
KY local 29.00
LT local 1.00
LT mobile 3.00
LU local 3.00
LV local 1.00
LV mobile 3.00
ML local 38.00
MO mobile 70.00
MT national 5.00
MU mobile 43.00
MX local 5.00
MX toll free 30.00
MY mobile 5.00
MY toll free 25.00
NA local 33.00
NA national 33.00
NL local 3.00
NL mobile 5.00
NL national 3.00
NL toll free 25.00
NO local 3.00
NO mobile 12.00
NO toll free 25.00
NZ local 3.00
NZ toll free 40.00
PA local 8.00
PE local 6.00
PH local 15.00
PH toll free 25.00
PL local 1.00
PL mobile 3.00
PL toll free 25.00
PR local 3.00
PT mobile 15.00
PT national 1.00
PT toll free 25.00
RO local 3.00
RO toll free 25.00
RS toll free 105.00
SE local 1.00
SE mobile 1.00
SE national 1.00
SE toll free 25.00
SG mobile 75.00
SI local 5.00
SK local 1.00
SK toll free 25.00
SV local 7.00
TH local 25.00
TH toll free 25.00
TN local 35.00
TN national 35.00
TT local 27.00
TZ local 27.00
TZ national 27.00
UG local 28.00
UG national 28.00
UG toll free 25.00
US local 1.00
US toll free 2.00
VN local 36.00
ZA national 1.50
ZA toll free 25.00
Categories: Uncategorized