Keith, thanks! I *think* this is exactly what I'm looking for. I will try this as soon as I get home.
~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 Mon, Mar 6, 2017 at 9:18 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > If you have a recent enough version of the SQLite3 command line shell: > > sqlite3 config.db "update table set value=readfile('pubkey.pem') where > key='pubkey';" > sqlite3 config.db "update table set value=readfile('privkey.pem') where > key='privkey';" > > or, create a file, called for example, updatekeys.sql containing: > > update table set value=readfile('pubkey.pem') where key='pubkey'; > update table set value=readfile('privkey.pem') where key='privkey'; > > then run in with: > > sqlite3 config.db < updatekeys.sql > > If you want to copy the existing fields to files you can do something like > this: > > select writefile('pubkey.bak', value) from table 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 [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Jacob Sylvia > > Sent: Sunday, 5 March, 2017 17:39 > > To: sqlite-users@mailinglists.sqlite.org > > Subject: [sqlite] Need some help running sqlite3 command line > > > > 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-guru.50678/ > > > > Basically, I cant figure out how to update a text field in the sqlite > > config database from the command line... > > > > The FreeNAS Config file is a sqlite3 database, and the two certificate > > entries (the certificate and the private key) are stored in "TEXT" fields > > in a specific table. What I need to do, is take the text from the two > PEM > > certificate/key files, and, via the command line, update the > > appropriate fields... I can do "simple" fields, but I can't figure out > > how > > to do "TEXT" fields, given the fact that the text has line-breaks, etc. > > > > Any help would be greatly appreciated. > > > > Thanks!!! > > > > ~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 > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
