On Wednesday 15 April 2009 12:16:04 Arno Lehmann wrote: > Hi, > > I forward this to the -devel list, reply-to set to -users. > > 15.04.2009 11:49, Chandranshu . wrote: > > Hi Craig, > > > > I was already using the -d100 flag :) > > > > However, this time I took a more radical approach and modified the code > > in src/cats/mysql.c to print the error message returned by > > mysql_error(). Then, I compiled and ran the code to see the most dubious > > error in my DBA career: > > Error 2002 (HY000): Can't connect to local MySQL server through socket > > '/var/lib/mysql/mysql.sock' (2) > > > > To my utter surprise, someone had changed the /etc/my.cnf file to use > > /tmp/mysql.sock as the socket file. I reverted the socket file and > > everything was back on track immediately. > > > > However, even at a debug level of 100, I was not getting the exact > > reason behind mysql connection failure. The code in mysql.c should print > > the mysql_error(), mysql_errno() and mysql_sqlstate() values at a much > > lower level once the connection couldn't be established. I think, this > > should be filed as a bug.
No, this is not a bug (at least not for us). This is a "feature request" or an enhancement of the current code. > > Can you submit your changes as a patch? Yes, if it is something that *should* print, then we will need a patch. > > I assume this could go into the main line code quickly and without > much discussion. Kern? Yes, I would like to see the code before making any definitive statement. Generally any amount of debug code is appreciated, though we would probably put something volumous or something a bit unlikely on a debug of 400 or greater. Debug of 100 is a *very* small number for Bacula. Virtually nothing is less than 100 except debug code for sockets which is at 50 and possibly some debug code a developer was using and forgot to increase to more than 100 ... Regards, Kern > > Arno > > > The problem stands resolved as of now. > > > > Thanks and regards > > Chandranshu > > > > > > > > On Wed, Apr 15, 2009 at 2:41 PM, Craig Ringer > > <cr...@postnewspapers.com.au <mailto:cr...@postnewspapers.com.au>> wrote: > > > > Chandranshu . wrote: > > > Hi Craig, > > > > > > How do I run the director in an interactive terminal? Please bear > > > > with me as > > > > > I'm still new with bacula. > > > > /etc/init.d/bacula-dir stop > > sudo -u bacula bacula-dir -d100 > > > > ... should do it. I don't have a director to test with. I think > > there's help on the website re debugging director/sd issues, too. > > > > Hopefully that'll get you a MySQL error code or something more useful > > than the generic error provided. > > > > -- > > Craig Ringer ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
