Unsubsribe
CONFIDENTIALITY NOTICE: This email message and the information contained herein is intended by Next Generation Films, Inc. for use only by the individual or entity to which it is addressed. This message may contain information that is privileged and/or confidential. It is not intended for transmission to, or receipt by, anyone other than the named addressee. If you have received this communication in error, please notify the sender at the reply email address and delete it from your system without copying or forwarding it. If you are not the intended recipient, you are hereby notified that any retention, distribution, or dissemination of this information is strictly prohibited. Thank you. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Johan Hendriks Sent: Tuesday, February 5, 2013 9:43 AM To: [email protected]; Baruwa users list Subject: Re: [Baruwa] Mailscanner start error. (SQL) I am on FreeBSD and the user is pgsql instead of postgres. Could it be the version of Postgresql, i am running 9.2 gr Johan Raymond Norton schreef: > Here is what mine looks like on Ubuntu 12.0.4 > > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > local all postgres trust > host all all 127.0.0.1/32 md5 > host all all ::1/128 md5 > > > On 02/05/2013 08:20 AM, Johan Hendriks wrote: >> I get the following >> >> $ psql -U baruwa baruwa >> psql: FATAL: no pg_hba.conf entry for host "[local]", user "baruwa", >> database "baruwa", SSL off >> >> my pg_hba.conf looks like this >> >> # TYPE DATABASE USER CIDR-ADDRESS METHOD >> local all pgsql trust >> host all all 127.0.0.1/32 md5 >> host all all ::1/128 md5 >> # end >> >> BTW the baruwa2 gui works. >> I installed phppgadmin, it it tells me the database is populated. >> >> Also i get the following in my /var/log/messages >> >> Feb 5 15:19:51 baruwa2 mailscanner: Process did not exit cleanly, >> returned 255 with signal 0 Feb 5 15:19:51 baruwa2 postgres[56585]: >> [2-1] ERROR: relation "msrulesets" does not exist at character 41 >> Feb 5 15:19:51 baruwa2 postgres[56585]: [2-2] STATEMENT: SELECT >> row_number, ruleset AS rule FROM msrulesets WHERE name=$1 Feb 5 >> 15:19:51 baruwa2 mailscanner: Process did not exit cleanly, returned >> 255 with signal 0 Feb 5 15:19:51 baruwa2 postgres[56587]: [2-1] >> ERROR: relation "msrulesets" does not exist at character 41 Feb 5 >> 15:19:51 baruwa2 postgres[56587]: [2-2] STATEMENT: SELECT row_number, >> ruleset AS rule FROM msrulesets WHERE name=$1 Feb 5 15:19:56 baruwa2 >> mailscanner: Process did not exit cleanly, returned 255 with signal 0 >> Feb 5 15:19:56 baruwa2 postgres[56589]: [2-1] ERROR: relation >> "msrulesets" does not exist at character 41 Feb 5 15:19:56 baruwa2 >> postgres[56589]: [2-2] STATEMENT: SELECT row_number, ruleset AS rule >> FROM msrulesets WHERE name=$1 Feb 5 15:19:56 baruwa2 mailscanner: >> Process did not exit cleanly, returned 255 with signal 0 Feb 5 >> 15:19:56 baruwa2 postgres[56591]: [2-1] ERROR: relation "msrulesets" >> does not exist at character 41 Feb 5 15:19:56 baruwa2 >> postgres[56591]: [2-2] STATEMENT: SELECT row_number, ruleset AS rule >> FROM msrulesets WHERE name=$1 Feb 5 15:20:01 baruwa2 mailscanner: >> Process did not exit cleanly, returned 255 with signal 0 Feb 5 >> 15:20:01 baruwa2 mailscanner: Process did not exit cleanly, returned >> 255 with signal 0 Feb 5 15:20:01 baruwa2 postgres[56598]: [2-1] >> ERROR: relation "msrulesets" does not exist at character 41 Feb 5 >> 15:20:01 baruwa2 postgres[56598]: [2-2] STATEMENT: SELECT row_number, >> ruleset AS rule FROM msrulesets WHERE name=$1 Feb 5 15:20:01 baruwa2 >> postgres[56600]: [2-1] ERROR: relation "msrulesets" does not exist >> at character 41 Feb 5 15:20:01 baruwa2 postgres[56600]: [2-2] >> STATEMENT: SELECT row_number, ruleset AS rule FROM msrulesets WHERE >> name=$1 >> >> >> gr >> Johan >> >> >> >> Andrew Colin Kissa schreef: >>> On 05 Feb 2013, at 3:45 PM, Johan Hendriks wrote: >>> >>>> So i geus it is, but i have never used postgresql. >>>> So what is the fastest way to check? >>> psql -U baruwa baruwa >>> >>> =>\dv >>> >>> -- >>> www.baruwa.org >>> >>> >>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
