<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><span style="font-family: Arial,Helvetica,sans-serif;">Hi All,</span></p>
<p><br style="font-family: Arial,Helvetica,sans-serif;">
</p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">I'm trying to configure shibboleth to pull attributes from a MySQL database. How do I figure out what the name is for the attribute encoder for a MySQL column name? LDAP attributes have an OID which
is usually something along the lines of 2.5.4.4, which would translate to the following AttributeEncoder:<br>
</span></p>
<p><br>
<span style="font-family: Arial,Helvetica,sans-serif;"></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"><resolver:AttributeEncoder xsi:type="enc:SAML2String" name="urn:oid:2.5.4.4" friendlyName="sn" encodeType="false" /></span></p>
<p><br>
<span style="font-family: Arial,Helvetica,sans-serif;"></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">As far as I can tell (and I may be wrong), MySQL doesn't haven an OID for each attribute. What should I put in the name section for the AttributeEncoder element of some attribute that I get out of a
MySQL table?</span></p>
<p><br>
<span style="font-family: Arial,Helvetica,sans-serif;"></span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;">Thanks,</span></p>
<p><span style="font-family: Arial,Helvetica,sans-serif;"> David N.<br>
<code style=""></code><code style="font-family: Arial,Helvetica,sans-serif;" class="xml string"></code></span></p>
</div>
</body>
</html>