[01:15] <Azendale> marcoceppi: I know this is like a little kid asking "are we there yet?". Do you think you'll get to review my merge proposal (for etherpad-lite) today?
[01:17] <marcoceppi> Azendale: if you're curious of progress, you can check the review queue out, we typically go in order top to bottom (a bunch of old stuff just showed up).  http://manage.jujucharms.com/tools/review-queue
[01:18] <marcoceppi> So if not tonight, then tomorrow
[01:22] <Azendale> marcoceppi: ok, thanks. Psychologically, it's kind of like waiting for a package to to get here. :)
[01:23] <marcoceppi> Azendale: :)
[02:46] <sbbrtn> Just playing around with Juju.  I added a mysql server.  If I expose this, should I be able to connect to it from the internet?  It appears that it only allows connections via relationships.
[02:47] <sarnold> yikes, you're brave to consider exposing mysql to the world :)
[02:47] <Azendale> sbbrtn: what environment are you running on?
[02:47] <sbbrtn> aws
[02:48] <Azendale> sbbrtn: ok, in that case I believe it would (but I haven't used AWS before, so I could be wrong)
[02:48] <sbbrtn> sarnold:  I wouldn't typically expose it to the outside world but just playing around
[02:53] <sarnold> sbbrtn: I didn't see any calls to the 'open-port' juju hook in the mysql charm; I don't think you can directly expose its port by just running "juju expose mysql"
[02:54] <sarnold> sbbrtn: (there is a defined python functio nthat run it, but I don't see it used anywhere: https://bazaar.launchpad.net/~charmers/charms/precise/mysql/trunk/view/head:/hooks/lib/utils.py#L119  )
[02:54] <sbbrtn> sarnold: ok, thanks.  It wasn't opening up the port on my amazon firewall so I figured it wasn't opening..
[02:55] <sbbrtn> sarnold: how do I execute that function from the juju command prompt? juju mysql expose ?
[02:58] <sarnold> sbbrtn: if you're just goofing around, you can juju ssh mysql/0    -- once you're logged in, you can run open-port <mysql port number>   and then connect your machine's mysql to the remote server ...
[02:58] <sarnold> sbbrtn: I'm trying to find if there's anything you have to do once you're logged in to make the 'open-port' command "available" for you to run .. I'm having trouble finding that. :)
[02:59] <sbbrtn> Ok.  Thanks.  I figured there might be a different option short of going in via SSH
[03:00] <sarnold> sbbrtn: this might be the way to get there... https://juju.ubuntu.com/docs/authors-hook-debug.html
[03:00] <sarnold> (it'll fire up ssh too. hehe. :)
[03:00] <sarnold> sbbrtn: it -could- be; if you really wanted this, you could fork the charm and modify one of the hooks to expose the port for you
[03:01] <sbbrtn> not a big deal.  I'm really just playing around to see how Juju works.
[03:01] <sbbrtn> thanks for the help
[03:02] <sarnold> connecting the local mysql client to a remote hosted server would be a fun thing to see. I'd just be afraid to leave it up for very long, who knows how long it'd take before it's discovered and potentially abused. :)
[03:06] <sbbrtn> yeah.  I see why you wouldn't want to expose it.  On my current web server I have multiple MySql instances running.  One is open to the public and is a development database so not too concerned with the contents.  The other two servers are only available via localhost and my VPN if I connect to it via OpenVPN.  I need access to the DB since the updates are made directly to the database and that is the best way I have
[03:06] <sbbrtn> found.  I wonder if this is possible with Juju...
[03:15] <sbbrtn> any way to kill a service after getting a hook failed?  I can't bring it down with destroy-service
[03:27] <marcoceppi> sbbrtn: run `juju resolved <unit>` a few times
[03:28] <marcoceppi> sbbrtn: sarnold it's odd that MySQL doesn't expose 3306. I should have that port "opened" and waiting for juju expose to be run. I'll look in to that
[03:29] <sbbrtn> marcoceppi: Thanks (this is Jason955 from earlier BTW)
[03:29] <marcoceppi> o/
[03:30] <marcoceppi> sbbrtn: if you could open a bug against the MySQL charm that it doesn't expose the default port, I'll have it patched https://bugs.launchpad.net/charms/+source/mysql/+bugs
[03:30] <sarnold> marcoceppi: I dunno, I kind of like the idea that it isn't just easily exposed. it feels like every CPU from oracle includes at least one remote unauthenticated mysql attack. :(
[03:30] <sarnold> marcoceppi: maybe a config option yes-really-expose-my-database   or something? :)
[03:31] <marcoceppi> sarnold: it won't be exposed unless the user really wants it to. What would be a better idea is to have the port configurable and have it use a non-standard port by default (if that was a concern)
[03:31] <sbbrtn> marcoceppi: will do
[03:31] <sarnold> marcoceppi: that'd be a help, but I wouldn't be surprised if mysql advertises itself on its port somehow..
[03:32] <marcoceppi> sbbrtn: feel free to open bugs for any other things you find odd. If you search for the charm in https://manage.jujucharms.com/ you'll find a link for "Bugs" that you can use
[03:36] <marcoceppi> Azendale: Wasn't able to get to your merge tonight, but it's next on the list for tomorrow!
[03:36] <sbbrtn> marcoceppi: will do.  I just got my launchpad account.
[03:38] <Azendale> marcoceppi: Awesome!
[03:38]  * marcoceppi heads to bed
[03:38] <sarnold> g'night marcoceppi :)
[03:42] <sbbrtn> Can I create multiple Mysql instances on different ports with Juju?
[06:04] <davecheney> sbbrtn: possibly
[06:04] <davecheney> but not using the same machine
[06:12] <sbbrtn> There isn't a way to change the port?
[06:20] <davecheney> sbbrtn: there might be
[06:20] <davecheney> didn't you say you wanted to have multiple mysqls ?
[06:23] <sbbrtn> Yes.  I wanted one exposed to the web on a non-default port.
[06:27] <davecheney> sbbrtn: the mysql charm doesn't currently support this, please raise a feature request, https://launchpad.net/charms/+source/mysql
[06:28] <sbbrtn> will do
[06:57] <stokachu> anyone awake that has any insight into the progress of https://bugs.launchpad.net/juju-core/+bug/1233457
[06:57] <_mup_> Bug #1233457: service with no units stuck in lifecycle dying  <cts-cloud-review> <destroy-service> <state-server> <juju-core:Triaged> <https://launchpad.net/bugs/1233457>
[14:23] <jcastro> hey marcoceppi
[16:18] <jcastro> hey evilnickveitch
[16:18] <jcastro> can you index the local troubleshooting page?
[16:18] <jcastro> I am unsure if you're making a new troubleshooting section or putting it somewhere else
[16:22] <evilnickveitch> jcastro, i am making a new section, but i will do it today
[16:23] <evilnickveitch> makes a nice change from trying to reverse engineer interfaces
[16:32] <jcastro> heh