Hostek.com Wiki - User contributions [en]

File:Style button.png

2015-09-21T14:54:20Z

Jonc:

Backup & Restore Databases - MS SQL

2015-07-16T17:22:06Z

Jonc: /* Manual Restore */

How to restore an MS SQL database (import MS SQL database) from a backup file.

== How to Backup a MSSQL Database ==

=== Backup with myLittleBackup ===

# Log into the WCP at http://wcp.hostek.com/
# Click '''"MSSQL Tools"'''
# Select your MSSQL database and database user from the dropdown menu
# Click '''"MyLittleBackup"'''
# Click '''"Backup Databases"''' from the left menu
# Select your MSSQL database
# Click '''"Ok"''' under the '''"Check the information about your database"''' heading
# Complete the name and description fields
# Click '''"Backup"'''
# Click the link to the database to download, note the backup will also stay archived for 30 days within myLittleBackup - for easy restore

=== Manual Backup ===
This method applies to those managing their own servers or for our Windows Based VPS.

# Open SQL Management Studio
# Expand Databases and right click on the database and select: Tasks > Backup
# Select "Disk" for the destination. Backup Type should be "Full".
# Click "Add" and specify a path, and file name and .bak extension.
# Click "OK" to complete the backup.

==How to Restore a MSSQL Database==

=== Restore with myLittleBackup ===
Steps to restore a database using myLittleAdmin through the control panel.

'''NOTE:''' You will need to create your MSSQL database in the WCP before doing these steps

# Log into the WCP at http://wcp.hostek.com/
# Click '''"MSSQL Tools"'''
# Select your MSSQL database and database user from the dropdown menu
# Click '''"MyLittleBackup"'''
# Click '''"Restore Databases"''' from the left menu
# Select your MSSQL database
# Click '''"Ok"''' under the '''"Check the information about your database"''' heading
# Click '''"Browse"''' and navigate to the .bak file of your database on your local system
# Click '''"Ok"'''
# Select the database file you uploaded in the list and click '''"Ok"'''
# Click '''"Restore"''' and then click '''"Ok"''' on the alert message that pops up

=== Manual Restore ===
This method applies to those managing their own servers or for our Windows Based VPS.

FOR WINDOWS VPS, create the database within WCP before proceeding.

# Open SQL Management Studio
# Expand Databases and right click on the database and select: Tasks > Restore
# Select "Device" and choose the location of your backup file.
# Select "Options" from the left panel and check the box to "Overwrite the existing database (WITH REPLACE)".
#*Also check the box to "Close existing connections" on newer versions of SQL.
# Click "OK" to complete the restore.

====Manual Restore Script====
If you have created the database and user, manually or with WCP, you can easily use this script to restore the database and fix user permissions. Change the "database_name" and "USERNAME" portions of the SQL below, then execute the script in SQL Management Studio.

<pre>

USE [master]
GO
ALTER DATABASE database_name SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE [database_name] FROM DISK = N'C:\\MSSQL\\Backup\\database_name.bak' WITH FILE = 1,
MOVE N'database_name' TO N'C:\\MSSQL\\Data\\database_name.mdf',
MOVE N'database_name_log' TO N'C:\\MSSQL\\Data\\database_name_log.LDF', NOUNLOAD, REPLACE, STATS = 5
GO
ALTER DATABASE database_name SET ONLINE
GO
USE [database_name]
GO
Exec sp_change_users_login 'auto_fix','USERNAME'
GO

</pre>

== Errors and Solutions ==

Solutions to common errors when restoring database backups.

===The backup file you selected exceeds the limit size of your database===

'''Error Message:'''
The backup file you selected exceeds the limit size of your database. Restore has been cancelled.

This error indicates that the database that created the backup file is larger than the database you are restoring to. It is important to note that the size of the actual backup file does not matter. The size that is important is the size of both of the data file and log file of the database on the original SQL Server where the backup was created. If those file sizes are too large, you will need to reduce them before creating the backup file.

The most common issue is that the transaction log file is too large. To reduce the size of the transaction log file before creating the backup, you can perform a transaction log backup (Tasks -> Backup -> set '''Backup type''' = '''Transaction Log''') and then shrink the transaction log (Tasks -> Shrink -> Files -> set '''File type''' = '''Log''').

==='''Invalid Object Name''' errors after database restore===
This error can occur when a table is prefixed with the schema of a user other than dbo (ex myuser.table).

====Transfer Tables to DBO schema====
This will generate the SQL to transfer your tables to the 'dbo' schema:
<pre>SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.tables p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id
WHERE s.Name = 'EXISTING_OWNER_USERNAME'</pre>

====Transfer All Objects to DBO schema====
If you wish to transfer all object such as stored procedures to the 'dbo' schema, as well as tables, use the following to generate the needed SQL:
<pre>SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.objects p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id
WHERE s.Name = 'EXISTING_OWNER_USERNAME'</pre>

====SQL Server 2000 - Transfer Table to DBO schema====
To change the owner of a table in SQL Server 2000:
<pre>use MyDB
EXEC sp_changeobjectowner 'MyUser.MyTableName', 'dbo'</pre>

For the above TSQL, do the following:
#Change MyDB to your database name.
#Change MyUser to the current owner username.
#Change MyTableName to the table needing modified.
#Repeat for each table in the database, if necessary.

__FORCETOC__
[[Category:Databases-MSSQL]]

Node.js on Windows

2015-07-03T16:57:38Z

Jonc: Created page with "== Installing Node.js on Windows VPS == #Download and install the Node.js installer (MSI) for Windows: https://nodejs.org/download/ #*Be sure to install the version with the..."

== Installing Node.js on Windows VPS ==

#Download and install the Node.js installer (MSI) for Windows: https://nodejs.org/download/
#*Be sure to install the version with the correct bitness of your server. Note that if you have Node.js already installed or the executable already on your server you can skip this step, although you might need to set additional permissions.
#Download and install the iisnode module from: https://github.com/Azure/iisnode/downloads
#Add "list folder" permissions on c:\home for IIS_USERS. Caution if your hosting multiple applications for various customers you might need to make further security considerations.

=== Running Your Node.js Application ===

You should have a domain already created using our control panel WCP. Copy the Node.js application to a the destination folder, where you want to run it. For example: your-domain.com/node, will likely be in

<pre>
c:\home\your-domain.com\wwwroot\node
</pre>

You will need to create a web.config and or iisnode.yml file (or modify the existing), see the next section for specifics.

=== Modify iisnode web.config settings ===

'''If you followed the steps to install we suggest getting the example web.config and iisnode.yml from: C:\Program Files\iisnode\www\configuration'''

NOTE: The iisnode.yml file overrides any iisnode specific settings except for the handler and entrypoint which you are required to include in the web.config.

<pre>
<handlers>
<add name="iisnode" path="hello.js" verb="*" modules="iisnode" />
</handlers>
</pre>

==== Example web.config ====

The only thing you'll need to change in this web.config example is moving the path to the node.exe executable and the interceptor. The nice thing about the web.config provided by the example is it details all the available settings. Here's an example web.config:

<pre>
<configuration>
<system.webServer>



<handlers>
<add name="iisnode" path="hello.js" verb="*" modules="iisnode" />
</handlers>

<iisnode
nodeProcessCommandLine=""%programfiles%\nodejs\node.exe""
interceptor=""%programfiles%\iisnode\interceptor.js""
node_env="%node_env%"
nodeProcessCountPerApplication="1"
maxConcurrentRequestsPerProcess="1024"
maxNamedPipeConnectionRetry="100"
namedPipeConnectionRetryDelay="250"
maxNamedPipeConnectionPoolSize="512"
maxNamedPipePooledConnectionAge="30000"
asyncCompletionThreadCount="0"
initialRequestBufferSize="4096"
maxRequestBufferSize="65536"
watchedFiles="*.js;iisnode.yml"
uncFileChangesPollingInterval="5000"
gracefulShutdownTimeout="60000"
loggingEnabled="true"
logDirectory="iisnode"
debuggingEnabled="true"
debugHeaderEnabled="false"
debuggerPortRange="5058-6058"
debuggerPathSegment="debug"
maxLogFileSizeInKB="128"
maxTotalLogFileSizeInKB="1024"
maxLogFiles="20"
devErrorsEnabled="true"
flushResponse="false"
enableXFF="false"
promoteServerVars=""
configOverrides="iisnode.yml"
/>

</system.webServer>
</configuration>
</pre>

==== iisnode.yml for configuration ====

