| *** puck has quit IRC | 00:37 | |
| *** puck has joined #openstack-dns | 00:41 | |
| *** diman has joined #openstack-dns | 04:18 | |
| *** diman has quit IRC | 04:23 | |
| *** bauruine has quit IRC | 05:15 | |
| *** Chealion has quit IRC | 05:15 | |
| *** Chealion has joined #openstack-dns | 05:16 | |
| *** bauruine has joined #openstack-dns | 05:21 | |
| *** trungnv has quit IRC | 06:20 | |
| *** pcaruana has joined #openstack-dns | 06:43 | |
| *** diman_ has joined #openstack-dns | 06:53 | |
| *** diman_ has quit IRC | 10:07 | |
| *** diman_ has joined #openstack-dns | 10:32 | |
| *** diman_ has quit IRC | 10:41 | |
| *** caowei has quit IRC | 10:43 | |
| *** pcaruana has quit IRC | 11:27 | |
| *** pcaruana has joined #openstack-dns | 11:39 | |
| *** pcaruana has quit IRC | 11:59 | |
| *** caowei has joined #openstack-dns | 12:05 | |
| *** caowei has quit IRC | 12:05 | |
| *** pcaruana has joined #openstack-dns | 12:12 | |
| *** MarkBaker has quit IRC | 12:50 | |
| *** rfreire has joined #openstack-dns | 13:03 | |
| *** MarkBaker has joined #openstack-dns | 13:16 | |
| rfreire | Morning Gringoes! o/ | 13:29 |
|---|---|---|
| *** MarkBaker has quit IRC | 13:47 | |
| mugsie | o/ | 13:50 |
| *** pcaruana has quit IRC | 15:13 | |
| *** b1tsh1ft3r has joined #openstack-dns | 15:18 | |
| b1tsh1ft3r | Hello all. Running into some issues with designate and powerDNS. It appears designate is looking to make the following SELECT statement when deleting a zone: [SQL: u'SELECT domains.id, domains.designate_id, and domains.designate_id doesnt exist... in either the designate or designate_pdns database that were created. | 15:19 |
| b1tsh1ft3r | Am i missing something obvious here? Im running ocata release of openstack and used the version avail from the openstack repo along with power dns version 3.4.11 which is what was avail via the repo. Anyone have any insight as to what might be wrong here? | 15:20 |
| b1tsh1ft3r | Full error can be seen here : http://paste.openstack.org/show/4mpfpwsBH3MOWP5m6FOb/ | 15:22 |
| b1tsh1ft3r | That was seen in the designate worker.log file ^^ | 15:26 |
| rfreire | b1tsh1ft3r, o/ ! | 15:28 |
| rfreire | b1tsh1ft3r, can you make a paste of your designate.conf ? | 15:28 |
| rfreire | b1tsh1ft3r, oooh boy; bailing out for customer lunch; gimmie a hour and half? Because... friday++ \o/ | 15:30 |
| *** b1tsh1ft3r has quit IRC | 15:31 | |
| rfreire | b1tsh1ft3r, if that helps, Designate 3.0.1 here: http://paste.openstack.org/show/720384/ | 15:31 |
| rfreire | oh he left | 15:31 |
| rfreire | :-P | 15:31 |
| * rfreire goes to the chopp time | 15:32 | |
| *** rfreire has quit IRC | 15:36 | |
| *** b1tsh1ft3r has joined #openstack-dns | 15:41 | |
| b1tsh1ft3r | rfreire sure! | 15:42 |
| *** bnemec is now known as beekneemech | 15:42 | |
| b1tsh1ft3r | @rfreire http://paste.openstack.org/show/dfa28RJ0PxOSNYuvv811/ | 15:44 |
| *** diman has joined #openstack-dns | 15:49 | |
| mugsie | b1tsh1ft3r: how did you create the powerDNS db ? | 15:51 |
| b1tsh1ft3r | Using powerdns docs. - https://doc.powerdns.com/md/authoritative/howtos/#basic-setup-configuring-database-connectivity | 15:53 |
| mugsie | (did you use designate-manage or use the powerdns provided schema?) | 15:53 |
| mugsie | ah | 15:53 |
| b1tsh1ft3r | Im guessing designate-manage powerdns sync <target_id> is whats supposed to be used here in this case? | 15:53 |
| mugsie | https://docs.openstack.org/designate/latest/admin/backends/powerdns.html | 15:53 |
| mugsie | yeah | 15:53 |
| b1tsh1ft3r | hmm | 15:54 |
| mugsie | any reason you are using pdns 3.x ? | 15:54 |
| *** diman has quit IRC | 15:54 | |
| b1tsh1ft3r | no tbh. thats just what was avail when i used yum from the repos (running ocata release) | 15:54 |
| b1tsh1ft3r | i did install 4.0.5 and had the same issue, but i figured it had to be either on the designate side or the db schema itself that pdns is hitting | 15:55 |
| mugsie | OK. pdns4 is what we recommend, as we no longer mess with the pdns schema | 15:55 |
| mugsie | we have a different driver for pdns4 | 15:55 |
| b1tsh1ft3r | ah ok | 15:55 |
| b1tsh1ft3r | so install pdns4 and run designate-manage powerdns sync <pool_id> ? | 15:55 |
| mugsie | for pdns4 just install as normal, and follow the pdns docs for the database | 15:56 |
| mugsie | then follow https://docs.openstack.org/designate/latest/admin/backends/pdns4.html | 15:56 |
| b1tsh1ft3r | So for pool id... where can i find this? | 15:57 |
| mugsie | designate manage pool generate_file --file /tmp/pools.yaml | 15:58 |
| mugsie | then the ID should be in that output | 15:59 |
| b1tsh1ft3r | Excellent, thank you for your insight | 16:00 |
| mugsie | np | 16:00 |
| mugsie | I am leaving the office now, but if you leave questions here, some of us will try and reply when we are connected :) | 16:01 |
| b1tsh1ft3r | Sounds good! Thanks again | 16:01 |
| *** diman has joined #openstack-dns | 16:01 | |
| *** diman has quit IRC | 16:10 | |
| b1tsh1ft3r | mugsie when you mention pdns4 you mean version >= 4.0.x | 16:25 |
| *** rfreire has joined #openstack-dns | 16:39 | |
| rfreire | b1tsh1ft3r, hi! | 16:39 |
| b1tsh1ft3r | Hi! | 16:40 |
| rfreire | b1tsh1ft3r, did you get any help? | 16:40 |
| b1tsh1ft3r | I did, however i still have a few questions. | 16:40 |
| rfreire | b1tsh1ft3r, if I can be of help... (which I doubt, but it'sok) | 16:40 |
| rfreire | Fire it | 16:40 |
| b1tsh1ft3r | Sounds like i need pdns4. i assume this is simple getting pdns verison 4.0.x from pdns site? | 16:40 |
| rfreire | ah | 16:40 |
| b1tsh1ft3r | or is this something entirely different? | 16:40 |
| * rfreire halts and catches fire | 16:41 | |
| *** AlexeyAbashkin has joined #openstack-dns | 16:43 | |
| rfreire | b1tsh1ft3r, sorry bud; I have only tested (I'm a end user) the BIND scenarios | 16:46 |
| rfreire | ;-/ | 16:46 |
| *** diman has joined #openstack-dns | 16:57 | |
| *** diman has quit IRC | 17:01 | |
| *** b1tsh1ft3r has quit IRC | 17:09 | |
| *** itlinux has joined #openstack-dns | 17:14 | |
| *** b1tsh1ft3r has joined #openstack-dns | 17:17 | |
| b1tsh1ft3r | so.... im a little confused with this. | 17:28 |
| b1tsh1ft3r | https://docs.openstack.org/designate/latest/admin/backends/pdns4.html | 17:28 |
| b1tsh1ft3r | Is step 2 supposed to be retro-fitted into an existing pools.yaml template? | 17:28 |
| * rfreire mira | 17:29 | |
| rfreire | b1tsh1ft3r, oh I think I know this one | 17:29 |
| rfreire | b1tsh1ft3r, first of all, which OpenStack version? | 17:29 |
| b1tsh1ft3r | ocata | 17:29 |
| rfreire | nice. | 17:29 |
| rfreire | is it red hat, suse, ..? | 17:29 |
| b1tsh1ft3r | Centos | 17:29 |
| rfreire | nice, RHT | 17:29 |
| rfreire | can you get me a | 17:29 |
| rfreire | # rpm -qa | grep designate ? | 17:30 |
| rfreire | just to see the designate version | 17:30 |
| * rfreire turns on his Newton environment | 17:30 | |
| b1tsh1ft3r | http://paste.openstack.org/show/720392/ | 17:30 |
| * rfreire mira | 17:30 | |
| rfreire | b1tsh1ft3r, just so I know, did you install Designate by using any recipe? | 17:31 |
| b1tsh1ft3r | nope. just yum install openstack-designate\* | 17:31 |
| rfreire | ok, DNSaaS version 4. nice, not too drifted from mine. | 17:31 |
| rfreire | b1tsh1ft3r, take a look at dis: | 17:31 |
| rfreire | https://access.redhat.com/documentation/en-us/red_hat_openstack_platform/10/html-single/dns-as-a-service_guide/ | 17:31 |
| rfreire | b1tsh1ft3r, your version is OSP 11, and I have not _tested_ that verison | 17:31 |
| rfreire | But in re: pools.yaml | 17:31 |
| rfreire | Check step 26 | 17:32 |
| rfreire | b1tsh1ft3r, in step 26, we create /etc/designate/pools.yaml with the suitable content for your system. | 17:32 |
| rfreire | THEN | 17:32 |
| rfreire | in step 29 | 17:32 |
| rfreire | su -s /bin/sh -c "designate-manage pool update" designate | 17:33 |
| rfreire | In step 29, it will READ your pools.yaml and UPDATE your database with the new YAML config | 17:33 |
| b1tsh1ft3r | ok | 17:33 |
| rfreire | Clear? :-) | 17:33 |
| rfreire | Did I help? | 17:33 |
| b1tsh1ft3r | so... would using this as a template (modifed) be an issue? | 17:33 |
| b1tsh1ft3r | https://docs.openstack.org/designate/latest/admin/pools.html#managing-pools | 17:33 |
| b1tsh1ft3r | its the only one i can find thats specific to powerdns | 17:33 |
| rfreire | by no means | 17:33 |
| rfreire | Craft yours | 17:34 |
| rfreire | That one in the kb fitted mine (and my custys, heh) | 17:34 |
| rfreire | but I pointed you just so you see how to use the yaml file | 17:34 |
| rfreire | so you write it | 17:34 |
| rfreire | define it | 17:34 |
| rfreire | run the designate-manage pool update | 17:34 |
| rfreire | And poof, your yml is production. | 17:34 |
| b1tsh1ft3r | https://docs.openstack.org/designate/latest/admin/backends/pdns4.html <--- i was referred to use this for pdns4 back end | 17:34 |
| b1tsh1ft3r | but appears step 2 of this should fit in the pools.yaml also? | 17:35 |
| rfreire | Try the one which works | 17:35 |
| rfreire | ;-D | 17:35 |
| b1tsh1ft3r | or atleast the missing configs (api content) | 17:35 |
| rfreire | b1tsh1ft3r, nutshell: | 17:35 |
| rfreire | 1. Write your YAML file (should be /etc/designate/pools.yaml), crafting your values | 17:36 |
| rfreire | 2. su -s /bin/sh -c "designate-manage pool update" designate | 17:36 |
| rfreire | <end< | 17:36 |
| rfreire | > | 17:36 |
| b1tsh1ft3r | i assume powerdns and designate should be using separate databses? | 17:50 |
| rfreire | b1tsh1ft3r, does powerdns uses a database? | 17:50 |
| rfreire | I don't know this tool | 17:50 |
| rfreire | bind does not | 17:50 |
| rfreire | if it uses yes, then it should be a different DB :-) | 17:50 |
| b1tsh1ft3r | Calling the designate-manage pool update designate fails | 17:53 |
| b1tsh1ft3r | RemoteError: Remote error: ProgrammingError (pymysql.err.ProgrammingError) (1146, u"Table 'designate.pools' doesn't exist") [SQL: u'SELECT pools.id, pools.created_at, pools.updated_at, pools.version, pools.name, pools.description, pools.tenant_id, pools.provisioner \nFROM pools \nWHERE pools.name = %(name_1)s AND (pools.tenant_id IS NULL OR pools.tenant_id IS NULL) \n LIMIT %(param_1)s'] [parameters: {u'name_1': u'default', u' | 17:53 |
| rfreire | wait | 17:54 |
| *** pcaruana has joined #openstack-dns | 17:54 | |
| rfreire | wait | 17:54 |
| rfreire | and wait | 17:54 |
| rfreire | b1tsh1ft3r, did you run: | 17:54 |
| rfreire | su -s /bin/sh -c "designate-manage database sync" designate | 17:54 |
| rfreire | su -s /bin/sh -c "designate-manage pool-manager-cache sync" designate | 17:55 |
| rfreire | after install? | 17:55 |
| b1tsh1ft3r | database was created (blank database with user and permissions) and designate.conf was configured and then yes i ran the first command which failed with what you see above | 17:55 |
| rfreire | read again | 17:55 |
| rfreire | designate-manage database sync | 17:55 |
| rfreire | and | 17:55 |
| rfreire | designate-manage pool-manager-cache sync | 17:55 |
| rfreire | -- | 17:56 |
| rfreire | these commands populates the database | 17:56 |
| *** diman has joined #openstack-dns | 17:56 | |
| rfreire | AFTER creating the pool yaml | 17:56 |
| rfreire | then, it is designate-manage pool update | 17:56 |
| rfreire | so these are three entirely different commands | 17:56 |
| rfreire | b1tsh1ft3r, take a look at this RHT configuration from here: https://access.redhat.com/documentation/en-us/red_hat_openstack_platform/10/html-single/dns-as-a-service_guide/#manual_dnsaas_installation | 17:57 |
| b1tsh1ft3r | ok so first command worked. 2nd failed | 17:57 |
| b1tsh1ft3r | su -s /bin/sh -c "designate-manage pool-manager-cache sync" designate | 17:58 |
| b1tsh1ft3r | 2018-05-04 13:57:44.527 15130 CRITICAL designate [designate-manage - - - - -] ValueError: Either database url or engine must be provided. | 17:58 |
| rfreire | b1tsh1ft3r, can you make a post of your designate.conf? | 17:59 |
| *** diman has quit IRC | 18:00 | |
| b1tsh1ft3r | http://paste.openstack.org/show/dfa28RJ0PxOSNYuvv811/ | 18:02 |
| * rfreire mira | 18:02 | |
| rfreire | b1tsh1ft3r, if you want to check mine: https://pastebin.com/0FcYpvSr | 18:03 |
| rfreire | b1tsh1ft3r, ha. Seems that you did not configure the SQL server for your pool manager | 18:04 |
| rfreire | mine: | 18:04 |
| rfreire | -- | 18:04 |
| rfreire | [pool_manager_cache:sqlalchemy] | 18:04 |
| rfreire | connection = mysql+pymysql://designate:Corinthians@172.25.250.79/designate_pool_manager | 18:04 |
| rfreire | -- | 18:04 |
| rfreire | yours: | 18:04 |
| rfreire | -- | 18:04 |
| rfreire | [pool_manager_cache:sqlalchemy] | 18:04 |
| rfreire | #connection = sqlite:///$state_path/designate_pool_manager.sqlite | 18:04 |
| rfreire | -- | 18:04 |
| rfreire | b1tsh1ft3r, follow that Red Hat step by step guide | 18:05 |
| rfreire | Really | 18:05 |
| rfreire | More things might be missing | 18:05 |
| rfreire | I have triple-checked that document | 18:05 |
| rfreire | and that's good for RHEL/CentOS | 18:05 |
| *** b1tsh1ft3r has quit IRC | 18:11 | |
| *** AlexeyAbashkin has quit IRC | 18:30 | |
| *** rfreire has quit IRC | 18:50 | |
| *** diman has joined #openstack-dns | 19:02 | |
| *** diman has quit IRC | 19:06 | |
| *** pcaruana has quit IRC | 19:10 | |
| *** rfreire has joined #openstack-dns | 19:45 | |
| *** b1tsh1ft3r has joined #openstack-dns | 19:59 | |
| *** diman has joined #openstack-dns | 20:00 | |
| b1tsh1ft3r | Ive managed to get pdns and designate somewhat working. Im running into issues still however. When a zone is created from designate dashboard, the worker.log appears to create but on removal it fails attempting to be authorized for the pdns web-server api. | 20:06 |
| b1tsh1ft3r | it states it is un-authorized | 20:06 |
| b1tsh1ft3r | 2018-05-04 16:06:38.470 16619 INFO designate.worker.tasks.zone [-] Failed to DELETE zone example.com. on target ec0b70d2-13eb-4a53-b942-0a966b525258 on attempt 9, Error: 401 Client Error: Unauthorized for url: http://127.0.0.1:8081/api/v1/servers/localhost/zones/example.co | 20:06 |
| rfreire | b1tsh1ft3r, hey! o/ | 20:06 |
| rfreire | b1tsh1ft3r, alrighto; question; your pdns runs in this very same server? | 20:07 |
| b1tsh1ft3r | yes, its a designate container with designate and pdns installed | 20:07 |
| rfreire | (in the same server as the Designate) | 20:07 |
| rfreire | hrnm okay. | 20:07 |
| rfreire | What about the keys | 20:07 |
| rfreire | Are they properly set? | 20:07 |
| b1tsh1ft3r | api key is defined in pdns.conf | 20:07 |
| rfreire | Okay another question | 20:08 |
| rfreire | When you create a zone | 20:08 |
| rfreire | Did you ran some dig tests | 20:08 |
| rfreire | in order to ensure that it was indeed properly created? | 20:08 |
| *** diman has quit IRC | 20:08 | |
| b1tsh1ft3r | yes | 20:08 |
| b1tsh1ft3r | they come back fine | 20:08 |
| rfreire | Hrnm. So your problem now lies on deleting a zone | 20:08 |
| rfreire | well | 20:08 |
| rfreire | ¯\_(ツ)_/¯ now I got clueless :-( | 20:09 |
| * rfreire does not knows powerdns | 20:09 | |
| rfreire | eandersson, ^ ? | 20:09 |
| rfreire | timsim, ^ ? | 20:10 |
| timsim | Almost certainly a powerdns config issue "401 Client Error: Unauthorized for url: http://127.0.0.1:8081/api/v1/servers/localhost/zones/example.co". The Designate code calling the powerdns API is getting that error. | 20:12 |
| rfreire | b1tsh1ft3r, ^ | 20:14 |
| b1tsh1ft3r | yeah its definately power dns | 20:15 |
| b1tsh1ft3r | the delete looks like its being triggered by designate for the zone but powerdns is...... not cooperating heh | 20:15 |
| rfreire | does a hug help? | 20:19 |
| * rfreire hugs powerdns | 20:19 | |
| rfreire | did that help?\ | 20:19 |
| mugsie | b1tsh1ft3r: I am on a phone, but did you set the pdns config from the page I send earlier? | 20:20 |
| mugsie | The webserver apikey and the then the same options in the pools.yaml for the server | 20:20 |
| rfreire | mugsie, the key seem to be fine, since it creates the zone | 20:21 |
| rfreire | mugsie, I asked if did he test, and after the zone is created, he tested and the pdns replied accordingly | 20:22 |
| mugsie | :/ | 20:22 |
| rfreire | mugsie, the problem seems to be in the deletion | 20:23 |
| rfreire | theres a commit about delete problems | 20:23 |
| rfreire | but in the commit, looks like designate fails silently | 20:24 |
| rfreire | commit defe3a8f29c70dcdb4d271613a3a32dbd3739a5a | 20:24 |
| rfreire | Author: Tim Simmons <tim.simmons@rackspace.com> | 20:24 |
| rfreire | Date: Fri Jan 29 17:21:06 2016 -0600 | 20:24 |
| rfreire | Actually poll for zone deletes | 20:24 |
| rfreire | -- | 20:24 |
| rfreire | - This originally failed in PowerDNS, because in older versions | 20:24 |
| rfreire | that are still in all the distro repos, PDNS responded with a | 20:24 |
| rfreire | NOERROR and empty answer section when it got a query for a zone | 20:24 |
| rfreire | it knew nothing about. NEAT. | 20:24 |
| rfreire | http://blog.powerdns.com/2015/03/02/from-noerror-to-refused/ | 20:24 |
| rfreire | -- | 20:24 |
| rfreire | But his version (4.0.0) does contains this commit as well | 20:25 |
| rfreire | Som as timsim told, it might be something in the pdns side. | 20:25 |
| b1tsh1ft3r | Ive tried many many guides manually (redhat, openstack docs, openstack-ansible guide). Nothing works with pdns sadly. each one has failed in a similar way. They seem to be able to poll but cannot actually manage | 20:27 |
| mugsie | That is weird, pdns is one of the DNS servers we test every commit against | 20:30 |
| mugsie | (we test bind9 and pdns4) | 20:30 |
| b1tsh1ft3r | is there any guide for installing specifically with pdns4 or configuring with pdns4 out there? The only ones i see are bind | 20:39 |
| *** rfreire has quit IRC | 20:42 | |
| *** b1tsh1ft3r has quit IRC | 20:55 | |
| *** diman has joined #openstack-dns | 20:57 | |
| *** diman has quit IRC | 21:02 | |
| *** itlinux has quit IRC | 21:47 | |
| *** brad[] has quit IRC | 21:50 | |
| *** diman has joined #openstack-dns | 21:54 | |
| *** diman has quit IRC | 21:59 | |
| *** abalutoiu_ has joined #openstack-dns | 22:08 | |
| *** abalutoiu__ has quit IRC | 22:11 | |
| *** rfreire has joined #openstack-dns | 22:17 | |
| *** brad[] has joined #openstack-dns | 22:33 | |
| *** rfreire has quit IRC | 22:55 | |
| *** diman has joined #openstack-dns | 22:59 | |
| *** diman has quit IRC | 23:04 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!