Print

A working installation of osTicket 1.9.4 or later helpdesk system is required before osTicky 2.2 can be configured. You will need the following data in order to configure osTicky:

osTicky supports both external (a dedicated database) and internal (using Joomla database) locations. Although a dedicated database is the standard and recommended storage solution for osTicket, some hosting providers put limits on the number of databases per account (especially for free accounts). Installing osTicket to the same database where Joomla is installed will not increase the number of databases in use. On the other hand, external database should be accessible from the domain where Joomla (and naturally osTicky) is installed. This is not always as trivial as it seems to be. Many hosting providers do not allow database access from other domains (mostly for free accounts). Even if you set all connection parameters correctly, database access may fail if osTicket is located on another domain. Please, ask your hosting provider if you are having issues. Normally, if you use the same hosting account for both databases everything should work smoothly.

 

When you first install osTicky 2.0 and go to "Components / osTicky2 (osTicket Bridge)" you should see the following messages:

db no settings

Step 1

Click "Options" to open configuration screen. The default settings are:

db details no settings

The value displayed in "Configuration ID" dropdown indicates that osTicky is not configured yet (when you save a correct configuration this dropdown will show the first configuration key available  - "core" for standard osTicket installation). All fields on this screen are required.

External database settings:

The database user must have CRUD (or higher) permissions for osTicket database plus DROP permission for at least one table: `ost_ticket__cdata`. This table plays a role of a temporary table in osTicket and is constantly recreated and dropped (it makes ticket list queries faster). When a new ticket is created via osTicky web interface this table should be dropped so that it can be recreated correctly when an osTicket staff member opens ticket list. If the user configured as a database user in osTicky settings doesn't have this 'DROP' privilege (which is quite normal for security reasons), it is highly recommended to add 'DROP' privilege at table level (<your_osticket_database_name>.ost_ticket__cdata). It will not compromise security (due to the temporary nature of `ost_ticket__cdata` table) but will make osTicky/osTicket integration smoother. Anyway, even if 'DROP TABLE `ost_ticket__cdata`' query fails due to insufficient privileges, the ticket will be created and written to osTicket database. You will see a warning message.

Of course if you access osTicket database as administrator (i.e. configure a root user in database settings) osTicky will have all permissions for osTicket database, but if you are concerned about security it is recommended to create a special db user for use with osTicky with the privileges listed above.

After you fill in all required fields, click save. If the settings were correct you should see the following screen (username, password etc. values will differ) - the screenshot below corresponds to "External" database option:

db details sample

Step 2

Go to the next pane - "osTicket frontend integration"

frontend integration

Default settings for all fields on this pane should work, but you can adjust the following settings:

"List layout" fieldset contains standard Joomla list views settings and should be normally left as suggested by default settings.

Step 3

The "Permissions" pane settings require modifications, otherwise only Super admins will be able to create tickets / respond in ticket thread, which is obviously not the desired behavior. First you should decide if guests (not logged in users) have to be authorised to create tickets. The following screenshot shows a configuration allowing guests to create tickets:

permissions public

"Reply" action has no meaning for not logged in users. A user must have access to a ticket in order to be able to reply, but no tickets are visible until the user logins. This action permission is important for registered users (or any other group considered as a group for logged in frontend users). The screenshot below shows a configuration when "public" group is authorised to create tickets, so the "Create tickets" permission results in "allowed" and is inherited. If you do not allow guests to create tickets you should set both "Creste tickets" and "Reply" permissions to "Allowed" explicitly.

permissions registered

It is also possible to configure permissions so that nobody (except super admins) will be authorised to create tickets, but logged in users will be able to post messages in ticket thread. Although functionally it looks like a really rare case.

Click "save and close". If database connection options were introduced correcly at step 1, the information view should read the following (helpdesk title and helpdesk URL will be different):

db ok

Step 4

Your site visitors will not be able to access osTicky component until you create menu items in Joomla menu manager. Normally two items should be added, one to create a new ticket and the other - to view the user's tickets. If access levels for these menu items are lower than permissions set on step 3, the user will be redirected to login view and after sucsessful authorisation back to the view assigned to menu item.