Database Information

Database Informationhttp://mises.org/community/wikis/ideas/database-information.aspxSuggest ideas for new features and content on Mises.org and volunteer to do them.en-USCommunityServer 2008.5 SP2 (Build: 40407.4157)Database Informationhttp://mises.org/community/wikis/ideas/database-information.aspxSat, 31 Oct 2009 08:57:04 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:149David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxCurrent revision posted to Ideas for Mises.org by David V on 10/31/2009 3:57:04 AM<br /> <h2>Database Information</h2> <p><span style="text-decoration: line-through; color: red;">[</span><span style="text-decoration: line-through; color: red;">View:http://mises.org/Community/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/ideas/6813.MisesDotOrgDbScript.zip:550:0]</span><p>A backup of the Mises database with confidential data stripped out  is available here:</p> <p>Server: data.mises.org Username: miseshelp Password: miseshelp1</p> <p> </p> <p><span style="background: SpringGreen;">Complete</span> <span style="background: SpringGreen;">DB</span> <span style="background: SpringGreen;">Script</span> <span style="background: SpringGreen;">of</span> <span style="background: SpringGreen;">Mises</span> <span style="background: SpringGreen;">DB</span><span style="background: SpringGreen;">:</span></p> <p><span style="background: SpringGreen;">[</span><span style="background: SpringGreen;">View:http://mises.org/Community/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/ideas/6813.MisesDotOrgDbScript.zip:550:0]</span></p> <p> </p> <p> </p> <p><strong>Priorities</strong></p> <ul> <li><span>TagGetRelatedTags - fix this to actually find related tags based on tags/metadata/content</span> <ul> <li>More info: <a href="/Community/blogs/misestech/archive/2007/10/09/tagging.aspx">http://mises.org/Community/blogs/misestech/archive/2007/10/09/tagging.aspx</a></li> </ul> </li> <li>Diagnose persistent hangs of Mises.org (I think it may be a locking issue) <ul> <li>Contact me if you need access to Sql Activity Monitor and/or Profiler</li> </ul> </li> <li>[DailyArticleGet] - NextId and PreviousId need to get the next and previous article.  (Doesn't work right currently)</li> <li>Improve performance overall</li> <li>Security audit to prevent sql injection for dynamically generated queries  <ul> <li>(mostly for media, documents, and articles)</li> </ul> </li> <li>MySql: we have a MySql instance on Windows 2003.  We need to automate backup in Windows Scheduler for it.</li> <li>Delete old tables and sprocs</li> <li>Is there anything not done that a DBA would do with our architecture?</li> </ul> <p>Note: normally the database server is locked down by IP address whitelist.  Once we figure out who needs long-term access, I will solicit IP addresses and lock it down again.</p>Database Informationhttp://mises.org/community/wikis/ideas/database-information/revision/6.aspxSat, 31 Oct 2009 08:21:55 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:3369David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxRevision 6 posted to Ideas for Mises.org by David V on 10/31/2009 3:21:55 AM<br /> <h2>Database Information</h2> <p><span style="background: SpringGreen;">[</span><span style="background: SpringGreen;">View:http://mises.org/Community/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/ideas/6813.MisesDotOrgDbScript.zip:550:0]</span></p> <p> </p> <p>A backup of the Mises database with confidential data stripped out  is available here:</p> <p>Server: data.mises.org Username: miseshelp Password: miseshelp1</p> <p><strong>Priorities</strong></p> <ul> <li><span>TagGetRelatedTags - fix this to actually find related tags based on tags/metadata/content</span> <ul> <li>More info: <a href="/Community/blogs/misestech/archive/2007/10/09/tagging.aspx">http://mises.org/Community/blogs/misestech/archive/2007/10/09/tagging.aspx</a></li> </ul> </li> <li>Diagnose persistent hangs of Mises.org (I think it may be a locking issue) <ul> <li>Contact me if you need access to Sql Activity Monitor and/or Profiler</li> </ul> </li> <li>[DailyArticleGet] - NextId and PreviousId need to get the next and previous article.  (Doesn't work right currently)</li> <li>Improve performance overall</li> <li>Security audit to prevent sql injection for dynamically generated queries  <ul> <li>(mostly for media, documents, and articles)</li> </ul> </li> <li>MySql: we have a MySql instance on Windows 2003.  We need to automate backup in Windows Scheduler for it.</li> <li>Delete old tables and sprocs</li> <li>Is there anything not done that a DBA would do with our architecture?</li> </ul> <p>Note: normally the database server is locked down by IP address whitelist.  Once we figure out who needs long-term access, I will solicit IP addresses and lock it down again.</p>Database Informationhttp://mises.org/community/wikis/ideas/database-information/revision/5.aspxWed, 14 Oct 2009 06:29:17 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:3368David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxRevision 5 posted to Ideas for Mises.org by David V on 10/14/2009 1:29:17 AM<br /> <h2>Database Information</h2> <p>A backup of the Mises database with confidential data stripped out  is available here:</p> <p>Server: data.mises.org Username: miseshelp Password: miseshelp1</p> <p><strong>Priorities</strong></p> <ul> <li><span>TagGetRelatedTags - fix this to actually find related tags based on tags/metadata/content</span> <ul> <li>More info: <a href="/Community/blogs/misestech/archive/2007/10/09/tagging.aspx">http://mises.org/Community/blogs/misestech/archive/2007/10/09/tagging.aspx</a></li> </ul> </li> <li>Diagnose persistent hangs of Mises.org (I think it may be a locking issue) <ul> <li><span style="background: SpringGreen;">Contact</span> <span style="background: SpringGreen;">me</span> <span style="background: SpringGreen;">if</span> <span style="background: SpringGreen;">you</span> <span style="background: SpringGreen;">need</span> <span style="background: SpringGreen;">access</span> <span style="background: SpringGreen;">to</span> <span style="background: SpringGreen;">Sql</span> <span style="background: SpringGreen;">Activity</span> <span style="background: SpringGreen;">Monitor</span> <span style="background: SpringGreen;">and/or</span> <span style="background: SpringGreen;">Profiler</span></li> </ul> </li> <li>[DailyArticleGet] - NextId and PreviousId need to get the next and previous article.  (Doesn't work right currently)</li> <li>Improve performance overall</li> <li>Security <span style="text-decoration: line-through; color: red;">audio</span> <span style="background: SpringGreen;">audit</span> to prevent sql injection for dynamically generated queries  <ul> <li><span style="background: SpringGreen;">(</span><span style="background: SpringGreen;">mostly</span> <span style="background: SpringGreen;">for</span> <span style="background: SpringGreen;">media</span><span style="background: SpringGreen;">,</span> <span style="background: SpringGreen;">documents</span><span style="background: SpringGreen;">,</span> <span style="background: SpringGreen;">and</span> <span style="background: SpringGreen;">articles</span><span style="background: SpringGreen;">)</span></li> </ul> </li> <li>MySql: we have a MySql instance on Windows 2003.  We need to automate backup in Windows Scheduler for it<span style="background: SpringGreen;">.</span></li> <li><span style="background: SpringGreen;">Delete</span> <span style="background: SpringGreen;">old</span> <span style="background: SpringGreen;">tables</span> <span style="background: SpringGreen;">and</span> <span style="background: SpringGreen;">sprocs</span></li> <li><span style="background: SpringGreen;">Is</span> <span style="background: SpringGreen;">there</span> <span style="background: SpringGreen;">anything</span> <span style="background: SpringGreen;">not</span> <span style="background: SpringGreen;">done</span> <span style="background: SpringGreen;">that</span> <span style="background: SpringGreen;">a</span> <span style="background: SpringGreen;">DBA</span> <span style="background: SpringGreen;">would</span> <span style="background: SpringGreen;">do</span> <span style="background: SpringGreen;">with</span> <span style="background: SpringGreen;">our</span> <span style="background: SpringGreen;">architecture</span><span style="background: SpringGreen;">?</span></li> </ul> <p><span style="background: SpringGreen;">Note</span><span style="background: SpringGreen;">:</span> <span style="background: SpringGreen;">normally</span> <span style="background: SpringGreen;">the</span> <span style="background: SpringGreen;">database</span> <span style="background: SpringGreen;">server</span> <span style="background: SpringGreen;">is</span> <span style="background: SpringGreen;">locked</span> <span style="background: SpringGreen;">down</span> <span style="background: SpringGreen;">by</span> <span style="background: SpringGreen;">IP</span> <span style="background: SpringGreen;">address</span> <span style="background: SpringGreen;">whitelist</span><span style="background: SpringGreen;">.</span>  <span style="background: SpringGreen;">Once</span> <span style="background: SpringGreen;">we</span> <span style="background: SpringGreen;">figure</span> <span style="background: SpringGreen;">out</span> <span style="background: SpringGreen;">who</span> <span style="background: SpringGreen;">needs</span> <span style="background: SpringGreen;">long-term</span> <span style="background: SpringGreen;">access</span><span style="background: SpringGreen;">,</span> <span style="background: SpringGreen;">I</span> <span style="background: SpringGreen;">will</span> <span style="background: SpringGreen;">solicit</span> <span style="background: SpringGreen;">IP</span> <span style="background: SpringGreen;">addresses</span> <span style="background: SpringGreen;">and</span> <span style="background: SpringGreen;">lock</span> <span style="background: SpringGreen;">it</span> <span style="background: SpringGreen;">down</span> <span style="background: SpringGreen;">again</span>.</p>Database Informationhttp://mises.org/community/wikis/ideas/database-information/revision/4.aspxWed, 14 Oct 2009 05:56:44 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:3170David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxRevision 4 posted to Ideas for Mises.org by David V on 10/14/2009 12:56:44 AM<br /> <h2>Database Information</h2> <p>A backup of the Mises database with confidential data stripped out  is available here:</p> <p>Server: data.mises.org Username: miseshelp Password: miseshelp1</p> <p><strong>Priorities</strong></p> <p> </p> <ul> <li><span>TagGetRelatedTags - fix this to actually find related tags based on tags/metadata/content</span> <ul> <li>More info: <a href="/Community/blogs/misestech/archive/2007/10/09/tagging.aspx">http://mises.org/Community/blogs/misestech/archive/2007/10/09/tagging.aspx</a></li> </ul> </li> <li>Diagnose persistent hangs of Mises.org (I think it may be a locking issue)</li> <li>[DailyArticleGet] - NextId and PreviousId need to get the next and previous article.  (Doesn't work right currently)</li> <li>Improve performance overall</li> <li>Security audio to prevent sql injection for dynamically generated queries</li> <li><span style="background: SpringGreen;">MySql</span><span style="background: SpringGreen;">:</span> <span style="background: SpringGreen;">we</span> <span style="background: SpringGreen;">have</span> <span style="background: SpringGreen;">a</span> <span style="background: SpringGreen;">MySql</span> <span style="background: SpringGreen;">instance</span> <span style="background: SpringGreen;">on</span> <span style="background: SpringGreen;">Windows</span> <span style="background: SpringGreen;">2003</span><span style="background: SpringGreen;">.</span>  <span style="background: SpringGreen;">We</span> <span style="background: SpringGreen;">need</span> <span style="background: SpringGreen;">to</span> <span style="background: SpringGreen;">automate</span> <span style="background: SpringGreen;">backup</span> <span style="background: SpringGreen;">in</span> <span style="background: SpringGreen;">Windows</span> <span style="background: SpringGreen;">Scheduler</span> <span style="background: SpringGreen;">for</span> <span style="background: SpringGreen;">it</span><span style="background: SpringGreen;">.</span></li> </ul> <p> </p>Database Informationhttp://mises.org/community/wikis/ideas/database-information/revision/3.aspxWed, 14 Oct 2009 05:52:25 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:3169David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxRevision 3 posted to Ideas for Mises.org by David V on 10/14/2009 12:52:25 AM<br /> <h2>Database Information</h2> <p><span style="background: SpringGreen;">A</span> <span style="background: SpringGreen;">backup</span> <span style="background: SpringGreen;">of</span> <span style="background: SpringGreen;">the</span> <span style="background: SpringGreen;">Mises</span> <span style="background: SpringGreen;">database</span> <span style="background: SpringGreen;">with</span> <span style="background: SpringGreen;">confidential</span> <span style="background: SpringGreen;">data</span> <span style="background: SpringGreen;">stripped</span> <span style="background: SpringGreen;">out</span>  <span style="background: SpringGreen;">is</span> <span style="background: SpringGreen;">available</span> <span style="background: SpringGreen;">here</span><span style="background: SpringGreen;">:</span></p> <p>Server: data.mises.org Username: miseshelp Password: miseshelp1</p> <p><b><span style="background: SpringGreen;">Priorities</span></b></p> <p> <ul> <li><span><span style="background: SpringGreen;">TagGetRelatedTags</span> <span style="background: SpringGreen;">-</span> <span style="background: SpringGreen;">fix</span> <span style="background: SpringGreen;">this</span> <span style="background: SpringGreen;">to</span> <span style="background: SpringGreen;">actually</span> <span style="background: SpringGreen;">find</span> <span style="background: SpringGreen;">related</span> <span style="background: SpringGreen;">tags</span> <span style="background: SpringGreen;">based</span> <span style="background: SpringGreen;">on</span> <span style="background: SpringGreen;">tags/metadata/content</span></span> <ul> <li><span style="background: SpringGreen;">More</span> <span style="background: SpringGreen;">info</span><span style="background: SpringGreen;">:</span> <a href="http://mises.org/Community/blogs/misestech/archive/2007/10/09/tagging.aspx"><span style="background: SpringGreen;">http://mises.org/Community/blogs/misestech/archive/2007/10/09/tagging.aspx</span></a></li> </ul> </li> <li><span style="background: SpringGreen;">Diagnose</span> <span style="background: SpringGreen;">persistent</span> <span style="background: SpringGreen;">hangs</span> <span style="background: SpringGreen;">of</span> <span style="background: SpringGreen;">Mises.org</span> <span style="background: SpringGreen;">(</span><span style="background: SpringGreen;">I</span> <span style="background: SpringGreen;">think</span> <span style="background: SpringGreen;">it</span> <span style="background: SpringGreen;">may</span> <span style="background: SpringGreen;">be</span> <span style="background: SpringGreen;">a</span> <span style="background: SpringGreen;">locking</span> <span style="background: SpringGreen;">issue</span><span style="background: SpringGreen;">)</span></li> <li><span style="background: SpringGreen;">[</span><span style="background: SpringGreen;">DailyArticleGet]</span> <span style="background: SpringGreen;">-</span> <span style="background: SpringGreen;">NextId</span> <span style="background: SpringGreen;">and</span> <span style="background: SpringGreen;">PreviousId</span> <span style="background: SpringGreen;">need</span> <span style="background: SpringGreen;">to</span> <span style="background: SpringGreen;">get</span> <span style="background: SpringGreen;">the</span> <span style="background: SpringGreen;">next</span> <span style="background: SpringGreen;">and</span> <span style="background: SpringGreen;">previous</span> <span style="background: SpringGreen;">article</span><span style="background: SpringGreen;">.</span>  <span style="background: SpringGreen;">(</span><span style="background: SpringGreen;">Doesn</span><span style="background: SpringGreen;">'</span><span style="background: SpringGreen;">t</span> <span style="background: SpringGreen;">work</span> <span style="background: SpringGreen;">right</span> <span style="background: SpringGreen;">currently</span><span style="background: SpringGreen;">)</span></li> <li><span style="background: SpringGreen;">Improve</span> <span style="background: SpringGreen;">performance</span> <span style="background: SpringGreen;">overall</span></li> <li><span style="background: SpringGreen;">Security</span> <span style="background: SpringGreen;">audio</span> <span style="background: SpringGreen;">to</span> <span style="background: SpringGreen;">prevent</span> <span style="background: SpringGreen;">sql</span> <span style="background: SpringGreen;">injection</span> <span style="background: SpringGreen;">for</span> <span style="background: SpringGreen;">dynamically</span> <span style="background: SpringGreen;">generated</span> <span style="background: SpringGreen;">queries</span></li> </ul> </p>Database Informationhttp://mises.org/community/wikis/ideas/database-information/revision/2.aspxWed, 14 Oct 2009 05:26:44 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:3168David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxRevision 2 posted to Ideas for Mises.org by David V on 10/14/2009 12:26:44 AM<br /> <h2>Database Information</h2> <p><span style="text-decoration: line-through; color: red;">The</span><p><span style="background: SpringGreen;">Server</span><span style="background: SpringGreen;">:</span> <span style="background: SpringGreen;">data.mises.org</span></p> <p><span style="background: SpringGreen;">Username</span><span style="background: SpringGreen;">:</span> <span style="background: SpringGreen;">miseshelp</span></p> <p><span style="background: SpringGreen;">Password</span><span style="background: SpringGreen;">:</span> <span style="background: SpringGreen;">miseshelp1</span></p>Database Informationhttp://mises.org/community/wikis/ideas/database-information/revision/1.aspxWed, 14 Oct 2009 04:42:56 GMT944abf2b-d1be-4bf2-990d-438cb0e377e9:3167David Vhttp://mises.org/community/wikis/ideas/database-information/comments.aspxRevision 1 posted to Ideas for Mises.org by David V on 10/13/2009 11:42:56 PM<br /> <p>The </p>