Fork me on GitHub
#datomic
<
2015-07-24
>
a.espolov07:07:25

Must I point basis-t in the rest transact request?

a.espolov07:07:08

however when I use basis-t, the transaction is still not satisfied (

marshall13:07:20

@a.espolov: I would suggest trying your transaction from the web UI to ensure your data and parameters are correct. Also, errors from the REST service will be in the transactor logs and/or the peer logs

marshall13:07:54

@a.espolov: Finally, for a transaction, you don’t use the :query-params, just the :tx-data map: http://docs.datomic.com/rest.html#transact

a.espolov13:07:42

key :query-params for client from http-kit

marshall13:07:55

@a.espolov: ah, sorry, misread

marshall13:07:08

@a.espolov: Can you verify your txn works from the web UI?

a.espolov13:07:41

web ui good worked)

marshall13:07:48

@a.espolov: the transactor logs should include additional information about the error. Also, can you build the transaction as a URL-encoded string directly and see if that works (instead of through http-kit)

lowl4tency14:07:48

guys, I’m trying to restore a datomic backup to transactor with psql as backend

lowl4tency14:07:04

org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided

lowl4tency14:07:01

My URI looks like datomic:<sql://example?jdbc:postgresql://datomic.example.com:5432/datomic?user=datomic&password=datomic>

lowl4tency14:07:24

What’s wrong with my restore-db command?

stuartsierra14:07:29

@lowl4tency: As a first step, I would suggest looking at the output of the Transactor when you start it. It prints the Datomic URI with a placeholder for the database name. Make sure that matches your URL in restore-db.

stuartsierra14:07:04

@lowl4tency: Also, make sure to quote the URI to prevent the shell from interpreting characters like ? and &

lowl4tency14:07:21

double quote?

stuartsierra14:07:42

Either double-quote or single-quote should work in Unix-style shells, double-quote only in Windows.

lowl4tency14:07:28

"Starting datomic:sql://<DB-NAME>?jdbc:<postgresql://datomic.example.com:5432/datomic?user=datomic&password=datomic>

lowl4tency14:07:59

I’ve got clean transactor and psql, I’ve created only datomic and datomic_kv dbs.

lowl4tency14:07:29

So I don’t need to pass datomic db name? only postgresql db?

lowl4tency14:07:49

Or my transactor working incorrect?

stuartsierra14:07:10

@lowl4tency: In the restore-db command, replace <DB-NAME> in that URI with the name of the (Datomic) database you want to restore into.

lowl4tency14:07:16

stuartsierra: is it critical? I’ve got CNAME for my postgresql rds instance

lowl4tency15:07:26

Oh, passed the A record for the db and quoted the address

lowl4tency15:07:57

So, just for clarify, CNAMEs are not working?

stuartsierra15:07:19

@lowl4tency: I don't know the answer to that. I do know that the Transactor's configuration file should have the correct URL to access the SQL database as the sql-url property.

stuartsierra15:07:03

As far as I know, if you can connect to the JDBC URI using Java's JDBC libraries, then Datomic should be able to connect to the same URI.

lowl4tency15:07:04

Will experiment so

lowl4tency15:07:37

Just it’s important for me, I’ve got a cname for RDS and if application are not able to use the cname for connect to datomic db is sad simple_smile

lowl4tency15:07:24

stuartsierra: okay, got it, thanks a lot!

stuartsierra15:07:31

You're welcome.