Difference between revisions of "CORE:Frequently Asked Questions"
Jump to navigation
Jump to search
(Replaced content with "Database === Security") |
|||
| (32 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[Database ===]] | + | {{DISPLAYTITLE:Frequently Asked Questions}} |
| − | [[ | + | |
| + | |||
| + | ===Database=== | ||
| + | * [[Size Comparison of SwSQL with MS SQL ]] | ||
| + | * [[Increasing the Maximum Size of the Analyst E-Mail Address Field]] | ([http://forums.hornbill.com/index.php?showtopic=4773 Forum thread]) | ||
| + | * [[Adding Extra Filter Columns to the Call-Index Table]] | ||
| + | * [[How to Run a Batch Update of All Customer Records for Web Access]] | ([http://forums.hornbill.com/index.php?showtopic=150 Forum thread]) | ||
| + | * [[Changing the SwSQL Account Password]] | ([http://forums.hornbill.com/index.php?showtopic=19 Forum thread]) | ||
| + | * [[How to Identify the Database that Holds a Specific Table]] | ||
| + | * [[How to repair all system tables (sw_systemdb)]][http://wikisvr1/wikifiles/Userwiki/FAQs/ESP/Database/SwRepairAll.zip | wiki] | ||
| + | * [[The Root Causes of Database Table Corruption]] | ||
| + | * [[Database Migration using the Database Migration Wizard]] | ||
| + | * [https://www.youtube.com/watch?v=w-L3nGZh1WA Minimum Number of Characters search] | ||
| + | * [[How to add a column to the database using the Database Schema Editor]] | ||
| + | * [[Moving SwSQL Databases to another drive]] | ||
| + | * [[Unable to connect to target database: Call to SQLError Failed]] | ||
| + | * [[Causes of Database table corruption]] | ||
| + | * [[Repairing a Corrupt Index File in ESP 7.x]] | ||
| + | * [[Repairing a Corrupt Table in ESP 8.x]] | ||
| + | * [[ODBC connection to sql server]] | ||
| + | * [[Historical data extract from Old version of supportworks]] | ||
| + | * [[How to remove ticket data from the database]] | ||
| + | * [[MSSQL Sorting or binary data would be truncated]] | ||
| + | * [[Deletion of Calls, Emails and Attachments before a certain date]] | ||
| + | * [[Special characters cause SQL insert/update statements to fail in Mariadb]] | ||
| + | |||
| + | ===Security=== | ||
| + | * [[Security audits reporting potential vulnerabilities in Core Services 3.X]] | ||
| + | * [[Apache Web Server Hardening]] | ||
| + | * [[Setting Up Single Sign-On for the Web Client]] | ||
| + | * [[Setting Up Single Sign-On for SelfService]] | ||
| + | * [[Configuring SSL and Using Your Own Certificate/Key on the Web Server]] | ||
| + | * [[Creating a Self-Signed Certificate]] | ||
| + | * [[IE-11 Not able to connect via Core Services 3.1.4 Apache Server using TLS v1.2]] | ||
| + | |||
| + | ===The Apache Web Server=== | ||
| + | * [[Unable to start SwHTTPServer due to port conflict]] | ||
| + | * [[Unable to start SwHTTPServer following an upgrade to Supportworks 7.6.2]] | ||
| + | * [[Rotate Apache Logs]] | ||
| + | |||
| + | ===Installation=== | ||
| + | * [[System Requirements]] | ||
Revision as of 13:56, 29 April 2020
Database
- Size Comparison of SwSQL with MS SQL
- Increasing the Maximum Size of the Analyst E-Mail Address Field | (Forum thread)
- Adding Extra Filter Columns to the Call-Index Table
- How to Run a Batch Update of All Customer Records for Web Access | (Forum thread)
- Changing the SwSQL Account Password | (Forum thread)
- How to Identify the Database that Holds a Specific Table
- How to repair all system tables (sw_systemdb)| wiki
- The Root Causes of Database Table Corruption
- Database Migration using the Database Migration Wizard
- Minimum Number of Characters search
- How to add a column to the database using the Database Schema Editor
- Moving SwSQL Databases to another drive
- Unable to connect to target database: Call to SQLError Failed
- Causes of Database table corruption
- Repairing a Corrupt Index File in ESP 7.x
- Repairing a Corrupt Table in ESP 8.x
- ODBC connection to sql server
- Historical data extract from Old version of supportworks
- How to remove ticket data from the database
- MSSQL Sorting or binary data would be truncated
- Deletion of Calls, Emails and Attachments before a certain date
- Special characters cause SQL insert/update statements to fail in Mariadb
Security
- Security audits reporting potential vulnerabilities in Core Services 3.X
- Apache Web Server Hardening
- Setting Up Single Sign-On for the Web Client
- Setting Up Single Sign-On for SelfService
- Configuring SSL and Using Your Own Certificate/Key on the Web Server
- Creating a Self-Signed Certificate
- IE-11 Not able to connect via Core Services 3.1.4 Apache Server using TLS v1.2
The Apache Web Server
- Unable to start SwHTTPServer due to port conflict
- Unable to start SwHTTPServer following an upgrade to Supportworks 7.6.2
- Rotate Apache Logs