[rh] powerdns + gmysql backend werkt niet?

[Ankh]

Ik heb hier thuis powerdns draaien om wat te testen.

code:

launch=gmysql
  gmysql-host=127.0.0.1
  gmysql-user=pdns
  gmysql-dbname=pdns

dat heb ik bij mijn pdns.conf staan.

dan krijg ik dus deze fout melding

code:

[root@o4c root]# /etc/rc.d/init.d/pdns monitor
pdns: Apr 25 22:43:57 This is a standalone pdns
Apr 25 22:43:57 Opened file '/etc/powerdns/pdns.conf' for configuration
Apr 25 22:43:57 UDP server bound to 62.212.76.219:53
Apr 25 22:43:57 TCP server bound to 62.212.76.219:53
Apr 25 22:43:57 PowerDNS 2.9.7 (C) 2001-2003 PowerDNS.COM BV (Mar 20 2003, 13:09:58) starting up
Apr 25 22:43:57 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.
Apr 25 22:43:57 Creating backend connection for TCP
% Apr 25 22:43:57 gmysql Connection failed: Unable to connect to database: Access denied for user: '@linspare' to database 'pdns'
Apr 25 22:43:57 Caught an exception instantiating a backend, cleaning up
Apr 25 22:43:57 TCP server is unable to launch backends - will try again when questions come in: Unable to launch gmysql connection: Unable to connect to database: Access denied for user: '@linspare' to database 'pdns'
Apr 25 22:43:57 About to create 3 backend threads
Apr 25 22:43:57 gmysql Connection failed: Unable to connect to database: Access denied for user: '@linspare' to database 'pdns'
Apr 25 22:43:57 Caught an exception instantiating a backend, cleaning up
Apr 25 22:43:57 gmysql Connection failed: Unable to connect to database: Access denied for user: '@linspare' to database 'pdns'
Apr 25 22:43:57 Caught an exception instantiating a backend, cleaning up
Apr 25 22:43:57 gmysql Connection failed: Unable to connect to database: Access denied for user: '@linspare' to database 'pdns'
Apr 25 22:43:57 Caught an exception instantiating a backend, cleaning up
Apr 25 22:43:58 Done launching threads, ready to distribute questions

http://doc.powerdns.com/configuring-db-connection.html

Ik heb eerst:

code:

GRANT SELECT ON supermasters TO pdns;
GRANT ALL ON domains TO pdns;
GRANT ALL ON records TO pdns;

Dit werkte niet, toen heb ik gewoon de user pdns aangemaakt waarbij dus alleen xs heeft tot de tabel pdns

Ook dit werkte niet.

[edit]

ik kan ook nergens een gmysql faq/man vinden.
Want wanneer ik gmysql-user=root gebruik dan komt ie met een scherm van using password=no. Dus misschien leek het me om een password te gebruiken

[ Voor 12% gewijzigd door Ankh op 25-04-2003 22:56 ]

[HGM]

Ik heb in mijn config toch echt staan: gmysql-password={PASSWORD}

En dat lijkt ook overeen te komen met de foutmelding

[Ankh]

code:

