search

damian-pastorini / reldens

Reldens - You can make it - Open Source MMORPG Platform
https://demo.reldens.com/
MIT License
430 stars 54 forks source link

Reldens on Plesk #247

Closed MBoberski closed 1 month ago

MBoberski commented 1 month ago

I was trying to run engine on my Plesk instance with node support but when I try to create game I get:

# yarn reldens createApp my-game
Process exited with non-zero exit code '1'
yarn run v1.22.22
$ /var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/.bin/reldens createApp my-game
- Reldens - 
- Use "help" as argument to see all the available commands:
$ node scripts/reldens-commands.js help
- Command "createApp" ready to be executed.
- Theme: my-game
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

warning package.json: No license field
(node:29377) Warning: Closing directory handle on garbage collection
(Use `node --trace-warnings ...` to show where the warning was created)
(node:29377) Warning: Closing directory handle on garbage collection
/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/utils/lib/error-manager.js:23
        throw new Error(message);
              ^

Error: Parcel build Game Client process failed.
    at ErrorManager.error (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/utils/lib/error-manager.js:23:15)
    at ThemeManager.buildClient (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/theme-manager.js:323:30)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ThemeManager.buildSkeleton (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/theme-manager.js:302:9)
    at async ThemeManager.fullRebuild (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/theme-manager.js:417:9)
    at async ThemeManager.createApp (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/theme-manager.js:432:9)
    at async Commander.execute (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/bin/commander.js:82:9)

Node.js v18.20.2
error Command failed with exit code 1.

I don't hjave npx but yarn should be doin the same job. Any idea why?

damian-pastorini commented 1 month ago

Hi @MBoberski !

I think you may be hitting an issue I've found and fix for the next beta.35, try by editing your package json to include the target and the alias for the "process" module, like this:

    "targets": {
        "main": false
    },
    "alias": {
        "process": false
    },

You can see this in the skeleton as well: https://github.com/damian-pastorini/reldens-skeleton/blob/master/package.json

These parameters are require by the bundler to generate the client side code.

Let me know if that fixes the issue for you :) thanks for reporting!

MBoberski commented 1 month ago

Yeah that worked but no I have:

CRITICAL - Connection failed, Objection JS error. Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'reldens'@'localhost' (using password: YES)
    at Sequence._packetToError (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
    at Protocol._parsePacket (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:559:12)
    --------------------
    at Protocol._enqueue (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at Connection.connect (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/mysql/lib/Connection.js:116:18)
    at /var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/knex/lib/dialects/mysql/index.js:71:18
    at new Promise (<anonymous>)
    at Client_MySQL.acquireRawConnection (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/knex/lib/dialects/mysql/index.js:66:12)
    at create (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/knex/lib/client.js:262:39)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
  code: 'ER_ACCESS_DENIED_ERROR',
  errno: 1045,
  sqlMessage: "Access denied for user 'reldens'@'localhost' (using password: YES)",
  sqlState: '28000',
  fatal: true
}
Error
    at Logger.log (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/storage/node_modules/@reldens/utils/lib/logger.js:60:19)
    at Logger.critical (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/storage/node_modules/@reldens/utils/lib/logger.js:110:14)
    at ObjectionJsDataServer.connect (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/storage/lib/objection-js/objection-js-data-server.js:44:20)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ServerManager.initializeStorage (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/manager.js:120:13)
    at async ServerManager.start (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/manager.js:146:9)
CRITICAL - Data Server could not be connected.
Error
    at Logger.log (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/utils/lib/logger.js:60:19)
    at Logger.critical (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/@reldens/utils/lib/logger.js:110:14)
    at ServerManager.initializeStorage (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/manager.js:121:20)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ServerManager.start (/var/www/vhosts/pojegrani.pl/mmorpg.pojegrani.pl/node_modules/reldens/lib/game/server/manager.js:146:9)

but DB is created and accesible...

damian-pastorini commented 1 month ago

I think now you are hitting another known issue but this time is one between nodejs and mysql, you probably need to grant your user with native password, try: CREATE USER '<YOUR_USERNAME>'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY '<YOUR_PASSWORD>'; or ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'current password'

damian-pastorini commented 1 month ago

I'm closing this, let me know if the issue persist with the latest beta. Thanks for reporting!