phpMyAdmin

I've been tempted to run own ElectrumX server for quite some. First attempt was to run this on Turris Omnia router, however that turned out to be impossible due to memory requirements both Bitcoind and ElectrumX have. This time I've dedicated host ... [More] for this and it runs fine: The server runs Debian sid (probably it would be doable on stretch as well, but I didn't try much) and the setup was pretty simple. First we need to install some things - Bitcoin daemon and ElectrumX dependencies: # Bitcoin daemon, not available in stretch apt install bitcoind # We will checkout ElectrumX from git apt install git # ElectrumX deps apt install python3-aiohttp # Build environment for ElectrumX deps apt install build-essentials python3-pip libleveldb-dev # ElectrumX deps not packaged in Debian pip3 install plyvel pylru # Download ElectrumX sources su - electrumx -c 'git clone https://github.com/kyuupichan/electrumx.git' Create users which will run the services: adduser bitcoind adduser electrumx Now it's time to prepare configuration for the services. For Bitcoin it's quite simple - we need to configure RPC interface and enable transaction index in /home/bitcoind/.bitcoin/bitcoin.conf: txindex=1 listen=1 rpcuser=bitcoin rpcpassword=somerandompassword The ElectrumX configuration is quite simple as well and it's pretty well documented. I've decided to place it in /etc/electrumx.conf: COIN=BitcoinSegwit DB_DIRECTORY=/home/electrumx/.electrumx DAEMON_URL=http://bitcoin:somerandompassword@localhost:8332/ TCP_PORT=50001 SSL_PORT=50002 HOST=:: DONATION_ADDRESS=3KPccmPtejpMczeog7dcFdqX4oTebYZ3tF SSL_CERTFILE=/etc/letsencrypt/live/btc.cihar.com/fullchain.pem SSL_KEYFILE=/etc/letsencrypt/live/btc.cihar.com/privkey.pem REPORT_HOST=btc.cihar.com BANNER_FILE=banner I've decided to control both services using systemd, so it's matter of creating pretty simple units for that. Actually the Bitcoin one closely matches the one I've used on Turris Omnia and the ElectrumX the one they ship, but there are some minor changes. Systemd unit for ElectrumX in /etc/systemd/system/electrumx.service: [Unit] Description=Electrumx After=bitcoind.target [Service] EnvironmentFile=/etc/electrumx.conf ExecStart=/home/electrumx/electrumx/electrumx_server.py User=electrumx LimitNOFILE=8192 TimeoutStopSec=30min [Install] WantedBy=multi-user.target And finally systemd unit for Bitcoin daemon in /etc/systemd/system/bitcoind.service: [Unit] Description=Bitcoind After=network.target [Service] ExecStart=/usr/bin/bitcoind User=bitcoind TimeoutStopSec=30min Restart=on-failure RestartSec=30 [Install] WantedBy=multi-user.target Now everything should be configured and it's time to start up the services: # Enable services so that they start on boot systemctl enable electrumx.service bitcoind.service # Start services systemctl start electrumx.service bitcoind.service Now you have few days time until Bitcoin fetches whole blockchain and ElectrumX indexes that. If you happen to have another Bitcoin node running (or was running in past), you can speedup the process by copying blocks from that system (located in ~/.bitcoin/blocks/). Only get blocks from sources you trust absolutely as it might change your view of history, see Bitcoin wiki for more information on the topic. There is also magnet link in the ElectrumX docs to download ElectrumX database to speed up this process. This should be safe to download from untrusted source. The last think I'd like to mention is resources usage. You should have at least 4 GB of memory to run this, 8 GB is really preferred (both services consume around 4GB). On disk space, Bitcoin currently consumes 170 GB and ElectrumX 25 GB. Ideally all this should be running on the SSD disk. You can however offload some of the files to slower storage as old blocks are rarely accessed and this can save some space on your storage. Following script will move around 50 GB of blockchain data to /mnt/btc/blocks (use only when Bitcoin daemon is not running): 1 2 3 4 5 6 7 8 9 10 11#!/bin/sh set -e DEST=/mnt/btc/blocks cd ~/.bitcoin/blocks/ find . -type f \( -name 'blk00[0123]*.dat' -o -name 'rev00[0123]*dat' \) | sed 's@^\./@@' | while read name ; do mv $name $DEST/$name ln -s $DEST/$name $name done Anyway if you would like to use this server, configure btc.cihar.com in your Electrum client. If you find this howto useful, you can send some Satoshis to 3KPccmPtejpMczeog7dcFdqX4oTebYZ3tF. Filed under: Crypto Debian English [Less]

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long, so it's time to process it and include new project. This time, the newly hosted projects include: Mind Map Architect - Program for ... [More] manipulating with mind maps Simple Weather - a weather app for Android FeedReader - a RSS reader for GNOME CityZen - the companion app to navigate the city Debian Installer - the Debian Installer Zotero Better BibTeX - better Bib(La)TeX for Zotero/Juris-M If you want to support this effort, please donate to Weblate, especially recurring donations are welcome to make this service alive. You can do that easily on Liberapay or Bountysource. Filed under: Debian English SUSE Weblate [Less]

Last week was pretty calm, with some minor fixes in the SQL parser and several merged pull requests. Handled issues: #13802 Use PSR-1 for PHPUnit TestCase #181 Use PSR-1 for PHPUnit TestCase #182 creating table in query #22 Use PSR-1 for PHPUnit ... [More] TestCase #20 Use PSR-1 for PHPUnit TestCase #1 Use PSR-1 for PHPUnit TestCase Filed under: English phpMyAdmin [Less]

Last week I refactored several methods that contained HTML code to use the template system, replaced global variables with dependency injection in some classes and fixed a few minor bugs. Issues: #13809 Errors in database designer #13806 Visualize ... [More] GIS broken #13786 Better rendering of icons in modern browsers #13744 Unable to get html views for … Continue reading "Weekly phpMyAdmin contributions 2017-W45" The post Weekly phpMyAdmin contributions 2017-W45 appeared first on mauriciofauth.com. [Less]

Most of last week was spent on bringing U2F and 2FA to phpMyAdmin. Besides that it was really just minor bug fixing. We've had one pull request for the 2FA already open, however it was not really in quality to be merged and the original author really ... [More] didn't come back to address our concerns. I was thinking to start over from his work, but in the end I've decided to start from scratch and come with code which will make easier to implement additional second authentication factors in the future. Anyway what is now there is support for HOTP/TOTP authentication (Google Authenticator and similar) and FIDO U2F hardware tokens. The latter has been tested with TREZOR, but should work with any compliant device. Handled issues: #13344 Correct location information for locales from Twig templates #13787 Second authentication factor #6197 Enhance security by adding support for 2-factor-authentication via Google Authenticator #13517 Select only visible / filtered results #13781 Delete filtered databases deletes ALL databses ! #13783 Error message on the User accounts page #13784 Many messages shown on database privilege page. #13777 Removing inline CSS Filed under: Crypto English phpMyAdmin [Less]

Last week I fixed a few bugs in some templates, moved to templates HTML code in PHP files and replaced the globals of some classes with dependency injection. Issues: #13789 User account page sub-level tabs don’t work #13796 Creating table or adding ... [More] fields broken The post Weekly phpMyAdmin contributions 2017-W44 appeared first on mauriciofauth.com. [Less]

Last week I completed the process of converting the templates to the Twig format and also removed the support for PHP templates. Issues: #13772 Null byte in regex #13785 Port templates to Twig and remove PHP templates support #13297 Port templates to ... [More] Twig and remove PHP templates support The post Weekly phpMyAdmin contributions 2017-W43 appeared first on mauriciofauth.com. [Less]

Last week was mostly focused on code cleanup. I've done quite some fixups in the database interface layer, which now has easier to use API and no more relies on global variables to store database links. Pretty much similar was done in the ... [More] authentication layer, where many of the methods had names coming from historical reasons rather than their current functionality. Handled issues: #13776 Cannot add decimal #13774 Symbol "\" lost in the code editor. #13770 Database interface cleanups #13771 Scrutinizer Auto-Fixes #13764 Authentication API cleanup Filed under: English phpMyAdmin [Less]

Last week I focused on converting templates to Twig format. I also added the JavaScript dependencies to the package.json file and updated some JavaScript libraries. Issues: #13754 Port some templates to Twig format #13759 Port some templates to Twig ... [More] format #13763 Add JavaScript dependencies to package.json #13766 removed inline css in index.inc.php #13767 Removed inline … Continue reading "Weekly phpMyAdmin contributions 2017-W42" The post Weekly phpMyAdmin contributions 2017-W42 appeared first on mauriciofauth.com. [Less]

Last week was mostly focused on refactoring and code cleanup. This time I've worked on authentication plugins, which now fully handle authentication (previously it was partly done in the mighty common.inc.php). Handled issues: #13762 Redirecting ... [More] issue on changelog.php #13758 single-sign-on: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given #12965 Fatal error when working with bookmarked queries in a different database #13761 Bookmark::getList function has a logical bug in the query conditions #13746 Add word wrap in export option heading-2 (H2) #13760 config.inc.php add more server,host not current #13755 RFC: Create CODE_OF_CONDUCT.md #13748 Table name hides column descriptions when creating table #13749 Fix for table names being obscured when changing table structure #13745 In mobile Export page is not responsive #13729 Differentiate between no default and empty string default. #137 Add app.json #177 wrong error row number Filed under: English phpMyAdmin [Less]