mySql Common Commands

CREATE TABLE foo LIKE bar;

CREATE TABLE IF NOT EXISTS offices_bk

SELECT * FROM

    offices;

==

CREATE TABLE IF NOT EXISTS new_table LIKE existing_table;

INSERT new_table

SELECT * FROM existing_table;

ALTER TABLE <tablename> CHANGE COLUMN <colname> <colname> VARCHAR(65536);

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);

Or use CHANGE, but that means you have to give the column name twice (because CHANGE allows you to change the name of the column too).
ALTER TABLE emp CHANGE COLUMN name name VARCHAR(100);

Linux Discover Teamviewer id

$sudo grep -n id /home/user/.local/share/teamviewer14/logfiles/TeamViewer14_Logfile.log

$whereis teamviewer
$/usr/bin/teamviewer help
$/usr/bin/teamviewer info #for get id too

$/usr/bin/teamviewer daemon stop
$/usr/bin/teamviewer setup
$/usr/bin/teamviewer daemon status
$/usr/bin/teamviewer daemon start

References:
[1] http://www.tonisoto.com/2013/07/launching-teamviewer-remotely-throught-ssh/

mySql change port problem

Can't start server: Bind on TCP/IP port: Permission denied
Do you already have another mysqld server running on port: 13306 ?


Common solution is change my.cnf adding port=newport, but in what section?

Discover who is the principal executable
$locate mysqld.service

/etc/systemd/system/multi-user.target.wants/mysqld.service
/usr/lib/systemd/system/mysqld.service

$vi /usr/lib/systemd/system/mysqld.service #for watch settings
In my case, was this:
ExecStart=/usr/bin/mysqld_safe --basedir=/usr

then i know what section i need to change

$vi /etc/my.cnf  # add new port in section [mysqld_safe]

Aditional commands during process:

tail -30 /var/log/mysql/error.log

sudo lsof -i TCP:3306
netstat -lp | grep 3306
 

$systemctl status iptables.service

$service iptables status

Ubuntu mySQL Backup/Restore

1)Create


2) Restore


$mysql -u root -p mysql
> create database mydb; mysql
> use mydb; mysql
> source db_backup.dump;


3) Another way, you  need to run:

$mysql -p -u[user] [database] < db_backup.dump

If the dump contains multiple databases you should omit the database name:

$mysql -p -u[user] < db_backup.dump

4) Restore specific database

$mysql -u onepoint -p --one-database maxx2016 < back_20190226.sql

Ubuntu Apache Django settings

References:
[1] main https://www.digitalocean.com/community/tutorials/how-to-serve-django-applications-with-apache-and-mod_wsgi-on-ubuntu-16-04

[2] https://coderwall.com/p/ooerda/python-django-apache-ubuntu
[3] https://www.digitalocean.com/community/tutorials/how-to-serve-django-applications-with-apache-and-mod_wsgi-on-debian-8

Fixing geopandas and osmnx problem: Could not find libspatialindex_c library file

For secondary problem trying to resolve (trying to find the library i got):
Traceback (most recent call last):
  File "", line 1, in
NameError: name 'find_library' is not defined
The solution is:

import ctypes
from ctypes.util import find_library

When you install environment and install geopandas, rtree and osmnx

pip install git+git://github.com/geopandas/geopandas.git

pip install rtree

pip install osmnx

No error, everythong aparently is ok, and you try to test

$python

>>> import rtree
Traceback (most recent call last):
 File "", line 1, in
 File "/var/www/sampleapp/crivist/myEnv/lib/python3.5/site-packages/rtree/__init__.py", line 1, in
   from .index import Rtree
 File "/var/www/sampleapp/crivist/myEnv/lib/python3.5/site-packages/rtree/index.py", line 5, in
   from . import core
 File "/var/www/sampleapp/crivist/myEnv/lib/python3.5/site-packages/rtree/core.py", line 125, in
   raise OSError("Could not find libspatialindex_c library file")
OSError: Could not find libspatialindex_c library file

You can solve using:
sudo apt install python3-rtree
But in some servers, you can't access to apt, then you decide do next commands:

$git clone https://github.com/libspatialindex/libspatialindex.git
$cd libspatialindex
$cmake --prefix=/usr .
$make
$sudo make install  #You cannot install on system

CMake Error at src/cmake_install.cmake:52 (file):
  file INSTALL cannot copy file
  "/home/fincahuanaco/Temp/libspatialindex/bin/libspatialindex.so.5.0.0" to
  "/usr/local/lib/libspatialindex.so.5.0.0".
Call Stack (most recent call first):
  cmake_install.cmake:42 (include)

But you compile, then you have the link to file, then set next variable

export SPATIALINDEX_C_LIBRARY=environmentpath/lib/libspatialindex_c.so


Enjoy

References:
[1] geopandas http://geopandas.org/install.html
[2] python environment https://docs.python-guide.org/dev/virtualenvs/
[3] python environment 2 https://docs.python.org/3/tutorial/venv.html

Level Set Topics

References:


[1] Methods In (Bio)Medical Image Analysis 2019 https://www.cs.cmu.edu/~galeotti/methods_course/

Print JavaScript

[1] PDF and HTML http://printjs.crabbly.com/

Latex On Line

Latex online

[1] Single/public https://www.papeeria.com

[2] Latex/R/Python/Octave/Julia/Shell/GPU https://cocalc.com/

[3] Single Latex & Octave http://www.verbosus.com/  #limit 4 resources

[4] Quick snap code to image quicklatex.com

 

Over google docs
http://docs.latexlab.org/


Single Compiler
[1] http://latex.informatik.uni-halle.de/latex-online/latex.php
[2] http://sciencesoft.at/latex/flatex.gsp?lang=en

After register
Unlimited https://www.sharelatex.com/
Monkey http://monkeytex.bradcater.webfactional.com/


 



Others References
[1] http://tex.stackexchange.com/questions/3/compiling-documents-online
[2] http://texblog.net/latex-link-archive/online-compiler/

Ubuntu VPN

References:

[1] https://www.digitalocean.com/community/tutorials/how-to-set-up-an-openvpn-server-on-ubuntu-16-04

[2] Setting clients https://www.utwente.nl/en/lisa/ict/manuals/network/vpn/openvpn-ubuntu-en/

Python 3D Interactive

[1] Python draw 2d and 3d http://jeffskinnerbox.me/notebooks/matplotlib-2d-and-3d-plotting-in-ipython.html

[2] Python 3D picking https://stackoverflow.com/questions/10424517/how-to-get-properties-of-picked-object-in-mplot3d-matplotlib-python

[3] Python mayavi picking http://docs.enthought.com/mayavi/mayavi/auto/example_pick_on_surface.html

[4] Python mayavi for 3D https://docs.enthought.com/mayavi/mayavi/mlab.html

Fedora 23 - Executing MONO Asp.NET MVC App

Table 'mysql.user' doesn't exist:ERROR
Or
ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist

$mysql_upgrade -u root

Access problem (resolve inner mysql)

$mysql -u root -p
>show GRANTS FOR onepoint@localhost;


Execution problem



Turns out simply creating the folder using mkdir

$sudo mkdir /etc/mono/registry
$sudo chmod uog+rw /etc/mono/registry # setting the right permissions

Another way

You can set MONO_REGISTRY_PATH to point to a directory that you control:

$mkdir my-registry
$MONO_REGISTRY_PATH=`pwd`/my-registry
$xsp4

 

Next problem

System.MissingMethodException Method 'RouteCollection.get_AppendTrailingSlash' not found.




[uxxx@sxxx MaxxCoreWeb]$ mono --version
Mono JIT compiler version 4.0.5 (Stable 4.0.5.1/1d8d582 Mon Jan  4 11:09:45 UTC 2016)




These message showed because the system was build in mono 4.5 and mono 4.2 (both are compatible
for me in my system), but in my case i installed mono 4, lastest on Fedora 23.


Command for update repository to Fedora 27, but after update still doesn't ran
 

$rpm --import "https://keyserver.ubuntu.com/pks/lookup?op=get&search=0x3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF"
$su -c 'curl https://download.mono-project.com/repo/centos7-stable.repo | tee /etc/yum.repos.d/mono-centos7-stable.repo'
$dnf update

I removed mono and tried to install mono 5, mono 4.8 and mono 4.2, but i got error of conflicts. Then i executed next command:

$sudo dnf autoremove #for remove dependences


And tried again and was successful.

$ sudo dnf install mono-complete-4.8.1.0-0.xamarin.1.x86_64




References:
[1] Upgrade tips https://fedoraproject.org/wiki/DNF_system_upgrade
[2] mono https://www.mono-project.com/download/stable/#download-lin-fedora

Fedora 23 Services

$systemctl status sshd.service
$systemctl enable httpd.service
$systemctl disable service_name.service

$systemctl start service_name.service

$systemctl stop service_name.service 

$systemctl restart service_name.service

$systemctl list-units --type=service 

References:
[1] General info https://docs.fedoraproject.org/en-US/fedora/rawhide/system-administrators-guide/infrastructure-services/Services_and_Daemons/
[2] List services https://docs.fedoraproject.org/en-US/Fedora/15/html/Deployment_Guide/s1-services-running.html
 

 

Ubuntu mySQL Setting for remote access

1) Verify if is listenning
$wget --verbose http://localhost:3306
$wget --verbose http://192.168.0.12:3306
or
$nmap -sV localhost
$nmap -sV 192.168.0.12
or
$sudo netstat -tulpn
or
$sudo iptables -L -n

2) Verify file /etc/mysql/conf.d/  #include other possibles files
$sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf  #edit file and comment next line, or
$sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf

#bind-address        = 127.0.0.1

3) Add user


mysql>select user, host, authentication_string from mysql.user;

mysql>SHOW GRANTS FOR 'onepoint'@'%'; #if not exist

mysql> CREATE USER 'onepoint'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON Maxx2018.* TO 'onepoint'@'localhost' WITH GRANT OPTION;

mysql>CREATE USER 'onepoint'@'%' IDENTIFIED BY 'password';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'onepoint'@'%' WITH GRANT OPTION;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'onepoint'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;

4) Update user

mysql>use mysql;
mysql>update user set password=PASSWORD("NEWPASSWORD") where User='root'; 
mysql>flush privileges;


5) Common Errors


ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.


ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'


ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

SET GLOBAL validate_password_policy=LOW;

You can edir /etc/mysql/my.cnf, but then you will have a security risk!
in [mysqld] add:

validate_password_policy=LOW

References:
[1] Firewall ubuntu https://stackoverflow.com/questions/30251889/how-to-open-some-ports-on-ubuntu
[2] https://stackoverflow.com/questions/14779104/how-to-allow-remote-connection-to-mysql

Fedora 29 mySQL

$sudo dnf install https://dev.mysql.com/get/mysql80-community-release-fc29-1.noarch.rpm

$sudo dnf --disablerepo=mysql80-community --enablerepo=mysql57-community install mysql-community-server


works too for Fedora 23 (Server Edition)

Problems
$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

$ sudo grep 'temporary password' /var/log/mysqld.log


Referencias:
[1] https://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/

free VPN Service

vpnbook 2019 https://www.vpnbook.com/
  Username: vpnbook
  Password: rktbz9c


