The attached screen shot shows the error when attempting to do any operation on an open ticket.More details:- There are no MySQL database errorsSystem log:Log TitleLog TypeLog DateIP Address Invalid CSRF Token __CSRFToken__Warning 02/10/2017 11 AM50.39.100.64 osTicket installed!Debug 02/09/2017 01 PM50.39.100.64Install details:About this osTicket InstallationServer InformationosTicket Versionv1.10 (901e5ea) — Up to dateWeb Server SoftwareApache/2.4.10 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4MySQL Version5.6.35PHP Version5.4.36PHP ExtensionsgdlibUsed for image manipulation and PDF printingimapUsed for email fetchingxmlXML APIxml-domUsed for HTML email processingjsonImproves performance creating and processing JSONmbstringHighly recommended for non western european language contentpharHighly recommended for plugins and language packsintlHighly recommended for non western european language contentfileinfoUsed to detect file types for uploadsAPCuImproves overall performanceZend OpcacheImproves overall performancePHP Settingscgi.fix_pathinfo"1" is recommended if AJAX is not workingdate.timezoneUTCDatabase Information and UsageSchemabobg_ostic696 (localhost)Schema Signature98ad7d550c26ac44340350912296e673Space Used0.30 MiBSpace for Attachments0.01 MiBTimezoneEST (Interpreted as America/New_York)Installed Language PacksEnglish - US (English) —en_US — include/i18n/en_US        

osticket issue 1-1 crop.jpg

osticket issue 1 crop.jpg

Are you saying that your agents are getting logged out when they post a reply?If so please see:http://forum.osticket.com/d/discussion//resolved-logged-out-when-submitting-ticket-updates

I am still seeing the same issues;  Is there specific confuration required to solved these issues described below?:We upgraded our server PHP to:Server InformationosTicket Versionv1.10 (901e5ea) —  Up to dateWeb Server SoftwareApache/2.4.25 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4MySQL Version5.6.35PHP Version5.6.30I am still seeing fundamental ticket operation issues:In admin panel with an open ticket:- cannot delete the ticketWhen changing ticket state from open to resolve get errors: " unable to lock the ticket"Ticket setting and options, Lock Semantics set to disabled,attempt to change ticket state get errors: "This operation requires a lock."

For clarification, the system is NOT getting logged out.  It just just generates lock errors when attempting to do operations on the database records

You would have to check your logs and see if there is an error some where which indicates why it cannot lock the ticket. (Mysql, PHP, webserver)

As stated above, there a NO SQL errors: see log:At this stage,  If using your application requires me to spend so much time to DEBUG why a basic installation of OSTICKET is not working is completely unacceptable and a complete waste of my valuable time.Unlike OSTicket, There are probably other ticket solutions available that most likely work after an install.The system will now check the “bobg_ostic696” database.

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

status: OK

Check Complete

You told us that you were having a CSRF token error in the osT syslog.A CSRF token is a value inserted into a form.  The server expects the token back when that form is submitted.  If the token is not returns or does not match then there is a security issue.  Why are you getting that?  No idea other than the generic that your token doesn't match the one that the server sent you. If you are running SELinux or mod_security or something like that I would investigate those first.  You might also want to make sure that the time/timezone is correct in all places: server, MySQL, PHP, and osTicket.As stated above "You would have to check your logs and see if there is an error some where which indicates why it cannot lock the ticket. (Mysql, PHP, webserver)"I asked you to look at three different logs and you tell me there are no SQL errors and show us a DB table check.  None of that is the SQL logs, the Apache logs, or the PHP error logs. I can tell you that 1000s of people have installed osTicket and not had the issues that you are saying you have.>In admin panel with an open ticket:- cannot delete the ticketDoes your account have permissions to delete tickets?> When changing ticket state from open to resolve get errors: " unable to lock the ticket"> Ticket setting and options, Lock Semantics set to disabled,> attempt to change ticket state get errors: "This operation requires a lock."Aren't sure. I don't know anyone that has this disabled. Does re-enabling make the error go away? (say by setting it to "Lock on activity").  You may have discovered a bug.  I've asked the devs to take a look at this thread to see if they have any additional insight to the issues that you are having.

Write a Reply...