ID3.8 Release 2.0 of the TENCompetence integrative software
Contents
1. Competence Bullding The A Network for Lifelong Competence Development Project no 027087 TENCompetence Building the European Network for Lifelong Competence Development Project acronym Integrated Project TENCompetence Thematic Priority 2 4 10 ID3 8 Release 2 0 of the TENCompetence integrative software Due date of internal deliverable 01 02 2008 Actual submission date 24 04 2008 Start date of project 01 12 2005 Duration 4 years LOGICACMG Revision 0 2 Project co funded by the European Commission within the Sixth Framework Programme 2002 2006 Dissemination Level PP Restricted to other programme participants including the Commission Services Co Restricted to a group specified by the consortium including the Commission an Services Confidential only for members of the consortium including the Commission Services Da Competence Building the European Network For Lifelong Competence Development TENCompetence IST 2005 027087 Building The European Network for Lifelong Competence Development Project I nternal Deliverable Report I D3 8 Release 2 0 of the TENCompetence integrative software Work Package Task Date of delivery Code name Type of deliverable Security distribution level Contributors Authors Partner Contact Person WP Task responsible EC Project Officer Abstract for dissemination Keywords List WP 3 Technical Design amp Implementation of the2. TENCompetence IST 2005 027087 Page 8 12 ne TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software 3 3 Openfire installation amp configuration 1 Run the OpenFire installer After successful installation it shows the Admin console 2 Select Launch Admin to configure OpenFire The default settings can be accepted except for Database Settings Set this to Embedded Database 3 Open the Openfire xml file found in the PCM server software package see section 1 step 5 4 Add an admin username between lt authorizedUsernames gt lt authorizedUsernames gt This has to be a username which is available in the TENC database 5 Make sure the following sections contain the right information relating to the TENC database you want to use lt database gt lt defaultProvider gt lt xdriver gt com mysgl doc Driver lt driver gt lt serverURL gt jJdbc mysgl lt host gt lt port gt tenc lt serverURL gt lt username gt lt username gt lt username gt lt password gt lt password gt lt password gt lt minConnections gt 5 lt minConnections gt lt maxConnections gt 15 lt maxConnections gt lt ConnectionTimeotit gt 1 0 lt connectionl imeout gt lt defaultProvider gt lt database gt lt setup gt true lt setup gt lt jdbcProvider gt lt driver gt com mysql jdbc Driver lt driver gt lt connectionString gt jdbc mysql lt host gt tenc user lt username gt amp amp pa ssword lt passw
3. Use the username root and password admin combination you selected during step 5 Because there is no Default Schema the popup from Figure 4 will be shown next Select Ignore to continue without selecting a schema TENCompetence IST 2005 027087 Page 6 12 TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software MySQL Query Browser 1 2 12 Query Browser Connect to MySQL Server Instance Stored Connection B server Host Fort 3306 Username Password C Default Schema Co Figure 3 connect to MySQL Server Instance Connection Dialog No Default Schema Specified Tou have not specified a default schema for this connection Although it is possible to connect without specitying default schema vou are highly encouraged to do so Piet Stk Co Schema ff Fi l aT aT aT af af aT aT at ataf aT aT aT aTi Do not show this message anymore Figure 4 Connection Dialog No Default Schema Specified Select menu option File gt Open Script and open the full_setup_db sql file from the temporary folder Your screen should look like Figure 3 now After opening the full_setup_db sql script click the green Execute button to create the initial database Note If there is an existing PCM database from PCM v1 0 beta 2 which contains data that must be reused then use the update_db_competencelevel sql script This script will update the database to PCM v1 0 0 TENCompetence IST 200
4. automatically via a wizard e Windows if you are sure you have installed the Java Runtime Environment JRE select tencomp pcm win 1 0 zip In all other cases select tencomp pcm win jre 1 0 zip e Windows installer with JRE tencomp pcm win jre 1 0 exe Windows installer without JRE tencomp pcm win 1 0 exe 2 Unzip the downloaded file to a folder of your personal choice 2 2 Configuration 1 Run tencomp pcm exe from the folder created in installation step 2 2 The PCM client uses a default public PCM server In case you need to switch to a special PCM server select menu option File gt Preferences then set Discovery Server URL to the http address of your discovery server Ask your PCM system administrator for this http address The regular format is http server port TENCDiscovery servers The two figures below illustrate this step TENCompetence IST 2005 027087 Page 4 12 Zs ae I D3 8 Release 2 0 of the TENCompetence Competence integrative software Personal Competence Manager AGS Edit Window Help New ea Chr LA CH mere we peten ce Client it H Save cirl4s All mi T iT T Save All Ctrl Shift s tart using this application Export configuration file Inport configuration file ess Help and learn how to use this application opie Alt Enter Preferences Exit Figure 1 select menu option Preferences Connection Chat Connectio
5. 5 027087 Page 7 12 TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software F MySQL Query Browser Connection root localhost 3306 File Edit View Query Script Tools Window MySQL Enterprise Help o P GO Q Aa Load Search Continue Step Execute i Script 1 Schemata i drop database tenc A 2 2 A A lt Sete See Seer gt information_schema z gt mysql 6 create database if not exists tenc DEFAULT CHARACTER SET utf amp COLLATE utf8_general_ci gt 5 Suse tenc 3 18 CREATE TABLE ratings 11 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT 12 rating FLOAT NOT NULL DEFAULT 9 13 subject VARCHAR 1024 NOT NULL 14 authorname VARCHAR 255 NOT NULL DEFAULT 15 authorurl VARCHAR 255 NULL 16 comment MEDIUMTEXT NULL 17 published DATETIME NOT NULL 18 updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP 19 PRIMARY KEY id 20 INDEX subject_indexl subject 21 22 23 CREATE TABLE status 24 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT 25 name VARCHAR 16 NOT NULL 26 description VARCHAR 32 NULL 27 PRIMARY KEY id 28 29 30 CREATE TABLE folder 31 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT 32 title VARCHAR 1624 NOT NULL Sunt 33 PRIMARY KEY id ibaa Data Definition Statements e 36 CREATE TABLE object_type GD Data Manipulation Statements 37 id INTEGER UNSIGNED NOT NULL AUTO INCREMENT MyS
6. Integrated System Contractual 01 02 2008 Actual 24 04 2008 Revision 0 2 Draft _ Final KI Report Public Harrie Martens OUNL Hubert Vogten OUNL Ruud Lemmers LOGICACMG Roy Cherian University of Bolton Sue Nasiopoulos LOGICACMG Roberto Celle ILABS Arne Koesling UHANN Paul Sharples University of Bolton Phil Beauvoir University of Bolton Michele Dicerto ILABS Ruud Lemmers LOGI CACMG WP3 Ruud Lemmers LOGICACMG Mr M M jek The document explains the installation and configuration steps to set up instances of the PCM client and the PCM server TENCompetence Software installation and configuration TENCompetence Project Coordination at Open University of the Netherlands Valkenburgerweg 177 6419 AT Heerlen The Netherlands Tel 31 45 5762624 Fax 31 45 5762800 ne TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software Table of contents k Modne o sa sxc ca cu eae eves sas ccs ciegeues vaca ca euiepeuies at cscs igezcucstsccsussecensvesteatecesteeecvcs Ze POUND client installatigh amp configuratii ssns a Ak MEV CVA D T E E E E E EAE E N AE E EE A AE E E E A EEE PAA Con E A E E E E E E eandineneeoe nee 3 PCM server installation amp COnfigurration ccccccccccsssssssssssssssssscscccccccccccccccsssssssssssssssccscsccccscssscsssssssseess aly IES CAMA TOM e E aces uenssneacaannaceeaesnacesacenasequbsaasannnaasepsaes vara O SMA Standard Coni raO s
7. LL ot cdg sg Logout paddy Server Manager Server Settings System Properties Below are properties for this server Click the Edit Properties button below to change some of the server settings Some settings can not be changed Language and Time Cache Summary Server Properties Database 3 Server Uptime 3 days 1 hour 2 minutes started Sep 18 2007 4 32 42 PM Logs Email Settings Version Openfire 3 3 2 Server Home C Program Files Openfire Server Settings EERS Server Name nl maa d111175 Server to Server Environment BOTZ St tee JVM Version and Vendor 1 6 0_01 Sun Microsystems Inc Java HotSpot TM Server VM Connection Managers HTTP Binding Appserver jetty 6 1 x Manage Updates OS Hardware Windows XP x86 Registration amp Logi sealants i ai Locale Timezone en Central European Time 1 GMT Resource Policy Offline Messages Java Memory Sw 13 34 MB of 63 31 MB 21 1 used Message Audit Policy Private Data Storage Server Ports Security Settings Interface Port Type Description Server Certificates Compression Settings Alladdresses 5222 B Client to Sener The ee sapere to connect to the server Connections may or may not be encrypted You can update the File Transfer Settings Security settings tor this port The port used for clients to connect to the server using the old SSL method The old SSL method is not an XMPP standard method and will be deprecated in the future You can update the security settings for
8. QL Utility Statements 38 name VARCHAR 32 NULL MySQL Transactional and Locking 39 PRIMARY KEY id Database Administration Statements i D Replication Statements e 42 CREATE TABLE user_role B SQL Syntax for Prepared Statements 43 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT 44 user_name VARCHAR 32 NOT NULL 45 role_name VARCHAR 32 NOT NULL 46 PRIMARY KEY id 47 INDEX user role UKIndexl user name role name 2 Figure 5 full_setup_db sql file For Windows installations move the serverlist xml file in the temporary folder to folder c data af the folder does not exist create it For Linux installations move serverlist xml to a folder that is reachable for the user running the Tomcat process The apache tomcat 5 5 23 webapps TENCDiscovery WEB INF conf server properties file now contains the location file path setting and filename file name for the serverlist xml file Note the file path setting should end with a folder separator After these steps the default configuration for the PCM server is complete Starting and stopping the application is done by standard Tomcat scripts In Windows 1 Running apache tomcat 5 5 23 bin startup bat starts the Tomcat server 2 Running apache tomcat 5 5 23 bin shutdown bat stops the Tomcat server In Linux 3 Running apache tomcat 5 5 23 bin catalina sh startlstop controls the Tomcat server or alternatively the wrapper script
9. eca a on Eaa iaa a a Eseo 3 3 Openfire installation amp configuration esssssssssssssseeeeeteereressssssssssseeererersssssssssssseseerereesssssssssseessseeeeeeereo TENCompetence IST 2005 027087 Page 1 12 xe TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software Version history Editor s 21 04 2008 Arne Koesling UHANN 24 04 2008 Review by Ruud Lemmers Ruud Lemmers LCMG TENCompetence IST 2005 027087 Page 2 12 xe TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software 1 Introduction The TENCompetence software consists to date of several tools but the main ones are the Personal Competence Manager PCM applications This includes the PCM server and the PCM client The server application provides the different services the storage space for learning material and the meeting point for learners The PCM client is the application to make use of those services and provide the learner a combined learning and communication environment for an individualized learning experience The goal of this document is the formal delivery of release 2 0 of the TENCompetence integrative software This internal deliverable is comprised of three parts 1 The second version of the actual software 2 An installation amp configuration guide for the PCM client included in this document 3 An installation amp configuration guide for the PCM server included in this docum
10. ent The software is available on Sourceforge an open accessible online repository hosting only software projects under open source license models at http sourceforge net projects tencompetence The source files for this release have been tagged at the end of January 2008 with label tenc pcm server release 1pOQp0 PCM server and tenc pcm client release 1pOpO PCM client The 1 0 0 label might be unexpected It s because the first release was tagged as 1 0 beta 2 Documentation for the software is available in internal deliverables D3 6 Architecture Design and ID3 7 Final API definitions for the second release as JavaDoc in the source code itself and in the user manual created by the Training work package TENCompetence IST 2005 027087 Page 3 12 xe TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software 2 PCM client installation amp configuration Note the described steps are targeted at installation amp configuration on a Windows system The steps for Linux and Mac systems will differ slightly 2 1 Installation To install the PCM client on a Windows machine take the following steps 1 Download the PCM client software for your operating system from SourceForge http sourceforge net projects tencompetence e Linux tencomp pcm lnx 1 0 tar gz e MAC tencomp pcm mac 1 0 tar gz The following give the choice between a zip file or an installer which installs the product
11. n Connection General fl Help HTTP Proxy settings Note The user name and password are encrypted with a light encryption algorithm Discovery Server URL http 193 145 44 9 38080 TENCDiscovery servers Advanced Use NTLM Authentication Restore Defaults Figure 2 set Discovery Server URL TENCompetence IST 2005 027087 Page 5 12 xe TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software 3 PCM server installation amp configuration This document covers installation and configuration on Windows and Linux systems Installation on Apple machines Mac is not incorporated 3 1 Installation To install the PCM server on a Windows machine take the following steps 1 Download and install the Java Runtime Environment JRE 5 0 Update 6 or a later 5 0 update or a 6 0 version from http java sun com javase downloads index_jdk5 jsp 2 Download and install the Core distribution for Apache Tomcat 5 5 23 or a later 5 5 update from http tomcat apache org download 55 cgi 3 Download and install the MySQL 5 0 41 Community Server or a later 5 0 update from http dev mysql com downloads mysql 5 0 html downloads 4 Download and install the MySQL GUI Tools Bundle for 5 0 from http dev mysql com downloads gui tools 5 0 html 5 Download the PCM server software from SourceForge http sourceforge net projects tencompetence 6 Download the Openfire chat server from http www igni
12. ns Enterprise Logout paddy Server Pagar HTTP Bind Settings Server Settings System Properties HTTP binding allows clients using the HTTP protocol to connect to the server Language and Time Cache Summary y a ees Enabled Clients can connect to this server using HTTP binding Database eo Port 8090 Email Settings SSL Port 8483 ee ings Disabled Clients will not be able to connect with this server using HTTP binding Profile Settings Server to Server Gan Soe External Components Connection Managers Manage Updates Registration amp Login Resource Policy Offline Messages Message Audit Policy Private Data Storage Security Settings Server Certificates Compression Settings File Transfer Settings Search Properties Media Services Media Proxy STUN Settings Openfire 3 3 2 built by Jive Software and the lgniteRealtime org community fea Done but with errors on page T H Local intranet Change HTTP binding port if necessary 10 Restart the Openfire server by clicking stop gt start Openfire QOpenfire 3 3 2 Sep 18 2007 4 32 42 PHM Admin console listening at http nl maa d111175 9090 https nl maa d111175 9091 TENCompetence IST 2005 027087 Page 12 12
13. ord gt lt connectionString gt lt jdbcProvider gt 6 When the necessary changes are completed copy the openfire xml file to Program Files Openfire conf 7 Restart the Openfire server and click Launch admin This will open up a login screen to the Openfire administration website Logon with the user you configured in openfire xml lox penfire 3 3 2 Sep 18 2007 4 32 42 PH Admin console listening at http ml maa d111175 9090 https nl maa d111175 S0S1 Click Launch Admin TENCompetence IST 2005 027087 Page 9 12 ws ee I D3 8 Release 2 0 of the TENCompetence Competence integrative software EE Address http 127 0 0 1 9090 login jsp url 62Findex jsp openfire Administration Console Login screen TENCompetence IST 2005 027087 Page 10 12 xe TEN I D3 8 Release 2 0 of the TENCompetence Competence integrative software 8 In the first screen Server gt Server settings it will show a Server Name If this is an IP address you will need to change it to the publicly resolvable hostname of the server Click edit at the bottom of the page to change the Server name e Openfire Admin Console Server Settings Microsoft Internet Explorer File Edit View Favorites Tools Help Q x A GD pln Lere O Z i a U a Address http 127 0 0 1 9090 index jsp Openfire Administration Console Server BAUS sey feist e Ot ad CTT
14. terealtime org projects openfire index jsp 3 2 Standard Configuration Create environment variables for your Java version In Windows this is done via Control Panel gt System gt Advanced gt Environment Variables gt System Variables Create the system variable JRE_HOME if you downloaded a JRE JAVA_HOME if you downloaded a JDK And assign it the path to the root folder of your installed Java version to this new system variable Example C java jdk1 5 0_11 For Linux installations information on how to do this can be found in your distributions documentation If multiple Java versions are installed it is advised to use a wrapper script around the Tomcat start stop script Unzip the downloaded PCM server file to a temporary folder From the temporary folder copy the TENCServer war and TENCDiscovery war files to your apache tomcat 5 5 23 webapps folder From the temporary folder copy the mysgl connector java 5 0 5 bin jar file to your apache tomcat 5 5 23 common lib folder Run the MySQL Server Instance Config Wizard to set up an instance of MySQL Use the typical installation and accept the defaults Use user root and password admin for the root user account as they are the defaults in the TENCompetence installation files Be aware that there is no default root password for MySQL on Linux systems The root password can be set using MySQL Administrator Open the MySQL Query Browser this shows the screen from Figure 3
15. this port Search Properties All addresses 5223 Client to Server All addresses 5269 8 Serer to Server The port used for remote servers to connect to this server Media Proxy STUN Settings Alladdresses 9090 Admin Console The port used for unsecured Admin Console access All addresses 9091 Admin Console The port used for secured Admin Console access Alladdresses 7777 File Transfer Proxy The port used for the proxy service that allows file transfers to occur between two entities on the XMPP network Alladdresses 8090 HTTP Binding The port used for unsecured HTTP client connections All addresses 8483 8 HTTP Binding The port used for secured HTTP client connections All addresses eta STUN Service The port used for the service that ensures connectivity between entities when behind a NAT SSI SSSR Check Server Name and edit if necessary 9 Click HTTP Binding in the left hand menu and check that it is set to enabled If it is disabled then enable it and change the port number from 8080 to a free port on the server TENCompetence IST 2005 027087 Page 11 12 T N I D3 8 Release 2 0 of the TENCompetence Competence integrative software 4 Openfire Admin Console HTTP Bind Settings Microsoft Internet Explorer File Edit View Favorites Tools Help Q O A A Powe Ker O i w JOS Address http 127 0 0 1 9090 http bindsp 0 is Openfire Administration Console Users Groups Sessions Group Chat Plugi
Download Pdf Manuals
Related Search