Symptom: When running FTK and attempting to connect to the database for the first time using a known correct password, FTK indicates "preparation failed. please verify the username and password provided".
Causes:
- The specified postgres password is incorrect
- The port PostgreSQL is using to communicate is blocked by a firewall
- The PostgreSQL DB store was installed on a non-NTFS formatted drive
- IPv6 support needs to be switched
- Python is corrupt or didn't get installed
- The PC has multiple active NICs
Resolution:
If a firewall is active, either disable the firewall or add an exclusion such that the port used by Postgresql (default port 5432) is not blocked.
If the PostgreSQL database is installed on a non-NTFS file system:
- Uninstall Postgres.
- Format the desired drive for postgres as NTFS.
- Reinstall postgres.
- Run FTK and connect to the database normally.
IPv6 support needs to be switched:
- Open Network and Sharing Center.
- In the "View your active networks" area, click on your network adapter,.
- Click Properties.
- On the Networking tab, toggle the state of "Internet Protocol Version 6 (TCP/IPv6)" -i.e. if it is on, turn it off and leave it off, and, if it is off, turn it on and leave it on.
- Click OK.
Python is corrupt or didn't get installed:
- Uninstall Python (take note of the version).
- Reboot.
- Download and install the appropriate version of Python from python.org..
- Run FTK and connect to the database normally.
PC has multiple active NICs:
- Open the Windows Network and Sharing Center
- Click "Change adapter settings" on the left
- Disable all but one of the network adapters
- Run FTK and connect to the database normally
- After the database connects correctly, the other network adapters can be re-enabled
Note: For Postgresql 9.1 users, also consider verifying the postgresql network settings found in the "pg_hba.conf" file of the pgdata folder. Use step 7 of this help article below as a reference point.