vpnbook (http://www.vpnbook.com/)
  Username: vpnbook
  Password: adv7ebeh
  .ovpn files  http://www.vpnbook.com/free-openvpn-account/VPNBook.com-OpenVPN-Euro1.zip

getusvpn (http://www.getusvpn.com/)

Notes:
After download OpenVPN Cliente on W7, run link (desktop) as Administrator.


References:

[1]  top 5 http://www.zeropaid.com/news/94826/top-5-free-vpn-services/
[2] http://www.tuvpn.com/es/tutoriales/openvpn-en-windows7#step-0
[3] Setting openvpn - ES https://hide.me/es/vpnsetup/ubuntu/openvpn/

Planes Internet Perú

Movistar
www.movistar.com.pe/negocio/internet-seguridad/internet-empresarial
www.movistar.com.pe/hogar/internet/solo-internet

Claro
www.claro.com.pe/negocios/fijos/adicionales/direcciones-ip-publicas/

Linux Fedora: Información de Hardware

En Windows, basta con instalar Everst, pero en Linux debemos seguir los siguientes pasos:

Paso 1: #yum install lshw lshw-gui

Paso 1: #yum install lshw lshw-gtk


Paso 2: #lshw


Otra forma es compilando desde el código fuente, asi :

Paso 1:#wget http://ezix.org/software/files/lshw-B.02.12.01.tar.gz
Paso 2:#tar -xvfz lshw-release.tar.gz
Paso 3:#cd lshw-B.02.12.01/src
Paso 4:#make
Paso 5:#lshw

make gui , para instalar interfaz gráfica


CONSTRUIR RPM package:

#rpmbuild -ta lshw-release.tar.gz
#rpmbuild -ta --with gui lshw-release.tar.gz

Linux Mono C#

$mono-csc searchmono.cs /out:seachmono -r:/usr/lib/mono/4.5/System.Web.dll

Compiling with mySql connector library
$mono-csc mysqlmono.cs /out:mysqlmono -r:System.Data.dll -r:/path/.nuget/packages/mysql.data/8.0.13/lib/net452/MySql.Data.dll


References:
[1] Example https://www.codeproject.com/Articles/9407/Introduction-to-Mono-Your-first-Mono-app
[2] Converter tools
     http://converter.telerik.com/
     https://codeconverter.icsharpcode.net/
     https://www.carlosag.net/tools/codetranslator/
[3] Mysql Connection https://www.mono-project.com/docs/database-access/providers/mysql/

Onde comprar no Brasil

Lojas online

[1] www.casasbahia.com.br
[2] www.extra.com.br
[3] www.americanas.com.br
[4] Notebook Accesories www.bringit.com.br
[5] www.kalunga.com.br
[6] Best Monitor prices than Notebook www.kabum.com.br
[7] Motos www.webmotors.com.br

Lojas remate
[1] www.saldaodainformatica.com.br

Ubuntu Services

sudo service --status-all


https://askubuntu.com/questions/912216/16-04-command-to-list-all-services-started-on-boot/912218

Linux small distro

Damn Small Project (bad)
Lubuntu 
Linux Lite (based on Ubuntu/Testing)
Tiny Core (Testing), works for Raspberry Pi
  Download:
  Installation GUI:
 

 $tce-load -wi Xvesa.tcz Xlibs.tcz Xprogs.tcz aterm.tcz flwm_topside.tcz wbar.tcz

 $tce-load -wi Xorg-7.7 #if Xvesa not found 

References:
[1] List of popular distros https://itsfoss.com/lightweight-linux-beginners/
[2] Comparison https://en.wikipedia.org/wiki/Light-weight_Linux_distribution
[3] Tiny Core installation https://iotbytes.wordpress.com/install-microcore-tiny-linux-on-local-disk/
[4] Tiny Core Packages http://distro.ibiblio.org/tinycorelinux/7.x/x86/tcz/
[5] Tiny Core Addin desktop http://wiki.tinycorelinux.net/wiki:adding_a_desktop_to_microcore
[6] WBar http://lxlinux.com/wbar.html

Ancho de Banda / Bandwidth Meter

Referencias
[1] www.speedtest.net
[2] http://openspeedtest.com
[3] https://www.meter.net

Ubuntu 16 - Setting PDF Printer

List of printers installed
$ls /etc/cups/ppd

Manually
Device URI:cups-pdf:/

By Command Line (Partial tested)

lpadmin -h localhost -p cups-pdf -v cups-pdf:/ -P /usr/share/cups/model/CUPS-PDF.ppd -E

Setting file (output/destination)
/etc/cups/cups-pdf.conf

Status Idle - File "/usr/lib/cups/backend/cups-pdf" has insecure permissions

$chmod 700 /usr/lib/cups/backend/cups-pdf

Null Printer
Device URI: file:/dev/null


References:
[1] Complete info https://en.opensuse.org/SDB:Printing_to_PDF

[2] openSUSE compile cups-pdf and ppd file https://pawn.physik.uni-wuerzburg.de/~vrbehr/cups-pdf/documentation.shtml
[3] CUPS PDF-WRITER Backend on Suse https://www.novell.com/coolsolutions/feature/17636.html

[4] Fake printer https://superuser.com/questions/304670/how-to-add-a-fake-dummy-null-printer-in-cups
[5] Install cups-pdf http://www.debianadmin.com/howto-install-and-customize-cups-pdf-in-debian.html

Fedora 29 Network Settings

References:
[1] https://alchemist.digital/articles/configure-a-static-ip-address-on-fedora-24-25/

Fedora 29 firewalld settings

$sudo service firewalld start 

$sudo firewall-cmd --list-all

$sudo firewall-cmd --get-zones

$sudo sudo firewall-cmd --zone=home --list-all

$sudo firewall-cmd --get-default-zone

$sudo firewall-cmd --get-active-zones

$sudo firewall-cmd --add-port=8081/tcp --permanent 
$sudo firewall-cmd --add-port=8081/udp --permanent 

$sudo firewall-cmd --reload  #important in Fedora 23 (VPS)
 
 
 
References:
[1] firewall-cmd https://docs.fedoraproject.org/en-US/Fedora/19/html/Security_Guide/sec-Open_Ports_in_the_firewall-CLI.html
[2] other firewall-cmd https://www.hiroom2.com/2017/07/12/fedora-26-firewalld-en/
[3] zones https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-using-firewalld-on-centos-7

Fedora - mySQL restoring root

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

#service mysqld stop // id doesn't stop run #mysqladmin -u root -p shutdown

#mysqld_safe --skip-grant-tables &

#mysql -u root 

> use mysql;

> update user set password=PASSWORD("mynewpassword") where User='root';

> flush privileges;

> quit

#service mysqld stop 

#service mysqld start &

if mysqld_safe not exist (updated 2019)
# systemctl stop mysqld
# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
# systemctl start mysqld
$ mysql -u root
get temporaly password (updated 2019)

$sudo grep 'temporary password' /var/log/mysqld.log

A temporary password is generated for root@localhost: cvcvcv 

$mysql -u root -p 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; 

https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
reference:
http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password

Ubuntu 18 add Samba

References:
[1] https://websiteforstudents.com/samba-setup-on-ubuntu-16-04-17-10-18-04-with-windows-systems/

Monitor network bandwidth on Linux server

References:
[1] https://www.binarytides.com/linux-commands-monitor-network/

Ubuntu Memory type ddr2 ddr3

$ sudo dmidecode --type 17

$ sudo lshw -short -C memory
 
From [1]

DDR1: 2.5 V, 133–200 MHz
DDR2: 200–400 MHz
DDR3: 1.5 V, 400–800 MHz (up to 1400 MHz for super-high-end)
DDR4: 1.2 V, 2133–4266 MHz

For example: if shows up in lshw -short -C memory as simply 16GiB DIMM Synchronous 2133 MHz (0.5 ns). The MHz rating indicates that it's almost certainly DDR4.

References:
[1] memory types http://en.wikipedia.org/wiki/Synchronous_dynamic_random-access_memory#Generations_of_SDRAM
[2]

Ubuntu upgrade from i386 to x86_64

https://askubuntu.com/questions/5018/is-it-possible-to-upgrade-from-a-32bit-to-a-64bit-installation

Mono ASP.NET MVC

References
[1] http://www.developerslearnit.com/2016/11/build-master-details-crud-in-aspnet-mvc.html
[2] 

Search old pages, Archive of webpages

[1] https://web.archive.org
      for example compelligence.com
                          grpiaa.inf.pucp.edu.pe

Tensor resources

References:
 [1] Tensor decomposition https://www.slideshare.net/panisson/tensor-decomposition-with-python
 [2] Tensores (sp) http://bibing.us.es/proyectos/abreproy/12082/fichero/Cap%C3%ADtulo3.pdf

Ubuntu 16 OpenCV 2.4

Problems during compilation:

relocation R_X86_64_32 against `ff_a64_muxer' can not be used when making a shared object

Solution:
recompile ffmpeg-3.4.5 with(2018-11-29):
./configure --enable-nonfree --enable-pic --enable-shared

Download ffmpeg and build 3.4.5, 3.2.12 or 4.0 and try to compile opencv doesn't help, then

Final solution: disable ffmpeg
$cmake  -D WITH_CUDA=OFF -D WITH_FFMPEG=0 ..
$make

That compile opencv 2.4.x and 3.4.x



References:
[1] Error sys/videoio.h not found problem http://yutopapa.hatenadiary.com/entry/2017/06/08/173149

ASP.NET MVC Mono

Settings at 11/2018

.Net Framework 4.5.2 using project properties
Mysql.Data.Entity using NuGet(6.10.8)

Setup Web.config

<!--Added--> 
<configSections> <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.2.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections> 
<connectionStrings> 
  <add name="ferredb" connectionString="server=127.0.0.1;Port=3306;Database=ferre;Uid=root;Pwd=Microsoft;" providerName="MySql.Data.MySqlClient"/> </connectionStrings> 
<!--Added--> 
<entityFramework> 
<providers> 
  <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.10.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d">
  </provider> 
</providers> 
</entityFramework> 
<!--Added--> 
<system.data> 
<DbProviderFactories> <remove invariant="MySql.Data.MySqlClient" /> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.10.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/> 
 </DbProviderFactories> 
</system.data>

Fix version of entry System.Web.Mvc.MvcWebRazorHostFactory at views/Web.config


Classes

//Ado
using System;
using System.Data.Entity;
using MySQLEntity.Models;

namespace MySQLEntity.Entity
{

public class MyDb : DbContext
{
public MyDb() : base("ferredb")
//public MyDb() : base(nameOrConnectionString: "ferredb")
{
}
public DbSet<Usuario> Usuarios { get; set; }
}

}

//Entity
using System;
//Added
using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;


namespace MySQLEntity.Models
{
        [Table("Users")]
        public class Usuario
        {
            [Key]
            public string usuario { get; set; }
            public string apenom  { get; set; }
        }

}



Controller Snippet code

public ActionResult Index()
{
  MyDb db = new MyDb();
  var Model=db.Usuarios.ToList();
  return View(Model);
}
View Snippet code

@foreach (var item in Model)
{

<div> @item.usuario @item.apenom </div>

}

Action results

References:
[1] MySQL EntityFramework web.config https://iyalovoi.wordpress.com/2015/04/06/entity-framework-with-mysql-on-mac-os/
[2] Action results
https://www.c-sharpcorner.com/article/different-types-of-action-results-in-asp-net-mvc/
[3] ViewBag better than DataView http://www.tutorialsteacher.com/mvc/viewbag-in-asp.net-mvc

mySQL Develop Optimization

Select * from MOVPRO where fecmov>='2018-11-25' and tipmov='S'
EXPLAIN Select * from MOVPRO where fecmov>='2018-11-25' and tipmov='S'

CREATE INDEX MOVPRO_fecmov_tipmov_index ON MOVPRO (fecmov,tipmov)


References:
[1] faster using indexes https://blog.nodeswat.com/making-slow-queries-fast-with-composite-indexes-in-mysql-eb452a8d6e46

python3 using mysql connection

$pip3 install mysql-connector-python --user

from mysql.connector import (connection)


cnx=connection.MySQLConnection(user='user', password='*******',
             host='ip', database='db')

cnx.close()


Resources:
[1] https://dev.mysql.com/doc/connector-python/en/connector-python-installation.html

API Testing

References
[1] postman https://steelkiwi.com/blog/api-testing-useful-tools-postman-tutorial-and-hints/

Water Simulation

Compiling Sources:
[1] 2D SPH https://github.com/tizian/SPH-Water-Simulation
    $sudo apt-cache search sfml
    $sudo apt-get install libsfml-dev
    #change for's
    $make
    $./sph

[2] WebGL water simulation https://experiments.withgoogle.com/webgl-water-simulation

[3] Google webgl https://experiments.withgoogle.com/search?q=fluid
  [3.1] http://david.li/fluid/
  [3.2] http://madebyevan.com/webgl-water/
[4] 3D Simulation/Animation/Fluids and more https://www.fetchcfd.com/search-projects/type/cfd

Related:
[1] Stanford su2 https://su2code.github.io/
[2] Multiple Interacting Fluids https://www.yiningkarlli.com/projects/multifluid.html

São Carlos to Guarulhos

1) Expensive alternative

São Carlos - SP to Rodoviária Tietê, São Paulo - SP  66.53R
https://passagemcometa.com.br

São Carlos - SP to Rodoviária Tietê, São Paulo - SP  66.55R
http://www.empresacruz.com.br

São Paulo - Tietê - SP to Aeroporto de Guarulhos      37.00R
http://www.airportbusservice.com.br/

2) Cheap alternative


São Carlos - SP to Campinas - SP                               40.53R
https://passagemcometa.com.br


São Carlos - SP to Campinas - SP                               40.55R
http://www.empresacruz.com.br

Campinas-SP to Aeroporto de Guarulhos-SP             42.75R
https://www.buscaonibus.com.br

English Tools

English test - Duolingo

[1] https://englishtest.duolingo.com/applicants

Lessons
  [1] https://webapps.towson.edu/ows/activepass.htm

e-Books
[1] http://www.kosstu.kz/static/uploads/library/gumanitar/english/g-e-91.pdf
     http://www.kosstu.kz/static/uploads/library/gumanitar/english/
[2] English Grammar In Use for Raymond Murphy. https://golammartoza.files.wordpress.com/2016/02/english-grammar-in-use-intermediate001.pdf


Online grammar
[1] http://www.gingersoftware.com/grammarcheck
[2] http://www.grammarcheck.net/editor/

Aditional helps

[1] https://www.websiteplanet.com/blog/talking-aloud-talking-allowed-watch-write-make-sure-right/

[2] For Presentation
  [2.1] Presentation Skills for Scientists

Physics resources

Physic Courses
[1] Cursos de Graduação em Engenharia do ITA http://www.ief.ita.br/~rrpela/

Foreings guide - Guia para extranjeros - Brasil

References:
[1] En http://portal.mj.gov.br/EstrangeiroWEB/guia_eng.pdf
[2] Sp http://portal.mj.gov.br/EstrangeiroWEB/guia_esp.pdf

Filtering

References:
[1] http://cattedraledigitale.isti.cnr.it
      2012 Bilateral filters https://onlinelibrary.wiley.com/doi/full/10.1111/j.1467-8659.2011.02078.x

[2] http://files.is.tue.mpg.de/pgehler/assets/publications/jampani16learning/jampani16learning.pdf
[3] https://zapdf.com/fast-high-dimensional-filtering-using-clustering.html


[6] http://www.inf.ufrgs.br/~oliveira/students_dissertations/PhD/Eduardo_Gastal_PhD_Dissertation.pdf
[7] https://is.tuebingen.mpg.de/uploads_file/attachment/attachment/259/0766_cameraready.pdf
[8] http://www.scitepress.org/Papers/2016/57151/57151.pdf
[9] http://vision.ai.illinois.edu/publications/yangijcv2015.pdf
http://openaccess.thecvf.com/content_cvpr_2018/papers/Wu_Fast_End-to-End_Trainable_CVPR_2018_paper.pdf
http://perso.ensta-paristech.fr/~manzaner/Publis/icpr10.pdf
http://www.cs.cityu.edu.hk/~rynson/papers/tcsvt16a.pdf
https://arxiv.org/pdf/1505.00077.pdf
https://fukushima.web.nitech.ac.jp/paper/2016_visapp_fujita.pdf
http://www.riken.jp/brict/Yoshizawa/Papers/cgf09yby.pdf

High-dimensional integration without Markov chains, Alexander gray
https://www.cs.ubc.ca/~nando/nipsfast/slides/high.pdf

Fast edge-preserving/-aware high dimensional filters for image & video processing https://www.slideshare.net/yuhuang/fast-edge-preservingaware-high-dimensional-filters-for-image-video-processing

 

Aditional
[1] Parallel methods for Numeric Analysis http://adl.stanford.edu/cme342/Home.html
[2] Fast Multipole Methods https://www.math.uci.edu/~chenlong/MathPKU/FMMsimple.pdf

Resources
[1] ImageStack https://code.google.com/archive/p/imagestack/
                          https://github.com/abadams/imagestack
[2] RGBD Utils, use ImageStack https://github.com/s-gupta/rgbdutils

[3] Recursive bilateral filtering  https://github.com/ufoym/RecursiveBF
    ./rbf girl_out.bmp girl.bmp 0.1 0.04
    file https://media.macphun.com/img/uploads/uploads/macphun/noiseless/nl_slider_1_b.jpg
[4] Bilateral grid http://groups.csail.mit.edu/graphics/bilagrid/
[5] Bilateral upsampling http://people.csail.mit.edu/jiawen/

Python tools
[1] ndimage 3D convolution https://docs.scipy.org/doc/scipy-0.16.0/reference/ndimage.html

video face fake

Resources:
[1] Original article (pt) https://medium.com/ensina-ai/deep-fakes-ao-vivo-que-tal-entrar-em-uma-video-confer%C3%AAncia-com-o-rosto-de-outra-pessoa-92fc8c2d5726

[2] source code using docker https://github.com/alew3/faceit_live

opengl compile error

Compiling Collisions, quadtrees, uniform grid.

https://github.com/MarcusMathiassen/P2D

$g++ Circle.cpp getTime64.cpp Process.cpp Utility.cpp Color.cpp      hwinfo.cpp Inputs.cpp Quadtree.cpp  Vec2.cpp Config.cpp main.cpp Rect.cpp FixedGrid.cpp Node.cpp Render.cpp -I ../include/  -lGL -lglut -lGLU -lGLEW -lpthread -lX11 -lglfw  -o q5


error while loading shared libraries: libGLEW.so.2.1: cannot open shared object file: No such file or directory

$sudo apt-get install libglew-dev
$locate libGLEW.so.2.1
...
/usr/lib64/libGLEW.so.2.1.0
/usr/local/lib/libGLEW.so.2.1
/usr/local/lib/libGLEW.so.2.1.0
...
...

sudo vi /etc/ld.so.conf.d/glew.conf
/usr/local/lib

$sudo ldconfig

Resources:
[1] https://sourceforge.net/projects/glew/files/glew/snapshots/

Delaunay Resources

Delaunay
[1] http://www.cs.uu.nl/docs/vakken/ga/slides9alt.pdf
[1.1] Geometric Algorithms
       http://www.cs.uu.nl/docs/vakken/ga/


[2] Geometric modeling codes* http://jeffe.cs.illinois.edu/compgeom/code.html
[3] Hexahedral mesh https://www.hextreme.eu/download/
[4] Delaunay 3D https://github.com/ashwin/gDel3D
[5] Delaunay 3D https://github.com/ashwin/gStar4D
[6] Delaunay 2D/3D https://github.com/mikolalysenko/delaunay-triangulate
[7] D3D for C++ http://www.geom.at/fade3d/html/

C++ code visualizer

Resources:
[1] http://pythontutor.com/cpp.html, example https://goo.gl/JhKhnq

3D Models & tools

1) Open .obj 3D format

view3dscene
$sudo apt-get install view3dscene

meshlab - System for processing and editing triangular meshes
$sudo apt-get install meshlab

g3dviewer
$sudo apt-get install  g3dviewer

Other tools

1. glc_player which is said to read-and-show '.3ds', '.obj', '.stl', '.off', '.3dxml', and Collada ('.dae') files
2. g3dviewer which is said to read-and-show '.3ds', '.lwo', '.obj', '.dxf', '.md2', '.md3', '.wrl', '.vrml', '.dae' (COLLADA), '.ase' (ASCII Scene Exporter), '.ac' (AC3D)
3. ivview which reads-and-shows '.iv' and VRML1 files
4. paraview which reads-and-shows '.ply' and '.vt*' files
5. varicad-view which reads-and-shows '.dwg' (2D), '.dxf' (2D only?), '.igs' (maybe?), '.stp' (3D) files 
6. wings3d - Nendo-inspired 3D polygon mesh modeller (legacy)
7. gmsh - Three-dimensional finite element mesh generator
8. libadmesh-dev - Tool for processing triangulated solid meshes.
9. libgmsh-dev - Three-dimensional finite element mesh generator.
10. libmadlib-dev - mesh adaptation library
11. libnglib-dev - Automatic 3d tetrahedral mesh generator development files
12. libscotch-dev - programs and libraries for graph, mesh and hypergraph partitioning
13. netgen - Automatic 3d tetrahedral mesh generator
14. libtriangle-dev - High-quality 2-D mesh generator development files

Resources
 [1] mview http://mview.sourceforge.net/

Models
  [1] .max, .obj, blender, etc. www.turbosquid.com
  [1] http://tf3dm.com/

Python extending functions from C/C++

References
[1] https://docs.python.org/3/library/ctypes.html

https://cython.readthedocs.io/en/latest/src/tutorial/cython_tutorial.html
https://opensourceforu.com/2010/05/extending-python-via-shared-libraries/
https://en.wikibooks.org/wiki/Python_Programming/Extending_with_C%2B%2B

Linear Regresion

[1] Regresion linear http://onlinestatbook.com/2/regression/intro.html
[2] https://towardsdatascience.com/linear-regression-with-example-8daf6205bd49

Z Stack Resources

Resources
[1] Head images   http://bids.neuroimaging.io/

pip3 ImportError: cannot import name 'main'

In linux you need to change the file: /usr/bin/pip3 from:

from pip import main
if __name__ == '__main__':
    sys.exit(main())

to:

from pip import __main__
if __name__ == '__main__':
    sys.exit(__main__._main())

 

 

c++ realloc references

https://en.cppreference.com/w/c/memory/realloc
https://www.tutorialspoint.com/c_standard_library/c_function_realloc.htm

quadtree

References:
[1] http://www.lcad.icmc.usp.br/~jbatista/procimg/quadtree_neighbours.pdf
[2] http://homepage.divms.uiowa.edu/~kvaradar/sp2012/daa/ann.pdf
[3] http://web.archive.org/web/20120907211934/http://ww1.ucmss.com/books/LFS/CSREA2006/MSV4517.pdf
[3] operations cost https://arxiv.org/pdf/1712.05591.pdf
Resources:

[1] quadtree neighbors https://bl.ocks.org/mbostock/4343214
[2] neighbors https://gist.github.com/patricksurry/6478178
[3] neighbors https://github.com/geidav/quadtree-neighbor-finding/blob/master/neighbors.py
[4] https://geidav.wordpress.com/2017/12/02/advanced-octrees-4-finding-neighbor-nodes/
[5] for check https://github.com/xoolive/quadtree

[6] gaussian kd-tree https://www.cg.tuwien.ac.at/courses/Visualisierung2/HallOfFame/2012/7-Labschuetz/Homepage/index.html#References
[7] quadtree over CUDA source code http://ecee.colorado.edu/~siewerts/extra/code/example_code_archive/a490dmis_code/CUDA/cuda_work/samples/Samples.html

Linux: mount folder to different folders

Code:

mount -o bind /media/disk1/pictures /home/user1/pictures
mount -o bind /media/disk1/pictures /home/user2/pictures

for add a fstab entry to auto-mount at startup.

Code:

/media/disk1/pictures /home/add1cker/pictures none defaults,bind 0 0

OpenGL Tutorial

 Common libs for start

$sudo apt-get install freeglut3-dev

Matrix Class [3]

Error:
_dl_check_map_versions: Assertion `needed != ((void *)0)' failed!

Fixed using -lpthread parameter [2].


References:


[1] https://www.opengl.org/wiki/Programming_OpenGL_in_Linux:_GLX_and_Xlib

[2]  http://stackoverflow.com/questions/20007961/error-running-a-compiled-c-file-uses-opengl-error-inconsistency-detected
[3] http://www.songho.ca/opengl/index.html
     http://www.songho.ca/opengl/gl_matrix.html#example1
[4] Image Libraries
      https://www.opengl.org/wiki/Image_Libraries
[5] SFML
      http://www.sfml-dev.org/tutorials/2.3/start-linux.php

git commands

References:
[1] https://git-scm.com/book/en/v2/Git-Branching-Basic-Branching-and-Merging

Raspberry pi 3

1) user and passwords:

Distribution   | Username   | Password
---------------|------------|-------------
Debian Squeeze | pi         | raspberry
Arch           | root       | root
QtonPi         | root       | rootme
Raspbian       | pi         | raspberry
OpenElec       | root       | openelec
Pidora         | root       | raspberrypi
RISC OS        | n/a        | n/a
raspbmc        | pi         | raspberry

2) add users

