Edgecast Rules based on Hostname or IP Address, only if you have a common naming convention for the Directory Name, for example:
prefix1_example.net
prefix2_example.org
You can then create a rule:
IF ‘URL Path Directory’ ‘Matches’ Value:
/123456/prefix1_* (I used 123456 in place of the CDN origin path, update this to your settings) ‘Ignore Case’, ‘Relative To’:’Root’
then you can group by prefix on folder name, and have rules for them that way.
Sometimes you want to move a database between hosts, this is an easy way to cut down on the clutter created in the process, is to output the backup directly to the new host.
|
1 |
mysqldump -uExapmleUser -pExapmlePass -hExapmleHostNameOrIp ExapmleDatabaseName | mysql -uExapmleUser -pExapmlePass -hExapmleHostNameOrIp ExapmleDatabaseName |
/Admin/Defaults/frmSiteDefaults.aspx
The page or resource that you are accessing is unavailable or an error has occurred.
This error occurred at 11/8/2012 11:00:16 AM and has been logged.
In my Event viewer I saw this error:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/8/2012 11:00:16 AM
Event time (UTC): 11/8/2012 4:00:16 PM
Event ID: 12ca4076f62c476eab139235f1d047bc
Event sequence: 26
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: 8bad665c-1-129968638742097055
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files (x86)\SmarterTools\SmarterStats\MRS\
Machine name: HaHaMachineName
Process information:
Process ID: 2572
Process name: SSWebSvr.exe
Account name: NT AUTHORITY\SYSTEM
Exception information:
Exception type: Exception
Exception message: There was a problem retrieving the information from the remote web server. Please contact support.
at SSWeb.HelperClasses.ServiceCommunication.GetSeoSearchEngines(Int32 serverId)
at SSWeb.UserControls.SiteSeoSearchEngineSettings.PopulateList(Int32 serverId)
at SSWeb.UserControls.SiteSeoSearchEngineSettings.LoadDefaultSettings(Int32 serverId, ConfigSettings settings)
at SSWeb.Admin.Defaults.frmSiteDefaults.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at SSWeb.HelperClasses.CustomPage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Request information:
Request URL: http://localhost:9999/Admin/Defaults/frmSiteDefaults.aspx
Request path: /Admin/Defaults/frmSiteDefaults.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\SYSTEM
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\SYSTEM
Is impersonating: False
Stack trace: at SSWeb.HelperClasses.ServiceCommunication.GetSeoSearchEngines(Int32 serverId)
at SSWeb.UserControls.SiteSeoSearchEngineSettings.PopulateList(Int32 serverId)
at SSWeb.UserControls.SiteSeoSearchEngineSettings.LoadDefaultSettings(Int32 serverId, ConfigSettings settings)
at SSWeb.Admin.Defaults.frmSiteDefaults.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at SSWeb.HelperClasses.CustomPage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
Soo, I tracked this down to what seems to be a bug with the latest installer as of version SmarterStats 7.6.4682. http://forums.smartertools.com/showthread.php/33031-An-error-occurred-while-loading-the-configuration-settings
As best as I can tell, SmarterTools describes this as:
FIXED: Configuring the Included Web Server to listen on All IP Addresses will now function correctly.
This is found in SmarterStats 7 Release Notes. The update was released on 2012-11-08.
Slash versus Backslash, I saw this image, after googling,
Make sure you give the user sufficient permissions to the DB they are being given access to, typically being db_datareader, db_datawriter, db_ddladmin, and public.
There is also a SQL statement you can run:
|
1 2 3 4 5 6 7 8 9 10 |
CREATE LOGIN [user] WITH PASSWORD='password', DEFAULT_DATABASE=[your_db], CHECK_POLICY=OFF GO CREATE USER [user] FOR LOGIN [user] EXEC sp_addrolemember N'db_datareader', N'your_db' EXEC sp_addrolemember N'db_datawriter', N'your_db' EXEC sp_addrolemember N'db_ddladmin', N'your_db' EXEC sp_addrolemember N'public', N'your_db' GO |
I have not tested this script, use at your own risk. In my example, I give the last two roles that seem to be not included in scripts mentioned on other sites.
A friend pointed me to this as an option, when trying to find out exactly what is going on with apache, you can run this:
|
1 |
ps auxw | egrep "sbin/apache|httpd" | awk '{print"-p " $2}' | xargs strace |
“This one-liner will use strace to attach to all of the currently running apache processes output and piped from the initial “ps auxw” command into some awk.” This has been rewritten to make it a little more flexible with finding the running process, as the original only searched for sbin/apache, and on my server, apache is run from an odd location.
I originally read about this script here. Decided to include the script below:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 |
#!/usr/bin/php <? /* This script takes a config file from WS_FTP (WS_FTP.ini) and converts it to filezilla format Version 1.0 Author: Andrew Kerr (andrew@arrkerr.com) Credit is given where due in the function headers I make no claims about this program, use it at your own risk. If for some reason anything in this script violates any rules on the part of wsftp or filezilla, please do not use it and let me know so that I can remove it. */ if ($argc != 2) { die("Usage: ". $argv[0] ." <wsftp config file>\n"); } $inFile = $argv[1]; $outFile = "FileZilla.xml"; // open up the input file if (!$inFH = fopen($inFile, "r")) { die("Unable to open the wsftp config file\n"); } // open up the output file if (!$outFH = fopen($outFile, 'w')) { die("Unable to open the wsftp config file\n"); } // a variable to keep track of if we're working on the very first host or not $firstHost = true; // print the config file header printHeader($outFH); // loop through the file one line at a time while ($currentLine = fgets($inFH)) { // check for an empty line if (strLen($currentLine) > 1) { // if the line starts with a [ then it is a new site, and a new site name if (substr($currentLine,0,1) == "[") { if ($firstHost == false) { //write out the site config writeSite($siteName, $hostName, $userName, $password, $remoteDir, $passive, $outFH); } $firstHost = false; $siteName = ltrim(trim(rtrim($currentLine), "\]"), "\["); } // otherwise it is a parameter to a previous site name else { // seperate the paramter from the value list($param, $val) = split("=", $currentLine, 2); switch ($param) { case "HOST": $hostName = chop($val); break; case "rdir0": $remoteDir = chop($val); break; case "UID": $userName = chop($val); break; case "PWD": $password = encryptFilezilla(decryptWSFTP("PWD=" . chop($val))); break; case "PASVMODE": $passive = chop($val); break; } } } } // write out the last site once we hit the end of the file if ($firstHost == false) { //write out the site config writeSite($siteName, $hostName, $userName, $password, $remoteDir, $passive, $outFH); } // print the footer printFooter($outFH); // close the input and output files fclose($inFH); fclose($outFH); /* Write the filezilla site config */ function writeSite($siteName, $hostName, $userName, $password, $remoteDir, $passive, $outFH) { if (($passive != 0) && ($passive != 1)) { // If PASVMODE was blank in the WS_FTP config (which it wouldn't ever be?) set it to 0 // 0 in FileZilla is "default" $passive = 0; } if ($passive = 0) { // WS_FTP uses 0 for active, FileZilla uses 2 $passive = 2; } // $passive=2; // if you need to convert everything to active (I did because of our firewall) fwrite($outFH, '<Site Name="' . $siteName . '" Host="' . $hostName . '" Port="21" User="' . $userName . '" Account="" RemoteDir='. $remoteDir .' LocalDir="" Pass="' . $password . '" Logontype="1" FWBypass="0" DontSavePass="0" ServerType="" PasvMode="' . $passive . '" TimeZoneOffset="0" TimeZoneOffsetMinutes="0" Comments="" UTF8="0" DefaultSite="0" />' . "\n"); } /* Convert the ws_ftp password to plain-text Converted from the javascript version at: http://www.tele-pro.co.uk/software/ws%5Fftp%5Fpass/ */ function decryptWSFTP($str) { $out = ""; $pw = substr($str, 37, strlen($str)); for ($i=0; $i<(strlen($pw)/2); $i++) { $character = substr($pw, $i*2, 2); $sal = substr($str, 5+$i, 1); $claro = ("0x". $character)-$i-1-((47+parseInt("0x" . $sal))%57); $out = $out . chr($claro); } return $out; } /* php version of the javascript parseInt() function that convers an int to a char */ function parseInt($data) { return intval(substr($data,0,8),16); } /* Convert a plain-text password to filezilla format Based on a version from http://www.sourceshock.com/details_snippet/39/ */ function encryptFilezilla($str) { $encryptionKey = "FILEZILLA1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"; $pos = strlen($str) % strlen($encryptionKey); $ret = ""; for ($i=0; $i<strlen($str); $i++) { $x = sprintf("%s",$str[$i] ^ $encryptionKey[($i + $pos) % strlen($encryptionKey)]); if (preg_match("/[^a-z]/",$str[$i])) { $min = 3 - strlen(ord($x)); $z = str_repeat('0',$min) . ord($x); } else { $z = "0" . ord($x); } $ret .= $z; } return $ret; } /* Print the filezilla config file footer */ function printFooter($outFH) { fwrite($outFH, '</Sites>' . "\n" . '<Settings>' . "\n" . '</Settings>' . "\n" . '<RecentServers/>' . "\n" . '</FileZilla>' . "\n"); } /* Print the filezilla config file header */ function printHeader($outFH) { fwrite($outFH, '<?xml version="1.0" encoding="ISO-8859-1"?>' . "\n" . '<FileZilla>'. "\n" . '<Sites>'. "\n"); } ?> |
Windows Vista, 7, Server 2008, 2008 R2 and newer Windows operating systems do not allow a user that is NOT the local Administrator access to the UNC location of c$ as it is considered an administrative share. This is a security within UAC (That I recommend leaving intact, I like security). Wiki makes mention of re enabling the access here. There is mention of this in a answer page on Microsoft here. A workaround is to create a folder and share that, then from the second machine UNC to \\hostname\sharename replacing ‘hostname’ with the hostname or IP and replacing ‘sharename’ with the name of the share created. I failed to realize this right away and was trying to connect to \\hostname\c$\sharename unsuccessfully.
The following text will output the SQL statement to recreate all databases:
|
1 2 3 |
select 'create database [' + name + '] go' from master..sysdatabases Where DBID > 4 |
You will need to set Results to Text so that the output is correctly formatted. You can then copy users/logins as seen here: http://support.microsoft.com/kb/918992.
When going to http://127.0.0.1:8086/login.aspx?ReturnUrl=%2fInterface%2fDefault.aspx:
I would receive the following error:
The file ‘/Skins/B9106EEE-DB03-489D-A19D-8647A55EC15C/control/login_3.ascx’ does not exist.
Source:
WHA.Helm.ControlPanel.dll /login.aspx Page_Load
Stack Trace:
at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at WHA.Helm.ControlPanel.loginpage.Page_Load(Object sender, EventArgs e)
Probing Paths:
C:\Program Files\Parallels\Helm4\ControlPanel\bin
This error was resolved by installing the Skins (Helm Configuration Tool -> Installed Modules -> select the ones under Control Panel Skins).