Snort mailing list archives

Re: BASE - Access denied to MySql database

From: For Sinton <forsin () inbox kg>
Date: Mon, 13 Jul 2015 10:49:45 +0600 (KGT)

Hi, please check .. if user have permission to connect to db from localhost... in mysql.user



----- Исходное сообщение -----
От: "Oleg Ruso" <soy_siberiano () yahoo com>
Кому: "snort-users" <snort-users () lists sourceforge net>
Отправленные: Воскресенье, 12 Июль 2015 г 14:18:27
Тема: [Snort-users] BASE - Access denied to MySql database

Hi List. 

Got some trouble with a BASE 1.4.5 
"Access denied for user ''@'localhost' to database 'snort' " 


My environment: 
FreeBSD 9.1 
PHP Version 5.4.42 
nginx-devel-1.9.2_1 
mysql56-client-5.6.24_1 
mysql56-server-5.6.24 

The snort & barnyard2 & Mysql base working extremely well. And was not any problem with a BASE, until 
installed an PHP extensions 
----------------------- 
PDO_MYSQL 
SIMPLEXML 
MCRYPT 
HASH 
---------------------- 

This extensions needs for a web service. 
I can to log in to snort mysql database by name/passwd , that specified in base_conf.php 
---------------------------- 
$alert_dbname = 'snort'; 
$alert_host = 'localhost:/tmp/mysql.sock'; or 127.0.0.1 or localhost, is a simular result 
$alert_port = ''; 
$alert_user = '********'; 
$alert_password = '********'; 
-------------------------------

SELECT count(*) FROM event;

Connection id: 86
Current database: snort

mysql> SELECT count(*) FROM event;
+----------+
| count(*) |
+----------+
| 335 |
+----------+
1 row in set (0,01 sec)

But when i puting on my username/passwd to BASE login web form, got :
Access denied for user ''@'localhost' to database 'snort'

I attempted to disable https(ssl) type connection for the web server, but result is a simular.

What`s wrong? Any ideas?

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
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://sourceforge.net/mailarchive/forum.php?forum_name=snort-users

Please visit http://blog.snort.org to stay current on all the latest Snort news!

Current thread:

BASE - Access denied to MySql database Oleg Ruso (Jul 12)
- Re: BASE - Access denied to MySql database For Sinton (Jul 12)