I have downloaded phpPgAdmin-4.1.1.zip and unziped it. how do i get it to work for me? where do i place the files and how do i get it to work with internet explorer. Im new to web development so please assist with simple easy to use instructions on how to set it up.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There seems to be a complete lack of documentation for how to start using phppgadmin. Searching through the forums is the only way to find some hints from other peoples experiences and then piece it together by trial and error. I am having the same problem with a debian system. I'm afraid I know almost nothing about windows, so I can't help you there. But just keep searching through the forums and with any luck you'll find enough information to figure out how to get it installed and functional.
I'm currently searching for a commercial software that offers similar capabilities, but at least has complete documentation. If I find one, I'll post a link.
Best of luck.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
um...unzip the files, put them in your webroot, and edit the config.inc.php file as needed. that's pretty much it. if you run into trouble, please post specific questions and we'll try to help out.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm having the same problem. Robert, I think the problem is, we are using Windows. I have unzipped the files, edited the config.inc.php file...now what. Browse to the directory in IE or Firefox...and what?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For people who write these programs:
You must have a clear description of what the program does.
What are the requirements to run this program.
How to install the program on different systems.
How to run the program.
How to deal with the errors.
This program lacks these basic instructions.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Considering the name of this project and its description: "phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server.", anyone with some knowledge about PHP and web-app will anderstand that they have to configure their http server and php installation to make PPA work.
But I am agree with you. We clearly lack documentation, feel free to contribute ! We actually doesn't just lack of doc, but more important, we lack of contributors.
However, I'm not sure our docs would have to explain how to install and configure http server and/or php. These are pre-requist here.
Cheers.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
> anyone with some knowledge about PHP and web-app will anderstand
> that they have to configure their http server and php installation to
> make PPA work.
Uh ... Don't assume that everyone on the planet knows PHP. I don't, and I don't want to. I want a tool to administer my Postgres database, and I DO NOT CARE what language it's written in. I just want it to work. I was hoping to find a list of instructions that said "Here is how you get started", but my hope was in vain. I guess I have to start looking for another solution.
Guys, you can write the greatest program in the world, but if you don't tell people at least how to start it, you have wasted your time. There is an old rule of writing user interfaces: "If the user can't find it, the function's not there." You might want to take note.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry, my last comment was a bit confusing, But I'm not withdrawing.
It wasn't about PHP and I obviously don't expect user to know PHP to use PPA. "knowledge" here was meaning "aware about what it is".
However, I'm 100% agree with you. As I said before, we lack of doc. But we probably not gonna explain how to set up a webserver and PHP: it seems to me it's a bit out of our buisness.
So to answer your question, you need to put the PPA files where your webserver can find them and run them. Optionally, you might need to reconfigure your httpd.
Let say your httpd server is "myhttpd.com" and you dropped PPA's files in its ppa folder, then you will have to point your browser to http://myhttpd.com/ppa
On a side note, we actually care of our users. I'm always happy to help anyone on mailing lists or IRC if I can. We are taking on our personal free time to write PPA and related stuff.
We lack time, we lack contributors, we lack doc.
You might want to have a look on pgAdmin3 if you don't need the "web-app" part of PPA.
Have a good day.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have the same problem than others here. I work always with phpmyadmin on mysql.
To acceed it i just go on my browser an type http://localhost/phpmyadmin.
It seems it's not the same for phppgadmin.
I have installed it using apt-get install phppgadmin on Ubuntu. Install run fine but... after ?
If I go in my browser with http://localhost/phppgadmin nothing append.
Ok I have found a method.
In my install on Ubuntu phppgadmin is installed in /usr/share. I have made a copy of the folder phppgadmin in /var/www/ and all work fine.
I go through another problem What is the username password for the first access ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This question relates more to Ubuntu policy and internal PostgreSQL anderstanding.
Debian (so I guess Ubuntu as well) makes documentation for every package. ou can find it under /usr/share/doc/<package_name>.
As you may already guess, there's Debian doc for phppgadmin as well. You'll probably find everything in your own system here : /usr/share/doc/phppgadmin.
The admin super user under PostgreSQL is postgres. And default policy of Debian is to allow connection only to the system user postgres. You'll probably have to tweak (carrefuly) your /etc/postgresql/<version>/<clustername>/pg_hba.conf to fit your need.
Consider using createuser to create your own first Postgres' user/admin (man createuser).
Is it possible to get phpPgAdmin to connect to a database server using trust authentication for a particular subnet? I've tried editing the phpPgAdmin configuration file to no avail.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, but this really isn't controlled by phppgadmin, it is controlled by your postgres server in the pg_hba.conf file. Please see the Postgres documentation for specifics on that.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have downloaded phpPgAdmin-4.1.1.zip and unziped it. how do i get it to work for me? where do i place the files and how do i get it to work with internet explorer. Im new to web development so please assist with simple easy to use instructions on how to set it up.
There seems to be a complete lack of documentation for how to start using phppgadmin. Searching through the forums is the only way to find some hints from other peoples experiences and then piece it together by trial and error. I am having the same problem with a debian system. I'm afraid I know almost nothing about windows, so I can't help you there. But just keep searching through the forums and with any luck you'll find enough information to figure out how to get it installed and functional.
I'm currently searching for a commercial software that offers similar capabilities, but at least has complete documentation. If I find one, I'll post a link.
Best of luck.
um...unzip the files, put them in your webroot, and edit the config.inc.php file as needed. that's pretty much it. if you run into trouble, please post specific questions and we'll try to help out.
Tou'll probably need to edit pg_hba.conf with something like:
host all all xxx.xxx.xxx.0/24 md5
Depending on your subnets.
I had trouble with that till I figured it out.
I'm having the same problem. Robert, I think the problem is, we are using Windows. I have unzipped the files, edited the config.inc.php file...now what. Browse to the directory in IE or Firefox...and what?
For people who write these programs:
You must have a clear description of what the program does.
What are the requirements to run this program.
How to install the program on different systems.
How to run the program.
How to deal with the errors.
This program lacks these basic instructions.
Well,
Considering the name of this project and its description: "phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server.", anyone with some knowledge about PHP and web-app will anderstand that they have to configure their http server and php installation to make PPA work.
But I am agree with you. We clearly lack documentation, feel free to contribute ! We actually doesn't just lack of doc, but more important, we lack of contributors.
However, I'm not sure our docs would have to explain how to install and configure http server and/or php. These are pre-requist here.
Cheers.
> anyone with some knowledge about PHP and web-app will anderstand
> that they have to configure their http server and php installation to
> make PPA work.
Uh ... Don't assume that everyone on the planet knows PHP. I don't, and I don't want to. I want a tool to administer my Postgres database, and I DO NOT CARE what language it's written in. I just want it to work. I was hoping to find a list of instructions that said "Here is how you get started", but my hope was in vain. I guess I have to start looking for another solution.
Guys, you can write the greatest program in the world, but if you don't tell people at least how to start it, you have wasted your time. There is an old rule of writing user interfaces: "If the user can't find it, the function's not there." You might want to take note.
Sorry, my last comment was a bit confusing, But I'm not withdrawing.
It wasn't about PHP and I obviously don't expect user to know PHP to use PPA. "knowledge" here was meaning "aware about what it is".
However, I'm 100% agree with you. As I said before, we lack of doc. But we probably not gonna explain how to set up a webserver and PHP: it seems to me it's a bit out of our buisness.
So to answer your question, you need to put the PPA files where your webserver can find them and run them. Optionally, you might need to reconfigure your httpd.
Let say your httpd server is "myhttpd.com" and you dropped PPA's files in its ppa folder, then you will have to point your browser to http://myhttpd.com/ppa
On a side note, we actually care of our users. I'm always happy to help anyone on mailing lists or IRC if I can. We are taking on our personal free time to write PPA and related stuff.
We lack time, we lack contributors, we lack doc.
You might want to have a look on pgAdmin3 if you don't need the "web-app" part of PPA.
Have a good day.
Hi Guillaume
I have the same problem than others here. I work always with phpmyadmin on mysql.
To acceed it i just go on my browser an type http://localhost/phpmyadmin.
It seems it's not the same for phppgadmin.
I have installed it using apt-get install phppgadmin on Ubuntu. Install run fine but... after ?
If I go in my browser with http://localhost/phppgadmin nothing append.
Ok I have found a method.
In my install on Ubuntu phppgadmin is installed in /usr/share. I have made a copy of the folder phppgadmin in /var/www/ and all work fine.
I go through another problem What is the username password for the first access ?
Hi nobody ( ;) ),
This question relates more to Ubuntu policy and internal PostgreSQL anderstanding.
Debian (so I guess Ubuntu as well) makes documentation for every package. ou can find it under /usr/share/doc/<package_name>.
As you may already guess, there's Debian doc for phppgadmin as well. You'll probably find everything in your own system here : /usr/share/doc/phppgadmin.
The admin super user under PostgreSQL is postgres. And default policy of Debian is to allow connection only to the system user postgres. You'll probably have to tweak (carrefuly) your /etc/postgresql/<version>/<clustername>/pg_hba.conf to fit your need.
Consider using createuser to create your own first Postgres' user/admin (man createuser).
If the Debian doc is a bit short for you, you will find further documentation about auth here :
- http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html
- http://www.depesz.com/index.php/2007/10/04/ident/
Remember to check your PostgreSQL logs when something is going wrong.
Seasons greating !
Is it possible to get phpPgAdmin to connect to a database server using trust authentication for a particular subnet? I've tried editing the phpPgAdmin configuration file to no avail.
Because phpPgAdmin doesn't handle the authentication itself...phpPgAdmin authentication obviously rely on the PG's backend you want to connect to.
So you have to tune your pg_hba.conf file to do this.
See http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html
Yes, but this really isn't controlled by phppgadmin, it is controlled by your postgres server in the pg_hba.conf file. Please see the Postgres documentation for specifics on that.