have issue while enable LUA script

[AndrewWasef]

Hi gus,
I have successfully installed powerdns server version 5.0.0 over ubuntu 24.0 LTS
Also i installed lua package but when i run lua scripts it didn't work with me

1. Log debug error

Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module = gmysql
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module-dir = /usr/lib/x86_64-linux-gnu/pdns
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: Loading '/usr/lib/x86_64-linux-gnu/pdns/libgmysqlbackend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Loading '/usr/lib/x86_64-linux-gnu/pdns/libgmysqlbackend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [gmysqlbackend] This is the gmysql backend version 5.0.0-alpha0.2629.master.ga1d98155e (Feb 14 2025 11:39:43) reporting
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module = lua2
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module-dir = /usr/lib/x86_64-linux-gnu/pdns
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: Loading '/usr/lib/x86_64-linux-gnu/pdns/liblua2backend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Loading '/usr/lib/x86_64-linux-gnu/pdns/liblua2backend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [lua2backend] This is the lua2 backend version 5.0.0-alpha0.2629.master.ga1d98155e (Feb 14 2025 11:39:43) reporting
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module = bind
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module-dir = /usr/lib/x86_64-linux-gnu/pdns
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: Loading '/usr/lib/x86_64-linux-gnu/pdns/libbindbackend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Loading '/usr/lib/x86_64-linux-gnu/pdns/libbindbackend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [bind2backend] This is the bind backend version 5.0.0-alpha0.2629.master.ga1d98155e (Feb 14 2025 11:39:43) (with bind-dnssec-db support) reporting
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module = lmdb
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: module-dir = /usr/lib/x86_64-linux-gnu/pdns
Feb 27 14:16:25 pdns5 pdns_server[1207894]: BackendMakerClass: Loading '/usr/lib/x86_64-linux-gnu/pdns/liblmdbbackend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Loading '/usr/lib/x86_64-linux-gnu/pdns/liblmdbbackend.so'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [lmdbbackend] This is the lmdb backend version 5.0.0-alpha0.2629.master.ga1d98155e (Feb 14 2025 11:39:43) reporting
Feb 27 14:16:25 pdns5 pdns_server[1207894]: This is a standalone pdns
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Listening on controlsocket in '/run/pdns/pdns.controlsocket'
Feb 27 14:16:25 pdns5 pdns_server[1207894]: UDP server bound to 0.0.0.0:53
Feb 27 14:16:25 pdns5 pdns_server[1207894]: UDP server bound to [::]:53
Feb 27 14:16:25 pdns5 pdns_server[1207894]: TCP server bound to 0.0.0.0:53
Feb 27 14:16:25 pdns5 pdns_server[1207894]: TCP server bound to [::]:53
Feb 27 14:16:25 pdns5 pdns_server[1207894]: PowerDNS Authoritative Server 5.0.0-alpha0.2629.master.ga1d98155e (C) PowerDNS.COM BV
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Using 64-bits mode. Built using gcc 13.3.0 on Feb 14 2025 11:39:43 by root@localhost.
Feb 27 14:16:25 pdns5 pdns_server[1207894]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [webserver] Listening for HTTP requests on 0.0.0.0:8081
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [stub-resolver] Doing stub resolving for 'auth-5.0.0-alpha0.2629.master.ga1d98155e.security-status.secpoll.powerdns.com.|TXT', using resolvers: 8.8.8.8
Feb 27 14:16:25 pdns5 pdns_server[1207894]: [stub-resolver] Question for 'auth-5.0.0-alpha0.2629.master.ga1d98155e.security-status.secpoll.powerdns.com.|TXT' got answered by 8.8.8.8
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Not validating response for security status update, this is a non-release version
Feb 27 14:16:25 pdns5 pdns_server[1207894]: gmysql Connection successful. Connected to database 'powerdns' on 'localhost'.
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Unable to read configuration file from 'powerdns-luabackend.lua': No such file or directory
Feb 27 14:16:25 pdns5 pdns_server[1207894]: Caught an exception instantiating a backend (lua2), cleaning up
Feb 27 14:16:25 pdns5 pdns_server[1207894]: STL Exception while filling the zone cache: No such file or directory
Feb 27 14:16:25 pdns5 systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE

2. pdns.conf

launch=gmysql,lua2
gmysql-host=localhost
gmysql-user=pdns
gmysql-password=powerdns passwrod
gmysql-dbname=powerdns
api=yes
api-key=your_secure_api_key
webserver=yes
webserver-port=8081
webserver-address=0.0.0.0

