The lamp charm readme suggested bzr-website does not work.

[Matt Bruzek]

I was writing tests for the lamp charm and I tried to follow the instructions in the README document.

The lamp charm failed to deploy with the error:

shared-db-relation-changed ERROR 1142 (42000) at line 2: INSERT command denied to user 'lamp-user'@'10.0.3.121' for table 'mytodo'

I believe this is related to the SQL commands in mysql_conf:

INSERT INTO `android_todo`.`mytodo` (`mytodo_id`, `mytodo`, `starred`) VALUES (NULL, 'hello this is a sample', '1'), (NULL, 'yes it works!', '0');

My understanding is the first part `android_todo` specifies the database and that is already specified on the mysql client command from the hook.

mysql -h $remote_host -u $myuser --password=$password "$mydatabase" < ./config/mysql_conf

I think you could fix this by changing the SQL command in the mysql_conf file to:

INSERT INTO `mytodo` (`mytodo_id`, `mytodo`, `starred`) VALUES (NULL, 'hello this is a sample', '1'), (NULL, 'yes it works!', '0');

Notice I removed `android_todo`. because the database was already specified in the mysql client call.

Let me know if you need any more information.