--- sql-ledger-2.8.18.orig/debian/.cvsignore +++ sql-ledger-2.8.18/debian/.cvsignore @@ -0,0 +1,3 @@ +files +sql-ledger +sql-ledger.substvars --- sql-ledger-2.8.18.orig/debian/TODO +++ sql-ledger-2.8.18/debian/TODO @@ -0,0 +1,29 @@ +Known bugs : +- postinst doesn't handle well apache2. It tries to create /etc/apache/httpd.conf + => Make use of "wwwconfig-common" to be nicer about apache configuration ? + +1/ Improve README.Debian to provide reliable secure instructions. + +2/ Automatize as much as possible: + - add plpgsql support in "template1" db automatically + - create a "sql-ledger" user in Postgres (password should be requested + by debconf) + - configure PostgreSQL to use password authentication for "sql-ledger" + user by default : + Currenly this means adding a line in pg_hba.conf: + local all sql-ledger md5 + This line should be before the lines: + # "local" is for Unix domain socket connections only + local all all ident sameuser + +3/ Upstream docs speak of locking SQL-ledger during "manual upgrades". Maybe + we should do that automatically: lock in preinst, unlock in postinst. + If the upgrade involves a new upstream version, we could decide to not + unlock to make sure that the administrator upgrades the database by + logging itself and then unlocking the DB manually. Otherwise we might + have "active sessions" working with the new code but with the old + database. + +4/ Starting from now (v2.6.4), anything described in various UPGRADE-* + files should be done automatically if at all possible. + --- sql-ledger-2.8.18.orig/debian/watch +++ sql-ledger-2.8.18/debian/watch @@ -0,0 +1,2 @@ +version=3 +http://www.sql-ledger.com/source/sql-ledger-(.*).tar.gz --- sql-ledger-2.8.18.orig/debian/copyright.pre +++ sql-ledger-2.8.18/debian/copyright.pre @@ -0,0 +1,7 @@ +This package was debianized by Finn-Arne Johansen on +Sun, 4 May 2003 05:21:25 +0200. + +It was downloaded from http://prdownloads.sourceforge.net/sql-ledger/sql-ledger-2.0.6.tar.gz?download + +Upstream Author: Dieter Simader dsimader@sql-ledger.org + --- sql-ledger-2.8.18.orig/debian/rules +++ sql-ledger-2.8.18/debian/rules @@ -0,0 +1,29 @@ +#!/usr/bin/make -f + +include /usr/share/quilt/quilt.make + +build: patch + dh build + +clean: unpatch + dh clean + rm -f sql-ledger.conf + +install: build + # Add here commands to install the package into debian/sql-ledger. + sed -e 's|^\$$userspath = .*$$|$$userspath = "/var/lib/sql-ledger/users";|' \ + -e 's|^\$$memberfile = .*$$|$$memberfile = "/var/lib/sql-ledger/users/members";|' \ + sql-ledger.conf.default > sql-ledger.conf + dh install + +# Build architecture-independent files here. +binary-indep: install + dh binary-indep + +# Build architecture-dependent files here. +binary-arch: install + dh binary-arch + +binary: binary-indep binary-arch + +.PHONY: build clean binary-indep binary-arch binary install --- sql-ledger-2.8.18.orig/debian/compat +++ sql-ledger-2.8.18/debian/compat @@ -0,0 +1 @@ +7 --- sql-ledger-2.8.18.orig/debian/sql-ledger.lintian-overrides +++ sql-ledger-2.8.18/debian/sql-ledger.lintian-overrides @@ -0,0 +1,4 @@ +# Lintian bug #348978 +# IMHO Hardlinks inside /usr/{lib,share}/ are not a problem +sql-ledger binary: package-contains-hardlink + --- sql-ledger-2.8.18.orig/debian/NEWS +++ sql-ledger-2.8.18/debian/NEWS @@ -0,0 +1,27 @@ +sql-ledger (2.6.28-1) unstable; urgency=low + + The package doesn't do any web-server configuration any more. If you want + to activate SQL-Ledger, just add a line + "Include /etc/sql-ledger/sql-ledger-httpd.conf" in your Apache2 + configuration (probably somewhere in a virtual host in + /etc/apache2/sites-enabled/). + + -- Raphael Hertzog Wed, 21 May 2008 23:37:43 +0200 + +sql-ledger (2.6.22-2) unstable; urgency=low + + SQL-Ledger is not safe to use in public installations or in installations + with unstrusted users. Please check the README.Debian file for more details. + + -- Raphael Hertzog Thu, 1 Mar 2007 15:32:10 +0100 + +sql-ledger (2.6.6-2) unstable; urgency=low + + SQL-Ledger is now installed in /usr/share/sql-ledger instead of + /usr/lib/sql-ledger. The default apache configuration has been + correspondingly updated. Please update the path if you have + other instances configured in Apache. A temporary symlink + has been put in place to avoid potential breakages, but it will + be removed one day. + + -- Raphael Hertzog Fri, 20 Jan 2006 19:52:39 +0000 --- sql-ledger-2.8.18.orig/debian/all2po +++ sql-ledger-2.8.18/debian/all2po @@ -0,0 +1,182 @@ +#!/usr/bin/perl +# +# Author: Petter Reinholdtsen +# Date: 2004-12-05 +# License: GPL +# +# Convert SQL-ledger 'all' translation files to gettext style .po +# files, and back. +# +# Based on code from po-debconf. + +use Text::Wrap; + +my $infile = shift;; + +my %alltext; +if ($infile eq "all") { + require "all"; + %alltext = %{ $self{texts} }; + as_po("all.po", %alltext); +} elsif ($infile eq "all.po") { + %alltext = load_po($infile); + as_sql_ledger_all("all", %alltext); +} else { + print STDERR "usage: $0 all > all.po\n"; + print STDERR " $0 all.po > all\n"; + exit 1; +} + +exit 0; + +sub perl_encode { + $msg = shift; + # Using single quotes, so there is no need to escape + #$msg =~ s%\"%\\\"%g; + return $msg; +} + +sub as_sql_ledger_all { + my ($filename, %alltext) = @_; + + print < '$translation',\n" + } + + print <, YEAR. +# +#, fuzzy +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\\n" +"PO-Revision-Date: YEAR-MO-DA HO:MI +ZONE\\n" +"Last-Translator: FULL NAME \\n" +"Language-Team: LANGUAGE \\n" +"MIME-Version: 1.0\\n" +"Content-Type: text/plain; charset=$charset\\n" +"Content-Transfer-Encoding: 8bit\\n" + +EOF + for $text (sort keys %alltext) { + my $translation = po_encode($alltext{$text}); + + my $id = wrap("", " ", "msgid \"$text\""); + my $str = wrap("", " ", "msgstr \"$translation\""); + $id =~ s/\n / \"\n \"/g; + $str =~ s/\n / \"\n \"/g; + print "$id\n"; + print "$str\n\n"; + } +} + +sub unescape_one_sequence +{ + my ($sequence) = @_; + + return "\\" if $sequence eq "\\\\"; + return "\"" if $sequence eq "\\\""; + return "\n" if $sequence eq "\\n"; + + # gettext also handles \n, \t, \b, \r, \f, \v, \a, \xxx (octal), + # \xXX (hex) and has a comment saying they want to handle \u and \U. + + return $sequence; +} + +sub unescape_po_string +{ + my ($string) = @_; + + $string =~ s/(\\.)/unescape_one_sequence($1)/eg; + + return $string; +} + +sub load_po { + my $filename = shift; + my %alltext; + open(PO_FILE, "<$filename") || die "Unable to read from $filename"; + + my $nextfuzzy = 0; + my $inmsgid = 0; + my $inmsgstr = 0; + my $msgid = ""; + my $msgstr = ""; + + while () + { + $nextfuzzy = 1 if /^#, fuzzy/; + + if (/^msgid "((\\.|[^\\])*)"/ ) + { + $alltext{$msgid} = $msgstr if $inmsgstr && $msgid && defined $msgstr; + $msgid = ""; + $msgstr = ""; + + if ($nextfuzzy) { + $inmsgid = 0; + } else { + $msgid = unescape_po_string($1); + $inmsgid = 1; + } + $inmsgstr = 0; + $nextfuzzy = 0; + } + + if (/^msgstr "((\\.|[^\\])*)"/) + { + $msgstr = unescape_po_string($1); + $inmsgstr = 1; + $inmsgid = 0; + } + + if (/^ *"((\\.|[^\\])*)"/) + { + $msgid .= unescape_po_string($1) if $inmsgid; + $msgstr .= unescape_po_string($1) if $inmsgstr; + } + } + $alltext{$msgid} = $msgstr if $inmsgstr && $msgid && $msgstr; + return %alltext; +} --- sql-ledger-2.8.18.orig/debian/dirs +++ sql-ledger-2.8.18/debian/dirs @@ -0,0 +1,3 @@ +etc/sql-ledger +usr/share/sql-ledger +var/lib/sql-ledger --- sql-ledger-2.8.18.orig/debian/sql-ledger.links +++ sql-ledger-2.8.18/debian/sql-ledger.links @@ -0,0 +1 @@ +usr/share/sql-ledger usr/lib/sql-ledger --- sql-ledger-2.8.18.orig/debian/copyright +++ sql-ledger-2.8.18/debian/copyright @@ -0,0 +1,117 @@ +This package was debianized by Finn-Arne Johansen on +Sun, 4 May 2003 05:21:25 +0200. + +It was downloaded from http://prdownloads.sourceforge.net/sql-ledger/sql-ledger-2.0.6.tar.gz?download + +Upstream Author: Dieter Simader + + Copyright (c) 1999 - 2007, DWS Systems Inc. + +Brazilian texts: + Author: Andre Felipe Machado + Miguel Koren O'Brien de Lacy +Simplified Chinese texts: + Author: Edmund Lian +Spanish texts: +Adoption to Colombian Accounting Terms: +Authors: Dirk Enrique Seiffert + Lourdes Mejía Martinez + Silfredo Godoy Chavez + +Catalan Translation: + Author: Jaume Teixi +Czech texts: + Author: Tomas Fencl +German texts: + Author: Thomas Bayen + Gunter Ohrner +Danish texts: + Author: Keld Jørn Simonsen + Jonas Smedegaard +Estonian texts: + Author: Martin Lillepuu + Lauri Jesmin + Tanel Kurvits +Egypt Arabic texts: + Author: Omar BaheyEldin + Rania Tayel +#---- Please Use UTF-8 encoding +#---- For some web servers you have to enable UTF-8 +#---- For Knoquere you have to edit the font and use an arabic font +--- Good Luck +#--- Omar BaheyEldin +British English texts: + Author: +Spanish texts: + Author: Maria Gabriela Fong + John Stoddart + Federico Montesino Pouzols + Tomás Pereira +Spanish texts: + Author: Maria Gabriela Fong + John Stoddart + Federico Montesino Pouzols + Tomás Pereira +Finish texts: + Author: Petri Leppänen +French texts: + Author: Sèbastien Brassard + Oscar Buijten + Wolfgang Sourdeau + Aguibou KONE + Jens-Ingo Brodesser +Hungarian texts: + Author: Kabai József +Icelandic texts: + Author: Margeir Reynisson +Italian texts: + Author: Paolo Bizzarri + Luca Venturini + Alessandro Pasotti + Daniele Giacomini 2003.09.28-2003.11.05 +Lithuanian texts: + Author: +Latvian texts: + Author: Kaspars Melkis +Spanish texts (Mexico): + Author: Alberto Ladron +Dutch texts: + Author: AJ Hettema + Oscar Buijten + Bert Tijhuis + Paul Tammes +Norwegian texts: + Author: Keld Jørn Simonsen + Morten Pedersen + Finn-Arne Johansen + Petter Reinholdtsen +Spanish texts: + Author: Maria Gabriela Fong +Polish texts: + Author: Peter Dabrowski +Portugese texts: + Author: Paulo Rodrigues +Russian texts: + Author: +Swedish texts: + Author: Jonny Larsson + Daniel Andersson +Spanish texts: + Author: Carlos López Linares +Turkish texts: + Author: Mufit Eribol +Traditional Chinese texts: + Author: Edmund Lian +Ukrainian texts: +Author: Ivan Petrouchtchak +Spanish Texts (Venezuela): + Author: John Stoddart + +These scripts are free software; you can redistribute it and/or modify it +under the terms of the GNU General Public License as published by the +Free Software Foundation; either version 2, or (at your option) any +later version. + +On Debian GNU/Linux systems, the complete text of the GNU General +Public License can be found in `/usr/share/common-licenses/GPL'. + --- sql-ledger-2.8.18.orig/debian/README.Debian +++ sql-ledger-2.8.18/debian/README.Debian @@ -0,0 +1,50 @@ +sql-ledger for Debian +--------------------- + +IMPORTANT SECURITY NOTICE +------------------------- +SQL-Ledger is known to have many vulnerabilities that are exploitable by +someone who has a user account on this web application. That's why you +should *only* use that application if you trust the users that have access +to it. + +Historically it also had some vulnerabilities that could be exploited even +without having an account. So we advise to you to put this web +application in an authenticated HTTP zone. + +Summary: SQL-Ledger is not suitable for public installations or for +installations with untrusted users. + +Some pointers: +http://bugs.debian.org/409703 +http://www.securityfocus.com/archive/1/459264 +http://www.securityfocus.com/archive/1/445817 + +CONFIGURATION INFORMATION +------------------------- + +To test this package you need to add this line to your +apache configuration, either in a virtual host configuration, or in the +global configuration (for example in /etc/apache2/conf.d/sql-ledger.conf): + include /etc/sql-ledger/sql-ledger-httpd.conf + +You also have to add some users to your postgres DB + +The easiest way to test this package is to add a postgres-users with +the name of www-data. This however will mean that every apache process +will be able to authenticate to your DB. + +To make a more robust security scheme, please read your postgres +documentation, but for now, do, as root, a + + su - postgres + createuser -d www-data + +Answer "n" to the question "Shall the new user be allowed to create +more new users?" + +To finally test this, point your browser at +http://localhost/sql-ledger/admin.pl to create the DB and the initial +user, and afterwards: http://localhost/sql-ledger/login.pl to log in. + + -- Finn-Arne Johansen , Sun, March 21, 2004 15:41:25 +0100 --- sql-ledger-2.8.18.orig/debian/postinst +++ sql-ledger-2.8.18/debian/postinst @@ -0,0 +1,17 @@ +#!/bin/sh + +set -e + +( + cd /var/lib/sql-ledger ; + chown www-data:www-data users templates + chown -R www-data:www-data css +) + +if ! test -L /usr/lib/sql-ledger; then + # Work around dpkg bug (can't replace dir by symlink itself) + (rmdir /usr/lib/sql-ledger && ln -sf /usr/share/sql-ledger /usr/lib/sql-ledger) || \ + echo "WARNING: Unable to replace /usr/lib/sql-ledger by a symlink" +fi + +#DEBHELPER# --- sql-ledger-2.8.18.orig/debian/copyright.post +++ sql-ledger-2.8.18/debian/copyright.post @@ -0,0 +1,9 @@ + +These scripts are free software; you can redistribute it and/or modify it +under the terms of the GNU General Public License as published by the +Free Software Foundation; either version 2, or (at your option) any +later version. + +On Debian GNU/Linux systems, the complete text of the GNU General +Public License can be found in `/usr/share/common-licenses/GPL'. + --- sql-ledger-2.8.18.orig/debian/control +++ sql-ledger-2.8.18/debian/control @@ -0,0 +1,38 @@ +Source: sql-ledger +Section: web +Priority: optional +Maintainer: Raphael Hertzog +Uploaders: Petter Reinholdtsen , Gerardo Reynoso +Build-Depends: debhelper (>= 7), quilt +Homepage: http://www.sql-ledger.com +Vcs-Svn: svn://svn.debian.org/pkg-sql-ledger/trunk +Vcs-Browser: http://svn.debian.org/wsvn/pkg-sql-ledger/trunk/?op=log +Standards-Version: 3.8.0 + +Package: sql-ledger +Architecture: all +Depends: ${perl:Depends}, apache2 | httpd, libdbd-pg-perl +Suggests: texlive-latex-extra | tetex-extra, postgresql +Description: A web based double-entry accounting program + Accounting data is stored in an SQL Server, for the display any text or + GUI browser can be used. The entire system is linked through a chart + of accounts. Each item in inventory is linked to revenue, expense, + inventory and tax accounts. When you sell and purchase goods and + services the accounts are automatically updated. + . + With the assembly feature you can build manufactured goods from parts, + services and assemblies. When you sell assemblies all the accounts + linked to the individual parts, services and assemblies are updated + and stock levels adjusted accordingly. If any item belonging to an + assembly is changed all assemblies are updated as well. + . + Invoices, Packing List, Income Statement, Balance Sheet, Sales and + Purchase Order, Statements, Receipts and Checks are generated from + templates and may be changed to suit your needs. Templates are provided + in html and tex format. The tex templates are processed with LaTeX + to produce postscript and PDF documents and can be sent to a printer, + displayed in a PDF viewer or sent out via email ... + . + NOTE: This package does not benefit from serious security support + and you should use it only in a trusted environment. It's known + to be affected by multiple SQL injections and similar problems. --- sql-ledger-2.8.18.orig/debian/README.source +++ sql-ledger-2.8.18/debian/README.source @@ -0,0 +1,2 @@ +Please read /usr/share/doc/quilt/README.source to know how to apply +and manage Debian specific patches on this package. --- sql-ledger-2.8.18.orig/debian/changelog +++ sql-ledger-2.8.18/debian/changelog @@ -0,0 +1,415 @@ +sql-ledger (2.8.18-1) unstable; urgency=low + + * New upstream release. It contains again more fixes for perl 5.10. + * Drop useless prerm and add missing "set -e" in postinst. + * s/latex/LaTeX/ in the package's description. + + -- Raphael Hertzog Mon, 10 Nov 2008 13:47:19 +0100 + +sql-ledger (2.8.16-1) unstable; urgency=low + + * New uptream release. It contains more fixes for perl 5.10. + + -- Raphael Hertzog Sun, 06 Jul 2008 12:29:24 +0200 + +sql-ledger (2.8.15-1) unstable; urgency=low + + * New upstream release. + * Invoice printing now works with perl 5.10. Closes: #484455 + * Use dh_lintian to install lintian overrides. Build-depend on + debhelper (>= 6.0.7) for this. + * Switch to quilt to manage patches. Ajust build-dependency and + debian/rules and debian/patches/* accordingly. + * Drop patch 05improve-sec-check which is merged upstream. + * Refresh all remaining patches. + * Switch to debhelper 7 and its associated rules file minimization. + + -- Raphael Hertzog Sun, 15 Jun 2008 12:04:31 +0200 + +sql-ledger (2.8.14-2) unstable; urgency=low + + * Remove Finn-Arne Johansen from Maintainer field (on his request) + and moved myself there. I'll continue to maintain the package in + low-maintenance mode until smbledger is properly supported in Debian. + Feel free to step in and help. + + -- Raphael Hertzog Thu, 22 May 2008 09:14:07 +0200 + +sql-ledger (2.8.14-1) unstable; urgency=low + + * New upstream release. + * Close a few security issues. Closes: #418724 + * Add Homepage field. + * Replaced dependency on apache by apache2. Closes: #482158 + * Also replace tetex-extra Suggests by texlive-latex-extra | tetex-extra. + * Added Vcs-Svn, Vcs-Browser control fields. + * Switched to debhelper v5 mode. + * Drop configuration in postinst add a NEWS entry about initial + configuration. + * Updated 10makefiles.dpatch to match new upstream version + (hopefully). + * Converted copyright file to UTF-8. + * Upgraded Standards-Version to 3.7.3 (no change). + + -- Raphael Hertzog Wed, 21 May 2008 23:07:35 +0200 + +sql-ledger (2.6.22-2) unstable; urgency=high + + * Document the security problem of SQL-Ledger in the README.Debian file + (and in NEWS). Closes: #409703 + + -- Raphael Hertzog Thu, 1 Mar 2007 15:34:36 +0100 + +sql-ledger (2.6.22-1) unstable; urgency=high + + * New upstream release that only adds one bugfix where the user can loose + his password while trying to change it. + + -- Raphael Hertzog Thu, 7 Dec 2006 08:53:45 +0100 + +sql-ledger (2.6.21-2) unstable; urgency=high + + * Further improve the security check introduced in 2.6.21. + + -- Raphael Hertzog Mon, 27 Nov 2006 08:30:51 +0100 + +sql-ledger (2.6.21-1) unstable; urgency=high + + * New upstream release. + + -- Raphael Hertzog Sun, 26 Nov 2006 11:53:53 +0100 + +sql-ledger (2.6.19-1) unstable; urgency=high + + * New upstream release. + - fixed path traversal bug in terminal variable (potential security issue) + - fixed New Window tab session timeout + * Increase urgency as the two last release fix security issues that should + go into testing as quickly as possible. + + -- Raphael Hertzog Tue, 12 Sep 2006 10:52:59 +0200 + +sql-ledger (2.6.18-1) unstable; urgency=low + + * New upstream release. + - fix security issue with sessions cookies: CVE-2006-4244 + Closes: #386519 + * Updated watch file, sourceforge is not really up-to-date. + + -- Raphael Hertzog Sun, 10 Sep 2006 21:08:15 +0200 + +sql-ledger (2.6.17-1) unstable; urgency=low + + * New upstream release: + - fixed problem with temporary id assignment when adding customers, + vendors and employees. + * Make the debian/postinst a bit less dumb. Do not reactivate the + configuration if the admin deactivated it, instead I only create a default + configuration if there's no file yet. + + -- Raphael Hertzog Sun, 3 Sep 2006 22:37:16 +0200 + +sql-ledger (2.6.16-1) unstable; urgency=low + + * New upstream version: + - added source field on drill-down list + - changed random number generator to avoid overwriting existing partnumber + - added hidden sales flag to employee screen + - fixed menu to exclude phantom lines + + -- Raphael Hertzog Sun, 20 Aug 2006 11:52:42 +0200 + +sql-ledger (2.6.15-1) unstable; urgency=low + + * New upstream version: + - fixed tax calculation for recurring transactions when rate changes + - fixed query error for non-taxable report + + -- Raphael Hertzog Mon, 3 Jul 2006 18:45:36 +0200 + +sql-ledger (2.6.14-1) unstable; urgency=low + + * New upstream version. + + -- Raphael Hertzog Wed, 28 Jun 2006 08:54:23 +0200 + +sql-ledger (2.6.13-1) unstable; urgency=low + + * New upstream version: + - added missing lastcost and assembly variable on assembly screen + - revised pricelist to add multiple items + - fixed UCOA contra switch + - added tax rate changes based on transaction date + + -- Raphael Hertzog Thu, 22 Jun 2006 17:00:46 +0200 + +sql-ledger (2.6.12-1) unstable; urgency=low + + * New upstream release. + + -- Raphael Hertzog Thu, 25 May 2006 23:39:46 +0000 + +sql-ledger (2.6.11-1) unstable; urgency=low + + * New upstream version. + + -- Raphael Hertzog Thu, 25 May 2006 22:35:33 +0000 + +sql-ledger (2.6.10-1) unstable; urgency=low + + * New upstream release. + * Updated Standards-Version to 3.7.2 (no change required). + * Use Build-Depends instead of Build-Depends-Indep since debhelper/patch are + needed for the "clean" rule too. (Fix lintian warning) + + -- Raphael Hertzog Tue, 28 Mar 2006 06:29:46 +0000 + +sql-ledger (2.6.8-1) unstable; urgency=low + + * New upstream release. + - fixed invoice batch printing + - included department for beginning balance calculation + - modified pagebreak code to count only characters for the description and + itemnotes + - updated Estonian translation and templates + - added Swiss German translation + - added price matrix for time cards + - added last cost and list price to labor items + - revised parts requirements report to split assemblies into their + components + + -- Raphael Hertzog Tue, 28 Mar 2006 06:07:37 +0000 + +sql-ledger (2.6.7-1) unstable; urgency=low + + [ Raphael Hertzog ] + * New upstream release. + * Generate sql-ledger.conf based on sql-ledger.conf.default from upstream. + Closes: #296293 + + -- Raphael Hertzog Sun, 12 Mar 2006 16:49:55 +0000 + +sql-ledger (2.6.6-2) UNRELEASED; urgency=low + + [ Raphael Hertzog ] + * Move all files below /usr/share/sql-ledger instead of /usr/lib/sql-ledger. + This is for better FHS conformance. Thus drop the imagepath patch. + Modified debian/patches/10makefiles.patch accordingly. Added a NEWS.Debian + to inform the admin of the change and put a compatibility symlink in the + mean time. Indirectly closes: #354781 + + [ Finn-Arne Johansen ] + * We now have enough manpower it seem (Closes: #320442) + + -- Finn-Arne Johansen Fri, 10 Feb 2006 20:24:58 +0100 + +sql-ledger (2.6.6-1) unstable; urgency=low + + [ Raphael Hertzog ] + * New upstream version. + * Added all CSS files in the "css" directory. Modified + debian/patches/10makefiles.patch. + * Added all files from the doc directory except COPYING and COPYRIGHT. + This includes in particular the various "UPGRADE-*" files. + * Use hardlinks instead of symlinks. This is better for suExec + compatibility (on advice from the author). This generates lintian + warnings. Put overrides until bug 348978 is fixed. + + -- Raphael Hertzog Fri, 20 Jan 2006 07:48:35 +0000 + +sql-ledger (2.6.5-1) unstable; urgency=low + + [ Raphael Hertzog ] + * New upstream version. + - added WITH OIDS to some tables (PostgreSQL 8.0+ changed the default from + using OIDS to not use them) + - fixed notes printing for lineitems + - fixed path for logo in Default templates + - updated Brazilian Portuguese translation and templates + + -- Raphael Hertzog Fri, 6 Jan 2006 11:33:36 +0000 + +sql-ledger (2.6.4-1) unstable; urgency=low + + [ Raphael Hertzog ] + * New upstream version. Closes: #346195 + * Added all members of the team in the Uploaders field (myself included). + * Build-Depends on debhelper >= 4 since we use debian/compat with level 4. + * Remove rsync build dependency (seems useless). + * Upgraded Standards-Version to 3.6.2 (no changes needed). + * Wrote plans for the future in debian/TODO. + * Update 10makefiles.dpatch because new modules have been added in the + upstream source package. Make it generate the list of modules + automatically. + * Reworked debian/rules so that we can have an .orig.tar.gz which is + the exact copy provided by upstream. Keep dpatch to apply patches + at build time however. + + -- Raphael Hertzog Wed, 4 Jan 2006 23:12:35 +0000 + +sql-ledger (2.6.3-1) UNRELEASED; urgency=low + + * New upstream version available (Closes: #303604) + * Updated debian/patches/40imagepath.dpatch to avoid patch rejection + * Removed reference to script debian/sql-ledger-enable on + debian/rules + * Removed reference to js directory from file + debian/patches/10makefiles.dpatch as this directory was removed + upstream. + + -- Gerardo Reynoso Fri, 2 Dec 2005 21:00:26 -0600 + +sql-ledger (2.4.9-3) UNRELEASED; urgency=low + + * Move contents of debian/sql-ledger-enable into debian/postinst to avoid + lintian/linda warning about missing man page + + -- Gerardo Reynoso Fri, 2 Dec 2005 20:25:42 -0600 + +sql-ledger (2.4.9-2) UNRELEASED; urgency=low + + * package description typo(s) and the like (Closes: #300043) + + -- Gerardo Reynoso Fri, 2 Dec 2005 20:08:19 -0600 + +sql-ledger (2.4.9-1) UNRELEASED; urgency=low + + * New upstream release. (Closes: #303604) + * Added debian/watch file to detect new versions. + * Drop 50norwegian_chart.dpatch as it only insed a duplicate entry + into the chart file. (Closes: #300204) + * Moved the content of 30default.dpatch into 10makefiles.dpatch, and + moved the files from sql-ledger/etc/ to sql-ledger/ to get the + sql-ledger.conf files closer to sql-ledger.conf.default. A future + improvement is to change this to patch and install + sql-ledger.conf.default instead of creating a new file + sql-ledger.conf. Related to bug #296293. + + -- Petter Reinholdtsen Sun, 17 Apr 2005 10:29:07 +0200 + +sql-ledger (2.4.7-2) unstable; urgency=low + + * Rewrite the new helper script sql-ledger-enable, to follow the + Debian apache config schema. + + -- Petter Reinholdtsen Sat, 25 Dec 2004 17:31:50 +0100 + +sql-ledger (2.4.7-1) unstable; urgency=low + + * New upstream version 2.4.7. + - Added string formatting for transaction printing. + - Fixed GL Report GIFI sorting error. + - Fixed multicompany login routine. + - Updated Finnish translation. + - Added tax included calculation to POS. + * Petter Reinholdtsen + - 40imagepath.dpatch: Updated patch for login.pl to match new + upstream version. + - Install new helper script /usr/sbin/sql-ledger-enable, taking + care of the apache config editing. Not sure if this is the + best way to do it. + + -- Petter Reinholdtsen Sat, 25 Dec 2004 15:28:02 +0100 + +sql-ledger (2.4.6-1) unstable; urgency=low + + * New upstream version. + * Petter Reinholdtsen + - 20norwegian.dpatch: Removing. The changes are now upstream. + - 40imagepath.dpatch: Updated admin.pl patch to match new upstream + version. + - Added script debian/all2po. It can convert between gettext .po + files and the SQL-ledger translation files. The script is sent + upstream. + + -- Petter Reinholdtsen Sun, 5 Dec 2004 15:04:02 +0100 + +sql-ledger (2.4.5-1) unstable; urgency=low + + * New upstream release. (Closes: #280766) + - Includes password confirm field and keeps working after the + password is changed. (Closes: #260122) + * Petter Reinholdtsen + - Improved short description slightly, dropping implementation + language and adding "web based". + - 10makefiles.dpatch: Add files arapprn.pl and pw.pl to MODULEs, + making sure they are included in the package. + Added install rules for sql-ledger.eps. (Closes: #281692) + - 20norwegian.dpatch: Most of this patch is now included upstream. + Updated it to only include the remaining translations. + - 30defaults.dpatch: New patch. Use full path to location of user info. + - 40imagepath.dpatch, 45crosslink.dpatch: - Update to match new + source version. + - 45crosslink.dpatch: Add links between the normal and admin login pages. + - 50norwegian_chart.dpatch: Most of this was now included + upstream. Redused to only include the remaining issues. + - 21norwegian.dpatch, 35http-redirect, 51norwegian_chart.dpatch: + Removed/merged into other patches. + + -- Petter Reinholdtsen Mon, 29 Nov 2004 21:35:31 +0100 + +sql-ledger (2.4.1-2) unstable; urgency=low + + * Updated Norwegian Bokmaal translation (20norwegian.dpatch). + + -- Petter Reinholdtsen Sat, 7 Aug 2004 16:44:54 +0200 + +sql-ledger (2.4.1-1) unstable; urgency=low + + * Petter Reinholdtsen + - New upstream release. + - Made Norwegian Bokmaal translation patch relative to new upstream + version. Updated translation based on input from Erik + Inge Bolsø. (20norwegian.dpatch) + - Corrected Norwegian general chart even further. Patch + from Erik Inge Bolsø. (51norwegian_chart.dpatch) + + -- Petter Reinholdtsen Thu, 5 Aug 2004 10:27:22 +0200 + +sql-ledger (2.4.0-2) unstable; urgency=low + + * Petter Reinholdtsen + - Updated Norwegian Bokmaal translation. + - Corrected Norwegian general chart. + - Add missing Build-Depends-Indep on dpatch. (Closes: #261042) + + -- Petter Reinholdtsen Sat, 24 Jul 2004 23:19:45 +0200 + +sql-ledger (2.4.0-1) unstable; urgency=low + + * New upstream release. (Closes: #252750) + * Rewrote build system to use dpatch and an untouced tarball. + * Correct file path in README.Debian. (Closes: #252595) + * Add /usr/lib/sql-ledger/index.html redirecting to + login.pl. (Closes: #258611) + * Changed suggests latex to tetex-extra, to make sure latex class + file 'scrartcl.cls' is available when the suggested package is + installed. (Closes: #248593) + + -- Petter Reinholdtsen Sun, 18 Jul 2004 14:02:27 +0200 + +sql-ledger (2.2.6-1) unstable; urgency=low + + * New upstream release (Closes: #245733) + * Changed to use symlinks from /usr/lib/sql-ledger and into + /var/lib/sql-ledger + (Closes: #245008, #245009) + * Changes dependencie on postgresql to suggest (Closes: #24493) + + -- Finn-Arne Johansen Mon, 10 May 2004 17:43:09 +0200 + +sql-ledger (2.0.6-2) Never released; urgency=low + + * Made the Makefiles so that it fits with _.orig.tar.gz + + -- Finn-Arne Johansen Wed, 21 Apr 2004 04:39:49 +0200 + +sql-ledger (2.0.6-1) unstable; urgency=low + + * Initial Release. (Closes: #129723, #138938) + * Fixed some errors to make it "lintian clean" + * Petter Reinholdtsen + - Removed (s) from copyright file to get rid of lintian warning + copyright-lists-upstream-authors-with-dh_make-boilerplate. + + -- Finn-Arne Johansen Sun, 21 Mar 2004 14:07:45 +0100 --- sql-ledger-2.8.18.orig/debian/patches/series +++ sql-ledger-2.8.18/debian/patches/series @@ -0,0 +1,3 @@ +# List of patches to apply. +10makefiles +45crosslink --- sql-ledger-2.8.18.orig/debian/patches/45crosslink +++ sql-ledger-2.8.18/debian/patches/45crosslink @@ -0,0 +1,25 @@ +Description: Add links between the normal login page and the admin login + page. +Forwarded-Upsteam: tried on 2004-08-07 but Dieter refused as he prefers to + "hide" the admin login page from users. + +--- sql-ledger-2.8.15.orig/bin/mozilla/admin.pl ++++ sql-ledger-2.8.15/bin/mozilla/admin.pl +@@ -104,6 +104,7 @@ function sf(){ + + {path}> + ++

