Wiki source code of Getting started: Installing the Requea Platform on your machine
Version 25.1 by Pierre Dubois on 2011/02/24 16:19
- Manage
Copy- Actions
Export
Print preview
View Source- Viewers
Siblings
Comments- Annotations
Attachments (6)
History
Information
Show last authors
| 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 | {{code language="none"}} |
| 14 | mysql -u root -e "create database requea" |
| 15 | {{/code}} |
| 16 | |
| 17 | Note : for UTF8 database, the create order is the following: |
| 18 | |
| 19 | {{code language="none"}} |
| 20 | mysql -u root -e "create database requea default charset utf8" |
| 21 | {{/code}} |
| 22 | |
| 23 | |
| 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):((( |
| 25 | {{code language="none"}} |
| 26 | mysql -u root -e "grant all privileges on requea.* to requea@localhost identified by 'password'" |
| 27 | {{/code}} |
| 28 | ))) |
| 29 | |
| 30 | = Download the Requea dysoweb Platform = |
| 31 | |
| 32 | Dysoweb is a small OSGi platform created by Requea to build and compose modular Web applications. |
| 33 | |
| 34 | Follow these instructions: |
| 35 | |
| 36 | * 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"]] |
| 37 | 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) |
| 38 | |
| 39 | * Unzip or untar the dysoweb-tomcat archive on a directory on your hard drive |
| 40 | |
| 41 | * Make sure that you do not have already a tomcat instance running or any program using the port 8080. |
| 42 | |
| 43 | * launch tomcat from a command prompt or shell: |
| 44 | |
| 45 | on Unix: |
| 46 | |
| 47 | {{code language="none"}} |
| 48 | bin/catalina.sh run |
| 49 | {{/code}} |
| 50 | |
| 51 | on Windows: |
| 52 | {{code language="none"}}bin\catalina.bat run{{/code}} |
| 53 | |
| 54 | * open your favorite browser: |
| 55 | |
| 56 | [[http:~~/~~/localhost:8080/dysoweb>>http://localhost:8080/dysoweb||rel="__blank"]] |
| 57 | |
| 58 | = Get a configuration key on the REPO = |
| 59 | |
| 60 | 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. |
| 61 | |
| 62 | 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. |
| 63 | |
| 64 | [[image:Screenshot2011-01-26at2.24.01PM.png]] |
| 65 | |
| 66 | |
| 67 | 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. |
| 68 | |
| 69 | 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). |
| 70 | |
| 71 | |
| 72 | 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). |
| 73 | |
| 74 | [[image:Screenshot2011-01-26at2.25.23PM.png]] |
| 75 | |
| 76 | = Configure database connexion = |
| 77 | |
| 78 | Once installed, you can go to the following URL: |
| 79 | |
| 80 | [[http:~~/~~/localhost:8080/dysoweb/page>>http://localhost:8080/dysoweb/page||rel="__blank"]] |
| 81 | |
| 82 | |
| 83 | You will be prompted with a database connexion configuration screen: |
| 84 | |
| 85 | |
| 86 | NOTE for UTF8 database and mySQL, the JDBC URL is the following: |
| 87 | |
| 88 | jdbc:mysql:~/~/localhost/requea**?characterEncoding=UTF-8** |
| 89 | |
| 90 | |
| 91 | [[image:Screenshot2011-01-26at2.30.01PM.png]] |
| 92 | |
| 93 | 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") |
| 94 | |
| 95 | |
| 96 | The database will be created. It may take some time. |
| 97 | |
| 98 | Once this is done, you should have a fully functional Requea platform with a sample room reservation application. |
| 99 | |
| 100 | |
| 101 | == Trouble shoot: == |
| 102 | |
| 103 | * to change database configuration, go to the following URL: |
| 104 | [[http:~~/~~/localhost:8080/dysoweb/config?op=init>>http://localhost:8080/dysoweb/config?op=init||rel="__blank"]] |
| 105 | |
| 106 | * HTTP Status 500 - Unable to retrieve user information: org.hibernate.exception.SQLGrammarException: could not load an entity: |
| 107 | Make sure that you have entered the proper "grant all" order, and that the password is correct. |