You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@brooklyn.apache.org by he...@apache.org on 2016/02/01 18:46:39 UTC
[09/50] brooklyn-library git commit: tweak web example sql so it is
more portable
tweak web example sql so it is more portable
Project: http://git-wip-us.apache.org/repos/asf/brooklyn-library/repo
Commit: http://git-wip-us.apache.org/repos/asf/brooklyn-library/commit/b67043fa
Tree: http://git-wip-us.apache.org/repos/asf/brooklyn-library/tree/b67043fa
Diff: http://git-wip-us.apache.org/repos/asf/brooklyn-library/diff/b67043fa
Branch: refs/heads/0.6.0
Commit: b67043fa5976690585abc8e7b8ab4f4e739ac193
Parents: 1f31bb0
Author: Alex Heneveld <al...@cloudsoftcorp.com>
Authored: Thu Oct 31 19:48:02 2013 -0700
Committer: Alex Heneveld <al...@cloudsoftcorp.com>
Committed: Thu Oct 31 19:48:45 2013 -0700
----------------------------------------------------------------------
.../src/main/resources/visitors-creation-script.sql | 10 ++++++++--
.../camp/src/test/resources/visitors-creation-script.sql | 10 ++++++++--
2 files changed, 16 insertions(+), 4 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/brooklyn-library/blob/b67043fa/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql
----------------------------------------------------------------------
diff --git a/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql b/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql
index f3bdd4a..e1a1de0 100644
--- a/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql
+++ b/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql
@@ -1,14 +1,20 @@
create database visitors;
use visitors;
-create user 'brooklyn' identified by 'br00k11n';
+
+# not necessary to create user if we grant (and not supported in some dialects)
+# create user 'brooklyn' identified by 'br00k11n';
+
grant usage on *.* to 'brooklyn'@'%' identified by 'br00k11n';
+
# ''@localhost is sometimes set up, overriding brooklyn@'%', so do a second explicit grant
grant usage on *.* to 'brooklyn'@'localhost' identified by 'br00k11n';
+
grant all privileges on visitors.* to 'brooklyn'@'%';
+
flush privileges;
CREATE TABLE MESSAGES (
- id INT NOT NULL AUTO_INCREMENT,
+ id BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(30) NOT NULL,
MESSAGE VARCHAR(400) NOT NULL,
PRIMARY KEY (ID)
http://git-wip-us.apache.org/repos/asf/brooklyn-library/blob/b67043fa/sandbox/camp/src/test/resources/visitors-creation-script.sql
----------------------------------------------------------------------
diff --git a/sandbox/camp/src/test/resources/visitors-creation-script.sql b/sandbox/camp/src/test/resources/visitors-creation-script.sql
index f3bdd4a..e1a1de0 100644
--- a/sandbox/camp/src/test/resources/visitors-creation-script.sql
+++ b/sandbox/camp/src/test/resources/visitors-creation-script.sql
@@ -1,14 +1,20 @@
create database visitors;
use visitors;
-create user 'brooklyn' identified by 'br00k11n';
+
+# not necessary to create user if we grant (and not supported in some dialects)
+# create user 'brooklyn' identified by 'br00k11n';
+
grant usage on *.* to 'brooklyn'@'%' identified by 'br00k11n';
+
# ''@localhost is sometimes set up, overriding brooklyn@'%', so do a second explicit grant
grant usage on *.* to 'brooklyn'@'localhost' identified by 'br00k11n';
+
grant all privileges on visitors.* to 'brooklyn'@'%';
+
flush privileges;
CREATE TABLE MESSAGES (
- id INT NOT NULL AUTO_INCREMENT,
+ id BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(30) NOT NULL,
MESSAGE VARCHAR(400) NOT NULL,
PRIMARY KEY (ID)