Failed to est conn to 127.0.0.1

[mmfitter]

Everything has been fine but today while I was playing and HEM was on, my LT abrubtly shut down (think there's something wrong w my battery) and when I re-started, I started getting that 'failed to est connection...' window.

I went to updates and found 2 of those 4 updates we were supposed to uninstall fr a few months back, and uninstalled them. Is this still an issue?

I also found a thread describing how to fix the PHPcode and I already had this at the bottom of my file, making me think this is not the problem:

127.0.0.1 localhost
::1 localhost
************************************************** ****

Please help - Thanks alot -- MM

[Patvs]

Uninstalling two recent Windows updates, is no longer required.


Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe


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

[mmfitter]

Thanks Patvs - I removed the .pid file and I'm now able to log onto HEM, but I still have a log onto PostgreSQL issue. Get no HUD and I tried table finder.

Before I originally posted my problem, I tried to fix it using the steps suggested. One involved going to services, PostgreSQL Database Server (postmaster), log on, then trying to switch to Local System account. That didn't work, so I was instructed to go back to 'This account' and I entered back the account username (that I recorded the first time as instructed).

I had some password issues then I entered postgrespass and that seemed to accept it after pressing apply and ok.

Then I went back to Services and pressed 'start service' and I got the following:

Error 1069 The service did not start due to log on failure.

Thanks - MM

[Patvs]

Try installing a different version of PostgreSQL to a different port number.
If 9.0/9.1 won't install, use 8.2: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)

[mmfitter]

I'm sorry P - I don't understand how to change the port. Still getting the log on error message. How can I find for certain what my password is?

[netsrak]

Standard passwords are postgres, postgrespass and dbpass.

If they don't work: http://faq.holdemmanager.com/questions/82/Password+Issues+%28PostgreSQL%29

[mmfitter]

Sorry guys - I'm not getting anywhere with this. Downloaded PostgreSQL 8.2 (mirror?) - it's not installing correctly. Tried to re-configure the password thing - nothing is working.

Gotta get HEM back pretty soon - playing without the hud is not the same.

[Patvs]

What goes wrong during the installation?

If it doesn't accept any password, delete the postgres user first.
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete'(without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

[mmfitter]

Ok, got PostgreSQL 8.2 downloaded. Now what?

[netsrak]

Try to install it and come back with the errors

[mmfitter]

I'm getting the original ' Failed to est conn 127.0.0.1.'

[Patvs]

Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.


Read: http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

[mmfitter]

Yes, I've been going there since the beginning of the problem. I go there now and when I try to start it says' Windows could not start PostgreSQL Database Srver 8.3 service on Local Computer. Error 1069. The service did not start due to logon failure.

Maybe I jumped the gun a couple of days ago, but once I did get 8.2 to install and I still saw 8.3 in this service window, I deleted 8.3 from my program files. When I ried to re-install 8.3 I keep getting a message that another version installation is not complete yet. So right now it says 8.2 in my program files, but 8.3 in the Local services.

Thanks --mm

[Patvs]

Reboot your computer.
And reinstall 8.2: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)

Or try installing Revo FREE uninstaller, reinstalling 8.3 completely.

[mmfitter]

Ok - uninstalled 8.3 again w Revo and re-booted. Now there are no versions of PostreSQL at all in servces. I have 8.2 in my program files but not sure what to do with it. Thanks

[Patvs]

Download, unzip and install 8.2: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)
using these install instructions: http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

[mmfitter]

Ok, got 8.2 installed and I see it's started in services. When trying to open HEM I get this error message, 'Unable to read data from transport connection. An existing connection was forcibly closed by the remote host.'

[Patvs]

Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

[mmfitter]

I tried to log onto HM today, Monday, and although I got the same error message as the last one, I was bought to the main db log-on window. I was asked to name my new db, and I did so. I was able to start HM afterwards and everything seems to be OK now. Right now I'm importing all my hands and mtts from my HMArchive folder which seems to still be intact.

Thanks for the help -- MM

[agnesrobert]

If failed to est conn to 127.0.0.1 then initially need to check that Mysql process is running in your system or not.. in windows it'called mysqld.exe.
Because of permission & ownership of your zone file, may be it is giving problem and also check chkconfig command..hope with this you can solve it.

[Patvs]

We don't use MySQL.
HoldemManager requires PostgreSQL: http://faq.holdemmanager.com/questions/91/Can%27tConnect%7B47%7DFailedToStartPostgreSQL
http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL