Tuesday, 2015-03-17

« Monday, 2015-03-16 Index Wednesday, 2015-03-18 »
andrewbogottbah, the ‘database_connection’ field must’ve been renamed and the docs disagree with the version I’m running00:00
*** pk_ has quit IRC00:02
*** pk_ has joined #openstack-dns00:02
*** pk__ has joined #openstack-dns00:06
*** pk_ has quit IRC00:06
*** MentalRay has joined #openstack-dns00:23
andrewbogottOh, and also the sqlalchemy setup is too broken to actually use with mysql anyway.  Sooooo, back to the defaults :(00:31
*** andrewbogott is now known as andrewbogott_afk00:32
*** pk__ has quit IRC00:52
*** rmoe has quit IRC00:57
*** MentalRay has quit IRC01:01
*** MentalRay_ has joined #openstack-dns01:01
*** rmoe has joined #openstack-dns01:11
*** EricGonczer_ has joined #openstack-dns01:13
*** pk_ has joined #openstack-dns01:17
*** GonZo2000 has quit IRC01:34
*** stanzgy has joined #openstack-dns01:36
*** stanzgy_ has joined #openstack-dns01:36
*** EricGonczer_ has quit IRC01:45
*** GonZo2000 has joined #openstack-dns02:20
*** richm has quit IRC02:26
*** stanzgy has quit IRC02:34
*** stanzgy has joined #openstack-dns02:34
*** boris-42 has quit IRC03:12
*** penick has joined #openstack-dns03:48
*** pk_ has quit IRC04:06
*** pk_ has joined #openstack-dns04:11
*** pk_ has quit IRC04:15
*** stanzgy has quit IRC04:37
*** stanzgy has joined #openstack-dns04:38
*** MentalRay_ has quit IRC04:47
*** pk_ has joined #openstack-dns05:37
*** pk__ has joined #openstack-dns05:47
*** pk_ has quit IRC05:47
*** pk_ has joined #openstack-dns05:47
*** pk__ has quit IRC05:51
*** pk_ has quit IRC05:58
openstackgerritOpenStack Proposal Bot proposed openstack/designate: Imported Translations from Transifex  https://review.openstack.org/16496206:40
*** pk_ has joined #openstack-dns07:09
*** pk_ has quit IRC07:13
*** MentalRay_ has joined #openstack-dns07:54
*** MentalRay_ has quit IRC07:54
*** GonZo2000 has quit IRC08:40
*** nkinder has quit IRC08:47
*** nkinder has joined #openstack-dns08:54
*** GonZo2000 has joined #openstack-dns08:58
*** GonZo2000 has joined #openstack-dns08:58
*** boris-42 has joined #openstack-dns08:59
*** jordanP has joined #openstack-dns09:03
*** GonZo2000 has quit IRC09:11
*** GonZo2000 has joined #openstack-dns09:20
*** GonZo2000 has joined #openstack-dns09:20
*** GonZo2000 has quit IRC10:19
*** GonZo2000 has joined #openstack-dns10:28
*** GonZo2000 has quit IRC10:34
*** stanzgy has quit IRC10:56
*** stanzgy_ has quit IRC10:56
*** untriaged-bot has joined #openstack-dns11:02
untriaged-botUntriaged bugs so far:11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143284211:02
openstackLaunchpad bug 1432842 in Designate "Property setters dont work." [Undecided,New]11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143285011:02
openstackLaunchpad bug 1432850 in Designate "Add periodic refresh task" [Undecided,New]11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/142566811:02
openstackLaunchpad bug 1425668 in Designate "Poor error message when using same database for designate and the pool manager cache" [Undecided,New]11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143285211:02
openstackLaunchpad bug 1432852 in Designate "Add periodic refresh task" [Undecided,New]11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143285111:02
openstackLaunchpad bug 1432851 in Designate "Add periodic refresh task" [Undecided,New]11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143283911:02
openstackLaunchpad bug 1432839 in Designate "Calling find_domain in any v1 operation is sub-optimal" [Undecided,New]11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143097611:02
openstackLaunchpad bug 1430976 in Designate "Pool Manager creates/deletes can go into an infinite loop" [Undecided,In progress] - Assigned to Tim Simmons (tim-simmons-t)11:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/142511711:02
openstackLaunchpad bug 1425117 in Designate "Designate does not work with postgres" [High,New]11:02
*** untriaged-bot has quit IRC11:02
*** puck has quit IRC11:52
*** puck has joined #openstack-dns11:56
*** puck has quit IRC12:44
*** puck has joined #openstack-dns12:49
*** puck has quit IRC13:16
*** elarson_ has joined #openstack-dns13:18
*** busterswt has joined #openstack-dns13:19
*** elarson_ has quit IRC13:21
*** richm has joined #openstack-dns13:24
*** puck has joined #openstack-dns13:24
*** elarson_ has joined #openstack-dns13:27
*** andrewbogott_afk is now known as andrewbogott13:28
openstackgerritMerged openstack/designate: Imported Translations from Transifex  https://review.openstack.org/16496213:32
openstackgerritMerged openstack/designate: Support secondary zones  https://review.openstack.org/13368213:33
openstackgerritMerged openstack/designate: MDNS part of Secondary zones  https://review.openstack.org/13368313:33
*** andrewbogott is now known as andrewbogott_afk13:33
openstackgerritGraham Hayes proposed openstack/designate: Add DESIGNATE_TOX_SQL_DEBUG toggle  https://review.openstack.org/16507013:36
*** andrewbogott_afk is now known as andrewbogott13:36
openstackgerritGraham Hayes proposed openstack/designate: Add API_v2 Adapter Objects  https://review.openstack.org/16432713:40
openstackgerritGraham Hayes proposed openstack/designate: Move the DesignateAdapter to return non-wrapped objects  https://review.openstack.org/16432613:40
openstackgerritGraham Hayes proposed openstack/designate: Add API_v1 Adapter Objects  https://review.openstack.org/16432813:40
openstackgerritGraham Hayes proposed openstack/designate: Add DESIGNATE_SQL_DEBUG toggle  https://review.openstack.org/16507013:44
openstackgerritGraham Hayes proposed openstack/designate: Add DESIGNATE_SQL_DEBUG toggle  https://review.openstack.org/16507013:47
*** elarson_ has quit IRC13:58
*** vinod1 has joined #openstack-dns14:04
*** paul_glass has joined #openstack-dns14:06
*** andrewbogott is now known as andrewbogott_afk14:12
*** andrewbogott_afk is now known as andrewbogott14:13
*** vinod1 has quit IRC14:22
*** vinod1 has joined #openstack-dns14:24
*** vinod1 has quit IRC14:31
*** MentalRay has joined #openstack-dns14:49
openstackgerritMerged openstack/designate: Add Tempest zone tests  https://review.openstack.org/16421814:49
andrewbogottdoes sink require that nova is using nova.openstack.common.notifier.rpc_notifier?  Or something else?  (So far sink isn’t noticing when I create instances)14:54
andrewbogottAh, the answer seems to be yes :)14:59
*** EricGonczer_ has joined #openstack-dns15:00
*** EricGonczer_ has quit IRC15:02
*** penick has quit IRC15:02
*** vinod1 has joined #openstack-dns15:12
*** crc32 has joined #openstack-dns15:17
*** crc32 has quit IRC15:18
*** crc32 has joined #openstack-dns15:19
*** pk_ has joined #openstack-dns15:21
*** crc32 has quit IRC15:28
*** pk_ has quit IRC15:32
*** pk_ has joined #openstack-dns15:33
*** pk_ has quit IRC15:48
*** EricGonczer_ has joined #openstack-dns16:03
*** EricGonczer_ has quit IRC16:03
*** pk_ has joined #openstack-dns16:13
*** MentalRay has quit IRC16:14
*** rmoe has quit IRC16:21
*** crc32 has joined #openstack-dns16:23
*** GonZo2000 has joined #openstack-dns16:32
*** GonZo2000 has joined #openstack-dns16:32
paul_glasswhen I do an import zone from a zone file, what is designate supposed to do with the serial number I pass in? It looks like it gets replace with one generated by designate (which seems necessary).16:35
*** GonZo2000 has quit IRC16:35
*** andrewbogott is now known as andrewbogott_afk16:35
mugsiepaul_glass: yup, thats correct16:35
*** MentalRay has joined #openstack-dns16:35
mugsienot ideal maybe, but we need to to allow the rest of designate to work properly16:36
paul_glasscool16:38
*** pk_ has quit IRC16:38
*** rmoe has joined #openstack-dns16:39
paul_glassDesignate doesn't seem to like when I import a zone file with NS records in it.16:40
*** GonZo2000 has joined #openstack-dns16:43
*** GonZo2000 has quit IRC16:44
mugsieyeah.... it wont... i thought we had stuff in to fix that though16:44
timsimDid this happen? I don't recall: https://github.com/openstack/designate-specs/blob/master/specs/kilo/zone-import-refactor.rst16:45
timsimYes, it seems it did16:46
timsimhttps://review.openstack.org/#/c/133681/16:46
*** penick has joined #openstack-dns16:47
*** andrewbogott_afk is now known as andrewbogott16:49
paul_glassI'm seeing something like this: http://paste.openstack.org/show/192933/16:54
paul_glassremoving the NS record works just fine, although the nameserver specified in the soa is replaced with one of the nameservers stored in desginate.16:55
openstackgerritKiall Mac Innes proposed openstack/designate: Move Pool nameservers to to own table  https://review.openstack.org/16514617:01
Kialltimsim: it did from memory17:01
*** untriaged-bot has joined #openstack-dns17:02
untriaged-botUntriaged bugs so far:17:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143284217:02
openstackLaunchpad bug 1432842 in Designate "Property setters dont work." [Undecided,New]17:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143285017:02
openstackLaunchpad bug 1432850 in Designate "Add periodic refresh task" [High,New] - Assigned to Endre Karlson (endre-karlson)17:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/142566817:02
openstackLaunchpad bug 1425668 in Designate "Poor error message when using same database for designate and the pool manager cache" [Undecided,New]17:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143283917:02
openstackLaunchpad bug 1432839 in Designate "Calling find_domain in any v1 operation is sub-optimal" [Medium,New] - Assigned to Endre Karlson (endre-karlson)17:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/143097617:02
openstackLaunchpad bug 1430976 in Designate "Pool Manager creates/deletes can go into an infinite loop" [Undecided,In progress] - Assigned to Tim Simmons (tim-simmons-t)17:02
untriaged-bothttps://bugs.launchpad.net/designate/+bug/142511717:02
openstackLaunchpad bug 1425117 in Designate "Designate does not work with postgres" [High,New]17:02
*** untriaged-bot has quit IRC17:02
*** GonZo2000 has joined #openstack-dns17:05
*** GonZo2000 has quit IRC17:06
openstackgerritKiall Mac Innes proposed openstack/designate: Move Pool nameservers to to own table  https://review.openstack.org/16514617:09
*** GonZo2000 has joined #openstack-dns17:09
*** GonZo2000 has joined #openstack-dns17:09
*** GonZo2000 has quit IRC17:10
andrewbogottHm… I have all the designate pieces up and running and talking to each other, but I’m getting all kinds of db errors.  ‘database-init’ and ‘database-sync’ claim that all is well.17:12
*** MentalRay_ has joined #openstack-dns17:12
andrewbogottThe very first API call, creating a server, returns Unknown backend failure: OperationalError('(OperationalError) (1054, "Unknown column \'designate_id\' in \'field list\'")',)17:13
andrewbogottAm I missing some db setup stage?17:13
Kiallandrewbogott: error looks like powerdns? There's a second DB for it and matching designate-manage commands to stand it up17:14
*** MentalRay has quit IRC17:15
andrewbogottKiall: ok, that sounds promising17:16
Kialldesignate-manage powerdns init17:16
Kialldesignate-manage powerdns sync <- Sounds like your on Juno? Thiose would be them17:16
andrewbogotticehouse, but, yeah, that’s clearly it.17:17
andrewbogottNow I have to hunt down a dba to give me rights to create a table :)17:17
KiallOuch!17:17
andrewbogottour main dba lives 14 timezones away from me, it’s a constant source of hilarity17:17
KiallIt's basically the stock powerdns schema, with some extra columns to let us track the data17:18
*** pk_ has joined #openstack-dns17:29
*** jordanP has quit IRC17:33
openstackgerritKiall Mac Innes proposed openstack/designate: Move Pool NS Records to their own table  https://review.openstack.org/16514617:45
ekarlsoKiall: you not out on the bottle ?17:46
KiallNo, I've been hiding from distraction to actually get something done ;)17:46
ekarlsoKiall: meaning your target stuff ? :D17:47
KiallYep17:49
ekarlsoKiall: ping me when you are done with it17:49
ekarlsoso I can do the also_notify stuff and dyn17:49
andrewbogottKiall: ah, running into the same problem I ran into yesterday… the database-sync scripts don’t work with mysql :(17:49
andrewbogottYesterday I had that problem with the main designate db so ripped out msql and reverted to sqlite.  I guess I’ll have to do that with pdns as well.17:50
andrewbogottMy dreams of having a stable, replicated db for this are dashed17:50
KiallDon't work with MySQL?17:50
andrewbogottnah, it tries to create the same table in two point revisions, which I guess sqlite is tolerant of?17:51
KiallCould you possibly be using the same MySQL DB for both the Designate and PowerDNS DB's?17:51
KiallOh, I think you end up with 2x SQLite DB files by default17:51
andrewbogotthttps://dpaste.de/ru5t17:52
andrewbogottwell, ok.  So there’s the designate db (which is sqlite currently)17:52
andrewbogottthen there’s pdns, which has a db17:52
KiallYea, they have to be separate mysql/sqlite/pgsql etc databases17:53
andrewbogottand then there’s a setting in the designate config for a pdns database.  /that/ is the same one that actual pdns uses, right?17:53
andrewbogottFor a total of two dbs, correct?17:53
KiallYes, actual PDNS and designate's [backend:powerdns] section connection string are the same DB17:53
andrewbogottok, in that case I’m doing things right.17:53
KiallOh, did you create the DB schema for powerdns by hand, probably according to their docs?17:54
andrewbogottKiall: yes.17:54
KiallThat's it I bet :) We have DB migrations to build that schema for you, because we have some additional columns on a few of the tables to track things17:54
andrewbogottBut for the designate db I started with a totally empty one, and database-sync errored out on that as well, with roughly the same error.17:55
*** csoukup has joined #openstack-dns17:55
KiallThat's odd, it certainly does work when you have 2 databases (e.g. "designate" and "powerdns"), point designate at them both, and pdns itself only at the powerdns DB17:56
*** penick has quit IRC17:56
andrewbogottWell, I’m using icehouse, I figured I was just mired in a use case that was never actually tested.17:56
KiallIt's tested ;) www.hpcloud.com/products-services/dns <-- Icehouse with PowerDNS17:57
Kiallwell - was icehouse, juno now.. But it was icehouse for a good length on time.17:57
*** MentalRay_ has quit IRC17:58
andrewbogottKiall: very first run of designate-manage dastabase-sync with empty databases:  https://phabricator.wikimedia.org/P40418:00
andrewbogotttrying to set an external field between two tables where the field had a different data type18:00
KiallHumm, I wonder if a backport broke something :/18:01
andrewbogottbut anyway, that’s a battle I already surrendered — I will wipe all my tables in the pdns database and see if things go better with that migration script18:01
andrewbogottBut… after lunch :)18:01
KiallOh, I remember something like this..18:01
KiallOn your DB - Is the default charset set to utf8?18:02
andrewbogottI don’t know, but probably.18:02
Kiallcurrent versions of oslo.db (or is it sqla-migrate?) exit straight away if your DB default charset is not UTF8, mysql defaults to latin1_ci18:03
andrewbogottok, I’ll check18:03
andrewbogottGotta run now, but thank you for your help!18:03
*** andrewbogott is now known as andrewbogott_afk18:03
harmwhm, do I need a pool-manager these days to talk to bind9?18:06
harmwand even a mdns service?18:06
harmwapi+central+sink+bind9 seem to just work though (though its not picking up events from either nova or neutron yet)18:08
*** penick has joined #openstack-dns18:18
*** penick has left #openstack-dns18:18
timsimharmw: On master, yes18:26
harmwthis is a single node designate deployment, so I'd be installing mdns and pool-man as well?18:27
harmwand that would be a rquirement for having designate act to new instances/ports created?18:28
mugsieharmw: yes. but they are lightwieght enough to all run togther on ther machine18:29
*** MentalRay_ has joined #openstack-dns18:30
harmwok18:30
harmwtime to rebuild an rpm first, wasn't prepared for these new bits :)18:30
*** GonZo2000 has joined #openstack-dns19:01
*** MentalRay_ has quit IRC19:05
*** andrewbogott_afk is now known as andrewbogott19:13
*** andrewbogott is now known as andrewbogott_afk19:13
*** andrewbogott_afk is now known as andrewbogott19:14
*** andrewbogott has joined #openstack-dns19:15
*** andrewbogott has quit IRC19:17
*** andrewbogott has joined #openstack-dns19:17
andrewbogottKiall: looks like I have root on this db after all.  What should I check regarding utf8?19:20
Kiallandrewbogott: this http://paste.openstack.org/show/192964/19:28
Kiallif you get latin1 or similar back, some of old icehouse migrations would accept the default, and others would explicitly specify UTF8, resulting in pain and suffering for creating FK's19:29
andrewbogottok — my designate db is utf8.  So that wasn’t it.19:30
andrewbogottthe pdns db says “/*!40100 DEFAULT CHARACTER SET binary */“ which I take to be correct.19:30
andrewbogottSo, I’m going to do this once more while you’re watching :)  First I will ‘drop table xxx’ for each table in the pdns db…19:31
KiallDamn :/ Pulling down icehouse to check that happens for me..19:31
andrewbogottok, now the pdns db is empty.  Now I’ll init and sync…19:31
andrewbogottKiall:  Here’s me trying to set up the pdns db.  Similar issues.  https://dpaste.de/EBJZ19:33
KiallWell, that one's an access denied from MySQL?19:34
Kiall"INDEX command denied to user 'pdns_admin'@'10.64.0.165' for table 'records'") 'CREATE INDEX nametype_index ON records (name, type)"19:34
andrewbogottAh, so it is.19:35
andrewbogottHm, I’m clearly not rigorous here, getting different behavior every time I try this.19:35
Kiall2015-03-17 19:35:56.900 INFO designate.manage.database [-] Database synchronized successfully19:37
Kiall2015-03-17 19:37:00.013 INFO designate.manage.powerdns [-] PowerDNS database synchronized successfully19:37
Kiallworked on stable/icehouse for me with these as the only conf options set: http://paste.openstack.org/show/192965/19:38
KiallMaybe different mysql versions? And we do something your version doesn't like?19:40
andrewbogottKiall: ok, I have the pdns db syncing properly.  Lemme return to the designate db and see what happens if I start from scratch.19:41
Kiallhttp://paste.openstack.org/show/192967/ is the schema I ended up with after running both19:41
KiallOn L314, the dump switches from the "designatetest" to "pdnstest" DB's - rather than all in 119:42
andrewbogotthm, can’t convince designate-manage to stop using sqlite.19:45
andrewbogottoh right, it used to be called ‘database_connection'19:46
andrewbogottdammit19:47
andrewbogottKiall, everything is working now.  Thanks to your over-the-shoulder effect I guess.19:47
Kialllol - no problem :)19:47
KiallYea - olso.db switch (I thought tha was after icehouse tho?) made us rename that option :(19:48
andrewbogottis pool_manager_cache something I should be paying attention to?19:48
timsimandrewbogott: Not on Juno.19:49
andrewbogottgreat19:49
andrewbogottWait, meaning it’s the future, or the past?19:49
timsimIt's introduced/used in Kilo19:50
andrewbogottah, ok.19:50
andrewbogottthanks19:50
KiallAnd, chances are you would back that with memcache rather than sql ;)19:52
*** MentalRay_ has joined #openstack-dns19:52
andrewbogottKiall: ok, now I can read/write things via REST.   So, big progress!  Are you interested in seeing my next error, or do you need to get on with your life?20:04
KiallJust about to walk out of the office! :)20:06
andrewbogottfair enough20:07
KiallYep! And it's National Drinking Day.. I mean St. Patricks Day here in Ireland ;)20:07
andrewbogottfor possible onlookers, here’s the error I get when sink tries to create an entry:  “badly formed hexadecimal UUID string”  https://dpaste.de/k1wx20:08
andrewbogottKiall: you’re getting an awfully late start.  Hope you make it count!20:08
*** nkinder has quit IRC20:18
*** andrewbogott is now known as andrewbogott_afk20:19
*** nkinder has joined #openstack-dns20:20
*** vinod1 has quit IRC20:33
*** boris-42 has quit IRC20:42
*** MentalRay_ has quit IRC20:56
*** vinod1 has joined #openstack-dns21:01
*** MentalRay_ has joined #openstack-dns21:02
*** EricGonc_ has joined #openstack-dns21:14
*** EricGonc_ has quit IRC21:18
*** vinod1 has quit IRC21:27
*** busterswt has quit IRC21:29
*** crc32 has quit IRC21:43
*** paul_glass1 has joined #openstack-dns21:53
*** paul_glass has quit IRC21:54
*** csoukup has quit IRC22:11
*** paul_glass1 has quit IRC22:12
*** crc32 has joined #openstack-dns22:29
*** MentalRay__ has joined #openstack-dns22:33
*** MentalRay__ has quit IRC22:33
*** MentalRay_ has quit IRC22:35
*** crc32 has quit IRC23:39
*** crc32 has joined #openstack-dns23:44
« Monday, 2015-03-16 Index Wednesday, 2015-03-18 »

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!