How to fix VIN can not be decoded on selected Partner in Vida2014

PLEASE MAKE A BACKUP OF DATABASE (basedata) to be able to revert any changes otherwise VIDA re installation may be required

You are making any changes at your own risk and I can’t be responsible for any damages you have made to your software/car by using this modification.

This reverse engineering tutorial explain how to make modification to Vida2014 database to allow decoding same model cars produced in 2016/2017. This tutorial is not for latest models of Volvo cars based on SPA platform etc.

Step 1

Install SQL Management Studio in your Vida Installation.

Check you Windows Version 32-bit or 64-bit in by right clicking on Computer->Properties

Then download SQL Management Studio 2008

Guide here also https://www.sqlshack.com/how-to-install-sql-server-management-studio-2008/

https://www.microsoft.com/en-us/download/details.aspx?id=22985

Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2: Download and install Windows Installer 4.5.
Step 3: Download and install Windows PowerShell 1.0.
Step 4: Download SQL Server 2008 R2 Management Tools by clicking the appropriate link below.

then download 32-bit x86 or 64-bit depending on your enviroment

Once Installed you need to decode your VIN.

Open up your SQL Management Studio then navigate to

Navigate to basedata database and dbo.VINDecodeModel to find your model ID number which will be needed later

10th Letter of the VIN is the Manufactures Year

fkPartnerGroup (1002 for Europe)

Write down this number

fkModelYear (1205 for Model 2015)

Write down this number

then issue this command

and find out your ID based on your VIN.

VinCompare take it from your VIN number

Chassis number take from VIN number so

So let say that 4th and 5th of your IN number is DZ

Your Model is 2015 (1205)

You will use Europe in Vida so (1002) and chassis number last number of your VIN is between 628000 and 999999

So your ID is -2042382900


This is basically an entry used by VIDA to decode your model car. It’s not working because 10th letter of your VIN codes for 2017 is letter H

F – 2015

G- 2016

H- 2017

You need to change the letter from F to H so that VIDA can use this entry to decode your car.

Make a backup if your database now.

Now update this entry by issue this command and using correct 10th letter from your VIN Number for my 2017 model it should be ‘H’ in the VIN number.

Your car should decode now correctly in VIDA. It will display model 2017 as 2015.

Disclaimer:

I don’t have or own any of these software and any screenshots have been provided by anonymous owner.

If you would like me to buy a beer here you go 🙂

Linux – How to pass ls result to remove files using rm

Sometimes it’s much easier during the log removal to first check what is going to be removed then use these known result to actually remove the files.

You can use the following command combination for instance to achieve it.

ls | grep “2019” | xarg rm

This will list the files in the current directory search for the files which contains “2019” in the filename then remove them.

This is a quick way to remove unnecessary logs.

How to fix freezes/disconnection in RDP

Info

The issue with session disconnection seems to be effecting connection between Windows 10 <=> Windows 10 machines.

MacOS users or users with different Windows version are not reporting this problem.

Disable URCP (Universal Rate Control Protocol)

On host machine (work pc) open up regedit then search in

HKLM:\Software\Microsoft\Terminal Server Cient

Add REG_DWORD with value 0

reboot is required for changes to take effect

Disable RDP UDP protocol

On home pc open up regedit then search in

HKLM\SOFTWARE\Policies\Microsoft\Windows NT\Terminal Services\Client

Create a DWORD named fClientDisableUDP and assign it a value of 1

reboot is required for changes to take effect or

Run Group Policy Editor.  Navigate to Computer Configuration > Administration Templates > Windows Components > Remote Desktop Services >

Remote Desktop Connection Client.  Set the “Turn Off UDP On Client” setting to Enabled.

Start an elevated command prompt (run cmd.exe as administrator), and then run:

reg add “HKLM\software\policies\microsoft\windows nt\Terminal Services\Client” /v fClientDisableUDP /d 1 /t REG_DWORD

Set fDenyTSConnections to 0

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server

fDenyTSConnections to 0

When the policy is refreshed (by default, every 90 minutes, or manually through GPUPDATE), the policy settings are deleted and then reset. During this period, the configuration on the server is temporarily valid. Therefore, all sessions may be disconnected.

Try different settings in Remote Desktop Connection

In Remote Desktop Connection navigate to Experience

Turn Off Persistent bitmap caching

