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