[root@o4c powerdns]# /etc/rc.d/init.d/pdns monitor
pdns: Apr 26 21:23:08 This is a standalone pdns
Apr 26 21:23:08 Opened file '/etc/powerdns/pdns.conf' for configuration
Apr 26 21:23:08 UDP server bound to 62.212.76.219:53
Apr 26 21:23:08 TCP server bound to 62.212.76.219:53
Apr 26 21:23:08 PowerDNS 2.9.7 (C) 2001-2003 PowerDNS.COM BV (Mar 20 2003, 13:09
:58) starting up
Apr 26 21:23:08 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free softwar
e, and you are welcome to redistribute it according to the terms of the GPL vers
ion 2.
Apr 26 21:23:08 Creating backend connection for TCP
% Apr 26 21:23:08 gmysql Connection failed: Unable to connect to database: Acces
s denied for user: 'pdns@linspare' (Using password: YES)
Apr 26 21:23:08 Caught an exception instantiating a backend, cleaning up
Apr 26 21:23:08 TCP server is unable to launch backends - will try again when qu
estions come in: Unable to launch gmysql connection: Unable to connect to databa
se: Access denied for user: 'pdns@linspare' (Using password: YES)
Apr 26 21:23:08 About to create 3 backend threads
Apr 26 21:23:08 gmysql Connection failed: Unable to connect to database: Access
denied for user: 'pdns@linspare' (Using password: YES)
Apr 26 21:23:08 Caught an exception instantiating a backend, cleaning up
Apr 26 21:23:08 gmysql Connection failed: Unable to connect to database: Access
denied for user: 'pdns@linspare' (Using password: YES)
Apr 26 21:23:08 Caught an exception instantiating a backend, cleaning up
Apr 26 21:23:08 gmysql Connection failed: Unable to connect to database: Access
denied for user: 'pdns@linspare' (Using password: YES)
Apr 26 21:23:08 Caught an exception instantiating a backend, cleaning up
Apr 26 21:23:08 Done launching threads, ready to distribute questions

Ik heb nu password erbij gezet,maar werkt ook niet. Wat kan er nog meer fout gaan?

code:

[root@o4c powerdns]# /etc/rc.d/init.d/pdns monitor
pdns: Apr 26 21:30:55 This is a standalone pdns
Apr 26 21:30:55 Opened file '/etc/powerdns/pdns.conf' for configuration
Apr 26 21:30:55 UDP server bound to 62.212.76.219:53
Apr 26 21:30:55 TCP server bound to 62.212.76.219:53
Apr 26 21:30:55 PowerDNS 2.9.7 (C) 2001-2003 PowerDNS.COM BV (Mar 20 2003, 13:09:58) starting up
Apr 26 21:30:55 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.
Apr 26 21:30:55 Creating backend connection for TCP
% Apr 26 21:30:55 gmysql Connection failed: Unable to connect to database: Access denied for user: 'pdns@o4c' (Using password: YES)
Apr 26 21:30:55 Caught an exception instantiating a backend, cleaning up
Apr 26 21:30:55 TCP server is unable to launch backends - will try again when questions come in: Unable to launch gmysql connection: Unable to connect to database: Access denied for user: 'pdns@o4c' (Using password: YES)
Apr 26 21:30:55 About to create 3 backend threads
Apr 26 21:30:55 gmysql Connection failed: Unable to connect to database: Access denied for user: 'pdns@o4c' (Using password: YES)
Apr 26 21:30:55 Caught an exception instantiating a backend, cleaning up
Apr 26 21:30:55 gmysql Connection failed: Unable to connect to database: Access denied for user: 'pdns@o4c' (Using password: YES)
Apr 26 21:30:55 Caught an exception instantiating a backend, cleaning up
Apr 26 21:30:56 gmysql Connection failed: Unable to connect to database: Access denied for user: 'pdns@o4c' (Using password: YES)
Apr 26 21:30:56 Caught an exception instantiating a backend, cleaning up
Apr 26 21:30:56 Done launching threads, ready to distribute questions
Apr 26 21:31:05 Distributor misses a thread (0<3), spawning new one
Apr 26 21:31:05 gmysql Connection failed: Unable to connect to database: Access denied for user: 'pdns@o4c' (Using password: YES)
Apr 26 21:31:05 Caught an exception instantiating a backend, cleaning up

ik heb nu geen -host=127.0.0.1 maar daar het ip ingevuld. maar helaas dat werkt ook niet

[ Voor 38% gewijzigd door Ankh op 26-04-2003 21:36 ]

[CyBeR]

hostname goed ingesteld in mysql user database? je kunt ook een unix socket gebruiken voor mysql geloof ik, staat wel in de docs.