Menu
▾
▴
phppgadmin-help
|
From: SourceForge.net <no...@so...> - 2004-01-17 06:12:31
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=2379407 By: nobody I keep getting the "login failed" message. I have checked the steps listed in the FAQ and everything is ok. (No error messages in the log, pg_hba.conf set up correctly, socket is open.) I'm not sure what else to try. I'm running phpPgAdmin 3.2.1 on PostgreSQL 7.4 and PHP 4.3.4. Any suggestions? ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2004-02-29 15:40:07
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=2448081 By: nobody I have: Fedora Core 1 phpPgAdmin 3.2.1 and phpPgAdmin 3.3 postgresql 7.3.4 pg_hba.conf host all all 0.0.0.0 0.0.0.0 trust local all all trust config of phpPgAdmin: // Example for a second server $conf['servers'][1]['desc'] = 'cenik'; $conf['servers'][1]['host'] = '127.0.0.1'; $conf['servers'][1]['port'] = 5432; $conf['servers'][1]['defaultdb'] = 'cenik'; I have problem with loging. There are no messages in postgresql log. With psql I can log normaly. Please help me. Thank you. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-23 21:06:09
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4118676 By: nobody I am receiving the login failed message. I double checked the pg_hba.conf file and cannot see any problem. I have phppgadmin installed on the same server as my postgresql install. I am able run simple web php script to connect and query the database. I am also to login into the shell client with user/pass. This is the line from pg_hba.conf I think should work to allow phppgadmin access: host all all 127.0.0.1 255.255.255.255 md5 I also have checked my log files. I don't see any log messages when using phppgadmin. Although I can verify the log is working because I can see messages when I use my php script or local shell client. But there is nothing from phppgadmin. When I can't login it comes back so quickly it doesn't even seem that it tried.... any help would be greatly appreciated. Thank you, Andrew ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-23 23:08:36
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4118850 By: nobody If got the same problem. With PostgreSQL 8.2 the tcpip_socket parameter in the postgresql.conf file doesn't work anymore. But the listen_addresses parameter also had no effect. Stil "login failed". I have tried all the solutions mentioned in de FAQ, but no effect. Has anybody a solution/work around? Thanks, Marco ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-24 21:05:02
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4120631 By: nobody Same problem here... I have two servers, one with "md5", the other one with "trust", both fail. I tried Unix sock and tcp/ip localhost. Same result. I turned on postgres debugging, no phppgadmin related info showed up. $conf['extra_login_security'] = false; This only happens on version 4.1. I tried version 3.5.x, it works just fine. Please help. Thanks! ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-26 22:10:43
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4124639 By: javierwilson which version of postgresql do you have? i have this problem when i use phppgadmin 4.1 with postgresl 8.2.1 but no with postgresql 8.1. also theres is problem with classes/database/Postgres81.php and classes/database/Postgres82.php line 86 reads: $clause = " AND pu.usename='{$username}'"; but should read: $clause = " AND pr.rolname='{$username}'"; ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-26 22:14:41
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4124643 By: javierwilson it seems like phppgadmin tries to connect to template1, and get: psql: FATAL: permission denied for database "template1" DETAIL: User does not have CONNECT privilege. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-27 12:47:49
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4125160 By: nobody I'm trying too use phppgadmin 4.1 with postgresql 8.2.1. I change the line Javier suggested in the Postgres82.php file but that had no effect, sadly. Still searching... Marco ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-01-30 06:36:28
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4128619 By: nobody Encountered this error too Please help............ searching to a web have no luck for answer :( Macoy ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-02 13:43:35
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4136020 By: xzilla It's worth pointing out that at least some of you are having different troubles than the others (the OP for instance was not running on 8.2) Also if you look on the demo server you can log in to the 8.2 instance, and all of it is pretty default, so that should work. For Javier, I would suggest either changing the defaultdb parameter in the phppgadmin conf file, or granting access to template1 for your user. For Marco, we need some more information... which user are you trying to connect with? what error message do you see in your postgresql.conf? ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-06 17:03:41
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4142171 By: nobody I have the same problem with postgres 7.2.1 + PgAdmin 4.1 and i'm 100% sure the config is ok since I can connect with pgsql -h <host> -U .... will try to downgrade PgAdmin. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-07 06:23:08
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4143015 By: xzilla um? pgadmin? do you mean phppgadmin? they are different. also just becuase you can log in with psql doesn't mean that you can log in with phppgadmin, for instance phppgadmin runs as your web server user in the operating system, so unless your logging in as "nobody" (or whoever your webserver runs as) connecting via psql is not the same thing neccessarily. Better information would be what error does phppgadmin give you, and what error do you see in your postgresql logs when you connection fails? oh, and 7.2.1 is ancient man! not to mention unsupported by the postgresql developers... you really ought to upgrade. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-08 09:20:04
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4146644 By: nobody of course I mean phpPgAdmin and yes i log from a different server with a different user to the postgresql server manually to be precise : # su - nobody nobody@xxx:~$ psql -h yyy -U zzz -d xxx Password: Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit xxx=> SUCCESS! but phpPgAdmin fails with message no other message than 'login failed' and apparently it doesnt even try to connect to the postgresql server (nothing logged and tcpdump just told me) so I guess it's not postgres fault. I know 7.2 is way too old, but that's a requirement here, and it's advertised to work, no ? if not, i will reconsider. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-08 10:17:14
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4146743 By: nobody It works with phpPgAdmin 4.0 so I guess a problem was introduced in 4.1 I can't find where though ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-09 18:42:54
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4149526 By: xzilla > of course I mean phpPgAdmin :-) > and yes i log from a different server with a different user to the > postgresql server manually > to be precise : > # su - nobody > nobody@xxx:~$ psql -h yyy -U zzz -d xxx > Password: > Welcome to psql, the PostgreSQL interactive terminal. Interesting. Does it work if you set the defaultdb param in phppgadmin to xxx ? > but phpPgAdmin fails with message no other message than 'login failed' > and apparently it doesnt even try to connect to the postgresql server > (nothing logged and tcpdump just told me) so I guess it's not postgres > fault. Your sure it's a login failed and not the super user security failure? (doesnt sound like it, but worth verifying). Try removing the @ in libraries/adodb/drivers/adodb-postgres64.inc.php round line 655 and see if you can get a better error message from php. > I know 7.2 is way too old, but that's a requirement here, and it's > advertised to work, no ? > if not, i will reconsider. It's advertised to work only because I don't know of any reason why it wouldn't work, but I don't have a 7.2 to test against (couldn't get it to run on recent slackware). Given 7.2 is not support by the postgresql developers... > It works with phpPgAdmin 4.0 so I guess a problem was introduced in 4.1 > I can't find where though Hmm... the two suspicious items that jump out are the change to send encrypted passwords and support for ssl. You might be able to dig around there and find something, but getting a better error message from php would probably be more helpful. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-11 15:44:40
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4151461 By: nobody When I remove the @ in libraries/adodb/drivers/adodb-postgres64.inc.php on line 655 I get the following error: Warning: pg_connect(): Unable to connect to PostgreSQL server: could not create socket: An address incompatible with the requested protocol was used. (0x0000273F) . in ..\libraries\adodb\drivers\adodb-postgres64.inc.php on line 655 Question is: why couldn't it create a socket?? Address incompatible with the requested protocol??? Marco ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-11 16:43:03
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4151525 By: nobody Okay, I found an answer. In the config file there is a line: $conf['servers'][0]['sslmode'] = 'allow'; I had to set the sslmode to: $conf['servers'][0]['sslmode'] = ''; to make it work. I can't explain it, but is works. I hope this helps some of you too. Marco ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-02-21 23:19:41
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4171643 By: nobody Ok! Thanks!! Felipe ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-03-07 13:52:27
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4195078 By: patc890 What config file is "sslmode" in? I see in the "TODO" file a line that says "Add sslmode to connection variables" Pat ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-03-07 14:42:03
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4195152 By: xzilla look in conf/config.inc.php in your phppgadmin directory ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-04-02 18:18:07
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4240118 By: javierwilson I got login failed on any server with postgres 8.2.x I finally solved this, I entered: GRANT CONNECT ON DATABASE template1 TO public; on the server I was trying to connect to. I starting getting this problem with postgresql 8.2.x and phppgadmin 4.1.x, maybe the upgrade process was the problem, I don't know. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-06-07 11:46:04
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4349913 By: nobody Hi, I am having a very peculiar problem. We have two identical servers. What I mean is the have the same hardware resources and have the same operating system (SLES 10). I installed on postgres 8.1.4 on both machines and phpPgAdmin 4.1.2. Both have the same data and same users with the same passwords. One machine acts as stand by. On one machine (othello), I was able to login using phpPgAdmin and do all the usual stuff. But on the standby machine (hector), when I tried to login using phpPgAdmin I am getting simple "Login failed" message. There is no entry about this failed login in logs. So, as you suggested in one of the messages above removed the @ in libraries/adodb/drivers/adodb-postgres64.inc.php to get more info. But there is no change in situation. I even copied the pg_hba.conf and config.inc.php from othello to hector and tried again. But it is till the same. I also checked all the php and postgres packages on both machines, they are the same ones. This is really puzzling and have no clue anymore where else to look. Any help is highly appreciated. Cheers, Samatha ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-07-11 12:31:33
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4407599 By: pradeepsamale hello, I have phppgadmin 3.2.1 and phppgadmin 4.1 with Red Hat 9 and postgresql 7.3.2. But when i use phppgadmin3.2.1 it works fine but in phppgadmin4.1. error message "Login Failed". Even I change in config.inc.php and pg_hba.conf to md5 and all tcp/ip numbers. Also i didn't get any log message in log file. I searched each and every forum as well as help but didn't file any answer regarding my problem. If I remove the ssl_mode to #conf['server']['0']['ssl_mode']='' instead of 'allow'. It gives an error message in phppgadmin-4.1. Also i got login in terminal as username 'test' and password as 'test123' it works fine, but not in phppgadmin-4.1 Is any problem in sslmode of phppgadmin. plese help me Thanx in Advance Reagards PRADEEP SAMALE ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2007-10-10 14:34:51
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4561958 By: nobody i have the same error have you resolved it? ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
|
From: SourceForge.net <no...@so...> - 2008-03-07 22:36:32
|
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4823182 By: nobody Hello All, I'm having trouble logging in and think I've tried the suggestions I've seen posted. PostgreSQL 8.2.3 installed on one server, phpPgAdmin 4.1.3 installed on a second (RHEL5) workstation. From the workstation I can connect as the user I'm trying to login as. I'm not seeing any errors on the server in /var/log/pgsql. Any suggestions? Thanks! -- john ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=115884 |
