Let's look at this

From the FAQ:

5.11 Sguild (loaderd) dies while trying to load SANCP data into the database.

Sguil uses the MySQL "LOAD DATA INFILE" syntax to load the SANCP data into the central database, and this requires special privileges above the normal INSERT/UPDATE privileges. You must also grant the FILE privilege, like so:

GRANT FILE ON *.* TO sguil@localhost;
FLUSH PRIVILEGES;

Notice that you have to grant the permission on every database and every table. FILE is a global privilege, and cannot be granted for just a single table or database.

But, according to riffraff:

+-----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for sguil@localhost |
+-----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'sguil'@'localhost' IDENTIFIED BY PASSWORD '(some password)' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `sguildb`.* TO 'sguil'@'localhost' |
+-----------------------------------------------------------------------------------------------------------------------------------------+

Does "ALL PRIVILEGES" NOT contain "FILE"? I'm assuming "ALL PRIVILEGES" would contain literally all privileges, but I'm having a really hard time finding out. Does it matter if the IDENTIFIED BY PASSWORD is listed? That is, is this dying due to an expectation of a passed variable for password?

Yesterday I regranted FILE on *.* to sguil@localhost. I flushed privileges, rebooted, and tried again. Same loaderd error occurred, so I tried GRANT ALL as Hanashi suggested in #snort-gui. I'm currently at a loss as to what to try next.