Hi, I had some time to test the suggested procedure with our current setup (Debian Sarge with "2.9.17-13sarge3"-pdns-packets). When using "launch=gmysql:first, gmysql:second" in the config-file, pdns fails at all. When using launch=gmysql,gmysql:second gmysql-host=127.0.0.1 gmysql-second-host=127.0.0.1 gmysql-user=pdns gmysql-second-user=pdns gmysql-password=XXX gmysql-second-password=XXX gmysql-dbname=newdns gmysql-second-dbname=pdns
where XXX is just anonymized, I get the following in the logs: Mar 22 16:55:08 ns2 pdns[19182]: PowerDNS 2.9.17 (C) 2001-2005 PowerDNS.COM BV (Nov 11 2006, 11:34:36) starting up Mar 22 16:55:08 ns2 pdns[19182]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the t erms of the GPL version 2. Mar 22 16:55:08 ns2 pdns[19182]: Set effective group id to 102 Mar 22 16:55:08 ns2 pdns[19182]: Set effective user id to 100 Mar 22 16:55:08 ns2 pdns[19182]: DNS Proxy launched, local port 55929, remote 127.0.0.1:53 Mar 22 16:55:08 ns2 pdns[19182]: Launched webserver on XXX:8081 Mar 22 16:55:08 ns2 pdns[19182]: Creating backend connection for TCP Mar 22 16:55:08 ns2 pdns[19182]: gmysql Connection succesful Mar 22 16:55:08 ns2 pdns[19182]: Caught an exception instantiating a backend, cleaning up Mar 22 16:55:08 ns2 pdns[19182]: TCP server is unable to launch backends - will try again when questions come in: Undefined but needed argument: 'gmysqlsecond--basic-query' Mar 22 16:55:08 ns2 pdns[19182]: About to create 3 backend threads Mar 22 16:55:08 ns2 pdns[19182]: gmysql Connection succesful Mar 22 16:55:08 ns2 pdns[19182]: Caught an exception instantiating a backend, cleaning up There is something which makes me thinking of an coding error: gmysqlsecond--basic-query => should IMHO at least be gmysql-second-basic-query . Even if setting the one or other possibility with values stated in the docs => gmysql-second-basic-query=select content,ttl,prio,type,domain_id,name from records where type='%s' and name='%s' brings no success... :-/ Could anybody help and/or give a solution for operating 2 gmysql-databases on the same server (as stated in my initial posting)? TIA and greetings Tobias > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Montag, 11. Dezember 2006 13:34 > To: Tobias Orlamuende > Cc: pdns-users > Subject: Re: [Pdns-users] Some details for multiple (gmysql) backends > > On Mon, Dec 11, 2006 at 01:16:37PM +0100, Tobias Orlamuende wrote: > > > Since we need to implement a new provisioning-tool, we're thinking > > about using two backends (gmysql) with different DBs on the same > > server for the time of implementation and migration. The > new DB will > > be feed by the provisioning tool and should run with higher > priority > > when answering requests so that e.g. older and/or wrong > entries in the > > old DB (the currently existing one) will not be used. The > old DB would > > be freed of the entries which are available in the new one > from time > > to time and will be replaced totally by the new one on a > certain day. > > That should "just work". Do however make sure that the > database that has the 'domains' table entry for a domain also > has the records, as that is what PowerDNS assumes! > > To configure this way, use: > launch=gmysql:first, gmysql:second > > And then configure with: > gmysql-first-dbname= and gmysql-second-dbname= etc. > > I may be off a bit, check doc.powerdns.com for detauls > > > Now my question(s): Is it possible to do it that way and if > yes, how > > could that priority-thing being configured? > > The first configured backend gets the first shot to answer. > If the data isn't there, the next one will be queried. > > Good luck! > > -- > http://www.PowerDNS.com Open source, database driven DNS > Software > http://netherlabs.nl Open and Closed source services _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
