accessing HEM db from second computer - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

accessing HEM db from second computer

Post Reply Subscribe

...

10-14-2008 , 03:19 AM

udbrky

Formerly known as udbrky

Join Date: Oct 2005 Posts: 28,908

I've been trying to figure out how I had it set up previously when I did this. I've made the changes in my pg.hba and postgresql.conf file, set my firewall on both computers to accept queries from each other.

When I open HEM on comp 2, I can get postgres to run when I'm trying to access a local DB, but when I try to access the remote one, postgres won't start. Is anyone else running this configuration successfully? I don't want to run it off my external drive, but I want to access my DB on both computers easily.

Quote

10-14-2008 , 03:39 AM

jeanqlassec

newbie

Join Date: Sep 2008 Posts: 21

I made it but had to change 2 things:

on postgresql.conf: listen_addresses: all
on pg_hba.conf: 192.168.1.0/24 considering I'm running on a local network using 192.168.1.xx IP addresses.

Then it worked.

Quote

10-14-2008 , 07:53 PM

udbrky

Formerly known as udbrky

Join Date: Oct 2005 Posts: 28,908

I've done both those steps, but I can't get postgres to start on my non-database computer. I can get it to start when I try to create a database locally.

Quote

10-15-2008 , 01:45 AM

Pomtidom

grinder

Join Date: Sep 2006 Posts: 500

This should work like this. Are you sure you gave HEM the right IP address of the server? Can you ping the server?

Quote

10-15-2008 , 02:13 AM

udbrky

Formerly known as udbrky

Join Date: Oct 2005 Posts: 28,908

Now I'm starting to find the issue. I can access my desktop shared files from my laptop, but not my laptop from desktop. It says access is denied. I can access my external HD which is run through my laptop's usb port.

I am running Vista on my laptop. I thought I had everything set to share files without a password. Do I need to create a user account? I'm a Vista rookie.

Quote

10-16-2008 , 01:21 PM

udbrky

Formerly known as udbrky

Join Date: Oct 2005 Posts: 28,908

I got it now.

1) Windows Firewall somehow turned back on. It might have been when I was changing firewalls the other day. This was one problem.

2) In my config files, I had the IP addresses listed under ipv6 instead of ipv4, which XP uses AFAIK. Now, I can access it on my XP desktop.

Quote

10-16-2008 , 11:01 PM

Neko

Pooh-Bah

Join Date: Jul 2005 Posts: 4,000

Quote:

Originally Posted by udbrky

It is probably safer to leave the firewall on but add an exception for port 5432. That way you still have the safety of a firewall.

Quote

10-16-2008 , 11:42 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,208

It sounds like he had 2 firewalls on for a period of time.

Quote

10-16-2008 , 11:48 PM

Neko

Pooh-Bah

Join Date: Jul 2005 Posts: 4,000

hmmm...what makes you think that?

Quote

10-17-2008 , 12:08 AM

#10

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,208

Quote:

Originally Posted by udbrky

I got it now.

1) Windows Firewall somehow turned back on. It might have been when I was changing firewalls the other day. This was one problem.
....

I am assuming he added a new (Comodo) firewall, and the Windows firewall was still on (or got turned back on).

Quote

10-17-2008 , 12:23 AM

#11

Neko

Pooh-Bah

Join Date: Jul 2005 Posts: 4,000

ugh...i read over the post twice and still missed that sentence. ADD FTL.

Quote

10-17-2008 , 12:25 AM

#12

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,208

I also know OP pretty well, and knew he wouldn't be using Windows Firewall on purpose, but using something else instead.

Quote

10-17-2008 , 01:14 AM

#13

udbrky

Formerly known as udbrky

Join Date: Oct 2005 Posts: 28,908

Quote:

Originally Posted by fozzy71

I also know OP pretty well, and knew he wouldn't be using Windows Firewall on purpose, but using something else instead.

This.

Quote

Post Reply Subscribe

...