New Software: Holdem Manager

[thac]

rvg - is there any way that we can copy/paste a hand history from HM? I dislike that it comes up in a warning box because I like to share past HH with friends and stuff, but can't copy/paste it.

[downrange]

[ QUOTE ]

Hi, this is the code I'm using in DBDelete - hardcoded to avoid issues:


NpgsqlCommand CMD = new NpgsqlCommand("DROP DATABASE \"HoldemManagerBeta\"", CONN);

CMD.ExecuteNonQuery();

Not sure why the logging is saying something different? You seem to know quite a bit about Postgres so I'd be happy to provide any more info to get to the bottom of this.

[/ QUOTE ]
I doubt I know enough to help but will just say that I open a terminal to monitor the log as I clicked "delete database" and what I pasted in is what showed up in the terminal. Repeated about a dozen times every 5s before hem posted its error 'can't delete db' dialog.

I will up logging a little to see what else it reveals but I don't think I'll see much more; it could be an issue with "^M" but I can't simulate that myself. I assume the other poster is running pgsql locally so there could be more than one issue w/the "delete" (or a single issue where the cmd/args are just plain wrong; really don't know. Mine is pgsql 8.2.3 if it matters).

TBH you seem like a very hard-working, conscientious and ambitious guy but I really only wanted to see what all the fuss was about w/hem and at this point will probably just wait until you go golden and take a look then.


[ QUOTE ]

Edit: And I;ve found with a few people that not having a "postgres" user name seemed to cause issues with DB creation.

[/ QUOTE ]

I do have a user postgres, just not local to xp. I run xp in vmware w/pgsql on linux and I doubt xp is calling him "postgres"; I'd guess something like "\localhostostgres" or something like that. But not being a windows user I don't really know; that's just that sort of thing I see when xp refers to remote discs.

Or the problem is that my xp login name has some appendage added to it by hem/xp such that linux pgsql doesn't recognize that xp user as a member of postgres group. Just a guess; but there is definitely a "postgres" user and a "postgres" group at the linux pgsql.

[Guernica22]

Using .12b importing "fresh" files directly from FTP HH worked this time. 89 of 89 files/ 5765 hands/ 85 duplicate / 89 import errors 27.2 hands/s.

Release the HUD even if its crappy right now!

Thanks for all your hard work, I understand it's a product you are selling so you have incentive but you are doing a great job with support, keep it up.

[Guernica22]

Am I missing something/forgot to do something or does it not move the hands after they are imported and read? Every minute it has to reread every HH in the folder?

[downrange]

This is for the "delete db" problem.

I up'd verbosity to debug/error and parameters hoping to catch the actual cmd passed but it isn't showing up. The source file line number may or may not be of any use (this is 8.2.3 and linux in case compile defines make this misleading for a windows user).

<font class="small">Code:</font><hr /><pre>
pokertracker pokertracker 192.168.89.1(44936) 2007-07-18 14:20:29 EDTFATAL: 3D000: database "pokertracker" does not exist
pokertracker pokertracker 192.168.89.1(44936) 2007-07-18 14:20:29 EDTLOCATION: InitPostgres, postinit.c:318</pre><hr />

columns are:

username/database name/remote host/timestamp/debug msg

I created the hem db by using "pokertracker" as my db owner name, pw, host + port and that's it. "psql -l" lists "HoldemManagerBeta" db as existing and owned by "pokertracker" and as an SQL ASCII db.

I don't have pgadmin but IIRC "pokertracker" was the db server name and all my poker dbs are underneath (including hem's) so perhaps it's not looking for a "pokertracker" db but the pokertracker server without supplying the actual db name underneath that?

I'm sketchy on the nomenclature but this could explain why a remote and a local pgsql are both having the same problem deleting a specific db - something is stripping/leaving off the actual db name to be deleted. This is just a guess.

hth

[greg nice]

i wanna be able to see reports of multilpe players at the same time

currently, i search for a player, it displays their one line of stats. then i have to search for another, and the stats replace the other players ones

is there a way i can look at both at once?

also

are there definitions anywhere for what some of these 'new' stats mean? for example, turn cbet%. i assume thats the % of the time they double barrel after raising preflop?

[Unabridged]

[ QUOTE ]
Am I missing something/forgot to do something or does it not move the hands after they are imported and read? Every minute it has to reread every HH in the folder?

[/ QUOTE ]

i dont want it to move hh files, id rather it just check if the file has be modified since the last import(like PT).

[rvg72]

[ QUOTE ]
i wanna be able to see reports of multilpe players at the same time

[/ QUOTE ]

It's coming

[ QUOTE ]
so perhaps it's not looking for a "pokertracker" db but the pokertracker server without supplying the actual db name underneath that?

[/ QUOTE ]

OK, that makes sense. When deleting a DB you need to first connect to the server and connect to the template1 database which should exist. I can then drop the HoldemManager database. Something isn't quite working though for some people - I'm pretty sure if it was a fresh postgresql install using my instructions that there won't be any problem and it's just a matter of time before I fix these other issues with Postgresql.

[ QUOTE ]
Am I missing something/forgot to do something or does it not move the hands after they are imported and read? Every minute it has to reread every HH in the folder?

[/ QUOTE ]

Doesn't move yet - it's coming. It won't read files that have already been imported without error if the file date has not changed but still, will be changed soon.

[ QUOTE ]
rvg - is there any way that we can copy/paste a hand history from HM? I dislike that it comes up in a warning box because I like to share past HH with friends and stuff, but can't copy/paste it.

[/ QUOTE ]

This is very temporary but I'll probably at least make it a selectable text box. The Hands tab is VERY basic right now and will be changing a lot shortly including the addition of a replayer and more.

[ QUOTE ]
here's a screenshot illustrating the problem. the first file is one that said 0 import, 0 duplicate when i imported the whole folder. the second file is one that worked. then i copied the first file to a new folder and it worked.

[/ QUOTE ]

Thanks - will look into this.

Everyone that still has the 0 import problem, I'll have something soon. Tonight I think I'll have it taken care of - thought I got it last night but it does look like there was 2 different problems causing this.

rvg

[Shoe Lace]

Any idea what this error means?

"unable to read data from the transport connection. an existing connection was closed by the remote host"

I installed postgreSQL the other day. It's working flawlessly with PT (I just converted my PT db the other day) + PAHUD + etc..

I installed HM and ran it. The initial dialog told me it made a successful connection and asked if I wanted to make a database because it didn't find one.

I chose no (because one of my less technical friends was having troubles figuring out how to make a new DB after NOT creating one initially) and then the above error popped up.

It kept popping up everytime I started HM. I tried to restart postgreSQL and it didn't help. I was going to reboot but decided not to and uninstalled HM for the time being with intentions to try it again after you clean up bugs.

[fozzy71]

[ QUOTE ]
I'm pretty sure if it was a fresh postgresql install using my instructions that there won't be any problem and it's just a matter of time before I fix these other issues with Postgresql.

[/ QUOTE ]

LOLOL - I beg to disagree.