• Cat package.json

pi@pi_mirror:~/MagicMirror $ cat package.json
{
  "name": "magicmirror",
  "version": "2.11.0-develop",
  "description": "The open source modular smart mirror platform.",
  "main": "js/electron.js",
  "scripts": {
    "start": "./run-start.sh",
    "install": "cd vendor && npm install",
    "install-fonts": "cd fonts && npm install",
    "postinstall": "sh untrack-css.sh && sh installers/postinstall/postinstall.sh && npm run install-fonts",
    "test": "NODE_ENV=test ./node_modules/mocha/bin/mocha tests --recursive",
    "test:unit": "NODE_ENV=test ./node_modules/mocha/bin/mocha tests/unit --recursive",
    "test:e2e": "NODE_ENV=test ./node_modules/mocha/bin/mocha tests/e2e --recursive",
    "config:check": "node tests/configs/check_config.js",
    "lint": "grunt"
  },
  "repository": {
    "type": "git",
    "url": "git+https://github.com/MichMich/MagicMirror.git"
  },
  "keywords": [
    "magic mirror",
    "smart mirror",
    "mirror UI",
    "modular"
  ],
  "author": "Michael Teeuw",
  "contributors": [
    "https://github.com/MichMich/MagicMirror/graphs/contributors"
  ],
  "license": "MIT",
  "bugs": {
    "url": "https://github.com/MichMich/MagicMirror/issues"
  },
  "homepage": "https://magicmirror.builders",
  "devDependencies": {
    "chai": "^4.1.2",
    "chai-as-promised": "^7.1.1",
    "current-week-number": "^1.0.7",
    "danger": "^3.1.3",
    "grunt": "latest",
    "grunt-eslint": "latest",
    "grunt-jsonlint": "latest",
    "grunt-markdownlint": "latest",
    "grunt-stylelint": "latest",
    "grunt-yamllint": "latest",
    "http-auth": "^3.2.3",
    "jsdom": "^11.6.2",
    "jshint": "^2.10.2",
    "mocha": "^7.0.0",
    "mocha-each": "^1.1.0",
    "mocha-logger": "^1.0.6",
    "spectron": "^8.0.0",
    "stylelint": "latest",
    "stylelint-config-standard": "latest",
    "time-grunt": "latest"
  },
  "optionalDependencies": {
    "electron": "^6.1.7"
  },
  "dependencies": {
    "colors": "^1.1.2",
    "console-stamp": "^0.2.9",
    "express": "^4.16.2",
    "express-ipfilter": "^1.0.1",
    "feedme": "latest",
    "helmet": "^3.21.2",
    "iconv-lite": "latest",
    "lodash": "^4.17.15",
    "module-alias": "^2.2.2",
    "moment": "latest",
    "request": "^2.88.0",
    "rrule": "^2.6.2",
    "rrule-alt": "^2.2.8",
    "simple-git": "^1.85.0",
    "socket.io": "^2.1.1",
    "valid-url": "latest"
  },
  "_moduleAliases": {
    "node_helper": "js/node_helper.js"
  }
}
pi@pi_mirror:~/MagicMirror $ 

• GIT Status:

pi@pi_mirror:~/MagicMirror $ git status
On branch develop
Your branch is behind 'origin/develop' by 17 commits, and can be fast-forwarded.
  (use "git pull" to update your local branch)
Changes not staged for commit:
  (use "git add <file>..." to update what will be committed)
  (use "git checkout -- <file>..." to discard changes in working directory)

	modified:   css/main.css

Untracked files:
  (use "git add <file>..." to include in what will be committed)

	InstallGuideURL.txt
	MMM-EventHorizon/
	READ_ME.txt
	core
	css/customOLD.css
	modules/default/calendar/calendar1.js
	modules/default/compliments/compliments.js.ORIG
	modules/default/compliments/compliments.json
	modules/default/compliments/compliments2.js

no changes added to commit (use "git add" and/or "git commit -a")

• Node Version:

pi@pi_mirror:~/MagicMirror $ node -v
v6.9.5

• NPM Version:

pi@pi_mirror:~/MagicMirror $ npm -v
3.10.10

@karsten13 said in After update, chrome-sandbox needs root and mode 4655?:

So are you using the develop-branch or have you edited package.json und upgraded electron?

Neither that I am aware of.
All I did was apply a batch of commits.

Noticed earlier that my MM had crashed for whatever reason - it’s not been touched changed in weeks.

On reboot, it wanted 44 updates.
pm2 start mm then showed nothing, with the logs giving an error:

0|mm       | [10532:0127/132321.643138:FATAL:setuid_sandbox_host.cc(157)] The SUID sandbox helper binary was found, but is not configured correctly. Rather than run without sandboxing I'm aborting now. You need to make sure that /home/pi/MagicMirror/node_modules/electron/dist/chrome-sandbox is owned by root and has mode 4755.

I did

