Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

11-07-2009 , 07:21 PM
Quote:
Originally Posted by Eratosthenes
You need to import psycopg2. That is the Python interface to PostgreSQL. Get it here. Make sure you get the version that matches your version of python 2.5 or 2.6.
Wow i feel pretty dumb that i wasn't able to figure that out on my own

Thanks

Now i have a new error:
Code:
  File "C:\Poker\FPDB\pyfpdb\fpdb_db.py", line 73, in connect
    self.db = psycopg2.connect(database = database)
psycopg2.OperationalError: fe_sendauth: no password supplied
I have set a password for my PostgreSQL and it works with pqAdmin III.

My HUD Config.xml looks like this:
Code:
    <supported_databases>
    	<database db_name="fpdb" db_server="postgresql" db_ip="localhost" db_user="fpdb" db_pass="fpdb" db_type="fpdb"></database>
    </supported_databases>
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-07-2009 , 09:58 PM
After you upload the new snapshot (0.12??) May I assume that we will need to recreate the database and bulk import?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-07-2009 , 10:05 PM
Quote:
Originally Posted by jurrasstoil
My HUD Config.xml looks like this: [code
<supported_databases>
<database db_name="fpdb" db_server="postgresql" db_ip="localhost" db_user="fpdb" db_pass="fpdb" db_type="fpdb"></database>
</supported_databases>[/code]
This indicates that your postgres password is "fpdb". (without the quotes) If that's not right, you'll need to change that entry.

Otherwise, you should take a look at the postgres howto on the fpdb wiki and make sure you have all of that covered.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-07-2009 , 10:06 PM
Quote:
Originally Posted by 1meandog4u
After you upload the new snapshot (0.12??) May I assume that we will need to recreate the database and bulk import?
Don't do anything rash. I'm not sure this will require a reimport.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 02:04 AM
Quote:
Originally Posted by Eratosthenes
This indicates that your postgres password is "fpdb". (without the quotes) If that's not right, you'll need to change that entry.

Otherwise, you should take a look at the postgres howto on the fpdb wiki and make sure you have all of that covered.
I followed that HowTo to create the role and database. The database named 'fpdb' has the password 'fpdb', but there has to be another password so it can connect to postgre before it is able to login into the database, right?
Every Tracker i used before needed a login that required username, pass, IP and Port of the Postgre Server.

Example:


Or am i messing something up here?

The error says "no pass supplies", not "pass incorrect/wrong".

Last edited by jurrasstoil; 11-08-2009 at 02:27 AM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 11:57 AM
Quote:
Originally Posted by jurrasstoil
I followed that HowTo to create the role and database. The database named 'fpdb' has the password 'fpdb', but there has to be another password so it can connect to postgre before it is able to login into the database, right?
Every Tracker i used before needed a login that required username, pass, IP and Port of the Postgre Server.

Example:


Or am i messing something up here?

The error says "no pass supplies", not "pass incorrect/wrong".
That dialog box has "postgres" as the user--I think that is the root user, so you would need the root password. If you had PT3 or HEM install postgres, you can probably find out the default root password from their threads. If you change the user to "fpdb" and the password to "fpdb" you should be able to log on (but not actually do anything).
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 12:20 PM
Quote:
Originally Posted by Eratosthenes
That dialog box has "postgres" as the user--I think that is the root user, so you would need the root password. If you had PT3 or HEM install postgres, you can probably find out the default root password from their threads. If you change the user to "fpdb" and the password to "fpdb" you should be able to log on (but not actually do anything).
I'm working on a clean windows install, installed Postgre myself and set a password. I'm able to login via pqadmin III and the psql console.
The user 'postgres' has the password i chose during the installation and it works.
The user 'fpdb' has the password 'fpdb' (as suggested in the Postgre HowTo) and i can login via the psql console as the user fpdb into the fpdb database using the password 'fpdb'. But i can't get the fpdb.py to get past the "fe_sendauth: no password supplied" error.

Really annyoning because it doesn't make a lot of sense to me...
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 01:29 PM
Quote:
Originally Posted by jurrasstoil
I'm working on a clean windows install, installed Postgre myself and set a password. I'm able to login via pqadmin III and the psql console.
The user 'postgres' has the password i chose during the installation and it works.
The user 'fpdb' has the password 'fpdb' (as suggested in the Postgre HowTo) and i can login via the psql console as the user fpdb into the fpdb database using the password 'fpdb'. But i can't get the fpdb.py to get past the "fe_sendauth: no password supplied" error.

Really annyoning because it doesn't make a lot of sense to me...
I am a MySQL guy now because I couldn't postgres running properly about 10 years ago

What version of fpdb are you using. You might have better luck using the most recent snapshot rather than the most recent 0.11.x.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 02:30 PM
Quote:
Originally Posted by Eratosthenes
I am a MySQL guy now because I couldn't postgres running properly about 10 years ago

What version of fpdb are you using. You might have better luck using the most recent snapshot rather than the most recent 0.11.x.
Has Sorrow, or someone, uploaded a new snapshot 0.12... I thought there was some kind of problem when I mentioned to him about files named "global..." something. He responded he needed to upload it again. Is that ready to download now. Is it just a drag and drop over the old files to make the changes? Thanks.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 03:33 PM
Quote:
Originally Posted by 1meandog4u
Has Sorrow, or someone, uploaded a new snapshot 0.12... I thought there was some kind of problem when I mentioned to him about files named "global..." something. He responded he needed to upload it again. Is that ready to download now. Is it just a drag and drop over the old files to make the changes? Thanks.

Dog
the first upload had a problem--he has not uploaded anything else yet
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 04:01 PM
Quote:
Originally Posted by Eratosthenes
I am a MySQL guy now because I couldn't postgres running properly about 10 years ago
Unfortunately i'm more of an idiot guy

My programming skills are limited to nonexistent and my knowledge about databases is similar.
Quote:
Originally Posted by Eratosthenes
What version of fpdb are you using. You might have better luck using the most recent snapshot rather than the most recent 0.11.x.
I'm using 0.11.3 - or, well, i'm trying to use 0.11.3...

This tilts me worse than any session i have ever played... and i play SNGs...

It just doesn't make any sense and google has no helpful results either. I mean, try googling "fe_sendauth: no password supplied", you'll just find some non-sense and suggestions like editing the pg_hba.conf and what not. When i set all connections to "trust" ie. no password required the fpdb.py says that it 'expected an authentification but' and then the error message ends...

ugh... i think i just give up...
thanks for your help tho.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 06:23 PM
Quote:
Originally Posted by jurrasstoil
The error says "no pass supplies", not "pass incorrect/wrong".
I think there might be a bug in the postgres connection code in that 0.11.3 version, I vaguely remember there was some problem with connecting to postgres at one point. It does generally work, I use postgres as my db, I think maybe it was just broken at the point that release was built.

Try downloading the first 0.12 snapshot from http://****************/projects/fpdb...ar.gz/download
(Get the 7-zip program if you need a prog to unzip that archive.)
Just unzip it into a new dir and copy your current HUD_config.xml into the /pyfpdb/ folder.

- sc
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 09:12 PM
Quote:
Originally Posted by Eratosthenes
the first upload had a problem--he has not uploaded anything else yet
The correct file has been uploaded into the Snapshots area now.

There is no db schema or config changes between the last snapshot and the one i've just uploaded.

Thanks

Sorrow.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 09:16 PM
Quote:
Originally Posted by sorrow
The correct file has been uploaded into the Snapshots area now.

There is no db schema or config changes between the last snapshot and the one i've just uploaded.

Thanks

Sorrow.
So, do we just down load, unzip, drag n drop all the files into FPDB and it works? Perfect? Do we have to protect our config file from overwriting, or is there no new config file. Thanks for the hard work.

Do we ignore the "pax_global header"?? that is outside the FPDB directory? Nevermind the config question, I see there is only the config example file... and we don't have to recreate the database...... yet....

Dog

Last edited by 1meandog4u; 11-08-2009 at 09:23 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 09:54 PM
I just downloaded, unzipped, drag n dropped all the files into FPDB. Thanks for the hard work. Do we ignore the "pax_global header"?? that is outside the FPDB directory?

I did install 0.12 and while I haven't tried the hud, I can't see any difference. Maybe I misunderstood, but I thought (not counting the green color change ) that the player stats columns were now sortable?? Was that a git build and not the one you just uploaded?

Sorry for two posts. Didn't realize I was going to have time to try installing.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-08-2009 , 11:54 PM
Quote:
Originally Posted by jurrasstoil
My programming skills are limited to nonexistent and my knowledge about databases is similar.I'm using 0.11.3 - or, well, i'm trying to use 0.11.3...
Please try the 0.12 version from the snapshots area. There were bugs in the 0.11.3 connect code that prevented it from working.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-09-2009 , 12:18 AM
Quote:
Originally Posted by 1meandog4u
I just downloaded, unzipped, drag n dropped all the files into FPDB. Thanks for the hard work. Do we ignore the "pax_global header"?? that is outside the FPDB directory?

I did install 0.12 and while I haven't tried the hud, I can't see any difference. Maybe I misunderstood, but I thought (not counting the green color change ) that the player stats columns were now sortable?? Was that a git build and not the one you just uploaded?

Sorry for two posts. Didn't realize I was going to have time to try installing.

Dog
I've no idea what pax_global_header is, and it isn't in the archive - it must be an artifact from the client you are using to unzip.

Where do you keep your config file dog? If it isn't in the pyfpdb/ folder then you can just delete the old 0.12 directory and replace it with the archive.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-09-2009 , 03:38 AM
Quote:
Originally Posted by sorrow
I've no idea what pax_global_header is, and it isn't in the archive - it must be an artifact from the client you are using to unzip.
It was a header file from my RAR unzipping program.

Quote:
Where do you keep your config file dog? Sorrow
It is in the pyfpdb/ folder AND I keep a zipped copy of the latest one in my "archives save" directory.


Here's the results:

Deleted the old directory and installed the 0.12 files I downloaded. Put a copy of my hud_config file back into the pyfpdb/ folder. Made one modification to the "stats.py" file, replacing the "%" with " " to get more spacing.

Opened up the fpdb program and it ran perfect. New colors (much appreciated). Columns all sorted perfect. Ran a couple of reports, all seemed without any errors.

Sat in a table, ran the hud and it too worked to perfection, including the spacing I had changed. I did notice we have a lot of discretion now on each table as to how we want the stats to show... multiple game levels, multiple times, and for both player and opponent. VERY nice feature. They all worked without a hitch.

This was version 0.12 running on Vista with MySQL database. Success is so sweet. My kudos to the coders for a job well done. It's coming along quite nicely.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-09-2009 , 05:07 AM
Quote:
Originally Posted by sorrow
Please try the 0.12 version from the snapshots area. There were bugs in the 0.11.3 connect code that prevented it from working.
Thanks 0.12 did the trick and installed just fine (i think).

I edited all the import stuff and it seems to import from the folders i specified, but there is no HUD showing and i can't seem to get any player statistics going in the main window. There are files in the Archive Folder tho, but when I open the HandHistory files, which were played on FTP, they say "Pokerstars Game #whatever etc."

While i'm at it: is there a way to configure the HUD? I only need VPIP, PFR and Number of Hands really, the rest would just clutter up my tiny netbookscreen.
Oh, and is it possible to filter the HUD stats by #Players?

Thanks in advance
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-10-2009 , 01:15 AM
Quote:
Originally Posted by 1meandog4u
This was version 0.12 running on Vista with MySQL database. Success is so sweet. My kudos to the coders for a job well done. It's coming along quite nicely.
Just think, it's only been about a year.

Wow, I look at the first page of the thread, and I guess Steffen started in August of last year.. I joined in sometime in November, I think, I didn't realise it had already been going for a couple of months at that time.

It's come a long way, although there's still plenty of work to be done.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-10-2009 , 10:40 AM
Hi again.

Wow, thanks for such a great program!

Currently running 0.12 on Vista and am wondering if there is a way to position the mucked cards. When I drag them with the mouse they jump right back to their default positions. I can get them to stay on the screen and cause the blank mucked cards to show with SHFT-Click, but still can't make them stay in a new position. Any ideas? Thanks.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-10-2009 , 11:46 AM
Quote:
Originally Posted by Jackpotmage
Hi again.

Wow, thanks for such a great program!

Currently running 0.12 on Vista and am wondering if there is a way to position the mucked cards. When I drag them with the mouse they jump right back to their default positions. I can get them to stay on the screen and cause the blank mucked cards to show with SHFT-Click, but still can't make them stay in a new position. Any ideas? Thanks.
Until recently dragging the mucked cards worked--then just save the layout. I don't know when that bug crept in. I'll see if I can track it down and kill it before the next snapshot.

You can also edit the HUD_config.xml file. When you run fpdb from the command line it prints the config file it is using, like this:
Code:
Reading configuration file /home/blah/.fpdb/HUD_config.xml
So open that file with a text editor and find the Flop_Mucked element:
Quote:
<aw card_ht="42" card_wd="30" class="Flop_Mucked" deck="Cards01.png" module="Mucked" name="mucked" opacity="0.7" timeout="5">
<layout height="546" max="6" width="792">
<location seat="1" x="555" y="169"> </location>
<location seat="2" x="572" y="276"> </location>
<location seat="3" x="363" y="348"> </location>
<location seat="4" x="150" y="273"> </location>
<location seat="5" x="150" y="169"> </location>
<location seat="6" x="363" y="113"> </location>
<location common="1" x="323" y="232"> </location>
</layout>
<layout height="546" max="9" width="792">
<location seat="1" x="486" y="113"> </location>
<location seat="2" x="555" y="169"> </location>
<location seat="3" x="572" y="276"> </location>
<location seat="4" x="522" y="345"> </location>
<location seat="5" x="363" y="348"> </location>
<location seat="6" x="217" y="341"> </location>
<location seat="7" x="150" y="273"> </location>
<location seat="8" x="150" y="169"> </location>
<location seat="9" x="230" y="115"> </location>
<location common="1" x="323" y="232"> </location>
</layout>
<layout height="546" max="10" width="792">
<location seat="1" x="486" y="113"> </location>
<location seat="2" x="499" y="138"> </location>
<location seat="3" x="522" y="212"> </location>
<location seat="4" x="501" y="281"> </location>
<location seat="5" x="402" y="323"> </location>
<location seat="6" x="243" y="311"> </location>
<location seat="7" x="203" y="262"> </location>
<location seat="8" x="170" y="185"> </location>
<location seat="9" x="183" y="128"> </location>
<location seat="10" x="213" y="86"> </location>
<location common="1" x="317" y="237"> </location>
</layout>
</aw>
For example, if you wanted to move the position for seat 3 in 6 max to the right or left, you would change the highlighted line.
x (horizontal) and y (verticle) are measured from the top left of the client window. The common location is for the community cards.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-10-2009 , 02:37 PM
Quote:
Originally Posted by jurrasstoil
Thanks 0.12 did the trick and installed just fine (i think).

I edited all the import stuff and it seems to import from the folders i specified, but there is no HUD showing and i can't seem to get any player statistics going in the main window. There are files in the Archive Folder tho, but when I open the HandHistory files, which were played on FTP, they say "Pokerstars Game #whatever etc."
Interesting. FYI, they all say PokerStars. That you have those files means the firt part of the auto-import is working, but the hud initialisation is failing.

Can you locate logging.out (it should be in pyfpdb/) and post any warning/error messages from that file.

Could you also try starting fpdb from a console, there may be an indication of why the hud istn't starting there.
Quote:
Originally Posted by jurrasstoil
While i'm at it: is there a way to configure the HUD? I only need VPIP, PFR and Number of Hands really, the rest would just clutter up my tiny netbookscreen.
Oh, and is it possible to filter the HUD stats by #Players?

Thanks in advance
http://****************/apps/mediawik...itle=Howto_HUD should detail this, but isn't quite there yet.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-10-2009 , 05:47 PM
New problem with 0.12

I played last night and everything went fine. I stopped the auto import and closed the program. I open it this morning and it said "unable to open Mysql...." I found the problem. My hud_config file was missing in action???''

So, got out my trusty backup and put it in pyfpdb/ folder. Opened the program, worked perfect. Finished the session, closed it all down and left. Came back awhile ago, tried to start it... same error, hud config file missing again. It keeps deleting the config file.. Any ideas?

p.s. After further investigation, it seems to delete the config file. Then, the next time I open the program, it creates a new config file using the "example" file. Going to try "saving as" my correct config file to the example file. That way, if I am correct, if it deletes the hud config file, it will create a new one using the example file... Right? Which will really be the hud config file I have as a backup.. Where is my logic wrong.... besides everywhere... here goes nothing.


Dog

Last edited by 1meandog4u; 11-10-2009 at 05:54 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-10-2009 , 07:41 PM
Quote:
Originally Posted by 1meandog4u
New problem with 0.12

I played last night and everything went fine. I stopped the auto import and closed the program. I open it this morning and it said "unable to open Mysql...." I found the problem. My hud_config file was missing in action???''

So, got out my trusty backup and put it in pyfpdb/ folder. Opened the program, worked perfect. Finished the session, closed it all down and left. Came back awhile ago, tried to start it... same error, hud config file missing again. It keeps deleting the config file.. Any ideas?

p.s. After further investigation, it seems to delete the config file. Then, the next time I open the program, it creates a new config file using the "example" file. Going to try "saving as" my correct config file to the example file. That way, if I am correct, if it deletes the hud config file, it will create a new one using the example file... Right? Which will really be the hud config file I have as a backup.. Where is my logic wrong.... besides everywhere... here goes nothing.


Dog
I might have caused this problem.

Try putting your good HUD_config.xml in your Application Data\fpdb folder. Make sure that you don't have one in the pyfpdb\ or whatever folder you start fpdb from.

Your Application Data\ folder should be in:
c:\Documents and Settings\1meandogforyou\
^----that's for XP

oh crap! the vista location is likely to be different.

I think that's the fix. If you don't know how to put HUD_config.xml there, then one of the guys has to chime in.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m