CODEWITHSUNDEEP
c#asp.net-web-apicassandraazure-web-app-servicedatastax-astra
Venkatesh
Venkatesh

Reputation: 299

Astra Datastax - Asp.net core - Secure Connect Bundle (Zip file) working in local but not when published to azure app service

We have created a simple asp.net core API to consume the database from Astra DataStax using a secure connect bundle(Zip file with certs and other information). It is working in the local as expected, however, when publishing to azure app service it is not working, but throw's the below error.

An unhandled exception was thrown by the application. Exception: System.AggregateException: One or more errors occurred. (There was an error fetching the metadata information from the Cloud Metadata Service (https://yourdb.db.astra.datastax.com:31977/metadata). Please make sure your cluster is not parked or terminated. See inner exception for more details.) ---> Cassandra.NoHostAvailableException: There was an error fetching the metadata information from the Cloud Metadata Service

we have checked the DB which is working(Not parked or terminated) and no issues when connecting from local.

Here is the code we are using to connect to the DB to establish a session.

 private async Task<ISession> ConnectToAstra(string username, string password, string keyspace, string secureConnectBundlePath)
    {
        var session = await Cluster.Builder()
                   .WithCloudSecureConnectionBundle(secureConnectBundlePath)
                   .WithCredentials(username, password)
                   .WithQueryOptions(new QueryOptions().SetConsistencyLevel(ConsistencyLevel.LocalQuorum))
                   .Build()
                   .ConnectAsync(keyspace);

        return session;
    }

Note: We have validated the path of the bundle after publishing in Azure App service and also tried moving the Secure bundle to wwwroot folder as well, but no luck.

Upvotes: 3

Views: 769

Answers (1)

Erick Ramirez
Erick Ramirez

Reputation: 16353

The error you posted indicates that your app is not able to reach any of the Astra nodes so it couldn't get the cluster metadata such as schema and topology.

This is most likely a network connectivity issue with your app and your Astra instance. Note that VPC peering is only available on Classic Astra databases and it is not available for dev and test databases.

If you provide more info on what you mean by "no issues when connecting from local", it will give us additional insight and I'll be happy to update my answer. Cheers!

Upvotes: 0

Related Questions