Follow these steps to install Magoware Management System
-
Install NODE JS
Make sure you install the latest version of nodejs
Recommended : versions 7.x.x or 8.x.x of nodejs -
Download MAGOWARE Backoffice application from Github
-
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) -
Make sure it is installed the latest version of npm
-
Make sure you have MySQL installed on your server
Create a database on MySQL server for Magoware management system to connect.
-
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 passwordMake 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
-
Login to start creating accounts and assets
go to:
http://YourDomain_or_IP/adminand login with username admin and password admin
…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.
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!
I will be testing this MW, can you please tell me which Distribution is better?? under linux?
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!
Try several times to install on Windows 10 and Debian 8 but not successful.
Any step by step to follow installation?
Thanks
Hello Mr.Eric!
We would like to assist you through installing our middlware step by step and check the problems you had during this process.
You can contact us via mail at info@magoware.tv or via skype at MAGOWARE IPTV
Thank you!
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
Hello!
Thank you for contacting Magoware!
If you need assistance to install and configure our management system please contact us on our e-mail address info@magoware.tv or in our skype address MAGOWARE IPTV
We will be glad to assist you!
Hi, does your solution work with multicast or unicast only?
Hello Eduardo!
Thank you for contacting Magoware.
Our middleware works with both formats, unicast and multicast.
For any further questions or assistance needed don’t hesitate to contact us on :
email : info@magoware.tv / support@magoware.tv
skype : MAGOWARE IPTV
Thanks
Magoware Team
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
Hello Isac!
Thank you for your interest in our solution!
Please send us an e-mail to our e-mail address support@magoware.tv with the questions or assistance you need for the installation
Regards
Team Magoware
hello
Magoware Team
II am very interested in this technology
but i’m not understand for installation for my computer database
so pls can you give me videos step by step how to install https://www.magoware.tv/download/ start to end
Hello Said!
Thank you for contacting Magoware!
Our engineers will contact on your e-mail address to assist with the installation
Regards
Magoware Team
I have tried to install the softrware and not luck yet. Please help me.
Hello Carlos!
Please contact us at support@magoware.tv and will assist during the installation of the management system
Regards
Magoware Team
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
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!
having issues with the installation and I already emailed .
I download the file using wget or git ?
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
What is the root folder? I cant find it on windows? plz help
Hello Masi!
Thank you for contacting Magoware!
The rooted folder means you need to work on Magoware directory for executing the commands for installing npm libraries and to run the web-server on the last step of installation.
Regards
Magoware Team
Thanks for the reply.
But can you show me, how to install it on linux
Hello Masi!
We will contact you to help with the installation step by step.
Regards
Magoware Team
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
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
I know that this is not an error, but base project on outdated and non supported components – not a good idea….
Also your instruction miss info, that it is highly possible that problems with mysql server will arise – spinning wheel while accessing most if menu items and to solve problem you need to add mysql setting -> sql_mode = “NO_ENGINE_SUBSTITUTION”
Hello Alex!
We have published the requirements for the system configurations on our article : Advanced Configurations
https://www.magoware.tv/knowledgebase/advanced-configurations/
Regards
Magoware Team
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 ??
Corregi el problema creando de nuevo el usuario y estableciendo nuevamente los permisos sobre la base de datos.
solucionado.
Hello Jonathan!
Thank you for contacting Magoware. For any further assistance regarding installation , configuration or testing the middleware , please contact us at support@magoware.tv
Regards
Magoware Team
Hola Jonathan,
Tengo ya varios dias tratando de instalar MW pero tengo el mismo problema tuyo k me esta dando error conectando al database. Podrias ayudarme al proceso de resolver el permiso? Gracias.
Hello Pablo!
Thank you for contacting Magoware. Please contact us at support@magoware.tv to assist you with the installation
Regards
Magoware Team
Podrías ayudamerme a instalar
Hello Jonathan!
Make sure the database credentials are correctly added when starting the server.
To resolve the problem check again the credentials an try a fresh installation
Regards
Magoware Team
Hello
Can i Install in Ubuntu
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
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
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
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?
Hello Jason!
Could you please confirm the nodejs version installed on server ?
Please make sure the nodejs version to be 8.x.x
Regards
Magoware Team
Hello what is the price of this product? or is it free?
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
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’;
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
Were you able to get it running? If so who do you use for your server ?
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
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
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
Hello Rony!
Thank you for contacting Magoware.
We have contacted you from our support to better assist with the installation
Regards
Magoware Team
Hi, Can I use node js version 9 or 10?
Please advice.
Thanks
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!
Buen día
mi problema es que no lo puedo abrir
ya lo instale y no lo he podido visualizar
Hello Jhon!
Please contact us at support@magoware.tv to assist you with the tests
Regards
Magoware Team
Hi
There is a docker image to install the backoffice?
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
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.
Hello Terence!
Thank you for contacting Magoware.
To login to the application connected to your management system , make sure the server address on the login page to be http://yourserverIP_or_DomainName
Regards
Magoware Team
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
Hello Loai!
To resolve the issue please make sure the SQL mode is set globally to ‘NO_ENGINE_SUBSTITUTION’
Regards
Magoware Team
Hi Loai, Can you possibly e-mail me at sazzam2@hotmail.com? I have some questions for you!
Hello Sal!
Can we assist you with any information or assistance for the middleware? If so , please send us all the questions on support@magoware.tv
Regards
Magoware Team
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.
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
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?
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
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
Hello Pablo!
If the database credentials are correct, please make sure the user you are using to allow management system to connect to MySQL has the permissions to do that
Regards
Magoware Team
Thank you Iris! I will give it a try. Regards.
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.
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’ }
Hello Nestor!
Which browser are you using to access the management system ? Please use chrome , because on the other browsers for the moment there is a redirection to the login page.
Regards
Magoware Team
@Nestor Were you able to solve the problem? I am facing same problem!
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
Tested on W10 but same problem.
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
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
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)
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
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
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
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
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
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?
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
Hello Helix!
Thank you for contacting Magoware.
Yes, there is a redirection at the moment to the login page. To access it after entering the credentials to login, please delete the last part of the url #/login and reload the page.
After that the management system will be redirected to the url : http://serverIP:portnumber/admin/#/dashboard
Best Regards
Magoware Team
I have the same problem as Helix MRM and following the instructions you gave and whatever I do it redirects me to the same place all over again
Hello mr. Smith!
Thank you for contacting Magoware.
To assist you further with the issue you are facing, please contact us at support@magoware.tv
Best Regards
Magoware Team
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
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 {}
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
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
I could customize the Android APP with my brand logo
?
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
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)
“
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
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
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
Hello Mahdi!
Can you please confirm the nodejs version, npm and server you are using to install the middleware?
Best Regards
Magoware Team
I am using npm 6.4.1 ,node v8.16.0 and ubuntu Version 18.04
Hello Mahdi!
Can you contact us at support@magoware.tv so we can check with you the issue on your server?
Best Regards
Magoware Team
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.
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
MW is compatible with tvheader?
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 }
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
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#
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
Hello Magoware Team
how to create a database on the MySQL server to connect with the Magoware management system?
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
hello magoware team
can you make a tutorial to install and configure magoware with the xampp application ??
Hello!
The installation steps are the same on every environment. Shall you need assistance for the installation please contact us at support@magoware.tv
Best Regards
Magoware team
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
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
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
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