Try Different Performance settings e.g. Satellite connection with high latency

Turn Off Printer and Smart card

Change Colors to True Color 24bit in Display settings

Disable IPv6

Navigate to your Network Adapters -> Properties and disable IPv6

KB

Similar issues reported

https://support.microsoft.com/en-us/help/2083411/remote-desktop-sessions-may-be-disconnected-during-group-policy-update

https://superuser.com/questions/1481191/remote-desktop-intermittently-freezing

Covid-19 UK Summary

Sites

World Heath Organization (WHO) – https://www.who.int/emergencies/diseases/novel-coronavirus-2019

Centers for Disease Control and Prevention – https://www.cdc.gov/coronavirus/2019-nCoV/index.html

Current https://www.arcgis.com/apps/opsdashboard/index.html#/f94c3c90da5b4e9f9a0b19484dd4bb14

https://coronavirus-disasterresponse.hub.arcgis.com

https://www.worldometers.info/coronavirus/#countries

UK Dashbord

https://www.arcgis.com/apps/opsdashboard/index.html#/f94c3c90da5b4e9f9a0b19484dd4bb14

Cases In World

https://www.statista.com/statistics/1043366/novel-coronavirus-2019ncov-cases-worldwide-by-country/

Self-check

Taiwan experts provide a simple self-check that we can do every morning. Take a deep breath and hold your breath for more than 10 seconds.

If you complete it successfully without coughing, without discomfort, stiffness or tightness, etc., it proves there is no Fibrosis in the lungs, basically indicates no infection.

In critical time, please self-check every morning in an environment with clean air.

Serious excellent advice by Japanese doctors treating COVID-19 cases: Everyone should ensure your mouth & throat are moist, never dry.

Take a few sips of water every 15 minutes at least.

Why? Even if the virus gets into your mouth, drinking water or other liquids will wash them down through your throat and into the stomach. Once there, your stomach acid will kill all the virus.

If you don’t drink enough water more regularly, the virus can enter your windpipe and into the lungs.

That’s very dangerous.

IMPORTANT ANNOUNCEMENT – CORONAVIRUS

1. If you have a runny nose and sputum, you have a common cold

2. Coronavirus pneumonia is a dry cough with no runny nose.

3. This new virus is not heat-resistant and will be killed by a temperature of just 26/27 degrees. It hates the Sun.

4. If someone sneezes with it, it takes about 10 feet before it drops to the ground and is no longer airborne.

5. If it drops on a metal surface it will live for at least 12 hours – so if you come into contact with any metal surface – wash your hands as soon as you can with a bacterial soap.

6. On fabric it can survive for 6-12 hours. normal laundry detergent will kill it.

7. Drinking warm water is effective for all viruses. Try not to drink liquids with ice.

8. Wash your hands frequently as the virus can only live on your hands for 5-10 minutes, but – a lot can happen during that time – you can rub your eyes, pick your nose unwittingly and so on.

9. You should also gargle as a prevention. A simple solution of salt in warm water will suffice.

10. Can’t emphasis enough – drink plenty of water!

THE SYMPTOMS

1. It will first infect the throat, so you’ll have a sore throat lasting 3/4 days

2. The virus then blends into a nasal fluid that enters the trachea and then the lungs, causing pneumonia. This takes about 5/6 days further.

3. With the pneumonia comes high fever and difficulty in breathing.

4. The nasal congestion is not like the normal kind. You feel like you’re drowning. It’s imperative you then seek immediate attention.

Recovery Time

  • mild cases: approximately 2 weeks
  • severe or critical disease: 3 – 6 weeks
  • time from onset to the development of severe disease (including hypoxia): 1 week

Symptoms

Common symptoms included:
(Wang et al study) [2]
Fever98.6%
Fatigue69.6%
Dry cough59.4%

The median time observed:

  • from first symptom to → Dyspnea (Shortness of breath) = 5.0 days
  • from first symptom to → Hospital admission = 7.0 days
  • from first symptom to → ARDS (Acute Respiratory Distress Syndrome) = 8.0 days (when occurring)
More info

Extending Web Monitoring History in Zabbix to increase 90 days hard limit

To extend the monitoring in Zabbix of Website Responses statistics you need to do it manually in the Zabbix database.

Open up database then issue this commands to display items which you will be amending to make sure that you are in the right place.

