PDA

View Full Version : trying to get HEM up and running



kaizer1981
03-05-2010, 03:08 PM
hey there, i just had to get my pc serviced - have been trying to reinstall HEM and when i start it i just get the error message "an error occured failed to connect to database...", then i get to the database management page and when i try and create a new database get "a connection to POstgresSQL could not be made" I have my user account switched off, i know its something simple but cant remember what?

fozzy71
03-05-2010, 04:10 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)

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+ )
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+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

kaizer1981
03-05-2010, 09:25 PM
i have tried the complete re install and i get a message saying postgres sql was not installed correctly at the end of the install? it runs the install and i get the message at the end but it takes a minute and writes alot of data.
Another weird thing is that it has created a seperate user account called postgres on my computer, which i deleted and has reappeared since i tries to reinstall postgres.

fozzy71
03-06-2010, 12:20 AM
i have tried the complete re install and i get a message saying postgres sql was not installed correctly at the end of the install? it runs the install and i get the message at the end but it takes a minute and writes alot of data.

Which Operating System, Firewall, and Anti-Virus are you using?

Is windows fully updated?



Another weird thing is that it has created a seperate user account called postgres on my computer, which i deleted and has reappeared since i tries to reinstall postgres.

Remove User Accounts From the Logon Screen in Windows Vista - How-To Geek (http://www.howtogeek.com/howto/windows-vista/remove-user-accounts-from-the-logon-screen-in-windows-vista/)

kaizer1981
03-06-2010, 08:59 AM
I am using windows vista and have it fully updated. I have avast antivirus running, and windows firewall. I have exclusions set up in avast for all postgres program files and in windows firewall. When i look in my c drive in the program files i notice there are postgres files:

8.3-prev-2010-05-Jan-18-53-18 (7.3mb)
8.3 (75mb)
8.4 (0mb)

well when i try an uninstall postgres sql i get a message saying: "error stopping postgressql-8.4" i then click ok and get immediate message "error deleting postgressql-8.4" i then click ok and it runs then uninstall with the progress bar filling up green from left to right, once the progress bar is completely filled i get message:

"The data directory (C:program files/postgresSQL/8.4/data) and service user account (postgres) have not been removed." and followed by "uninstallation completed"

heres the details of the unsuccessful install with both avast and windows security disabled:

Output folder: C:\Program Files\PSQLINSTALL
top level install dir -->C:\Program Files
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: True
test antivirus returned 1
antivirus installed
security center error status: 0
security center status: 4
disabling security center
security center error status: 0
security center status: 1
disabled security center
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgres installdir: C:\Program Files\PSQLINSTALL
==================== running PsqlTestClient
try pass: postgres
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
no existing install dir
wrote testfile
Delete file: C:\Program Files\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\Program Files\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files\PSQLINSTALL
==================== running PsqlTestClient
try pass: postgres
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient

kaizer1981
03-06-2010, 09:31 AM
this is so fuked up,i completely uninstall HEM and postgres, restart my computer after deleting the postgres user account (and the postgres account has not shown up since i deleted it for 3-4 restarts) and boom, there it is again - postgres user account with a password (which i dont know and isnt "postgrespass") - so i cant delete the thing and i cant log into it

kaizer1981
03-06-2010, 10:11 AM
it seems every time i reinstall the software it creates a seperate user account called postgres. I still cannot get the installion to run correctly without the errors listed above. I have the latest version of vista, avast antivirus and windows firewall exemption, user control off, WTF am i doing wrong here, installing this software is tilting me to the point of no return.

Also my C:windows....host file has the path listed correctly and i didnt have to edit it so that was never the problem.

kaizer1981
03-06-2010, 12:26 PM
ok so even though i had avast (which is ok with postgres) installed i uninstalled it and shut down all security on my pc - i ran the combo installer but only chked postgres, at the end end of the install i get :

sorry could not install postgreSQL
installation aborted
-setup was not completed successfully

i have absolutely no clue where to from here, i've tried installing the 8.3 version after using command prompt, no good, i'm seriously lost as to what else i can do to install htis software. please help me :confused:

kaizer1981
03-06-2010, 02:22 PM
latest attempt with everything uninstalled computer rebooted no user control or security, anyone know what any of this code refers to what i need to do to get software to install??

Output folder: C:\Program Files\RVG Software\Holdem Manager
Is admin account
Extract: Acid Library.dll... 100%
Extract: Acid Library.snk
(extract files list removed as message to long...kaizer1981)
Extract: sample.pop... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\Config\AutoRate
Output folder: C:\Program Files\RVG Software\Holdem Manager\Config\PreflopRanges
Extract: Billings Davidson Schaeffer Szafron.txt... 100%
Extract: HU vs Random.txt... 100%
Extract: PokerStove vs 3 Random.txt... 100%
Extract: Sklansky-Chubukov.txt... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\Filters
Extract: Called Flop CBet Raise with Overpair.filter... 100%
Extract: Called Flop CBet Raise with TPTK.filter... 100%
Extract: Called Flop CBet Raise with less than TPTK.filter... 100%
Extract: Calling Flop CBet Raise.filter... 100%
Extract: Defend the Blinds.filter... 100%
Extract: Heads Up on Flop.filter... 100%
Extract: Heads up on Flop No PFR.filter... 100%
Extract: Multiway Flop.filter... 100%
Extract: Multiway Flops No PFR.filter... 100%
Extract: Pocket Pairs.filter... 100%
Extract: Steal Attempt Made.filter... 100%
Extract: Suited Connectors below KQs.filter... 100%
Extract: Unsuited Connectors below KQo.filter... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder
Extract: ABS.txt... 100%
Extract: Everest.txt... 100%
Extract: Ftp.txt... 100%
Extract: IP.txt... 100%
Extract: Manual.pdf... 100%
Extract: OG.txt... 100%
Extract: OG2.txt... 100%
Extract: Prima.txt... 100%
Extract: Stars.txt... 100%
Extract: endscan.wav... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Colors
Extract: avgVPIP... 100%
Extract: pVPIP... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Colors\Backup
Extract: HighVPIP
Extract: Loser
Extract: MaxVPIP
Extract: PFlop
Extract: TCount... 100%
Extract: avg3BET
Extract: avgAF... 100%
Extract: avgBB100
Extract: avgPFR
Extract: avgVPIP... 100%
Extract: avgWHWSF
Extract: avgWSD
Extract: numPlayer
Extract: numShorts... 100%
Extract: numWaitlist... 100%
Extract: p3BET
Extract: pAF... 100%
Extract: pBB100
Extract: pHands... 100%
Extract: pPFR
Extract: pRating
Extract: pScore
Extract: pStack... 100%
Extract: pVPIP... 100%
Extract: pWHWSF
Extract: pWON
Extract: pWSD... 100%
Extract: pWTSD
Extract: tBuddies
Extract: tFriends
Extract: tRating
Extract: tRegulars
Extract: tScore
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Docs
Extract: gettingstarted.htm... 100%
Extract: scanabs.htm... 100%
Extract: scaneverest.htm... 100%
Extract: scanipoker.htm... 100%
Extract: scanparty.htm... 100%
Extract: scanprima.htm... 100%
Extract: scanstars.htm... 100%
Extract: scantilt.htm... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Filter
Extract: All Player.ppf... 100%
Extract: All Tables.fpf... 100%
Extract: Buddies.fpf... 100%
Extract: Buddies.ppf... 100%
Extract: Friends.fpf... 100%
Extract: Friends.ppf... 100%
Extract: HighVPIP.ppf... 100%
Extract: Loser.ppf... 100%
Extract: NoShortStacks.fpf... 100%
Extract: Regulars.ppf... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Images
Extract: abs.png
Extract: ante.png
Extract: cap.png
Extract: deep.png
Extract: empty.png
Extract: everest.png
Extract: ftp.png
Extract: ip.png
Extract: jackpot.png
Extract: none.png
Extract: ongame.png
Extract: party.png
Extract: prima.png
Extract: speed.png
Extract: stars.png
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Scoring
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\Scoring\Backup
Extract: NoLimit.spf... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\filterv2
Output folder: C:\Program Files\RVG Software\Holdem Manager\FishFinder\filterv2\backup
Extract: Buddies.fpf... 100%
Extract: Buddies.ppf... 100%
Extract: Friends.fpf... 100%
Extract: Friends.ppf... 100%
Extract: HighVPIP.ppf... 100%
Extract: Loser.ppf... 100%
Extract: NoShortStacks.fpf... 100%
Extract: Regulars.ppf... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\Images
Extract: Cards0.png... 100%
Extract: Cards1.png... 100%
Extract: Cards2.png... 100%
Extract: Cards3.png... 100%
Extract: Cards4.png... 100%
Extract: Cards5.png... 100%
Extract: Cards6.png... 100%
Extract: Cards7.png... 100%
Extract: Cards8.png... 100%
Extract: Cards9.png... 100%
Extract: NoteBlue.png... 100%
Extract: NoteCyan.png... 100%
Extract: NoteGreen.png... 100%
Extract: NoteGrey.png
Extract: NoteOrange.png... 100%
Extract: NotePurple.png... 100%
Extract: NoteRed.png... 100%
Extract: NoteYellow.png... 100%
Extract: smallicons.png
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing\HEM Data
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing\HUD Data
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing\Import Errors
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing\Logs
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing\Status
Output folder: C:\Program Files\RVG Software\Holdem Manager\Importing\Work Folder
Output folder: C:\Program Files\RVG Software\Holdem Manager\Logs
Extract: Reg.log... 100%
Extract: VersionHistory.txt
Extract: VersionHistory1.08.txt
Output folder: C:\Program Files\RVG Software\Holdem Manager\ReplayerSkin
Output folder: C:\Program Files\RVG Software\Holdem Manager\ReplayerSkin\Default Skin
Extract: Chips.png... 100%
Extract: Deck.png... 100%
Extract: FoldedPlayerBackground.png... 100%
Extract: PlayerBackground.png... 100%
Extract: TableBackground.jpg... 100%
Extract: TableData.xml... 100%
Extract: TableElements.xml... 100%
Extract: button.png... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\Reports
Extract: 1 - Leak Buster - Stakes.Report... 100%
Extract: 2 - Leak Buster - Overall.Report... 100%
Extract: 3 - Leak Buster - Position.Report... 100%
Extract: 4 - Leak Buster - Pre-flop.Report... 100%
Extract: By Stakes.Report... 100%
Extract: HandAtShowdown.Report... 100%
Extract: HandAtShowdownDetailed.Report... 100%
Extract: HoleCards.Report... 100%
Extract: NumberOfPlayers.Report... 100%
Extract: Overall.Report... 100%
Extract: Position.Report... 100%
Extract: PreflopActivity.Report... 100%
Extract: StackSize.Report... 100%
Extract: WinningsSummary.Report... 100%
Output folder: C:\Program Files\RVG Software\Holdem Manager\Temp
Output folder: C:\Program Files\RVG Software\Holdem Manager
Extract: HoldemManager.config... 100%
Copy to C:\Program Files\RVG Software\Holdem Manager\Config\HoldemManager.config
Delete file: C:\Program Files\RVG Software\Holdem Manager\HoldemManager.config
Create folder: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Holdem Manager
Create shortcut: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Holdem Manager\Holdem Manager.lnk
Create shortcut: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Holdem Manager\Uninstall Holdem Manager.lnk
Create shortcut: C:\Users\Public\Desktop\HoldemManager.lnk
Created uninstaller: C:\Program Files\RVG Software\Holdem Manager\UninstallHoldemManager.exe
Output folder: C:\Program Files\PSQLINSTALL
top level install dir -->C:\Program Files
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: True
test antivirus returned 1
antivirus installed
security center error status: 0
security center status: 4
disabling security center
security center error status: 0
security center status: 1
disabled security center
seclogon error status: 0
seclogon status: 4
firewall enabled: 1
firewall port 5432 enabled: 1
port 5432 already enabled
postgres installdir: C:\Program Files\PSQLINSTALL
==================== running PsqlTestClient
try pass: postgres
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
no existing install dir
wrote testfile
Delete file: C:\Program Files\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\Program Files\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files\PSQLINSTALL
==================== running PsqlTestClient
try pass: postgres
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient

followed by popup box "sorry could not install postgreSQL
installation aborted
-setup was not completed successfully"

fozzy71
03-06-2010, 02:30 PM
Please email support@holdemmanager.com, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.net/teamviewer. Please let us know what time zone you are in and what time/days are convenient for you.

kaizer1981
03-07-2010, 11:21 PM
ty for that morny all good now your a legend for doing it on sunday night cheers :)