unifi_audit database missing? #150
Description
Is there an existing issue for this?
- I have searched the existing issues
Current Behavior
After creating the mongo db container the application tries to connect, but I am getting the following error
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auditDbService' defined in com.ubnt.service.DatabaseSpringContext: Command failed with error 13 (Unauthorized): 'not authorized on unifi_audit to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db: "unifi_audit", lsid: { id: UUID("b92016c0-cf97-432b-82c7-c869b787f998") } }' on server unifi-db:27017. The full response is {"ok": 0.0, "errmsg": "not authorized on unifi_audit to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db: \"unifi_audit\", lsid: { id: UUID(\"b92016c0-cf97-432b-82c7-c869b787f998\") } }", "code": 13, "codeName": "Unauthorized"}
I don't see the db unifi_audit anywhere in the documentation?
Expected Behavior
No response
Steps To Reproduce
docker compose up -d
Environment
- OS: Unraid
- Using OS docker system
mongosh show users
unifi> show users;
[
{
_id: 'unifi.unifi',
userId: UUID('afc3d923-878f-4aa5-9d49-eb9e9aeab4c0'),
user: 'unifi',
db: 'unifi',
roles: [
{ role: 'dbOwner', db: 'unifi_stat' },
{ role: 'dbOwner', db: 'unifi' }
],
mechanisms: [ 'SCRAM-SHA-1', 'SCRAM-SHA-256' ]
}
]CPU architecture
x86-64
Docker creation
docker-compose.yml file
services:
unifi-db:
image: docker.io/mongo:8
container_name: unifi-db
environment:
- MONGO_INITDB_ROOT_USERNAME=root
- MONGO_INITDB_ROOT_PASSWORD={root pwd}
- MONGO_USER=unifi
- MONGO_PASS={pwd}
- MONGO_DBNAME=unifi
- MONGO_AUTHSOURCE=admin
volumes:
- $PWD/mongo-data:/data/db
- $PWD/init-mongo.sh:/docker-entrypoint-initdb.d/init-mongo.sh:ro
restart: unless-stopped
unifi-network-application:
image: lscr.io/linuxserver/unifi-network-application:latest
container_name: unifi-network-application
environment:
- PUID=0
- PGID=0
- TZ={TZ}
- MONGO_USER=unifi
- MONGO_PASS={pwd}
- MONGO_HOST=unifi-db
- MONGO_PORT=27017
- MONGO_DBNAME=unifi
- MONGO_AUTHSOURCE=admin
- MEM_LIMIT=1024 #optional
- MEM_STARTUP=1024 #optional
volumes:
- $PWD/unms-data:/config
ports:
- 8444:8443
- 3478:3478/udp
- 10001:10001/udp
- 8080:8080
- 1902:1900/udp #optional
- 8843:8843 #optional
- 8881:8880 #optional
- 6789:6789 #optional
- 5514:5514/udp #optional
restart: unless-stopped
depends_on:
- unifi-dbContainer logs
unifi-network-application | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auditDbService' defined in com.ubnt.service.DatabaseSpringContext: Command failed with error 13 (Unauthorized): 'not authorized on unifi_audit to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db: "unifi_audit", lsid: { id: UUID("b92016c0-cf97-432b-82c7-c869b787f998") } }' on server unifi-db:27017. The full response is {"ok": 0.0, "errmsg": "not authorized on unifi_audit to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db: \"unifi_audit\", lsid: { id: UUID(\"b92016c0-cf97-432b-82c7-c869b787f998\") } }", "code": 13, "codeName": "Unauthorized"}
unifi-network-application | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1806)
unifi-network-application | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600)
unifi-network-application | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
unifi-network-application | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337)
unifi-network-application | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
unifi-network-application | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335)
unifi-network-application | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
unifi-network-application | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975)
unifi-network-application | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:971)
unifi-network-application | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:625)
unifi-network-application | at com.ubnt.service.F.Õ00000(Unknown Source)
unifi-network-application | at com.ubnt.service.ooOO.Óo0000(Unknown Source)
unifi-network-application | at com.ubnt.net.S.õÔ0000(Unknown Source)
unifi-network-application | at com.ubnt.net.S.ÕÔ0000(Unknown Source)
unifi-network-application | ... 4 more
unifi-network-application | Caused by: com.mongodb.MongoCommandException: Command failed with error 13 (Unauthorized): 'not authorized on unifi_audit to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db: "unifi_audit", lsid: { id: UUID("b92016c0-cf97-432b-82c7-c869b787f998") } }' on server unifi-db:27017. The full response is {"ok": 0.0, "errmsg": "not authorized on unifi_audit to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db: \"unifi_audit\", lsid: { id: UUID(\"b92016c0-cf97-432b-82c7-c869b787f998\") } }", "code": 13, "codeName": "Unauthorized"}
unifi-network-application | at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:205)
unifi-network-application | at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:431)
unifi-network-application | at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:354)
unifi-network-application | at com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:114)
unifi-network-application | at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:743)
unifi-network-application | at com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:76)
unifi-network-application | at com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:209)
unifi-network-application | at com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:115)
unifi-network-application | at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:83)
unifi-network-application | at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:74)
unifi-network-application | at com.mongodb.internal.connection.DefaultServer$OperationCountTrackingConnection.command(DefaultServer.java:299)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.createReadCommandAndExecute(SyncOperationHelper.java:270)
unifi-network-application | at com.mongodb.internal.operation.ListCollectionsOperation.lambda$execute$1(ListCollectionsOperation.java:167)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.lambda$withSourceAndConnection$0(SyncOperationHelper.java:124)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.withSuppliedResource(SyncOperationHelper.java:149)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.lambda$withSourceAndConnection$1(SyncOperationHelper.java:123)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.withSuppliedResource(SyncOperationHelper.java:149)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.withSourceAndConnection(SyncOperationHelper.java:122)
unifi-network-application | at com.mongodb.internal.operation.ListCollectionsOperation.lambda$execute$2(ListCollectionsOperation.java:164)
unifi-network-application | at com.mongodb.internal.operation.SyncOperationHelper.lambda$decorateReadWithRetries$12(SyncOperationHelper.java:289)
unifi-network-application | at com.mongodb.internal.async.function.RetryingSyncSupplier.get(RetryingSyncSupplier.java:67)
unifi-network-application | at com.mongodb.internal.operation.ListCollectionsOperation.execute(ListCollectionsOperation.java:175)
unifi-network-application | at com.mongodb.internal.operation.ListCollectionsOperation.execute(ListCollectionsOperation.java:73)
unifi-network-application | at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:153)
unifi-network-application | at com.mongodb.client.internal.MongoIterableImpl.execute(MongoIterableImpl.java:130)
unifi-network-application | at com.mongodb.client.internal.MongoIterableImpl.iterator(MongoIterableImpl.java:90)
unifi-network-application | at com.mongodb.client.internal.MongoIterableImpl.forEach(MongoIterableImpl.java:116)
unifi-network-application | at com.mongodb.client.internal.MappingIterable.forEach(MappingIterable.java:62)
unifi-network-application | at com.mongodb.client.internal.MappingIterable.into(MappingIterable.java:67)
unifi-network-application | at com.mongodb.client.internal.ListCollectionNamesIterableImpl.into(ListCollectionNamesIterableImpl.java:104)
unifi-network-application | at com.ubnt.service.system.aA.Objectsuper(Unknown Source)
unifi-network-application | at com.ubnt.service.system.aA.afterPropertiesSet(Unknown Source)
unifi-network-application | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853)
unifi-network-application | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1802)
unifi-network-application | ... 17 more