LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 09-21-2006, 03:49 PM   #1
gabsik
Member
 
Registered: Dec 2005
Location: This planet
Distribution: Debian,Xubuntu
Posts: 567

Rep: Reputation: 30
Question snort data collections


I have a debian sarge 3.1 and i have installed snort oinkmaster and mysql.I would like to collect snort data allerts in php format.I'm very bad in mysql and i'm reading a mysql guide about this issue .
I have created a database snort as the guide says ...
Code:
root@www:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 705 to server version: 4.0.24_Debian-10sarge2-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database snort;
Query OK, 1 row affected (0.05 sec)

mysql> connect snort;
Connection id:    706
Current database: snort

mysql> status;
--------------
mysql  Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)

Connection id:          706
Current database:       snort
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Server version:         4.0.24_Debian-10sarge2-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 1 day 9 hours 51 min 23 sec

Threads: 1  Questions: 12780  Slow queries: 0  Opens: 226  Flush tables: 1  Open tables: 59  Queries per second avg: 0.105
--------------

mysql> grant CREATE,INSERT,SELECT,DELETE,UPDATE on snort.* to root@localhost;
ERROR 1146: Table 'mysql.user' doesn't exist
mysql> grant CREATE,INSERT,SELECT,DELETE,UPDATE on root.* to root@localhost;
ERROR 1146: Table 'mysql.user' doesn't exist
What is this guide trying to say to me with the grant command ?Why this error?Should i have to create a table ?The guide doesn't say to do it.
Thanks!
 
Old 09-24-2006, 12:01 PM   #2
peter_robb
Senior Member
 
Registered: Feb 2002
Location: Szczecin, Poland
Distribution: Gentoo, Debian
Posts: 2,458

Rep: Reputation: 48
Try this version..

http://www.howtoforge.com/forums/showthread.php?t=5163
MySQL stuff is at the end..
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error when starting up snort: bash:!/bin/sh/usr/local/bin/snort :Eent not found cynthia_thomas Linux - Software 1 11-11-2005 02:59 PM
snort failed: snort: symbol lookup error: undefined symbol: usmAES192PrivProtocol Emmanuel_uk Linux - Security 1 07-10-2005 10:29 AM
ACID not displaying data from Snort linuxNewbie2 Linux - Security 6 12-16-2004 03:31 AM
how data correlation between snort and nessus works? jarien Linux - Security 0 11-27-2004 01:32 AM
synchronising mp3 collections dukeinlondon Linux - Software 1 10-05-2004 05:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 04:25 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration