Skip to content

erivera3/osticket-prereqs

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 

Repository files navigation

osTicket logo

osTicket Deployment in Azure (Multi-Service Application Troubleshooting)

This project focuses on deploying a working web application in Azure while resolving failures across multiple system layers (IIS, PHP, MySQL).

The objective was not just deployment, but restoring functionality when dependencies failed.


📌 Context

A Windows-based environment was deployed in Azure to host osTicket. The system required coordination between:

  • IIS (web server)
  • PHP (application processing)
  • MySQL (database backend)

Failure in any layer prevented the application from working.


🧰 Technologies Used

  • Microsoft Azure (Virtual Machines)
  • Windows 10
  • Remote Desktop Protocol (RDP)
  • Internet Information Services (IIS)
  • PHP
  • MySQL
  • HeidiSQL
  • osTicket

💻 Environment

  • Windows 10 Virtual Machine (osticket-vm)
  • IIS with CGI enabled
  • PHP installed in C:\PHP
  • MySQL database
  • osTicket deployed in C:\inetpub\wwwroot\osTicket

⚙️ Implementation

1. Infrastructure Setup

Problem:
No working environment to host application.

Decision:
Deploy Windows VM in Azure and establish remote access.

Result:

  • Functional system accessible via RDP
  • Base environment ready for service configuration


2. PHP Execution Failure (Critical Blocker)

Problem:
IIS could not process PHP files, blocking application execution.

Root Cause:
PHP was installed but not registered with IIS.

Decision:
Manually configure FastCGI and link php-cgi.exe.

Result:

  • PHP execution restored
  • Web server able to process application requests

PHP Not Registered

PHP Registered

3. Database Dependency Setup

Problem:
Application required database backend to function.

Decision:
Install MySQL and manually create database using HeidiSQL.

Result:

  • Database created and accessible
  • Tables successfully generated during installation


4. Application Deployment

Problem:
Application not yet integrated into web environment.

Decision:
Deploy osTicket into IIS web root and complete installation via browser.

Result:

  • Application successfully installed
  • Web interface accessible


5. System Validation

Problem:
Need to confirm system functionality across all layers.

Decision:
Test authentication and simulate ticket workflow.

Result:

  • Admin access verified
  • Ticket creation and handling confirmed
  • Full application functionality validated


🔍 Key Failures & Resolutions

PHP Not Executing

  • Cause: Missing FastCGI configuration
  • Fix: Manual registration of PHP with IIS

Missing PHP Dependencies

  • Cause: Required extensions disabled
  • Fix: Enabled extensions required by osTicket

Database Not Configured

  • Cause: No backend defined
  • Fix: Created MySQL database and connected application

🧠 Decisions That Mattered

  • Chose IIS to align with Windows-based environments
  • Configured PHP manually to understand integration points
  • Validated each dependency before proceeding
  • Used direct database access (HeidiSQL) for verification

🛡️ System Understanding

  • Application stability depends on all service layers functioning correctly
  • Failures often occur at integration points, not installation
  • Troubleshooting requires isolating each layer independently

📌 Key Lessons

  • Most failures are configuration issues, not missing software
  • Dependency validation must happen before deployment
  • Fixing one layer does not guarantee full system functionality
  • Multi-service environments require step-by-step isolation

Summary

This project demonstrates the ability to diagnose and resolve failures across a multi-layer application stack.

Instead of following a linear installation, this required:

  • Identifying where execution failed (IIS vs PHP vs MySQL)
  • Restoring functionality at each layer
  • Validating full system behavior after integration

Result:
A working application environment built by resolving dependency failures, not just completing installation steps.

About

Azure lab installing and configuring osTicket with IIS, PHP, MySQL, and Windows 10.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors