Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
Where do I get the database name, username and password on my web app
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jamie Soon
125
Reputation points
Hi,
I would like to install the CMS, Expression Engine on my web app. But first I'm going to run EE wizard to test the server. I'm not sure what details to key in as my database name, username and password. Where do I get this information? Thank you.
I found some mysql database information under environment variables>connection strings, but I'm getting an error when I run the Expression Engine Test.
https://jamiesoonwebsite-afc4a4bhh0fyf2c8.eastasia-01.azurewebsites.net/ee_wizard/
regards
Jamie
Azure App Service
-
Jamie Soon 125 Reputation points
2025-04-13T08:23:50.8966667+00:00 Hi,
I tried putting in the info from the connection string but I'm getting this error when I run the Expression Engine Wizard.
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /home/site/wwwroot/ee_wizard/index.php:249 Stack trace: #0 /home/site/wwwroot/ee_wizard/index.php(249): PDO->__construct('mysql:host=jami...', 'nnezqappyr', Object(SensitiveParameterValue), Array) #1 /home/site/wwwroot/ee_wizard/index.php(131): check_db(Array) #2 {main} thrown in /home/site/wwwroot/ee_wizard/index.php on line 249
Attached some screenshots. What seems to be the problem. Is it how I set up the server configuration. Is selecting PHP stack ok? Thank you.
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti 785 Reputation points Microsoft External Staff Moderator2025-04-15T00:43:07.54+00:00 Hi Jamie Soon,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Jamie Soon 125 Reputation points
2025-04-15T07:05:04.65+00:00 Thanks Prasad,
The expression engine tech support said they are not familiar with Azure but gave us a new index.php file to replace in the EE wizard. I have uploaded to github but I'm still getting this error message.
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /home/site/wwwroot/ee_wizard_new/index.php:250 Stack trace: #0 /home/site/wwwroot/ee_wizard_new/index.php(250): PDO->__construct('mysql:host=jami...', 'nnezqappyr', Object(SensitiveParameterValue), Array) #1 /home/site/wwwroot/ee_wizard_new/index.php(131): check_db(Array) #2 {main} thrown in /home/site/wwwroot/ee_wizard_new/index.php on line 250
But I haven't tried the other things you suggested like checking MySQL server configuration and firewall rules. Attached some screenshots and the updated index.php file. Here is the link to the updated eewizard.
https://webdesigner4theworld.com/ee_wizard_new
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
Jamie Soon 125 Reputation points
2025-04-17T08:40:45.25+00:00 Thanks Siva, can you clarify for the last 2 steps, provide a screenshot where I can download CA certificate.. and if I'm using github desktop, do I just create an SSL folder in my html folder...? thanks
- You should download the CA certificate and upload it to your App Service (e.g., in
/home/site/wwwroot/ssl/). - Update the path in
index.phpaccordingly.
- You should download the CA certificate and upload it to your App Service (e.g., in
-
Jamie Soon 125 Reputation points
2025-04-18T01:58:09.1933333+00:00 I'm going to cancel the web app and try setting the website up on a Azure Virtual Machine, so that I can get back the 'traditional' web hosting environment setup. Hopefully it works.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2025-04-22T01:37:28.73+00:00 Hi Jamie Soon
Can you download the SSL from here ssl-certificate and then update the below path in index.php as per the path where the certificate is stored inside wwwroot.
PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/Do let me know if you have implemented virtual machine for environment works fine for you, If it does, Please share it so that other people who faces similar issue may get benefitted from it.
Thanks
-
Jamie Soon 125 Reputation points
2025-04-22T02:49:39.39+00:00 Thanks Siva. It works! Thank goodness......
Attached screenshots..
This is the code I added
PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/DigiCertGlobalRootCA.crt.pem', // Update this path to where you've uploaded the cert PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, // Only use this for testing!I haven't tried it on a Virtual Machine yet. Looks like there's alot of work like setting up Apache, MySQL, DNS zone...
-
Anonymous
2025-04-22T03:24:56.43+00:00 Hi Jamie Soon,
Glad that you got your issue resolved, Thanks for sharing back, this will really help other member who has similar issue, Thanks again.
Sign in to comment
1 answer
Sort by: Oldest
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more