Ubuntu mysql won't accept remote connections
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
openstack-api-site |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
This bug tracker is for errors with the documentation, use the following as a template and remove or add fields as you see fit. Convert [ ] into [x] to check boxes:
- [ ] This doc is inaccurate in this way: ______
- [ ] This is a doc addition request.
- [x] I have a fix to the document that I can paste below including example: input and output.
We need to correct the userdata for the api-services install to change /etc/mysql/
sed -i 's/^bind-
Failure to do so gives connection refused from the api-workers.
If you have a troubleshooting or support issue, use the following resources:
- Ask OpenStack: http://
- The mailing list: http://
- IRC: 'openstack' channel on Freenode
-------
Release: 0.1 on 2017-10-15 08:38
SHA: 3a85f163cb7433e
Source: https:/
URL: https:/
Changed in openstack-api-site: | |
status: | New → Confirmed |
Actually looks like the issue is in https:/ /git.openstack. org/cgit/ openstack/ faafo/plain/ contrib/ install. sh. Its attempting to do it but however its intending to do it it doesn't work for ubuntu 16.04. Will update if I find a workaround.
if [[ $INSTALL_DATABASE -eq 1 ]]; then FRONTEND= noninteractive apt-get install -y mysql-server python-mysqldb \nbind- address = 127.0.0.1\n" | sudo tee /etc/my. cnf.d/faafo. conf
URL_DATABASE= 'mysql: //root: password@ localhost/ faafo'
if [[ $ID = 'ubuntu' || $ID = 'debian' ]]; then
sudo DEBIAN_
sudo sed -i -e "/bind-address/d" /etc/mysql/my.cnf
sudo service mysql restart
elif [[ $ID = 'fedora' ]]; then
sudo dnf install -y mariadb-server python-mysql
printf "[mysqld]
sudo systemctl enable mariadb
sudo systemctl start mariadb
else
echo "error: distribution $ID not supported"
exit 1
fi
sudo mysqladmin password password
sudo mysql -uroot -ppassword mysql -e "CREATE DATABASE IF NOT EXISTS faafo; GRANT ALL PRIVILEGES ON faafo.* TO 'faafo'@'%' IDENTIFIED BY 'password';"
fi