Article ID: 121517, created on May 9, 2014, last review on May 10, 2014

  • Applies to:
  • H-Sphere

Symptoms

1) Attempt to log in phpMyAdmin fails because user is not allowed to log in, however in is possible to access as root.
2) Under "user" CP, in "MySQL database management section", "Unable to load users. Tech support was notified" message is shown instead of list of users.
3) The following error is present in hsphere.log file.

2014-05-09 08:02:42,266 [TP-Processor2] DEBUG psoft.hsphere.CP - ssh -o StrictHostKeyChecking=no -x -a root@10.10.10.11 /hsphere/shared/scripts/mysql-db-users some_users 10.10.10.15
2014-05-09 08:02:42,317 [TP-Processor2] DEBUG psoft.hsphere.CP - PhysicalServer some errors: 3328
2014-05-09 08:02:42,338 [TP-Processor2] DEBUG psoft.hsphere.CP - TT#12124 from:null
2014-05-09 08:02:42,339 [TP-Processor2] DEBUG psoft.hsphere.CP - TT is:
User: some
CP URL: https://cp.webaddress.com:8443/psoft/servlet/psoft.hsphere.CP
VERSION: 3.6.1713
Account: 56624
Object: [MySQLDatabase]
Other: AccessMethodModel: method: FM_getUsers, arguments = []
Request: template_name = [MySQL/adm_database2.html]
db_id = [102788_6001]

----------------------
psoft.hsphere.resource.admin.phservers.SSHCommandNonZeroExitCodeException: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /hsphere/shared/lib/perl5/site_perl /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at (eval 6) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
 at /hsphere/shared/scripts/mysql.pm line 27
 Command: ssh -o StrictHostKeyChecking=no -x -a root@10.10.10.11 /hsphere/shared/scripts/mysql-db-users some_users 10.10.10.15
        at psoft.hsphere.resource.admin.phservers.UnixExecutor.pooledExec(UnixExecutor.java:347)
        at psoft.hsphere.resource.admin.phservers.UnixExecutor.execAnyPath(UnixExecutor.java:199)
        at psoft.hsphere.resource.admin.phservers.UnixExecutor.exec(UnixExecutor.java:212)
        at psoft.hsphere.resource.admin.phservers.UnixExecutor.exec(UnixExecutor.java:374)

Cause

DBD::MySQL is not installed

Resolution

To install DBD::MySQL please run:

    yum install perl-DBD-MySQL  

Search Words

Can't locate DBD/mysql.pm

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF