Postgres database setup in vmware windows virtual machine

[JeyBurns]

Hello,

did anyone succeed in setting up a postgreSQL database in a vmware virtual machine? I already installed Pokertracker and now tried to install postgres according to the PT howto. The installation failed. Unfortunately I didn´t copy the error message.

I run (K) ubuntu linux and kindly ask you to post your recommendations.

Thanks in advance.

[APerfect10]

PT3 Beta 6 with PostgreSQL 8.3 installed fine for me running WinXP in VMWare (under Vista).

Where is the installation failing? If you can provide me the error message I can probably assist you.

Best regards,

Derek

[_dave_]

If you are running Kubuntu (or any linux host with PT3 in a VM) - it is my recommendation to install the linux build of PostgreSQL on the host. This way yor databases are available to any VM shgould you create new ones in the future - and setup is probably easier (just install postgres however your distribution usually would.

Once Postgres is up and running under linux, just enter the host's IP address in to the PT3 setup when it asks where your database is located, and all should be well

[JeyBurns]

If you are running Kubuntu (or any linux host with PT3 in a VM) - it is my recommendation to install the linux build of PostgreSQL on the host.

At the moment, I run PT 2 within vmware under kubuntu. Is there any difference?
Of cours, I plan to switch to PT3 later, but at the moment it is very important to get PT2 running in order to back up my old data from a semi - destroyed windows installation. The boot sector crashed and I couldn´t get it running again. Fortunately, my directories weren´t harmed, so I still have them stored.
Is it possible to do this restore process using postgreSQL in Linux?

This way yor databases are available to any VM shgould you create new ones in the future - and setup is probably easier (just install postgres however your distribution usually would.

I use Kubuntu 7.10 Gutsy Gibbon. Would it be difficult to install? Is there anything to keep in mind, concerning certain settings?

[JeyBurns]

Just an update - it took longer than I thought. Now I found some time again.

I was able to set up postgresql as recommended in my linux environment and not in the virtual machine. I set up a running server and now tried to point to it from whithin vmware / pokertracker.

It asks for the "ODBC entry to use". this field is obviously blank, as I didn´t install an ODBC driver yet. Which one should I use for Postgresql 8.2?

I already found a lot of possible files, but I´m not sure, which one is the best pick. http://www.postgresql.org/ftp/odbc/versions/dll/

[JeyBurns]

Which one should I use for Postgresql 8.2?

I already found a lot of possible files, but I´m not sure, which one is the best pick. http://www.postgresql.org/ftp/odbc/versions/dll/

I installed these drivers: http://www.pokertracker3.com/products/P ... teodbc.exe
http://www.pokertracker3.com/products/P ... bc_new.exe

- There is still no entry in the ODBC field in Pokertracker running within vmware. What do you recommend trying next?

Edit: I messed it up. The drivers mentioned above are special ones for compatibility with certain poker sites.
However, the problem still remains unsolved. I just don´t want to go through every possible driver and rather have a clear recommendation from someone running it succesfully. I´m afraid of screwing my system. (I know, you can take snapshots of the vm and go back if something messed up, but I didn´t test this yet)

[JeyBurns]

I found a working ODBC driver file.

I entered all data in Pokertracker succesfully, but (what a wonder) I can´t connect to the postgresql database.
The error message is:

Code: Select all

Error #: 1
Unable to connect to PostgreSQL (Port #: 5432) to get the list of databases. The error was:
101 - SQLSTATE = 08001
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "192.168.xxx.xx" and accepting TCP/IP connections on port 5432?

The server is running in Linux. Username and Password are verified and should be correct.

By the way: I´d rather have edited my entries, but this is only possible for a short period of time. Sorry for the mess created by my posts.

[APerfect10]

Please copy/paste the bottom 10 lines in your PostgreSQL pg_hba.conf file where it lists what connections are accepted by PostgreSQL.

Best regards,

Derek

[JeyBurns]

Please copy/paste the bottom 10 lines in your PostgreSQL pg_hba.conf file where it lists what connections are accepted by PostgreSQL.

Hi Derek,

here are the relevant lines of my pg_hba.conf. I'm also pretty sure that the error lies in these lines. I just can't tell where.

Code: Select all

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5
host   all   all   192.168.171.33   trust
host   all   all   192.168.172.128   trust

Is spacing between the different values relevant?

When I open the log file, I find the following errors:

Code: Select all

2008-05-01 11:42:37 CEST LOG:  incorrect IP-mask »trust« in file »/etc/postgresql/8.2/main/pg_hba.conf« line 84: Name or service not known
2008-05-01 11:42:37 CEST FATAL:  missing or incorrect entry in pg_hba.conf-file

The above mentioned line 84 is this one:

Code: Select all

host   all   all   192.168.171.33   trust

Thanks for your help in advance

Jey

[APerfect10]

No, the spacing is irrelevant. Change those lines to:

Code: Select all

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         192.168.0.0/16        md5
# IPv6 local connections:
host    all         all         ::1/128               md5

That should work for you.

Best regards,

Derek