Thread: PostgreSQL for Holdem Manager could not be installed.

PostgreSQL for Holdem Manager could not be installed.

From
Alphadion
Date:
Hi,

I was using Holdem Manager and Postgres database server until a month ago
when it just stopped. Whatever I did didn't help, incl. a teamviewer session
with one of the HM administrators.

I've already read and done everything about that in FAQ, forums,net etc. and
nothing helps.

Please help! I am using Windows 7 64, I've also tried with/without
firewalls, opened all local ports... Using Nod32 atm and Spybot that runs in
the background, when ununstalled (both of them) postgres doesn' t work
too....

Cheers,

Dion

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3700954.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: PostgreSQL for Holdem Manager could not be installed.

From
tv@fuzzy.cz
Date:
>
> Please help! I am using Windows 7 64, I've also tried with/without
> firewalls, opened all local ports... Using Nod32 atm and Spybot that runs
> in
> the background, when ununstalled (both of them) postgres doesn' t work
> too....

Hi.

I really don't know what a Holdem Manager is, but have you tried to
connect to PostgreSQL directly (using pgadmin-III for example)? Is the
process running, or does it fail at start time? Is there something in the
log?

regards
Tomas


Re: PostgreSQL for Holdem Manager could not be installed.

From
Adrian Klaver
Date:
On Tuesday, March 15, 2011 5:09:27 am Alphadion wrote:
> Hi,
>
> I was using Holdem Manager and Postgres database server until a month ago
> when it just stopped. Whatever I did didn't help, incl. a teamviewer
> session with one of the HM administrators.
>
> I've already read and done everything about that in FAQ, forums,net etc.
> and nothing helps.
>
> Please help! I am using Windows 7 64, I've also tried with/without
> firewalls, opened all local ports... Using Nod32 atm and Spybot that runs
> in the background, when ununstalled (both of them) postgres doesn' t work
> too....

Some information required:
What version of Postgres?
How was Postgres installed?
How do you know Postgres is not working?
Or is that Holdem is not finding Postgres?
Is all of this happening locally or is there a remote component?

>
> Cheers,
>
> Dion
>
--
Adrian Klaver
adrian.klaver@gmail.com

Re: PostgreSQL for Holdem Manager could not be installed.

From
Alphadion
Date:
I tried to install any of the versions but it always gives that message
"Could not connect to the database server, please check port 5432 and
127.0.0.1" or  something like that. I've opened a range of ports on my
router's page, and also opened one in my computer through the firewall.

Holdem Manager is a tracking software for playing poker online. It stores
all yours and opponents' hands and uses Postgresql for that. It was working
properly until one day when it just stopped, giving a message about
inability to onnect to database server. I tried system restore and
everything possible, including a teamviewer session with one of the Holdem
Manager forums admins. Nothing helped...

I dont want to reinstall the whole Windows as I'm not sure if it's going to
work. I tried installing HM and postgres on another computer in the same
network and it doesnt work on it too...

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708616.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: PostgreSQL for Holdem Manager could not be installed.

From
Merlin Moncure
Date:
On Tue, Mar 15, 2011 at 10:55 AM, Alphadion <s_savovbg@yahoo.com> wrote:
> I tried to install any of the versions but it always gives that message
> "Could not connect to the database server, please check port 5432 and
> 127.0.0.1" or  something like that. I've opened a range of ports on my
> router's page, and also opened one in my computer through the firewall.
>
> Holdem Manager is a tracking software for playing poker online. It stores
> all yours and opponents' hands and uses Postgresql for that. It was working
> properly until one day when it just stopped, giving a message about
> inability to onnect to database server. I tried system restore and
> everything possible, including a teamviewer session with one of the Holdem
> Manager forums admins. Nothing helped...
>
> I dont want to reinstall the whole Windows as I'm not sure if it's going to
> work. I tried installing HM and postgres on another computer in the same
> network and it doesnt work on it too...


Check your event viewer application log for interesting details.
Confirm if any postgres processes are running in task manager.  Look
and see if postgres services is installed in service control manager,
and if it is not running, try and start it.

My money is on expired password issue on the postgres account.

