Re: Problem getting Snort to Connect to PostgreSQLdatabase

[Brian Hughes <hughbria () isu edu>]

Hi Alejandro,

Thank you for the reply.  As it turns out I had some extra commas in my
snort.conf file.  Joe McAlerney asked me to send him my output database
line from snort.conf and he noticed that instead of saying "output
database: log, postgresql, dbname=snort user=brian host=localhost
port=5432" mine said "output database: log, postgresql, dbname=snort,
user=brian, host=localhost, port=5432" as soon as I removed the extra
commas all was well.

Thanks & Best Regards,
Brian

Alejandro Flores wrote:
>         Hi Brian,
>
>         Follow these steps:
>         (as root type:)
>         #su - postgres
>         $createdb snort
>         $exit
>         #cd (snort_sources dir)
>         #cd contrib
>         #psql -U postgres snort < create_postgresql
>
>         Now try to start snort.
>
> See ya.
>
> Alejandro
>
> > Hi Folks,
> >
> > I'm sure I'm doing something stupid as I am new to both Snort and
> > PostgreSQL. I'm running Snort version 1.8.7 beta 2 build 114 and
> > PostgreSQL 7.2.1-4.  When I attempt to start Snort I get the error
> > message:
> >
> > database: Connection to database 'snort' failed
> > Fatal Error, Quitting..
> >
> > It's obvious that I've done something wrong, but was wondering if there
> > was somewere I could look to find a few more clues as to why the
> > connection to the database is failing?
> >
> > Any pointers would be greatly appreciated,
> > Brian
>
> _______________________________________________________________
>
> Have big pipes? SourceForge.net is looking for download mirrors. We supply
> the hardware. You get the recognition. Email Us: bandwidth () sourceforge net
> _______________________________________________
> 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

_______________________________________________________________

Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: bandwidth () sourceforge net
_______________________________________________
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