salawank

sguildb sql script

Nov 16th, 2011
148
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Error while starting sguil server:
  2.  
  3. $ sudo /etc/init.d/sguil-server start
  4. * Starting sguil-server pid(11948) Loading access list: /etc/sguild/sguild.access
  5. pid(11948) Sensor access list set to ALLOW ANY.
  6. pid(11948) Client access list set to ALLOW ANY.
  7. pid(11948) Email Configuration:
  8. pid(11948) Config file: /etc/sguild/sguild.email
  9. pid(11948) Enabled: No
  10. pid(11948) Connecting to localhost on 3306 as sguil
  11. pid(11948) MySQL Version: version 5.1.58-1ubuntu1
  12. pid(11948) SguilDB Version: 0.12 0.12
  13. ERROR: Incompatable DB schema. Required Version: 0.12 Installed Version: 0.12 0.12 Check the server/sql_scripts directory of the src that came with sguild for scripts to help you upgrade
  14. SGUILD: Exiting...
  15.  
  16. ----------------------------------------------------------------------------------
  17.  
  18. Error while importing sql from /usr/share/doc/sguil-server/sql_scripts/create_sguildb.sql
  19.  
  20.  
  21. mysql> SOURCE /usr/share/doc/sguil-server/sql_scripts/create_sguildb.sql
  22. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--)' at line 1
  23. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--CREATE TABLE tcphdr
  24. --(
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37. --CREATE TABLE udphdr
  38. --(
  39.  
  40.  
  41.  
  42.  
  43.  
  44.  
  45. --CREATE T' at line 1
  46.  
  47. #Incomplete table from the original source:
  48.  
  49.  
  50. mysql> show tables;
  51. +-------------------+
  52. | Tables_in_sguildb |
  53. +-------------------+
  54. | history |
  55. | nessus |
  56. | nessus_data |
  57. | pads |
  58. | portscan |
  59. | status |
  60. | user_info |
  61. | version |
  62. +-------------------+
  63. 8 rows in set (0.00 sec)
  64. ---------------------------------------------------------------------------------------
  65.  
  66. Changed to use different one at http://www.bufferoverflow.it/media/create_sguildb.sql
  67. and this settles the problem.
  68.  
  69. mysql> SOURCE /usr/share/doc/sguil-server/sql_scripts/create_sguildb.sql.1
  70. Query OK, 0 rows affected, 1 warning (0.14 sec)
  71.  
  72. Query OK, 0 rows affected (0.12 sec)
  73.  
  74. Query OK, 0 rows affected (0.11 sec)
  75.  
  76. Query OK, 0 rows affected (0.13 sec)
  77.  
  78. Query OK, 0 rows affected (0.15 sec)
  79.  
  80. Query OK, 0 rows affected (0.13 sec)
  81.  
  82. Query OK, 0 rows affected (0.12 sec)
  83.  
  84. Query OK, 0 rows affected (0.11 sec)
  85.  
  86. Query OK, 1 row affected (0.00 sec)
  87.  
  88. Query OK, 1 row affected (0.00 sec)
  89.  
  90. Query OK, 1 row affected (0.00 sec)
  91.  
  92. Query OK, 1 row affected (0.00 sec)
  93.  
  94. Query OK, 1 row affected (0.00 sec)
  95.  
  96. Query OK, 1 row affected (0.00 sec)
  97.  
  98. Query OK, 1 row affected (0.00 sec)
  99.  
  100. Query OK, 1 row affected (0.00 sec)
  101.  
  102. Query OK, 1 row affected (0.00 sec)
  103.  
  104. Query OK, 1 row affected (0.00 sec)
  105.  
  106. Query OK, 0 rows affected (0.11 sec)
  107.  
  108. Query OK, 1 row affected (0.00 sec)
  109.  
  110. mysql> show tables;
  111. +-------------------+
  112. | Tables_in_sguildb |
  113. +-------------------+
  114. | history |
  115. | nessus |
  116. | nessus_data |
  117. | pads |
  118. | portscan |
  119. | sensor |
  120. | status |
  121. | user_info |
  122. | version |
  123. +-------------------+
  124. 9 rows in set (0.00 sec)
  125.  
  126.  
  127.  
  128.  
RAW Paste Data