@rogermathew said in Error 3154 – Restore SQL database is terminating abnormally:

Hello Experts,

Our team is developing a module which takes data from SQL Sever database 2014 and shows the data on Magic Mirror screen. We are in trouble while accessing database, all data not show on the screen. The, we tried to restore SQL database and face SQL Error 3154. To fix this kind of error, we are tried T-SQL command but no result found. Then we try to use WITH REPLACE while using restore script.

RESTORE FILELISTONLY
FROM DISK = 'C:\company_file.bak'
GO
 
RESTORE DATABASE company_file
FROM DISK = 'C\:company_file.bak'
WITH MOVE 'company_file_Data' TO 'C:\Database\company_file.mdf',
MOVE 'companyfile_Log' TO 'C:\Database\companyfile.ldf',
REPLACE

After executing these commands we are still facing error. Then someone suggested me to use below resources, but we are confused which one is better.
Please provide full proof method.
https://forum.magicmirror.builders/topic/6803/magicmirror-to-mssql
https://www.essentialsql.com/error-3154-restore-sql-database/
https://www.stellarinfo.com/sql-recovery.php

I have no idea, but I have a suggestion :
Create a proxy service, so you donot have to access database directly but a distant service.
This last will access the database. You can use the platform you want especially .Net technology which is very easy to integrate with SQL Server.

@maukoell said in Music Player Module:

Hello,
I am trying to create a module which plays music from a directory. I wanted to use two buttons to control it. One for Pause/Play and one to skip the current song. But unfortunately when I start the MM2 I always get the message that it is not able to find the helper for my module. I’m new to node.js so maybe there are just some basic mistakes.

My module:

Module.register("MMM-MusicPlayer",{	
	defaults: {
		playButtonPIN: 10,
        	nextButtonPIN: 12,
        	clickDelay: 500,
        	musicPath = "/home/pi/MagicMirror/modules/MMM-MusicPlayer/music",		
	},	
	start: function() {
		this.sendSocketNotification("BUTTON_CONFIG", this.config);
		Log.info('Starting module: ' + this.name);
	}
});

My node_helper:

"use strict";

const NodeHelper = require("node_helper");
const gpio = require("onoff");
var path = require('path');
var fs = require('fs');
const { Howl, Howler } = require('howler');
var sound;
var musicList = [];
var index = 0;
var started;
var config;
module.exports = NodeHelper.create({
    start: function () {
        started = false;
    },
    // Subclass socketNotificationReceived received.
    socketNotificationReceived: function (notification, payload) {
        const self = this;
        if (notification === 'BUTTON_CONFIG' && started === false) {
            config = payload;
            self.fromDir(config.musicPath, "mp3");
            self.createSound();
            var GPIO = require('onoff').Gpio;
            var button1 = new GPIO(config.playButtonPIN, 'in', 'both', { persistentWatch: true, debounceTimeout: config.clickDelay });
            button1.watch(function (err, state) {
                // 1 == pressed, 0 == not pressed
                if (state === 1) {

                    if (sound.playing()) {
                        sound.pause();
                    } else {
                        sound.play();
                    }
                }
            });
            var button2 = new GPIO(config.playButtonPIN, 'in', 'both', { persistentWatch: true, debounceTimeout: config.clickDelay });
            button2.watch(function (err, state) {
                // 1 == pressed, 0 == not pressed
                if (state === 1) {
                    self.playNext();
                }
            });
                started = true;
        }
    },

    fromDir: function(startPath, filter) {
        if (!fs.existsSync(startPath)) {
            Log.info("no dir ", startPath);
            return;
        }
    
        var files = fs.readdirSync(startPath);
        var i;
        var fullPath;
        var filename;
        var stat;
        for (i = 0; i < files.length; i+=1) {
            fullPath = path.join(startPath, files[i]);
            filename = files[i];
            stat = fs.lstatSync(fullPath);
            if (stat.isFile()) {
                if (filename.indexOf(filter) >= 0) {
                    musicList.push(fullPath);
                }
            }
        }
    },

    playNext: function() {
        if (sound.playing()) {
            sound.stop();
        }
        index += 1;
        if (index === musicList.length()) {
            index = 0;
        }
        sound.play(index);
    },

    createSound: function() {
        sound = new Howl({
            src: musicList
        });
    }

}
);

Maybe someone can help me.
Thanks in advance

I don’t think that your code respects helpers as described in official documentarion,
Or we are not talking about the same helpers Pnr Status.TextNow