How to add unknown mime types to IIS

Sometimes you may need an extention without knowing the correct mime-type or just may not exist yet or may not be defined.

You can use the following

.yourExtension application/octet-stream

This basically tells to download the file without try to opening by any software.

Some people saying that this comply with RFC and some not.

https://tools.ietf.org/html/rfc2046#section-4.5.1

The recommended action for an implementation that receives an
“application/octet-stream” entity is to simply offer to put the data
in a file, with any Content-Transfer-Encoding undone, or perhaps to
use it as input to a user-specified process.

It is expected that many other subtypes of “application” will be
defined in the future. MIME implementations must at a minimum treat
any unrecognized subtypes as being equivalent to “application/octet-
stream”.

You decide.

I have also see people adding application/unknown for mime type but I would still recommend putting octet-stream as at least it is defined in the RFC otherwise you can also put applicatoion/I_dont_know and it would be the same as ‘unknown’ in my opinion.

Other resources:

MIME Types in IIS – https://msdn.microsoft.com/en-us/library/bb742440.aspx

Many Thanks

Raf

 

How to clean up Winsxs folder on Windows Server 2012 R2 or Windows 8.1

For Windows 7 Refer to my other blog here:

https://amionrails.wordpress.com/2016/08/05/how-to-cleanup-winsxs-folder-on-windows-2008-r2-and-windows-7/

Windows 2012

Windows 2012 Source: https://technet.microsoft.com/en-gb/library/dn251565.aspx

Deployment Image Servicing and Management (DISM) is a command-line tool that allows you to install, uninstall, configure, and update Windows features, packages, drivers, and international settings. The /Cleanup-Image parameter of Dism.exe provides advanced users more options to further reduce the size of the WinSxS folder. For more information, see DISM Operating System Package Servicing Command-Line Options.

  1. Using the /StartComponentCleanup parameter of Dism.exe on a running version of Windows 8.1 gives you similar results to running theStartComponentCleanup task in Task Scheduler, except previous versions of updated components will be immediately deleted (without a 30 day grace period) and you will not have a 1-hour timeout limitation.From an elevated command prompt, type the following:
    Dism.exe /online /Cleanup-Image /StartComponentCleanup
    
  1. Using the /ResetBase switch with the /StartComponentCleanup parameter of DISM.exe on a running version of Windows 8.1 removes all superseded versions of every component in the component store.From an elevated command prompt, type the following:
    Dism.exe /online /Cleanup-Image /StartComponentCleanup /ResetBase
    
    WarningWarning
    All existing service packs and updates cannot be uninstalled after this command is completed. This will not block the uninstallation of future service packs or updates.
  1. To reduce the amount of space used by a Service Pack, use the /SPSuperseded parameter of Dism.exe on a running version of Windows 8.1 to remove any backup components needed for uninstallation of the service pack. A service pack is a collection of cumulative updates for a particular release of Windows.From an elevated command prompt, type the following:
    Dism.exe /online /Cleanup-Image /SPSuperseded
    
    WarningWarning
    The service pack cannot be uninstalled after this command is completed.

How to fix [DBNETLIB]ConnectionOpen (SECDoClientHandshake()) SSL Security error CODE 80004005

I have recently have this issue on SQL Server 2012 with Windows Server 2012 R2.

The error was displayed one using OLE DP Provider in the VB script connection strings.
After looking at various google post explaining this issue nothing has worked.

To confirm the server is PCI DSS compliant and TLS 1.0 < and SSL are disabled.

I have changed the connection string from

‘connstring = “Provider=SQLOLEDB.1;

to

connstring = “Provider=SQLNCLI11;

this is to use native SQL Client Drivers to connect.

This has worked and no more issues the script complained.

Some background:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50131

Connection Strings for SQL Server 2012

https://www.connectionstrings.com/sql-server-2012/

https://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/

How to fix League of Legends LOL game crashed / reconnecting – Collection of fixes / Fix LoL


Cheap SSD Hosting $5 a month Sign UP

First. Please read it careful if something is wrong or you got something else PLEASE SHARE it add comments and I will update the set of fixes so the other gamers can enjoy the game the same as you 🙂

How to fix crashing in League of Legends? Why I am creating it?

The answer is simple I had the same issue and I wonder what I have changed that suddenly the game started crashing every time. Welcome Bans and lost of lost games !

The game should PC proof but it seems it is not :).

In my situation everything was working fine then suddenlyt it started crashing all the time. Lags in game/ Crash PC restarted game re installation nothing helped ;).

I manage to get a list of thing what it might be and after I finish doing everything and restarting my PC at the end it fixed my problem.

If nothing below helped you report your issue to LOL

https://support.leagueoflegends.com/requests/new

0.1 Check your Internet Connection. The below is recommend by LOL

              http://n1.netalyzr.icsi.berkeley.edu

