root@192.168.56.103's password: Linux db.example.com 2.6.26-2-amd64 #1 SMP Thu Sep 16 15:56:38 UTC 2010 x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Fri Nov 12 03:11:57 2010 from 192.168.56.1 db:~# vim /etc/apt/sources.list.d/lenny-backports db:~# vim /etc/apt/sources.list.d/lenny-backports db:~# apt-get update Hit http://ftp.hk.debian.org lenny Release.gpg Hit http://security.debian.org lenny/updates Release.gpg Ign http://security.debian.org lenny/updates/main Translation-en_US Ign http://security.debian.org lenny/updates/non-free Translation-en_US Ign http://security.debian.org lenny/updates/contrib Translation-en_US Hit http://security.debian.org lenny/updates Release Ign http://ftp.hk.debian.org lenny/main Translation-en_US Ign http://security.debian.org lenny/updates/main Packages/DiffIndex Ign http://security.debian.org lenny/updates/non-free Packages/DiffIndex Ign http://security.debian.org lenny/updates/contrib Packages/DiffIndex Ign http://ftp.hk.debian.org lenny/non-free Translation-en_US Ign http://security.debian.org lenny/updates/main Sources/DiffIndex Ign http://security.debian.org lenny/updates/non-free Sources/DiffIndex Ign http://security.debian.org lenny/updates/contrib Sources/DiffIndex Hit http://security.debian.org lenny/updates/main Packages Hit http://security.debian.org lenny/updates/non-free Packages Ign http://ftp.hk.debian.org lenny/contrib Translation-en_US Hit http://security.debian.org lenny/updates/contrib Packages Hit http://security.debian.org lenny/updates/main Sources Hit http://security.debian.org lenny/updates/non-free Sources Hit http://security.debian.org lenny/updates/contrib Sources Hit http://ftp.hk.debian.org lenny Release Ign http://ftp.hk.debian.org lenny/main Packages/DiffIndex Ign http://ftp.hk.debian.org lenny/non-free Packages/DiffIndex Ign http://ftp.hk.debian.org lenny/contrib Packages/DiffIndex Ign http://ftp.hk.debian.org lenny/main Sources/DiffIndex Ign http://ftp.hk.debian.org lenny/non-free Sources/DiffIndex Ign http://ftp.hk.debian.org lenny/contrib Sources/DiffIndex Hit http://ftp.hk.debian.org lenny/main Packages Hit http://ftp.hk.debian.org lenny/non-free Packages Hit http://ftp.hk.debian.org lenny/contrib Packages Hit http://ftp.hk.debian.org lenny/main Sources Hit http://ftp.hk.debian.org lenny/non-free Sources Hit http://ftp.hk.debian.org lenny/contrib Sources Reading package lists... Done db:~# wget http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-server-5.2_5.2.3-mariadb87_amd64.deb --2010-11-12 03:59:17-- http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-server-5.2_5.2.3-mariadb87_amd64.deb Resolving ftp.osuosl.org... 140.211.166.134 Connecting to ftp.osuosl.org|140.211.166.134|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 18188128 (17M) [application/x-debian-package] Saving to: `mariadb-server-5.2_5.2.3-mariadb87_amd64.deb' 100%[==============================================================================================>] 18,188,128 18.0K/s in 14m 59s 2010-11-12 04:14:18 (19.7 KB/s) - `mariadb-server-5.2_5.2.3-mariadb87_amd64.deb' saved [18188128/18188128] db:~# wget http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-client-5.2_5.2.3-mariadb87_amd64.deb http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb --2010-11-12 04:21:11-- http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-client-5.2_5.2.3-mariadb87_amd64.deb Resolving ftp.osuosl.org... 140.211.166.134 Connecting to ftp.osuosl.org|140.211.166.134|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 1973374 (1.9M) [application/x-debian-package] Saving to: `mariadb-client-5.2_5.2.3-mariadb87_amd64.deb' 100%[==============================================================================================>] 1,973,374 59.3K/s in 46s 2010-11-12 04:21:57 (42.3 KB/s) - `mariadb-client-5.2_5.2.3-mariadb87_amd64.deb' saved [1973374/1973374] --2010-11-12 04:21:57-- http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb Reusing existing connection to ftp.osuosl.org:80. HTTP request sent, awaiting response... No data received. Retrying. --2010-11-12 04:21:58-- (try: 2) http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb Connecting to ftp.osuosl.org|140.211.166.134|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 193136 (189K) [application/x-debian-package] Saving to: `mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb' 100%[==============================================================================================>] 193,136 62.8K/s in 3.0s 2010-11-12 04:22:02 (62.8 KB/s) - `mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb' saved [193136/193136] FINISHED --2010-11-12 04:22:02-- Downloaded: 2 files, 2.1M in 49s (43.6 KB/s) db:~# dpkg -i mariadb- mariadb-client-5.2_5.2.3-mariadb87_amd64.deb mariadb-server-5.2_5.2.3-mariadb87_amd64.deb mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb db:~# dpkg -i mariadb-* Selecting previously deselected package mariadb-client-5.2. (Reading database ... 19141 files and directories currently installed.) Unpacking mariadb-client-5.2 (from mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.2. Unpacking mariadb-client-core-5.2 (from mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... Selecting previously deselected package mariadb-server-5.2. dpkg: regarding mariadb-server-5.2_5.2.3-mariadb87_amd64.deb containing mariadb-server-5.2, pre-dependency problem: mariadb-server-5.2 pre-depends on mariadb-common mariadb-common is not installed. dpkg: error processing mariadb-server-5.2_5.2.3-mariadb87_amd64.deb (--install): pre-dependency problem - not installing mariadb-server-5.2 dpkg: dependency problems prevent configuration of mariadb-client-5.2: mariadb-client-5.2 depends on libdbi-perl; however: Package libdbi-perl is not installed. mariadb-client-5.2 depends on libdbd-mysql-perl (>= 1.2202); however: Package libdbd-mysql-perl is not installed. mariadb-client-5.2 depends on mariadb-common; however: Package mariadb-common is not installed. mariadb-client-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-client-core-5.2: mariadb-client-core-5.2 depends on mariadb-common; however: Package mariadb-common is not installed. mariadb-client-core-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-core-5.2 (--install): dependency problems - leaving unconfigured Processing triggers for man-db ... Errors were encountered while processing: mariadb-server-5.2_5.2.3-mariadb87_amd64.deb mariadb-client-5.2 mariadb-client-core-5.2 db:~# apt-get install -f Reading package lists... Done Building dependency tree Reading state information... Done Correcting dependencies... Done The following packages were automatically installed and are no longer required: libnet-daemon-perl libmysqlclient15off libdbi-perl libdbd-mysql-perl libplrpc-perl mysql-common Use 'apt-get autoremove' to remove them. The following extra packages will be installed: libdbd-mysql-perl libdbi-perl libmysqlclient15off libnet-daemon-perl libplrpc-perl mysql-common Suggested packages: dbishell libcompress-zlib-perl The following packages will be REMOVED: mariadb-client-5.2 mariadb-client-core-5.2 The following NEW packages will be installed: libdbd-mysql-perl libdbi-perl libmysqlclient15off libnet-daemon-perl libplrpc-perl mysql-common 0 upgraded, 6 newly installed, 2 to remove and 0 not upgraded. 2 not fully installed or removed. Need to get 2977kB of archives. After this operation, 2023kB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://ftp.hk.debian.org lenny/main libnet-daemon-perl 0.38-1.1 [45.8kB] Get:2 http://security.debian.org lenny/updates/main mysql-common 5.0.51a-24+lenny4 [61.8kB] Get:3 http://ftp.hk.debian.org lenny/main libplrpc-perl 0.2017-1.1 [34.9kB] Get:4 http://ftp.hk.debian.org lenny/main libdbi-perl 1.605-1 [788kB] Get:5 http://security.debian.org lenny/updates/main libmysqlclient15off 5.0.51a-24+lenny4 [1905kB] Get:6 http://ftp.hk.debian.org lenny/main libdbd-mysql-perl 4.007-1+lenny1 [142kB] Fetched 2977kB in 1min38s (30.1kB/s) (Reading database ... 19191 files and directories currently installed.) Removing mariadb-client-5.2 ... Removing mariadb-client-core-5.2 ... Processing triggers for man-db ... Selecting previously deselected package mysql-common. (Reading database ... 19141 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.0.51a-24+lenny4_all.deb) ... Selecting previously deselected package libmysqlclient15off. Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.51a-24+lenny4_amd64.deb) ... Selecting previously deselected package libnet-daemon-perl. Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ... Selecting previously deselected package libplrpc-perl. Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ... Selecting previously deselected package libdbi-perl. Unpacking libdbi-perl (from .../libdbi-perl_1.605-1_amd64.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.007-1+lenny1_amd64.deb) ... Processing triggers for man-db ... Setting up mysql-common (5.0.51a-24+lenny4) ... Setting up libmysqlclient15off (5.0.51a-24+lenny4) ... Setting up libnet-daemon-perl (0.38-1.1) ... Setting up libplrpc-perl (0.2017-1.1) ... Setting up libdbi-perl (1.605-1) ... Setting up libdbd-mysql-perl (4.007-1+lenny1) ... db:~# dpkg -i mariadb-* Selecting previously deselected package mariadb-client-5.2. (Reading database ... 19359 files and directories currently installed.) Unpacking mariadb-client-5.2 (from mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.2. Unpacking mariadb-client-core-5.2 (from mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... dpkg: regarding mariadb-server-5.2_5.2.3-mariadb87_amd64.deb containing mariadb-server-5.2, pre-dependency problem: mariadb-server-5.2 pre-depends on mariadb-common mariadb-common is not installed. dpkg: error processing mariadb-server-5.2_5.2.3-mariadb87_amd64.deb (--install): pre-dependency problem - not installing mariadb-server-5.2 dpkg: dependency problems prevent configuration of mariadb-client-5.2: mariadb-client-5.2 depends on mariadb-common; however: Package mariadb-common is not installed. mariadb-client-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-client-core-5.2: mariadb-client-core-5.2 depends on mariadb-common; however: Package mariadb-common is not installed. mariadb-client-core-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-core-5.2 (--install): dependency problems - leaving unconfigured Processing triggers for man-db ... Errors were encountered while processing: mariadb-server-5.2_5.2.3-mariadb87_amd64.deb mariadb-client-5.2 mariadb-client-core-5.2 db:~# wget http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mysql-common_5.2.3-mariadb87_all.deb --2010-11-12 04:25:55-- http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/mysql-common_5.2.3-mariadb87_all.deb Resolving ftp.osuosl.org... 140.211.166.134 Connecting to ftp.osuosl.org|140.211.166.134|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 10546 (10K) [application/x-debian-package] Saving to: `mysql-common_5.2.3-mariadb87_all.deb' 100%[==============================================================================================>] 10,546 38.1K/s in 0.3s 2010-11-12 04:25:56 (38.1 KB/s) - `mysql-common_5.2.3-mariadb87_all.deb' saved [10546/10546] db:~# dpkg -i mariadb-* mysql-common_5.2.3-mariadb87_all.deb (Reading database ... 19409 files and directories currently installed.) Preparing to replace mariadb-client-5.2 5.2.3-mariadb87 (using mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-5.2 ... Preparing to replace mariadb-client-core-5.2 5.2.3-mariadb87 (using mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-core-5.2 ... dpkg: regarding mariadb-server-5.2_5.2.3-mariadb87_amd64.deb containing mariadb-server-5.2, pre-dependency problem: mariadb-server-5.2 pre-depends on mariadb-common mariadb-common is not installed. dpkg: error processing mariadb-server-5.2_5.2.3-mariadb87_amd64.deb (--install): pre-dependency problem - not installing mariadb-server-5.2 Preparing to replace mysql-common 5.0.51a-24+lenny4 (using mysql-common_5.2.3-mariadb87_all.deb) ... Unpacking replacement mysql-common ... dpkg: dependency problems prevent configuration of mariadb-client-5.2: mariadb-client-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-client-core-5.2: mariadb-client-core-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-core-5.2 (--install): dependency problems - leaving unconfigured Setting up mysql-common (5.2.3-mariadb87) ... Installing new version of config file /etc/mysql/my.cnf ... Processing triggers for man-db ... Errors were encountered while processing: mariadb-server-5.2_5.2.3-mariadb87_amd64.deb mariadb-client-5.2 mariadb-client-core-5.2 db:~# dpkg -i mysql* mariadb-* (Reading database ... 19410 files and directories currently installed.) Preparing to replace mysql-common 5.2.3-mariadb87 (using mysql-common_5.2.3-mariadb87_all.deb) ... Unpacking replacement mysql-common ... Preparing to replace mariadb-client-5.2 5.2.3-mariadb87 (using mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-5.2 ... Preparing to replace mariadb-client-core-5.2 5.2.3-mariadb87 (using mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-core-5.2 ... dpkg: regarding mariadb-server-5.2_5.2.3-mariadb87_amd64.deb containing mariadb-server-5.2, pre-dependency problem: mariadb-server-5.2 pre-depends on mariadb-common mysql-common provides mariadb-common but is unpacked but not configured. dpkg: error processing mariadb-server-5.2_5.2.3-mariadb87_amd64.deb (--install): pre-dependency problem - not installing mariadb-server-5.2 Setting up mysql-common (5.2.3-mariadb87) ... dpkg: dependency problems prevent configuration of mariadb-client-5.2: mariadb-client-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-client-core-5.2: mariadb-client-core-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-core-5.2 (--install): dependency problems - leaving unconfigured Processing triggers for man-db ... Errors were encountered while processing: mariadb-server-5.2_5.2.3-mariadb87_amd64.deb mariadb-client-5.2 mariadb-client-core-5.2 db:~# dpkg -i mysql* (Reading database ... 19410 files and directories currently installed.) Preparing to replace mysql-common 5.2.3-mariadb87 (using mysql-common_5.2.3-mariadb87_all.deb) ... Unpacking replacement mysql-common ... Setting up mysql-common (5.2.3-mariadb87) ... db:~# dpkg -i mariadb-* (Reading database ... 19410 files and directories currently installed.) Preparing to replace mariadb-client-5.2 5.2.3-mariadb87 (using mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-5.2 ... Preparing to replace mariadb-client-core-5.2 5.2.3-mariadb87 (using mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-core-5.2 ... Unpacking mariadb-server-5.2 (from mariadb-server-5.2_5.2.3-mariadb87_amd64.deb) ... dpkg: dependency problems prevent configuration of mariadb-client-5.2: mariadb-client-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-client-core-5.2: mariadb-client-core-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-core-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-server-5.2: mariadb-server-5.2 depends on mariadb-client-5.2 (>= 5.2.3-mariadb87); however: Package mariadb-client-5.2 is not configured yet. mariadb-server-5.2 depends on libmariadbclient16 (>= 5.1.21-1); however: Package libmariadbclient16 is not installed. mariadb-server-5.2 depends on psmisc; however: Package psmisc is not installed. dpkg: error processing mariadb-server-5.2 (--install): dependency problems - leaving unconfigured Processing triggers for man-db ... Errors were encountered while processing: mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-5.2 db:~# apt-get install -f Reading package lists... Done Building dependency tree Reading state information... Done Correcting dependencies... Done The following packages were automatically installed and are no longer required: libnet-daemon-perl libmysqlclient15off libdbi-perl libdbd-mysql-perl libplrpc-perl mysql-common Use 'apt-get autoremove' to remove them. The following extra packages will be installed: psmisc The following packages will be REMOVED: mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-5.2 The following NEW packages will be installed: psmisc 0 upgraded, 1 newly installed, 3 to remove and 0 not upgraded. 3 not fully installed or removed. Need to get 89.6kB of archives. After this operation, 48.6MB disk space will be freed. Do you want to continue [Y/n]? y Get:1 http://ftp.hk.debian.org lenny/main psmisc 22.6-1 [89.6kB] Fetched 89.6kB in 3s (26.7kB/s) (Reading database ... 19612 files and directories currently installed.) Removing mariadb-server-5.2 ... Removing mariadb-client-5.2 ... Removing mariadb-client-core-5.2 ... Processing triggers for man-db ... Selecting previously deselected package psmisc. (Reading database ... 19371 files and directories currently installed.) Unpacking psmisc (from .../psmisc_22.6-1_amd64.deb) ... Processing triggers for man-db ... Setting up psmisc (22.6-1) ... db:~# dpkg -i mariadb-* Selecting previously deselected package mariadb-client-5.2. (Reading database ... 19409 files and directories currently installed.) Unpacking mariadb-client-5.2 (from mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.2. Unpacking mariadb-client-core-5.2 (from mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... Selecting previously deselected package mariadb-server-5.2. Unpacking mariadb-server-5.2 (from mariadb-server-5.2_5.2.3-mariadb87_amd64.deb) ... dpkg: dependency problems prevent configuration of mariadb-client-5.2: mariadb-client-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-client-core-5.2: mariadb-client-core-5.2 depends on libmariadbclient16 (>= 5.2.3-mariadb87); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-client-core-5.2 (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mariadb-server-5.2: mariadb-server-5.2 depends on mariadb-client-5.2 (>= 5.2.3-mariadb87); however: Package mariadb-client-5.2 is not configured yet. mariadb-server-5.2 depends on libmariadbclient16 (>= 5.1.21-1); however: Package libmariadbclient16 is not installed. dpkg: error processing mariadb-server-5.2 (--install): dependency problems - leaving unconfigured Processing triggers for man-db ... Errors were encountered while processing: mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-5.2 db:~# wget http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/libmariadbclient16_5.2.3-mariadb87_amd64.deb --2010-11-12 04:28:51-- http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/libmariadbclient16_5.2.3-mariadb87_amd64.deb Resolving ftp.osuosl.org... 140.211.166.134 Connecting to ftp.osuosl.org|140.211.166.134|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 1975914 (1.9M) [application/x-debian-package] Saving to: `libmariadbclient16_5.2.3-mariadb87_amd64.deb' 100%[==============================================================================================>] 1,975,914 8.01K/s in 1m 40s 2010-11-12 04:30:33 (19.3 KB/s) - `libmariadbclient16_5.2.3-mariadb87_amd64.deb' saved [1975914/1975914] db:~# dpkg -i libmariadbclient16_5.2.3-mariadb87_amd64.deb Selecting previously deselected package libmariadbclient16. (Reading database ... 19650 files and directories currently installed.) Unpacking libmariadbclient16 (from libmariadbclient16_5.2.3-mariadb87_amd64.deb) ... dpkg: dependency problems prevent configuration of libmariadbclient16: libmariadbclient16 depends on libmysqlclient16 (= 5.2.3-mariadb87); however: Package libmysqlclient16 is not installed. dpkg: error processing libmariadbclient16 (--install): dependency problems - leaving unconfigured Errors were encountered while processing: libmariadbclient16 db:~# wget http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/libmysqlclient16_5.2.3-mariadb87_amd64.deb --2010-11-12 04:31:05-- http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-deb-debian5-amd64/debs/binary/libmysqlclient16_5.2.3-mariadb87_amd64.deb Resolving ftp.osuosl.org... 140.211.166.134 Connecting to ftp.osuosl.org|140.211.166.134|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 4292 (4.2K) [application/x-debian-package] Saving to: `libmysqlclient16_5.2.3-mariadb87_amd64.deb' 100%[==============================================================================================>] 4,292 --.-K/s in 0s 2010-11-12 04:31:08 (15.6 MB/s) - `libmysqlclient16_5.2.3-mariadb87_amd64.deb' saved [4292/4292] db:~# dpkg -i lib* (Reading database ... 19658 files and directories currently installed.) Preparing to replace libmariadbclient16 5.2.3-mariadb87 (using libmariadbclient16_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement libmariadbclient16 ... Selecting previously deselected package libmysqlclient16. Unpacking libmysqlclient16 (from libmysqlclient16_5.2.3-mariadb87_amd64.deb) ... Setting up libmysqlclient16 (5.2.3-mariadb87) ... Setting up libmariadbclient16 (5.2.3-mariadb87) ... db:~# dpkg -i mariadb-* (Reading database ... 19661 files and directories currently installed.) Preparing to replace mariadb-client-5.2 5.2.3-mariadb87 (using mariadb-client-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-5.2 ... Preparing to replace mariadb-client-core-5.2 5.2.3-mariadb87 (using mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-client-core-5.2 ... Preparing to replace mariadb-server-5.2 5.2.3-mariadb87 (using mariadb-server-5.2_5.2.3-mariadb87_amd64.deb) ... Unpacking replacement mariadb-server-5.2 ... Setting up mariadb-client-core-5.2 (5.2.3-mariadb87) ... Processing triggers for man-db ... Setting up mariadb-client-5.2 (5.2.3-mariadb87) ... Setting up mariadb-server-5.2 (5.2.3-mariadb87) ... Stopping MariaDB database server: mysqld. 101112 4:31:39 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set 101112 4:31:39 [Note] Plugin 'PBXT' is disabled. 101112 4:31:39 [Note] Plugin 'InnoDB' is disabled. Starting MariaDB database server: mysqld . . . . .. Checking for corrupt, not cleanly closed and upgrade needing tables.. db:~# ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: NO) db:~# mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 5.2.3-MariaDB-mariadb87-log (MariaDB - http://mariadb.com/) This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> \s -------------- mysql Ver 14.16 Distrib 5.2.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1 Connection id: 6 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 5.2.3-MariaDB-mariadb87-log (MariaDB - http://mariadb.com/) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 1 min 21 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.49 -------------- MariaDB [(none)]> select * from information_schema. tables; +---------------+--------------------+---------------------------------------+-------------+--------+---------+------------+------------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+------------------+---------------------------------------------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | +---------------+--------------------+---------------------------------------+-------------+--------+---------+------------+------------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+------------------+---------------------------------------------------+ | NULL | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 384 | 0 | 32869632 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=87381 | | | NULL | information_schema | CLIENT_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 370 | 0 | 33018800 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=90687 | | | NULL | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 231 | 0 | 33409761 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=145257 | | | NULL | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 195 | 0 | 32715540 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=172074 | | | NULL | information_schema | COLUMNS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=9120 | | | NULL | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2565 | 0 | 33514290 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=13081 | | | NULL | information_schema | ENGINES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 731 | 0 | 33326290 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=45902 | | | NULL | information_schema | EVENTS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=1237 | | | NULL | information_schema | FILES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2677 | 0 | 33516040 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=12534 | | | NULL | information_schema | GLOBAL_STATUS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 33513340 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=10267 | | | NULL | information_schema | GLOBAL_VARIABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 33513340 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=10267 | | | NULL | information_schema | INDEX_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1743 | 0 | 33533577 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=19250 | | | NULL | information_schema | KEY_CACHES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 659 | 0 | 33301247 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=50917 | | | NULL | information_schema | KEY_COLUMN_USAGE | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4637 | 0 | 33530147 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=7236 | | | NULL | information_schema | PARTITIONS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=11225 | | | NULL | information_schema | PLUGINS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=21426 | | | NULL | information_schema | PROCESSLIST | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=47060 | | | NULL | information_schema | PROFILING | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 308 | 0 | 33124168 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=108942 | | | NULL | information_schema | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4814 | 0 | 33539138 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6970 | | | NULL | information_schema | ROUTINES | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=1176 | | | NULL | information_schema | SCHEMATA | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3464 | 0 | 33476096 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=9686 | | | NULL | information_schema | SCHEMA_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2179 | 0 | 33475977 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=15399 | | | NULL | information_schema | SESSION_STATUS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 33513340 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=10267 | | | NULL | information_schema | SESSION_VARIABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 33513340 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=10267 | | | NULL | information_schema | STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2679 | 0 | 33541080 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=12524 | | | NULL | information_schema | TABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3545 | 0 | 33486070 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=9465 | | | NULL | information_schema | TABLE_CONSTRAINTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2504 | 0 | 33445928 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=13400 | | | NULL | information_schema | TABLE_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2372 | 0 | 33497384 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=14146 | | | NULL | information_schema | TABLE_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1181 | 0 | 33468359 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=28411 | | | NULL | information_schema | TRIGGERS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=1138 | | | NULL | information_schema | USER_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1986 | 0 | 33452184 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=16895 | | | NULL | information_schema | USER_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 310 | 0 | 33339260 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=108240 | | | NULL | information_schema | VIEWS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 137438945280 | 8192 | 0 | NULL | 2010-11-12 04:33:12 | 2010-11-12 04:33:12 | NULL | utf8_general_ci | NULL | max_rows=13865 | | | NULL | information_schema | INNODB_BUFFER_POOL_PAGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 234 | 0 | 32715540 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=143395 | | | NULL | information_schema | PBXT_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 134 | 0 | 33060882 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=250406 | | | NULL | information_schema | INNODB_CMP | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 25 | 0 | 26214400 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=1342177 | | | NULL | information_schema | INNODB_RSEG | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 49 | 0 | 29360114 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=684784 | | | NULL | information_schema | XTRADB_ENHANCEMENTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2604 | 0 | 33500460 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=12885 | | | NULL | information_schema | INNODB_BUFFER_POOL_PAGES_INDEX | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 105 | 0 | 31457265 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=319566 | | | NULL | information_schema | XTRADB_ADMIN_COMMAND | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3075 | 0 | 33499050 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=10912 | | | NULL | information_schema | INNODB_TRX | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3446 | 0 | 33533026 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=9737 | | | NULL | information_schema | INNODB_SYS_TABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1783 | 0 | 33534664 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=18819 | | | NULL | information_schema | INNODB_LOCK_WAITS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 599 | 0 | 33498476 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=56017 | | | NULL | information_schema | INNODB_SYS_STATS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 25 | 0 | 26214400 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=1342177 | | | NULL | information_schema | INNODB_LOCKS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 31244 | 0 | 33524812 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=1073 | | | NULL | information_schema | INNODB_CMPMEM | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 25 | 0 | 26214400 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=1342177 | | | NULL | information_schema | INNODB_TABLE_STATS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1189 | 0 | 33469161 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=28220 | | | NULL | information_schema | INNODB_SYS_INDEXES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 627 | 0 | 33288684 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=53515 | | | NULL | information_schema | INNODB_CMP_RESET | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 25 | 0 | 26214400 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=1342177 | | | NULL | information_schema | INNODB_BUFFER_POOL_PAGES_BLOB | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 65 | 0 | 30292145 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=516222 | | | NULL | information_schema | INNODB_CMPMEM_RESET | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 25 | 0 | 26214400 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=1342177 | | | NULL | information_schema | INNODB_INDEX_STATS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2529 | 0 | 33461199 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=13267 | | | NULL | mysql | columns_priv | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 227994731135631359 | 4096 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_bin | NULL | | Column privileges | | NULL | mysql | db | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 123848989752688639 | 2048 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | utf8_bin | NULL | | Database privileges | | NULL | mysql | event | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Events | | NULL | mysql | func | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 162974011515469823 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_bin | NULL | | User defined functions | | NULL | mysql | general_log | BASE TABLE | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | General log | | NULL | mysql | help_category | BASE TABLE | MyISAM | 10 | Fixed | 37 | 581 | 21497 | 163536961468891135 | 3072 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:39 | NULL | utf8_general_ci | NULL | | help categories | | NULL | mysql | help_keyword | BASE TABLE | MyISAM | 10 | Fixed | 450 | 197 | 88650 | 55450570411999231 | 16384 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:39 | NULL | utf8_general_ci | NULL | | help keywords | | NULL | mysql | help_relation | BASE TABLE | MyISAM | 10 | Fixed | 990 | 9 | 8910 | 2533274790395903 | 18432 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:39 | NULL | utf8_general_ci | NULL | | keyword-topic relation | | NULL | mysql | help_topic | BASE TABLE | MyISAM | 10 | Dynamic | 504 | 836 | 421536 | 281474976710655 | 20480 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:39 | NULL | utf8_general_ci | NULL | | help topics | | NULL | mysql | host | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 110056715893866495 | 2048 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_bin | NULL | | Host privileges; Merged with database privileges | | NULL | mysql | ndb_binlog_index | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | latin1_swedish_ci | NULL | | | | NULL | mysql | plugin | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 162411061562048511 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_bin | NULL | | MySQL plugins | | NULL | mysql | proc | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Stored Procedures | | NULL | mysql | procs_priv | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 239253730204057599 | 4096 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_bin | NULL | | Procedure privileges | | NULL | mysql | servers | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 433752939111120895 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | MySQL Foreign Servers table | | NULL | mysql | slow_log | BASE TABLE | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | Slow log | | NULL | mysql | tables_priv | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 239535205180768255 | 4096 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_bin | NULL | | Table privileges | | NULL | mysql | time_zone | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | 1 | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Time zones | | NULL | mysql | time_zone_leap_second | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 3659174697238527 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Leap seconds information for time zones | | NULL | mysql | time_zone_name | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 55450570411999231 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Time zone names | | NULL | mysql | time_zone_transition | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 4785074604081151 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Time zone transitions | | NULL | mysql | time_zone_transition_type | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 10696049115004927 | 1024 | 0 | NULL | 2010-11-12 04:31:38 | 2010-11-12 04:31:38 | NULL | utf8_general_ci | NULL | | Time zone transition types | | NULL | mysql | user | BASE TABLE | MyISAM | 10 | Dynamic | 3 | 106 | 320 | 281474976710655 | 2048 | 0 | NULL | 2010-11-12 04:31:39 | 2010-11-12 04:31:40 | NULL | utf8_bin | NULL | | Users and global privileges | +---------------+--------------------+---------------------------------------+-------------+--------+---------+------------+------------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+------------------+---------------------------------------------------+ 75 rows in set (0.08 sec) MariaDB [(none)]> show engines; +------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | Aria | YES | Crash-safe tables with MyISAM heritage | YES | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | InnoDB | DEFAULT | XtraDB engine based on InnoDB plugin. Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | PBXT | YES | High performance, multi-versioning transactional engine | YES | YES | NO | +------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ 10 rows in set (0.00 sec) MariaDB [(none)]> exit Bye db:~# /etc/init.d/mysql stop Stopping MariaDB database server: mysqld failed! db:~# tail /var/log/syslog Nov 12 04:31:49 db /etc/mysql/debian-start[4468]: Phase 1/3: Fixing table and database names Nov 12 04:31:49 db /etc/mysql/debian-start[4468]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: NO) when trying to connect Nov 12 04:31:49 db /etc/mysql/debian-start[4468]: FATAL ERROR: Upgrade failed Nov 12 04:31:49 db /etc/mysql/debian-start[4474]: Checking for insecure root accounts. Nov 12 04:31:49 db mysqld: 101112 4:31:49 [Warning] Access denied for user 'debian-sys-maint'@'localhost' (using password: NO) Nov 12 04:32:34 db dhclient: DHCPREQUEST on eth1 to 192.168.56.100 port 67 Nov 12 04:32:37 db dhclient: DHCPACK from 192.168.56.100 Nov 12 04:32:37 db dhclient: bound to 192.168.56.103 -- renewal in 1433 seconds. Nov 12 04:34:30 db mysqld: 101112 4:34:30 [Warning] Access denied for user 'debian-sys-maint'@'localhost' (using password: NO) Nov 12 04:34:30 db mysqld: 101112 4:34:30 [Warning] Access denied for user 'debian-sys-maint'@'localhost' (using password: NO) db:~# ls -lha total 22M drwxr-xr-x 4 root root 4.0K 2010-11-12 04:34 . drwxr-xr-x 22 root root 4.0K 2010-11-10 10:38 .. drwx------ 2 root root 4.0K 2010-11-10 10:32 .aptitude -rw------- 1 root root 650 2010-11-12 03:42 .bash_history -rw-r--r-- 1 root root 412 2004-12-15 17:53 .bashrc drwxr-xr-x 2 root root 4.0K 2010-11-10 10:40 .debtags -rw-r--r-- 1 root root 1.9M 2010-11-09 10:09 libmariadbclient16_5.2.3-mariadb87_amd64.deb -rw-r--r-- 1 root root 4.2K 2010-11-09 10:09 libmysqlclient16_5.2.3-mariadb87_amd64.deb -rw-r--r-- 1 root root 1.9M 2010-11-09 10:09 mariadb-client-5.2_5.2.3-mariadb87_amd64.deb -rw-r--r-- 1 root root 189K 2010-11-09 10:09 mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb -rw-r--r-- 1 root root 18M 2010-11-09 10:09 mariadb-server-5.2_5.2.3-mariadb87_amd64.deb -rw-r--r-- 1 root root 11K 2010-11-09 10:09 mysql-common_5.2.3-mariadb87_all.deb -rw------- 1 root root 59 2010-11-12 04:34 .mysql_history -rw-r--r-- 1 root root 140 2007-11-19 12:57 .profile db:~#