API tools faq
paste
Advertisement
Guest User

brunotec

a guest
Mar 24th, 2011
150
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.83 KB | None | 0 0
raw download clone embed print report
  1. 2011-03-23 13:25:39,497 [main] INFO com.ilient - SysAid Version: v7.5.05
  2. 2011-03-23 13:25:43,236 [main] INFO com.ilient - Checking license....
  3. 2011-03-23 13:25:43,694 [main] INFO com.ilient - SysAid Version: v7.5.05
  4. 2011-03-23 13:25:43,900 [main] INFO com.ilient - License found: ActivationAccountID: free
  5. 2011-03-23 13:25:43,900 [main] INFO com.ilient - Expiration date: unlimited
  6. 2011-03-23 13:25:43,900 [main] INFO com.ilient - ActivationAssets: 100
  7. 2011-03-23 13:25:43,900 [main] INFO com.ilient - ActivationEndUsers: 100
  8. 2011-03-23 13:25:43,900 [main] INFO com.ilient - ActivationAdmins: 2
  9. 2011-03-23 13:25:43,901 [main] INFO com.ilient - ActivationManagers: 0
  10. 2011-03-23 13:25:43,901 [main] INFO com.ilient - ActivationMonitoring: 1
  11. 2011-03-23 13:25:43,901 [main] INFO com.ilient - CMDB: false
  12. 2011-03-23 13:25:43,901 [main] INFO com.ilient - Task_And_project: false
  13. 2011-03-23 13:25:43,901 [main] INFO com.ilient - ITIL: false
  14. 2011-03-23 13:25:43,901 [main] INFO com.ilient - Chat: true
  15. 2011-03-23 13:25:43,901 [main] INFO com.ilient - SLA: false
  16. 2011-03-23 13:25:43,902 [main] INFO com.ilient - Sysaid Edition: Free
  17. 2011-03-23 13:25:43,902 [main] INFO com.ilient - Product Type: SysAid
  18. 2011-03-23 13:26:08,413 [main] INFO com.ilient - Initializing account....
  19. 2011-03-23 13:26:08,868 [main] INFO com.ilient - SysAid Version: v7.5.05
  20. 2011-03-23 13:26:09,082 [main] INFO com.ilient - License found: ActivationAccountID: free
  21. 2011-03-23 13:26:09,082 [main] INFO com.ilient - Expiration date: unlimited
  22. 2011-03-23 13:26:09,082 [main] INFO com.ilient - ActivationAssets: 100
  23. 2011-03-23 13:26:09,083 [main] INFO com.ilient - ActivationEndUsers: 100
  24. 2011-03-23 13:26:09,083 [main] INFO com.ilient - ActivationAdmins: 2
  25. 2011-03-23 13:26:09,083 [main] INFO com.ilient - ActivationManagers: 0
  26. 2011-03-23 13:26:09,083 [main] INFO com.ilient - ActivationMonitoring: 1
  27. 2011-03-23 13:26:09,083 [main] INFO com.ilient - CMDB: false
  28. 2011-03-23 13:26:09,083 [main] INFO com.ilient - Task_And_project: false
  29. 2011-03-23 13:26:09,084 [main] INFO com.ilient - ITIL: false
  30. 2011-03-23 13:26:09,084 [main] INFO com.ilient - Chat: true
  31. 2011-03-23 13:26:09,084 [main] INFO com.ilient - SLA: false
  32. 2011-03-23 13:26:09,084 [main] INFO com.ilient - Sysaid Edition: Free
  33. 2011-03-23 13:26:09,084 [main] INFO com.ilient - Product Type: SysAid
  34. 2011-03-23 13:44:01,058 [main] INFO com.ilient - checking database configuration....
  35. 2011-03-23 13:44:01,501 [main] INFO com.ilient - SysAid Version: v7.5.05
  36. 2011-03-23 13:44:04,160 [main] ERROR com.ilient - Exception while checking configuration: null, message from server: "Host '192.168.0.101' is not allowed to connect to this MySQL server"
  37. 2011-03-23 13:44:59,368 [main] INFO com.ilient - checking database configuration....
  38. 2011-03-23 13:44:59,844 [main] INFO com.ilient - SysAid Version: v7.5.05
  39. 2011-03-23 13:45:03,177 [main] INFO com.ilient - Checking license....
  40. 2011-03-23 13:45:03,597 [main] INFO com.ilient - SysAid Version: v7.5.05
  41. 2011-03-23 13:45:03,807 [main] INFO com.ilient - License found: ActivationAccountID: free
  42. 2011-03-23 13:45:03,807 [main] INFO com.ilient - Expiration date: unlimited
  43. 2011-03-23 13:45:03,808 [main] INFO com.ilient - ActivationAssets: 100
  44. 2011-03-23 13:45:03,808 [main] INFO com.ilient - ActivationEndUsers: 100
  45. 2011-03-23 13:45:03,808 [main] INFO com.ilient - ActivationAdmins: 2
  46. 2011-03-23 13:45:03,808 [main] INFO com.ilient - ActivationManagers: 0
  47. 2011-03-23 13:45:03,808 [main] INFO com.ilient - ActivationMonitoring: 1
  48. 2011-03-23 13:45:03,808 [main] INFO com.ilient - CMDB: false
  49. 2011-03-23 13:45:03,808 [main] INFO com.ilient - Task_And_project: false
  50. 2011-03-23 13:45:03,809 [main] INFO com.ilient - ITIL: false
  51. 2011-03-23 13:45:03,809 [main] INFO com.ilient - Chat: true
  52. 2011-03-23 13:45:03,809 [main] INFO com.ilient - SLA: false
  53. 2011-03-23 13:45:03,809 [main] INFO com.ilient - Sysaid Edition: Free
  54. 2011-03-23 13:45:03,809 [main] INFO com.ilient - Product Type: SysAid
  55. 2011-03-23 13:46:51,904 [main] INFO com.ilient - Initializing account....
  56. 2011-03-23 13:46:52,368 [main] INFO com.ilient - SysAid Version: v7.5.05
  57. 2011-03-23 13:46:52,584 [main] INFO com.ilient - License found: ActivationAccountID: free
  58. 2011-03-23 13:46:52,584 [main] INFO com.ilient - Expiration date: unlimited
  59. 2011-03-23 13:46:52,584 [main] INFO com.ilient - ActivationAssets: 100
  60. 2011-03-23 13:46:52,584 [main] INFO com.ilient - ActivationEndUsers: 100
  61. 2011-03-23 13:46:52,585 [main] INFO com.ilient - ActivationAdmins: 2
  62. 2011-03-23 13:46:52,585 [main] INFO com.ilient - ActivationManagers: 0
  63. 2011-03-23 13:46:52,585 [main] INFO com.ilient - ActivationMonitoring: 1
  64. 2011-03-23 13:46:52,585 [main] INFO com.ilient - CMDB: false
  65. 2011-03-23 13:46:52,585 [main] INFO com.ilient - Task_And_project: false
  66. 2011-03-23 13:46:52,585 [main] INFO com.ilient - ITIL: false
  67. 2011-03-23 13:46:52,585 [main] INFO com.ilient - Chat: true
  68. 2011-03-23 13:46:52,585 [main] INFO com.ilient - SLA: false
  69. 2011-03-23 13:46:52,586 [main] INFO com.ilient - Sysaid Edition: Free
  70. 2011-03-23 13:46:52,586 [main] INFO com.ilient - Product Type: SysAid
  71. 2011-03-23 13:46:55,140 [main] FATAL com.ilient - Exception in sql statement:
  72. CREATE TABLE account (
  73. account_id varchar(32) NOT NULL default '',
  74. customer_name varchar(64) default NULL,
  75. expiration_time datetime default NULL,
  76. serial_key varchar(64) NOT NULL default '',
  77. account_conf mediumtext,
  78. assets int,end_users int,
  79. admins int,
  80. managers int default 1,
  81. alert_monitor bool,
  82. task bool,
  83. monitoring int default -1,
  84. report_design bool default 0,
  85. css bool default 0,
  86. css_free bool default 0,
  87. sr int default 100,
  88. attachments int default 4,
  89. cmdb bool default 0,
  90. maintanance_expiration datetime,
  91. enable bool default 1,
  92. paid bool default 0,
  93. version int default 0,
  94. css_demo bool default 0,
  95. max_inactive_interval int default 0,
  96. cookie_support bool default 0,
  97. sysaid_version varchar(64) default '',
  98. change_mgmt int default 0,
  99. sla bool default 0,
  100. backup_time datetime default NULL,
  101. sysaid_edition int default 1,
  102. product_type int default 1,
  103. send_automatic_notifications_from_modifier bool default 0,
  104. PRIMARY KEY (account_id)
  105. ) TYPE=MyISAM
  106. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'account' already exists
  107. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  108. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  109. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  110. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  111. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  112. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  113. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  114. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  115. at com.ilient.server.AccountMap.runScript(Unknown Source)
  116. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  117. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  118. at com.ilient.server.InitAccount.main(Unknown Source)
  119. 2011-03-23 13:46:55,143 [main] FATAL com.ilient - Exception in sql statement:
  120. CREATE TABLE schedule_task (
  121. task_id int(11) NOT NULL default '0',
  122. account_id varchar(32) NOT NULL default '',
  123. computer_id varchar(64) NOT NULL default '',
  124. group_name varchar(255) NOT NULL default '',
  125. command varchar(255) NOT NULL default '',
  126. next_run datetime NOT NULL default '0000-00-00 00:00:00',
  127. granularity int(11) NOT NULL default '0',
  128. units int(11) NOT NULL default '0',
  129. discovery_service_name varchar(64),
  130. start_ip_range varchar(64),
  131. end_ip_range varchar(64),
  132. exclude_ip_list varchar(255),
  133. schedule char(1),
  134. snmp_version int(11),
  135. community_string varchar(64),
  136. community_password varchar(64),
  137. domain varchar(255),
  138. agent_settings mediumtext,
  139. PRIMARY KEY (task_id)
  140. ) TYPE=MyISAM
  141. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'schedule_task' already exists
  142. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  143. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  144. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  145. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  146. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  147. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  148. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  149. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  150. at com.ilient.server.AccountMap.runScript(Unknown Source)
  151. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  152. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  153. at com.ilient.server.InitAccount.main(Unknown Source)
  154. 2011-03-23 13:46:55,150 [main] FATAL com.ilient - Exception in sql statement:
  155. insert into schedule_task (task_id,account_id, group_name, command, next_run, granularity, units) values (1,'account','\\','Inventory',DATE_ADD(CURDATE(), INTERVAL '1 01:05 ' DAY_MINUTE),3,1)
  156. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'PRIMARY'
  157. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  158. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  159. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  160. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  161. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  162. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  163. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  164. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  165. at com.ilient.server.AccountMap.runScript(Unknown Source)
  166. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  167. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  168. at com.ilient.server.InitAccount.main(Unknown Source)
  169. 2011-03-23 13:46:55,150 [main] FATAL com.ilient - Exception in sql statement:
  170. insert into schedule_task (task_id,account_id, group_name, command, next_run, granularity, units) values (2,'account','\\','Upgrade',DATE_ADD(CURDATE(), INTERVAL '1 01:55 ' DAY_MINUTE),2,1)
  171. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'PRIMARY'
  172. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  173. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  174. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  175. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  176. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  177. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  178. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  179. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  180. at com.ilient.server.AccountMap.runScript(Unknown Source)
  181. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  182. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  183. at com.ilient.server.InitAccount.main(Unknown Source)
  184. 2011-03-23 13:46:55,151 [main] FATAL com.ilient - Exception in sql statement:
  185. CREATE TABLE version (
  186. version varchar(64) NOT NULL default ''
  187. ) TYPE=MyISAM
  188. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'version' already exists
  189. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  190. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  191. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  192. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  193. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  194. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  195. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  196. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  197. at com.ilient.server.AccountMap.runScript(Unknown Source)
  198. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  199. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  200. at com.ilient.server.InitAccount.main(Unknown Source)
  201. 2011-03-23 13:46:55,164 [main] ERROR com.ilient - Error on AccountMap
  202. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'free' for key 'PRIMARY'
  203. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  204. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  205. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  206. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  207. at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
  208. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
  209. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
  210. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
  211. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
  212. at com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Source)
  213. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  214. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  215. at com.ilient.server.InitAccount.main(Unknown Source)
  216. 2011-03-23 13:47:50,848 [main] INFO com.ilient - checking database configuration....
  217. 2011-03-23 13:47:51,294 [main] INFO com.ilient - SysAid Version: v7.5.05
  218. 2011-03-23 13:47:54,668 [main] INFO com.ilient - Checking license....
  219. 2011-03-23 13:47:55,098 [main] INFO com.ilient - SysAid Version: v7.5.05
  220. 2011-03-23 13:47:55,315 [main] INFO com.ilient - License found: ActivationAccountID: free
  221. 2011-03-23 13:47:55,315 [main] INFO com.ilient - Expiration date: unlimited
  222. 2011-03-23 13:47:55,315 [main] INFO com.ilient - ActivationAssets: 100
  223. 2011-03-23 13:47:55,315 [main] INFO com.ilient - ActivationEndUsers: 100
  224. 2011-03-23 13:47:55,316 [main] INFO com.ilient - ActivationAdmins: 2
  225. 2011-03-23 13:47:55,316 [main] INFO com.ilient - ActivationManagers: 0
  226. 2011-03-23 13:47:55,316 [main] INFO com.ilient - ActivationMonitoring: 1
  227. 2011-03-23 13:47:55,316 [main] INFO com.ilient - CMDB: false
  228. 2011-03-23 13:47:55,316 [main] INFO com.ilient - Task_And_project: false
  229. 2011-03-23 13:47:55,316 [main] INFO com.ilient - ITIL: false
  230. 2011-03-23 13:47:55,316 [main] INFO com.ilient - Chat: true
  231. 2011-03-23 13:47:55,317 [main] INFO com.ilient - SLA: false
  232. 2011-03-23 13:47:55,317 [main] INFO com.ilient - Sysaid Edition: Free
  233. 2011-03-23 13:47:55,317 [main] INFO com.ilient - Product Type: SysAid
  234. 2011-03-23 13:48:04,756 [main] INFO com.ilient - Initializing account....
  235. 2011-03-23 13:48:05,213 [main] INFO com.ilient - SysAid Version: v7.5.05
  236. 2011-03-23 13:48:05,412 [main] INFO com.ilient - License found: ActivationAccountID: free
  237. 2011-03-23 13:48:05,412 [main] INFO com.ilient - Expiration date: unlimited
  238. 2011-03-23 13:48:05,412 [main] INFO com.ilient - ActivationAssets: 100
  239. 2011-03-23 13:48:05,412 [main] INFO com.ilient - ActivationEndUsers: 100
  240. 2011-03-23 13:48:05,412 [main] INFO com.ilient - ActivationAdmins: 2
  241. 2011-03-23 13:48:05,412 [main] INFO com.ilient - ActivationManagers: 0
  242. 2011-03-23 13:48:05,413 [main] INFO com.ilient - ActivationMonitoring: 1
  243. 2011-03-23 13:48:05,413 [main] INFO com.ilient - CMDB: false
  244. 2011-03-23 13:48:05,413 [main] INFO com.ilient - Task_And_project: false
  245. 2011-03-23 13:48:05,413 [main] INFO com.ilient - ITIL: false
  246. 2011-03-23 13:48:05,413 [main] INFO com.ilient - Chat: true
  247. 2011-03-23 13:48:05,413 [main] INFO com.ilient - SLA: false
  248. 2011-03-23 13:48:05,414 [main] INFO com.ilient - Sysaid Edition: Free
  249. 2011-03-23 13:48:05,414 [main] INFO com.ilient - Product Type: SysAid
  250. 2011-03-23 13:48:07,958 [main] FATAL com.ilient - Exception in sql statement:
  251. CREATE TABLE account (
  252. account_id varchar(32) NOT NULL default '',
  253. customer_name varchar(64) default NULL,
  254. expiration_time datetime default NULL,
  255. serial_key varchar(64) NOT NULL default '',
  256. account_conf mediumtext,
  257. assets int,end_users int,
  258. admins int,
  259. managers int default 1,
  260. alert_monitor bool,
  261. task bool,
  262. monitoring int default -1,
  263. report_design bool default 0,
  264. css bool default 0,
  265. css_free bool default 0,
  266. sr int default 100,
  267. attachments int default 4,
  268. cmdb bool default 0,
  269. maintanance_expiration datetime,
  270. enable bool default 1,
  271. paid bool default 0,
  272. version int default 0,
  273. css_demo bool default 0,
  274. max_inactive_interval int default 0,
  275. cookie_support bool default 0,
  276. sysaid_version varchar(64) default '',
  277. change_mgmt int default 0,
  278. sla bool default 0,
  279. backup_time datetime default NULL,
  280. sysaid_edition int default 1,
  281. product_type int default 1,
  282. send_automatic_notifications_from_modifier bool default 0,
  283. PRIMARY KEY (account_id)
  284. ) TYPE=MyISAM
  285. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'account' already exists
  286. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  287. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  288. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  289. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  290. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  291. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  292. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  293. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  294. at com.ilient.server.AccountMap.runScript(Unknown Source)
  295. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  296. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  297. at com.ilient.server.InitAccount.main(Unknown Source)
  298. 2011-03-23 13:48:07,960 [main] FATAL com.ilient - Exception in sql statement:
  299. CREATE TABLE schedule_task (
  300. task_id int(11) NOT NULL default '0',
  301. account_id varchar(32) NOT NULL default '',
  302. computer_id varchar(64) NOT NULL default '',
  303. group_name varchar(255) NOT NULL default '',
  304. command varchar(255) NOT NULL default '',
  305. next_run datetime NOT NULL default '0000-00-00 00:00:00',
  306. granularity int(11) NOT NULL default '0',
  307. units int(11) NOT NULL default '0',
  308. discovery_service_name varchar(64),
  309. start_ip_range varchar(64),
  310. end_ip_range varchar(64),
  311. exclude_ip_list varchar(255),
  312. schedule char(1),
  313. snmp_version int(11),
  314. community_string varchar(64),
  315. community_password varchar(64),
  316. domain varchar(255),
  317. agent_settings mediumtext,
  318. PRIMARY KEY (task_id)
  319. ) TYPE=MyISAM
  320. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'schedule_task' already exists
  321. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  322. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  323. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  324. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  325. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  326. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  327. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  328. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  329. at com.ilient.server.AccountMap.runScript(Unknown Source)
  330. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  331. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  332. at com.ilient.server.InitAccount.main(Unknown Source)
  333. 2011-03-23 13:48:07,961 [main] FATAL com.ilient - Exception in sql statement:
  334. insert into schedule_task (task_id,account_id, group_name, command, next_run, granularity, units) values (1,'account','\\','Inventory',DATE_ADD(CURDATE(), INTERVAL '1 01:05 ' DAY_MINUTE),3,1)
  335. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'PRIMARY'
  336. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  337. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  338. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  339. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  340. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  341. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  342. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  343. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  344. at com.ilient.server.AccountMap.runScript(Unknown Source)
  345. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  346. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  347. at com.ilient.server.InitAccount.main(Unknown Source)
  348. 2011-03-23 13:48:07,962 [main] FATAL com.ilient - Exception in sql statement:
  349. insert into schedule_task (task_id,account_id, group_name, command, next_run, granularity, units) values (2,'account','\\','Upgrade',DATE_ADD(CURDATE(), INTERVAL '1 01:55 ' DAY_MINUTE),2,1)
  350. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'PRIMARY'
  351. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  352. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  353. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  354. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  355. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  356. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  357. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  358. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  359. at com.ilient.server.AccountMap.runScript(Unknown Source)
  360. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  361. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  362. at com.ilient.server.InitAccount.main(Unknown Source)
  363. 2011-03-23 13:48:07,963 [main] FATAL com.ilient - Exception in sql statement:
  364. CREATE TABLE version (
  365. version varchar(64) NOT NULL default ''
  366. ) TYPE=MyISAM
  367. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'version' already exists
  368. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  369. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  370. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  371. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  372. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  373. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  374. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  375. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  376. at com.ilient.server.AccountMap.runScript(Unknown Source)
  377. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  378. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  379. at com.ilient.server.InitAccount.main(Unknown Source)
  380. 2011-03-23 13:48:07,976 [main] ERROR com.ilient - Error on AccountMap
  381. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'free' for key 'PRIMARY'
  382. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  383. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  384. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  385. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  386. at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
  387. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
  388. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
  389. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
  390. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
  391. at com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Source)
  392. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  393. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  394. at com.ilient.server.InitAccount.main(Unknown Source)
  395. 2011-03-23 14:19:12,438 [main] INFO com.ilient - checking database configuration....
  396. 2011-03-23 14:19:12,967 [main] INFO com.ilient - SysAid Version: v7.5.05
  397. 2011-03-23 14:19:16,747 [main] INFO com.ilient - Checking license....
  398. 2011-03-23 14:19:17,172 [main] INFO com.ilient - SysAid Version: v7.5.05
  399. 2011-03-23 14:19:17,410 [main] INFO com.ilient - License found: ActivationAccountID: free
  400. 2011-03-23 14:19:17,410 [main] INFO com.ilient - Expiration date: unlimited
  401. 2011-03-23 14:19:17,410 [main] INFO com.ilient - ActivationAssets: 100
  402. 2011-03-23 14:19:17,410 [main] INFO com.ilient - ActivationEndUsers: 100
  403. 2011-03-23 14:19:17,410 [main] INFO com.ilient - ActivationAdmins: 2
  404. 2011-03-23 14:19:17,410 [main] INFO com.ilient - ActivationManagers: 0
  405. 2011-03-23 14:19:17,411 [main] INFO com.ilient - ActivationMonitoring: 1
  406. 2011-03-23 14:19:17,411 [main] INFO com.ilient - CMDB: false
  407. 2011-03-23 14:19:17,411 [main] INFO com.ilient - Task_And_project: false
  408. 2011-03-23 14:19:17,411 [main] INFO com.ilient - ITIL: false
  409. 2011-03-23 14:19:17,411 [main] INFO com.ilient - Chat: true
  410. 2011-03-23 14:19:17,411 [main] INFO com.ilient - SLA: false
  411. 2011-03-23 14:19:17,411 [main] INFO com.ilient - Sysaid Edition: Free
  412. 2011-03-23 14:19:17,411 [main] INFO com.ilient - Product Type: SysAid
  413. 2011-03-23 14:19:39,344 [main] INFO com.ilient - Initializing account....
  414. 2011-03-23 14:19:39,781 [main] INFO com.ilient - SysAid Version: v7.5.05
  415. 2011-03-23 14:19:39,985 [main] INFO com.ilient - License found: ActivationAccountID: free
  416. 2011-03-23 14:19:39,985 [main] INFO com.ilient - Expiration date: unlimited
  417. 2011-03-23 14:19:39,985 [main] INFO com.ilient - ActivationAssets: 100
  418. 2011-03-23 14:19:39,986 [main] INFO com.ilient - ActivationEndUsers: 100
  419. 2011-03-23 14:19:39,986 [main] INFO com.ilient - ActivationAdmins: 2
  420. 2011-03-23 14:19:39,986 [main] INFO com.ilient - ActivationManagers: 0
  421. 2011-03-23 14:19:39,986 [main] INFO com.ilient - ActivationMonitoring: 1
  422. 2011-03-23 14:19:39,986 [main] INFO com.ilient - CMDB: false
  423. 2011-03-23 14:19:39,986 [main] INFO com.ilient - Task_And_project: false
  424. 2011-03-23 14:19:39,986 [main] INFO com.ilient - ITIL: false
  425. 2011-03-23 14:19:39,986 [main] INFO com.ilient - Chat: true
  426. 2011-03-23 14:19:39,987 [main] INFO com.ilient - SLA: false
  427. 2011-03-23 14:19:39,987 [main] INFO com.ilient - Sysaid Edition: Free
  428. 2011-03-23 14:19:39,987 [main] INFO com.ilient - Product Type: SysAid
  429. 2011-03-23 14:19:42,409 [main] FATAL com.ilient - Exception in sql statement:
  430. CREATE TABLE account (
  431. account_id varchar(32) NOT NULL default '',
  432. customer_name varchar(64) default NULL,
  433. expiration_time datetime default NULL,
  434. serial_key varchar(64) NOT NULL default '',
  435. account_conf mediumtext,
  436. assets int,end_users int,
  437. admins int,
  438. managers int default 1,
  439. alert_monitor bool,
  440. task bool,
  441. monitoring int default -1,
  442. report_design bool default 0,
  443. css bool default 0,
  444. css_free bool default 0,
  445. sr int default 100,
  446. attachments int default 4,
  447. cmdb bool default 0,
  448. maintanance_expiration datetime,
  449. enable bool default 1,
  450. paid bool default 0,
  451. version int default 0,
  452. css_demo bool default 0,
  453. max_inactive_interval int default 0,
  454. cookie_support bool default 0,
  455. sysaid_version varchar(64) default '',
  456. change_mgmt int default 0,
  457. sla bool default 0,
  458. backup_time datetime default NULL,
  459. sysaid_edition int default 1,
  460. product_type int default 1,
  461. send_automatic_notifications_from_modifier bool default 0,
  462. PRIMARY KEY (account_id)
  463. ) TYPE=MyISAM
  464. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'account' already exists
  465. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  466. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  467. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  468. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  469. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  470. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  471. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  472. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  473. at com.ilient.server.AccountMap.runScript(Unknown Source)
  474. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  475. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  476. at com.ilient.server.InitAccount.main(Unknown Source)
  477. 2011-03-23 14:19:42,411 [main] FATAL com.ilient - Exception in sql statement:
  478. CREATE TABLE schedule_task (
  479. task_id int(11) NOT NULL default '0',
  480. account_id varchar(32) NOT NULL default '',
  481. computer_id varchar(64) NOT NULL default '',
  482. group_name varchar(255) NOT NULL default '',
  483. command varchar(255) NOT NULL default '',
  484. next_run datetime NOT NULL default '0000-00-00 00:00:00',
  485. granularity int(11) NOT NULL default '0',
  486. units int(11) NOT NULL default '0',
  487. discovery_service_name varchar(64),
  488. start_ip_range varchar(64),
  489. end_ip_range varchar(64),
  490. exclude_ip_list varchar(255),
  491. schedule char(1),
  492. snmp_version int(11),
  493. community_string varchar(64),
  494. community_password varchar(64),
  495. domain varchar(255),
  496. agent_settings mediumtext,
  497. PRIMARY KEY (task_id)
  498. ) TYPE=MyISAM
  499. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'schedule_task' already exists
  500. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  501. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  502. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  503. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  504. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  505. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  506. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  507. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  508. at com.ilient.server.AccountMap.runScript(Unknown Source)
  509. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  510. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  511. at com.ilient.server.InitAccount.main(Unknown Source)
  512. 2011-03-23 14:19:42,445 [main] FATAL com.ilient - Exception in sql statement:
  513. insert into schedule_task (task_id,account_id, group_name, command, next_run, granularity, units) values (1,'account','\\','Inventory',DATE_ADD(CURDATE(), INTERVAL '1 01:05 ' DAY_MINUTE),3,1)
  514. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'PRIMARY'
  515. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  516. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  517. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  518. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  519. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  520. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  521. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  522. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  523. at com.ilient.server.AccountMap.runScript(Unknown Source)
  524. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  525. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  526. at com.ilient.server.InitAccount.main(Unknown Source)
  527. 2011-03-23 14:19:42,446 [main] FATAL com.ilient - Exception in sql statement:
  528. insert into schedule_task (task_id,account_id, group_name, command, next_run, granularity, units) values (2,'account','\\','Upgrade',DATE_ADD(CURDATE(), INTERVAL '1 01:55 ' DAY_MINUTE),2,1)
  529. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'PRIMARY'
  530. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  531. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  532. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  533. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  534. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  535. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  536. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  537. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  538. at com.ilient.server.AccountMap.runScript(Unknown Source)
  539. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  540. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  541. at com.ilient.server.InitAccount.main(Unknown Source)
  542. 2011-03-23 14:19:42,447 [main] FATAL com.ilient - Exception in sql statement:
  543. CREATE TABLE version (
  544. version varchar(64) NOT NULL default ''
  545. ) TYPE=MyISAM
  546. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'version' already exists
  547. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  548. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  549. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  550. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  551. at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
  552. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
  553. at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
  554. at com.bitmechanic.sql.PooledStatement.executeUpdate(Unknown Source)
  555. at com.ilient.server.AccountMap.runScript(Unknown Source)
  556. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  557. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  558. at com.ilient.server.InitAccount.main(Unknown Source)
  559. 2011-03-23 14:19:42,483 [main] ERROR com.ilient - Error on AccountMap
  560. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'free' for key 'PRIMARY'
  561. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
  562. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  563. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  564. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  565. at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
  566. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
  567. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
  568. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
  569. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
  570. at com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Source)
  571. at com.ilient.server.AccountMap.newAccount(Unknown Source)
  572. at com.ilient.server.InitAccount.initAccount(Unknown Source)
  573. at com.ilient.server.InitAccount.main(Unknown Source)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!