$sudo adduser username

$usermod -aG sudo username

3) Ports

$lsof -nP -i | grep LISTEN
$netstat -tlpn | grep LISTEN
 

4) vncserver (reinstall, by default sometime doesn't works)

$sudo apt-get install tightvncserver 

5) Firewalls

iptables -I INPUT -p tcp --dport 5900 -j ACCEPT
iptables -I INPUT -p tcp --dport 5901 -j ACCEPT

Resources:

[1] https://www.digitalocean.com/community/tutorials/how-to-create-a-sudo-user-on-ubuntu-quickstart

[2] direct way https://www.shellhacks.com/how-to-grant-root-access-user-root-privileges-linux/

[3] vncserver https://quaintproject.wordpress.com/2013/03/24/establish-a-vnc-connection-to-your-raspberry-pi-from-a-linux-pc/

smoothing

References:

[1] smoothing python https://matthew-brett.github.io/teaching/smoothing_intro.html

Optimize code C/C++

If you are using linux: use getchar_unlocked() and putchar_unlocked() for taking fast single character I/O.
In Windows the equivalent is getchar() and puchar() repectively


Resources:
[1] fast input/output https://ideone.com/BrsDz4


Enteprise solutions:
[1] http://www.fastformat.org/

Computational Resources

Resources:
[1] Computational Biophysics Software http://www.ks.uiuc.edu/Research/vmd/vmd-1.9.1/

