| Author |
Message |
SoCalUser |
|
 |
Post subject: Database Authentication Error
 Posted: Mar 21, 2007 - 12:56 PM
|
|
Joined: Mar 21, 2007
Posts: 3
Status: Offline
|
|
Newbie to Snort. Just finished installing Snort, Base MySQL on IIS.
When firing up the browser to http://winids/base, I get the following error:
Error (p)connecting to DB : snort@winids
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 'base'@'localhost' (using password: YES)
I checked base_conf.php and all looks well. where is 'base'@'localhost' coming from?
Thanks. |
|
|
| |
|
|
|
 |
|
Morpheus |
|
|
Post subject: RE: Database Authentication Error
Posted: Mar 21, 2007 - 05:11 PM
|
|
Site Admin
Joined: Sep 04, 2003
East Coast - USA
Posts: 1415
Location: East Coast - USA
Status: Offline
|
|
It looks like there is a problem with the 'base' users password accessing the database.
Try manually logging into the database using the credentials for base.
CD to folder 'd:\win-ids\mysql\bin' and from the command prompt type 'mysql -u base -p' (less the quotes) and tap the 'Enter' key. You will be prompted for a password and type '@n@l1st' (less the quotes), and tap the 'Enter' key. You should be dropped into the mysql. |
_________________
Best regards,
Morpheus...
WINSNORT.com Management
|
| |
|
|
|
|
|
SoCalUser |
|
 |
Post subject: Database Authentication Error
Posted: Mar 22, 2007 - 06:57 AM
|
|
Joined: Mar 21, 2007
Posts: 3
Status: Offline
|
|
Nothin' Doin'.
When I enter that password from a command prompt, I get the following error:
ERROR 1045 (28000): Access denied for user 'base'@'localhost' (using password: YES).
So, I assume I hosed the "Create Database Access and Authenticated Users" portion of the installation.
How do I go about fixing this?
Thanks |
|
|
| |
|
|
|
|
|
Morpheus |
|
|
Post subject: RE: Database Authentication Error
Posted: Mar 22, 2007 - 07:26 AM
|
|
Site Admin
Joined: Sep 04, 2003
East Coast - USA
Posts: 1415
Location: East Coast - USA
Status: Offline
|
|
Go back to the guide and create the authentication for the user 'base'.
This link could be helpful:
http://www.snort.org/archive-5-1686.html |
_________________
Best regards,
Morpheus...
WINSNORT.com Management
|
| |
|
|
|
|
|
SoCalUser |
|
 |
Post subject: Database Authentication Error
Posted: Mar 22, 2007 - 12:50 PM
|
|
Joined: Mar 21, 2007
Posts: 3
Status: Offline
|
|
Creating the authentication for 'base' on 'localhost' did the trick.
Thanks. |
|
|
| |
|
|
|
|
|
|
