|
|
Choosing A Webhost: |
Re: phpPgAdmin problem: msg#01762db.postgresql.general
Advanced authentication means you will be prompted for a user name and password by phppgadmin. You would then enter a standard username/password combination like with psql or any other app, however you need to make sure that your pg_hba.conf file is configured correctly to allow that user to login. (this is how the configuation information is set below) if you don't use advance authentication, you will need to supply a user name and password that you will always use to connect with. In this case you will not be prompted by phpPgAdmin for login information, but you still need to make sure your pg_hba.conf is configured properly to allow that user to log in. in either case, your database should be producing a connection error message that is hopefully being written to a log file somewhere, this will help you figure out why it wont let you authenticate. Robert Treat phpPgAdmin team On Mon, 2002-07-29 at 14:43, Markus Jais wrote: > Hello > > I am using apache-1.3.23 > the browsers are Konqueror 3.0.0 and Mozilla 1 RC3 > > the logfile seems to be empty or I checked the wrong one. > I am new to postgresql. I will check my book > > I get a login screen prompting for username and password > I entered postgres and the linux postword for postgres > but that didn't work > > I thought that I shouldn't get a login screen at all. > > markus > > > On Mon, 2002-07-29 at 19:54, Robert Treat wrote: > > a couple of questions, > > > > which version of apache are you using? > > which browser are you using? > > are any error messages reported back on the screen? > > what error message is produced in your postgres log files? > > > > also you might want to grab an update from the cvs if possible. > > > > Robert Treat > > phpPgAdmin team > > > > > > On Fri, 2002-07-26 at 16:33, Markus Jais wrote: > > > hello > > > > > > I have a problem with phpPgAdmin_2-4-2 > > > > > > my config file looks like this: > > > > > > $cfgServers[1]['local'] = true; > > > $cfgServers[1]['host'] = 'localhost'; > > > $cfgServers[1]['port'] = '5432'; > > > $cfgServers[1]['adv_auth'] = true; > > > > > > $cfgServers[1]['user'] = ''; // if you are not using adv_auth, > > > e > > > nter the username to connect all the time > > > $cfgServers[1]['password'] = ''; // if you are not using adv_auth > > > and a password is required enter a password > > > $cfgServers[1]['only_db'] = ''; // if set to a db-name, only this > > > db is accessible > > > > > > > > > they say that I should not enter a username if I use adv_auth > > > but I can not connect. even when I enter a username and a password > > > nothing happens > > > > > > what I am doing wrong ?? > > > I have > > > postgresql-7.2.1 > > > php 4.2.1 > > > RedHat 7.3 > > > phpPgAdmin_2-4-2 > > > > > > markus > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 6: Have you searched our list archives? > > > > TIP 6: Have you searched our list archives? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: phpPgAdmin problem, Markus Jais |
|---|---|
| Next by Date: | Re: Importing data, Patrick Nelson |
| Previous by Thread: | Re: phpPgAdmin problem, Markus Jais |
| Next by Thread: | Re: phpPgAdmin problem, Devrim GUNDUZ |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |