tiagocardosos

Server setup for Ubuntu and Elasticsearch Cluster on Digital Ocean

Update system

apt-get update && apt-get dist-upgrade -y
apt-get autoremove -y

Create and expose a SSH Key for the new user

tiagocardosos

Install PostgreSQL 10 on Ubuntu

This is a quick guide to install PostgreSQL 10 - tested on Ubuntu 16.04 but likely can be used for Ubuntu 14.04 and 17.04 as well, with one minor modification detailed below.

(Optional) Uninstall other versions of postgres

To make life simple, remove all other versions of Postgres. Obviously not required, but again, makes life simple.

dpkg -l | grep postgres

tiagocardosos

#aula 1

import numpy as np
my_array = np.arange(1000000)
my_list = list(range(1000000))

%time for _ in range(10):my_array * 2
%time for _ in range(10):my_list2 = [x * 2 for x in my_list]

data = np.random.rand(5, 7)

tiagocardosos

Solving GPG error (public key not available)

Exemplo de mensagem de erro:

W: Erro GPG: http://ppa.launchpad.net precise Release: As assinaturas a seguir não puderam ser verificadas devido à chave pública não estar disponível: NO_PUBKEY A8AA1FAA3F055C03

A mensagem acima indica que o sistema não possui a chave GPG de autenticação (número A8AA1FAA3F055C03) para o repositório PPA.

A solução é simples. Basta adicionar o número da chave (indicado na mensagem de erro). Sinopse do comando: sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys NÚMERO_DA_CHAVE

tiagocardosos

#!/bin/bash
#mysql_config_editor set --login-path=local --host=localhost --user=username --password
echo "$(date +'%Y%m%d %k%M%S'): Starting daily backup." >> dump.log

echo "SET autocommit=0;
SET unique_checks=0;
SET foreign_key_checks=0;" > /root/backup.sql

#bkp mysql
/usr/bin/mysqldump --login-path=local --databases my_db >> /root/backup.sql

tiagocardosos

Server setup for Ubuntu 16.04 on Digital Ocean

The setup installs the following software:

• Nginx
• MySQL
• PHP
• Node
• Composer

tiagocardosos

Installing Docker CE on Ubuntu 17.10 Artful Aardvark

As of 20/10/2017, a release file for Ubuntu 17.10 Artful Aardvark is not available on Download Docker.

If you are used to installing Docker to your development machine with get-docker script, that won't work either. So the solution is to install Docker CE from the zesty package.

sudo apt-get update
sudo apt-get install apt-transport-https ca-certificates curl software-properties-common
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -

tiagocardosos

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import httplib
import re
import sys
import base64
import subprocess
import urllib
import lxml.etree

tiagocardosos

sudo apt-get install software-properties-common

sudo add-apt-repository ppa:jonathonf/python-3.6
sudo apt-get update
sudo apt-get install python3.6 libpython3.6

sudo update-alternatives --install /usr/bin/python3 python3 /usr/bin/python3.5 2
sudo update-alternatives --install /usr/bin/python3 python3 /usr/bin/python3.6 1

sudo rm /usr/bin/python3

tiagocardosos

# Importando o Driver de conexao do Firebird
import fdb
import os.path

# Conecta ao Firebird
con = fdb.connect(dsn='X.X.X.X:/Caminho/Base.GDB', user='user', password='senha')

# Executando  SQL

cursor = con.cursor() # cria cursor