Hello,

I recently updated my norton anti-virus and norton goback - and up until
then - everything for my sambc was working fine now when I try and open
sambc and I received the error message:

X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not
connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

I went to the postgresql.conf and I added *listen_addresses='*' *under
the # CONNECTIONS AND AUTHENTICATION section.

It still did not work:

When I tried to start the server - I got the error message -

Failed to start server pgsql-8.0 Errcode = 1069

I also noticed that when I start windows xp - that I have two accounts
owner(administrative) account and postgre account. The postgre account
requires a password. The password that is listed on sambc/core.xml file
does not work.

How do I fix the problem and also get into the postgre account?? or remove
the postgre account all together
HELP
Anika Evans

Anika,

thanks for the complete error description, I bet the culprit is in here:

>
> I recently updated my norton anti-virus and norton goback - and up until
> then - everything for my sambc was working fine now when I try and open
> sambc and I received the error message:
>


X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not
> connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?
>

We had many times trouble with antivirus and similiar products interfering
with the connections between pgadmin / psql and the Postrges Server.

I recommend to NOT remove the postgres account!!

Please try to configure Norton whatever to allow connections on Port 5432.
Or roll back that update.

Best wishes,

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now
you can prepare budget for visiting EuroPython 2007.

Hello Anika,

please see that we are in different timezones, and I usually try to sleep at
night. Please also try to keep your mail on the list, so others can try to
help you as well.

Now, dig deeper in the analyzis:

1st) Logon as Admin, checkout services.msc

is there a postgres service running? If not, why not? Any messages there?
Try to start the service from service control panel. Check out system event
log, application event log.

2nd) where is your PostgreSQL data directory? in a standard installation it
is in <program files>\postgres\8.1\data

there should be a log directory within, chechout what is in the youngest
logfiles. Maybe post it to the list.

3rd) Try to connect to postgres using psql; that is the command line
utilitie

4th) what is Postgresql used for on your computer? "sambc/core.xml" is no
application I know connected to "pgadmin". I forwarded your mail to the
postgres support list, because propably the problem is NOT connected to the
pg-admin

Additional information: the password within the .xml file is most propably
the passwort for the user within the database. NOT the postgres Service
Account password. The password of the postgres account should be irrelevant
for you, since it is only used for the service to connec.t

Best wishes,

Harald




On 7/11/06, anika evans <hianika@gmail.com> wrote:
>
> HELLO!!
>
> I STILL NEED HELP -
> I removed norton internet security and norton goback - postgre sql still
> doesn't work!!!!!
>
> I need to get this thing running - asap - before my ass is fired!!
>
>
>
>
> On 7/10/06, anika evans <hianika@gmail.com> wrote:
> >
> > Unfortunatly rolling back the update did not work - and adding port
> > 5432 did not work either.
> >
> > If I cant remove postgre - then what do I do??
> >
> > also, When I turn on the computer I have 2 accounts on windows ex - the
> > Owner (administrator) account and a postgre account - the postgre acccount
> > requires a password - unfortunatly when I get the password from
> > sambc/core.xml file - the password does not work.... HELP
> >
> > Thank you
> > Anika Evans
> > On 7/10/06, Harald Armin Massa <haraldarminmassa@gmail.com > wrote:
> > >
> > > Anika,
> > >
> > > thanks for the complete error description, I bet the culprit is in
> > > here:
> > >
> > > >
> > > > I recently updated my norton anti-virus and norton goback - and up
> > > > until then - everything for my sambc was working fine now when I try and
> > > > open sambc and I received the error message:
> > > >
> > >
> > >
> > >
> > > X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not
> > > > connect to server: Connection refused (0x0000274D/10061)
> > > > Is the server running on host "localhost" and accepting
> > > > TCP/IP connections on port 5432?
> > > >
> > >
> > > We had many times trouble with antivirus and similiar products
> > > interfering with the connections between pgadmin / psql and the Postrges
> > > Server.
> > >
> > > I recommend to NOT remove the postgres account!!
> > >
> > > Please try to configure Norton whatever to allow connections on Port
> > > 5432. Or roll back that update.
> > >
> > >
> > > Best wishes,
> > >
> > > Harald
> > >
> > >
> > > --
> > > GHUM Harald Massa
> > > persuadere et programmare
> > >
> > > Harald Armin Massa
> > > Reinsburgstraße 202b
> > > 70197 Stuttgart
> > > 0173/9409607
> > > -
> > > on different matter:
> > > EuroPython 2006 is over. It was a GREAT conference. If you missed it,
> > > now you can prepare budget for visiting EuroPython 2007.
> > >
> >
> >
>


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now
you can prepare budget for visiting EuroPython 2007.