search

rphillips / deploy-gitorious

Fabric deployment script for gitorious
Apache License 2.0
17 stars 5 forks source link

EC2 Ubuntu 10.04 32bit mysql database creation? #4

Closed thomasballinger closed 13 years ago

thomasballinger commented 13 years ago

EC2 Ubuntu 10.04 32bit from fresh install, using user ubuntu Seems like a problem with the '~' not being expanded? I don't know if there's fabric magic that's supposed to happen, but there's a file called ~ in /home/ubuntu, containing the text: create database if not exists gitorious_production; create database if not exists gitorious_test; create database if not exists gitorious_development;

error message:

... [50.17.222.221] put: configs/database.sql -> ~ [50.17.222.221] sudo: mysql -u root --password='admin' < ~/database.sql [50.17.222.221] out: /bin/bash: /home/ubuntu/database.sql: No such file or direc [50.17.222.221] out: [50.17.222.221] out:

Fatal error: sudo() encountered an error (return code 1) while executing 'mysql -u root --password='admin' < ~/database.sql'

thomasballinger commented 13 years ago

My mistake, appears to be a problem with accessing the repos;

out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-common 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main libmysqlclient16 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-client-core-5.1 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-client-5.1 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-server-core-5.1 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main mysql-server-5.1 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main linux-libc-dev 2.6.32-28.55 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ lucid-updates/main libmysqlclient-dev 5.1.41-3ubuntu12.9 out: 404 Not Found [IP: 10.210.205.172 80] out: Err http://security.ubuntu.com/ubuntu/ lucid-security/main linux-libc-dev 2.6.32-28.55 out: 404 Not Found [IP: 91.189.92.166 80] out: E: Failed to fetch http://us-east-1.ec2.archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.1/mysql-common_5.1.41-3ubuntu12.9_all.d out: P: 10.210.205.172 80]

thomasballinger commented 13 years ago

Doing an apt-get update / apt-get upgrade first fixed this. I don't understand the full implications of running those - should that be in this script?