How to add static routes in Windows Server 2008 R2

Download PDF

– Open CMD (elevated only – Run As Administrator)
– To display existing routes type: route print

route add mask
Where first destination IP, mask if single IP than /32 (.255) and then the next hop (other server)

So the example would be:
route add mask

– To delete the route: route delete

route add mask if 1 (where 1 is the interface number). You can see the interface numbers when route print.

How to Redirect HTTP to HTTPS with IIS 7

Download PDF

In IIS, to redirect (force) HTTPS on every HTTP request, do the following.

Before you start, make sure you have the following done;

  • IIS 7 installed
  • Microsoft URL Rewrite Module installed
  • Create HTTPS bindings to your IIS website and assign certificate
  • Ensure Require SSL is NOT checked under SSL Settings for your website

Once you have this done you can simply copy and paste the following code between the <rules>and </rules> tags in your your web.config file in your website root directory.

Please note if you already have some rules in you web.config file, make sure to put the bellow rule within <rules>. Every rule ends with <rule> and then all rules end with <ruleS>, so make sure not to put this rule inside another rule.

<rule name="HTTP to HTTPS redirect" stopProcessing="true">
<match url="(.*)" />
<add input="{HTTPS}" pattern="off" ignoreCase="true" />
<action type="Redirect" redirectType="Found" url="https://{HTTP_HOST}/{R:1}" />

Now save the web.config file and it’s all done.

MySQL error: Field doesn’t have a default value – ClipBucket – Clip-bucket

Download PDF

Clip-bucket Field ‘action_link’ doesn’t have a default value


MySQL error: Field doesn’t have a default value

When inserting a new record with varchar or text field that is required and has no default value. This error will display for example:error : Field ‘description’ doesn’t have a default value

The possible reason is that sql-mode in my.ini is set to STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION.

Change the value to
sql-mode = “”

Update 2011/4/25:
Add Default value “” if possible to avoid changing mysql setting.