Page 1 of 4

Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 4:34 pm
by fbg1919
I had a lil rootkit that I had to remove manually that used to block some of my connections w/Mozilla (mail google , web pages etc). Along with those, PT couldn't connect to server also.
Well I took care of the rootkit, everything else works fine but PT still won't connect to the server. Which leads me to believe it somehow affected the settings of PT or there is a problem with PostgresSQL.

Anyhow, I get this message upon opening PT3 :

Unable to login to database (PT3 DB). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?


Checked in PGAdmin, all is well and same settings are there.. no pass filed but I guess that/'s common, how do I fix this ?

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 4:46 pm
by kraada
Start --> Programs --> PostgreSQL --> Start Services to start the PostgreSQL server.

If that doesn't start the server properly, search for and delete the postmaster.pid file and then the server should come up normally.

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 5:13 pm
by fbg1919
the services part did not work

where would i find the postmaster.pid file ? cause under normal search I cant find it

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 5:14 pm
by WhiteRider
It's a hidden file - have a look in the Database / Postgres FAQ where this is mentioned.

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 5:19 pm
by fbg1919
weird

i found it on my laptop (where PT is working fine) but it does not exist on my desktop

i guess i can copy it there and see if it works ?

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 5:23 pm
by fbg1919
WhiteRider wrote:It's a hidden file - have a look in the Database / Postgres FAQ where this is mentioned.



yah i know, it wasn't there..i copied it... still same message :(

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 5:58 pm
by WhiteRider
I think the point is to delete the postmaster file if it exists, so if it isn't there that won't be it.
If you open Task Manager / Processes, do you see any postgres processes?

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 6:24 pm
by fbg1919
none whatsoever

i did dl procmon too if that helps... so i can use it if it comes to it

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 6:56 pm
by keggler
before using procmon, what anti-virus, spyware & firewalls have you got installed?


susan

Re: Cannot connect to server ! internal error

PostPosted: Wed Aug 06, 2008 7:16 pm
by fbg1919
keggler wrote:before using procmon, what anti-virus, spyware & firewalls have you got installed?


susan



i just recovered from that rootkit...i got none whatsoever right now

highfalutin