www.numberspeaks.com

BLOG

Linux

Problem with Godaddy VPS upgrade

I recently had a problem with Godaddy ubuntu 16.04 VPS, after updating and upgrading the system: SSH port wasn’t anymore reachable, it’s the only access we have to the server, however other services are working normally, so the system is still running. I tried many times to restart, call the support, but it didn’t solve the problem. The only solution was to destroy the server and rebuild it from scratch + restoration of backups. I’ve also tested the upgrade with a clean and freshly installed system, same issue occurred. If you’re running Ubuntu 16.04 VPS on Godaddy, Do not upgrade …

Odoo / OpenERP

Additional measure in Odoo graph view

  This article will help you to add measures in graph view, my exemple is based on sale order model, for all additional computed fields, attribute store must be set to True, otherwise you won’t be able to choose it from the dropdown list measure in graph view. When grouping, you might want to calculate on some fields the average instead of the sum, if so, you need to use group_operator = ‘avg’ directly in your model file, see margin_percent field bellow. Find the view_id of your graph view and inherit from it. then place your new field as measure …

Odoo / OpenERP

Odoo 9 Email Template

This is a basic email template to put in the xml file: if the module name is abc and the model name is voyelle then module_name.model_model_name should be abc.model_voyelle. ${object} is the model ${object.name} will display the attribute name of the current model.

Hacking

Hacking : man-in-the-middle attack

Interesting video (in French) explaining man-in-the-middle attack. for more information concerning the attack, click here Tools used during this demo. Nmap : network scanner. Ettercap : man in the middle utility. Wireshark : network packet reader. Metasploit : hacking framework. This video and all information from this post are only for educative purpose, it’s totally illegal to use it in public or corporate network.

Microsoft / MsSql

Mssql differential restoration error

After trying to restore differential backup after a full backup, i got this error message : The log or differential backup cannot be restored because no files are ready to roll forward. To be able to complete differential restoration, full backup needs to be restored with “WITH NORECOVERY” option as follow:

Linux / Mac OS X / OpenVPN / sTunnel

Stealthy tunnel with stunnel, OpenVPN on Mac OS and Debian

OpenVPN is more and less banned in some countries, therefore to be able to use it there, we need to make it stealthy by installing a 3rd party software like Tor, SSH Tunnel or Stunnel which hides openVPN traffic from governmental firewall detection. The principle is quite simple, we create a tunnel between our computer and the openVPN server which is encrypted by a certificate, then we send our openVPN traffic through this tunnel. Debian 8 stunnel server installation First OpenVPN should be configured to use TCP instead of UDP, on this example we open port number 1000 and redirect …

More