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.

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>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

Reply via email to