Open Side Menu Go to the Top
Register
Holdem Manager Support Holdem Manager Support

09-04-2007 , 10:30 PM
Quote:
Quote:
"The following error occured when trying to open the Holdem Manager database: unable to read from the transport connection: An existing connection was forcibly closed by the remote host."
Make sure Postgres is running as a service and then make sure you have the port / user name / password entered correctly.

How do you make sure postgres is running as a service?

I'm getting the same message as above. My server name is localhost, my port number is 5432, my login name is postgres. the password is incoreect, but after I change it I get this error: "Connection Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."

I have never had any issues of any kind until the last patch.
Holdem Manager Support Quote
09-05-2007 , 01:58 AM
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ComponentModel.Win32Exception: Not enough storage is available to process this command
at System.Drawing.BufferedGraphicsContext.CreateCompa tibleDIB(IntPtr hdc, IntPtr hpal, Int32 ulWidth, Int32 ulHeight, IntPtr& ppvBits)
at System.Drawing.BufferedGraphicsContext.CreateBuffe r(IntPtr src, Int32 offsetX, Int32 offsetY, Int32 width, Int32 height)
at System.Drawing.BufferedGraphicsContext.AllocBuffer (Graphics targetGraphics, IntPtr targetDC, Rectangle targetRectangle)
at System.Drawing.BufferedGraphicsContext.Allocate(In tPtr targetDC, Rectangle targetRectangle)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ContainerControl.WndProc(Mess age& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at DevComponents.DotNetBar.Office2007RibbonForm.WndPr oc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/Microsoft.NET/Fra...7/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Sof...demManager.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/assembly/GAC_MSIL...dows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/assembly/GAC_MSIL...089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/assembly/GAC_MSIL...em.Drawing.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 6.7.3.1
Win32 Version: 6.7.3.1
CodeBase: file:///C:/Program%20Files/RVG%20Sof...DotNetBar2.DLL
----------------------------------------
Replayer
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Sof...a/Replayer.EXE
----------------------------------------
HoldemLibrary
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Sof...demLibrary.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/assembly/GAC_MSIL...System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///H:/WINDOWS/assembly/GAC_MSIL...essibility.dll
----------------------------------------
Npgsql
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Sof...eta/Npgsql.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/assembly/GAC_32/S...ystem.Data.dll
----------------------------------------
Mono.Security
Assembly Version: 1.0.5000.0
Win32 Version:
CodeBase: file:///C:/Program%20Files/RVG%20Sof...o.Security.DLL
----------------------------------------
ZedGraph
Assembly Version: 5.0.8.21916
Win32 Version: 5.0.8.21916
CodeBase: file:///C:/Program%20Files/RVG%20Sof...a/ZedGraph.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///H:/WINDOWS/assembly/GAC_MSIL...figuration.dll
----------------------------------------
HMClass
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Sof...ta/HMClass.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


-----------

This is the error I get when auto-importing about 100 files.
Holdem Manager Support Quote
09-05-2007 , 03:26 AM
Quote:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

This is the error I get when auto-importing about 100 files.
Does this happen every time? It looks like an error caused by one of the visual parts of the program and should be fixed in the next update.

Quote:
I'm getting the same message as above. My server name is localhost, my port number is 5432, my login name is postgres. the password is incoreect, but after I change it I get this error: "Connection Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."
ok, will try to duplicate the problem. If you launch pgadmin from your start menu and then double click on the server does it prompt you for a password? if so does entering in the password get you access to the database?

Quote:
Is there a way to backup the database like on pokertracker if I wanted to move it to another computer?
Not just yet although you can probably use Poker Tracker's postgre utilities to do this. Otherwise you could use pgadmin but you might be better off just waiting until I add it.


Update: Bodog cash has been added but I need tourney hand histories. If you have Bodog tourney hand histories, especially ones where it went deep enough to get antes, please send them to tourneymgr@gmail.com

Ultimate Bet is next although it won't be in the update coming out later this week. The new sites are Absolute, Crypto and Bodog to go along with Party, Full Tilt, Stars, Prima and iPoker.

rvg
Holdem Manager Support Quote
09-05-2007 , 03:32 AM
It happens quite a lot.
Holdem Manager Support Quote
09-05-2007 , 03:49 AM
Quote:
Quote:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

This is the error I get when auto-importing about 100 files.
Does this happen every time? It looks like an error caused by one of the visual parts of the program and should be fixed in the next update.
Because of the "Graphics Context" bit?

This error is usually caused by an out of memory issue caused by another part of the program. That part uses up all the available memory, and then one of the multiple repainting threads that are going on concurrently in the background don't have enough memory left to do their painting routine, throwing this error. It's rarely related to graphics, and since it happens during memory-intensive importing it's quite likely a glitch in the import routine.

I scratched my head with this one for a while as well, just a heads up.
Holdem Manager Support Quote
09-05-2007 , 03:56 AM
Quote:
Quote:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

This is the error I get when auto-importing about 100 files.
Does this happen every time? It looks like an error caused by one of the visual parts of the program and should be fixed in the next update.

Quote:
I'm getting the same message as above. My server name is localhost, my port number is 5432, my login name is postgres. the password is incoreect, but after I change it I get this error: "Connection Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."
ok, will try to duplicate the problem. If you launch pgadmin from your start menu and then double click on the server does it prompt you for a password? if so does entering in the password get you access to the database?

Quote:
Is there a way to backup the database like on pokertracker if I wanted to move it to another computer?
Not just yet although you can probably use Poker Tracker's postgre utilities to do this. Otherwise you could use pgadmin but you might be better off just waiting until I add it.


Update: Bodog cash has been added but I need tourney hand histories. If you have Bodog tourney hand histories, especially ones where it went deep enough to get antes, please send them to tourneymgr@gmail.com

Ultimate Bet is next although it won't be in the update coming out later this week. The new sites are Absolute, Crypto and Bodog to go along with Party, Full Tilt, Stars, Prima and iPoker.

rvg
I get the following error when I enter my password in pgAdmin:

An error has occured: Error connecting to the server: server closed the connection unexpectedly. This probably means the server terminated abnoramlly before or while processing the request.
Holdem Manager Support Quote
09-05-2007 , 04:01 AM
Quote:
Quote:
Quote:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

This is the error I get when auto-importing about 100 files.
Does this happen every time? It looks like an error caused by one of the visual parts of the program and should be fixed in the next update.
Because of the "Graphics Context" bit?

This error is usually caused by an out of memory issue caused by another part of the program. That part uses up all the available memory, and then one of the multiple repainting threads that are going on concurrently in the background don't have enough memory left to do their painting routine, throwing this error. It's rarely related to graphics, and since it happens during memory-intensive importing it's quite likely a glitch in the import routine.

I scratched my head with this one for a while as well, just a heads up.
It might be related to the import although in the forums for the graphical tool I use this exact "Not enough storage is available to process this command" error had been posted and apparently it had something to do with having the app support system tray functionality which mine does as well...

They have a new full version release (the current version I have compiled into HM is an incremental build) and they have fixed some other bugs like one where if you click and drag a horizontal scroll bar on a datagrid in a certain way so hopefully when I merge the new build into the next HM update these two problems will go away. If not I'll dig a bit deeper.

rvg
Holdem Manager Support Quote
09-05-2007 , 04:05 AM
Quote:

I get the following error when I enter my password in pgAdmin:

An error has occured: Error connecting to the server: server closed the connection unexpectedly. This probably means the server terminated abnoramlly before or while processing the request.
Did a little digging and found a few people mention this:

"This error is most likely some antivirus or firewall software that's misbehaving."

Could you turn off your anti virus and firewall software and let me know if that solves this. Once you can connect with pgadmin you should be able to with HM as well.

rvg
Holdem Manager Support Quote
09-05-2007 , 04:11 AM
Cool, I used to get the exact same error message when PT imports from another program chewed through all available memory. Looks like there's more than one cause. Debugging software is fun.
Holdem Manager Support Quote
09-05-2007 , 04:12 AM
Turning off my firewall kind of works. The first time I'm asked for my password I get the same error. When I do it for the 2nd time, it works. I have done it 6 times and I always have to do it twice.....
Holdem Manager Support Quote
09-05-2007 , 04:24 AM
My biggest concern is with SpadeEye. It can't read my database at all. I get the same message as above.
Holdem Manager Support Quote
09-05-2007 , 04:37 AM
I have turned off both my McCaffee and Windows firewall and anti virus. I can get SpadeEye to scan my database now, but it always comes up with an error and then after pressing scan all tables multiple times will it begin to read my database... I don't really like the idea of playing without any protection for my computer
Holdem Manager Support Quote
09-05-2007 , 05:27 AM
A word about the PostgreSQL installation: in the instructions over at HoldemManager.net, rvg instructs to leave the password area blank at a given time. He shows a screenshot of the Postgres installation wizzard asking if you want a random password generated, and instructs to click 'NO'.

In the new release of Postgres, you are no longer offered the possibility to leave the pw area blank. The installation wizzard now says: "if you do not make a pw, one will be generated automatically". I'm not sure if this is causing the problems I'm having with HM, but it's probably a good idea to look into it when you have time, rvg.

(I posted on the HM forum about this as well, fyi.)
Holdem Manager Support Quote
09-05-2007 , 11:35 AM
Quote:
A word about the PostgreSQL installation: in the instructions over at HoldemManager.net, rvg instructs to leave the password area blank at a given time. He shows a screenshot of the Postgres installation wizzard asking if you want a random password generated, and instructs to click 'NO'.

In the new release of Postgres, you are no longer offered the possibility to leave the pw area blank. The installation wizzard now says: "if you do not make a pw, one will be generated automatically". I'm not sure if this is causing the problems I'm having with HM, but it's probably a good idea to look into it when you have time, rvg.

(I posted on the HM forum about this as well, fyi.)
Hi Neku,

Thanks for this, I'll download the latest install and update my installation instructions.

Roy
Holdem Manager Support Quote
09-05-2007 , 11:38 AM
Quote:
I have turned off both my McCaffee and Windows firewall and anti virus. I can get SpadeEye to scan my database now, but it always comes up with an error and then after pressing scan all tables multiple times will it begin to read my database... I don't really like the idea of playing without any protection for my computer
You should be able to run these programs and have them just let Postgres, HM, Spadeeye etc do what they need to do - I'll dig around some more on the Postgres forums for suggestions. I've seen a lot of people have problems specifically with Mcafee. have you tried just disabling that and leaving everything else (ie windows firewall) running?

rvg
Holdem Manager Support Quote
09-05-2007 , 01:09 PM
Quote:
Quote:
I have turned off both my McCaffee and Windows firewall and anti virus. I can get SpadeEye to scan my database now, but it always comes up with an error and then after pressing scan all tables multiple times will it begin to read my database... I don't really like the idea of playing without any protection for my computer
You should be able to run these programs and have them just let Postgres, HM, Spadeeye etc do what they need to do - I'll dig around some more on the Postgres forums for suggestions. I've seen a lot of people have problems specifically with Mcafee. have you tried just disabling that and leaving everything else (ie windows firewall) running?

rvg
Yeah, I have done that. SpadeEye gets the same error and HoldEmManager requires mulitple trys.
Holdem Manager Support Quote
09-05-2007 , 02:00 PM
Quote:
Quote:
Quote:
I have turned off both my McCaffee and Windows firewall and anti virus. I can get SpadeEye to scan my database now, but it always comes up with an error and then after pressing scan all tables multiple times will it begin to read my database... I don't really like the idea of playing without any protection for my computer
You should be able to run these programs and have them just let Postgres, HM, Spadeeye etc do what they need to do - I'll dig around some more on the Postgres forums for suggestions. I've seen a lot of people have problems specifically with Mcafee. have you tried just disabling that and leaving everything else (ie windows firewall) running?

rvg
Yeah, I have done that. SpadeEye gets the same error and HoldEmManager requires mulitple trys.
These types of problems some people are having is exactly why I was looking at replacing postgres. After I release the next update with a few enhancements and Bodog, Crypto and Absolute support I'll provide a SQLite option for HM. It is no install / no config and you should not have any of these problems and performance is comparable.

rvg
Holdem Manager Support Quote
09-05-2007 , 06:37 PM
I need to move the PostgreSQL folder to another location.

Is it possible to do this without losing my db?

If not, how do I backup my db?
Holdem Manager Support Quote
09-05-2007 , 11:18 PM
Where do I find true hourly winrate and multi table ratio?
Holdem Manager Support Quote
09-06-2007 , 03:11 AM
After I release the next update with a few enhancements and Bodog, Crypto and Absolute support I'll provide a SQLite option for HM. It is no install / no config and you should not have any of these problems and performance is comparable.

rvg

[/quote]

now you tell us
Holdem Manager Support Quote
09-06-2007 , 05:14 PM
Interface kinda blows tbh, looks "pretty" but functionally not amazingly easy to learn.

Find player button should DISPLAY A LIST OF NAMES ORDERED AND THE SEARCH BOX.

SHOULD ALSO HAVE A DATABASE PANEL SO I CAN SEE IF A DATEBASE IS CREATED OPENED.

I import, search see my hadns etc.
Close it, search again and nothing there.... WTF? Suppose to stay in the database and the DB should be open.


Not as easy to use at PT IMO, this is where the major downfall is right now.

But its a beta, so ill prob buy full thing dependind on fixes.
Holdem Manager Support Quote
09-07-2007 , 12:08 AM
Quote:
I need to move the PostgreSQL folder to another location.

Is it possible to do this without losing my db?

If not, how do I backup my db?
Holdem Manager Support Quote
09-07-2007 , 03:17 AM
Quote:
I need to move the PostgreSQL folder to another location.

Is it possible to do this without losing my db?

If not, how do I backup my db?
The data is all stored in C:\Program Files\PostgreSQL\8.2\data. After you move the file you will have to point PGAdmin to the right place
Holdem Manager Support Quote
09-07-2007 , 05:33 AM
Can you please explain to me how to do this with PGAdmin?

Thankyou
Holdem Manager Support Quote
09-07-2007 , 01:06 PM
Quote:
Can you please explain to me how to do this with PGAdmin?

Thankyou
I'll see if I can add some of this DB management stuff into the update I'm working on because I'm getting these types of questions a lot.

Thanks,

rvg
Holdem Manager Support Quote

      
m