Programming online C++ and others

Online programming tools

Resources:
[1] C++, Python  https://repl.it/@melhorum


[2] Multi Language Support https://code.dcoder.tech/

[3] Account for C/C++, C#, Java  http://rextester.com
[4] http://www.onlinegdb.com/

Store on EEUU for Buy

Stores:
[1] https://www.shipito.com/pt/shipito-pricing

Python 2.7 pip

Resolving error on python 2.7 using pip: ImportError: No module named _internal

$wget https://pypi.python.org/packages/e7/a8/7556133689add8d1a54c0b14aeff0acb03c64707ce100ecd53934da1aa13/pip-8.1.2.tar.gz
$tar -xzvf pip-8.1.2.tar.gz
$cd pip-8.1.2
$sudo python setup.py install

Lectures

https://arxiv.org/pdf/1803.04189.pdf

OpenCV 2.4.9 and 3.4.1 Compiling

2.4.x

CUDA_nppi_LIBRARY  CUDA 7.5 -> 8.0 (was removed)
  -D WITH_CUDA=OFF ..

c++ 6 fatal error: stdlib.h: No such file or directory

 export CC=path_of_gcc/gcc-version
 export CXX=path_of_g++/g++-version
 cmake  path_of_project_contain_CMakeList.txt
 make 

