Friday Oct 31, 2008

SSO between SGD 4.4 and PortalServer 7.2

To obtain SSO between SGD server 4.4 version and Portalserver 7.2 version :

1. Install SGD server version 4.4

2. cd /opt/tarantella/webserver/tomcat/5.0.28_axis1.2/shared

3. cat /opt/tarantella/webserver/tomcat/5.0.28_axis1.2/shared//classes/com/tarantella/tta/webservices/client/views/Resources.properties

(imagine the content is abcdefghijkl)

3. run the following command :

root[bash]@megha# java -cp lib/sgd-webservices.jar com.tarantella.tta.webservices.client.views.SgdPasswd --decode abcdefghijkl

output of the above command will be : sgd_trusted_user:Ez---=itxyz


add this to the sgd portlet username/password field ie username will be sgd_trusted_user and password will be Ez---=itxyz


Installing SGD version 4.4

If you already had SGD version 4.3 on your machine and you may want to remove that and install SGD 4.4 version, then follow the following steps :

mkdir /space/ttasys
mkdir /space/ttaserv
chown ttasys:ttaserv /space/ttasys
chown ttaserv:ttaserv /space/ttaserv

add the existing tta users to /etc/passwd file

ttaserv:x:841:841:test:/space/ttaserv:/sbin/sh
ttasys:x:844:841:test:/space/ttasys:/sbin/sh

After this run #pkgadd -d /space/tta-4.40-917.sol-x86.pkg

Websynergy on Oracle

1. Downloaded Oracle 10g XE for windows from www.oracle.com. Install it. I gave SYS/password
2. Access http://localhost:8080/apex -> login as SYS/password
3. Click on Administration -> Database Users -> Create users
Enter username : lportal
password : lportal
Granted all user privileges (except for the DBA checkbox)
4. Go to Oracle sql prompt and run "connect lportal/lportal;" command
5. run the following command "create schema authorization lportal;"

6. Now install websynergy (change the port of websynergy to 6060 in the setup.xml of glassfish so that it doesn't clash with oracle port. ). Start GF V2
7. copy ojdbc14.jar (Download from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html) to glassfish/domains/domain1/lib directory and restart GF V2 again
8. Go to the admin of GF V2 (http://localhost:4848) -> resources -> Connection Pools -> LiferayPool

9. Change to the following properties :
Under "General" Tab :
Datasource Classname : oracle.jdbc.pool.OracleDataSource
Under "Additional Properties" Tab : set the following properties :
username : lportal
password : lportal
URL : jdbc:oracle:thin:@localhost:1521:XE

10. Go to general tab and click on ping. If everything is fine, This should succeed :-)

11. Restart GF V2. This should create the tables and populate all the data into the oracle db.
About

siddeshk123

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today