bitcoin core – View backed up wallet.dat using sqlite browser

I backed up my wallet.dat using the command as mentioned in the api ref:

bitcoin-cli -rpcport=18332 -rpcuser=user -rpcpassword=password backupwallet "/bitcoin/backup.dat"

I would like to view the backed-up db file using ‘DB browser for sqlite’ (or any other sqlite browser). However when opening the db file it prompts for the password / key to decrypt the wallet file.

Which password / key is it referring to? When creating the backup I didnt specify any password or key..

enter image description here

Update from Drupal 8.7.14 to 8.8/8.9 Core File module upload error

I updated drupal 8.7.14 to 8.8.
I have a problem with the File module.
When I upload a file, I get the error message “this value cannot be zero” (see picture).
The file is however present in the site/default/files folder.
I have already tested changing the permissions, I have no php errors in the logs, checked the /tmp folder, added a private folder, created a new content type with only the file field, I still have this error.
I also tested these patch : https://www.drupal.org/files/issues/2020-08-13/3098718-core.system_update_8804.truncate_path_alias_tables-69.patch, https://www.drupal.org/files/issues/2862702-3.patch with no results.
Have you ever had this scenario?
enter image description here

updating – How can I update without losing some folders/files from the core and vendor directories?

I recently saw in the status report that I have a security update. I have the version: 9-1.4. The update is at: 9-1.5.
I tried to manually update on a local development site and after the update I saw that php mailer is gone. That’s when I remembered that the vendor file had the php mailer library.
My question is when you do an update, how do you know what folders or files are in the folders: core, vendor?
I don’t think a person can remember if two months ago he installed a library I want to mention that php mailer was installed with: composer.

json rpc – How do you determine whether Bitcoin Core is synced fully or not from the RPC API?

I keep getting the wrong numbers returned daily in the beginning of the day because Bitcoin Core has not yet synced the blockchain from the computer being powered off during the night. So I need a way to determine if it’s been synced fully or not, so that I can avoid using the numbers until it has synced fully.

I’ve looked through https://bitcoincore.org/en/doc/0.21.0/ but can’t find anything such as “getsyncamount” or “isfullysynced”.

How is it done?

Compiling Bitcoin Core v0.10.0 on Ubuntu 20.04

I’m trying to compile Bitcoin Core v0.10.0 on Ubuntu 20.04, but then I get the following error:

rpcserver.cpp: In function ‘void StartRPCThreads()’:
rpcserver.cpp:594:77: error: no matching function for call to ‘boost::asio::ssl::context::context(boost::asio::io_service&, boost::asio::ssl::context_base::method)’
  594 |     rpc_ssl_context = new ssl::context(*rpc_io_service, ssl::context::sslv23);
      |                                                                             ^
In file included from /usr/include/boost/asio/ssl/context.hpp:757,
                 from /usr/include/boost/asio/ssl.hpp:18,
                 from rpcprotocol.h:16,
                 from rpcserver.h:10,
                 from rpcserver.cpp:6:
/usr/include/boost/asio/ssl/impl/context.ipp:371:1: note: candidate: ‘boost::asio::ssl::context::context(boost::asio::ssl::context&&)’
  371 | context::context(context&& other)
      | ^~~~~~~
/usr/include/boost/asio/ssl/impl/context.ipp:371:1: note:   candidate expects 1 argument, 2 provided
/usr/include/boost/asio/ssl/impl/context.ipp:63:1: note: candidate: ‘boost::asio::ssl::context::context(boost::asio::ssl::context_base::method)’
   63 | context::context(context::method m)
      | ^~~~~~~
/usr/include/boost/asio/ssl/impl/context.ipp:63:1: note:   candidate expects 1 argument, 2 provided
rpcserver.cpp:613:50: error: ‘class boost::asio::ssl::context’ has no member named ‘impl’
  613 |         SSL_CTX_set_cipher_list(rpc_ssl_context->impl(), strCiphers.c_str());
      |                                                  ^~~~
rpcserver.cpp: In instantiation of ‘void RPCListen(boost::shared_ptr >, boost::asio::ssl::context&, bool) (with Protocol = boost::asio::ip::tcp; SocketAcceptorService = boost::asio::executor)’:
rpcserver.cpp:673:58:   required from here
rpcserver.cpp:482:111: error: ‘class boost::asio::basic_socket_acceptor’ has no member named ‘get_io_service’
  482 |     boost::shared_ptr > conn(new AcceptedConnectionImpl(acceptor->get_io_service(), context, fUseSSL));
      |                                                                                                     ~~~~~~~~~~^~~~~~~~~~~~~~
In file included from primitives/block.h:9,
                 from chainparams.h:11,
                 from base58.h:17,
                 from rpcserver.cpp:8:
./primitives/transaction.h: In instantiation of ‘static _OI std::__copy_move::__copy_m(_II, _II, _OI) (with _II = const CTxOut*; _OI = CTxOut*)’:
/usr/include/c++/9/bits/stl_algobase.h:404:30:   required from ‘_OI std::__copy_move_a(_II, _II, _OI) (with bool _IsMove = false; _II = const CTxOut*; _OI = CTxOut*)’
/usr/include/c++/9/bits/stl_algobase.h:441:30:   required from ‘_OI std::__copy_move_a2(_II, _II, _OI) (with bool _IsMove = false; _II = __gnu_cxx::__normal_iterator >; _OI = __gnu_cxx::__normal_iterator >)’
/usr/include/c++/9/bits/stl_algobase.h:474:7:   required from ‘_OI std::copy(_II, _II, _OI) (with _II = __gnu_cxx::__normal_iterator >; _OI = __gnu_cxx::__normal_iterator >)’
/usr/include/c++/9/bits/vector.tcc:238:31:   required from ‘std::vector& std::vector::operator=(const std::vector&) (with _Tp = CTxOut; _Alloc = std::allocator)’
coins.h:90:19:   required from here
./primitives/transaction.h:103:7: warning: implicitly-declared ‘CScript& CScript::operator=(const CScript&)’ is deprecated (-Wdeprecated-copy)
  103 | class CTxOut
      |       ^~~~~~
In file included from ./primitives/transaction.h:10,
                 from primitives/block.h:9,
                 from chainparams.h:11,
                 from base58.h:17,
                 from rpcserver.cpp:8:
./script/script.h:365:5: note: because ‘CScript’ has user-provided ‘CScript::CScript(const CScript&)’
  365 |     CScript(const CScript& b) : std::vector(b.begin(), b.end()) { }
      |     ^~~~~~~
In file included from /usr/include/c++/9/algorithm:61,
                 from serialize.h:9,
                 from amount.h:9,
                 from rpcserver.h:9,
                 from rpcserver.cpp:6:
/usr/include/c++/9/bits/stl_algobase.h:342:18: note: synthesized method ‘CTxOut& CTxOut::operator=(const CTxOut&)’ first required here
  342 |        *__result = *__first;
      |        ~~~~~~~~~~^~~~~~~~~~
In file included from chain.h:11,
                 from main.h:14,
                 from rpcserver.cpp:10:
tinyformat.h: In static member function ‘static const char* tinyformat::detail::FormatIterator::streamStateFromFormat(std::ostream&, unsigned int&, const char*, int, int)’:
tinyformat.h:785:21: warning: this statement may fall through (-Wimplicit-fallthrough=)
  785 |             out.setf(std::ios::uppercase);
      |             ~~~~~~~~^~~~~~~~~~~~~~~~~~~~~
tinyformat.h:786:9: note: here
  786 |         case 'x': case 'p':
      |         ^~~~
tinyformat.h:791:21: warning: this statement may fall through (-Wimplicit-fallthrough=)
  791 |             out.setf(std::ios::uppercase);
      |             ~~~~~~~~^~~~~~~~~~~~~~~~~~~~~
tinyformat.h:792:9: note: here
  792 |         case 'e':
      |         ^~~~
tinyformat.h:797:21: warning: this statement may fall through (-Wimplicit-fallthrough=)
  797 |             out.setf(std::ios::uppercase);
      |             ~~~~~~~~^~~~~~~~~~~~~~~~~~~~~
tinyformat.h:798:9: note: here
  798 |         case 'f':
      |         ^~~~
tinyformat.h:802:21: warning: this statement may fall through (-Wimplicit-fallthrough=)
  802 |             out.setf(std::ios::uppercase);
      |             ~~~~~~~~^~~~~~~~~~~~~~~~~~~~~
tinyformat.h:803:9: note: here
  803 |         case 'g':
      |         ^~~~
make(2): *** (Makefile:3910: libbitcoin_server_a-rpcserver.o) Error 1
make(2): Leaving directory '/usr/local/src/bitcoin-0.10.0/src'
make(1): *** (Makefile:6475: all-recursive) Error 1
make(1): Leaving directory '/usr/local/src/bitcoin-0.10.0/src'
make: *** (Makefile:569: all-recursive) Error 1

I followed the instructions on the build-unix.md file, and I believe the problem is related to the required dependencies, especially the libboost-all-dev package. Interestingly, I was able to compile every released version from v0.20.1 to 0.16.0, but nothing older than that, using the same instructions on build-unix.md. If the problem really is libboost-all-dev , how can I solve it?

Update:

I’ve installed boost version 1.57 as Pieter suggested with:

tar --bzip2 -xf /path/to/boost_1_57_0.tar.bz2
cd boost_1_57_0/
./bootstrap.sh --prefix=/usr/
./b2
sudo ./b2 install

And then, on the bitcoin root, used:

./configure --with-boost-liddir=LIB_DIR

But as result I got:

configure: error: Could not find a version of the boost_system library!

And I’ve tried different paths but always got the same result. Is this just path problem or is there something else?

Update 2:

Apparently I fixed the path with:

