[BUG]:latest package (15.06.01) is BROKEN #81

bheemreddy181-zz · 2019-03-12T03:30:49Z

 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

Steps As below :

export SCHEMACRAWLER_VERSION=15.06.01
wget https://github.com/adriens/schemacrawler-deb/releases/download/${SCHEMACRAWLER_VERSION}/schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
sudo dpkg -i schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
schemacrawler -version

The text was updated successfully, but these errors were encountered:

adriens · 2019-03-12T04:37:06Z

@bheemreddy181 : can you please try with the default package (no additional lints) ?

bheemreddy181-zz · 2019-03-12T12:18:02Z

I could see the same issue with that as well

bheemreddy181-zz · 2019-03-12T14:45:03Z

I also tried with the steps you mentioned on this : #78 (comment)

adriens · 2019-03-12T23:29:26Z

Please try this :

cd
mkdir schemacrawler-issue
schemacrawler-issue
sudo apt-get remove schemacrawler
# should return an error
schemacrawler -version
export SCHEMACRAWLER_VERSION=15.06.01
wget https://github.com/adriens/schemacrawler-deb/releases/download/${SCHEMACRAWLER_VERSION}/schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
sudo dpkg -i schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
schemacrawler -version

This gives me that :

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 · 2019-03-13T13:42:45Z

15.04.01 - works well for me - All later versions i am facing issue

8b@ip-10-110-37-249:~/schemacrawler-issue$ export SCHEMACRAWLER_VERSION=15.04.01
8b@ip-10-110-37-249:~/schemacrawler-issue$ wget https://github.com/adriens/schemacrawler-deb/releases/download/${SCHEMACRAWLER_VERSION}/schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
--2019-03-13 13:41:07--  https://github.com/adriens/schemacrawler-deb/releases/download/15.04.01/schemacrawler-deb-15.04.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/8d869b00-3aa3-11e9-94fd-da2304f106cf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190313%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190313T134107Z&X-Amz-Expires=300&X-Amz-Signature=b1f4b8e3f940fa621ee7c4f044a17a136c25a8dc209c03b0861a38dba76f5632&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dschemacrawler-deb-15.04.01_all-with-additional-lints.deb&response-content-type=application%2Foctet-stream [following]
--2019-03-13 13:41:07--  https://github-production-release-asset-2e65be.s3.amazonaws.com/23130372/8d869b00-3aa3-11e9-94fd-da2304f106cf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190313%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190313T134107Z&X-Amz-Expires=300&X-Amz-Signature=b1f4b8e3f940fa621ee7c4f044a17a136c25a8dc209c03b0861a38dba76f5632&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dschemacrawler-deb-15.04.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)... 54.231.81.16
Connecting to github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)|54.231.81.16|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 45406836 (43M) [application/octet-stream]
Saving to: ‘schemacrawler-deb-15.04.01_all-with-additional-lints.deb’

schemacrawler-deb-15.04.01_all-with-addit 100%[====================================================================================>]  43.30M  39.6MB/s    in 1.1s

2019-03-13 13:41:08 (39.6 MB/s) - ‘schemacrawler-deb-15.04.01_all-with-additional-lints.deb’ saved [45406836/45406836]

8b@ip-10-110-37-249:~/schemacrawler-issue$ sudo dpkg -i schemacrawler-deb-${SCHEMACRAWLER_VERSION}_all-with-additional-lints.deb
Selecting previously unselected package schemacrawler.
(Reading database ... 193354 files and directories currently installed.)
Preparing to unpack schemacrawler-deb-15.04.01_all-with-additional-lints.deb ...
Unpacking schemacrawler (15.04.01) ...
Setting up schemacrawler (15.04.01) ...
8b@ip-10-110-37-249:~/schemacrawler-issue$ schemacrawler -version
SchemaCrawler 15.04.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 OpenJDK 64-Bit Server VM 1.8.0_191-8u191-b12-2ubuntu0.16.04.1-b12
Linux 4.4.0-1030-aws

Working to reproduce #81

adriens · 2019-03-13T22:03:38Z

Full list of files below :

vagrant@ubuntu-bionic:/opt/schemacrawler/lib$ du -sh * .
588K    derbyclient-10.15.1.3.jar
2.1M    h2-1.4.198.jar
1.5M    hsqldb-2.4.1.jar
4.7M    jt400-9.7.jar
576K    mariadb-java-client-2.4.0.jar
1.2M    mssql-jdbc-7.0.0.jre8.jar
2.1M    mysql-connector-java-8.0.15.jar
808K    postgresql-42.2.5.jar
624K    schemacrawler-15.06.01.jar
12K     schemacrawler-db2-15.06.01.jar
8.0K    schemacrawler-hsqldb-15.06.01.jar
88K     schemacrawler-lint-15.06.01.jar
12K     schemacrawler-mysql-15.06.01.jar
12K     schemacrawler-offline-15.06.01.jar
32K     schemacrawler-oracle-15.06.01.jar
16K     schemacrawler-postgresql-15.06.01.jar
12K     schemacrawler-sqlite-15.06.01.jar
12K     schemacrawler-sqlserver-15.06.01.jar
6.8M    sqlite-jdbc-3.25.2.jar
4.0K    .

adriens · 2019-03-13T22:04:10Z

I could reproduce the issue then :

vagrant@ubuntu-bionic:/opt/schemacrawler/lib$ schemacrawler -version
Error: Could not find or load main class schemacrawler.Main
vagrant@ubuntu-bionic:/opt/schemacrawler/lib$

adriens · 2019-03-13T22:06:49Z

@bheemreddy181 : I'm investigating on it as I can reproduce the issue.

bheemreddy181-zz · 2019-03-13T22:08:08Z

Cool thanks for taking a look

adriens · 2019-03-13T22:21:00Z

OK, GOT IT !!!

A new jar schemacrawler-scripting-15.06.01.jar must be added to the distribution 👍

adriens · 2019-03-13T22:23:44Z

<dependency>
    <groupId>us.fatehi</groupId>
    <artifactId>schemacrawler-scripting</artifactId>
    <version>15.06.01</version>
</dependency>

adriens · 2019-03-13T22:27:55Z

This one is the one that causes the issue as it's required :

<dependency>
    <groupId>us.fatehi</groupId>
    <artifactId>schemacrawler-commandline</artifactId>
    <version>15.06.01</version>
    <scope>test</scope>
</dependency>

adriens · 2019-03-13T22:28:22Z

I'll fix t very soon 👍

adriens · 2019-03-13T22:36:23Z

Corrupted releases dropped.

adriens · 2019-03-14T00:44:42Z

The fix is on its way 🕙

adriens · 2019-03-14T00:50:23Z

Destroying my vm, then rebuild from scratch then release the fix

adriens · 2019-03-14T01:02:51Z

@bheemreddy181 : the debians are being released : can you confirm me the issue is fixed ❓

bheemreddy181-zz · 2019-03-14T02:05:09Z

@adriens it's not really working even after new release leading to a new error as below

Mar 14, 2019 2:02:52 AM us.fatehi.commandlineparser.CommandLineUtility logFullStackTrace
SEVERE: Could not find a suitable JDBC driver for database connection URL, jdbc:postgresql://localhost:5432/development?ApplicationName=SchemaCrawler;loggerLevel=DEBUG
schemacrawler.schemacrawler.SchemaCrawlerSQLException: Could not find a suitable JDBC driver for database connection URL, jdbc:postgresql://localhost:5432/development?ApplicationName=SchemaCrawler;loggerLevel=DEBUG
	at schemacrawler.tools.databaseconnector.BaseDatabaseConnectionOptions.getJdbcDriver(BaseDatabaseConnectionOptions.java:376)
	at schemacrawler.tools.databaseconnector.BaseDatabaseConnectionOptions.createConnectionProperties(BaseDatabaseConnectionOptions.java:321)
	at schemacrawler.tools.databaseconnector.BaseDatabaseConnectionOptions.getConnection(BaseDatabaseConnectionOptions.java:145)
	at schemacrawler.tools.databaseconnector.BaseDatabaseConnectionOptions.getConnection(BaseDatabaseConnectionOptions.java:104)
	at schemacrawler.tools.commandline.SchemaCrawlerCommandLine.execute(SchemaCrawlerCommandLine.java:119)
	at schemacrawler.Main.main(Main.java:92)
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315)
	at schemacrawler.tools.databaseconnector.BaseDatabaseConnectionOptions.getJdbcDriver(BaseDatabaseConnectionOptions.java:371)
	... 5 more

adriens · 2019-03-14T02:17:25Z

Please provide your command line or parameter file

bheemreddy181-zz · 2019-03-14T02:18:56Z

Same error even with the base package @adriens - PFB command line arguments used

schemacrawler -server=postgresql -database=portfolio_development -user=8b -password=''  -c=lint -lintdispatch=terminate_system -runalllinters=false -loglevel=ALL

adriens · 2019-03-14T02:20:53Z

In the documentation see https://jdbc.postgresql.org/documentation/80/connect.html

Your url :

jdbc:postgresql://localhost:5432/development?ApplicationName=SchemaCrawler;loggerLevel=DEBUG

psql recommanded :

jdbc:postgresql://localhost/test?user=fred&password=secret&ssl=true

See the & instead of ; ?

adriens · 2019-03-14T02:22:00Z

I don't know where ApplicationName=SchemaCrawler is coming from..

adriens · 2019-03-14T02:23:50Z

Are you using psql mode provided by schemacrawler or using a custome generic jdbc url ?

adriens · 2019-03-14T02:30:52Z

OK @bheemreddy181 : can you please give a try to the native zip or tar.gz distribution ?

Unzip it a pass the exact same command line 👍

adriens · 2019-03-14T02:31:00Z

🙏

adriens · 2019-03-14T02:31:43Z

There is something strange in the jdbc generated url, I want to be sure it's not a core schemacrawler issue

bheemreddy181-zz · 2019-03-14T02:33:11Z

I was using the same command line arguments which were passing with the 15.04.01 version of the debain package

adriens · 2019-03-14T02:36:45Z

Yep, but can you try with the native zip distribution ?

bheemreddy181-zz · 2019-03-14T02:36:46Z

Base package works fine , you don't see any lints just because the runAllLinters is set to false

adriens · 2019-03-14T02:46:09Z

ANd whatif you provide the generic jdbc url ? (sorry for asking you)

adriens · 2019-03-14T03:02:59Z

OK, reproduced in my Vagrant VM :

schemacrawler -server=postgresql -database=public -host=localhost -user=postgres -c=lint

vagrant@ubuntu-bionic:~$ schemacrawler -server=postgresql -database=public -host=localhost -user=postgres -c=lint
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.
password:
SchemaCrawler 15.06.01

Error: Could not find a suitable JDBC driver for database connection URL, jdbc:postgresql://localhost:5432/public?ApplicationName=SchemaCrawler;loggerLevel=DEBUG

adriens · 2019-03-14T03:05:27Z

Same error with jdbc generic :

schemacrawler -url=jdbc:postgresql://localhost/public -database=public -host=localhost -user=postgres -c=lint

adriens · 2019-03-14T03:37:57Z

The derby driver in its derbyclient-10.15.1.3.jar puts the shit in here 😆

adriens · 2019-03-14T03:48:15Z

I think I got it ! Can you give it a try ? @bheemreddy181 ?

Fixes #81

adriens · 2019-03-14T04:01:37Z

Fully tested against Postgres @bheemreddy181 👍

adriens · 2019-03-14T04:02:06Z

Can you confirm me you can enjoy the package too ? (clean up your sintall prior to this)

adriens · 2019-03-14T04:22:10Z

@bheemreddy181 : waiting or your feedback to definitely close this issue 🙏

bheemreddy181-zz · 2019-03-14T12:04:14Z

@adriens will verify this in some time

bheemreddy181-zz · 2019-03-14T12:32:37Z

Working as expected 💯 👍 💯

bheemreddy181-zz · 2019-03-14T14:16:30Z

@adriens Appreciate your time and effort for this, thanks again :-) Have a great day 👍

adriens · 2019-03-14T19:28:53Z

Thanks a lot for having reported tis and your patience, great team job !

adriens · 2019-03-15T02:42:19Z

Thanks a lot for having reported tis and your patience, great team job !

adriens self-assigned this Mar 12, 2019

adriens changed the title ~~latest package (15.06.01) isn't working~~ latest package (15.06.01) with all lints isn't working Mar 12, 2019

adriens closed this as completed Mar 12, 2019

adriens reopened this Mar 13, 2019

adriens changed the title ~~latest package (15.06.01) with all lints isn't working~~ latest package (15.06.01) is BROKEN Mar 13, 2019

adriens added bug blocking labels Mar 13, 2019

adriens mentioned this issue Mar 13, 2019

Build a Vagrant image to test install process #83

Closed

adriens added a commit that referenced this issue Mar 13, 2019

Build a Vagrant image to test install process #83

e9b560b

Working to reproduce #81

bheemreddy181-zz changed the title ~~latest package (15.06.01) is BROKEN~~ [BUG]:latest package (15.06.01) is BROKEN Mar 13, 2019

adriens pinned this issue Mar 13, 2019

adriens closed this as completed in 3190b1f Mar 14, 2019

adriens reopened this Mar 14, 2019

adriens closed this as completed in 675db28 Mar 14, 2019

adriens added a commit that referenced this issue Mar 14, 2019

latest package (15.06.01) is BROKEN

e5380c4

Fixes #81

adriens mentioned this issue Mar 14, 2019

Impossible to uprade Derby driver to its latest version schemacrawler/SchemaCrawler#247

Closed

adriens reopened this Mar 14, 2019

bheemreddy181-zz closed this as completed Mar 14, 2019

[BUG]:latest package (15.06.01) is BROKEN #81

[BUG]:latest package (15.06.01) is BROKEN #81

Comments

bheemreddy181-zz commented Mar 12, 2019 • edited Loading

adriens commented Mar 12, 2019

bheemreddy181-zz commented Mar 12, 2019

bheemreddy181-zz commented Mar 12, 2019 • edited Loading

adriens commented Mar 12, 2019

bheemreddy181-zz commented Mar 13, 2019

adriens commented Mar 13, 2019 • edited Loading

adriens commented Mar 13, 2019

adriens commented Mar 13, 2019

bheemreddy181-zz commented Mar 13, 2019

adriens commented Mar 13, 2019

adriens commented Mar 13, 2019

adriens commented Mar 13, 2019

adriens commented Mar 13, 2019

adriens commented Mar 13, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019 • edited Loading

adriens commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019

adriens commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019 • edited Loading

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019

bheemreddy181-zz commented Mar 14, 2019

adriens commented Mar 14, 2019

adriens commented Mar 15, 2019

bheemreddy181-zz commented Mar 12, 2019 •

edited

Loading

bheemreddy181-zz commented Mar 12, 2019 •

edited

Loading

adriens commented Mar 13, 2019 •

edited

Loading

bheemreddy181-zz commented Mar 14, 2019 •

edited

Loading

bheemreddy181-zz commented Mar 14, 2019 •

edited

Loading