melmoth@x220:~$ juju status
2012-04-13 12:31:32,709 INFO Connecting to environment...
2012-04-13 12:31:33,442 INFO Connected to environment.
machines:
  0:
    agent-state: running
    dns-name: 192.168.123.4
    instance-id: i-00000028
    instance-state: running
  1:
    agent-state: running
    dns-name: 192.168.123.5
    instance-id: i-00000029
    instance-state: running
services:
  mysql:
    charm: local:oneiric/mysql-118
    relations: {}
    units:
      mysql/0:
        agent-state: install-error
        machine: 1
        public-address: server-41.novalocal
2012-04-13 12:31:33,973 INFO 'status' command finished successfully



Why is mysql's "public-address" set to server-41.novalocal ?

If i log on ubuntu@192.168.123.4 with ssh, i have the following:

#########################
ubuntu@server-40:~$ ping -c 1  server-41.novalocal
PING server-41.novalocal (10.0.0.4) 56(84) bytes of data.
64 bytes from server-41.novalocal (10.0.0.4): icmp_req=1 ttl=64 time=0.056 ms

--- server-41.novalocal ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.056/0.056/0.056/0.000 ms
##########################

The machine i run juju on has access to the 192.168.123.0/24 network (floating ip), but not the the 10.0.0.0.24 (static) one.

This is causing a problem with juju debug-hooks:

melmoth@x220:~$ juju debug-hooks mysql/0
2012-04-13 12:36:35,170 INFO Connecting to environment...
2012-04-13 12:36:35,942 INFO Connected to environment.
2012-04-13 12:36:36,004 INFO Connecting to remote machine server-41.novalocal...
ssh: Could not resolve hostname server-41.novalocal: Name or service not known
2012-04-13 12:36:36,411 INFO Debug session ended.
2012-04-13 12:36:36,411 INFO 'debug_hooks' command finished successfully