#1
|
|||
|
|||
Please Help....Database is filled with 0's
Picture 1.jpg
Picture 2.jpg Hi, I been working on this for the whole day and still can not figure this out. I filled everything out and uncheck the "Scan Cache Only" and still nothing shows up as Zero's. Im not sure if the database name has to do with anything but i left it blank. I tried putting in full tilt and SQL dtatbase and still not work. I am not sure how I should get this to work. ANy Help would be great.. Tommy |
#2
|
|||
|
|||
What type of database software are you using? And by that I mean HoldemManager or PokerTracker3 or PokerStrategy Elephant? The database name is important, TableScan needs the name of the database in order to connect to it
If you want, send me a message on AIM/MSN/ICQ/Skype and I can explain if theres any misunderstandings and I can look on teamviewer and see if theres any issues AIM: ZandryTST MSN: [email protected] ICQ: 571846001 Skype: ZandryTST |
#3
|
|||
|
|||
Hi, I am using Poker Tracker 3.
Whenever I put a name on the database like Full Tilt, it saids the name is wrong. Im not sure what name I should put in there, please help. |
#4
|
|||
|
|||
Alright, well, the issue is, TableScan will not allow you to enter a name manually, unless you have entered an incorrect username/password.
Then you will get a popup informing you that it could not connect to the database, and only after that will it allow you to enter a database name manually. If you had the correct username/password, then instead of you entering the database name manually, when you hit "Get Databases" you would be presented with a dropdown box which shows all of your available databases. So, the default username/pass for PT3 is username: postgres password: dbpass you could also try "postgrespass", or "svcpass" - but note that if you fail to get the password, you should cancel the add database and re-open the window, otherwise it will not give you the dropdown list of your databases once it has failed once. But if you changed the password to something else, then you will not be able to connect. But, there is a way to set up postgres to accept any password. Here is how you do it: 1) First, you want to find out your username. You should be able to see your username if you go in PT3 > Manage Databases. If that doesn't work, you can get it in the windows command prompt by going to Start > Run in windows and typing "cmd" into the box. Once you have your command prompt open, type "net user" then hit enter. This will list all the users on your machine. One of the users should be named "postgres", if not then you have to figure out which username you created for postgres 2) Now, to set it so it will accept any password: In Windows go to Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf Scroll to the bottom where you will see this code Code:
# TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: #host all all ::1/128 md5 Code:
# TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: #host all all ::1/128 md5 Start > Programs > Postgresql 8.3 > Stop service then Start > Programs > Postgresql 8.3 > Start service This will enable your database to accept any password when trying to connect. Again, if you need help with this just send me a message on AIM/MSN/ICQ/Skype P.S. The default database name for PT3 is "PT3 DB". But that won't help if you dont have the right username/password |
#5
|
|||
|
|||
wow you are good dude, I just input PT3 DB and it worked..
Everything is working great now and i see the stats. The only bad side about it, is that it shows only little stats about the players.. maybe i just need to reconfiguer the database or something.. But overall, this is awsome..thank you |
Tags |
database, not showing. |
Thread Tools | |
Display Modes | |
|
|