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?
If I run any SMT command that requires a DB connection it just fails with:
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
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.