merlin

Re: PostgreSQL for Holdem Manager could not be installed.

From
Adrian Klaver
Date:
On Tuesday, March 15, 2011 8:55:33 am Alphadion wrote:
> I tried to install any of the versions but it always gives that message
> "Could not connect to the database server, please check port 5432 and
> 127.0.0.1" or  something like that. I've opened a range of ports on my
> router's page, and also opened one in my computer through the firewall.
>
> Holdem Manager is a tracking software for playing poker online. It stores
> all yours and opponents' hands and uses Postgresql for that. It was working
> properly until one day when it just stopped, giving a message about
> inability to onnect to database server. I tried system restore and
> everything possible, including a teamviewer session with one of the Holdem
> Manager forums admins. Nothing helped...
>
> I dont want to reinstall the whole Windows as I'm not sure if it's going to
> work. I tried installing HM and postgres on another computer in the same
> network and it doesnt work on it too...

To get this moving please answer the questions I provided earlier:
What version of Postgres?
How was Postgres installed?
How do you know Postgres is not working?
Or is that Holdem is not finding Postgres?
Is all of this happening locally or is there a remote component?

In addition:
Anything happen a month ago when it stopped working?
    Software upgrade?
        Computer crash?
        Etc?



>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-coul
> d-not-be-installed-tp3700954p3708616.html Sent from the PostgreSQL -
> general mailing list archive at Nabble.com.

--
Adrian Klaver
adrian.klaver@gmail.com

Re: PostgreSQL for Holdem Manager could not be installed.

From
Alphadion
Date:
Quote: "Is all of this happening locally or is there a remote component?"

I dont know how to define that...

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708753.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: PostgreSQL for Holdem Manager could not be installed.

From
Bruce Momjian
Date:
I am ready to conclude that the commercial software, Holdem Manager, is
basically trying to farm out their database support to us.  However,
Holdem Manager has extensive help topics about getting Postgres working:

    http://faq.holdemmanager.com/categories/Frequently+Asked+Questions/PostgreSQL/

I think we just need to point users to those pages.

---------------------------------------------------------------------------

Alphadion wrote:
> I tried to install any of the versions but it always gives that message
> "Could not connect to the database server, please check port 5432 and
> 127.0.0.1" or  something like that. I've opened a range of ports on my
> router's page, and also opened one in my computer through the firewall.
>
> Holdem Manager is a tracking software for playing poker online. It stores
> all yours and opponents' hands and uses Postgresql for that. It was working
> properly until one day when it just stopped, giving a message about
> inability to onnect to database server. I tried system restore and
> everything possible, including a teamviewer session with one of the Holdem
> Manager forums admins. Nothing helped...
>
> I dont want to reinstall the whole Windows as I'm not sure if it's going to
> work. I tried installing HM and postgres on another computer in the same
> network and it doesnt work on it too...
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708616.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Re: PostgreSQL for Holdem Manager could not be installed.

From
Bruce Momjian
Date:
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.

---------------------------------------------------------------------------

Alphadion wrote:
> Quote: "Is all of this happening locally or is there a remote component?"
>
> I dont know how to define that...
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708753.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Re: PostgreSQL for Holdem Manager could not be installed.

From
Alphadion
Date:
Merlin Moncure-2 wrote:
>
> Check your event viewer application log for interesting details.
> Confirm if any postgres processes are running in task manager.  Look
> and see if postgres services is installed in service control manager,
> and if it is not running, try and start it.
>
> My money is on expired password issue on the postgres account.
>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

The process is running and I've tried the service manager..  How can I
renovate the pass?

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708915.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: PostgreSQL for Holdem Manager could not be installed.

From
Adrian Klaver
Date:
On Tuesday, March 15, 2011 9:01:50 am Alphadion wrote:
> Quote: "Is all of this happening locally or is there a remote component?"
>
> I dont know how to define that...

Are HM and the database both on the same machine or is the connection happening
over the network?

--
Adrian Klaver
adrian.klaver@gmail.com

Re: PostgreSQL for Holdem Manager could not be installed.

From
Adrian Klaver
Date:
On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> The larger question is whether these forums should be used to help
> people get support for commercial products that embed Postgres.
>

