# Revision history [back]

### packstack and remote mysql server

I'm trying to setup openstack using packstack on a fresh centos 7 minimal machine. I have 3 existing mysql servers in a master/slave replication setup for another project that I would like to use for openStack as well. I'm having a heck of a time getting packstack to work though, and i'm likely missing something simple. I haven't been able to get packstack --allinone to work. After chasing down all of the work arounds, the script still dies at the mysql install, so Idecided to generate an answer file and use my existing mysql servers. In the answer file I have set the following:

CONFIG_MYSQL_INSTALL=n
CONFIG_MYSQL_HOST=192.168.1.xxx
CONFIG_MYSQL_USER=cloud
CONFIG_MYSQL_PW=xxxxxxxxxxxxx
CONFIG_KEYSTONE_DB_PW=xxxxxxxxxxxxx (set to same as above password)


I always get:

192.168.1.200_keystone.pp:                        [ ERROR ]
Applying Puppet manifests                         [ ERROR ]

ERROR : Error appeared during Puppet run: 192.168.1.200_keystone.pp
Error: /Stage[main]/Keystone::Db::Sync/Exec[keystone-manage db_sync]: Failed to call refresh: keystone-manage db_sync returned 1 instead of one of [0]


The "cloud" db user has root permissions (double checked to rule that out). Turned the firewall on the db server off to rule that out (although we have 50 other servers connecting to the db machines, so I doubt that could be the issue anyway). Finally, disabled selinux on the controller node and restarted.

Anything i'm missing?