Now the code not able to connect(really funny)

Unix admin says, it's something to do with my 64 bit client version, but the DBA denies it.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)xxxxxxxxx#

The above error can be resolved by setting the LD_LIBRARY_PATH
xxxxxxxxxx# LD_LIBRARY_PATH=/usr/local/lib
xxxxxxxxxx# export LD_LIBRARY_PATH

I ran the Bugzilla's checksetup.pl, here is what happened


xxxxxxxxxxx# /opt/DKBbugzla/bugzilla-2.20/checksetup.pl

Checking perl modules ...Checking for AppConfig (v1.52) ok: found v1.52Checking for CGI (v2.93) ok: found v3.04Checking for Data::Dumper (any) ok: found v2.102Checking for Date::Format (v2.21) ok: found v2.22Checking for DBI (v1.38) ok: found v1.48Checking for File::Spec (v0.84) ok: found v3.13Checking for File::Temp (any) ok: found v0.12Checking for Template (v2.08) ok: found v2.08Checking for Text::Wrap (v2001.0131) ok: found v2001.0131Checking for Mail::Mailer (v1.65) ok: found v1.67Checking for Storable (any) ok: found v2.15

The following Perl modules are optional:Checking for GD (v1.20) ok: found v2.22Checking for Chart::Base (v1.0) ok: found v2.3Checking for XML::Parser (any) ok: found v2.31Checking for GD::Graph (any) ok: found v1.43Checking for GD::Text::Align (any) ok: found v1.18Checking for PatchReader (v0.9.4) ok: found v0.9.4

Checking user setup ...Removing existing compiled templates ...Precompiling templates ...

Can't connect to the database.Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Is your database installed and up and running? Do you havethe correct username and password selected in localconfig?

Now I made sure the PATH variable is exactly pointing to my mysql client and the error is resolved