Re: No table creation within SNORT databse

[Stefan Schleifer <stefan.schleifer () linbit com>]

try to connect to the database with:
mysql -usnort -p snort

the snort user has a password, but with your connect string (-p missing) 
  mysql won't ask for one ( 'snort@localhost' (Using password: NO) and 
that should be YES)

hope that helps.

stefan.

Matt Furminger wrote:
> DATABASE TABLES NOT BEING CREATED FROM SCRIPT
>
> I have stared at this for too long and can no longer see the wood for 
> the trees. This is the deal:
> * I cannot create the tables within snort using the standard script 
> "create_mysql". There is a permission error but it does not makes sense 
> why.(and 'yes', CAPS LOCK is off)  ;)
>
> Any help would be greatly apprecited.
>
> PRESENT SCENARIO:
> Created snort database. (snort databse was created in lower case)
> Created user:  grant INSERT,SELECT,CREATE,DELETE on snort.* to 
> snort@localhost identified by "snort";
>     User created successfully. User table in Mysql database is populated 
> with user 'snort'
> Attempt to create database tables with:  mysql -u snort snort < 
> c:\snort\create_mysql
>     ERROR 1045: Access denied for user: 'snort@localhost' (Using 
> password: NO)
>
> CONFIG DETAILS:
> SNORT     - 1.8.7b121
> WinPcap    - 2.3
> MySQL    - 3.23.40
> PHP    - 4.1.1
> PHPlot    - 4.4.6
> ADODB    - 1.72
> ACID    - 0.9.6b21
>
> For completeness, I have included SNORT.CONF & ACID_CONF.PHP
> SNORT.CONF - output database: log, mysql, user=snort password=snort 
> dbname=snort host=localhost
> acid_conf.php -
> $alert_dbname   = "snort";
> $alert_host     = "localhost";
> $alert_port     = "";
> $alert_user     = "snort";
> $alert_password = "snort";
>
> /* Archive DB connection parameters */
> $archive_dbname   = "snort";
> $archive_host     = "localhost";
> $archive_port     = "";
> $archive_user     = "snort";
> $archive_password = "snort";
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos: 
> http://photos.msn.com/support/worldwide.aspx
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: Jabber - The world's fastest growing 
> real-time communications platform! Don't just IM. Build it in! 
> http://www.jabber.com/osdn/xim
> _______________________________________________
> 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://www.geocrawler.com/redir-sf.php3?list=snort-users


--

: Stefan Schleifer                            Tel +43-1-8974897-754 :
: LINBIT Information Technologies GmbH        Fax +43-1-8974897-111 :
: Sechshauserstr 48, A-1150 Vienna/Europe     http://www.linbit.com :




-------------------------------------------------------
This sf.net email is sponsored by: Jabber - The world's fastest growing 
real-time communications platform! Don't just IM. Build it in! 
http://www.jabber.com/osdn/xim
_______________________________________________
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://www.geocrawler.com/redir-sf.php3?list=snort-users