Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
as & | && || ^ etc. > > sqlite3 freenas-v1.db "UPDATE system_certificate SET > cert_certificate=readfile('fullchain.pem'), > cert_privatekey=readfile('privkey.pem') > WHERE ID=4;" > > > -Original Message----- > > From: sqlite-us

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
ll: (508) - 954 - 2536 EMail: jacob.syl...@gmail.com Web: http://www.jacobsylvia.com On Mon, Mar 6, 2017 at 7:39 PM, Richard Hipp wrote: > On 3/6/17, Jacob Sylvia wrote: > > > > How can I check if that support is compiled in? > > > > The readfile() SQL function was

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
7;s Consulting 430 Cole St. Seekonk, MA 02771 Cell: (508) - 954 - 2536 EMail: jacob.syl...@gmail.com Web: http://www.jacobsylvia.com On Mon, Mar 6, 2017 at 11:28 AM, Jacob Sylvia wrote: > Keith, thanks! I *think* this is exactly what I'm looking for. I will > try this as soon as I get

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
ble where key='pubkey'; > select writefile('privkey.bak', value) from table where key='privkey'; > > > This is documented in section 6.1 of the CLI page > https://www.sqlite.org/cli.html > > > > -Original Message- > > From: sqlite-users [

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
--- > 1 > asql> select * from test; > a > -- > a > b > c > d > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Jacob Sylvia > Gesendet: Montag, 06. März 2017 13

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
syntax fails. ~Jake -- Jacob D. Sylvia Jake Sylvia's Consulting 430 Cole St. Seekonk, MA 02771 Cell: (508) - 954 - 2536 EMail: jacob.syl...@gmail.com Web: http://www.jacobsylvia.com On Mar 6, 2017 6:28 AM, "Clemens Ladisch" wrote: > Jacob Sylvia wrote: > > Basically, I c

[sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
Howdy all! I'm working on getting letsencrypt certificates into my FreeNAS installation... I can't find anyone who can help me with the last piece, the sqlite command line piece... The reference post is here: https://forums.freenas.org/index.php?threads/letsencrypt-webgui-ssl-need-sqlite3-cli-gu