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)

---

}

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