Пример #1
0
        /// <summary>
        /// For an invalid request, returns a HTML-formatted error page with the details of the request and the error
        /// </summary>
        public static string GetInvalidRequestDebugPage(string requestPath, DadConfiguration dadConfig)
        {
            StringBuilder page = new StringBuilder();

            page.Append("<style> body { font-family: verdana, sans-serif; } p { font-size: 9pt; } div.errormsg { border: 1px double black; background-color: gold; font-family: lucida console, courier; font-size: 14pt; padding: 10px; width: 85%; } div.code { border: 1px dotted black; font-family: lucida console, courier; font-size: 14pt; padding: 10px; } </style>");
            page.AppendFormat("<h1>Thoth Gateway Invalid Request</h1>");

            page.AppendFormat("<p>The request is invalid. Please check the URL syntax, and examine the inclusion and exclusion lists.</p>");

            page.AppendFormat("<h3>Request</h3><div class='code'>{0}</div>", requestPath);

            page.AppendFormat("<h3>Inclusion List</h3><div class='code'>{0}</div>", dadConfig.InclusionList);

            page.AppendFormat("<h3>Exclusion List</h3><div class='code'>{0}</div>", DadConfiguration.DEFAULT_EXCLUSION_LIST + " " + dadConfig.ExclusionList);

            page.Append(GetSignature());

            return(page.ToString());
        }
Пример #2
0
        private void ParseRequest(string requestMethod, string thePath, string rawUrl, string soapAction)
        {
            string requestPath = thePath.Substring(1);

            DadSpecifiedInRequest = true;
            IsFlexibleParams      = false;
            IsPathAlias           = false;

            string[] pathElements = requestPath.Split('/');

            if (pathElements.Length >= 2)
            {
                ModuleName = pathElements[0];
                DadName    = pathElements[1];

                if (DadName.Length == 0 || !DadConfiguration.IsValidDad(DadName))
                {
                    DadSpecifiedInRequest = false;
                    DadName = DadConfiguration.DefaultDad;
                }

                // get dad-specific configuration settings
                DadConfig = new DadConfiguration(DadName);

                if (pathElements.Length >= 3)
                {
                    ProcName = pathElements[2];
                    if (ProcName.Length > 0)
                    {
                        if (ProcName.Substring(0, 1) == "!")
                        {
                            IsFlexibleParams = true;
                        }
                        else if (ProcName == DadConfig.PathAlias)
                        {
                            IsPathAlias    = true;
                            PathAliasValue = GetAliasValue(ProcName, thePath);
                        }
                        else if (ProcName == DadConfig.XdbAlias)
                        {
                            IsXdbAlias    = true;
                            XdbAliasValue = GetAliasValue(ProcName, thePath);
                        }
                        else if (ProcName == DadConfig.DocumentPath)
                        {
                            IsDocumentPath = true;
                        }
                    }
                }
                else
                {
                    // missing trailing slash in request
                    ProcName = "";
                }

                if (ProcName.Length == 0)
                {
                    ProcName = DadConfig.DefaultPage;
                }

                if (DadConfig.InvocationProtocol == DadConfiguration.INVOCATION_PROTOCOL_SOAP)
                {
                    IsSoapRequest = true;
                    IsWsdlRequest = requestMethod.ToUpper() == "GET" && rawUrl.ToLower().EndsWith("?wsdl");
                }

                if (IsSoapRequest && !IsWsdlRequest)
                {
                    // get the procedure name from the SOAPAction header
                    string methodName = soapAction.Replace("\"", "");
                    methodName = methodName.Substring(methodName.LastIndexOf("/") + 1);
                    ProcName   = ProcName + "." + StringUtil.ReversePrettyStr(methodName);
                }

                ProcName = SanitizeProcName(ProcName, DadConfig.ExclusionList);
            }
            else
            {
                ModuleName = "";
                DadName    = "";
                ProcName   = "";
            }

            if (DadName.Length > 0 && ProcName.Length > 0)
            {
                string[] urlProcElements = ProcName.Split('.');

                if (urlProcElements.Length == 3)
                {
                    // schema, package and procedure specified
                    OraSchema  = urlProcElements[0];
                    OraPackage = urlProcElements[1];
                    OraProc    = urlProcElements[2];
                }
                else if (urlProcElements.Length == 2)
                {
                    // assume package and procedure specified (although it could also be schema and procedure, but there is no way to be certain)
                    OraSchema  = "";
                    OraPackage = urlProcElements[0];
                    OraProc    = urlProcElements[1];
                }
                else
                {
                    // just the procedure is specified
                    OraSchema  = "";
                    OraPackage = "";
                    OraProc    = ProcName;
                }

                logger.Debug("Parsed module = " + ModuleName + ", dad = " + DadName + ", proc = " + ProcName);
            }
        }
Пример #3
0
        public OracleInterface(GatewayRequest req, OracleParameterCache opc)
        {
            _dadName   = req.DadName;
            _dadConfig = req.DadConfig;
            _opc       = opc;

            string dbUsername = _dadConfig.DatabaseUserName;
            string dbPassword = _dadConfig.DatabasePassword;

            // Integrated Windows Authentication (use in combination with Oracle proxy authentication)
            if (dbUsername == "LOGON_USER")
            {
                dbUsername = req.WindowsUsername;
                // if username contains backslash (domain\user), add double quotes to username
                if (dbUsername.IndexOf("\\") > -1)
                {
                    dbUsername = "******"" + dbUsername + "\"";
                }
            }

            if (dbUsername == "LOGON_USER_NO_DOMAIN")
            {
                dbUsername = req.WindowsUsernameNoDomain;
            }

            // for connection string attributes, see http://download.oracle.com/docs/html/E15167_01/featConnecting.htm#i1006259
            _connStr = "User Id=" + dbUsername + ";Password="******";Data Source=" + _dadConfig.DatabaseConnectString + ";" + _dadConfig.DatabaseConnectStringAttributes;

            // careful with this one, it will expose the passwords in the log
            // use it just for additional debugging during development
            // logger.Debug("Connection string: " + _connStr);

            // Connect to Oracle
            if (logger.IsDebugEnabled)
            {
                logger.Debug("Connecting with user " + dbUsername + " to " + _dadConfig.DatabaseConnectString + "...");
            }

            _conn = new OracleConnection(_connStr);

            try
            {
                _conn.Open();
                _connected = true;
                if (logger.IsDebugEnabled)
                {
                    logger.Debug("Connected to Oracle " + _conn.ServerVersion);
                }
            }
            catch (OracleException e)
            {
                _lastError = e.Message;
                logger.Error("Failed to connect to database: " + e.Message);
            }

            if (_connected)
            {
                _txn = _conn.BeginTransaction();

                // setup National Language Support (NLS)

                string sql = "alter session set nls_language='" + _dadConfig.NLSLanguage + "' nls_territory='" + _dadConfig.NLSTerritory + "'";
                ExecuteSQL(sql, new ArrayList());

                //OracleGlobalization glb = OracleGlobalization.GetThreadInfo();
                //logger.Debug ("ODP.NET Client Character Set: " + glb.ClientCharacterSet);

                // ensure a stateless environment by resetting package state
                sql = "begin dbms_session.modify_package_state(dbms_session.reinitialize); end;";
                ExecuteSQL(sql, new ArrayList());

                if (_dadConfig.InvocationProtocol == DadConfiguration.INVOCATION_PROTOCOL_SOAP)
                {
                    // use SOAP date encoding
                    sql = "alter session set nls_date_format = '" + _dadConfig.SoapDateFormat + "'";
                    ExecuteSQL(sql, new ArrayList());
                }
            }
        }