Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id F06689FB311 for ; Fri, 10 Nov 2006 21:18:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 08317-08 for ; Sat, 11 Nov 2006 01:17:35 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.230]) by postgresql.org (Postfix) with ESMTP id 7ADCB9FB32B for ; Fri, 10 Nov 2006 21:17:33 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so619087wxd for ; Fri, 10 Nov 2006 17:17:32 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=Gvmgf4q0H1w8p44b8fguEWnIBwlStyO+MNAYWZU1hYI8olnIoOwraPAZm0SsDVUDbkCup28XaOswnHMA7+083O4v397wFE0y5n29CrThXaN9jC5T/LAJ5NN25eSLVhFovVXI0nxXeLzcaelPP0BmyAGggA3k7CNTsik80ysk7cU= Received: by 10.90.54.20 with SMTP id c20mr2160627aga.1163207852093; Fri, 10 Nov 2006 17:17:32 -0800 (PST) Received: by 10.65.249.11 with HTTP; Fri, 10 Nov 2006 17:17:31 -0800 (PST) Message-ID: <7b872b430611101717s1adafc50o207f53c19d8da138@mail.gmail.com> Date: Sat, 11 Nov 2006 04:47:31 +0330 From: "Servers24 Network" To: pgsql-php@postgresql.org Subject: Re: PgSQL and integration between 2 PHP programs and a Java program MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_27783_22369054.1163207851968" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/38 X-Sequence-Number: 3655 ------=_Part_27783_22369054.1163207851968 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, First I should thank Brew and Juan for their kind helps :) Now I have good news for you two : CAS supports authenticating the users from a non-LDAP DB server such as MySQL or PgSQL. This way there would be no need to implement a LDAP server for authentication as it can simply read from my main application database tables where it stores users information ( http://developer.ja-sig.org/projects/cas/multiproject/cas-server-jdbc/apidocs/index.html ) So now everything seems to be OK with the first method. Also with the help of DBI-Link I can have my main application write user information to all the connected DBs, tables and fields. The main application will be Liferay Portal ( www.liferay.com ). It's a Java program and it can also be implemented using PgSQL database. I don't really know how this DBI-Link works, but the way Juan said, maybe I can have Liferay write user information to a PgSQL DB and have DBI-Link propagates the data (username, password, first_name, last_name, city, state, country, zipcode and ... ) inside Liferay's DB to all appropriate DBs. Also I will disable ANY modification to the above mentioned fields in other applications so that a user need to change for e.g his name in Liferay, and then it will take effect in other applications as well. So in this method, I will use a PgSQL server with 2 databases ( one for DBI-Link and one for Liferay ) and a MySQL server with maybe 10 databases for other applications. In this case, CAS will read authentication information from Liferay DB in PgSQL. Any comments or ideas ?! -- Warm Regards, Amir ------=_Part_27783_22369054.1163207851968 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi,
 
First I should thank Brew and Juan for their kind helps :)
 
Now I have good news for you two :
CAS supports authenticating the users from a non-LDAP DB server such as MySQL or PgSQL. This way there would be no need to implement a LDAP server for authentication as it can simply read from my main application database tables where it stores users information ( http://developer.ja-sig.org/projects/cas/multiproject/cas-server-jdbc/apidocs/index.html)
 
So now everything seems to be OK with the first method. Also with the help of DBI-Link I can have my main application write user information to all the connected DBs, tables and fields.
The main application will be Liferay Portal ( www.liferay.com ). It's a Java program and it can also be implemented using PgSQL database. I don't really know how this DBI-Link works, but the way Juan said, maybe I can have Liferay write user information to a PgSQL DB and have DBI-Link propagates the data (username, password, first_name, last_name, city, state, country, zipcode and ... ) inside Liferay's DB to all appropriate DBs.
Also I will disable ANY modification to the above mentioned fields in other applications so that a user need to change for e.g his name in Liferay, and then it will take effect in other applications as well.
So in this method, I will use a PgSQL server with 2 databases ( one for DBI-Link and one for Liferay ) and a MySQL server with maybe 10 databases for other applications. In this case, CAS will read authentication information from Liferay DB in PgSQL.
Any comments or ideas ?!


--

Warm Regards,
Amir
------=_Part_27783_22369054.1163207851968--