sparse-intern-71089
03/29/2022, 8:34 AMwonderful-motherboard-66151
03/29/2022, 8:44 AM@pulumi/azure-native
and @pulumi/mysql
packages… The problem only appears with the defined objects from @pulumi/mysql
wonderful-motherboard-66151
03/29/2022, 9:05 AM@pulumi/azure-native
, but I also want to add users and grant them some permissions, which seems to be only possible with `@pulumi/mysql``billowy-army-68599
wonderful-motherboard-66151
03/30/2022, 7:16 AMmysql
command on the command linewonderful-motherboard-66151
03/30/2022, 1:34 PMpulumi up -d
in here? Secrets should not be shown there, right? Maybe that would help finding the error?billowy-army-68599
pulumi up -v=9 --logtostderr
wonderful-motherboard-66151
03/30/2022, 5:36 PMwonderful-motherboard-66151
03/30/2022, 5:37 PMwonderful-motherboard-66151
03/30/2022, 5:37 PMconst databaseServer = new dbformysql.Server(
key,
{
properties: {
administratorLogin: config.requireSecret("database_user"),
administratorLoginPassword: databaseRootPassword,
createMode: "Default",
sslEnforcement: "Disabled", // TODO should not be necessary
storageProfile: {
storageAutogrow: "enabled",
storageMB: 5120,
},
version: "8.0",
},
resourceGroupName: resourceGroup.name,
sku: {
name: "B_Gen5_1",
},
}
);
wonderful-motherboard-66151
03/30/2022, 5:38 PMpulumi up
wonderful-motherboard-66151
03/30/2022, 5:38 PMconst mysqlProvider = new mysql.Provider('mysql', {
endpoint: databaseServer.fullyQualifiedDomainName as pulumi.Output<string>,
username: databaseServer.administratorLogin as pulumi.Output<string>,
password: databaseRootPassword,
});
wonderful-motherboard-66151
03/30/2022, 5:40 PMconst database = new mysql.Database(
databaseName,
{
name: databaseName,
},
{
provider: mysqlProvider,
}
);
wonderful-motherboard-66151
03/30/2022, 5:40 PMbillowy-army-68599
wonderful-motherboard-66151
03/30/2022, 5:49 PMmysql
command. Is that enough? Or do I have to use netcat/telnet? And I am going to doublecheck, tried quite some stuff until now 😄wonderful-motherboard-66151
03/30/2022, 5:50 PMmysql -h <host> -u <user> -p
command workswonderful-motherboard-66151
03/30/2022, 5:51 PMwonderful-motherboard-66151
03/30/2022, 5:52 PMwonderful-motherboard-66151
03/30/2022, 5:55 PMbillowy-army-68599
wonderful-motherboard-66151
03/30/2022, 5:59 PMwonderful-motherboard-66151
03/30/2022, 5:59 PMwonderful-motherboard-66151
03/30/2022, 6:00 PMbillowy-army-68599
const mysqlProvider = new mysql.Provider('mysql', {
endpoint: databaseServer.fullyQualifiedDomainName as pulumi.Output<string>,
username: databaseServer.administratorLogin as pulumi.Output<string>,
password: databaseRootPassword,
});
Can you try defining the provider with hardcoded values instead of the outputs, to eliminate that from the equationwonderful-motherboard-66151
03/30/2022, 6:10 PMadministratorLogin
returned is missing the part after the @
that is shown in portal.azure.com? 🤔wonderful-motherboard-66151
03/30/2022, 6:11 PMadministratorLogin
would contain the correct username and that I would get a more specific error if the credentials are wrong…billowy-army-68599
pulumi.Output<string>
btw, but glad that helped figure it out. you can use pulumi.interpolate
to add the @
wonderful-motherboard-66151
03/30/2022, 6:17 PMwonderful-motherboard-66151
03/30/2022, 6:17 PMbillowy-army-68599
!
wonderful-motherboard-66151
03/30/2022, 6:22 PMwonderful-motherboard-66151
03/30/2022, 6:23 PMbillowy-army-68599