search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

Retrieve DB name from influxdb #112

Closed florasamuel closed 8 months ago

florasamuel commented 10 months ago

Hi,

I am using dbschema 9.4.1 and trying to connect to influxdb using dbschema, however it returns 400 error.

com.influxdb.exceptions.BadRequestException: HTTP status code: 400; Message: failed to decode request body: organization name "SAP?days=" not found at com.influxdb.internal.AbstractRestClient.responseToError(AbstractRestClient.java:113) at com.influxdb.internal.AbstractQueryApi$1.onResponse(AbstractQueryApi.java:220) at com.influxdb.internal.AbstractQueryApi.query(AbstractQueryApi.java:247) at com.influxdb.internal.AbstractQueryApi.query(AbstractQueryApi.java:199) at com.influxdb.internal.AbstractQueryApi.query(AbstractQueryApi.java:131) at com.influxdb.client.internal.QueryApiImpl.query(QueryApiImpl.java:939) at com.influxdb.client.internal.QueryApiImpl.query(QueryApiImpl.java:123) at com.influxdb.client.internal.QueryApiImpl.query(QueryApiImpl.java:85) at com.influxdb.client.internal.QueryApiImpl.query(QueryApiImpl.java:75) at com.wisecoders.dbschema.influxdb.InfluxMetaData.getSchemas(InfluxMetaData.java:31) at com.wisecoders.dbs.dbms.Dbms.listSchemasAndCatalogs(Dbms.java:287) at com.wisecoders.dbs.dbms.Dbms.loadSchemasAndCatalogs(Dbms.java:265) at com.wisecoders.dbs.dbms.reverseEngineer.tasks.FxImportSelectionTask.a(FxImportSelectionTask.java:41) at com.wisecoders.dbs.dbms.reverseEngineer.tasks.FxImportSelectionTask.call(FxImportSelectionTask.java:20)

Provided we have buckets in influxdb, what valu should be entered in organization field?

florasamuel commented 10 months ago

Found the issue. replaced ? in JDBC url with & using Edit manually option and it worked.

JDBC url: https://HOST:PORT/DB?org=PARAM&token=PARAM2 and not https://HOST:PORT/DB?org=PARAM?token=PARAM2

wise-coders commented 10 months ago

Thank you for writing about the fix. May I ask, were did you saw the URL with two '?'? I mean the wrong one: https://host:PORT/DB?org=PARAM?token=PARAM2 Was this in DbSchema, in help or other place? We would fix this. I am not sure where to check.

florasamuel commented 10 months ago
image
florasamuel commented 10 months ago

same when i choose the HTTPs option for JDBC URL.

wise-coders commented 10 months ago

Could you please install the latest DbSchema version 9.4.1. from the website ? It should have this issue fixed. If not, please write back and we will check again with high priority.

wise-coders commented 10 months ago

Best regards, Dragos Pruteanu

On Friday, August 11, 2023 at 1:18:33 PM, DaveDevelop wrote:

same when i choose the HTTPs option for JDBC URL. — Reply to this email directly, [1] view it on GitHub, or [2] unsubscribe. You are receiving this because you commented.Message ID:

[1] https://github.com/wise-coders/dbschema/issues/112#issuecomment-1674586699 [2] https://github.com/notifications/unsubscribe-auth/AOL52Y2FG7LM74G2GROXEF3XUYIH7ANCNFSM6AAAAAA3MCPMAE

florasamuel commented 10 months ago

Sure...Thanks a lot for the fix...will try with the newer version and update soon

wise-coders commented 8 months ago

I consider the issue closed. Please reopen the ticket if is the case.