PostgreSQL 10 + postgis

Install repository https://yum.postgresql.org/repopackages.php#pg10 yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm Listing avalble packages yum list postgis* Install proper packages (client, server, .. packages) yum install postgresql10 postgresql10-server postgresql10-contrib postgresql10-libs -y Install postgis yum install postgis25_10-utils postgis25_10 -y initialize the cluster /usr/pgsql-10/bin/postgresql-10-setup initdb enable postgres to start automatically upon reboot systemctl enable postgresql-10.service start postgres systemctl start postgresql-10.service Switch into … Sigue leyendo PostgreSQL 10 + postgis

Anuncios

Tomcat`s jvm issue

After an update tomcat does not start up. systemctl status tomcat8 -l ● tomcat8.service - Apache Tomcat Web 8.x Application Container Loaded: loaded (/etc/systemd/system/tomcat8.service; enabled; vendor preset: disabled) Active: inactive (dead) (Result: exit-code) since Wed 2018-05-16 12:26:36 CEST; 7min ago Process: 1805 ExecStop=/opt/tomcat/bin/shutdown.sh (code=exited, status=1/FAILURE) Process: 1794 ExecStart=/opt/tomcat/bin/startup.sh (code=exited, status=0/SUCCESS) Main PID: 1804 (code=exited, status=127) … Sigue leyendo Tomcat`s jvm issue

Tomcat 8.5.27 in Centos 7

Prerequisites CentOS 7 Server - 64bit 524 MB de RAM (2 GB or more RAM) Root privileges Tomcat 8.5.27 yum -y install java-1.8.0-openjdk.x86_64 java-1.8.0-openjdk-devel.x86_64 yum -y install java-1.8.0-openjdk java -versionjava -version openjdk version "1.8.0_161"OpenJDK Runtime Environment (build 1.8.0_161-b14)OpenJDK 64-Bit Server VM (build 25.161-b14, mixed mode) cd /opt/ wget http://download.oracle.com/otn-pub/java/jdk/8u161-b12/2f38c3b165be4555a1fa6e98c45e0808/jdk-8u161-linux-x64.tar.gz Check Java directory with the command … Sigue leyendo Tomcat 8.5.27 in Centos 7

Creacion usuario ftp virtual

INSTALACIÓN DEL PAQUETE proftpd yum install -y proftpd  proftpd-utils systemctl start proftpd && systemctl enable proftpd getenforce Enforcing setenforce 0 getenforce Permissive firewall-cmd --zone=public --add-service=ftp –permanent firewall-cmd --permanent --zone=public --add-port=21/tcp firewall-cmd –-reload lsof -i tcp:21 COMMAND  PID   USER   FD   TYPE DEVICE SIZE/OFF NODE NAME proftpd 5954 nobody    0u  IPv6  56981      0t0  TCP *:ftp (LISTEN) CREACIÓN … Sigue leyendo Creacion usuario ftp virtual

Actualizacion Drupal: MySQL de UTF-8 a uft8mb4

Desde hace meses cada vez que actualizo Drupal muestra un aviso de información para actualizar la base de datos para soportar UTF-8 de 4 bytes, con este mensaje: 4 byte UTF-8 for mysql is not activated, but it is supported on your system. It is recommended that you enable this to allow 4-byte UTF-8 input … Sigue leyendo Actualizacion Drupal: MySQL de UTF-8 a uft8mb4

GROUP BY

La cláusula GROUP BY se usa para generar valores de agregado para cada fila de un  conjunto de resultados, es decir, sirve para agrupar datos, según un determinado criterio, y aplicar operaciones sobre los elementos del conjunto conformado. mysql -u root -p mysql> select @@sql_mode; +-------------------------------------------------------------+ | @@sql_mode | +-------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE, | | NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,| … Sigue leyendo GROUP BY