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

EXAMPLE:
route add 1.1.1.10 mask 255.255.255.255 10.0.1.1
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 192.168.10.15 mask 255.255.255.255 192.168.10.254

– To delete the route: route delete 192.168.10.15

IF YOU WISH TO SPECIFY THE INTERFACE ROUTE WILL USE DO THIS:
route add 192.168.10.15 mask 255.255.255.255 192.168.10.254 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="(.*)" />
<conditions>
<add input="{HTTPS}" pattern="off" ignoreCase="true" />
</conditions>
<action type="Redirect" redirectType="Found" url="https://{HTTP_HOST}/{R:1}" />
</rule>

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

or

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.