<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><head><!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1477604817208_4519">Hi Bob,</div><div id="yui_3_16_0_ym19_1_1477604817208_4520"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1477604817208_4554"><span id="yui_3_16_0_ym19_1_1477604817208_4524">Yes, take a look to msencrypt utility: <a href="http://mapserver.org/utilities/msencrypt.html" class="enhancr2_cb8f07bf-efab-4062-dc5f-e83493561147" id="yui_3_16_0_ym19_1_1477604817208_4552">msencrypt — MapServer 7.0.2 documentation</a></span></div><div id="yui_3_16_0_ym19_1_1477604817208_4715"><br></div><div id="enhancr2_cb8f07bf-efab-4062-dc5f-e83493561147" class="yahoo-link-enhancr-card yahoo-link-enhancr-not-allow-cover ymail-preserve-class ymail-preserve-style" style="max-width:400px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;" data-url="http://mapserver.org/utilities/msencrypt.html" data-type="yenhancr" data-category="article" data-embed-url="" data-size="medium" dir="ltr" contenteditable="false"> <a href="http://mapserver.org/utilities/msencrypt.html" style="text-decoration:none !important; color: #000 !important" class="yahoo-enhancr-cardlink" target="_blank" rel="noreferrer" id="yui_3_16_0_ym19_1_1477604817208_4724"> <table class="card-wrapper" style="max-width:400px;" id="yui_3_16_0_ym19_1_1477604817208_4723" cellspacing="0" cellpadding="0" border="0"> <tbody id="yui_3_16_0_ym19_1_1477604817208_4722"><tr id="yui_3_16_0_ym19_1_1477604817208_4721"> <td id="yui_3_16_0_ym19_1_1477604817208_4720" width="400"> <table class="card-info" style="background:#fff;max-width:400px;border:1px solid #e0e4e9;border-bottom:3px solid #000000;" id="yui_3_16_0_ym19_1_1477604817208_4719" width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody id="yui_3_16_0_ym19_1_1477604817208_4718"><tr id="yui_3_16_0_ym19_1_1477604817208_4717"> <td style="vertical-align:top;padding:16px 0 16px 12px;"> </td> <td style="vertical-align:middle;padding:16px 12px;width:99%;" id="yui_3_16_0_ym19_1_1477604817208_4716"> <h2 class="card-title" style="margin:0 0 4px 0;font-size:16px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;word-break:break-word;">msencrypt — MapServer 7.0.2 documentation</h2> <div class="card-description" style="font-size:11px;line-height:15px;color:#999;word-break:break-word;"></div> </td> <td class="card-share-container"></td> </tr> </tbody></table> </td> </tr> </tbody></table> </a></div><div id="yui_3_16_0_ym19_1_1477604817208_4790"><br></div><div id="yui_3_16_0_ym19_1_1477604817208_4517"><div id="yui_3_16_0_ym19_1_1477604817208_4791">Best regards</div></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1477604817208_4431"><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1477604817208_4416" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;" id="yui_3_16_0_ym19_1_1477604817208_4415"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1477604817208_4414"> <div dir="ltr" id="yui_3_16_0_ym19_1_1477604817208_4413"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> "Vogt, Robert (RCIS)" <Robert.Vogt@rcis.com><br> <b><span style="font-weight: bold;">To:</span></b> "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, October 27, 2016 3:57 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] SQL credentials<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1477604817208_4812"><br><div id="yiv6795437427">
<style><!--
#yiv6795437427
_filtered #yiv6795437427 {font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv6795437427
#yiv6795437427 p.yiv6795437427MsoNormal, #yiv6795437427 li.yiv6795437427MsoNormal, #yiv6795437427 div.yiv6795437427MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman", "serif";}
#yiv6795437427 a:link, #yiv6795437427 span.yiv6795437427MsoHyperlink
{
color:blue;
text-decoration:underline;}
#yiv6795437427 a:visited, #yiv6795437427 span.yiv6795437427MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
#yiv6795437427 span.yiv6795437427EmailStyle17
{
font-family:"Calibri", "sans-serif";
color:#1F497D;}
#yiv6795437427 .yiv6795437427MsoChpDefault
{
font-family:"Calibri", "sans-serif";}
_filtered #yiv6795437427 {
margin:1.0in 1.0in 1.0in 1.0in;}
#yiv6795437427 div.yiv6795437427WordSection1
{}
--></style>
<div id="yui_3_16_0_ym19_1_1477604817208_4811">
<div class="yiv6795437427WordSection1" id="yui_3_16_0_ym19_1_1477604817208_4810">
<div class="yiv6795437427MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">In my connection is it possible to replace the “uid” and “pwd” with an environmental variable that mapserver would look up?</span></div>
<div class="yiv6795437427MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Or some other way obfuscating the credentials?</span></div>
<div class="yiv6795437427MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div class="yiv6795437427MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">CONNECTION "server=stgissql01.dvcorp.rcis.com,5208;uid=MS_UID;pwd=MS_PASS;Initial Catalog=NATIONALDB;Integrated Security=False"</span></div>
<div class="yiv6795437427MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div class="yiv6795437427MsoNormal" id="yui_3_16_0_ym19_1_1477604817208_4809"><span style="font-size:11.0pt;color:#1F497D;">-Bob</span></div>
<div class="yiv6795437427MsoNormal" id="yui_3_16_0_ym19_1_1477604817208_4813"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
</div>
</div>
</div><br>_______________________________________________<br>mapserver-users mailing list<br><a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br><br></div> </div> </div> </div></div></body></html>