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
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.
__
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
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
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?
-
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
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
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
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
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
10 matches
Mail list logo