CORE:Frequently Asked Questions: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (9 intermediate revisions by 3 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 22: | Line 24: | ||
* [[MSSQL Sorting or binary data would be truncated]] | * [[MSSQL Sorting or binary data would be truncated]] | ||
* [[Deletion of Calls, Emails and Attachments before a certain date]] | * [[Deletion of Calls, Emails and Attachments before a certain date]] | ||
* [[Special characters cause SQL insert/update statements to fail in Mariadb]] | |||
===Security=== | ===Security=== | ||
| Line 29: | 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]] | |||
* [[Creating a Self-Signed Certificate CS 7.x]] | |||
* [[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=== | ||
Latest revision as of 07:34, 31 May 2023
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
- Creating a Self-Signed Certificate CS 7.x
- 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