Postgresql on MAC OSX and PT4 on VMware

A special forum dedicated to our PT4 for Mac OS X users

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Mon Jun 03, 2013 3:10 pm

Hi,

I own a MacBook Pro with OSX installed and want to play Zoom with a HUD. I understood that I should install Pokerstars and Pokertracker 4 in VMware (Win7) and postgresql on my OSX system (which would also allow me to play everything else than Zoom in OSX). So far, so good (installation done).

BUT: How do I access the postgresql DB from VMware? Sorry, but I am a noob in all these DB and networking configuration things.

Is there a step-by-step tutorial somewhere? Or anything else that could help me?

Thanks lot in advance, Thilo
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Re: Postgresql on MAC OSX and PT4 on VMware

Postby kraada » Mon Jun 03, 2013 4:59 pm

The way to do this is to configure PostgreSQL to allow other machines on the VMWare's virtual subnet to be able to connect. See here for details on how to configure PostgreSQL to allow other machines to connect, and you can find your VMWare machine's IP address by clicking Start, typing cmd, clicking on it and typing ipconfig /all and hitting enter. It will be listed as the IPv4 Address.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Tue Jun 04, 2013 1:57 am

Already found the propposed tutorial.

BUT: Where are these files located: pg_hba.conf & postgresql.conf? I cannot find them on my MAC, neither Postgresql's Library nor in the Program folder.

Would it be possible to post a step-by-step solution that clearly shows what needs to be done on the MAC side and on the WIN side?
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Re: Postgresql on MAC OSX and PT4 on VMware

Postby kraada » Tue Jun 04, 2013 7:55 am

By default on OS X once PostgreSQL is installed they're in /Library/PostgreSQL/x.y/data/ where x.y is your version (at this point we recommend 9.0).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Tue Jun 04, 2013 4:26 pm

Ok, I found the files.

But if follow the instructions from IP Address from the Local Network (https://www.pokertracker.com/guides/PT4/tutorials/postgresql-server-hosted-on-a-local-network#ip-address-for-the-local-network), I receive this:

OSX: ifconfig

lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384
options=3<RXCSUM,TXCSUM>
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff000000
inet6 ::1 prefixlen 128
gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280
stf0: flags=0<> mtu 1280
en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
options=2b<RXCSUM,TXCSUM,VLAN_HWTAGGING,TSO4>
ether 58:b0:35:f2:38:d3
media: autoselect (none)
status: inactive
en1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 58:b0:35:73:1c:3c
inet6 fe80::5ab0:35ff:fe73:1c3c%en1 prefixlen 64 scopeid 0x5
inet 192.168.2.52 netmask 0xffffff00 broadcast 192.168.2.255
inet6 2003:62:460d:c101:5ab0:35ff:fe73:1c3c prefixlen 64 autoconf
inet6 2003:62:460d:c101:353c:dd48:6c0a:6251 prefixlen 64 autoconf temporary
media: autoselect
status: active
p2p0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 2304
ether 0a:b0:35:73:1c:3c
media: autoselect
status: inactive
fw0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 4078
lladdr d8:30:62:ff:fe:ec:44:e8
media: autoselect <full-duplex>
status: inactive
vmnet1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 00:50:56:c0:00:01
inet 192.168.212.1 netmask 0xffffff00 broadcast 192.168.212.255
vmnet8: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 00:50:56:c0:00:08
inet 192.168.185.1 netmask 0xffffff00 broadcast 192.168.185.255

There are three lines with 192.168.x.x in it - in these, the third digit is "2", "212" and "185" - none of them is a "0" or a "1" desired in the article.

So, what do I have to do now?

(Sorry for asking possibly stupid questions)
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Re: Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Tue Jun 04, 2013 4:32 pm

Oh, and another question: How do I add the database to PT4 (on VMware)? What do I have to enter in the database management dialogue?
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Re: Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Tue Jun 04, 2013 4:33 pm

And the last one: Maybe you could move my thread to the right forum? (as I posted it in Pokertracker 3 - but am actually looking for a solution for PT4)
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Re: Postgresql on MAC OSX and PT4 on VMware

Postby kraada » Tue Jun 04, 2013 5:18 pm

I think vmnet1 is the VMWare one - that's 192.168.212.1 so use 192.168.212.0/24. Once you've gotten the networking set up you can either create the database in PT4 in VMWare or connect to the one you already have from OS X - you can search for existing databases with the blue Browse Databases link in the Database -> Database Management -> New window.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Tue Jun 04, 2013 6:03 pm

I used 212 and added

host all all 192.168.212.0/24 md5

to pg_hba.conf (OSX) as an additional line at the bottom of the document. I also added

listen_addresses = '*'

as the last line to postgresql.conf as last line.

But I still can't find my OSX databases (even just created test-databases) in the windows PT4 by searching for them via the blue link in the DB management dialogue.

So what am I doing wrong? (I have postgresql installed on my vmware windows system - in case that matters)
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Re: Postgresql on MAC OSX and PT4 on VMware

Postby th1L0 » Tue Jun 04, 2013 6:10 pm

I just checked: Turning on VMware adds vmnet1 & vmnet2 to the output of ifconfig.
th1L0
 
Posts: 10
Joined: Fri May 31, 2013 11:12 am

Next

Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 10 guests

cron
highfalutin