[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#861443: marked as done (ora2pg: please make the build reproducible)

Your message dated Thu, 15 Jun 2017 21:33:42 +0000
with message-id <E1dLcOc-000H85-Pw@fasolo.debian.org>
and subject line Bug#861443: fixed in ora2pg 18.1-1
has caused the Debian Bug report #861443,
regarding ora2pg: please make the build reproducible
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
861443: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=861443
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
Source: ora2pg
Version: 18.0-1
Severity: wishlist
Tags: patch
User: reproducible-builds@lists.alioth.debian.org
Usertags: randomness
X-Debbugs-Cc: reproducible-bugs@lists.alioth.debian.org

Hi,

Whilst working on the Reproducible Builds effort [0], we noticed
that ora2pg could not be built reproducibly.

This is because it encodes the build process's current PID in the
default configuration file.


Patch attached.

 [0] https://reproducible-builds.org/


Regards,

-- 
      ,''`.
     : :'  :     Chris Lamb
     `. `'`      lamby@debian.org / chris-lamb.co.uk
       `-

--- a/debian/patches/03_reproducible_build.diff	1970-01-01 01:00:00.000000000 +0100
--- b/debian/patches/03_reproducible_build.diff	2017-04-29 09:06:38.343116627 +0100
@@ -0,0 +1,57 @@
+Description: Make the build reproducible
+Author: Chris Lamb <lamby@debian.org>
+Last-Update: 2017-04-29
+
+--- ora2pg-18.0.orig/Makefile.PL
++++ ora2pg-18.0/Makefile.PL
+@@ -51,6 +51,8 @@ if ($^O !~ /MSWin32|dos/i) {
+ 
+ my $oracle_home = $ENV{ORACLE_HOME} || '/usr/local/oracle/10g';
+ 
++my $T = $ENV{SOURCE_DATE_EPOCH} || $$;
++
+ # Setup ok. generating default ora2pg.conf config file
+ unless(open(OUTCFG, ">$DEST_CONF_FILE")) {
+ 	print "\nError: can't write config file $DEST_CONF_FILE, $!\n";
+@@ -288,7 +290,7 @@ CONTEXT_AS_TRGM		0
+ # To automatically update the column when a modification in the title column
+ # appears, Ora2Pg adds the following trigger:
+ #
+-# CREATE FUNCTION tsv_t_document_title() RETURNS trigger AS $$
++# CREATE FUNCTION tsv_t_document_title() RETURNS trigger AS $T
+ # BEGIN
+ #        IF TG_OP = 'INSERT' OR new.title != old.title THEN
+ #                new.tsv_title :=
+@@ -296,7 +298,7 @@ CONTEXT_AS_TRGM		0
+ #        END IF;
+ #        return new;
+ # END
+-# $$ LANGUAGE plpgsql;
++# $T LANGUAGE plpgsql;
+ # CREATE TRIGGER trig_tsv_t_document_title BEFORE INSERT OR UPDATE
+ #  ON t_document
+ #  FOR EACH ROW EXECUTE PROCEDURE tsv_t_document_title();
+@@ -325,9 +327,9 @@ FTS_INDEX_ONLY	1
+ #
+ #	CREATE OR REPLACE FUNCTION unaccent_immutable(text)
+ #	RETURNS text AS
+-#	$$
++#	$T
+ #		SELECT public.unaccent('public.unaccent', $1)
+-#	$$  LANGUAGE sql IMMUTABLE
++#	$T  LANGUAGE sql IMMUTABLE
+ #	    COST 1;
+ #
+ # indexes are exported as follow:
+@@ -347,9 +349,9 @@ USE_UNACCENT		0
+ #
+ #      CREATE OR REPLACE FUNCTION unaccent_immutable(text)
+ #      RETURNS text AS
+-#      $$
++#      $T
+ #          SELECT lower(public.unaccent('public.unaccent', $1));
+-#      $$ LANGUAGE sql IMMUTABLE;
++#      $T LANGUAGE sql IMMUTABLE;
+ #
+ USE_LOWER_UNACCENT	0
+ 
--- a/debian/patches/series	2017-04-29 09:03:13.670357628 +0100
--- b/debian/patches/series	2017-04-29 09:04:46.710702421 +0100
@@ -1,2 +1,3 @@
 01_Ora2Pg.pod.diff
 02_remove_unnecessary_files.diff
+03_reproducible_build.diff

--- End Message ---
--- Begin Message --- 
Source: ora2pg
Source-Version: 18.1-1

We believe that the bug you reported is fixed in the latest version of
ora2pg, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 861443@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Christoph Berg <myon@debian.org> (supplier of updated ora2pg package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@ftp-master.debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Format: 1.8
Date: Thu, 15 Jun 2017 23:16:26 +0200
Source: ora2pg
Binary: ora2pg
Architecture: source
Version: 18.1-1
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>
Changed-By: Christoph Berg <myon@debian.org>
Description:
 ora2pg     - Oracle/MySQL to PostgreSQL database schema converter
Closes: 826778 861443
Changes:
 ora2pg (18.1-1) unstable; urgency=medium
 .
   * Adopt package in the PostgreSQL team. (Closes: #826778)
   * New upstream release.
     + Fixes $$ handling. (Closes: #861443)
   * Update package description.
   * Switch to the primary download location on GitHub.
   * Add autopkgtest.
Checksums-Sha1:
 170acb153c6671ecda614d6e84091394e65cdb16 2019 ora2pg_18.1-1.dsc
 15cee4d2050bb24398c2882d1f4aa48efc1baa2f 358395 ora2pg_18.1.orig.tar.gz
 928ffc97ecbf3055b0192cf8c0a36248ede56842 6408 ora2pg_18.1-1.debian.tar.xz
 94353314bc888e979d45a8c65edfbb39cc79acd1 5174 ora2pg_18.1-1_source.buildinfo
Checksums-Sha256:
 802fbcc455018186e7f7ae33537afdb6cc0a763a78c366c6df40cbbe523822c6 2019 ora2pg_18.1-1.dsc
 b8d330b4b4f57d3bc32624880e37f25077656be6c4b5c9f8e9042a6ea83e20da 358395 ora2pg_18.1.orig.tar.gz
 774f90e5373049bb5b8b452daa43192f2df87787657939ea10c1266387872afc 6408 ora2pg_18.1-1.debian.tar.xz
 ae156db0ce6ab70465cf3942b8e2f2fca351f2acd3eea71f44e9436f7bfd6b3f 5174 ora2pg_18.1-1_source.buildinfo
Files:
 99928e1689b0ca9665f286b98a0330c9 2019 database extra ora2pg_18.1-1.dsc
 4d19f4ec9fe75d643ac470cd295b8342 358395 database extra ora2pg_18.1.orig.tar.gz
 ebceb285984039c659261cc647dd583a 6408 database extra ora2pg_18.1-1.debian.tar.xz
 03b91fc64a39c200489493c63e15f4c8 5174 database extra ora2pg_18.1-1_source.buildinfo

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAllC+WMACgkQTFprqxLS
p658/xAApJ+YGaGW4fb3Z6Lb2+DUg5G4nv9ptKzfCeOEWPSgLq4wKP40UCJJBCJ5
qASL89Ukg68JaLKU2TCBhD3nxIjlqHgDFIUiGt56W9jvTxUsuo5MUzXvfvAamHCl
9I2gK6B6lZAiRZrPYcpZekO01uAu4ok0H/aCczbCqalXZfdMqoo6R0MDdw6sstUq
ExVtyZVKZkJOLSIyU4qmi+6Y+NAub9TVsP/BQoxnmShJdA1jNvGzHHT7b8qFOKWe
uGeVu1nI051uPEx07e9q/aOE4JjQGUiZR4qxg/QCTKciZUWKwo3AVHyrjtrDP+v6
SL+l5hjIka0RGGqby7pCXeYgMSvtk5/PbIRPLguwn31EElNxnjZekXxf3dTVzQ/F
giFoQSQYtYka/eP0Q9apYcxSwIA7Jsd46sVn3X5lnru914UCkvZH9EGou/Z5ePFC
LdIJZQBPZ9pgcHYOwO33Xac1ey6nxHnEAvigVpdwDkDiwDJJs1T998WnzJ1yp6k2
i2cmGbWOAnzgBLzKYzyGgvS6b/qMreUyJU9ANvhikDO6zHHK8PNYTAwvdiIorEmI
r6YSHa+ZZAOCtefXaA4fi8yTKqQ9P+uFd9qtQJQQOIo5ppcwrxFijWrpurZnLeiS
MlL1ik/667p0gOm/PUYGFsBHjSrIJ0V7LTrJ+2ZYs25mCsuaoXI=
=Nd2q
-----END PGP SIGNATURE-----

--- End Message ---
Reply to: