dab task mysql & dab install dtc-toaster error on squeeze

[chymian]

hi,
I have a proxmox lenny machine running as KVM, used to create templates.

$ pveversion -v
pve-manager: 1.5-10 (pve-manager/1.5/4822)
running kernel: 2.6.24-11-pve
proxmox-ve-2.6.24: 1.5-23
pve-kernel-2.6.24-11-pve: 2.6.24-23
qemu-server: 1.1-16
pve-firmware: 1.0-5
libpve-storage-perl: 1.0-13
vncterm: 0.9-2
vzctl: 3.0.23-1pve11
vzdump: 1.2-5
vzprocps: 2.0.11-1dso2
vzquota: 3.0.11-1
pve-qemu-kvm: 0.12.4-1

using dab to create a squeeze template for dtc fails at serveral points:

1.

dab task mysql --password=admin
no such package 'mysql-server-5.0' at /usr/share/perl5/PVE/DAB.pm line 1025.

fails, because dab is assuming mysql-server-5.0, but there is 5.1 in squeeze, which would be better selected by the meta package mysql-server.

corrected this in dab.pm, calling it again leaves to the following error:

dab task mysql --password=admin
install: psmisc
install: libdbd-mysql-perl
install: libnet-daemon-perl
install: mysql-server-5.1
install: libmysqlclient16
install: mysql-server-core-5.1
install: libdbi-perl
install: mysql-server
install: libplrpc-perl
install: mysql-common
install: mysql-client-5.1
command 'vzctl exec2 90000 defenv /usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables --skip-bdb  --skip-innodb --skip-ndbcluster' failed with exit code 2

installing mysql via:

dab install mysql-server

works so far…

2. installing dtc from the squeeze-rep. throws the following error:

