Aug 16 2010
GLPI user has to select the group he belongs to when creating a ticket or else the field remains empty. This stored procedure automatically assigns all tickets to the user’s group. Setup a cron job to run it every so often. begin update SI_BD.glpi_tracking t set t.fk_group= ( SELECT g.id FROM SI_BD.glpi_users u, SI_BD.glpi_groups [...]
Aug 16 2010
Fortigate Dialup VPN client does not get an IP address although a DHCP pool is created and “DHCP-IPsec” is checked in the phase-2 VPN settings. An IPSEC ESP error is also raised in the event log. Setting a static IP does connect the client. To solve this, an additional firewall rule needs to be [...]
Aug 12 2010
I use this script to keep a full local backup of my tftp directory on Linux. It keeps the archive only if some of the files were modified. It can be used for any directory indeed. There are the files produced: [root@tftp_server backup]$ ls -l -rw-r—– 1 tftp tftp 124200 May 1 04:04 tftp-20100501.tgz [...]