Re: [Pdns-users] mysql has gone away

2014-09-17 Thread chayes
Oh wait! I misunderstood ... cur is the cursor. Do I need to close all three as below? env = assert (luasql.mysql()) con = assert (env:connect ("dbname", "dbuser", "dbpassword", "127.0.0.1", 3306)) cur = assert (con:execute ("SELECT count(*) from whiteList where wldomain = '"..strDomain3.."'")) ro

Re: [Pdns-users] mysql has gone away

2014-09-17 Thread chayes
Thanks! added to my script (cur is the DB handle): cur:close() That appears to have worked! -- View this message in context: http://powerdns.13854.n7.nabble.com/mysql-has-gone-away-tp10974p10978.html Sent from the PowerDNS mailing list archive at Nabble.com. __

Re: [Pdns-users] mysql has gone away

2014-09-16 Thread chayes
Positive. This is a new server with no users yet so I am still testing. Logs show no activity in between tests. Nothing else running on the server. Two servers both with the identical problem. Nothing wrong with mysql. Many others have had this problem based on my search but they don't specify whic

[Pdns-users] mysql has gone away

2014-09-16 Thread chayes
I am running pdns-recursor version 3.6 In low-usage times (approx 1.5 hours of no activity) I start seeing the "mysql has gone away" errors and pdns becomes sluggish and unresponsive. I searched the archives and see recommendations to increase mysql wait times, but there is never an indication of w

[Pdns-users] lua variables

2013-09-12 Thread chayes
I'd like to isolate the domain inside of an lua script. I know about the "domain" variable ... but it can contain subdomain like "alt1-safebrowsing.google.com." Is there a variable that only contains the "google.com" in the above example? Or do I have to do the string manipulation to get it? -

Re: [Pdns-users] Why is pdns searching for NS records at the sub-domain level?

2013-09-05 Thread chayes
well if I am running authoritative and recursive on the same server, won't the authoritative only pass a request if it can't handle it ? that way the white listed sites get handled by the authoritative via the database and the recursive only gets what's left ... the sites to reject. Is that right

Re: [Pdns-users] Why is pdns searching for NS records at the sub-domain level?

2013-09-05 Thread chayes
Aki, That sounds like a good solution but I don't know how to implement it. Could you please be more specific with examples? I have not gotten nxdomain to work and don't know how to send the CNAME. Thanks, Cliff -- View this message in context: http://powerdns.13854.n7.nabble.com/Why-is-pdns

Re: [Pdns-users] Why is pdns searching for NS records at the sub-domain level?

2013-09-05 Thread chayes
John, You are correct. I am trying to build a white-list dns. So for example, if I wanted to white-list cnn.com then I would have sufficient domains and records in the pdns database to cover it (corrected info below). And if a user attempted to browse to a site that was not allowed, like gamb

Re: [Pdns-users] Why is pdns searching for NS records at the sub-domain level?

2013-09-04 Thread chayes
More details as requested: I am currently running both of the following on the same server running Scientific Linux 6.4: PowerDNS Authoritative Server 3.3 PowerDNS recursor 3.5.2 I have an empty hint file because I want all requests to fail except for what I have in the pdns database. pdns.conf h

[Pdns-users] Why is pdns searching for NS records at the sub-domain level?

2013-09-03 Thread chayes
I am trying to get wildcard working. I notice that pdns is querying the database looking for NS records at the subdomain level, which I did not expect. I have only seen NS records exist at the domain level and that is how our DNS server is set up. This behavior is preventing me from being able to i