This section describes the steps required in order to properly install and configure the Etics DB (MySQL).

Schema Creation and Data population

In order to create the Etics database and populate the Etics data you have to perform the following steps:

  • Log in into MySQL and create the Etics DB user that will be used by the WebService to access the DB:

  1. mysql -u root -p
  2. GRANT ALL PRIVILEGES ON * .* TO 'etics'@'localhost';

  • Load the Etics DB Schema (can be downloaded from the org.etics.data-model.schema-db-mysql CVS module) and populate the default Etics data

  1. mysql -u etics < eticsDBSchema.sql;
  2. mysql -u etics etics < eticsDBDefaults.sql
  3. mysql -u etics etics < eticsDBData.sql

  • Grant access to the etics DB (from the MySQL prompt)

  1. grant ALL PRIVILEGES on etics.* to 'etics'@'hostname' identified by "password";
  2. grant ALL PRIVILEGES on etics.* to etics identified by "pass";
  3. grant ALL PRIVILEGES on etics.* to etics@localhost identified by "pass";

-- MarianZUREK - 08 Nov 2006

Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r5 - 2006-11-14 - unknown
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    ETICS All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback