{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Niektoré skripty pracujú s premennými ","type":"text"},{"text":"APP_NAME ","type":"text","marks":[{"type":"strong"}]},{"text":"a ","type":"text"},{"text":"APP_USER","type":"text","marks":[{"type":"strong"}]},{"text":", ktoré by mali byť nastavené pred spustením príkazov.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Java","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"sudo apt update\nsudo apt -y install openjdk-8-jdk\nsudo update-alternatives --config java\nsudo update-alternatives --config javac\necho 'Setting JAVA_HOME'\necho 'JAVA_HOME=\"/usr/lib/jvm/java-8-openjdk-amd64\"' | sudo tee -a /etc/environment","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"MongoDB 3.6","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"sudo apt install -y gnupg\nwget -qO - https://www.mongodb.org/static/pgp/server-4.4.asc | sudo apt-key add -\necho \"deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu focal/mongodb-org/4.4 multiverse\" | sudo tee /etc/apt/sources.list.d/mongodb-org-4.4.list\nsudo apt update\nsudo apt install -y mongodb-org\nsudo systemctl enable mongod.service\nsudo service mongod start\necho 'MongoDB starting'","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Redis","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"sudo apt install -y build-essential tcl\n#sudo add-apt-repository ppa:chris-lea/redis-server -y\nsudo apt update\nsudo apt install -y redis-server\necho 'Updating redis config'\nsed -i -e \"s/supervised no/supervised systemd/g\" /etc/redis/redis.conf\n#echo 'dir /var/lib/redis' | sudo tee -a '/etc/redis/redis.conf'\nsudo systemctl restart redis-server\necho 'Redis starting'","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"MySQL 5.7","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Ubuntu 18.04 and less","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"sudo apt update\necho \"mysql-server-5.7 mysql-server/root_password password Hujkbu#6C#hHnURt\" | sudo debconf-set-selections\necho \"mysql-server-5.7 mysql-server/root_password_again password Hujkbu#6C#hHnURt\" | sudo debconf-set-selections\nsudo apt -y install mysql-server-5.7","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Ubuntu 20.04","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"echo 'deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-apt-config' | sudo tee -a /etc/apt/sources.list.d/mysql.list\necho 'deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-5.7' | sudo tee -a /etc/apt/sources.list.d/mysql.list\necho 'deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-tools' | sudo tee -a /etc/apt/sources.list.d/mysql.list\necho 'deb-src http://repo.mysql.com/apt/ubuntu/ bionic mysql-5.7' | sudo tee -a /etc/apt/sources.list.d/mysql.list\nsudo apt update\n\n#W: GPG error: http://repo.mysql.com/apt/ubuntu bionic InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 8C718D3B5072E1F5\n\nsudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys ''\nsudo apt update\nsudo apt-cache policy mysql-server\nsudo apt -y install mysql-client=5.7.30-1ubuntu18.04\nsudo apt -y install mysql-community-server=5.7.30-1ubuntu18.04\nsudo apt -y install mysql-server=5.7.30-1ubuntu18.04","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"MySQL 8 - Ubuntu 20.04","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"sudo apt update\nsudo apt install -y mysql-server\nsudo mysql_secure_installation","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Create MySQL user","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"read -sp 'MySQL root password: ' sql_root\nsudo mysql -u root -Bse \"CREATE USER IF NOT EXISTS 'netgrif_nae'@'localhost' IDENTIFIED BY 'netgrif_nae'; GRANT ALL PRIVILEGES ON * . * TO 'netgrif_nae'@'localhost';FLUSH PRIVILEGES;\"\necho \"MySQL user for app ${APP_NAME} was created\"","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Neo4j","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"wget -O - https://debian.neo4j.com/neotechnology.gpg.key | sudo apt-key add -\necho 'deb https://debian.neo4j.com stable 3.5' | sudo tee /etc/apt/sources.list.d/neo4j.list\nsudo apt update\nsudo apt -y install neo4j=1:3.5.18\nsudo systemctl enable neo4j.service\nsudo systemctl start neo4j.service\necho 'Neo4j starting'\nsleep 10s\ncurl -H \"Content-Type: application/json\" -X POST -d '{\"password\":\"netgrif_nae\"}' -u neo4j:neo4j http://localhost:7474/user/neo4j/password\necho 'NEO4J_ULIMIT_NOFILE=60000' | sudo tee -a /etc/default/neo4j","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Elasticsearch 6.8","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo apt-key add -\nsudo apt install apt-transport-https\necho \"deb https://artifacts.elastic.co/packages/6.x/apt stable main\" | sudo tee /etc/apt/sources.list.d/elastic-6.x.list\nsudo apt update\nsudo apt -y install elasticsearch\nsudo systemctl daemon-reload\nsudo systemctl enable elasticsearch.service\nsudo systemctl stop elasticsearch.service\n\necho 'Updating configurations for ElasticSearch'\nsudo sed -i -e \"s/# End of file.*//g\" /etc/security/limits.conf\necho '* soft nofile 64000' | sudo tee -a /etc/security/limits.conf\necho '* hard nofile 64000' | sudo tee -a /etc/security/limits.conf\necho 'root soft nofile 64000' | sudo tee -a /etc/security/limits.conf\necho 'root hard nofile 64000' | sudo tee -a /etc/security/limits.conf\necho '# End of file' | sudo tee -a /etc/security/limits.conf\necho 'session required pam_limits.so' | sudo tee -a /etc/pam.d/common-session\necho 'session required pam_limits.so' | sudo tee -a /etc/pam.d/common-session-noninteractive\nsudo sed -i -e \"s/#DefaultLimitNOFILE=.*/DefaultLimitNOFILE=65536/g\" /etc/systemd/system.conf\nsudo mkdir /etc/systemd/system/elasticsearch.service.d\nsudo bash -c 'cat > /etc/systemd/system/elasticsearch.service.d/override.conf < /etc/apache2/sites-available/${APP_NAME}.conf <\n #ServerName netgrif.uniqa-international.eu\n ServerAdmin webmaster@localhost\n DocumentRoot /var/www/html/${APP_NAME}/\n\n \n Options Indexes FollowSymLinks MultiViews\n AllowOverride all\n Require all granted\n \n\n RewriteEngine on\n RewriteCond %{REQUEST_FILENAME} !-f\n RewriteCond %{REQUEST_FILENAME} !-d\n RewriteCond %{REQUEST_URI} !^/index\\.html$\n RewriteCond %{REQUEST_URI} !\\.(css|gif|ico|jpg|js|png|swf|txt|svg|woff|woff2|ttf|eot|html|json|pdf)$\n RewriteCond %{REQUEST_URI} !^/api/(.*)$\n RewriteRule . /index.html [L]\n\n ProxyPreserveHost On\n ProxyRequests Off\n ProxyVia Off\n\n \n Order deny,allow\n Allow from all\n \n\n RemoteIPHeader X-Forwarded-For\n RequestHeader set X-Forwarded-Proto \\\"https\\\"\n\n ProxyPass /api/ http://localhost:8080/api/\n ProxyPassReverse /api/ http://localhost:8080/api/\n\n ErrorLog /var/log/apache2/${APP_NAME}/error.log\n CustomLog /var/log/apache2/${APP_NAME}/access.log combined\n\nEOF\n\"\nsudo a2ensite $APP_NAME\nsudo systemctl restart apache2","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Application Service","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"sudo mkdir /opt/$APP_NAME\nsudo chown $APP_USER:$APP_USER -R /opt/$APP_NAME\nsudo bash -c \"cat > /etc/systemd/system/${APP_NAME}.service < /opt/${APP_NAME}/mysql_starter.sql <