osticket, realms, php, mysql, and tech related blog

So you wrote a mod or a plugin and want to add some configuration options directly to into the osTicket Admin panel. This is a short tutorial on how to add a setting to osTicket 1.8.1.2, and then have your mod (or plugin) check that setting.

First off realize that modding osTicket can result in the breaking of your site, and you should really perform a backup of both the site and your database prior to making changes.

One of the [I feel] less documented features of osTicket is the ticket API.  This API has been built into osTicket for quite some time and allows you to write your own html forms and push the data to osTicket to open tickets.  This means that you could write a contact block for your web page and have it submit to osTicket directly, or if you have another piece of software that can run a script you can write your own custom script to open tickets from that software.  Example a network monitoring system (like NOCOL/SNIPS) could open a tick

There has been a lot of talk recently about some of the new features and the direction that osTicket is heading in. In the past I've mentioned that osTicket will have individual user accounts for clients. Today I get to share a little more about this coming feature! Jared (aka greezybacon) posted the following commit notes over on github a short time ago:

Now that Spring is here it's time to try to sell my motorcycle again. I'm not aware of this bike having any issues at all. It was registered (2014) and inspected (2013), and currently being stored in my garage. I started her up and took for a short spin today. If you are interested in buying her you know how to contact me!

I'm not sure why anyone would WANT to do this, but on the off chance someone thinks that they need to and wants to try it here is how you can manually add or update an existing client/user phone number in osTicket at the SQL level.

• First Look up user id in ost_user

SELECT id FROM ost_user where name='THE NAME';lets pretend it returns '15'.

Over on github at the osTicket-1.8 project this a new v1.8.1.2 tag was added.  This tag means that version 1.8.1.2 will be released shortly.  Here are the release notes:

As of a few days ago you can now download 1.8.1.1 from the osticket.com/downloads page.

Here is a list of the enhancements, bug fixes, and Security updates:

I have been running a Debian server here at work for a several years now mostly as a web server, but also as a way for me to have quick access to some of the old cli tools like whois, dig, etc.  While running updates I ran across this error:

Fetched 199 B in 1s (122 B/s)
Reading package lists... Done
W: GPG error: http://debian.opennms.org stable Release: The following signatures couldn't be 
verified because the public key is not available: NO_PUBKEY 57801F6F5B9EFD43