OR

 #Current version is 6, but we need to compile using another version (installed for sure)

$CC="gcc-4.9" CXX="g++-4.9" cmake /CMakeLists.txt 

OR$cmake -G "Unix Makefiles" -DCMAKE_CXX_COMPILER=/usr/bin/g++ CMAKE_C_COMPILER=/usr/bin/gcc -DCMAKE_BUILD_TYPE=RELEASE -DCMAKE_INSTALL_PREFIX=/usr/local -DWITH_TBB=ON -DBUILD_NEW_PYTHON_SUPPORT=ON -DWITH_V4L=ON -DINSTALL_C_EXAMPLES=ON -DINSTALL_PYTHON_EXAMPLES=ON -DBUILD_EXAMPLES=ON -DWITH_QT=ON -DWITH_OPENGL=ON -DBUILD_FAT_JAVA_LIB=ON -DINSTALL_TO_MANGLED_PATHS=ON -DINSTALL_CREATE_DISTRIB=ON -DINSTALL_TESTS=ON -DENABLE_FAST_MATH=ON -DWITH_IMAGEIO=ON -DBUILD_SHARED_LIBS=OFF -DWITH_GSTREAMER=ON -DWITH_OPENMP=OFF -DWITH_CUDA=OFF -DBUILD_opencv_gpu=OFF ..

3.4.x

Unknown CMake command "ocv_append_source_files_cxx_compiler_options".

This happened when the opencv_contrib version is no compatible with your current version.

cmake -D CMAKE_BUILD_TYPE=RELEASE -D CMAKE_INSTALL_PREFIX=/usr/local -D WITH_TBB=ON -D BUILD_NEW_PYTHON_SUPPORT=ON -D WITH_V4L=ON -D INSTALL_C_EXAMPLES=ON -D INSTALL_PYTHON_EXAMPLES=ON -D BUILD_EXAMPLES=ON -D WITH_QT=ON -D WITH_OPENGL=ON -D OPENCV_EXTRA_MODULES_PATH=../../opencv_contrib/modules/ ..


$make
$sudo make install
$sudo ldconfig

After installation, if doesn't compile, check the files opencv.conf and opencv.pc:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
#/etc/ld.so.conf.d/opencv.conf
/usr/local/lib
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
#/usr/local/lib/pkgconfig/opencv.pc

prefix=/usr/local
exec_prefix=${prefix}
libdir=${exec_prefix}/lib
includedir_old=${prefix}/include/opencv
includedir_new=${prefix}/include

