Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > > >

Notices

Free Software Discussion of Free / Freeware / Donationware / Open Source poker software and Free Graphics mods

Reply
 
Thread Tools Display Modes
Old 10-28-2008, 10:46 PM   #601
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Eratosthenes View Post
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.
I'm pretty sure mysql wasn't running, or it hasn't been completely installed, since it didn't appear anywhere in the start menu or in control panel, nor was it in the running processes list in task manager, however the MySQL folder was in program files. I did remember to restart XP after running the installer.

I removed all mysql files, fpdb installer and alpha files (but kept Python, since I do see it in the start menu) and then re-installed the installer, but this time without my zonealarm security suite running. The installation went more smoothly than the first time and I then restarted XP. The mysql folder is back in program files, but mysql still doesnt appear in the start menu or running processes list.

Should I have a mysql link in the start menu after running the fpdb installer? Is there a file in the mysql folder (in program files), that I can use to run mysql or install or configure mysql?

Quote:
Originally Posted by Eratosthenes View Post
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.
I chose a password for mysql (and the poker db) during instalation, but do not have a mysql username. Do I need one? How do I do that?

What is the .tar file? Is this recommended as opposed to the zip file?

Here is the latest error log. Thanks again for your help!

Traceback (most recent call last):
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\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:\Program Files\FPDB\fpdb-1.0_alpha8_p137\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)")
Clemenza is offline   Reply With Quote
Old 10-28-2008, 10:57 PM   #602
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Clemenza View Post
I'm pretty sure mysql wasn't running, or it hasn't been
Should I have a mysql link in the start menu after running the fpdb installer? Is there a file in the mysql folder (in program files), that I can use to run mysql or install or configure mysql?
Right click My Computer, select manage
Services and Applications -> Services

You should have MySQL in the services list, does it show its status as Started? If not start it and try running fpdb again.

You may also need to make an exception for localhost for the MySQL process in ZoneAlarm. (Port 3306)
sorrow is offline   Reply With Quote
Old 10-29-2008, 12:26 AM   #603
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by sorrow View Post
Right click My Computer, select manage
Services and Applications -> Services

You should have MySQL in the services list, does it show its status as Started? If not start it and try running fpdb again.

You may also need to make an exception for localhost for the MySQL process in ZoneAlarm. (Port 3306)
Thank-you, Sorrow and Eartosthenes!

I did find MySQL in the services list but I am unable to start it. I keep getting:
"Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly."

I tried changing the "Log On" settings in MySQL properties (from the services list in Computer Management) to logon as Administrator including my PC's administrator password. But I still get the error message when I try to start MySQL.

Any other ideas? I feel like I'm getting closer to getting this to work. Persistency pays!
Clemenza is offline   Reply With Quote
Old 10-29-2008, 12:47 AM   #604
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Clemenza View Post
Thank-you, Sorrow and Eartosthenes!

I did find MySQL in the services list but I am unable to start it. I keep getting:
"Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly."
I finally decided to run the install on a windows xp machine to see what it looks like - and i'm getting exactly the same message when trying to start MySQL.

I'll see if i can't track it down.
sorrow is offline   Reply With Quote
Old 10-29-2008, 01:07 AM   #605
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by sorrow View Post
I'll see if i can't track it down.
Can you try running from a command prompt

cd \program files\mysql\mysql 5.0\bin
mysqld --standalone --console

I'm getting:
Files\MySQL\MySQL Server 5.0\bin>mysqld --console --standalone
081029 13:58:00 [ERROR] Can't find messagefile 'C:\Programme\MySQL\MySQL Server
5.0\share\english\errmsg.sys'
081029 13:58:00 [ERROR] Aborting

Which make it look like the installer got the language wrong.

I'll see if i can figure which files need to be edited, for now though you might want to download and run the mysql installer from http://dev.mysql.com/downloads/mysql/5.0.html#win32
sorrow is offline   Reply With Quote
Old 10-29-2008, 01:52 AM   #606
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by sorrow View Post
Can you try running from a command prompt

cd \program files\mysql\mysql 5.0\bin
mysqld --standalone --console

I'll see if i can figure which files need to be edited, for now though you might want to download and run the mysql installer from http://dev.mysql.com/downloads/mysql/5.0.html#win32
Sorrow, From the command prompt, all I could get is:

C:\Documents and Settings\BP>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
C:\Documents and Settings\BP>cd \
C:\>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
C:\>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.


Do you recommend the "Windows Essentials" version of MySQL v5.0? Or are extra tools, or another version needed.

