RPG-Research / bcirpg

Brain-Computer Interface Controlled Electronic Role-playing Game development efforts by the 100% volunteer RPG Research community at https://www.rpgresearch.com.
https://bcirpg.com
GNU Affero General Public License v3.0
12 stars 8 forks source link

Database Connection with Web Based Project #52

Open PersonGuyGit opened 11 months ago

PersonGuyGit commented 11 months ago

Hello There,

I wanted to post this issue to make sure there was a record of what we can do, to try and fix the Database problems, with the Database Test version of this project.

The biggest thing, is that there is either the incorrect value, or the wrong value under "Const HOST" in the postgres test file.

I would say we should try srv1@bcirpg.com, as well as each IP found under the "ip address" command, that we run on the server.

If that does not work, we can look into it from there.

I also did some digging to see if this was a problem that people have had with NGINX projects before, but this seems a bit in the weeds.

MacDugRPG commented 11 months ago

Getting this on the console output on http://srv1.bcirpg.com:8086/

Init running index.js:354:16 USER: ernie; HOST: localhost; PORT: 5432; DATABASE: main index.js:354:16 ERROR: getaddrinfo failed! Cannot resolve hostname. index.js:369:18 at: _resolve_hostname (drivers/unix/ip_unix.cpp:98) - getaddrinfo failed! Cannot resolve hostname. index.js:369:18 [PostgreSQLClient:1337] Invalid host Postgres. index.js:354:16 Test is running index.js:354:16 Physics running 583 index.js:354:16

Let me know what hostname you want to try with this. From the session before last, Hawke suggested a mod we'll maybe need to make in the nginx conf in order to use localhost—additional modules are needed for Nginx to communicate with PostgreSQL.