dab install dtc-toaster
command 'vzctl exec2 90000 defenv dpkg --force-depends --force-confold --install /php-net-smtp_1.4.2-1_all.deb /libfile-copy-recursive-perl_0.38-1_all.deb /libclamav6_0.96.1+dfsg-1_i386.deb /dtc-common_0.30.20-1_all.deb /libhtml-parser-perl_3.66-1_i386.deb /courier-pop-ssl_0.65.0-1_i386.deb /clamav-base_0.96.1+dfsg-1_all.deb /libnet-xwhois-perl_0.90-3_all.deb /spamc_3.3.1-1_i386.deb /libmime-tools-perl_5.428-1_all.deb /php-xml-parser_1.3.2-1_all.deb /librrd4_1.4.3-1_i386.deb /libcairo2_1.8.10-4_i386.deb /ncftp_3.2.4-1_i386.deb /libnetaddr-ip-perl_4.028+dfsg-1_i386.deb /expect_5.44.1.15-2_i386.deb /libio-stringy-perl_2.110-4_all.deb /dtc-postfix-courier_0.30.20-1_all.deb /courier-ssl_0.65.0-1_i386.deb /php-pear_5.3.2-1_all.deb /lsb-release_3.2-23.1_all.deb /fetchmail_6.3.17-4_i386.deb /update-inetd_4.36_all.deb /clamav-daemon_0.96.1+dfsg-1_i386.deb /clamav-freshclam_0.96.1+dfsg-1_i386.deb /libtommath0_0.39-4_i386.deb /libberkeleydb-perl_0.41-1_i386.deb /libdbi0_0.8.2-3_i386.deb /rrdtool_1.4.3-1_i386.deb /roundcube_0.3.1-4_all.deb /dtc-toaster_0.30.20-1_all.deb /libio-multiplex-perl_1.10-1_all.deb /courier-authdaemon_0.63.0-2_i386.deb /courier-authlib-mysql_0.63.0-2_i386.deb /php-mail-mimedecode_1.5.0-3_all.deb /courier-base_0.65.0-1_i386.deb /libsasl2-modules_2.1.23.dfsg1-5_i386.deb /libnet-cidr-perl_0.13-1_all.deb /libjs-mootools_1.2.4.0~debian1-1_all.deb /php-mail-mime_1.8.0-1_all.deb /gawk_3.1.7.dfsg-5_i386.deb /libarchive-zip-perl_1.30-3_all.deb /libglib2.0-0_2.24.1-1_i386.deb /libapache2-mod-log-sql-mysql_1.100-14+b1_i386.deb /libpango1.0-common_1.28.1-1_all.deb /visitors_0.7-7_i386.deb /libcrypt-openssl-rsa-perl_0.25-1+b1_i386.deb /php-net-ipv4_1.3.1-2_all.deb /libhtml-tree-perl_3.23-2_all.deb /liberror-perl_0.17-1_all.deb /libxcrypt1_2.4-1_i386.deb /libxcb-render-util0_0.3.6-1_i386.deb /libhtml-tagset-perl_3.20-2_all.deb /php5-sqlite_5.3.2-1_i386.deb /courier-maildrop_0.65.0-1_i386.deb /zip_3.0-3_i386.deb /libmail-dkim-perl_0.38-1_all.deb /libthai-data_0.1.14-2_all.deb /libssh2-1_1.2.6-1_i386.deb /tinymce_3.3.8-1_all.deb /php5-pspell_5.3.2-1_i386.deb /php-mdb2_2.5.0b2-1_all.deb /libnusoap-php_0.7.3-3_all.deb /libjs-jquery_1.4.2-2_all.deb /sasl2-bin_2.1.23.dfsg1-5_i386.deb /libdatrie1_0.2.4-1_i386.deb /libunix-syslog-perl_1.1-2_i386.deb /dtc-dos-firewall_0.30.20-1_all.deb /ca-certificates_20090814_all.deb /libaspell15_0.60.6-4_i386.deb /libpam-mysql_0.7~RC1-4+b1_i386.deb /php-crypt-cbc_1.0.0.1-1_all.deb /spamassassin_3.3.1-1_all.deb /sbox-dtc_1.11.2-1_i386.deb /openbsd-inetd_0.20080125-4_i386.deb /libltdl7_2.2.6b-2_i386.deb /libsocket6-perl_0.23-1_i386.deb /courier-imap_4.8.0-1_i386.deb /bzip2_1.0.5-4_i386.deb /dkimproxy_1.2-5_all.deb /php5-curl_5.3.2-1_i386.deb /php-mdb2-driver-sqlite_1.5.0b2-1_all.deb /libconvert-binhex-perl_1.119+pristine-3_all.deb /libtimedate-perl_1.2000-1_all.deb /defoma_0.11.11_all.deb /unzip_6.0-4_i386.deb /libdigest-sha1-perl_2.13-1_i386.deb /libcrypt-openssl-bignum-perl_0.04-2_i386.deb /spfquery_1.2.9-4_i386.deb /fontconfig_2.8.0-2.1_i386.deb /liburi-perl_1.54-1_all.deb /libconvert-uulib-perl_1.12-1_i386.deb /php5-mcrypt_5.3.2-1_i386.deb /chrootuid_1.3-5_i386.deb /libmailtools-perl_2.06-1_all.deb /libnet-ip-perl_1.25-2_all.deb /libsys-hostname-long-perl_1.4-2_all.deb /python-spf_2.0.5-2_all.deb /mhonarc_2.6.16-1_all.deb /sudo_1.7.2p7-1_i386.deb /librrds-perl_1.4.3-1_i386.deb /tumgreyspf_1.35-4_all.deb /php-net-socket_1.0.9-2_all.deb /libnss-mysql-bg_1.5-2_i386.deb /php-auth_1.6.2-1_all.deb /libfile-tail-perl_0.99.3-4_all.deb /libcurl3_7.21.0-1_i386.deb /awstats_6.9.5~dfsg-2_all.deb /phpmyadmin_3.3.5-1_all.deb /libconvert-tnef-perl_0.17-9_all.deb /libthai0_0.1.14-2_i386.deb /courier-authlib-userdb_0.63.0-2_i386.deb /tcl8.5_8.5.8-2_i386.deb /pure-ftpd-common_1.0.28-2_all.deb /roundcube-core_0.3.1-4_all.deb /libmcrypt4_2.5.8-3.1_i386.deb /libtext-wrapper-perl_1.02-1_all.deb /libfam0_2.7.0-17_i386.deb /libdigest-hmac-perl_1.02+dfsg-1_all.deb /php-fpdf_1.53.dfsg-6.1_all.deb /libnet-server-perl_0.97-1_all.deb /db4.8-util_4.8.26-1_i386.deb /bind9_9.7.0.dfsg.P1-1_i386.deb /clamav_0.96.1+dfsg-1_i386.deb /libwww-perl_5.836-1_all.deb /python-dns_2.3.4-4_all.deb /postfix-mysql_2.7.1-1_i386.deb /courier-authlib_0.63.0-2_i386.deb /mlmmj_1.2.17-1.1_i386.deb /courier-imap-ssl_4.8.0-1_i386.deb /bind9utils_9.7.0.dfsg.P1-1_i386.deb /libspf2-2_1.2.9-4_i386.deb /pure-ftpd-mysql_1.0.28-2_i386.deb /libpixman-1-0_0.16.4-1_i386.deb /sqlite_2.8.17-6_i386.deb /libpam-unix2_2.4.1-4_i386.deb /libnet-dns-perl_0.66-2_i386.deb /courier-pop_0.65.0-1_i386.deb /php-xml-serializer_0.20.0-2_all.deb /dbconfig-common_1.8.46_all.deb /libpango1.0-0_1.28.1-1_i386.deb /php5-mysql_5.3.2-1_i386.deb /libapache2-mod-log-sql_1.100-14+b1_i386.deb /libsqlite0_2.8.17-6_i386.deb /mailgraph_1.14-1.4_all.deb /pax_20090728-1_i386.deb /roundcube-sqlite_0.3.1-4_all.deb /libxcb-render0_1.6-1_i386.deb /webalizer_2.01.10-32.7_i386.deb /amavisd-new_2.6.4-2_all.deb' failed with exit code 1

