All posts filed under: System Administration

Linux: MySQLdb on virtualenv with –no-site-packages

comment 1
Howtos / Python / System Administration

In the past it was difficult to get MySQL working on virtualenv without using system packages. Now you can have a real separated environment with simple steps: Follow this guide to install virtualenv using this command: This command will install a new virtualenv inside a new directory myproject created by the command itself. Activate virtualenv: Upgrade setuptools You can now install MySQLdb, inside the package MySQL-python: Now do a simple test trying to connect to […]

Free SSL certificates and how to install on nginx in 10 steps

comment 1
Howtos / System Administration
HTTPS, encrypt via SSL / TLS

Here how you can get free SSL cerificates using Let’s Encrypt. Forget about the expire of certificates using the auto-renewal script. A complete reference to install a Let’s Encrypt certificate is this Digital Ocean’s howto. Here there’s a quick guide based on it, plus some additional suggestions. Here we go! The following code download the script and make it executable. (1) Logout and login again to make the certbot-auto script available as a command without […]

Transfer files from iPad to Windows wireless w/o cloud in 10 steps

Leave a comment
Howtos / System Administration

10 steps to transfer files without using iCloud or other cloud services: an iPad and Windows are all you need. Requirements: Windows (tested on Windows 7) Wi-fi router Windows Create a new folder ipadshare on your disk (even removable) to host files Right click on the folder > Share with... > Specific users… Click on the bottom arrow on the dropdown > Create a new user > Another account (second to last element) > Create […]

PuTTY freezes on OpenVPN on Windows

Leave a comment
Howtos / System Administration

Issue: Opening PuTTY no login information are returned and then the connection is closed. Solution (Windows 7): On the taskbar Right click and then Disconnect the VPN Look for the VPN icon and then Right click on VPN shortcut icon > Properties Select Compatibility tab and then check Run as administrator Launch OpenVPN: a message will be prompted to allow the app to run as administrator

Stop to send Microsoft information about your system

Leave a comment
Howtos / System Administration

These steps will help you to block some of error reporting to Microsoft. To help you in the task of finding error reporting issues install and run the free Kaspersky Security Scan: you will be notified by a list of issue affecting the PC the other antivirus usually don’t tell. One of it is the notification to Microsoft of system states in situations like crashes. To stop sending Microsoft information like this you can follow […]

Free disk space by finding big files

Leave a comment
Howtos / System Administration

Here you can find some useful application to look for big files on disk for Windows and Linux. These disk tools are all free software, and very useful to find big files on disk and free disk space. On Windows: WinDirStat Download and install WinDirStat Run WinDirStat on your disks (it will take time) You’ll see a coloured map of file occupation by file type On Linux command line: ncdu On Ubuntu / Debian apt-get […]

How to exchange a webserver maintaining the same IP address: haproxy

Leave a comment
Howtos / System Administration

Scenario: An obsolete server hosting a website must be put offline and a new one must take his IP address. You don’t want to change all of yours A records on DNS to put online your new website, just exchange the internal IP address of your local network. Your provider can exchange the addresses to assign the old IP public address to the new internal IP but it takes his time. How to cover the […]

Installing Solr 5 on CentOS 6 with Java 1.7

Leave a comment
Howtos / System Administration

Here the instructions for a CentOS 6 with an already-installed Java 1.7 for Solr 5 without Tomcat. Now run the install_solr_service script as documented on official documentation: To get the current status: The service is already set to autostart: If you want to secure the Solr instance running it only on localhost, you can add a custom SOLR_OPTS: Apply the changes and then check where the service is running: Before was available to all clients: […]

How to enable gzip on proxy servers on nginx

Leave a comment
Howtos / System Administration

I use often Gunicorn as web server for django applications. Usually I use Apache but I’m starting to use nginx as webserver to serve both the static files and the proxied gunicorn response. I need to do something like what I’ve done with Apache to compress the response after I received from django since I’ve noticed that in my case compressing it before using @gzip_page decorator is more detrimental to performance than doing it after. […]