Hide Forgot
From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050122 Fedora/1.7.5-3 Description of problem: When trying to connect to a server via file -> add server, I get an error stating the below response. An Error occurred: Is the host running on 127.0.0.1 and accepting TCP/IP connections on port 5342? I tried with adding port 5432 to the firewall rules, stopping iptables and disabling selinux, none of the changes improved the situation. I am able to createdb <database> and to psql <database> with success. I cannot connect through this program though. The same user is selected where there is an actual database. I tried this on another computer and had the sam results as indicated above. Version-Release number of selected component (if applicable): pgadmin3-1.0.2-3, postgresql-7.4.7-1.FC3.2, wxGTK2-2.4.2-7, wxGTK2-stc-2.4.2-7 wxGTK2-xrc-2.4.2-7 wxGTK-common-2.4.2-7 How reproducible: Always Steps to Reproduce: 1. Start pgadmin3 2. try to connect to server 3. get error as described above Actual Results: most menu choices were blank, no servers identified in right pane. Could not connect to an existing databae or postgres server in general. I could create or manipulate the database thrugh a command shell Expected Results: Expected to be able to connect to the server and work with or create database and be able to change the properties of the DB Additional info: This is the first time that I have tried this program out. I have used rhdb before with moderate success. The system defaults are the configuration settings, only a user and database created by the user were performed.
Created attachment 110845 [details] this is the ~/pgadmin.log In case this shows errors as to wgy I cannot connect to the server, here it is!
Created attachment 110847 [details] could not edit logging level with program tool .pgadmin3 Using the GUI menu choice, I could not change my logging level to allow debugging mode to log. I was able to change the entry with an editor. The problem is that you select the debugging button on the GUI program. When you click on the OK button, nothing happens.
Created attachment 110850 [details] After enabling debugging logging -pgadmin.log After manually changing the logging options with a test editor, I tried to connect to the server, then change the logging options. This is the logging with debugging enbled. Strange enough, the button selection and pressing OK works now, after the manual entry change.
Referencing this message, the problem is related to TCP/IP socets being set to false in reference to the message listed below. https://www.redhat.com/archives/fedora-list/2004-January/msg05652.html The program seems to react as postgresql does now when trying to use tcp/ip.
You also need to edit pg_hba.conf file to add 127.0.0.1 or your specific IP address and netmask. The program is working now, but not initially. A helpful solution would be to change the error message to point to checking if postgresql.conf has tcpip_socket set to = true. and you have a pg_hda.conf file allowing your localhost or IP address information set.
[package owner's e-mail address gives 550 user unknown - reassigning to extras-orphan]