CREATE TABLE raw_log (
    RAW_LOG_ID VARCHAR(100) NOT NULL,
    SECTION VARCHAR(100),
    ORDER_ID VARCHAR(100),
    IS_ERROR VARCHAR(10),
    TRANSACTION_CODE VARCHAR(100),
    TRACE_POINT VARCHAR(255),
    TRACE LONGTEXT,
    RAW LONGTEXT,
    DATA LONGTEXT,
    CREATION_DATE DATETIME,
    SERVER LONGTEXT,
    POST LONGTEXT,
    HEADER LONGTEXT,
    PAGE VARCHAR(255),
    REPONSE LONGTEXT,
    INSERT_DATETIME DATETIME DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (RAW_LOG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


 
#//Rendre le script exécutable
chmod +x /var/www/html/projets/portal/myle_payment/load_trans_log.php
chmod +x /var/www/html/projets/portal/myle_payment/load_dump_all_callback.php
chmod +x /var/www/html/projets/portal/myle_payment/load_raw_log.php


# 1. Créer le service systemd pour trans_log
sudo bash -c 'cat > /etc/systemd/system/trans_log.service' <<'EOF'
[Unit]
Description=Service Traitement trans_logs
After=network.target mariadb.service

[Service]
ExecStart=/usr/bin/php /var/www/html/projets/portal/myle_payment/load_trans_log.php >> /trans_log_daemon.log 2>> /trans_log_daemon.err
Restart=always
RestartSec=5
User=www-data
Group=www-data

[Install]
WantedBy=multi-user.target
EOF

# 2. Créer le service systemd pour dump_all_callback
sudo bash -c 'cat > /etc/systemd/system/dump_all_callback.service' <<'EOF'
[Unit]
Description=Service Traitement des dump_all_callback
After=network.target mariadb.service

[Service]
ExecStart=/usr/bin/php /var/www/html/projets/portal/myle_payment/load_dump_all_callback.php >> /dump_all_callback_daemon.log 2>> /dump_all_callback_daemon.err
Restart=always
RestartSec=5
User=www-data
Group=www-data

[Install]
WantedBy=multi-user.target
EOF

# 2. Créer le service systemd pour raw_log
sudo bash -c 'cat > /etc/systemd/system/raw_log.service' <<'EOF'
[Unit]
Description=Service Traitement des raw_log
After=network.target mariadb.service

[Service]
ExecStart=/usr/bin/php /var/www/html/projets/portal/myle_payment/load_raw_log.php >> /raw_log_daemon.log 2>> /raw_log_daemon.err
Restart=always
RestartSec=5
User=www-data
Group=www-data

[Install]
WantedBy=multi-user.target
EOF

# 3. Créer la règle logrotate pour trans_log
sudo bash -c 'cat > /etc/logrotate.d/trans_log_daemon' <<'EOF'
/trans_log_daemon.log /trans_log_daemon.err {
    daily
    rotate 7
    compress
    missingok
    notifempty
    create 640 www-data www-data
}
EOF

# 4. Créer la règle logrotate pour dump_all_callback
sudo bash -c 'cat > /etc/logrotate.d/dump_all_callback_daemon' <<'EOF'
/dump_all_callback_daemon.log /dump_all_callback_daemon.err {
    daily
    rotate 7
    compress
    missingok
    notifempty
    create 640 www-data www-data
}
EOF

# 4. Créer la règle logrotate pour raw_log
sudo bash -c 'cat > /etc/logrotate.d/raw_log_daemon' <<'EOF'
/raw_log_daemon.log /raw_log_daemon.err {
    daily
    rotate 7
    compress
    missingok
    notifempty
    create 640 www-data www-data
}
EOF

# 5. Recharger systemd pour prendre en compte les nouveaux services  
sudo systemctl daemon-reload

# 6. Activer les services au démarrage
sudo systemctl enable trans_log
sudo systemctl enable dump_all_callback
sudo systemctl enable raw_log

# 7. Démarrer les services immédiatement
sudo systemctl start trans_log
sudo systemctl start dump_all_callback
sudo systemctl start raw_log


# 8. Forcer une rotation immédiate pour tester
sudo logrotate -f /etc/logrotate.d/trans_log_daemon
sudo logrotate -f /etc/logrotate.d/dump_all_callback_daemon

# 9. Vérifier que les fichiers de log existent
ls -lh /trans_log_daemon.* /dump_all_callback_daemon.*