Also, should I delete the MySQL folder in Program Files or just install over what I have? (MySQL soes not appear in my Add/Delete Programs and there are no start menu shortcuts, however the MySQL folder in Program Files appeared after I ran the fpdb installer.)
Clemenza is offline   Reply With Quote
Old 10-29-2008, 02:01 AM   #607
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Clemenza View Post
Sorrow, From the command prompt, all I could get is:

C:\Documents and Settings\BP>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
C:\Documents and Settings\BP>cd \
C:\>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
C:\>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
Sorry, didn't copy and paste.

cd \program files\mysql\mysql server 5.0\bin
Quote:
Originally Posted by Clemenza View Post

Do you recommend the "Windows Essentials" version of MySQL v5.0? Or are extra tools, or another version needed.
No idea - I'm guessing the setup.exe version may be easier.

Quote:
Originally Posted by Clemenza View Post
Also, should I delete the MySQL folder in Program Files or just install over what I have? (MySQL soes not appear in my Add/Delete Programs and there are no start menu shortcuts, however the MySQL folder in Program Files appeared after I ran the fpdb installer.)
Try installing over the top, if that fails uninstall then delete and see if that makes a difference.
sorrow is offline   Reply With Quote
Old 10-29-2008, 02:11 AM   #608
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Okay, thanks. This time I got:

C:\>cd \program files\mysql\mysql server 5.0\bin

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld --standalone --console
081029 2:06:34 [ERROR] Can't find messagefile 'C:\Programme\MySQL\MySQL Server
5.0\share\english\errmsg.sys'
081029 2:06:34 [ERROR] Aborting

I'll try downloading and installing MySQL again tomorrow and see if that does the trick.
Clemenza is offline   Reply With Quote
Old 10-29-2008, 02:34 AM   #609
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Ok, Same error.

c:\program files\mysql\mysql server\5.0\my.ini

Has 2 lines in it that need editing:
basedir=
datadir=

Change "Programme" to "Program Files" and you should be able to start mysqld, same instructions as previously.

I now have another error with gtk, I suspect its from a previous install of gtk from Gimp
sorrow is offline   Reply With Quote
Old 10-29-2008, 03:19 AM   #610
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by sorrow View Post
c:\program files\mysql\mysql server\5.0\my.ini

Has 2 lines in it that need editing:
basedir=
datadir=

Change "Programme" to "Program Files" and you should be able to start mysqld, same instructions as previously.
Excellent! I just edited those 2 lines and MySQL is now running.
Sorrow, thanks for fixing that!

If you or anyone can advise, I'm now apparently having a password problem. According to previous posts in this thread, I think the info is correct but last line in the error file is "Access denied for user...":

Traceback (most recent call last):
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\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:\Program Files\FPDB\fpdb-1.0_alpha8_p137\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: (1045, "Access denied for user 'BP'@'localhost' (using password: YES)")


My default.conf in Application Data\fpdb is:

db-backend=2
db-host=localhost
db-databaseName=fpdb
db-user=BP (my PC's Admin name)
db-password=**** (the MySQL Root Password I chose during fpdb install)
tv-combinedStealFold=True
tv-combined2B3B=True
tv-combinedPostflop=True
bulkImport-defaultPath=default
hud-defaultPath=default
imp-callFpdbHud=True


Is this correct?

Will I need to use the "Poker DB User Password" that I also chose during fpdb install?

Do I need to adjust the settings in Computer Management > Services > MySQL > Properties > Log On. Right now I have it set to "Log on as: Local System account".

Thanks so much!
Clemenza is offline   Reply With Quote
Old 10-29-2008, 03:33 AM   #611
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Clemenza View Post
db-databaseName=fpdb
db-password=**** (the MySQL Root Password I chose during fpdb install)
Will I need to use the "Poker DB User Password" that I also chose during fpdb install?

Do I need to adjust the settings in Computer Management > Services > MySQL > Properties > Log On. Right now I have it set to "Log on as: Local System account".

Thanks so much!
the db-password is the Poker DB password, but i suspect that was never set during setup due to your previous problem

Local System Account is correct, it should work either way though.

From a command prompt:
cd \program files\mysql\mysql server 5.0\bin

mysql -u root -p
(Enter password here - may be blank due to error)
> create database fpdb;
> GRANT ALL PRIVILEGES on fpdb.* to fpdb identified by 'fpdbpassword';
> FLUSH PRIVILEGES;
> exit

Then try and run fpdb again.

Last edited by sorrow; 10-29-2008 at 03:33 AM. Reason: Typo
sorrow is offline   Reply With Quote
Old 10-29-2008, 05:18 AM   #612
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by sorrow View Post
the db-password is the Poker DB password, but i suspect that was never set during setup due to your previous problem

From a command prompt:
cd \program files\mysql\mysql server 5.0\bin

mysql -u root -p
(Enter password here - may be blank due to error)
> create database fpdb;
> GRANT ALL PRIVILEGES on fpdb.* to fpdb identified by 'fpdbpassword';
> FLUSH PRIVILEGES;
> exit

Then try and run fpdb again.
Thanks, Sorrow.

From the command prompt I was able to just hit enter instead of the password (all passwords attempted did not work anyway), so I guess I don't have a MySQL root password yet. I entered all of the info and granted all privileges to the Poker DB Password I chose during fpdb install which is now also the same as is in the default.conf file in the Application Data folder.

But fpdb still does not work when I click on fpdb.py in the pyfpdb folder.
The latest error code is below.
Do I need a root password for MySQL?
What should db-user= be in the default.conf file?
Am I missing something obvious?

Traceback (most recent call last):
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\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:\Program Files\FPDB\fpdb-1.0_alpha8_p137\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: (1045, "Access denied for user 'BP'@'localhost' (using password: YES)")
Clemenza is offline   Reply With Quote
Old 10-29-2008, 05:27 AM   #613
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Its not you its me.... (Note: db-password is the fpdb password, not the root password)

cd to the mysql server /bin folder from command prompt again.

Try:
mysql -u BP -p
(fpdb password)

If that fails, i'm pretty sure we forgot to create the user properly. Teach me to do support from memory.

mysql -u root -p
(root password, still <enter> I think)
> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'some_pass';

Then try it again with same config file.

FYI, to get the HUD working you'll need to edit HUD_config.xml and add the same username and password

Last edited by sorrow; 10-29-2008 at 05:28 AM. Reason: remove footnote reference
sorrow is offline   Reply With Quote
Old 10-29-2008, 06:14 AM   #614
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by sorrow View Post
Try:
mysql -u BP -p
(fpdb password)

If that fails,

mysql -u root -p
(root password, still <enter> I think)
> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'some_pass';

Then try it again with same config file.
The mysql -u BP -p did not work when I entered the fpdb password.

I tried the second option with 'some_pass' as the fpdb db-password and didnt receive any error messages and then typed "exit", but still no luck in getting fpdb to run.

I then ran the first command again trying the fpdb password but received:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u BP -p
Enter password: ********
ERROR 1045 (28000): Access denied for user 'BP'@'localhost' (using password: YES)

Then I tried again, but hit enter (no password) and got:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u BP -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.67-community MySQL Community Edition (GPL)
mysql>


Does this mean I have no password for MySQL or the fpdb???
Clemenza is offline   Reply With Quote
Old 10-29-2008, 06:24 AM   #615
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Actually, here is the command prompt screenshot after I just tried the "mysql -u root -p" and just hit enter when prompted for a password:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\BP>cd \program files\mysql\mysql server 5.0\bin

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword'
->

Does this help figure out what the problem is?
Clemenza is offline   Reply With Quote
Old 10-29-2008, 06:38 AM   #616
ekdikeo
old hand
 
Join Date: Aug 2006
Posts: 1,307
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

someone might want to research if upper-case usernames are accepted in MySQL, i wouldn't know why they wouldn' tbe, but just seems like something that could be a problem.

I had the c:\programme\mysql .. problem, too, but as soon as i fixed that, the service started right up, and i was able to connect using the username and password that i selected when i ran the installation.
ekdikeo is offline   Reply With Quote
Old 10-29-2008, 06:47 AM   #617
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

When did you select a username during installation?

I recall selecting and confirming a Poker DB Password and a MySQL root password, but no username.
Clemenza is offline   Reply With Quote
Old 10-29-2008, 09:08 AM   #618
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Clemenza View Post
mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword'
->
This statement needs a semicolon ( ; ) at the end

That is
mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword';
Eratosthenes is offline   Reply With Quote
Old 10-29-2008, 12:12 PM   #619
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Weird - didn't get an email notification you'd responded - sorry.

in mysql just to confirm a couple of things.

> show databases;

and make sure fpdb is there.

After the GRANT ALL command, you must:
> FLUSH PRIVILEGES;

Or it won't take, i had that in my original post but forgot in the next couple.
sorrow is offline   Reply With Quote
Old 10-29-2008, 12:16 PM   #620
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

One more thing from within mysql

> use mysql;
> select user, host from user;
sorrow is offline   Reply With Quote
Old 10-29-2008, 02:53 PM   #621
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

It's almost working! Thank-you Sorrow and Eratoshtenes!

I also edited the HUD_config file and added my fpdb password and username. When I clicked on fpdb.py the application opened along with a command prompt indicating that it failed to load graphing and that I need to recreate the tables. After I clicked "Recreate Tables" in the "Database" dropdown menu, the comand prompt said "finished recreating tables". I'm going to continue playing around with it and post again on my progress.

Here is my command prompt after trying all of the above.

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password: (I just clicked "enter")
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases; (It looks like the fpdb database is here)
+--------------------+
| Database |
+--------------------+
| information_schema |
| fpdb |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> use mysql;
Database changed
mysql> select user, host from user;
+------+-----------+
| user | host |
+------+-----------+
| fpdb | % |
| root | 127.0.0.1 |
| | localhost |
| BP | localhost |
| bp | localhost |
| root | localhost |
+------+-----------+
6 rows in set (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.0\bin>
Clemenza is offline   Reply With Quote
Old 10-29-2008, 06:45 PM   #622
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Quote:
Originally Posted by Clemenza View Post
It's almost working! Thank-you Sorrow and Eratoshtenes!

I also edited the HUD_config file and added my fpdb password and username. When I clicked on fpdb.py the application opened along with a command prompt indicating that it failed to load graphing and that I need to recreate the tables. After I clicked "Recreate Tables" in the "Database" dropdown menu, the comand prompt said "finished recreating tables". I'm going to continue playing around with it and post again on my progress.

Here is my command prompt after trying all of the above.

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password: (I just clicked "enter")
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases; (It looks like the fpdb database is here)
+--------------------+
| Database |
+--------------------+
| information_schema |
| fpdb |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> use mysql;
Database changed
mysql> select user, host from user;
+------+-----------+
| user | host |
+------+-----------+
| fpdb | % |
| root | 127.0.0.1 |
| | localhost |
| BP | localhost |
| bp | localhost |
| root | localhost |
+------+-----------+
6 rows in set (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.0\bin>
It looks like you are running OK. You could try the bulk importer now.
Eratosthenes is offline   Reply With Quote
Old 10-29-2008, 09:17 PM   #623
Clemenza
centurion
 
Join Date: Mar 2005
Posts: 138
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Fpdb is running fine now. No more MySQL issues.
Thanks everyone for your help!

I ran the bulk importer. The HUD is working well with Stud, Hi/Lo and Razz.

This is an excellent application!
Clemenza is offline   Reply With Quote
Old 10-29-2008, 10:10 PM   #624
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha8 - bugfix) - 17-Oct-2

Good to hear.

The graphing wont work without matplotlib, numpy and pylab which aren't included in the windows installer yet. For *nix these are standard packages, but i've not found (nor looked too hard to be honest) a "nice" windows installer for these additional python modules yet.

For the ambitious the home pages:
http://numpy.scipy.org/
http://scipy.org/ (http://prdownloads.****************/s...5.exe?download)
http://matplotlib.****************/
sorrow is offline   Reply With Quote
Old 10-30-2008, 11:31 PM   #625
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha6 - bugfix) - 04-Oct-2

Real multitabling support has been added to the fpdb git tree, mostly due to the work of ekdikeo (yeah, we have 4 developers now--all are welcome). Stat windows will be appropriately hidden when you are using cascaded/stacked tables.

This has been tested on Linux and Windows, though Stars is not popping up tables correctly for me on Linux, it is not a problem with fpdb. This has not been tested on Full Tilt, but I don't see any reason why it won't work on FTP.

The other recent addition that might be interesting to the multitable crowd is preferred seat support on PokerStars. To get that going you need to edit your HUD_config.xml file, find the correct line that looks like this:

<layout fav_seat="5" height="546" max="8" width="792">

and set the fav_seat to the one that you have set up in PokerStars. Note that the example above is for an 8 max table; be sure to select the correct max. Setting fav_seat="0" turns off the feature.

We would be interested in feedback from anybody using these features.

This is not in the main repo yet and is not in a release, so get it with git from my repo with:

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

Lastly, you may think that not much has been done on this recently, but there have been some good "infrastructure" improvements that users don't see but will provide convenience and stability later on, plus some good ease of use things that aren't ready for prime time, like consolidating the config files and improving the windows installer.
Eratosthenes is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 12:03 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © 2008-2017, Two Plus Two Interactive
 
Poker Players - Streaming Live Online