DEIT-2020 / questions_answers

这里是大家讲所提问题记录下来的地方,请将问题及后来的解决方案列出来。
0 stars 0 forks source link

数据库数据输入成功,但heroes网页显示数据库未连接 #17

Open changqing915 opened 4 years ago

changqing915 commented 4 years ago

在连接数据库之前所有的代码都可以运行并在localhost:8888/heroes上运行

连接数据库时的cmd:

D:\VSCode\changtongwuzu_server\ctwz>aqueduct db upgrade --connect changtongwuzu://iflyup:729at3663@x..x.x.x:5432/changtongwuzu_allpass
-- Aqueduct CLI Version: 3.3.0+1
-- Aqueduct project version: 3.3.0+1
-- Updating to version 1 on new database...
    PostgreSQL connecting, iflyup@13.115.53.84:5432/changtongwuzu_allpass.
    Initializating database...
        CREATE TABLE _aqueduct_version_pgsql (versionNumber INT NOT NULL UNIQUE,dateOfUpgrade TIMESTAMP NOT NULL)
    Applying migration version 1...
        CREATE TABLE _Ctwz (id BIGSERIAL PRIMARY KEY,name TEXT NOT NULL UNIQUE)
    Seeding data from migration version 1...
    Query:execute (101ms) INSERT INTO _Ctwz (name) VALUES (@name) -> []
    Query:execute (88ms) INSERT INTO _Ctwz (name) VALUES (@name) -> []
    Query:execute (88ms) INSERT INTO _Ctwz (name) VALUES (@name) -> []
    Query:execute (89ms) INSERT INTO _Ctwz (name) VALUES (@name) -> []
    Query:execute (89ms) INSERT INTO _Ctwz (name) VALUES (@name) -> []
    Applied schema version 1 successfully.

连接数据库之后,在数据库中运行select * from _ctwz这个表格之后(我自己定的表格名字),显示已连接并且数据正常,之后在VSCode中向数据库添加数据也添加成功。

但是aqueduct serve时,在localhost:8888/heroes上显示: {"error":"unable to connect to database"} 我将heroes换成example,网页显示的结果是正确的

这是cmd运行的数据:(每次刷新/heroes的网页都显示503)


-- Aqueduct CLI Version: 3.3.0+1
-- Aqueduct project version: 3.3.0+1
-- Preparing...
-- Starting application 'ctwz/ctwz'
    Channel: CtwzChannel
    Config: D:\VSCode\changtongwuzu_server\ctwz\config.yaml
    Port: 8888
[INFO] aqueduct: Server aqueduct/1 started.
[INFO] aqueduct: Server aqueduct/2 started.
[INFO] aqueduct: Server aqueduct/3 started.
[INFO] aqueduct: Server aqueduct/4 started.
[INFO] aqueduct: GET /favicon.ico 14ms 404
[INFO] aqueduct: PostgreSQL connecting, heroes_user@localhost:5432/heroes.
[INFO] aqueduct: GET /heroes 1070ms 503```
meflyup commented 4 years ago
 aqueduct: PostgreSQL connecting, heroes_user@localhost:5432/heroes.

的你错误输出中,明显表示了你连接的是localhost(即你本机)的数据库,所以连接不上。