Snort mailing list archives
MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?)
From: "McCash, John" <John.McCash () andrew com>
Date: Mon, 26 Apr 2004 11:41:20 -0500
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] ------------------------------------------------------- This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek For a limited time only, get FREE Ground shipping on all orders of $35 or more. Hurry up and shop folks, this offer expires April 30th! http://www.thinkgeek.com/freeshipping/?cpg297 _______________________________________________ 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
Current thread:
- MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?) McCash, John (Apr 26)
- <Possible follow-ups>
- MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?) McCash, John (Apr 27)