{"id":5769,"date":"2021-09-27T11:41:34","date_gmt":"2021-09-27T17:41:34","guid":{"rendered":"https:\/\/ugit.siua.ac.cr\/?p=5769"},"modified":"2021-09-28T11:14:38","modified_gmt":"2021-09-28T17:14:38","slug":"instalacion-sistema-asistencia-siua-ac-cr-ubuntu-20-04-server","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=5769","title":{"rendered":"Instalaci\u00f3n sistema \u00abasistencia.siua.ac.cr\u00bb ubuntu 20.04 server"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>Guia base: <a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/JeffersonHF06\/SISCOA\/tree\/UNA\" target=\"_blank\">https:\/\/github.com\/JeffersonHF06\/SISCOA\/tree\/UNA<\/a><\/li><li>Instalamos el sistema operativo y lo actualizamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt update\napt upgrade<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install apache2 git composer npm<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Clonamos el repositorio en una carpeta de nombre \u00abasistencia.siua.ac.cr\u00bb dentro de \/var\/www\/html<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>git clone https:\/\/github.com\/JeffersonHF06\/SISCOA.git asistencia.siua.ac.cr<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos al directorio<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd asistencia.siua.ac.cr\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Dependencias<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt install php php-xml php-mbstring php-mysql libapache2-mod-php7.4 php7.4<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Habillitamos el m\u00f3dulo rewrite<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>a2enmod rewrite\nsystemctl restart apache2<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ejecutamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>composer update dompdf\/dompdf\ncomposer install\nnpm install\ncp .env.example .env\nphp artisan key:generate<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos una base de datos \u00abbd_sis_asistencia_siua\u00bb<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"673\" height=\"368\" src=\"\/wp-content\/uploads\/2021\/09\/Seleccion_019.png\" alt=\"\" class=\"wp-image-5779\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2021\/09\/Seleccion_019.png 673w, https:\/\/sada.services\/wp-content\/uploads\/2021\/09\/Seleccion_019-300x164.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Abrimos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano .env<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Modificamos los datos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>DB_CONNECTION=mysql\nDB_HOST=127.0.0.1\nDB_PORT=3306\nDB_DATABASE=laravel\nDB_USERNAME=root\nDB_PASSWORD=\n\nX\nDB_CONNECTION=mysql\nDB_HOST=mysqlp.siua.ac.cr\nDB_PORT=3306\nDB_DATABASE=bd_sis_asistencia_siua\nDB_USERNAME=rm\nDB_PASSWORD=RB0\n\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Modificamos el archivo (como dio error al crear BD)<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/var\/www\/html\/asistencia.siua.ac.cr\/config\/database.php<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Modificamos en mysql<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>'charset' => 'utf8mb4',\n'collation' => 'utf8mb4_unicode_ci',\n'engine' => null,\n\nX\n'charset' => 'utf8',\n'collation' => 'utf8_general_ci',\n'engine' => 'InnoDB',<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ejecutamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>php artisan migrate\nphp artisan migrate --seed<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Publicar con apache<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Verificamos que tenemos apache corriendo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>service apache2 status<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Dentro de la carpeta del proyecto<\/li><li>Verificamos que tenemos una aplicaci\u00f3n laravel<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>php artisan --version\n\nRESULTADO\nLaravel Framework 7.30.4<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ahora podr\u00edamos ingresar al sistema por la ruta <a rel=\"noreferrer noopener\" href=\"http:\/\/10.20.200.151\/asistencia.siua.ac.cr\/public\" target=\"_blank\">http:\/\/10.20.200.151\/asistencia.siua.ac.cr\/public<\/a><\/li><li>Pero nos da error de laravel por que no tenemos permiso de escritura en la carpeta storage del proyecto<\/li><li>Le damos permiso a la carpeta storage<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod 777 -R storage\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ahora no da un nuevo error por que no encuentra las rutas de nuestro proyecto<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"627\" height=\"200\" src=\"\/wp-content\/uploads\/2021\/09\/Seleccion_020.png\" alt=\"\" class=\"wp-image-5785\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2021\/09\/Seleccion_020.png 627w, https:\/\/sada.services\/wp-content\/uploads\/2021\/09\/Seleccion_020-300x96.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Pero esto lo corregimos con los host virtuales<\/li><li>Seguimos la guia normal de letsencrypt <a rel=\"noreferrer noopener\" href=\"\/?p=1831\" target=\"_blank\">\/?p=1831<\/a><\/li><li>Y la de configuraci\u00f3n de apache <a rel=\"noreferrer noopener\" href=\"\/?p=1784\" target=\"_blank\">\/?p=1784<\/a><\/li><li>Y dentro de los host virtuales de MV de asistencia tenemos que agregar el siguiente c\u00f3digo para que nos reconozca las rutas<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;Directory \/var\/www\/html\/asistencia.siua.ac.cr\/public\/>\n           AllowOverride All\n    &lt;\/Directory><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Quedando as\u00ed el asistencia.siua.ac.cr.conf<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;VirtualHost *:80>\n\n    #************************************************************************\n    #******************* DATOS DEL SITIO WEB ********************************\n    #************************************************************************\n    ServerName asistencia.siua.ac.cr\n    ServerAlias www.asistencia.siua.ac.cr\n    ErrorLog \/var\/log\/apache2\/asistencia_80.siua.ac.cr-error.log\n    CustomLog \/var\/log\/apache2\/asistencia_80.siua.ac.cr-access.log common\n\n    #************************************************************************\n    #********************** DATOS DEL WEBMASTER *****************************\n    #************************************************************************\n    ServerAdmin interuniversitariadealajuela@gmail.com\n    Header add Author \"Unidad de Gestion e Innovacion Tecnologica\"\n\n    #************************************************************************\n    #********************* DATOS DEL REDIRECIONAMIENTO **********************\n    #************************************************************************\n    RedirectMatch permanent ^\/(.*) https:\/\/asistencia.siua.ac.cr\/$1\n\n\n    #************************************************************************\n    #************************* DATOS DEL SITIO WEB **************************\n    #************************************************************************\n    DocumentRoot \/var\/www\/html\/asistencia.siua.ac.cr\/public\/\n    &lt;Directory \/var\/www\/html\/asistencia.siua.ac.cr\/public\/>\n           AllowOverride All\n    &lt;\/Directory>\n\n&lt;\/VirtualHost>\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Y as\u00ed asistencia.siua.ac.cr-le-ssl.conf<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;IfModule mod_ssl.c>\n\n   #************************************************************************\n   #HTTPS:\/\/www.asistencia.siua.ac.cr\n   #************************************************************************\n   &lt;VirtualHost *:443>\n        ServerName www.asistencia.siua.ac.cr\n        RedirectMatch permanent ^\/(.*) https:\/\/asistencia.siua.ac.cr\/$1\n        #************************************************************************\n        #*************************** DATOS DEL CERTIFICADO **********************\n        #************************************************************************\n        SSLEngine on\n        SSLCertificateFile \/etc\/apache2\/certificados\/asistencia.siua.ac.cr\/fullchain.pem\n        SSLCertificateKeyFile \/etc\/apache2\/certificados\/asistencia.siua.ac.cr\/privkey.pem\n\n        &lt;Directory \/var\/www\/html\/asistencia.siua.ac.cr\/public\/>\n                AllowOverride All\n        &lt;\/Directory>\n\n   &lt;\/VirtualHost>\n\n   #************************************************************************\n   #HTTPS:\/\/asistencia.siua.ac.cr\n   #************************************************************************\n   &lt;VirtualHost *:443>\n\n        #************************************************************************\n        #******************* DATOS DEL SITIO WEB ********************************\n        #************************************************************************\n        ServerName asistencia.siua.ac.cr\n        ErrorLog \/var\/log\/apache2\/asistencia_443.siua.ac.cr-error.log\n        CustomLog \/var\/log\/apache2\/asistencia_443.siua.ac.cr-access.log common\n\n        #************************************************************************\n        #********************** DATOS DEL WEBMASTER *****************************\n        #************************************************************************\n        ServerAdmin interuniversitariadealajuela@gmail.com\n        Header add Author \"Unidad de Gestion e Innovacion Tecnologica\"\n\n\n        #************************************************************************\n        #************************** DATOS DEL CERTIFICADO ***********************\n        #************************************************************************\n        SSLEngine on\n        SSLCertificateFile \/etc\/apache2\/certificados\/asistencia.siua.ac.cr\/fullchain.pem\n        SSLCertificateKeyFile \/etc\/apache2\/certificados\/asistencia.siua.ac.cr\/privkey.pem\n\n        #************************************************************************\n        #************************** DATOS DEL SITIO WEB *************************\n        #************************************************************************\n        DocumentRoot \/var\/www\/html\/asistencia.siua.ac.cr\/public\/\n        &lt;Directory \/var\/www\/html\/asistencia.siua.ac.cr\/public\/>\n                AllowOverride All\n        &lt;\/Directory>\n\n  &lt;\/VirtualHost>\n&lt;\/IfModule>\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Gu\u00eda de instalaci\u00f3n del sistema de asistencia.siua.ac.cr sobre ubuntu 20.04 server.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[192],"tags":[343,193],"class_list":["post-5769","post","type-post","status-publish","format-standard","hentry","category-sistemas","tag-asistencia","tag-sistemas"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/5769","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5769"}],"version-history":[{"count":17,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/5769\/revisions"}],"predecessor-version":[{"id":5790,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/5769\/revisions\/5790"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}