Page 1 of 1

Problem with PostgeSQL at setup

PostPosted: Sat Jan 07, 2012 8:34 pm
by gramsyn
Hello everybody.

I am new to Pokertracker. I use Linux operating system (Ubuntu) and I have heard that Pokertracker works fine through Wine. For example Pokerstars software works.

I ran the setup program through Wine and I think everything went ok. Then I followed the instructions for the setup of the PostgreWQL. However, I tried to change passwords. Then, tried the default ones, but I get two messages stating the following:

Code: Select all
"Unable to create PostgreSQL database: PT3 DB
Reason: Unable to login to database (template 1).
Reason: FATAL: password authentication failed for user "postgres"


Code: Select all
    The directory PostgreSQL is to be installed to already exists. If PostgreSQL has ben installed in this computer in the past, please make sure the directory is deleted before continuing.

    The directory that must be removed is:

    C:\Program Giles\PostgreSQL\8.3


I loged through Windows and deleted the dir C:\Program Giles\PostgreSQL\8.3 so it may be created properly, but it doesn't, either I run setup from Windows or from Ubuntu by Wine.

Any ideas please?

Re: Problem with PostgeSQL at setup

PostPosted: Sun Jan 08, 2012 10:56 am
by kraada
You need to edit postgresql.conf to allow access via the IP address range that WINE's networking sees itself under. See this post for the details on how to edit postgresql.conf. The file will be located in /etc/postgresql/9.0/main/ - note that even though Ubuntu has PostgreSQL 9.1 packages, PT3 only supports up to 9.0 (and if you're using 8.3.x or 8.4.x replace 9.0 in the path with 8.x as appropriate).

Re: Problem with PostgeSQL at setup

PostPosted: Sun Jan 08, 2012 2:13 pm
by gramsyn
Thanks for the answer.

I checked the link. It sticks with server accessing from different PC's. I think that this is not the case. However I changed the files as it said. The only difference from the instructions is that the third number from my IP was 2 (not 0 or 1). So I pasted the same line as it says but with my IP. I have also deleted the folde 9.4 from etc/Postgresql and left only 8.4.

I then ran PokerTracker3. It requested to install PostgreSQL. I click the defaults. Then the same messages appear. I am stuck.

Any more suggestions?

Re: Problem with PostgeSQL at setup

PostPosted: Sun Jan 08, 2012 2:16 pm
by gramsyn
If I click not to install PostgeSQL it leads me to the screen where I connect to the db. I leave the defaults and click connect but returns a message sauing the there is wrong configuration. Maybe some wrong port? How can I check that?

Re: Problem with PostgeSQL at setup

PostPosted: Mon Jan 09, 2012 11:11 am
by kraada
What version of WINE are you using? If you paste the output of ipconfig /all in wine and an ifconfig in a terminal in the main OS that will help.

Re: Problem with PostgeSQL at setup

PostPosted: Fri Jan 13, 2012 8:09 pm
by gramsyn
Thanks for the reply and sorry for the delay

The version of wine is 1.3.28

I cannot understand what you mean by: "paste the output of ipconfig /all in wine".

The output of ifconfig
Code: Select all
eth0      Link encap:Ethernet  HWaddr 1c:6f:65:4e:e0:6b 
          inet addr:192.168.2.3  Bcast:192.168.2.255  Mask:255.255.255.0
          inet6 addr: fe80::1e6f:65ff:fe4e:e06b/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:606934 errors:0 dropped:0 overruns:0 frame:0
          TX packets:775553 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:214097302 (214.0 MB)  TX bytes:408185931 (408.1 MB)
          Interrupt:41 Base address:0x4000

lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:652 errors:0 dropped:0 overruns:0 frame:0
          TX packets:652 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:95985 (95.9 KB)  TX bytes:95985 (95.9 KB)

Re: Problem with PostgeSQL at setup

PostPosted: Mon Jan 16, 2012 10:33 am
by kraada
Add this line at the bottom of your pg_hba.conf and restart the server:

host all all 192.168.2.0/24 md5

That will likely get things working for you.

highfalutin