Обсуждение: phpPgAdmin problem
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
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? > > http://archives.postgresql.org
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? > > > > http://archives.postgresql.org > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________________________________________ Gesendet von Yahoo! Mail - http://mail.yahoo.de M�chten Sie mit einem Gru� antworten? http://grusskarten.yahoo.de
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?
Hi,
On 29 Jul 2002, Markus Jais wrote:
> I get a login screen prompting for username and password
> I entered postgres and the linux postword for postgres
> but that didn't work
Well, you must use the password that you assigned to "postgres" user using
pg_passwd.
In etc/shadow, you could have an entry as below:
postgres:!!:11723:0:99999:7:::
This means that, postgres user will NOT accept ANY password. IMHO, maybe
this is a better security issue than assigning a passwd to postgres user.
You could disable the password by using passwd command with -l parameter.
This option is used to lock the specified account and it is available to
root only.
> I thought that I shouldn't get a login screen at all.
If so, anyone could access you db :)
Regards and best wished.
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
Web : http://devrim.oper.metu.edu.tr
-------------------------------------
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 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? >> >> http://archives.postgresql.org > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster