Bug 219682 - [NEW PORT] databases/ora2pg: Oracle to PostgreSQL database schema converter
Summary: [NEW PORT] databases/ora2pg: Oracle to PostgreSQL database schema converter
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Wen Heping
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-31 10:50 UTC by Jov
Modified: 2017-06-13 03:32 UTC (History)
2 users (show)

See Also:


Attachments
ora2pg.shar (2.42 KB, text/plain)
2017-05-31 10:50 UTC, Jov
no flags Details
ora2pg_v2.shar (2.69 KB, text/plain)
2017-06-10 02:54 UTC, Jov
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jov 2017-05-31 10:50:22 UTC
Created attachment 183096 [details]
ora2pg.shar

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL
compatible schema. It connects your Oracle database, scan it automatically
and extracts its structure or data, it then generates SQL scripts that you
can load into your PostgreSQL database. Ora2Pg can be used from reverse
engineering Oracle database to huge enterprise database migration or simply
to replicate some Oracle data into a PostgreSQL database. It is really easy
to used and doesn't need any Oracle database knowledge than providing the
parameters needed to connect to the Oracle database.

WWW: https://github.com/darold/ora2pg
Comment 1 Wen Heping freebsd_committer freebsd_triage 2017-06-10 01:16:13 UTC
The build failed with message:


....
Installing /wrkdirs/usr/ports/databases/ora2pg/work/stage/usr/local/lib/perl5/site_perl/man/man3/ora2pg.3
Installing /wrkdirs/usr/ports/databases/ora2pg/work/stage/usr/local/bin/ora2pg_scanner
Installing /wrkdirs/usr/ports/databases/ora2pg/work/stage/usr/local/bin/ora2pg
Installing default configuration file (ora2pg.conf.dist) to /usr/local/etc/ora2pg
====> Compressing man pages (compress-man)
===========================================================================
====> Running Q/A tests (stage-qa)
Notice: You have some Perl modules as dependencies but you do not have devel/p5-Module-CoreList installed, the perlcore QA check gets better results when using it, especially with older Perl versions.
====> Checking for pkg-plist issues (check-plist)
===> Parsing plist
===> Checking for items in STAGEDIR missing from pkg-plist
===> Checking for items in pkg-plist which are not in STAGEDIR
===> No pkg-plist issues found (check-plist)
====>> Checking for staging violations... done
====>> Error: Filesystem touched during stage (files must install to ${STAGEDIR}):
extra: usr/local/doc
extra: usr/local/etc/ora2pg
build of databases/ora2pg ended at Sat Jun 10 09:11:55 CST 2017
build time: 00:00:23
!!! build failure encountered !!!
[00:01:12] ====>> Error: Build failed in phase: stage_fs_violation
[00:01:12] ====>> Cleaning up
[00:01:13] ====>> Umounting file systems
Comment 2 Jov 2017-06-10 02:54:35 UTC
Created attachment 183370 [details]
ora2pg_v2.shar

v2 patch:
1.remove .packlist from plist file make poudriere happy
2.fix ETCDIR and DOCDIR

portlint clean
poudriere 11.0Ramd64 pass
Comment 3 Jov 2017-06-10 02:56:36 UTC
(In reply to Wen Heping from comment #1)
Hi, I just fix 2 problems for this port,now should work.
Comment 4 commit-hook freebsd_committer freebsd_triage 2017-06-13 03:31:57 UTC
A commit references this bug:

Author: wen
Date: Tue Jun 13 03:30:52 UTC 2017
New revision: 443484
URL: https://svnweb.freebsd.org/changeset/ports/443484

Log:
  Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL
  compatible schema. It connects your Oracle database, scan it automatically
  and extracts its structure or data, it then generates SQL scripts that you
  can load into your PostgreSQL database. Ora2Pg can be used from reverse
  engineering Oracle database to huge enterprise database migration or simply
  to replicate some Oracle data into a PostgreSQL database. It is really easy
  to used and doesn't need any Oracle database knowledge than providing the
  parameters needed to connect to the Oracle database.

  WWW: https://github.com/darold/ora2pg

  PR:		219682
  Submitted by:	amutu@amutu.com

Changes:
  head/databases/Makefile
  head/databases/ora2pg/
  head/databases/ora2pg/Makefile
  head/databases/ora2pg/distinfo
  head/databases/ora2pg/pkg-descr
  head/databases/ora2pg/pkg-plist