Package Details: shinobi-git r2038.04a7bae-2

Git Clone URL: https://aur.archlinux.org/shinobi-git.git (read-only, click to copy)
Package Base: shinobi-git
Description: The Open Source CCTV and NVR Solution
Upstream URL: https://shinobi.video/
Keywords: ai camera detection monitor recognition record security surveillance video
Licenses: custom
Provides: shinobi
Submitter: AlphaJack
Maintainer: AlphaJack
Last Packager: AlphaJack
Votes: 2
Popularity: 1.05
First Submitted: 2021-06-14 19:31
Last Updated: 2021-09-20 20:32

Latest Comments

graysky commented on 2021-09-21 15:07

Installing this package from the latest commit on a fresh VM is giving errors relating to database access:

ep 21 11:03:55 shinobi node[529]: insert into `Logs` (`info`, `ke`, `mid`) values ('{\"type\":\"Shinobi is ready.\",\"msg\":\"\"}',>
Sep 21 11:03:55 shinobi node[529]: knexError----------------------------------- END
Sep 21 11:03:55 shinobi node[529]: knexError----------------------------------- START
Sep 21 11:03:55 shinobi node[529]: Error: ER_DBACCESS_DENIED_ERROR: Access denied for user ''@'shinobi' to database 'ccio'
Sep 21 11:03:55 shinobi node[529]:     at Handshake.Sequence._packetToError (/usr/share/shinobi/node_modules/mysql/lib/protocol/sequ>
Sep 21 11:03:55 shinobi node[529]:     at Handshake.ErrorPacket (/usr/share/shinobi/node_modules/mysql/lib/protocol/sequences/Handsh>
Sep 21 11:03:55 shinobi node[529]:     at Protocol._parsePacket (/usr/share/shinobi/node_modules/mysql/lib/protocol/Protocol.js:291:>
Sep 21 11:03:55 shinobi node[529]:     at Parser._parsePacket (/usr/share/shinobi/node_modules/mysql/lib/protocol/Parser.js:433:10)
Sep 21 11:03:55 shinobi node[529]:     at Parser.write (/usr/share/shinobi/node_modules/mysql/lib/protocol/Parser.js:43:10)
Sep 21 11:03:55 shinobi node[529]:     at Protocol.write (/usr/share/shinobi/node_modules/mysql/lib/protocol/Protocol.js:38:16)
Sep 21 11:03:55 shinobi node[529]:     at Socket.<anonymous> (/usr/share/shinobi/node_modules/mysql/lib/Connection.js:88:28)
Sep 21 11:03:55 shinobi node[529]:     at Socket.<anonymous> (/usr/share/shinobi/node_modules/mysql/lib/Connection.js:526:10)
Sep 21 11:03:55 shinobi node[529]:     at Socket.emit (node:events:394:28)
Sep 21 11:03:55 shinobi node[529]:     at addChunk (node:internal/streams/readable:315:12)
Sep 21 11:03:55 shinobi node[529]:     at readableAddChunk (node:internal/streams/readable:289:9)
Sep 21 11:03:55 shinobi node[529]:     at Socket.Readable.push (node:internal/streams/readable:228:10)
Sep 21 11:03:55 shinobi node[529]:     at TCP.onStreamRead (node:internal/stream_base_commons:199:23)
Sep 21 11:03:55 shinobi node[529]:     --------------------
Sep 21 11:03:55 shinobi node[529]:     at Protocol._enqueue (/usr/share/shinobi/node_modules/mysql/lib/protocol/Protocol.js:144:48)
Sep 21 11:03:55 shinobi node[529]:     at Protocol.handshake (/usr/share/shinobi/node_modules/mysql/lib/protocol/Protocol.js:51:23)
Sep 21 11:03:55 shinobi node[529]:     at Connection.connect (/usr/share/shinobi/node_modules/mysql/lib/Connection.js:116:18)
Sep 21 11:03:55 shinobi node[529]:     at /usr/share/shinobi/node_modules/knex/lib/dialects/mysql/index.js:68:18
Sep 21 11:03:55 shinobi node[529]:     at new Promise (<anonymous>)
Sep 21 11:03:55 shinobi node[529]:     at Client_MySQL.acquireRawConnection (/usr/share/shinobi/node_modules/knex/lib/dialects/mysql>
Sep 21 11:03:55 shinobi node[529]:     at create (/usr/share/shinobi/node_modules/knex/lib/client.js:290:39)
Sep 21 11:03:55 shinobi node[529]:     at processTicksAndRejections (node:internal/process/task_queues:96:5) {
Sep 21 11:03:55 shinobi node[529]:   code: 'ER_DBACCESS_DENIED_ERROR',
Sep 21 11:03:55 shinobi node[529]:   errno: 1044,
Sep 21 11:03:55 shinobi node[529]:   sqlMessage: "Access denied for user ''@'shinobi' to database 'ccio'",
Sep 21 11:03:55 shinobi node[529]:   sqlState: '42000',
Sep 21 11:03:55 shinobi node[529]:   fatal: true
Sep 21 11:03:55 shinobi node[529]: }

I followed the procedure I type on the wiki page. Thoughts?

AlphaJack commented on 2021-09-20 20:33

Fixed, thank you

graysky commented on 2021-09-20 19:25

Line 47 is bad

AlphaJack commented on 2021-09-20 18:34

Because it hardcodes the database name to "ccio".
Now one can run sudo mysql ccio < /usr/share/shinobi/sql/framework.sql to get the same result or change "ccio" with "shinobi-db" or anything that he wants.

Also I'm not a fan of user.sql, which is made of three commands that one can run himself choosing its username, host, password and database name:

create user 'UUUUUU'@'HHHHHH' identified by 'PPPPPP';
grant all on 'DDDDDD' to 'UUUUUU'@'HHHHHH' identified by "PPPPPP" with grant option;
flush privileges;

graysky commented on 2021-09-20 16:41

@AlphaJack - Wondering why you modify the database.sql here: https://aur.archlinux.org/cgit/aur.git/tree/PKGBUILD?h=shinobi-git#n40

graysky commented on 2021-09-19 20:45

I created https://wiki.archlinux.org/title/Shinobi just now. Feel free to contribute.

lmartinez-mirror commented on 2021-06-14 20:03

This package needs git in its makedepends.