The eternal Open Source dilemma.  Once it is released into the wild are we
responsible for it?  In a perfect world the folks that incorporate Postgres into
their products would be entirely  accountable for its care and feeding. Part of
me says hold to that standard. Another part says how do you know where a
question is really coming from?  I for one am not going to interrogate everyone
on their reasons for asking a question. The other issue is perception. Right or
wrong, not answering questions ends up reflecting negatively on the community.

--
Adrian Klaver
adrian.klaver@gmail.com

Re: PostgreSQL for Holdem Manager could not be installed.

From
Bruce Momjian
Date:
Adrian Klaver wrote:
> On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> > The larger question is whether these forums should be used to help
> > people get support for commercial products that embed Postgres.
> >
>
> The eternal Open Source dilemma.  Once it is released into the wild are we
> responsible for it?  In a perfect world the folks that incorporate Postgres into
> their products would be entirely  accountable for its care and feeding. Part of
> me says hold to that standard. Another part says how do you know where a
> question is really coming from?  I for one am not going to interrogate everyone
> on their reasons for asking a question. The other issue is perception. Right or
> wrong, not answering questions ends up reflecting negatively on the community.

I think we should make sure they have checked the vendor help system
first or point them to that.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Re: PostgreSQL for Holdem Manager could not be installed.

From
Merlin Moncure
Date:
On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> The larger question is whether these forums should be used to help
> people get support for commercial products that embed Postgres.

I have no particular philosophical objection to helping people using
Holdem Manager -- I'd venture most people posting here asking for help
are working on commercial software, and I'd prefer people to come away
from this forum with a positive impression.

It's not like we are getting 100 emails a day on this stuff.  This is
a participatory environment -- so what's the fuss? That said, to the
OP, on this issue you might have better luck on irc channel with this
type of problem.

merlin

Re: PostgreSQL for Holdem Manager could not be installed.

From
Adrian Klaver
Date:
On Tuesday, March 15, 2011 9:26:44 am Bruce Momjian wrote:
> Adrian Klaver wrote:
> > On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> > > The larger question is whether these forums should be used to help
> > > people get support for commercial products that embed Postgres.
> >
> > The eternal Open Source dilemma.  Once it is released into the wild are
> > we responsible for it?  In a perfect world the folks that incorporate
> > Postgres into their products would be entirely  accountable for its care
> > and feeding. Part of me says hold to that standard. Another part says
> > how do you know where a question is really coming from?  I for one am
> > not going to interrogate everyone on their reasons for asking a
> > question. The other issue is perception. Right or wrong, not answering
> > questions ends up reflecting negatively on the community.
>
> I think we should make sure they have checked the vendor help system
> first or point them to that.


Actually in this case that had already been done:) From the original post:

"Whatever I did didn't help, incl. a teamviewer session
with one of the HM administrators.

I've already read and done everything about that in FAQ, forums,net etc. and
nothing helps. "




--
Adrian Klaver
adrian.klaver@gmail.com

Re: PostgreSQL for Holdem Manager could not be installed.

From
John R Pierce
Date:
On 03/15/11 9:26 AM, Bruce Momjian wrote:
> I think we should make sure they have checked the vendor help system
> first or point them to that.

well, the OP did mention a troubleshooting  session with the HM support
folks using teamviewer.   if they couldn't fix it, well, I dunno how
we're going to be able to help without a LOT more information than is
likely to be available.

win7 definately made a mess out of the windows NT security model



Re: PostgreSQL for Holdem Manager could not be installed.

From
Adrian Klaver
Date:
On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
> On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > The larger question is whether these forums should be used to help
> > people get support for commercial products that embed Postgres.
>
> I have no particular philosophical objection to helping people using
> Holdem Manager -- I'd venture most people posting here asking for help
> are working on commercial software, and I'd prefer people to come away
> from this forum with a positive impression.
>
> It's not like we are getting 100 emails a day on this stuff.  This is
> a participatory environment -- so what's the fuss?

Not only that, but should a particular product show up consistently it becomes
an opportunity, for those on this list that do offer commercial support, to make
a 'warm' call.

