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
