Knowledgebase

Installation

Follow these steps to install Magoware  Management System

  1. Install NODE JS

    Make sure you install the latest version of nodejs
    Recommended : versions 7.x.x or 8.x.x of nodejs

  2. Download MAGOWARE Backoffice application from Github

    https://github.com/MAGOWARE/backoffice-administration.git

  3. Run the following command within the root folder of Magoware to install application libriaries:

    a) sudo npm install (in linux)
    a ) npm install (in windows)

    b) sudo npm install stripe (in linux)
    b) npm install stripe (in windows)

  4.  

    Make sure it is installed the latest version of npm

  5. Make sure you have MySQL installed on your server

    Create a database on MySQL server for Magoware management system to connect.

  6. After all libraries are installed, run the following command to start the server:

    sudo node server.js (in linux)
    node server.js (in windows)

    In order to run the web-server   it’s necessary to connect to your database
    Database information required
    database name (Created on Step 4)
    database host
    database username
    database password

    Make sure that the collation and charset of your schema supports the languages that you intend to use.

    For the moment the service is operational only in MYSQL database

  7. Login to start creating accounts and assets

    go to: http://YourDomain_or_IP/admin and login with username admin and password admin

INSTALLATION FEE

You can ask for our support to install the middleware for you. The installation fee is 130 $ and will be returned in case of purchasing the products.

Click the link below to continue with the payment and please send us your contact information to support@magoware.tv

paypal.me/MAGOWARE

