https://wiki.hostek.com/api.php?action=feedcontributions&feedformat=atom&user=KaseyaHostek.com Wiki - User contributions [en]2024-03-28T10:31:21ZUser contributionsMediaWiki 1.24.2https://wiki.hostek.com/index.php?title=Assigning_IPs&diff=3807Assigning IPs2018-02-05T18:38:47Z<p>Kaseya: </p>
<hr />
<div>==Assigning IP Addresses==<br />
<br />
===Windows===<br />
<br />
You can use the following steps to set the IP address to a certain site in IIS:<br />
<br />
#Open '''IIS 7.5 Manager''' from the desktop or the start menu<br />
#Click the plus sign next to the server name of your VPS<br />
#Click the '''Sites''' folder<br />
#Right-click the site you want to add the IP address to<br />
#Select '''Bindings''' from the menu<br />
#Leave the '''Type''' option set to '''http'''<br />
#Enter the unused IP address into the '''IP address''' section<br />
#Leave the '''Port''' section set to '''80'''<br />
#Leave the '''Hostname''' section blank and click '''OK'''<br />
<br />
===Linux/cPanel===<br />
<br />
You can use the following steps to set the IP address to a certain site in WHM:<br />
<br />
#Log into the WHM for your VPS<br />
#Type '''List Accounts''' in the search bar at the right of the page<br />
#Click '''List Accounts'''<br />
#Click the plus sign next to the site you want to assign the static IP to<br />
#Click '''Change IP Address'''<br />
#Select an unused IP address from the '''New Address''' drop-down and click '''Change'''<br />
<br />
[[Category:VPS]]<br />
[[Category:ColdFusion-VPS]]<br />
[[Category:Linux-VPS]]<br />
[[Category:Railo-VPS]]<br />
[[Category:Windows-VPS]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=Category:WCP_(Windows_based_Control_Panel)&diff=3721Category:WCP (Windows based Control Panel)2017-08-27T18:21:57Z<p>Kaseya: </p>
<hr />
<div><!-- BANNER ACROSS TOP OF PAGE --><br />
<div id="mp-topbanner" style="clear:both; position:relative; box-sizing:border-box; width:100%; margin:1.2em 0 6px; min-width:47em; border:1px solid #ddd; background-color:#f9f9f9; color:#000; white-space:nowrap;"><br />
<br />
<div style="margin:0.4em; width:22em; text-align:center;"><br />
<div style="font-size:162%; padding:.1em;">Category: WCP (Windows Control Panel)</div><br />
<div style="font-size:95%;">Manage Websites, Resellers, & Dedicated Servers</div><br />
<div id="articlecount" style="font-size:85%;">[[Special:Statistics|{{PAGESINCAT:WCP_(Windows_based_Control_Panel)}}]] articles in WCP.</div><br />
</div><br />
<!-- PORTAL LIST ON RIGHT-HAND SIDE --><br />
<ul style="position:absolute; right:-1em; top:50%; margin-top:-2.4em; width:38%; min-width:25em; font-size:95%;"><br />
<br /><br />
<b style="font-size: 18px; font-weight: bold;"> Windows Control Panel: https://wcp.hostek.com </b><br />
</ul><br />
</div><br />
<!-- MAIN PAGE BANNER --><br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">We've organized the list of WCP articles in the below categories for easy browsing. If needed view the full list of articles at the bottom of the page.<br />
</td></tr><br />
</table> <br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#cef2e0; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If you are looking for the category page for either '''WCP Reseller Management''' or '''WCP Server Management''' click on the corresponding links below:<br /><br />
<center> [[:Category:WCP Account Management| WCP Account Management]] | [[:Category:WCP Server Management| WCP Server Management]] </center><br />
</td></tr><br />
</table> <br />
<br />
<br />
{| id="mp-upper" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"<br />
<!-- first frame (green) --><br />
| class="MainPageBG" style="width:55%; border:1px solid #cef2e0; background-color:#f5fffa; vertical-align:top; color:#000;" |<br />
{| id="mp-left" style="width:100%; vertical-align:top; background-color:#f5fffa;"<br />
| style="padding:2px;" | <h2 id="mp-tfa-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">Intro Information</h2><br />
|-<br />
| style="color:#000;" | <div id="mp-tfa" style="padding:2px 5px"><br />
<br />
<li>Logging into WCP [ [[How_to_login_to_WCP| View ]] ]</li><br />
<li>Forgot WCP Password? [[Forgot_WCP_Password| View ]] ]</li><br />
<li>Change Domain to Manage [ [[Change_Domain_to_Manage| View ]] ] <br />
<li>Switch between Account & Server Manager [ [[Switching_Between_WCP_Management_Options| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Domains" & "Domain Settings" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Domain Notes [ [[Domain_Notes| View ]] ]<br />
<li>Additional Control Panel Logins [ [[Adding_Additional_Control_Panel_Logins| View ]] ]</li><br />
<li>Manage Sub Domains [ [[Create_and_manage_subdomains_via_WCP| View ]] ]</li><br />
<li>Manage Domain Aliases [ [[Create_and_manage_domain_aliases_in_WCP| View ]] ]</li><br />
<li>DNS Manager [ [[Managing_DNS_Records_via_WCP| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Files" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>FTP Accounts [ [[FTP_Accounts| View ]] ]</li><br />
<li>File Manager [ [[WCP_File_Manager| View ]] ]</li><br />
<li>Virtual Directories [ [[Virtual_Directories| View ]] ]</li><br />
<li>Password Protect [ [[IIS_Password_Protect| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Databases" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage MySQL Databases [ [[Manage_MySQL/MariaDB_Databases_(Windows_Environment)| View ]] ]</li><br />
<li>Login to phpMyAdmin [ [[WCP_-_Login_to_phpMyAdmin| View ]] ]</li><br />
<li>Manage MS SQL Databases [ [[Manage_MS_SQL_Databases| View ]] ]</li><br />
<li>Using MyLittleAdmin/MyLittleBackup [ [[MyLittleAdmin_/_myLittleBackup| View ]] ]</li><br />
<li>Manage DSNs (Datasources) [ [[Manage_DataSources_(DSNs)_in_Windows_Environment| View]] ]</li><br />
<br />
</div><br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Website Settings" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage ASP.net Settings [ [[Manage_ASP.net_Settings| View ]] ]<br />
<li>Manage PHP Settings [ [[Manage_PHP_Settings| View ]] ] <br />
<br />
<li class="mw-customtoggle-iissettings">IIS Settings</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-iissettings"><br />
<ul><br />
<li>Manage Custom Errors [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Mime Types [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Default Documents [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage URL Forwarding [ [[URL_Forwarding| View ]] ] </li><br />
<li>Manage Authentication [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage IIS Caching [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Advanced IIS Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
</ul><br />
</div><br />
<li>Manage Application Folders [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>View Site Details [ [[Site_Details| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Email" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage E-Mail Users [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage E-Mail Aliases [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Enable SPF & Domain Keys For E-Mail [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Searching E-Mail Logs [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage DSNs (Datasources) [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Reporting & Applications" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Enable & Manage Stats [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Applications [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Cron Jobs [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Enable / Disable Application extensions [ [[Enable / Disable Application extensions| View ]] ] </li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"ColdFusion" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>ColdFusion Error Log [ [[ColdFusion Error Log| View ]] ] </li><br />
<li>Clear Template Cache [ [[Clear Template Cache| View ]] ] </li><br />
<li>ColdFusion Scheduled Task (Cron Jobs) [ [[ColdFusion Scheduled Task| View ]] ] </li><br />
<br />
</div><br />
<br />
<br />
|}<br />
| style="border:1px solid transparent;" |<br />
<br />
<!-- Second frame (blue) --><br />
| class="MainPageBG" style="width:45%; border:1px solid #cedff2; background-color:#f5faff; color:#000; vertical-align:top;"|<br />
{| id="mp-right" style="width:100%; vertical-align:top; background-color:#f5faff;"<br />
| style="padding:2px;" | <h2 id="mp-itn-h2" style="margin:3px; background-color:#cedff2; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3b0bf; text-align:left; color:#000; padding:0.2em 0.4em;">WIKI Categories:</h2><br />
|-<br />
| style="color:#000; padding:2px 5px;" | <div id="mp-itn"><br />
<br />
<ul><br />
<br />
<!--- Billing ---><br />
<li class="mw-customtoggle-billing">Billing [ [[#| View]] ]</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-billing"><br />
<ul><br />
<li>Domain Registrations [ [[:Category:Domain_Registrations| View]] ]</li><br />
</ul><br />
</div><br /><br />
<!--- Windows ---><br />
<li class="mw-customtoggle-windows">Windows Environment</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-windows"><br />
<ul><br />
<li>ColdFusion [ [[#| View]] ]</li><br />
<li>IIS - Need to Knows [ [[#| View]] ]</li><br />
<li>MS SQL [ [[#| View]] ]</li><br />
<li>PHP [ [[#| View]] ]</li><br />
<li>Railo/Lucee [ [[#| View]] ]</li><br />
<li>RDP (Remote Desktop) [ [[#| View]] ]</li><br />
<li>SmarterMail [ [[#| View]] ]</li><br />
<li>WCP (Windows Control Panel) [ [[#| View]] ]</li><br />
<br />
</ul><br />
</div><br />
<br />
<br />
<!--- Windows ---><br />
<li class="mw-customtoggle-linux">Linux Environment</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-linux"><br />
<ul><br />
<li>ColdFusion [ [[#| View]] ]</li><br />
<li>cPanel [ [[#| View]] ]</li><br />
<li>cPanel Mail [ [[#| View]] ]</li><br />
<li>Railo/Lucee [ [[#| View]] ]</li><br />
<li>SSH (Shell Access) [ [[#| View]] ]</li><br />
<li>WHM (Remote Desktop) [ [[#| View]] ]</li><br />
<br />
</ul><br />
</div><br />
<br />
|}<br />
|}<br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If there is any suggestions for additional wiki articles or an article that you think needing updated please make the request to our support team.<br />
</td></tr><br />
</table> <br />
<br />
<!-- INTERWIKI STRAPLINE --><br />
__NOTOC____NOEDITSECTION__</div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_aspnet_settings.png&diff=3652File:Wcp aspnet settings.png2017-08-08T14:46:45Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=Managing_DNS_Records_via_WCP&diff=3651Managing DNS Records via WCP2017-08-08T14:29:30Z<p>Kaseya: </p>
<hr />
<div>__TOC__<br />
<br />
In this tutorial, you'll learn how to create and manage DNS records in WCP.<br />
<br />
This tutorial assumes that you are already logged in to WCP. You can see our tutorials on [[How_to_login_to_WCP|logging in]] or recovering your password if necessary.<br />
<br />
= Before using the WCP DNS Editor =<br />
<br /><br />
If you would like to manage your domain's DNS records in WCP, then your domains authoritative name servers '''MUST''' to be set to use the correct Hostek name servers. You can find the correct name servers (''Primary DNS &amp; Secondary DNS'') to use by clicking on the ''''Site Details'''' button under the ''''Website Settings'''' section.<br />
<br /><br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<br />
<li><p>To get the name servers that the domain needs to be updated to click the ''''Site Details'''' icon in your WCP control panel.</p><br />
[[Image:Wcp site details icon.png]]<br />
</li><br />
<br />
<br />
<li><p>The Name Servers information can be found next to their respective sections in this ''''Site Details'''' pane as shown below:</p><br />
[[Image:Wcp sitedetails dns info.png]]<br />
</li><br />
<br />
<br />
<li><p>From the above screenshot we can gather that the name servers we'd need to update our domain to in this example would be ''''''ns1.hostek<span>.com'''''</span>' and ''''''ns2.hostek<span>.com'''''</span>'.</p><br />
<p>'''Note:''' ''The name servers may vary per domain so be sure to check that you're updating to the correct name servers.''</p></li><br />
<br />
<br />
<li><p>At the registrar for your domain you'll need to update the authoritative name servers to point to the listed name servers that you found in the control panel. Any records you crewate and manage in the DNS editor will not resolve for your domain until you've updated the authoritative name servers to point correctly and allow time for propagation.</p></li><br />
</ol><br />
<br />
<br /><br />
<br />
= Adding DNS Records ( A, CNAME, MX, ect.) =<br />
<br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<li><p>Click on the icon for ''''DNS Editor'''' under the ''''Domains'''' section to open the DNS editor.</p><br />
<br /><br />
[[Image:wcp_dns_editor.png]]<br />
<br /><br /><br />
</li><br />
<br />
<li>If you have any domain aliases (parked domains) setup then you'll have an option to click ''''Manage DNS'''' for the domain you wish to edit the DNS for, as shown in the screenshot below.</li><br />
<br /><br />
[[file:wcp_dns_managedns_bttn.png]]<br />
<br /><br /><br />
<br />
<li><p>You should now see a list of all your existing DNS records that you have on our DNS servers. Click the ''''Add Record'''' button to add a new record.</p><br />
<br /><br />
[[Image:wcp_dns_add_record.png]]<br />
<br /><br /><br />
</li><br />
<br />
<br />
<li><p>You should now see a few fields for the new DNS record which we'll explain below for each type of record:</p></li></ol><br />
<br />
== A Records ==<br />
<br /><br />
<br />
[[Image:wcp_dns_arecord.png]]<br />
<br />
'''What is it:''' ''An A Record maps a domain name to an IP Address of the server hosting the domain the record is for.''<br />
<br />
* '''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''example''' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''example.hostektutorials.com'''.<br />
* '''Type:''' The type of record, which in this case would be an ''''A Record''''.<br />
* '''Data:''' The data field for an ''''A Record'''' tells the record what IP Address the record resolves to such as '''216.15.245.49'''. An A Record has to point to an IP Address and can '''NOT''' point to a canonical name.<br />
* '''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.<br />
<br />
== CNAME Records ==<br />
<br /><br />
<br />
[[Image:wcp_cname_record.png]]<br />
<br />
'''What is it:''' ''A CNAME record stands for 'Canonical Name Record', as it is used to state that the domain in the 'record name' field is an alias to another domain ( which is the canonical domain ). So the record will resolve to the same location as the domain you put in the 'Data' field.''<br />
<br />
<ul><br />
<li><p>'''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''example''' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''example.hostektutorials.com'''.</p></li><br />
<li><p>'''Type:''' The type of record, which in this case would be an ''''CNAME Record''''.</p></li><br />
<li><p>'''Data:''' The data field for a ''''CNAME Record'''' tells the record what domain ( canonical name ) the record resolves to such as '''example.hostektutorials<span>.com</span>'''. A CNAME Record '''MUST''' point to a canonical name and can '''NOT''' point to an IP Address.</p><br />
<p>''The above screenshot shows we're pointing 'tutorials.hostektutorials<span>.com</span>' to 'example.hostektutorials<span>.com</span>'.''</p><br />
<p>''So for example if 'example.hostektutorials<span>.com</span>' points to '216.15.245.49' the new record for 'tutorials.hostektutorials<span>.com</span>' will also reside to this same IP of '216.15.245.49'.''</p></li><br />
<li><p>'''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.</p></li></ul><br />
<br />
== MX Record==<br />
<br /><br />
[[Image:wcp_mx_record.png]]<br />
<br />
'''What is it:''' ''MX Record(s) delegate which mail server a domains email should route to. You can have many MX Records for a domain to allow for redundancy in case one of the mail servers is down. The order of which server the domains mail routes to is determined by the ''''Priority'''' value for the MX Record, which the record with the lowest priority is attempted BEFORE a record with a higher priority number.''<br />
<br />
<ul><br />
<li><p>'''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''example''' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''example.hostektutorials.com'''.</p><br />
<p>'''NOTE:''' ''In most cases you leave the record name blank for MX Records as most clients only need mail for the main domain, such as 'hostektutorials<span>.com</span>'.''</p></li><br />
<li><p>'''Type:''' The type of record, which in this case would be an ''''MX Record''''.</p></li><br />
<li><p>'''Priority:''' If your domain has more than one MX record, then the sending mail server needs to determine which server to send the email to for your domain. The ''''Priority'''' field will be looked at to determine which server to first attempt sending the mail to. The record with the lowest priority number will be looked at first, so a mx record with a priority of 0 would be attempted before a record with a priority of 10.</p></li><br />
<li><p>'''Data:''' The data field for a ''''MX Record'''' tells the record what domain ( canonical name ) the record resolves to such as '''mail.hostektutorials<span>.com</span>'''. An MX Record '''MUST''' point to a canonical name and can '''NOT''' point to an IP Address.</p><br />
<p>''The above screenshot shows we're pointing the MX record for 'hostektutorials<span>.com</span>' to 'mail.hostektutorials<span>.com</span>'.''</p><br />
<p>''So for example if 'mail.hostektutorials<span>.com</span>' points to the IP '65.175.112.222' the new MX record for 'hostektutorials<span>.com</span>' will also reside to this same IP of '65.175.112.222'.''</p></li><br />
<li><p>'''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.</p></li></ul><br />
<br />
== NS Record==<br />
<br /><br />
<br />
[[Image:wcp_ns_record.png]]<br />
<br />
'''What is it:''' ''NS record(s) lets recursive nameservers know which nameservers are authoritative for a zone. This is sometimes used to delegate DNS management for a subdomain to another nameserver. You should also have NS records for your domain that match what is set at the registrar level.''<br />
<br />
<ul><br />
<li><p>'''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''example''' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''example.hostektutorials.com'''.</p><br />
<p>'''NOTE:''' ''In most cases you leave the record name blank for NS Records as most clients only need the NS records for the main domain, such as 'hostektutorials<span>.com</span>'.''</p></li><br />
<li><p>'''Type:''' The type of record, which in this case would be an ''''NS Record''''.</p></li><br />
<li><p>'''Data:''' The data field will be a canonical name (domain name) that points to the IP of your DNS server. This NS record is used to tell which authoritative name servers are responsible for the domain. It is good to have multiple 'NS' records for redundancy.</p><br />
<p>''The above screenshot shows that we set ''''ns1.hostek<span>.com'''</span>' as an authoritative name server for the domain. After a host does the initial lookup for the domain it will now know it can query ''''ns1.hostek<span>.com</span>'''' for the DNS records associated to the domain instead of having to obtain the authoritative name servers from the registrar again.''</p></li><br />
<li><p>'''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.</p></li></ul><br />
<br />
== TXT Record==<br />
<br /><br />
[[Image:wcp_txt_record.png]]<br />
<br />
'''What is it:''' ''A TXT Record is a resource record. What this means is it is used to store arbitrary attribute names along with the value of those attributes. The text within this record can be used for services / applications that look for a specific 'name' in your TXT records, for example some mail servers may look in the TXT record to see if there is a valid SPF entry that indicates what IP Addresses the domain is actually allowed to send mail from.''<br />
<br />
<ul><br />
<li><p>'''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''example''' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''example.hostektutorials.com'''.</p><br />
<p>'''NOTE:''' ''In most cases you leave the record name blank for TXT Records so that the record exist on the root level of the domain.''</p></li><br />
<li><p>'''Type:''' The type of record, which in this case would be an ''''TXT Record''''.</p></li><br />
<li><p>'''Data:''' The data field will contain the attribute names and values for the record. View the below example of a TXT record:</p></li></ul><br />
<br />
TXT Record: ''&quot;Hostek=Best Hosting Company&quot;''<br />
<br />
The above example has a attribute name of ''''''Hostek'''''' and the value for that attribute is ''''''Best Hosting Company''''''.<br />
<br />
* '''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.<br />
<br />
== SPF Record==<br />
<br /><br />
<br />
[[Image:wcp_spf_record.png]]<br />
<br />
'''What is it:''' ''A SPF Record was designed to specify what mail servers are actually allowed to send mail for a domain. This record type is considered '''outdated''' as SPF Records are now actually looked and and controlled within the TXT Records we went over above. Some older mail systems still use this 'SPF' record though so it's good to have just in case, but is not necessarily needed.''<br />
<br />
<ul><br />
<li><p>'''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''example''' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''example.hostektutorials.com'''.</p><br />
<p>'''NOTE:''' ''In most cases you leave the record name blank for SPF Records so that the record exist on the root level of the domain.''</p></li><br />
<li><p>'''Type:''' The type of record, which in this case would be an ''''SPF Record''''.</p></li><br />
<li><p>'''Data:''' The data field will contain the SPF details that state what mail servers are allowed to send email. View the below example of a SPF record:</p><br />
<p>SPF Record: ''&quot;v=spf1 include:spf.ezhostingserver.com -all&quot;''</p><br />
<p>The above example shows the version of SPF that is being used with the 'v=', so the version is ''spf1'' since it shows ''''''v=spf1''''''. The value for the SPF record is ''''''include:spf.ezhostingserver.com -all'''''' which would work for domains on our shared servers, as the above record includes all the IP Addresses belonging to our shared mail servers.</p></li><br />
<li><p>'''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.</p></li></ul><br />
<br />
== SRV Record==<br />
<br /><br />
<br />
[[Image:wcp_srv_record.png]]<br />
<br />
'''What is it:''' ''A SRV Record stands for ''''Service Record'''. It's a specification of data defining the location ( hostname and port number ) of servers for a specified service.''<br />
<br />
<ul><br />
<li><p>'''Record Name:''' The name of the DNS record. The field for this record name will append the domain automatically so if you insert '''smtp.''tcp' into the field when adding a record for '''hostektutorials.com''' then the record created would be '''smtp._tcp.hostektutorials<span>.com</span>'.</p><br />
<p>'''NOTE:''' ''The format for SRV records is'' '''service.''protocol' ''so for the 'SMTP' service example in the screenshot above we have'' '''smtp.''tcp' ''to show this record is for the SMTP service listening on TCP.''</p></li><br />
<li><p>'''Type:''' The type of record, which in this case would be an ''''SRV Record''''.</p></li><br />
<li><p>'''Priority:''' Like the MX record, the '''priority''' helps determine which SRV record is used in the case of there being multiple SRV records with the same name. If there is two or more SRV records with the same name and priority, then the '''weight''' will be the tie breaker for which record will be looked at first.</p></li><br />
<li><p>'''Weight:''' The weight allows the zone to distribute the load between two or more SRV records with the same name and priority. This can be thought of as a load balance solution for SRV records.</p></li><br />
<li><p>'''Port:''' The port would be the port of the service this SRV is related to, such as 587 for SMTP.</p></li><br />
<li><p>'''Data:''' The '''Data''' field will be the hostname or IP of the server that holds the service this record is for.</p></li><br />
<li><p>'''TTL:''' The TTL field stands for ''''Time to Live'''', which determines how long a network should keep the record in it's DNS cache before it is cleared out and checks for any updates to the record.</p></li></ul><br />
<br />
<br /><br />
<br />
= Updating Existing DNS Records =<br />
<br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<br />
<li><p>Click on the icon for ''''DNS Editor'''' under the ''''Domains'''' section to open the DNS editor.</p><br />
<br /><br />
[[Image:wcp_dns_editor.png]]<br />
<br /><br /><br />
</li><br />
<br />
<li>If you have any domain aliases (parked domains) setup then you'll have an option to click ''''Manage DNS'''' for the domain you wish to edit the DNS for, as shown in the screenshot below.</li><br />
<br /><br />
[[file:wcp_dns_managedns_bttn.png]]<br />
<br /><br /><br />
<br />
<li><p>Now click on the pencil icon next to the DNS record you wish to update.</p><br />
<br /><br />
[[Image:wcp_edit_record.png]]<br />
<br /><br /><br />
</li><br />
<br />
<br />
<li><p>Now you can make the necessary update to the record and then click ''''Save'''' to save the new changes.</p><br />
<br /><br />
[[Image:wcp_save_record.png]]<br />
<br /><br /><br />
</li><br />
</ol><br />
<br /><br />
<br />
= Removing Existing DNS Records =<br />
<br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<br />
<li><p>Click on the icon for ''''DNS Editor'''' under the ''''Domains'''' section to open the DNS editor.</p><br />
<br /><br />
[[Image:wcp_dns_editor.png]]<br />
<br /><br /><br />
</li><br />
<br />
<li>If you have any domain aliases (parked domains) setup then you'll have an option to click ''''Manage DNS'''' for the domain you wish to edit the DNS for, as shown in the screenshot below.</li><br />
<br /><br />
[[file:wcp_dns_managedns_bttn.png]]<br />
<br /><br /><br />
<br />
<br />
<li><p>To delete an existing DNS record click on the trash can icon next to the record you wish to delete.</p><br />
<br /><br />
[[Image:wcp_delete_record.png]]<br />
<br /><br /><br />
</li><br />
<br />
<br />
<li><p>You should receive a prompt verifying you wish to delete the chosen record. Click ''''OK'''' to delete, or ''''Cancel'''' to cancel the deletion of the record.</p><br />
<br /><br />
[[Image:wcp_confirm_delete_record.png]]<br />
<br /><br /><br />
</li><br />
</ol><br />
<br />
<br />
<br />
[[Category:WCP (Windows based Control Panel)]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dns_managedns_bttn.png&diff=3650File:Wcp dns managedns bttn.png2017-08-08T14:22:33Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=Manage_DataSources_(DSNs)_in_Windows_Environment&diff=3649Manage DataSources (DSNs) in Windows Environment2017-08-07T14:52:10Z<p>Kaseya: Created page with "__FORCETOC__ <br /><br /> =Navigating to DataSources (DSNs)= <ol style="list-style-type: decimal;"> <li><p>First login to your WCP control panel for the account the domain i..."</p>
<hr />
<div>__FORCETOC__<br />
<br />
<br /><br /><br />
<br />
=Navigating to DataSources (DSNs)=<br />
<ol style="list-style-type: decimal;"><br />
<li><p>First login to your WCP control panel for the account the domain is under: https://wcp.hostek.com</p><br />
<br /><br />
[[file:wcp_url_secure.png]]<br />
<br /><br /><br />
<p>If you have any issues with logging into WCP then please see our tutorials on [[Forgot_WCP_Password|recovering your password]] if necessary</p></li><br />
<br />
<br /><br />
<br />
<li><p>Once logged into WCP if you have multiple domains you may need to select the appropriate domain to manage using the ''''Hosted Domains'''' drop-down in the top-right of the page as shown in the screenshot below:</p><br />
<br /><br />
[[file:wcp_change_domain.png]]<br />
<br /><br /><br />
</li><br />
<br />
<li>Click on the icon in the control panel labeled ''''DataSources (DSNs)'''' under the '''Databases''' section.</li><br />
<br /><br />
[[file:wcp_dsn_icon.png]]<br />
<br /><br /><br />
<br />
<li>You should now see a list of any existing DSNs (if any).</li><br />
<br /><br /><br />
</ol><br />
<br />
=Add a new DataSource=<br />
<br /><br />
The above section gave instructions on navigating to DataSources in the control panel. Let's now show how to add a new datasource.<br />
<br /><br /><br />
<br />
<ol><br />
<br />
<li>Click on the icon in the control panel labeled ''''DataSources (DSNs)'''' under the '''Databases''' section.</li><br />
<br /><br />
[[file:wcp_dsn_icon.png]]<br />
<br /><br /><br />
<br />
<li>You should now see a list of any existing DSNs (if any). Now to add a new Datasource click on the ''''Add'''' button.</li><br />
<br /><br />
[[file:wcp_dsn_add_bttn.png]]<br />
<br /><br /><br />
<br />
<li>You will now see a list of available DSN types.. depending on what kind of database this DSN is going to connect to. See a screenshot of the different types of DSNs you can create in the screenshot below:</li><br />
<br /><br />
[[file:wcp_dsn_add_type.png]]<br />
<br /><br /><br />
<br />
<li>Click on the ''''Add'''' button next to the type of DSN you want to add as shown in the above screenshot.. the next few sections will show the options listed for each of the different DSN types:</li><br />
<br /><br /><br />
<br />
==Access Database==<br />
<br /><br /><br />
'''DataSource Name:''' The DataSource name is the actual name of the DSN that you'll be calling within your websites code (PHP,CF, etc.)<br /><br /><br />
'''Database Path:''' The path field is the location within your website files to the Access database you're attempting to connect this DSN to. To the right of this field is a '''Browse''' button that you can use to navigate the directories of your website for this access database file.<br /><br /><br />
'''Username (Optional):''' The username field is an optional field.. unless the access database you're attempting to connect to is a 2007 Access database (.accdb file).<br /><br /><br />
'''Password (Optional):''' The password field is an optional field.. unless the access database you're attempting to connect to is a 2007 Access database (.accdb file).<br /><br /><br />
'''ColdFusion DataSource:''' If your website is on a server that has ColdFusion installed then you will have a checkbox for '''ColdFusion DataSource'''. When this field is checked then the datasource will be created within ColdFusion as well as the default ODBC service.<br /><br /><br />
'''Automatically Compact and Repair (Recommended):''' This option will do exactly what is sounds like. It will run a 'compact & repair' function on the access database. This will sometimes help in cases where the database is locked or user connections are stuck.<br />
<br /><br /><br />
<br />
[[file:wcp_dsn_access.png]]<br />
<br /><br /><br />
<br />
<br />
<br />
==MySQL/MariaDB Database==<br />
<br /><br /><br />
<br />
'''DataSource Name:'''The DataSource name is the actual name of the DSN that you'll be calling within your websites code (PHP,CF, etc.)<br /><br /><br />
'''Database Name:''' Enter in the database name that you are connecting to (You can obtain from the '''MySQL''' section of the control panel).<br /><br /><br />
'''Server:''' Enter in the server name for the database you are connecting to (You can obtain from the '''MySQL''' section of the control panel).<br /><br /><br />
'''Port:''' Enter in the port for the MySQL server (All of our shared servers and VPS use the default MySQL port of ''''3306'''').<br /><br /><br />
'''Username (Optional):''' Enter in the user name for the database you are wanting to connect to (You can obtain from the '''MySQL''' section of the control panel).<br /><br /><br />
'''Password (Optional):''' Enter in the password to the user name you provided in the 'Username' field.<br /><br /><br />
'''ColdFusion DataSource:''' If your website is on a server that has ColdFusion installed then you will have a checkbox for '''ColdFusion DataSource'''. When this field is checked then the datasource will be created within ColdFusion as well as the default ODBC service.<br /><br /><br />
'''Unicode Support:''' Adds JDBC query parameters for Unicode character support.<br /><br /><br />
'''Enable CLOB:''' Allows you to enable CLOB strings.<br /><br /><br />
'''Enable BLOB:''' Allows you to enable BLOB strings.<br /><br /><br />
'''JDBC Query Parameters:''' Allows custom JDBC query parameters to be added. These are name=value pairs. Multiple settings can be separated by the '&' character. <br /><br /><br />
<br />
'''Example of JDBC Query Parameters:''' zeroDateTimeBehavior=convertToNull&characterEncoding=UTF-8<br />
<br />
The full list of supported properties can be found at http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html.<br />
<br />
<br />
[[file:Dsn mysql.png]]<br />
<br /><br /><br />
<br />
==MS SQL Database==<br />
<br /><br /><br />
<br />
'''DataSource Name:'''The DataSource name is the actual name of the DSN that you'll be calling within your websites code (PHP,CF, etc.)<br /><br /><br />
'''Database Name:''' Enter in the database name that you are connecting to (You can obtain from the '''MS SQL''' section of the control panel).<br /><br /><br />
'''Server:''' Enter in the server name for the database you are connecting to (You can obtain from the '''MS SQL''' section of the control panel).<br /><br /><br />
'''Port:''' Enter in the port for the MS SQL server (All of our shared servers and VPS use the default MS SQL port of ''''1433'''').<br /><br /><br />
'''Username (Optional):''' Enter in the user name for the database you are wanting to connect to (You can obtain from the '''MySQL''' section of the control panel).<br /><br /><br />
'''Password (Optional):''' Enter in the password to the user name you provided in the 'Username' field.<br /><br /><br />
'''ColdFusion DataSource:''' If your website is on a server that has ColdFusion installed then you will have a checkbox for '''ColdFusion DataSource'''. When this field is checked then the datasource will be created within ColdFusion as well as the default ODBC service.<br /><br /><br />
'''Enable CLOB:''' Allows you to enable CLOB strings.<br /><br /><br />
'''Enable BLOB:''' Allows you to enable BLOB strings.<br /><br /><br />
<br />
[[file:wcp_dsn_mssql.png]]<br />
<br /><br /><br />
<br />
<br />
==PostgreSQL==<br />
<br /><br /><br />
<br />
'''DataSource Name:'''The DataSource name is the actual name of the DSN that you'll be calling within your websites code (PHP,CF, etc.)<br /><br /><br />
'''Database Name:''' Enter in the database name that you are connecting to.<br /><br /><br />
'''Server:''' Enter in the server name for the database you are connecting to.<br /><br /><br />
'''Port:''' Enter in the port for the PostgreSQL server (defaults to port ''''5432'''').<br /><br /><br />
'''Username (Optional):''' Enter in the user name for the database you are wanting to connect to.<br /><br /><br />
'''Password (Optional):''' Enter in the password to the user name you provided in the 'Username' field.<br /><br /><br />
'''Enable CLOB:''' Allows you to enable CLOB strings.<br /><br /><br />
'''Enable BLOB:''' Allows you to enable BLOB strings.<br /><br /><br />
<br />
'''Note:''' This is only an option if the domain is on a ColdFusion server. We do not have any shared PostgreSQL servers so this would be an external connection to a PostgreSQL database.. and not a connection to any of our servers.<br />
<br />
[[file:wcp_dsn_postgreSQL.png]]<br />
<br /><br /><br />
<br />
==Sybase==<br />
<br /><br /><br />
<br />
'''DataSource Name:'''The DataSource name is the actual name of the DSN that you'll be calling within your websites code (PHP,CF, etc.)<br /><br /><br />
'''Database Name:''' Enter in the database name that you are connecting to.<br /><br /><br />
'''Server:''' Enter in the server name for the database you are connecting to.<br /><br /><br />
'''Port:''' Enter in the port for the Sybase server (defaults to port ''''5000'''').<br /><br /><br />
'''Username (Optional):''' Enter in the user name for the database you are wanting to connect to.<br /><br /><br />
'''Password (Optional):''' Enter in the password to the user name you provided in the 'Username' field.<br /><br /><br />
'''Enable CLOB:''' Allows you to enable CLOB strings.<br /><br /><br />
'''Enable BLOB:''' Allows you to enable BLOB strings.<br /><br /><br />
<br />
'''Note:''' This is only an option if the domain is on a ColdFusion server. We do not have any shared PostgreSQL servers so this would be an external connection to a PostgreSQL database.. and not a connection to any of our servers.<br />
<br />
[[file:wcp_dsn_sybase.png]]<br />
<br /><br /><br />
<br />
==Oracle==<br />
<br /><br /><br />
<br />
'''DataSource Name:'''The DataSource name is the actual name of the DSN that you'll be calling within your websites code (PHP,CF, etc.)<br /><br /><br />
'''Database Name:''' Enter in the database name that you are connecting to.<br /><br /><br />
'''Server:''' Enter in the server name for the database you are connecting to.<br /><br /><br />
'''SID Name:''' Enter the SID Name from your Oracle host here.<br /><br /><br />
'''Port:''' Enter in the port for the Oracle server (defaults to port ''''1521'''').<br /><br /><br />
'''Username (Optional):''' Enter in the user name for the database you are wanting to connect to.<br /><br /><br />
'''Password (Optional):''' Enter in the password to the user name you provided in the 'Username' field.<br /><br /><br />
'''Enable CLOB:''' Allows you to enable CLOB strings.<br /><br /><br />
'''Enable BLOB:''' Allows you to enable BLOB strings.<br /><br /><br />
<br />
'''Note:''' This is only an option if the domain is on a ColdFusion server. We do not have any shared PostgreSQL servers so this would be an external connection to a PostgreSQL database.. and not a connection to any of our servers.<br />
<br />
[[file:wcp_dsn_oracle.png]]<br />
<br /><br /><br />
<br />
</ol><br />
<br />
=Updating a DSN=<br />
<br /><br /><br />
<br />
<ol><br />
<li>Click on the icon in the control panel labeled ''''DataSources (DSNs)'''' under the '''Databases''' section.</li><br />
<br /><br />
[[file:wcp_dsn_icon.png]]<br />
<br /><br /><br />
<br />
<li>You should now see a list of any existing DSNs (if any). To update a DSN click the pencil icon to the left of the DSN name as shown in the screenshot below:</li><br />
<br /><br />
[[file:wcp_dsn_edit_icon.png]]<br />
<br /><br /><br />
<br />
<li>You will now be able to update the values for the DSN such as the password if needed... click on the ''''Save'''' button to save any changes you make to a DSN.</li><br />
<br />
<br />
=Deleting a DSN=<br />
<br /><br /><br />
<br />
<ol><br />
<li>Click on the icon in the control panel labeled ''''DataSources (DSNs)'''' under the '''Databases''' section.</li><br />
<br /><br />
[[file:wcp_dsn_icon.png]]<br />
<br /><br /><br />
<br />
<li>You should now see a list of any existing DSNs (if any). To delete a DSN click on the trash can icon to the right of the DSN as shown in the screenshot below:</li><br />
<br /><br />
[[file:wcp_dsn_delete_icon.png]]<br />
<br /><br /><br />
<br />
<li>A prompt should appear asking if you want to confirm the deletion of the DSN. Click ''''OK'''' to proceed with the removal or click ''''Cancel'''' to cancel the deletion of the DSN.</li><br />
<br />
</ol><br />
<br />
<br />
[[Category:WCP (Windows based Control Panel)]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_delete_icon.png&diff=3648File:Wcp dsn delete icon.png2017-08-07T14:39:49Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_edit_icon.png&diff=3647File:Wcp dsn edit icon.png2017-08-07T14:31:31Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_oracle.png&diff=3646File:Wcp dsn oracle.png2017-08-06T23:00:55Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_sybase.png&diff=3645File:Wcp dsn sybase.png2017-08-06T22:58:20Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_postgreSQL.png&diff=3644File:Wcp dsn postgreSQL.png2017-08-06T22:54:35Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_mssql.png&diff=3643File:Wcp dsn mssql.png2017-08-06T22:51:01Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Dsn_mysql.png&diff=3642File:Dsn mysql.png2017-08-06T22:25:29Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_access.png&diff=3641File:Wcp dsn access.png2017-08-06T22:14:23Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_add_type.png&diff=3640File:Wcp dsn add type.png2017-08-06T21:56:14Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_add_bttn.png&diff=3639File:Wcp dsn add bttn.png2017-08-06T21:53:16Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_dsn_icon.png&diff=3638File:Wcp dsn icon.png2017-08-06T21:10:16Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=Category:WCP_(Windows_based_Control_Panel)&diff=3637Category:WCP (Windows based Control Panel)2017-08-06T18:34:35Z<p>Kaseya: </p>
<hr />
<div><!-- BANNER ACROSS TOP OF PAGE --><br />
<div id="mp-topbanner" style="clear:both; position:relative; box-sizing:border-box; width:100%; margin:1.2em 0 6px; min-width:47em; border:1px solid #ddd; background-color:#f9f9f9; color:#000; white-space:nowrap;"><br />
<br />
<div style="margin:0.4em; width:22em; text-align:center;"><br />
<div style="font-size:162%; padding:.1em;">Category: WCP (Windows Control Panel)</div><br />
<div style="font-size:95%;">Manage Websites, Resellers, & Dedicated Servers</div><br />
<div id="articlecount" style="font-size:85%;">[[Special:Statistics|{{PAGESINCAT:WCP_(Windows_based_Control_Panel)}}]] articles in WCP.</div><br />
</div><br />
<!-- PORTAL LIST ON RIGHT-HAND SIDE --><br />
<ul style="position:absolute; right:-1em; top:50%; margin-top:-2.4em; width:38%; min-width:25em; font-size:95%;"><br />
<br /><br />
<b style="font-size: 18px; font-weight: bold;"> Windows Control Panel: https://wcp.hostek.com </b><br />
</ul><br />
</div><br />
<!-- MAIN PAGE BANNER --><br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">We've organized the list of WCP articles in the below categories for easy browsing. If needed view the full list of articles at the bottom of the page.<br />
</td></tr><br />
</table> <br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#cef2e0; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If you are looking for the category page for either '''WCP Reseller Management''' or '''WCP Server Management''' click on the corresponding links below:<br /><br />
<center> [[:Category:WCP Account Management| WCP Account Management]] | [[:Category:WCP Server Management| WCP Server Management]] </center><br />
</td></tr><br />
</table> <br />
<br />
<br />
{| id="mp-upper" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"<br />
<!-- first frame (green) --><br />
| class="MainPageBG" style="width:55%; border:1px solid #cef2e0; background-color:#f5fffa; vertical-align:top; color:#000;" |<br />
{| id="mp-left" style="width:100%; vertical-align:top; background-color:#f5fffa;"<br />
| style="padding:2px;" | <h2 id="mp-tfa-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">Intro Information</h2><br />
|-<br />
| style="color:#000;" | <div id="mp-tfa" style="padding:2px 5px"><br />
<br />
<li>Logging into WCP [ [[How_to_login_to_WCP| View ]] ]</li><br />
<li>Forgot WCP Password? [[Forgot_WCP_Password| View ]] ]</li><br />
<li>Change Domain to Manage [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Switch between Account & Server Manager [ [[Switching_Between_WCP_Management_Options| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Domains" & "Domain Settings" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Domain Notes [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Additional Control Panel Logins [ [[Adding_Additional_Control_Panel_Logins| View ]] ]</li><br />
<li>Manage Sub Domains [ [[Create_and_manage_subdomains_via_WCP| View ]] ]</li><br />
<li>Manage Domain Aliases [ [[Create_and_manage_domain_aliases_in_WCP| View ]] ]</li><br />
<li>DNS Manager [ [[Managing_DNS_Records_via_WCP| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Files" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>FTP Accounts [ [[FTP_Accounts| View ]] ]</li><br />
<li>File Manager [ [[WCP_File_Manager| View ]] ]</li><br />
<li>Virtual Directories [ [[Virtual_Directories| View ]] ]</li><br />
<li>Password Protect [ [[IIS_Password_Protect| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Databases" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage MySQL Databases [ [[Manage_MySQL/MariaDB_Databases_(Windows_Environment)| View ]] ]</li><br />
<li>Login to phpMyAdmin [ [[WCP_-_Login_to_phpMyAdmin| View ]] ]</li><br />
<li>Manage MS SQL Databases [ [[Manage_MS_SQL_Databases| View ]] ]</li><br />
<li>Using MyLittleAdmin/MyLittleBackup [ [[MyLittleAdmin_/_myLittleBackup| View ]] ]</li><br />
<li>Manage DSNs (Datasources) [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
</div><br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Website Settings" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage ASP.net Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage PHP Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
<li class="mw-customtoggle-iissettings">IIS Settings</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-iissettings"><br />
<ul><br />
<li>Manage Custom Errors [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Mime Types [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Default Documents [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage URL Forwarding [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Authentication [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage IIS Caching [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Advanced IIS Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
</ul><br />
</div><br />
<li>Manage Application Folders [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>View Site Details [ [[Site_Details| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Email" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage E-Mail Users [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage E-Mail Aliases [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Enable SPF & Domain Keys For E-Mail [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Searching E-Mail Logs [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage DSNs (Datasources) [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Reporting & Applications" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Enable & Manage Stats [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Applications [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Cron Jobs [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Enable / Disable Application extensions [ [[Enable / Disable Application extensions| View ]] ] </li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"ColdFusion" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>ColdFusion Error Log [ [[ColdFusion Error Log| View ]] ] </li><br />
<li>Clear Template Cache [ [[Clear Template Cache| View ]] ] </li><br />
<li>ColdFusion Scheduled Task (Cron Jobs) [ [[ColdFusion Scheduled Task| View ]] ] </li><br />
<br />
</div><br />
<br />
<br />
|}<br />
| style="border:1px solid transparent;" |<br />
<br />
<!-- Second frame (blue) --><br />
| class="MainPageBG" style="width:45%; border:1px solid #cedff2; background-color:#f5faff; color:#000; vertical-align:top;"|<br />
{| id="mp-right" style="width:100%; vertical-align:top; background-color:#f5faff;"<br />
| style="padding:2px;" | <h2 id="mp-itn-h2" style="margin:3px; background-color:#cedff2; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3b0bf; text-align:left; color:#000; padding:0.2em 0.4em;">WIKI Categories:</h2><br />
|-<br />
| style="color:#000; padding:2px 5px;" | <div id="mp-itn"><br />
<br />
<ul><br />
<br />
<!--- Billing ---><br />
<li class="mw-customtoggle-billing">Billing [ [[#| View]] ]</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-billing"><br />
<ul><br />
<li>Domain Registrations [ [[:Category:Domain_Registrations| View]] ]</li><br />
</ul><br />
</div><br /><br />
<!--- Windows ---><br />
<li class="mw-customtoggle-windows">Windows Environment</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-windows"><br />
<ul><br />
<li>ColdFusion [ [[#| View]] ]</li><br />
<li>IIS - Need to Knows [ [[#| View]] ]</li><br />
<li>MS SQL [ [[#| View]] ]</li><br />
<li>PHP [ [[#| View]] ]</li><br />
<li>Railo/Lucee [ [[#| View]] ]</li><br />
<li>RDP (Remote Desktop) [ [[#| View]] ]</li><br />
<li>SmarterMail [ [[#| View]] ]</li><br />
<li>WCP (Windows Control Panel) [ [[#| View]] ]</li><br />
<br />
</ul><br />
</div><br />
<br />
<br />
<!--- Windows ---><br />
<li class="mw-customtoggle-linux">Linux Environment</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-linux"><br />
<ul><br />
<li>ColdFusion [ [[#| View]] ]</li><br />
<li>cPanel [ [[#| View]] ]</li><br />
<li>cPanel Mail [ [[#| View]] ]</li><br />
<li>Railo/Lucee [ [[#| View]] ]</li><br />
<li>SSH (Shell Access) [ [[#| View]] ]</li><br />
<li>WHM (Remote Desktop) [ [[#| View]] ]</li><br />
<br />
</ul><br />
</div><br />
<br />
|}<br />
|}<br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If there is any suggestions for additional wiki articles or an article that you think needing updated please make the request to our support team.<br />
</td></tr><br />
</table> <br />
<br />
<!-- INTERWIKI STRAPLINE --><br />
__NOTOC____NOEDITSECTION__</div>Kaseyahttps://wiki.hostek.com/index.php?title=MyLittleAdmin_/_myLittleBackup&diff=3636MyLittleAdmin / myLittleBackup2017-08-06T18:33:24Z<p>Kaseya: Created page with "This wiki article will show how to login to your myLittleAdmin or myLittleBackup via your WCP control panel. <br /><br /> =What is myLittleAdmin / myLittleBackup?= '''myLitt..."</p>
<hr />
<div>This wiki article will show how to login to your myLittleAdmin or myLittleBackup via your WCP control panel.<br />
<br /><br /><br />
<br />
=What is myLittleAdmin / myLittleBackup?=<br />
<br />
'''myLittleAdmin''' - The '''myLittleAdmin''' feature is an application that allows you to login to your database and view and manage your MS SQL database. You can run queries via your database(s) as well as view, create, update, and delete table information for your database.<br />
<br />
This is an alternative option for those that don't want to use SQL Server Management Studio.. which is the main tool used for managing Microsoft SQL databases.<br />
<br /><br /><br />
<br />
'''myLittleBackup''' - The '''myLittleBackup''' feature is an application that allows you to backup and / or restore your database. If you are moving your database from one host machine to another (such as from another hosting provider) then you can use this tool to upload your backup file and restore the database on our servers.<br />
<br /><br /><br />
<br />
'''Note:''' ''These two tools are only an option for those on our shared platforms.. as these tools are licensed for the use for our shared MS SQL servers. For dedicated (VPS) customers please connect to your database(s) via SQL Server Management Studio directly on your local computer or directly on the desktop of your server via RDP.<br />
<br />
=Navigating to myLittleAdmin / myLittleBackup=<br />
<br />
<ol style="list-style-type: decimal;"><br />
<li>First login to your WCP control panel for the account the domain is under: https://wcp.hostek.com<br />
<br /><br />
[[file:wcp_url_secure.png]]<br />
<br /><br /><br />
<p>If you have any issues with logging into WCP then please see our tutorials on [[Forgot_WCP_Password|recovering your password]] if necessary</p></li><br />
<br />
<br /><br />
<br />
<li>Once logged into WCP if you have multiple domains you may need to select the appropriate domain to manage using the ''''Hosted Domains'''' drop-down in the top-right of the page as shown in the screenshot below:<br />
<br /><br />
[[file:wcp_change_domain.png]]<br />
<br /><br /><br />
</li><br />
<br />
<li>Now click on the icon labeled ''''MS SQL Tools'''' under the '''Databases''' section</li><br />
<br /><br />
[[file:wcp_mssql_tools.png]]<br />
<br /><br /><br />
<br />
<li>You should now see a list of available database users you can login to for each database and it's associated server. Click on the ''''Login'''' button next to either '''myLittleAdmin''' or '''myLittleBackup'''.. depending on which tool you're wanting to access.</li><br />
<br /><br />
[[file:mssql_tools_login_btn.png]]<br />
<br /><br /><br />
</ol><br />
<br />
==Backing up Database (myLittleBackup)==<br />
In the above section we covered how to login to myLittleBackup.. let's now show how to backup the database.<br />
<br /><br /><br />
<br />
<ol><br />
<br />
<li>In the menu on the left-navigation panel click on the ''''Backup Database'''' option as shown in the screenshot below:</li><br />
<br /><br />
[[file:mLB_backup_menu.png]]<br />
<br /><br /><br />
<br />
<li>Now click the drop-down and select the database you want to backup as shown in the screenshot below:</li><br />
<br /><br />
[[file:mLB_backup_db_option.png]]<br />
<br /><br /><br />
<br />
<li>Next click on ''''OK'''', then click on ''''Backup'''' as shown in the screenshot below:</li><br />
<br /><br />
[[file:mLB_backup_bttn.png]]<br />
<br /><br /><br />
<br />
<li>Now you should see a message stating the backup was successful and link to download the backup. Click the link and the file will download to the location your browser has set as the default downloads folder on your computer</li><br />
<br /><br />
[[file:mLB_backup_download.png]]<br />
<br /><br /><br />
<br />
</ol><br />
<br />
==Restoring Database (myLittlebackup)==<br />
In the above section we covered how to login to myLittlebackup.. let's now show how to restore a database.<br />
<br />
<ol><br />
<br />
<li>In the menu on the left-navigation menu click on the ''''Restore Database'''' option as shown in the below screenshot:</li><br />
<br /><br />
[[file:mLB_restore_menu.png]]<br />
<br /><br /><br />
<br />
<li>Now click on the drop-down and select the database you wish to restore to as shown in the screenshot below:</li><br />
<br /><br />
[[file:mLB_restore_options.png]]<br />
<br /><br /><br />
<br />
<li>Click on the ''''OK'''' button. A new field will appear asking you to select the backup file (or upload one) to use to restore the database from. Click ''''Choose File'''' and select your database backup file and then click ''''OK'''' again to start the upload.</li><br />
<br /><br />
[[file:mLB_restore_file.png]]<br />
<br /><br /><br />
<br />
<li>Now you should see the file you uploaded in the list of available files to choose from. Click on the file you wish to select and then click on ''''OK'''' to use that file.</li><br />
<br /><br />
[[file:mLB_restore_choosefile.png]]<br />
<br /><br /><br />
<br />
<li>Now click on the ''''Restore'''' button as shown in the screenshot below:</li><br />
<br /><br />
[[file:mLB_restore_bttn.png]]<br />
<br /><br /><br />
<br />
<li>You will receive a prompt in your browser asking if you're sure that you want to restore / overwrite your existing database with the file you selected. Click ''''OK'''' to proceed and ''''Cancel'''' to cancel.</li><br />
<br /><br /><br />
</ol><br />
<br />
===Post Restore Common Issue===<br />
<br /><br />
<br />
It is known that when restoring an MS SQL database that this can cause the database owner (DBO) to become lost and needing to be set back to the actual database user. If you find that your database becomes inaccessible or has permissions issues after this restore please set the Database Owner (DBO) back to the user it should be assigned to. You can see the wiki article on managing your [[Manage_MS_SQL_Databases#Update_MS_SQL_Database_Settings|database settings]] if needed.<br />
<br />
<br />
[[Category:WCP (Windows based Control Panel)]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_restore_bttn.png&diff=3635File:MLB restore bttn.png2017-08-06T18:26:07Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_restore_choosefile.png&diff=3634File:MLB restore choosefile.png2017-08-06T18:23:25Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_restore_file.png&diff=3633File:MLB restore file.png2017-08-06T18:22:22Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_restore_options.png&diff=3632File:MLB restore options.png2017-08-06T18:18:11Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_restore_menu.png&diff=3631File:MLB restore menu.png2017-08-06T18:08:52Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_backup_download.png&diff=3630File:MLB backup download.png2017-08-06T18:07:14Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_backup_bttn.png&diff=3629File:MLB backup bttn.png2017-08-06T18:05:01Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_backup_db_option.png&diff=3628File:MLB backup db option.png2017-08-06T18:03:31Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:MLB_backup_menu.png&diff=3627File:MLB backup menu.png2017-08-06T18:01:20Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Mssql_tools_login_btn.png&diff=3626File:Mssql tools login btn.png2017-08-06T17:53:49Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_mssql_tools.png&diff=3625File:Wcp mssql tools.png2017-08-06T17:51:59Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=Manage_MS_SQL_Databases&diff=3624Manage MS SQL Databases2017-08-06T17:34:48Z<p>Kaseya: Created page with "__FORCETOC__ In this tutorial we will show how to create and manage MSSQL Databases and their respective users in WCP. = Navigate to MSSQL Database Section = <br /><br /> <..."</p>
<hr />
<div>__FORCETOC__<br />
<br />
In this tutorial we will show how to create and manage MSSQL Databases and their respective users in WCP.<br />
<br />
= Navigate to MSSQL Database Section =<br />
<br /><br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<li><p>First login to your WCP control panel for the account the domain is under: https://wcp.hostek.com</p><br />
<br /><br />
[[file:wcp_url_secure.png]]<br />
<br /><br /><br />
<p>If you have any issues with logging into WCP then please see our tutorials on [[Forgot_WCP_Password|recovering your password]] if necessary</p></li><br />
<br />
<br /><br />
<br />
<li><p>Once logged into WCP if you have multiple domains you may need to select the appropriate domain to manage using the ''''Hosted Domains'''' drop-down in the top-right of the page as shown in the screenshot below:</p><br />
[[file:wcp_change_domain.png]]<br />
<br /><br /><br />
</li><br />
<br />
<br />
<li><p>In your control panel click on the ''''MS SQL'''' icon under the ''''Databases'''' section.</p><br />
<br /><br />
[[file:wcp_mssql_icon.png]]<br />
<br /><br /><br />
</li><br />
</ol><br />
<br />
<br /><br />
<br />
==Add MS SQL Database==<br />
<br /><br /><br />
<ol><br />
<br />
<li>If you don't have any existing databases then skip to step 3, as you'll automatically be on the '''new database''' screen. If you do already have existing database(s) then you should see them listed here, along with the server they reside on. Click on the ''''Add Database'''' button to create a new database.<br />
<br /><br />
[[file:wcp_add_db_bttn.png]]<br />
<br /><br /><br />
<br />
</li><br />
<br />
<li><p>You will now be asked for the below database information to be created:</p><br />
<br /><br />
[[file:wcp_mssql_add_db.png]]<br />
<br /><br /><br />
<br />
<p>'''MSSQL Version:''' This '''MSSQL Version''' field will show the server that your MS SQL database will be created on, along with the version of MS SQL that the server is using.</p><br />
<p>'''Database Name:''' Enter the desired database name that you wish to create.</p><br />
<p>'''User:''' This '''User''' drop-down allows you to select an already existing user if you have a MS SQL user that is already on the server that your new database is being created on. If you do not have a pre-existing user or you don't wish to use a pre-existing user then you'll need to fill in the ''username'' and ''password'' fields.</p><br />
<p>'''''Note'':''' ''If you do select a pre-existing user then the 'username' and 'password' fields will disappear.''</p><br />
<p>'''Username:''' Enter the username you wish to create that you'll use to login to the MS SQL database.</p><br />
<p>'''Password:''' Enter the password for the new MS SQL user that you are creating. You'll use this password to login to the MS SQL database user.</p><br />
<p>'''Default Collation:''' In the 'Default Collation' drop-down menu, select the default collation for this database. Our default collation is usually sufficient, and you likely won't need to change it. If you're unsure, you'll need to consult with your application developer.</p><br />
<p>'''Recovery Model:''' A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. In the '''Recovery Model''' drop-down menu, you can set your recovery model to either 'Full' or 'Simple'. We recommend keeping this as 'Simple' to prevent large log files that can cause the database to fill up. We have backups on our shared servers for MS SQL if needed so setting to 'Simple' would be our recommendation.</p><br />
<p>'''ColdFusion DataSource:''' This checkbox option is only visible if your site resides on a ColdFusion server. Selecting the checkbox will automatically create a data source (DSN) within ColdFusion Admin with the configuration details of the database you're creating. After selecting the checkbox a field will appear which you can enter the name of the data source that you'll call within your sites application (code).</p><br />
<br /><br /><br />
<br />
</li><br />
<br />
<li><p>Double check the values you have entered, then click the ''''Save'''' button to add this MSSQL database.</p></li></ol><br />
<br />
==Update MS SQL Database Settings==<br />
<br /><br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<br />
<li><p>If you have databases on multiple database servers, you may need to click on the pencil icon next to the related MS SQL database server (you should see a list of databases on each database server in order to differentiate). Now to update an existing MS SQL database click on the pencil icon next to the MS SQL database that you would like to manage.</p><br />
<br /><br />
[[file:wcp_edit_database.png]]<br />
<br /><br /><br /><br />
<br />
</li><br />
<br />
<li><p>You should now have the option to update the following:</p><br />
<br /><br />
[[file:wcp_edit_mssql_database.png]]<br />
<br /><br /><br />
<br />
<p>'''Database Size:''' Use this drop-down to change your database's maximum size.</p><br />
<p>'''Default Collation:''' Use this drop-down to change your databases default collation for tables. A collation is a set of rules for comparing characters in a character set. The application developer for the site should know which collation is needed, which if not the pre-set default collation of '''SQL''Latin1_General_CP1_CI_AS_''' would probably be best.</p><br />
<p>'''Recovery Model:''' Use this drop-down to change the way transaction logs are stored for the database. Keep in mind that setting this option to 'Full' can cause the transaction logs for the database to become full which would result in the database being non-functional until the logs were shrunk or more space was allocated to the database.</p><br />
<p>'''''Note:''' Please also note that we keep backups for databases already for shared servers. Depending on the add-ons you have selected for backups we may have database backups for VPS servers as well.''</p><br />
<p>'''Database Owner (DBO):''' Use this drop-down to change which user is the owner of the database. The database owner has special permissions, which commonly is needed for any updates to the database via a sites application or even by logging into the database with tools such as SQL Server Management Studio.</p><br />
<p>'''''Note:''' If you login successfully to an application but cannot see the database then it's usually a sign that the user you're connected with is not set as the DBO.''</p><br />
<br /><br />
</li><br />
<br />
<li><p>Double check the values you have selected, then click the ''''Save'''' button to finish modifying this MS SQL database.</p></li></ol><br />
<br />
==Add an MSSQL User==<br />
<br /><br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<br />
<li><p>Click on the ''''Add User'''' button to create a new user.</p><br />
<br /><br />
[[file:wcp_add_mssqluser_btn.png]]<br />
<br /><br /><br />
<br />
<p>'''''Note:''' If you have databases on multiple database servers, you may need to click on the pencil icon next to the related MS SQL database server first (you should see a list of databases on each database server in order to differentiate).''</p></li><br />
<li><p>You should now see the below requested fields for the new MS SQL user:</p><br />
<br /><br />
[[file:wcp_mssql_new_user_info.png]]<br />
<br /><br /><br />
<br />
<p>'''Username:''' ''Enter the name of the new MS SQL user you would like to add.''</p><br />
<p>'''Password:''' ''Enter the password for the new MS SQL user you would like to add.''</p><br />
<p>'''Permissions:''' ''The 'Permissions' section allows you to choose which databases the MS SQL user has access to. Select the checkbox for each database this user should have basic permissions to.''</p><br />
<p>'''''Note:''' The user does not automatically get assigned as DBO, which most task in MS SQL requires the user to be set as, so you'll have to follow the instructions in the above section ''''Update MS SQL Database Settings''''.''</p><br />
</li><br />
<br /><br /><br />
<br />
<li><p>Double check the values you have entered, then click the ''''Save'''' button to add this MySQL database user and it's respective permissions.</p></li></ol><br />
<br />
===Updating MSSQL User Password &amp; Permissions===<br />
<br /><br /><br />
<br />
<ol style="list-style-type: decimal;"><br />
<br />
<li><p>Click on the pencil icon next to the user.</p><br />
<br /><br />
[[file:wcp_edit_db_user.png]]<br />
<br /><br /><br />
<br />
<p>'''''Note:''' If you have databases on multiple database servers, you may need to click on the pencil icon next to the related MS SQL database server first (you should see a list of databases on each database server in order to differentiate).''</p></li><br />
<li><p>Now you will be able to update the MS SQL users password and / or permissions.</p><br />
<br /><br />
[[file:wcp_edit_mssql_user_info.png]]<br />
<br /><br /><br />
<br />
<ul><br />
<li><p>To update your password enter in the newly desired password into the ''''Password'''' field. Passwords must:</p></li><br />
<ul><br />
<li>Be at least 6 characters long</li><br />
<li>Have a lowercase letter</li><br />
<li>Have a uppercase letter</li><br />
<li>Have a number</li><br />
<li>Have a symbol</li><br />
</ul><br />
<br /><br />
<br />
<li><p>You may update this user's default database by selecting the new default database in the drop-down menu next to ''''Default Database''''.</p></li><br />
<br /><br />
<br />
<li><p>The permissions section allows you to select the checkbox next to each database you wan the user to have basic permissions to. Please note that most MS SQL database functions and applications require that the user be set as the DBO, which you'll have to do through the above section for [[#Update_MS_SQL_Database_Settings| Updating Database Settings]].</p></li></ul><br />
</li><br />
<br /><br /><br />
<br />
<li><p>Double check the values you have entered, then click the ''''Save'''' button.</p></li></ol><br />
<br />
[[Category:WCP_(Windows_based_Control_Panel)]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_edit_db_user.png&diff=3623File:Wcp edit db user.png2017-08-06T17:20:47Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_edit_mssql_user_info.png&diff=3622File:Wcp edit mssql user info.png2017-08-06T17:17:51Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_mssql_new_user_info.png&diff=3621File:Wcp mssql new user info.png2017-08-06T17:15:16Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_add_mssqluser_btn.png&diff=3620File:Wcp add mssqluser btn.png2017-08-06T17:14:13Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_edit_mssql_database.png&diff=3619File:Wcp edit mssql database.png2017-08-06T16:56:39Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_edit_database.png&diff=3618File:Wcp edit database.png2017-08-06T16:54:01Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_mssql_add_db.png&diff=3617File:Wcp mssql add db.png2017-08-06T16:39:07Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_add_db_bttn.png&diff=3616File:Wcp add db bttn.png2017-08-06T16:35:12Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_mssql_icon.png&diff=3615File:Wcp mssql icon.png2017-08-06T16:31:33Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=Category:WCP_(Windows_based_Control_Panel)&diff=3614Category:WCP (Windows based Control Panel)2017-08-06T16:29:20Z<p>Kaseya: </p>
<hr />
<div><!-- BANNER ACROSS TOP OF PAGE --><br />
<div id="mp-topbanner" style="clear:both; position:relative; box-sizing:border-box; width:100%; margin:1.2em 0 6px; min-width:47em; border:1px solid #ddd; background-color:#f9f9f9; color:#000; white-space:nowrap;"><br />
<br />
<div style="margin:0.4em; width:22em; text-align:center;"><br />
<div style="font-size:162%; padding:.1em;">Category: WCP (Windows Control Panel)</div><br />
<div style="font-size:95%;">Manage Websites, Resellers, & Dedicated Servers</div><br />
<div id="articlecount" style="font-size:85%;">[[Special:Statistics|{{PAGESINCAT:WCP_(Windows_based_Control_Panel)}}]] articles in WCP.</div><br />
</div><br />
<!-- PORTAL LIST ON RIGHT-HAND SIDE --><br />
<ul style="position:absolute; right:-1em; top:50%; margin-top:-2.4em; width:38%; min-width:25em; font-size:95%;"><br />
<br /><br />
<b style="font-size: 18px; font-weight: bold;"> Windows Control Panel: https://wcp.hostek.com </b><br />
</ul><br />
</div><br />
<!-- MAIN PAGE BANNER --><br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">We've organized the list of WCP articles in the below categories for easy browsing. If needed view the full list of articles at the bottom of the page.<br />
</td></tr><br />
</table> <br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#cef2e0; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If you are looking for the category page for either '''WCP Reseller Management''' or '''WCP Server Management''' click on the corresponding links below:<br /><br />
<center> [[:Category:WCP Account Management| WCP Account Management]] | [[:Category:WCP Server Management| WCP Server Management]] </center><br />
</td></tr><br />
</table> <br />
<br />
<br />
{| id="mp-upper" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"<br />
<!-- first frame (green) --><br />
| class="MainPageBG" style="width:55%; border:1px solid #cef2e0; background-color:#f5fffa; vertical-align:top; color:#000;" |<br />
{| id="mp-left" style="width:100%; vertical-align:top; background-color:#f5fffa;"<br />
| style="padding:2px;" | <h2 id="mp-tfa-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">Intro Information</h2><br />
|-<br />
| style="color:#000;" | <div id="mp-tfa" style="padding:2px 5px"><br />
<br />
<li>Logging into WCP [ [[How_to_login_to_WCP| View ]] ]</li><br />
<li>Forgot WCP Password? [[Forgot_WCP_Password| View ]] ]</li><br />
<li>Change Domain to Manage [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Switch between Account & Server Manager [ [[Switching_Between_WCP_Management_Options| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Domains" & "Domain Settings" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Domain Notes [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Additional Control Panel Logins [ [[Adding_Additional_Control_Panel_Logins| View ]] ]</li><br />
<li>Manage Sub Domains [ [[Create_and_manage_subdomains_via_WCP| View ]] ]</li><br />
<li>Manage Domain Aliases [ [[Create_and_manage_domain_aliases_in_WCP| View ]] ]</li><br />
<li>DNS Manager [ [[Managing_DNS_Records_via_WCP| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Files" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>FTP Accounts [ [[FTP_Accounts| View ]] ]</li><br />
<li>File Manager [ [[WCP_File_Manager| View ]] ]</li><br />
<li>Virtual Directories [ [[Virtual_Directories| View ]] ]</li><br />
<li>Password Protect [ [[IIS_Password_Protect| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Databases" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage MySQL Databases [ [[Manage_MySQL/MariaDB_Databases_(Windows_Environment)| View ]] ]</li><br />
<li>Login to phpMyAdmin [ [[WCP_-_Login_to_phpMyAdmin| View ]] ]</li><br />
<li>Manage MS SQL Databases [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon! (KA)</strong></li><br />
<li>Using MyLittleAdmin/MyLittleBackup [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage DSNs (Datasources) [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
</div><br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Website Settings" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage ASP.net Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage PHP Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
<li class="mw-customtoggle-iissettings">IIS Settings</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-iissettings"><br />
<ul><br />
<li>Manage Custom Errors [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Mime Types [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Default Documents [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage URL Forwarding [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Authentication [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage IIS Caching [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Advanced IIS Settings [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
</ul><br />
</div><br />
<li>Manage Application Folders [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>View Site Details [ [[Site_Details| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Email" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage E-Mail Users [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage E-Mail Aliases [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Enable SPF & Domain Keys For E-Mail [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Searching E-Mail Logs [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage DSNs (Datasources) [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"Reporting & Applications" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Enable & Manage Stats [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Manage Applications [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Cron Jobs [ [[#| View ]] ] <strong style="color: #FF0000; ">Coming soon!</strong></li><br />
<li>Enable / Disable Application extensions [ [[Enable / Disable Application extensions| View ]] ] </li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">"ColdFusion" Section</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>ColdFusion Error Log [ [[ColdFusion Error Log| View ]] ] </li><br />
<li>Clear Template Cache [ [[Clear Template Cache| View ]] ] </li><br />
<li>ColdFusion Scheduled Task (Cron Jobs) [ [[ColdFusion Scheduled Task| View ]] ] </li><br />
<br />
</div><br />
<br />
<br />
|}<br />
| style="border:1px solid transparent;" |<br />
<br />
<!-- Second frame (blue) --><br />
| class="MainPageBG" style="width:45%; border:1px solid #cedff2; background-color:#f5faff; color:#000; vertical-align:top;"|<br />
{| id="mp-right" style="width:100%; vertical-align:top; background-color:#f5faff;"<br />
| style="padding:2px;" | <h2 id="mp-itn-h2" style="margin:3px; background-color:#cedff2; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3b0bf; text-align:left; color:#000; padding:0.2em 0.4em;">WIKI Categories:</h2><br />
|-<br />
| style="color:#000; padding:2px 5px;" | <div id="mp-itn"><br />
<br />
<ul><br />
<br />
<!--- Billing ---><br />
<li class="mw-customtoggle-billing">Billing [ [[#| View]] ]</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-billing"><br />
<ul><br />
<li>Domain Registrations [ [[:Category:Domain_Registrations| View]] ]</li><br />
</ul><br />
</div><br /><br />
<!--- Windows ---><br />
<li class="mw-customtoggle-windows">Windows Environment</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-windows"><br />
<ul><br />
<li>ColdFusion [ [[#| View]] ]</li><br />
<li>IIS - Need to Knows [ [[#| View]] ]</li><br />
<li>MS SQL [ [[#| View]] ]</li><br />
<li>PHP [ [[#| View]] ]</li><br />
<li>Railo/Lucee [ [[#| View]] ]</li><br />
<li>RDP (Remote Desktop) [ [[#| View]] ]</li><br />
<li>SmarterMail [ [[#| View]] ]</li><br />
<li>WCP (Windows Control Panel) [ [[#| View]] ]</li><br />
<br />
</ul><br />
</div><br />
<br />
<br />
<!--- Windows ---><br />
<li class="mw-customtoggle-linux">Linux Environment</li><br />
<br />
<div class="mw-collapsible" id="mw-customcollapsible-linux"><br />
<ul><br />
<li>ColdFusion [ [[#| View]] ]</li><br />
<li>cPanel [ [[#| View]] ]</li><br />
<li>cPanel Mail [ [[#| View]] ]</li><br />
<li>Railo/Lucee [ [[#| View]] ]</li><br />
<li>SSH (Shell Access) [ [[#| View]] ]</li><br />
<li>WHM (Remote Desktop) [ [[#| View]] ]</li><br />
<br />
</ul><br />
</div><br />
<br />
|}<br />
|}<br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If there is any suggestions for additional wiki articles or an article that you think needing updated please make the request to our support team.<br />
</td></tr><br />
</table> <br />
<br />
<!-- INTERWIKI STRAPLINE --><br />
__NOTOC____NOEDITSECTION__</div>Kaseyahttps://wiki.hostek.com/index.php?title=WCP_-_Login_to_phpMyAdmin&diff=3613WCP - Login to phpMyAdmin2017-08-06T16:24:38Z<p>Kaseya: Created page with "In this tutorial we'll show how to login to phpMyAdmin via your WCP control panel. <br /><br /> <ol style="list-style-type: decimal;"> <li><p>First login to your WCP control..."</p>
<hr />
<div>In this tutorial we'll show how to login to phpMyAdmin via your WCP control panel.<br />
<br /><br /><br />
<br />
<br />
<ol style="list-style-type: decimal;"><br />
<li><p>First login to your WCP control panel for the account the domain is under: https://wcp.hostek.com</p><br />
[[file:wcp_url_secure.png]]<br />
<br /><Br /><br />
<p>If you have any issues with logging into WCP then please see our tutorials on [[Forgot_WCP_Password|recovering your password]] if necessary</p></li><br />
<br />
<br /><br />
<br />
<li><p>Once logged into WCP if you have multiple domains you may need to select the appropriate domain to manage using the ''''Hosted Domains'''' drop-down in the top-right of the page as shown in the screenshot below:</p><br />
[[file:wcp_change_domain.png]]<br />
<br /><br /><br />
</li><br />
<br />
<br /><br />
<br />
<li><p>In the &quot;Databases&quot; section, click on &quot;phpMyAdmin&quot;</p><br />
<br /><br />
[[file:wcp_phpmyadmin_icon.png]]<br />
<br /><br /><br />
<br />
<p>Here you'll see a list of each MySQL user you've setup for this domain. You will only see each user listed once, unless you have the same username created on multiple MySQL servers ( Each server can only have the user listed once ). You can see the database(s) this user is assigned to in the &quot;Databases&quot; column.</p><br />
<br /><br />
[[file:wcp_phpmyadmin_users.png]]<br />
<br /><br /><br />
<br />
</li><br />
<li><p>Click ''''Login'''' next to the MySQL user you would like to login to phpMyAdmin with.</p><br />
<br /><br />
[[file:wcp_phpmyadmin_login.png]]<br />
<br /><br /><br />
<br />
<p>''You should now be logged into phpMyAdmin where you can manage your MySQL databases.''</p></li></ol><br />
<br />
<br />
[[Category:WCP_(Windows_based_Control_Panel)]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_phpmyadmin_login.png&diff=3612File:Wcp phpmyadmin login.png2017-08-06T16:23:00Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_phpmyadmin_users.png&diff=3611File:Wcp phpmyadmin users.png2017-08-06T16:17:05Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=File:Wcp_phpmyadmin_icon.png&diff=3610File:Wcp phpmyadmin icon.png2017-08-06T16:16:13Z<p>Kaseya: </p>
<hr />
<div></div>Kaseyahttps://wiki.hostek.com/index.php?title=Category:Billing&diff=3609Category:Billing2017-08-06T16:00:07Z<p>Kaseya: </p>
<hr />
<div><!-- BANNER ACROSS TOP OF PAGE --><br />
<div id="mp-topbanner" style="clear:both; position:relative; box-sizing:border-box; width:100%; margin:1.2em 0 6px; min-width:47em; border:1px solid #ddd; background-color:#f9f9f9; color:#000; white-space:nowrap;"><br />
<br />
<div style="margin:0.4em; width:22em; text-align:center;"><br />
<div style="font-size:162%; padding:.1em;">Category: Billing</div><br />
<div style="font-size:95%;">Account, Ordering, Invoicing, etc.</div><br />
<div id="articlecount" style="font-size:85%;">[[Special:Statistics|{{PAGESINCAT:Billing}}]] articles in Billing.</div><br />
</div><br />
<!-- PORTAL LIST ON RIGHT-HAND SIDE --><br />
<ul style="position:absolute; right:-1em; top:50%; margin-top:-2.4em; width:38%; min-width:25em; font-size:95%;"><br />
<br /><br />
<b style="font-size: 18px; font-weight: bold;"> Billing Control Panel: https://cp.hostek.com </b><br />
</ul><br />
</div><br />
<!-- MAIN PAGE BANNER --><br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">We've organized the list of Billing articles in the below categories for easy browsing. If needed view the full list of articles at the bottom of the page.<br />
</td></tr><br />
</table> <br />
<br />
{| id="mp-upper" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"<br />
<!-- first frame (green) --><br />
| class="MainPageBG" style="width:55%; border:1px solid #cef2e0; background-color:#f5fffa; vertical-align:top; color:#000;" |<br />
{| id="mp-left" style="width:100%; vertical-align:top; background-color:#f5fffa;"<br />
| style="padding:2px;" | <h2 id="mp-tfa-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">Billing Account</h2><br />
|-<br />
| style="color:#000;" | <div id="mp-tfa" style="padding:2px 5px"><br />
<br />
<li>Register Account [ [[Billing_-_Register_Account| View ]] ]</li><br />
<li>Reset / Recover Password [ [[Billing_-_Password_Reset| View ]] ]</li><br />
<li>Update Account Information [ [[Billing_-_Update_Account_Information| View ]] ]</li><br />
<li>Manage Contacts / Sub-Accounts. [ [[Billing_-_Contacts_%26_Sub-Accounts| View ]] ]</li><br />
<li>Manage Security Question [ [[Billing_-_Security_Question| View ]] ]</li><br />
<li>Two-factor Authentication [ [[Client_Area_-_Two_Factor_Authentication| View ]] ]</li><br />
<br />
</div><br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">Invoices & Payment Information</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk"><br />
<br />
<li>Manage Credit Card on File [ [[Billing_-_Manage_Credit_Card| View ]] ]</li><br />
<li>Manage & Pay Invoices [ [[Billing_-_Manage_%26_Pay_Invoices| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background-color:#cef2e0; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">Misc.</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-otd"><br />
<br />
<li>Viewing Account Billing Related E-Mails? [ [[Billing_-_View_Email_History| View ]] ]</li><br />
<li>Transferring Services to Another Billing Account? [ [[Transfer_service_to_another_billing_account| View ]] ]</li><br />
<br />
</div><br />
<br />
<br />
|}<br />
| style="border:1px solid transparent;" |<br />
<br />
<!-- Second frame (blue) --><br />
| class="MainPageBG" style="width:45%; border:1px solid #cedff2; background-color:#f5faff; color:#000; vertical-align:top;"|<br />
{| id="mp-right" style="width:100%; vertical-align:top; background-color:#f5faff;"<br />
| style="padding:2px;" | <h2 id="mp-itn-h2" style="margin:3px; background-color:#cedff2; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3b0bf; text-align:left; color:#000; padding:0.2em 0.4em;">Domains, Hosting, & Add-ons</h2><br />
|-<br />
| style="color:#000; padding:2px 5px;" | <div id="mp-itn"><br />
<br />
<li>Ordering Domain Registrations [ [[Ordering_a_Domain_Registration| View ]] ]</li><br />
<li>Manage Domain Registrations [ [[Manage Domain Registration| View ]] ] </li><br />
<li>Ordering Add-On Services [ [[Ordering_Add-On_Products| View ]] ]</li><br />
<li>Cancel Hosting [ [[Cancel_Hosting| View ]] ]</li><br />
<li>Cancel Domain Registration [ [[Cancel Domain Registration| View ]] ] </li><br />
<li>Ordering SSL Certificate [ [[Ordering SSL Certificate| View ]] ] </li><br />
<br />
</div><br />
<br />
|-<br />
| style="padding:2px;" | <h2 id="mp-otd-h2" style="margin:3px; background-color:#cedff2; font-family:inherit; font-size:120%; font-weight:bold; border:1px solid #a3b0bf; text-align:left; color:#000; padding:0.2em 0.4em;">Affiliates</h2><br />
|-<br />
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-otd"><br />
<br />
<li>View Affiliate Program category page [ [[:Category:Affiliate_Program| View ]] ]</li><br />
All the affiliate information can be found in the category page mentioned above.<br />
</div><br />
<br />
|}<br />
|}<br />
<br />
<br /><br />
<table id="mp-banner" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"><br />
<tr><td class="MainPageBG" style="padding:8px; background-color:#fffaf5; border:1px solid #f2e0ce; color:#000; text-align: center; font-size:100%;">If there is any suggestions for additional wiki articles or an article that you think needing updated please make the request to our support team.<br />
</td></tr><br />
</table> <br />
<br />
<!-- INTERWIKI STRAPLINE --><br />
__NOTOC____NOEDITSECTION__</div>Kaseyahttps://wiki.hostek.com/index.php?title=Affiliate_Program&diff=3608Affiliate Program2017-08-06T15:56:50Z<p>Kaseya: Redirected page to Category:Affiliate Program</p>
<hr />
<div>#REDIRECT [[:Category:Affiliate_Program]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=Requesting_Withdrawal_from_Affiliate_Balance&diff=3607Requesting Withdrawal from Affiliate Balance2017-08-06T15:56:09Z<p>Kaseya: </p>
<hr />
<div><br />
<p>In this tutorial we will be showing how you can request a withdrawal from your affiliate account, in order to request a withdrawal you must have at least $100 within your affiliate account.</p><br />
<br /><br />
<br />
<ol style="list-style-type: decimal"><br />
<li>Is your affiliate balance >= $100</li><br />
<ol style="list-style-type: decimal"><br />
<li><p>If yes, please proceed to step 2.</p></li><br />
<br /><br />
[[file:Request_Withdrawl.PNG|400px|Click to expand]]]]<br />
<li><p>If no, a withdrawal is not possible as your affiliate balance must be >=$100.</p></li><br />
</ol><br />
<br />
<li>Where do you live?<br />
<ol style="list-style-type: decimal"><br />
<li><p>If in the United States, make sure to first provide us with a W-9</p></li><br />
<p>Please complete and fax back a W-9. You can get the W-9 at:</p><br />
<p>http://www.irs.gov/pub/irs-pdf/fw9.pdf</p><br />
You can fax the W9 to:<br />
1-866-565-5138<br />
<li><p>If you live outside of the United States, make sure you first provide us with a W-8BEN</p></li><br />
<p>Please complete and fax back a W-8BEN. You can get the W-8BEN at:</p><br />
<p>http://hostek.com/forms/w-8ben.pdf</p><br />
<p>Instructions for form: http://hostek.com/forms/instructions-form-w-8ben.pdf</p><br />
<p>You can fax the W-8BEN to:</p><br />
1-866-565-5138<br />
</ol><br />
<br />
<li><p>Once all of the above is verified and completed, then you can submit a [https://support.hostek.com Support Ticket] to billing requesting the withdrawal. </p></li><br />
<ol style="list-style-type: decimal"><br />
<li>Be sure to include how you prefer the withdrawal handled within your ticket to billing:</li><br />
<ol style="list-style-type: decimal"><br />
<li>applied as a credit to your account</li><br />
<li>paid via paypal (if so, what email address)</li><br />
<li>sent via check</li><br />
</ol><br />
<br />
<br />
<br />
[[Category:Billing]]<br />
[[Category:Affiliate Program]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=How_to_Check_Affiliate_Balance&diff=3606How to Check Affiliate Balance2017-08-06T15:55:50Z<p>Kaseya: </p>
<hr />
<div><h1 id="How to Check Affiliate Balance">How to Check Affiliate Balance.</h1><br />
<br />
<br />
<p>In this tutorial we will be showing how you can check the balance of your affiliate account.</p><br />
<br /><br />
<br />
<ol style="list-style-type: decimal"><br />
<li>Login to your [https://cp.hostek.com Client Area]</li><br />
[[file:Billing-account-register-01.png|400px|Click to expand]]<br />
<li><p>Click on the Affiliates tab.</p></li><br />
[[file:Affiliates Tab.PNG|400px|Click to expand]]<br />
<br /><br />
<li><p>Here you can view your affiliate account balance and other affiliate information.</p></li><br />
[[file:Affiliate_Information.PNG|400px|Click to expand]]<br />
</ol><br />
<br />
<br />
<br />
[[Category:Billing]]<br />
[[Category:Affiliate Program]]</div>Kaseyahttps://wiki.hostek.com/index.php?title=Obtain_Affiliate_Links_%26_Banners&diff=3605Obtain Affiliate Links & Banners2017-08-06T15:55:36Z<p>Kaseya: </p>
<hr />
<div><h1 id="Obtain Affiliate Links & Banners">Obtain Affiliate Links & Banners.</h1><br />
<br />
<br />
<p>In this tutorial we will be showing how to obtain affiliate links and banners.</p><br />
<br /><br />
<br />
<ol style="list-style-type: decimal"><br />
<li>Login to your [https://cp.hostek.com Client Area]</li><br />
[[file:Billing-account-register-01.png|400px|Click to expand]]<br />
<li><p>Click on the Affiliates tab.</p></li><br />
[[file:Affiliates Tab.PNG|400px|Click to expand]]<br />
<br /><br />
<li><p>Here you can obtain your affiliate links and banners.</p></li><br />
<ol style="list-style-type: decimal"><br />
<li>Your unique referral link</li><br />
[[file:Referral_link.PNG|400px|Click to expand]]<br />
<li>Specific hosting links with your unique referral code</li><br />
[[file:Hosting_referral_links.PNG|400px|Click to expand]]<br />
<li>Banners</li><br />
[[file:Banners.PNG|400px|Click to expand]]<br />
</ol></ol><br />
<br />
[[Category:Billing]]<br />
[[Category:Affiliate Program]]</div>Kaseya