Estimados. Pasamos una instancia de Guarani 3.17 de una vm en azure a otra para que la db este en el mismo servidor para solucionar un problema anterior y ahora estamos viendo que no está funcionan 1) el envío de correos y 2) el modulo de autogestion no esta funcionando: Esta página no funcionaLa página no puede procesar esta solicitud ahora.
HTTP ERROR 500
Les paso los logs de apache
Gracias
error_log.txt (21.1 KB)
Hola
Revisando el log, vimos que parece ser un problema de conexión con la base de datos. Por favor revisen los parámetros de conexión en el archivo instalacion/config.php
Luego corran el test de conexión desde Autogestion
[path raiz Autogestion]/bin/guarani test_conexion des01
donde des01 es el bloque de acceso configurado.
Deberia devolver algo similar a esto:
bin/guarani test_conexion des01
SE CONECTO CON EXITO!!!!!!!!!
PAR�METROS DE LA APLICACION
vendor: pgsql
dbname: trunk
schema: negocio
schema_toba: desarrollo
host: localhost
port: 5433
pdo_user: postgres
pdo_passwd: postgres
DATOS
propuesta: 1
nombre: Diplomatura Superior en Redes
nombre_abreviado: Diplo
codigo: 01
propuesta_tipo: 205
publica: S
documento_alta:
fecha_alta: 2015-08-27
campo_disciplinar: 11
escala_cumplimiento:
documento_baja:
fecha_baja:
a_termino:
entidad: 3
estado: A
Otro Error que vemos en el log, es de permisos en el sistema de archivos de gestión, que no tiene que ver con el problema de Autogestión, pero que tambien deben resolve, revisen el punto 6 de la documentación de instalación
Saludos
Estimados corri el comando y me dice command not found
[root@az-sslxsi000002 g3w3]# cd bin
[root@az-sslxsi000002 bin]# guarani test_conexion des01
-bash: guarani: command not found
[root@az-sslxsi000002 bin]# test_conexion des01
-bash: test_conexion: command not found
[root@az-sslxsi000002 bin]# test_conexion des01
-bash: test_conexion: command not found
Gracias
se corrio el punto 6 del manual nuevamente y se reinicio el apache, les paso los logs
[Wed Jun 10 01:02:40.705821 2020] [autoindex:error] [pid 61673] [client ::1:55016] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:02:45.707187 2020] [autoindex:error] [pid 61669] [client ::1:55028] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:02:50.708254 2020] [autoindex:error] [pid 61674] [client ::1:55050] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:02:55.709628 2020] [autoindex:error] [pid 61672] [client ::1:55062] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:00.711137 2020] [autoindex:error] [pid 61679] [client ::1:55084] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:05.712251 2020] [autoindex:error] [pid 61670] [client ::1:55106] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:10.713827 2020] [autoindex:error] [pid 61671] [client ::1:55118] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:15.715117 2020] [autoindex:error] [pid 61673] [client ::1:55140] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:20.716627 2020] [autoindex:error] [pid 61669] [client ::1:55162] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:25.717898 2020] [autoindex:error] [pid 61674] [client ::1:55180] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:30.719232 2020] [autoindex:error] [pid 61671] [client ::1:55202] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:03:31.549667 2020] [php7:error] [pid 61672] [client 186.134.215.162:53103] PHP Fatal error: Uncaught SIU\\Chulupi\\ErrorKernelDb: DB CONNECTION ERROR: ERROR conectandose al motor - SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "100.65.9.5", user "siu@100.65.8.2", database "toba_3_0", SSL off\n\nPor favor, verifique sus par\xc3\xa1metros de conexi\xc3\xb3n:\ndbname=toba_3_0\nhost=100.65.8.27\nport=5432 in /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php:83\nStack trace:\n#0 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php(21): SIU\\Chulupi\\util\\db\\DbPdo->conectar()\n#1 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/dba.php(33): SIU\\Chulupi\\util\\db\\DbPdo->__construct(Array)\n#2 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/kernel.php(169): SIU\\Chulupi\\util\\db\\dba::conectar(Array)\n#3 /usr/local/proyectos/g3w3/src/siu/modelo/datos/db/sistema.php(227): SIU\\Chulupi\\kernel::db()\n#4 /usr/local/proyectos/g3w3/src/siu/modelo/datos/catalogo.php(74): siu\\modelo\\datos\\db\\sistema->version_b in /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php on line 83
[Wed Jun 10 01:03:35.697201 2020] [php7:error] [pid 61670] [client 186.134.215.162:53106] PHP Fatal error: Uncaught SIU\\Chulupi\\ErrorKernelDb: DB CONNECTION ERROR: ERROR conectandose al motor - SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "100.65.9.5", user "siu@100.65.8.2", database "toba_3_0", SSL off\n\nPor favor, verifique sus par\xc3\xa1metros de conexi\xc3\xb3n:\ndbname=toba_3_0\nhost=100.65.8.27\nport=5432 in /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php:83\nStack trace:\n#0 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php(21): SIU\\Chulupi\\util\\db\\DbPdo->conectar()\n#1 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/dba.php(33): SIU\\Chulupi\\util\\db\\DbPdo->__construct(Array)\n#2 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/kernel.php(169): SIU\\Chulupi\\util\\db\\dba::conectar(Array)\n#3 /usr/local/proyectos/g3w3/src/siu/modelo/datos/db/sistema.php(227): SIU\\Chulupi\\kernel::db()\n#4 /usr/local/proyectos/g3w3/src/siu/modelo/datos/catalogo.php(74): siu\\modelo\\datos\\db\\sistema->version_b in /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php on line 83
[Wed Jun 10 01:03:35.720839 2020] [autoindex:error] [pid 62047] [client ::1:55232] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
agrego nuevos logs
[Wed Jun 10 01:18:05.061433 2020] [autoindex:error] [pid 62339] [client ::1:58654] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:10.062932 2020] [autoindex:error] [pid 62338] [client ::1:58676] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:15.064369 2020] [autoindex:error] [pid 62336] [client ::1:58688] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:20.065619 2020] [autoindex:error] [pid 62344] [client ::1:58710] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:25.066914 2020] [autoindex:error] [pid 62340] [client ::1:58732] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:30.068270 2020] [autoindex:error] [pid 62338] [client ::1:58750] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:35.069552 2020] [autoindex:error] [pid 62336] [client ::1:58772] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:40.070803 2020] [autoindex:error] [pid 62337] [client ::1:58794] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:40.206962 2020] [php7:error] [pid 62340] [client 186.134.215.162:53267] PHP Fatal error: Uncaught SIU\\Chulupi\\ErrorKernelDb: DB CONNECTION ERROR: ERROR conectandose al motor - SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "100.65.9.5", user "siu@100.65.8.2", database "toba_3_0", SSL off\n\nPor favor, verifique sus par\xc3\xa1metros de conexi\xc3\xb3n:\ndbname=toba_3_0\nhost=100.65.8.27\nport=5432 in /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php:83\nStack trace:\n#0 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php(21): SIU\\Chulupi\\util\\db\\DbPdo->conectar()\n#1 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/dba.php(33): SIU\\Chulupi\\util\\db\\DbPdo->__construct(Array)\n#2 /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/kernel.php(169): SIU\\Chulupi\\util\\db\\dba::conectar(Array)\n#3 /usr/local/proyectos/g3w3/src/siu/modelo/datos/db/sistema.php(227): SIU\\Chulupi\\kernel::db()\n#4 /usr/local/proyectos/g3w3/src/siu/modelo/datos/catalogo.php(74): siu\\modelo\\datos\\db\\sistema->version_b in /usr/local/proyectos/g3w3/vendor/siu/chulupi-framework/src/SIU/Chulupi/util/db/DbPdo.php on line 83
[Wed Jun 10 01:18:45.071997 2020] [autoindex:error] [pid 62341] [client ::1:58818] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:50.073285 2020] [autoindex:error] [pid 62338] [client ::1:58844] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:18:55.074553 2020] [autoindex:error] [pid 62344] [client ::1:58866] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:19:00.075831 2020] [autoindex:error] [pid 62336] [client ::1:58878] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:19:05.077175 2020] [autoindex:error] [pid 62337] [client ::1:58900] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:19:10.078224 2020] [autoindex:error] [pid 62341] [client ::1:58916] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:19:15.079552 2020] [autoindex:error] [pid 62344] [client ::1:58934] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:19:20.080692 2020] [autoindex:error] [pid 62336] [client ::1:58956] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Jun 10 01:19:25.082312 2020] [autoindex:error] [pid 62337] [client ::1:58968] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
¿Alguna novedad?, Gracias
Hola
El comando se debe correr de la siguiente forma
[path a la raíz de la aplicacion 3w]# bin/guarani test_conexion des01
o también
[path a la raíz de la aplicacion 3w]/bin# ./guarani test_conexion des01
Con respecto a los logs, se ve un a entrada de error de conexión
DB CONNECTION ERROR: ERROR conectandose al motor - SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "100.65.9.5", user "siu@100.65.8.2", database "toba_3_0",
Es un tema de configuración del Motor de BD, revisen el archivo pg_hba.conf y el postgresql.conf
Saludos