SQL2Diagram: A sourceforge project that I am involved in; we use that program at work to keep track of our database structure, consisting of 250+ tables in several modules. It basically parses the SQL Create Table statements and generates both
Installing Java Stored Procedures on PostgreSQL 8.0 (Win)
February 2005 look at the page PL Java Website.change the file C:\Program Files\PostgreSQL\8.0\data\postgresql.conf: dynamic_library_path = ‘$libdir;C:/Program Files/PostgreSQL/8.0/pljava’custom_variable_classes = ‘pljava’pljava.classpath = ‘C:/Program Files/PostgreSQL/8.0/pljava/pljava.jar’ Set the classpath: set CLASSPATH=%CLASSPATH%;deploy.jar;..\jdbc\postgresql-8.0.309.jdbc2.jar;pljava.jar change into directory “Program Files\PostgreSQL\8.0\pljava” and execute java org.postgresql.pljava.deploy.Deployer -install -database mydatabase -user
Use patched files in RPMs
see Packaging software with RPM diff -uNr the_package/the_file \ the_package/the_file.new > the_file.patchcopy the patch file to /usr/src/redhat/SOURCES The spec file has those lines: After Sources:Patch0: the_file.patch After %setup, before %build %patch -p1 To get your new version from the original
Package a Perl module
First check if somebody did already the job, e.g. on artfiles.org RPMS (SRPMS) or just for RPMS: RPMPan or this search site: Linux Software Directory . You need to install perl-Archive-Tar-1.08-2.noarch.rpm and perl-RPM-Specfile-1.17-1.noarch.rpm.A description of the module perl-RPM-Specfile can be
The file list conversion from OpenPKG
rpmtool:One idea could be, to download the file from the OpenPKG CVS and save it to /usr/bin/rpmtool; you need to change the first line of that file to #!/bin/bashAlso add at the top of the spec file: %define l_rpmtool /usr/bin/rpmtool
Converting OpenPKG spec file to Fedora
have a look at Building Packages with OpenPKGSee /usr/local/kolabopenpkg/etc/openpkg/rpmmacros to know what the macros (e.g. %l_musr) mean. To get the spec file, install the OpenPKG source package: /kolab/bin/openpkg rpm -i kolab-webadmin-0.4.0-20050318.src.rpm Copy the /kolab/RPM/SRC/kolab-webadmin/kolab-webadmin.spec to /usr/src/redhat/SPECS;Copy the other files (e.g.
Quick RPM lookaround
April 2005:That is how I learnt about RPM packaging of software for Fedora Linux.My goal was to create Fedora packages for Kolab, which is packaged with OpenPKG. Links to RPM introductions The Basics of Developing With RPM Maximum RPM Manual
Find IP address of a Pocket Print Server (e.g. DP-301P+)
on the linux console, type: i=1; \while [ $i != 254 ]; do \ ping -c 1 192.168.1.$i; \ i=`expr $i + 1`; \donearp -a That should give a list of all computers on that subnet 192.168.1.0. The MAC address
VPN between 2 networks with same IP address scheme (Windows)
Problem is, the routing does not work. Solution is: On DOS command prompt, type route add 192.168.1.84 MASK 255.255.255.255 192.168.1.160 …1.84 is the number of the computer you want to contact in the other network, …1.160 is the client IP
GIMP, Gaim, GTK
Install gimp 2.0 and gaim 0.79 on Windows, problems with GTK 2.4:according to the gimpwin-users list, do this:Install Gaim’s GTK+- 2.2.4, then Gaim, then uninstall Gaim’s GTK+-, and install GTK+- 2.4.1 and Gimp. Gaim should still work with GTK+- 2.4.1.You