--- Log opened Wed Jan 08 00:00:01 2020
00:06 -!- paultroon [~paultroon@h-5-150-248-150.NA.cust.bahnhof.se] has joined #c-lightning
01:37 -!- vasild [~vd@gateway/tor-sasl/vasild] has joined #c-lightning
01:40 -!- vasild_ [~vd@gateway/tor-sasl/vasild] has quit [Ping timeout: 240 seconds]
02:14 -!- paultroon [~paultroon@h-5-150-248-150.NA.cust.bahnhof.se] has quit [Ping timeout: 258 seconds]
02:18 -!- paultroon [~paultroon@185.128.24.51] has joined #c-lightning
02:25 < k3tan> darosior, i'm looking at your lightning-qt plugin. i generally use a config file to add my plugins into, and i use a service file to start run in background. `lightning-cli gui` produces no result, but if i run lightningd in terminal, it pops up fine. any ideas?
02:40 < darosior> k3tan: about the backup, the hsm_secret (which can be encrypted) and the database are crucial. But restoring from backed up database is discouraged
02:40 < darosior> About ln-qt: is it registered ?
02:41 < darosior> Also you don't need to put them into the config file, all plugins in /path/to/lightning-dir/<network>/plugins will be started
02:42 < darosior> You can list registered plugins with `lightning-cli plugin list`
02:42 < darosior> You can also start ln-qt after startup like `plugin start /path/to/lightning-qt.py`
02:43 < darosior> Btw I've not updated it really for some time now, so if you find quirks or possible enhancement feel free to post an issue here https://github.com/darosior/lightning-qt/issues
02:52 -!- belcher [~belcher@unaffiliated/belcher] has joined #c-lightning
02:53 < k3tan> thanks darosior, appreciate the response. can you define database? is that sqlite.db or lightningd.sqlite3?
02:53 < k3tan> or both?
02:55 -!- jonatack [~jon@2a01:e0a:53c:a200:bb54:3be5:c3d0:9ce5] has quit [Ping timeout: 260 seconds]
02:58 < darosior> Hmmm has the sqlite.db been created by lightningd ? If yes do you use a custom config for the db (like postgres setup)? I was talking about lightningd.sqlite3
02:58 < k3tan> nah no custom config
02:59 < k3tan> admittedly, this sqlite.db looks new, could be from v0.8.0?
03:22 -!- CubicEarth [~CubicEart@c-67-168-1-172.hsd1.wa.comcast.net] has quit [Read error: Connection reset by peer]
03:23 -!- CubicEarth [~CubicEart@c-67-168-1-172.hsd1.wa.comcast.net] has joined #c-lightning
03:44 < darosior> Maybe, I'm no db expert maybe cdecker can put some light on this ^^
03:45 < darosior> But I've never seen this file and I can't reproduce it either on master
03:46 < darosior> k3tan what about lightning-qt ?
03:51 < k3tan> i'll keep at it, whenever i run it as service file it doesn't pop up
03:51 < k3tan> im just exploring the plugins and seeing what they can do
03:58 < darosior> k3tan is ligthning-qt shown when you run `lightning-cli plugin list` ?
03:58 < darosior> the way lightningd is started shouldnt matter
03:59 < k3tan> when i type `lightning-cli gui` it just hangs
04:00 < k3tan> but if i have lightningd running in a terminal
04:00 < k3tan> lightning-cli gui works
04:18 -!- jonatack [~jon@213.152.162.94] has joined #c-lightning
04:45 < darosior> Hmm could you post an issue along with any traceback in your debug.log on https://github.com/darosior/lightning-qt/issues ?
06:09 < cdecker> fwiw we don't create sqlite.db, that might have been a plugin. Maybe the schema can give us a clue?
06:22 -!- paultroo_ [~paultroon@h-5-150-248-150.NA.cust.bahnhof.se] has joined #c-lightning
06:23 -!- paultroon [~paultroon@185.128.24.51] has quit [Read error: Connection reset by peer]
06:28 -!- Victor_sueca is now known as Victorsueca
06:42 -!- jonatack [~jon@213.152.162.94] has quit [Ping timeout: 268 seconds]
06:43 -!- jonatack [~jon@109.202.107.147] has joined #c-lightning
06:57 < vasild> k3tan: what does this print: echo '.tables' |sqlite3 sqlite.db
07:27 -!- jonatack [~jon@109.202.107.147] has quit [Ping timeout: 260 seconds]
07:42 -!- mdunnio [~mdunnio@38.126.31.226] has joined #c-lightning
07:45 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-zkjjaoqsjfattawp] has left #c-lightning []
07:45 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-zkjjaoqsjfattawp] has joined #c-lightning
08:02 < ctrlbreak> *sigh*... so, I'm trying to fix up my nodes.  I've upgraded the underlying OS and brought bitcoind up to current.  Turning my focus to CL now and I'm presented with: lightningd: SQLITE version mismatch: compiled 3011000, now 3022000
08:03 < ctrlbreak> Anyone gracious enough to tell me what's happened here now and how to proceed? :-/
08:05 < darosior> Looks like your database was created with a newer `lightningd` that you have now
08:06 < ctrlbreak> That's not possible as far as I can tell..
08:06 < ctrlbreak> Only thing I've done is upgrade underlying Ubuntu to 18.0.4.3 and bitcoind to 0.19.0.1
08:07 < darosior> What `lightningd` version are you running ?
08:08 < ctrlbreak> I can't even check to confirm... 
08:08 < ctrlbreak> bitcoin@cLightning:~/lightning/lightningd$ ./lightningd --version
08:08 < ctrlbreak> lightningd: SQLITE version mismatch: compiled 3011000, now 3022000
08:09 < ctrlbreak> based on file timestamps... looks like I last compiled Aug 30?
08:10 < ctrlbreak> bitcoin@cLightning:~/lightning/cli$ ./lightning-cli --version
08:10 < ctrlbreak> v0.7.2.1-56-g49496ab
08:10 < darosior> ah ^^
08:11 -!- sword_smith [sword_smit@bitcoinfundamentals.org] has joined #c-lightning
08:11 < ctrlbreak> I had hoped to confirm that CL still functioned, and then proceed with upgrading it as well...
08:11 < ctrlbreak> confused as to why it thinks anything with CL has changed?
08:11 < darosior> hmm can you try to recompile last version ? `git clone https://github.com/ElementsProject/lightning/ && cd lightning make clean && make disclean && ./configure && make -j $(nproc)`
08:11 < darosior> git clone https://github.com/ElementsProject/lightning/ && cd lightning && make clean && make disclean && ./configure && make -j $(nproc) && su -c 'make install'
08:12 < ctrlbreak> What's the likelihood of this breaking things... 
08:12 < darosior> Hmm updating to last version should not break you
08:12 < ctrlbreak> full disclosure... before starting this node 'maintenance'... I shutdown CL, bitcoind, and the OS and took a snapshot.
08:12 < darosior> It's even a better idea to update than to keep running this version
08:13 < ctrlbreak> as I have a not insignificant amount of coin in about 45 channels atm.
08:13 < ctrlbreak> okay.  I'm going to shutdown bitcoind and the OS here... and take another snapshot.
08:14 < ctrlbreak> I also have an appointment and have to step out... but I'll come back and try compiling latest CL after that.
08:15 < darosior> Okay, maybe raising an issue is a good idea too. But this is a common behavior solved by upgrading
08:16 < ctrlbreak> I mean... I fully acknowledge that I upgraded the OS and bitcoind.... I just didn't expect CL to... even really notice?  I guess I just don't fully comprehend.  Now nervous.
08:16 < ctrlbreak> bbiab.  Thanks for the assist.
08:26 -!- jonatack [~jon@2a01:e0a:53c:a200:bb54:3be5:c3d0:9ce5] has joined #c-lightning
08:35 < cdecker> ctrlbreak: the issue is that we rely on the OSs version of the sqlite3 library (which got upgraded along with your OS). For safety we refuse to start with anything but the sqlite3 version that we were compiled with. thugh it'd likely be ok in this case 
08:35 < cdecker> It's just us being a bit too pedantic when it comes to versions of dependencies
08:36 < cdecker> The database file itself is not at fault here, c-lightning just refuses to start and even look at the file if the versions of the library don't match ;-)
08:37 < darosior> Ah ! So I was wrong thanks for correcting.
08:54 < vasild> ctrlbreak: so even recompiling your existent ancient (v0.7.2.1-56-g49496ab) c-lightning will fix it because it will re-link with the upgraded system sqlite library. But its always better to upgrade to the latest one (0.8.0).
09:41 -!- paultroo_ [~paultroon@h-5-150-248-150.NA.cust.bahnhof.se] has quit [Remote host closed the connection]
09:53 -!- paultroon [~paultroon@h-5-150-248-150.NA.cust.bahnhof.se] has joined #c-lightning
09:57 -!- michaelfolkson [~textual@2a00:23c5:be04:e501:d831:3541:1e0f:d67e] has joined #c-lightning
10:09 -!- paultroon [~paultroon@h-5-150-248-150.NA.cust.bahnhof.se] has quit []
10:35 < k3tan> vasild, here's the output on sqlite.db
10:35 < k3tan> invoice               knex_migrations     invoice_webhook       knex_migrations_lock
10:56 < ctrlbreak> Sweet!  Makes sense, and thanks for the clarity, cdecker et al. :-)
10:58 < vasild> k3tan: that is probably from some additionally installed plugin, what is knex?
10:59 < vasild> k3tan: remove sqlite.db and see what will break :-D
11:23 < k3tan> haha yeah probably some plugin
11:23 < k3tan> no idea what it was though
11:24 < k3tan> went on a bit of a 'lets see whats happening in the world of lightningd plugins' spree
11:25 < ctrlbreak> Ummm... it normal for this version to move previous configuration files and whatnot?
11:25 < ctrlbreak> bitcoin@cLightning:~/lightning/lightningd$ ./lightningd
11:25 < ctrlbreak> 2020-01-08T19:22:57.505Z UNUSUAL lightningd: Creating configuration directory /home/bitcoin/.lightning/bitcoin
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving gossip_store into /home/bitcoin/.lightning/bitcoin/
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving debug.log.1 into /home/bitcoin/.lightning/bitcoin/
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving lightning-rpc into /home/bitcoin/.lightning/bitcoin/
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving hsm_secret into /home/bitcoin/.lightning/bitcoin/
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving info.log into /home/bitcoin/.lightning/bitcoin/
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving lightningd.sqlite3 into /home/bitcoin/.lightning/bitcoin/
11:25 < ctrlbreak> 2020-01-08T19:22:57.506Z UNUSUAL lightningd: Moving debug.log into /home/bitcoin/.lightning/bitcoin/
11:27 < ctrlbreak> Hmmm.... things *seem* okay.
11:29 < k3tan> yeah, i believe thats one of the changes in v0.8.0 ctrlbreak - everything moves to a new directory.
11:30 < ctrlbreak> Kk... I'll have to re-jigger some of my config then to match :-)
11:55 < cdecker> Yep, that was the one breaking change in 0.8.0, but we wanted it now, since more and more people start relying on the location, so now was the least painful time to migrate :-)
12:55 -!- DeanGuss [~dean@gateway/tor-sasl/deanguss] has quit [Remote host closed the connection]
12:55 < ctrlbreak> totally fair.  Already fixed up.
12:56 -!- kristapsk [~KK@gateway/tor-sasl/kristapsk] has quit [Remote host closed the connection]
13:00 < ctrlbreak> Anyone happen to have created a systemd service definition for lightningd?
13:01 < ctrlbreak> hmmm... looks like Stadicus made something.
13:24 -!- kristapsk [~KK@gateway/tor-sasl/kristapsk] has joined #c-lightning
13:30 <@niftynei> there's one in contrib/
13:31 <@niftynei> ctrlbreak, https://github.com/ElementsProject/lightning/blob/master/contrib/init/lightningd.service
13:34 <@niftynei> i believe it's set up to work nicely with the one in bitcoind https://github.com/bitcoin/bitcoin/blob/master/contrib/init/bitcoind.service
13:37 -!- vasild_ [~vd@gateway/tor-sasl/vasild] has joined #c-lightning
13:40 -!- vasild [~vd@gateway/tor-sasl/vasild] has quit [Ping timeout: 240 seconds]
13:48 < ctrlbreak> sweet... thanks! 
13:49 < ctrlbreak> I'm currently sad that I apparently can't use the following in a unit file :-(
13:49 < ctrlbreak> --announce-addr=`curl -s icanhazip.com` --daemon
13:54 -!- michaelfolkson [~textual@2a00:23c5:be04:e501:d831:3541:1e0f:d67e] has quit [Ping timeout: 252 seconds]
15:16 < sword_smith> I made this pull request which has been approved. But it hasn't been merged yet: https://github.com/lightningnetwork/lightning-rfc/pull/700
15:22 < sword_smith> Sorry. Wrong channel.
15:34 < ctrlbreak> dear lord that took me entirely too long :-( 
15:34 < ctrlbreak> sed -i "s@announce-addr=\([0-9]\{1,3\}.[0-9]\{1,3\}.[0-9]\{1,3\}.[0-9]\{1,3\}\)@announce-addr=`curl -s icanhazip.com`@" config
15:40 < k3tan> ctrl - maybe announce through Tor instead?
15:40 -!- mdunnio [~mdunnio@38.126.31.226] has quit [Remote host closed the connection]
15:45 < ctrlbreak> k3tan:  I intend on also spinning up a tor node.  Still not afraid/opposed to advertising my node on clearnet... at least for the time being.
15:45 < ctrlbreak> moving these nodes to a more isolated and locked down DMZ was part of my chores for today as well :-/
15:46 < ctrlbreak> Also... looks like I can incorporate with the contributed systemd unit file with: 
15:46 < ctrlbreak> [Service]
15:46 < ctrlbreak> ExecStartPre=/home/bitcoin/.lightning/updatepubip.sh
15:47 < ctrlbreak> I noticed that there are now directives for a 'Tor specific proxy' for lightningd.  Is that recent, or have I just not noticed?
16:01 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-zkjjaoqsjfattawp] has left #c-lightning []
16:01 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-zkjjaoqsjfattawp] has joined #c-lightning
17:50 < ctrlbreak> *sigh*... anyone else here running ElectrumX?  Since attempting to switch to systemd for service control, it won't listen on anything other than localhost.
17:55 < ctrlbreak> ... nevermind.  
17:55 < ctrlbreak> HOST = 0.0.0.0 isn't documented for their .conf file apparently.
18:18 -!- jonatack [~jon@2a01:e0a:53c:a200:bb54:3be5:c3d0:9ce5] has quit [Ping timeout: 252 seconds]
18:26 -!- k3tan [k3tan@gateway/vpn/protonvpn/k3tan] has quit [Remote host closed the connection]
18:29 -!- DeanGuss [~dean@gateway/tor-sasl/deanguss] has joined #c-lightning
18:30 -!- ysangkok [janus@anubis.0x90.dk] has joined #c-lightning
18:31 < ysangkok> i don't understand this error message
18:31 < ysangkok> aborted opening negotiation: channel capacity with funding 10000000sat, reserves 1000sat/100000sat, max_htlc_value_in_flight_msat is 5000msat, channel capacity is 5sat, which is below 8908000msat
18:31 < ysangkok> why is the channel capacity 5sat? where does that come from?
18:31 < ysangkok> (this is regtest)
18:48 -!- k3tan [k3tan@gateway/vpn/protonvpn/k3tan] has joined #c-lightning
19:10 -!- queip [~queip@unaffiliated/rezurus] has quit [Read error: Connection reset by peer]
19:15 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning
20:15 <@niftynei> is anybody else watching testnet zoom along right now
20:15 <@niftynei> there's new blocks poppin out every few seconds right now lol https://blockstream.info/testnet/
20:41 < ysangkok> niftynei: happens regularly: https://testnet.smartbit.com.au/charts/block-interval
23:47 -!- jonatack [~jon@2a01:e0a:53c:a200:bb54:3be5:c3d0:9ce5] has joined #c-lightning
--- Log closed Thu Jan 09 00:00:03 2020