GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Failed to connect to MySQL server as DBD::mysql module is not installed

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Failed to connect to MySQL server as DBD::mysql module is not installed

    Hi guys,

    I've been using innobackupex on my MySQL production server for a few years with no issues, now though I've noticed it has stopped working.
    I believe this has happened after a recent "apt-get upgrade", but I'm not sure as I just found out about the problem.

    The server it self is an Ubuntu Server x64 running the following software.
    - Kernel: 3.2.0-40-generic
    - MySQL: 5.5.32
    - XtraBackup: 2.1.4
    - Perl: 5.14.2


    This is the script I'm running.
    #!/bin/sh

    user=root
    pass=*****
    tmpdir=/media/data/tmp
    file=$tmpdir/mysql-$(date +%A).tar.gz


    ### Start MySQL Backup ###
    echo "$(date): Starting MySQL backup." >> /tmp/backup.log
    /usr/bin/innobackupex
    --ibbackup=xtrabackup_55
    --user=$user --password=$pass --no-timestamp --rsync $tmpdir/backup
    /usr/bin/innobackupex
    --ibbackup=xtrabackup_55 --user=$user --password=$pass --apply-log --use-memory=1GB $tmpdir/backup

    tar -zcvf $file $tmpdir/backup
    rm -rf $tmpdir/backup
    /usr/bin/scp $file admin@*********.com:/share/MD0_DATA/Backup/bb-mysql-01/
    rm $file

    sync
    echo 1 > /proc/sys/vm/drop_caches

    echo "$(date): Backup completed." >> /tmp/backup.log




    And here is the output.
    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona Ireland Ltd 2009-2012. All Rights Reserved.

    This software is published under
    the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

    130905 10:11:19 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
    ERROR: Failed to connect to MySQL server as DBD::mysql module is not installed at /usr/bin/innobackupex line 1614.

    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona Ireland Ltd 2009-2012. All Rights Reserved.

    This software is published under
    the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

    IMPORTANT: Please check that the apply-log run completes successfully.
    At the end of a successful apply-log run innobackupex
    prints "completed OK!".


    Could not open required defaults file: /media/data/tmp/backup/backup-my.cnf
    Fatal error in defaults handling. Program aborted
    xtrabackup: Error: --defaults-file must be specified first on the command line
    innobackupex: fatal error: no 'mysqld' group in MySQL options
    tar: Removing leading `/' from member names
    tar: /media/data/tmp/backup: Cannot stat: No such file or directory

    mysql-Thursday.tar.gz 100% 45 0.0KB/s 00:00



    I did an "apt-cache search perl dbd".
    freetds-dev - MS SQL and Sybase client library (static libs and headers)
    libct4 - libraries for connecting to MS SQL and Sybase SQL servers
    libdbd-mysql-perl - Perl5 database interface to the MySQL database
    libdbd-sqlite3-perl - Perl DBI driver with a self-contained RDBMS
    libdbi-dev - DB Independent Abstraction Layer for C -- development files
    libdbi-doc - DB Independent Abstraction Layer for C -- documentation
    libdbi-perl - Perl Database Interface (DBI)
    libdbi1 - DB Independent Abstraction Layer for C -- shared library
    postgresql-contrib-9.1 - additional facilities for PostgreSQL
    hobbit-plugins - plugins for the Xymon network monitor
    libanyevent-dbd-pg-perl - AnyEvent interface to DBD::Pg's async interface
    libapache-dbilogger-perl - Perl module for tracking what's being transferred in a DBI database
    libdbd-anydata-perl - perl DBI driver for files and data structures
    libdbd-csv-perl - DBI driver for CSV files
    libdbd-excel-perl - provides an SQL interface (via DBI) for accessing Excel files
    libdbd-firebird-perl - Perl DBI driver for Firebird RDBMS server
    libdbd-ldap-perl - Perl extension for LDAP access via an SQL/Perl DBI interface
    libdbd-mock-perl - Mock database driver for testing
    libdbd-odbc-perl - Perl Database Driver implementing ODBC for DBI
    libdbd-pg-perl - Perl DBI driver for the PostgreSQL database server
    libdbd-sqlite2-perl - Perl DBI driver with a self-contained RDBMS (SQLite2 version)
    libdbd-sybase-perl - Sybase/MS SQL database driver for the DBI module
    libdbd-xbase-perl - Perl module to access xbase files (optionally through DBI)
    libdbix-class-perl - extensible and flexible object <-> relational mapper
    libdbix-dbschema-perl - Database-independent schema objects
    libdbix-fulltextsearch-perl - Indexing documents with MySQL as storage
    libdbix-recordset-perl - Perl extension for DBI recordsets
    libsql-statement-perl - module for parsing and processing SQL statements
    libtest-database-perl - support for testing against multiple unspecified databases
    postgresql-contrib-8.4 - additional facilities for PostgreSQL
    ruby-dbi - Database Independent Interface for Ruby



    What can be causing the issue?
    As far as I can tell I'm running the latest stable version of all software, maybe there is some conflict there?

    Any help would be greatly appreciated!
    Last edited by ZyBeR; 09-05-2013, 04:12 AM.

  • #2
    After I ran a little Perl script ( perl -MDBD::mysql -e 'print $DBD::mysql::VERSION ) I noticed it complained about the ssl library not being installed.

    Odd that it's needed when I don't have ssl enabled on my MySQL server, but anyhow I installed the library to satisfy it.
    apt-get install libssl0.9.8

    And now my backup seams to be working, at least it's running now, we'll see in a hour or so if it worked.

    Comment

    Working...
    X