first of all, i must say "sorry" for my bad english. i hope, i can manage to describe the problem i have in a way that you can understand
i use pt3 since a couple of weeks on a laptop and a desktop-pc at home. of course, i want pt3 to store data in one central database on
my fileserver which i run in my small network.
to configure pt3 on the server an the clients, i read the faq and tried to do as described. but obviously i made mistakes, and so the whole
thing doesn´t work
.i will try to tell you what i have done, and hopefully you will be able to help me understand
:Please note: if you are not behind a router, this will not work for you.
ok, i have a router running in my network.
the ip-adresses are as follows:
- router: 192.168.0.1
- fileserver: 192.168.0.100
- client1 (desktop): 192.168.0.2
- client2 (laptop): 192.168.0.3
pt3 is installed and registered on all of these machines. the databases of client1 and client2 contain several data from the played sessions.
The general overview is to update your configuration files to let the server know that computers in your same subnet are allowed access to the server. To do this, goto start -> programs -> postgresql -> configuration files -> pg_hba.conf. Scroll to the bottom of the file. You will see something similar to this at the bottom:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
Step A) simply add the line below to the bottom of your document:
host all all 192.168.0.0/24 md5
Save and exit.
that´s what i did. to confirm: i added this line in the pg_hba.conf on the SERVER.
Now, go back to start -> programs -> postgresql -> configuration files -> postgresql.conf and add the following line to the end of the file:
listen_addresses = '*'
This tells your server to listen to ALL addresses your computer has, not just localhost (which is only accessible from the local computer).
this is an action to be done on the server, too, right ?
Once saved, your computer will now send sql results to computer in your local network. To connect to that server remotely, you need to know that server's address.
as told above, the ip-adress of my fileserver is 192.168.0.100
My IP address here is 192.168.1.16, so my server's ip address is the same. Therefore, to log into this database from my other computers in the house the server:port:pass is - 192.168.1.16:5432:dbpass.
following this, the equivalent pass for my network should be 192.168.0.100:5432:dbpass, right ?
this is the part i have the most problems with:
Substitute your information to access your database from another computer in your local network.
where do i have to put this information to (which file) ? this is the action to be done on the clients, right ?
Also, if you have removed password authentication from your server, please substitute "trust" for "md5" in the line you are adding to your pg_hba.conf file.
i did not intentionally remove any password from the db-server, i just installed it with the standard-options. so i think, i can ignore this last command ?!?
thank you very much for taking your time to read and trying to understand my post. i would be very happy if someone could give me the hint which helps me solving this problem
.
