Getting started: Installing the Requea Platform on your machine (Main.Installation)

1

= Install the Database server =

2

3

Requea supports several databases:

4

5

mySQL 5.0 and above (5.1 and above recommended)

6

Oracle 10g and above

7

Microsoft SQL server 2005 and above

8

9

* For the purpose of this small tutorial , we recommend that you install mysql on your environment if not already done : [[MySQL Install>>platform:Main:MySQLInstall]]

10

11

* Create the requea database: (adapt mysql commands to your environment or your way of doing it):

12

13

14

mysql -u root -e "create database requea"

15

16

17

Note : for UTF8 database, the create order is the following (you should use utf-8 if you plan to have non iso latin 1 characters)

18

19

20

mysql -u root -e "create database requea default charset utf8"

* Give all privileges to the requea user for accessing the requea database. For example (if you get connections problems try 127.0.0.1 instead of the localhost address below):(((

25

26

mysql -u root -e "grant all privileges on requea.* to requea@localhost identified by 'password'"

)))

= Setup environment variables for memory and Tomcat =

31

32

The memory size needs to be adjusted. You shoud define the following variables:

33

34

CATALINA_OPTS=-Xmx784M -XX:MaxPermSize=192M

35

36

note: the max memory size (-Xmx) should be set to 512M as an absolute min, 1024 recomanded, 2048 comfortable if your machine supports.

Path to Java:

JAVA_HOME=[path to java without bin]

42

43

Example for windows XP:

44

45

[[image:envvars.png]]

46

47

= Download the Requea dysoweb Platform =

48

49

Dysoweb is a small OSGi platform created by Requea to build and compose modular Web applications.

50

51

Follow these instructions:

52

53

* Download and install dysoweb 1.0.47 or greater: [[download dysoweb on OW2 forge>>http://download.forge.ow2.org/dysoweb/||rel="__blank"]]

54

Get the tomcat version (the tar version if your platform is Unix, Solaris, AIX or Mac OS X, and the .zip version if you are a Windows user)

55

56

* Unzip or untar the dysoweb-tomcat archive on a directory on your hard drive

57

58

* Make sure that you do not have already a tomcat instance running or any program using the port 8080.

59

60

* launch tomcat from a command prompt or shell:

on Unix:

bin/catalina.sh run

on Windows:

{{code language="none"}}bin\catalina.bat run{{/code}}

70

71

* open your favorite browser:

72

73

[[http:~~/~~/localhost:8080/dysoweb>>http://localhost:8080/dysoweb||rel="__blank"]]

74

75

= Get a configuration key on the REPO =

76

77

The Requea Repository is an OSGi repository hosted at Requea used to manage Requea configurations. Since Requea applications are modular, each configuration describes which bundles (and bundle versions) should be installed on your dysoweb platform. A typical configuration contains the bundles for the platform and several bundles for the application you are installing.

78

79

A key is used to give access to a particular configuration. For the purpose of this tutorial, we will use a demo key which contains the open source dynapage platform and a few demo applications.

80

81

[[image:Screenshot2011-01-26at2.24.01PM.png]]

82

83

84

Right to the auth key input field you have a link to request a key on the requea repo. Register if you have no account, and request a demo key. The Key will be sent to you by email.

85

86

Enter a password for this platform. This password is the dysoweb administration platform. Do put an obvious platform and do not forget it (although there is a way to reset it in case you need).

87

88

89

The platform will show you a list of bundles and products with some version numbers. Click on install and wait until all the bundles are downloaded and installed on your platform. (speed may depend on your network).

90

91

[[image:Screenshot2011-01-26at2.25.23PM.png]]

92

93

= Configure database connexion =

94

95

Once installed, you can go to the following URL:

96

97

[[http:~~/~~/localhost:8080/dysoweb/page>>http://localhost:8080/dysoweb/page||rel="__blank"]]

98

99

100

You will be prompted with a database connexion configuration screen:

101

102

103

NOTE for UTF8 database and mySQL, the JDBC URL is the following:

104

105

jdbc:mysql:~/~/localhost/requea**?characterEncoding=UTF-8**

106

107

108

[[image:Screenshot2011-01-26at2.30.01PM.png]]

109

110

If you have left database name by default, the only thing you have to do is to enter the mySql daatabase password (the one you entered when typeing 'grant all privileges on requea.* to requea@localhost identified by "password")

111

112

113

The database will be created. It may take some time.

114

115

Once this is done, you should have a fully functional Requea platform with a sample room reservation application.

== Trouble shoot: ==

* to change database configuration, go to the following URL:

121

[[http:~~/~~/localhost:8080/dysoweb/config?op=init>>http://localhost:8080/dysoweb/config?op=init||rel="__blank"]]

122

123

* HTTP Status 500 - Unable to retrieve user information: org.hibernate.exception.SQLGrammarException: could not load an entity:

124

Make sure that you have entered the proper "grant all" order, and that the password is correct.

125

126

* Tomcat not starting (port already in use). Make sure that ports 8080, 8005, 8009 (default tomcat ports are free). If not, change them in the server.xml in tomcat/conf directory.

127

128

* OutOfMemory exception: make sure you have configured your JAVA_OPTS correctly (with enough memory in the -Xmx setting)

129

130

131

= Build the platform =

== Build Dysoweb ==