PDA

View Full Version : Connecting to 127.0.0.1....



leehagen
10-08-2010, 12:52 PM
HM was fine, for the past few months. But Today it starts telling me it fails to establish connection to 127.0.0.1.

I havent install anything recently, except the normal windows updates. The only thing i did was i am back in England.

Windows 7, PostgreSQL 8.4 .

Many thanks for the help.

Player007
10-08-2010, 06:23 PM
Hi.

I have same problem. It started on Wednesday, two days ago. I started my session as usual, and holdem manager worked, but after 2 hours it stopped working. When I tried to restart it, it told me : ”Failed to establish connection….”. yesterday I did not play, and I hoped that if I restart my computer I would solve problem, but today (Friday) same message. I checked forum for solution, and found post which explains how to update file hosts. When I opened that file, I discovered that there is already that line you said it would solve problem. Here is post of my file “hosts”:

# 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 did not update windows or change anything, it just stopped working in middle of session. I did not shut down computer for days, so configuration is same like many days before when holdem manager worked.

morny
10-08-2010, 11:08 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while its starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it.Do not delete any other files

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


If none of those worked Please reboot and 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

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you wont have access to the hands in the old database but since you cant connect to the database your already in that situation. In the case its not possible to reconnect you can either contact the postgreSQL forums who may be able to help with advanced connection issues or you can reinstall. Ive listed 3 postgreSQL forums below
PostgreSQL Help Forums (http://forums.devshed.com/postgresql-help-21/)
PostgreSQL forum (http://old.nabble.com/PostgreSQL-f759.html)
PostgreSQL - dBforums (http://www.dbforums.com/postgresql/)

1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://rvgsoftware.fileburst.com/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Go to Start > Programs (All Programs) > Accessories > Command Prompt > Right-Click on command prompt and choose Run As Administrator
net user postgres /delete
B) Try installing this version of PostgreSQL - http://rvgsoftware.fileburst.com/Postgres_8.3.9-v1.0.7.exe

if that also fails Please follow step A again and try this version PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)

Player007
10-09-2010, 09:26 AM
OK, thank you for your prompt reply. I managed to solve problem with first step of your advice, when I stopped and then started service.

leehagen
10-09-2010, 02:12 PM
I have tried all the solutions, you listed up there. And it seems like the only way is to uninstall the whole PostgreSQL 8.4 and install the 9.0 instead.
Here the problem occurs, all the hand history is gone... but luckily when i uninstall PostgreSQL 8.4 , i kept the PostgresSQL/8.4/data in my computer.
So is there anyway, i could input the data back into the new PostgreSQL?
Many thanks for your help.

morny
10-09-2010, 09:25 PM
Why do you want to install 9.0, if you just reinstall postgreSQL 8.4 that i linked to in the combo installer it should reinstall and use your data folder and hopefully connect successfully this time

leehagen
10-10-2010, 04:04 AM
But your combo installer is 8.3.
And the first thing it said is
Note: You must install the same version of PostgreSQL the old database was stored in.

Patvs
10-10-2010, 08:30 AM
The combo installer is SQL 8.4.1.
If you saved your old SQL 8.4/data folder, reinstall SQL 8.4.5 (from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)) to the SAME folder and you should be able to connect to your old database and use the old database.

If you want to upgrade to SQL 9.0.1, you will require to reimport all the original handhistories into the new empty database. It's not possible to convert a SQL 8.4.x database to 9.0.x (it IS possible to savely update SQL 8.4.x to SQL 8.4.5)

Also when you install a different version of SQL, install it to a different port.
If you install both SQL 8.4 and 9.0 both to port 5432, you'll have to uninstall one of them first.

leehagen
10-10-2010, 12:35 PM
thats what i did before, i tried to reinstall the 8.4 version first. but i still get the same problem with connect to 127.0.0.1 .... any ideas?

leehagen
10-10-2010, 02:01 PM
When i try to start the server after reinstalling it said
The postgresql-8.4 services is starting......................................
The postgresql-8.4 services could not be started.
The service did not report an error.
More help is avaliable by typing NET HELPMSG 3534
The start command returned an error <2>

morny
10-10-2010, 10:48 PM
Can you try to restart the service again via Control Panel > Administrative Tools > Services and look for PostgreSQL and click start. It will time out after several minutes and give an error. Then go to the event viewer and under applications in there it should give an error message, can you copy and paste those details here or post a screenshot

How to open event viewer in Vista or Windows 7
Event Viewer in Windows 7 | help.artaro.eu (http://help.artaro.eu/index.php/windows-7/essential-windows-7-administration/event-viewer-in-windows-7.html)

leehagen
10-11-2010, 02:23 PM
2010-10-11 18:16:20 GMTFATAL: could not create lock file "postmaster.pid": Permission denied

morny
10-11-2010, 10:33 PM
delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it.Do not delete any other files

Once you delete that restart the postgreSQL service and tell me what the new error is in the event viewer, were hoping it dosent say something like GMT Fatal as thats unfixable.

leehagen
10-12-2010, 06:47 AM
There isnt a file call postmaster...

Patvs
10-12-2010, 07:54 AM
2010-10-11 18:16:20 GMTFATAL: could not create lock file "postmaster.pid": Permission denied



For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

Also try installing a different version of SQL to a different port. Try 9.0.1 to port 5433 (PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)) if that fails try 8.2

leehagen
10-12-2010, 09:04 AM
For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

Also try installing a different version of SQL to a different port. Try 9.0.1 to port 5433 (PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)) if that fails try 8.2

could you please tell me step by step... how to '' Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab. ''

Thanks a lot for your help.

netsrak
10-13-2010, 08:42 AM
FAQ - Hold'em Manager Poker Tracking Software :: Run .exe Files As Administrator (Windows 7 & Vista) (http://faq.holdemmanager.com/questions/129/Run+.exe+Files+As+Administrator+%28Windows+7+%26+V ista%29)

leehagen
10-13-2010, 11:49 AM
it has already been set before. is there anything else i need to do?

morny
10-13-2010, 07:57 PM
Try setting the security permissions for the PostgreSQL folder in Program files.

Right click on the main PostgreSQL folder, choose properties and go into the security TAB, youll see a list of group or usernames in the top pane, select the first one and choose edit. You should see a new popup window quite similar to the previous one, in the bottom pane make sure all the Allow boxes are ticked, then go back to the top pane and select the next user, again make sure all the allow boxes are ticked, repeat this for all the users and click apply when finished. Now try restarting PostgreSQL and let me know what the new error in the event viewer is.

btw i meant the error you dont want to see is: GMT Fatal: No TCP/IP Sockets could be found or something to that effect as this is the unsolvable error

leehagen
10-14-2010, 08:09 AM
thanks a lot!!! now the server is operating .

But now i got another problem....when i opened holdem manager it saids : ''the following error occurred when trying to open the database unable to read data from the transport connection. An existing connection was forcibly closed by the remote host. ''

Patvs
10-14-2010, 04:18 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. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely

leehagen
10-14-2010, 04:50 PM
Thank you so much for all of you who helped me!!!! it is finally working!!!
Thx a lot for the support!!:)