[http://tomasz.janczuk.org/2012/05/yaml-configuration-support-in-iisnode.html About the iisnode.yml configuration it's importance.]

[[Category:Tutorials]]
[[Category:Windows-VPS]]

View MS SQL .BAK Files

2015-02-24T17:45:09Z

Jonc:

==Viewing MSSQL .bak Files==
*To view the contents of a .bak file you will need use a program such as SQL Management Studio. Using a text editor will not work as .bak files are not text based files and only contain raw data.

*The best way to view a .bak file is to create a MSSQL database on your local system and restore the .bak file into it. Once you've done this you can view the tables in SQL Management Studio and view the database content.

'''Need to backup or restore you MSSQL Database?''' Visit our [https://wiki.hostek.com/Backup_%26_Restore_Databases_-_MS_SQL How to Backup and Restore MSSQL Databases] Page.

[[Category:Databases-MSSQL]]

Seamlessly Change Hosting to Hostek.com

2015-02-24T17:42:25Z

Jonc: /* MSSQL */

==Steps to Changing Hosting Providers==

# [https://wiki.hostek.com/Changing_Hosting_Providers#Sign_up_for_hosting Sign up with Hostek.com]
# Transfer your site files and databases. Specific details for moving to: [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_Shared_Hosting Shared Hosting] or [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_VPS VPS Hosting]
# [https://wiki.hostek.com/Changing_Hosting_Providers#Planning_Ahead Test your site(s)]
# [https://wiki.hostek.com/DNS_(Name_Servers) Update Your Domain Name's Name Servers] NOTE: you will find the Name Server information in the New Hosting Account Email.

==Planning Ahead==
*Transferring hosting companies can be, and should be, easy if you follow the right steps and choose the right hosting company. You have made the correct choice in hosting companies, as we have many years experience in helping customers just like you transfer their hosting to us. We've created this easy-to-follow list for you to transfer your website to Hostek.com.

#Plan as far ahead as possible, the more detailed the better.
#Make sure your customers are well informed of any possible service interruption and changes they should consider well in advance.
#Test each site after uploading the files, importing databases and updating connection strings to make sure no errors are occurring. Use the Testing URL provided in the email after setting up hosting.
#Complete unfinished business, including tightening security on any ports or protocols that do not need to remain open to the public.

===For sites with constantly changing data===
The most difficult sites to move are those that have constantly changing data. The is because updates made during the backup & transfer will not be reflected in the data backup being moved.

To resolve this:

Perform the transfer during off-peak hours. In addition display a "under construction" page on both the new and old server while the transition is in progress.

After the site move has been completed, update your DNS as quickly as possible and leave the old site stopped. In some cases pointing the website on the previous host to the database on the new website will allow both sites to run without inconsistent data.

Another solution to insure quick switch over is setting the DNS, TTL to a low value such as 600 (10 minutes) on A records for domains being moved.

===Pre-Migration Site Assessment===

;Domains List
:Which domains are hosted and need moved?
:Do they require SSL?
:Are there any other hostnames that point to the site such as a sub-domain or alias?
:Special requirements such as a Virtual Directory or Sym Link?

;Database List
:Types of databases?
:User and permissions for each user?
:Password for each user?

;Domains with Mail
:Which domains USE mail?
:How do users access email, POP, IMAP, Web?
:Server URL for POP, SMTP, IMAP and Web?
:Special requirements such as SSL?

;Domains with FTP
:User and permission such as directory, read/write for each user?
:Passwords for each user?

;Registrar for each Domain?
:Where can the Name Servers be updated?
:Login for the Account?

;DNS for each Domain
:Where is it managed?
:Will DNS management be moved?
:Should we set the TTL low for any to insure quick switchover?

==Sign up for hosting==
The First step in transferring is to sign up for a hosting package. We offer a wide range of hosting packages that will fit your needs. After signing up for a hosting package, you will get an email with a Testing URL and Temporary FTP information. Use this information to complete the next task of moving your site files.

[http://hostek.com/hosting/web-hosting/best-web-hosting.asp Web Hosting] Windows / Linux / ColdFusion / Railo

[http://hostek.com/reseller-hosting.asp Reseller Hosting]

[http://hostek.com/hosting/vps/best-vps-hosting.asp VPS (Virtual Private Server) Hosting]

[http://hostek.com/hosting/dedicated/virtual-dedicated-hosting.asp Virtual Dedicated Hosting]

Custom VPS or Infrastructure as a Service Solutions contact [mailto:vps_sales@hostek.com VPS sales.]

==your-provider to Hostek.com Windows Shared Hosting==

===Moving Site Files and Databases===
#Open an FTP(File Transfer Protocol) client on your computer. If you do not have one, you can download FileZilla for free at "http://filezilla-project.org/download.php/".
#Connect to your site on your old host. Generally, the connection details will either be in an e-mail you received from them or listed in your control panel with them.
#Once connected, you should see two sets of files, local (files on your computer) and remote (files on your website). Under your local files, create a folder to store your site files.
#Once the folder is created, open that folder on the local side. Then, select all the files on the remote site and download them into that folder.
#Wait for the transfer of all files to complete. This may take several minutes.
#Once the transfer is complete, disconnect from the server. Then connect to your site on our server using the FTP details that we sent in your account details e-mail.
#On the remote side, open the /wwwroot folder. Also, on the local side, if there is a 'www', 'wwwroot', or 'public_html' folder, open that folder as well. #Select all files on the local side and upload them to the remote side.
#Wait for the transfer of all files to complete. This may take several minutes.
#Done - your site files have been moved.

===Databases===

====MSSQL====
#Request a full backup of your database from your host, or create one through their control panel if you have that option.
#Once you have the full database backup (should be a .bak file), login into your WCP control panel at "https://wcp.hostek.com" using the same e-mail address and password as your billing control panel.
#Once logged in, select 'MS SQL', and click 'Add MS SQL database'. Enter name of the backed up database and choose a size larger than the .bak file. Enter a username and password and click 'Save'.
#Follow the steps for [https://wiki.hostek.com/Backup_%26_Restore_Databases_-_MS_SQL How to Restore a MSSQL Database].

NOTE: If you have any issues restoring the database due to the size or structure of the database, you may need to upload the backup file to your website and ask support to restore the database. If you do this, it is recommended that you zip the backup file before uploading it as that will make it much smaller.

===Update your domain’s DNS===
*Update your domain’s DNS settings Once you have tested your site, contact your domain name registrar and change your DNS settings to the Name Servers we provided in the New Account email. Your registrar is the company you purchased your domain name from. You’ll replace your existing primary and secondary name servers with the ones we provided you in the new account email. This change will take about 12 to 48 hours to propagate throughout the internet.

===Wait for your domain to propagate===
*Wait for your domain to propagate (approximately 12-48 hours) While your domain propagation is taking effect, some will see your site on our servers and others will see the site on your old host. This will prevent any downtime. In order to receive mail from both locations, you will need to check email from both hosts. You can simply use our web mail interface to get the email that is sent to our servers during

===Cancel with your previous host===
Cancel with your previous host After the site is pointing to us, you can go and cancel the hosting account you have at your previous host.

===Transfer your domain name to our registrar (optional)===
Transfer your domain name (optional)If you would like to transfer your domain and consolidate your registration and web hosting to one source, you can request to transfer the domain. The domain transfer itself costs NOTHING; we simply add one year of registration onto the expiration date for a base price for the common .TLD's. After that, you will able to renew your domain name at the same great price.
A registrar transfer is the moving a domain name from one registrar to another. A registrar is the company that actually registers a domain name.
#You will need to log into your billing control panel at https://cp.hostek.com
#Click on the domains drop-down menu and click "My Domains".
#Scroll down to your domain name and click "Manage Domain"
#Click the "Registrar Lock" tab, then click the "Disable Registrar Lock" button.
#Click on the "Management Tools" drop-down menu and select "Contact Information"
#You will need to update the Admin contact email address to an email address that you can receive emails at and click "Save Changes".
#Click "Management Tools" drop-down and select "Get EPP Code". This will display the EPP code that you will need to provide to the registrar you are transferring to.
#Once you have initiated the transfer with the registrar and provided the EPP code you will receive a transfer approval email at the email address you specified.

==your-provider to Hostek.com Windows VPS==
*We recommend setting up each domain using WCP as you move them, not all at one time. Doing so ensures there are less complications with mail delivery between two domains.

[[media:Hostek.com_Migration_Checklist.xls | Download this Migration Checklist]] to keep track of your migration progress.

===Moving Domains===
Familiarize yourself and your team with our [https://wcp.hostek.com Windows Control Panel]. We have prepared a [https://wiki.hostek.com/WCP_(Windows_based_Control_Panel) WCP Guide] to help.

#Create the domain using the "addon domain" icon in the WCP.
#*When initially logging into WCP the domain which was used for referencing your VPS will be listed and new domains added.
#*If you selected a database server be installed locally or remotely it should be integrated with your control panel and databases can be added under each domain using the appropriate Icon.
#*Note if you ordered the FREE SmarterMail edition which only includes mail for a single domain, upon adding your second domain you may encounter an error. If so contact support for upgrading your SmarterMail license or disabling the action for adding new domains to the mail server.
#DNS zones are automatically created for new domains, for the name servers which are used for domains added to your VPS click on the "Site Details" icon within the WCP for the domain in question.
#Copy files to your VPS. Use FTP directly from your VPS to transfer site files, this is extremely fast and efficient.
#Test the domain. Each domain will have a "Testing URL" within the "Site Details" area of WCP, note that if the database is not moved over and or DSN not created you may encounter errors.
#Prepare the DNS for moving. Before switching your DNS we suggest a shorter TTL such as 300 (5 minutes), after this change you must wait out the original TTL before the new value will take affect. For example if your original TTL was 7200 seconds (2 hours) you must wait 2 hours after submitting any change before the new TTL will be take effect.
#Switch your DNS. By now your site is tested and you're ready to make the switch.
#*In most cases we suggest moving the database first so data will be consistent from the old location to the new.

===SSL===

*Our Windows Control Panel has provisions for creating a CSR and installing a new certificate but you cannot "import" an existing certificate. There are two ways to resolve "moving" a certificate to a Windows server easily.

====Pkey format====
#Export the certificate in PKey format. Within the certificate manager, export the current certificate in PKey format, you will be asked for a "passphrase" assign one and remember it.
#Copy the certificate to the new server.
#Open IIS on your VPS, open the main server node then click on the icon "Server Certificates" found under >> IIS >> Server Certificates.
#Click import and follow the prompts.
#Edit the bindings for the specific site to assign the certificate
#*Right click on the website in Sites >> your-website.abc select "Edit Bindings".
#*Select "Add" change the type to https, select the IP Address, select the "SSL Certificate" from the drop down.

====Re-key the certificate====
*Using this method could render the SSL certificate expired on the old server.

#Click on the "Dedicated SSL" icon in WCP.
#Fill in the appropriate information to generate a CSR.
#At your certificate provider request a "rekey" using the CSR provided from WCP.
#After receiving the new certificate back from your provider, complete the installation in WCP.

===Databases===

====MSSQL====
#Add the database and user in MSSQL using the WCP under the correct domain.
#Set the database to single user mode on the new server.
#*<pre>USE database_name ALTER DATABASE [DB_NAME_HERE] SET SINGLE_USER WITH NO_WAIT</pre>
#Using SQL Studio Manager restore from backup selecting the file you exported from your previous server.
#Set the database to multi user mode on the new server.
#*<pre>USE database_name ALTER DATABASE [DB_NAME_HERE] SET MULTI_USER WITH NO_WAIT</pre>
#To fix user a created user which existed before the database was restored.
#*<pre>USE database_name Exec sp_change_users_login 'auto_fix','USERNAME'</pre>
#In some cases you may continue to receive errors. Try adding double slashes for the file restore paths. Here's a scripted example:
<pre>
RESTORE DATABASE [exampledatabase] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\exampledatabase.bak'
WITH FILE = 1, MOVE N'old_database_name_Data' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.mdf',
MOVE N'old_database_name_Log' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.LDF',
NOUNLOAD, REPLACE, STATS = 10
GO
</pre>

===Don't forget===
*Scheduled tasks, add them on the new server remove them from the old.
*Change the DNS TTL back to default.

=== Mail===

====SmarterMail to SmarterMail====

#See the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration] for preparing the MX record and SSL (if applicable). You can however skip the step for creating users / passwords on the new server since you will be moving everything at once.
#Zip the contents of the {smartermail root}\domains\yourdomain.com.
#FTP the files from the old server to the new, this can be done by installing a simple FTP client such as FileZilla on the VPS and connecting to the old server.
#On the new VPS unzip and overwrite the contents {smartermail root}\domains\yourdomain.com.
#Login to the SmarterMail Webmail interface, "Reload" the domain. This should cause all the users to be revealed, with their inbox, calendar and other assets intact.
#Complete the "Final Steps" mentioned under [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration].

====Any Provider to Windows & Smartermail====

Easily migrate from any mail service. Move a single mailbox, or an entire domain, from mail services like:

Gmail
Yahoo!
Hotmail / Windows Live
Microsoft Exchange
Or even mail servers like Merak, iMail and MailEnable

We suggest following the "Preparation Steps" under the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration]. Then follow the steps provided by SmarterMail.

http://portal.smartertools.com/KB/a1937/import-mailbox-data-to-smartermail-from-third-party.aspx

====Why move one domain at a time?====
If you setup domain X, Y, and Z via WCP, then migrate X from your old server to Hostek. If a user on X tries to email someone on domain Y or Z they'll get a kickback saying "No such user." This is because you haven't migrated the data over into these other accounts yet. The server will try to send the message locally before it goes "outside" to resolve it's IP address. Setting up new domains "as you go", will avoid this possibility.

If mail is not involved in the migration, then you may not need to worry about this issue.

==your-provider to VPS Mail Migration General Information==
There are various ways to migrate mail from an existing provider. In cases where POP is the method for retrieving mail then simply switching providers in a thoughtful preplanned manner is sufficient.

===Keys for simple POP/SMTP Mail Migration===

====Preparation Steps for Mail Migration====
#Create domain on the new server.
#Setup users & passwords in advance on the new server.
#Take note of the specific DNS details and modify the TTL.
#*Note the MX record.
#*Set the TTL for the MX record to 600 (10 minutes).
#*If the MX is set to "something.yourdomain.com", then also change the TTL for the A record "something.yourdomain.com" to 600 (10 minutes).
#Does your mailserver use SSL? Note, if the SSL mail encryption works for "mail.yourisp.com" and you're moving to a VPS then you will likely have to also purchase and have the certificate installed and insure the exact same type of SSL support works before proceeding.

====Final Steps to complete the Mail Migration====
#Plan and prepare users with what they should expect.
#Be sure your mail server is listening on the IP Address you will point the A record to
#We suggest to create or modify the A record "something.yourdomain.com" if it already exists, when you are ready to make the switch change that A record "something.yourdomain.com" to point at your VPS.
#When finished change the TTL for the MX record and applicable A record back to it's default (Usually 14400).

*You can use the standard ports for POP/SMTP or IMAP with or without SSL.
*Alternate Ports for SMTP (26) is pre-configured in our firewall and will just need configured in either SmarterMail or Cpanel.

===your-provider Mail Migration any IMAP Mail Server===

'''This can easily apply to migrating from any mail service to Linux with Cpanel.'''

We suggest following the "Preparation Steps" under the Keys for Simple Mail Migration above. It also may be possible to find an application to migrate IMAP mail including calendars & contacts. We suggest checking into "IMAPSync".

[[Category:Windows-VPS]]
[[Category:ColdFusion-VPS]]
[[Category:VPS]]
[[Category: Sales]]
[[Category:Getting Started]]

Backup & Restore Databases - MS SQL

2015-02-24T17:39:30Z

Jonc: Jonc moved page Restoring Databases - MS SQL to Backup & Restore Databases - MS SQL: Provide full instructions.

How to restore an MS SQL database (import MS SQL database) from a backup file.

== How to Backup a MSSQL Database ==

=== Backup with myLittleBackup ===

# Log into the WCP at http://wcp.hostek.com/
# Click '''"MSSQL Tools"'''
# Select your MSSQL database and database user from the dropdown menu
# Click '''"MyLittleBackup"'''
# Click '''"Backup Databases"''' from the left menu
# Select your MSSQL database
# Click '''"Ok"''' under the '''"Check the information about your database"''' heading
# Complete the name and description fields
# Click '''"Backup"'''
# Click the link to the database to download, note the backup will also stay archived for 30 days within myLittleBackup - for easy restore

=== Manual Backup ===
This method applies to those managing their own servers or for our Windows Based VPS.

# Open SQL Management Studio
# Expand Databases and right click on the database and select: Tasks > Backup
# Select "Disk" for the destination. Backup Type should be "Full".
# Click "Add" and specify a path, and file name and .bak extension.
# Click "OK" to complete the backup.

==How to Restore a MSSQL Database==

=== Restore with myLittleBackup ===
Steps to restore a database using myLittleAdmin through the control panel.

'''NOTE:''' You will need to create your MSSQL database in the WCP before doing these steps

# Log into the WCP at http://wcp.hostek.com/
# Click '''"MSSQL Tools"'''
# Select your MSSQL database and database user from the dropdown menu
# Click '''"MyLittleBackup"'''
# Click '''"Restore Databases"''' from the left menu
# Select your MSSQL database
# Click '''"Ok"''' under the '''"Check the information about your database"''' heading
# Click '''"Browse"''' and navigate to the .bak file of your database on your local system
# Click '''"Ok"'''
# Select the database file you uploaded in the list and click '''"Ok"'''
# Click '''"Restore"''' and then click '''"Ok"''' on the alert message that pops up

=== Manual Restore ===
This method applies to those managing their own servers or for our Windows Based VPS.

FOR WINDOWS VPS, create the database within WCP before proceeding.

# Open SQL Management Studio
# Expand Databases and right click on the database and select: Tasks > Restore
# Select "Device" and choose the location of your backup file.
# Select "Options" from the left panel and check the box to "Overwrite the existing database (WITH REPLACE)".
#*Also check the box to "Close existing connections" on newer versions of SQL.
# Click "OK" to complete the restore.

== Errors and Solutions ==

Solutions to common errors when restoring database backups.

===The backup file you selected exceeds the limit size of your database===

'''Error Message:'''
The backup file you selected exceeds the limit size of your database. Restore has been cancelled.

This error indicates that the database that created the backup file is larger than the database you are restoring to. It is important to note that the size of the actual backup file does not matter. The size that is important is the size of both of the data file and log file of the database on the original SQL Server where the backup was created. If those file sizes are too large, you will need to reduce them before creating the backup file.

The most common issue is that the transaction log file is too large. To reduce the size of the transaction log file before creating the backup, you can perform a transaction log backup (Tasks -> Backup -> set '''Backup type''' = '''Transaction Log''') and then shrink the transaction log (Tasks -> Shrink -> Files -> set '''File type''' = '''Log''').

==='''Invalid Object Name''' errors after database restore===
This error can occur when a table is prefixed with the schema of a user other than dbo (ex myuser.table).

====Transfer Tables to DBO schema====
This will generate the SQL to transfer your tables to the 'dbo' schema:
<pre>SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.tables p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id
WHERE s.Name = 'EXISTING_OWNER_USERNAME'</pre>

====Transfer All Objects to DBO schema====
If you wish to transfer all object such as stored procedures to the 'dbo' schema, as well as tables, use the following to generate the needed SQL:
<pre>SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.objects p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id
WHERE s.Name = 'EXISTING_OWNER_USERNAME'</pre>

====SQL Server 2000 - Transfer Table to DBO schema====
To change the owner of a table in SQL Server 2000:
<pre>use MyDB
EXEC sp_changeobjectowner 'MyUser.MyTableName', 'dbo'</pre>

For the above TSQL, do the following:
#Change MyDB to your database name.
#Change MyUser to the current owner username.
#Change MyTableName to the table needing modified.
#Repeat for each table in the database, if necessary.

__FORCETOC__
[[Category:Databases-MSSQL]]

Restoring Databases - MS SQL

2015-02-24T17:39:30Z

Jonc: Jonc moved page Restoring Databases - MS SQL to Backup & Restore Databases - MS SQL: Provide full instructions.

#REDIRECT [[Backup & Restore Databases - MS SQL]]

Backup & Restore Databases - MS SQL

2015-02-24T17:38:53Z

Jonc:

How to restore an MS SQL database (import MS SQL database) from a backup file.

== How to Backup a MSSQL Database ==

=== Backup with myLittleBackup ===

# Log into the WCP at http://wcp.hostek.com/
# Click '''"MSSQL Tools"'''
# Select your MSSQL database and database user from the dropdown menu
# Click '''"MyLittleBackup"'''
# Click '''"Backup Databases"''' from the left menu
# Select your MSSQL database
# Click '''"Ok"''' under the '''"Check the information about your database"''' heading
# Complete the name and description fields
# Click '''"Backup"'''
# Click the link to the database to download, note the backup will also stay archived for 30 days within myLittleBackup - for easy restore

=== Manual Backup ===
This method applies to those managing their own servers or for our Windows Based VPS.

# Open SQL Management Studio
# Expand Databases and right click on the database and select: Tasks > Backup
# Select "Disk" for the destination. Backup Type should be "Full".
# Click "Add" and specify a path, and file name and .bak extension.
# Click "OK" to complete the backup.

==How to Restore a MSSQL Database==

=== Restore with myLittleBackup ===
Steps to restore a database using myLittleAdmin through the control panel.

'''NOTE:''' You will need to create your MSSQL database in the WCP before doing these steps

# Log into the WCP at http://wcp.hostek.com/
# Click '''"MSSQL Tools"'''
# Select your MSSQL database and database user from the dropdown menu
# Click '''"MyLittleBackup"'''
# Click '''"Restore Databases"''' from the left menu
# Select your MSSQL database
# Click '''"Ok"''' under the '''"Check the information about your database"''' heading
# Click '''"Browse"''' and navigate to the .bak file of your database on your local system
# Click '''"Ok"'''
# Select the database file you uploaded in the list and click '''"Ok"'''
# Click '''"Restore"''' and then click '''"Ok"''' on the alert message that pops up

=== Manual Restore ===
This method applies to those managing their own servers or for our Windows Based VPS.

FOR WINDOWS VPS, create the database within WCP before proceeding.

# Open SQL Management Studio
# Expand Databases and right click on the database and select: Tasks > Restore
# Select "Device" and choose the location of your backup file.
# Select "Options" from the left panel and check the box to "Overwrite the existing database (WITH REPLACE)".
#*Also check the box to "Close existing connections" on newer versions of SQL.
# Click "OK" to complete the restore.

== Errors and Solutions ==

Solutions to common errors when restoring database backups.

===The backup file you selected exceeds the limit size of your database===

'''Error Message:'''
The backup file you selected exceeds the limit size of your database. Restore has been cancelled.

This error indicates that the database that created the backup file is larger than the database you are restoring to. It is important to note that the size of the actual backup file does not matter. The size that is important is the size of both of the data file and log file of the database on the original SQL Server where the backup was created. If those file sizes are too large, you will need to reduce them before creating the backup file.

The most common issue is that the transaction log file is too large. To reduce the size of the transaction log file before creating the backup, you can perform a transaction log backup (Tasks -> Backup -> set '''Backup type''' = '''Transaction Log''') and then shrink the transaction log (Tasks -> Shrink -> Files -> set '''File type''' = '''Log''').

==='''Invalid Object Name''' errors after database restore===
This error can occur when a table is prefixed with the schema of a user other than dbo (ex myuser.table).

====Transfer Tables to DBO schema====
This will generate the SQL to transfer your tables to the 'dbo' schema:
<pre>SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.tables p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id
WHERE s.Name = 'EXISTING_OWNER_USERNAME'</pre>

====Transfer All Objects to DBO schema====
If you wish to transfer all object such as stored procedures to the 'dbo' schema, as well as tables, use the following to generate the needed SQL:
<pre>SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.objects p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id
WHERE s.Name = 'EXISTING_OWNER_USERNAME'</pre>

====SQL Server 2000 - Transfer Table to DBO schema====
To change the owner of a table in SQL Server 2000:
<pre>use MyDB
EXEC sp_changeobjectowner 'MyUser.MyTableName', 'dbo'</pre>

For the above TSQL, do the following:
#Change MyDB to your database name.
#Change MyUser to the current owner username.
#Change MyTableName to the table needing modified.
#Repeat for each table in the database, if necessary.

__FORCETOC__
[[Category:Databases-MSSQL]]

MochaPanel

2015-01-09T17:45:58Z

Jonc: /* Why Hostek loves MochaPanel */

=Why Hostek loves MochaPanel=

We could not find a control panel that included all the features customers were asking for so we built our own. Shared hosting customers get full control of their domain, resellers can easily manage their customers and integrate with billing software, VPS/Cloud customers can manage firewall and infrastructure. Best of all it's not bloated with features that you'll never use. Let's review 4 core benefits that make MochaPanel great.

*'''POWERFUL:''' Manage hosting from one place, full control of your domains and more..

*'''EASY:''' Clearly labeled controls, similar across shared, reseller and VPS - with advance features nicely nested within.

*'''FAST:''' Single domain management, reseller and advanced VPS/Cloud server management is ALL blazing fast!

*'''FOUNDATIONAL:''' In production for over 3 years but we are constantly adding new features - and have quite ambitions goals for the future!

Try the [https://wcp.hostek.com/demo DEMO] for yourself.

Reselling hosting? Try the [https://wcp.hostek.com/resellerdemo RESELLER DEMO] for yourself.

Migration Assistance

2014-05-05T16:04:53Z

Jonc: /* Migrations - Preparation Steps */

__FORCETOC__

In most cases, Hostek.com can help you migrate from your current provider to our services.

We perform this process day in and day out for both shared and VPS customers, so we have this process down to a good science.

== Migrations - Preparation Steps ==
#Be sure you are going to a matching platform.
##If you know you are changing platforms, check with our support team to make sure it will be fine. Most of the time it will be fine.
#Be sure you have all your login details at your current host so that we can get access to your site, database, etc.

=== Required Information ===
To get started on your migration we will need the following information. We find it's easiest if customers provide a spreadsheet with the information below.

#List of domains
#*For Cpanel to Cpanel moves we need access to the existing CPanel Account, or WHM (preferred)
#*For large migrations 10+ domains or 10+GB full server access is preferred.
#Specific important details about each domain, such as the type of CMS or application framework, what parts are critical - which should ALSO be noted in your documents.
#List of databases, users and passwords (preferred)
#List of accounts, ftp, email
#URL and login details for your registrar, if we will be changing the DNS for you, this should be pre-determined.

See [http://blog.hostek.com/blog/uncategorized/3-steps-to-prepare-for-a-successful-hosting-migration/ this blog post] on how to make your migration pain free, there's also an Excel document for tracking the domains and account information.

More information in [https://wiki.hostek.com/index.php?title=Seamlessly_Change_Hosting_to_Hostek.com this wiki] on making your migration seamless.

== Migrations - Completion Steps ==

#Initial discussion about the migration (ticket or phone).
#*This is the best time to explain what is being migrated, specifically the required information (domains, accounts etc..) we should have received from you.
#*We will likely coordinate a time for the migration during this conversation.
#Migration Start - We will carry out the migration at the discussed time.
#Testing - After the migration is complete we will test any discussed URL/Parts of the websites/services that are critical and pre-determined.
#Migration Finish - When the migration and testing are complete we will let you know usually by ticket.
##There may be additional parts that need to be tested or finished such as DNS changes, however we can answer your questions about this in the initial discussion.

To find out how we can help with your migration, submit a ticket at https://support.hostek.com

== Limitations - Fine Print ==
You might ask, what if I have 1000 sites will Hostek migrate them all for me? For migrations that will require more than 2hrs support time we must pre-approve first. We may discuss the complete migration or an effective plan for coordinating and working alongside the customer to move their sites. We have never had to tell a customer NO we can't do that and we have completed very large and complex multi-server migrations for many customers.

Firewall Options - VPS/Dedicated

2014-04-01T20:54:15Z

Jonc: /* IPS & Firewall Protection */

== IPS & Firewall Protection ==
Hostek protects it's VPS customers with [https://wiki.hostek.com/Hostek_infrastructure#Firewall_.26_IPS perimeter load balanced IPS’s] by [http://www.corero.com/products/corero-ips.html Corero] (Includes DDOS & deep packet inspection for known threats) which also act as a firewall. Customers have three options for the protection of their VPS, by default servers will be in the Protected port group:

#Protected (supports most common ports*, DDOS, deep packet inspection)
#PCI (restricted to a few ports, DDOS, deep packet inspection)
#Server Managed (less restrictive, no port blocking, no deep packet inspection, includes DDOS)

*Note in the default group there are some additional ports open for custom applications, contact support and we will provide the port numbers.

== Customizable Firewall Options ==
In our VPS/Dedicated Firewall Protected port group (Number 1 above), we open commonly utilized ports. If you need a non-standard fixed port to be open, contact support to have your VPS moved to the "Server Managed" group. If your application can be set to use an alternate port, there are a few alternate ports open for this purpose, contact support for more details. However keep in mind traffic to your server will be rate limited for DDOS protection but there will be no port blocking. RECOMMENDED - unneeded ports can be blocked from the software firewall on your server. This can be managed easily for Windows VPS's from WCP (limited control) or more extensive control for Windows thru Microsoft Remote Desktop or for Linux cPanel Servers use ConfigServer Firewall.

== Windows Firewall ==
=== Opening a Port in Windows Firewall ===
To open a port in your VPS's Windows Firewall, you'll need to perform the following steps:
#Click the '''Start''' button, open the '''Administrative Tools''' menu, then click '''Windows Firewall with Advanced Security'''. [[File:openfirewallport-step01.png]]
#Click the '''Inbound Rules''' section, then click the '''New Rule''' link at the right side of the window. [[File:openfirewallport-step02.png]]
#Select '''Port''' and click '''Next'''. [[File:openfirewallport-step03.png]]
#Enter the port you wish to open in the '''Specific local ports''' section. For example, if you wish to open MySQL you'd enter 3306. You can also open multiple ports at a time by separating the ports with commas. [[File:openfirewallport-step04.png]]
#Make sure '''Allow the connection''' is selected and click '''Next'''. [[File:openfirewallport-step05.png]]
#Make sure '''Domain''', '''Private''', and '''Public''' are selected and click '''Next'''. [[File:openfirewallport-step06.png]]
#Now you just need to enter a name for the rule and click '''Finish''' [[File:openfirewallport-step07.png]]
=== Restricting Access to a Port ===
#First, open '''Windows Firewall with Advanced Security''' by clicking the '''Start''' button, opening the '''Administrative Tools''' menu, then clicking '''Windows Firewall with Advanced Security'''. [[File:openfirewallport-step01.png]]
#Right-click on the rule you wish to edit, and click '''Properties'''
#Click the '''Scope''' tab in the pop-up that appears. [[File:restrictfirewallport-step03.png]]
#Under '''Remote IP Addresses''' select '''These IP addresses''' then click '''Add'''.
#In the popup that appears, you will choose what IP will have access to the port defined in your rule. For example, if you wish to restrict access to your local computer, you'd enter your computer's IP address in the '''This IP address or subnet''' section. FYI, to find your computer's IP address, you can use [http://hostek.com/ip/ our IP finder]. [[File:restrictfirewallport-step05.png]]
#After entering your IP, click '''OK''' in the '''IP Address''' window. Then click '''OK''' in the rule properties window, and you're done.

[[Category:ColdFusion-VPS]]
[[Category:Railo-VPS]]
[[Category:Windows-VPS]]
[[Category:Email-VPS]]

Firewall Options - VPS/Dedicated

2014-04-01T20:51:39Z

Jonc: /* Firewall Options */

== IPS & Firewall Protection ==
Hostek protects it's VPS customers with perimeter load balanced IPS’s (DDOS, deep packet inspection for known threats) which also act as a firewall (blocking). Customers have three options for the protection of their VPS, by default servers will be in the Protected port group:

#Protected (supports most common ports*, DDOS, deep packet inspection)
#PCI (restricted to a few ports, DDOS, deep packet inspection)
#Server Managed (less restrictive, no port blocking, no deep packet inspection, includes DDOS)

*Note in the default group there are some additional ports open for custom applications, contact support and we will provide the port numbers.

== Customizable Firewall Options ==
In our VPS/Dedicated Firewall Protected port group (Number 1 above), we open commonly utilized ports. If you need a non-standard fixed port to be open, contact support to have your VPS moved to the "Server Managed" group. If your application can be set to use an alternate port, there are a few alternate ports open for this purpose, contact support for more details. However keep in mind traffic to your server will be rate limited for DDOS protection but there will be no port blocking. RECOMMENDED - unneeded ports can be blocked from the software firewall on your server. This can be managed easily for Windows VPS's from WCP (limited control) or more extensive control for Windows thru Microsoft Remote Desktop or for Linux cPanel Servers use ConfigServer Firewall.

== Windows Firewall ==
=== Opening a Port in Windows Firewall ===
To open a port in your VPS's Windows Firewall, you'll need to perform the following steps:
#Click the '''Start''' button, open the '''Administrative Tools''' menu, then click '''Windows Firewall with Advanced Security'''. [[File:openfirewallport-step01.png]]
#Click the '''Inbound Rules''' section, then click the '''New Rule''' link at the right side of the window. [[File:openfirewallport-step02.png]]
#Select '''Port''' and click '''Next'''. [[File:openfirewallport-step03.png]]
#Enter the port you wish to open in the '''Specific local ports''' section. For example, if you wish to open MySQL you'd enter 3306. You can also open multiple ports at a time by separating the ports with commas. [[File:openfirewallport-step04.png]]
#Make sure '''Allow the connection''' is selected and click '''Next'''. [[File:openfirewallport-step05.png]]
#Make sure '''Domain''', '''Private''', and '''Public''' are selected and click '''Next'''. [[File:openfirewallport-step06.png]]
#Now you just need to enter a name for the rule and click '''Finish''' [[File:openfirewallport-step07.png]]
=== Restricting Access to a Port ===
#First, open '''Windows Firewall with Advanced Security''' by clicking the '''Start''' button, opening the '''Administrative Tools''' menu, then clicking '''Windows Firewall with Advanced Security'''. [[File:openfirewallport-step01.png]]
#Right-click on the rule you wish to edit, and click '''Properties'''
#Click the '''Scope''' tab in the pop-up that appears. [[File:restrictfirewallport-step03.png]]
#Under '''Remote IP Addresses''' select '''These IP addresses''' then click '''Add'''.
#In the popup that appears, you will choose what IP will have access to the port defined in your rule. For example, if you wish to restrict access to your local computer, you'd enter your computer's IP address in the '''This IP address or subnet''' section. FYI, to find your computer's IP address, you can use [http://hostek.com/ip/ our IP finder]. [[File:restrictfirewallport-step05.png]]
#After entering your IP, click '''OK''' in the '''IP Address''' window. Then click '''OK''' in the rule properties window, and you're done.

[[Category:ColdFusion-VPS]]
[[Category:Railo-VPS]]
[[Category:Windows-VPS]]
[[Category:Email-VPS]]

PCI Compliance

2014-03-26T17:56:38Z

Jonc: /* hostek.com */

__FORCETOC__

== Obtaining PCI Compliance ==

You need PCI Compliance if your website/business: '''accepts, transmits or stores any cardholder data.'''

'''If that is you:'''

Find a Quality Security Accessor such as [https://www.securitymetrics.com SecurityMetrics] or [https://trustwave.com/ TrustWave], there are many such vendors. They will help you determine the type of compliance required for your business and provide the services to achieve and maintain compliance.

'''How do I know what level / validation type?'''

The Quality Security Accessor will help you determine this and based on PCI DSS Standards.

*The level of "compliance" required (1-4) is based on transaction or monetary volume.
*The "Validation Type" determines the assessment requirements and is based on how much card data you store.

A copy of the PCI DSS is available [https://www.pcisecuritystandards.org/security_standards/index.php here].
More general unofficial details can be found at [http://en.wikipedia.org/wiki/Payment_Card_Industry_Data_Security_Standard here].

=== How Hostek complements efforts for PCI compliance ===

#Insuring PCI standards can be met and kept for our own systems.
#Providing firewall protection for all servers and the option for PCI compliant firewall rules to be applied to customers environment.
#Providing VPN for customers to securely connect and manage environment remotely.
#Providing VLAN (virtual private network) for customers environment with multiple servers so their database server is completely isolated from public access.
#Including or offering Anti-Virus scanning on VPS and/or Shared Hosting servers.
#Protecting physical access to network and servers. Data centers are managed & monitored 24x7 by security cameras and on-site staff.

== Hostek.com ==

PCI compliance requires quarterly scans from a PCI compliance vendor. Hostek.com goes above and beyond this requirement by having regular scans from two different PCI compliance vendors. One vendor's scans are done quarterly. The other's scans are done nightly. This ensures that all potential PCI compliance issues are accurately identified and dealt with promptly.

===Hostek.com PCI Compliance Report ===
Hostek.com PCI DSS Compliance report: [[Media:PCI-DSS-Compliance-hostek-com.pdf]]

==Datacenter==
The data center where the hostek.com equipment is housed maintains SOC 2 Certification ([[FIle:SOC2_CERT_2013.pdf]]). This replaced the SSAE16 Certification.

Full audit report part 1: [[File:SOC2-2013_CYBERCON_Full_Report_PART-1.pdf]]

Full audit report part 2: [[File:SOC2-2013_CYBERCON_Full_Report_PART-2.pdf]]

===Previous Certifications===
2011-12 - SSAE 16 Certification ([http://hostek.com/forms/SSAE-16_Letter_of_Cert.pdf audit report]). This replaced the SAS 70 Type 2 Certification.

==Common PCI Compliance Resolutions==

===SSL/TLS Protocol Initialization Vector Implementation Information Disclosure===

aka: BEAST (Browser Exploit Against SSL/TLS) Vulnerability

'''NOTE:''' If you are on a '''shared server''' or a '''managed VPS''', please submit a support ticket [http://support.hostek.com] and attach/include your PCI scan report. The information below is for our non managed VPS customers.

* Place the following text in a file named '''TLS.reg''' and execute the file. It will add registry values to enable TLS 1.1 and TLS 1.2 support:
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.1]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.1\Client]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.1\Server]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.2]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.2\Client]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.2\Server]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

* After completing the above step, go to '''Start''' -> '''Run''' -> (type '''gpedit.msc''') -> (click '''OK''')
* Navigate to '''Computer Configuration''' -> '''Administrative Template''' -> '''Network''' -> '''SSL Configuration Settings'''
* Right click on '''SSL Cipher Suite Order''' and choose '''Edit''' (Windows 2008 R2) or '''Properties''' (Windows 2008)
* Select '''Enabled''' and replace the text in the textbox under '''SSL Cipher Suites'''(not to be confused with the '''Notes''' textbox) with the following long line of text(All on a single line - no line breaks or spaces):
TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_AES_256_CBC_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P384,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P521,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P521,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256_P256,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256_P384,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256_P521,TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384_P384,TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384_P521,TLS_DHE_DSS_WITH_AES_128_CBC_SHA256,TLS_DHE_DSS_WITH_AES_256_CBC_SHA256,TLS_RSA_WITH_NULL_SHA256,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256_P256,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256_P384,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256_P521,TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384_P384,TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384_P521,TLS_RSA_WITH_RC4_128_SHA,TLS_RSA_WITH_RC4_128_MD5,SSL_CK_RC4_128_WITH_MD5,TLS_RSA_WITH_NULL_SHA,TLS_RSA_WITH_NULL_MD5
* Click '''OK'''
* Reboot server

===Disable SSLv2 & Strong Cyphers Only & Strong Protocols Only===
If you are on a shared server, please open a support ticket and attach the PCI scan report.

For VPS's: This generally applies to a Windows based server. If you see one of these items on your PCI scan report, download this zip [http://hostek.com/wikifiles/disablessl2-strongcyphersonly-strongprotocolsonly.zip] and extract the appropriate .reg file and put that on your VPS and double click it to make the appropriate registry change to fix the issue. Generally if one of these show on your report, we suggest running all three .reg files to fully take care of the issue at one time.

'''NOTE:''' You will need to reboot the server for these changes to take affect.

====VPS-Windows 2008 Servers====
This free tool can be used to determine if vulnerable or weak protocols or cypers are enabled, and provides the option to disable them.

https://www.nartac.com/Products/IISCrypto/Default.aspx

Changes using this tool require a server reboot to complete them.

Websites that allow testing for SSL Protocols and Cyphers:

https://www.ssllabs.com/ssltest/index.html

http://www.serversniff.net/sslcheck.php

[[Category:Infrastructure]]
[[Category:VPS]]

Hostek infrastructure

2014-01-27T16:48:59Z

Jonc: /* Firewall & IPS */

A significant amount of effort and expense goes into designing and maintaining the network infrastructure to ensure maximum performance and availability of services hosted by hostek.com. Below are some of the highlights of the hostek.com infrastructure.

==Bandwidth providers==

Hostek.com utilizes multiple Internet bandwidth providers. By utilizing multiple vendors for Internet bandwidth, service to the hostek.com network avoids interruption from vendor maintenance and outages. See figure 1 below.

[[File:internet.png|link=|Internet bandwidth providers]]
'''figure 1'''

==Server and storage hardware==

Hostek.com is proud to utilize Dell servers and Dell Compellent & EqualLogic storage arrays.

==Server virtualization with high availability==

Our web servers are virtualized utilizing VMWare vSphere. With VMWare High Availability, should a physical server fail, any virtual machine will be automatically migrated to another physical server and powered on, and resume normal operations. This operation can be completed with the affected virtual machines back in service often in 3-5 minutes! This is an amazingly short time frame to recover from a failed physical server.

Another added benefit to virtualization is that resources such as CPU, RAM, and disk space, can be quickly allocated based on utilization patterns. This ensures optimal performance for your site or mail server with minimal down time.

Due to the nature of certain kinds of workloads, some servers may not be virtualized. 

==Redundant power==

Electricity is provided from two separate power feeds. In addition, our equipment is protected with UPS systems and diesel generators. Servers and storage devices have redundant power supplies, each on separate feeds to help prevent loss of data due to power failures.

==Storage==

Virtual machines, along with their data (i.e. your web site files, email, etc.) reside on enterprise storage arrays. These arrays have the following features:
*Multiple arrays clustered for high performance
*Redundant storage controllers
*Redundant hard drives
*Redundant network adapters
*Redundant storage network switches
*Redundant power supplies connected to redundant power feeds
*All servers are connected to the storage network via multiple paths for performance and redundancy

Additionally, all data on our storage arrays are replicated to standby storage devices daily. This means that should an array cluster fail, the replica can quickly be brought online to resume storage. See figure 2 below for an example of normal operations. Figure 3 is an example of a storage array failover situation. Note that in the failover situation, "Data volume 1" and "Data volume 2" become available on the standby array and virtual machines depending on those volumes may resume normal operations.

[[File:san.png|link=|figure 2]]
'''figure 2''' -- normal operations

[[File:san-failover.png|link=|figure 3]]
'''figure 3''' -- failover situation

==IT security==

*'''Note''' This section is not a comprehensive guide to our IT security. This just serves to highlight some of the general points.

===Firewall & IPS===
Perimeter firewall and Intrusion Prevention System (IPS) exist which perform the following functions:
*Stateful packet inspection
*Deep packet inspection for known malicious attack patterns
*DDoS (Distributed Denial of Service) protection mechanisms

These devices are configured in a load-balanced, high availability cluster.

===SPAM filtering===
All inbound email is filtered using multiple real-time RBL and content inspection technologies.

Additionally, outbound mail from our Windows web servers are checked with anti-SPAM content filters to prevent delivery of mail from your site from being disrupted by compromised mail submission forms from other tenants on the server your site resides on.

===Anti-virus===
Our servers run commercial anti-virus products from reputable software vendors.

==Backups==

We perform daily backups of all web, email, and database servers.

Backups for VPSs are stored off-site in a location that is in a different geographical area than the primary site. This means that should a major disaster occur in the area where the servers running your VPS reside, your data is safe in another location.

==Physical security==

===Restricted access to premises===
The buildings housing our datacenter have a comprehensive security system which include but not limited to the following:
*24x7 on-site security
*Access codes
*Biometric hand scanners
*Electronic proximity readers
*Security surveillance system

===Fire suppression system===
Our equipment is protected by a pre-action, dry pipe fire suppression system.

==PCI Compliance==

[https://wiki.hostek.com/index.php?title=PCI_Compliance Click here] for details on hostek.com's PCI Compliance.

[[Category:Infrastructure]]

Custom Name Servers on a VPS

2014-01-23T15:15:56Z

Jonc: /* VPS Windows Default */

'''How do I setup custom name servers with my Windows or Windows ColdFusion VPS?'''

== Steps ==

#Setup "A" records in your domain name's DNS records for ns1.your-domain.com and ns2.your-domain.com pointing these to the IP address of our nameservers.
#At your registrar, register the name servers. Every registrar is different but this is usually straight forward and they can help you do it if you have trouble.

== Default Name Servers ==
*The DNS server names are included in the email sent to you with server login information.

=== VPS Windows Default ===
ns1 - 64.37.66.145

ns2 - 64.73.203.254

=== VPS cPanel Linux Default ===
ns7 - 66.201.97.248

ns8 - 66.201.98.102

[[Category:VPS]]
[[Category:Windows-VPS]]
[[Category: Linux-VPS]]
[[Category:ColdFusion-VPS]]

Server Management

2014-01-13T20:08:52Z

Jonc: /* Premium VPS Management Services */

'''Server Management'''

Our goal at Hostek.com is to let you focus on what you do best and we will focus on the servers and keeping you running.

As part of this goal, we are now offering free Managed Services for your VPS or Virtual Dedicated server.

__FORCETOC__
==OS Patching==
Hostek.com provides OS Patching for all VPS servers. These patches are automatically applied during night time hours unless you have made previous arrangements with our VPS Management Team.

==Application Patching==
Patching applications such as MS SQL, MySQL, ColdFusion or other Hostek.com installed software is handled on a per request basis.

==Monitoring==
We routinely monitor your VPS or Virtual Dedicated server for high utilization of CPU, RAM, or disk I/O and will contact you with any concerns or suggestions.

==Premium VPS Management Services==
To compliment our already great managed service we offer the Premium VPS Services add-on, this service engagement includes:

*Solution Engineers available to help optimize your infrastructure and your data.
*Help with custom configurations for installed services such as ColdFusion, Railo, PHP, .NET, MySql, MSSQL and more.
*Help with the setup of additional backup, synchronization or custom firewall needs.

Two hours of Premium Management Services is included with the Premium service add-on. Each support case is a 15 minute minimum. Additional time beyond two hours can be purchased at our current hourly rate.

NOTE: This is NOT a supplement for programming or development.

2013-11-14T22:23:54Z

Jonc: /* Installing Razuna on your Windows VPS */

== Hosting Razuna ==
Easily install and setup your own Razuna Hosting at Hostek.com. This can be done on any of our platforms Linux or Windows and we will cover each below. Razuna is a Digital Asset Manager, and commonly used for storing company media such as images, video and audio within a single portal. Read more about the [http://razuna.org/whatisrazuna benefits of Razuna].

=== Installing Razuna on your Windows VPS ===
*Java 7 JDK is required for installation.

#First [http://razuna.org/download download Stand-alone Server] version of Razuna either directly to your VPS or upload to your server after downloading directly.
#Run the installer for Razuna, which will install Tomcat and OpenBD (an opensource CFML engine).
#To enjoy all of the features of Razuna you will also need to install many free add-on products. We recommend installing all of these as suggested in the [http://wiki.razuna.com/display/ecp/Install+Razuna+on+Windows Razuna Installation Documents].
#After installation you will be able to access your Razuna installation and finalize setup at: '''http://your-server-ip:8080/razuna'''

2013-06-04T19:42:47Z

Jonc:

==How do I see all running processes in MySQL?==
#Open up a command prompt on your server
#Log into MySQL with this command: <pre>mysql -u root -p</pre>
#Enter your root MySQL password when prompted
#Issue this command: <pre>SHOW FULL PROCESSLIST\G</pre>

MySQL will display a full list of running processes along with the state of the query and the SQL being ran at that time.

==VPS - How do I log slow queries?==
You can set the this options in the my.cnf/my.ini option files

<pre>
log_slow_queries = 1
slow_query_log_file = <some file name>
</pre>

If your server is above 5.1.6 you can set the slow query log in the runtime itself. For which you have to execute these queries (as root).

<pre>
set global log_slow_queries = 1;
set global slow_query_log_file = <some file name>;
</pre>

[[Category:Databases-MySQL]]

VPS Resources

2013-05-30T19:40:49Z

Jonc: /* Storage configuration */

PCI Compliance

2013-05-10T20:06:27Z

Jonc: /* Datacenter */

__FORCETOC__

==hostek.com==

PCI compliance requires quarterly scans from a PCI compliance vendor. Hostek.com goes above and beyond this requirement by having regular scans from two different PCI compliance vendors. One vendor's scans are done quarterly. The other's scans are done nightly. This ensures that all potential PCI compliance issues are accurately identified and dealt with promptly.

==Datacenter==
The data center where the hostek.com equipment is housed maintains SOC 2 Certification ([[FIle:SOC2_CERT_2013.pdf]]). This replaced the SSAE16 Certification.

Full audit report part 1: [[File:SOC2-2013_CYBERCON_Full_Report_PART-1.pdf]]

Full audit report part 2: [[File:SOC2-2013_CYBERCON_Full_Report_PART-2.pdf]]

===Previous Certifications===
2011-12 - SSAE 16 Certification ([http://hostek.com/forms/SSAE-16_Letter_of_Cert.pdf audit report]). This replaced the SAS 70 Type 2 Certification.

==Common PCI Compliance Resolutions==

===SSL/TLS Protocol Initialization Vector Implementation Information Disclosure===

aka: BEAST (Browser Exploit Against SSL/TLS) Vulnerability

'''NOTE:''' If you are on a '''shared server''' or a '''managed VPS''', please submit a support ticket [http://support.hostek.com] and attach/include your PCI scan report. The information below is for our non managed VPS customers.

* Place the following text in a file named '''TLS.reg''' and execute the file. It will add registry values to enable TLS 1.1 and TLS 1.2 support:
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.1]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.1\Client]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.1\Server]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.2]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.2\Client]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.2\Server]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

* After completing the above step, go to '''Start''' -> '''Run''' -> (type '''gpedit.msc''') -> (click '''OK''')
* Navigate to '''Computer Configuration''' -> '''Administrative Template''' -> '''Network''' -> '''SSL Configuration Settings'''
* Right click on '''SSL Cipher Suite Order''' and choose '''Edit''' (Windows 2008 R2) or '''Properties''' (Windows 2008)
* Select '''Enabled''' and replace the text in the textbox under '''SSL Cipher Suites'''(not to be confused with the '''Notes''' textbox) with the following long line of text(All on a single line - no line breaks or spaces):
TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_AES_256_CBC_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P384,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P521,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P521,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256_P256,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256_P384,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256_P521,TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384_P384,TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384_P521,TLS_DHE_DSS_WITH_AES_128_CBC_SHA256,TLS_DHE_DSS_WITH_AES_256_CBC_SHA256,TLS_RSA_WITH_NULL_SHA256,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256_P256,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256_P384,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256_P521,TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384_P384,TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384_P521,TLS_RSA_WITH_RC4_128_SHA,TLS_RSA_WITH_RC4_128_MD5,SSL_CK_RC4_128_WITH_MD5,TLS_RSA_WITH_NULL_SHA,TLS_RSA_WITH_NULL_MD5
* Click '''OK'''
* Reboot server

===Disable SSLv2 & Strong Cyphers Only & Strong Protocols Only===
If you are on a shared server, please open a support ticket and attach the PCI scan report.

For VPS's: This generally applies to a Windows based server. If you see one of these items on your PCI scan report, download this zip [http://hostek.com/wikifiles/disablessl2-strongcyphersonly-strongprotocolsonly.zip] and extract the appropriate .reg file and put that on your VPS and double click it to make the appropriate registry change to fix the issue. Generally if one of these show on your report, we suggest running all three .reg files to fully take care of the issue at one time.

'''NOTE:''' You will need to reboot the server for these changes to take affect.

====VPS-Windows 2008 Servers====
This free tool can be used to determine if vulnerable or weak protocols or cypers are enabled, and provides the option to disable them.

https://www.nartac.com/Products/IISCrypto/Default.aspx

Changes using this tool require a server reboot to complete them.

Websites that allow testing for SSL Protocols and Cyphers:

https://www.ssllabs.com/ssltest/index.html

http://www.serversniff.net/sslcheck.php

[[Category:Infrastructure]]
[[Category:VPS]]

File:SOC2-2013 CYBERCON Full Report PART-2.pdf

2013-05-10T19:56:56Z

Jonc: Datacenter SOC 2 FULL Audit Report part 2 - 2013

Datacenter SOC 2 FULL Audit Report part 2 - 2013

File:SOC2-2013 CYBERCON Full Report PART-1.pdf

2013-05-10T19:56:22Z

Jonc: Datacenter SOC 2 FULL Audit Report part 1 - 2013

Datacenter SOC 2 FULL Audit Report part 1 - 2013

File:SOC2 CERT 2013.pdf

2013-05-10T19:51:13Z

Jonc: Datacenter SOC 2 Audit Certification - 2013

Datacenter SOC 2 Audit Certification - 2013

WCP (Windows based Control Panel)

2013-04-02T19:08:18Z

Jonc: /* MSSQL Tools */

==How To Login To My WCP Control Panel==
#To manage your domain, login to the WCP Control Panel, using the details below
#URL: '''https://wcp.hostek.com'''/
#Username:
#Password: ** same as your cp.hostek.com password **
*You can also login to the control panel through your billing control panel https://cp.hostek.com/clientarea.php
#Click on ''''My Services'''' 'Click the '''small Green arrow''' on the the notepad to the right'
#Now click the '''Login to Control Panel''' Icon'''

[[Category:Windows]]
[[Category:ColdFusion]]
[[Category:Railo]]

==Custom URL for the WCP Control Panel==
The WCP can als be accessed by wcp.your_domain.com

Setup wcp.your_domain.com as an A record for "184.175.108.65" or as a CName record for "wcp.ezhostingserver.com".

===Resellers and VPS - WCP White label Settings===
Resellers and VPS customers can setup their logo in their Reseller control panel, however those additional features will only be avaialble when using the specific domain they configured in the reseller setttings. The reseller settings will be available using ANY url, and as mentioned within these settings the reseller "URL" can be setup and other whitelabel options making WCP the ultimate Windows Control Panel

[[Category: Windows VPS]]
[[Category:Resellers]]

==Adding Additional Control Panel Logins==
*This will allow you to set up additional control panel logins for you or for others involved in editing or managing your account. You can limit the Permissions or options available for them to manage.
#Login to the WCP Control Panel, using the details below
#URL: '''https://wcp.hostek.com'''/
#Username:
#Password: ** same as your cp.hostek.com password **
#Click on the '''Control panel Logins''' tab, then click on the '''Add''' icon.
#Put the "Username, Password and if you want them to have Limited Permission.
#If you want them to have Limited Permission then check the '''Limited Permission''' box. This will load a dropdown where you can select what privlages they have to manage.
#Once you are done click the '''Save''' icon at the bottom of the screen.
#Once it has bee added you or they can login by going to https://wcp.hostek.com/Login.aspx and using the username and password that you set for it.
[[Category:Windows]]
[[Category:ColdFusion]]
[[Category:Railo]]

==VPS and Unlimited Plans - Add Additional Domains==
Use these steps to add additional domains under your VPS or Windows Unlimited account.

#Login to your WCP control panel
#*Windows Unlimited: For adding a third (or more) domain select any domain from the upper right hand corner dropdown box "Domains".
#*'''VPS: Select a domain already created''' on your VPS, a good bet is your server name (ie server.your-domain.com) from the upper right hand corner dropdown box "Domains".
#Within the "Domains" box click the "Addon Domains" icon.
#Click "Add" and enter the following:
#*Domain Name
#*Username
#*Password
#*VPS: If you've ordered static IP's select one from the "IP Address" box.
#Click "Save"
#To manage the domain, you can now select it from the domains list dropdown box.
[[Category:Windows]]

==Site Details==
We recommend you review the "Site Settings" which includes many important details about your domain including:

WCP (login and select domain) > Website Settings > '''Site Details'''

*Testing URL
*Primary and Secondary DNS
*Site IP
*Web Root Path
*FTP Root Path
*IIS & ColdFusion Version (if applicable)

==FTP Accounts==
*Adding or editing FTP accounts.
#click on the '''FTP Accounts''' tab.
#To edit one click on the little '''Pencil Icon''' to the left, to add one click on the '''Add FTP User''' tab.
#If you are adding one you will set the Username:, Password: and folder then click the #Click on the '''Save''' Icon.
[[Category:Windows]]
[[Category:ColdFusion]]
[[Category:Railo]]

==File Manager==
*Basic File Operations, file uploading and editing now supported- Zip, GZip, and Tar Archive support.
#Click on the '''File Manager icon''', then the '''Login icon''' on the next screen.
#To create files or Directory's outside the WWW root folder right click and click on the '''Create File''' or '''Create Directory''' option.
#Click the '''Continue Icon''' to add this.
#To add/edit files in the WWWroot click on the '''wwwroot file'''.
#once you are in you can add, edit or delete by right clicking and clicking on the options given.
[[Category:ColdFusion]]
[[Category:Windows]]

==IIS Settings==
*Setting up error pages, default pages, advanced settings, etc.
===Custom Error pages===
#Click on '''IIS Settings''' in your WCP
#Click the edit button next to the error page you want to change
#Uncheck the '''Use System Default''' checkbox
#Enter the path to your custom error page
#Click '''Save'''
===Mime Types===
#Click on '''IIS Settings''' in your WCP
#Scroll to the bottom of the window and click '''Add Mime Type'''
#Enter the extension for the Mime Type
#Enter the Mime Type information
#Click '''Save'''
*An example Mime Type is below:
<pre>
Extension: .mp3
Mime Type: audio/mpeg
</pre>

More information here: https://wiki.hostek.com/Mime_types

===Default Docs===
*Select a default document and drag it to the top position to set it as top priority
*Click '''Add''' to add a default doc
*Click the red '''X''' to delete a default doc
*Click a default doc and change the name
*For example: change '''"index.htm"''' to '''"index.asp"'''

===Advanced===
====Recycle Application Pool====
If you see a Service Unavailable message on your site, or have a general need to recycle a site's IIS Application Pool, you can do so through this section of WCP.
#Click the '''IIS Settings''' icon in WCP
#Click the '''Advanced''' tab in the '''IIS Settings''' section
#Click the '''Recycle''' button.

[[Category:ColdFusion]]
[[Category:Windows]]

==DNS Editor==
'''READ FIRST''' When a new domain is added to WCP all DNS records are also created (in most cases). Clicking on the DNS Editor will open a window with these records, for editing, adding and deleting. Most times nothing needs to be done other than pointing your domain to the Primary and Secondary DNS Servers listed under [https://wiki.hostek.com/WCP_(Windows_based_Control_Panel)#Site_Details WCP Site Details].

===Create a new DNS record===
#Click '''Add DNS''' Record button
#Enter Name for record (If DNS record name is your domain name please leave this Name - text box blank as the control panel will automatically add your domain name)
#Choose the Record type (A, CNAME, MX, NS, TXT, SPF, SRV)
#Enter Data Type
#Generally leave the TTL (Time To Live) as the default 86400
#Click on the '''Save''' Icon.

===Update DNS records===
#To update an existing DNS record click the '''Pencil''' icon next to the record you would like to update.
#You will then be able to change the Name of the record, the Type of record, Data of the record, and Time to Live.
#Once updated Click on the '''Save''' Icon.

===SVR Record Fields===

<pre>
Name: _service._protocol
Type: SRV
Data: priority weight port address
TTL: 86400
</pre>

Example:
<pre>
Name: _sip._udp
Type: SRV
Data: 10 5 4030 sip.mydomain.com
TTL: 86400
</pre>

===SPF Records===
An SPF Record (simply an entry into the DNS records) is used by mail servers to know if mail coming from an address at your domain is really allowed to be sent from the sending mail server.

If you will be using our servers send email related to your domain, you would generally use an SPF record like the following:<pre>"v=spf1 a mx include:spf.hostek.com -all"</pre>

For our Resellers that don't want to use hostek.com, use an SPF Record like:<pre>"v=spf1 a mx include:spf.ezhostingserver.com -all"</pre>
'''Steps to add an SPF Record to your domain:'''
Assuming that your DNS is managed with us:
#Log in to your hosting control panel at wcp.hostek.com
#Open the DNS Editor (DNS Manager) section
#Click on Add Record.
#Leave the Name field blank.
#For the Type, choose TXT
#For the Data enter the SPF Record detail as you need, using the sample provided above.

'''Basic information related to some SPF Record options:'''

The '''"-all"''' may be adjusted on a per customer basis to any of the following depending on their needs:

'''-all''' = mail not sent from an address listed in the SPF record should be completely rejected (Hard Fail). Mail that IS sent from an address in the SPF record may be given a lower spam score by some servers.

'''~all''' = mail not sent from an address listed in the SPF record should be given a higher spam score(Soft Fail). Mail that IS sent from an address in the SPF record may be given a lower spam score by some servers.

'''?all''' = mail not sent from an address listed in the SPF record should be treated normally as if the domain did not have an spf record (Neutral). Mail that IS sent from an address in the SPF record may be given a lower spam score by some servers.

[[Category:Windows]]
[[Category:ColdFusion]]
[[Category:Railo]]

==Sub Domains==
*A sub-domain is like an extension of your domain name. For example, if your domain name were myfamily.com, a sub-domain would be in the following form: dad.myfamily.com or mom.myfamily.com etc.
*You can have a sub-domain pointed to any folder within your web site. If a visitor goes directly to that sub-domain he will be taken to that folder, not to your site's main page.
#Click on the '''Sub Domains icon'''
#Click "'''Add'''" sub Domain button
#Enter sub domain name in Name text box. This will automatically populate the Folder text box to a folder with the same name as the subdomain.
#If you wish this Subdomain to point to a different folder you can click on the folder icon and choose the directory you would like your Sub Domain to point to.
#Click on the "'''Save'''" Icon.
#This will create the sub domain record within your domains DNS zone,
*If the domains name servers are not pointed to us you will need to manually create this record where your domains DNS is hosted.
[[Category:Control-Panels]]
[[Category:Windows]]
[[Category:ColdFusion]]
[[Category:Railo]]

==Domain Alias==
*This will allow you to point 2 domains to the same website. How to create a Domain
#To create a domain alias you will click on the ''Domain Aliases icon''
#Click '''Add Domain Alias''' button
#Enter your Alias Name
#Click on the "'''Save'''" Icon.
*You will need to be sure that your Domain Alias has been registered and has the name servers pointed to the name servers found beneath the Site Details icon.

==Email==
*Below is information on how to manage your email account within the WCP.
*'''FOR VPS''' You will also have "Admin" access to SmarterMail. Access webmail (click the webmail link in WCP) and login with user "admin" and the primary VPS password.

==Email Users==
*Allows you to create Email users as well as log directly into users Webmail account
#Once you are logged into your WCP account, under the Email Section
#Click '''Users''' icon
#Click '''Add Email User''' button
#Enter email user name (Example: if you need the email address "admin@domain.com" enter the user "admin")
#Enter password for Email user (**See note below regarding password requirements)
#Enter Display name (Usually set to the name of the person using the specific email account)
#Choose if you would like this user to have administrator rights
#Choose mail box size limit for this specific user
#Click on the '''Save'''
#'''NOTE Password requirements'''
*Minimum Length 6 Characters
*Must include Uppercase
*Must include Lowercase
*Must include Number
*Must include Special character
*Password cannot match username

==Edit existing Email user==
#Once you are logged into your WCP account, under the Email Section
#Click '''Users''' icon
#Click '''pencil icon''' next to user to update
#Update information
#Click '''Save'''

==Web mail==
#Once you are logged into your WCP account, under the Email Section
#Click '''Login button''' next to user you would like access the mail for
*Web Mail Provides links to access the Webmail program as well as to access mail before domain propagation to our mail server
#Click '''Web Mail icon'''
#If domain is propagated and pointed to our mail server you can click the '''webmail''' link to access the SmarterMail webmail log in screen.
#If you domain has not yet propagated to our mail server click the "Pr-Propagation Web Mail" link to access the SmarterMail webmail log in screen.

==Mail Forwarding==
#Once you are logged into your WCP account, under the Email Section
*Allows you to set up an email alias.
#Click on the '''Forwarding button'''
#Enter Alias name
#Enter address for email to this Alias to be forwarded to
#Click on the '''Save Icon'''

==MySQL database==
*MySQL Allow you to create a MySQL database under your domain
#Click on '''MySQL icon'''
#To add new database click '''Add MySQL Database'''
#Enter Database Name
#Enter Username
#Enter Password
#(If you need a coldfusion DSN place check in check box and provide Coldfusion DSN name)
#Click '''Save'''

*To create new user for existing database
#Click '''MySQL icon'''
#Click '''Add new user button'''
#Enter Username
#Enter Password
#Place check mark in check box for each database you would like this user to have access to.
#To update the password on existing database user.
#Click '''MySQL icon'''
#Click '''pencil icon next to Username'''
#enter new password
#Click on the '''Save Icon'''.

*To update the password on existing database user.
#Click '''MySQL icon'''
#Click pencil '''icon next to Username'''
#Enter new password
#Click on the '''Save''' Icon.

==PhpMyAdmin==
*Allows you to log directly into your MySQL database to manage.
#Click on '''PhpMyAdmin link'''
#If you are not logged directly into your MySQL database simply enter the server your database is located on (Can be found by clicking the MySQL icon) and enter your Username and Password.
#Once logged in your Databases will be displayed on the Left, click on '''database name''' to manage that database.

==MSSQL==
*Allows you to create MSSQL databases and users.
#Click '''MSSQL icon'''
#To add a new database click '''Add MSSQL''' database
#Enter Database Name
#Choose database size
#Enter or Choose existing Username
#Enter Password
#Choose '''Default Collation''' (Usually left as default)
#Choose '''Recovery Model''' (Usually left as Simple as we make daily full backups of all #databases which we keep for 7 days)
#Place a Check mark in the box for Coldfusion DataSource if ColdFusion DSN is needed.
#Enter ColdFusion DSN name.
#Click on the '''Save''' Icon.

*To edit an existing MSSQL database
#Click '''MSSQL icon'''
#Click '''Pencil icon''' next to database name to edit
#Edit field necessary
#Click on the '''Save''' Icon.

*To edit password for existing MSSQL user
#Click '''MSSQL icon'''
#Click '''Pencil next''' to user to edit
#Update password
#Click on the '''Save''' Icon.

*To add new MSSQL user
#Click '''MSSQL icon'''
#Click '''Add MSSQL''' User button
#Enter username
#Enter password
#Place checkmark next to each database this users needs access to
#Click on the '''Save''' Icon.

==MSSQL Tools (Shared Hosting)==
*Allows you to log directly into MyLittleAdmin to manage your MSSQL database or MyLittleBackup to backup or restore your MSSQL database.
#Click '''MSSQL Tools''' icon
#Select database to Manage/Backup/Restore
#Select User with access to database needed
#Choose myLittleAdmin button to manage your MSSQL database
#Choose myLittleBackup button to backup/restore your database

==DataSources(DSN's)==
*Allows to create a DSN for an existing database for your domain.
#To create a MySQL or MSSQL DataSource
#Click '''DataSources''' (DSN's) icon
#Choose MySQL or MSSQL from drop down depending on the database this is connecting to
#Click '''Add DSN'''
#Choose DSN type Access/MySQL/MSSQL
#Enter DSN name
#Enter Database name DSN will be connecting to
#Enter Server (Can by found by viewing database DSN is for)
#Enter Username for database DSN is connecting to
#Enter Password for database DSN is connecting to
#Choose if it is a ColdFusion DSN
#Choose if you need Unicode Support
#Click on the '''Save''' Icon.

*To create an Access DataSource
#Click '''DataSources''' (DSN's) icon
#Choose '''Access''' from drop down menu
#Enter DSN Name
#Click on Folder icon to choose correct directory Access Database is located in
#Enter Username (If one is set for your Access Database, if not this can be left blank)
#Enter Password (If one is protecting your Database, if not this can be left blank)
#Choose if it needs to be a ColdFusion DSN
#Click on the '''Save''' Icon.

*To edit existing DSN
#Click '''DataSources''' (DSN's) icon
#Click pencil next to DSN to edit
#Update information
#Click on the '''Save''' Icon.

==Security and SSL==
Installing a new certificate, or re-keying an existing certificate.

===Dedicated SSL===
'''VPS Hosting''' Request a static IP for sites added to your server which require SSL, we will provision the IP on the server and assign it in WCP for use with installing a Dedicated SSL.

'''Shared Hosting''' If ordering a new certificate from Hostek.com you will be assigned a static IP, if importing from another provider you will need to request a static IP be assigned before the certificate can be activated.

#Login to WPC, (select the domain, in some cases), Security and SSL, '''Dedicated SSL (click)'''
#Click '''Generate CSR (Certificate Signing Request)'''
#Fill in the requested information.
#Click Create
#Copy the '''Certificate Signing Request (CSR)''', which should be used when placing a new SSL order or re-keying an existing certificate.

===Shared SSL(shared hosting)===
#Login to WPC, (select the domain, in some cases), Security and SSL, '''Shared SSL (click)'''
#Click '''Enable'''
#The URL for your sites shared SSL will be provided.

[[Category:Control-Panels]]
[[Category:Windows]]
[[Category:ColdFusion]]
[[Category:Railo]]
[[Category:ColdFusion-VPS]]
[[Category:Railo-VPS]]
[[Category:Windows-VPS]]

Seamlessly Change Hosting to Hostek.com

2013-04-01T18:53:56Z

Jonc: /* your-provider to Hostek.com Windows VPS */

==Steps to Changing Hosting Providers==

# [https://wiki.hostek.com/Changing_Hosting_Providers#Sign_up_for_hosting Sign up with Hostek.com]
# Transfer your site files and databases. Specific details for moving to: [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_Shared_Hosting Shared Hosting] or [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_VPS VPS Hosting]
# [https://wiki.hostek.com/Changing_Hosting_Providers#Planning_Ahead Test your site(s)]
# [https://wiki.hostek.com/DNS_(Name_Servers) Update Your Domain Name's Name Servers] NOTE: you will find the Name Server information in the New Hosting Account Email.

==Planning Ahead==
*Transferring hosting companies can be, and should be, easy if you follow the right steps and choose the right hosting company. You have made the correct choice in hosting companies, as we have many years experience in helping customers just like you transfer their hosting to us. We've created this easy-to-follow list for you to transfer your website to Hostek.com.

#Plan as far ahead as possible, the more detailed the better.
#Make sure your customers are well informed of any possible service interruption and changes they should consider well in advance.
#Test each site after uploading the files, importing databases and updating connection strings to make sure no errors are occurring. Use the Testing URL provided in the email after setting up hosting.
#Complete unfinished business, including tightening security on any ports or protocols that do not need to remain open to the public.

===For sites with constantly changing data===
The most difficult sites to move are those that have constantly changing data. The is because updates made during the backup & transfer will not be reflected in the data backup being moved.

To resolve this:

Perform the transfer during off-peak hours. In addition display a "under construction" page on both the new and old server while the transition is in progress.

After the site move has been completed, update your DNS as quickly as possible and leave the old site stopped. In some cases pointing the website on the previous host to the database on the new website will allow both sites to run without inconsistent data.

Another solution to insure quick switch over is setting the DNS, TTL to a low value such as 600 (10 minutes) on A records for domains being moved.

===Pre-Migration Site Assessment===

;Domains List
:Which domains are hosted and need moved?
:Do they require SSL?
:Are there any other hostnames that point to the site such as a sub-domain or alias?
:Special requirements such as a Virtual Directory or Sym Link?

;Database List
:Types of databases?
:User and permissions for each user?
:Password for each user?

;Domains with Mail
:Which domains USE mail?
:How do users access email, POP, IMAP, Web?
:Server URL for POP, SMTP, IMAP and Web?
:Special requirements such as SSL?

;Domains with FTP
:User and permission such as directory, read/write for each user?
:Passwords for each user?

;Registrar for each Domain?
:Where can the Name Servers be updated?
:Login for the Account?

;DNS for each Domain
:Where is it managed?
:Will DNS management be moved?
:Should we set the TTL low for any to insure quick switchover?

==Sign up for hosting==
The First step in transferring is to sign up for a hosting package. We offer a wide range of hosting packages that will fit your needs. After signing up for a hosting package, you will get an email with a Testing URL and Temporary FTP information. Use this information to complete the next task of moving your site files.

[http://hostek.com/hosting/web-hosting/best-web-hosting.asp Web Hosting] Windows / Linux / ColdFusion / Railo

[http://hostek.com/reseller-hosting.asp Reseller Hosting]

[http://hostek.com/hosting/vps/best-vps-hosting.asp VPS (Virtual Private Server) Hosting]

[http://hostek.com/hosting/dedicated/virtual-dedicated-hosting.asp Virtual Dedicated Hosting]

Custom VPS or Infrastructure as a Service Solutions contact [mailto:vps_sales@hostek.com VPS sales.]

==your-provider to Hostek.com Windows Shared Hosting==

===Moving Site Files and Databases===
#Open an FTP(File Transfer Protocol) client on your computer. If you do not have one, you can download FileZilla for free at "http://filezilla-project.org/download.php/".
#Connect to your site on your old host. Generally, the connection details will either be in an e-mail you received from them or listed in your control panel with them.
#Once connected, you should see two sets of files, local (files on your computer) and remote (files on your website). Under your local files, create a folder to store your site files.
#Once the folder is created, open that folder on the local side. Then, select all the files on the remote site and download them into that folder.
#Wait for the transfer of all files to complete. This may take several minutes.
#Once the transfer is complete, disconnect from the server. Then connect to your site on our server using the FTP details that we sent in your account details e-mail.
#On the remote side, open the /wwwroot folder. Also, on the local side, if there is a 'www', 'wwwroot', or 'public_html' folder, open that folder as well. #Select all files on the local side and upload them to the remote side.
#Wait for the transfer of all files to complete. This may take several minutes.
#Done - your site files have been moved.

===Databases===

====MSSQL====
#Request a full backup of your database from your host, or create one through their control panel if you have that option.
#Once you have the full database backup (should be a .bak file), login into your WCP control panel at "https://wcp.hostek.com" using the same e-mail address and password as your billing control panel.
#Once logged in, select 'MS SQL', and click 'Add MS SQL database'. Enter the same name as the backed up database and give it a size that is larger than the .bak file. Enter a username and password and click 'Save'.
#Now that the database has been created on the new server, choose the 'MS SQL Tools' option. Select the database and user, and click on the 'myLittleBackup' button.
#Click 'Restore databases'.
#Select the database from the drop-down.
#Click 'OK'.
#Click the 'Choose File' button and select the .bak backup file from your old host and click 'Ok'.
#The backup file will most likely only have one backup set so you
will not have to worry about selecting one. If there are multiple,
select whichever one has the most recent backup date.
#Click 'Restore' and click 'OK' on the popup.

NOTE: If you have any issues restoring the database due to the size or structure of the database, you may need to upload the backup file to your website and ask support to restore the database. If you do this, it is recommended that you zip the backup file before uploading it as that will make it much smaller.

===Update your domain’s DNS===
*Update your domain’s DNS settings Once you have tested your site, contact your domain name registrar and change your DNS settings to the Name Servers we provided in the New Account email. Your registrar is the company you purchased your domain name from. You’ll replace your existing primary and secondary name servers with the ones we provided you in the new account email. This change will take about 12 to 48 hours to propagate throughout the internet.

===Wait for your domain to propagate===
*Wait for your domain to propagate (approximately 12-48 hours) While your domain propagation is taking effect, some will see your site on our servers and others will see the site on your old host. This will prevent any downtime. In order to receive mail from both locations, you will need to check email from both hosts. You can simply use our web mail interface to get the email that is sent to our servers during

===Cancel with your previous host===
Cancel with your previous host After the site is pointing to us, you can go and cancel the hosting account you have at your previous host.

===Transfer your domain name to our registrar (optional)===
Transfer your domain name (optional)If you would like to transfer your domain and consolidate your registration and web hosting to one source, you can request to transfer the domain. The domain transfer itself costs NOTHING; we simply add one year of registration onto the expiration date for a base price for the common .TLD's. After that, you will able to renew your domain name at the same great price.
A registrar transfer is the moving a domain name from one registrar to another. A registrar is the company that actually registers a domain name.
#You will need to log into your billing control panel at https://cp.hostek.com
#Click on the domains drop-down menu and click "My Domains".
#Scroll down to your domain name and click "Manage Domain"
#Click the "Registrar Lock" tab, then click the "Disable Registrar Lock" button.
#Click on the "Management Tools" drop-down menu and select "Contact Information"
#You will need to update the Admin contact email address to an email address that you can receive emails at and click "Save Changes".
#Click "Management Tools" drop-down and select "Get EPP Code". This will display the EPP code that you will need to provide to the registrar you are transferring to.
#Once you have initiated the transfer with the registrar and provided the EPP code you will receive a transfer approval email at the email address you specified.

==your-provider to Hostek.com Windows VPS==
*We recommend setting up each domain using WCP as you move them, not all at one time. Doing so ensures there are less complications with mail delivery between two domains.

[[media:Hostek.com_Migration_Checklist.xls | Download this Migration Checklist]] to keep track of your migration progress.

===Moving Domains===
Familiarize yourself and your team with our [https://wcp.hostek.com Windows Control Panel]. We have prepared a [https://wiki.hostek.com/WCP_(Windows_based_Control_Panel) WCP Guide] to help.

#Create the domain using the "addon domain" icon in the WCP.
#*When initially logging into WCP the domain which was used for referencing your VPS will be listed and new domains added.
#*If you selected a database server be installed locally or remotely it should be integrated with your control panel and databases can be added under each domain using the appropriate Icon.
#*Note if you ordered the FREE SmarterMail edition which only includes mail for a single domain, upon adding your second domain you may encounter an error. If so contact support for upgrading your SmarterMail license or disabling the action for adding new domains to the mail server.
#DNS zones are automatically created for new domains, for the name servers which are used for domains added to your VPS click on the "Site Details" icon within the WCP for the domain in question.
#Copy files to your VPS. Use FTP directly from your VPS to transfer site files, this is extremely fast and efficient.
#Test the domain. Each domain will have a "Testing URL" within the "Site Details" area of WCP, note that if the database is not moved over and or DSN not created you may encounter errors.
#Prepare the DNS for moving. Before switching your DNS we suggest a shorter TTL such as 300 (5 minutes), after this change you must wait out the original TTL before the new value will take affect. For example if your original TTL was 7200 seconds (2 hours) you must wait 2 hours after submitting any change before the new TTL will be take effect.
#Switch your DNS. By now your site is tested and you're ready to make the switch.
#*In most cases we suggest moving the database first so data will be consistent from the old location to the new.

===SSL===

*Our Windows Control Panel has provisions for creating a CSR and installing a new certificate but you cannot "import" an existing certificate. There are two ways to resolve "moving" a certificate to a Windows server easily.

====Pkey format====
#Export the certificate in PKey format. Within the certificate manager, export the current certificate in PKey format, you will be asked for a "passphrase" assign one and remember it.
#Copy the certificate to the new server.
#Open IIS on your VPS, open the main server node then click on the icon "Server Certificates" found under >> IIS >> Server Certificates.
#Click import and follow the prompts.
#Edit the bindings for the specific site to assign the certificate
#*Right click on the website in Sites >> your-website.abc select "Edit Bindings".
#*Select "Add" change the type to https, select the IP Address, select the "SSL Certificate" from the drop down.

====Re-key the certificate====
*Using this method could render the SSL certificate expired on the old server.

#Click on the "Dedicated SSL" icon in WCP.
#Fill in the appropriate information to generate a CSR.
#At your certificate provider request a "rekey" using the CSR provided from WCP.
#After receiving the new certificate back from your provider, complete the installation in WCP.

===Databases===

====MSSQL====
#Add the database and user in MSSQL using the WCP under the correct domain.
#Set the database to single user mode on the new server.
#*<pre>USE database_name ALTER DATABASE [DB_NAME_HERE] SET SINGLE_USER WITH NO_WAIT</pre>
#Using SQL Studio Manager restore from backup selecting the file you exported from your previous server.
#Set the database to multi user mode on the new server.
#*<pre>USE database_name ALTER DATABASE [DB_NAME_HERE] SET MULTI_USER WITH NO_WAIT</pre>
#To fix user a created user which existed before the database was restored.
#*<pre>USE database_name Exec sp_change_users_login 'auto_fix','USERNAME'</pre>
#In some cases you may continue to receive errors. Try adding double slashes for the file restore paths. Here's a scripted example:
<pre>
RESTORE DATABASE [exampledatabase] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\exampledatabase.bak'
WITH FILE = 1, MOVE N'old_database_name_Data' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.mdf',
MOVE N'old_database_name_Log' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.LDF',
NOUNLOAD, REPLACE, STATS = 10
GO
</pre>

===Don't forget===
*Scheduled tasks, add them on the new server remove them from the old.
*Change the DNS TTL back to default.

=== Mail===

====SmarterMail to SmarterMail====

#See the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration] for preparing the MX record and SSL (if applicable). You can however skip the step for creating users / passwords on the new server since you will be moving everything at once.
#Zip the contents of the {smartermail root}\domains\yourdomain.com.
#FTP the files from the old server to the new, this can be done by installing a simple FTP client such as FileZilla on the VPS and connecting to the old server.
#On the new VPS unzip and overwrite the contents {smartermail root}\domains\yourdomain.com.
#Login to the SmarterMail Webmail interface, "Reload" the domain. This should cause all the users to be revealed, with their inbox, calendar and other assets intact.
#Complete the "Final Steps" mentioned under [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration].

====Any Provider to Windows & Smartermail====

Easily migrate from any mail service. Move a single mailbox, or an entire domain, from mail services like:

Gmail
Yahoo!
Hotmail / Windows Live
Microsoft Exchange
Or even mail servers like Merak, iMail and MailEnable

We suggest following the "Preparation Steps" under the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration]. Then follow the steps provided by SmarterMail.

http://portal.smartertools.com/KB/a1937/import-mailbox-data-to-smartermail-from-third-party.aspx

====Why move one domain at a time?====
If you setup domain X, Y, and Z via WCP, then migrate X from your old server to Hostek. If a user on X tries to email someone on domain Y or Z they'll get a kickback saying "No such user." This is because you haven't migrated the data over into these other accounts yet. The server will try to send the message locally before it goes "outside" to resolve it's IP address. Setting up new domains "as you go", will avoid this possibility.

If mail is not involved in the migration, then you may not need to worry about this issue.

==your-provider to VPS Mail Migration General Information==
There are various ways to migrate mail from an existing provider. In cases where POP is the method for retrieving mail then simply switching providers in a thoughtful preplanned manner is sufficient.

===Keys for simple POP/SMTP Mail Migration===

====Preparation Steps for Mail Migration====
#Create domain on the new server.
#Setup users & passwords in advance on the new server.
#Take note of the specific DNS details and modify the TTL.
#*Note the MX record.
#*Set the TTL for the MX record to 600 (10 minutes).
#*If the MX is set to "something.yourdomain.com", then also change the TTL for the A record "something.yourdomain.com" to 600 (10 minutes).
#Does your mailserver use SSL? Note, if the SSL mail encryption works for "mail.yourisp.com" and you're moving to a VPS then you will likely have to also purchase and have the certificate installed and insure the exact same type of SSL support works before proceeding.

====Final Steps to complete the Mail Migration====
#Plan and prepare users with what they should expect.
#Be sure your mail server is listening on the IP Address you will point the A record to
#We suggest to create or modify the A record "something.yourdomain.com" if it already exists, when you are ready to make the switch change that A record "something.yourdomain.com" to point at your VPS.
#When finished change the TTL for the MX record and applicable A record back to it's default (Usually 14400).

*You can use the standard ports for POP/SMTP or IMAP with or without SSL.
*Alternate Ports for SMTP (26) is pre-configured in our firewall and will just need configured in either SmarterMail or Cpanel.

===your-provider Mail Migration any IMAP Mail Server===

'''This can easily apply to migrating from any mail service to Linux with Cpanel.'''

We suggest following the "Preparation Steps" under the Keys for Simple Mail Migration above. It also may be possible to find an application to migrate IMAP mail including calendars & contacts. We suggest checking into "IMAPSync".

[[Category:Windows-VPS]]
[[Category:ColdFusion-VPS]]
[[Category:VPS]]
[[Category: Sales]]
[[Category:Getting Started]]

Seamlessly Change Hosting to Hostek.com

2013-04-01T18:41:24Z

Jonc: Jonc moved page Changing Hosting Providers to Seamlessly Change Hosting to Hostek.com

==Steps to Changing Hosting Providers==

# [https://wiki.hostek.com/Changing_Hosting_Providers#Sign_up_for_hosting Sign up with Hostek.com]
# Transfer your site files and databases. Specific details for moving to: [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_Shared_Hosting Shared Hosting] or [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_VPS VPS Hosting]
# [https://wiki.hostek.com/Changing_Hosting_Providers#Planning_Ahead Test your site(s)]
# [https://wiki.hostek.com/DNS_(Name_Servers) Update Your Domain Name's Name Servers] NOTE: you will find the Name Server information in the New Hosting Account Email.

==Planning Ahead==
*Transferring hosting companies can be, and should be, easy if you follow the right steps and choose the right hosting company. You have made the correct choice in hosting companies, as we have many years experience in helping customers just like you transfer their hosting to us. We've created this easy-to-follow list for you to transfer your website to Hostek.com.

#Plan as far ahead as possible, the more detailed the better.
#Make sure your customers are well informed of any possible service interruption and changes they should consider well in advance.
#Test each site after uploading the files, importing databases and updating connection strings to make sure no errors are occurring. Use the Testing URL provided in the email after setting up hosting.
#Complete unfinished business, including tightening security on any ports or protocols that do not need to remain open to the public.

===For sites with constantly changing data===
The most difficult sites to move are those that have constantly changing data. The is because updates made during the backup & transfer will not be reflected in the data backup being moved.

To resolve this:

Perform the transfer during off-peak hours. In addition display a "under construction" page on both the new and old server while the transition is in progress.

After the site move has been completed, update your DNS as quickly as possible and leave the old site stopped. In some cases pointing the website on the previous host to the database on the new website will allow both sites to run without inconsistent data.

Another solution to insure quick switch over is setting the DNS, TTL to a low value such as 600 (10 minutes) on A records for domains being moved.

===Pre-Migration Site Assessment===

;Domains List
:Which domains are hosted and need moved?
:Do they require SSL?
:Are there any other hostnames that point to the site such as a sub-domain or alias?
:Special requirements such as a Virtual Directory or Sym Link?

;Database List
:Types of databases?
:User and permissions for each user?
:Password for each user?

;Domains with Mail
:Which domains USE mail?
:How do users access email, POP, IMAP, Web?
:Server URL for POP, SMTP, IMAP and Web?
:Special requirements such as SSL?

;Domains with FTP
:User and permission such as directory, read/write for each user?
:Passwords for each user?

;Registrar for each Domain?
:Where can the Name Servers be updated?
:Login for the Account?

;DNS for each Domain
:Where is it managed?
:Will DNS management be moved?
:Should we set the TTL low for any to insure quick switchover?

==Sign up for hosting==
The First step in transferring is to sign up for a hosting package. We offer a wide range of hosting packages that will fit your needs. After signing up for a hosting package, you will get an email with a Testing URL and Temporary FTP information. Use this information to complete the next task of moving your site files.

[http://hostek.com/hosting/web-hosting/best-web-hosting.asp Web Hosting] Windows / Linux / ColdFusion / Railo

[http://hostek.com/reseller-hosting.asp Reseller Hosting]

[http://hostek.com/hosting/vps/best-vps-hosting.asp VPS (Virtual Private Server) Hosting]

[http://hostek.com/hosting/dedicated/virtual-dedicated-hosting.asp Virtual Dedicated Hosting]

Custom VPS or Infrastructure as a Service Solutions contact [mailto:vps_sales@hostek.com VPS sales.]

==your-provider to Hostek.com Windows Shared Hosting==

===Moving Site Files and Databases===
#Open an FTP(File Transfer Protocol) client on your computer. If you do not have one, you can download FileZilla for free at "http://filezilla-project.org/download.php/".
#Connect to your site on your old host. Generally, the connection details will either be in an e-mail you received from them or listed in your control panel with them.
#Once connected, you should see two sets of files, local (files on your computer) and remote (files on your website). Under your local files, create a folder to store your site files.
#Once the folder is created, open that folder on the local side. Then, select all the files on the remote site and download them into that folder.
#Wait for the transfer of all files to complete. This may take several minutes.
#Once the transfer is complete, disconnect from the server. Then connect to your site on our server using the FTP details that we sent in your account details e-mail.
#On the remote side, open the /wwwroot folder. Also, on the local side, if there is a 'www', 'wwwroot', or 'public_html' folder, open that folder as well. #Select all files on the local side and upload them to the remote side.
#Wait for the transfer of all files to complete. This may take several minutes.
#Done - your site files have been moved.

===Databases===

====MSSQL====
#Request a full backup of your database from your host, or create one through their control panel if you have that option.
#Once you have the full database backup (should be a .bak file), login into your WCP control panel at "https://wcp.hostek.com" using the same e-mail address and password as your billing control panel.
#Once logged in, select 'MS SQL', and click 'Add MS SQL database'. Enter the same name as the backed up database and give it a size that is larger than the .bak file. Enter a username and password and click 'Save'.
#Now that the database has been created on the new server, choose the 'MS SQL Tools' option. Select the database and user, and click on the 'myLittleBackup' button.
#Click 'Restore databases'.
#Select the database from the drop-down.
#Click 'OK'.
#Click the 'Choose File' button and select the .bak backup file from your old host and click 'Ok'.
#The backup file will most likely only have one backup set so you
will not have to worry about selecting one. If there are multiple,
select whichever one has the most recent backup date.
#Click 'Restore' and click 'OK' on the popup.

NOTE: If you have any issues restoring the database due to the size or structure of the database, you may need to upload the backup file to your website and ask support to restore the database. If you do this, it is recommended that you zip the backup file before uploading it as that will make it much smaller.

===Update your domain’s DNS===
*Update your domain’s DNS settings Once you have tested your site, contact your domain name registrar and change your DNS settings to the Name Servers we provided in the New Account email. Your registrar is the company you purchased your domain name from. You’ll replace your existing primary and secondary name servers with the ones we provided you in the new account email. This change will take about 12 to 48 hours to propagate throughout the internet.

===Wait for your domain to propagate===
*Wait for your domain to propagate (approximately 12-48 hours) While your domain propagation is taking effect, some will see your site on our servers and others will see the site on your old host. This will prevent any downtime. In order to receive mail from both locations, you will need to check email from both hosts. You can simply use our web mail interface to get the email that is sent to our servers during

===Cancel with your previous host===
Cancel with your previous host After the site is pointing to us, you can go and cancel the hosting account you have at your previous host.

===Transfer your domain name to our registrar (optional)===
Transfer your domain name (optional)If you would like to transfer your domain and consolidate your registration and web hosting to one source, you can request to transfer the domain. The domain transfer itself costs NOTHING; we simply add one year of registration onto the expiration date for a base price for the common .TLD's. After that, you will able to renew your domain name at the same great price.
A registrar transfer is the moving a domain name from one registrar to another. A registrar is the company that actually registers a domain name.
#You will need to log into your billing control panel at https://cp.hostek.com
#Click on the domains drop-down menu and click "My Domains".
#Scroll down to your domain name and click "Manage Domain"
#Click the "Registrar Lock" tab, then click the "Disable Registrar Lock" button.
#Click on the "Management Tools" drop-down menu and select "Contact Information"
#You will need to update the Admin contact email address to an email address that you can receive emails at and click "Save Changes".
#Click "Management Tools" drop-down and select "Get EPP Code". This will display the EPP code that you will need to provide to the registrar you are transferring to.
#Once you have initiated the transfer with the registrar and provided the EPP code you will receive a transfer approval email at the email address you specified.

==your-provider to Hostek.com Windows VPS==
*We recommend setting up each domain using WCP as you move them, not all at one time. Doing so ensures there are less complications with mail delivery between two domains.

[[media:Hostek.com_Migration_Checklist.xls | Download this Migration Checklist]] to keep track of your migration progress.

===Moving Domains===
Familiarize yourself and your team with our [https://wcp.hostek.com Windows Control Panel]. If you have any questions please [https://support.hostek.com ask our support team].

#Create the domain using the "addon domain" icon in the WCP.
#*When initially logging into WCP the domain which was used for referencing your VPS will be listed and new domains added.
#*If you selected a database server be installed locally or remotely it should be integrated with your control panel and databases can be added under each domain using the appropriate Icon.
#*Note if you ordered the FREE SmarterMail edition which only includes mail for a single domain, upon adding your second domain you may encounter an error. If so contact support for upgrading your SmarterMail license or disabling the action for adding new domains to the mail server.
#DNS zones are automatically created for new domains, for the name servers which are used for domains added to your VPS click on the "Site Details" icon within the WCP for the domain in question.
#Copy files to your VPS. Use FTP directly from your VPS to transfer site files, this is extremely fast and efficient.
#Test the domain. Each domain will have a "Testing URL" within the "Site Details" area of WCP, note that if the database is not moved over and or DSN not created you may encounter errors.
#Prepare the DNS for moving. Before switching your DNS we suggest a shorter TTL such as 300 (5 minutes), after this change you must wait out the original TTL before the new value will take affect. For example if your original TTL was 7200 seconds (2 hours) you must wait 2 hours after submitting any change before the new TTL will be take effect.
#Switch your DNS. By now your site is tested and you're ready to make the switch.
#*In most cases we suggest moving the database first so data will be consistent from the old location to the new.

===SSL===

*Our Windows Control Panel has provisions for creating a CSR and installing a new certificate but you cannot "import" an existing certificate. There are two ways to resolve "moving" a certificate to a Windows server easily.

====Pkey format====
#Export the certificate in PKey format. Within the certificate manager, export the current certificate in PKey format, you will be asked for a "passphrase" assign one and remember it.
#Copy the certificate to the new server.
#Open IIS on your VPS, open the main server node then click on the icon "Server Certificates" found under >> IIS >> Server Certificates.
#Click import and follow the prompts.
#Edit the bindings for the specific site to assign the certificate
#*Right click on the website in Sites >> your-website.abc select "Edit Bindings".
#*Select "Add" change the type to https, select the IP Address, select the "SSL Certificate" from the drop down.

====Re-key the certificate====
*Using this method could render the SSL certificate expired on the old server.

#Click on the "Dedicated SSL" icon in WCP.
#Fill in the appropriate information to generate a CSR.
#At your certificate provider request a "rekey" using the CSR provided from WCP.
#After receiving the new certificate back from your provider, complete the installation in WCP.

===Databases===

====MSSQL====
#Add the database and user in MSSQL using the WCP under the correct domain.
#Set the database to single user mode on the new server.
#*<pre>USE database_name ALTER DATABASE [DB_NAME_HERE] SET SINGLE_USER WITH NO_WAIT</pre>
#Using SQL Studio Manager restore from backup selecting the file you exported from your previous server.
#Set the database to multi user mode on the new server.
#*<pre>USE database_name ALTER DATABASE [DB_NAME_HERE] SET MULTI_USER WITH NO_WAIT</pre>
#To fix user a created user which existed before the database was restored.
#*<pre>USE database_name Exec sp_change_users_login 'auto_fix','USERNAME'</pre>
#In some cases you may continue to receive errors. Try adding double slashes for the file restore paths. Here's a scripted example:
<pre>
RESTORE DATABASE [exampledatabase] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\exampledatabase.bak'
WITH FILE = 1, MOVE N'old_database_name_Data' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.mdf',
MOVE N'old_database_name_Log' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.LDF',
NOUNLOAD, REPLACE, STATS = 10
GO
</pre>

===Don't forget===
*Scheduled tasks, add them on the new server remove them from the old.
*Change the DNS TTL back to default.

=== Mail===

====SmarterMail to SmarterMail====

#See the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration] for preparing the MX record and SSL (if applicable). You can however skip the step for creating users / passwords on the new server since you will be moving everything at once.
#Zip the contents of the {smartermail root}\domains\yourdomain.com.
#FTP the files from the old server to the new, this can be done by installing a simple FTP client such as FileZilla on the VPS and connecting to the old server.
#On the new VPS unzip and overwrite the contents {smartermail root}\domains\yourdomain.com.
#Login to the SmarterMail Webmail interface, "Reload" the domain. This should cause all the users to be revealed, with their inbox, calendar and other assets intact.
#Complete the "Final Steps" mentioned under [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration].

====Any Provider to Windows & Smartermail====

Easily migrate from any mail service. Move a single mailbox, or an entire domain, from mail services like:

Gmail
Yahoo!
Hotmail / Windows Live
Microsoft Exchange
Or even mail servers like Merak, iMail and MailEnable

We suggest following the "Preparation Steps" under the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration]. Then follow the steps provided by SmarterMail.

http://portal.smartertools.com/KB/a1937/import-mailbox-data-to-smartermail-from-third-party.aspx

====Why move one domain at a time?====
If you setup domain X, Y, and Z via WCP, then migrate X from your old server to Hostek. If a user on X tries to email someone on domain Y or Z they'll get a kickback saying "No such user." This is because you haven't migrated the data over into these other accounts yet. The server will try to send the message locally before it goes "outside" to resolve it's IP address. Setting up new domains "as you go", will avoid this possibility.

If mail is not involved in the migration, then you may not need to worry about this issue.

==your-provider to VPS Mail Migration General Information==
There are various ways to migrate mail from an existing provider. In cases where POP is the method for retrieving mail then simply switching providers in a thoughtful preplanned manner is sufficient.

===Keys for simple POP/SMTP Mail Migration===

====Preparation Steps for Mail Migration====
#Create domain on the new server.
#Setup users & passwords in advance on the new server.
#Take note of the specific DNS details and modify the TTL.
#*Note the MX record.
#*Set the TTL for the MX record to 600 (10 minutes).
#*If the MX is set to "something.yourdomain.com", then also change the TTL for the A record "something.yourdomain.com" to 600 (10 minutes).
#Does your mailserver use SSL? Note, if the SSL mail encryption works for "mail.yourisp.com" and you're moving to a VPS then you will likely have to also purchase and have the certificate installed and insure the exact same type of SSL support works before proceeding.

====Final Steps to complete the Mail Migration====
#Plan and prepare users with what they should expect.
#Be sure your mail server is listening on the IP Address you will point the A record to
#We suggest to create or modify the A record "something.yourdomain.com" if it already exists, when you are ready to make the switch change that A record "something.yourdomain.com" to point at your VPS.
#When finished change the TTL for the MX record and applicable A record back to it's default (Usually 14400).

*You can use the standard ports for POP/SMTP or IMAP with or without SSL.
*Alternate Ports for SMTP (26) is pre-configured in our firewall and will just need configured in either SmarterMail or Cpanel.

===your-provider Mail Migration any IMAP Mail Server===

'''This can easily apply to migrating from any mail service to Linux with Cpanel.'''

We suggest following the "Preparation Steps" under the Keys for Simple Mail Migration above. It also may be possible to find an application to migrate IMAP mail including calendars & contacts. We suggest checking into "IMAPSync".

[[Category:Windows-VPS]]
[[Category:ColdFusion-VPS]]
[[Category:VPS]]
[[Category: Sales]]
[[Category:Getting Started]]