> That said, to the
> OP, on this issue you might have better luck on irc channel with this
> type of problem.
>
> merlin

--
Adrian Klaver
adrian.klaver@gmail.com

Re: PostgreSQL for Holdem Manager could not be installed.

From
Bruce Momjian
Date:
Adrian Klaver wrote:
> On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
> > On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > > The larger question is whether these forums should be used to help
> > > people get support for commercial products that embed Postgres.
> >
> > I have no particular philosophical objection to helping people using
> > Holdem Manager -- I'd venture most people posting here asking for help
> > are working on commercial software, and I'd prefer people to come away
> > from this forum with a positive impression.
> >
> > It's not like we are getting 100 emails a day on this stuff.  This is
> > a participatory environment -- so what's the fuss?
>
> Not only that, but should a particular product show up consistently it becomes
> an opportunity, for those on this list that do offer commercial support, to make
> a 'warm' call.

Well, also consider how many subscribers to this email list might not
want to read Holdem Manager problem reports.  As long as the reports are
generic to Postgres, I think we are fine, but I am unclear how many of
these are released to Holdem Manager or the Holdem Manager installer?
The same issue exists for the EnterpriseDB installers.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Re: PostgreSQL for Holdem Manager could not be installed.

From
"David Johnston"
Date:
Depending on whether the vendor or user is expected to install and setup
PostgreSQL the issue is that the vendor should be contacting the list and
asking for help with one of their users/setups as opposed to the end-user
asking directly for help.  The end-user shouldn't be expected to have the
skill and knowledge to debug/fix their database setup if the vendor is
providing and setting up the database during install.

Now, if the vendor leaves PostgreSQL integration to the end-user then maybe
the end-user can be expected to make a somewhat informed choice as to which
back-end they wish to use and should be expected to at least be able to
assist in their own trouble-shooting if they plan to make use of community
resources.  In this case making the effort to isolate the problem with
respect to the software or the database.

Depending on the un-importance of data loss I would be surprised if a full
uninstall of both the software and PostgreSQL (including manual deletion of
any data directorie and maybe the user account) did not at least make the
software functional again.

As for the "working on commercial software" comment - that is true but in
most of those cases the interrogator is mostly able to separate the database
and the software and thus isolate and ask pointed questions.  When a
software end-user ends up asking about the database that ability is limited.
Hence why the software provider, and not the user, should be asking the
questions.

One last thought comes to mind is that having an "unsecure" distribution
that is much easier to setup and keep running, that can be used with desktop
deployment, may be something to consider to make having PostgreSQL a more
viable option for back-end integration.  IMO, currently PostgreSQL is
excellent for vertical deployment as opposed to horizontal deployment.
Having a PostgreSQL Lite configuration that is designed for horizontal
deployment is something to consider.  Personally I do not care but the
situation this thread implies stems from what appears to be a mis-match
between what the vendor needs and what PostgreSQL provides.

David J.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Adrian Klaver
Sent: Tuesday, March 15, 2011 12:44 PM
To: pgsql-general@postgresql.org
Cc: Merlin Moncure; Bruce Momjian; Alphadion
Subject: Re: [GENERAL] PostgreSQL for Holdem Manager could not be installed.

On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
> On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > The larger question is whether these forums should be used to help
> > people get support for commercial products that embed Postgres.
>
> I have no particular philosophical objection to helping people using
> Holdem Manager -- I'd venture most people posting here asking for help
> are working on commercial software, and I'd prefer people to come away
> from this forum with a positive impression.
>
> It's not like we are getting 100 emails a day on this stuff.  This is
> a participatory environment -- so what's the fuss?

Not only that, but should a particular product show up consistently it
becomes an opportunity, for those on this list that do offer commercial
support, to make a 'warm' call.

> That said, to the
> OP, on this issue you might have better luck on irc channel with this
> type of problem.
>
> merlin

--
Adrian Klaver
adrian.klaver@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: PostgreSQL for Holdem Manager could not be installed.

From
Alphadion
Date:
Doesn't matter.... I'l try reinstallin the Windows anyway....

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3712964.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.