Wiki source code of Getting started: Installing the Requea Platform on your machine

Version 28.1 by Pierre Dubois on 2011/02/25 09:30

3.1	1	= Install the Database server =
1.2	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
15.1	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]]
3.1	10
24.1	11	* Create the requea database: (adapt mysql commands to your environment or your way of doing it):
	12
13.1	13	{{code language="none"}}
17.1	14	mysql -u root -e "create database requea"
13.1	15	{{/code}}
23.1	16
26.1	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)
24.1	18
23.1	19	{{code language="none"}}
	20	mysql -u root -e "create database requea default charset utf8"
	21	{{/code}}
	22
14.1	23
19.1	24	* 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):(((
13.1	25	{{code language="none"}}
19.1	26	mysql -u root -e "grant all privileges on requea.* to requea@localhost identified by 'password'"
13.1	27	{{/code}}
	28	)))
3.1	29
26.1	30	= 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=128M
	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.
	37
	38
	39	Path to Java:
	40
	41	JAVA_HOME=[path to java without bin]
	42
	43	Example for windows XP:
	44
28.1	45	[[image:envvars.png]]
26.1	46
3.1	47	= Download the Requea dysoweb Platform =
	48
4.1	49	Dysoweb is a small OSGi platform created by Requea to build and compose modular Web applications.
	50
3.1	51	Follow these instructions:
	52
11.1	53	* Download and install dysoweb 1.0.19 or greater: [[download dysoweb on OW2 forge>>http://forge.ow2.org/project/showfiles.php?group_id=304\|\|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)
4.1	55
5.1	56	* Unzip or untar the dysoweb-tomcat archive on a directory on your hard drive
4.1	57
5.1	58	* Make sure that you do not have already a tomcat instance running or any program using the port 8080.
	59
7.1	60	* launch tomcat from a command prompt or shell:
5.1	61
6.1	62	on Unix:
	63
	64	{{code language="none"}}
	65	bin/catalina.sh run
	66	{{/code}}
	67
	68	on Windows:
7.1	69	{{code language="none"}}bin\catalina.bat run{{/code}}
	70
8.1	71	* open your favorite browser:
7.1	72
9.1	73	[[http:~~/~~/localhost:8080/dysoweb>>http://localhost:8080/dysoweb\|\|rel="__blank"]]
7.1	74
10.1	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.
16.1	80
22.1	81	[[image:Screenshot2011-01-26at2.24.01PM.png]]
	82
	83
16.1	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
22.1	88
16.1	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
22.1	91	[[image:Screenshot2011-01-26at2.25.23PM.png]]
16.1	92
17.1	93	= Configure database connexion =
16.1	94
17.1	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
25.1	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
22.1	108	[[image:Screenshot2011-01-26at2.30.01PM.png]]
17.1	109
19.1	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")
17.1	111
	112
	113	The database will be created. It may take some time.
	114
22.1	115	Once this is done, you should have a fully functional Requea platform with a sample room reservation application.
17.1	116
22.1	117
	118	== Trouble shoot: ==
	119
18.1	120	* 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:
17.1	124	Make sure that you have entered the proper "grant all" order, and that the password is correct.

Wiki source code of Getting started: Installing the Requea Platform on your machine

Quick Links

My Recent Modifications