Comment 2 for bug 597905

I actually think there might be another issue here that I'm not sure should be resolved in drizzle, or via package maintainers.

a) Starting up drizzled for the first time creates the database [of missing] in DATADIR

b) If run as root, even with 'user=drizzle' in drizzled.cnf ... the DATADIR/.temporary directory is created by root before switching the context to the 'drizzle' user (as per the config).

c) drizzled seg faults because DATADIR/.temporary is owned by root... but drizzled is running as the 'drizzle' user at this point.

Basically, what this means is... that package maintainers would need to 'chown -R $DATADIR' on startup to ensure the files in DATADIR are owned by the drizzle owner... something that has been a big stink for mysql users on Redhat/Fedora in the past.

SUGGESTION:

The process should be handed over to the 'user' as per the config before any files in DATADIR are created (specifically .temporary).