DEV Community: Alejandro Bonilla

Installing PostGis and QGis, first GeoDataBase and Simple Insert

Alejandro Bonilla — Thu, 06 Jun 2019 05:17:50 +0000

Hi!, I have a longer time without write a post ... ups xD.

Today I write a little post explain you: How I installed PostGis plugin, create geometry table, and insert data.

Fast Specs in my server: Centos 7 minimal install, Postgres 11.
Fast Specs in my Macbook: PgAdmin 4, QGis.

Step 1: Install PostGis Plugin.

# yum install postgis2_11

important!!! : the latest number its your Postgres Version in your server.

Step 2: SQL time.

I use PgAdmin because my team its a non-programmer or technical users, maybe I write a post explain this.

2.1 : Create Database

2.2 : Run the script on "Enabling PostGIS" section: https://postgis.net/install/

2.3 : Create a simple Geo Table on public schema:

CREATE TABLE TABLEOFPOINTS
(
    id serial,
    Place character varying COLLATE pg_catalog."default" NOT NULL,
    dir character varying COLLATE pg_catalog."default",
    geog geography(Point,4326) NOT NULL,
    CONSTRAINT TABLEOFPINTS_pkey PRIMARY KEY (id)
)

Okay, Now you have a simple points table; NOT POLYGONAL.

Step 3: Run QGis (I running on 3.4) and connect to PostGis

Step 4: Install OpenLayers

4.1: Enable experimental and deprecated plugins

Plugins->Manage and install plugins->Settings

4.2 Search and Install OpenLayers

Plugins->Manage and install plugins->All

4.3 Add OpenLayers plugin to project

Web->OpenLayers Plugin->OpenStreetMap->OpenStreetMap

Step 5: Add your Point Layer (Postgres spacial table)

Step 6: Make Points

First make sure you have chosen the layer "TABLEOFPOINTS"

1- Click on Pencil icon (Toggle edit).
2- Click on "Add Point feature", and add your points.
3- Complete your data info and click on "Save Layer edit" icon

Ok, if I'am a good teacher you can create spatial database of point, basic use of Qgis and connect at your first Geo Table; finally add points at your database.

The next week, I need use the Geo table to show points using NodeJS and VUE. I hope, this post has been useful for you and also listen to any suggestions for use in node and vue

How do you manage your usernames and passwords?

Alejandro Bonilla — Sat, 01 Jun 2019 23:42:59 +0000

Hi, The last week I lost 3, yes TRHEE! credentials:

1-Grandstream IP-PBX.
2-Hikvision NVR.
3-and pizza hut online delivery.

The 1 and 2 item; I lost $160 in spending.

and you... How many users and password did you lose on mid of 2019?
How manage your credentials?

Bootstrap-vue custom color variant

Alejandro Bonilla — Fri, 18 Jan 2019 22:47:40 +0000

Hi Dev's, i'm new in Bootstrap-Vue.

How I can customize the navbar background and text colors?

Thanks.

where is vue.config.js?

Alejandro Bonilla — Tue, 02 Oct 2018 01:08:12 +0000

I new in vue, where is the vue.config.js?

I read the documentation, but I do not understand

https://cli.vuejs.org/config/#vue-config-js

thanks.

Edit:solved... appears magically

Drawing in dev.to

Alejandro Bonilla — Mon, 24 Sep 2018 21:25:28 +0000

Did you create your drawing?

A few minutes ago I had internet problems, and at that precise moment I wanted to enter dev.to, and discovered something.

The internet came back, but I wanted to continue drawing, the backend can wait.

Yes, it is mine, not kidding, the drawing of a man 26 years old.

Go to Dev.to, deactivate your network card, F5 and draw.

bye bye

docker+node+vue+apache

Alejandro Bonilla — Sat, 22 Sep 2018 00:55:51 +0000

Hi Dev's

I have 1 physical server with Centos 6. This a old server, with a lot services for my office, and now goes to migrating at new technologies. (Vue and node)

The cuestion...

Its a great idea dockerizer the Website of my business?

I need dockerizer vue+node on same container, or one container for vue frontend and other for node backend container?

PD: I learning docker ... and English xD

configure and run vue+nodejs

Alejandro Bonilla — Wed, 12 Sep 2018 22:07:03 +0000

Hi Devs. I am noob in StackDeveloper.

How configure vue-cli and nodejs for run both in same script for example:

run server app.js

And run the frontend and the backend.

Thanks.

PD: my english is bad

Cleaning our Macbook

Alejandro Bonilla — Mon, 10 Sep 2018 23:58:23 +0000

Hi, today I clean my laptop, server, networking devices and I share with you my steps for cleaning my macbook :P .

One day without programming.
Clean your devices and clear your mind -Me.
Step 1: Your laptop

