RE: Problem logging to postgres

["Hutchinson, Andrew" <Andrew.Hutchinson () Vanderbilt edu>]

A couple add'l things to check:

1> Look at the logs that the pgsql server is generating, and see if it's throwing any messages.
2> If you're logging remotely (the db is not on the same server as the sensor) you'll need to make certain that you 
have permissions to access the database from the remote machine.  Postgres permissions are kept in the pg_hba.conf 
file, which will be in the root of your database cluster (usually where you have $PGDATA pointed to...).

My guess is that the machine is getting denied not because of table perms, but rather because of network access perms.

Andrew

Andrew Hutchinson - Network Security
Vanderbilt University Medical Center
(615) 936-2856

> -----Original Message-----
> From: Roger D. Vargas [mailto:roger () eht scu tur cu] 
> Sent: Friday, April 25, 2003 10:27 AM
> To: Snort-users () lists sourceforge net
> Subject: RE: [Snort-users] Problem logging to postgres
>
>
> On Thu, 24 Apr 2003, Roger D. Vargas wrote:
>
> > On 24 Apr 2003, Frank Knobbe wrote:
> >
> > >           - First create a user - for this example we will use
> > > "snortusr"
> > >           - now grant the right privileges for that user 
> > >           > grant INSERT,SELECT on snort.* to snortusr@localhost;
> > On my postgres this causes Parse error near .
> > Im recreating all tables and permissions now to try again.
> After recreating all tables, in both postgres and musql, 
> seems that i cant 
> get it working.
>
> -- 
> Roger D. Vargas, MSCE (Minesweeper and Solitaire Certified Expert)
> ICQ: 117641572  
> Linux User: 180787      
>
>
> -- 
> Este mensaje ha sido analizado por MailScanner
> en busca de virus y otros contenidos peligrosos,
> y se considera que está limpio.
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Snort-users mailing list
> Snort-users () lists sourceforge net
> Go to this URL to change user options or unsubscribe:
> https://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=ort-users


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users