{"id":87,"date":"2008-12-31T15:56:02","date_gmt":"2008-12-31T20:56:02","guid":{"rendered":"http:\/\/blog.paymentconsulting.net\/?p=87"},"modified":"2008-12-31T15:58:07","modified_gmt":"2008-12-31T20:58:07","slug":"important-security-info-for-your-it-department-from-usssfbi","status":"publish","type":"post","link":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/?p=87","title":{"rendered":"important security info for your IT department from USSS\/FBI"},"content":{"rendered":"<p>Hi,<\/p>\n<p>IFor those of you with computer networks\/systems in case your IT department isn&#8217;t aware. (attached)<\/p>\n<p>Bill<br \/>\n*** Joint USSS\/FBI Advisory ***<br \/>\nPREVENTIVE MEASURES<br \/>\nOver the past year, there has been a considerable spike in cyber attacks against the financial services and the online retail industry. There are a number of actions a firm can take in order to prevent or thwart the specific attacks and techniques used by these intruders. The following steps can be taken to reduce the likelihood of a similar compromise while improving an organization&#8217;s ability to detect and respond to similar incidents quickly and thoroughly.<br \/>\nAttacker Methodology:<br \/>\nIn general, the attackers perform the following activities on the networks they compromise: <\/p>\n<p>1.<br \/>\nThey identify Web sites that are vulnerable to SQL injection. They appear to target MSSQL only. <\/p>\n<p>2.<br \/>\nThey use &#8220;xp_cmdshell&#8221;, an extended procedure installed by default on MSSQL, to download their hacker tools to the compromised MSSQL server. <\/p>\n<p>3.<br \/>\nThey obtain valid Windows credentials by using fgdump or a similar tool. <\/p>\n<p>4.<br \/>\nThey install network &#8220;sniffers&#8221; to identify card data and systems involved in processing credit card transactions. <\/p>\n<p>5.<br \/>\nThey install backdoors that &#8220;beacon&#8221; periodically to their command and control servers, allowing surreptitious access to the compromised networks. <\/p>\n<p>6.<br \/>\nThey target databases, Hardware Security Modules (HSMs), and processing applications in an effort to obtain credit card data or brute-force ATM PINs. <\/p>\n<p>7.<br \/>\nThey use WinRAR to compress the information they pilfer from the compromised networks. <\/p>\n<p>We are providing the following preventive measures. Performing these steps may not prevent the intruders from gaining access, but they will severely impact their effectiveness based on current attack methods.<br \/>\nRecommendation 1: Disable potentially harmful SQL stored procedure calls.<br \/>\nThe xp_cmdshell, OPENROWSET, and OPENDATASOURCE stored procedures should be disabled on all databases unless they are explicitly serving a business need within the network.<br \/>\nThe xp_cmdshell procedure allows someone to execute commands on a local system from the database, with the permissions of the service account used for the database. The OPENROWSET and OPENDATASOURCE procedures allow one to cause the database to transfer data from the local database to a remote database and vice versa.<br \/>\nThe following two steps should be taken to remove the potentially harmful stored procedure calls. <\/p>\n<p>1.<br \/>\nDisable access to the xp_cmdshell functions within Microsoft SQL Server. <\/p>\n<p>Microsoft SQL Server 2000<br \/>\nxp_cmdshell&#8217;<br \/>\nEXEC sp_dropextendedproc &#8216;Microsoft SQL Server 2005<br \/>\nEXEC sp_configure &#8216;xp_cmdshell&#8217;, 0 <\/p>\n<p>2.<br \/>\nRemove the &#8220;xplog70.dll&#8221; file from the server. <\/p>\n<p>If it is necessary to use the potentially harmful stored procedure calls, limit the exposure by applying IP filters on the SQL servers. Assign explicit ALLOW rules to the interfaces for the application the SQL server is supporting. Disallow communication between SQL Server hosts unless an application necessitates otherwise.<br \/>\nRecommendation 2: Deny extended URLs.<br \/>\nExcessively long URLs can be sent to Microsoft IIS servers, causing the server to fail to log the complete request. Unless specific applications require long URLs, set a limit of 2048 characters. Microsoft IIS will process requests over 4096 bytes long, but will not place the contents of the request in the log files. This has become an effective means to evade detection while performing attacks. <\/p>\n<p>1.<br \/>\nModify &#8220;%windir%system32inetsrvurlscanurlscan.ini&#8221; <\/p>\n<p>Ensure &#8220;MaxQueryString=2048&#8221; is present <\/p>\n<p>Ensure &#8220;LogLongUrls=1&#8221; is present <\/p>\n<p>Recommendation 3: Implement specific approaches to secure dynamic web site content.<br \/>\nCertain measures can be taken to mitigate the risk of these types of attacks by developing a secure code base. The steps below are a few of the best practices for secure coding that will help prevent the attack associated with this incident. Additional information can be found at http:\/\/msdn2.microsoft.com\/en-us\/library\/ms998271.aspx. <\/p>\n<p>1.<br \/>\nReplace escape sequences <\/p>\n<p>private string SafeSqlLiteral(string inputSQL)<br \/>\n{<br \/>\ninputSQL.Replace(&#8220;&#8216;&#8221;, &#8220;&#8221;&#8221;);<br \/>\n} <\/p>\n<p>2.<br \/>\nUse parameters with stored procedures <\/p>\n<p>using (SqlConnection connection = new SqlConnection(connectionString))<br \/>\n{<br \/>\nDataSet userDataset = new DataSet();<br \/>\nSqlDataAdapter myDataAdapter = new SqlDataAdapter(<br \/>\n&#8220;SELECT au_lname, au_fname FROM Authors WHERE au_id = @au_id&#8221;,<br \/>\nconnection);<br \/>\nmyCommand.SelectCommand.Parameters.Add(&#8220;@au_id&#8221;, SqlDbType.VarChar, 11);<br \/>\nmyCommand.SelectCommand.Parameters[&#8220;@au_id&#8221;].Value = SSN.Text;<br \/>\nmyDataAdapter.Fill(userDataset);<br \/>\n} <\/p>\n<p>3.<br \/>\nConstrain input in ASP.NET web pages <\/p>\n<p>if (!Regex.IsMatch(userIDTxt.Text, @&#8221;^[a-zA-Z&#8217;.\/s]{1,40}$&#8221;))<br \/>\nthrow new FormatException(&#8220;Invalid name format&#8221;);<br \/>\nRecommendation 4: Install and run authorized Microsoft SQL Server and IIS services under a non-privileged account.<br \/>\nUnless a specific application requires system or administrative level permissions, all instances of Microsoft SQL Server and IIS should run under accounts with restricted user permissions.<br \/>\nRecommendation 5: Apply the principle of &#8216;least privilege&#8217; on all SQL machine accounts.<br \/>\nThe attackers generally create tables into which they store malware or data collected from the enterprise. Unless specific applications dictate otherwise, restrict the capabilities of the accounts used to modify databases on the servers. In particular, remove the ability to create new tables, denying the attackers a means of transporting malware and stolen data.<br \/>\nRecommendation 6: Require the use of a password on Microsoft SQL Server administrator, user, and machine accounts.<br \/>\nSeveral SQL servers examined had an empty password on the &#8220;sa&#8221; SQL account. All accounts with access to resources should be protected with passwords or certificates.<br \/>\nRecommendation 7: Lock out accounts on the mainframes after several unsuccessful logon attempts.<br \/>\nLocking accounts and requiring IT support to restore service aids in protection against brute force attacks. This can serve as an early detection of potential security problems.<br \/>\nRecommendation 8: Run the minimum required applications and services on servers necessary to perform their intended function.<br \/>\nSeveral servers, to include Active Directory master servers, have unnecessary software installed (e.g. Microsoft Office). In addition, ensure that no unnecessary services are running. This includes SQL Server and SQL Server Express on support and other workstations. Should these services be necessary, restrict access through IP filters on Microsoft Windows or through third-party firewall software.<br \/>\nRecommendation 9: Deny access to the Internet except through proxies for Store and Enterprise servers and workstations.<br \/>\nAttacks on victim networks make extensive use of HTTP, HTTPS, and DNS network ports. Denying direct access to the Internet will frustrate and mislead an attacker.<br \/>\nRecommendation 10: Implement firewall rules to block or restrict Internet and intranet access for database systems.<br \/>\nDisallow all traffic outbound from servers harboring sensitive data. Communication to the SQL servers and data warehousing servers should be tightly controlled. Restrict traffic between data centers and stores to essential ports and services only.<br \/>\nRecommendation 11: Implement firewall rules to block known malicious IP addresses.<br \/>\nFirewall rule sets designed to block all ingress (incoming) and egress (outgoing) traffic to the known malicious IP addresses have been put in place. Note that traffic violating the rules should be logged and observed in near-real time.<br \/>\nRecommendation 12: Ensure your HSM systems are not responsive to any commands which generate encrypted pin blocks. More specifically, HSMs should not accept commands that allow plain text PINs as an argument and respond with encrypted PIN blocks.<br \/>\nHSMs are normally used to verify Personal Identification Numbers (PINs), generate PINs used with bank accounts and credit cards, generate encrypted Card Verification Values (CVVs), generate keys for Electronic Funds Transfer Point of Sale systems (EFTPOS), and generating and verifying Message Authorization Codes (MACs). These systems, if accessed by an unauthorized intruder, can provide the attacker the ability to discover the appropriate PIN number for a corresponding credit or debit card. Therefore, in an effort to prevent this, HSMs should be configured to disallow &#8220;in the clear&#8221; PINs as an argument for performing its tasks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, IFor those of you with computer networks\/systems in case your IT department isn&#8217;t aware. (attached) Bill *** Joint USSS\/FBI Advisory *** PREVENTIVE MEASURES Over the past year, there has been a considerable spike in cyber attacks against the financial services and the online retail industry. There are a number of actions a firm can &hellip; <a href=\"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/?p=87\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">important security info for your IT department from USSS\/FBI<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[5],"class_list":["post-87","post","type-post","status-publish","format-standard","hentry","category-news-update","tag-business-advice"],"_links":{"self":[{"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/87","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=87"}],"version-history":[{"count":1,"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/87\/revisions"}],"predecessor-version":[{"id":88,"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/87\/revisions\/88"}],"wp:attachment":[{"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=87"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=87"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.paymentconsulting.net\/Blog\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}