[Pdns-users] Pdns-users Digest, Vol 204, Issue 17

[Thomas Mieslinger]

Please check contents of your mysql user table and check if the pdns
user has a name or ip set from which the user is allowed to login.

I run my mysqls with --skip-name-resolve to avoid circle dependencies
(user can only login if dns works, dns works only if pdns user an login
to mysql).

On 28.01.20 19:09, Satya Sharma wrote:
> Reverse DNS does not have any impact with MySQL host. You should check
> the MySQL configuration in it my.cnf file for the host. If MySQL was
> bind with any IP that time you should use the same or reconfigure it.
>
> You should have tried to login from CLI using mysql - u user -p -h hostIP
>
> If all were okay then PDNS should also be able to connect.
>
> One other concern could be port conflict.
>
> On Tue, 28 Jan 2020 at 5:30 PM, <pdns-users-request at mailman.powerdns.com
> <mailto:pdns-users-request at mailman.powerdns.com>> wrote:
>     Hi guys,
>     I have an error on the authoritative server I tried some things but
>     nothing
>     substantial follows error, Distributor caught fatal exception: Unable to
>     launch gmysql connection: Unable to connect to database: Can't
>     connect to
>     local MySQL server through socket '/ var / run / mysqld /
>     mysqld.sock '(2),
>     gmysql configuration was pointing to localhost, I changed it to
>     127.0.0.1
>     according to the pdns manual, I don't know if that was exactly the
>     problem,
>     today I checked the logs and no longer had an error message. even though
>     this DNS error was apparently working, the only thing we noticed was
>     that
>     the reverse of the IPs was not correct on sites like speedtest, what
>     would
>     be the impact on pdns without accessing mysql? does this impact on the
>     reverse of the ip blocks?