search

adriens / schemacrawler-deb

Debian package for schemacrawler
9 stars 3 forks source link

Latest Release (15.05.01) isn't working #78

Closed bheemreddy181-zz closed 5 years ago

bheemreddy181-zz commented 5 years ago

Seeing the below error : 

Error: Could not find or load main class schemacrawler.Main

Steps followed :

  1. export SCHEMACRAWLER_VERSION=15.05.01
  2. wget https://github.com/adriens/schemacrawler-deb/releases/download/${SCHEMACRAWLER_VERSION}/schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
  3. sudo dpkg -i schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
  4. run schemacrawler command
bheemreddy181-zz commented 5 years ago

https://github.com/schemacrawler/SchemaCrawler in general working as expected : 

bvennapureddy@clm-C02TT0U0HTDG ~/Desktop/schemacrawler-15.05.01-distribution/_schemacrawler $ ./schemacrawler.sh -server=postgresql -database=test -user=bvennapureddy -password='' -linterconfigs=/bin/schemacrawler-linter-configs.xml -c=lint -lintdispatch=terminate_system -runalllinters=false

Lints
========================================================================

_reporting.loans_info_fact                                       [table]
------------------------------------------------------------------------

                                                        [lint, critical]
    no primary key

portfolio.foos                                                   [table]
------------------------------------------------------------------------

                                                        [lint, critical]
    no primary key

Summary of schema lints:
[critical]*     2- no primary key
bheemreddy181-zz commented 5 years ago

Base package as well has the same issues 

export SCHEMACRAWLER_VERSION=15.05.01
8b@schemacrawlerpoc:~$ wget  https://github.com/adriens/schemacrawler-deb/releases/download/${SCHEMACRAWLER_VERSION}/schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all.deb
--2019-03-11 15:57:17--  https://github.com/adriens/schemacrawler-deb/releases/download/15.05.01/schemacrawler-deb-15.05.01_all.deb
Resolving github.com (github.com)... 192.30.253.113, 192.30.253.112
Connecting to github.com (github.com)|192.30.253.113|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-production-release-asset-2e65be.s3.amazonaws.com/23130372/a118f680-43ff-11e9-9f78-38fa09154d5b?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190311%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190311T155717Z&X-Amz-Expires=300&X-Amz-Signature=bff2e0187da0ee53daa4919ee2ebac2334fa85ebf992424b72d4df79a6d418de&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dschemacrawler-deb-15.05.01_all.deb&response-content-type=application%2Foctet-stream [following]
--2019-03-11 15:57:17--  https://github-production-release-asset-2e65be.s3.amazonaws.com/23130372/a118f680-43ff-11e9-9f78-38fa09154d5b?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190311%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190311T155717Z&X-Amz-Expires=300&X-Amz-Signature=bff2e0187da0ee53daa4919ee2ebac2334fa85ebf992424b72d4df79a6d418de&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dschemacrawler-deb-15.05.01_all.deb&response-content-type=application%2Foctet-stream
Resolving github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)... 52.216.97.35
Connecting to github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)|52.216.97.35|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 45374758 (43M) [application/octet-stream]
Saving to: ‘schemacrawler-deb-15.05.01_all.deb’

schemacrawler-deb-15.05.01_all.deb                              100%[======================================================================================================================================================>]  43.27M  51.3MB/s    in 0.8s

2019-03-11 15:57:18 (51.3 MB/s) - ‘schemacrawler-deb-15.05.01_all.deb’ saved [45374758/45374758]

8b@schemacrawlerpoc:~$ sudo dpkg -i schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all.deb
Selecting previously unselected package schemacrawler.
(Reading database ... 168212 files and directories currently installed.)
Preparing to unpack schemacrawler-deb-15.05.01_all.deb ...
Unpacking schemacrawler (15.05.01) ...
Setting up schemacrawler (15.05.01) ...
8b@schemacrawlerpoc:~$ schemacrawler
Error: Could not find or load main class schemacrawler.Main
adriens commented 5 years ago 
8b@schemacrawlerpoc:~$ schemacrawler
Error: Could not find or load main class schemacrawler.Main
adriens commented 5 years ago

I'm reproducing it. Still not finding what's wrong ...

adriens commented 5 years ago

A jar is corrupting the deb : I have to figure out which one...

adriens commented 5 years ago 
export SCHEMACRAWLER_VERSION=15.06.01
wget  https://github.com/adriens/schemacrawler-deb/releases/download/${SCHEMACRAWLER_VERSION}/schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all.deb
sudo dpkg -i schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all.deb
schemacrawler -version

Finally leads to :

SchemaCrawler 15.06.01
Database schema discovery and comprehension tool
Copyright (c) 2000-2019, Sualeh Fatehi <sualeh@hotmail.com>.

You can search for database schema objects using regular expressions, 
and output the schema and data in a readable text format. You can find 
potential schema design issues with lint. The output serves for 
database documentation is designed to be diff-ed against other database 
schemas. SchemaCrawler also generates schema diagrams.

Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.8.0_201-b09
Linux 4.10.0-38-generic
bheemreddy181-zz commented 5 years ago

Error: Could not find or load main class schemacrawler.Main Issue still exists on the debain package with Additional-lints

bheemreddy181-zz commented 5 years ago 
 https://github.com/adriens/schemacrawler-deb/releases/download/15.06.01/schemacrawler-deb-15.06.01_all-with-additional-lints.deb
Resolving github.com (github.com)... 192.30.253.113, 192.30.253.112
Connecting to github.com (github.com)|192.30.253.113|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-production-release-asset-2e65be.s3.amazonaws.com/23130372/fe6e7f80-44b3-11e9-866c-b4b58164a5e0?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190312%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190312T003945Z&X-Amz-Expires=300&X-Amz-Signature=e0fb8dad3187a988ee25f44a51d1224aa04a07617167f2e18df698af8b969d76&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dschemacrawler-deb-15.06.01_all-with-additional-lints.deb&response-content-type=application%2Foctet-stream [following]
--2019-03-11 19:39:46--  https://github-production-release-asset-2e65be.s3.amazonaws.com/23130372/fe6e7f80-44b3-11e9-866c-b4b58164a5e0?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190312%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190312T003945Z&X-Amz-Expires=300&X-Amz-Signature=e0fb8dad3187a988ee25f44a51d1224aa04a07617167f2e18df698af8b969d76&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dschemacrawler-deb-15.06.01_all-with-additional-lints.deb&response-content-type=application%2Foctet-stream
Resolving github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)... 52.216.170.243
Connecting to github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)|52.216.170.243|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 45379998 (43M) [application/octet-stream]
Saving to: ‘schemacrawler-deb-15.06.01_all-with-additional-lints.deb’
100%[======================================>] 45,379,998  27.8MB/s   in 1.6s   
2019-03-11 19:39:47 (27.8 MB/s) - ‘schemacrawler-deb-15.06.01_all-with-additional-lints.deb’ saved [45379998/45379998]
Selecting previously unselected package schemacrawler.
(Reading database ... 77643 files and directories currently installed.)
Preparing to unpack schemacrawler-deb-15.06.01_all-with-additional-lints.deb ...
Unpacking schemacrawler (15.06.01) ...
Setting up schemacrawler (15.06.01) ...
===============Running the linters==============
19:39:48
Error: Could not find or load main class schemacrawler.Main