Can't access admin page/How should I set up .env in vscode devcontainer?

[MahmoudHamdy02]

Hello, I'm running into some errors in the dev-container, the storybook works fine, but when I try to login to admin page I get 'No repository for User was found', is this the intended behaviour?

If I leave .env empty I get this error:

IntersectionObserver not available; interactive embeds won't load on this page Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'127.0.0.1' (using password: NO) at Handshake.Sequence._packetToError (/workspace/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Handshake.ErrorPacket (/workspace/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18) at Protocol._parsePacket (/workspace/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser._parsePacket (/workspace/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/workspace/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/workspace/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket.<anonymous> (/workspace/node_modules/mysql/lib/Connection.js:88:28) at Socket.<anonymous> (/workspace/node_modules/mysql/lib/Connection.js:526:10) at Socket.emit (node:events:526:28) at Socket.emit (node:domain:475:12) -------------------- at Protocol._enqueue (/workspace/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Protocol.handshake (/workspace/node_modules/mysql/lib/protocol/Protocol.js:51:23) at PoolConnection.connect (/workspace/node_modules/mysql/lib/Connection.js:116:18) at Pool.getConnection (/workspace/node_modules/mysql/lib/Pool.js:48:16) at /workspace/node_modules/typeorm/driver/mysql/MysqlDriver.js:863:18 at new Promise (<anonymous>) at MysqlDriver.createPool (/workspace/node_modules/typeorm/driver/mysql/MysqlDriver.js:860:16) at MysqlDriver.<anonymous> (/workspace/node_modules/typeorm/driver/mysql/MysqlDriver.js:288:51) at step (/workspace/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) at Object.next (/workspace/node_modules/typeorm/node_modules/tslib/tslib.js:124:57) { code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlMessage: "Access denied for user 'root'@'127.0.0.1' (using password: NO)", sqlState: '28000', fatal: true } Could not connect to grapher database. Continuing without DB... WORDPRESS_DB_NAME is not configured -- continuing without Wordpress DB WORDPRESS_API_URL is not configured -- continuing without Wordpress API owid-admin server started on http://localhost:3030

If I copy .env.example-grapher into .env I get this:

IntersectionObserver not available; interactive embeds won't load on this page Error: connect ECONNREFUSED 127.0.0.1:3307 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1157:16) -------------------- at Protocol._enqueue (/workspace/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Protocol.handshake (/workspace/node_modules/mysql/lib/protocol/Protocol.js:51:23) at PoolConnection.connect (/workspace/node_modules/mysql/lib/Connection.js:116:18) at Pool.getConnection (/workspace/node_modules/mysql/lib/Pool.js:48:16) at /workspace/node_modules/typeorm/driver/mysql/MysqlDriver.js:863:18 at new Promise (<anonymous>) at MysqlDriver.createPool (/workspace/node_modules/typeorm/driver/mysql/MysqlDriver.js:860:16) at MysqlDriver.<anonymous> (/workspace/node_modules/typeorm/driver/mysql/MysqlDriver.js:288:51) at step (/workspace/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) at Object.next (/workspace/node_modules/typeorm/node_modules/tslib/tslib.js:124:57) { errno: -111, code: 'ECONNREFUSED', syscall: 'connect', address: '127.0.0.1', port: 3307, fatal: true } Could not connect to grapher database. Continuing without DB... WORDPRESS_DB_NAME is not configured -- continuing without Wordpress DB WORDPRESS_API_URL is not configured -- continuing without Wordpress API owid-admin server started on http://localhost:3030

Thanks!

[danyx23]

Hi @MahmoudHamdy02! There were some issues with the VS Code dev-container setup. Can you update to the latest version of the codebase, remove your .env file and run the new make command described in the devcontainer setup docs?

[MahmoudHamdy02]

Tried the new instructions and worked perfectly, thanks!