The language setting of your computer can cause issues while conducting the initial database sync. In order to prevent such issues, export the language variables using the following command:

export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8

Please ensure that the configuration file has the correct SQL URL. The format is mysql://username:password@host:port/databaseName. If your password has an @ symbol, the database sync will fail.

The service may hang, due to which you will see 5XX errors. Restart the service using the service Keystone restart command.

Please ensure that you are able to resolve the names that are mentioned in several of the configuration URLs. If you cannot ping them, check the DNS server configuration in /etc/resolv.conf (if it is an enterprise environment) or simply ensure that the /etc/hosts file has the appropriate entries.

Please ensure that there are no IP table services, that, if present, they are disabled, or that the proper rules are in place to allow different ports and communications. Please note, Keystone uses the 5000 and 35357 ports.

Please ensure that the ports are listening to all IP addresses or to an external IP address rather than to the 127.0.0.1 or localhost. You can verify this by netstat –ln.

Please ensure that you have proper routing rules and a default gateway in place. The routing table can be checked using the netstat –rn command.