./configure --with-boost-libdir=/usr/lib/

But when I run make I got this error.

What is the problem?

bitcoin core – What algorithm do miners (mining pools) use the generate different blocks as they exhaust the nonce values

As I understand it, the building of a block goes something like this (please correct):

  1. Collect a bunch of new transactions.
  2. Hash all those transactions.
  3. Generate a coinbase transaction using the miner’s (mining pool) public address.
  4. Generate the Merkle root for all the transactions using an arbitrary order.
  5. Fill in the block header.
  6. Dispatch to mining hardware which will try all 2^32 nonce combinations.

Now, when the mining hardware says that there is no solution after trying all nonce combinations, it appears that it has the following options for generating new options to check:

  • Gather new transactions (or drop transactions), hash, and recalculate the Markle root.
  • Update the script (extranonce) field in the coinbase transaction (or the target address), hash, recalculate the Merkle root.
  • Update the timestamp in the header (what is the granularity on the timestamp).
  • Update the difficulty in the header (is this possible)??
  • Rearrange transaction order, and recalculate the Merkle root.

Are there any options I missed. What is the typical order that the mining pools do these things?

Thanks

bitcoin core – Classifying Miners based on their Location

Is there any way to classify the bitcoin miners based on their geographical locations?

According to this answer it’s not possible to check IP address of miners: https://bitcoin.stackexchange.com/a/66269

Even if it is possible with a workaround, they can use Tor, VPN, other proxy etc.

Non-KYC mining pools exist so miners do not share their real identity and location with pools. Even if they share such information, it can be faked and not necessary they have all the ASICs at one location.

Lot of journalists and researchers use other information and assumptions to speculate miners location. Example: https://coinshares.com/assets/resources/Research/bitcoin-mining-network-december-2019.pdf

updating – How can I update drupal without losing some folders / files from: Core, Vendor?

I recently saw in the status report that I have a security update. I have the version: 9-1.4. The update is at: 9-1.5.
I tried to manually update on a local development site and after the update I saw that php mailer is gone. That’s when I remembered that the vendor file had the php mailer library.
My question is when you do an update, how do you know what folders or files are in the folders: core, vendor?
I don’t think a person can remember if two months ago he installed a library I want to mention that php mailer was installed with: composer.

bitcoin core – How do I use bitcoind to spend from private key but not store it

I understand that I need to import a private key in order to spend bitcoins, would it be possible to generate/use an address without storing or the server having the private keys in the server

Ive seen many crypto wallets claim to do this but how would I go about this process

Thank you!

sorting – Default files sort order used by “dir” command / core Windows 10

tl;dr I cannot replicate sort order used by dir command in Windows 10, neither within File Explorer nor Total Commander. I have tried to change sort order based on many different columns and still nothing. Thus, I am wondering how files listed by dir command are ordered by default? And how can I change it?


I have noticed that my MP3 player plays music in a “weird” order. To investigate this I have:

  • mounted SD card under my Windows 10,
  • run cmd as an administrator,
  • navigated to SD card root,
  • executed dir command.

I have received following output:

 Volume in drive D has no label.
 Volume Serial Number is 36BA-963E

 Directory of D:

05.06.2018  23:00       159ÿ280ÿ594 02. Stream.mp3
15.10.2019  20:18       144ÿ000ÿ738 05. Campfire.mp3
11.02.2020  23:32       134ÿ040ÿ469 07. Piano Soft.mp3
11.02.2020  17:32       153ÿ195ÿ986 10. Flutes.mp3
16.09.2019  05:09       171ÿ600ÿ882 11. Tibetan.mp3
11.02.2020  08:13       115ÿ326ÿ973 13. Train.mp3
20.10.2018  22:16       159ÿ280ÿ281 01. Birds.mp3
05.06.2018  23:00       161ÿ086ÿ282 03. Sea.mp3
05.06.2018  23:00       161ÿ247ÿ510 04. Rain.mp3
05.06.2018  23:00       159ÿ280ÿ596 06. Cave.mp3
11.12.2019  17:57       131ÿ792ÿ464 12. Meditation.mp3
10.02.2020  19:42       142ÿ827ÿ986 08. Piano Water.mp3
10.02.2020  21:57       159ÿ780ÿ933 09. Jazz.mp3
              14 File(s)  1ÿ952ÿ741ÿ728 bytes
               0 Dir(s)   5ÿ819ÿ006ÿ976 bytes free

As you can see — files are not sorted by filename. By changing sort order through many columns I was not able to replicate above sort order. I tried:

  • file name,
  • file extension,
  • file size,
  • date created,
  • date modified and
  • date last saved.

All for nothing.

Can someone guide me, what is the default sort order as used by dir command?

And even more important — how to change it (since my MP3 player plays files in exactly the same “weird” order)? By “change it” I mean, which property of each file (i.e. maybe some date) I should modify in order to have sort order reported by dir command as close to alphabetical one as possible?