116 responses to “Installation”

  1. paul says:

    …hi I was installing on linux Fedora 25 and found there were numerous references to dateformat and dateFormat int the js code … this caused crash exceptions till dateFormat ref was modified to dateformat.

    • Iris Staro says:

      Hello!
      Thank you for your interest in our middleware and for reporting this issue.
      In a few days a new version will be released and this is among the issues that will be fixed in the new version. For further information you can contact us on our e-mail address info@magoware.tv
      Have a nice day!

  2. I will be testing this MW, can you please tell me which Distribution is better?? under linux?

    • Iris Staro says:

      Hello!
      Thank you for your interest in our middleware platform.
      The developement and testing of the middleware is done mostly in Debian GNU/Linux 8 , so we recommend this distributor.
      For further information or assistance please contact us on our e-mail address info@magoware.tv
      Have a nice day!

  3. Eric says:

    Try several times to install on Windows 10 and Debian 8 but not successful.
    Any step by step to follow installation?
    Thanks

  4. hidri says:

    Hello,

    I am interested in your solution and I want to test
    I like to know how to install it
    there is no detailed installation procedure with step by step
    Thanks

  5. Eduardo Muniz says:

    Hi, does your solution work with multicast or unicast only?

  6. Isaac Kabi says:

    Hello
    II am very interested in this technology
    But I wasn’t able to run some test on this
    Is the a step by step install documentation. I a have been strugging with this
    for days now. I really need help configuring this and

  7. ali says:

    hello, i have already installed the midleware, but when i run “node server.js” command, i got database connection error, the error is about tables does not exist in database.
    database structures not automatically created
    output error example :
    SequelizeDatabaseError: ER_NO_SUCH_TABLE: Table ‘ magoware.epg_data’ doesn’t exist

    • Iris Staro says:

      Hello Ali!

      Thank you for contacting Magoware!
      This error is shown when the system is not connected correctly to the database. Please make sure you have installed the latest version of nodejs (recommended versions 7.x.x or 8.x.x).
      Try to delete the “config” file and copy again this folder on the server , and run again sudo node server.js

      For any question or assistance needed you can contact us on our support address : support@magoware.tv

      Regards
      Team Magoware!

  8. Tex says:

    having issues with the installation and I already emailed .

    I download the file using wget or git ?

    • Iris Staro says:

      Hello Ted!
      Thank you for contacting Magoware!
      After downloading the Magoware files on your server , install nodejs (version 7.x.x or 8.x.x) and npm files within the rooted folder of magoware.
      Create a database on MySQL to connect to Magoware and run sudo node server.js to start the web-server
      For any further question or assistance needed don’t hesitate to contact us
      E-mail : support@magoware.tv
      Skype : MAGOWARE IPTV

      Regards
      Magoware Team

  9. Masi Saffi says:

    What is the root folder? I cant find it on windows? plz help

  10. Alex says:

    node 8.x.x is recommended
    but while installation there are warning that used packages are deprecated and not maintained (((((

    npm WARN deprecated nodemailer@2.7.2: All versions below 4.0.1 of Nodemailer are deprecated. See https://nodemailer.com/status/
    npm WARN deprecated swig@1.4.2: This package is no longer maintained
    npm WARN deprecated mailcomposer@4.0.1: This project is unmaintained
    npm WARN deprecated socks@1.1.9: If using 2.x branch, please upgrade to at least 2.1.6 to avoid a serious bug with socket data flow and an import issue introduced in 2.1.0
    npm WARN deprecated buildmail@4.0.1: This project is unmaintained
    npm WARN deprecated gulp-util@3.0.8: gulp-util is deprecated – replace it, following the guidelines at https://medium.com/gulpjs/gulp-util-ca3b1f9f9ac5
    npm WARN deprecated graceful-fs@3.0.11: please upgrade to graceful-fs 4 for compatibility with current and future versions of Node.js
    npm WARN deprecated minimatch@2.0.10: Please update to minimatch 3.0.2 or higher to avoid a RegExp DoS issue
    npm WARN deprecated minimatch@0.2.14: Please update to minimatch 3.0.2 or higher to avoid a RegExp DoS issue
    npm WARN deprecated graceful-fs@1.2.3: please upgrade to graceful-fs 4 for compatibility with current and future versions of Node.js

    • Iris Staro says:

      Hello Alex!
      Thank you for contacting Magoware!

      This warnings appears when installing npm, and it is not a problem. What is important is to install npm within the rooted folder of Magoware
      For any further assistance you can contact us at support@magoware.tv

      Regards
      Magoware Team

  11. Jonathan says:

    Buenas tardes
    luego de realizar la instalacion, al ejecutar nodeserver.js
    genera error de conexion a la base de datos

    MAGOWARE – Development Environment
    Environment: development
    Port: 80
    Database: iptv
    App version: 1.12.007 db.010
    App URL: localhost:80
    2018-04-24T22:16:13.040Z – error: Error connecting to database

    cual puede ser el problema ??

  12. Edik says:

    Hello
    Can i Install in Ubuntu

    • Iris Staro says:

      Hello Edik!
      Thank you for contacting Magoware!
      Yes , you can install on Ubuntu server , it’s the server we recommend most for the backoffice

      Regards
      Magoware Team

  13. danny says:

    C:\Users\danny\Desktop\backoffice-administration-master>node server.js
    sync = true
    force = undefined
    ————————————-Starting server—————————-
    ————————
    2018-06-06T12:01:17.158Z – info: Initializing Sequelize…
    2018-06-06T12:01:17.766Z – info: Finished Connecting to Database
    2018-06-06T12:01:17.766Z – info: Initializing Stack…
    2018-06-06T12:01:17.766Z – info: Initializing LocalVariables…
    2018-06-06T12:01:17.766Z – info: Initializing Middleware…
    2018-06-06T12:01:17.797Z – info: Initializing ViewEngine…
    2018-06-06T12:01:17.797Z – info: Initializing Session…
    2018-06-06T12:01:17.797Z – info: Initializing Modules Configuration…
    2018-06-06T12:01:17.797Z – info: Initializing Helmet Headers…
    2018-06-06T12:01:17.797Z – info: Initializing Modules Client Routes…
    2018-06-06T12:01:17.797Z – info: Initializing Modules Server Policies…
    2018-06-06T12:01:17.922Z – info: Initializing Modules Server Routes…
    2018-06-06T12:01:18.453Z – info: Initializing Languages …
    2018-06-06T12:01:18.453Z – info: Initializing Error Routes…
    2018-06-06T12:01:18.453Z – info: Initializing Socket.io…
    Running HTTP server
    ————————–
    MAGOWARE – Development Environment
    Environment: development
    Port: 8081
    Database: iptv
    App version: 1.12.6 db.009
    App URL: localhost:8081
    module.js:674
    throw err;
    ^

    SyntaxError: C:\Users\danny\Desktop\backoffice-administration-master\config\lang
    uages\._en.json: Unexpected token

    hi please can you help me with this error I cant access the url after running node server.js

    • Iris Staro says:

      Hello Danny!
      Thank you for contacting Magoware!

      Please check on the following folder:/config/lib/express.js the following parameter if it’s declared this way :
      const language_folder_path = ‘./config/languages/’;

      If not, please modify it as above , and try again to run the server

      Regards
      Magoware Team

  14. Jason says:

    I keep getting the following error:

    const language_folder_path = ‘./config/languages/’;
    ^^^^^
    SyntaxError: Use of const in strict mode.
    at Module._compile (module.js:439:25)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Module.require (module.js:364:17)
    at require (module.js:380:17)
    at Object. (/home/cuppakar/lurnto.com/config/lib/app.js:7:13)
    at Module._compile (module.js:456:26)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)

    ======

    just wondering how I can overcome this?

  15. kiruban says:

    Hello what is the price of this product? or is it free?

    • Iris Staro says:

      Hello Kiruban!
      The management system is open source and can be downloaded from GitHUB. You can use the applications under Magoware brand on no charge. For customization we offer different packages, if you are interested please contact us at info@magoware.tv

      Regards
      Magoware Team

  16. Donald Judge says:

    Could you tell me I have set my node server up correctly and why do I have the files after it says the server is running?

    C:\Users\Owner\Documents\GitHub\backoffice-administration>node server.js
    sync = false
    force = undefined
    ————————————-Starting server—————————————————-
    2018-07-12T00:11:12.035Z – info: Initializing Sequelize…
    2018-07-12T00:11:18.763Z – info: Finished Connecting to Database
    2018-07-12T00:11:18.763Z – info: Initializing Stack…
    2018-07-12T00:11:18.763Z – info: Initializing LocalVariables…
    2018-07-12T00:11:18.763Z – info: Initializing Middleware…
    2018-07-12T00:11:18.763Z – info: Initializing ViewEngine…
    2018-07-12T00:11:18.763Z – info: Initializing Session…
    2018-07-12T00:11:18.779Z – info: Initializing Modules Configuration…
    2018-07-12T00:11:18.847Z – info: Initializing Helmet Headers…
    2018-07-12T00:11:18.847Z – info: Initializing Modules Client Routes…
    2018-07-12T00:11:18.847Z – info: Initializing Modules Server Policies…
    2018-07-12T00:11:20.489Z – info: Initializing Modules Server Routes…
    2018-07-12T00:11:26.675Z – info: Initializing Languages …
    2018-07-12T00:11:26.675Z – info: Initializing Error Routes…
    2018-07-12T00:11:26.675Z – info: Initializing Socket.io…
    Running HTTP server
    ————————–
    MAGOWARE – Development Environment
    Environment: development
    Port: 88
    Database: mysql
    App version: 1.12.007 db.010
    App URL: localhost:88
    2018-07-12T00:11:33.228Z – verbose: Executing (default): SELECT 1+1 AS result
    2018-07-12T00:11:33.228Z – verbose: Executing (default): SELECT `id`, `locale`, `log_event_interval`, `mobile_background_url`, `mobile_logo_url`, `box_logo_url`, `box_background_url`, `vod_background_url`, `assets_url`, `ip_service_url`, `ip_service_key`, `firebase_key`, `help_page`, `vod_subset_nr`, `activity_timeout`, `channel_log_time`, `email_address`, `email_username`, `email_password`, `analytics_id`, `old_encryption_key`, `new_encryption_key`, `key_transition`, `company_url`, `vodlastchange`, `livetvlastchange`, `menulastchange`, `googlegcmapi`, `applekeyid`, `appleteamid`, `applecertificate`, `akamai_token_key`, `flussonic_token_key`, `createdAt`, `updatedAt` FROM `settings` AS `settings` LIMIT 1;
    2018-07-12T00:11:33.329Z – verbose: Executing (default): SELECT `epg_data`.`id`, `epg_data`.`channel_number`, `epg_data`.`program_start`, `program_schedules`.`id` AS `program_schedules.id`, `program_schedules`.`login_id` AS `program_schedules.login_id`, `program_schedules`.`program_id` AS `program_schedules.program_id` FROM `epg_data` AS `epg_data` INNER JOIN `program_schedule` AS `program_schedules` ON `epg_data`.`id` = `program_schedules`.`program_id` WHERE `epg_data`.`program_start` >= ‘2018-07-12 00:16:33’;

    • Iris Staro says:

      Hello Donald!
      Thank you for contacting Magoware. Based on the logs you have sent looks like the installation is correct and the management system is running. If you have any specific problem please contact us at support@magoware.tv

      Regards
      Magoware Team

    • Jason says:

      Were you able to get it running? If so who do you use for your server ?

      • Iris Staro says:

        Hello Jason!
        Thank you for contacting Magoware!
        Could you please tell us which is the problem you are having on the installation ? If you need assistance please contact us at support@magoware.tv

        Regards
        Magoware Team

        • Iris Staro says:

          Hello Jason!
          Thank you for contacting Magoware!
          Please make sure the database credentials are correct (you can check it on the file db.connection.js)
          Also make sure that it is possible to connect to the database with those credentials.
          If you still continue to have the same issue please contact us at support@magoware.tv

          Regards
          Magoware Team

  17. Rony says:

    Hi team,
    It will be really appreciated if you got step by step guide to install your software and configure it on Debain or Ubuntu Disrto.

    It will really make things easier as you can see from previous posts we all having same issue, as installation procedure not clear at all.

    RG
    Rony

  18. Reza says:

    Hi, Can I use node js version 9 or 10?
    Please advice.
    Thanks

    • Iris Staro says:

      Hello Reza!
      Thank you for contacting Magoware!
      We mostly recommend use node version 8.x.x because it is most stable and the features are supported

      Regards
      Magoware Team!

  19. Jhon says:

    Buen día
    mi problema es que no lo puedo abrir
    ya lo instale y no lo he podido visualizar

  20. Hernani says:

    Hi
    There is a docker image to install the backoffice?

    • Iris Staro says:

      Hello Hernani!
      Thank you for contacting Magoware!

      The installation steps are described on this article and also on the github repository where you can download the source code. If you need help with the installation please contact us at support@magoware.tv , we will be glad to assist

      Regards
      Magoware Team

  21. Terence says:

    Dear Sir,
    I have finished the installation. How can I test my server? I installed your “MAGOWARE IPTV” APK from playstore. But I can only use the default server address to login as “guest/guest”. If I put my server IP address of “10.0.0.33”, the App alway tell an error.

  22. Loai Zahra says:

    Dears,
    I have installed backoffice Mangoware, and loged in as admin,
    I can not open Categories/genre or even create a channel
    and when trying:
    http://localhost:8011/api/Genres?_end=30&_orderBy=id&_orderDir=DESC&_start=0
    I get: { “message”: “User is not allowed” }
    I gave the user all permissions and still same problem.
    I am using the last version of magoware
    please help me

  23. Santiago says:

    Thank you Magoware for this open source OTT. I have installed and gone over all of the components (npm, MySQL, NodeJS, etc..). The website is coming up but when I try to logon as: username=admin, password=admin; the portal does not proceed to display menus.
    Can you please provide any assistance as to what exactly is missing with my Windows 10 configuration? Thank you again for the open source.

    • Iris Staro says:

      Hello Santiago!
      Thank you for contacting Magoware!

      The problem you are having may be related to the connection with the database. MySQL is installed also locally ? Please make sure the database credentials on the file : config/env/db.connection.js are correct.
      We can assist you on checking the error , by sending us the logs when running the server. Please send us the logs at support@magoware for further assistance

      Regards
      Magoware Team

  24. Carlos says:

    Hello! The system was working fine, but when I made a logout, I tried to login again, but the admin password isn´t working (the same password, I´ve not changed). Where can I change the admin password?

    • Iris Staro says:

      Hello Carlos!
      Thank you for contacting Magoware !

      Have you tried to change the admin password , from the admin user edit on the right corner of the panel ?

      Regards
      Magoware Team

  25. Pablo says:

    Thank you Support for this open source. Im getting closer to complete the configuration but also having issue connecting to database when running the node.js. Im running mysql is the same windows 10 platform. I have also checked the config file and updated password gew times but no luck. Do i need to set up a scheme on mysql acter I create de database? Any extra database permissions needed once account is established? Same as Santiago above, the portal is coming up but after I entered credentials (admin admin) nothing else happens.
    Thank you again!
    Pablo

  26. Pablo says:

    Hi Iris,
    I followed your advice and made sure to grant the user full access on mysql database but no luck. I’m still getting “142z – error: Error connecting to database”.
    Is there any logs I can provide to you?
    Thank you.

  27. Nestor Cruz says:

    Hi

    I’m testing your system and following the steps of installation from https://github.com/MAGOWARE/backoffice-administration.

    I have the following problem I can access the login page, I have entered the credentials user admin and password admin, and I do not pass that point.

    No error is displayed on the screen
    the console message is next

    #sudo nodejs server.js
    ————————————-Starting server—————————————————-
    Running HTTP server
    ————————–
    MAGOWARE – Development Environment
    Environment: development
    Port: 8080
    Database: vodTest
    App version: 1.14.1 db.012
    App URL: localhost:8080
    { SITE_ID: ‘KMDK’,
    AES256_IV: ‘0123456789abcdef’,
    API_TYPE: ‘JSON’,
    SITE_KEY: ‘WxoXbCibLa6ZAuwIxlfG8ZaX3JzX68uZ’,
    PACK_KEY: ‘Ma6VRgtv0C40NAQfNShhRRLFljiHunAJ’,
    TEST_USERID: ‘morningstar1’,
    TEST_CID: ‘kombi2.stream_360p’,
    TEST_STREAM: ‘http://109.69.2.124:8337/testpallycon/kombi2.stream_360p/playlist.m3u8’,
    LIC_SERVER: ‘https://license.pallycon.com/ri/licenseManager.do’ }

  28. Sam says:

    Hi,

    Everything is installed and I can load the login page but:

    user: admin
    pass: admin

    doesn’t login to the panel. What can be the problem?

    Debian 9, node 10.15.1, npm 6.4.1, Chrome

    Thanks

    • Sam says:

      Tested on W10 but same problem.

    • Iris Staro says:

      Hello Sam!
      Thank you for contacting Magoware.
      The problem you are having may be related to the connection with the database, when you first run the management system.
      Please check the logs when you run : node server.js , if you see a log ” Error connecting to database”
      If yes, first make sure the database credentials are correct , and also if the user you are using has the right permissions.

      Shall you need further assistance please contact us support@magoware.tv

      Regards
      Magoware Team

      • Sam says:

        Thanks.

        Solution:

        Execute the following query in MYSQL Workbench

        ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’

        Try connecting using node after you do so

        • Sam says:

          What make this to prompt when I want to upload an image?

          fs.js:142
          throw new ERR_INVALID_CALLBACK();
          ^

          TypeError [ERR_INVALID_CALLBACK]: Callback must be a function
          at makeCallback (fs.js:142:11)
          at Object.unlink (fs.js:960:14)
          at ReadStream. (/root/backoffice-administration/modules/mago/server/controllers/common.controller.js:47:16)
          at ReadStream.emit (events.js:202:15)
          at endReadableNT (_stream_readable.js:1129:12)
          at processTicksAndRejections (internal/process/next_tick.js:76:17)

          • Iris Staro says:

            Hello Sam!
            Please check nodejs version installed regarding the issue of uploading an image.
            If the nodejs version is higher that 8.x please downgrade it. We recommend nodejs version 7.xx or 8.xx

            Regards
            Magoware Team

  29. Ricardo Gallagher says:

    Hello, I install the middleware under ubuntu 16.04, all ok till the point I open the channels / Genres/ or trying to add a channel, I get the following message :
    error: Getting genre list failed with error: message=ER_WRO
    NG_FIELD_WITH_GROUP: Expression #5 of SELECT list is not in
    GROUP BY clause and contains nonaggregated column ‘magoware.
    channels.id’ which is not functionally dependent on columns
    in GROUP BY clause; this is incompatible with sql_mode=only_
    full_group_by, name=SequelizeDatabaseError, stack=SequelizeD
    atabaseError: ER_WRONG_FIELD_WITH_GROUP:

    Issue is also open in github

    • Iris Staro says:

      Hello Ricardo!
      Thank you for contacting Magoware. To solve the problem you are having please make sure MySQL mode is set globally to ‘NO_ENGINE_SUBSTITUTION’

      Regards
      Magoware Team

  30. fitimi says:

    pershendetje,desha te ju bej nje pyetje per se ne celular nuk e ruan url , duhet te i japesh sa her te kyqesh a ka ndonje zgjidhje ju faleminderit

    • Iris Staro says:

      Hello Fitim!
      Thank you for contacting Magoware.

      The server address field is available only for testing purposes,and that’s why it is not saved. If you are interested on having the applications and the management system branded for your company, please don’t hesitate to contact us at info@magoware.tv

      Regards
      Magoware Team

  31. Max says:

    I create a subscription for users but it is not reflected in the user menu and the user can not view the channels. how to fix?

  32. Helix MRM says:

    hi?
    install work fine
    but access web not exmpale.com/admin
    only exmpale.com:port/admin/
    but if i type admin admin
    not work loging page its stop

  33. Aleksan Avetisyan says:

    Hi

    I cant done it installation . After run server,js setup stop it on this action
    info: /apiv2/schedule/reload {}
    and stop it on this action . How I can fix it this ?

    Thanks

    • Aleksan Avetisyan says:

      2019-03-22T06:50:49.401Z – info: Live TV stream source created successfully.
      2019-03-22T06:50:49.419Z – info: /apiv2/schedule/reload {}
      2019-03-22T06:50:49.419Z – info: /apiv2/schedule/reload {}

      • Iris Staro says:

        Hello Aleksan!
        The logs you see after running the service and stopping on info: /apiv2/schedule/reload {} means the management system is successfully installed. You can go ahead and access the management system on the web browser.
        The url you need to access is on this format : http://serverIP_or_domainName/admin
        If you are running the service on a different port than 80 , please include the port number too.

        Best Regards
        Magoware Team

    • Iris Staro says:

      Hello Aleksan!

      Regarding the installation , it is okay that it stops to that point , means the service has been started. You can access the management system on the browser on the following format url : http://serverIP_or_domainname:portnumber/admin
      If the port number is 80 there is no need to include port number
      ​To have the service running after closing the command line you can install pm2 service and start the server as shown below :
      to install : npm install pm2 -g
      To start the server : pm2 start server.js ( on the root folder of magoware)

      Best Regards
      Magoware Team

  34. lucio says:

    I could customize the Android APP with my brand logo
    ?

    • Iris Staro says:

      Hello Lucio!
      Thank you for contacting Magoware.
      We would be more than happy to assist you in providing a branded application for your company. Please don’t hesitate to contact us at info@magoware.tv and one of our sales representatives will get in touch with you

      Best Regards
      Magoware Team

  35. Mahdi says:

    Hi dear Magoware
    it’s my db.connection.js
    name: process.env.DB_NAME || “IPTV1”
    host: process.env.DB_HOST || “localhost”
    port: process.env.DB_PORT || “3306”
    username: process.env.DB_USERNAME || “root”
    password: process.env.DB_PASSWORD || “1”
    dialect: process.env.DB_DIALECT || “mysql”
    and when i enter ” sudo node server.js ” it shows me ”
    ————————————-Starting server—————————————————-
    2019-04-23T12:20:20.723Z – info: Initializing Sequelize…
    /media/backoffice-administration-master/node_modules/sequelize/lib/sequelize.js:231
    throw new Error(‘The dialect ‘ + this.getDialect() + ‘ is not supported. Supported dialects: mariadb, mssql, mysql, postgres, and sqlite.’);
    ^

    Error: The dialect undefined is not supported. Supported dialects: mariadb, mssql, mysql, postgres, and sqlite.
    at new Sequelize (/media/backoffice-administration-master/node_modules/sequelize/lib/sequelize.js:231:13)
    at Object.db.connect (/media/backoffice-administration-master/config/lib/sequelize.js:63:21)
    at Object. (/media/backoffice-administration-master/config/lib/sequelize-connect.js:22:5)
    at Module._compile (internal/modules/cjs/loader.js:701:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:712:10)
    at Module.load (internal/modules/cjs/loader.js:600:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:539:12)
    at Function.Module._load (internal/modules/cjs/loader.js:531:3)
    at Module.require (internal/modules/cjs/loader.js:637:17)
    at require (internal/modules/cjs/helpers.js:22:18)
    at Object. (/media/backoffice-administration-master/config/lib/app.js:9:15)
    at Module._compile (internal/modules/cjs/loader.js:701:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:712:10)
    at Module.load (internal/modules/cjs/loader.js:600:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:539:12)
    at Function.Module._load (internal/modules/cjs/loader.js:531:3)

    • Iris Staro says:

      Hello Mahdi!
      Thank you for contacting Magoware.
      Regarding the problem you are having, please make sure the dialect is set “MySQL” without spaces and spelled correctly.
      Can you confirm the nodejs, sequelize, npm version installed? And also which is the environment you have used to install the management system?

      Regards
      Magoware Team

      • Mahdi says:

        Hi Magoware Team
        that problem has solved by reinstalling mysql and there is another new problem
        ——————————————————————————————————-
        sudo node server.js
        ————————————-Starting server—————————————————-
        2019-04-23T14:05:04.855Z – info: Initializing Sequelize…
        /media/backoffice-administration-master/node_modules/sequelize/lib/sequelize.js:185
        throw new Error(‘Dialect needs to be explicitly supplied as of v4.0.0’);
        ^

        Error: Dialect needs to be explicitly supplied as of v4.0.0
        at new Sequelize (/media/backoffice-administration-master/node_modules/sequelize/lib/sequelize.js:185:13)
        at Object.db.connect (/media/backoffice-administration-master/config/lib/sequelize.js:63:21)
        at Object. (/media/backoffice-administration-master/config/lib/sequelize-connect.js:22:5)
        at Module._compile (module.js:653:30)
        at Object.Module._extensions..js (module.js:664:10)
        at Module.load (module.js:566:32)
        at tryModuleLoad (module.js:506:12)
        at Function.Module._load (module.js:498:3)
        at Module.require (module.js:597:17)
        at require (internal/module.js:11:18)
        at Object. (/media/backoffice-administration-master/config/lib/app.js:9:15)
        at Module._compile (module.js:653:30)
        at Object.Module._extensions..js (module.js:664:10)
        at Module.load (module.js:566:32)
        at tryModuleLoad (module.js:506:12)
        at Function.Module._load (module.js:498:3)
        at Module.require (module.js:597:17)
        at require (internal/module.js:11:18)
        at /media/backoffice-administration-master/server.js:90:15
        at /media/backoffice-administration-master/node_modules/async/dist/async.js:473:16
        at next (/media/backoffice-administration-master/node_modules/async/dist/async.js:5329:29)
        at /media/backoffice-administration-master/node_modules/async/dist/async.js:969:16

  36. Mahdi says:

    Hi Magoware Team
    that problem has solved by reinstalling mysql and there is another new problem
    ——————————————————————————————————-
    sudo node server.js
    ————————————-Starting server—————————————————-
    2019-04-23T14:05:04.855Z – info: Initializing Sequelize…
    /media/backoffice-administration-master/node_modules/sequelize/lib/sequelize.js:185
    throw new Error(‘Dialect needs to be explicitly supplied as of v4.0.0’);
    ^

    Error: Dialect needs to be explicitly supplied as of v4.0.0
    at new Sequelize (/media/backoffice-administration-master/node_modules/sequelize/lib/sequelize.js:185:13)
    at Object.db.connect (/media/backoffice-administration-master/config/lib/sequelize.js:63:21)
    at Object. (/media/backoffice-administration-master/config/lib/sequelize-connect.js:22:5)
    at Module._compile (module.js:653:30)
    at Object.Module._extensions..js (module.js:664:10)
    at Module.load (module.js:566:32)
    at tryModuleLoad (module.js:506:12)
    at Function.Module._load (module.js:498:3)
    at Module.require (module.js:597:17)
    at require (internal/module.js:11:18)
    at Object. (/media/backoffice-administration-master/config/lib/app.js:9:15)
    at Module._compile (module.js:653:30)
    at Object.Module._extensions..js (module.js:664:10)
    at Module.load (module.js:566:32)
    at tryModuleLoad (module.js:506:12)
    at Function.Module._load (module.js:498:3)
    at Module.require (module.js:597:17)
    at require (internal/module.js:11:18)
    at /media/backoffice-administration-master/server.js:90:15
    at /media/backoffice-administration-master/node_modules/async/dist/async.js:473:16
    at next (/media/backoffice-administration-master/node_modules/async/dist/async.js:5329:29)
    at /media/backoffice-administration-master/node_modules/async/dist/async.js:969:16

  37. Ashir says:

    I have installed magoware on Debian server successfully. But the issue is after I login with user name and password. It’s not going to the other page.

    • Iris Staro says:

      Hello Ashir!
      Thank you for contacting Magoware. To solve the issue you are having, after logging in please delete the last part of the url “#login” and reload the page. You will be redirected to the dashboard view.
      Within this week we will update the version on github with the issue fixed. Shall you need further assistance please don’t hesitate to contact us at support@magoware.tv

      Best Regards
      Magoware Team

  38. Nahuel says:

    MW is compatible with tvheader?

  39. Sergio says:

    BUENOS DIAS AL INICIAR EL SERVIDOR ME MUSTRA ESTE ERROR YA CORROBORE LAS CREDENCIALES DE BASE DE DATOS PERO SIGUE IGUAL.

    MAGOWARE – Development Environment
    Environment: development
    Port: 8081
    Database: iptv
    App version: 1.13.7 db.010
    App URL: localhost:8081
    2019-04-26T17:00:17.318Z – error: Error connecting to database
    2019-04-26T17:00:17.319Z – error: error reading advanced settings:
    { message: ‘getaddrinfo ENOTFOUND locahost locahost:3306’,
    name: ‘SequelizeHostNotFoundError’,
    stack: ‘SequelizeHostNotFoundError: getaddrinfo ENOTFOUND locahost locahost:3306\n at Handshake. (/var/www/html/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:86:20)\n at Handshake. (/var/www/html/node_modules/mysql/lib/Connection.js:502:10)\n at Handshake._callback (/var/www/html/node_modules/mysql/lib/Connection.js:468:16)\n at Handshake.Sequence.end (/var/www/html/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)\n at Protocol.handleNetworkError (/var/www/html/node_modules/mysql/lib/protocol/Protocol.js:361:14)\n at Connection._handleNetworkError (/var/www/html/node_modules/mysql/lib/Connection.js:420:18)\n at emitOne (events.js:116:13)\n at Socket.emit (events.js:211:7)\n at emitErrorNT (internal/streams/destroy.js:66:8)\n at _combinedTickCallback (internal/process/next_tick.js:139:11)\n at process._tickCallback (internal/process/next_tick.js:181:9)\nFrom previous event:\n at ConnectionManager.connect (/var/www/html/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:55:10)\n at ConnectionManager. (/var/www/html/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:247:43)\n at runCallback (timers.js:810:20)\n at tryOnImmediate (timers.js:768:5)\n at processImmediate [as _immediateCallback] (timers.js:745:5)\nFrom previous event:\n at Promise.then (/var/www/html/node_modules/sequelize/lib/promise.js:21:17)\n at ConnectionManager.$connect (/var/www/html/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:246:70)\n at ConnectionManager.getConnection (/var/www/html/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:203:44)\n at Sequelize.query (/var/www/html/node_modules/sequelize/lib/sequelize.js:844:83)\n at Sequelize.authenticate (/var/www/html/node_modules/sequelize/lib/sequelize.js:1085:15)\n at Object.db.connect (/var/www/html/config/lib/sequelize.js:70:15)\n at Object. (/var/www/html/config/lib/sequelize-connect.js:22:5)\n at Module._compile (module.js:653:30)\n at Object.Module._extensions..js (module.js:664:10)\n at Module.load (module.js:566:32)\n at tryModuleLoad (module.js:506:12)\n at Function.Module._load (module.js:498:3)\n at Module.require (module.js:597:17)\n at require (internal/module.js:11:18)\n at Object. (/var/www/html/config/lib/app.js:9:17)\n at Module._compile (module.js:653:30)\n at Object.Module._extensions..js (module.js:664:10)\n at Module.load (module.js:566:32)\n at tryModuleLoad (module.js:506:12)’,
    parent:
    { errno: ‘ENOTFOUND’,
    code: ‘ENOTFOUND’,
    syscall: ‘getaddrinfo’,
    hostname: ‘locahost’,
    host: ‘locahost’,
    port: 3306,
    fatal: true },
    original: { ‘$ref’: ‘$[“parent”]’ },
    __stackCleaned__: true }

    • Iris Staro says:

      Hello Sergio!
      Thank you for contacting Magoware.

      Regarding the problem you are having, please make sure the database credentials and the user used for MySQL has the right permissions to allow the connections

      Regards
      Magoware Team

      • jeferson says:

        no sé como debo solucionar este error al ejecutar node server.js

        Error: Cannot find module ‘async’
        at Function.Module._resolveFilename (internal/modules/cjs/loader.js:581:15)
        at Function.Module._load (internal/modules/cjs/loader.js:507:25)
        at Module.require (internal/modules/cjs/loader.js:637:17)
        at require (internal/modules/cjs/helpers.js:22:18)
        at Object. (/usr/local/src/magoware/server.js:3:13)
        at Module._compile (internal/modules/cjs/loader.js:689:30)
        at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10)
        at Module.load (internal/modules/cjs/loader.js:599:32)
        at tryModuleLoad (internal/modules/cjs/loader.js:538:12)
        at Function.Module._load (internal/modules/cjs/loader.js:530:3)
        root@ngn-VirtualBox:/usr/local/src/magoware#

        • Iris Staro says:

          Hello Jeferson!
          From the error looks like the npm packages are not installed correctly. Please make sure node version is 8.x.x and npm version 6.x (those are the version we recommend mostly) and try to install again the npm packages

          Best Regards
          Magoware Team

  40. MyKmpng Hotspt says:

    Hello Magoware Team

    how to create a database on the MySQL server to connect with the Magoware management system?

    • Iris Staro says:

      Hello!

      You need to create an empty database on mysql, and when you run the server the system will require database information. Make sure the data’s you enter are correct and the management system will auto-populate the database with the needed information to start the setup

      Best Regards
      Magoware Team

  41. MyKmpng Hotspt says:

    hello magoware team

    can you make a tutorial to install and configure magoware with the xampp application ??

  42. MyKmpng Hotspt says:

    hello magoware team

    how to overcome this problem
    hunk (_stream_readable.js:250:11)\n at Socket.Readable.push (_stream_readable
    .js:208:10)\nFrom previous event:\n at ConnectionManager.connect (C:\\xampp\\
    htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialects\\mysql\\connecti
    on-manager.js:55:10)\n at ConnectionManager. (C:\\xampp\\htdocs\\m
    agoware-master\\node_modules\\sequelize\\lib\\dialects\\abstract\\connection-man
    ager.js:247:43)\n at runCallback (timers.js:785:20)\n at tryOnImmediate (t
    imers.js:747:5)\n at processImmediate [as _immediateCallback] (timers.js:718:
    5)\nFrom previous event:\n at Promise.then (C:\\xampp\\htdocs\\magoware-maste
    r\\node_modules\\sequelize\\lib\\promise.js:21:17)\n at ConnectionManager.$co
    nnect (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialect
    s\\abstract\\connection-manager.js:246:70)\n at ConnectionManager.getConnecti
    on (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialects\\
    abstract\\connection-manager.js:203:44)\n at Sequelize.query (C:\\xampp\\htdo
    cs\\magoware-master\\node_modules\\sequelize\\lib\\sequelize.js:844:83)\n at
    Sequelize.authenticate (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequel
    ize\\lib\\sequelize.js:1085:15)\n at Object.db.connect (C:\\xampp\\htdocs\\ma
    goware-master\\config\\lib\\sequelize.js:71:15)\n at Object. (C:\\
    xampp\\htdocs\\magoware-master\\config\\lib\\sequelize-connect.js:22:5)\n at
    Module._compile (module.js:612:30)\n at Object.Module._extensions..js (module
    .js:623:10)\n at Module.load (module.js:531:32)\n at tryModuleLoad (module
    .js:494:12)\n at Function.Module._load (module.js:486:3)\n at Module.requi
    re (module.js:556:17)\n at require (internal/module.js:11:18)\n at Object.
    (C:\\xampp\\htdocs\\magoware-master\\config\\lib\\app.js:9:15)\n
    at Module._compile (module.js:612:30)\n at Object.Module._extensions..js (mod
    ule.js:623:10)\n at Module.load (module.js:531:32)\n at tryModuleLoad (mod
    ule.js:494:12)’,
    parent:
    { code: ‘ER_ACCESS_DENIED_ERROR’,
    errno: 1045,
    sqlMessage: ‘Access denied for user \’Admin\’@\’localhost\’ (using password
    : YES)’,
    sqlState: ‘28000’,
    fatal: true },
    original: { ‘$ref’: ‘$[“parent”]’ },
    __stackCleaned__: true }
    2019-05-25T01:53:47.122Z – error: error reading database settings:
    { message: ‘ER_ACCESS_DENIED_ERROR: Access denied for user \’Admin\’@\’localhost
    \’ (using password: YES)’,
    name: ‘SequelizeAccessDeniedError’,
    stack: ‘SequelizeAccessDeniedError: ER_ACCESS_DENIED_ERROR: Access denied for
    user \’Admin\’@\’localhost\’ (using password: YES)\n at Handshake.
    (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialects\\my
    sql\\connection-manager.js:83:20)\n at Handshake. (C:\\xampp\\htdo
    cs\\magoware-master\\node_modules\\mysql\\lib\\Connection.js:525:10)\n at Han
    dshake._callback (C:\\xampp\\htdocs\\magoware-master\\node_modules\\mysql\\lib\\
    Connection.js:491:16)\n at Handshake.Sequence.end (C:\\xampp\\htdocs\\magowar
    e-master\\node_modules\\mysql\\lib\\protocol\\sequences\\Sequence.js:83:24)\n
    at Handshake.ErrorPacket (C:\\xampp\\htdocs\\magoware-master\\node_modules\\mys
    ql\\lib\\protocol\\sequences\\Handshake.js:125:8)\n at Protocol._parsePacket
    (C:\\xampp\\htdocs\\magoware-master\\node_modules\\mysql\\lib\\protocol\\Protoco
    l.js:291:23)\n at Parser._parsePacket (C:\\xampp\\htdocs\\magoware-master\\no
    de_modules\\mysql\\lib\\protocol\\Parser.js:433:10)\n at Parser.write (C:\\xa
    mpp\\htdocs\\magoware-master\\node_modules\\mysql\\lib\\protocol\\Parser.js:43:1
    0)\n at Protocol.write (C:\\xampp\\htdocs\\magoware-master\\node_modules\\mys
    ql\\lib\\protocol\\Protocol.js:38:16)\n at Socket. (C:\\xampp\\htd
    ocs\\magoware-master\\node_modules\\mysql\\lib\\Connection.js:91:28)\n at Soc
    ket. (C:\\xampp\\htdocs\\magoware-master\\node_modules\\mysql\\lib\\C
    onnection.js:525:10)\n at emitOne (events.js:115:13)\n at Socket.emit (eve
    nts.js:210:7)\n at addChunk (_stream_readable.js:263:12)\n at readableAddC
    hunk (_stream_readable.js:250:11)\n at Socket.Readable.push (_stream_readable
    .js:208:10)\nFrom previous event:\n at ConnectionManager.connect (C:\\xampp\\
    htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialects\\mysql\\connecti
    on-manager.js:55:10)\n at ConnectionManager. (C:\\xampp\\htdocs\\m
    agoware-master\\node_modules\\sequelize\\lib\\dialects\\abstract\\connection-man
    ager.js:247:43)\n at runCallback (timers.js:785:20)\n at tryOnImmediate (t
    imers.js:747:5)\n at processImmediate [as _immediateCallback] (timers.js:718:
    5)\nFrom previous event:\n at Promise.then (C:\\xampp\\htdocs\\magoware-maste
    r\\node_modules\\sequelize\\lib\\promise.js:21:17)\n at ConnectionManager.$co
    nnect (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialect
    s\\abstract\\connection-manager.js:246:70)\n at ConnectionManager.getConnecti
    on (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequelize\\lib\\dialects\\
    abstract\\connection-manager.js:203:44)\n at Sequelize.query (C:\\xampp\\htdo
    cs\\magoware-master\\node_modules\\sequelize\\lib\\sequelize.js:844:83)\n at
    Sequelize.authenticate (C:\\xampp\\htdocs\\magoware-master\\node_modules\\sequel
    ize\\lib\\sequelize.js:1085:15)\n at Object.db.connect (C:\\xampp\\htdocs\\ma
    goware-master\\config\\lib\\sequelize.js:71:15)\n at Object. (C:\\
    xampp\\htdocs\\magoware-master\\config\\lib\\sequelize-connect.js:22:5)\n at
    Module._compile (module.js:612:30)\n at Object.Module._extensions..js (module
    .js:623:10)\n at Module.load (module.js:531:32)\n at tryModuleLoad (module
    .js:494:12)\n at Function.Module._load (module.js:486:3)\n at Module.requi
    re (module.js:556:17)\n at require (internal/module.js:11:18)\n at Object.
    (C:\\xampp\\htdocs\\magoware-master\\config\\lib\\app.js:9:15)\n
    at Module._compile (module.js:612:30)\n at Object.Module._extensions..js (mod
    ule.js:623:10)\n at Module.load (module.js:531:32)\n at tryModuleLoad (mod
    ule.js:494:12)’,
    parent:
    { code: ‘ER_ACCESS_DENIED_ERROR’,
    errno: 1045,
    sqlMessage: ‘Access denied for user \’Admin\’@\’localhost\’ (using password
    : YES)’,
    sqlState: ‘28000’,
    fatal: true },
    original: { ‘$ref’: ‘$[“parent”]’ },
    __stackCleaned__: true }
    2019-05-25T01:53:47.130Z – info: Pallycon config loaded
    error: Finding the user failed with error: message=groups is not associated to
    users!, stack=Error: groups is not associated to users!
    at Model.validateIncludedElement (C:\xampp\htdocs\magoware-master\node_modul
    es\sequelize\lib\model.js:558:11)
    at C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\model.js:440:2
    9
    at Array.map ()
    at Model.validateIncludedElements (C:\xampp\htdocs\magoware-master\node_modu
    les\sequelize\lib\model.js:436:37)
    at Model. (C:\xampp\htdocs\magoware-master\node_modules\sequelize
    \lib\model.js:1372:32)
    at runCallback (timers.js:785:20)
    at tryOnImmediate (timers.js:747:5)
    From previous event:
    at Promise.then (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\
    promise.js:21:17)
    at Model.findAll (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1368:6)
    at Model.findOne (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1527:34)
    at exports.authenticate (C:\xampp\htdocs\magoware-master\modules\mago\server
    \controllers\authentication.controller.js:37:13)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\rou
    te.js:137:13)
    at Route.dispatch (C:\xampp\htdocs\magoware-master\node_modules\express\lib\
    router\route.js:112:3)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    281:22
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at serveStatic (C:\xampp\htdocs\magoware-master\node_modules\serve-static\in
    dex.js:75:16)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\xampp\htdocs\magoware-master\node_modules\express\lib\rou
    ter\index.js:317:13)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    284:7
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at hsts (C:\xampp\htdocs\magoware-master\node_modules\hsts\index.js:52:5)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5), __stackCleaned__=true
    error: Finding the user failed with error: message=groups is not associated to
    users!, stack=Error: groups is not associated to users!
    at Model.validateIncludedElement (C:\xampp\htdocs\magoware-master\node_modul
    es\sequelize\lib\model.js:558:11)
    at C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\model.js:440:2
    9
    at Array.map ()
    at Model.validateIncludedElements (C:\xampp\htdocs\magoware-master\node_modu
    les\sequelize\lib\model.js:436:37)
    at Model. (C:\xampp\htdocs\magoware-master\node_modules\sequelize
    \lib\model.js:1372:32)
    at runCallback (timers.js:785:20)
    at tryOnImmediate (timers.js:747:5)
    From previous event:
    at Promise.then (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\
    promise.js:21:17)
    at Model.findAll (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1368:6)
    at Model.findOne (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1527:34)
    at exports.authenticate (C:\xampp\htdocs\magoware-master\modules\mago\server
    \controllers\authentication.controller.js:37:13)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\rou
    te.js:137:13)
    at Route.dispatch (C:\xampp\htdocs\magoware-master\node_modules\express\lib\
    router\route.js:112:3)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    281:22
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at serveStatic (C:\xampp\htdocs\magoware-master\node_modules\serve-static\in
    dex.js:75:16)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\xampp\htdocs\magoware-master\node_modules\express\lib\rou
    ter\index.js:317:13)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    284:7
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at hsts (C:\xampp\htdocs\magoware-master\node_modules\hsts\index.js:52:5)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5), __stackCleaned__=true
    error: Finding the user failed with error: message=groups is not associated to
    users!, stack=Error: groups is not associated to users!
    at Model.validateIncludedElement (C:\xampp\htdocs\magoware-master\node_modul
    es\sequelize\lib\model.js:558:11)
    at C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\model.js:440:2
    9
    at Array.map ()
    at Model.validateIncludedElements (C:\xampp\htdocs\magoware-master\node_modu
    les\sequelize\lib\model.js:436:37)
    at Model. (C:\xampp\htdocs\magoware-master\node_modules\sequelize
    \lib\model.js:1372:32)
    at runCallback (timers.js:785:20)
    at tryOnImmediate (timers.js:747:5)
    From previous event:
    at Promise.then (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\
    promise.js:21:17)
    at Model.findAll (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1368:6)
    at Model.findOne (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1527:34)
    at exports.authenticate (C:\xampp\htdocs\magoware-master\modules\mago\server
    \controllers\authentication.controller.js:37:13)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\rou
    te.js:137:13)
    at Route.dispatch (C:\xampp\htdocs\magoware-master\node_modules\express\lib\
    router\route.js:112:3)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    281:22
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at serveStatic (C:\xampp\htdocs\magoware-master\node_modules\serve-static\in
    dex.js:75:16)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\xampp\htdocs\magoware-master\node_modules\express\lib\rou
    ter\index.js:317:13)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    284:7
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at hsts (C:\xampp\htdocs\magoware-master\node_modules\hsts\index.js:52:5)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5), __stackCleaned__=true
    error: Finding the user failed with error: message=groups is not associated to
    users!, stack=Error: groups is not associated to users!
    at Model.validateIncludedElement (C:\xampp\htdocs\magoware-master\node_modul
    es\sequelize\lib\model.js:558:11)
    at C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\model.js:440:2
    9
    at Array.map ()
    at Model.validateIncludedElements (C:\xampp\htdocs\magoware-master\node_modu
    les\sequelize\lib\model.js:436:37)
    at Model. (C:\xampp\htdocs\magoware-master\node_modules\sequelize
    \lib\model.js:1372:32)
    at runCallback (timers.js:785:20)
    at tryOnImmediate (timers.js:747:5)
    From previous event:
    at Promise.then (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib\
    promise.js:21:17)
    at Model.findAll (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1368:6)
    at Model.findOne (C:\xampp\htdocs\magoware-master\node_modules\sequelize\lib
    \model.js:1527:34)
    at exports.authenticate (C:\xampp\htdocs\magoware-master\modules\mago\server
    \controllers\authentication.controller.js:37:13)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\rou
    te.js:137:13)
    at Route.dispatch (C:\xampp\htdocs\magoware-master\node_modules\express\lib\
    router\route.js:112:3)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    281:22
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at serveStatic (C:\xampp\htdocs\magoware-master\node_modules\serve-static\in
    dex.js:75:16)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\xampp\htdocs\magoware-master\node_modules\express\lib\rou
    ter\index.js:317:13)
    at C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\index.js:
    284:7
    at Function.process_params (C:\xampp\htdocs\magoware-master\node_modules\exp
    ress\lib\router\index.js:335:12)
    at next (C:\xampp\htdocs\magoware-master\node_modules\express\lib\router\ind
    ex.js:275:10)
    at hsts (C:\xampp\htdocs\magoware-master\node_modules\hsts\index.js:52:5)
    at Layer.handle [as handle_request] (C:\xampp\htdocs\magoware-master\node_mo
    dules\express\lib\router\layer.js:95:5), __stackCleaned__=true

    • Iris Staro says:

      Hello!
      Thank you for contacting Magoware.

      Looks like the problem you are having is connected to the database credentials and the user permissions to allow connection to the SQL. Please check the credentials and the permissions to resolve the problem you are having

      Best Regards
      Magoware Team

  43. albert born says:

    Hello
    What is the correct step to update the soft. Where I can find the info without loose all the data base or make some mistake
    Thanks in advance

    • Iris Staro says:

      Hello Albert!

      The update of the management system and database migration are published on github. Please also find them below to help you:
      1. Update the files on the server from the new update ( make sure to not touch folder env and files so they will not be overwritten)
      2. Install once more the npm packages
      3. Execute the database migration which steps are also published on the github guidelines. However, find below the commands to run:

      1. sudo npm install -g sequelize-cli
      2. sequelize db:migrate

      Best Regards
      Magoware Team

Leave a Reply to Isaac Kabi Cancel reply

Your email address will not be published.