0.2 Check if you meet all the LOL criteria with regards to networking

http://demo1.speedsight.com/quality-detail.html?code=lol

1. Uninstall Pando Booster.

  • This get installed together with game at some point and once you got a game and it’s completely not needed.

2. IP Helper Disabling – Windows Service (This is for proxy, IPv6)

What the IP helper is ?

Windows description: Provides tunnel connectivity using IPv6 transition technologies (6to4, ISATAP, Port Proxy, and Teredo) and IP-HTTPS. If this service is stopped, the computer will not have the enhanced connectivity benefits that these technologies offer. Why this can be disabled: Many organizations haven’t even started testing IPv6, much less fully deployed it. As indicated in the service description, the IP Helper service is leveraged in IPv4-to-IPv6 transitions

Please follow the steps below to disable it. PC restart my be required once you finish for the changes to take affect.

  • Press the keys “Windows” and “R” simultaneously. (Windows normally between Left Alt and Left Ctrl) or click the windows start button bottom left and click the search box
  • Type “services.msc” in the field and hit enter.
  • Scroll down and find “IP Helper” in the list.
  • Right-Click on “IP Helper” and select “Properties.”
  • Change “Startup type” to “Disabled.”
  • Stop the service
  • Click “Ok.”
  • Reboot your machine.

3. Java updater in running processes can also cause the game to drop in champion loading screen disable this if possible show up in process as jusched.exe*32

  • Right click on star bar then click on Task Manager then go to Processes and if its running kill the process by right clicking and pressing End Task
  • Next step is to disable it in Java

4. Switching to the NA (North America) server, grabbing the patch and then switching back to EU. This fix is not for NA users obviously 🙂

5. Use the Logitech G19 keyboard from Logitech can cause issues and the LOL support for Logitech seems to be causing problems.

  •   to disable the support ready Step 8 and Step 13 just in case.

6. Right click your lol.exe and go into properties and run it for 640 x 480 in the settings (the little tick box) the bug splats stop happening and it connects to the game successfully, maybe turning down the resolution in the actual config file / settings may help too.

  • your computer / riot games / league of legends / RADS / solutions / lol_game_client_sln / releases / 0.0.0.236 / deploy – Right click league of legends .exe and tick the box for run in 640 x 480. doesn’t bug splat anymore.
    seems to work for a number of people, doesn’t seem to fix everyone though

7. I have a Microsoft Sidewinder X4 that is changing profile with LoL application.

  • Again disable switching in application or uninstall it.

8.Logitech hardware support

  • can now be disabled by adding “LogitechSupport=0” to the “General” section in your game.cfg Path – >C:\Riot Games\League of Legends\Config\game.cfg (This may be different depend where you have installed your game)

9.  Blocking IP 54.244.21.158 on firewall

  • This fix will block overloaded auth IP so u can connect to sever!!!
  • Also u can block it manually with ur router or firewall – 54.244.21.158
  • Open up Windows Firewall -> Advanced -> Inbound/Outbound Rule and add blocking for a specific IP 54.244.21.158

10.Disabling Logitech program/software can also fix game crashing.

  • This seems to fix the problem if you have a Logitech G35 software. Good advise. Disable it anyway 🙂

 11. ATI Catalyst and Nvidia Control panel may set up profiles which override program settings.

  • Try disabling them to ensure they are not conflicting with the game. Additionally, you could even enable a profile (if it was already disabled) to see if this fixes the problem.

12.After closing down the program “Logitech Gaming Software 8.50”

13. Renaming Logitech DLL files

  • Go to your Riot Games directory and there to: \Riot Games\League of Legends\RADS\solutions\lol_game_client_sln\release s\XXXXX-version(it’s a number)\deploy
  • There are two files: LogitechGkey.dll and LogitechLed.dll
  • Make a copy of each file, just in case. Then delete the two in the \deploy folder. Loading screen should now start without crashing.

14. Unistalled LOLreplay

15. Another reason may be for those who updated to windows 8.1. In this case, RiotRadsIO.dll will make an error.

16. http://forums.euw.leagueoflegends.com/board/showthread.php?t=1633122

17. Run Compatibility troubleshooter

  • On Windows 8 Right click on LOL launcher then click on Properties -> Compatibility and Run compatibility Troubleshooter

18. Disabled LoLRecorder.

19. Uninstall Razor Game Booster.

20.  Install latest drives for Ati and Nvidia graphics card.

21. Don’t buy any hardware 🙂

22. In very hardcore situation Windows Re installation fix it as well.

23. Add lol…..exe files to DAP

Control – Panel – System -> Advance -> Performance then Settings -> Data Execution Prevention and add lol.launcher.exe / lol.launcher.admin then restart your PC.
24. Change DNS to 8.8.8.8 and 8.8.4.4

