Can't Install on Digital Ocean without an SSH Key

[jaschwar]

I used the following link, http://installer.71m.us/install?url=https%3A%2F%2Fgithub.com%2Fchurchio%2Fonebody with defaults 1G memory and region as NY 3.

It failed for my four times in the same manner -- failing to install mysql.

Please help me in recovering or make changes so this will work.

Here is screen shot of console:

[mattt416]

Tried this 2x, first time the instance built, second time it failed as per the above screenshot. Had to hop into a meeting so didn't have time to investigate further.

[seven1m]

Interesting, I'll take a look soon.

[jaschwar]

It's been a week any update?

Thanks,
Jesse
On Tue, Dec 2, 2014 at 6:27 PM Tim Morgan [email protected] wrote:

Interesting, I'll take a look soon.

—
Reply to this email directly or view it on GitHub
#349 (comment).

[seven1m]

So sorry guys. I'm still trying to figure this one out. Seems to be a problem with DigitalOcean's MySQL package installer.

[seven1m]

I just ran this twice and it worked fine.

Perhaps this was a temporary problem with DigitalOcean's package...

@jaschwar can you try it again?

[jaschwar]

Failed again for me here is a screenshot

Is there any other logging available either from DigitalOcean or on your side?

Seems to be having problems with DigitalOcean's MYSQL installer. I have tried 3 times without success seems to be same issue.

[seven1m]

Check in /var/log/cloud-init-output.log.

[juddey]

Today I've spun up four successful instances of OneBody on DO. Two were on SGP1, the other two were on NYC3. We're having some trouble replicating this issue. 😞.

A thought: I've seen DO re-use the same IP address (which presumably means the same VPS...?), so perhaps its just a problem with this particular instance.

@jaschwar - what do you think?

pinging @mattt416, perhaps we can have a convo over IRC at some point as to some possible solutions...?

[juddey]

Hey @seven1m, @mattt416 and I have been doing some more with this today.

I spun up another two droplets on NYC today under my DO account. No problems, both ran to completion.

Then I created a _brand new_ DO account with another email address I had, and tried using that. I was able to replicate the problem on two new droplets. The failure was the same as jaschwar's.

Then I added my SSH key to the brand new account, re-ran the installer, and the build completed successfully.

I presume your account has SSH keys on it too @seven1m, and this is why we have been unable to replicate the problem. I've had this key on my account in all the testing I have ever done of the installer (even back in the early tests). mattt416 doesn't have SSH keys, and his are failing.

@mattt416 also gave it a try on his DO account, and it failed. Heres the log from his failure:

<mattt> adduser: `/usr/bin/chfn -f MySQL Server mysql' returned error code 1. Exiting.
<mattt> root@OneBody:/var/log# /usr/bin/chfn -f MySQL Server mysql
<mattt> chfn: user 'Server' does not exist
<mattt> i'm assuming it should be
<mattt> root@OneBody:/var/log# /usr/bin/chfn -f "MySQL Server" mysql

Might be a wild goose chase, but its the only current goose I can see 😄 HTH!

[seven1m]

@X-Light you are a genius!!! Thanks @mattt416 for your help!!

I don't understand why (not) having an SSH key matters, but I should definitely update the DO Installer to instruct the user to add an SSH key.

Wow thanks guys! 😺

[juddey]

No problem @seven1m. I don't get it either (SSH vs. no SSH key), but hey, if it works then lets roll with it and see how it goes.

[jaschwar]

Once I followed the instructions on digital ocean to create ssh key, and added, creating droplet worked. Otherwise failed. I'd be happy to delete ssh-key and retry once a fix in the DO installer is in place to handle not having an ssh key. Thanks for all your help!

[bonpixel]

+1 for didn't work w/o ssh key, works with ssh key.

Thanks for the help!

[theskyfloor]

Can y'all give me tip on this... I have SSH keys installed on my DO account but it still won't let me install using the tool - says that the user OneBody doesn't have access to the key... I just tried this again and SSH'd in after droplet creation to try and grant extra permissions/privileges and still got an error. Please help.

[theskyfloor]

I just installed it manually. It was far easier than the one click installer : (

[seven1m]

I've opened an support issue with DigitalOcean. They were able to reproduce this problem with a simple CloudConfig of just:

#cloud-config
packages:
- mysql-server

(Bypassing the DO-install-button app entirely.)

They're investigating further at this time.

[seven1m]

DigitalOcean gave me this response:

Our engineers looked into this and have discovered the problem is due to the requirement to change your root password on first login when using a password over a SSH key. We came up with a work around of setting the root password in the cloud-config

We're working on finding a better answer for you but someone else in our community has found this problem as well - https://www.digitalocean.com/community/questions/forcing-to-change-password-when-using-api

[seven1m]

I changed the installer so it now does a ahead-of-time fail with a helpful error message if the DO account has no SSH keys. The error page also gives links to guides showing the user how to add an SSH key to their account.

I think this is the best we can do given that an SSH key is absolutely required.