can anyone shed some light on this?

tia
chymian

 

[apmuthu]

Try with backports in dab with/without your dab.pm fix and let us know.

Sample Contents of dab.conf:

Suite: squeeze
CacheDir: ../cache
Source: http://ftp.debian.org/debian SUITE main contrib non-free
Source: http://security.debian.org SUITE/updates main contrib non-free
Source: http://www.backports.org/debian squeeze-backports main contrib non-free
#Mirror: http://ftp.debian.org/debian => ftp://mirror/debian
Architecture: i386
.
.
.

You may also want to try the latest dab.pm v1.1-5 in the post.

 

[dietmar]

Squeeze is still not stable, and there was some incompatible changes recently that broke mysql.

Please can you send me your dab.conf and makefile, so that I can reproduce the error here? (to dietmar@proxmox.com)

 

[apmuthu]

Try the latest DAB v1.1-6. This addresses the MySQL Server v5.1 for squeeze issue:

File Diffs: /usr/share/perl5/PVE/DAB.pm

v1.1-5 Lines 1489-1490:

    my $cmd = "/usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables " .
 "--skip-bdb  --skip-innodb --skip-ndbcluster";

replaced with Lines 1489-1499 in v1.1-6

    my $cmd;
    my $suite = $self->{config}->{suite};
 
    if ($suite eq 'squeeze') {
 $cmd = "/usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables";
    } else {
 $cmd = "/usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables " .
     "--skip-bdb  --skip-innodb --skip-ndbcluster";
    }

v1.1-5 Line 1542

    my $required = $self->compute_required ([qw (mysql-common mysql-server-5.0)]);

replaced with Lines 1551-1555 in v1.1-6

    my $suite = $self->{config}->{suite};
 
    my $ver = $suite eq 'squeeze' ? '5.1' : '5.0';
    my $required = $self->compute_required (['mysql-common', "mysql-server-$ver"]);