#enable-lua-records=yes
lua-prequery-script=/etc/powerdns/scripts/dns_lookup.lua
#lua-nodata-script=/etc/powerdns/scripts/nodata.lua
# Enable logging
logging-facility=0
loglevel=9
log-dns-queries=yes
log-dns-details=yes
query-logging=yes
local-address=0.0.0.0, ::

3. powerdns-luabackend.lua

-- 1- Logging (log_query)
local function log_query(uid, remote_ip, qname, qtype)
    local log_path = "/var/log/pdns_uid.log"
    local file = io.open(log_path, "a")

    if file then
        local log_entry = string.format(
            "[%s] UID: %s | Remote IP: %s wants '%s|%s', do = 0, bufsize = 1232: packetcache MISS\n",
            os.date("%Y-%m-%d %H:%M:%S"), uid, remote_ip, qname, qtype:getName()
        )
        file:write(log_entry)
        file:close()
    else
        pdnslog("❌ Failed to open UID log file: " .. log_path, pdns.loglevels.Error)
    end
end



-- 2- Access Control & Validation (is_ip_allowed, validate_digits, get_enum_domain)
local allowed_domains = {
    ["en-164enum."] = { allowed_ips = {"10.2.10.117", "10.2.10.228"}, digit_limit = 12 },
    ["pr-164enum."] = { allowed_ips = {"10.2.10.117", "10.2.10.226"}, digit_limit = 12 }
}

local function is_ip_allowed(remote_ip, domain)
    if not allowed_domains[domain] then return false end
    for _, allowed_ip in ipairs(allowed_domains[domain].allowed_ips) do
        if remote_ip == allowed_ip then return true end
    end
    return false
end

local function validate_digits(qname, domain)
    local digits = {}
    for digit in string.gmatch(tostring(qname), "[0-9]") do
        table.insert(digits, digit)
    end
    return #digits == allowed_domains[domain].digit_limit
end

local function get_enum_domain(qname)
    local parts = {}
    for part in string.gmatch(tostring(qname), "[^.]+") do
        table.insert(parts, part)
    end
    if #parts >= 3 then
        return table.concat({parts[#parts-2], parts[#parts-1], parts[#parts]}, ".")
    end
    return nil
end
- 3- Database Queries (get_record_id)
local luasql = require "luasql.mysql"
local env = luasql.mysql()

local function get_record_id(qname)
    local conn = env:connect("powerdns", "dbuser", "password", "10.2.10.156", 3306)
    if not conn then
        pdnslog("❌ Database connection failed", pdns.loglevels.Error)
        return nil
    end

    local query = string.format("SELECT id FROM records WHERE LOWER(name) = LOWER('%s') LIMIT 1", qname)
    pdnslog("🔍 Executing SQL: " .. query, pdns.loglevels.Info)

    local cursor = conn:execute(query)
    local record_id = nil

    if cursor then
        local row = cursor:fetch({}, "a")
        if row then
            record_id = tonumber(row.id)
            pdnslog("✅ Record found! ID: " .. tostring(record_id), pdns.loglevels.Info)
        else
            pdnslog("⚠️ No record found for: " .. qname, pdns.loglevels.Warning)
        end
        cursor:close()
    else
        pdnslog("❌ SQL Query execution failed!", pdns.loglevels.Error)
    end

    conn:close()
    return record_id
end



-- 4- Unique ID Generation (generate_unique_id)
local function generate_unique_id(qname)
    local record_id = get_record_id(qname)
    if not record_id then return nil end

    local rand1 = string.format("%04d", math.random(0, 9999))
    local rand2 = string.format("%04d", math.random(0, 9999))
    local rand3 = string.format("%04d", math.random(0, 9999))

    return string.format("%d-%s-%s-%s", record_id, rand1, rand2, rand3)
end

[miodvallat]

Your logs mention

Unable to read configuration file from 'powerdns-luabackend.lua': No such file or directory

Be sure to check that this file is either located in the same directory as pdns.conf or that you are using a fully qualified path to refer to it in the lua2-filename configuration setting.

[AndrewWasef]

I make sure that my file name and path are correct as pdns.conf

[Bodenhaltung]

I make sure that my file name and path are correct as pdns.conf

Can you please set lua2-filename=/etc/powerdns/powerdns-luabackend.lua to the location of your powerdns-luabackend.lua script please?