blocks|key|214612|text|正如在文档中所解释的，您可以定义一个工厂函数，在其中注入配置服务，允许您解析相应的值：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|214613|TypeOrmModule.forRootAsync({
++imports:+[ConfigModule],
++useFactory:+(configService:+ConfigService)+=>+({
++++type:+'postgres',
++++host:+configService.get('POSTGRES_HOST'),
++++port:+%2BconfigService.get<number>('POSTGRES_PORT'),
++++username:+configService.get('POSTGRES_USER'),
++++password:+configService.get('POSTGRES_PASSWORD'),
++++database:+configService.get('POSTGRES_DATABASE'),
++++synchronize:+true,
++++autoLoadEntities:+true,
++}),
++inject:+[ConfigService],
});|code-block|syntax|javascript|214614|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.nestjs.com/techniques/database#async-configuration^0|3|2|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

As explained in the <a href="https://docs.nestjs.com/techniques/database#async-configuration" rel="nofollow noreferrer">docs</a>, you can define a factory function where you inject the config-service allowing you to resolve the corresponding values:
<pre><code>TypeOrmModule.forRootAsync({
 imports: [ConfigModule],
 useFactory: (configService: ConfigService) =&gt; ({
 type: 'postgres',
 host: configService.get('POSTGRES_HOST'),
 port: +configService.get&lt;number&gt;('POSTGRES_PORT'),
 username: configService.get('POSTGRES_USER'),
 password: configService.get('POSTGRES_PASSWORD'),
 database: configService.get('POSTGRES_DATABASE'),
 synchronize: true,
 autoLoadEntities: true,
 }),
 inject: [ConfigService],
});
</code></pre>

blocks|key|421596|text|在NestJs中，您应该使用ConfigService获取您的typeorm模块中的环境变量，阅读文档获取更多信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|421597|你可以这样用它：|421598|import+{+ConfigModule,+ConfigService+}+from+'@nestjs/config';
import+{+Module+}+from+'@nestjs/common';
import+{+TypeOrmModule+}+from+'@nestjs/typeorm';

@Module({
++imports:+[
++++ConfigModule.forRoot(
++++++envFilePath:+`.${process.env.NODE_ENV}.env`
++++),
++++TypeOrmModule.forRootAsync({
++++++imports:+[ConfigModule],
++++++injects:+[ConfigService],
++++++useFactory:+(configService:+ConfigService)+=>+({
++++++++type:+'postgres',
++++++++host:+configService.get("POSTGRES_HOST"),
++++++++port:+configService.get("POSTGRES_PORT"),
++++++++username:+configService.get("POSTGRES_USER"),
++++++++password:+configService.get("POSTGRES_PASSWORD"),
++++++++database:+configService.get("POSTGRES_DB"),
++++++++entities:+[],
++++++++synchronize:+true,
++++++}),
++++}),
++],
++controllers:+[],
++providers:+[],
})
export+class+AppModule+{}|code-block|syntax|javascript|421599|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.nestjs.com/techniques/configuration^0|1D|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

In NestJs you should use ConfigService to get environment variables inside your typeorm module, read the <a href="https://docs.nestjs.com/techniques/configuration" rel="nofollow noreferrer">docs</a> for more information.
You can use it like that:
<pre><code>import { ConfigModule, ConfigService } from '@nestjs/config';
import { Module } from '@nestjs/common';
import { TypeOrmModule } from '@nestjs/typeorm';

@Module({
 imports: [
 ConfigModule.forRoot(
 envFilePath: `.${process.env.NODE_ENV}.env`
 ),
 TypeOrmModule.forRootAsync({
 imports: [ConfigModule],
 injects: [ConfigService],
 useFactory: (configService: ConfigService) =&gt; ({
 type: 'postgres',
 host: configService.get(&quot;POSTGRES_HOST&quot;),
 port: configService.get(&quot;POSTGRES_PORT&quot;),
 username: configService.get(&quot;POSTGRES_USER&quot;),
 password: configService.get(&quot;POSTGRES_PASSWORD&quot;),
 database: configService.get(&quot;POSTGRES_DB&quot;),
 entities: [],
 synchronize: true,
 }),
 }),
 ],
 controllers: [],
 providers: [],
})
export class AppModule {}
</code></pre>