Name: OpenCV
Description: Open Source Computer Vision Library
Version: 2.4.13.6
Libs: -L${exec_prefix}/lib -lopencv_contrib -lopencv_legacy -lopencv_stitching -lopencv_nonfree -lopencv_superres -lopencv_ocl -lopencv_objdetect -lopencv_ml -lopencv_ts -lopencv_videostab -lopencv_video -lopencv_photo -lopencv_calib3d -lopencv_features2d -lopencv_highgui -lopencv_imgproc -lopencv_flann -lopencv_core -L/usr/lib/x86_64-linux-gnu -lIlmThread -lHalf -lIex -lIlmImf -lImath -ljasper -ltiff -lpng -ljpeg -lavutil -lswscale -lswresample -lavcodec -lz -llzma -lxcb-shape -lxcb-render -lxcb-xfixes -lxcb-shm -lxcb -lavformat -lv4l2 -lv4l1 -ldc1394 -lGL -lGLU -latomic -ltbb -lrt -lpthread -lm -ldl -lstdc++
Cflags: -I${includedir_old} -I${includedir_new}

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


Resources:

[1] opencv github (choice right branch) https://github.com/opencv/opencv

[1] opencv_contrib is just from 3.0 .. https://github.com/opencv/opencv_contrib/releases
[2] Steps for install () http://karytech.blogspot.com/2012/05/opencv-24-on-ubuntu-1204.html
[3] Script for install under ubuntu16 https://gist.github.com/fortunto2/20a9696c7fc23ef18f8cfc50e371fe5f
[4] Some variables http://daveaubin.com/index.php/how-to-build-and-install-opencv-2-4-9-on-raspberry-pi/

Signal Processing - Sound Processing

 Resources:
[1] Course and Tutorial https://github.com/AllenDowney/ThinkDSP

Fluid Simulation: Lectures and Resources

CAELinux LiveDVD in your computer to turn it into a free and open engineering development workstation with CAD, CAM, CAE / FEA / CFD, electronic design and 3D printing  features: no licence and even no installation is required ! [2]


Resources:
[1] Laboratory http://lgg.epfl.ch/research_physicsbased_animation.php
[2] CFD Linux distro https://caelinux.com/CMS3/

Courses:
[1] Khan https://pt.khanacademy.org/partner-content/pixar/effects/particle/p/water-simulation

Compiling tris2indicator on Linux Ubuntu 16

change code from MapViewOfFile (Windows) to mmap (Linux) on read_obj.cpp and write_grid.cpp.

$g++ read_obj.cpp vect.cpp global.cpp insert_poly.cpp write_grid.cpp timer.cpp main.cpp -lpthread -lm -o tris2indicator



source code:
[1] http://josiahmanson.com/research/wavelet_rasterization/

Mapping files into memory

• CreateFile(); or OpenFile();
• CreateFileMapping();
• MapViewOfFile();
  

mmap() combines the functions of CreateFileMapping() and MapViewOfFile()

References
[1] https://stackoverflow.com/questions/8391094/equivalent-win-api-in-nix
[2] http://pubs.opengroup.org/onlinepubs/9699919799/functions/mmap.html
[3] mmap example https://gist.github.com/marcetcheverry/991042

AI Courses and Resources

Resources:

 [1] Berkeley course http://ai.berkeley.edu
 [2] Minimax algorithm https://www.geeksforgeeks.org/minimax-algorithm-in-game-theory-set-3-tic-tac-toe-ai-finding-optimal-move/
 [3] Alfa Beta Prunning https://www.geeksforgeeks.org/minimax-algorithm-in-game-theory-set-4-alpha-beta-pruning/

 [4] Full Course, Search slides https://courses.cs.washington.edu/courses/cse473/14au/slides/

Qt Project to MakeFile

qmake -spec macx-g++ x.pro on Mac OS X to generate Makefile
qmake x.pro on linux to generate Makefile (default behaviour)
qmake -spec win32-g++ x.pro on Windows to generate Makefile

References:
[1] https://stackoverflow.com/questions/8571687/how-to-get-a-makefile-from-qmake

Fluid SImulaton Source codes

Compile OceanSurface under Ubuntu 16 [2]
* Install dependences
libglm-dev
libglfw3-dev
libsoil-dev

$g++ -o OceanSurface main.cpp wave.cpp Record.cpp -lGL -lglfw -lGLEW -lfftw3 -lfftw3f -lSOIL


Resources:
[1] splishsplash http://melhorum.blogspot.com.br/2018/05/compile-splishsplash.html
[2] https://github.com/JiashuoLi/OceanSurface
[3] https://ttnghia.github.io/

Ubuntu 16 Setting Screen Samsung SyncMaster T240M

$cvt 1600 1000 #get right values for this resolution
$gtf 1600 1000 60 #alternative


# 1600x1000 59.87 Hz (CVT 1.60MA) hsync: 62.15 kHz; pclk: 132.25 MHz
Modeline "1600x1000_60.00" 132.25 1600 1696 1864 2128 1000 1003 1009 1038 -hsync +vsync
 
$ sudo xrandr --newmode "1600x1000" 132.25 1600 1696 1864 2128 1000 1003 1009 1038 -hsync +vsync  #define

$ sudo xrandr --addmode DVI-I-1 "1600x1000" #register on system

$ xrandr
Screen 0: minimum 320 x 200, current 1600 x 900, maximum 16384 x 16384
DVI-I-1 connected primary 1600x900+0+0 (normal left inverted right x axis y axis) 518mm x 324mm
1920x1200 59.95 +
1600x1200 60.00
1280x1024 75.02 60.02
1280x960 60.00
1152x864 75.00
1024x768 75.08 70.07 60.00
832x624 74.55
800x600 72.19 75.00 60.32 56.25
640x480 75.00 72.81 66.67 60.00
720x400 70.08
1600x900 59.95*
1600x1000 59.87
DVI-I-2 disconnected (normal left inverted right x axis y axis)
HDMI-1 disconnected (normal left inverted right x axis y axis)
1600x900_60.00 (0x58e) 118.250MHz -HSync +VSync
h: width 1600 start 1696 end 1856 total 2112 skew 0 clock 55.99KHz
v: height 900 start 903 end 908 total 934 clock 59.95Hz

* Set permanent settings using ~/.xprofile (for example)
$vi ~/.xprofile
#
xrandr --newmode "1600x1000" 132.25 1600 1696 1864 2128 1000 1003 1009 1038 -hsync +vsync 
xrandr --addmode DVI-I-1 "1600x1000"


* Problem: After nvidia drivers installation this doesn't works (crap)



$xrandr --fb 1600x1000 #show
xrandr: specified screen 1900x1000 not large enough for output DVI-I-3 (1920x1200+0+0)
xrandr: Configure crtc 0 failed
X Error of failed request:  BadValue (integer parameter out of range for operation)
#or
X Error of failed request:  BadMatch (invalid parameter attributes)

$xrandr --output DVI-I-3 --scale 1x0.85  #this solve  after nvidia drivers installation



