HM2 crashed, cant acces rn because of this error.
Results 1 to 9 of 9
  1. #1
    Member
    Join Date
    Oct 2017
    Posts
    64

    Default HM2 crashed, cant acces rn because of this error.

    Hello HM Support, I cant access the Hm2 and then I have the following message, could you help me please?

    The last time I dealt with this I clicked on "Reset Password" and I lose the entire database in a click. please help

    https://ibb.co/pKqtbdk
    Attached Images Attached Images

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,806

    Default

    PT4's default name/password is - postgres/dbpass
    HM2's default name/password is - postgres/postgrespass

    You might also want to try svcPASS83 or h0ld3mManag3r! for a password if none of the above works.

    If that doesnt help:

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

    HM will accept any password now.

    http://faq.holdemmanager.com/questio...8PostgreSQL%29

  3. #3
    Member
    Join Date
    Oct 2017
    Posts
    64

    Default

    The password was correct and helped me, but now im having the following problem: it freezes and then I have the following message. any idea on how to fix this please?
    Attached Images Attached Images

  4. #4
    Member
    Join Date
    Oct 2017
    Posts
    64

    Default

    is another option making an effective backup and then reseting the password? If so, could you guide me on how to do it please?

  5. #5
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,806

    Default

    Here is a laundry list of different things you can try:

    a) Please see this section of the Windows FAQ and reset your Winsock Adapter - http://hm2faq.holdemmanager.com/ques...+files#winsock

    This is usually a firewall or Windows update issue and the following guide gives a step by step guide:
    http://hm2faq.holdemmanager.com/ques...rt+PostgreSQL+

    The secondary logon service is a standard windows service which is available on every windows computer and is required to install PostgreSQL. In some versions it is not started automatically and it will just give an error when trying to connect to PostgreSQL. You need to verify it is turned on via control panel > administrative tools > services > secondary logon > right-click > start AND right-click > properties and choose startup type: automatic so it will be started automatically next time your PC reboots.

    Please see this FAQ to alleviate any security bottlenecks - http://hm2faq.holdemmanager.com/ques...olders+HM2+use


    b) If you continue to have problems:

    Which Operating System, Firewall, and AntiVirus are you using?

    Many of those free Norton, Mcaffee, Comodo, Zonealarm, Avira, Avast, AVG, Bitdefender, etc, 'internet security' bundles will not work well with Holdem Manager.

    Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager:

    1) Uninstall any 3rd party security software (even windows defender or security essentials) bundles and dont reinstall them until after you reconnect postgresql.
    2) Reboot your computer
    3) Please install the latest version: http://www.holdemmanager.com/downloa...ger_2_Beta.exe
    - After downloading, you should right-click the file, go to properties and click unblock.*
    * If you do not see an 'unblock' option you can ignore this step.
    - Then, right click the file and run as administrator.
    4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender (unless you are using Windows 10, in which case it should be enabled), and add firewall exceptions for HM and SQL - http://hm2faq.holdemmanager.com/ques...rewall%29#MSES
    5) Install Microsoft Security Essentials (unless you are using Windows 10) for antivirus/malware protection and update it - https://support.microsoft.com/en-us/help/14210


    c) If you continue to have problems you can try to reinstall the same version of postgresql and reconnect your database:

    Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser).

    Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F

    If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques...nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

    Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

    net user postgres /delete

    3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

    4) Reboot your PC

    5) Install the same version of PostgreSQL as your previous database using these instructions - http://hm2faq.holdemmanager.com/ques...rving+database
    http://www.holdemmanager.com/downloads/postgres84


    d)*If none of that helps you will have to reinstall postgresql from scratch:

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Delete the \PostgreSQL\X.x\data folder that is left behind.

    3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

    4) run the command - start > programs > accessories > command prompt > right-click > run as administrator

    net user postgres /delete

    After you click 'Enter' for the code above also do that same for this code:

    sc delete postgresql-8.4

    and click 'Enter' again.

    5) Restart your PC

    6) Install PostgreSQL 9.3 from https://www.enterprisedb.com/downloa...esql-downloads

    7) Once installed you should disable the postgresql logging as instructed here - http://hm2faq.holdemmanager.com/ques...arge+Log+Files


    e) If there is still an issue, we need to know the error - it is in the %Temp% folder - bitrockinstaller.txt file. *If you can't see it, turn off the windows option that is hiding that directory - https://support.microsoft.com/en-us/...0-1166d1d9f4b5

    We will also want to see the following logs in addition to the bitrockinstaller.txt file:

    Please duplicate the issue and send us log files with a detailed description of what you were doing and what problems you were experiencing:
    - Open Windows Event Viewer's (Control Panel > System & Security > Administrative Tools or Start > Search > 'Event Viewer') > Windows Logs > Applications.*
    - Check for any errors and send the information (Save All Events As...).*
    - Please send your \HM2Logs folder files as well - http://hm2faq.holdemmanager.com/ques...ger+Support%3F

    When sending any files please zip them (select all files with CTRL+A > right-click > send to > compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like Dropbox, then in Windows File Explorer right-click (DropBox Icon) 'Share' > 'Create Link' > Copy Link' and right-click > 'Paste' the download link directly into the support ticket email. If you have any problems with Dropbox try using WeTransfer or FileDropper or FireFox Send or Google Drive and copy/paste the download link to us.

  6. #6
    Member
    Join Date
    Oct 2017
    Posts
    64

    Default

    Quote Originally Posted by fozzy71 View Post
    Here is a laundry list of different things you can try:

    a) Please see this section of the Windows FAQ and reset your Winsock Adapter - http://hm2faq.holdemmanager.com/ques...+files#winsock

    .
    I did this step and it worked so thank you! Also I lost the entire database, again. Could you help me with steps to do backups please?

  7. #7
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,806

    Default

    Quote Originally Posted by AngelR View Post
    I did this step and it worked so thank you! Also I lost the entire database, again. Could you help me with steps to do backups please?
    If you have a previous backup you can restore it - https://hm2faq.holdemmanager.com/que...fault+settings

    If you do not have a backup you can reimport your C:\HM2Archive folder - https://hm2faq.holdemmanager.com/que...Hand+Importing

    If you do not have either of those you can try requesting your old hands to import. If you play a site like stars/ftp/party you can email their support and ask for all your old hand histories and tourney histories/results.

    Note: Unfortunately, HM2 support and updates ended on Dec 31, 2020, so it will likely not work at many of the sites it used to support. *You will need to upgrade to HM3 for future technical support. *You can read more about the HM2 End Of Life here - https://kb.holdemmanager.com/knowled...m2-end-of-life

  8. #8
    Member
    Join Date
    Oct 2017
    Posts
    64

    Default

    Im sorry ive got this made manually by me from a few weeks, is it helpful in anyway? I saved it from : c:\programfiles\postgres\data\base
    Attached Images Attached Images

  9. #9
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,806

    Default

    Unfortunately, I have no idea how to recover those types of folders/files as HM2 support and updates ended on Dec 31, 2020, so I have no recent experience with HM2 or PSQL.

    The only thing I can find in my old 'canned replies' that might apply is below:

    Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F

    If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques...nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

    Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

    net user postgres /delete

    3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

    4) Reboot your PC

    5) Install the same version of PostgreSQL (HM2 ships with 8.4) - http://www.holdemmanager.com/downloads/postgres84 - as your previous database using these instructions - http://hm2faq.holdemmanager.com/ques...rving+database

Similar Threads

  1. hm2 crashed hm1 crashed
    By scottypep63 in forum General Support
    Replies: 10
    Last Post: 04-05-2017, 09:01 AM
  2. HM2 crashes when trying to acces different reports
    By elrosmeero in forum General Support
    Replies: 3
    Last Post: 02-03-2017, 05:28 AM
  3. can't acces notcady tab in hm2
    By ken aces in forum NoteCaddy
    Replies: 3
    Last Post: 12-04-2012, 06:44 PM
  4. Need help restoring HM2 because computer crashed
    By mohitmadaan in forum General Support
    Replies: 4
    Last Post: 12-01-2011, 09:39 PM
  5. Cant acces my database anymore
    By krul in forum Manager General
    Replies: 5
    Last Post: 10-09-2010, 06:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •