This will cause mysql errors to display a warning
Status: Beta
Brought to you by:
bboy
I added a call to mysql_error() to check for query
errors, and warn the user if there was one. This is a
very minor change to sql.c.
apply like so:
[root@austin mydns-0.9.7]# patch -p0 < ~/mydns-sql.c.patch
patching file src/lib/sql.c
[root@austin mydns-0.9.7]#
This is very helpful for cases like an initial bind
import, if you don't realize that your mydns mysql user
doesn't have insert privileges. The error mydnsimport
gave before wasn't very meaningful :) Now it shows:
mydnsimport: insert command denied to user:
'mydns@localhost' for table 'soa': error during query:
insert command denied to user: 'mydns@localhost' for
table 'soa' (errno=0)
sql.c patch to display mysql errors
Logged In: YES
user_id=655834
Originator: NO
Has been incorporated in 1.2.7 for mydns-ng.