{"id":1634,"date":"2019-09-17T09:35:44","date_gmt":"2019-09-17T15:35:44","guid":{"rendered":"https:\/\/ugit.siua.ac.cr\/?p=1634"},"modified":"2021-02-08T12:48:36","modified_gmt":"2021-02-08T18:48:36","slug":"onlyoffice-instalacion-debian-9","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=1634","title":{"rendered":"ONLYOFFICE: instalaci\u00f3n debian 10"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Instalaci\u00f3n de Mono<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Instrucciones <a href=\"https:\/\/www.mono-project.com\/download\/stable\/#download-lin-debian\">https:\/\/www.mono-project.com\/download\/stable\/#download-lin-debian<\/a><\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos dependencias<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt install apt-transport-https dirmngr gnupg ca-certificates<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Incluimos la llave<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt-key adv --keyserver hkp:\/\/keyserver.ubuntu.com:80 --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregamos el repositorio<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>echo \"deb https:\/\/download.mono-project.com\/repo\/debian stable-buster main\" | sudo tee \/etc\/apt\/sources.list.d\/mono-official-stable.list<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Actualizamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt update<\/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 mono-devel<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Instalaci\u00f3n de NGINX<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install nginx<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Instalaci\u00f3n de NODEJS<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos dependencias<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install curl<\/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>curl -sL https:\/\/deb.nodesource.com\/setup_14.x | bash -<\/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-get install -y nodejs<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install -y build-essential<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Instalaci\u00f3n de MYSQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Obtenemos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>wget repo.mysql.com\/mysql-apt-config_0.8.15-1_all.deb<\/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>dpkg -i mysql-apt-config_0.8.15-1_all.deb<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Aceptamos<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"734\" height=\"502\" src=\"\/wp-content\/uploads\/2019\/09\/a46-1.png\" alt=\"\" class=\"wp-image-1637\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a46-1.png 734w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a46-1-300x205.png 300w\" sizes=\"(max-width: 734px) 100vw, 734px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"728\" height=\"495\" src=\"\/wp-content\/uploads\/2019\/09\/a47-1.png\" alt=\"\" class=\"wp-image-1638\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a47-1.png 728w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a47-1-300x204.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Actualizamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt update <\/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 mysql-server<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Contrase\u00f1a root<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"720\" height=\"480\" src=\"\/wp-content\/uploads\/2019\/09\/a48-1.png\" alt=\"\" class=\"wp-image-1639\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a48-1.png 720w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a48-1-300x200.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a48-1-120x80.png 120w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ugit.blog.siua.ac.cr\/content\/public\/upload\/selecci\u00f3n244_0_o.png\" alt=\"undefined\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Lo configuramos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_secure_installation<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>RESULTADO<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Securing the MySQL server deployment.\n\nEnter password for user root:\n\nVALIDATE PASSWORD PLUGIN can be used to test passwords\nand improve security. It checks the strength of password\nand allows the users to set only those passwords which are\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?\n\nPress y|Y for Yes, any other key for No: y\n\nThere are three levels of password validation policy:\n\nLOW Length &gt;= 8\nMEDIUM Length &gt;= 8, numeric, mixed case, and special characters\nSTRONG Length &gt;= 8, numeric, mixed case, special characters and dictionary file\n\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1\nUsing existing password for root.\n\nEstimated strength of the password: 100\nChange the password for root ? ((Press y|Y for Yes, any other key for No) : n\n\n... skipping.\nBy default, a MySQL installation has an anonymous user,\nallowing anyone to log into MySQL without having to have\na user account created for them. This is intended only for\ntesting, and to make the installation go a bit smoother.\nYou should remove them before moving into a production\nenvironment.\n\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\n\nNormally, root should only be allowed to connect from\n'localhost'. This ensures that someone cannot guess at\nthe root password from the network.\n\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nBy default, MySQL comes with a database named 'test' that\nanyone can access. This is also intended only for testing,\nand should be removed before moving into a production\nenvironment.\n\n\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\n- Dropping test database...\nSuccess.\n\n- Removing privileges on test database...\nSuccess.\n\nReloading the privilege tables will ensure that all changes\nmade so far will take effect immediately.\n\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nAll done!<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Probamos conexi\u00f3n<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Instalar onlyoffice community server<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>LLave<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-key adv --keyserver hkp:\/\/keyserver.ubuntu.com:80 --recv-keys CB2DE8E5<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>echo \"deb http:\/\/download.onlyoffice.com\/repo\/debian squeeze main\" | tee \/etc\/apt\/sources.list.d\/onlyoffice.list<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Actualizamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get update<\/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-get install onlyoffice-communityserver<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Nos pide la contrase\u00f1a de MYSQL<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"733\" height=\"506\" src=\"\/wp-content\/uploads\/2019\/09\/a49-1.png\" alt=\"\" class=\"wp-image-1640\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a49-1.png 733w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a49-1-300x207.png 300w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos el navegador<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>http:&#47;&#47;10.20.200.48\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos los datos<\/li><li>Pas:AC2<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"487\" src=\"\/wp-content\/uploads\/2019\/09\/a50-1.png\" alt=\"\" class=\"wp-image-1641\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a50-1.png 1000w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a50-1-300x146.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a50-1-768x374.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Si nos da problemas de codificaci\u00f3n:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>locale-gen en_US en_US.UTF-8\ndpkg-reconfigure locales \nreboot\n\nmysql -u root -p\nUSE onlyoffice\nselect textValue from res_data where cultureTitle='ru' limit 1;\ndelete from res_data;\nsource \/var\/www\/onlyoffice\/Sql\/onlyoffice.resources.sql\nexit\n\n\nservice monoserve restart<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Instalar certificados<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">DNS<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregamos el dominio office.siua.ac.cr -&gt; 10.20.200.48 \/ 181.193.87.6<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">PROXY<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/apache2\/sites-available\/office.siua.ac.cr.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Contenido:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>NameVirtualHost 181.193.87.6:80\n\n&lt;VirtualHost 181.193.87.6:80&gt;\n\n#************************************************************************\n#******************* DATOS DEL SITIO WEB ********************************\n#************************************************************************\nServerName office.siua.ac.cr\nServerAlias www.office.siua.ac.cr\nErrorLog \/var\/log\/apache2\/office_80.siua.ac.cr-error.log\nCustomLog \/var\/log\/apache2\/office_80.siua.ac.cr-access.log common\n\n#************************************************************************\n#********************** DATOS DEL WEBMASTER *****************************\n#************************************************************************\nServerAdmin interuniversitariadealajuela@gmail.com\nHeader add Author \"Unidad de Gestion e Innovacion Tecnologica\"\n\n#************************************************************************\n#************************** DATOS DEL REDIRECCIONAMIENTO ****************\n#************************************************************************\n\n&lt;\/VirtualHost&gt;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Habilitamos el sitios<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>a2ensite office.siua.ac.cr.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Recargamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl reload apache2<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ejecutamos el cerbot<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>certbot --installer apache<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Editamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/apache2\/sites-available\/office.siua.ac.cr-le-ssl.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Contenido<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;IfModule mod_ssl.c&gt;\n&lt;VirtualHost 181.193.87.6:443&gt;\n\n#************************************************************************\n#******************* DATOS DEL SITIO WEB ********************************\n#************************************************************************\nServerName office.siua.ac.cr\nServerAlias www.office.siua.ac.cr\nErrorLog \/var\/log\/apache2\/office_443.siua.ac.cr-error.log\nCustomLog \/var\/log\/apache2\/office_443.siua.ac.cr-access.log common\n\n#************************************************************************\n#********************** DATOS DEL WEBMASTER *****************************\n#************************************************************************\nServerAdmin interuniversitariadealajuela@gmail.com\nHeader add Author \"Unidad de Gestion e Innovacion Tecnologica\"\n\n#************************************************************************\n#********************* DATOS DEL REDIRECCIONAMIENTO *********************\n#************************************************************************\nProxyPreserveHost On\nProxyRequests off\nSSLProxyEngine on\nProxyPass \/ https:\/\/10.20.200.48\/\nProxyPassReverse \/ https:\/\/10.20.200.48\/\n\n\n#************************************************************************\n#********************** DATOS DEL CERTIFICADO ***************************\n#************************************************************************\nInclude \/etc\/letsencrypt\/options-ssl-apache.conf\nSSLCertificateFile \/etc\/letsencrypt\/live\/office.siua.ac.cr\/fullchain.pem\nSSLCertificateKeyFile \/etc\/letsencrypt\/live\/office.siua.ac.cr\/privkey.pem\n&lt;\/VirtualHost&gt;\n&lt;\/IfModule&gt;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Recargamos apache<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl reload apache2<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ONLYOFFICE<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos la carpeta donde se guardan los certificados<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/var\/www\/onlyoffice\/Data\/certs<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Le damos permisos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod 777 -R \/var\/www\/onlyoffice\/Data\/certs<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">PROXY<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Le pasamos los certificados<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>scp -P 44 -r \/etc\/letsencrypt\/live\/office.siua.ac.cr\/privkey.pem root@10.20.200.48:\/var\/www\/onlyoffice\/Data\/certs\/privkey.pem\nscp -P 44 -r \/etc\/letsencrypt\/live\/office.siua.ac.cr\/fullchain.pem root@10.20.200.48:\/var\/www\/onlyoffice\/Data\/certs\/fullchain.pem <\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ONLYOFFICE<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Abrimos el archivo de configuraci\u00f3n:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/nginx\/sites-available\/onlyoffice<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Modificamos el servidor 80 para que diriga a 443<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>server {\n        listen 80;\n        server_name  office.siua.ac.cr;\n        rewrite ^ https:\/\/$http_host$request_uri? permanent;    # force redirect http to https\n        # Enables or disables emitting nginx version on error pages and in the \"Server\" response header field.\n        server_tokens off;\n\n}<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregamos el servidor 443<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>server {\n\n        listen 443;\n        server_name  office.siua.ac.cr;\n        server_tokens off;\n        charset utf-8;\n        ssl on;\n        ssl_certificate \/var\/www\/onlyoffice\/Data\/certs\/fullchain.pem; # managed by Certbot\n        ssl_certificate_key \/var\/www\/onlyoffice\/Data\/certs\/privkey.pem; # managed by Certbot\n\n\n        add_header Access-Control-Allow-Origin *;\n\n        large_client_header_buffers 4 16k;\n\n        set $X_REWRITER_URL $the_scheme:\/\/$the_host;\n\n        if ($http_x_rewriter_url != '') {\n                set $X_REWRITER_URL $http_x_rewriter_url ;\n        }\n\n        include \/etc\/nginx\/includes\/onlyoffice-communityserver-*.conf;\n\n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>&nbsp;Instalaci\u00f3n de Document-Server<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos dependencias<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install build-essential apt-transport-https dirmngr libstdc++6<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Instalamos NGINX<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install nginx<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Instalamos NODEJS<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos dependencias<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install curl<\/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>curl -sL https:\/\/deb.nodesource.com\/setup_10.x | bash -<\/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-get install -y nodejs<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install -y build-essential<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;Instalamos PostgreSQL<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install postgresql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Le indicamos que inicie<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl start postgresql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Vemos el estado<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl status postgresql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Para logearnos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>su - postgres<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos a la consola<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>psql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Modificamos la contrase\u00f1a de administrador<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER postgres PASSWORD 'HB3';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Salimos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CTRL+D<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Abrimos un nuevo cliente<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code> psql -U postgres -h localhost -W \n\n(HB3)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos la base de datos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE onlyoffice;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos el usuario<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER onlyoffice PASSWORD 'HB0';<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;Le damos permisos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL privileges ON DATABASE onlyoffice TO onlyoffice;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Salimos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CTRL+D<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Instalamos REDIS<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install redis-server<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Instalamos Rabbitmq<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install rabbitmq-server<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Instalamos NPM y NGINX-EXTRAS<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install npm nginx-extras<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Instalar Document Server<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Llave<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-key adv --keyserver hkp:\/\/keyserver.ubuntu.com:80 --recv-keys CB2DE8E5<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Agregar el repositorio<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>echo \"deb http:\/\/download.onlyoffice.com\/repo\/debian squeeze main\" | tee \/etc\/apt\/sources.list.d\/onlyoffice.list<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Actualizar<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get update<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Instalar<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install onlyoffice-documentserver<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Solicita la contrase\u00f1a de usuario de base de datos onlyoffice (HB3)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"224\" src=\"\/wp-content\/uploads\/2019\/09\/a51-1.png\" alt=\"\" class=\"wp-image-1642\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a51-1.png 514w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a51-1-300x131.png 300w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Si nos da error al instalar<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>psql: FATAL:  password authentication failed for user \"onlyoffice\"<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Correguimos con:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>echo RESET onlyoffice\/db-user | debconf-communicate onlyoffice-documentserver\necho RESET onlyoffice\/db-pwd | debconf-communicate onlyoffice-documentserver\ndpkg --configure onlyoffice-documentserver<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ya podemos ir al navegador<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>http:&#47;&#47;10.20.200.49\/welcome\/<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"600\" src=\"\/wp-content\/uploads\/2019\/09\/a52-1.png\" alt=\"\" class=\"wp-image-1643\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a52-1.png 558w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a52-1-279x300.png 279w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Creaci\u00f3n de certificado Letsencrypt<\/strong><\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">PROXY<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos en los DNS el dominio: document.siua.ac.cr -&gt; 10.20.200.49\/181.193.87.6<\/li><li>Creamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/apache2\/sites-available\/document.siua.ac.cr.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Contenido<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>NameVirtualHost 181.193.87.6:80\n\n&lt;VirtualHost 181.193.87.6:80&gt;\n\n        #************************************************************************\n        #******************* DATOS DEL SITIO WEB ********************************\n        #************************************************************************\n        ServerName document.siua.ac.cr\n        ServerAlias www.document.siua.ac.cr\n        ErrorLog \/var\/log\/apache2\/document_80.siua.ac.cr-error.log\n        CustomLog \/var\/log\/apache2\/document_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 REDIRECCIONAMIENTO ****************\n        #************************************************************************\n\n&lt;\/VirtualHost&gt;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Lo habilitamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>a2ensite document.siua.ac.cr.conf <\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Reiniciamos apache<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl reload apache2<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Mandamos a crear el certificado<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>certbot --installer apache<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Editamos el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/apache2\/sites-available\/document.siua.ac.cr-le-ssl.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Remplazamos todo el contenido por:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;IfModule mod_ssl.c&gt;\n&lt;VirtualHost 181.193.87.6:443&gt;\n\n#************************************************************************\n#******************* DATOS DEL SITIO WEB ********************************\n#************************************************************************\nServerName document.siua.ac.cr\nServerAlias www.document.siua.ac.cr\nErrorLog \/var\/log\/apache2\/document_443.siua.ac.cr-error.log\nCustomLog \/var\/log\/apache2\/document_443.siua.ac.cr-access.log common\n\n#************************************************************************\n#********************** DATOS DEL WEBMASTER *****************************\n#************************************************************************\nServerAdmin interuniversitariadealajuela@gmail.com\nHeader add Author \"Unidad de Gestion e Innovacion Tecnologica\"\n\n#************************************************************************\n#********************* DATOS DEL REDIRECCIONAMIENTO *********************\n#************************************************************************\nProxyPreserveHost On\nProxyRequests off\nSSLProxyEngine on\nProxyPass \/ https:\/\/10.20.200.49\/\nProxyPassReverse \/ https:\/\/10.20.200.49\/\n\n\n#************************************************************************\n#********************** DATOS DEL CERTIFICADO ***************************\n#************************************************************************\nInclude \/etc\/letsencrypt\/options-ssl-apache.conf\nSSLCertificateFile \/etc\/letsencrypt\/live\/document.siua.ac.cr\/fullchain.pem\nSSLCertificateKeyFile \/etc\/letsencrypt\/live\/document.siua.ac.cr\/privkey.pem\n&lt;\/VirtualHost&gt;\n&lt;\/IfModule&gt;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Reiniciamos apache<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl reload apache2<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Servidor DOCUMENT<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos una carpeta para almacenar los certificados<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir \/var\/www\/onlyoffice\/Data\/certs<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Le damos permisos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod 777 -R \/var\/www\/onlyoffice\/Data\/certs<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>PROXY<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Le pasamos los certificados<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>scp -P 44 -r \/etc\/letsencrypt\/live\/document.siua.ac.cr\/fullchain.pem root@10.20.200.49:\/var\/www\/onlyoffice\/Data\/certs\/fullchain.pem \n\nscp -P 44 -r \/etc\/letsencrypt\/live\/document.siua.ac.cr\/privkey.pem root@10.20.200.49:\/var\/www\/onlyoffice\/Data\/certs\/privkey.pem<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>DOCUMENT<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Detenemos el servicio<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>service nginx stop<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Copiamos la plantilla<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cp -f \/etc\/onlyoffice\/documentserver\/nginx\/onlyoffice-documentserver-ssl.conf.template \/etc\/nginx\/conf.d\/onlyoffice-documentserver.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Abrimos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/nginx\/conf.d\/onlyoffice-documentserver.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Editamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>include \/etc\/nginx\/includes\/onlyoffice-http.conf;\n\n## Normal HTTP host\nserver {\nlisten 0.0.0.0:80;\nlisten &#91;::]:80 default_server;\nserver_name _;\nserver_tokens off;\n\n## Redirects all traffic to the HTTPS host\nroot \/nowhere; ## root doesn't have to be a valid path since we are redirecting\nrewrite ^ https:\/\/$host$request_uri? permanent;\n}\n\n#HTTP host for internal services\nserver {\nlisten 127.0.0.1:80;\nlisten &#91;::1]:80;\nserver_name localhost;\nserver_tokens off;\n\ninclude \/etc\/nginx\/includes\/onlyoffice-documentserver-common.conf;\ninclude \/etc\/nginx\/includes\/onlyoffice-documentserver-docservice.conf;\n}\n\n## HTTPS host\nserver {\nlisten 0.0.0.0:443 ssl;\nlisten &#91;::]:443 ssl default_server;\nserver_tokens off;\nroot \/usr\/share\/nginx\/html;\n\n## Strong SSL Security\n## https:\/\/raymii.org\/s\/tutorials\/Strong_SSL_Security_On_nginx.html\nssl on;\nssl_certificate \/var\/www\/onlyoffice\/Data\/certs\/fullchain.pem;\nssl_certificate_key \/var\/www\/onlyoffice\/Data\/certs\/privkey.pem;\nssl_verify_client off;\n\nssl_ciphers \"EECDH+AESGCM:EDH+AESGCM:AES256+EECDH:AES256+EDH\";\n\nssl_protocols TLSv1 TLSv1.1 TLSv1.2;\nssl_session_cache builtin:1000 shared:SSL:10m;\n\nssl_prefer_server_ciphers on;\n\nadd_header Strict-Transport-Security max-age=31536000;\n# add_header X-Frame-Options SAMEORIGIN;\nadd_header X-Content-Type-Options nosniff;\n\ninclude \/etc\/nginx\/includes\/onlyoffice-documentserver-*.conf;\n\n}\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Iniciamos el servicio<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>service nginx start<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">&nbsp;Integrar a NEXTCLOUD<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos por ssh a nuestro servidor NEXTCLOUD<\/li><li>Instalamos si no lo tenemos la app<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/var\/www\/html\/SIUA\/apps\/\ngit clone https:\/\/github.com\/ONLYOFFICE\/onlyoffice-owncloud.git onlyoffice<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos a la aplicaci\u00f3n como administrador y habilitamos la apps<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"271\" src=\"\/wp-content\/uploads\/2019\/09\/a53-1.png\" alt=\"\" class=\"wp-image-1646\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a53-1.png 1000w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a53-1-300x81.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2019\/09\/a53-1-768x208.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingresamos a Configuraci\u00f3n-&gt;Administraci\u00f3n-&gt;ONLYOFFICE<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Si nos da error de javascript \u00abAllfonts.js\u00bb not Found<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/var\/log\/onlyoffice\/documentserver\/nginx.error.log<\/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 sudo<\/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>documentserver-generate-allfonts.sh<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Verificamos que ya exista el archivo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>ls \/var\/www\/onlyoffice\/documentserver\/sdkjs\/common<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p> ONLYOFFICE: instalaci\u00f3n debian 9<\/p>\n","protected":false},"author":2,"featured_media":2177,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[125],"tags":[100,36,126],"class_list":["post-1634","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-onlyoffice","tag-debian","tag-nextcloud","tag-onlyoffice"],"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\/1634","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=1634"}],"version-history":[{"count":5,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/1634\/revisions"}],"predecessor-version":[{"id":4478,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/1634\/revisions\/4478"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/media\/2177"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}