postgresql - Kerberos for Schemacrawler PostgresDB -


i trying access postgres database using kerberos credentials not have use password schemacrawler ask password , providing following error. 

schemacrawler 14.15.04  error: not connect jdbc:postgresql://nhc-contracts-db-dev.nicc.noblis.org:5432/networx?applicationname=schemacrawler;loggerlevel=debug, user 'phayes', properties {}  re-run schemacrawler -? option  or, re-run schemacrawler additional -loglevel=config option details on error apr 14, 2017 10:43:29 us.fatehi.commandlineparser.commandlineutility logsafearguments info: schemacrawler, v14.15.04 apr 14, 2017 10:43:29 us.fatehi.commandlineparser.commandlineutility logsafearguments info: command line: -server=postgresql -host=nhc-contracts-db-dev.nicc.noblis.org -port=5432 -database=networx -schemas=public -user=phayes -password=***** -infolevel=standard -command=schema -loglevel=config apr 14, 2017 10:43:29 us.fatehi.commandlineparser.commandlineutility logfullstacktrace severe: not connect jdbc:postgresql://nhc-contracts-db-dev.nicc.noblis.org:5432/networx?applicationname=schemacrawler;loggerlevel=debug, user 'phayes', properties {} schemacrawler.schemacrawler.schemacrawlersqlexception: not connect jdbc:postgresql://nhc-contracts-db-dev.nicc.noblis.org:5432/networx?applicationname=schemacrawler;loggerlevel=debug, user 'phayes', properties {}         @ schemacrawler.schemacrawler.basedatabaseconnectionoptions.getconnection(basedatabaseconnectionoptions.java:183)         @ schemacrawler.schemacrawler.basedatabaseconnectionoptions.getconnection(basedatabaseconnectionoptions.java:102)         @ schemacrawler.tools.commandline.schemacrawlercommandline.execute(schemacrawlercommandline.java:127)         @ schemacrawler.main.main(main.java:90) caused by: org.postgresql.util.psqlexception: gss authentication failed         @ org.postgresql.gss.makegss.authenticate(makegss.java:66)         @ org.postgresql.core.v3.connectionfactoryimpl.doauthentication(connectionfactoryimpl.java:594)         @ org.postgresql.core.v3.connectionfactoryimpl.openconnectionimpl(connectionfactoryimpl.java:222)         @ org.postgresql.core.connectionfactory.openconnection(connectionfactory.java:49)         @ org.postgresql.jdbc.pgconnection.<init>(pgconnection.java:194)         @ org.postgresql.driver.makeconnection(driver.java:431)         @ org.postgresql.driver.connect(driver.java:247)         @ schemacrawler.schemacrawler.basedatabaseconnectionoptions.getconnection(basedatabaseconnectionoptions.java:161)         ... 3 more caused by: javax.security.auth.login.loginexception: no loginmodules configured pgjdbc         @ javax.security.auth.login.logincontext.init(unknown source)         @ javax.security.auth.login.logincontext.<init>(unknown source)         @ org.postgresql.gss.makegss.authenticate(makegss.java:56)         ... 10 more

is there anyway can resolve this?

schemacrawler allows alternate way connect, using jdbc database connection url string. please refer postgresql documentation relating "connecting database" construct appropriate url string.

then, instead of host , port, use url instead example below. if not plan to, or not required to, use password, please make sure provide empty password -password=.

example snippet of schemacrawler command-line: -server=postgresql -url=<appropriate url here> -database=networx -schemas=public -user=phayes -password= -infolevel=standard -command=schema

sualeh fatehi, schemacrawler


-

Comments

Post a Comment

Popular posts from this blog

php - Permission denied. Laravel linux server -

when try register , send email user got error. working till yesterday. today gives me , cant figure out why. way on local testing work's. i'm stuck. please errorexception in compiled.php line 7512: file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied in compiled.php line 7512 @ handleexceptions->handleerror('2', 'file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied', '/var/www/html/bootstrap/cache/compiled.php', '7512', array('path' => '/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php', 'contents' => 'please activate account clicking on following link. <a href="<?php echo e(route('auth.activate', $token)); ?>"><?php echo e(route('auth.activate', $token)); ?...
Read more

google bigquery - Delta between query execution time and Java query call to finish -

context our container cluster located @ us-east1-c we using following java library: google-cloud-bigquery, 0.9.2-beta our dataset has around 26m rows , represents ~10g all of our queries return less 100 rows grouping on specific column question we analyzed last 100 queries executed in bigquery, these executed in 2-3 seconds (we analyzed calling bq --format=prettyjson show -j jobid , end time - creation time). in our java logs though, of calls bigquery.query blocking 5-6 seconds (and 10 seconds not out of ordinary). explain systematic gap between query finish in bigquery cluster , results being available in java? know 5-6 seconds isn't astronomic, curious see if normal behaviour when using java bigquery cloud library. i didn't dig point analyzed outbound call using wireshark. our tests executed in our container cluster (kubernetes). code queryrequest request = queryrequest.newbuilder(sql) .setmaxwaittime(30000l) .setuselega...
Read more

python - Pandas two dataframes multiplication? -

i have 2 data frames (a , b) a: column 1, column 2, column 3 0.1 0.5 0.7 b: row 1 5 row 2 6 row 3 7 how perform multiplication like (0.1)*5, (0.5)* 6, , (0.7)*7? in other words, how multiply value in first row of b value in first column of a, second row of b value in second column of b, , etc? you want multiply values without respect whether rows or columns. pd.series(a.values.ravel() * b.values.ravel()) 0 0.5 1 3.0 2 4.9 dtype: float64
Read more