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.

Can you submit your changes as a patch?

I assume this could go into the main line code quickly and without 
much discussion. Kern?

Arno

> The problem stands resolved as of now.
> 
> Thanks and regards
> Chandranshu
> 
> 
> 
> On Wed, Apr 15, 2009 at 2:41 PM, Craig Ringer 
> <craig AT postnewspapers.com DOT au <mailto:craig AT postnewspapers.com DOT 
> 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
> 
> 
>
-- 
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de

------------------------------------------------------------------------------
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users