PDA

View Full Version : Failed to establish a connection to '127.0.0.1'



Pocket Sixes
06-18-2010, 06:37 PM
Hi, I got this message and saw your "sticky" on the topic, which says:

2: Enter "127.0.0.1 localhost" (without the quotes) at the bottom of the
file, so it looks like this:

PHP Code:
**************************************************
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost
::1 localhost


I got to the hosts file, but there was already a line that read:
127.0.0.1 localhost

Now what do you recommend?

Thanks

_Loki_
06-18-2010, 07:38 PM
FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)

Pocket Sixes
06-19-2010, 01:25 PM
Tried to adjust settings in Norton to "allow" (my version has "allow" option vs. "Permit" option), as suggested in the FAQ referenced by LOKI. It turns out, however, that I have no "postgres.exe" file in PostgresSQL/8.x/bin/

I did find the pg_cti.exe file there, though.


Suggestions?

morny
06-19-2010, 07:23 PM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems) - Windows Firewall / Defender Problems

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ ) Can't Connect / Failed to Start PostgreSQL
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all) PostgreSQL Preserving Old Database
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=8261)

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

Pocket Sixes
06-21-2010, 09:37 AM
Will try suggestions, but just want to check first:

Shouldn't I have a "postgres.exe" file in PostgresSQL/8.x/bin/ ?

Thanks

ps

_Loki_
06-21-2010, 11:13 AM
yes. mine is here:

"C:\Program Files\PostgreSQL\8.4\bin\postgres.exe"

If in 'Folder Options' you have you have the 'Hide Extensions...' box checked it will just be called postgres though

Pocket Sixes
06-21-2010, 03:03 PM
Sorry, I should have completed my whole thought, which is:

If postgres.exe is not there (with or without the .exe extention), can postgres still run?

If it can't run without postgres.exe, then is my only option to just reinstall postgres?

Also, any idea how postgres.exe could have disappeared?

Thanks again

PS

_Loki_
06-21-2010, 05:02 PM
I wonder if Norton didn't 'like' postgres.exe?
I really don't like Norton, but that's maybe unfair of me. Is it possible to disable it totally for a while & reinstall postgresql?

There's a way I do this - removing everything including registry items, but I think you should wait for guidance from the support guys as i don't want to be responsible if it screws up for you :)

morny
06-21-2010, 08:02 PM
Yeah the antivirus probably moved it to your vault, it may have moved other files too so try adding the postgreSQL folder to exceptions and reinstall FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database) and if that doesnt work and it disappears completely uninstall the antivirus and reinstall PostgreSQL again

Pocket Sixes
06-22-2010, 08:43 PM
Ok, so I uninstalled postgresql (what is a postgre?), downloaded the setup package, unzipped the zip file (but didn't go to the desktop?); I double clicked on postgresql-8.3.msi but got the following message:

"Windows installer

This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package. "


Is this because the zip file didn't unzip to teh desktop? If so, how do you make it do that?

PS

_Loki_
06-22-2010, 09:15 PM
Are you sure you unzipped it ?

See fozzy post here:
http://forums.holdemmanager.com/manager-general/16724-installation-package-could-not-opened.html

I haven't had this problem - so that's the best help I can give - I use 7zip & it adds helpful unzip commands to your right-click context menu if you choose the options to display them from within 7zip
[there's a link in fozzys post to the 7zip site]

Pocket Sixes
06-23-2010, 09:16 AM
OK! I unzipped it

now stuck on Service configuration screen. I left password blank but it didn't seem to like that (it didn't create one for me). Do I have a password already?

PS

_Loki_
06-23-2010, 11:21 AM
FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+%28PostgreSQL%29)

Pocket Sixes
07-10-2010, 04:12 PM
Was out of town, but back now. On the service configuration screen, the "dbpass" (I didn't use the quote marks) password did not work;

These were the names in the various boxes:

Account name: PostgresSQL Database Server 8.3
Account name: postgres
Account password: dbpass

Also tried postgrespass as the password

In both cases, I got following message:

"invalid user name specified: logon failure; unknown user name or bad password"

_Loki_
07-10-2010, 04:53 PM
Try this (from the same FAQ) :- FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+%28PostgreSQL%29)

Use any user/pass for PostgreSQL

You can't retrieve your username and password, but you can edit the pg_hba.conf file so any username and password will work.
To edit the pg_hba.conf file, do the following:


Go to C:\Program Files\PostgreSQL\8.x\data, move the pg_hba file to your Desktop and open it with notepad.
Scroll to the bottom and change all md5 references to trust. Save and close the file.
Move the file back to the data folder.
Restart the PostgreSQL service: Control Panel → Administrative Tools → Services


Holdem Maanger and PostgreSQL will accept any password now

Pocket Sixes
07-14-2010, 05:19 PM
Hi Michael,

Forgive me; I am sorry but being just a simple poker player I am getting REALLY confused! I thought I was in the process of reinstalling postgres. If that is correct, why is it listed under my programs files since I previously uninstalled it?

morny
07-14-2010, 08:21 PM
Might be possible you installed 2 versions of 8.3 and 8.4? Try uninstalling it again , maybe it didn't uninstall correctly the 1st time