blocks|key|214646|text|我能够通过使用config模块来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|214647|只要做npm+i+@nestjs/config。然后，在TypeOrmModule+put+ConfigModule.forRoot({+isGlobal:+true+}),之上的imports数组中。这允许模块从.env文件中获取环境变量。|offset|length|style|CODE|214648|entityMap^0|0|3|K|1A|15|2Z|4|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|I|$]]

I was able to fix the problem by using the config module.
Just do <code>npm i @nestjs/config</code>. Then in the imports array just above the TypeOrmModule put <code>ConfigModule.forRoot({ isGlobal: true }),</code>. This allows your module to get the environment variables from the <code>.env</code> file

blocks|key|434399|text|我得到这个错误是因为我错误地将.env文件放进了src中。如果你把它放在src之外，它就会修复它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|434400|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I got this error because I put the .env file inside the src by mistake. If you put it outside of the src it will fix it

blocks|key|421669|text|我面临着同样的问题，这是奇怪的，因为我修改了几次配置，只是为了检查“新的事情发生了”，但没有成功。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|421670|长话短说，我删除了该项目的"dist“文件夹，并重新构建了应用程序(npm+run+build)，它成功了！似乎我有一个“坏的构建”一遍又一遍地运行，所以这个解决方案可以“刷新”构建，让事情继续正常运行。|offset|length|style|CODE|421671|希望能帮上忙！|421672|entityMap^0|0|Y|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I was facing the same issue and it was weird because I modified several times that configuration just to check if &quot;something new happens&quot; but have no success.
Long story short, I deleted the &quot;dist&quot; folder of the project and build the app again (<code>npm run build</code>) and it worked! It appeared that I had a &quot;bad build&quot; running over and over again so this workaround kind of &quot;refreshed&quot; the build and let things running well again.
Hope this help!

i have a problem with connecting to database in nest.js with typeorm and postgres.
I created a .env file in the root project directory with the following content
<pre><code>POSTGRES_HOST=127.0.0.1
POSTGRES_PORT=5432
POSTGRES_USER=postgres
POSTGRES_PASSWORD=password
POSTGRES_DATABASE=db-name
</code></pre>
In the app.module.ts I writed the code below:
<pre><code>import { Module } from '@nestjs/common';
import { ConfigModule } from '@nestjs/config';
import { TypeOrmModule } from '@nestjs/typeorm';
import { FeedModule } from './feed/feed.module';

 @Module({
 imports: [
 ConfigModule.forRoot({ isGlobal: true }),
 TypeOrmModule.forRoot({
 type: 'postgres',
 host: process.env.POSTGRES_HOST,
 port: parseInt(&lt;string&gt;process.env.POSTGRES_PORT),
 username: process.env.POSTGRES_USER,
 password: process.env.POSTGRES_PASSWORD,
 database: process.env.POSTGRES_DATABASE,
 autoLoadEntities: true,
 synchronize: true,
 }),
 FeedModule,
 ],
 
})
export class AppModule {}
</code></pre>
But when im running the app by npm start it throws this error: <code>new Error('SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string')</code>
What am I missing or doing wrong?

NestJs: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我在用typeorm和postgres连接到nest.js数据库时遇到了问题。我在根项目目录中创建了一个.env文件，其内容如下POSTGRES_HOST=127.0.0.1POSTGRES_PORT=5432POSTGRES_USER=postgresPOSTGRES_PASSWORD=passwordPOSTGRE...

问NestJs: SCRAM-SERVER-FIRST-MESSAGE:客户端密码必须是字符串。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问NestJs: SCRAM-SERVER-FIRST-MESSAGE:客户端密码必须是字符串。EN