PDA

View Full Version : connection to hm from virtual machine



yvonneasshigh
02-23-2010, 07:33 PM
hi, is there a way to connect from a virtualmachine (virtualbox) to the database of my realcomputer? I just want to install holdemmanager without a database on my virtual pc and then connection to the database of my holdemmanager on the real computer.

thanks

yvonneasshigh

Veteran68
02-23-2010, 09:23 PM
hi, is there a way to connect from a virtualmachine (virtualbox) to the database of my realcomputer? I just want to install holdemmanager without a database on my virtual pc and then connection to the database of my holdemmanager on the real computer.

thanks

yvonneasshigh

Do you have the network configured properly from the VM? The VM will need not only local networking to access the host PC, but also internet access to allow HEM to check its activation status. Once you have that working, then you just change the Server Name field in HEM's Database Management window to the host PC's IP/hostname instead of the default 127.0.0.1 (localhost) and it should work.

The Minder
02-23-2010, 11:42 PM
You also need the appropriate ODBC driver installed into the client.

netsrak
02-24-2010, 08:00 AM
I only installed pgadmin on the client and it works

yvonneasshigh
02-24-2010, 10:23 AM
hi many thanks so far, really nice!!

stupid quesiton but how do I install this ODBC driver or pgadmin?

veterean: change the Server Name field in HEM's Database Management window to the host PC's IP/hostname instead of the default 127.0.0.1 (localhost) and

---->if I do so, am I then still able to use holdemmanger also on my "real" machine?


many thanks

Veteran68
02-24-2010, 04:02 PM
You also need the appropriate ODBC driver installed into the client.
I was going on the assumption the full HEM installer would be used, which would include the driver and an unused instance of postgres. But yeah, if a stripped down HEM installer that doesn't contain postgres is used, then installing the client driver (or pgadmin that includes it) will be necessary.


