Running PH and Database on different servers

[Mike Godsey]

Anders,

I seem to recall either reading or being told that if you do not put a UID
and Password in the dictionary that it will pass through the user
information. This might only be with PW Web. Check with Bob, he would
definitely know the answer.

Mike

 

 

From: powerh-l-bounces+mgo=columbus.rr.com at lists.sowder.com
[mailto:powerh-l-bounces+mgo=columbus.rr.com at lists.sowder.com] On Behalf Of
Birkmose, Anders
Sent: Wednesday, June 16, 2010 09:50
To: powerh-l at lists.sowder.com
Subject: Running PH and Database on different servers

 

Hi all, 

 

For infra structure reasons we have been ask to separate our PH application
and ORACLE Database into two different Linux Redhat servers. 

But there is still a requirement that each User most connect to the ORACLE
Database via PowerHouse with their own user/password.  

 

Currently  we are running on one AIX server, so we uses the OPS$ option from
ORACLE, where the user automatically are granted access, 

as long as they are locally login to the AIX server. 

 

So our issue is, how do we connect via the PH Dictionary to the from PH
application server to another database server, when each user most have
their own user/password in the database. 

 

We don’t want the user to type in user/password each time they should attach
to the database. The users also starts a lot of background job, running in
the own Shells, so where it will not be possible for them to type database
user/password. 

 

One top of everything, we have also been ask to implement AD (Active
Directory), but that is another issue, which brings up a lot of other
challenges.  Right now our focus is on splitting the application and
Database, and still have the users there own database user. 

 

Any suggestion will be appreciated . 

 

Many regards 

Anders 

 


Please help Logica to respect the environment by not printing this email /
Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen
Sie so Logica dabei, die Umwelt zu schützen. / Por favor ajude a Logica a
respeitar o ambiente não imprimindo este correio electrónico. This e-mail
and any attachment is for authorised use by the intended recipient(s) only.
It may contain proprietary material, confidential information and/or be
subject to legal privilege. It should not be copied, disclosed to, retained
or used by, any other party. If you are not an intended recipient then
please promptly delete this e-mail and any attachment and all copies and
inform the sender. Thank you. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100616/c7f9973a/attachment-0001.htm