Turning on logging of SQL queries
Results 1 to 7 of 7
  1. #1
    Senior Member SuperSized's Avatar
    Join Date
    Jan 2009
    Posts
    494

    Default Turning on logging of SQL queries

    I would like to turn on logging of SQL queries run by HEM. I found this thread http://forums.holdemmanager.com/mana...ostgresql.html, but the file holdemmanager.config doesn't appear to exist anymore. The config.HEM file, which I assume is the the replacement file, is loaded as odd characters in notepad++.

    How would I go about logging information to the DBTrace.log file?

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    The file must exist. You find it in the config subfolder.

    If you have "Hide known file extensions" in the windows folder options it might just be displayed as
    holdemmanager...............................config file
    or something like that.

  3. #3
    Senior Member SuperSized's Avatar
    Join Date
    Jan 2009
    Posts
    494

    Default

    Quote Originally Posted by netsrak View Post
    The file must exist. You find it in the config subfolder.

    If you have "Hide known file extensions" in the windows folder options it might just be displayed as
    holdemmanager...............................config file
    or something like that.
    Thanks for your help. It's apparently a hidden file in the config folder.

  4. #4
    Senior Member SuperSized's Avatar
    Join Date
    Jan 2009
    Posts
    494

    Default

    Hmm, when I try and open HEM I get this error message:

    "Error creating Stat Ranges xml file: Accesss to the path 'E:\Program Files.....\Config\StatRanages.xml' is denied."

    Why is it complaining about this now that logging is turned on? I'm running XP and I am the administrator.

  5. #5
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Odd, are you using any security programs?

    Can you restore the original version of the holdemmanager.config file and check whether the message still comes up?

  6. #6
    Senior Member SuperSized's Avatar
    Join Date
    Jan 2009
    Posts
    494

    Default

    Quote Originally Posted by netsrak View Post
    Odd, are you using any security programs?

    Can you restore the original version of the holdemmanager.config file and check whether the message still comes up?
    Just Avast! Antivirus and Windows Firewall.

    I restored the holdemmanager.config file and still had the same problem. This sounds rather arb, but I altered the holdemmanager.config file again and hid the hidden files again and this time it logs to dbtrace.log. This might be completely unrelated, but this is the only thing I changed.

  7. #7
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

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


    Add exceptions to the windows firewall for \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe, even if the firewall is turned off.


    --

    Do you also have logging turned on in the postgresql.conf (open it with with notepad (or any txt editor)
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

Similar Threads

  1. PostrgeSQL turning itself off
    By GarethChantler in forum Manager General
    Replies: 8
    Last Post: 02-13-2011, 01:23 AM
  2. Turning the HUD off
    By henrics in forum Manager General
    Replies: 1
    Last Post: 09-30-2009, 06:52 AM
  3. Hud not turning on
    By fees in forum Manager General
    Replies: 1
    Last Post: 03-13-2009, 12:20 PM
  4. Turning my HH into agt files.
    By vikesfan353 in forum Manager General
    Replies: 5
    Last Post: 01-19-2009, 08:08 PM
  5. Turning HUD on/off
    By heartless in forum Manager General
    Replies: 4
    Last Post: 01-15-2009, 10:36 PM

Posting Permissions

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