search

near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
123 stars 56 forks source link

ERROR: permission denied for table #270

Closed ryancwalsh closed 2 years ago

ryancwalsh commented 2 years ago

Using the public credentials at https://github.com/near/near-indexer-for-explorer#shared-public-access, I've connected (via pgAdmin 4 and also via Nocodb) to the mainnet and testnet indexers.

I've used it successfully in the past, but today for every table I've tried (on both mainnet and testnet), I get errors like:

ERROR: permission denied for table transactions SQL state: 42501

I've used queries like:

SELECT transaction_hash, block_hash, chunk_hash, index_in_chunk, block_timestamp, signer_id, public_key, nonce, receiver_id, signature, status, receipt_id, receipt_conversion_gas_burnt, receipt_conversion_tokens_burnt
    FROM public.transactions
    LIMIT 100;
ryancwalsh commented 2 years ago

I used to be able to browse the Near indexer via this same pgAdmin installation. I'm not sure why it stopped working.

I'm on Mac, and I upgraded from pgAdmin 6.7 to 6.8 today but still have this problem.

Interestingly, running certain queries via Nocodb works.

khorolets commented 2 years ago

The query you've posted is weird. I've checked public access with psql, and I've used proper field names (included_in_block_hash, included_in_chunk_hash, signer_account_id, etc.). I haven't received permission denied error. I suspect something wrong with the apps you're using. 

$ psql "postgres://public_readonly:nearprotocol@mainnet.db.explorer.indexer.near.dev/mainnet_explorer"
mainnet_explorer=> SELECT transaction_hash, included_in_block_hash, included_in_chunk_hash, index_in_chunk, block_timestamp, signer_account_id, signer_public_key, nonce, receiver_account_id, signature, status, converted_into_receipt_id, receipt_conversion_gas_burnt, receipt_conversion_tokens_burnt
        FROM public.transactions
        LIMIT 100;
               transaction_hash               |            included_in_block_hash            |            included_in_chunk_hash            | index_in_chunk |   block_timestamp   |                        signer_account_id                         |                  signer_public_key                   |     nonce      |                       receiver_account_id                        |                                            signature                                             |       status       |          converted_into_receipt_id           | receipt_conversion_gas_burnt | receipt_conversion_tokens_burnt
----------------------------------------------+----------------------------------------------+----------------------------------------------+----------------+---------------------+------------------------------------------------------------------+------------------------------------------------------+----------------+------------------------------------------------------------------+--------------------------------------------------------------------------------------------------+--------------------+----------------------------------------------+------------------------------+---------------------------------
 AAmZkHvo6dwiy6gBU1sP59Feeav3PaPJjG6LJJvSFZtS | 4UQXrn3Ds2EEeQc72ep1Kv4MrWbhezfLuW9w7QYAXPEy | AWrABn5kXBqStz7hwtsjJaV3obNnkjnpY9aNF7p9eSdA |              1 | 1627455335933073267 | pro100kill2.near                                                 | ed25519:6uQadp3A13dGQuzXRLSUNe4SLHVh6uW4PDCPoUwASAFU | 43698590000027 | berryclub.ek.near                                                | ed25519:2ADKD8THNLEbiwe63LgLyWgDt7vRL4j6nDgLzEz26qkDuskcyFiVzGjzvcAkggBnUxixPDtYkTxdyDHAvgttFUHN | SUCCESS_RECEIPT_ID | fnjidxDqRY4fJ3D68vnB3B45caMdt4zQqJwQH62RUzz  |                2428529174048 |           242852917404800000000
 FJ41XumayYzJtt9ar5znJ6fbvcNcEDgw7YK2eoUFDK2t | 4UQXrn3Ds2EEeQc72ep1Kv4MrWbhezfLuW9w7QYAXPEy | AWrABn5kXBqStz7hwtsjJaV3obNnkjnpY9aNF7p9eSdA |              2 | 1627455335933073267 | valet.near                                                       | ed25519:5QrqiUHXDDgGKSZbGEvmHWwHFxMbuSKht2fSjo3zMkTR | 43259325000435 | app.nearcrowd.near                                               | ed25519:2VkhvxpPbFRkhcYgB8PWur9xLh8WUdg6rFe9PpjXBF8f9UWo97Z8qXbXShyeQHE1LNt55kFJ2kh2TU1qhAapZQTX | SUCCESS_RECEIPT_ID | BmdmTtUMDr9op8UVASups8QaV4TSYo8fFYjdmFT5tgUy |                2428068571644 |           242806857164400000000
 48S1CUHemKzrsAEM63smMYQPHU8siv6eRc89FVXNKxMF | TKxT1s92SZ71k3C3yiLMT2mKfV6mujBLSAFibrKpWua  | FR4rR2SBvVSpapn8rFaCvVpwKpTgLL4BUbHebTHwqrXa |              0 | 1627455338051153440 | gata45.near                                                      | ed25519:64MXpZeMa2jq93u9W2nuDp6CkJEukMm9RbtekgrWuDS4 | 43299180000451 | app.nearcrowd.near                                               | ed25519:3CQGtGQZN4NYM185eujeBpmr1dxxe7H23cuRMFTRteJQzJLsrPU13PU6ZuqN87Vn2gjc9RfQLrNx2isa5qb6NcYz | SUCCESS_RECEIPT_ID | HmHBzyyJ9dVqh2nqJYuxf2XYa3MT2vqNu4xxmHCJYqyZ |                2428073043512 |           242807304351200000000
 2DrPLbdASYQWUbmJbdN39vFUQMCDETUXrP4nHH8HDh9T | TKxT1s92SZ71k3C3yiLMT2mKfV6mujBLSAFibrKpWua  | FR4rR2SBvVSpapn8rFaCvVpwKpTgLL4BUbHebTHwqrXa |              1 | 1627455338051153440 | wg548.near                                                       | ed25519:HptXmzCajjXxoJ4rdG8UofEehnqMV1kPiuJjYthCzWa4 | 43759444000002 | 125c29c9748acb86e8c2595b15737a3471828b7f2d39dbf1f646c557c5eff433 | ed25519:3b8MUTyhFco3GcA9tZrNWPPehe7ZBU3zYtnrXbFsZNgrXZAGEsDrhpb6ecsWettdaCRMcQ7R5FWYBuBgdJfC64Pj | SUCCESS_RECEIPT_ID | B4LCQq6hbq7mfjZPhkdeb2go6oFTYs29cppCAeqLWXnj |                 424555062500 |            42455506250000000000
 3Y2pJ4dEyx8Sd6VSHTaycB5TsAhv4izCAsomUmTK2vKG | TKxT1s92SZ71k3C3yiLMT2mKfV6mujBLSAFibrKpWua  | FR4rR2SBvVSpapn8rFaCvVpwKpTgLL4BUbHebTHwqrXa |              2 | 1627455338051153440 | mthaitrinh2.near                                                 | ed25519:HSyimECfVUMvWGhMHV9ktLpRLgoX1xF3p571eZHEQ5BH | 43760346000047 | app.nearcrowd.near                                               | ed25519:41BEFCBRUFfmh3bYqpCKn61yJ6j1fHHKYXA13DHijY5RFpQET2erxVo1vCL4oqC6PsLUn8vNweFSeu2ajUAxjMpu | SUCCESS_RECEIPT_ID | 9JJopHcY5NzfFxMVn2n2bQdoBWUj3gHAsTbRQnwevwmQ |                2428068571644 |           242806857164400000000
 Fd8E3JnwNQNshhJnfgzhTvQSihnEkhzvT9KLt36WptWj | 6jrsXoBmTUwJGuSdeM3fNPAqb39yJ7bmpHz3L72kedHS | 8CZwdosjts1zj21fsvHSdgVRkvMbpxYhmHphn65AzDvC |              0 | 1627455338968317066 | app.nearcrowd.near                                               | ed25519:HtW1yGPW7JUAorCgJvjQyank8nWHHgXC2dMLxyA7YCuW | 43616820003832 | app.nearcrowd.near                                               | ed25519:2QjQbZKvQVJGL6UG43D4ZJHNsjMimXpAxswPSGvuakerpMFLEAT6EzUw71MnZmqustmQt1kjXzbMsAs2XboqMAwo | SUCCESS_RECEIPT_ID | HyZnjBhBR4qcNvJHfvZ4FN3TWMbm1aAxx3xk8cy4Di9u |                2428325704054 |           242832570405400000000
 CANmVLfFn469fSRddGsK4ojWaaCbV4juu89cdUFotXDV | 6jrsXoBmTUwJGuSdeM3fNPAqb39yJ7bmpHz3L72kedHS | 8CZwdosjts1zj21fsvHSdgVRkvMbpxYhmHphn65AzDvC |              1 | 1627455338968317066 | roschel1234.n

Nothing we can fix on the database end because nothing is broken with permissions, sorry.

Feel free to reopen the issue if you think we can help you form our end.

ryancwalsh commented 2 years ago

Never mind.

select * from transactions
LIMIT 20

does work.

I eventually figured out that it's helpful in pgAdmin to set the "DB restriction" field:

image

I must have mixed something up earlier.

Apologies for the distraction.