smartscenes / sstk

SSTK: SmartScenes ToolKit
MIT License
116 stars 41 forks source link

Error: Database access denied #16

Closed jb892 closed 4 years ago

jb892 commented 4 years ago
OS: Ubuntu 16.04
nodejs version: v10.21.0
npm version: 6.14.4
MySQL version: 14.14 Distrib 5.7.30
SSTK: head -> dev

Hi,

I'm trying to setup SSTK server on my pc. However, I'm running into this error:

(node:13358) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
error: Error querying database code=ER_ACCESS_DENIED_ERROR, errno=1045, sqlMessage=Access denied for user 'DBUSERNAME'@'localhost' (using password: YES), sqlState=28000, fatal=true, name=SQLQuerier

Could anyone help?

jb892 commented 4 years ago

Hi @msavva and @angelxuanchang

After some research, I have managed to set up a MySQL server by doing the following steps:

  1. puting correct user and password info in the file sstk/server/config.index.js in this line config.annDb = { host: 'localhost', user: 'USER', password: 'PASSWORD', database: 'scannet' };
  2. Create a database called 'scannet' in MySQL server.
  3. Change line 4 in file sstk/server/proj/scannet/tasks/segment_annotation/default.config.yml to scansToAnnotate: '../../../../static/data/nyuv2/nyuv2.example.csv' # up to server directory

Current status and problems:

I can access to the example annotation model now: scannet_annotation

But, I'm unable to fetch and save the annotation in MySQL since I don't know how to create the data table with the correct attribute fields.

Could you please tell me how to set up the database correctly? Thx in advance!

Additional info: Error and logs

error

audited 517 packages in 2.474s

2 packages are looking for funding
  run `npm fund` for details

found 81 vulnerabilities (25 low, 18 moderate, 35 high, 3 critical)
  run `npm audit fix` to fix them, or `npm audit` for details

> sstk-server@0.5.3 start /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server
> node app/

STK running on localhost:9010
Reverse proxy running on localhost:8010
*** Done booting server. Access through localhost:8010 ***
(node:12333) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
(node:12333) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
info: query filters 0=ann.task, 1=scan-model-align, 2=ann.itemId, 3=ann.condition, 4=ann.status, 5=ann.status, name=SQLQuerier
info: query SELECT * FROM annotations AS ann where `ann`.`task` = 'scan-model-align' AND `ann`.`itemId` REGEXP 'nyuv2[.].*' AND `ann`.`condition` IN ('manual') AND (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) ORDER BY created_at DESC name=SQLQuerier
error: Error querying database code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=SELECT * FROM annotations AS ann where `ann`.`task` = 'scan-model-align' AND `ann`.`itemId` REGEXP 'nyuv2[.].*' AND `ann`.`condition` IN ('manual') AND (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) ORDER BY created_at DESC, name=SQLQuerier
info: query filters 0=ann.type, 1=segment, 2=ann.itemId, 3=ann.condition, 4=ann.status, 5=ann.status, name=SQLQuerier
info: query SELECT GROUP_CONCAT(`label`) as `label`,COUNT(DISTINCT(label)) as `nlabels`,COUNT(label) as `ninstances`,`ann`.`id` FROM annotations AS ann JOIN segment_annotations AS parts ON parts.annId = ann.id  where `ann`.`type` = 'segment' AND `ann`.`itemId` REGEXP 'nyuv2[.].*' AND `ann`.`condition` IN ('manual') AND (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) GROUP BY `ann`.`id` ORDER BY ann.created_at DESC name=SQLQuerier
error: Error querying database code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=SELECT GROUP_CONCAT(`label`) as `label`,COUNT(DISTINCT(label)) as `nlabels`,COUNT(label) as `ninstances`,`ann`.`id` FROM annotations AS ann JOIN segment_annotations AS parts ON parts.annId = ann.id  where `ann`.`type` = 'segment' AND `ann`.`itemId` REGEXP 'nyuv2[.].*' AND `ann`.`condition` IN ('manual') AND (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) GROUP BY `ann`.`id` ORDER BY ann.created_at DESC, name=SQLQuerier
warn: Unknown task: manual, using default task configuration name=SegmentAnnotatorServer
info: loading task config ./default.config.yml name=SegmentAnnotatorServer
info: loading file /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server/proj/scannet/tasks/segment_annotation/default.config.yml name=SegmentAnnotatorServer
info: loading file /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server/static/data/nyuv2/nyuv2.example.csv name=SegmentAnnotatorServer
info: loading file /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server/proj/scannet/tasks/segment_annotation/annotation-checks.yml name=SegmentAnnotatorServer
info: loading file /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server/proj/scannet/tasks/segment_annotation/segment-labels.json name=SegmentAnnotatorServer
info: loading file /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server/proj/scannet/tasks/segment_annotation/survey.json name=SegmentAnnotatorServer
info: loading file /media/jake/DATA/Documents/SceneAnnotationTool/sstk/server/proj/scannet/tasks/segment_annotation/category-parts.json name=SegmentAnnotatorServer
info: query filters 0=ann.status, 1=ann.status, name=SQLQuerier
info: query SELECT `itemId`,COUNT(DISTINCT(`id`)) as `id`,COUNT(DISTINCT(`created_at`)) as `created_at` FROM annotations AS ann where (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) GROUP BY `itemId` ORDER BY created_at DESC name=SQLQuerier
error: Error querying SQL for existing annotations code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=SELECT `itemId`,COUNT(DISTINCT(`id`)) as `id`,COUNT(DISTINCT(`created_at`)) as `created_at` FROM annotations AS ann where (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) GROUP BY `itemId` ORDER BY created_at DESC, name=SegmentAnnotatorServer
info: SegmentAnnotatorServer annotateSingle processing user USER@::ffff:127.0.0.1 name=SegmentAnnotatorServer
info: passing to client mId=nyuv2.bedroom_0114 name=SegmentAnnotatorServer
info: query filters 0=ann.taskMode, 1=fixup, 2=ann.itemId, 3=nyuv2.bedroom_0114, name=SQLQuerier
info: query SELECT `id` FROM annotations AS ann where `ann`.`taskMode` = 'fixup' AND `ann`.`itemId` = 'nyuv2.bedroom_0114' ORDER BY created_at DESC LIMIT 1 name=SQLQuerier
error: Error querying database code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=SELECT `id` FROM annotations AS ann where `ann`.`taskMode` = 'fixup' AND `ann`.`itemId` = 'nyuv2.bedroom_0114' ORDER BY created_at DESC LIMIT 1, name=SQLQuerier
info: query filters 0=ann.type, 1=segment, 2=ann.itemId, 3=nyuv2.bedroom_0114, name=SQLQuerier
info: query SELECT GROUP_CONCAT(`label`) as `label`,COUNT(DISTINCT(label)) as `nlabels`,COUNT(label) as `ninstances`,`ann`.`id` FROM annotations AS ann JOIN segment_annotations AS parts ON parts.annId = ann.id  where `ann`.`type` = 'segment' AND `ann`.`itemId` = 'nyuv2.bedroom_0114' GROUP BY `ann`.`id` ORDER BY ann.created_at DESC name=SQLQuerier
error: Error querying database code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=SELECT GROUP_CONCAT(`label`) as `label`,COUNT(DISTINCT(label)) as `nlabels`,COUNT(label) as `ninstances`,`ann`.`id` FROM annotations AS ann JOIN segment_annotations AS parts ON parts.annId = ann.id  where `ann`.`type` = 'segment' AND `ann`.`itemId` = 'nyuv2.bedroom_0114' GROUP BY `ann`.`id` ORDER BY ann.created_at DESC, name=SQLQuerier
warn: Unknown task: undefined, using default task configuration name=SegmentAnnotatorServer
info: query filters 0=ann.status, 1=ann.status, name=SQLQuerier
info: query SELECT `itemId`,COUNT(DISTINCT(`id`)) as `id`,COUNT(DISTINCT(`created_at`)) as `created_at` FROM annotations AS ann where (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) GROUP BY `itemId` ORDER BY created_at DESC name=SQLQuerier
error: Error querying SQL for existing annotations code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=SELECT `itemId`,COUNT(DISTINCT(`id`)) as `id`,COUNT(DISTINCT(`created_at`)) as `created_at` FROM annotations AS ann where (`ann`.`status` <> 'rejected' OR `ann`.`status` IS NULL) GROUP BY `itemId` ORDER BY created_at DESC, name=SegmentAnnotatorServer
info: Got annotation for nyuv2.bedroom_0114, user jake name=SQLAnnotationDb
error: Error querying database code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table 'scannet.annotations' doesn't exist, sqlState=42S02, index=0, sql=INSERT INTO annotations (type, task, taskMode, appId, sessionId, workerId, itemId, `condition`, data, preview_data) VALUES ('segment', '', 'fixup', 'SegmentAnnotator.v5', 'local-session', 'jake', 'nyuv2.bedroom_0114', 'manual', '{\"stats\":{\"initial\":{\"annotatedVertices\":19544,\"unannotatedVertices\":47677,\"annotatedSegments\":59,\"unannotatedSegments\":383,\"totalSegments\":442,\"totalVertices\":67221,\"percentComplete\":29.074247630948662},\"delta\":{\"annotatedVertices\":33775,\"unannotatedVertices\":-33775,\"annotatedSegments\":180,\"unannotatedSegments\":-180,\"totalSegments\":0,\"totalVertices\":0,\"percentComplete\":50.2447151931688},\"total\":{\"annotatedVertices\":53319,\"unannotatedVertices\":13902,\"annotatedSegments\":239,\"unannotatedSegments\":203,\"totalSegments\":442,\"totalVertices\":67221,\"percentComplete\":79.31896282411746}},\"timings\":{\"times\":{\"initial\":1594027333438,\"modelLoad\":{\"start\":1594027335060,\"end\":1594027336158,\"duration\":1098},\"annotatorReady\":1594027337237,\"annotationSubmit\":1594028256206},\"durations\":{\"modelLoad\":1098,\"annotatorReady\":3799,\"annotationSubmit\":922768}},\"metadata\":{\"segmentType\":\"surfaces\",\"startFrom\":\"latest\",\"startAnnotations\":\"aggr\"}}', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGQAAABPCAYAAAAdiWChAAAgAElEQVR4Xu19CXhU5fX+e+fOnT2TfSFAICxhCSBoxaValWpYBLUuuFSt1J8ormxuVRTRtiJaEC2gIlJtK5YqIqCyyKIgFTdUkD1AVhISkkyS2e7M3P9zzne/yQRQtmK1/V+ePGFm7r1zv/N+55z3LN8XBQAmjhxhRGMxWFV17aMvzDn3hqKirNeWLaumz/7/8cNKQCkaX5TVqdhR5XI6YLNaETMMuBx2qBYVO0rLkJ2WikZ/AEbMmPXCgndG/bCP97/3bcpVj116dcGepHn+YAiKRYFmtUIBGJiwriOsRxCLxUCANQeCMAwDqsWC6rr6uW+uXDPif09kJ3fEyuUPDL26Y6lrHgk9Eo1BUcBCt2ka3E4HAsGweI+ewzBQdaCOTBtCus5PFgiGkOxxY+7i9wlHPl555P5hIyZNXnRyH/2/8+7KlY8Muyt/t2c6AaKqFlgUxdSOCCwWhbVFURQGhD5z2O040OBDJBrln4amJmiqlQHyul1on5ONnLRUeN1u2A3NPnzixPB/p+hOzqiU4ROGPt5mh/1hu82GWIzEbsBisTAIobAOzaqyiSITRprDzt9igaZprDa1vgakeDxI9nhQsb+GtapNRgZyMtLgcTpw8egH4ppzcobw33VXBqRdseth8hcEAvkQOjRVZa0gAEgzLIqFNUKPRGDAYPBIo8h87a+rhx6JIhgKsZ+ha4LhMAPSq0snJLldyExJXZzmTWqwKpanhz80ceN/lxj/faNhQHK22x+OGTG4HA4WJpkv+lEUC6xWFbFojH/TQUAEQiHYNGsLQBFgSNLArpf+9Y6d/75H+9+8k3Llw0M/yCt2DdCjEdYQMk/0m2Y+MSwyU/SaDulTyLJFY1H+jH5c+zLQKTXvb7ctnHD98YpxzNk3GVM/nntSzduNFw/8XVZayrjS2vq0r4r3LvV6vQN75WazCd6waw/sTifT/FyXA8G6npj7we9P6vMcTlbKFQ8NNdQtNoT0MDq67YjGDPYbhiEAILslfAqgqiprDmkRmS67prFZ81RkYuIHz53Qw9911o3Gc+tfPaF70ADv+8UtxteuMnjtGjTNCs1igStGkw0IR6IwyARbBHlh5miSFXqPJ2Ekgvp6G3z1LuRlFZTMfPd3HY53kh3Pdcq1ky4zXn/kbWXgwIFGF6+L/QKBIWMRKzEvC71H2iCYFn1Ipou0hHxHcm0WJq9+6biFeVPH8x3e3LzA9I9PDJDbC6/ydGjXsbE8pTj+jKpF4YlEfJEtgGrhsRGJkROOgJEsM8nlwo5tKTjga2IiM3/d9OMe13EBMmLqNcYrY+Yp9914rUGznmY/CV6YKiBq+g8CgnyKOIQZI1DI9yRXZePxVTOO+8EX3/DCuH+VffX0EydwD3oq0rJsdzpqs8r4KdnU0uRSpJYzLCxoGW8RMDTpmvxB6BGdLUTJnjQ4bC6+h9eZhtnLJx732I4VFOXWmTcYe/6ydW6P/A43EcMiJkVg/CujDqGOTiiqBTE9ikC5D0Oqc4S2xIhn0T9AVRR4KrPR0ZubP+LtB/cc6wPQ+Q+cN9Lw2pPwu2XPHPfA7//FLUZFYzVOy+2FoMOPOk+VYIQJPpC0gFSHwKDJRICZ7tHUeM7noaK0DfRImJllKBKAS/Vc9I9/PbfieMZ2rNcoV0+81PCUZqC6ohwdklw8W0joi9MrEAvqDAaBYrGrGFybyyZLOnkaLB2efVk4kdk96cJ7jF21JfjLlwtaAfLVbW9lnTLr8uo/FI01ynxV0SSbSy2vr7j0r18veSdxoLvHr3p04ZblE5vDQYRjOmrTy+JmlyROPpEmG2k7PTNpNVsB+mdOLvaTAE/IqvK2PNkILE21I6T78db6Wcc9WY4FFOWcq/t/m+7PLjilXz81EonAt3MrC/299ArxsNEYqz05yIF1bdhssRsxgSETkLwvBxNWTDvuB54+bIKR4UzFdf8Yy/f4+q7FRmVjNQoyO6I+4ENJfSX8kSD2HChDr5wCBPQg3tq8vGp478HZ72z5AKe1LUQkFoVVsaI8Wo5Qqo8FTzM8asTiQLCxpfeJrJgUnn6TmRYMU8H+qnREI3a+NhBuhtvhRUgPIM2TjTkrHj/uMR4tKPwFY/r1M7bn5kLXdXRPTeKH+1fSftQqQSjMuGIYVtceiqrw4A4+2tTl44GlU5Sre1+899b+V+c5NQfOmjVcOb9T/5+tLt7w2fc9zOxf/X7Mil0f/4ns+mMX3g2H1Y76QANSnMkoqa/AxyVfwAILLu5xATyaCxsrtj76afnGx85o3xcbyr7GkILz8NGez9Avtwe+2rcN+zNKOE4SvrAleCWNoOA3kVnJ5yLtYGCiUewqdjMIFoUYZYS1yWX38Ov2WZ0vf3L+qAVHK9zjOY8BubNPH2NPXh6MoB9dM9OE2zYMvKcXI6YIX3GJravIaRHbYkts5rjIBOxxYV/jfpzWthfsqg1Omx2ZrjSenanOZJ5tF8y+/rCza8Rplz84rPsv/5DjyUCaKwV2qw2hSAh76sphUzU060Ek2V1IcyaD/My0dXP7BSOhL5vDfnTP7IRPy75B39yeGNT1HKwq3oCyZIpNhVkVcRPRW+EvmOqabJHUXhIYQQCE4y+vSka4WYHN6uCYLBLV+Yecu8uehBeXPXJStYRvfvcppxhJQ4ciuGcnU1mpznJQAmnhAOUApf8gR3meOgAZ7lQs37EORV3PQTgaRigSRn2wEVWNNfik7Cvc/4uRmPLRKzf+/au3X0ucOUtvmlP5+teLcjw2Ny7p8UsGj4RF9RjNYkWzHkBQD+GLvEr0KE7de828MR0v7n6BkeNJxwG/D31zu8Nu0RCM6vCFfdBzfbCqlP5pmTicoTMduvhu8iPif0zjzbNpLPb2nbD3X5T+iXJ2m0asR0PITctHdX0ZMry5J5V1CUD69jU8Q4agefd2nvlE/RIfVAhfzDB5SIYSQwx3594urjNiUBVKsZhc0xx0JBaBqlhYyOFItKxg6oXt5X2Kx69knSOgRRJTBJ6UQRa5ZuD9yo+xwb4LJSUlw5YtW7b4YFOwcuZUo8bXgI83bjI/EtdJamtyD9YYSenld/JX8OMq0K0aNEcHNO62ocFfA3pu9kOxCN8vJ7UD9lRtQUHbfnhu8fiToil803v69DFcF1/MNrSppBg2U7UTB0Ug8ayTRtjMCvdM7obz3b9gdiIDSDHLhdmLD1yKiust4oXVovI1BCIBIU2iZHFy5j5SMQehUAgpKSm9X375ZSn1VrismjXNoBnuD4XAfIliKMoo6BFEyJ9Qfo7Mq6kp9H1Ei/lZFfEsy7bsA6oy0BSoZ/ISiYahWR3QI0EE9QC6tT0VYT2AkB7E3JUnJ62ijJw4MqN6zY793vbtWSCNjY1oawVXD6UDZ1tsaocIrITw6HNiZroZu5CEIpEoJyJJ0CQQkr5M5wsuKiaWyJnRS0pjCNkKKiqiZr7W9FP1USDVpqKkKbj64SuHVgBKQyQSnWG1Wn6tKMoD0qcJAM0bHaRG8XnUSodaTqrxNWLFB5ThNrC/oRwxI2pG76TVIQTDfmhWO9qkdMCe6i3Iy+yGOSsm/du1RBk2tmhp+Eu96Ixzz8WaNWuQ5nSgfbJHcHQzVUIzS4IinDmlUgSXJ1srHKaZXjF5DIHFqXvSADJFcQELwcedrEkReGSthidUib9btSAYDMFu0/gkyjQ7bTZ4XC6+D9VgKBGa5k1i+iucNzjIE59RdVPYJkqjUO+AXbMhHNGhQOMxrP5IQ8WB3eYkkKxL58mnWihg1jlItFo0eJ2pqG2sQnpSNrq2PWXopHk3LTnYjB7va2XAFecbdr8Tffr0QXDvrriJaSnbmikIk6kIcyMEJbVFDrY1o7HwvcgM0iGppfRHUvYtrlcMQQJjeoE4Q6KYSNZf6DwGytS2uDaZjEqmdCRB4OIamVwzQo8zRWJWpOkxA5Vl2TypJADsI02pSqJDvoQmI02u7NT2PGH0aPjfmhVWhv3fIKNHWh+UlZUhr307BEt2szaI1IJgVYmRLTlb+do0ECwcaYakWFlzTPpJ2kTykEGZHKrMKUkeLQgFpS/Ed9Dr5kgMboqF4hGEsEvytQwA6WRJaQVOQiPkBJD+j+4vSwzyvVhUQ1VletxH0vOSeaLfdEhAEn2bx5EMf6gJbkcSATThtdWTnzherUi8Trlm0mUf5Ad6DGhqaoLVaoWlmuxnC0Npse1icLJwJbLCQkvEOeZn8Tq8+Fxoh8luzEqjALIljyRuIGRIwuIUB5EGxYLtDc0oSHa3BiTh/EOEEAerZYa3qJ6EqeUqOquiNMecAOzU4qyKGSObP2oA0WFVybwRERAkpGNWd+yu+haZTIUf+7f4E2X4Q5f+3tBsj/nW+0JpaWno2rUrmRmfqqpemhE7d+xAFvQ4M+IMsBkFCwopZpFMcYuJKQ1Ri9AT2Zlp9UwcTFCJ6agq/KEwglEDqU47g7+3MYC8JEccsLgoEzy5LBcI+E2w4/bvIMikd2+xmSgvzTYxE4EjExYSvEUVqSIozLiYgPCEiUCz2mC12ECaUla7E23TOpe/tPzRdieqJcq4ebcZz1wzS7n88ssNLtxYLJOH3zWtMhIJfTL/+fGRzm7bp+QHJPuR5kmOPW5KTEdNgCTS3sQHpPuTkCUVbqHEQgjWth2xceNGJCcnIxwOoxMVzMhXmDdJzNyazLaVponygDRTpvGUyVCZTDRnQ0vGQUF5aY5kGmbcQQyLYg9BVkgzyFc0h3wMAAEUNajrRken7EJUN5Syr/zHv6F2oox99TbjTzfOUkaOHMmAkOm6/I4prSjPh9Pv5NHJxgYR+Zrz0ZxRbJ7i9FUImMyPZLp0bZhSEVCQpqlMl0PkqIVDYK1rsLvx2muv8V0GDhr0Xtdk9yCmxHG2bL6Agu1KBdztc/Xw1vAXLpdrwbx58ybTdeNvuMGdk+VsP/6ZF7dOG3vXK8FIOGpV1Js1zbrRYondYuiK0xcOpBXv9rzlseRZwpFm1DZVs6YrEOyRWSQMjj+sqk2YZab5EYQjQThsbiYDnFJxpXHicXPpJ+jZ/gxMe2f0CZkuZcLDEwyKOSjwohjkguseYvOTeKx5VgAitUE668RIWNh8syx6EOmXAf7WuiZRPjXbiAiUYMCPLG8SKuoaKPBDc3PzN8uWLetD3zd48GCD/AdbHwX40rYHpWoNQorObUiuHi4oHoVjJgD6phGbbPSfwlcKXwdwjfQiESXys603bf38cOZkwtVzDTJPvkAd9tXtjQepNMEisbBpnuxsvkgCVCchGpzkTIXPX8v5LcoKExXeWfk1urTpXTV35R9zjtd0Kb8eN3zx1tW7LiYQ8vPzcfXoZw+51+pn74hze1nqjGd9TRPFRR8zsot7kAQ7TZOsJhTC3xcsVh555JGLt2zZ8v78+fMFJwZw1VVXvVtYWDiY7j9p0iRlyJAhBaqqbuvdIw8Lu61G3cq6ST1O7zGjV32vbo6AY8/kyZNLOk3oZNhybFCdZOtFdE6am8iG5P03jdj0nTO3MO/MJ0cOnHT/l8VrOEon9GXKhJ6HGBflsyj1Q9pKkXqSM4WDR5EWUpHszmCAGgP1KMjti6nHqSnK8Ecv+bzp08ipNFvJqaelp+PC6ye0AmXd3McRPFAR72xMdNCyz1QyKulrKUCjGSprD3TDamjo1q0b/H4/p/q9Xi8ef/xxAsiorq5GamoqgsEgmc0RL7300txL7rjE2Jq3FWqyCovVAnImUvAkmHBNGFF/FI52jri5TCyeJQITi8WWfnvzt4O+b+aOHz/e2LM+KAmzaAyMCucuYy8CJRaLYr+vHF3b9GW/Qq8JnNy0zjjQVMXX/23N08dlupRf/ubcbdoBd4ESUVggubm5nqSk5KbeRbfEn725yYfP5/yOAyjBqkQVjs2YjKZN5ymCMhHDyHiB3iNgfFXfoCm9D3r16sXOnUxkXV0dBrQL44t9BraV1/P9ysrK7Js3bw4PGzrM2NRhE+zd7QyIYj90jE3fNMHVxQWLXQAWj2nIfHLw0/Jez6U9raSVhS8VNipWxUPPHw1Gv9wyasup9P8JEyYYpesjaA40mSaasg3k4KNspmRGgt5z272i7q4o8Ad90KM6WxGX3cuaYtecxwWKcuaA/oY96mSWsHbtWmXixImcpOs7+PY4IPTZh8/dzciLiFsYJWkexEw0HUdCY4E0YbLtprtvIZbah8LlcsFut3PcQ5r5XO4CvFBWgHU1yfBHVczuvuqTnKebz6QH6Dmrp6E36FDdKpsmBjnBLEWaIoiFYtBSNC6gEShG1IChG/yaNdcExWW4cFHZRbc++eSTLxbOLmTfSYMic9bz5Z7FFosln0bW6+ULOc5gwMxML/2fNIUcOY2WzBhVEtuk5qOuuYrrJcS22qZ35tyXHgmhKdiANz8+tuYP5dRz+5UUnJ3fvv+1p2D97zelFxYW1pI5OW3oXS3abRhY89xdcUBSs3Jgs2loDkdE/EE9T3W1aPA1moWhlqkqTRmdc0Z4Mfp2yka+7QBs1taBG9Nqzp2Zxa/HfMoXM0cY1yufIOKLQEvTGAi9XofFJoiwzA6Hq8NwtHXwe7FwDCBZEnYRc5IQSyOwCC+rBVvu2qJ0/3P3qGK20Zj3eyoYCj7vcDpKhiy6HXv3bxMZCSrvWhQWMgm9KVjPppiE7Q81IiulPScenZoLhgKkuNJh05zsb+qbaqBnl7BWHq2TV/7v+esv2vVW+bLzxv0Mn874Nj7Q3z40u9U9Vk29nU1RuW6wyaHZnXiQ6bHsr4wnESUjI+pLaW46htqXY9v+CG45VWPh0w+5BgJLjwI2toIKwlFiOMC2dr/Cb5RPoEQAvU5HLBCD1WsVGhCmer+g2gSUo72DNSXSIDQm2hTl3zE9BpjiIC2zuWwYFB40a8aMGaMKniow6B4ElmJV1lgclgcsNst6umfhKwMQiYrnloEimS4X1djDfn5oek2sy2n38GSl8xyam8HITe+MA437UNdUjTfWPnvU/kS559WRedtfL93786v7I1xsYPfu3XC63Bj4m0fNRJ+414ZZY3nNyOrtu3HWWWfB4XDEZyh93tDQAGf9/rhfEYOQXR4iWHPmd0PmZ1OwJHouli9frugTvMaD/pvh9nj5uowNk7EznIEO1hpUp/ZFt/Zp6NYuHUP+sYiBcOY7+Tf5C8WmINdwclGsoskPNUllM8UAEOMLxhg0cvypIStiDVFo+9IRaRtBm+Q2SImkZGzM/rzm3V8MwrA9K9nkOWxW3JPSHS827sAF71+AbaXhFqpvAsBaaFADOq0KEKn59KQc+PwHeIykNS6Hh2O2TjmFaDCZ1xsfHV0TiHLjU1ctyanJH0Iz3mazYeLElqawSy+91Div6Gp0PHUANr06gWeEoSj4cFtxhdfrzRUUWDVT2io6u4mvm3UQU31Ep6OCM1zbUVV/AM3792JR5FxmdI9224qsWDWet97KZ1+v/x1PfObGzyxb8M+SpKSL+vdoHNCvA9pnUtOBghSPPb48IqF4iWpfENc+9zXadNQa//rrfklScxPKL/FegMT3zCwPkxVRpOJ5zpfPbdyJd5/JZqcu6jnCTEYiOhw2JwPBqRUQDQ5wABmJ6czKCCACgqJ6Kv2W1xbj7x8eXc+Zcv9rdzdXLq+/MC8v72P64rq6uivS0tLeTDRHvYtuxbh3KK4SDzuofhEWJV+Cy/3v8cP+o6ETbFn5UJgeHv6YXX7F0E8qsPjy7ipeLG6H7ZYuWHL6WjSFDdQFDJQ3GqhsNLCjwYL7lzYpU0aeX3HhqfltdpbXoVfHDDjtGlKTHDyLuXcsEZHvMdCShov1LXSi8CsHpR5NZijL1OKcWl8Ao6aSNrSUcUngCtd4rKht3Id0TzZqGiuR4s6E1SLMOAWZ1LlC+a+s5PZIcadjT/U2vPnxn49oupRx824tjqx3nG+32/c6nU489thjyqOPPmokcviu516Pb8oP4PXNYmHutcpavG78HAWxcjTDjtKIBxbNTmXG7xTNqM+uYJ/hsilwWYGbT7WhPmggFKWagrjMYVXw9290RCNGUSjvjGW98jPR0BxC/265SHbbkeTUOBbSuJlPVDETq4WJX35IDtFMz8h8GOuC2ZXSUkaQDeaiCYL6tMbPULG3uoGnovQpBmLsK4J6s2m6rBwOkFZQWoUCRRG7UGtRBIV5/VmLnll495EBuWPOiEtdWzLO3Lp16wNdunTB1KlTDwHElt4Zbbv1xyMf7Pieufj9H53X+D6KKmejNgCkORW4NOHU+QkVwK2JzPDWmhhGvx9Upt1+oUEWxO2w4dSu2chMccFtt8Hj1OKRuOiiPLpHkp2KkYiorcuOGhJ6vKHDbOYQeiQ0im5/3RNBjs4pyUhmmz4lOkxdjexPzKSp1CSixOzwo2GmyfR5p5xeKK7a9OSiT+Y8+H1PrIyZd+vtzs+SPux+wbXfPPvISAwZMmS5YRgXJbIoihUoLhn3zhdHN/rDnEUz858HrsG6UiqxCjDoJy9ZQZlPsCrBVIADp4/7w3vNeb+7MTQfaV4H0pKc6NkhAyluO1wOjU2WPFea0YOBiWcTTBotH4n8BS9ISujm1yjoTMjDiRydAIW+p64xgFueFmsuJY0nQXucKQiEmvhaWWmkJggChEwaHc1BH1TVCrc9ibXpSBG8Mub1W150fJ1xy+nD7kYoHMKHb0zGjh07oethDuDoGH7nU/CmpmPswuMHhO4zo3Q4DgRiCEeFOaAyO1FdblKjgQcNJNmBTQX3GPOMc5QxTc8yeG3SPCjskAGbpqJdpmBkVlXM7MPlraTwW1I88d4KESNS4pD7fM0qJqX+rYf6JVmBJCDGPB9FRW3ILMRFQEWEsB7k5CI5c5lwlQUsAsyuOVhDaALosTByUzsesZCljJtx5wtaiWdk/0tHH3H2j3n7e7tCj3j9BRvuRqO3B4rLqqGHAny+qI+IFVs9O2ahQbciKysLa9oMx5jGaUwfk902pHtdKGiXhnYZSTxz7ZrK6yBZMxIbAMx4IA6KsD+sSJJVyUyD0BZByQlY6Zta+SKz2EbvXfOY3+xGEU6PmBd1OBIgHMGbquVxpMAfbozXVihqJ59CASQMjFm68W/TvktYyvBJl8zfsaD0SqtmY0oX0XVOZ4j6BoW7wpZEew5GuMuAIwr9SCcYkTAUK2fJDzkM7mChWoQIss5Ut+GsuvfQv3sbntGVB5pwYb+OcNjF5gaUT5PL7EwJyZJM3LRIJA52NdJkydxbHJTv0BS6T1VdM0ZNDZtO28KZ3nA4AKedmDaRk5D5GCqcNrcwZ2aFkYgABZFEo5dvfP07PZ8y8je/XVpaXVmUU3CWGeiJYI4Q5UynqjLSK2x9jyTrE/z88HxpbOM02DQLQnoM5xS2w4HGAGtKThpFxC0plHhW+SB6Fc+yHWy/4jUbYb5IW0TykMyh8CmtTZ94vmf+UYsNWxzUHRCvfjo0F1NcbsyLhrhViLSGaiSUjqdEYzDczO/RbMtOzXto7ge//8PhBKZcM/Kyj+pLgufkdv/5IWot1FI0KHxg73eCAj++y8f4prGJyk51Y1tJLQrzM3Fmj1x4nDa4aB0hOeQWvWDzdZTEK06ZaXzUeSmbO2gRqKDELaV86U/oWa6dFODA0GalNZkRBoNMFzl2qig6bUm8poRqJhSTiDIwreMM8PmkOZ3b9MbLh2mMUK4Zc9m6+i3Bs6WGxLO20r6bDW5rPGccn0RP8KoJye+jqXQrTuuazRR4Z2UdeuZlIN3rQLLbwbNZNR08uwtJXQ9iVwmu5LAzn94kULiOblLhROaWqGDT/+nCus3745RWfi+lUriiyM3eolGCQCPnL3qWqXOFNmiIwWl3c0RP0fyUBXfE55ByxX1Dv/F/E+3VptvZppqS7xC1ZbMvkwfwgZ1LBj/4YcQiGNv0PJsDt0Njp+522tAzLx12m5Xfo4OASTwONoDfGUAy/Rb2i8yV6GEWLPBgBpdIpa+e2Mwykml6lle8J5q6963sLzTVxpOENCYcFS2pVIenNSdket5Y23pRqTL8wUv3Nm4M57XtcY7pyE2wZPBEOzoYBpapvX9wMOQX3tMwlQV0Xp88fFtagy5tUph1tSE/Qhoi+4S/01glNgiZZlhMa/MrRHwRL6yZRjCx2ik1TC5RWLI+FXPeK2ZfK7SSQNDYfNFBsQgd0oBSZZF8DZk0ivgJEKLM8nh11ZMiRr7kgcH7wxuNDALE7N8Xs4U6RshsRUXv7nZ3N5Tozv8IKLMy/4ltxWXISnGhY3Yy/rWlAkP6d2JQKJ1CMYQceiszkyBzmRGQGIi+CGkpBDAt+S6RQjk4XyZbh/hKRcF1j4tClDxknotqKKmeLPYfBBT5F9IMMmkEDGkIOX7RnalAdXiyX1v2GOellGG3D66J7EY6O3XxTaLRzURdzoAN1i7wWbjq+YMfSiSE0f6Z7MBvvKgX/vnRNganT6csjt4pYBQMSaRSEgX5faZKDjdRWRK77rlYlrBqrFUvARROPt45jZiV6Goks0U+RHQ4RrmZTjSMU3ZCpOrJsZOzp7QK+RBV1Va8tPSRi6RQlYvvHtgc3a64WENMp0hgUOqEflP1kMzCnGlHt5Qr776FF8FQFiqK4jzqRNNRQDzaR2bLgh556Wib4cHGndU4rSAHGV4n+5TEvBb/P3FhJ5nfhMU6MrEodSSeBDaJgOxDJjAE0zJgHfhU3PH6l4x/xqIoY+mT6x5vZrMlclxCJZne0uYEmpOBIYBEHiyGyrrd7MgdNg87+0WfvtyKFCqDn7jghfceXiUKEifx6DD+nXxYsBWK5fBR4RG++yltNvYdaOIY5Jxe7fDJ1gpOqWQmO5l9ydQHzWK5lRRplDRlFGsICyAa/uiQqReZSJSOnD+XpWQzrxUzjOvsg6dQvxcf/iXjdSNmWMc8n4K6pipzzQx1ZkbZgRObIhNm04gai4CXGJfYVUnnvjRwvWUAAAwRSURBVC6LxTr55eUTH0gc+tFS9pMCVYf7F5ktXEd+DEX3Y3TwRXidNuyoqMOoYaeKrQftGiccOWubYPeJLQkQDDg0keiLJHRbyuQhxRycNDRnN70vG8nloOk9ixIbah30dHwdSPPicfzsMxf0xvqtG1rVV8g3EDCcjrHaGQA6yIfQ99T69nEk/+7nfzlk4EeWxEmB4tCbtrtv8c2qgtaF/MTTDAOUbKR8U98uWfhq134MOj0fNqvKgFDhimc49+MKTSBBEjDNwTC8LrvZnyz8owSEfstsr9QcViTTF8miFgnSPnhKK3n53hlrhMIxjJoaMU1VxMzyEs0NQiMzRUsbSFtMgMh0ESWm36+tmvzjBSRR9nn3LapRFIUWbLQ6Hgw+h6AeZb9BZql7+3R0yPKy9KhOcvCiVJmfot9NgTCSXGQtW5ZGi4yvoLsEKLNKM9kozZm5IRLf2z6kNSD1b48O2qxW+y1TgKDuN5cpJPgSroXIJQ2cWubxUFMErYFJdWdvmL54XKuI+0ejIYdTRDZpCbHF0KQd6FK+GP26ZMMf1LmaeGbPtvC6bKwpYma3UNlwJMbv0ztklmh7JipQkUZJk6abBSsybaRFxLIi1ImSwNZkPGJRlBecFz99W+KzHlgw2nhgVjpqGyvjb/NKMrN4TwlTgkEWt2Q3DsUhFLf8ZeUfWjv1H8gindDXxIExYhjd+Cwykl08287q2Rb+UARtM5LMrZZadikiwdo1Kxr9IQaAgKJonrSCtpRy2K0fw8DZ1KNM9JVYmMdB/khE1mLFrvgh30NmjRstLpt6yCR+9/E/GnPeK2vJjZnLvInuEiUWpksEj2KphsK1Elpfomn22jnLJ2VIAf2oNSQRxfbjF/eyqPjmPv90hPQoU9++nbPjs1ru2iCrfSQANdzg0TxpIw/4gn9y2oVjJ5AyrxR9UlXz7+LeAbddw/4GP2uNzSo2MouzMhKjYtwbDEanUIaXGJ3Dpi7KuGL6JfL56haMNkZPd3INJDEnIKkwAUMsi2rtRInpfWJh5Njp+/+6usUU/mQAkYNve8PTxr1J7+OM7m0QDEeRmUzpCOq9bakgOjSLX1UtNYFg8OpQ1LLebbfSKt1xeswYE4sZ19ms6iW9R758L91z2ysjDYfdem4sZswpqWroSlrktGt7DeC3p416ZeX66Tfs0SzqLq/HPkDEGKILxWW3Iu/XMxT/kvGG3ari3hm52Fu9rXXansMSsd2VxSIaIeSyOFlZpPQJpezf+EhMkp8cIPTQU0f90iAAenXMhNthPf2Mu177bN6EYadf8/iiT9+ZdIUeCEWslHgkU0aplaaAjqAeQWOgKT8QtOzWVMuspkD4i2v/+M5Ly5+8pqI5pLe57NE3lSVPXPGzjbv3X+awqBuSPPaFBrBvf31zTn1TGHk5KWckO60rVVWpiUWx8ManFt8jJ0nlG3dyn/Cd00z9MPuCBYEQxEFm0SlYpIhdZgB4rYxqx+sf/umnCwgJ4k+3/dIgClzYMQOb99ZwSZc0hWz+3X9ewYN7aezghzK8zidsVnScu2Jb7fzVm5v+ePP5rzz48upWW6RPHTXgQE6aJ3XjzqpnCztk9le12LXhcn/ViLmrg3Sf5+68sHdYj33dFAivapfhHmPTtI2NgTCIEKzbXI4eHdKR6XVi5eddzGZ0Qb9FJljsz0W5K0qXkHaJz0ScInWCCljvfv7q0TbRnJBPPikX//nuoqjPH7EU5KbsrqpvzpcbEyTuOkEOW7Ya0RwlCis2hqamBqrJUy+uFfXNIQTCtMe9uRRcpkxMpkRik9E/3Ydq+XQQcVj9RVdU1ZeisKMF9b58rnnIlbtigwWhHWIVb0tKXu6jIjdhIKDmr3v+pwvIs3dcuEW1WLq3y/Csd9m1szbvqWm1OCjOWhL2VhG82PzEzLxL00HvHlT9TaDRJlk1Vzbwmkda9hAD1nzZ2WwDIkJAfVqiyMWHudeLCESJgju4JiIWMon9uGS7kNh7hT77iR6z7im6ORwxZns92nnN/sgaMldyJwmx2DQhhEkQvhyu/Dy+zt6kqiz6eL3dPNvcQMGUMrcvkXaU73ehsqaAG6yJNVFqROz2kLDViAmKTKdw1E7ZX17JS/5FOHq5YdpPFhDTuUfHzPwg3lD8wuhBhmhQMBvdJCicg5dlhZYKYSI4UlPod2K1UOa4yBRGo2LTM1lV/ODTTixcah8VCUWxH77McpOwxXYdwmwRKHaqjeh+psEUn1CcIpcqu67IK/xJAzLr7oEjbpu+9JVEJZ91T9HtVlX9c5KLugdp6bJM8lEXTcsWUDr5F16HIv5EB5kZWcqVdIcCQe7xPahllQLLnWUZ2FWeziZKlnKZ3sr+ZvMmkmXJND7ltGwqrb8XXfWJTOyt9TN/uj6ERLhqyrXGBfcevsdp3dub44ZHd62AYt+PtDQ3fJWdAX/hCRvq3dvK8e67yxDlBjmxt1Z8lySOyMVCUdYNc10mg0PZZ6uTK4fkP6h62MiVRaXkrfUzO/xkNWTdgs3kNCw0K2nWBcPNPx947dkfS0l/9NGE92w266DkZFd8rxWxVIXW5Oto2DksDopMQh4bSgbemP0+anyVpgkSVPfgCmVLxVEumBUmk6J2osHCRFpB2pHIOY7tWf6DZ69b8O0oKMaM73qEsoalKDyNWnFEF4rYqODQeafrUdRtv/iERkIFqBemvwafvw6aVezlxXGGWfaViU7JssRyDZH+p0bthuYaBsPjTcWrS0WS8SelIYlm6LskWWd9BR06ZDAIFGu07q2idedi6wz63F/vhb/S7CU4Cmg2VRex/83NpWSl8MVr5oxFVV0ZAuEmM0XS4hd4UzfJ2uLbR7U4eFWxcm5r4Sct++b/JABZ9/bmAwBSj0JmSOu2BLt3C38hzJXY7ikxYKQgsm7XANiSKhGq63Q0t+Vz3lp7HrIyNezdG8bQYaILX9ME+yopduD9V8+PawgvUSB+LJGLr00Um6SRptCa9sZIAxaufSGOw48akLULv71IMYxlRy0xWjja4z1ec//hh9twxhmd4XKJbZ5IaERq6rYPPZbbtTp3e90g7N4ThtOh4NTTqIdDQTgcg91uQThMjSHmCiwAjY1R7PvyKqxZSRv8i9W8MhMsonfhzw5ex/6jBeRozNPhJFtZNROnDMhHc3MIK1ZsQlFRb+gNnRGq74ykjsvh29XizI8VmW11AxEIxKBpFvxzfgPuvS+TARHmUYhyf4UX3vR6lr5VU7Bq9j3YVbGzVdQuKbDhUO9bsOrPtPVS/PjRAbLu7U2tqoTHKrR3XxyPm6b8ErApaGgI4MsNfvTM/TXfRs2Zj5QUN2q3FQEG0dKjH37TU8PQfG8UJXt1tG2noaxMx8YvA7j+hlTWBperhTzEDONGX31ojWrV9oYCGt6eOdjcmIf7W8zYI3rYDf6P/omOVTLHeP66tzfTHuGdEy+rrC1BXeN+9Ox42lHf7f0Xx2PQyKeR2mUJNDvtyxXDt9+WI0cVe7douW8iKYk6MEWjQ8SfgcayIzeS74sN4fMbGqKgnmy324LmphhCYQMFBTaEQgacTrE/WNFFxXG5vv56nvHOzCvEd/FyBBGxKzEj/OYns0S/6Y9JQ8g0vb5iJjIy4lXMQ4R/4SlXfu/StcQL3n1hHIbc+gxnXS1ZbyEry8vXkmNvKDkTjuy1vLdwsPRXRw1yw97t+Fa/HRmZtLpLZZO1dWsQ2VlW7NgZRlaWFUlJFjidCpy0HwtaQHl/af5X86fc0EesqFI5ZiEfIuOO/zgg697edL8BhXYn4M1JKKh74c3J6Ny5MztjXpBpLoGQmxIQUyrqN/yoBLhs9n0o+r+n4ucGk/6KNm1SoWmyKVo402OJQ96+5QJYewFn3uNEY3MMDgf99TqFzZbXa8GWLSEGRdcN5OVpSEujTXViGDJ4T1xTrjz7jvpgIHCey+3ZSGP+rjXrP5jJWrtg89eKgsO20D8373F06NCBgXC7xQ5yBx9NDQH86rwbjwgKAfLY4iXxcd1//9BTzuv78MpkZ5L4sw/HeNCfQVp++0DQX2/M0zR0/60d+7pHkJ5B6XMDtI2LzxdFaanOTIvi0Yxs9brbbqmIdzkmfuUtRRONl5Z9959Q+n9w2XEL47637gAAAABJRU5ErkJggg=='), name=SQLQuerier
warn: Unknown task: undefined, using default task configuration name=SegmentAnnotatorServer
info: Got annotation for nyuv2.bedroom_0114, user jake name=SQLAnnotationDb
...
jb892 commented 4 years ago

After contact with the author Manolis, I found the MySQL setup script inside SSTK/scripts/db folder.