Thread: pg_hba.conf problem

pg_hba.conf problem

From
JWDougherty
Date:
I have run into a problem with the vanilla pg_hba.conf with 7.34.  While most
normal local operations work as they ought, I found that when attempting use
postgresqs from GRASS that an error was returned due to a problem with the
pg_hba.conf file.  The error message is:

LOG:  parse_hba: invalid syntax in pg_hba.conf file at line 45, token "TYPE"
FATAL:  Missing or erroneous pg_hba.conf file, see postmaster log for details

The problem is that line 45 reads as follows:

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

It seems to be a comment describing the datastructure that follows it.  This
is the basic pg_hba.conf that is created when initdb is run and has not been
modified in any way.

I am running grass on the same system that I am running postgresql on and
there are no networking issues that I need to resolve, or at least I don't
think so.

John


Re: pg_hba.conf problem

From
Josh Berkus
Date:
John,

> LOG:  parse_hba: invalid syntax in pg_hba.conf file at line 45, token "TYPE"
> FATAL:  Missing or erroneous pg_hba.conf file, see postmaster log for
details
>
> The problem is that line 45 reads as follows:
>
> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

My guess is that something is messed up in the file, such as a wrong line
break character.   Take a look at it in a good text editor, such as eMacs or
Vi or Kate.

Failing that, post the whole bottom section of the file.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


HTML email

From
"Derrick Betts"
Date:
Does anyone know of a function that I can use to send HTML formatted email
from the database?  Actually I currently use pgMail, but I cannot get it to
send HTML formatted email.

Thanks,
Derrick


Re: HTML email

From
"Derrick Betts"
Date:
When I place the HTML tags in the body of the email, I just get the tags
showing as text.  Is this what you meant?  I currently use a function to
create the concatenate the HTML and variables together, and then I pass that
string as the body of the email, but it is delivered as text.

Is there anything I should do that I am missing?

Thanks,
Derrick

----- Original Message -----
From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
<sank89@sancharnet.in>
To: "Derrick Betts" <Derrick@grifflink.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Friday, February 20, 2004 3:55 PM
Subject: Re: [NOVICE] HTML email


> Dear Derrick Betts  ,
>
> >from the database?  Actually I currently use pgMail, but I cannot get it
to
> >send HTML formatted email.
> >
> >
> pgMail can handle this just format the text by conactinating text and
> HTML tag in a simple pgsql function.
> If you want more help just pass on the text you want to mail
>
> --
> Best Regards,
> Vishal Kashyap
> Director / Lead Developer,
> Sai Hertz And Control Systems Pvt Ltd,
> http://saihertz.rediffblogs.com
> Jabber IM: vishalkashyap@jabber.org
> ICQ :      264360076
> -----------------------------------------------
> You yourself, as much as anybody in the entire
> universe, deserve your love and affection.
> - Buddha
> ---------------
> I am usually called as Vishal Kashyap
> and my Girlfriend calls me Vishal CASH UP.
> Because everyone loves me as Vishal Kashyap
> and my Girlfriend loves me as CASH.
>                     ___
>                    //\\\
>                   ( 0_0 )
> ----------------o0o-----o0o---------------------
>
>
>


Re: HTML email

From
"V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Date:
Dear Derrick Betts  ,

>from the database?  Actually I currently use pgMail, but I cannot get it to
>send HTML formatted email.
>
>
pgMail can handle this just format the text by conactinating text and
HTML tag in a simple pgsql function.
If you want more help just pass on the text you want to mail

--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ :      264360076
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
I am usually called as Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
Because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
                    ___
                   //\\\
                  ( 0_0 )
----------------o0o-----o0o---------------------


Re: HTML email

From
Date:
On Fri, 20 Feb 2004, Derrick Betts wrote:

> When I place the HTML tags in the body of the email, I just get the tags
> showing as text.  Is this what you meant?  I currently use a function to
> create the concatenate the HTML and variables together, and then I pass that
> string as the body of the email, but it is delivered as text.
>
> Is there anything I should do that I am missing?

Read the standards as to what HTTP and HTML do?  For me (and
emacs) HTTP/HTML can be strict.  If what you generate for an
attachment is strict HTML, it should display in any browser.  Or,
any browser which understands (or has HTML processing turned on).

> > >from the database?  Actually I currently use pgMail, but I cannot get it
> > > to send HTML formatted email.

For me, there is NO html formatted email.  If you send HTML only,
it is spam.  Include a text only version of what you send as the
main body.

Gord
--
Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng.. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (alt.)


Re: HTML email

From
"V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Date:
Dear Derrick Betts

>Is this what you meant?
>
Nop just add the things between the <code> </code> tags below to your
mail and see the trick
<code>

Content-type: text/html
Content-transfer-encoding: 7BIT

<HTML>
<HEAD>
<title>email</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</code>

Write it very HTML strict as some mail clients will not parse it good
enough.
Shoot back if this worked
--

Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ :      264360076
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
I am usually called as Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
Because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
                    ___
                   //\\\
                  ( 0_0 )
----------------o0o-----o0o---------------------


Re: pg_hba.conf problem

From
Tom Lane
Date:
JWDougherty <jwdougherty@mcihispeed.net> writes:
> I have run into a problem with the vanilla pg_hba.conf with 7.34.  While most
> normal local operations work as they ought, I found that when attempting use
> postgresqs from GRASS that an error was returned due to a problem with the
> pg_hba.conf file.  The error message is:

> LOG:  parse_hba: invalid syntax in pg_hba.conf file at line 45, token "TYPE"
> FATAL:  Missing or erroneous pg_hba.conf file, see postmaster log for details

I've been trying to think of an explanation for this, but it's hard to
come up with one, if your pg_hba.conf is indeed factory-stock.  Did you
build PG from source, or is it from somebody's RPM distribution?  (Some
distributions supply modified pg_hba files.)  For that matter, what
platform is this on anyway?

            regards, tom lane