If would like to gift my a gift to support hosting and this and future development please donate or send a in game gift to aMiPL

Many thanks!

Equipment Recommendation:

Logitech MX 518 High Performance Optical Gaming Mouse (Metal)

Razer DeathAdder Ergonomic PC Gaming Mouse

Logitech G500s Laser Gaming Mouse with Adjustable Weight Tuning

Logitech Wireless Gaming Mouse G700

Razer Naga 2014 MMO Gaming Mouse

beer raf

beer raf

How to Open CSV files using iMacro

1. Let’s make it happened.

The below is just an example which will not work for you as I am using it on bespoke system.

‘open 1 tab only type

TAB T=1
‘ignore errors. this is to allow proceed with macro even if the ip has already been removed
SET !ERRORIGNORE YES
‘wait 2 second instead of default 6s if errors occurs (to speed up the work also sometimes you need to increase because the web page might not appear in the right time and some steps will be missing)
SET !TIMEOUT_PAGE 2
‘set up datasource (this is where the CSV is)
SET !DATASOURCE bulk_reconfiguring.csv
‘ you need to specify the number of rows
SET !DATASOURCE_COLUMNS 2
‘set up loop ( this is what will be repeated from 1 row as the loop is setup as 1 next loop is basically a next row)
SET !LOOP 1
SET !DATASOURCE_LINE {{!LOOP}}
‘open a device search do some work and repeat with the next row
‘ you can see that the {{!COL1}} is build in variable from iMacro this is where your data from CSV will be.
URL GOTO=http://xx.xx.xx/ABLDevice
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:OSSMeta-filter-form ATTR=ID:edit-Value CONTENT={{!COL1}}
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:OSSMeta-filter-form ATTR=ID:edit-submitonce
TAG POS=1 TYPE=A ATTR=TXT:{{!COL1}}

How to use Javascript with iMacro and find out the end of file in CSV file.

1. Once you recorded your Macro using iMacro you need to change to file to (.js) extension. This will enable you to use javascript code inside to macro to give what you need.

Example of use of JavaScript can be found here on my Github account.

https://github.com/ber5ien/imacros_scripts/blob/master/javascript/daily_calls_update_v2.js

This piece of code will be found at the finish of CSV files so you can iterate over rows in cvs files.

This is very useful with imacro otherwise you need to type in manually how many rows you got in to CSV files.

 

datasource – this is path to your datasource C://…

Hylas – this can be ignored 🙂

csv_file_name = your csv name which need to be put into Datasource directory.

function count_rows(datasource,hylas,csv_file_name)
{
 // COUNT THE NUMBERS OF ROWS IN CSV FOR LOOP
 const CRLF = “\r\n”;
 const LF = “\n”;
 
 var lines = new Array();
 
 var file_i = imns.FIO.openNode(datasource+hylas+csv_file_name);
 var text = imns.FIO.readTextFile(file_i); // Read file into one string
 
 // Determine end-of-line marker
 var eol = (text.indexOf(CRLF) == -1) ? LF : CRLF;
 
 // Split into lines (number of lines) NUMBER OF LINES IN CSV
 lines = text.split(eol);
 eol = lines.length;
 //iimDisplay(eol);
 // FINISH COUNTING EOL = NUmber of LInes
 return eol;
}

SSD Hosting for 5 dollars a month https://www.digitalocean.com/?refcode=71a52388956e

Web Automation with iMacro Software. No more repetetive task! Boost your Web Productivity

Hi Guys,

I though I will share some of my knowledge regards the automation tool and how you can improve your work and any repetitive task.

What we need first is to get right tools for the job. You can use any

1. iMacro Software (Free)

http://imacros.net/overview

You can see my scripts on GitHub

https://github.com/ber5ien/imacros_scripts/tree/master/imacros_scripts

The one based on Javascript. This will give you some more flexibility as you can use them to change your iMacros scripts depending on some data which you can scrap/export from web itself

https://github.com/ber5ien/imacros_scripts/tree/master/javascript

2. Firefox 🙂

http://www.mozilla.org/firefox/new/

3. Some plugins! ( will add some plugins soon )

xMark – Save your bookmarks and sync them anywhere

Autofill Forms – You can use this to automate filling some forms. You can predefine forms so then you can just right click and select the one you need. This is a great tool especially for any web based ticketing systems.

InstantFox – Search Via your Address. This can save few click as you can open some pages directly for instance : open g – This would open a website named as g.

MyWords – You can predefined some sentence and they use keyboard shortcut to it.

4. Let’s get started. I will just give you a quick introduction to it. It’s a quite nice tool and you can use their api to integrate it with language such as vb script php javascript etc.

5.What you need to do first is to records your Macro. Press F8 to get the info then you can start recording.

Once you finish your imacro script you can then see current.imm file which contain what you have recorded.

This is just a beginning more to go which I will be posting soon.