Instalación y configuración inicial de Banred Helpdesk

<VirtualHost *:80>
    ServerName helpdesk.banred.com.co
    DocumentRoot /var/www/helpdesk

    <Directory /var/www/helpdesk>
        AllowOverride All
        Require all granted
    </Directory>

    ErrorLog  ${APACHE_LOG_DIR}/helpdesk-error.log
    CustomLog ${APACHE_LOG_DIR}/helpdesk-access.log combined
</VirtualHost>

server {
    listen 80;
    server_name helpdesk.banred.com.co;
    root /var/www/helpdesk;
    index index.php;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        fastcgi_pass unix:/run/php/php8.2-fpm.sock;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
}

extension=imap
extension=pdo_mysql
extension=mbstring
extension=openssl

git clone https://github.com/banredco/helpdesk.git /var/www/helpdesk
cd /var/www/helpdesk
composer install --no-dev --optimize-autoloader

<?php

return [

    'host'     => 'localhost',

    'database' => 'helpdesk',

    'username' => 'helpdeskadmin',

    'password' => 'Redesjc2026*',

    'charset'  => 'utf8mb4'

];

$pdo = new PDO(
    "mysql:host={$config['host']};dbname={$config['database']};charset={$config['charset']}",
    $config['username'],
    $config['password']
);

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("SET time_zone='-05:00'");

mysql -u helpdeskadmin -p helpdesk < database/schema.sql

<?php

if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

function isLogged()
{
    return isset($_SESSION['user_id']);
}

function requireLogin()
{
    if (!isLogged()) {
        header('Location: /admin/login.php');
        exit;
    }
}

<?php

echo password_hash('Banred5050*', PASSWORD_DEFAULT);

# Genera el hash (reemplaza la contraseña por la tuya)
php -r "echo password_hash('TuContraseñaSegura2025*', PASSWORD_DEFAULT);"

# Inserta o actualiza el usuario administrador en la base de datos
mysql -u helpdeskadmin -p helpdesk -e \
  "UPDATE users SET password_hash='HASH_GENERADO' WHERE email='admin@banred.com.co';"