crud operations posting to "test" database (Cosmosdb/Mongodb - Nextjs with mongoose)

rwkd26 21

I am using Nextjs with mongoose to perform crud operations in my cosmosdb/mongodb database. But when i post or get data they are posted to a database called "test" and not the database i want to. I cant find a solution for changing the destination to where my data is posted. any help?

Anurag Sharma 17,606 Reputation points

2021-02-15T05:54:51.113+00:00

Hi @rwkd26 , welcome to Microsoft Q&A forum.

Can you tell us where are you defining the endpoints of Azure Cosmos DB and provide the code snippet, databases should be defined there as well? Normally in Next js it should be something like below:

Referenced Article: https://parveensingh.com/next-js-node-app-with-cosmos-db/
rwkd26 21 Reputation points

2021-02-15T06:17:39.313+00:00

with MONGO_URI being the primary connection string provided in the portal (its the same implementation provided in a video published to azure youtube page)
Anurag Sharma 17,606 Reputation points

2021-02-15T07:23:38.6+00:00

Thanks for replying back.

MONGO_URI is the environment variable which must be defined in any of the files. If we check that it must be appended with 'test' database name as mentioned in below screenshot(link). We need to change this value to the database we want to use:

Meanwhile could you please provide the link of YouTube video you mentioned?
rwkd26 21 Reputation points

2021-02-15T07:36:58.75+00:00

Checked the uri and the dbname is the one provided in the portal and changing it to any other name will cause an error. Can't find the word "test" in the uri and thus my confusion. While working with mongodb on its own i can specify the database, but when using mongoose thats where i have the problem.

As for the youtube link: https://www.youtube.com/playlist?list=PLLasX02E8BPAZSRAR5IYS62CGQsfvcubW
this is the link for the playlist
Anurag Sharma 17,606 Reputation points

2021-02-16T06:36:04.657+00:00

Thanks for providing the link. I am checking this and will get back at the earliest.

Accepted answer

Anurag Sharma 17,606 Reputation points

2021-02-16T19:00:15.703+00:00
Hi @@rwkd26 ,

I was looking into the youtube video link you provided but could not get much out of it. Then there was this link which is having more insight.

Instead of declaring the entire connection string in 'MONGO_URI' variable can you please create below variables. You can provide the database name which you want to use:

COSMOSDB_USER = "<Azure Cosmos account's user name, usually the database account name>" COSMOSDB_PASSWORD = "<Azure Cosmos account password, this is one of the keys specified in your account>" COSMOSDB_DBNAME = "<Azure Cosmos database name>" COSMOSDB_HOST= "<Azure Cosmos Host name>" COSMOSDB_PORT=10255

Post this you can use the below code to connect:

mongoose.connect("mongodb://"+process.env.COSMOSDB_HOST+":"+process.env.COSMOSDB_PORT+"/"+process.env.COSMOSDB_DBNAME+"?ssl=true&replicaSet=globaldb", { auth: { user: process.env.COSMOSDB_USER, password: process.env.COSMOSDB_PASSWORD }, useNewUrlParser: true, useUnifiedTopology: true, retryWrites: false })

All this is mentioned in the same article I provided link for.

Please let me know if this works, or else we can discuss more.
Please sign in to rate this answer.
rwkd26 21 Reputation points

2021-02-16T20:27:02.797+00:00

The solution worked. Thank you for providing it appreciated.

Anurag Sharma 17,606 Reputation points

2021-02-17T07:27:45.133+00:00

Really glad it worked for you. Thanks for the confirmation.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

crud operations posting to "test" database (Cosmosdb/Mongodb - Nextjs with mongoose)

0 additional answers

Your answer