Debug
## Debugging
- If you are experiencing a problem with ITFlow you may be directed to this page to gather server/app info.
- When creating forum posts / support requests ensure you share the information under Server Info, ITFlow app and Database stats.
- Caution:Â Be careful when sharing the full debug output - it contains your PHP session variables/cookies ("PHPSESSID") which could allow anyone to login to your ITFlow instance
- Note: Sometimes you might need to gather PHP error logs as well
---
### System Information
| | |
|---|---|
|Operating System|Linux *** 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64|
|Web Server|Apache/2.4.62 (Debian) mod_fcgid/2.3.9 OpenSSL/1.1.1w|
|Kernel Version|5.10.0-32-amd64|
|Database Version|10.11.9-MariaDB-deb11|
### PHP Extensions and Configuration
|PHP Extensions| | |
|---|---|---|
|php-mailparse installed||Installed|
|php-imap installed||Installed|
|php-mysqli installed||Installed|
|php-intl installed||Installed|
|php-curl installed||Installed|
|php-mbstring installed||Installed|
|php-gd installed||Installed|
|PHP Configuration| | |
|---|---|---|
|shell_exec is enabled||Enabled|
|upload_max_filesize >= 500M||100M|
|post_max_size >= 500M||100M|
|PHP Memory Limit >= 128M||128M|
|Max Execution Time >= 300 seconds||60 seconds|
|PHP version >= 8.2.0||8.3.13|
|Shell Commands| | |
|---|---|---|
|Command 'whois' available||/usr/bin/whois|
|Command 'dig' available||/usr/bin/dig|
|Command 'git' available||/usr/bin/git|
|SSL Checks| | |
|---|---|---|
|Accessing via HTTPS||Yes|
|SSL Certificate is valid||Valid|
|Domain Checks| | |
|---|---|---|
|Site has a valid FQDN||***.com|
|File Permissions| | |
|---|---|---|
|Web user has write access to webroot directory||/home/***/public_html|
### Database Structure Comparison
| | | |
|---|---|---|
|No discrepancies found between the database and db.sql file.| | |
### Uploads Directory Stats
| | | |
|---|---|---|
|Number of files in uploads directory|9| |
|Total size of uploads directory (MB)|0.01 MB| |
### Database Stats
| | | |
|---|---|---|
|Current Database Version|1.6.5| |
|Total number of tables|99| |
|Total number of fields|957| |
|Total number of rows|39| |
|Total database size (MB)|1.59 MB| |
### Table Stats
|Table Name|Fields / Rows|Size (MB)|
|---|---|---|
|accounts|Fields: 10, Rows: 0|0.02 MB|
|api_keys|Fields: 7, Rows: 0|0.02 MB|
|asset_custom|Fields: 4, Rows: 0|0.02 MB|
|asset_documents|Fields: 2, Rows: 0|0.02 MB|
|asset_files|Fields: 2, Rows: 0|0.02 MB|
|asset_history|Fields: 5, Rows: 0|0.02 MB|
|asset_interfaces|Fields: 14, Rows: 0|0.02 MB|
|assets|Fields: 26, Rows: 0|0.02 MB|
|budget|Fields: 8, Rows: 0|0.02 MB|
|calendars|Fields: 6, Rows: 0|0.02 MB|
|categories|Fields: 9, Rows: 9|0.02 MB|
|certificates|Fields: 14, Rows: 0|0.02 MB|
|client_tags|Fields: 2, Rows: 0|0.02 MB|
|clients|Fields: 16, Rows: 0|0.02 MB|
|companies|Fields: 15, Rows: 0|0.02 MB|
|contact_assets|Fields: 2, Rows: 0|0.02 MB|
|contact_documents|Fields: 2, Rows: 0|0.02 MB|
|contact_files|Fields: 2, Rows: 0|0.02 MB|
|contact_logins|Fields: 2, Rows: 0|0.02 MB|
|contact_tags|Fields: 2, Rows: 0|0.02 MB|
|contacts|Fields: 23, Rows: 0|0.02 MB|
|custom_fields|Fields: 6, Rows: 0|0.02 MB|
|custom_links|Fields: 11, Rows: 0|0.02 MB|
|custom_values|Fields: 3, Rows: 0|0.02 MB|
|document_files|Fields: 2, Rows: 0|0.02 MB|
|documents|Fields: 17, Rows: 0|0.05 MB|
|domains|Fields: 19, Rows: 0|0.02 MB|
|email_queue|Fields: 13, Rows: 0|0.02 MB|
|event_attendees|Fields: 9, Rows: 0|0.02 MB|
|events|Fields: 13, Rows: 0|0.02 MB|
|expenses|Fields: 15, Rows: 0|0.02 MB|
|files|Fields: 17, Rows: 0|0.02 MB|
|folders|Fields: 5, Rows: 0|0.02 MB|
|history|Fields: 7, Rows: 0|0.02 MB|
|invoice_items|Fields: 16, Rows: 0|0.02 MB|
|invoices|Fields: 17, Rows: 0|0.02 MB|
|location_tags|Fields: 2, Rows: 0|0.02 MB|
|locations|Fields: 19, Rows: 0|0.02 MB|
|login_tags|Fields: 2, Rows: 0|0.02 MB|
|logins|Fields: 22, Rows: 0|0.02 MB|
|logs|Fields: 10, Rows: 8|0.02 MB|
|modules|Fields: 3, Rows: 6|0.02 MB|
|networks|Fields: 17, Rows: 0|0.02 MB|
|notifications|Fields: 10, Rows: 0|0.02 MB|
|patch_panel_ports|Fields: 10, Rows: 0|0.03 MB|
|patch_panels|Fields: 13, Rows: 0|0.02 MB|
|payments|Fields: 11, Rows: 0|0.02 MB|
|products|Fields: 10, Rows: 0|0.02 MB|
|project_template_ticket_templates|Fields: 3, Rows: 0|0.02 MB|
|project_templates|Fields: 6, Rows: 0|0.02 MB|
|projects|Fields: 12, Rows: 0|0.02 MB|
|quotes|Fields: 17, Rows: 0|0.02 MB|
|rack_units|Fields: 9, Rows: 0|0.03 MB|
|racks|Fields: 15, Rows: 0|0.02 MB|
|records|Fields: 9, Rows: 0|0.02 MB|
|recurring|Fields: 18, Rows: 0|0.02 MB|
|recurring_expenses|Fields: 19, Rows: 0|0.02 MB|
|remember_tokens|Fields: 4, Rows: 0|0.02 MB|
|revenues|Fields: 13, Rows: 0|0.02 MB|
|scheduled_tickets|Fields: 16, Rows: 0|0.02 MB|
|service_assets|Fields: 2, Rows: 0|0.02 MB|
|service_certificates|Fields: 2, Rows: 0|0.02 MB|
|service_contacts|Fields: 2, Rows: 0|0.02 MB|
|service_documents|Fields: 2, Rows: 0|0.02 MB|
|service_domains|Fields: 2, Rows: 0|0 MB|
|service_logins|Fields: 2, Rows: 0|0.02 MB|
|service_vendors|Fields: 2, Rows: 0|0.02 MB|
|services|Fields: 12, Rows: 0|0.02 MB|
|settings|Fields: 88, Rows: 0|0.02 MB|
|shared_items|Fields: 14, Rows: 0|0.02 MB|
|software|Fields: 19, Rows: 0|0.02 MB|
|software_assets|Fields: 2, Rows: 0|0.02 MB|
|software_contacts|Fields: 2, Rows: 0|0.02 MB|
|software_documents|Fields: 2, Rows: 0|0.02 MB|
|software_files|Fields: 2, Rows: 0|0.02 MB|
|software_logins|Fields: 2, Rows: 0|0.02 MB|
|tags|Fields: 8, Rows: 0|0.02 MB|
|task_templates|Fields: 8, Rows: 0|0.02 MB|
|tasks|Fields: 10, Rows: 0|0.02 MB|
|taxes|Fields: 6, Rows: 0|0.02 MB|
|ticket_attachments|Fields: 6, Rows: 0|0.02 MB|
|ticket_history|Fields: 5, Rows: 0|0.02 MB|
|ticket_replies|Fields: 9, Rows: 0|0.02 MB|
|ticket_statuses|Fields: 4, Rows: 5|0.02 MB|
|ticket_templates|Fields: 8, Rows: 0|0.02 MB|
|ticket_views|Fields: 4, Rows: 0|0.02 MB|
|ticket_watchers|Fields: 4, Rows: 0|0.02 MB|
|tickets|Fields: 30, Rows: 0|0.02 MB|
|transfers|Fields: 8, Rows: 0|0.02 MB|
|trips|Fields: 14, Rows: 0|0.02 MB|
|user_permissions|Fields: 2, Rows: 0|0.02 MB|
|user_role_permissions|Fields: 3, Rows: 9|0.02 MB|
|user_roles|Fields: 8, Rows: 2|0.02 MB|
|user_settings|Fields: 7, Rows: 0|0.02 MB|
|users|Fields: 17, Rows: 0|0.02 MB|
|vendor_documents|Fields: 2, Rows: 0|0.02 MB|
|vendor_files|Fields: 2, Rows: 0|0.02 MB|
|vendor_logins|Fields: 2, Rows: 0|0.02 MB|
|vendors|Fields: 20, Rows: 0|0.02 MB|