MacOS – Suggestd Crash due to SGSqliteDatabaseError

FileVault 2 uses the GeneratedUID user attribute to save who is permitted to unlock an encrypted volume. If the GeneratedUID of a user differs from what was generated (or pulled from LDAP) when FileVault 2 was enabled, the user will not be permitted to unlock the machine, as their account will appear to be unavailable at the EFI menu. Also, this causes the crash of System Preferences on their Mac whenever they try to access the Security & Privacy prefpane.

This problem arises when /usr/bin/mcxrefresh runs and pulls a null value or a value different than what is stored locally from LDAP (if the attribute isn't defined for the user in question or is defined incorrectly, respectively), overwriting the GeneratedUID stored locally (which is generated and only stored locally when FileVault 2 is enabled without a matching LDAP attribute).

In other words, if an apple-generateduid value exists in LDAP for a user and is mapped properly on the users Mac to the GeneratedUID attribute, FileVault 2 will not generate a new value, but will instead use the value stored in LDAP.

I was able to resolve this issue by adding an attribute called apple-generateduid to the LDAP entry of any user experiencing this issue. I could generate a random value for this attribute in Python by running the following one-liner from my terminal:

python -c 'import uuid; print str(uuid.uuid4()).upper();'

This isn't the only step, however. You must also add a mapping for this attribute on the client side. This is easily done using the following steps:

1. Open System Preferences.
2. Click Users & Groups.
3. Click Login Options.
4. Click on the Unlock Icon.
5. Under Network Account Server, click Edit.
6. Click to highlight your directory server.
7. Under Services, double-click on your directory service (in my case, it was LDAPv3)
8. In the window that slides open, highlight your configuration name, and then click the Edit... button.
9. Under Search & Mappings scroll down and single-click on Users to highlight it.
10. Click the Add button (the left one).
11. Choose GeneratedUID from the list of available Attribute Types.
12. In the right column, click the Add button, and type apple-generateduid. Click OK to save the changes until you're back at the main System Preferences dialog.
13. At this point a mapping from GeneratedUID to apple-generateduid has been created. Now when OS X looks up the GeneratedUID value it will get the value of apple-generateduid from the user in questions LDAP entry.

Finally, it's important that the locally stored value of GeneratedUID and value stored on LDAP match. Run the following command and make sure the two GeneratedUID values match:

dscl /Search search /Users GeneratedUID $(dscl . read /Users/$(echo $USER) GeneratedUID | cut -d " " -f2)

Make sure you did exactly this step by step:

1. Create a new blank wrapper with the latest Wine Engine
2. Select Install software and click SteamSetup.exe in Downloads or wherever you put it
3. Go through the setup wizard.
4. This is where the crash takes place. Force Quit all Wineskin processes.
5. Launch your wrapper again and click Advanced options
6. In the EXE flags, type -no-dwrite, tick use Start.exe and change nothing.exe on top to C:\Program Files\Steam\Steam.exe
7. Now do a test run and see if it worked. Now whenever you launch your wrapper, Steam should launch.