[Snort-users] MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?)

McCash, John John.McCash at ...10979...
Mon Apr 26 09:42:21 EDT 2004


Hi Everyone,
	I'm migrating from mysql to mssql, and trying to get the database set up correctly. I'm probably making some terrible newbie mistake, as I've never done database administration except for my initial snort mysql setup, which was wonderfully documented :-). When I run the osql command on Windows to read in the snortdb-extra file, I get the following errors: 


$ osql -S aopsecdb -s snort -U snort -P fleabitez  -i snortdb-extra

<many line numbers removed for clarity...>

618> 619> 620> 621> 622> 623> 624> 625> 626> 627> 628> 629> 630> 631> Msg 170, Level 15, State 1, Server AOPSECDB, Line 2
Line 2: Incorrect syntax near 'Copyright'.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 36
The label 'example' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 39
The label 'example' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 170, Level 15, State 1, Server AOPSECDB, Line 81
Line 81: Incorrect syntax near 'valid'.
Msg 156, Level 15, State 1, Server AOPSECDB, Line 85
Incorrect syntax near the keyword 'CREATE'.
Msg 170, Level 15, State 1, Server AOPSECDB, Line 750
Line 750: Incorrect syntax near 's'.
Msg 170, Level 15, State 1, Server AOPSECDB, Line 1401
Line 1401: Incorrect syntax near 's'.
Msg 128, Level 15, State 1, Server AOPSECDB, Line 3158
The name 'Manager' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not
permitted.
Msg 128, Level 15, State 1, Server AOPSECDB, Line 3159
The name 'Manager' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not
permitted.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 6903
The label 'cc' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 380
The label 'URG' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 381
The label 'URG' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 382
The label 'URG' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 384
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 385
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 386
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 387
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 388
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 389
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 390
The label 'ACK' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 392
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 393
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 394
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 395
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 396
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 397
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 398
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 399
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 400
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 401
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 402
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 403
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 404
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 405
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 406
The label 'PSH' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 408
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 409
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 410
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 411
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 412
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 413
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 414
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 415
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 416
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 417
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 418
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 419
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 420
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 421
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 422
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 423
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 424
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 425
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 426
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 427
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 428
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 429
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 430
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 431
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 432
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 433
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 434
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 440
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 441
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 442
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 447
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 448
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 449
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 450
The label 'SYN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 504
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 505
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 506
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 507
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 508
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 509
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 510
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 511
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 512
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 513
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 514
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 515
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 516
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 517
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 518
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 519
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 520
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 521
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 522
The label 'RST' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 523
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 524
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 525
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 526
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 527
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 528
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 529
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 530
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 531
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 532
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 533
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 534
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 555
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 556
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 557
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 558
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 567
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 156, Level 15, State 1, Server AOPSECDB, Line 567
Incorrect syntax near the keyword 'open'.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 568
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 156, Level 15, State 1, Server AOPSECDB, Line 568
Incorrect syntax near the keyword 'open'.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 569
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 156, Level 15, State 1, Server AOPSECDB, Line 569
Incorrect syntax near the keyword 'open'.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 570
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 156, Level 15, State 1, Server AOPSECDB, Line 570
Incorrect syntax near the keyword 'open'.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 587
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 588
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 589
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 590
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 627
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 628
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 629
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Server AOPSECDB, Line 630
The label 'FIN' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 105, Level 15, State 1, Server AOPSECDB, Line 630
Unclosed quotation mark before the character string ');
'.



Can anybody refer me to comprehensive documentation for using mssql wioth snort? It seems to be supported, but I guess they assume if you're going the MS route, you must have or be a real DBA.
		Thanks lots in advance
			John

------------------------------------------------------------------------------------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information.  
If you have received it in error, please notify the sender
immediately and delete the original.  Any unauthorized use of
this email is prohibited.
------------------------------------------------------------------------------------------------
[mf2]




More information about the Snort-users mailing list