LoginHelp/GuideAbout TracPreferences
WikiTimelineRoadmapBrowse SourceView TicketsSearchDownloads

Database

PostreSQL

We create one database (bootrobot) with two schemas (bootrobot and lakshmi_stdcmp)

CREATE USER bootrobot WITH PASSWORD 'bootrobot';
CREATE USER lakshmi_stdcmp WITH PASSWORD 'lakshmi_stdcmp';

CREATE DATABASE bootrobot
  WITH OWNER = bootrobot
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'en_US.UTF-8'
       LC_CTYPE = 'en_US.UTF-8'
       CONNECTION LIMIT = -1;

CREATE SCHEMA bootrobot AUTHORIZATION bootrobot;
CREATE SCHEMA lakshmi_stdcmp AUTHORIZATION lakshmi_stdcmp;

MySQL

We create two databases (bootrobot and lakshmi_stdcmp)

CREATE USER 'bootrobot'@'localhost' IDENTIFIED BY 'bootrobot';
CREATE USER 'lakshmi_stdcmp'@'localhost' IDENTIFIED BY 'lakshmi_stdcmp';

CREATE DATABASE bootrobot DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE lakshmi_stdcmp DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON bootrobot.* TO bootrobot@localhost;
GRANT ALL PRIVILEGES ON lakshmi_stdcmp.* TO lakshmi_stdcmp@localhost;

The default maximum size of a communication packet is quite small (1MB). It should be increased to at least 16MB.

max_allowed_packet=16M

Oracle

We create two users (and implicitly two schemas)

CREATE USER bootrobot IDENTIFIED BY "bootrobot";
GRANT CONNECT, RESOURCE, ALL PRIVILEGES TO bootrobot;

CREATE USER lakshmi_stdcmp IDENTIFIED BY "lakshmi_stdcmp";
GRANT CONNECT, RESOURCE, ALL PRIVILEGES TO lakshmi_stdcmp;
 

Wichtiger Hinweis:
Diese Website wird in älteren Versionen von Netscape ohne graphische Elemente dargestellt. Die Funktionalität der Website ist aber trotzdem gewährleistet. Wenn Sie diese Website regelmässig benutzen, empfehlen wir Ihnen, auf Ihrem Computer einen aktuellen Browser zu installieren. Weitere Informationen finden Sie auf
folgender Seite.

Important Note:
The content in this site is accessible to any browser or Internet device, however, some graphics will display correctly only in the newer versions of Netscape. To get the most out of our site we suggest you upgrade to the newer browser.
More information

 
© 2005 ETH Zürich | Imprint | 26.09.2007 | Version 0.12
top