Normal login

+ + + +--- sql-ledger-2.8.15.orig/bin/mozilla/login.pl ++++ sql-ledger-2.8.15/bin/mozilla/login.pl +@@ -130,6 +130,7 @@ $sf + + + ++

Administration login

+ + + --- sql-ledger-2.8.18.orig/debian/patches/10makefiles +++ sql-ledger-2.8.18/debian/patches/10makefiles @@ -0,0 +1,214 @@ +Description: Add some makefiles to be able to copy the required files + in place without using the too invasive setup.pl. +Forwarded-Upstream: not yet tried + +--- /dev/null ++++ sql-ledger-2.8.15/bin/Makefile +@@ -0,0 +1,18 @@ ++PACKAGE = sql-ledger ++ ++# Assumption: only the menu/login/admin.pl differs between each directory ++MODULES = $(shell find mozilla/ -name '*.pl' | sed -e 's|mozilla/||' | grep -v menu.pl | grep -v login.pl | grep -v admin.pl) ++SUBDIRS = lynx mozilla ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/usr/share/sql-ledger/bin ++ cp -r $(SUBDIRS) $(DESTDIR)/usr/share/sql-ledger/bin ++ ++ cd $(DESTDIR)/usr/share/sql-ledger ; \ ++ for module in $(MODULES) ; do \ ++ (cd bin/lynx ; ln -f ../mozilla/$$module) ;\ ++ done ; +--- /dev/null ++++ sql-ledger-2.8.15/doc/Makefile +@@ -0,0 +1,13 @@ ++PACKAGE = sql-ledger ++ ++FILES = $(shell ls * | grep -v Makefile | grep -v COPYING | grep -v COPYRIGHT) ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/usr/share/doc/sql-ledger ++ cp -a $(FILES) $(DESTDIR)/usr/share/doc/sql-ledger ++ ++#for ALL in locale/*/COPYING ; do HEAD=$(grep -n "# This program is free software" $ALL |cut -f1 -d:); let HEAD=$HEAD-1; head -$HEAD $ALL | tail +4 ; done | grep -v "^#$" +--- /dev/null ++++ sql-ledger-2.8.15/sql/Makefile +@@ -0,0 +1,11 @@ ++PACKAGE = sql-ledger ++ ++FILES = *.sql ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/usr/share/sql-ledger/sql ++ cp $(FILES) $(DESTDIR)/usr/share/sql-ledger/sql +--- /dev/null ++++ sql-ledger-2.8.15/templates/Makefile +@@ -0,0 +1,14 @@ ++PACKAGE = sql-ledger ++ ++FILES = *.html *.tex *.txt *.eps *.png ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/var/lib/sql-ledger/templates ++ cp -a $(FILES) $(DESTDIR)/var/lib/sql-ledger/templates ++ chown www-data:www-data $(DESTDIR)/var/lib/sql-ledger/templates ++ ln -sf /var/lib/sql-ledger/templates $(DESTDIR)/usr/share/sql-ledger/ ++ +--- /dev/null ++++ sql-ledger-2.8.15/css/Makefile +@@ -0,0 +1,13 @@ ++PACKAGE = sql-ledger ++ ++FILES = $(shell ls sql-ledger*.css) ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/var/lib/sql-ledger/css ++ cp $(FILES) $(DESTDIR)/var/lib/sql-ledger/css ++ chown -R www-data:www-data $(DESTDIR)/var/lib/sql-ledger/css ++ ln -sf /var/lib/sql-ledger/css $(DESTDIR)/usr/share/sql-ledger/ +--- /dev/null ++++ sql-ledger-2.8.15/users/Makefile +@@ -0,0 +1,13 @@ ++PACKAGE = sql-ledger ++ ++FILES = sql-ledger.eps sql-ledger.png ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/var/lib/sql-ledger/users ++ cp -r $(FILES) $(DESTDIR)/var/lib/sql-ledger/users/ ++ chown www-data:www-data $(DESTDIR)/var/lib/sql-ledger/users ++ ln -sf /var/lib/sql-ledger/users $(DESTDIR)/usr/share/sql-ledger/ +--- /dev/null ++++ sql-ledger-2.8.15/SL/Makefile +@@ -0,0 +1,11 @@ ++PACKAGE = sql-ledger ++ ++FILES := $(shell ls *.pm) ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(DESTDIR)/usr/share/sql-ledger/SL ++ cp -r $(FILES) $(DESTDIR)/usr/share/sql-ledger/SL +--- /dev/null ++++ sql-ledger-2.8.15/locale/Makefile +@@ -0,0 +1,43 @@ ++PACKAGE = sql-ledger ++ ++LOCALES = $(shell ls */LANGUAGE | cut -d/ -f1) ++ ++localedir = /usr/share/sql-ledger/locale ++dlocaledir = $(DESTDIR)$(localedir) ++srctopdir := $(shell pwd)/.. ++ ++all: ++ ++clean: ++ ++install: ++ mkdir -p $(dlocaledir) ++ set -e ; \ ++ for lang in $(LOCALES) ; do \ ++ mkdir -p $(dlocaledir)/$$lang ; \ ++ for file in `find $$lang/. -type f | grep -v COPYING`; do \ ++ if [ -f $$file ] ; then \ ++ cp $$file $(dlocaledir)/$$lang/. ; \ ++ fi ; \ ++ done ; \ ++ if [ -h $$lang/Num2text ] ; then \ ++ ln -sf ../es/Num2text $(dlocaledir)/$$lang/Num2text ; \ ++ elif [ -h $$lang/Num2text ] ; then \ ++ cp $$lang/Num2text $(dlocaledir)/$$lang/. ; \ ++ fi ; \ ++ done ++ ++ cp de/locales.pl $(dlocaledir)/de ++ set -e ; for lang in $(LOCALES) ; do \ ++ if [ -d $(dlocaledir)/$$lang -a \ ++ -f $(dlocaledir)/$$lang/LANGUAGE -a \ ++ ! -f $(dlocaledir)/$$lang/locales.pl ] ; then \ ++ ln -sf ../de/locales.pl $(dlocaledir)/$$lang/locales.pl ;\ ++ fi ; \ ++ done ++ ++ set -e ; for lang in $(LOCALES) ; do \ ++ (cd $(dlocaledir)/$$lang && \ ++ perl -I $(srctopdir) ./locales.pl || exit 1) ; \ ++ done ++ +--- /dev/null ++++ sql-ledger-2.8.15/Makefile +@@ -0,0 +1,36 @@ ++PACKAGE = sql-ledger ++ ++# Assumption: all .pl except am/login/admin/setup are modules ++MODULES = $(shell ls *.pl | grep -v -E '(am|login|admin|setup)\.pl') ++SUBDIRS = bin doc SL locale sql templates users css ++ ++LIB_FILES = am.pl favicon.ico login.pl menu.ini setup.pl \ ++ sql-ledger.conf.default VERSION index.html \ ++ images ++ ++ ++CFG_FILES = sql-ledger-httpd.conf sql-ledger.conf ++ ++all: ++ ++install: ++ mkdir -p $(DESTDIR)/usr/share/sql-ledger ++ cp -a $(LIB_FILES) $(DESTDIR)/usr/share/sql-ledger/ ++ ++ ++ ++ cd $(DESTDIR)/usr/share/sql-ledger ; \ ++ ln -f login.pl admin.pl ; \ ++ set -e ; for module in $(MODULES) ; do \ ++ ln am.pl $$module ; \ ++ done ; \ ++ ln -sf /etc/sql-ledger/sql-ledger.conf ++ ++ set -e ; for subdir in $(SUBDIRS) ; do \ ++ $(MAKE) -C $$subdir $@ ; \ ++ done ++ ++ mkdir -p $(DESTDIR)/etc/sql-ledger ++ cp $(CFG_FILES) $(DESTDIR)/etc/sql-ledger ++ ++clean: +--- /dev/null ++++ sql-ledger-2.8.15/sql-ledger-httpd.conf +@@ -0,0 +1,8 @@ ++ ++ ++Alias /sql-ledger/ /usr/share/sql-ledger/ ++ ++ ++ AddHandler cgi-script .pl ++ Options ExecCGI Includes FollowSymlinks ++