References:
http://ubuntuhandbook.org/index.php/2017/04/custom-screen-resolution-ubuntu-desktop/

ARM Virtual Machine resources

[1] https://www.red-lang.org/2012/03/setting-up-arm-virtual-machine.html

Nvidia and Opengl doesn't works

libGL error: No matching fbConfigs or visuals found
libGL error: failed to load driver: swrast

Prepare removing

• sudo apt-get purge nvidia* #This will remove your current nVidia drivers
• sudo apt-get install --reinstall xserver-xorg-video-intel libgl1-mesa-glx libgl1-mesa-dri xserver-xorg-core
• sudo dpkg-reconfigure xserver-xorg #This should fix Xorg
• sudo update-alternatives --remove gl_conf /usr/lib/nvidia-current/ld.so.conf

After this reïnstall nVidia software

• sudo apt-add-repository ppa:xorg-edgers/ppa #provides the necessary repository
• sudo apt-get update
• sudo apt-get install bumblebee-nvidia nvidia-319 nvidia-settings-319

voip by web

[1] 12voip https://www.12voip.com

My favorite Music

Ludwig Van Beethoven
   Symphony No. 5 in C minor ("Fate") (composed 1804–08, premièred 1808)
   Sonata N° 14 'moonlight'
   Fur Elisa
   Himno de la alegria
   Turkish March  (Adapted by Chavo del 8 program, in intro)


Wolfgang Amadeus Mozart
  Turkish March
  Réquiem

Antonio Vivaldi
  Storm
  La Stravaganza  Four Season:Spring

Johan Sebastian Bach
 Toccata and Fugue Ave maria
  Passacaglia
Frédéric Chopin
  Waltz rain
  Spring waltz (Mariage d'Amour)

Antonín Dvořák
  Symphony no. 9 - 4th movement - Allegro con fuoco

C++ equivalent to getch() and getche() from conio.h

#include <iostream>
#include <termios.h> //TCSANOW, ICANON, ..
#include <unistd.h>  //STDIN_FILENO ..
#include <stdio.h>  //getchar

using namespace std;

char getch(void)
{
  struct termios oldattr, newattr;
  char ch;
  tcgetattr( STDIN_FILENO, &oldattr );
  newattr = oldattr;
  newattr.c_lflag &= ~( ICANON | ECHO );
  tcsetattr( STDIN_FILENO, TCSANOW, &newattr );
  ch = getchar();
  tcsetattr( STDIN_FILENO, TCSANOW, &oldattr );
  return ch;
}

char getche(void) //with ECHO
{
  struct termios oldattr, newattr;
  int ch;
  tcgetattr( STDIN_FILENO, &oldattr );
  newattr = oldattr;
  newattr.c_lflag &= ~( ICANON );
  tcsetattr( STDIN_FILENO, TCSANOW, &newattr );
  ch = getchar();
  tcsetattr( STDIN_FILENO, TCSANOW, &oldattr );
  return ch;
}

int main(int argc,char *argv[])
{
  char ch1=getch();
  char ch2=getche();
  cout << "\nFirst : " << ch1
       << "\nSecond: " << ch2 << endl;
  return 0;
}
//g++ getchx.cpp -o getchx

References
[1] https://www.daniweb.com/programming/software-development/threads/410155/gcc-equivalent-for-getch

Alternatives to shazam

[1] On web https://www.midomi.com
[2] Get song name from mp3 on web  http://audiotag.info
[3] Chrome plugin https://www.aha-music.com/

Deep Learning Lectures

References:
[1] Top ten papers https://www.techleer.com/articles/517-a-list-of-top-10-deep-learning-papers-the-2018-edition/

Printable Grid and Rulers Paper

Resources:
[1] Graph Paper, ready for print over A4 http://www.grassfedjp.com/print-grid-paper/
[2] Rulers http://leversetdujour.info/ruler-to-print.html

Alternatives to Google StreeView

References:

[1] https://www.mapillary.com/
[2] https://www.topbestalternatives.com/google-street-view/

Linux Microphone doesn't working

Try to reload drivers

$sudo alsa force-reload

restart device and check if sound is workin? if it doesnt do this:

$sudo apt-get remove --purge alsa-base pulseaudio
$sudo apt-get install alsa-base pulseaudio 

References:
[1] https://askubuntu.com/questions/508221/sound-input-device-microphone-not-working

Fedora/CentOS Change ports of Apache Web Server (httpd)

1) In file /etc/httpd/conf/httpd.conf

Listen 80
Listen 8079

This till your server to listen to the port 8079

2) virtual host file  /etc/httpd/conf.d/vhost.conf

<VirtualHost *:8079>
 DocumentRoot /var/www/html/api_folder
 ServerName example.com
 ServerAlias www.example.com
 ServerAdmin root@example.com 
 ErrorLog logs/www.example.com-error_log
 CustomLog logs/www.example.com-access_log common
</VirtualHost>

This mean when you go to your www.example.com:8079 redirect to
/var/www/html/api_folder

3) Restart the service

$sudo service httpd restart
$systemctl restart httpd.service

references:
[1] https://httpd.apache.org/docs/2.4/bind.html

Call using Internet (Brasil - Perú)

https://www.poptox.com/Peru
https://www.spytox.com/whose-number-is-calling-me

Ubuntu 16 OpenCV 2.4.x disable ffmpeg and jpeg

cmake -D CMAKE_BUILD_TYPE=RELEASE -D CMAKE_INSTALL_PREFIX=/usr/local -D WITH_TBB=ON -D BUILD_NEW_PYTHON_SUPPORT=ON -D WITH_V4L=ON -D INSTALL_C_EXAMPLES=ON -D INSTALL_PYTHON_EXAMPLES=ON -D BUILD_EXAMPLES=ON -D WITH_QT=ON -D WITH_OPENGL=ON -D WITH_FFMPEG=OFF -D WITH_JPEG=OFF ..

Ubuntu webm to mp4

ffmpeg -i video.webm -movflags faststart -profile:v high -level 4.2 video.mp4

Ubuntu 16 VMWare Player


$wget -c https://download3.vmware.com/software/player/file/VMware-Player-12.5.0-4352439.x86_64.bundle
$sudo chmod u+x VMware-Player-12.5.0-4352439.x86_64.bundle
$sudo ./VMware-Player-12.5.0-4352439.x86_64.bundle

Ubuntu how to get interval time for run Application

howmuchdelay.sh

T="$(date +%s%N)"
# Do some work here
$1 $2 $3 $4 $5 #sleep 2

# Time interval in nanoseconds
T="$(($(date +%s%N)-T))"

# Seconds
S="$((T/1000000000))"

# Milliseconds
M="$((T/1000000))"

printf "Take: %02d:%02d:%02d:%02d.%03d\n" "$((S/86400))" "$((S/3600%24))" "$((S/60%60))" "$((S%60))" "${M}"

Learn Persian On Line

Resources:
[1] https://www.persianlanguageonline.com/learn/beginner/hello/
[2] http://www.persiandee.com/view/showLesson/currentLesson/1
[3] http://mylanguages.org/multimedia/farsi_audio_colors.php