<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3379308617221153982</id><updated>2010-08-20T12:49:31.278-07:00</updated><title type='text'>Red Militante's Blog</title><subtitle type='html'>Code samples and other things I want to remember.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>15</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-618267501994670658</id><published>2010-06-04T15:37:00.001-07:00</published><updated>2010-06-04T15:43:39.043-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='LDAP'/><category scheme='http://www.blogger.com/atom/ns#' term='Shibboleth'/><title type='text'>Shibboleth script attribute definition</title><content type='html'>Shibboleth script attribute definition - this example adds the member value to a scripted version of eduPersonAffiliation attribute for a principal with affiliation staff or student while keeping any affiliation values retrieved from the directory.  The IdP will remove any duplicates.&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="java"&gt;&lt;resolver:AttributeDefinition xsi:type="Script" xmlns="urn:macehibboleth:2.0:resolver:ad"&lt;br /&gt;id="scripteduPersonAffiliation"&lt;br /&gt;sourceAttributeID="eduPersonAffiliation"&gt;&lt;br /&gt;&lt;br /&gt;&lt;!-- Dependency that provides the source attribute. --&gt;&lt;br /&gt;&lt;resolverependency ref="directory" /&gt;&lt;br /&gt;&lt;resolverependency ref="eduPersonAffiliation" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;!-- The script, wrapped in a CDATA section so that special XML characters don't need to be removed --&gt;&lt;br /&gt;&lt;Script&gt;&lt;![CDATA[&lt;br /&gt;importPackage(Pactkages.edu.internet2.middleware.shibboleth.common.attribute.provider);&lt;br /&gt;&lt;br /&gt;// Create attribute to be returned from definition&lt;br /&gt;scripteduPersonAffiliation = new BasicAttribute("scripteduPersonAffiliation");&lt;br /&gt;&lt;br /&gt;if (eduPersonAffiliation.getValues().contains("staff")) {&lt;br /&gt;scripteduPersonAffiliation.getValues().add("staff");&lt;br /&gt;scripteduPersonAffiliation.getValues().add("member");&lt;br /&gt;}&lt;br /&gt;if (eduPersonAffiliation.getValues().contains("student")) {&lt;br /&gt;scripteduPersonAffiliation.getValues().add("student");&lt;br /&gt;scripteduPersonAffiliation.getValues().add("member");&lt;br /&gt;}&lt;br /&gt;if (eduPersonAffiliation.getValues().contains("faculty")) {&lt;br /&gt;scripteduPersonAffiliation.getValues().add("faculty");&lt;br /&gt;scripteduPersonAffiliation.getValues().add("member");&lt;br /&gt;}&lt;br /&gt;]]&gt;&lt;/Script&gt;&lt;br /&gt;&lt;br /&gt;&lt;/resolver:AttributeDefinition&gt;&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-618267501994670658?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/618267501994670658/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/06/tes.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/618267501994670658'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/618267501994670658'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/06/tes.html' title='Shibboleth script attribute definition'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-5911503429568844183</id><published>2010-04-14T11:32:00.001-07:00</published><updated>2010-06-04T22:56:17.097-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jsp'/><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><category scheme='http://www.blogger.com/atom/ns#' term='Shibboleth'/><title type='text'>Get entityId of referring SP via LoginContext in Shibboleth IdP login.jsp</title><content type='html'>&lt;pre name="code" class="xml"&gt;&lt;%@ page import="edu.internet2.middleware.shibboleth.idp.authn.LoginContext" %&gt;&lt;br /&gt;&lt;%@ page import="edu.internet2.middleware.shibboleth.idp.session.*" %&gt;&lt;br /&gt;&lt;%@ page import="edu.internet2.middleware.shibboleth.idp.util.HttpServletHelper" %&gt;&lt;br /&gt;&lt;%@ page import="org.opensaml.saml2.metadata.*" %&gt;&lt;br /&gt;&lt;br /&gt;&lt;%&lt;br /&gt;    LoginContext loginContext = HttpServletHelper.getLoginContext(HttpServletHelper.getStorageService(application), application, request);&lt;br /&gt;    EntityDescriptor entityDescriptor = HttpServletHelper.getRelyingPartyMetadata(loginContext.getRelyingPartyId(), HttpServletHelper.getRelyingPartyConfirmationManager(application));&lt;br /&gt;    String entityID = entityDescriptor.getEntityID();&lt;br /&gt;    Session userSession = HttpServletHelper.getUserSession(request);&lt;br /&gt;%&gt;&lt;br /&gt;                &lt;% if(("https://x.com".equals(entityID)) || ("https://x2.com".equals(entityID))){ %&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-5911503429568844183?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/5911503429568844183/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/04/get-entityid-of-referring-sp-via.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/5911503429568844183'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/5911503429568844183'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/04/get-entityid-of-referring-sp-via.html' title='Get entityId of referring SP via LoginContext in Shibboleth IdP login.jsp'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-2634096104429329079</id><published>2010-03-05T13:30:00.000-08:00</published><updated>2010-03-05T13:34:41.046-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Programming'/><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><category scheme='http://www.blogger.com/atom/ns#' term='Java Mail IMAP'/><title type='text'>Fast way to get IMAP folder size information</title><content type='html'>Code that connects to an IMAP store over SSL, and obtains folder/subfolder information such as folder size by adding up the RFC822.size of all the messages in the folder.  This is normally a very slow operation, but some pre-fetch code has been added to speed up this operation.  Also a Map comparator implementation to sort folders in order of size.&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="java"&gt; &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;    public static String getMailboxInfo(String mail, String mailHost)&lt;br /&gt;            throws javax.mail.NoSuchProviderException, MessagingException, IOException, GeneralSecurityException, Exception {&lt;br /&gt;        String html = "&lt;table cellpadding=\"5\" cellspacing=\"0\"&gt;&lt;tr&gt;&lt;th style=\"border-bottom: 1px solid #D5D5CC;\"&gt;Mailbox/Folder&lt;/th&gt;&lt;th style=\"border-bottom: 1px solid #D5D5CC;\"&gt;Message Count&lt;/th&gt;&lt;th style=\"border-bottom: 1px solid #D5D5CC;\"&gt;Size/Usage&lt;/th&gt;&lt;/tr&gt;";&lt;br /&gt;        String pattern = "%";&lt;br /&gt;        Config conf = nsit.Config.getInstance();&lt;br /&gt;        String mpUser = conf.getOption("mp_user");&lt;br /&gt;        String mpPassword = conf.getOption("mp_password");&lt;br /&gt;        // setup mail server&lt;br /&gt;        MailSSLSocketFactory sf = new MailSSLSocketFactory();&lt;br /&gt;        sf.setTrustAllHosts(true);&lt;br /&gt;&lt;br /&gt;        // set system properties&lt;br /&gt;        Properties mailProps = System.getProperties();&lt;br /&gt;        mailProps.put("mail.imaps.ssl.socketFactory", sf);&lt;br /&gt;        mailProps.put("mail.store.protocol", "imaps");&lt;br /&gt;        mailProps.put("mail.imaps.host", mailHost);&lt;br /&gt;        mailProps.put("mail.imaps.port", "993");&lt;br /&gt;        // get session&lt;br /&gt;        //Session session = Session.getDefaultInstance(mailProps);&lt;br /&gt;        mailProps.setProperty("mail.imaps.sasl.authorizationid", mail);&lt;br /&gt;        Session session = Session.getInstance(mailProps, new SASLMasqueradeAuthenticator(mpUser, mpPassword));&lt;br /&gt;        session.setDebug(false);&lt;br /&gt;&lt;br /&gt;        // Get a Store object&lt;br /&gt;        Store store = null;&lt;br /&gt;        Folder rf = null;&lt;br /&gt;&lt;br /&gt;        store = session.getStore();&lt;br /&gt;        store.connect();&lt;br /&gt;&lt;br /&gt;        rf = store.getDefaultFolder();&lt;br /&gt;        //dumpFolder(rf, false, "");&lt;br /&gt;&lt;br /&gt;        map.clear();&lt;br /&gt;&lt;br /&gt;        if ((rf.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;            Folder[] f = rf.list(pattern);&lt;br /&gt;            for (int i = 0; i &lt; f.length; i++) {&lt;br /&gt;                dumpFolder(f[i], true, "    ");&lt;br /&gt;            }&lt;br /&gt;            store.close();&lt;br /&gt;        }&lt;br /&gt;&lt;br /&gt;        ValueComparator bvc = new ValueComparator(map);&lt;br /&gt;        TreeMap&lt;String, FolderInfo&gt; sorted_map = new TreeMap(bvc);&lt;br /&gt;        sorted_map.putAll(map);&lt;br /&gt;&lt;br /&gt;        Set set = sorted_map.entrySet();&lt;br /&gt;        Iterator i = set.iterator();&lt;br /&gt;        while (i.hasNext()) {&lt;br /&gt;            Map.Entry me = (Map.Entry) i.next();&lt;br /&gt;            FolderInfo fi = (FolderInfo) me.getValue();&lt;br /&gt;            int fn = fi.folderNmsgs;&lt;br /&gt;            Long fs = fi.folderSize;&lt;br /&gt;            System.out.println(me.getKey() + " : " + fn + " : " + fs);&lt;br /&gt;            html += "&lt;tr&gt;&lt;td style=\"border-bottom: 1px solid #D5D5CC;\"&gt;" + me.getKey() + "&lt;/td&gt;&lt;td align=\"right\" style=\"border-bottom: 1px solid #D5D5CC;\"&gt;" + fn + "&lt;/td&gt;&lt;td align=\"right\" style=\"border-bottom: 1px solid #D5D5CC;\"&gt;" + fs + " MB&lt;/td&gt;&lt;/tr&gt;";&lt;br /&gt;&lt;br /&gt;        }&lt;br /&gt;        html += "&lt;/table&gt;";&lt;br /&gt;        return html;&lt;br /&gt;    }&lt;br /&gt;&lt;br /&gt;    private static class SASLMasqueradeAuthenticator extends Authenticator {&lt;br /&gt;&lt;br /&gt;        String authcid, authcpass;&lt;br /&gt;&lt;br /&gt;        public SASLMasqueradeAuthenticator(String adminusername, String adminpassword) {&lt;br /&gt;            authcid = adminusername;&lt;br /&gt;            authcpass = adminpassword;&lt;br /&gt;        }&lt;br /&gt;&lt;br /&gt;        protected PasswordAuthentication getPasswordAuthentication() {&lt;br /&gt;            return new PasswordAuthentication(authcid, authcpass);&lt;br /&gt;        }&lt;br /&gt;    }&lt;br /&gt;&lt;br /&gt;    static void dumpFolder(Folder folder, boolean recurse, String tab)&lt;br /&gt;            throws Exception, MessagingException {&lt;br /&gt;&lt;br /&gt;        if (folder.getType() == 2) {&lt;br /&gt;            if ((folder.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;                if (recurse) {&lt;br /&gt;                    Folder[] f = folder.list();&lt;br /&gt;                    for (int i = 0; i &lt; f.length; i++) {&lt;br /&gt;                        dumpFolder(f[i], recurse, tab + "    ");&lt;br /&gt;                    }&lt;br /&gt;                }&lt;br /&gt;            }&lt;br /&gt;            return;&lt;br /&gt;        }&lt;br /&gt;        folder.open(Folder.READ_ONLY);&lt;br /&gt;        Message messages[] = folder.getMessages();&lt;br /&gt;&lt;br /&gt;        // Tell JavaMail to do some pre-fetching of the usual cruft.&lt;br /&gt;        FetchProfile fp = new FetchProfile();&lt;br /&gt;        fp.add(FetchProfile.Item.ENVELOPE);&lt;br /&gt;        folder.fetch(messages, fp);&lt;br /&gt;&lt;br /&gt;        System.out.println(tab + "Name:      " + folder.getName());&lt;br /&gt;        System.out.println(tab + "Full Name: " + folder.getFullName());&lt;br /&gt;        System.out.println(tab + "URL:       " + folder.getURLName());&lt;br /&gt;        boolean verbose = true;&lt;br /&gt;&lt;br /&gt;        if (verbose) {&lt;br /&gt;            if (!folder.isSubscribed()) {&lt;br /&gt;                System.out.println(tab + "Not Subscribed");&lt;br /&gt;            }&lt;br /&gt;&lt;br /&gt;            if ((folder.getType() &amp; Folder.HOLDS_MESSAGES) != 0) {&lt;br /&gt;                if (folder.hasNewMessages()) {&lt;br /&gt;                    System.out.println(tab + "Has New Messages");&lt;br /&gt;                }&lt;br /&gt;                System.out.println(tab + "Total Messages:  " +&lt;br /&gt;                        folder.getMessageCount());&lt;br /&gt;                System.out.println(tab + "New Messages:    " +&lt;br /&gt;                        folder.getNewMessageCount());&lt;br /&gt;                System.out.println(tab + "Unread Messages: " +&lt;br /&gt;                        folder.getUnreadMessageCount());&lt;br /&gt;            }&lt;br /&gt;            if ((folder.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;                System.out.println(tab + "Is Directory");&lt;br /&gt;            }&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;            long folderSize = 0;&lt;br /&gt;            for (Message message : messages) {&lt;br /&gt;                folderSize += message.getSize();&lt;br /&gt;            }&lt;br /&gt;&lt;br /&gt;            long folderSizeMB = (folderSize / (1024L * 1024L));&lt;br /&gt;            System.out.printf("Folder Size in MB: %d\n", folderSizeMB);&lt;br /&gt;            FolderInfo fi = new FolderInfo(folder.getMessageCount(), folderSizeMB);&lt;br /&gt;            map.put(folder.getFullName(), fi);&lt;br /&gt;&lt;br /&gt;            /*&lt;br /&gt;             * Demonstrate use of IMAP folder attributes&lt;br /&gt;             * returned by the IMAP LIST response.&lt;br /&gt;             */&lt;br /&gt;            if (folder instanceof IMAPFolder) {&lt;br /&gt;                IMAPFolder f = (IMAPFolder) folder;&lt;br /&gt;                String[] attrs = f.getAttributes();&lt;br /&gt;                if (attrs != null &amp;&amp; attrs.length &gt; 0) {&lt;br /&gt;                    System.out.println(tab + "IMAP Attributes:");&lt;br /&gt;                    for (int i = 0; i &lt; attrs.length; i++) {&lt;br /&gt;                        System.out.println(tab + "    " + attrs[i]);&lt;br /&gt;                    }&lt;br /&gt;                }&lt;br /&gt;            }&lt;br /&gt;        }&lt;br /&gt;&lt;br /&gt;        System.out.println();&lt;br /&gt;&lt;br /&gt;        if ((folder.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;            if (recurse) {&lt;br /&gt;                Folder[] f = folder.list();&lt;br /&gt;                for (int i = 0; i &lt; f.length; i++) {&lt;br /&gt;                    dumpFolder(f[i], recurse, tab + "    ");&lt;br /&gt;                }&lt;br /&gt;            }&lt;br /&gt;        }&lt;br /&gt;    }&lt;br /&gt;&lt;br /&gt;    public static void main(String[] args) {&lt;br /&gt;    }&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;class ValueComparator implements Comparator {&lt;br /&gt;&lt;br /&gt;    Map base;&lt;br /&gt;&lt;br /&gt;    public ValueComparator(Map base) {&lt;br /&gt;        this.base = base;&lt;br /&gt;    }&lt;br /&gt;&lt;br /&gt;    public int compare(Object a, Object b) {&lt;br /&gt;&lt;br /&gt;        FolderInfo fa = (FolderInfo) base.get(a);&lt;br /&gt;        FolderInfo fb = (FolderInfo) base.get(b);&lt;br /&gt;        Long fsa = fa.folderSize;&lt;br /&gt;        Long fsb = fb.folderSize;&lt;br /&gt;&lt;br /&gt;        if ((Long) fsa &lt; (Long) fsb) {&lt;br /&gt;            return 1;&lt;br /&gt;        } else if ((Long) fsa == (Long) fsb) {&lt;br /&gt;            return 1;&lt;br /&gt;        } else {&lt;br /&gt;            return -1;&lt;br /&gt;        }&lt;br /&gt;    }&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;class FolderInfo {&lt;br /&gt;&lt;br /&gt;    int folderNmsgs;&lt;br /&gt;    Long folderSize;&lt;br /&gt;&lt;br /&gt;    public FolderInfo(int i, Long l) {&lt;br /&gt;        this.folderNmsgs = i;&lt;br /&gt;        this.folderSize = l;&lt;br /&gt;    }&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-2634096104429329079?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/2634096104429329079/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/03/fast-way-to-get-imap-folder-size.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2634096104429329079'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2634096104429329079'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/03/fast-way-to-get-imap-folder-size.html' title='Fast way to get IMAP folder size information'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-2771194774783667496</id><published>2010-02-22T09:46:00.001-08:00</published><updated>2010-03-03T13:36:22.733-08:00</updated><title type='text'>Using QuotaAwareStore</title><content type='html'>Using the QuotaAwareStore interface to obtain quota information for an IMAP folder&lt;br /&gt;&lt;pre name="code" class="java"&gt; &lt;br /&gt;        Store store = null;&lt;br /&gt;        Folder rf = null;&lt;br /&gt;        store = session.getStore();&lt;br /&gt;        store.connect();&lt;br /&gt; &lt;br /&gt;        rf = store.getDefaultFolder();&lt;br /&gt; &lt;br /&gt;        if ((rf.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;            Folder[] f = rf.list(pattern);&lt;br /&gt;            for (int i = 0; i &lt; f.length; i++) {&lt;br /&gt;                log.info(f[i].getName());&lt;br /&gt; &lt;br /&gt;                IMAPSSLStore store3 = (IMAPSSLStore) f[i].getStore();&lt;br /&gt;                QuotaAwareStore qas = (QuotaAwareStore) store3;&lt;br /&gt;                Quota[] test = qas.getQuota(f[i].getName());&lt;br /&gt;                log.info("test.length " + test.length);&lt;br /&gt;                log.info("test[0] " + test[0]);&lt;br /&gt;                log.info("quota root " + test[0].quotaRoot);&lt;br /&gt;                Quota.Resource[] resources = test[0].resources;&lt;br /&gt;                log.info("resources.length " + resources.length);&lt;br /&gt;                log.info("resources[0].name " + resources[0].name);&lt;br /&gt;                log.info("resources[0].limit " + resources[0].limit);&lt;br /&gt;                log.info("resources[0].usage " + resources[0].usage);&lt;br /&gt;            }&lt;br /&gt;            store.close();&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-2771194774783667496?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/2771194774783667496/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/02/using-quotaawarestore.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2771194774783667496'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2771194774783667496'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/02/using-quotaawarestore.html' title='Using QuotaAwareStore'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-1522685333566446722</id><published>2010-02-22T09:42:00.000-08:00</published><updated>2010-03-03T13:36:49.155-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Java Mail IMAP'/><title type='text'>Get size of IMAP folder using JavaMail</title><content type='html'>Obtaining size of IMAP folder by totalling RFC822 message sizes of msgs in a folder.&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="java"&gt;          if (verbose) {&lt;br /&gt;            if (!folder.isSubscribed()) {&lt;br /&gt;                System.out.println(tab + "Not Subscribed");&lt;br /&gt;            }&lt;br /&gt;&lt;br /&gt;            if ((folder.getType() &amp; Folder.HOLDS_MESSAGES) != 0) {&lt;br /&gt;                if (folder.hasNewMessages()) {&lt;br /&gt;                    System.out.println(tab + "Has New Messages");&lt;br /&gt;                }&lt;br /&gt;                System.out.println(tab + "Total Messages:  " +&lt;br /&gt;                        folder.getMessageCount());&lt;br /&gt;                System.out.println(tab + "New Messages:    " +&lt;br /&gt;                        folder.getNewMessageCount());&lt;br /&gt;                System.out.println(tab + "Unread Messages: " +&lt;br /&gt;                        folder.getUnreadMessageCount());&lt;br /&gt;            }&lt;br /&gt;            if ((folder.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;                System.out.println(tab + "Is Directory");&lt;br /&gt;            }&lt;br /&gt;&lt;br /&gt;            if (folder.getName().length() != 0) { //root folder&lt;br /&gt;                if (folder.getMessageCount() != 0) {&lt;br /&gt;                    long msgs_size = 0;&lt;br /&gt;                    log.info("folder.getMessageCount() " + folder.getMessageCount());&lt;br /&gt;                    folder.open(Folder.READ_ONLY);&lt;br /&gt;                    Message[] messages = folder.getMessages();&lt;br /&gt;                    log.info("messages.length " + messages.length);&lt;br /&gt;                    log.info("msgs_size " + msgs_size);&lt;br /&gt;                    //rjm 010810:scp scp slowness due to something in here? set debugging statements&lt;br /&gt;                    //if (folder.getName().equals("Sent Messages")) {&lt;br /&gt;                    for (int x = 0; x &lt; messages.length; x++) {&lt;br /&gt;                        IMAPMessage tmp = (IMAPMessage) messages[x];&lt;br /&gt;                        if (tmp.getSize() != -1) {&lt;br /&gt;                            log.info("tmp.getSize() " + tmp.getSize());&lt;br /&gt;                            msgs_size = msgs_size + tmp.getSize();&lt;br /&gt;                            log.info("msgs_size " + msgs_size);//size in bytes&lt;br /&gt;                            log.info(msgs_size / (1024L * 1024L)); //converted to MB&lt;br /&gt;                            }&lt;br /&gt;                    }&lt;br /&gt;                    //}&lt;br /&gt;                }&lt;br /&gt;            }&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-1522685333566446722?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/1522685333566446722/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/02/get-size-of-imap-folder-using-javamail.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/1522685333566446722'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/1522685333566446722'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/02/get-size-of-imap-folder-using-javamail.html' title='Get size of IMAP folder using JavaMail'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-3354182443109726814</id><published>2010-02-01T08:12:00.000-08:00</published><updated>2010-02-02T07:24:53.157-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Linux'/><category scheme='http://www.blogger.com/atom/ns#' term='Networking'/><title type='text'>Multiple hop tunnel to chain port forwarding</title><content type='html'>I was trying to set up a db connection to from a vm on my laptop to a db server that was configured to only accept connections from machines behind its own subnet.  I had trouble setting up a multiple hop tunnel for chaining port forwarding through my firewall machine on the same subnet as the db.  My first attempt involved two port forwards, on localhost and on the firewall machine, which didn't work for me.  This approach I found at &lt;a href="http://www.derkeiler.com/Newsgroups/comp.security.ssh/2006-03/msg00267.html"&gt;http://www.derkeiler.com/Newsgroups/comp.security.ssh/2006-03/msg00267.html&lt;/a&gt; involved constructing an end to end connection to the db via the firewall machine&lt;br /&gt;&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;When you have to go through multiple hops, it's usually better to get an&lt;br /&gt;end-to-end connection. In this case:&lt;br /&gt;&lt;br /&gt;ssh -oproxycommand="ssh -qaxT firewall nc %h %p" -L 5432:localhost:5432 dbserver&lt;br /&gt;&lt;br /&gt;If you have a copy of the snail book, section 11.4 (p444) has a discussion&lt;br /&gt;of these two approaches.&lt;br /&gt;&lt;br /&gt;The annoyance with the second approach is that it requires having netcat&lt;br /&gt;("nc") or something equivalent on the intermediate host. I hope that&lt;br /&gt;someday OpenSSH will have this feature built in, i.e. connecting an exec&lt;br /&gt;channel to a remote TCP connection.&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;br /&gt;Edit:  I found some documentation on 'ProxyCommand' &lt;a href="http://www.openbsd.org/cgi-bin/man.cgi?query=ssh_config&amp;sektion=5&amp;arch=&amp;apropos=0&amp;manpath=OpenBSD+Current"&gt;here&lt;/a&gt; that seems relevant&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;     ProxyCommand&lt;br /&gt;             Specifies the command to use to connect to the server.  The com-&lt;br /&gt;             mand string extends to the end of the line, and is executed with&lt;br /&gt;             the user's shell.  In the command string, `%h' will be substitut-&lt;br /&gt;             ed by the host name to connect and `%p' by the port.  The command&lt;br /&gt;             can be basically anything, and should read from its standard in-&lt;br /&gt;             put and write to its standard output.  It should eventually con-&lt;br /&gt;             nect an sshd(8) server running on some machine, or execute sshd&lt;br /&gt;             -i somewhere.  Host key management will be done using the Host-&lt;br /&gt;             Name of the host being connected (defaulting to the name typed by&lt;br /&gt;             the user).  Setting the command to ``none'' disables this option&lt;br /&gt;             entirely.  Note that CheckHostIP is not available for connects&lt;br /&gt;             with a proxy command.&lt;br /&gt;&lt;br /&gt;             This directive is useful in conjunction with nc(1) and its proxy&lt;br /&gt;             support.  For example, the following directive would connect via&lt;br /&gt;             an HTTP proxy at 192.0.2.0:&lt;br /&gt;&lt;br /&gt;                ProxyCommand /usr/bin/nc -X connect -x 192.0.2.0:8080 %h %p&lt;br /&gt;&lt;/blockquote&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-3354182443109726814?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/3354182443109726814/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/02/multiple-hop-tunnel-to-chain-port.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/3354182443109726814'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/3354182443109726814'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/02/multiple-hop-tunnel-to-chain-port.html' title='Multiple hop tunnel to chain port forwarding'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-8500157445580527385</id><published>2010-01-11T19:10:00.000-08:00</published><updated>2010-03-03T13:37:11.344-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><title type='text'>Connect to IMAP using JavaMail over SSL</title><content type='html'>Connect to and get mailbox information from an imaps server using JavaMail.  I'm using a custom SASLMasqueradeAuthenticator method, configuring JavaMail's Socket Fetcher class to use  "MailSSLSocketFactory".&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="java"&gt;    public static void getMailboxInfo(String mail, String mailHost)&lt;br /&gt;            throws javax.mail.NoSuchProviderException, MessagingException, IOException, GeneralSecurityException {&lt;br /&gt;        Config conf = nsit.Config.getInstance();&lt;br /&gt;        String mpUser = "";&lt;br /&gt;        String mpPassword = "";&lt;br /&gt;        // setup mail server&lt;br /&gt;        MailSSLSocketFactory sf = new MailSSLSocketFactory();&lt;br /&gt;        sf.setTrustAllHosts(true);&lt;br /&gt;&lt;br /&gt;        // set system properties&lt;br /&gt;        Properties mailProps = System.getProperties();&lt;br /&gt;        mailProps.put("mail.imaps.ssl.socketFactory", sf);&lt;br /&gt;        mailProps.put("mail.store.protocol", "imaps");&lt;br /&gt;        mailProps.put("mail.imaps.host", mailHost);&lt;br /&gt;        mailProps.put("mail.imaps.port", "993");&lt;br /&gt;&lt;br /&gt;        // get session&lt;br /&gt;        //Session session = Session.getDefaultInstance(mailProps);&lt;br /&gt;        mailProps.setProperty("mail.imaps.sasl.authorizationid", mail);&lt;br /&gt;        Session session = Session.getInstance(mailProps, new SASLMasqueradeAuthenticator(mpUser, mpPassword));&lt;br /&gt;        session.setDebug(false);&lt;br /&gt;        Store srcStore;&lt;br /&gt;        srcStore = session.getStore();&lt;br /&gt;        srcStore.connect();&lt;br /&gt;        Folder src = srcStore.getDefaultFolder();&lt;br /&gt;        //log.info("src.getName() " + src.getName());&lt;br /&gt;        //log.info("src.getType() " + src.getType());&lt;br /&gt;        //log.info("src.HOLDS_FOLDERS " + src.HOLDS_FOLDERS);&lt;br /&gt;&lt;br /&gt;        if ((src.getType() &amp; Folder.HOLDS_FOLDERS) != 0) {&lt;br /&gt;            Folder[] subfolders = src.list();&lt;br /&gt;            log.info("subfolders.length " + subfolders.length);&lt;br /&gt;            for (int i = 0; i &lt; subfolders.length; i++) {&lt;br /&gt;                long msgs_size = 0;&lt;br /&gt;&lt;br /&gt;                if (subfolders[i].getMessageCount() != 0) {&lt;br /&gt;                    log.info("subfolders[i].getMessageCount() " + subfolders[i].getMessageCount());&lt;br /&gt;                    subfolders[i].open(Folder.READ_ONLY);&lt;br /&gt;                    Message[] messages = subfolders[i].getMessages();&lt;br /&gt;&lt;br /&gt;                    for (int x = 0; x &lt; messages.length; x++) {&lt;br /&gt;                        //log.info("msg_size " + messages[i].getSize() + " bytes long.");&lt;br /&gt;                        if (messages[i].getSize() != -1) {&lt;br /&gt;                            msgs_size += messages[i].getSize();&lt;br /&gt;                        }&lt;br /&gt;                    }&lt;br /&gt;                    log.info("msgs_size " + (msgs_size));&lt;br /&gt;                    log.info("msgs_size " + (msgs_size / (1024L * 1024L)));&lt;br /&gt;&lt;br /&gt;                    subfolders[i].close(false);         &lt;br /&gt;            }&lt;br /&gt;        } else {&lt;br /&gt;            System.out.println("Not default folder");&lt;br /&gt;        }&lt;br /&gt;    }&lt;br /&gt;&lt;br /&gt;    private static class SASLMasqueradeAuthenticator extends Authenticator {&lt;br /&gt;&lt;br /&gt;        String authcid, authcpass;&lt;br /&gt;&lt;br /&gt;        public SASLMasqueradeAuthenticator(String adminusername, String adminpassword) {&lt;br /&gt;            authcid = adminusername;&lt;br /&gt;            authcpass = adminpassword;&lt;br /&gt;        }&lt;br /&gt;&lt;br /&gt;        protected PasswordAuthentication getPasswordAuthentication() {&lt;br /&gt;            return new PasswordAuthentication(authcid, authcpass);&lt;br /&gt;        }&lt;br /&gt;    }&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-8500157445580527385?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/8500157445580527385/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2010/01/connect-to-imap-using-javamail-over-ssl.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/8500157445580527385'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/8500157445580527385'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2010/01/connect-to-imap-using-javamail-over-ssl.html' title='Connect to IMAP using JavaMail over SSL'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-7311992687066479554</id><published>2009-08-26T08:55:00.000-07:00</published><updated>2009-08-26T08:56:22.856-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MySQL'/><category scheme='http://www.blogger.com/atom/ns#' term='Crypto'/><title type='text'>Stored functions to BASE64 ENCODE and DECODE in MySQL</title><content type='html'>-- base64.sql - MySQL base64 encoding/decoding functions&lt;br /&gt;-- Copyright (C) 2006 Ian Gulliver&lt;br /&gt;-- &lt;br /&gt;-- This program is free software; you can redistribute it and/or modify&lt;br /&gt;-- it under the terms of version 2 of the GNU General Public License as&lt;br /&gt;-- published by the Free Software Foundation.&lt;br /&gt;-- &lt;br /&gt;-- This program is distributed in the hope that it will be useful,&lt;br /&gt;-- but WITHOUT ANY WARRANTY; without even the implied warranty of&lt;br /&gt;-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the&lt;br /&gt;-- GNU General Public License for more details.&lt;br /&gt;-- &lt;br /&gt;-- You should have received a copy of the GNU General Public License&lt;br /&gt;-- along with this program; if not, write to the Free Software&lt;br /&gt;-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA&lt;br /&gt;&lt;br /&gt;delimiter |&lt;br /&gt;&lt;br /&gt;DROP TABLE IF EXISTS base64_data |&lt;br /&gt;CREATE TABLE base64_data (c CHAR(1) BINARY, val TINYINT) |&lt;br /&gt;INSERT INTO base64_data VALUES &lt;br /&gt; ('A',0), ('B',1), ('C',2), ('D',3), ('E',4), ('F',5), ('G',6), ('H',7), ('I',8), ('J',9),&lt;br /&gt; ('K',10), ('L',11), ('M',12), ('N',13), ('O',14), ('P',15), ('Q',16), ('R',17), ('S',18), ('T',19),&lt;br /&gt; ('U',20), ('V',21), ('W',22), ('X',23), ('Y',24), ('Z',25), ('a',26), ('b',27), ('c',28), ('d',29),&lt;br /&gt; ('e',30), ('f',31), ('g',32), ('h',33), ('i',34), ('j',35), ('k',36), ('l',37), ('m',38), ('n',39),&lt;br /&gt; ('o',40), ('p',41), ('q',42), ('r',43), ('s',44), ('t',45), ('u',46), ('v',47), ('w',48), ('x',49),&lt;br /&gt; ('y',50), ('z',51), ('0',52), ('1',53), ('2',54), ('3',55), ('4',56), ('5',57), ('6',58), ('7',59),&lt;br /&gt; ('8',60), ('9',61), ('+',62), ('/',63), ('=',0) |&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;DROP FUNCTION IF EXISTS BASE64_DECODE |&lt;br /&gt;CREATE FUNCTION BASE64_DECODE (input BLOB)&lt;br /&gt; RETURNS BLOB&lt;br /&gt; CONTAINS SQL&lt;br /&gt; DETERMINISTIC&lt;br /&gt; SQL SECURITY INVOKER&lt;br /&gt;BEGIN&lt;br /&gt; DECLARE ret BLOB DEFAULT '';&lt;br /&gt; DECLARE done TINYINT DEFAULT 0;&lt;br /&gt;&lt;br /&gt; IF input IS NULL THEN&lt;br /&gt;  RETURN NULL;&lt;br /&gt; END IF;&lt;br /&gt;&lt;br /&gt;each_block:&lt;br /&gt; WHILE NOT done DO BEGIN&lt;br /&gt;  DECLARE accum_value BIGINT UNSIGNED DEFAULT 0;&lt;br /&gt;  DECLARE in_count TINYINT DEFAULT 0;&lt;br /&gt;  DECLARE out_count TINYINT DEFAULT 3;&lt;br /&gt;&lt;br /&gt;each_input_char:&lt;br /&gt;  WHILE in_count &lt; 4 DO BEGIN&lt;br /&gt;   DECLARE first_char CHAR(1);&lt;br /&gt; &lt;br /&gt;   IF LENGTH(input) = 0 THEN&lt;br /&gt;    RETURN ret;&lt;br /&gt;   END IF;&lt;br /&gt; &lt;br /&gt;   SET first_char = SUBSTRING(input,1,1);&lt;br /&gt;   SET input = SUBSTRING(input,2);&lt;br /&gt; &lt;br /&gt;   BEGIN&lt;br /&gt;    DECLARE tempval TINYINT UNSIGNED;&lt;br /&gt;    DECLARE error TINYINT DEFAULT 0;&lt;br /&gt;    DECLARE base64_getval CURSOR FOR SELECT val FROM base64_data WHERE c = first_char;&lt;br /&gt;    DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET error = 1;&lt;br /&gt; &lt;br /&gt;    OPEN base64_getval;&lt;br /&gt;    FETCH base64_getval INTO tempval;&lt;br /&gt;    CLOSE base64_getval;&lt;br /&gt;&lt;br /&gt;    IF error THEN&lt;br /&gt;     ITERATE each_input_char;&lt;br /&gt;    END IF;&lt;br /&gt;&lt;br /&gt;    SET accum_value = (accum_value &lt;&lt; 6) + tempval;&lt;br /&gt;   END;&lt;br /&gt;&lt;br /&gt;   SET in_count = in_count + 1;&lt;br /&gt;&lt;br /&gt;   IF first_char = '=' THEN&lt;br /&gt;    SET done = 1;&lt;br /&gt;    SET out_count = out_count - 1;&lt;br /&gt;   END IF;&lt;br /&gt;  END; END WHILE;&lt;br /&gt;&lt;br /&gt;  -- We've now accumulated 24 bits; deaccumulate into bytes&lt;br /&gt;&lt;br /&gt;  -- We have to work from the left, so use the third byte position and shift left&lt;br /&gt;  WHILE out_count &gt; 0 DO BEGIN&lt;br /&gt;   SET ret = CONCAT(ret,CHAR((accum_value &amp; 0xff0000) &gt;&gt; 16));&lt;br /&gt;   SET out_count = out_count - 1;&lt;br /&gt;   SET accum_value = (accum_value &lt;&lt; 8) &amp; 0xffffff;&lt;br /&gt;  END; END WHILE;&lt;br /&gt; &lt;br /&gt; END; END WHILE;&lt;br /&gt;&lt;br /&gt; RETURN ret;&lt;br /&gt;END |&lt;br /&gt;&lt;br /&gt;DROP FUNCTION IF EXISTS BASE64_ENCODE |&lt;br /&gt;CREATE FUNCTION BASE64_ENCODE (input BLOB)&lt;br /&gt; RETURNS BLOB&lt;br /&gt; CONTAINS SQL&lt;br /&gt; DETERMINISTIC&lt;br /&gt; SQL SECURITY INVOKER&lt;br /&gt;BEGIN&lt;br /&gt; DECLARE ret BLOB DEFAULT '';&lt;br /&gt; DECLARE done TINYINT DEFAULT 0;&lt;br /&gt;&lt;br /&gt; IF input IS NULL THEN&lt;br /&gt;  RETURN NULL;&lt;br /&gt; END IF;&lt;br /&gt;&lt;br /&gt;each_block:&lt;br /&gt; WHILE NOT done DO BEGIN&lt;br /&gt;  DECLARE accum_value BIGINT UNSIGNED DEFAULT 0;&lt;br /&gt;  DECLARE in_count TINYINT DEFAULT 0;&lt;br /&gt;  DECLARE out_count TINYINT;&lt;br /&gt;&lt;br /&gt;each_input_char:&lt;br /&gt;  WHILE in_count &lt; 3 DO BEGIN&lt;br /&gt;   DECLARE first_char CHAR(1);&lt;br /&gt; &lt;br /&gt;   IF LENGTH(input) = 0 THEN&lt;br /&gt;    SET done = 1;&lt;br /&gt;    SET accum_value = accum_value &lt;&lt; (8 * (3 - in_count));&lt;br /&gt;    LEAVE each_input_char;&lt;br /&gt;   END IF;&lt;br /&gt; &lt;br /&gt;   SET first_char = SUBSTRING(input,1,1);&lt;br /&gt;   SET input = SUBSTRING(input,2);&lt;br /&gt; &lt;br /&gt;   SET accum_value = (accum_value &lt;&lt; 8) + ASCII(first_char);&lt;br /&gt;&lt;br /&gt;   SET in_count = in_count + 1;&lt;br /&gt;  END; END WHILE;&lt;br /&gt;&lt;br /&gt;  -- We've now accumulated 24 bits; deaccumulate into base64 characters&lt;br /&gt;&lt;br /&gt;  -- We have to work from the left, so use the third byte position and shift left&lt;br /&gt;  CASE&lt;br /&gt;   WHEN in_count = 3 THEN SET out_count = 4;&lt;br /&gt;   WHEN in_count = 2 THEN SET out_count = 3;&lt;br /&gt;   WHEN in_count = 1 THEN SET out_count = 2;&lt;br /&gt;   ELSE RETURN ret;&lt;br /&gt;  END CASE;&lt;br /&gt;&lt;br /&gt;  WHILE out_count &gt; 0 DO BEGIN&lt;br /&gt;   BEGIN&lt;br /&gt;    DECLARE out_char CHAR(1);&lt;br /&gt;    DECLARE base64_getval CURSOR FOR SELECT c FROM base64_data WHERE val = (accum_value &gt;&gt; 18);&lt;br /&gt;&lt;br /&gt;    OPEN base64_getval;&lt;br /&gt;    FETCH base64_getval INTO out_char;&lt;br /&gt;    CLOSE base64_getval;&lt;br /&gt;&lt;br /&gt;    SET ret = CONCAT(ret,out_char);&lt;br /&gt;    SET out_count = out_count - 1;&lt;br /&gt;    SET accum_value = accum_value &lt;&lt; 6 &amp; 0xffffff;&lt;br /&gt;   END;&lt;br /&gt;  END; END WHILE;&lt;br /&gt;&lt;br /&gt;  CASE&lt;br /&gt;   WHEN in_count = 2 THEN SET ret = CONCAT(ret,'=');&lt;br /&gt;   WHEN in_count = 1 THEN SET ret = CONCAT(ret,'==');&lt;br /&gt;   ELSE BEGIN END;&lt;br /&gt;  END CASE;&lt;br /&gt; &lt;br /&gt; END; END WHILE;&lt;br /&gt;&lt;br /&gt; RETURN ret;&lt;br /&gt;END |&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-7311992687066479554?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/7311992687066479554/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/08/stored-functions-to-base64-encode-and.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/7311992687066479554'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/7311992687066479554'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/08/stored-functions-to-base64-encode-and.html' title='Stored functions to BASE64 ENCODE and DECODE in MySQL'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-148549169144982351</id><published>2009-07-02T08:39:00.000-07:00</published><updated>2009-07-02T11:11:19.778-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MySQL'/><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><category scheme='http://www.blogger.com/atom/ns#' term='Shibboleth'/><category scheme='http://www.blogger.com/atom/ns#' term='Crypto'/><title type='text'>Shibboleth Relational Database DataConnector</title><content type='html'>Example &lt;a href="https://spaces.internet2.edu/display/SHIB2/ResolverRDBMSDataConnector"&gt;Shibboleth Relational Database DataConnector&lt;/a&gt; configuration for MySQL with column mapping of AES encrypted attribute.&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="xml"&gt;&lt;br /&gt;    &lt;resolver:DataConnector xsi:type="dc:RelationalDatabase"&lt;br /&gt;                            xmlns="urn:mace:shibboleth:2.0:resolver:dc"&lt;br /&gt;                            id="MyDatabase"&gt;&lt;br /&gt;        &lt;resolver:Dependency ref="directory" /&gt;&lt;br /&gt;        &lt;ApplicationManagedConnection jdbcDriver="com.mysql.jdbc.Driver"&lt;br /&gt;                                           jdbcURL="jdbc:mysql://localhost:3306/handle"&lt;br /&gt;                                           jdbcUserName="test"&lt;br /&gt;                                           jdbcPassword="test" /&gt;&lt;br /&gt;&lt;br /&gt;        &lt;QueryTemplate&gt;&lt;br /&gt;            &lt;![CDATA[&lt;br /&gt;                SELECT AES_DECRYPT(password, 'key') FROM handle WHERE username='$requestContext.principalName'&lt;br /&gt;            ]]&gt;&lt;br /&gt;        &lt;/QueryTemplate&gt;&lt;br /&gt;     &lt;Column columnName="AES_DECRYPT(password, 'key')" attributeID="handle" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;    &lt;/resolver:DataConnector&gt;&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-148549169144982351?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/148549169144982351/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/07/shibboleth-relational-database.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/148549169144982351'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/148549169144982351'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/07/shibboleth-relational-database.html' title='Shibboleth Relational Database DataConnector'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-2735566222241113223</id><published>2009-07-01T10:53:00.000-07:00</published><updated>2009-07-02T11:10:51.609-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MySQL'/><category scheme='http://www.blogger.com/atom/ns#' term='Jsp'/><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><category scheme='http://www.blogger.com/atom/ns#' term='Crypto'/><title type='text'>Jsp Insert into MySQL database, AES encryption</title><content type='html'>Jsp code that inserts into a MySQL database, using &lt;a href="http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_aes-decrypt"&gt;AES_ENCRYPTION for 128 bit AES encryption of one of the database columns&lt;/a&gt; with ON DUPLICATE KEY UPDATE syntax.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="Java"&gt;&lt;br /&gt;&lt;%@page import="java.sql.*"%&gt;&lt;br /&gt;&lt;%@page import="java.io.*"%&gt;&lt;br /&gt;&lt;br /&gt;&lt;%&lt;br /&gt;String username = request.getParameter("username");&lt;br /&gt;String password = request.getParameter("password");&lt;br /&gt;String connectionURL = "jdbc:mysql://localhost:3306/handle";&lt;br /&gt;Connection connection = null;&lt;br /&gt;PreparedStatement pstatement = null;&lt;br /&gt;Class.forName("com.mysql.jdbc.Driver").newInstance();&lt;br /&gt;int updateQuery = 0;&lt;br /&gt;if(username!=null &amp;&amp; password!=null){&lt;br /&gt;            try {&lt;br /&gt;              connection = DriverManager.getConnection (connectionURL, "test", "test");&lt;br /&gt;              String queryString = "INSERT INTO handle(username, password, last_login) VALUES (?, AES_ENCRYPT(?, 'key'), now()) ON DUPLICATE KEY UPDATE last_login=now()";&lt;br /&gt;              /* createStatement() is used for create statement&lt;br /&gt;              object that is used for sending sql statements to &lt;br /&gt;              the specified database. */&lt;br /&gt;              pstatement = connection.prepareStatement(queryString);&lt;br /&gt;              pstatement.setString(1, username);&lt;br /&gt;              pstatement.setString(2, password);&lt;br /&gt;              pstatement.setString(3, password);&lt;br /&gt;              updateQuery = pstatement.executeUpdate();&lt;br /&gt;              if (updateQuery != 0) { %&gt;&lt;br /&gt;                   &lt;!-- &lt;br&gt; --&gt;&lt;br /&gt;                   &lt;!-- &lt;TABLE WIDTH="30%" border="1"&gt; --&gt;&lt;br /&gt;                      &lt;!-- &lt;tr&gt;Data is inserted successfully in database.&lt;/tr&gt; --&gt;&lt;br /&gt;                   &lt;!-- &lt;/table&gt; --&gt;&lt;br /&gt;              &lt;%&lt;br /&gt;&lt;br /&gt;              }&lt;br /&gt;            } &lt;br /&gt;            catch (Exception ex)  { %&gt;&lt;br /&gt;                   &lt;!-- &lt;br&gt; --&gt;&lt;br /&gt;                   &lt;!-- &lt;TABLE WIDTH="30%" border="1"&gt; --&gt;&lt;br /&gt;                      &lt;!-- &lt;tr&gt;Unable to connect to the database.&lt;/tr&gt; --&gt;&lt;br /&gt;                   &lt;!-- &lt;/table&gt; --&gt;&lt;br /&gt;              &lt;%&lt;br /&gt;&lt;br /&gt;              }&lt;br /&gt;&lt;br /&gt;            finally {&lt;br /&gt;                // close all the connections.&lt;br /&gt;                pstatement.close();&lt;br /&gt;                connection.close();&lt;br /&gt;            }&lt;br /&gt;}&lt;br /&gt;%&gt;&lt;br /&gt;&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-2735566222241113223?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/2735566222241113223/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/07/jsp-insert-into-mysql-database.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2735566222241113223'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2735566222241113223'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/07/jsp-insert-into-mysql-database.html' title='Jsp Insert into MySQL database, AES encryption'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-7083564637192380939</id><published>2009-06-30T13:48:00.000-07:00</published><updated>2009-06-30T16:42:16.483-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='Html'/><title type='text'>Javascript form autosubmit</title><content type='html'>Autosubmit form with Javascript. Place&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="xml"&gt;&lt;br /&gt; onload="document.forms[0].submit()" &lt;br /&gt;&lt;/pre&gt;&lt;br /&gt;&lt;br /&gt;in your form's body tag then something like&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="xml"&gt;&lt;br /&gt;                &lt;noscript&gt;&lt;br /&gt;                    &lt;p&gt;&lt;br /&gt;                        &lt;strong&gt;Note:&lt;/strong&gt; Since your browser does not support JavaScript,&lt;br /&gt;                        you must press the Continue button once to proceed.&lt;br /&gt;                    &lt;/p&gt;&lt;br /&gt;                &lt;/noscript&gt;&lt;br /&gt;                        &lt;form method="post" action="action_pg"&gt;&lt;br /&gt;                                &lt;input type="hidden" name="username" value=&lt;%=request.getParameter("username")%&gt; /&gt;&lt;br /&gt;                                &lt;input type="hidden" name="password" value=&lt;%=request.getParameter("password")%&gt; /&gt;&lt;br /&gt;                    &lt;noscript&gt;&lt;br /&gt;                        &lt;div&gt;&lt;br /&gt;                            &lt;input type="submit" value="Continue"/&gt;&lt;br /&gt;                        &lt;/div&gt;&lt;br /&gt;                    &lt;/noscript&gt;&lt;br /&gt;                        &lt;/form&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-7083564637192380939?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/7083564637192380939/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/06/javascript-form-autosubmit.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/7083564637192380939'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/7083564637192380939'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/06/javascript-form-autosubmit.html' title='Javascript form autosubmit'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-908169283921000147</id><published>2009-06-30T08:06:00.000-07:00</published><updated>2009-06-30T08:08:14.285-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Programming'/><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><title type='text'>POST with HttpClient</title><content type='html'>An alternative way to do Http POST using &lt;a href="http://hc.apache.org/httpclient-3.x/tutorial.html"&gt;Jakarta-HttpClient&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;pre name="code" class="java"&gt;&lt;br /&gt;PostMethod post = new PostMethod("http://jakarata.apache.org/");&lt;br /&gt;        NameValuePair[] data = {&lt;br /&gt;          new NameValuePair("user", "joe"),&lt;br /&gt;          new NameValuePair("password", "bloggs")&lt;br /&gt;        };&lt;br /&gt;        post.setRequestBody(data);&lt;br /&gt;        // execute method and handle any error responses.&lt;br /&gt;        ...&lt;br /&gt;        InputStream in = post.getResponseBodyAsStream();&lt;br /&gt;        // handle response.&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-908169283921000147?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/908169283921000147/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/06/post-with-httpclient.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/908169283921000147'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/908169283921000147'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/06/post-with-httpclient.html' title='POST with HttpClient'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-1918897063754711894</id><published>2009-06-29T06:42:00.000-07:00</published><updated>2009-06-29T09:24:19.906-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><category scheme='http://www.blogger.com/atom/ns#' term='Shibboleth'/><category scheme='http://www.blogger.com/atom/ns#' term='Tomcat'/><title type='text'>Shibboleth UsernamePassword login handler</title><content type='html'>We recently switched our IdP installation from using RemoteUser login handler to the &lt;a href="https://spaces.internet2.edu/display/SHIB2/IdPAuthUserPass"&gt;UsernamePassword handler&lt;/a&gt; for authentication.  The UsernamePassword handler uses &lt;a href="http://java.sun.com/j2se/1.5.0/docs/guide/security/jaas/tutorials/index.html"&gt;jaas&lt;/a&gt; for authentication.  We're attempting to customize the default login.jsp page used by the Shibboleth IdP to our own page, this is done by recompiling the IdP with a web.xml file pointing to the new login page&lt;br /&gt;&lt;pre name="code" class="xml"&gt;&lt;br /&gt;&lt;servlet&gt;&lt;br /&gt;     &lt;servlet-name&gt;UsernamePasswordAuthHandler&lt;/servlet-name&gt;&lt;br /&gt;     &lt;servlet-class&gt;edu.internet2.middleware.shibboleth.idp.authn.provider.UsernamePasswordLoginServlet&lt;/servlet-class&gt;&lt;br /&gt;     &lt;init-param&gt;&lt;br /&gt;        &lt;param-name&gt;loginPage&lt;/param-name&gt;&lt;br /&gt;        &lt;param-value&gt;specialPages/login.jsp&lt;/param-value&gt;&lt;br /&gt;     &lt;/init-param&gt;&lt;br /&gt; &lt;/servlet&gt;&lt;br /&gt;&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-1918897063754711894?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/1918897063754711894/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/06/shibboleth-usernamepassword-login.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/1918897063754711894'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/1918897063754711894'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/06/shibboleth-usernamepassword-login.html' title='Shibboleth UsernamePassword login handler'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-6017447028964828091</id><published>2009-06-23T12:24:00.000-07:00</published><updated>2009-06-29T09:13:30.551-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Programming'/><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><title type='text'>Java HTTP POST Request</title><content type='html'>&lt;pre name="code" class="java"&gt;    public void doPost() throws Exception {&lt;br /&gt;        try {&lt;br /&gt;            // Construct data&lt;br /&gt;            String data = URLEncoder.encode("j_username", "UTF-8") + "=" + URLEncoder.encode("test", "UTF-8");&lt;br /&gt;            data += "&amp;" + URLEncoder.encode("j_password", "UTF-8") + "=" + URLEncoder.encode("test", "UTF-8");&lt;br /&gt;&lt;br /&gt;            // Send data&lt;br /&gt;            URL url = new URL("/specialpages/script.jsp");&lt;br /&gt;            URLConnection conn = url.openConnection();&lt;br /&gt;            conn.setDoOutput(true);&lt;br /&gt;            OutputStreamWriter wr = new OutputStreamWriter(conn.getOutputStream());&lt;br /&gt;            wr.write(data);&lt;br /&gt;            wr.flush();&lt;br /&gt;&lt;br /&gt;            //// Get the response&lt;br /&gt;            BufferedReader rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));&lt;br /&gt;            String line;&lt;br /&gt;            while ((line = rd.readLine()) != null) {&lt;br /&gt;                System.out.println(line);&lt;br /&gt;            }&lt;br /&gt;            wr.close();&lt;br /&gt;            rd.close();&lt;br /&gt;        } catch (Exception e) {&lt;br /&gt;        }&lt;br /&gt;&lt;br /&gt;    }&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-6017447028964828091?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/6017447028964828091/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/06/java-http-post-request-us.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/6017447028964828091'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/6017447028964828091'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/06/java-http-post-request-us.html' title='Java HTTP POST Request'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3379308617221153982.post-2998413675995364291</id><published>2009-06-22T12:32:00.001-07:00</published><updated>2009-06-22T12:32:33.733-07:00</updated><title type='text'>test</title><content type='html'>test&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3379308617221153982-2998413675995364291?l=blog.redmilitante.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.redmilitante.com/feeds/2998413675995364291/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.redmilitante.com/2009/06/test.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2998413675995364291'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3379308617221153982/posts/default/2998413675995364291'/><link rel='alternate' type='text/html' href='http://blog.redmilitante.com/2009/06/test.html' title='test'/><author><name>Red</name><uri>http://www.blogger.com/profile/14259406941405804079</uri><email>red@redmilitante.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='16931918746770280123'/></author><thr:total>0</thr:total></entry></feed>