[Snort-users] Access denied error in MySQL

Steve Halligan agent33 at ...187...
Wed Jan 23 10:38:28 EST 2002


ARRRGHHH....stop the HTML mail please.










<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word"><HEAD>

<TITLE>Message</TITLE>

<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2712.300" name=GENERATOR>
<META content="Microsoft Word 10" name=Originator><LINK 
href="cid:filelist.xml at ...4653..." rel=File-List><!--[if gte mso
9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in
1.25in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source:
0; }
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New
Roman"; mso-style-parent: ""; mso-pagination: widow-orphan;
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New
Roman"; mso-style-parent: ""; mso-pagination: widow-orphan;
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New
Roman"; mso-style-parent: ""; mso-pagination: widow-orphan;
mso-fareast-font-family: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
	COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
	COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.EmailStyle17 {
	COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type:
personal-compose; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt;
mso-bidi-font-size: 10.0pt; mso-ascii-font-family: Arial;
mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
}
SPAN.SpellE {
	mso-style-name: ""; mso-spl-e: yes
}
DIV.Section1 {
	page: Section1
}
</STYLE>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */ 
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
</style>
<![endif]--></HEAD>
<BODY lang=EN-US style="tab-interval: .5in" vLink=purple link=blue>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=128051318-23012002>Looks 
like you just need to add <FONT color=#000000>INSER,SELECT,CREATE,DELETE on 
snortout.* to <STRONG><A
href="mailto:outthere at ...4654...">outthere@<FONT 
size=4>host130.xyz.com</A></FONT></STRONG></FONT></SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p></o:p></SPAN></FONT></P><FONT 
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p><FONT 
color=#0000ff></FONT> </o:p></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=Section1>
  <P class=MsoNormal><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN 
  class=128051318-23012002><FONT 
  color=#0000ff> </FONT></SPAN></SPAN></FONT></P>
  <P class=MsoNormal><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN 
  class=128051318-23012002></SPAN></SPAN></FONT> </P>
  <P class=MsoNormal><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN 
  class=128051318-23012002> </SPAN>I have snort 1.8.3 + MySQL + ACID 
  running in my ServerFarm. I want to install another snort on external side

  i.e. outside firewall using same MySQL server and ACID server in
ServerFarm as 
  Centralized server. I have successfully installed another database named 
  snortout on MySQL for it and created another user named outthere and given

  INSER,SELECT,CREATE,DELETE on snortout.* to <STRONG>outthere@<FONT 
  size=3><FONT size=4>localhost</FONT> </FONT>rights</STRONG> on MySQL 
  server.<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When I am trying to run snort
from 
  outside firewall machine by executing snort -c c:\snort\snort.conf -l 
  c:\snort\logs -i1 it is giving me following 
error:<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Database: mysql_error: Access 
  denied for user<STRONG>: '@<FONT size=4>host130.xyz.com'</FONT> to
database 
  'snortout'<o:p></o:p></STRONG></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Fatal Error, 
  Quitting...<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have configured snort.conf
on 
  machine outside firewall for output log as 
  follows:<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Output database: log, mysql, 
  user=outthere dbname=snortout host=host35.xyz.com 
  sensor_name=DMZ<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Host35.xyz.com is FQDN of
MySQL 
  centralized database server.<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Host130.xyz.com is FQDN of
machine 
  out side of Firewall running snort.<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can someone help me out in
solving 
  this problem?<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in 
  advance.<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial">Protect<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>




More information about the Snort-users mailing list