Re: [Secureideas-base-user] Database Connection Problems

[Tim R. <TAR...@in...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

That error and your description suggests that you set up remote access
for the snort user but not localhost access for the user. Your mysql
database, user table probably has something like this in it i assume

localhost  	root
%		root
%		snort

In which case you'd need to also tell mysql to allow connections from
the snort user to the localhost. Or at least thats what it sounds like.
I'm also assuming that base is running on the same database that the
mysql database is running.

Tim Rupp

Cody Holland wrote:
| Ok,
|
| I've got a snort sensor running and it's logging to the mysql database.
| But I cannot get base to work.  I keep getting:
|
| Error (p)connecting to DB : snort@localhost
|
| Check the DB connection variables in base_conf.php
|
|                = $alert_dbname   : MySQL database name where the alerts
| are stored
|                = $alert_host     : host where the database is stored
|                = $alert_port     : port where the database is stored
|                = $alert_user     : username into the database
|                = $alert_password : password for the username
|
| Database ERROR:Access denied for user 'snort'@'localhost' (using
| password: YES
|
| I've checked and double checked the base_conf.php file and everything is
| correct.  I know the database works because the sensor is able to log to
| it remotely.  Any ideas?
|
| Cody Holland
| Field Engineer
| Redmoon Broadband, Inc.
| 972-599-3900
| cho...@re...
|
|
| -------------------------------------------------------
| SF email is sponsored by - The IT Product Guide
| Read honest & candid reviews on hundreds of IT Products from real users.
| Discover which products truly live up to the hype. Start reading now.
| http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
| _______________________________________________
| Secureideas-base-user mailing list
| Sec...@li...
| https://lists.sourceforge.net/lists/listinfo/secureideas-base-user
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFCOg+E18YR2nBmCgYRAhyxAKDtPUgZGTUDHrh1QoC0l6/dcwb3OACfdBs7
n4r1ZPWVVweyRvTawBnk9TM=
=AzS+
-----END PGP SIGNATURE-----