Tirana, Albania
+355 445 043 50

Advanced Configurations

You may need to do further configurations to completelly install the backoffice system.

Here are some of the configuration you may need to do if one of this cases presents during installation

After downloading the source code, configure the database connection in the file  ./config / env / db.connection.js  replacing the words in italic with the settings of your schema
name: process.env.DB_NAME || ” insert database name ”
host: process.env.DB_HOST || ” insert database host “,
port: process.env.DB_PORT || , 3306,
username: process.env.DB_USERNAME || ” insert username created in your schema “,
password: process.env.DB_PASSWORD || ” insert pasword created in your schema ”
dialect: process.env.DB_DIALECT || ‘ insert value mysql ‘

Automaticlly webserver will start running in Port Service 80 . You may have other services running in this host por so you will have to change the host port for Magoware webserver.

Change port number in the following path    ./config /env/default.js
Configure port number : port: process.env.PORT ||  change port number from 80 in the  port number you are using

  1. Make sure sure you have acquired a SSL Certificate , and copy in the following directory
    ./ config / sslcertificate/
  2. Rename certificate file as certificate.txt
  3. Rename key file as key.txt
  4. Run file serverhttps.js

After downloading the source code, configure in the following path

  1. In case of using http change the following value in file  ./server.js

process.env.NODE_ENV = ‘development /  production ‘;

  1. In case of using https change the following value in file ./serverhttps.js

//process.env.NODE_ENV = ”development /  production ‘;

Remember in case you are using both http & https values should  not be the same

Example : http : process.env.NODE_ENV = ‘development ‘; https : //process.env.NODE_ENV = ”production ‘;

Our code uses clauses such as group by, having, order by etc. Make sure that the your database mode supports these clauses.

The code was tested with sql mode set to “NO_ENGINE_SUBSTITUTION”, so we would recommend using this as the sql mode if possible.


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


14 responses to “Advanced Configurations”

  1. Anonymous says:

    After installation and run a server specified database is empty
    Why is it ?

    • Iris Staro says:

      Thank you for your interest on Magoware. We will be more than happy to assist you
      The database needs to be populated with your own data since you have installed your own demo. If you need assistance on how to setup in further steps the backoffice system please contact us :
      E-mail : info@magoware.tv
      Skype : MAGOWARE IPTV

      Have a nice day!

  2. gilbert says:

    Hi Staff,

    Thank you for great OTT solution to share as open source.
    I’ve installed the middleware and works fine except delete function and ..

    Can you please let me know what did i get wrong?

    • Iris Staro says:

      Hello Gilbert!
      Thank you for contacting Magoware!

      I want to explain that there are some menu-s and data that is not possible to delete from the system , but you can make them not available.
      We have replied to your e-mail address in order to better server you for any question or assistance you may need

      Magoware Team 

  3. Rassel Viamonte says:

    I would like to test your system, but there’s something is not working, or I don’t know how to do it. That’s why I need your support.
    When I run the server (server.js) there is nothing on the Data Base. I mean, the data base doesn’t exist. When the mysql schema is created, before or after the server.js runs for the first time? Can I have the mysql schema to create it manually, please?
    Thank you in advanced!
    Have a good day.


  4. Carlos says:


    The database is empty, please send me the database mysql schema.

    • Iris Staro says:

      Hello Carlos!

      Thank you for contacting Magoware!
      You need to create a database in MySQL server for Magoware first , and it will be empty.
      When you run the command sudo node server.js , you will see the system require the database credentials like database name, database username , database password and database host. After entering these data-s the web-server will start to run and the database will be populated with the default values

      If you need further assistance with the installation please contact us in our e-mail address info@magoware.tv or in our skype address : MAGOWARE IPTV

      Magoware Team

  5. Cody says:

    My download doesnt include the db.connection.js in the env folder. Any help would be nice so I can get this up and running!

    • Iris Staro says:


      Thank you for contacting Magoware!
      The file db.connection.js is created automatically after you run the command sudo node server.js and connect to the MySQL database.
      If you need help with the installation or configuration you can contact us also in our e-mail address support@magoware.tv

      Magoware Team

  6. Mauricio says:

    when i run command node server.js it connect to my db but i can see error
    SequelizeDatabaseError: ER_NO_SUCH_TABLE: Table ‘iptv_pambicom.epg_data’ doesn’t exist
    at Query.formatError (C:\backoffice-administration-master\node_modules\sequelize\lib\dialects\mysql\query.js:175:14)
    at Query._callback (C:\backoffice-administration-master\node_modules\sequelize\lib\dialects\mysql\query.js:49:21)
    at Query.Sequence.end (C:\backoffice-administration-master\node_modules\mysql\lib\protocol\sequences\Sequence.js:88:24)
    at Query.ErrorPacket (C:\backoffice-administration-master\node_modules\mysql\lib\protocol\sequences\Query.js:90:8)
    at Protocol._parsePacket (C:\backoffice-administration-master\node_modules\mysql\lib\protocol\Protocol.js:279:23)
    at Parser.write (C:\backoffice-administration-master\node_modules\mysql\lib\protocol\Parser.js:76:12)
    at Protocol.write (C:\backoffice-administration-master\node_modules\mysql\lib\protocol\Protocol.js:39:16)
    at Socket. (C:\backoffice-administration-master\node_modules\mysql\lib\Connection.js:103:28)
    at Socket.emit (events.js:160:13)
    at addChunk (_stream_readable.js:269:12)
    at readableAddChunk (_stream_readable.js:256:11)
    at Socket.Readable.push (_stream_readable.js:213:10)
    at TCP.onread (net.js:599:20)…

    and so on

    but the web server run but nothing happens when i try to login with user: admin and pass: admin

    Can you help me?

    • Iris Staro says:

      Hello Mauricio!
      Thank you for contacting Magoware!
      First please check nodejs version installed (it is required version 7.x.x or 8.x.x). If you have one of these versions installed, try to delete config folder , copy it again on the server and run : sudo node server.js
      Make sure database credentials you are entering are correct to not experience the same problem again.
      If you need further assistance please contact our support at support@magoware.tv

      Magoware Team

Leave a Reply

Your email address will not be published.