View source for User:Aapo/Waemo/Status

After flash, before updating anything, run this shell-script (doesn't need bash. sqlite3 is installed by default):

 sqlite3 packages.sqlite "CREATE table packages(name TEXT, maemo_version TEXT, wheezy_version TEXT);"
 
 for p in `cat goal.txt`
 do
         m=`apt-cache policy $p | head -n 2 | tail -n 1 | awk {'print $2'}`
         sqlite3 packages.sqlite "INSERT into packages values('$p','$m','0');"
 done


----
After upgrade, run this:
 #if version differs, bump wheezy-version
 for p in `cat goal.txt`
 do
    w=`apt-cache policy $p | head -n 2 | tail -n 1 | awk {'print $2'}`
    sqlite3 packages.sqlite "UPDATE packages SET wheezy_version='$w' WHERE  name='$p' AND maemo_version!='$w'"
 done

----
Then print results on wiki-format with this:
 #!/bin/sh
 #this doesn't need bash.
 
 #header of table
 echo "{| class="wikitable sortable"
 ! Name !! Maemo-version !! Waemo-version !! Issues 
 |-"
 
 #loop over each package
 for p in `cat goal.txt`
 do
 m=`sqlite3 packages.sqlite "SELECT maemo_version  FROM packages WHERE name='$p';"`
 w=`sqlite3 packages.sqlite "SELECT wheezy_version FROM packages WHERE name='$p';"`
 
 echo -n "| $p ||"
 echo -n $m
 echo -n " || "
 if [ "$w" == "0" ]; then
     echo " - || Some issue"
 else
     echo "$w || none"
 fi
 
 echo "|-"
 done
 
 #footer of table
 echo "}"

And it should produce skeleton (without hand filled issues)

----




{| class=wikitable sortable
! Name !! Maemo-version !! Waemo-version !! Issues 
|-
| alsa-utils ||1.0.20-0maemo1+0m5 ||  - || Built. Needs libasound2 and module-init-tools
|-
| apt ||0.7.20.2maemo13.1+0m5 || 0.9.7.9 || none
|-
| apt-transport-https ||0.7.20.2maemo13.1+0m5 || 0.9.7.9 || none
|-
| base-files ||3.1.osso2+3.1.10.osso25+0m5 || 7.1 || none
|-
| base-passwd ||3.5.11.osso10 || 3.5.26 || none
|-
| bluez ||4.60-0maemo1.6+0m5 ||  - || compile error (define!)
|-
| busybox ||3:1.10.2.legal-1osso30+0m5 || 3:1.10.2.withouttar || none
|-
| dbus ||1.2.14-0maemo4+0m5 ||  - || Built. Installing tries remove 'icd2', which will brick.
|-
| dbus-x11 ||1.2.14-0maemo4+0m5 ||  - || Built. Needs x11-common
|-
| desktop-file-utils ||0.12-2osso7+0m5 || 0.20-0.1 || none
|-
| dnsmasq ||2.45-1+lenny1+maemo3+0m5 || 2.62-3+deb7u1 || none
|-
| dnsmasq-base ||2.45-1+lenny1+maemo3+0m5 || 2.62-3+deb7u1 || none
|-
| dosfstools ||1:2.11maemo8-2+0m5 ||  3.0.13-1 || Install with apt-get install dosfstools=3.0.13-1 (maemo version has epoch, wheezy doesn't)
|-
| dpkg ||1.14.25maemo3+0m5 || 1.16.10 || none
|-
| e2fslibs ||1.41.3-1maemo6+0m5 ||  - || Replaces e2fsprogs (but not provides)
|-
| e2fsprogs ||1.41.3-1maemo6+0m5 ||  - || Needs util-linux
|-
| fontconfig ||2.6.0-1osso1+0m5 || 2.9.0-7.1 || none
|-
| gconf2 ||2.16.0-2osso6.3+0m5 ||  - || Built. "update-gconf-defaults --no-signal" causes parse errors
|-
| gnuchess ||5.07-9osso1 || 6.0.2-1 || none
|-
| gnupg ||1.4.6-2maemo2 || 1.4.12-7 || none
|-
| gpgv ||1.4.6-2maemo2 || 1.4.12-7 || none
|-
| gstreamer0.10-gnomevfs ||0.10.25-0maemo14+0m5 ||  - || Building waits gstreamer0.10-plugins-base
|-
| gstreamer0.10-plugins-bad ||0.10.14-git265-0maemo10+0m5 ||  - || Building waits gstreamer0.10-plugins-base
|-
| gstreamer0.10-plugins-base ||0.10.25-0maemo14+0m5 ||  - || Building error (define!)
|-
| gstreamer0.10-plugins-good ||0.10.16-git276-0maemo19+0m5 ||  - || Building waits gstreamer0.10-plugins-base
|-
| gstreamer0.10-x ||0.10.25-0maemo14+0m5 ||  - || Building waits gstreamer0.10-plugins-base
|-
| gvfs ||1.0.3-3maemo3.2+0m5 ||  - || Some building issue (define!)
|-
| gvfs-backends ||1.0.3-3maemo3.2+0m5 ||  - || Some building issue (define!)
|-
| hal ||0.5.12~git20090219-0maemo9+0m5 ||  - || Built. Needs udev>=143
|-
| libasound2 ||1.0.20-0maemo1+0m5 1.0.20-0maemo1+0m5 || - || Built. Will remove old libasound2-plugins (is this bad thing?)
|-
| libasound2-plugins ||1.0.20-0maemo1+0m5 ||  - || Building issue: Waits dependencies e.g. libpulse-dev (Source package is alsa-plugins.)
|-
| libatk1.0-0 ||1.24.0-2maemo1 || 2.4.0-2 || none
|-
| libblkid1 ||1.41.3-1maemo6+0m5 || 2.17.2-9-squeeze || none
|-
| libbluetooth3 ||4.60-0maemo1.6+0m5 || - || Some building issue (define!)
|-
| libbz2-1.0 ||1:1.0.5-3+0m5 ||  1.0.6-4  || Install with apt-get install libbz2-1.0=1.0.6-4 (maemo version has epoch, wheezy doesn't)
|-
| libc6 ||2.5.1-1eglibc27+0m5 2.5.1-1eglibc27+0m5 || 2.10.90-maemo1 || none
|-
| libcairo2 ||1.8.8-0maemo1+0m5 || 1.12.2-3 || none
|-
| libcanberra-gtk0 ||0.14-0maemo5+0m5 ||  - || Build issue: canberra-gtk needs gtk 2.20
|-
| libcanberra0 ||0.14-0maemo5+0m5 ||  0.28-6 || none
|-
| libcomerr2 ||1.41.3-1maemo6+0m5 || 1.42.5-1.1 || none
|-
| libcurl3 ||7.18.2-8maemo6+0m5 || 7.26.0-1+wheezy2 || none
|-
| libdbus-1-3 ||1.2.14-0maemo4+0m5 || 1.6.8-1+deb7u1 || none
|-
| libdbus-glib-1-2 ||0.78-0maemo9+0m5 || 0.100.2-1 || none
|-
| libdrm2 ||2.3.1-3 || 2.4.40-1~deb7u2 || none
|-
| libelfg0 ||0.8.10-2maemo2+0m5 || 0.8.13-3 || none
|-
| libenca0 ||1.9-7maemo2+0m5 || 1.13-4 || none
|-
| libexempi3 ||2.0.2-1maemo8+0m5 || 2.2.0-1 || none
|-
| libexif12 ||0.6.17-1maemo3+0m5 || 0.6.20-3 || none
|-
| libexpat1 ||1.95.8-5maemo1+0m5 || 2.1.0-1 || none
|-
| libffi5 ||3.0.7-2maemo2+0m5 || 3.0.10-3 || none
|-
| libfontconfig1 ||2.6.0-1osso1+0m5 || 2.9.0-7.1 || none
|-
| libfontenc1 ||1:1.0.4-2 || 1:1.1.1-1 || none
|-
| libfreetype6 ||2.3.9-1osso2+0m5 || 2.4.9-1.1 || none
|-
| libgcc1 ||1:4.2.1-4maemo13+0m5 || 1:4.7.2-0+cssu0 || none
|-
| libgdbm3 ||1.8.3-2maemo3+0m5 || 1.8.3-11 || none
|-
| libglade2-0 ||1:2.6.3-1maemo1 || 1:2.6.4-1 || none
|-
| libglib2.0-0 ||2.20.3-1maemo5+0m5 || 2.35.3-0maemo3 || none
|-
| libgnome-menu2 ||2.23.3-2maemo+0m5 ||  3.0.1-4 || none
|-
| libgstreamer-plugins-base0.10-0 ||0.10.25-0maemo14+0m5 ||  - || Building issue: qemu seg faultting
|-
| libgstreamer0.10-0 ||0.10.25-0maemo4+0m5 ||  - ||  Building waits gstreamer0.10-plugins-base
|-
| libgtk2.0-0 ||2:2.14.7-1maemo33+0m5 ||  - || GTK is big mess
|-
| libgtk2.0-bin ||2:2.14.7-1maemo33+0m5 ||  - || GTK is big mess
|-
| libgtk2.0-common ||2:2.14.7-1maemo33+0m5 ||  - || GTK is big mess
|-
| libgupnp-av-1.0-2 ||0.5.2-0maemo3+0m5 || 0.10.3-1 || none
|-
| libhal-storage1 ||0.5.12~git20090219-0maemo9+0m5 ||  0.5.14-8 || none
|-
| libhal1 ||0.5.12~git20090219-0maemo9+0m5 ||  - || Built. Bricks device if installed.
|-
| libice6 ||2:1.0.4-1 || 2:1.0.8-2 || none
|-
| libiptcdata0 ||1.0.2+libtool01-2maemo1 || 1.0.4-3 || none
|-
| libiw30 ||30~pre7-1.3maemo+0m5 || 30~pre9-8 || none
|-
| libjpeg62 ||6b-9osso8+0m5 || 6b1-3 || none
|-
| liblas1 ||1.0.2+0m5 ||  - || Not yet compiled: Waiting dependencies to be compiled
|-
| liblocale-gettext-perl ||1.01-17osso2 || 1.05-7 || none
|-
| libloudmouth1-0 ||1.4.1-0osso10+0m5 || 1.4.3-9 || none
|-
| libltdl7 ||2.2.6a-1~maemo2 || 2.4.2-1.1 || none
|-
| libmatchbox1 ||2:1.9-osso8+0m5 ||  1.9-osso8-3 || install libmatchbox1=1.9-osso8-3 (maemo version has epoch, wheezy doesn't)
|-
| libncurses5 ||5.7+20081213-1.maemo1+0m5 || 5.9-10 || none
|-
| libnl1 ||1.1-2nokia1 ||  1.1-7 || None
|-
| libnspr4 ||20100401-1.9.2-5.2+0m5 ||  - || Built. Needs libnss3. This or libnss3 bricks device.
|-
| libnss3 ||20100401-1.9.2-5.2+0m5 ||  - || Built. Needs libnspr4. This or libnspr4 bricks device.
|-
| liboil0.3 ||0.3.15-1maemo7 || 0.3.17-2 || none
|-
| libopenobex1 ||1.4-0maemo3+0m5 || 1.5-2 || none
|-
| libpango1.0-0 ||1.24.2-0maemo4+0m5 || 1.30.0-1 || none
|-
| libpciaccess0 ||0.10.3-1 || 0.13.1-2 || none
|-
| libpixman-1-0 ||0.16.2-5+0m5 || 0.26.0-4 || none
|-
| libpng12-0 ||1.2.37-1maemo3+0m5 || 1.2.49-1 || none
|-
| libpopt0 ||1.10-3osso3+0m5 || 1.16-7 || none
|-
| libpulse-mainloop-glib0 ||0.9.15-1maemo43+0m5 ||  - || Building waits some other packages
|-
| libpulse0 ||0.9.15-1maemo43+0m5 ||  - || Building waits some other packages
|-
| libqt4-core ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-dbus ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-declarative ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-gui ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-network ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-opengl ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-phonon ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-script ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-sql ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-sql-sqlite ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-svg ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-webkit ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-xml ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libqt4-xmlpatterns ||4.7.0~git20100909-0maemo1+0m5 ||  - || Building waits some other packages
|-
| libreadline5 ||5.2-2maemo2+0m5 || 5.2+dfsg-1 || none
|-
| libsdl-image1.2 ||1.2.4-5-recomp1 || 1.2.12-2|| none
|-
| libsdl-mixer1.2 ||1:1.2.6-5+0m5 || 1:1.2.6-5+0m5+ogg+mp3 || none
|-
| libsm6 ||2:1.0.3-1 || 2:1.2.1-2 || none
|-
| libsndfile1 ||1.0.20-0maemo1+0m5 || 1.0.25-5 || none
|-
| libsofia-sip-ua-glib3 ||1.12.10-0maemo5+0m5 || 1.12.11+20110422-1 || none
|-
| libsofia-sip-ua0 ||1.12.10-0maemo5+0m5 || 1.12.11+20110422-1 || none
|-
| libsoup2.4-1 ||2.26.3-0maemo3+0m5 || 2.38.1-2 || none
|-
| libspeexdsp1 ||1.2~rc1-1maemo7+0m5 || 1.2~rc1-7 || none
|-
| libsqlite3-0 ||3.6.14-1maemo4+0m5 || 3.7.13-1+deb7u1 || none
|-
| libss2 ||1.41.3-1maemo6+0m5 || 1.42.5-1.1 || none
|-
| libstdc++6 ||4.2.1-4maemo13+0m5 || 4.7.2-0+cssu0 || none
|-
| libsysfs2 ||2.1.0-3osso3 || 2.1.0+repack-2 || none
|-
| libtelepathy-glib0 ||0.8.1-0maemo2+0m5 || 0.18.2-2 || none
|-
| libtiff4 ||1:3.8.2-11maemo5+0m5 || 3.9.6-11 || libtiff4=3.9.6-11 (maemo version has epoch, wheezy doesn't)
|-
| libusb-0.1-4 ||2:0.1.12-5osso3+0m5 || 2:0.1.12-20+nmu1 || none
|-
| libuuid1 ||1.41.3-1maemo6+0m5 || 2.17.2-9-squeeze || none
|-
| libvte-common ||1:0.16.14-0mh9.m5 ||  - || Building needs GTK 2.20
|-
| libwbxml2-0 ||0.10.7-3+0m5 ||  0.10.7-1 || Maemo version numbering barges. install libwbxml2-0=0.10.7-1
|-
| libx11-6 ||2:1.1.99.6+0m5 || 2:1.5.0-1+deb7u1 || none
|-
| libx11-data ||2:1.1.99.6+0m5 || 2:1.5.0-1+deb7u1 || none
|-
| libxau6 ||1:1.0.3-2osso1.1 || 1:1.0.7-1 || none
|-
| libxcb-randr0 ||1.1.92-2downgraded || 1.8.1-2+deb7u1 || none
|-
| libxcb-shm0 ||1.1.92-2downgraded || 1.8.1-2+deb7u1 || none
|-
| libxcb-xv0 ||1.1.92-2downgraded || 1.8.1-2+deb7u1 || none
|-
| libxcb1 ||1.1.92-2downgraded || 1.8.1-2+deb7u1 || none
|-
| libxcomposite1 ||1:0.4.0-3+0m5 || 1:0.4.3-2 || none
|-
| libxcursor1 ||1:1.1.9-2+0m5 || 1:1.1.13-1+deb7u1 || none
|-
| libxdamage1 ||1:1.1.1-3osso1.1 || 1:1.1.3-2 || none
|-
| libxdmcp6 ||1:1.0.2-2osso1.1 || 1:1.1.1-1 || none
|-
| libxext6 ||2:1.0.99.1-0maemo20081209.0 || 2:1.3.1-2+deb7u1 || none
|-
| libxfixes3 ||1:4.0.3-2osso1.1 || 1:5.0-4+deb7u1 || none
|-
| libxfont1 ||1:1.3.2-1maemo2+0m5 || 1:1.4.5-2 || none
|-
| libxft2 ||2.1.12-2osso2.cs2007q3+0m5 || 2.3.1-1 || none
|-
| libxi6 ||2:1.2.99.1-1 || 2:1.6.1-1+deb7u1 || none
|-
| libxkbfile1 ||1:1.0.5-1 || 1:1.0.8-1 || none
|-
| libxml2 ||2.6.32.dfsg-5maemo4+0m5 || 2.8.0+dfsg1-7+nmu1 || none
|-
| libxrandr2 ||2:1.2.99.4-2 || 2:1.3.2-2+deb7u1 || none
|-
| libxrender1 ||1:0.9.4-2+0m5 || 1:0.9.7-1+deb7u1 || none
|-
| libxt6 ||1:1.0.5-4+0m5 || 1:1.1.3-1+deb7u1 || none
|-
| libxtst6 ||2:1.0.3-4+0m5 || 2:1.2.1-1+deb7u1 || none
|-
| libxv1 ||2:1.0.4-2+0m5 || 2:1.0.7-1 || none
|-
| lsb-base ||3.2-15osso2 || 4.1+Debian8+deb7u1 || none
|-
| lsof ||4.70-1osso2 || 4.86+dfsg-1 || none
|-
| makedev ||2.3.2~2.3.1-80osso9 ||  2.3.1-92 || install makedev=2.3.1-92 (Maemo version barges)
|-
| matchbox-window-manager ||3:1.2-osso21+0m5 || 1.2-osso21-1 || install matchbox-window-manager=1.2-osso21-1 (maemo version has epoch, wheezy doesn't)
|-
| module-init-tools ||3.4-1maemo5+0m5 3.4-1maemo5+0m5 || - || In wheezy this is transitional package for kmod, which will brick the device.
|-
| mtools ||3.9.10-0osso4 || 4.0.17-1 || none
|-
| ncurses-base ||5.7+20081213-1.maemo1+0m5 || 5.9-10 || none
|-
| netbase ||1:4.24.osso9 ||  - || New netbase uses ifupdown, which is not used on maemo (and depends initscripts, which depends debianutils and coreutils)
|-
| openssh-client ||1:5.1p1-6.maemo5 ||  1:6.0p1-4 || none
|-
| openssh-server ||1:5.1p1-6.maemo5 ||  1:6.0p1-4 || none
|-
| openssl ||0.9.8n-1+maemo4+0m5 || 1.0.1e-2 || none
|-
| passwd ||1:4.0.18.1-7+etch1maemo1.m5 ||  - || Built. Needs debianutils
|-
| perl-base ||5.8.3-3osso13+0m5 || 5.14.2-20 || none
|-
| pulseaudio ||0.9.15-1maemo43+0m5 ||  - || Building waits some other packages
|-
| pulseaudio-esound-compat ||0.9.15-1maemo43+0m5 ||  - || Building waits some other packages
|-
| pulseaudio-module-bluetooth ||0.9.15-1maemo43+0m5 ||  - || Building waits some other packages
|-
| pulseaudio-module-gconf ||0.9.15-1maemo43+0m5 ||  - || Building waits some other packages
|-
| readline-common ||5.2-2maemo2+0m5 || 6.2+dfsg-0.1 || none
|-
| shared-mime-info ||0.30-2maemo5+0m5 || 1.0-1 || none
|-
| sqlite3 ||3.6.14-1maemo4+0m5 || 3.7.13-1+deb7u1 || none
|-
| sudo ||1:1.6.8p12-4osso22+0m5 1:1.6.8p12-4osso22+0m5 || 1.8.5p2-1+nmu1 || apt-get install sudo=1.8.5p2-1+nmu1 (maemo version has epoch, wheezy doesn't)
|-
| swi-prolog ||5.6.50-0maemo3+0m5 ||  - || Build issue: needs java (which keeps crashing qemu)
|-
| telepathy-gabble ||0.8.13-0maemo3+0m5 || 0.16.5-1+deb7u1 || none
|-
| telepathy-sofiasip ||0.6.2-0maemo4+0m5 0.6.2-0maemo4+0m5 || 0.7.4-1 || none
|-
| tracker ||0.6.95-35maemo1+0m5 ||  - || Build waits gstreamer-plugins
|-
| tracker-utils ||0.6.95-35maemo1+0m5 ||  - || Build waits gstreamer-plugins
|-
| udev ||0.125-7+142.maemo1+0m5 ||  - || Bricks the device.
|-
| udhcpc ||0.9.8cvs20050303-2osso7 ||  - || Comes from busybox.
|-
| upstart ||0.3.8-67+0m5 ||  - || Building issue (define!)
|-
| usbutils ||0.72-8osso2 || 1:005-3 || none
|-
| x11-common ||1:7.3+10.0maemo2 ||  - || Built. Installing clashes files from system-services (which is maemo specific, open source package) 
|-
| x11-xkb-utils ||7.4+1-maemo2+0m5 || 7.7~1 || none
|-
| xkb-data ||1.5-2maemo15+0m5 || 2.5.1-3 || none
|-
| xserver-xorg-core ||2:1.6.99.1-0osso20090208.108+0m5 ||  - || Built. Needs newer udev >= 149 (maemo has 142)
|-
| xserver-xorg-input-evdev ||1:2.1.99-1osso20090206.12+0m5 ||  - || Built. Needs newer xserver-xorg-core 
|-
| xserver-xorg-video-fbdev ||1:0.4.0-180+0m5 ||  - || Built. Needs newer xserver-xorg-core 
|-
| zlib1g ||1:1.2.3-9.osso9+0m5 || 1:1.2.7.dfsg-13 || none
|-
}