Requeriments Part 1:
Cloths and Air compressed (I have compressor because in my house I have server's, switches and routers, motor of my car and blah blah).

Requeriments Part 2:
Silicone for the body, keyboard and tochpad. And crystal cleaner for your Retina (Laptop, not for you).

In the Malls have 2 common type of silicone, fatty and dry, the fatty is a horrible option por clean your PC's, he sensation when touching it is ugly.

My laptop :(

Cleaning 1:
Use the air compressing on all laptop.

Apple Oficial guide for clean the macbook pro 2017 keyboard

Cleaning 2:
Attention!! : "Don't use aerosol sprays, solvents, abrasives, or cleaners containing hydrogen peroxide that might damage the finish". Apple Oficial guide for clean the macbook

Maybe you have a sticky or glued particles, and use cloth for remove this with sugar.
Use the "Dust" clothe, for remove the big particles, a little strength, and a lot of sugar, be sugar; if you not have sugar, your laptop get scratches in the body.

Cleaning 3:

Use the silicone

Attention!! : "Don't use aerosol sprays, solvents, abrasives, or cleaners containing hydrogen peroxide that might damage the finish". Apple Oficial guide for clean the macbook

Clean the body, keyboard and Touchpad; DONT USE THIS IN YOUR SCREEN!!!

Cleaning 4:
Clean the screen, with a nice lint-free cloth. "Avoid abrasive cloths, towels, paper towels, and similar items that might cause damage" Apple Oficial guide for clean the macbook pro 2017 keyboard
And again, be sugar, sugar, the macbook need sugar.

Result:

Finally
Use your peripherals, go to the park, look a movie at Netflix, read your book and let the silicon take effect if you use your keyboard after apply the "silicone",can spots appear, this spots are not permanent but your need repeat the "Cleaning 2" step.

Happy Cleaning.

PD: My english is bad

HTTPS server with NojeJS

Alejandro Bonilla — Wed, 05 Sep 2018 23:48:05 +0000

Hi :D

This week I write a little bot for messenger ( Facebook chat). I have not had fb for some years.

I re-discover the facebook social network and join in developer.facebook.com, the documentation in this site is big confused.

well...

You need run your webhook over HTTPS server, and Facebook check your certs; if you run nodejs over local https; with self-generated certificates Facebook says: "..." I don't remember xD, but Facebook don't accept your "insecure" connection with your self-generated certificates with openssl.

I try install my self-generated certificates with openssl, and not found :(

But!.. in my post

Install SSL certificate with Certbot in Centos 7

Alejandro Bonilla ・ Jul 30 '18

#certbot #centos7 #apache #ssl

I use "certbot" and in this project I used an online service: zerossl.com they also use let's Encrypt.

Go to Zerossl.com and get your certificates, search the "Service FAQ" and "How-To Videos" in the website and get yours CA, CERT and Key archives.

Copy your download files in your workspace folder.

Ok, you have your files, generated in zerossl.com, now write the daily code for simple NodeJS; and add this require.

var https = require("https");]

add your download files (the zerossl.com certificates)

const options = {
  key: fs.readFileSync("/dir/key.key"),
  cert: fs.readFileSync("/dir/crt.crt"),
  ca: fs.readFileSync("/dir/ca.ca"),
};

Finally replace your

app.listen(3000);

for this:

https.createServer(options, app).listen(port,console.log("webhookk listen")).

Complete example:

'use strict';

THE REQUIRES AND process.env.PORT AND BLAH BLAH cons and other magic trick

var https = require("https");
var  fs = require("fs");

const options = {
  key: fs.readFileSync("YOURDIR/key.key"),
  cert: fs.readFileSync("YOURDIR/crt.crt"),
  ca: fs.readFileSync("YOURDIR/ca.ca"),
};

app.post('/webhook', (req, res) => {  
 yourcode
});


app.get('/webhook', (req, res) => {
   yourcode
  });

function handleMessage(sender_psid, received_message) {
   yourcode
}

function handlePostback(sender_psid, received_postback) {
  yourcode
  callSendAPI(sender_psid, response);
}

function callSendAPI(sender_psid, response) {
  yourcode
}
https.createServer(options, app).listen(port,console.log("webhookk listen"));

Now, Facebook accept your secure connection :D

remember that the certificates expire, you must renew them.

remember 2: Https use the port 443, configure your firewall and move your others server (apache , nginx).

List of Open-Source Software for Business, you and me

Alejandro Bonilla — Tue, 04 Sep 2018 23:26:38 +0000

Hello, I always like to start a post with a "hello" to all.

Today I write a little list of open-source software for Business, for you and everyone.

For the Business

Server OS: CentOS/RHEL 7 or Ubuntu; or pay for RedHat or Opensuse Enterprise and go to sleep?

Email Server:Postfix+Dovecot

Webmail Server:RoundCube or Squirrelmail (webmail for nuts! xD)

AntiSpam: Spamassassin

Web Server: LAMP (or LEMP, or you know xD)

Email client: Thunderbid

CardDav server: Radicale

Data safety backup: Seafile

edited
Office Suite: LibreOffice, Open365 in your Server... or Google Docs (free but not opensource; thx Antony Garand )
end edit
For the social networks guys: Gimp

And for big enterprises company's:Containers+Orchestration.

Unfortunately many of the users of my company need Microsoft Excel, macros and functions that are not compatible with the other programs, but step by step, will change

and if you do not agree with this, and you need sleep: AWS, Google, Microsoft and etc solutions :) .

For me:
Ubuntu and Linux Mint <3
Visual Code Studio
GIMP
LibreOffice
Seafile
Thunderbird
Filezilla
Telegram ?
Git
All the open-source framework's and libraries to make the unbelievable software.

comment your open-source software's, maybe you can help someone solve a problem.
We are a community.

PD: My english is bad :P

Web App or LAMP?

Alejandro Bonilla — Fri, 31 Aug 2018 21:25:59 +0000

Hi guys, and ladies.

I am a freelance and I have a project, a website with a catalog of proudcts, profiles and "mini-stores" within the same website. The boss wants a web app.

All sponsors say Web App.

Is it a good idea, a Web App for public access and production?

Web app for change network configuration?

Alejandro Bonilla — Wed, 29 Aug 2018 06:40:57 +0000

Hi to all.
It's possible change the network configuration via Web APP?

Maybe with Dart?

I don't want use Micro.. Visua Studi.. (Cough, cough). xD

I need change the network configuration of my LAN (Windows 10 and 7) via Software.