PDA

View Full Version : New Hardrive, New Windows 7, Unable to connect to 127.0.0.1



AZTERROR
08-14-2010, 01:46 PM
Hello. I purchased and have been using HM/OM for about a year now. I recently installed a new hard drive and upgraded from Windows XP to 7. My old hard drive is still in the computer, now as E:

I copied the RVG software and PostgreSQL folders to my new C: I made sure the exe files run as admin, turned UAC off, edited the RUNDLL32 file, uninstalled software security programs, turned off Firewall and Defender, added all of the exceptions recommended in the forums (although I couldn't find out how to add the port in Win7- I don't know if that's important), and rebooted.

The program validates fine, then goes to the "15 days left" activation screen, and activates fine, with the message: "Success". Then, the dreaded "cannot connect to 127.0.0.1" message. I've manually started secondary logon service, but still no luck. I don't even see PostgreSQL listed in "services".

I could do a full uninstall/ reinstall, but I hate to risk losing all my data.

Any advice would be much appreciated!

netsrak
08-14-2010, 02:17 PM
Please download and install postgresql from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).

If you want to use your old postgresql data folder you need to install the same version following this FAQ: FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)

AZTERROR
08-14-2010, 03:39 PM
OK, I uninstalled PostgreSQL, rec'd a message: "The service could not be stopped", then "The service could not be removed", then "The data folder was not uninstalled", then "Uninstall complete".

I found a 8.4 mirror and installed it, but the install procedure didn't look much like your FAQ link, and didn't include the option to unselect "initiate database cluster". But the install finished successfully, and my data folder is still over 1GB, so I assume it's intact.

However, I'm STILL having the same issue. Cannot connect to 127.0.0.1.

Might we try a teamviewer session? I've put so many hours into this problem already!

Thanks!

Patvs
08-15-2010, 02:01 AM
Download SQL 8.3.11 and install it on port 5433.
http://www.enterprisedb.com/join-dev-community.do?fileid=1198

and connect to that instead.

AZTERROR
08-16-2010, 12:09 AM
Thanks. That gets me up and running. When it asked for the database location, and had postgresql>8.3>data as the default, I tried to change it to 8.4 to retain my current data, but I rec'd the message: "Not compatible...", so I left it as 8.3, and now my data from the last 2 years isn't there. Can I somehow change it to access my 8.4 data folder, or am I still going to get the "not compatible" issue?

AZTERROR
08-16-2010, 04:46 AM
Problem solved. Here's my solution for use with clients with this problem:

>Save a copy of C:\HMArchive on your desktop
>Uninstall PostgreSQL 8.x
>Uninstall Holdem Manager
>Reinstall Holdem Manager from Hold'Em Manager Poker Tracking and Analysis Software (http://www.holdemmanager.com)
>Allow the install of PostgreSQL by keeping the box checked when prompted
>Run Holdem Manager
>Click IMPORT
>Select "Import From Folder"
>Navigate to your saved copy of HMArchive and click OK

That's it! It only took me about 15 hours of trial and error to figure this out, and I'm no slouch on the computer, so I hope this saves some other users some time and heartache!:rolleyes:

Patvs
08-17-2010, 01:44 AM
SQL 8.3 and 8.4 are not compatible with each other.
So you did the perfect fix by just reimporting all the hand into the new database which is the best solution.