Posts made by Richard238

Richard238

pi@magicmirror:~/MagicMirror $ pm2 stop 0
[PM2] Applying action stopProcessId on app [0](ids: [ '0' ])
[PM2] [MagicMirror](0) ✓
┌────┬────────────────────┬──────────┬──────┬───────────┬──────────┬──────────┐
│ id │ name               │ mode     │ ↺    │ status    │ cpu      │ memory   │
├────┼────────────────────┼──────────┼──────┼───────────┼──────────┼──────────┤
│ 0  │ MagicMirror        │ fork     │ 0    │ stopped   │ 0%       │ 0b       │
└────┴────────────────────┴──────────┴──────┴───────────┴──────────┴──────────┘
pi@magicmirror:~/MagicMirror $ pm2 flush
[PM2] Flushing /home/pi/.pm2/pm2.log
[PM2] Flushing:
[PM2] /home/pi/.pm2/logs/MagicMirror-out.log
[PM2] /home/pi/.pm2/logs/MagicMirror-error.log
[PM2] Logs flushed
pi@magicmirror:~/MagicMirror $ pm2 start 0
[PM2] Applying action restartProcessId on app [0](ids: [ '0' ])
[PM2] [MagicMirror](0) ✓
[PM2] Process successfully started
┌────┬────────────────────┬──────────┬──────┬───────────┬──────────┬──────────┐
│ id │ name               │ mode     │ ↺    │ status    │ cpu      │ memory   │
├────┼────────────────────┼──────────┼──────┼───────────┼──────────┼──────────┤
│ 0  │ MagicMirror        │ fork     │ 0    │ online    │ 0%       │ 2.4mb    │
└────┴────────────────────┴──────────┴──────┴───────────┴──────────┴──────────┘



pi@magicmirror:~/MagicMirror $ pm2 logs --lines=50
[TAILING] Tailing last 50 lines for [all] processes (change the value with --lines option)
/home/pi/.pm2/pm2.log last 50 lines:
PM2        | 2022-01-06T14:24:56: PM2 log: App [MagicMirror:0] starting in -fork mode-
PM2        | 2022-01-06T14:24:56: PM2 log: App [MagicMirror:0] online

/home/pi/.pm2/logs/MagicMirror-out.log last 50 lines:
0|MagicMir | 
0|MagicMir | > magicmirror@2.18.0 start
0|MagicMir | > DISPLAY="${DISPLAY:=:0}" ./node_modules/.bin/electron js/electron.js
0|MagicMir | 

/home/pi/.pm2/logs/MagicMirror-error.log last 50 lines:
0|MagicMir | App threw an error during load
0|MagicMir | TypeError: Log.log is not a function
0|MagicMir |     at Object.<anonymous> (/home/pi/MagicMirror/js/app.js:20:5)
0|MagicMir |     at Module._compile (node:internal/modules/cjs/loader:1116:14)
0|MagicMir |     at Object.Module._extensions..js (node:internal/modules/cjs/loader:1169:10)
0|MagicMir |     at Module.load (node:internal/modules/cjs/loader:988:32)
0|MagicMir |     at Module._load (node:internal/modules/cjs/loader:829:12)
0|MagicMir |     at Function.c._load (node:electron/js2c/asar_bundle:5:13331)
0|MagicMir |     at Module.require (node:internal/modules/cjs/loader:1012:19)
0|MagicMir |     at require (node:internal/modules/cjs/helpers:94:18)
0|MagicMir |     at Object.<anonymous> (/home/pi/MagicMirror/js/electron.js:4:14)
0|MagicMir |     at Module._compile (node:internal/modules/cjs/loader:1116:14)
0|MagicMir | (node:12755) [DEP0025] DeprecationWarning: sys is deprecated. Use util instead.
0|MagicMir | (Use `electron --trace-deprecation ...` to show where the warning was created)
0|MagicMir | A JavaScript error occurred in the main process
0|MagicMir | Uncaught Exception:
0|MagicMir | TypeError: Log.log is not a function
0|MagicMir |     at Object.<anonymous> (/home/pi/MagicMirror/js/app.js:20:5)
0|MagicMir |     at Module._compile (node:internal/modules/cjs/loader:1116:14)
0|MagicMir |     at Object.Module._extensions..js (node:internal/modules/cjs/loader:1169:10)
0|MagicMir |     at Module.load (node:internal/modules/cjs/loader:988:32)
0|MagicMir |     at Module._load (node:internal/modules/cjs/loader:829:12)
0|MagicMir |     at Function.c._load (node:electron/js2c/asar_bundle:5:13331)
0|MagicMir |     at Module.require (node:internal/modules/cjs/loader:1012:19)
0|MagicMir |     at require (node:internal/modules/cjs/helpers:94:18)
0|MagicMir |     at Object.<anonymous> (/home/pi/MagicMirror/js/electron.js:4:14)
0|MagicMir |     at Module._compile (node:internal/modules/cjs/loader:1116:14)
0|MagicMir | [12789:0106/142502.942799:ERROR:viz_main_impl.cc(161)] Exiting GPU process due to errors during initialization
0|MagicMir | [12805:0106/142503.366582:ERROR:sandbox_linux.cc(376)] InitializeSandbox() called with multiple threads in process gpu-process.

Richard238

Still no MM though. Status says online, but it’s not launching MM.
I’ll reboot, because, why not…

pi@magicmirror:~/MagicMirror $ pm2 start MagicMirror
[PM2] Applying action restartProcessId on app [MagicMirror](ids: [ 0 ])
[PM2] [MagicMirror](0) ✓
[PM2] Process successfully started
┌────┬────────────────────┬──────────┬──────┬───────────┬──────────┬──────────┐
│ id │ name               │ mode     │ ↺    │ status    │ cpu      │ memory   │
├────┼────────────────────┼──────────┼──────┼───────────┼──────────┼──────────┤
│ 0  │ MagicMirror        │ fork     │ 0    │ online    │ 0%       │ 2.6mb    │
└────┴────────────────────┴──────────┴──────┴───────────┴──────────┴──────────┘
pi@magicmirror:~/MagicMirror $

Richard238

What are “dev dependencies” to the uninitiated?

Richard238

@mumblebaj

Looking better…

pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm i mysql --force
npm WARN using --force Recommended protections disabled.
npm WARN ERESOLVE overriding peer dependency
npm WARN While resolving: grunt-stylelint@0.17.0
npm WARN Found: stylelint@8.4.0
npm WARN node_modules/stylelint
npm WARN   dev stylelint@"^8.3.0" from the root project
npm WARN 
npm WARN Could not resolve dependency:
npm WARN peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm WARN node_modules/grunt-stylelint
npm WARN   dev grunt-stylelint@"latest" from the root project
npm WARN 
npm WARN Conflicting peer dependency: stylelint@14.2.0
npm WARN node_modules/stylelint
npm WARN   peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm WARN   node_modules/grunt-stylelint
npm WARN     dev grunt-stylelint@"latest" from the root project
npm WARN ERESOLVE overriding peer dependency
npm WARN While resolving: stylelint-config-standard@24.0.0
npm WARN Found: stylelint@8.4.0
npm WARN node_modules/stylelint
npm WARN   dev stylelint@"^8.3.0" from the root project
npm WARN 
npm WARN Could not resolve dependency:
npm WARN peer stylelint@"^14.0.0" from stylelint-config-standard@24.0.0
npm WARN node_modules/stylelint-config-standard
npm WARN   dev stylelint-config-standard@"latest" from the root project
npm WARN 
npm WARN Conflicting peer dependency: stylelint@14.2.0
npm WARN node_modules/stylelint
npm WARN   peer stylelint@"^14.0.0" from stylelint-config-standard@24.0.0
npm WARN   node_modules/stylelint-config-standard
npm WARN     dev stylelint-config-standard@"latest" from the root project
npm WARN ERESOLVE overriding peer dependency
npm WARN deprecated time-grunt@2.0.0: Deprecated because Grunt is practically unmaintained. Move on to something better. This package will continue to work with Grunt v1, but it will not receive any updates.
npm WARN deprecated har-validator@5.1.5: this library is no longer supported
npm WARN deprecated browserslist@2.11.3: Browserslist 2 could fail on reading Browserslist >3.0 config used in other tools.
npm WARN deprecated circular-json@0.3.3: CircularJSON is in maintenance only, flatted is its successor.
npm WARN deprecated uuid@3.4.0: Please upgrade  to version 7 or higher.  Older versions may use Math.random() in certain circumstances, which is known to be problematic.  See https://v8.dev/blog/math-random for details.
npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142

added 606 packages, and audited 1043 packages in 3m

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

29 vulnerabilities (1 low, 17 moderate, 11 high)

To address issues that do not require attention, run:
  npm audit fix

To address all issues (including breaking changes), run:
  npm audit fix --force

Run `npm audit` for details.
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

Richard238

@mumblebaj

pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm i mysql
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR! 
npm ERR! While resolving: mmm-mysqlquery@1.0.0
npm ERR! Found: stylelint@8.4.0
npm ERR! node_modules/stylelint
npm ERR!   dev stylelint@"^8.3.0" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm ERR! node_modules/grunt-stylelint
npm ERR!   dev grunt-stylelint@"latest" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR! See /home/pi/.npm/eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/pi/.npm/_logs/2022-01-06T14_02_53_804Z-debug-0.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

Richard238

@mumblebaj

Install mysql - how and where?

Apologies for the detail request, but having got this far, I don’t want to break anything else.

Thank you.

Richard238

@mumblebaj

did you do the uninstall in the MagicMirror folder first?
Yes, I did.

pi@magicmirror:~ $ sudo rm package-lock.json
pi@magicmirror:~ $ cd ~/MagicMirror
pi@magicmirror:~/MagicMirror $ cd modules/MMM-MysqlQuery
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm install
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR! 
npm ERR! While resolving: mmm-mysqlquery@1.0.0
npm ERR! Found: stylelint@8.4.0
npm ERR! node_modules/stylelint
npm ERR!   dev stylelint@"^8.3.0" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm ERR! node_modules/grunt-stylelint
npm ERR!   dev grunt-stylelint@"latest" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR! See /home/pi/.npm/eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/pi/.npm/_logs/2022-01-06T13_37_32_112Z-debug-0.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

Richard238

@richard238

And step two:

pi@magicmirror:~/MagicMirror $ npm uninstall mysql

up to date, audited 758 packages in 10s

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

found 0 vulnerabilities

pi@magicmirror:~/MagicMirror $ cd modules/MMM-MysqlQuery
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm install
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR! 
npm ERR! While resolving: mmm-mysqlquery@1.0.0
npm ERR! Found: stylelint@8.4.0
npm ERR! node_modules/stylelint
npm ERR!   dev stylelint@"^8.3.0" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm ERR! node_modules/grunt-stylelint
npm ERR!   dev grunt-stylelint@"latest" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR! See /home/pi/.npm/eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/pi/.npm/_logs/2022-01-06T12_51_27_088Z-debug-0.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

Richard238

@mumblebaj

Ok, step one completed and looking much more up-to-date:

pi@magicmirror:~ $ npm -v
8.3.0
pi@magicmirror:~ $ node -v
v17.3.0

Richard238

@mumblebaj

Great ok, thank you.

What’s the best way to do those two updates, please?