https://pulumi.com
Join Slack
This message was deleted.
# getting-started
s
This message was deleted.
w
Ah, and by the way, I am using the 
@pulumi/azure-native
and 
@pulumi/mysql
packages… The problem only appears with the defined objects from 
@pulumi/mysql
And I know that I can create databases using 
@pulumi/azure-native
, but I also want to add users and grant them some permissions, which seems to be only possible with `@pulumi/mysql``
b
is your database accessible from where you're running pulumi from?
w
@billowy-army-68599 I am running pulumi on my local machine, and there I can access it via the 
mysql
command on the command line
Is it save to paste the output from 
pulumi up -d
in here? Secrets should not be shown there, right? Maybe that would help finding the error?
b
you would need 
pulumi up -v=9 --logtostderr
w
It just seems to time out, from what I see there is no helpful log message…
Just to give you a gist: I create a database like that:
Copy code
const 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",
		},
	}
);
Then I added a few firewall rules, so that it is accessible from my local machine, on which I also run 
pulumi up
Afterwards I create mysql provider:
Copy code
const mysqlProvider = new mysql.Provider('mysql', {
	endpoint: databaseServer.fullyQualifiedDomainName as pulumi.Output<string>,
	username: databaseServer.administratorLogin as pulumi.Output<string>,
	password: databaseRootPassword,
});
Then I try to create a database as follows (this is the first thing not working):
Copy code
const database = new mysql.Database(
		databaseName,
		{
			name: databaseName,
		},
		{
			provider: mysqlProvider,
		}
	);
@billowy-army-68599 Am I making some kind of stupid beginner’s error?
b
you can reach the database with netcat/telnet the mysql command line from the box you're running Pulumi from?
w
I am running the command on my local machine, where I can access the database using the 
mysql
command. Is that enough? Or do I have to use netcat/telnet? And I am going to doublecheck, tried quite some stuff until now 😄
Yeah, using the 
mysql -h <host> -u <user> -p
command works
(Have neither netcat nor telnet installed, would that make a difference?)
It does not matter that I am using the pulumi service, right? The way I understood it, the communication with azure is happening via my machine anyway.
@billowy-army-68599 If that does not help at all, I am happy to create a (minimal) repro github repository for you to try
b
can you share the code you used to define the database too?
w
There’s no other object created by me that I would call a database 🙂
b
ah i see now
Copy code
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 equation
w
It’s running, but the username changed… Is it possible that the 
administratorLogin
returned is missing the part after the 
@
that is shown in portal.azure.com? 🤔
Yeah, that seems to be the issue… Thought the 
administratorLogin
would contain the correct username and that I would get a more specific error if the credentials are wrong…
b
you shouldn't need to cast as 
pulumi.Output<string>
btw, but glad that helped figure it out. you can use 
pulumi.interpolate
to add the 
@
w
Had to cast it, because the return type of administratorLogin seems to be `Output<string|undefined>`…
Will try to get it running and get back to you 🙂
b
oh, just ensure it's defined with 
!
w
With interpolate it’s not necessary anymore anyway 🙂 But I was also confused by the fact that it can be undefined… Is that a peculiarity of azure?
But anyway, thank you very much for your help!
b
yup, that's coming from the azure api definition
5 Views
Open in Slack
PreviousNext
Powered by

Pulumi Community

No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.

Powered by