Instalaci\u00f3n faveo ubuntu server 17.10 en maquina virtual proxmox 5<\/p>\n\n\n\n
useradd -r www-data <\/code><\/pre>\n\n\n\n- Paso 2: Creamos el grupo \u00abwww-data\u00bb<\/li><\/ul>\n\n\n\n
\/usr\/sbin\/usermod -G www-data www-data;<\/code><\/pre>\n\n\n\n- Paso 3: obtenemos la llave de ngix y la guardamos (-O) en el archivo \u00ab\/tmp\/nginx-gpg.key\u00bb<\/li><\/ul>\n\n\n\n
wget -O \/tmp\/nginx-gpg.key http:\/\/nginx.org\/keys\/nginx_signing.key<\/code><\/pre>\n\n\n\n- Paso 4: a\u00f1adimos la llave al sistema<\/li><\/ul>\n\n\n\n
apt-key add \/tmp\/nginx-gpg.key<\/code><\/pre>\n\n\n\n- Paso 5: agregamos al sources list el repositorio de ngix y de php<\/li><\/ul>\n\n\n\n
nano \/etc\/apt\/sources.list<\/code><\/pre>\n\n\n\n- AGREGAR<\/li><\/ul>\n\n\n\n
deb http:\/\/nginx.org\/packages\/ubuntu\/ zesty nginx<\/code><\/pre>\n\n\n\n- Paso 6: agregar el repositorio de PHP y apache<\/li><\/ul>\n\n\n\n
sudo add-apt-repository ppa:ondrej\/apache2 sudo add-apt-repository ppa:ondrej\/php<\/code><\/pre>\n\n\n\n- Paso 7: agregar repositorio de mariaDB<\/li><\/ul>\n\n\n\n
sudo apt-get install software-properties-common\n\nsudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8\n\nsudo add-apt-repository 'deb [arch=amd64,i386] http:\/\/sfo1.mirrors.digitalocean.com\/mariadb\/repo\/10.2\/ubuntu artful main'<\/code><\/pre>\n\n\n\n- Paso 8: actualizamos el sistema<\/li><\/ul>\n\n\n\n
apt-get update && apt-get upgrade -y <\/code><\/pre>\n\n\n\n- Paso 9: instalamos programas<\/li><\/ul>\n\n\n\n
apt-get install curl software-properties-common git sl mlocate dos2unix bash-completion openssl mariadb-server nginx \\\nphp5.6-soap php5.6-json php5.6-fpm php5.6-cli php5.6-gd php5.6-mbstring php5.6-common \\\nphp5.6-mcrypt php5.6-xml php5.6-curl php5.6-imap php5.6-mysql php5.6-xmlrpc -y && updatedb;<\/code><\/pre>\n\n\n\n- Paso 10: detenemos los servicios<\/li><\/ul>\n\n\n\n
service nginx stop && \\\nservice php5.6-fpm stop<\/code><\/pre>\n\n\n\n- Paso 11: respaldamos el archivo de configuraci\u00f3n de ngix<\/li><\/ul>\n\n\n\n
mv \/etc\/nginx\/nginx.conf \/etc\/nginx\/nginx.conf.back;<\/code><\/pre>\n\n\n\n- Paso 12: abrimos el archivo de configuraci\u00f3n de ngix<\/li><\/ul>\n\n\n\n
nano \/etc\/nginx\/nginx.conf<\/code><\/pre>\n\n\n\n- AGERGAMOS<\/li><\/ul>\n\n\n\n
user www-data;
worker_processes 2;
pid \/var\/run\/nginx.pid;
events {
worker_connections 1024;
}
http {
log_format main '$remote_addr - $remote_user [$time_local] \"$request\" '
'$status $body_bytes_sent \"$http_referer\" '
'\"$http_user_agent\" \"$http_x_forwarded_for\"';
access_log \/var\/log\/nginx\/access.log main;
error_log \/var\/log\/nginx\/error.log;
include \/etc\/nginx\/mime.types;
default_type application\/octet-stream;
server_tokens off;
gzip on;
gzip_disable \"msie[1-6]\";
gzip_vary on;
gzip_proxied any;
gzip_comp_level 6;
gzip_buffers 16 8k;
gzip_min_length 256;
gzip_types text\/plain text\/css application\/json application\/x-javascript text\/xml application\/xml application\/xml+rss text\/javascript application\/vnd.ms-fontobject application\/x-font-ttf font\/opentype image\/svg+xml image\/x-icon;
ignore_invalid_headers on;
max_ranges 1;
read_ahead 512K;
reset_timedout_connection on;
keepalive_timeout 600;
sendfile on;
include \/etc\/nginx\/conf.d\/*.conf;
proxy_read_timeout 3600;
}<\/pre>\n\n\n\n
- Paso 13: creamos el archivo de configuraci\u00f3n para faveo-ngix<\/li><\/ul>\n\n\n\n
nano \/etc\/nginx\/conf.d\/faveo-helpdesk.conf<\/code><\/pre>\n\n\n\n- AGREGAMOS<\/li><\/ul>\n\n\n\n
# Faveo Helpdesk - Basic, Quick-Start NGINX Server Block
# 16.06.18 Author: Mathieu Aubin
upstream faveo_php {
server unix:\/\/opt\/faveo\/run\/faveo_php.socket;
}
server {
listen 80;
listen 127.0.0.1:80;
# Edit the following line with the correct information.
server_name %(SERVERNAME)s;
error_log \/opt\/faveo\/log\/faveo_error_log;
access_log \/opt\/faveo\/log\/faveo_access_log;
root \/opt\/faveo\/faveo-helpdesk\/public;
index index.php index.html index.htm;
error_page 403 404 405 500 501 502 503 504 @error;
try_files $uri $uri\/ \/index.php?$args;
location @error {
rewrite ^\/(.*)$ \/index.php?$1;
}
location ~ \/\\. {
deny all;
}
location ~ \/(artisan|composer.json|composer.lock|gulpfile.js|LICENSE|package.json|phpspec.yml|phpunit.xml|README.md|readme.txt|release-notes.txt|server.php) {
deny all;
}
location ~ [^\/]\\.php(\/|$) {
fastcgi_split_path_info ^(.+?\\.php)(\/.*)$;
if (!-f $document_root$fastcgi_script_name) {
return 404;
}
include \/etc\/nginx\/fastcgi_params;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_pass faveo_php;
fastcgi_read_timeout 240;
}
}<\/pre>\n\n\n\n
- Paso 14: eliminamos el el archivo default de configuraci\u00f3n de ngix<\/li><\/ul>\n\n\n\n
rm -rf \/etc\/nginx\/conf.d\/default.conf<\/code><\/pre>\n\n\n\n- Paso 15: creamos nuestro php-fpm pool<\/li><\/ul>\n\n\n\n
nano \/etc\/php\/5.6\/fpm\/pool.d\/faveo_php.conf<\/code><\/pre>\n\n\n\n- AGREGAR<\/li><\/ul>\n\n\n\n
; Faveo-Helpdesk CE PHP-FPM pool definition
; Author: Mathieu Aubin
[faveo_php]
user = www-data
group = www-data
listen = \/opt\/faveo\/run\/faveo_php.socket
listen.owner = www-data
listen.group = www-data
pm = dynamic
pm.max_children = 5
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 3
chdir = \/<\/pre>\n\n\n\n
- Paso 16: creamos los directorios para almacenar al proyecto (-p parent crea el directorio padre \u00abfaveo\u00bb si no existe )<\/li><\/ul>\n\n\n\n
mkdir -p \/opt\/faveo\/log && mkdir -p \/opt\/faveo\/run;<\/code><\/pre>\n\n\n\n- Paso 17: clonamos el proyecto<\/li><\/ul>\n\n\n\n
git clone https:\/\/github.com\/ladybirdweb\/faveo-helpdesk.git \/opt\/faveo\/faveo-helpdesk<\/code><\/pre>\n\n\n\n- Paso 18: modificamos el due\u00f1o de la carpeta faveo<\/li><\/ul>\n\n\n\n
chown www-data:www-data \/opt\/faveo<\/code><\/pre>\n\n\n\n- Paso 19: actualizamos la base de datos de los archivos de sistema<\/li><\/ul>\n\n\n\n
updatedb<\/code><\/pre>\n\n\n\n- Paso 20: abrimos el archivo de configuraci\u00f3n para modificar el nombre ser servidor<\/li><\/ul>\n\n\n\n
nano \/etc\/nginx\/conf.d\/faveo-helpdesk.conf<\/code><\/pre>\n\n\n\n- ORIGINAL<\/li><\/ul>\n\n\n\n
# Faveo Helpdesk - Basic, Quick-Start NGINX Server Block
# 16.06.18 Author: Mathieu Aubin
upstream faveo_php {
server unix:\/\/opt\/faveo\/run\/faveo_php.socket;
}
server {
listen 80;
listen 127.0.0.1:80;
# Edit the following line with the correct information.
server_name %(SERVERNAME)s;<\/strong>
error_log \/opt\/faveo\/log\/faveo_error_log;
access_log \/opt\/faveo\/log\/faveo_access_log;
root \/opt\/faveo\/faveo-helpdesk\/public;
index index.php index.html index.htm;
error_page 403 404 405 500 501 502 503 504 @error;
try_files $uri $uri\/ \/index.php?$args;
location @error {
rewrite ^\/(.*)$ \/index.php?$1;
}
location ~ \/\\. {
deny all;
}
location ~ \/(artisan|composer.json|composer.lock|gulpfile.js|LICENSE|package.json|phpspec.yml|phpunit.xml|README.md|readme.txt|release-notes.txt|server.php) {
deny all;
}
location ~ [^\/]\\.php(\/|$) {
fastcgi_split_path_info ^(.+?\\.php)(\/.*)$;
if (!-f $document_root$fastcgi_script_name) {
return 404;
}
include \/etc\/nginx\/fastcgi_params;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_pass faveo_php;
}
}<\/pre>\n\n\n\n- Modificamos<\/li><\/ul>\n\n\n\n
server_name soporte.siua.ac.cr<\/strong>;<\/pre>\n\n\n\n- Paso 21: configuramos MariaDB<\/li>
- Iniciamos el servicio<\/li><\/ul>\n\n\n\n
service mysql start<\/code><\/pre>\n\n\n\n- Mandamos a configurar<\/li><\/ul>\n\n\n\n
mysql_secure_installation<\/code><\/pre>\n\n\n\n NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none): HB3<\/strong>
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y\/n] n<\/strong>
... skipping.
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y\/n] Y<\/strong>
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y\/n] Y<\/strong>
... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y\/n] Y<\/strong>
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y\/n] Y<\/strong>
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!<\/pre>\n\n\n\n- Paso 22: lo configuramos para permitir ingreso remoto<\/li><\/ul>\n\n\n\n
nano \/etc\/mysql\/my.cnf<\/code><\/pre>\n\n\n\n- BUSCAMOS y comentamos<\/li><\/ul>\n\n\n\n
#bind-address = 127.0.0.1\n<\/code><\/pre>\n\n\n\n- Ingresamos a MYSQL<\/li><\/ul>\n\n\n\n
mysql -u root -p mysql<\/code><\/pre>\n\n\n\n- Creamos el usuario remoto<\/li><\/ul>\n\n\n\n
GRANT ALL PRIVILEGES ON *.* TO 'remoto'@'%' IDENTIFIED BY 'RB0' WITH GRANT OPTION;<\/code><\/pre>\n\n\n\n- Actualizamos privilegios<\/li><\/ul>\n\n\n\n
FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n- Reiniciamos mysql<\/li><\/ul>\n\n\n\n
service mysql restart\n<\/code><\/pre>\n\n\n\n- Paso 23: creamos la base de datos, para esto creamos un script<\/li><\/ul>\n\n\n\n
nano \/tmp\/faveo-createdb.sh<\/code><\/pre>\n\n\n\n- AGREGAMOS, modificando los datos, esto crea un archivo \u00ab\/tmp\/faveo-blank.sql\u00bb<\/li><\/ul>\n\n\n\n
#!\/bin\/sh
# Edit the values AFTER the EQUAL \"=\" sign to your desired database for Faveo-Helpdesk
# Database name, user and password must all be different from one another...
# Also enter your MYSQL root password.
# The values that are currently entered are for demonstration only, you have to enter the right values for YOU.
# No spaces BEFORE or AFTER, be smart.
DB_NAME=faveo<\/strong>
DB_USER=remoto<\/strong>
DB_PASS=RB0<\/strong>
MYSQL_ROOT_PASS=HB3<\/strong>
########################################################################
########################################################################
######### DO NOT TOUCH THE FOLLOWING LINES #############################
########################################################################
########################################################################
printf \"CREATE DATABASE %s;\" $DB_NAME > \/tmp\/faveo-blank.sql;
printf \"GRANT ALL PRIVILEGES ON %s.* TO '%s'@'localhost' IDENTIFIED BY '%s';\" $DB_NAME $DB_USER $DB_PASS >> \/tmp\/faveo-blank.sql;
printf \"FLUSH PRIVILEGES;\" >> \/tmp\/faveo-blank.sql;
\/usr\/bin\/mysql -u root -p\"$MYSQL_ROOT_PASS\" < \/tmp\/faveo-blank.sql;
echo \"La base de datos de faveo a sido creada...\"<\/pre>\n\n\n\n- Paso 24: le damos permisos de ejecuci\u00f3n<\/li><\/ul>\n\n\n\n
chmod +x \/tmp\/faveo-createdb.sh<\/code><\/pre>\n\n\n\n- Paso 25: convertimos el archivo en formato Unix<\/li><\/ul>\n\n\n\n
dos2unix \/tmp\/faveo-createdb.sh<\/code><\/pre>\n\n\n\n- Paso 26: ejecutamos el archivo<\/li><\/ul>\n\n\n\n
sh \/tmp\/faveo-createdb.sh<\/code><\/pre>\n\n\n\n- Paso 27: podemos comprobar que la base de datos se creo correctamente ingresando a mariadb<\/li><\/ul>\n\n\n\n
mysql -u root -p<\/code><\/pre>\n\n\n\n- Listar las bases de datos<\/li><\/ul>\n\n\n\n
show databases;\n<\/code><\/pre>\n\n\n\n- RESULTADO<\/li><\/ul>\n\n\n\n
+--------------------+
| Database |
+--------------------+
| faveo<\/strong> |
| information_schema |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)<\/pre>\n\n\n\n- Salimos<\/li><\/ul>\n\n\n\n
quit<\/code><\/pre>\n\n\n\n- Paso 28: iniciar los servicios<\/li><\/ul>\n\n\n\n
service php5.6-fpm start\n\nservice nginx start\n\nservice mysql start\n<\/code><\/pre>\n\n\n\n- Paso 29: instalamos composer de forma global<\/li><\/ul>\n\n\n\n
curl -sS https:\/\/getcomposer.org\/installer | php -- --install-dir=\/usr\/local\/bin --filename=composer<\/code><\/pre>\n\n\n\n- Paso 30: creamos un cron<\/li><\/ul>\n\n\n\n
crontab -l ;\\
echo -e \"# Faveo-Helpdesk Cronjobs\\n# This gets email tickets every 5 minutes, change to suit your needs\\n\\
*\/5 * * * * \/usr\/bin\/curl http:\/\/127.0.0.1\/readmails\\n\\
<\/a># This runs the notification everyday at 23:55, change for another time if you want.\\n\\
55 23 * * * \/usr\/bin\/curl http:\/\/127.0.0.1\/notification\" | crontab - && sleep 1;<\/pre>\n\n\n\n- Paso 31: comprobamos que los servicios est\u00e9n corriendo<\/li><\/ul>\n\n\n\n
service nginx status | grep 'Active:' | grep --color=auto 'dead\\|failed\\|running'service mysql status | grep 'Active:' | grep --color=auto 'dead\\|failed\\|running'service php5.6-fpm status | grep 'Active:' | grep --color=auto 'dead\\|failed\\|running'<\/code><\/pre>\n\n\n\n- RESULTADO<\/li><\/ul>\n\n\n\n
Active: active (running<\/strong>) since Thu 2017-12-07 10:39:35 CST; 16min ago<\/pre>\n\n\n\n- Paso 32: comprobamos que tenemos todos los requisitos para esto creamos una carpeta<\/li><\/ul>\n\n\n\n
mkdir \/opt\/faveo\/faveo_probe<\/code><\/pre>\n\n\n\n- Le damos permisos<\/li><\/ul>\n\n\n\n
chmod 777 -R \/opt\/faveo\/faveo_probe<\/code><\/pre>\n\n\n\n- Le insertamos los siguientes archivos<\/li><\/ul>\n\n\n\n
faveo_probe<\/a>
<\/p>\n\n\n\n- Les damos permisos<\/li><\/ul>\n\n\n\n
chmod 777 -R \/opt\/faveo\/faveo_probe<\/code><\/pre>\n\n\n\n- Paso 33: instalamos dependecias<\/li><\/ul>\n\n\n\n
apt-get install curl php5.6-cli php5.6-mbstring git unzip<\/code><\/pre>\n\n\n\n- Paso 34: ingresamos a la carpeta del proyecto<\/li><\/ul>\n\n\n\n
cd \/opt\/faveo\/faveo-helpdesk\/<\/code><\/pre>\n\n\n\n- Paso 35: instalamos composer<\/li><\/ul>\n\n\n\n
php -r \"copy('https:\/\/getcomposer.org\/installer', 'composer-setup.php');\"<\/code><\/pre>\n\n\n\nphp -r \"if (hash_file('SHA384', 'composer-setup.php') === '544e09ee996cdf60ece3804abc52599c22b1f40f4323403c44d44fdfdd586475ca9813a858088ffbc1f233e9b180f061') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;\"<\/code><\/pre>\n\n\n\nphp composer-setup.php<\/code><\/pre>\n\n\n\nphp -r \"unlink('composer-setup.php');\"<\/code><\/pre>\n\n\n\n- Podemos comprobar que esta instalado<\/li><\/ul>\n\n\n\n
php artisan --version<\/code><\/pre>\n\n\n\n- RESULTADO<\/li><\/ul>\n\n\n\n
PHP Notice: Use of undefined constant MCRYPT_RIJNDAEL_128 - assumed 'MCRYPT_RIJNDAEL_128' in \/opt\/faveo\/faveo-helpdesk\/config\/app.php on line 101
Laravel Framework version 5.2.45<\/pre>\n\n\n\n
- Paso 36: damos permisos de escritura a estas carpetas<\/li><\/ul>\n\n\n\n
chmod 777 -R \/opt\/faveo\/faveo-helpdesk\/storage\/\nchmod 777 -R \/opt\/faveo\/faveo-helpdesk\/vendor\/\n<\/code><\/pre>\n\n\n\n- Paso 37: ingresamos al archivo:<\/li><\/ul>\n\n\n\n
nano \/opt\/faveo\/faveo-helpdesk\/config\/database.php<\/code><\/pre>\n\n\n\n- Y modificamos el mysql<\/li><\/ul>\n\n\n\n
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'localhost'),
'database' => env('DB_DATABASE','faveo'<\/strong>),
'username' => env('DB_USERNAME','remoto'<\/strong>),
'password' => env('DB_PASSWORD','RB0'<\/strong>),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'port' => env('DB_PORT', '3306'<\/strong>),
'prefix' => '',
'strict' => false,
],<\/pre>\n\n\n\n- Paso 38: ya podemos acceder al sitio http:\/\/faveo.siua.ac.cr<\/a>