Ctrl-Alt-Backspace / ctrl_alt_bksp
Ref:
http://alanyih.blogspot.com/2010/05/slitaz-setxkbmap.html
Extract from:
https://wiki.archlinux.org/index.php/Xorg
[..]
Ctrl-Alt-Backspace does not work
There are two ways of restoring Ctrl+Alt+Backspace; with and without input-hotplugging. Using hot-plugging is recommended.
With input hot-plugging
System-wide
Within /etc/X11/xorg.conf.d/10-evdev.conf, simply add the following:
Section "InputClass"
Identifier "Keyboard Defaults"
MatchIsKeyboard "yes"
Option "XkbOptions" "terminate:ctrl_alt_bksp"
EndSection
Note: On KDE, this system-wide setting has no effect. To restore, go to Kickoff > Computer > System Settings which will open up the System Settings window. Click on 'Input Devices'. In this new window click the Keyboard tab and then click on the advanced tab. In this new window, click the box for 'Configure keyboard options.' Expand the entry for 'Key sequence to kill the X server' and ensure Control + Alt + Backspace is checked. Click Apply and close the System Settings window. You now have your CTRL-ALT-Backspace back in KDE.
User-specific
Another way is to put this line in xinitrc:
setxkbmap -option terminate:ctrl_alt_bksp
Note: This setting has no effect on Gnome 3.
Without input hot-plugging
New Xorg disables zapping with Ctrl+Alt+Backspace by default. You can enable it by adding the following line to /etc/X11/xorg.conf,
Option "XkbOptions" "terminate:ctrl_alt_bksp"
to InputDevice section for keyboard.
2011-11-30
2011-11-25
Slitaz -- navimap / easymap
1.
http://easymap.land.moi.gov.tw
8. 系統更新，請更新java版本至1.6 JRE 6(update 26~)，否則系統將無法正常運作。
2.
http://navimap.land.moi.gov.tw
Slitaz -- java6-jdk
1.
tux@slitaz:~$ uname -a
Linux slitaz 2.6.37-slitaz #2 SMP Wed Nov 2 22:01:57 CET 2011 i686 GNU/Linux
tux@slitaz:~$ java -version
java version "1.6.0_29"
Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
Java HotSpot(TM) Server VM (build 20.4-b02, mixed mode)
tux@slitaz:~$
2.
tux@slitaz:~$ ls -l /usr/lib/mozilla/plugins
total 0
lrwxrwxrwx 1 root root 34 Nov 25 19:48 libflashplayer.so -> /usr/share/flash/libflashplayer.so
lrwxrwxrwx 1 root root 50 Nov 25 19:09 libnpjp2.so -> /usr/lib/java/jdk1.6.0_29/jre/lib/i386/libnpjp2.so
tux@slitaz:~$
3.
tux@slitaz:~$ ls -l /usr/lib/java/jdk1.6.0_29/jre/lib/fonts/fall*
lrwxrwxrwx 1 root root 36 Nov 25 19:43 /usr/lib/java/jdk1.6.0_29/jre/lib/fonts/fallback -> /usr/share/fonts/truetype/droid-font
tux@slitaz:~$
4.
tux@slitaz:~$ cat get-java6-jdk.diff
--- get-java6-jdk-orig
+++ get-java6-jdk
@@ -6,9 +6,9 @@
# Author : Kévin DA SILVA
PACKAGE="java6-jdk"
-VERSION="1.6.0_13"
-URL="http://raphaello.univ-fcomte.fr/ftp/java/Jdk"
-TARBALL="jdk-6u13-linux-i586.bin"
+VERSION="1.6.0_29"
+URL="http://download.oracle.com/otn-pub/java/jdk/6u29-b11/"
+TARBALL="jdk-6u29-linux-i586.bin"
TEMP_DIR="/tmp/$PACKAGE.$$"
ROOT="$1"
@@ -80,8 +80,9 @@
post_install()
{
echo -n "Processing post install commands..."
- cd /usr/lib/firefox*/plugins
- ln -s /usr/lib/java/jdk\$VERSION/jre/plugin/i386/ns7/libjavaplugin_oji.so
+ mkdir -p /usr/lib/mozilla/plugins
+ cd /usr/lib/mozilla/plugins
+ ln -s /usr/lib/java/jdk\$VERSION/jre/lib/i386/libnpjp2.so
#lien mit dans red5 /usr/bin/javajdk
cd /usr/bin
@@ -94,8 +95,11 @@
post_remove()
{
- rm -f /usr/lib/firefox*/plugins/libjavaplugin_oji.so
+ rm -f /usr/lib/mozilla/plugins/libnpjp2.so
rm -f /usr/bin/java
+ rm -f /usr/bin/javac
+ rm -f /usr/bin/javadoc
+ rm -f /usr/bin/javap
}
EOT
tux@slitaz:~$
2011-11-02
Slitaz -- LibreOffice / langpack
tux@slitaz:~$ echo ${LANG/_/-} ${LANG%_*} ${LANG%.*} | sed s/_/-/
zh-TW.UTF-8 zh zh-TW
tux@slitaz:~$ diff get-LibreOffice-orig get-LibreOffice
--- get-LibreOffice-orig
+++ get-LibreOffice
@@ -24,7 +24,7 @@
TARBALL="LibO_${VER}_${SUFFIX}"
-for LOC in ${LANG/_/-} ${LANG%_*}; do
+for LOC in ${LANG/_/-} ${LANG%_*} ${LANG%.*} | sed s/_/-/; do
L_SUFFIX="Linux_x86_langpack-rpm_$LOC.tar.gz"
L_TARBALL="LibO_${VER}_${L_SUFFIX}"
LANG_URL="$WGET_URL/${VERSION}/rpm/x86/${L_TARBALL}"
tux@slitaz:~$
----
get-LibreOffice
tar: can't open '/tmp/src.1650/LibO_3.4.3_Linux_x86_langpack-rpm_zh.tar.gz': No such file or directory
http://download.documentfoundation.org/libreoffice/stable/3.4.3/rpm/x86/LibO_3.4.3_Linux_x86_langpack-rpm_zh-TW.tar.gz
1.
tux@slitaz:~$ head -1 /tmp/get-LibreOffice.log
tar: can't open '/tmp/src.1650/LibO_3.4.3_Linux_x86_langpack-rpm_zh.tar.gz': No such file or directory
tux@slitaz:~$ tazpkg info get-LibreOffice
Tazpkg information
================================================================================
Package : get-LibreOffice
Version : 1.2
Category : office
Short desc : Productivity suite.
Maintainer : ben@seawolfsanctuary.com
Web site : http://www.documentfoundation.org
================================================================================
tux@slitaz:~$ tazpkg info LibreOffice
Tazpkg information
================================================================================
Package : LibreOffice
Version : 3.4.3
Category : office
Short desc : Productivity suite.
Maintainer :
Depends : java6-jre
Web site : http://www.libreoffice.org
================================================================================
2.
http://download.documentfoundation.org/libreoffice/stable/3.4.3/rpm/x86/
[..]
| LibO_3.4.3_Linux_x86_langpack-rpm_xh.tar.gz | 25-Aug-2011 13:57 | 7.8M | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_xh.tar.gz.asc | 25-Aug-2011 13:57 | 836 | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_zh-CN.tar.gz | 25-Aug-2011 13:57 | 1.7M | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_zh-CN.tar.gz.asc | 25-Aug-2011 13:57 | 836 | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_zh-TW.tar.gz | 25-Aug-2011 13:57 | 1.7M | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_zh-TW.tar.gz.asc | 25-Aug-2011 13:57 | 836 | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_zu.tar.gz | 25-Aug-2011 13:57 | 1.6M | Details | |
| LibO_3.4.3_Linux_x86_langpack-rpm_zu.tar.gz.asc | 25-Aug-2011 13:57 | 836 | Details |
3.
tux@slitaz:~$ grep LOC /usr/bin/get-LibreOffice
for LOC in ${LANG/_/-} ${LANG%_*}; do
L_SUFFIX="Linux_x86_langpack-rpm_$LOC.tar.gz"
echo "Added $LANG ($LOC)."
tux@slitaz:~$ echo ${LANG/_/-}
zh-TW.UTF-8
tux@slitaz:~$ echo ${LANG%_*}
zh
tux@slitaz:~$ echo ${LANG/_/-} ${LANG%_*}
zh-TW.UTF-8 zh
2011-10-23
Slitaz -- Java Plug-in : libnpjp2.so
tazweb-1.4
midori-0.3.6
firefox-4.0.1
google-chrome-unstable-16.0.912.4-r106469
opera-11.52.1100
Java plug-in -- libnpjp2.so
Java(TM) Plug-in 1.6.0_17
Description: The next generation Java plug-in for Mozilla browsers.
Location: /usr/lib/java/jre1.6.0_17/lib/i386/libnpjp2.so
get-java6-jre and get-java6-jdk -- libjavaplugin_oji.so don't work.
echo -n "Processing post install commands..."
cd /usr/lib/firefox*/plugins
ln -s /usr/lib/java/jre\$VERSION/plugin/i386/ns7/libjavaplugin_oji.so
ln -s /usr/lib/java/jdk\$VERSION/jre/plugin/i386/ns7/libjavaplugin_oji.so
1.
root@slitaz:~# ls -l /usr/lib/mozilla/plugins/
total 0
lrwxrwxrwx 1 root root 34 Oct 23 15:27 libflashplayer.so -> /usr/share/flash/libflashplayer.so
lrwxrwxrwx 1 root root 46 Oct 23 16:24 libnpjp2.so -> /usr/lib/java/jre1.6.0_17/lib/i386/libnpjp2.so
root@slitaz:~#
2. How do I test whether Java is working on my computer?
http://www.java.com/en/download/testjava.jsp
Your Java configuration is as follows:
Vendor: Sun Microsystems Inc.
Version: Java SE 6 Update 17
Operating System: Linux 2.6.37-slitaz
Architecture: i386
3. tazweb-1.4
file:///usr/share/doc/tazweb/tazweb.html
SliTaz Web Browser
[..]
The browser fast, very fast and small, the binary is about 24 Kb and uses the Webkit engine for page rendering and therefore supports all the latest web standards as well as Javascript and Flash animations or videos.
4. midori-0.3.6
about:version
Version numbers in brackets show the version used at runtime.
Command line midori
Midori 0.3.6
WebKitGTK+ 1.2.7 (1.2.7)
GTK+ 2.24.4 (2.24.4)
Glib 2.28.6 (2.28.7)
libsoup 2.34.0
libnotify Yes
libidn No
libunique No
libhildon No
Platform Linux i686
Identification Mozilla/5.0 (X11; Linux) AppleWebKit/531.2+ Midori/0.3
Netscape Plugins:
libflashplayer.so Shockwave Flash
libnpjp2.so Java(TM) Plug-in 1.6.0_17
Video Formats:
H264 false
Ogg Theora false
WebM false
5. firefox-4.0.1
about:plugins
Java(TM) Plug-in 1.6.0_17
File: libnpjp2.so
Version:
The next generation Java plug-in for Mozilla browsers.
http://www.mozilla.org/en-US/plugincheck/
6. google-chrome-unstable-16.0.912.4-r106469
about:plugins
Java - Version: 1.6.0_17 Download Critical Security Update
The next generation Java plug-in for Mozilla browsers.
Name: Java(TM) Plug-in 1.6.0_17
Description: The next generation Java plug-in for Mozilla browsers.
Version: 1.6.0_17
Location: /usr/lib/java/jre1.6.0_17/lib/i386/libnpjp2.so
7. opera-11.52.1100
opera:about
About Opera
Version information
Version 11.52
Build 1100
Platform Linux
System i686, 2.6.37-slitaz
Browser identification
Opera/9.80 (X11; Linux i686; U; en) Presto/2.9.168 Version/11.52
Paths
Preferences
/home/tux/.opera/operaprefs.ini
Saved session
/home/tux/.opera/sessions/autopera.win
Bookmarks
/home/tux/.opera/bookmarks.adr
Opera directory
/home/tux/.opera/
Cache
/home/tux/.opera/cache/
Help documents
/home/tux/.opera/opcache/
Mail directory
/home/tux/.opera/mail/
Plug-in path
/usr/lib/opera/plugins
/usr/lib/mozilla/plugins
User CSS directory
/home/tux/.opera/styles/user/
.
2011-10-07
Slitaz -- ogdi
What is OGDI
OGDI is the Open Geographic Datastore Interface. OGDI is an application programming interface (API) that uses a standardized access methods to work in conjunction with GIS software packages (the application) and various geospatial data products. OGDI uses a client/server architecture to facilitate the dissemination of geospatial data products over any TCP/IP network, and a driver-oriented approach to facilitate access to several geospatial data products/formats.1.
root@slitaz:~# tazpkg info ogdi
Tazpkg information
================================================================================
Package : ogdi
Version : 3.2.0b2
Category : misc
Short desc : Open Geographic Datastore Interface Library
Maintainer : alanyih
Depends : expat zlib proj
Build deps : file expat-dev zlib-dev
Web site : http://ogdi.sourceforge.net/
================================================================================
root@slitaz:~#
2.
http://localhost/cooker/cooker.cgi?pkg=ogdi
Package: ogdi
receipt
Cook summary
Summary for: ogdi 3.2.0b2
================================================================================
Produced : 668.0K
Packed : 620.0K
Compressed : 160.0K
Files : 18
Cook time : 10s
Cook date : 2011-10-07 16:12
================================================================================
Cook log
Cook: ogdi 3.2.0b2
================================================================================
QA: checking package receipt...
Checking build dependencies...
Extracting: ogdi-3.2.0.beta2.tar.gz
Executing: compile_rules
configure: loading site script /etc/slitaz/cook.site
checking for i486-slitaz-linux-gcc... i486-slitaz-linux-gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether i486-slitaz-linux-gcc accepts -g... yes
checking for i486-slitaz-linux-gcc option to accept ISO C89... none needed
checking for dlopen in -ldl... yes
checking for -shared ... no(1)
checking for ld -shared ... yes
checking how to run the C preprocessor... i486-slitaz-linux-gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
[..]
================================================================================
Pack: ogdi 3.2.0b2
================================================================================
Executing: genpkg_rules
Copying receipt... OK
Creating the list of files... OK
Executing strip on all files... OK
Creating md5sum of files... OK
Compressing the fs... OK
Updating receipt sizes... OK
Creating full cpio archive... OK
Restoring original package tree... OK
QA: Checking for empty package... OK
================================================================================
Package: ogdi-3.2.0b2.tazpkg
Summary for: ogdi 3.2.0b2
================================================================================
Produced : 668.0K
Packed : 620.0K
Compressed : 160.0K
Files : 18
Cook time : 10s
Cook date : 2011-10-07 16:12
================================================================================
3. Fixme!
mkdir -p /home/slitaz/wok/ogdi/install/lib/ogdi
mv -f /home/slitaz/wok/ogdi/install/lib/libogdi.so.3.2 /home/slitaz/wok/ogdi/install/lib
cp /home/slitaz/wok/ogdi/source/ogdi-3.2.0b2/bin/Linux/libogdi.so /home/slitaz/wok/ogdi/install/lib/ogdi
mv: can't rename '/home/slitaz/wok/ogdi/install/lib/libogdi.so.3.2': No such file or directory
make[2]: *** [install-so-link] Error 1
.
2011-10-05
Slitaz -- PyQt4
root@slitaz:~# python
Python 2.7.1 (r271:86832, Apr 6 2011, 10:12:09)
[GCC 4.5.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from PyQt4.QtCore import QT_VERSION_STR, PYQT_VERSION_STR
>>> print QT_VERSION_STR, PYQT_VERSION_STR
4.7.3 4.8.3
>>> quit()
root@slitaz:~# tazpkg info PyQt-x11-gpl
Tazpkg information
================================================================================
Package : PyQt-x11-gpl
Version : 4.8.3
Category : development
Short desc : PyQt
Maintainer : allan316@gmail.com
Depends : python libQtDesigner libQtScript libQtCore libQtGui libQtWebkit libQtXml libQtNetwork libQtSvg libQtSql libQtDBus libQtClucene sip gcc-lib-base dbus
Build deps : python-dev Qt4-dev qmake libQtDesigner libQtScript libQtCore libQtGui libQtWebkit libQtXml libQtNetwork libQtSvg libQtSql libQtDBus libQtClucene sip sip-dev
Web site : http://www.riverbankcomputing.co.uk
================================================================================
root@slitaz:~# tazpkg list | grep ^qt4
qt4 4.7.3 meta
qt4-phonon 4.7.3 multimedia
root@slitaz:~#
2011-10-02
Slitaz -- cookutils
SliTaz Cook & Cooker
The SliTaz Cookutils provide tools and utils to help build SliTaz packages. They are easy to use and learn, fast and light. You will be able to create SliTaz packages in a few commands. The cookutils provide the 'cook' utility and the Cooker.
Cook lets you compile and create a package, provide a log file and check the receipt/package quality. The Cooker is a build bot with more automation and can be used as a frontend to cook since it provides a CGI/web interface which lets you view cook logs in a nice and colored way. Cook and the Cooker use the same DB files and wok, they both share blocked and broken packages as well as any activity.
For technical information, for example the coding style, etc, please refer to the README found in the source tree or in /usr/share/doc/cookutils.
SliTaz Cooker
Package:
Summary
Running command : Not running
Wok revision : 10963
Commits to cook : 0
Current cooklist : 0
Broken packages : 0
Blocked packages : 0
Packages: 3054 in the wok - 10 cooked - 3044 unbuilt - Server date: 2011-10-03 12:28
0%
Latest: cookorder.log commits.log installed.diff - Architecture i486: toolchain.log
Activity
2011-10-03 10:35 : No revision changes: 10963 vs 10963
2011-10-03 10:35 : Updating wok: /home/slitaz/wok-hg
2011-10-03 10:30 : Cook started for: glibc-base
2011-10-03 10:29 : Cook started for: glibc-extra-samba
2011-10-03 10:28 : Cook started for: glibc-locale
2011-10-03 10:28 : Cook started for: glibc-dev
2011-10-03 10:21 : Cook started for: locale-zh_TW
2011-10-03 10:21 : Cook started for: slitaz-tools
2011-10-03 10:20 : Cook started for: locale-zh_TW
2011-10-03 10:20 : Cook started for: slitaz-configs
2011-10-03 10:17 : Cook started for: glibc
2011-10-03 10:14 : Cook started for: locale-zh_TW
More activity
Cooknotes
More notes
Commits
Cooklist
Full cooklist
Broken
All broken packages
Blocked
Latest cook
2011-10-03 10:30 : glibc-base-2.13.tazpkg
2011-10-03 10:29 : glibc-extra-samba-2.13.tazpkg
2011-10-03 10:29 : glibc-locale-2.13.tazpkg
2011-10-03 10:28 : glibc-dev-2.13.tazpkg
2011-10-03 10:25 : glibc-2.13.tazpkg
2011-10-03 10:21 : locale-zh_TW-4.0.tazpkg
2011-10-03 10:21 : slitaz-tools-4.4.1.tazpkg
2011-10-03 10:20 : slitaz-configs-4.4.tazpkg
2011-10-03 10:08 : sudo-1.8.1p2.tazpkg
2011-10-03 10:08 : cooktest-1.0.tazpkg
SliTaz Website Cooker Documentation
.
2011-09-30
Slitaz -- pgadmin-1.10.0 / 1.14.0
Warning:
This version of pgAdmin has only been tested with PostgreSQL version 8.4 and below and may not function correctly with this server. Please upgrade pgAdmin.
tux@slitaz:~$ tazpkg info pgadmin
Tazpkg information
================================================================================
Package : pgadmin
Version : 1.10.0
Category : utilities
Short desc : PostgreSQL administration an management tools
Maintainer : erjo@slitaz.org
Depends : postgresql wxWidgets gtk+ libxslt libcomerr3 libkrb5 xorg-libXxf86vm
Build deps : libcrypto postgresql postgresql-dev libxslt-dev libxml2-dev wxWidgets-dev
Web site : http://www.pgadmin.org
================================================================================
tux@slitaz:~$ tazpkg info postgresql
Tazpkg information
================================================================================
Package : postgresql
Version : 9.0.4
Category : misc
Short desc : SQL database system.
Maintainer : pascal.bellard@slitaz.org
Depends : postgresql-client slitaz-base-files
Build deps : zlib-dev readline-dev ncurses-dev bison flex perl libxslt
Web site : http://www.postgresql.org/
================================================================================
tux@slitaz:~$
2011-09-15
Slitaz -- QGIS - GDAL
GDAL - Geospatial Data Abstraction Library
1.
tux@slitaz:~$ uname -a
Linux slitaz 2.6.37-slitaz #2 SMP Sat May 21 19:25:28 CEST 2011 i686 GNU/Linux
2.
tux@slitaz:~$ df -h
Filesystem Size Used Available Use% Mounted on
tmpfs 2.9G 511.4M 2.4G 17% /
tmpfs 1.6G 0 1.6G 0% /dev/shm
3.
tux@slitaz:~$ tazpkg list | tail -2
297 packages installed.
4.
tux@slitaz:~$ tazpkg info qgis
Tazpkg information
================================================================================
Package : qgis
Version : 1.7.0
Category : misc
Short desc : Geographic Information System (GIS)
Maintainer :
Web site : http://www.qgis.org
================================================================================
tux@slitaz:~$
5.
tux@slitaz:~$ tazpkg info gdal
Tazpkg information
================================================================================
Package : gdal
Version : 1.8.1
Category : misc
Short desc : Geospatial Data Abstraction Library
Maintainer :
Web site : http://www.gdal.org/
================================================================================
tux@slitaz:~$ gdal-config --version
1.8.1
6.
tux@slitaz:~$ gdal-config --dep-libs
-L/usr/lib -lgeos_c -lsqlite3 -lodbc -lodbcinst -lexpat -lxerces-c -lpthread -ljasper -lhdf5 -lmfhdfalt -ldfalt -logdi -lgif -ljpeg -lpng -lnetcdf -L/usr/lib/postgresql -lpq -lz -lpthread -lm -lrt -ldl -lcurl
7.
tux@slitaz:~$ gdal-config --formats
gxf gtiff hfa aigrid aaigrid ceos ceos2 iso8211 xpm sdts raw dted mem jdem envisat elas fit vrt usgsdem l1b nitf bmp pcidsk airsar rs2 ilwis rmf leveller sgi srtmhgt idrisi gsg ingr ers jaxapalsar dimap gff cosar pds adrg coasp tsx terragen blx msgn til r northwood saga xyz hf2 kmlsuperoverlay ozi wcs wms grib bsb jpeg2000 hdf5 hdf4 ogdi gif jpeg png netcdf pcraster rik rasterlite postgisraster
8.
tux@slitaz:~$ gdalinfo --formats
Supported Formats:
VRT (rw+v): Virtual Raster
GTiff (rw+v): GeoTIFF
NITF (rw+v): National Imagery Transmission Format
RPFTOC (rov): Raster Product Format TOC format
HFA (rw+v): Erdas Imagine Images (.img)
SAR_CEOS (rov): CEOS SAR Image
CEOS (rov): CEOS Image
JAXAPALSAR (ro): JAXA PALSAR Product Reader (Level 1.1/1.5)
GFF (rov): Ground-based SAR Applications Testbed File Format (.gff)
ELAS (rw+): ELAS
AIG (rov): Arc/Info Binary Grid
AAIGrid (rwv): Arc/Info ASCII Grid
SDTS (rov): SDTS Raster
OGDI (ro): OGDI Bridge
DTED (rwv): DTED Elevation Raster
PNG (rwv): Portable Network Graphics
JPEG (rwv): JPEG JFIF
MEM (rw+): In Memory Raster
JDEM (ro): Japanese DEM (.mem)
GIF (rwv): Graphics Interchange Format (.gif)
BIGGIF (rov): Graphics Interchange Format (.gif)
ESAT (ro): Envisat Image Format
BSB (rov): Maptech BSB Nautical Charts
XPM (rwv): X11 PixMap Format
BMP (rw+v): MS Windows Device Independent Bitmap
DIMAP (rov): SPOT DIMAP
AirSAR (ro): AirSAR Polarimetric Image
RS2 (ro): RadarSat 2 XML Product
PCIDSK (rw+v): PCIDSK Database File
PCRaster (rw): PCRaster Raster File
ILWIS (rw+v): ILWIS Raster Map
SGI (rw+): SGI Image File Format 1.0
SRTMHGT (rwv): SRTMHGT File Format
Leveller (rw+): Leveller heightfield
Terragen (rw+): Terragen heightfield
GMT (rw): GMT NetCDF Grid Format
netCDF (rw): Network Common Data Format
HDF4 (ro): Hierarchical Data Format Release 4
HDF4Image (rw+): HDF4 Dataset
ISIS3 (rov): USGS Astrogeology ISIS cube (Version 3)
ISIS2 (rov): USGS Astrogeology ISIS cube (Version 2)
PDS (rov): NASA Planetary Data System
TIL (ro): EarthWatch .TIL
ERS (rw+): ERMapper .ers Labelled
JPEG2000 (rwv): JPEG-2000 part 1 (ISO/IEC 15444-1)
L1B (ro): NOAA Polar Orbiter Level 1b Data Set
FIT (rwv): FIT Image
GRIB (rov): GRIdded Binary (.grb)
RMF (rw+): Raster Matrix Format
WCS (ro): OGC Web Coverage Service
WMS (ro): OGC Web Map Service
MSGN (ro): EUMETSAT Archive native (.nat)
RST (rw+): Idrisi Raster A.1
INGR (rw+v): Intergraph Raster
GSAG (rw): Golden Software ASCII Grid (.grd)
GSBG (rw+): Golden Software Binary Grid (.grd)
GS7BG (ro): Golden Software 7 Binary Grid (.grd)
COSAR (ro): COSAR Annotated Binary Matrix (TerraSAR-X)
TSX (ro): TerraSAR-X Product
COASP (ro): DRDC COASP SAR Processor Raster
R (rwv): R Object Data Store
PNM (rw+): Portable Pixmap Format (netpbm)
DOQ1 (ro): USGS DOQ (Old Style)
DOQ2 (ro): USGS DOQ (New Style)
ENVI (rw+v): ENVI .hdr Labelled
EHdr (rw+v): ESRI .hdr Labelled
GenBin (ro): Generic Binary (.hdr Labelled)
PAux (rw+): PCI .aux Labelled
MFF (rw+): Vexcel MFF Raster
MFF2 (rw+): Vexcel MFF2 (HKV) Raster
FujiBAS (ro): Fuji BAS Scanner Image
GSC (ro): GSC Geogrid
FAST (ro): EOSAT FAST Format
BT (rw+): VTP .bt (Binary Terrain) 1.3 Format
LAN (rov): Erdas .LAN/.GIS
CPG (ro): Convair PolGASP
IDA (rw+): Image Data and Analysis
NDF (ro): NLAPS Data Format
EIR (rov): Erdas Imagine Raw
DIPEx (ro): DIPEx
LCP (rov): FARSITE v.4 Landscape File (.lcp)
GTX (rw+v): NOAA Vertical Datum .GTX
LOSLAS (rov): NADCON .los/.las Datum Grid Shift
NTv2 (rw+v): NTv2 Datum Grid Shift
RIK (ro): Swedish Grid RIK (.rik)
USGSDEM (rw): USGS Optional ASCII DEM (and CDED)
GXF (ro): GeoSoft Grid Exchange Format
HTTP (ro): HTTP Fetching Wrapper
BAG (ro): Bathymetry Attributed Grid
HDF5 (ro): Hierarchical Data Format Release 5
HDF5Image (ro): HDF5 Dataset
NWT_GRD (ro): Northwood Numeric Grid Format .grd/.tab
NWT_GRC (ro): Northwood Classified Grid Format .grc/.tab
ADRG (rw+v): ARC Digitized Raster Graphics
SRP (rov): Standard Raster Product (ASRP/USRP)
BLX (rw): Magellan topo (.blx)
Rasterlite (rw): Rasterlite
PostGISRaster (ro): PostGIS Raster driver
SAGA (rw+v): SAGA GIS Binary Grid (.sdat)
KMLSUPEROVERLAY (rwv): Kml Super Overlay
XYZ (rwv): ASCII Gridded XYZ
HF2 (rwv): HF2/HFZ heightfield raster
OZI (rov): OZI
9.
tux@slitaz:~$ ogrinfo --formats
Supported Formats:
-> "ESRI Shapefile" (read/write)
-> "MapInfo File" (read/write)
-> "UK .NTF" (readonly)
-> "SDTS" (readonly)
-> "TIGER" (read/write)
-> "S57" (read/write)
-> "DGN" (read/write)
-> "VRT" (readonly)
-> "REC" (readonly)
-> "Memory" (read/write)
-> "BNA" (read/write)
-> "CSV" (read/write)
-> "NAS" (readonly)
-> "GML" (read/write)
-> "GPX" (read/write)
-> "KML" (read/write)
-> "GeoJSON" (read/write)
-> "Interlis 1" (read/write)
-> "Interlis 2" (read/write)
tux@slitaz:~$
.
2011-09-12
Slitaz -- postgis-1.5.3 -2
1.
postgres@slitaz:~$ tazpkg list-files postgis
Installed files with: postgis
================================================================================
/usr/bin/pgsql2shp
/usr/bin/shp2pgsql
/usr/lib/postgresql/postgis-1.5.so
/usr/share/postgresql/contrib/postgis-1.5/postgis.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_13_to_15.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_14_to_15.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_15_minor.sql
/usr/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql
/usr/share/postgresql/contrib/postgis-1.5/uninstall_postgis.sql
================================================================================
9 files installed with postgis.
2.
postgres@slitaz:~$ createdb -E utf-8 -T template0 --owner=postgis gis
postgres@slitaz:~$ psql -f /usr/share/postgresql/contrib/postgis-1.5/postgis.sql -d gis
postgres@slitaz:~$ psql -f /usr/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql -d gis
3.
postgres@slitaz:~$ psql -U postgis -d gis
psql (9.0.4)
Type "help" for help.
gis=# \set
AUTOCOMMIT = 'on'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
VERBOSITY = 'default'
VERSION = 'PostgreSQL 9.0.4 on i486-slitaz-linux-gnu, compiled by GCC i486-slitaz-linux-gcc (SliTaz) 4.5.2, 32-bit'
DBNAME = 'gis'
USER = 'postgis'
PORT = '5432'
ENCODING = 'UTF8'
4.
gis=# select lanname from pg_language;
lanname
----------
internal
c
sql
plpgsql
(4 rows)
5.
gis=# \d
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+----------
public | geography_columns | view | postgres
public | geometry_columns | table | postgres
public | spatial_ref_sys | table | postgres
(3 rows)
6.
gis=# \d spatial_ref_sys
Table "public.spatial_ref_sys"
Column | Type | Modifiers
-----------+-------------------------+-----------
srid | integer | not null
auth_name | character varying(256) |
auth_srid | integer |
srtext | character varying(2048) |
proj4text | character varying(2048) |
Indexes:
"spatial_ref_sys_pkey" PRIMARY KEY, btree (srid)
7.
gis=# select count(*) from spatial_ref_sys;
count
-------
3749
(1 row)
8.
gis=# select * from spatial_ref_sys limit 2;
srid | auth_name | auth_srid | srtext | proj4text
------+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------
3819 | EPSG | 3819 | GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408],AUTHORITY["EPSG","1024"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3819"]] | +proj=longlat +ellps=bessel +towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs
3821 | EPSG | 3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]] | +proj=longlat +ellps=aust_SA +no_defs
(2 rows)
9.
gis=# select srid,srtext from spatial_ref_sys where srid=3821;
srid | srtext
------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]]
(1 row)
gis=#
.
postgres@slitaz:~$ tazpkg list-files postgis
Installed files with: postgis
================================================================================
/usr/bin/pgsql2shp
/usr/bin/shp2pgsql
/usr/lib/postgresql/postgis-1.5.so
/usr/share/postgresql/contrib/postgis-1.5/postgis.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_13_to_15.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_14_to_15.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_15_minor.sql
/usr/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql
/usr/share/postgresql/contrib/postgis-1.5/uninstall_postgis.sql
================================================================================
9 files installed with postgis.
2.
postgres@slitaz:~$ createdb -E utf-8 -T template0 --owner=postgis gis
postgres@slitaz:~$ psql -f /usr/share/postgresql/contrib/postgis-1.5/postgis.sql -d gis
postgres@slitaz:~$ psql -f /usr/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql -d gis
3.
postgres@slitaz:~$ psql -U postgis -d gis
psql (9.0.4)
Type "help" for help.
gis=# \set
AUTOCOMMIT = 'on'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
VERBOSITY = 'default'
VERSION = 'PostgreSQL 9.0.4 on i486-slitaz-linux-gnu, compiled by GCC i486-slitaz-linux-gcc (SliTaz) 4.5.2, 32-bit'
DBNAME = 'gis'
USER = 'postgis'
PORT = '5432'
ENCODING = 'UTF8'
4.
gis=# select lanname from pg_language;
lanname
----------
internal
c
sql
plpgsql
(4 rows)
5.
gis=# \d
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+----------
public | geography_columns | view | postgres
public | geometry_columns | table | postgres
public | spatial_ref_sys | table | postgres
(3 rows)
6.
gis=# \d spatial_ref_sys
Table "public.spatial_ref_sys"
Column | Type | Modifiers
-----------+-------------------------+-----------
srid | integer | not null
auth_name | character varying(256) |
auth_srid | integer |
srtext | character varying(2048) |
proj4text | character varying(2048) |
Indexes:
"spatial_ref_sys_pkey" PRIMARY KEY, btree (srid)
7.
gis=# select count(*) from spatial_ref_sys;
count
-------
3749
(1 row)
8.
gis=# select * from spatial_ref_sys limit 2;
srid | auth_name | auth_srid | srtext | proj4text
------+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------
3819 | EPSG | 3819 | GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408],AUTHORITY["EPSG","1024"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3819"]] | +proj=longlat +ellps=bessel +towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs
3821 | EPSG | 3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]] | +proj=longlat +ellps=aust_SA +no_defs
(2 rows)
9.
gis=# select srid,srtext from spatial_ref_sys where srid=3821;
srid | srtext
------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]]
(1 row)
gis=#
.
Slitaz -- postgis-1.5.3
PostGIS 1.5.3 Release
The 1.5.3 release of PostGIS is now available. This is a minor release addressing a few issues that have been filed since the 1.5.2 release in addition to fixes that allow it to compile against PostgreSQL 9.1beta.1.
postgres@slitaz:~$ psql -U postgis -d gis
psql (9.0.4)
Type "help" for help.
2.
gis=# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.0.4 on i486-slitaz-linux-gnu, compiled by GCC i486-slitaz-linux-gcc (SliTaz) 4.5.2, 32-bit
(1 row)
3.
gis=# select postgis_full_version();
postgis_full_version
-------------------------------------------------------------------------------------------------------
POSTGIS="1.5.3" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS
(1 row)
4.
gis=# \! tazpkg info postgis
Tazpkg information
================================================================================
Package : postgis
Version : 1.5.3
Category : misc
Short desc : geographic objects support for PostgreSQL
Maintainer :
Depends : proj geos
Build deps : proj geos
Web site : http://postgis.org/
================================================================================
5.
gis=# \q
postgres@slitaz:~$
.
2011-09-07
Slitaz -- QGIS 1.7
 | Quantum GIS Documentation Version 1.7.0 Wrocław Please read this entire document for important information about this release. You find a PDF manual of the current version on the QGIS website. |
Whats new in Version 1.7.0 'Wrocław'?
This release is named after the town of Wrocław in Poland. The Department of Climatology and Atmosphere Protection, University of Wrocław kindly hosted our developer meeting in November 2010. Please note that this is a release in our 'cutting edge' release series. As such it contains new features and extends the programmatic interface over QGIS 1.0.x and QGIS 1.6.0. As with any software, there may be bugs and issues that we were not able to fix in time for the release. We therefore recommend that you test this version before rolling it out en-masse to your users.This release includes over 277 bug fixes and many new features and enhancements. Once again it is impossible to document everything here that has changed so we will just provide a bullet list of key new features here.
[..]
Available QGIS Data Provider Plugins
- WFS data provider
- Delimited text data provider
- GDAL provider
- GPS eXchange format provider
- Memory provider
- OGR data provider (compiled against GDAL/OGR library version 1.6.3, running against GDAL/OGR library version 1.6.3)
- Open Street Map data provider
- PostgreSQL/PostGIS data provider
- SpatiaLite data provider
- OGC Web Map Service version 1.3 data provider
Available Qt Database Plugins
- QSQLITE
- QMYSQL3
- QMYSQL
- QODBC3
- QODBC
- QPSQL7
- QPSQL
Available Qt Image Plugins
Qt Image Plugin Search Paths
/usr/lib/qt/plugins
/usr/bin
- bmp
- gif
- ico
- jpeg
- jpg
- mng
- pbm
- pgm
- png
- ppm
- svg
- svgz
- tif
- tiff
- xbm
- xpm
2011-08-25
Slitaz -- perl-dbd-oracle
complie perl module DBD::Oracle
# perl Makefile.PL
# make
# make install
1.
oracle@slitaz:~$ tazpkg list | grep perl
perl 5.12.3 development
perl-dbi-dbd 1.607 development
perl-uri 1.58 development
perl-xml-parser 2.40 development
perl-xml-simple 2.18 development
oracle@slitaz:~$
2.
http://cpan.stu.edu.tw/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.29_1.tar.gz
http://cpan.stu.edu.tw/modules/by-module/DBD/DBD-Oracle-1.28.tar.gz
3.
root@slitaz:/usr/src/DBD-Oracle-1.29_1# perl Makefile.PL
Using DBI 1.607 (for perl 5.012003 on i686-linux) installed in /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI/
Configuring DBD::Oracle for perl 5.012003 on linux (i686-linux)
Remember to actually *READ* the README file! Especially if you have any problems.
Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:'
client_version=10.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102
Checking for functioning wait.ph
System: perl5.012003 linux tank 2.6.30.6-slitaz #1 smp thu apr 8 21:19:10 cest 2010 i686 gnulinux
Compiler: cc -O2 -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override them:
CC: /usr/bin/gcc
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread
WARNING: If you have problems you may need to rebuild perl with threading enabled.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
Using DBD::Oracle 1.29_1.
Using DBD::Oracle 1.29_1.
Using DBI 1.607 (for perl 5.012003 on i686-linux) installed in /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
root@slitaz:/usr/src/DBD-Oracle-1.29_1#
4.
root@slitaz:/usr/src/DBD-Oracle-1.29_1# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.12.3/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.12.3/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.29_1\" -DXS_VERSION=\"1.29_1\" -fPIC "-I/usr/lib/perl5/5.12.3/i686-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 Oracle.c
cc -c -I/usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.29_1\" -DXS_VERSION=\"1.29_1\" -fPIC "-I/usr/lib/perl5/5.12.3/i686-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 dbdimp.c
cc -c -I/usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.29_1\" -DXS_VERSION=\"1.29_1\" -fPIC "-I/usr/lib/perl5/5.12.3/i686-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 oci8.c
oci8.c: In function ‘ora_blob_read_mb_piece’:
oci8.c:1781:4: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 6 has type ‘ub4’
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib" cc -shared -O2 -fstack-protector Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora_explain
root@slitaz:/usr/src/DBD-Oracle-1.29_1#
5.
root@slitaz:/usr/src/DBD-Oracle-1.29_1# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/Oracle.h
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/dbdimp.h
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/Oracle.bs
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/ocitrace.h
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/Oracle.so
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/mk.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/oraperl.ph
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/Oraperl.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/DBD/Oracle.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/DBD/Oracle/GetInfo.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/DBD/Oracle/Object.pm
Installing /usr/bin/ora_explain
Appending installation info to /usr/lib/perl5/5.12.3/i686-linux/perllocal.pod
root@slitaz:/usr/src/DBD-Oracle-1.29_1#
.
# perl Makefile.PL
# make
# make install
1.
oracle@slitaz:~$ tazpkg list | grep perl
perl 5.12.3 development
perl-dbi-dbd 1.607 development
perl-uri 1.58 development
perl-xml-parser 2.40 development
perl-xml-simple 2.18 development
oracle@slitaz:~$
2.
http://cpan.stu.edu.tw/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.29_1.tar.gz
http://cpan.stu.edu.tw/modules/by-module/DBD/DBD-Oracle-1.28.tar.gz
3.
root@slitaz:/usr/src/DBD-Oracle-1.29_1# perl Makefile.PL
Using DBI 1.607 (for perl 5.012003 on i686-linux) installed in /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI/
Configuring DBD::Oracle for perl 5.012003 on linux (i686-linux)
Remember to actually *READ* the README file! Especially if you have any problems.
Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:'
client_version=10.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102
Checking for functioning wait.ph
System: perl5.012003 linux tank 2.6.30.6-slitaz #1 smp thu apr 8 21:19:10 cest 2010 i686 gnulinux
Compiler: cc -O2 -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override them:
CC: /usr/bin/gcc
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread
WARNING: If you have problems you may need to rebuild perl with threading enabled.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
Using DBD::Oracle 1.29_1.
Using DBD::Oracle 1.29_1.
Using DBI 1.607 (for perl 5.012003 on i686-linux) installed in /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
root@slitaz:/usr/src/DBD-Oracle-1.29_1#
4.
root@slitaz:/usr/src/DBD-Oracle-1.29_1# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.12.3/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.12.3/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.29_1\" -DXS_VERSION=\"1.29_1\" -fPIC "-I/usr/lib/perl5/5.12.3/i686-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 Oracle.c
cc -c -I/usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.29_1\" -DXS_VERSION=\"1.29_1\" -fPIC "-I/usr/lib/perl5/5.12.3/i686-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 dbdimp.c
cc -c -I/usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -march=i486 -Os -pipe -fomit-frame-pointer -fno-strict-aliasing -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.29_1\" -DXS_VERSION=\"1.29_1\" -fPIC "-I/usr/lib/perl5/5.12.3/i686-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 oci8.c
oci8.c: In function ‘ora_blob_read_mb_piece’:
oci8.c:1781:4: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 6 has type ‘ub4’
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib" cc -shared -O2 -fstack-protector Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora_explain
root@slitaz:/usr/src/DBD-Oracle-1.29_1#
5.
root@slitaz:/usr/src/DBD-Oracle-1.29_1# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/Oracle.h
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/dbdimp.h
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/Oracle.bs
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/ocitrace.h
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/Oracle.so
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/auto/DBD/Oracle/mk.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/oraperl.ph
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/Oraperl.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/DBD/Oracle.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/DBD/Oracle/GetInfo.pm
Installing /usr/lib/perl5/site_perl/5.12.3/i686-linux/DBD/Oracle/Object.pm
Installing /usr/bin/ora_explain
Appending installation info to /usr/lib/perl5/5.12.3/i686-linux/perllocal.pod
root@slitaz:/usr/src/DBD-Oracle-1.29_1#
.
Slitaz -- Oracle XE 10g - perl
1.
oracle@slitaz:~$ perl oraxe-query.pl
Beijing
Bern
Bombay
Geneva
Hiroshima
London
Mexico City
Munich
Oxford
Roma
Sao Paulo
Seattle
Singapore
South Brunswick
South San Francisco
Southlake
Stretford
Sydney
Tokyo
Toronto
Utrecht
Venice
Whitehorse
2.
oracle@slitaz:~$ cat oraxe-query.pl
#!/usr/bin/perl
use DBI;
use strict;
use vars qw($dbh $sth);
# get a database handle
$dbh = DBI->connect('dbi:Oracle:', 'hr@localhost/XE', 'oracle');
# get a statement handle
$sth=$dbh->prepare('SELECT city FROM locations');
# execute the statement handle
$sth->execute();
# loop through the results
while (my ($r_city) = $sth->fetchrow())
{
print " $r_city \n";
}
$sth->finish();
$dbh->disconnect();
oracle@slitaz:~$
3.
Extract from
An Introduction to DBD::Oracle
[..]
4 Using DBI and DBD::Oracle
4.1 Understanding DBI
Since its inception by Tim Bunce in 1994, DBI (DataBase Interface) has been the de facto standard for interfacing databases with the Perl language. Thanks to the designers' foresight, DBI is database-independent, with methods, variables, and conventions that provide a consistent programming interface, no matter what database management system is being used.
As an API, DBI is just an interface to a database driver--in our case, DBD::Oracle--so you can think of DBI as the glue that links the Perl language to a specific database driver, as seen in the diagram below.
DBD::Oracle Diagram
.
Slitaz -- lxpanel font
Panel Setting --> Appearance --> Font --> Custom color
1.
litaz-core.iso 2011-Aug-21 04:08:36 30.0M
http://mirror.slitaz.org/iso/rolling/slitaz-core.iso
2.
tux@slitaz:~$ grep color /etc/lxpanel/slitaz/panels/bottom
tintcolor=#ffffff
usefontcolor=1
fontcolor=#ffffff
tux@slitaz:~$ grep color /etc/lxpanel/slitaz/panels/panel
tintcolor=#ffffff
usefontcolor=1
fontcolor=#ffffff
tux@slitaz:~$ grep color .config/lxpanel/slitaz/panels/panel
tintcolor=#ffffff
usefontcolor=1
fontcolor=#ffffff
tux@slitaz:~$ grep color .config/lxpanel/slitaz/panels/bottom
tintcolor=#ffffff
usefontcolor=1
fontcolor=#ffffff
3.
tux@slitaz:~$ grep color .config/lxpanel/slitaz/panels/panel
tintcolor=#ffffff
usefontcolor=0
fontcolor=#ffffff
tux@slitaz:~$ grep color .config/lxpanel/slitaz/panels/bottom
tintcolor=#ffffff
usefontcolor=1
fontcolor=#ffffff
tux@slitaz:~$
.
2011-08-23
Slitaz -- Oracle XE - perl - lighttpd
Oracle 10g XE + DBD::Oracle + FastCGI
Fast CGI on Lighttpd
Invocation number 4 PID 14231.Requested uri is /index.html
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
1.
oracle@slitaz:~$ ps ax | grep httpd
14221 www 0:00 /usr/sbin/lighttpd -f /etc/lighttpd/lighttpd.conf
14222 www 0:00 /usr/bin/perl /usr/bin/lighttpd.fcgi
14225 www 0:00 /usr/bin/perl /usr/bin/lighttpd.fcgi
14228 www 0:00 /usr/bin/perl /usr/bin/lighttpd.fcgi
14231 www 0:00 /usr/bin/perl /usr/bin/lighttpd.fcgi
14239 root 0:00 leafpad /var/log/lighttpd/error.log
14376 oracle 0:00 grep httpd
2.
oracle@slitaz:~$ ls /tmp/fastcgi.socket*
/tmp/fastcgi.socket-0 /tmp/fastcgi.socket-2
/tmp/fastcgi.socket-1 /tmp/fastcgi.socket-3
3.
oracle@slitaz:~$ cat /usr/bin/lighttpd.fcgi
#!/usr/bin/perl
use CGI::Fast qw(:standard);
use DBI;
use URI;
$ENV{FCGI_SOCKET_PATH} = "/tmp/fastcgi.socket";
$ENV{FCGI_LISTEN_QUEUE} = 100;
$COUNTER = 0;
my $dbh = DBI->connect('dbi:Oracle:', 'hr@localhost/XE', 'oracle') || die ;
while (new CGI::Fast) {
print header;
print start_html("Fast CGI Rocks");
h1("Fast CGI on Lighttpd"),
"Invocation number ",b($COUNTER++),
" PID ",b($$),".",
hr;
my $uri = URI->new( $ENV{REQUEST_URI} );
print br;
print "Requested uri is ",b($uri);
my $sql = 'SELECT * from v$version';
my $sth = $dbh->prepare($sql);
$sth->execute();
while (my (@s) = $sth->fetchrow_array())
{
print br;
print b($s[0]);
}
print end_html;
}
4.
oracle@slitaz:~$ netstat -nltp
netstat: showing only processes with your user ID
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:6000 0.0.0.0:* LISTEN -
tcp 0 0 127.0.0.1:8080 0.0.0.0:* LISTEN 10723/tnslsnr
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 10723/tnslsnr
tcp 0 0 0.0.0.0:55037 0.0.0.0:* LISTEN 10749/xe_d000_XE
tcp 0 0 :::6000 :::* LISTEN -
oracle@slitaz:~$
.
2011-08-18
Slitaz -- Oracle JDeveloper 10g
Oracle JDeveloper
Oracle JDeveloper is a free integrated development environment that simplifies the development of Java-based SOA applications and user interfaces with support for the full development life cycle.
| Oracle JDeveloper 10.1.3 Archive | |
 | Oracle JDeveloper 10g (Version 10.1.3.0, build 3673) Supported on Windows NT/2000/XP, Linux, Solaris, HP-UX, and Macintosh |
root@slitaz:~# java -version
java version "1.6.0_13"
Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
Java HotSpot(TM) Server VM (build 11.3-b02, mixed mode)
root@slitaz:~# /dev/shm/jdev10g/jdev/bin/jdev &
Oracle JDeveloper 10g 10.1.3
Copyright 1997, 2005 Oracle. All Rights Reserved
.
Slitaz -- Oracle 10g XE
Extract from:
Oracle Database 10g Express Edition
Free to develop, deploy, and distribute
Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer.
Oracle Database XE is a great starter database for:
- Developers working on PHP, Java, .NET, XML, and Open Source applications
- DBAs who need a free, starter database for training and deployment
- Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
- Educational institutions and students who need a free database for their curriculum
1.
oracle@slitaz:~$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 18 18:47:27 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> select count(*) from hr.employees;
COUNT(*)
----------
107
SQL> exit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
2.
oracle@slitaz:~$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-AUG-2011 19:05:41
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 18-AUG-2011 16:27:27
Uptime 0 days 2 hr. 38 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/nerk/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/nerk/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slitaz)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=P)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
3.
oracle@slitaz:~$ netstat -nltp
netstat: showing only processes with your user ID
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:36583 0.0.0.0:* LISTEN 8923/xe_d000_XE
tcp 0 0 127.0.0.1:8080 0.0.0.0:* LISTEN 9078/tnslsnr
tcp 0 0 0.0.0.0:6000 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 9078/tnslsnr
tcp 0 0 :::6000 :::* LISTEN -
tcp 0 0 :::80 :::* LISTEN -
tcp 0 0 :::82 :::* LISTEN -
oracle@slitaz:~$
.
