Ok I have all the repositories required (thank you for the list of codes to place in the terminal), what do I do from there, I try to connect to MySQL but I seem to get this error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
perry@perry-laptop:~$

I think you need to setup your database. Use the step 3 here. You will also have to set up the default.conf as it says in that step. Then you should be able to start fpdb and import files, etc.

To set up the HUD, go here.

if this doesn't work you will have 1 or 2 error log files in the same dir as fpdb.py. They would be named something like fpdb-error-log.txt and HUD-error-log.txt. They may or may not have helpful error messages in them.

It says in the installation (Ubuntu) notes, that it will prompt me for a MySql password, this has not happened, have I missed something?

The first time mysql is installed it will ask for the database root password.

Run:
# dpkg -l | grep mysql

and look for mysql-client, if that is installed:
# mysql -u root -p
And you will be prompted for a password. If successful you should be able to continue using the install-in-ubuntu.txt - try a blank password if you have not yet entered one.

Ok, so I do the "dpkg -l | grep mysql" thing, and this is what I get

perry@perry-laptop:~$ dpkg -l | grep mysql
ii libdbd-mysql-perl 4.005-1 A Perl5 database interface to the MySQL data
ii libmysqlclient15off 5.0.51a-3ubuntu5.1 MySQL database client library
ii mysql-client 5.0.51a-3ubuntu5.1 MySQL database client (meta package dependin
ii mysql-client-5.0 5.0.51a-3ubuntu5.1 MySQL database client binaries
ii mysql-common 5.0.51a-3ubuntu5.1 MySQL database common files
ii mysql-doc-5.0 5.0.56-0ubuntu1 MySQL database documentation
ii python-mysqldb 1.2.2-5ubuntu1 A Python interface to MySQL

I think this shows I have the MySql client. yet I am still getting the same error as above. Any thoughts?

Good News, everyone! *insert picture of Professor Farnsworth*

I almost have the HUD working on a non-FTP and non-PS site.

If I can pack in enough new knowledge over the next day or two to figure out just what on earth is going on in the actual HUD code, and get it to actually display my hud, instead of just a little window saying it's displaying the HUD, then we should have total site agnosticism for that part.

It does.

Now run:

# mysql -u root -p

Try a blank password, or the one you set it up with, or post the errors back.

IF anyone cares, I just imported about 9000 hands in approx 15 minutes, using the current alpha8. Only a couple dozen errors importing, this time, too .. and not to worry anyone, i'm not using PS or FTP, but a converter to PS from another site, and both the site and the converter are known to do some strange things some times.

Also have the HUD working fully in Windows for non-PS/FTP sites, as far as I can tell, though you obviously still need some way of getting the data INTO the database, so it won't just magically work for anyone unless you have a Your Site to PS or FTP HH converter.

I think my next area of research might be into making the HUD more usable, unless someone else has already managed to do work on making pieces of it not visible when they shouldn't be, it's pretty difficult to multitable with a few dozen always-on-top windows on.

perry@perry-laptop:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
perry@perry-laptop:~$

Tried blank password, tried root password.

Gotcha - looks like mysql isn't started.

sudo /etc/init.d/mysql start

Then try my last post

If you want to add your code to the main tree you should send me a patch very soon. The quicker you send, the easier it will be for me to figure it out and add to the tree.

I was going to say that you don't need to change anything inside Hud.py to support a new site, but I think you have figured that out.

If you look back through the thread you should notice some posts between Eleactic Stranger and me. He is 16 tabling and has done some hacks to (somewhat) support that. My git repo has the beginnings of such support. In that code the stat windows will minimize when you minimize the hud table window. They will unminimize when you unminimize the hud table window. (I have done the easy part. ) What is needed is a way to detect when a new window is on top. I have started playing with that on Linux, but you could really help by figuring that out on Windows. If you want to work on that, don't even bother putting it in the HUD, just a simple demo program that writes to stdout when a new poker table window is on top.

My git repo is here: git://git.assembla.com/free_poker_tools.git

get a copy with:

git clone git://git.assembla.com/free_poker_tools.git

do that in a new folder so that you don't clobber your changes. There are some other changes from alpha8 in my repo, most notably the integration of the 2 cofig files. All config info is now in HUD_config.xml.

I guess I'm going to need to figure out how to operate this git thingee.. :| but for now, i do have a unidiff from alpha8 .. where to send?

I did make some changes to Hud.py, adding a "FPDBHUD" tag to window names, so that they could easily be identified as "not the poker table itself", attempted to add error checking to the create() function, which did not work properly, and adding a bunch of debug code, that suddenly mysteriously stopped the interpreter from locking up in the middle of what appeared to be perfectly valid code, otherwise.

I put a note on the FPDB forum, that current form of my patch will break Linux/Mac, as I did not write a function for those platforms for determining a specific window by name... but i'd guess whoever wrote those functions to begin with would easily be able to adapt one to fit.

I have PMed you my email address.

I found the problem, it turns out there is two mysql, mysql-client, but the one I needed turned out to be called mysql server. I would hate ubuntu, if it wasn't what I wanted Windows to be.

Anyways, thank you guys a lot for helping me, really appreciate this.

My apologies for leaving off mysql-server from the packages requiring install. Should have been an easy fix.

I know you've sent the patch to Eratosthenes, but could you post it to the mailing list, its a lot easier to disect that way. (https://****************/mail/?group_id=226872)

alright, everyone, i'm on the mailing list now, so i guess i'll be using that for the dev talk and stop confusing all the people who are sure that programming is all about knowing when to boil the orange sponge donkey across the phillipines

Hello Everyone, me again.

You know when I said I got the problem sorted out, turns out that was just naivety talking.

Ok I have done the whole Create Database part, and set up a .fpdb folder and copied the default.conf document, and edited it with my password. Now it tells me to double-click pyfpdb/fpdb.py

Is that the one in the archive manager, as I seem to be just going to a text file, and nothing else happens?

I'm not sure what this is supposed to look like windows - is pyfpdb/fpdb.py still in a zip archive? It should be in Program Files/fpdb/ i think

The file is just a text file, i needs to be opened by the python interpreter. Try right-clicking the file and select Open with...

The find and select python.

Can any windows guys give better instructions?

The installer doesn't unzip the fpdb archive. When you unzip that, you should have a subdir that is pyfpdb--double click the fpdb.py file in there. Yes it is just a text file with python commands in it.

Someone is working on improving the Windows installer, but I just unzipped the whole pyfpdb archive onto E:\fpdb , then I run e:\fpdb\pyfpdb\fpdb.py .. python installs itself to be auto associated with .PY files, so it should work right.

Here's a screenshot of some recent work, illustrating that we seem to have solved most of the problems associated with window overlap

http://img186.imageshack.us/img186/2846/fpdbtp0.jpg

this should be posted to the fpdb page in the next day or two

Thanks so much for creating this! My installation problems seem similar to those already discussed, but after trying many fixes, I still can't get fpdb running. (1.0 alpha 8 p137 on Windows XP)

I choose 2 passwords at the beginning of the fpdb install process. MySQL and Python appear to have have been installed, even though I have not been prompted for either of the new passwords I just chose. (MySQL is now in my Program Files folder and Python is in the C: folder).

My default.conf file in C:\Documents and Settings\BP\Application Data\fpdb looks like:
db-backend=2
db-host=localhost
db-databaseName=fpdb
db-user=fpdb
db-password=****(the poker db user password I choose during fpdb install)
tv-combinedStealFold=True
tv-combined2B3B=True
tv-combinedPostflop=True
bulkImport-defaultPath=default
hud-defaultPath=default
imp-callFpdbHud=True

My fpdb-error-log.txt is:
Traceback (most recent call last):
File "C:\Documents and Settings\BP\Desktop\FPDB\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Documents and Settings\BP\Desktop\FPDB\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Documents and Settings\BP\Desktop\FPDB\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Documents and Settings\BP\Desktop\FPDB\pyfpdb\fpdb.py", line 330, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\Documents and Settings\BP\Desktop\FPDB\pyfpdb\fpdb_db.py", line 43, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

My HUD-error.txt is:
Traceback (most recent call last):
File "C:\Documents and Settings\BP\Desktop\FPDB\pyfpdb\Database.py", line 61, in __init__
db = c.supported_databases[db_name].db_name)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

Each time I click on fpdb.py in the pyfdb folder I still get a command prompt with a very quick error message.

Thanks, in advance for your help and the additional improvements your doing. I'd love to make this application work!

I was going to download this, but then I saw it didn't support MTT's

These mysql errors are a little mysterious to me, but I think this indicates that mysql is not running. You need to start it in the system services area of the control panel--I don't have windows right now, so I can't be more specific. The other thing that occurs to me is that you might not have restarted XP after running the installer.

You can test if mysql is running by opening the mysql client that is somewhere in your start menu. Just give it your username and password and you should see a prompt like this:
mysql>
exit and enter makes it go away.

Keep your eye on this thread. We will have STT and MTT support going pretty soon. You are not the only person bugging me about this.