Thread: pg_hba.conf problem
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
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
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
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--------------------- > > >
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---------------------
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.)
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---------------------
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