SELECT * from items WHERE TYPE=9

then update items to extend 90 days trends to a year for example.

Update items set trends=365 where type=9

List of User-Agent used in DDos attack to website

Please find the list below which seems to be quite popular. Search for the user agent in your web logs and block the whole list.

Someone was using the list during DDOS with traffic originating from different IP’s

https://github.com/mythsman/weiboCrawler/blob/master/opener.py

ua=["Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_8; en-us) AppleWebKit/534.50 (KHTML, like Gecko) Version/5.1 Safari/534.50",
"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-us) AppleWebKit/534.50 (KHTML, like Gecko) Version/5.1 Safari/534.50",
"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0",
" Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:2.0.1) Gecko/20100101 Firefox/4.0.1",
"Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1",
"Opera/9.80 (Macintosh; Intel Mac OS X 10.6.8; U; en) Presto/2.8.131 Version/11.11",
"Opera/9.80 (Windows NT 6.1; U; en) Presto/2.8.131 Version/11.11",
" Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Maxthon 2.0)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; TencentTraveler 4.0)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; The World)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; SE 2.X MetaSr 1.0; SE 2.X MetaSr 1.0; .NET CLR 2.0.50727; SE 2.X MetaSr 1.0)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; 360SE)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser)",
" Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)",
"Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_3_3 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8J2 Safari/6533.18.5",
"Mozilla/5.0 (iPod; U; CPU iPhone OS 4_3_3 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8J2 Safari/6533.18.5",
"Mozilla/5.0 (iPad; U; CPU OS 4_3_3 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8J2 Safari/6533.18.5",
" Mozilla/5.0 (Linux; U; Android 2.3.7; en-us; Nexus One Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1",
" MQQBrowser/26 Mozilla/5.0 (Linux; U; Android 2.3.7; zh-cn; MB200 Build/GRJ22; CyanogenMod-7) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1",
" Opera/9.80 (Android 2.3.4; Linux; Opera Mobi/build-1107180945; U; en-GB) Presto/2.8.149 Version/11.10",
" Mozilla/5.0 (Linux; U; Android 3.0; en-us; Xoom Build/HRI39) AppleWebKit/534.13 (KHTML, like Gecko) Version/4.0 Safari/534.13",
" Mozilla/5.0 (BlackBerry; U; BlackBerry 9800; en) AppleWebKit/534.1+ (KHTML, like Gecko) Version/6.0.0.337 Mobile Safari/534.1+",
" Mozilla/5.0 (hp-tablet; Linux; hpwOS/3.0.0; U; en-US) AppleWebKit/534.6 (KHTML, like Gecko) wOSBrowser/233.70 Safari/534.6 TouchPad/1.0",
" Mozilla/5.0 (SymbianOS/9.4; Series60/5.0 NokiaN97-1/20.0.019; Profile/MIDP-2.1 Configuration/CLDC-1.1) AppleWebKit/525 (KHTML, like Gecko) BrowserNG/7.1.18124",
" Mozilla/5.0 (compatible; MSIE 9.0; Windows Phone OS 7.5; Trident/5.0; IEMobile/9.0; HTC; Titan)",
" UCWEB7.0.2.37/28/999",
" NOKIA5700/ UCWEB7.0.2.37/28/999",
" Openwave/ UCWEB7.0.2.37/28/999",
" Mozilla/4.0 (compatible; MSIE 6.0; ) Opera/UCWEB7.0.2.37/28/999"]

How to fix Window Search Bug 2020

Open up command line then run those. These disable bing/cortana in search.

REG ADD HKCU\Software\Microsoft\Windows\CurrentVersion\Search /v BingSearchEnabled /t REG_DWORD /d 0

REG ADD HKCU\Software\Microsoft\Windows\CurrentVersion\Search /v CortanaConsent /t REG_DWORD /d 0

press y / rebooted if not fixed immediately

Enjoy!

How to add additional static ip to debian distro in Linux

/etc/network
then
vim interfaces

check the interface name in the first two lines iface eth0 inet static
then add
ip addr add 10.2.22.2/24 dev $IFACE label $IFACE:0
down ip addr del 10.2.22.2/24 dev $IFACE label $IFACE:0

then save the file :wq

you can then add it to the interface so it’s available without reloading the network service

address add 10.2.22.22/24 dev eth0

You should be able to ping this ip now.