Hi,
Sorry for the delayed response. As mentioned in my previous update, I tried to install mysql manually under /opt/appscale, but that process turned out to be tedious and it seemed like it will not be easy to do any updates in future if I take that route to install mysql.
Then, while reading online I realized that we can take an AMI snapshot of the appscale VM image at any state (i.e., after installing some custom software). As I am a new EC2 user, I did not know that before otherwise I could have tried that first.
So, I came back to your original solution of pointing DATADIR to somewhere in /opt/appscale, then took AMI image snapshots so that I won't lose mysql installation next time I do 'appscale up'.
I got a new issue now. Once I start my custom appscale AMI instance with 'appscale up', it is giving me following error: [Errno 111] Connection refused
If I switch back to the original appscale ami( ami-0ef4bf66), I don't have issues.
Issue details:
---------------
shell> ssh -i /home/vagrant/.appscale/appscale2bce9326ccab4f11a83b1330249d7551.key -o LogLevel=quiet -o NumberOfPasswordPrompts=0 -o StrictHostkeyChecking=no -o UserKnownHostsFile=/dev/null
root@ec2-[IP address].compute-1.amazonaws.com stdin str: service monit start
stdout buffer: /tmp/tmpHec0ZC
shell> ssh -i /home/vagrant/.appscale/appscale2bce9326ccab4f11a83b1330249d7551.key -o LogLevel=quiet -o NumberOfPasswordPrompts=0 -o StrictHostkeyChecking=no -o UserKnownHostsFile=/dev/null
root@ec2-[IP address].compute-1.amazonaws.com stdin str: monit start -g controller
stdout buffer: /tmp/tmp42cK3X
Please wait for the AppController to finish pre-processing tasks.
Please wait for AppScale to prepare your machines for use.
[Errno 111] Connection refused
A log with more information is available at
/home/vagrant/.appscale/log-4338e1b8-cfbf-41d5-9a2b-9dc63edebb85.
--------------
That log file shows this:
--------------------
stacktrace : Traceback (most recent call last):
File "/usr/local/appscale-tools/bin/appscale", line 61, in <module>
appscale.up()
File "/usr/local/appscale-tools/bin/../lib/appscale.py", line 252, in up
AppScaleTools.run_instances(options)
File "/usr/local/appscale-tools/bin/../lib/appscale_tools.py", line 412, in run_instances
instance_id)
File "/usr/local/appscale-tools/bin/../lib/local_state.py", line 361, in update_local_metadata
role_info = acc.get_role_info()
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 183, in get_role_info
self.server.get_role_info, self.secret)
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 116, in run_with_timeout
function, *args)
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 116, in run_with_timeout
function, *args)
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 116, in run_with_timeout
function, *args)
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 116, in run_with_timeout
function, *args)
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 116, in run_with_timeout
function, *args)
File "/usr/local/appscale-tools/bin/../lib/appcontroller_client.py", line 118, in run_with_timeout
raise exception
error: [Errno 111] Connection refused
exception : error
locale : en_US
tools_version : 2.2.0
platform : Linux-3.2.0-23-generic-x86_64-with-Ubuntu-12.04-precise
message : [Errno 111] Connection refused
runtime : CPython
-------------------
Please note I just added mysql installation to the original appscale ami: ami-0ef4bf66
and created a new ami.
Please let me know..Thanks much.