Comments on Elastician: Using RDS in Boto

Oops. I found where I made the mistake. I didn...

2009-12-01T10:54:24.784-05:00

Oops. I found where I made the mistake. I didn't refresh my get_all_dbinstances

Hi Mitch how do you remove an rds? I tried: rds.d...

2009-12-01T10:49:00.834-05:00

Hi Mitch how do you remove an rds?
I tried:

rds.delete_dbinstance('dbdev',True,'')

but it still shows up in the list.

Thanks again,

Dean

Oh, and it's security_groups, not security_gro...

2009-11-05T16:09:21.288-05:00

Oh, and it's security_groups, not security_group.

You need to pass in a list of security groups or s...

2009-11-05T16:08:56.848-05:00

You need to pass in a list of security groups or security group names. That was the change I made, The docs were a little unclear. So, try:

inst2 = rds.modify_dbinstance(id='dbdev', security_group=['linkage'])

Mitch

Thanks Mitch. I just tried it and I get the follo...

2009-11-05T15:24:47.092-05:00

Thanks Mitch. I just tried it and I get the following error when I try to modify the instance.
I created a new connection and then tried:

inst2 = rds.modify_dbinstance(id='dbdev', security_group='linkage')

TypeError: modify_dbinstance() got an unexpected keyword argument 'security_group'

Is this not how I would change the security group?

Thanks again,

Dean

Just checked in a fix to both problems (they were ...

2009-11-05T13:36:28.426-05:00

Just checked in a fix to both problems (they were related). Thanks for pointing it out.

Mitch

thanks mitch

2009-11-05T12:56:21.724-05:00

thanks mitch

Sounds like a boto issue. I'm wondering if th...

2009-11-05T12:17:56.012-05:00

Sounds like a boto issue. I'm wondering if there is a problem in setting the sec group in the first place, too. Let me try to reproduce here and fix if necessary.

Hi Mitch, It looks like it is set to default inste...

2009-11-05T11:14:15.528-05:00

Hi Mitch,
It looks like it is set to default instead of the one I created. How do I modify this? I tried:
inst2 = rds.modify_dbinstance(id='dbdev', security_group='linkage') but I get a global name 'backup_retention_period' is not defined error

Can you confirm that the DBInstance is actually in...

2009-11-05T07:29:40.888-05:00

Can you confirm that the DBInstance is actually in the DBSecurityGroup that you created? Try doing a get_all_dbinstances() and then checking the security_group attribute.

Nope. It resolves to an ip address but it times o...

2009-11-04T09:41:29.701-05:00

Nope. It resolves to an ip address but it times out.

connect to address ###.###.###.###: Operation timed out

Any thoughts? Thanks again

Can you telnet to that host/port? That would tell...

2009-11-04T07:01:56.759-05:00

Can you telnet to that host/port? That would tell us whether it's a connectivity problem or a MySQL problem.

I tried to connect to the new rds but it says come...

2009-11-03T23:38:14.245-05:00

I tried to connect to the new rds but it says comes back with the following message:

MySQL said: Can't connect to MySQL server on 'dbdev.crwrstqvz17c.us-east-1.rds.amazonaws.com'

I use the CIDR 9#.2##.2##.1##/32 to allow my ip to test out accces to the new rds database. It says that it is ready but I can't connect. Am I missing something? I used the master user I setup as the user and it's password but no luck. Also how do I use the ModifyDBInstance of the API in boto? I will want to add another security group to the db once I'm done testing from my machine here. Thanks again for a great python product to help do this.

Yes, it's in GB. Valid values are from 5-1024...

2009-11-03T16:00:24.648-05:00

Yes, it's in GB. Valid values are from 5-1024.

thanks for the help with the cidr format.

2009-11-03T15:56:37.935-05:00

thanks for the help with the cidr format.

One more questions. Is the allocated_storage in Gb...

2009-11-03T15:56:01.531-05:00

One more questions. Is the allocated_storage in Gb? Just trying to setup an rds to see what we can do with it and our applications.

It would be something like this: sg.authorize(cid...

2009-11-03T15:27:03.799-05:00

It would be something like this:

sg.authorize(cidr_ip='0.0.0.0/0')

Obviously, you would probably want to limit the CIDR block a bit more than that.

How would you do this with a CIDR group?

2009-11-03T14:43:39.250-05:00

How would you do this with a CIDR group?