PDA

View Full Version : Networking HEM database



nojgib
09-11-2010, 11:48 PM
I'm having issues connecting to my DB over my network and I'm not sure where I'm going wrong.
To start, I installed HEM and Postgres on my laptop. I liked it and bought it. I then installed it along with postgres on my desktop system.
I have changed the files as stated elsewhere in this forum, I have made exceptions in my firewalls and I'm not sure where else to look.
I do still have Postgres installed on my laptop, is there any way that is affecting my connection?
I have never gotten it to connect over the network, but it works fine if I just let it connect to the DB on my laptop.

Thanks in advance for any recommendations.
noj

Windows XP with AVG antivirus, and no other protective software other than Windows software.

The Minder
09-12-2010, 12:25 AM
what error msg are u getting when you try and connect to the desktop db from your laptop?

what are the IP addresses for your desktop and laptop computers?

nojgib
09-12-2010, 12:49 AM
Laptop IP 192.168.100.102
Desktop IP 192.168.100.101

Error
http://img815.imageshack.us/img815/3651/sserror.png (http://img815.imageshack.us/i/sserror.png/)

The Minder
09-12-2010, 01:29 AM
Have you tried:

From the laptop (with the desktop up and running but HM not loaded):

Start HM then select:
Options > Database Management

from the popup that appears make sure Server Name is set to 192.168.100.101

nojgib
09-12-2010, 01:41 AM
Forgot I had it running on desktop....
error code I usually get
http://img443.imageshack.us/img443/4305/sserror2.png (http://img443.imageshack.us/i/sserror2.png/)

Uploaded with ImageShack.us (http://imageshack.us)

My DBCP on laptop
http://img255.imageshack.us/img255/3466/dbcp.png (http://img255.imageshack.us/i/dbcp.png/)

Uploaded with ImageShack.us (http://imageshack.us)
My HBA on desktop
http://img202.imageshack.us/img202/5396/sshba.png (http://img202.imageshack.us/i/sshba.png/)

Uploaded with ImageShack.us (http://imageshack.us)

The Minder
09-12-2010, 02:04 AM
This appears to me to be password problem... have you confirmed the desktop postgres pw?

nojgib
09-12-2010, 02:18 AM
Desktop DBCP
http://img20.imageshack.us/img20/7026/deskdbcp.png (http://img20.imageshack.us/i/deskdbcp.png/)

Uploaded with ImageShack.us (http://imageshack.us)

I remember reading about a postgres password (which I remember when I installed was like ~30 characters long?) which I did not write down, but there is a file in the registry that contains it?....

I thought the "trust" took care of the password.

Thanks for the help BTW

Patvs
09-12-2010, 04:00 AM
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /del' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.





Then run the SQL installer again from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) and use postgrespass as password

nojgib
09-12-2010, 03:54 PM
deleted user and reinstall done.
I had to adjust to port 5433 so the SS is correct.
new user postgres, pass postgrespass.

new error
http://img825.imageshack.us/img825/1373/bdcpnewerror.png (http://img825.imageshack.us/i/bdcpnewerror.png/)
After clicking yes
http://img685.imageshack.us/img685/4900/afterclickingyes1.png (http://img685.imageshack.us/i/afterclickingyes1.png/)
After clicking OK
http://img255.imageshack.us/img255/9933/afterclickingok.png (http://img255.imageshack.us/i/afterclickingok.png/)

Trying to connect again will just result in the same sequence above.
The service is started and running on my desktop system.

The Minder
09-12-2010, 09:20 PM
So, postgres is running on the desktop as a service but you don't have postgres running on the laptop. That's the way it should be imo.

However, you need a (postgress) way for the laptop to communicate with the desktop and that can be done with an ODBC driver.
This link http://forums.holdemmanager.com/manager-general/26862-connection-hm-virtual-machine.html talks about VMs, but the same situation applies in your case.

nojgib
09-12-2010, 11:24 PM
Postgres running on the desktop and stopped on the laptop... correct.
Downloaded and installed recommended driver. No change.
Uninstalled Postgres on the laptop (but left the ODBC driver). No change.
I still have the same results as above.

nojgib
09-13-2010, 09:56 AM
I have reinstalled Postgres on my laptop.
After playing a bit in Postgres (trying to configure it to find the DB on the desktop), I believe that the communication between the 2 systems is there, I believe the desktop (host) is just rejecting the connection from the laptop. Does the SS of the pg_hba.conf above look correct?

netsrak
09-14-2010, 04:01 AM
Please try to edit the conf file directly. I'm not sure whether the configuration editor does the right things.

nojgib
09-14-2010, 08:54 AM
I found part of the problem. After the reinstallation of Postgres on my desktop, when I was editing the conf file with the editor, it was editing the file from my old install (8.3) not the new install (8.4).
I can now log in from my laptop, but I do not see any DBs.
I believe that my DB is scattered between the old and new install. I would like to remove all the old files, and just keep the 8.4. Is there any way to combine the files into the new install? Or maybe there's something else I'm missing to be able to view the DBs from my laptop?

nojgib
09-14-2010, 09:51 AM
I guess what I'm saying is my DB is still on the 8.3 server. I cannot log into it from my laptop for some reason.
I can log into 8.4 server.

Aside from creating a new DB on the 8.4 server and importing all my hands into it, is there any way I can move the DB to the 8.4 server?

netsrak
09-14-2010, 09:52 AM
You need to backup the databases in your 8.3 installation and restore them in your 8.4 installation

nojgib
09-14-2010, 12:02 PM
Working now. I had to create a new user on the 8.4 server with the same name and password as the 8.3 install.... got it all straightened out.
Thanks alot for all the help.

Thread can be closed.