<%@ page import="org.opencms.setup.*,java.util.*" session="true" %><%-- --%><%-- --%><% // next page String nextPage = "../../step_4a_database_validation.jsp"; // previous page String prevPage = "../../step_2_check_components.jsp"; boolean isFormSubmitted = Bean.setDbParamaters(request, CmsSetupBean.POSTGRESQL_PROVIDER); %> <%= Bean.getHtmlPart("C_HTML_START") %> Alkacon OpenCms Setup Wizard <%= Bean.getHtmlPart("C_HEAD_START") %> <%= Bean.getHtmlPart("C_STYLES") %> <%= Bean.getHtmlPart("C_STYLES_SETUP") %> <%= Bean.getHtmlPart("C_SCRIPT_HELP") %> <%= Bean.getHtmlPart("C_HEAD_END") %> <% if (Bean.isInitialized()) { %> Alkacon OpenCms Setup Wizard - <%= Bean.getDatabaseName(Bean.getDatabase()) %> database setup <%= Bean.getHtmlPart("C_CONTENT_SETUP_START") %>

<%= Bean.getHtmlPart("C_BLOCK_START", "Database") %> <% if (Bean.getFullDatabaseKey().contains("_jpa")) { %> <% } %>

Select Database

<%= Bean.getHtmlForDbSelection() %>

<%= Bean.getHtmlHelpIcon("6", "../../") %>

<%= Bean.getHtmlPart("C_BLOCK_END") %>

<% if (Bean.getFullDatabaseKey().contains("_jpa")) { %> <% } else { %> <% } %>

<%= Bean.getHtmlPart("C_BLOCK_START", "Database specific settings") %> <% String user = Bean.getDbWorkUser(); //if(user.equals("")) { // user = request.getContextPath(); //} //if(user.startsWith("/")) { // user = user.substring(1,user.length()); //} %> <% //Fixing the Back Button Bug in the next steps. String cnString=Bean.getDbCreateConStr(); if (cnString.indexOf(Bean.getDbProperty(Bean.getDatabase() + ".templateDb"))>0) { cnString=cnString.substring(0,cnString.indexOf(Bean.getDbProperty(Bean.getDatabase() + ".templateDb"))); } %>

	User	Password	Template Db
Setup Connection				<%= Bean.getHtmlHelpIcon("1", "../../") %>
OpenCms Connection			<%= Bean.getHtmlHelpIcon("2", "../../") %>
Connection String			<%= Bean.getHtmlHelpIcon("3", "../../") %>
Database Name			<%= Bean.getHtmlHelpIcon("4", "../../") %>
Create Database	User	Tables	<%= Bean.getHtmlHelpIcon("5", "../../") %>

<%= Bean.getHtmlPart("C_BLOCK_END") %>

<%= Bean.getHtmlPart("C_CONTENT_END") %> <%= Bean.getHtmlPart("C_BUTTONS_START") %>

<%= Bean.getHtmlPart("C_BUTTONS_END") %> <%= Bean.getHtmlPart("C_HELP_START", "1") %> The Setup Connection is used only during this setup process.

The specified user must have database administration permissions in order to create the database and tables. This user information is not stored after the setup is finished. For Postgresql versions before 8.0 you can use "template1"/"template0" databases. For Postgresql 8.0 and newer it is better to use "postgres" database. If you discover problems accessing to the templatedb tipcally a "templatedb is being accessed by other users" try to restart your DBMS or change the templatedb you are accessing. Some tools (i.e. PgAdmin3) are accessing to template1 by default, so turn off that tools. <%= Bean.getHtmlPart("C_HELP_END") %> <%= Bean.getHtmlPart("C_HELP_START", "2") %> The OpenCms Connection is used when running Alkacon OpenCms after the installation.

For security reasons, the specified user should not have database administration permissions. This user information is stored in the opencms.properties file after the setup. <%= Bean.getHtmlPart("C_HELP_END") %> <%= Bean.getHtmlPart("C_HELP_START", "3") %> Enter the JDBC Connection String to your database. <%= Bean.getHtmlPart("C_HELP_END") %> <%= Bean.getHtmlPart("C_HELP_START", "4") %> Enter the Database Name. <%= Bean.getHtmlPart("C_HELP_END") %> <%= Bean.getHtmlPart("C_HELP_START", "5") %> The setup wizard creates the PostgreSql user, the database and the tables for Alkacon OpenCms.

Attention: Existing user, database and tables will be overwritten!

Uncheck this option if an already existing user/database should be used. <%= Bean.getHtmlPart("C_HELP_END") %> <%= Bean.getHtmlPart("C_HELP_START", "6") %> Traditional SQL drivers are well tested and offer a slight performance increase in comparison with JPA driver. Because SQL drivers are specific for each RDBMS they may be not available for some databases.

JPA driver is a new generation driver based on JPA specification (Java Persistence API). It uses modern JPA implementation - Apache OpenJPA which is quite extensible and flexible. <%= Bean.getHtmlPart("C_HELP_END") %> <% } else { %> Alkacon OpenCms Setup Wizard - Database setup <%= Bean.getHtmlPart("C_CONTENT_SETUP_START") %> <%= Bean.displayError("../../")%> <%= Bean.getHtmlPart("C_CONTENT_END") %> <% } %> <%= Bean.getHtmlPart("C_HTML_END") %>