MySQL concerns ... ?

Dos Wizard <[email protected]> Thu, 14 Jul 2011 03:25:31 +0300
Newsgroups gmane.network.dns.bind9.dlz
Message-ID <[email protected]> 
This is a multi-part message in MIME format.
--===============6903250144580794578==
Content-Type: multipart/alternative;
	boundary="------------030003080605070308000302"

This is a multi-part message in MIME format.
--------------030003080605070308000302
Content-Type: text/plain; charset=ISO-8859-7
Content-Transfer-Encoding: 7bit

 Hello,

I have read your documentation, but I still have questions ...

Assuming that I have read your documentation, how I would know what bind is looking for? e.g.

dlz "Mysql zone" {
   database "mysql
   {host=localhost dbname=dns_data ssl=tRue}
   {select zone from dns_records where zone = '%zone%'}
   {select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
        else data end from dns_records where zone = '%zone%' and host = '%record%'
        and not (type = 'SOA' or type = 'NS')}
   {select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
        from dns_records where zone = '%zone%' and (type = 'SOA' or type='NS')}
   {select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
        minimum from dns_records where zone = '%zone%' and not (type = 'SOA' or type = 'NS')}
   {select zone from xfr_table where zone = '%zone%' and client = '%client%'}
   {update data_count set count = count + 1 where zone ='%zone%'}";
};


Your main paradigm, doesn't have something which pinpoints if bind should use the A or the B query. So assuming that I have customized tables to my own way, how I could be sure that it would work, if I can't distinguish the needed queries?

Best Regards
Nick

--------------030003080605070308000302
Content-Type: text/html; charset=ISO-8859-7
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-7">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    Hello,<br>
    <br>
    I have read your documentation, but I still have questions ...<br>
    <br>
    Assuming that I have read your documentation, how I would know what
    bind is looking for? e.g.<br>
    <br>
    <meta http-equiv="content-type" content="text/html;
      charset=ISO-8859-7">
    <table align="CENTER">
      <tbody>
        <tr>
          <td>
            <pre class="config_sample" style="font: xx-small Courier;">dlz "Mysql zone" {
   database "mysql
   {host=localhost dbname=dns_data ssl=tRue}
   {select zone from dns_records where zone = '%zone%'}
   <font color="RED">{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
        else data end from dns_records where zone = '%zone%' and host = '%record%'
        and not (type = 'SOA' or type = 'NS')}</font>
   <font color="GREEN">{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
        from dns_records where zone = '%zone%' and (type = 'SOA' or type='NS')}</font>
   <font color="BLUE">{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
        minimum from dns_records where zone = '%zone%' and not (type = 'SOA' or type = 'NS')}</font>
   <font color="DARKVIOLET">{select zone from xfr_table where zone = '%zone%' and client = '%client%'}</font>
   <font color="DARKTURQUOISE">{update data_count set count = count + 1 where zone ='%zone%'}";</font>
};</pre>
          </td>
        </tr>
      </tbody>
    </table>
    <p></p>
    <br>
    Your main paradigm, doesn't have something which pinpoints if bind
    should use the A or the B query. So assuming that I have customized
    tables to my own way, how I could be sure that it would work, if I
    can't distinguish the needed queries?<br>
    <br>
    Best Regards<br>
    Nick<br>
  </body>
</html>

--------------030003080605070308000302--


--===============6903250144580794578==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric 
Ries, the creator of the Lean Startup Methodology on "Lean Startup 
Secrets Revealed." This video shows you how to validate your ideas, 
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
--===============6903250144580794578==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers

--===============6903250144580794578==--