EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Web browser access to Dashboard  XML

Forum Index » Postgres Enterprise Manager
Author Message
Terry_Schmitt

Member

Joined: 19 Mar 2010 17:33:19
Messages: 34
Offline

I attended the web seminar today on PEM and it was demonstrated that you could access the Dashboard via a web browser, in this case Chrome.
I cannot see any way to authenticate using this method.
I attempt to use the URL as demonstrated: http://<hostname>:8080/pem/web/, but receive the error "Username not specified or session expired."

What is the trick to using a web browser instead of the PgAdmin-based UI?

Thanks,
Terry
Robert_D

Member

Joined: 13 Jun 2011 14:35:50
Messages: 13
Offline

What version of the PEM server are you running? If it's 2.0.0, try upgrading to 2.0.2. I believe this feature was added in version 2.0.1, and the upgrade process is very easy.

Keep in mind that you will only be able to see the dashboards and analysis features that pull from the PEM database. You won't be able to see the PgAdmin-based features like table data, current sessions, schema structures, etc.

HTH,
Bobby
Terry_Schmitt

Member

Joined: 19 Mar 2010 17:33:19
Messages: 34
Offline

Thanks for the reply.
I did upgrade from 2.0.0 to 2.0.2 today thinking it might be this very exact thing.

Is there anything else that has to be done? I'm just hitting the URL directly from the web browser, but do you have to initiate this from withing pgAdmin/PEM?

Also, what is the intended authentication mechanism for the web?

I have the 2.0.0 docs, I suppose I should download the 2.0.2 docs and see if this is mentioned in there at all.

Thanks,
Terry
Robert_D

Member

Joined: 13 Jun 2011 14:35:50
Messages: 13
Offline

I'm also using 2.0.2 and I'm able to get to the PEM dashboards by hitting a URL directly without going through the PEM client. The only requirements that I'm aware of are to make sure Apache is running on your PEM server and that the PEM Postgres cluster is running. To start the EnterpriseDB version of Apache on Linux you can run this as root:

/etc/init.d/EnterpriseDBApachePhp start

However, it sounds like Apache is running for you since you are getting a web page in PEM. I get the same error message that you do when I try to access a page in PEM before I've authenticated to the server. However, if I go to the following page I get a login prompt and from there I can get to the dashboards (note the trailing slash):

http://<hostname>:8080/pem/

As far as authentication goes, it looks like you have to enter the username for a user on the PEM database. It doesn't appear that a password is required at all, which is a major bug in my mind.

Thanks,
Bobby
Terry_Schmitt

Member

Joined: 19 Mar 2010 17:33:19
Messages: 34
Offline

Thanks Bobby.

Looks like I was going one level too deep. It's running fine for me now.
Accessing via the browser is much better than the tiny window in PgAdmin.

Authentication appears to be working correctly for me. It requires a PEM database password and throws an error if none is supplied.

Thanks,
Terry
test-lab

New member

Joined: 22 Dec 2011 09:51:34
Messages: 1
Offline

We had this same problem on CentOS6 x64. Turned out to be a permissions issue on /tmp/pem.

I ran chmod 777 /tmp/pem to fix it. It's working now.
 
Forum Index » Postgres Enterprise Manager
Go to:   
Powered by JForum 2.1.8 © JForum Team