[ANNOUNCE] Abe 0.7: Open Source Block Explorer Knockoff - page 36.

ErebusBat

hero member

Activity: 560

Merit: 500

I am the one who knocks

Quote from: Remember remember the 5th of November on September 14, 2012, 07:33:14 PM

Quote from: John Tobey on September 11, 2012, 01:44:21 PM

Quote from: Remember remember the 5th of November on September 11, 2012, 01:38:57 PM

I see that Abe is still under development, when can we expect 0.7?

At the moment the holdup is writing a change log. Then I'll try to find all the pieces I need to build the Windows installer and update pypi. Anything particular you need?

As a matter of fact there are a few things. Currently ABE doesn't gracefully handle Ctr+C and so I have to execute the queries you gave a couple of pages back AND reset the blkoffset number to either 0 or a value which I've stored for emergencies.
And though it happened a long time ago, I had a very nasty problem where the bitcoin days destroyed value was 0 every few transactions/blocks and since I could not arbitrarily delete any blocks manually I was forced to reimport the blockchain all over again and this usually takes 2 weeks for me.

And not sure if there was a workaround, but while Abe is importing blocks, the webserver is off and there is no way for me to view the chain imported thus far.

I have a query that will give you import status. PM me if you want it.

Remember remember the 5th of November

legendary

Activity: 1862

Merit: 1011

Reverse engineer from time to time

Quote from: John Tobey on September 11, 2012, 01:44:21 PM

Quote from: Remember remember the 5th of November on September 11, 2012, 01:38:57 PM

I see that Abe is still under development, when can we expect 0.7?

At the moment the holdup is writing a change log. Then I'll try to find all the pieces I need to build the Windows installer and update pypi. Anything particular you need?

As a matter of fact there are a few things. Currently ABE doesn't gracefully handle Ctr+C and so I have to execute the queries you gave a couple of pages back AND reset the blkoffset number to either 0 or a value which I've stored for emergencies.
And though it happened a long time ago, I had a very nasty problem where the bitcoin days destroyed value was 0 every few transactions/blocks and since I could not arbitrarily delete any blocks manually I was forced to reimport the blockchain all over again and this usually takes 2 weeks for me.

And not sure if there was a workaround, but while Abe is importing blocks, the webserver is off and there is no way for me to view the chain imported thus far.

grazcoin

sr. member

Activity: 284

Merit: 250

Quote from: John Tobey on September 11, 2012, 01:44:21 PM

Quote from: Remember remember the 5th of November on September 11, 2012, 01:38:57 PM

I see that Abe is still under development, when can we expect 0.7?

At the moment the holdup is writing a change log. Then I'll try to find all the pieces I need to build the Windows installer and update pypi. Anything particular you need?

I would be glad to have the following features:

Support for multisig addresses:
===================
http://abe.bitcoinstats.org:2750/address/3JEFRC6tuXRjxG6YUDtYzEmYEphf5pb86C
https://blockchain.info/address/3JEFRC6tuXRjxG6YUDtYzEmYEphf5pb86C

Support for unspent:
============
http://blockchain.info/unspent?address=3JEFRC6tuXRjxG6YUDtYzEmYEphf5pb86C
(something in the direction on listunspent in https://en.bitcoin.it/wiki/Original_Bitcoin_client/API_calls_list)

A tool to convert address to pubkey
=====================
http://blockchain.info/q/pubkeyaddr/12oESJ63gKmf7EtqEdrV7Xnid8dmYTBKE3

and as a bonus, it could be nice to have something like:
http://blockchain.info/multiaddr?active=3871TUSvEuHqHZZnswWtQSs31vK6LWnwcG|383TnXCdXnCkhQy4fwm6ZN2sf7XpZ4YJmp|3JEFRC6tuXRjxG6YUDtYzEmYEphf5pb86C

Since blockchain.info does not support testnet, there is currently no way to get the above data for testnet.

greetings,
Grazcoin

John Tobey

hero member

Activity: 481

Merit: 529

Quote from: Remember remember the 5th of November on September 11, 2012, 01:38:57 PM

I see that Abe is still under development, when can we expect 0.7?

At the moment the holdup is writing a change log. Then I'll try to find all the pieces I need to build the Windows installer and update pypi. Anything particular you need?

Remember remember the 5th of November

legendary

Activity: 1862

Merit: 1011

Reverse engineer from time to time

I see that Abe is still under development, when can we expect 0.7?

Icoin

hero member

Activity: 585

Merit: 501

Thanks for the Support - Everything works

John Tobey

hero member

Activity: 481

Merit: 529

Icoin

hero member

Activity: 585

Merit: 501

I had to rebuild my server with ubuntu 12.04 64bit after the switch im not able to run abe anymore. I suspect that the change from python 2.6 to 2.7 aswell as the change from mysql 5.1 to 5.5 has something to do with it, since i use the same abe.conf as before and it was running on ubuntu 10.04 32bit.
I allways end up with this error:

Code:

Traceback (most recent call last):
  File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main
    "__main__", fname, loader, pkg_name)
  File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
    exec code in run_globals
  File "/opt/abe/Abe/abe.py", line 2023, in 
    sys.exit(main(sys.argv[1:]))
  File "/opt/abe/Abe/abe.py", line 1976, in main
    args, argv = readconf.parse_argv(argv, conf)
  File "Abe/readconf.py", line 57, in parse_argv
    _include(set(), val, arg_dict, config_name, strict)
  File "Abe/readconf.py", line 77, in _include
    entries = read(fp)
  File "Abe/readconf.py", line 153, in read
    js, c = scan_json(fp, c)
  File "Abe/readconf.py", line 259, in scan_json
    return _scan_json_compound(fp, c, ']')
  File "Abe/readconf.py", line 247, in _scan_json_compound
    cs, c = scan_json(fp, c)
  File "Abe/readconf.py", line 261, in scan_json
    return _scan_json_compound(fp, c, '}')
  File "Abe/readconf.py", line 247, in _scan_json_compound
    cs, c = scan_json(fp, c)
  File "Abe/readconf.py", line 264, in scan_json
    raise SyntaxError('Invalid initial JSON character: ' + c)
SyntaxError: Invalid initial JSON character: ?

Python 2.7.3
mysql Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using readline 6.2

i guess thats realy a python problem since i tried it with dbtype = sqlite3 and got the same result

Atheros

sr. member

Activity: 249

Merit: 251

I have upgrade my server to 64bit. I have abe running at http://abe.bitcoinstats.org:2750 for anyone who wants to demo it. I'll list it in the wiki.

John Tobey

hero member

Activity: 481

Merit: 529

Quote from: Eisenhower34 on August 23, 2012, 08:44:20 PM

Regarding your two small code examples posted above, I wrote an MySQL query to get the confirmations for each block. I only wanted to crosscheck with you if I understood everything right and didnt make a misstake here:

Code:

SELECT (
    (SELECT b.block_height AS maxheight
    FROM block b
    JOIN chain c ON c.chain_last_block_id = b.block_id
    WHERE c.chain_id = 1) - chain_candidate.block_height
) AS cofirmations, chain_candidate.block_id
FROM chain_candidate
WHERE chain_candidate.chain_id = 1
    AND chain_candidate.in_longest = 1

I think this is correct.

Eisenhower34

legendary

Activity: 906

Merit: 1002

Regarding your two small code examples posted above, I wrote an MySQL query to get the confirmations for each block. I only wanted to crosscheck with you if I understood everything right and didnt make a misstake here:

Code:

SELECT (
    (SELECT b.block_height AS maxheight
    FROM block b
    JOIN chain c ON c.chain_last_block_id = b.block_id
    WHERE c.chain_id = 1) - chain_candidate.block_height
) AS cofirmations, chain_candidate.block_id
FROM chain_candidate
WHERE chain_candidate.chain_id = 1
    AND chain_candidate.in_longest = 1

ErebusBat

hero member

Activity: 560

Merit: 500

I am the one who knocks

Quote from: mav on August 13, 2012, 01:28:10 AM

Quote from: John Tobey on August 07, 2012, 11:09:01 PM

By the way, I don't know if anyone has ever loaded the whole thing in SQLite. I'll be surprised if it works and more surprised if it takes under a month. I recommend MySQL or better for the BTC chain. And regardless of database, an initial run with --no-serve --commit-bytes=100000 will probably speed it up.

I ran for ... about 5 days trying to populate sqlite on my i5 laptop.

It got to block 187400ish so far and is more than 5GB.

To anyone else who is considering using sqlite, it's not a good solution compared to mysql or postgres. It's possible, but not good.

Took me about 7.5 days, then electrum server complained about not being 64bit, I haven't ad time to look into it past there.

mav

full member

Activity: 169

Merit: 107

Quote from: John Tobey on August 07, 2012, 11:09:01 PM

By the way, I don't know if anyone has ever loaded the whole thing in SQLite. I'll be surprised if it works and more surprised if it takes under a month. I recommend MySQL or better for the BTC chain. And regardless of database, an initial run with --no-serve --commit-bytes=100000 will probably speed it up.

I ran for ... about 5 days trying to populate sqlite on my i5 laptop.

It got to block 187400ish so far and is more than 5GB.

To anyone else who is considering using sqlite, it's not a good solution compared to mysql or postgres. It's possible, but not good.

Tittiez

hero member

Activity: 686

Merit: 500

Quote from: John Tobey on August 12, 2012, 07:41:29 AM

For you? Done! Please test.

I will when I get a chance, thanks!

John Tobey

hero member

Activity: 481

Merit: 529

Quote from: Tittiez on August 12, 2012, 12:27:32 AM

Is a /q/getdifficulty a possibility?

For you? Done! Please test.

Tittiez

hero member

Activity: 686

Merit: 500

Is a /q/getdifficulty a possibility?

ErebusBat

hero member

Activity: 560

Merit: 500

I am the one who knocks

Quote from: John Tobey on August 07, 2012, 11:09:01 PM

Quote from: mav on August 07, 2012, 10:41:58 PM

...
block_tx 2259 2289
commit
block_tx 2260 2290
commit
block_tx 2261 2291

By the way, I don't know if anyone has ever loaded the whole thing in SQLite. I'll be surprised if it works and more surprised if it takes under a month. I recommend MySQL or better for the BTC chain. And regardless of database, an initial run with --no-serve --commit-bytes=100000 will probably speed it up.

I have a pretty weak machine (512MB VPS) that takes several days to load BTC into Abe using PostgreSQL.

Initial loading tips would be welcomed... I am going on 6 days and still have 2658 blocks left to go.

John Tobey

hero member

Activity: 481

Merit: 529

Quote from: slush on August 08, 2012, 08:38:59 AM

Any chance to update PYPI, please?

A release? It's sure overripe for one. Noted.

slush

legendary

Activity: 1386

Merit: 1097

Any chance to update PYPI, please?

John Tobey

hero member

Activity: 481

Merit: 529

Quote from: mav on August 07, 2012, 10:41:58 PM

...
block_tx 2259 2289
commit
block_tx 2260 2290
commit
block_tx 2261 2291

By the way, I don't know if anyone has ever loaded the whole thing in SQLite. I'll be surprised if it works and more surprised if it takes under a month. I recommend MySQL or better for the BTC chain. And regardless of database, an initial run with --no-serve --commit-bytes=100000 will probably speed it up.

I have a pretty weak machine (512MB VPS) that takes several days to load BTC into Abe using PostgreSQL.

Topic: [ANNOUNCE] Abe 0.7: Open Source Block Explorer Knockoff - page 36. (Read 221044 times)