Cloud Foundry won't create a MySQL service

[ewolff]

After installing Cloud Foundry on a 32bit Xubuntu system I can create a redis service just fine but creating a MySQL services doesn't work.

vmc create-service mysql MyService

results in no error but

vmc services

won't list the service

After

vmc create-service redis AnotherService

the new service is listed.

[Juan L. Negron (negronjl)]

This is how I am installing it from a brand new oneiric system:

#####################################################################################
# Dependency and utility packages
#####################################################################################
apt-get -y install debconf-utils python-software-properties pwgen facter

#####################################################################################
# Global variables
#####################################################################################
# MySQL
MYSQL_ROOT_PASSWORD=`pwgen -N1`
MYSQL_TOKEN=`pwgen -N1`

# DynDNS
USE_DYNDNS="false"
DYNDNS_USERNAME="username"
DYNDNS_PASSWORD="password"
DYNDNS_HOSTNAME="your-cf-hostname.dyndns.org"

# CloudFoundry Server
CF_SERVER_IP=`facter ipaddress`
NATS_USERNAME="natsadmin"
NATS_PASSWORD=`pwgen -N1`
NATS_DEFAULT_PORT="4222"

#####################################################################################
# Add repositories
#####################################################################################
apt-add-repository ppa:cloudfoundry/ppa
apt-get -y update

#####################################################################################
# Preseed variables
#####################################################################################

# Mysql
echo debconf mysql-server/root_password password ${MYSQL_ROOT_PASSWORD}| /usr/bin/debconf-set-selections
echo debconf mysql-server/root_password_again password ${MYSQL_ROOT_PASSWORD}| /usr/bin/debconf-set-selections

# Postfix
echo debconf postfix/main_mailer_type select No configuration | /usr/bin/debconf-set-selections

# CloudFoundry
echo debconf cloudfoundry-server/use_dyndns boolean ${USE_DYNDNS} | /usr/bin/debconf-set-selections
echo debconf cloudfoundry-server/hostname string api.${DYNDNS_HOSTNAME} | /usr/bin/debconf-set-selections
echo debconf cloudfoundry-server-dea/ip string ${CF_SERVER_IP} | /usr/bin/debconf-set-selections
echo debconf cloudfoundry-server/ip string ${CF_SERVER_IP} | /usr/bin/debconf-set-selections

#####################################################################################
# Install CloudFoundry package
#####################################################################################
apt-get -y install cloudfoundry-server

#####################################################################################
# Configure mysql password for cloudfoundry-server
#####################################################################################
sed -i -e "s/ pass:.*/ pass: ${MYSQL_ROOT_PASSWORD}/" /opt/cloudfoundry-server/vcap/services/mysql/config/mysql_node.yml

#####################################################################################
# Configure all of the gateway services to point to the correct cloud_controller_uri
#####################################################################################
cd /opt/cloudfoundry-server/vcap/services
find -type f | grep yml | xargs sed -i -e "s/.*cloud_controller_uri.*/cloud_controller_uri: api.${DYNDNS_HOSTNAME}/"

#####################################################################################
# Restart CloudFoundry
##############################...

[ewolff (eberhard-wolff)]

Hi Juan,

thanks for the reply! I installed CF according to http://cloud.ubuntu.com/2011/08/howto-install-the-cloudfoundry-server-paas-on-ubuntu-11-10/ i.e. with
apt-get install cloudfoundry-server cloudfoundry-client
after adding the PPA. I am confused about the instructions you gave as they are much more complex.

I am installing on Xubuntu 32bit - are you using 64bit? Ubunutu or Xubuntu?

I did try a virgin Xubuntu and installed the software there. The problem persists, however. I will attach the files from that machine as requested.

[ewolff (eberhard-wolff)]

hostname -f :
cloudfoundryadesso
(I am using 127.0.0.1 during the installation and api.vcap.me as target)
hostname -i :
127.0.1.1

adesso@cloudfoundryadesso:~$ facter ipaddress
10.0.2.15

adesso@cloudfoundryadesso:~$ facter fqdn
cloudfoundryadesso.fritz.box