Changeset 40 for trunk/grails-app/conf/DataSource.groovy

Timestamp:

Oct 29, 2009, 5:46:11 PM (11 years ago)

Author:

keesvb

Message:

changed study and experiment schema, added mysql production database

File:

• trunk/grails-app/conf/DataSource.groovy (modified) (3 diffs)

trunk/grails-app/conf/DataSource.groovy

@@ -12 +12 @@
 // environment specific settings
 environments {
-        development {
+        development {
                 dataSource {
                         dbCreate = "create-drop" // one of 'create', 'create-drop','update'
@@ -18 +18 @@
                 }
         }
-        test {
+    test {
                 dataSource {
                         dbCreate = "update"
@@ -26 +26 @@
         production {
                 dataSource {
-                        dbCreate = "update"
-                        url = "jdbc:hsqldb:file:prodDb;shutdown=true"
+                           //   create a database first called gscf, add a user nmc with password nmcdsp and grant him all rights to nmc_dsp_tno
+                            //  $ mysql --user=root
+                            //  mysql> create database nmc_dsp_tno;
+                            //  mysql> use nmc_dsp_tno;
+                            //  mysql> grant all on nmc_dsp_tno.* to nmc@localhost identified by 'nmcdsp';
+                            //  mysql> flush privileges;
+                            //  mysql> exit
+                            //  $ mysql --user=nmc -p --database=nmc_dsp_tno
+
+                            driverClassName = "com.mysql.jdbc.Driver"
+                            dbCreate =  "update"
+                            username = "gscf"
+                            password = "dbnp"
+                            url = "jdbc:mysql://localhost/gscf"
+
+                        //dbCreate = "update"
+                        //url = "jdbc:hsqldb:file:prodDb;shutdown=true"
                 }
         }