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/