InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch)

Submitted by luxian on Mon, 12/05/2016 - 07:10

Recently I had to investigate some Drupal website crashing. While debugging I noticed a lot of mysql crashes and MySQL log was full of errors like this:

InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch)

After some searching I managed to fix it by running mysql_upgrade command:

mysql_upgrade -u root -p <mysql_root_pass>

I added -p because my root username has a password, you can try without it first.


DDoS attack agains heating system in Finland

Submitted by luxian on Mon, 12/05/2016 - 00:22

DDoS attack halts heating in Finland amidst winter

A Distributed Denial of Service (DDoS) attack halted heating distribution at least in two properties in the city of Lappeenranta, located in eastern Finland. In both of the events the attacks disabled the computers that were controlling heating in the buildings.


Netflix will let you download movies to watch offline

Submitted by luxian on Thu, 12/01/2016 - 06:53

This announcement made my day. I will definitely use it for long trips and even while commuting.

Few things you need to know:

  • works only on smartphones (iOS and Android)
  • all videos have an expiration date and they will be deleted automatically afterwards
  • for ~ 1 hour of video you'll need ~280Mb for standard definition or ~ 440Mb for high definition
  • you cannot access video with your file manager (similar to Spotify offline content)

Gizmodo has a full article describing how it will work in detail: Everything you need to know about Netflix downloads

Security News 2016-11-30

Submitted by luxian on Wed, 11/30/2016 - 18:03

Emergency Bulletin: Firefox 0 day in the wild. What to do. (first seen here)

A few hours ago a zero day vulnerability emerged in the Tor browser bundle and the Firefox web browser. Currently it exploits Windows systems with a high success rate and affects Firefox versions 41 to 50 and the current version of the Tor Browser Bundle which contains Firefox 45 ESR.

If you use Firefox, we recommend you temporarily switch browsers to Chrome, Safari or a non-firefox based browser that is secure until the Firefox dev team can release an update. The vulnerability allows an attacker to execute code on your Windows workstation. The exploit is in the wild, meaning it’s now public and every hacker on the planet has access to it. There is no fix at the time of this writing.

App-installing malware found in over 1 million Android phones

A new malware campaign has been discovered in over 1 million Android devices, according to a new report from the security firm Check Point. Dubbed “Googlian” by the firm, the campaign first emerged in August, and is currently compromising devices at a rate of roughly 13,000 per day.