PDA

View Full Version : Running PostGres 8.3 on Ubunt 9.04 - Timeout value in ConnectionString



pazzorilancio
11-25-2009, 03:25 PM
Hey guys.

So I did an apt-get install postgres and its installed 8.3 on Ubuntu 9.04.

The IP of the server is 174.143.146.210

The port the server is listening on is 5000, and I have a line to allow 0.0.0.0/0 ident sameuser with the user being postgres.

So the server listens on port 5000 and sees my incoming connection but then displays the "Increase Timeout value in ConnectionString" error.. I'm using HEM 1.09.

I tried setting the statement timeout variable in the main conf file to 0 (disabled) but still getting the timeout. The server is hosted in the states but through a great data centre so should be working fine... Its a clean dedicated box with nothing else on it...

Any ideas? I don't mind sharing some logon access if anyone technical could take a look or advise as to what the issue may be :)

Cheers

pazzorilancio
11-25-2009, 03:41 PM
Btw tcpdump shows:

root@SuggysServer:/etc/postgresql/8.3/main# tcpdump port 5000
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 96 bytes
19:40:48.911328 IP 82.109.203.178.1242 > SuggysServer.5000: S 2530071708:2530071708(0) win 8192 <mss 1360,nop,wscale 2,nop,nop,sackOK>
19:40:48.911328 IP SuggysServer.5000 > 82.109.203.178.1242: S 516977292:516977292(0) ack 2530071709 win 5840 <mss 1460,nop,nop,sackOK,nop,wscale 5>
19:40:49.081328 IP 82.109.203.178.1242 > SuggysServer.5000: . ack 1 win 4420
19:40:49.081328 IP 82.109.203.178.1242 > SuggysServer.5000: P 1:56(55) ack 1 win 4420
19:40:49.081328 IP SuggysServer.5000 > 82.109.203.178.1242: . ack 56 win 183

My host machine is the 82
postgres server is SuggysServer

pazzorilancio
11-25-2009, 07:38 PM
Would I be better off emailing this or am I just being impatient? ;)

fozzy71
11-25-2009, 08:37 PM
I have forwarded this thread to my colleagues for a reply.

pazzorilancio
11-26-2009, 05:00 AM
Ok thanks very much! I've been messing around with it but can only seem to make it worse not better so no idea what's going on really!

netsrak
11-26-2009, 07:41 AM
This is a very specific question and i think its beyond our knowledge - the Holdemmanager support cant help you. You should look for help in special ubuntu / postgresql communities.

The timeout value for the connection is not changeable in the application.

I personally use an ubuntu server with postgresql and HM in a virtual machine. This works without problems.

pazzorilancio
11-26-2009, 07:48 AM
Hmmm I tried recreating a new server and doing it all again but same problem even with all default info. Another HEM user tried connecting and same problem too!

Did you have to do any specific configuration? Could you possibly give me an account with restricted permission to try and connect?

I just want to debug where exactly the issue lies. Maybe there are other services required to host a postgresql server for HEM use that aren't installed by default?. Saying that I can't connect remotely with PGAadmin.. "Server unexpectedly closed" error!

netsrak
11-26-2009, 11:13 AM
You mean for my server? Its just a local Ubuntu system with a virtual machine connect via private network. Its not connected to the internet.

For the others questions you should wait for Roy. I hope he will post in this thread later, we forwarded it to him.

pazzorilancio
11-26-2009, 11:20 AM
I did some messing about with the config and figured it out. Had ident sameuser on the end of the host 0.0.0.0/0 line and it should have been md5! Casing some weird ass errors though!!!

:)

So if youd like a dedicated online server for storage let me know! :p

netsrak
11-26-2009, 01:34 PM
nice to hear :)

pazzorilancio
11-26-2009, 03:36 PM
Ok trying to import.. selected my hands folders..

The interface is showing "Found 97 files to process....." and the progress bar is there but at 0.. however nothings happening :S

I did a tcpdump on the server and about 5000 packets are getting exchanged a minute so a lot of communication is going on, but nothing on the HEM interface... any idea? Is this common in remote database imports? Only imported 35kish hands..

pazzorilancio
11-26-2009, 03:39 PM
After 10 minutes, interface now displays more importing states such as 0.7 hands per/s with an estimated time of 12 and a half hours... :/

I got 80 hands per second doing it on my LAN ffs :P

netsrak
11-27-2009, 05:21 AM
Thats not usual. Try to run some sql statements via the pgadmin query tool to compare the performance.

pazzorilancio
11-27-2009, 05:31 AM
I exported the database and restored it on the dedicated server..

But then when hold'em manager used the remote server everything was taking absolutely ages to do.. going on sessions and selecting a different session took at least 30 seconds to process...

The dedicated server was a quad core with 1gb of ram and was hardly utilised so not sure what it could have been.

Will just stick to running it locally I guess :/ Would be good to have a linux server version of HEM which did all the work and the client could connect to!

The Minder
11-28-2009, 05:10 AM
I exported the database and restored it on the dedicated server..

But then when hold'em manager used the remote server everything was taking absolutely ages to do.. going on sessions and selecting a different session took at least 30 seconds to process...

The dedicated server was a quad core with 1gb of ram and was hardly utilised so not sure what it could have been.

Will just stick to running it locally I guess :/ Would be good to have a linux server version of HEM which did all the work and the client could connect to!
All the hard yakka is done by postgres, iirc, so I'm not sure why you'd want a Linux version of HEM. I have the same setup as Netsrak, Postgres on Ubuntu and HEM in a Win VM client. Nice and stable and quicker than snot.