sudo chown root /home/pi/MagicMirror/node_modules/electron/dist/chrome-sandbox
sudo chmod 4755 /home/pi/MagicMirror/node_modules/electron/dist/chrome-sandbox

This seems to have fixed it, with MM now starting correctly.

What’s caused this, and is the chown/chmod the correct thing todo?

The vertical bar is only shown on Firefox or Edge, Chrome is OK, as is Electron on the Pi itself.

#flightsabove {overflow:hidden;}

Tried, but the vertical scroll bar is still there.

@broberg

This…

.MMM-FlightsAbove .tabulator-footer {
	visibility: hidden;
}

…works just fine, thank you.

.MMM-FlightsAbove {
	width: 400px;
	overflow: hidden;
}

Worked when I added a width figure, the horizontal scroll bar is gone.
The vertical scroll bar however, remains.
I tired some height: nnnpx; figures, but still the pesky vertical bar is showing.

I’ve set Max Entries to 10, but I get loads of entries, why? Seems OK after a PM2 stop/start!
How do I get rid of the scroll bars?
How do I lose the footer/key? (I tried footerLegend: false in MMM-tabulator.js)

My config.js:

		{
			module: 'MMM-FlightsAbove',
			header: 'Flights Above',
			position: 'top_center',
			config: {
				header: "Flights Above",          // The module header text, if any. Use: "" to remove.
				compassHeading: true,             // Use a compass direction (NSWE) for the of heading indicator ("45" vs "NE")
				updateInterval: 180,              // [s] Radar scan/ping/update period in secodns [default 3 min]
				maxItems: 10,                     // MAX Number of planes to display [default is 10]
				homeIata: "LGW",
				// The geographical (map) Boundary-Box (BB), from within planes will be shown are given by:
				// the maximim Lat/Lon edges of: [N-lat, W-lon, S-lat, E-lon] - all in decimal degrees.
				radarBBox: [51.34985,-0.49832,50.95459,0.13182], // "DPS" (Bali Airport) [default]
				//radarLocation: "51.10741,-0.15029",     // [Lat,Lon] - The location of radar center in decimal degrees
				//radarRadius: 90,                // [km] - The maximum distance of planes shown.
				//watchList: "",                  // Alert or Highlight planes/flights/types on this watch list
			}
		}, 

I’m not worried about the compliments module being in the way just now.

There’s an API here: https://ukvehicledata.co.uk/Fuel-Prices for UK fuel prices.
It’d be useful to someone I’m sure, rather like MMM-Fuel

Just a thought, if anyone were interested! :)

I have the MMM-MysqlQuery module working OK, just a couple of queries:

How might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

(As posted in the CSS area, but no replies there.)

I’m looking at the border-bottom in the ‘Lower third’ region.
Currently, the line below the heading, when enabled, crosses the entire display.

The CSS attributeborder-bottom-width changes not the width, but the height of the line, not what I want.

How then, do I get border-bottom in lower-third, to be just the width of what it’s showing, and not the entire width of the display?

Thank you.

@Richard238 said in MMM-MysqlQuery module just released!:

I have this module working quite well, just a couple of queries:

How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.

And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

How do you get the title “______________MYSQL SPICES” line displayed?
Fixed that one in config.js with header: 'Module Title',

Other enhancements still need attention, if anyone can help, please?

I’m looking at the border-bottom in the ‘Lower third’ region.
Currently, the line below the heading, when enabled, crosses the entire display.

The CSS attributeborder-bottom-width changes not the width, but the height of the line, not what I want.

How then, do I get border-bottom in lower-third, to be just the width of what it’s showing, and not the entire width of the display?

Thank you.

I have this module working quite well, just a couple of queries:

How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.

And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

Had to add a line:

position: 'bottom_right'

Now to make the SQL work with the Mysqli db I have running on an adjacent pi.

My currentweather module isn’t showing its location.

Module.register("currentweather",{

	// Default module config.
	defaults: {
		location: false,
		locationID: 1234567,
		appid: "", 
		units: config.units,

		{
			module: 'currentweather',
			position: 'top_right',
			config: {
				location: 'AnyTown,GB',
				locationID: '1234567',  //ID from http://www.openweathermap.org
				appid: '############'
			}
		},

How do I get the location back on the current weather, please?

Doesn’t help much, but mine is still OK.

Hi Joe,

I just ran the updates, which cleared the “undefined” message.
No code was changed.

Richard.

I think this update has fixed it.

currentweather shows “undefined”, whereas weatherforecast shows “My Town”.

Any ideas why, please?

		{
			module: 'currentweather',
			position: 'top_right',
			config: {
				location: 'My Town',
				locationID: '',  //ID from http://www.openweathermap.org
				appid: 'a################'
			}
		},


		{
			module: 'weatherforecast',
			position: 'top_right',
			header: 'Weather Forecast',
			config: {
				location: 'My Town',
				locationID: '',  //ID from http://www.openweathermap.org
				appid: 'a#############'
			}
		},