Difference between revisions of "CORE:Frequently Asked Questions"
Jump to navigation
Jump to search
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{DISPLAYTITLE:Frequently Asked Questions}} | {{DISPLAYTITLE:Frequently Asked Questions}} | ||
| + | |||
| + | |||
===Database=== | ===Database=== | ||
* [[Size Comparison of SwSQL with MS SQL ]] | * [[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]) | * [[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]] | * [[Adding Extra Filter Columns to the Call-Index Table]] | ||
| Line 16: | Line 17: | ||
* [[Unable to connect to target database: Call to SQLError Failed]] | * [[Unable to connect to target database: Call to SQLError Failed]] | ||
* [[Causes of Database table corruption]] | * [[Causes of Database table corruption]] | ||
| − | * [[Repairing a Corrupt Index File]] | + | * [[Repairing a Corrupt Index File in ESP 7.x]] |
| + | * [[Repairing a Corrupt Table in ESP 8.x]] | ||
* [[ODBC connection to sql server]] | * [[ODBC connection to sql server]] | ||
* [[Historical data extract from Old version of supportworks]] | * [[Historical data extract from Old version of supportworks]] | ||
| Line 30: | Line 32: | ||
* [[Setting Up Single Sign-On for SelfService]] | * [[Setting Up Single Sign-On for SelfService]] | ||
* [[Configuring SSL and Using Your Own Certificate/Key on the Web Server]] | * [[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=== | ===The Apache Web Server=== | ||
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