1. Home
2. php - Symfony - Azure Vault for DB password

639 votes

1 answers

php - Symfony - Azure Vault for DB password

Get the solution ↓↓↓

Is it possible to use Azure Vault to store MySQL DB credentials in Symfony? Right now the credentials are stored in an .env file (encrypted) but there's a request to use Azure Key Vault instead. I've never heard about such a setup, is it possbile at all?

Undefined asked

2021-09-3

Write your answer

---

79

votes

Answer

Solution:

There is no official PHP SDK for Azure keyvault, you could call the REST API - to store the MySQL DB credentials directly as secrets in the keyvault. If you want to retrieve them, use to do that.

There are some prerequisites to call the rest apis.

1.Register an application with Azure AD and create a service principal.

2.Get values for signing in and create a new application secret.

3.Add the service principal to the keyvault access policy with correct secret permissions.

4.Use the AAD client credential flow to get the token, then call the rest api.

Here is a sample wrapper of calling the rest apis, you could refer to it. See Add secret and Get secret.

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-09-3

Link To Source
Link To Answer People are also looking for solutions of the problem: the requested url was not found on this server. xampp

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

233 php - Symfony3 Form Error - A form with an empty name cannot have a parent form

583 php - Proper nested array to JSON formatting for API curl post

672 [PHP][MySQL] How to implement a title field for each selected file in an upload form?

933 php - How to select the Typeform API on a hidden field?

725 PHP 5.4 code update - Creating default object from empty value warnings in foreach and objects array

42 php - What way is better to use date with timzone for clients

182 php - Laravel 5.6: Eloquent + DB::Builder query array indexes

779 php - Laravel form array validation doesn't work

356 php - foreach function in JSON returning only one row

889 php - How do you avoid the same data in foreach, on sequential data?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Symfony

Symfony compares favorably with other PHP frameworks in terms of reliability and maturity. This framework appeared a long time ago, in 2005, that is, it has existed much longer than most of the other tools we are considering. It is popular for its web standards compliance and PHP design patterns.
https://symfony.com/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/