mkild / dental-admin-api Goto Github PK

Ignoring invalid configuration option passed to Connection: collate. This is currently a warning, but in future versions of MySQL2, an error will be thrown if 
you pass an invalid configuration option to a Connection
Ignoring invalid configuration option passed to Connection: collate. This is currently a warning, but in future versions of MySQL2, an error will be thrown if 
you pass an invalid configuration option to a Connection
Ignoring invalid configuration option passed to Connection: collate. This is currently a warning, but in future versions of MySQL2, an error will be thrown if 
you pass an invalid configuration option to a Connection
Ignoring invalid configuration option passed to Connection: collate. This is currently a warning, but in future versions of MySQL2, an error will be thrown if 
you pass an invalid configuration option to a Connection
Ignoring invalid configuration option passed to Connection: collate. This is currently a warning, but in future versions of MySQL2, an error will be thrown if 
you pass an invalid configuration option to a Connection
Ignoring invalid configuration option passed to Connection: collate. This is currently a warning, but in future versions of MySQL2, an error will be thrown if 
you pass an invalid configuration option to a Connection
Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `username` VARCHAR(255) NOT NULL UNIQUE, `password` VARCHAR(255) NOT NULL, `salt` VARCHAR(255) NOT NULL, `state` TINYINT(1) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
Executing (default): CREATE TABLE IF NOT EXISTS `user_role` (`id` INTEGER NOT NULL auto_increment , `username` VARCHAR(255) NOT NULL, `role_id` INTEGER NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB;
Executing (default): CREATE TABLE IF NOT EXISTS `role` (`id` INTEGER NOT NULL auto_increment , `rolename` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
Executing (default): CREATE TABLE IF NOT EXISTS `user_detail` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(255), `username` VARCHAR(255) NOT NULL, `gender` VARCHAR(255), `phone` VARCHAR(255), `email` VARCHAR(255), PRIMARY KEY (`id`), FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE CASCADE 
ON UPDATE CASCADE) ENGINE=InnoDB;
Executing (default): CREATE TABLE IF NOT EXISTS `notice` (`id` INTEGER NOT NULL auto_increment , `title` VARCHAR(255) NOT NULL, `author` VARCHAR(255) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`author`) REFERENCES `user` (`username`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB;
Executing (default): CREATE TABLE IF NOT EXISTS `notice_text` (`id` INTEGER NOT NULL auto_increment , `notice_id` INTEGER NOT NULL, `text` TEXT NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`notice_id`) REFERENCES `notice` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB;
Executing (default): CREATE TABLE IF NOT EXISTS `department` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(255) NOT NULL UNIQUE, `director` VARCHAR(255) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
C:\Users\Desktop\dental-admin-api-master\node_modules\sequelize\lib\dialects\mysql\query.js:239
        return new sequelizeErrors.DatabaseError(err);
               ^
      at Socket.emit (node:events:526:28)
      at addChunk (node:internal/streams/readable:315:12)
      at readableAddChunk (node:internal/streams/readable:289:9)
      at Socket.Readable.push (node:internal/streams/readable:228:10)
      at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
    code: 'ER_FK_CANNOT_OPEN_PARENT',
    errno: 1824,
    sqlState: 'HY000',
    sqlMessage: "Failed to open the referenced table 'role'",
    sql: 'CREATE TABLE IF NOT EXISTS `user_role` (`id` INTEGER NOT NULL auto_increment , `username` VARCHAR(255) NOT NULL, `role_id` INTEGER NOT NULL, PRIMARY 
KEY (`id`), FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB;',
    parameters: undefined
  },
  original: Error: Failed to open the referenced table 'role'
      at Socket.emit (node:events:526:28)
      at addChunk (node:internal/streams/readable:315:12)
      at readableAddChunk (node:internal/streams/readable:289:9)
      at Socket.Readable.push (node:internal/streams/readable:228:10)
      at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
    code: 'ER_FK_CANNOT_OPEN_PARENT',
    errno: 1824,
    sqlState: 'HY000',
    sqlMessage: "Failed to open the referenced table 'role'",
    sql: 'CREATE TABLE IF NOT EXISTS `user_role` (`id` INTEGER NOT NULL auto_increment , `username` VARCHAR(255) NOT NULL, `role_id` INTEGER NOT NULL, PRIMARY 
KEY (`id`), FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB;',
    parameters: undefined
  },
  sql: 'CREATE TABLE IF NOT EXISTS `user_role` (`id` INTEGER NOT NULL auto_increment , `username` VARCHAR(255) NOT NULL, `role_id` INTEGER NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB;',
  parameters: undefined
}

漏洞标题：nodejs ejs远程代码执行漏洞
缺陷组件：[email protected]
漏洞编号：CVE-2017-1000228
漏洞描述：nodejs ejs是一款嵌入式JavaScript模板，它具有流量控制、自定义分隔符和转义输出等功能。

nodejs ejs 2.5.3之前的版本中的‘ejs.renderFile()’函数存在远程代码执行漏洞，该漏洞源于较弱的输入验证。远程攻击者可利用该漏洞执行代码。 
国家漏洞库信息：https://www.cnvd.org.cn/flaw/show/CNVD-2017-36621
影响范围：(∞, 2.5.3)
最小修复版本：2.5.3
缺陷组件引入路径：[email protected]>[email protected]