stupid quesiton but how do I install this ODBC driver or pgadmin?
Per above, it's probably easiest to just install the full HEM installer, leaving the local postgres instance unused. But if you don't want to do that, you can try installing the ODBC driver from here (http://wwwmaster.postgresql.org/download/mirrors-ftp/odbc/versions/msi/psqlodbc_08_04_0200.zip). Or like netsrak said you could go to the pgAdmin website and download/install that.


veterean: change the Server Name field in HEM's Database Management window to the host PC's IP/hostname instead of the default 127.0.0.1 (localhost) and

---->if I do so, am I then still able to use holdemmanger also on my "real" machine?
Yes, but it will count as two installations against your activation.

I have to ask what you're trying to accomplish though? I first assumed you were trying to run HEM on a Linux/Mac box with a native postgres installation, but now you say you want to run HEM on the host too so that presumes a Windows host. Are you trying to just keep separate databases? Also if you intend to play and use a HUD in the VM, I don't have any idea how the HUD would perform in a VM environment, given how it uses graphic overlays and requires fast system support to be useful.

yvonneasshigh
02-24-2010, 04:45 PM
hi veteran

many many thanks!!!

I just want to play on the virtualmachine because my laptop got some database problems. And I thougth in a virtual machine it would work properly...so that I must not buy a new laptop....Pokertracker 3 got a method that you can install only pokertracker on the virtual machine and then access the database of your realcomputer. so I thought with holdem manager I could do the same....I will try as you said, I guess it should work too.....

many thanks so far

Veteran68
02-24-2010, 05:52 PM
hi veteran

many many thanks!!!

I just want to play on the virtualmachine because my laptop got some database problems. And I thougth in a virtual machine it would work properly...so that I must not buy a new laptop....Pokertracker 3 got a method that you can install only pokertracker on the virtual machine and then access the database of your realcomputer. so I thought with holdem manager I could do the same....I will try as you said, I guess it should work too.....

many thanks so far

If your laptop is your host, then if it has DB problems you're still going to have DB problems since the VM is going to be accessing the host laptop DB. I think perhaps you don't quite understand the usefulness or purpose of running software in a VM -- if I had to guess, PT3 was suggesting VMs as a way to run on unsupported OSes like OSX and Linux. Running in a VM on a supported host OS needlessly complicates matters and degrades performance. And on the off-chance you think you can still play poker on the host machine with HEM running in a VM, then you're really going to be disappointed. While the HH import could be made to work with a drive mapping to the host OS filesystem, the HUD would not work at all on the host PC since it's running in the VM. You'd have to actually play poker from within the VM to use the HUD, again with a hit to performance.

It all just seems like an unnecessary amount of effort that would lead to a unsatisfactory experience. Without a better reason (like an unsupported host OS) I think your efforts would be better spent fixing the DB problems with your laptop, which shouldn't be that difficult. Completely wipe postgres and reinstall, etc.

yvonneasshigh
02-24-2010, 05:58 PM
hi, ok nice to know that....I guess then I gotta buy a new laptop anyway....
somehow I thougth It would make a diffrence but it's too much time-consuming and unnecessary so you are right....but thanks anyway very very much for your nice support:)

infurrrno
12-11-2010, 03:20 AM
hey guys sorry to dig this up but it covers exactly my issue and I have a question about it:

how do you install hem on the guest but not postgres (as you're accessing the db of your host).

Thx

Sarek
12-11-2010, 04:44 AM
as mentioneed above, "just change the Server Name field in HEM's Database Management window to the host PC's IP/hostname instead of the default 127.0.0.1 (localhost) and it should work. "

infurrrno
12-11-2010, 07:22 AM
Following is a copy of my ipconfig details: (not sure which IP to enter).

Is it only the server name that you change in this window or must the port number and login details also be changed?

Thanks!

C:\Users\XXXX>ipconfig

Windows IP Configuration


Wireless LAN adapter Wireless Network Connection:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::e033:7e55:6083:ca8a%13
IPv4 Address. . . . . . . . . . . : 192.168.1.XXX
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.1

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::ecf6:2c87:bb72:4bc3%11
IPv4 Address. . . . . . . . . . . : 192.168.1.XXX
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.1

Ethernet adapter VMware Network Adapter VMnet1:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::4c12:61d0:cc7:2390%14
IPv4 Address. . . . . . . . . . . : 10.128.1.XXX
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 10.128.1.252

Ethernet adapter VMware Network Adapter VMnet8:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::f19b:7485:a0e3:6d85%15
IPv4 Address. . . . . . . . . . . : 10.128.1.XXX
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 10.128.1.252

Ethernet adapter VirtualBox Host-Only Network:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::55c0:c64:6013:a3f3%22
IPv4 Address. . . . . . . . . . . : 192.168.56.X
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :

Tunnel adapter isatap.{D2D46A9B-5F9B-4D4C-B7A2-243ECBF450D2}:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter Teredo Tunneling Pseudo-Interface:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter isatap.{02E76547-7DED-40E6-87DC-B03B9CCD3AE8}:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter isatap.{A63B092C-C08C-4E1E-B24A-C5F9B3DE6AAC}:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter isatap.{424CAB28-EA62-4AF1-8BF7-DF5C0F2935A1}:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter isatap.{1DCC9972-814D-4F1A-8B9F-01FE8D514DA0}:

Media State . . . . . . . . . . . : Media disconnected

infurrrno
12-11-2010, 07:43 AM
Do you have the network configured properly from the VM? The VM will need not only local networking to access the host PC, but also internet access to allow HEM to check its activation status. Once you have that working, then you just change the Server Name field in HEM's Database Management window to the host PC's IP/hostname instead of the default 127.0.0.1 (localhost) and it should work.

I think this may be where I am stuck. Can anyone give me any advice on giving my vm local networking access in order to access the host?

thx! and dw I wish I was smarter also :)

The Minder
12-11-2010, 09:35 AM
Hmmm... it is my understanding that the network adapter in the VM needs to be configured as a Bridge Adapter.

Here is my ipconfig from an XP guest:
Windows IP Configuration

Host Name . . . . . . . . . . . . : hero-40ded09d8
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Unknown
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : AMD PCNET Family PCI Ethernet Adapter
Physical Address. . . . . . . . . : 08-00-27-1D-EC-8D
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 192.168.1.103 (... this is my XP Guest IP address)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.100 (... this is my router IP which is providing DHCP service)
DHCP Server . . . . . . . . . . . : 192.168.1.100
DNS Servers . . . . . . . . . . . : 192.168.1.100
192.168.1.100
Lease Obtained. . . . . . . . . . : Saturday, December 11, 2010 9:19:03 PM
Lease Expires . . . . . . . . . . : Sunday, December 12, 2010 9:19:03 PM

Then, from my Host (Linux) side I have this:
ifconfig -a

eth0 Link encap:Ethernet HWaddr 00:22:68:59:d7:78
inet addr:192.168.1.101 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::222:68ff:fe59:d778/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:222355 errors:0 dropped:0 overruns:0 frame:0
TX packets:361793 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:220309266 (210.1 MB) TX bytes:137705323 (131.3 MB)
Interrupt:220 Base address:0x8000

So 192.168.1.101 is my Host's ip address and where postgres lives. Therefore in HM to connect to a db I use 192.168.1.101 as 'Server Name'.

In your ipconfig, I don't see a unique IP address for the guest which is telling me you don't have the DHCP set up correctly. Are you behind a router?

infurrrno
12-11-2010, 09:59 AM
Thanks for the info so far, yes I'm behind a router... should I be?

The Minder
12-11-2010, 08:53 PM
Thanks for the info so far, yes I'm behind a router... should I be?
Being behind a router helps. I would suggest:

~ make sure only the router is providing DCHP,
~ 'hard wire' into the router fixed IP addresses for the host and guest, and
~ ensure the guest adapter is set to Bridge.

From there, the rest of the info is contained in this thread.

gl at the tables.