会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 134129个问题

老师您好。我这个mongodb一开启auth=true, test中的代码执行完就会提示如下的unauthorized错误。我已经尝试了多种方式,包括多种yml中配置的格式,以及在@SpringBootApplication后面添加(exclude=...........)的这种写法,全都不管用。


后来删掉auth=true,就可以运行成功。而且很奇怪的是,开启用户认证后不光test中的代码会提示错误,就算在mongdb控制台中已经可以验证通过后再操作几分钟之后,mongdb控制台也会提示unauthorize的错误,类似db.shutdownServer()也无法执行了。好奇怪,请问这个有什么解决方式吗?


org.springframework.data.mongodb.UncategorizedMongoDbException: Command failed with error 13 (Unauthorized): 'not authorized on livegoods to execute command { insert: "banner", ordered: true, $db: "livegoods" }' on server 192.168.86.147:27017. The full response is {"ok": 0.0, "errmsg": "not authorized on livegoods to execute command { insert: \"banner\", ordered: true, $db: \"livegoods\" }", "code": 13, "codeName": "Unauthorized"}; nested exception is com.mongodb.MongoCommandException: Command failed with error 13 (Unauthorized): 'not authorized on livegoods to execute command { insert: "banner", ordered: true, $db: "livegoods" }' on server 192.168.86.147:27017. The full response is {"ok": 0.0, "errmsg": "not authorized on livegoods to execute command { insert: \"banner\", ordered: true, $db: \"livegoods\" }", "code": 13, "codeName": "Unauthorized"}


at org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:138)

at org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:2902)

at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:587)

at org.springframework.data.mongodb.core.MongoTemplate.insertDocumentList(MongoTemplate.java:1519)

at org.springframework.data.mongodb.core.MongoTemplate.doInsertBatch(MongoTemplate.java:1384)

at org.springframework.data.mongodb.core.MongoTemplate.insert(MongoTemplate.java:1308)

at com.livegoods.mongodb.TestDatas.insertBanners(TestDatas.java:51)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)

at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)

at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)

at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)

at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)

at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)

at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)

at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)

at org.junit.runners.ParentRunner.run(ParentRunner.java:363)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)

at org.junit.runner.JUnitCore.run(JUnitCore.java:137)

at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)

at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)

at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)

at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

Caused by: com.mongodb.MongoCommandException: Command failed with error 13 (Unauthorized): 'not authorized on livegoods to execute command { insert: "banner", ordered: true, $db: "livegoods" }' on server 192.168.86.147:27017. The full response is {"ok": 0.0, "errmsg": "not authorized on livegoods to execute command { insert: \"banner\", ordered: true, $db: \"livegoods\" }", "code": 13, "codeName": "Unauthorized"}

at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:175)

at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:303)

at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:259)

at com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:99)

at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:450)

at com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:72)

at com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:218)

at com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:269)

at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:131)

at com.mongodb.operation.MixedBulkWriteOperation.executeCommand(MixedBulkWriteOperation.java:435)

at com.mongodb.operation.MixedBulkWriteOperation.executeBulkWriteBatch(MixedBulkWriteOperation.java:261)

at com.mongodb.operation.MixedBulkWriteOperation.access$700(MixedBulkWriteOperation.java:72)

at com.mongodb.operation.MixedBulkWriteOperation$1.call(MixedBulkWriteOperation.java:205)

at com.mongodb.operation.MixedBulkWriteOperation$1.call(MixedBulkWriteOperation.java:196)

at com.mongodb.operation.OperationHelper.withReleasableConnection(OperationHelper.java:501)

at com.mongodb.operation.MixedBulkWriteOperation.execute(MixedBulkWriteOperation.java:196)

at com.mongodb.operation.MixedBulkWriteOperation.execute(MixedBulkWriteOperation.java:71)

at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:206)

at com.mongodb.client.internal.MongoCollectionImpl.executeInsertMany(MongoCollectionImpl.java:524)

at com.mongodb.client.internal.MongoCollectionImpl.insertMany(MongoCollectionImpl.java:508)

at com.mongodb.client.internal.MongoCollectionImpl.insertMany(MongoCollectionImpl.java:503)

at org.springframework.data.mongodb.core.MongoTemplate.lambda$insertDocumentList$17(MongoTemplate.java:1526)

at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:585)

... 34 more


JAVA 全系列/第二十二阶段:租房网(Spring Cloud最新架构)/Livegoods第一天 31741楼
JAVA 全系列/第一阶段:AI驱动的JAVA编程/变量、数据类型、运算符 31745楼

jdbc链接数据库出现问题:

1:代码

package sxt.com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcTest {

    //向departments表添加一条数据
    public void insertDepartments(String department_name){
        Connection conn = null;
        Statement state = null;

        //驱动注册
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //创建链接
             conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/sxt?characterEncoding=utf-8","root","root");
            //执行sql
            String sql = "insert into department values(default,‘研发部’)";
             state = conn.createStatement();
           int flag = state.executeUpdate(sql);
            System.out.println(flag);
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            if (state != null){
                try {
                    state.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
        }
        if (conn != null){
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

    }

    public static void main(String[] args) {
        JdbcTest test = new JdbcTest();
        test.insertDepartments("研发部");
    }
}

2:问题:


image.png

JAVA 全系列/第四阶段:数据库与AI协同技术实战/JDBC技术(旧) 31749楼
JAVA 全系列/第九阶段:Spring Boot实战/Spring Boot 31751楼
JAVA 全系列/第十八阶段:亿级高并发电商项目_架构/编码(旧)/电商:使用RabbitMQ实现大广告异步缓存 31753楼
JAVA 全系列/第六阶段:JavaWeb开发/Servlet技术详解(旧) 31754楼
JAVA 全系列/第十三阶段:高性能数据处理、NoSQL、分库分表/MyCat 31755楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637