Hi - hope someone can help with this, I'm looking at setting up an SMT (Subscription Management Tool) server to mirror SLES updates for our internal servers. I've installed SMT as an Add On Product and configured as per documentation. However the MySQL DB connection always fails even though I can connect to the MySQL server with the SMT credentials from the command line. Does anyone know why or have any clues as to what's happening?

/etc/smt.conf
[DB]
config = dbi:mysql:database=smt;host=localhost
user = smt
pass = password


If I run any SMT command that requires a DB connection it just fails with:

smt ncc-sync
Downloading Product information
DBI connect('database=smt;host=localhost','smt',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /usr/lib/perl5/vendor_perl/5.10.0/SMT/Utils.pm line 114



However if I try to connect to the MySQL server using the credentials from the smt.conf file it works....

mysql -hlocalhost -usmt -ppassword -S/var/lib/mysql/mysql.sock smt
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.30-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>



Any help would be appreciated.

Thanks - Julian.