Anyone want to help me figure out how to set up osticket?

osticketnoob22

osticket was recommended to me. I'm a noon, hence the name here. But I'm not done with it yet.

I have Windows Server 2019 set up.
PHP 8.0.22 The osticket downloaded page said 8.0.x, so I picked 8.0.22 instead of the 8.1 option there. Non-threaded, like the youtube video had. PHPManagerForIIS_V1.5.0

osTicket-v1.17-rc3 I want modern authentication, so I included the modern auth plugin on the download.

I followed this youtube video. How to Install osTicket v1.12 - Windows IIS It's a little out of date, but I was able to follow along up to a point. Even in the video, things don't work for this person. She shows the manual file download, unzip, copy in process, which is good. I did that.

And mysql-installer-web-community-8.0.30.0

That's the video still shown on the osticket install page. https://docs.osticket.com/en/latest/Getting%20Started/Installation.html

So I followed along on the video up to the part where she clicks on the osticket Browser *80. I tried Chrome and Firefox for this in case Chrome has anything with forcing https. I get the same results on both. Mine errors out. Hers worked. I stopped at that point, trying to figure out what went wrong.

In a browser, I'm going here. http://localhost/osticket

I get this 500 error, which I think might be too generic to be useful from googling. HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.

Detailed Error Information: Module IIS Web Core Notification BeginRequest Handler Not yet determined Error Code 0x8007000d Config Error
Config File \?\C:\inetpub\wwwroot\osticket\web.config

When I look in C:\Windows\Temp for the PHP log, I found it.

php-8.0.22_errors.log

That has these two lines. I haven't figured out how to make it error out like this again.

PHP Warning: PHP Startup: Unable to load dynamic library 'php_gd2.dll' (tried: C:\Program Files (x86)\PHP\php-8.0.22-nts-Win32-vs16-x64\ext\php_gd2.dll (The specified module could not be found), C:\Program Files (x86)\PHP\php-8.0.22-nts-Win32-vs16-x64\ext\php_php_gd2.dll.dll (The specified module could not be found)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'php_xmlrpc.dll' (tried: C:\Program Files (x86)\PHP\php-8.0.22-nts-Win32-vs16-x64\ext\php_xmlrpc.dll (The specified module could not be found), C:\Program Files (x86)\PHP\php-8.0.22-nts-Win32-vs16-x64\ext\php_php_xmlrpc.dll.dll (The specified module could not be found)) in Unknown on line 0

I started googling and looked in the PHP/ext folder, for php_gd2.dll and php_xmlrpc.dll. It doesn't look like those are in PHP version 8. Yet, that's what's osticket is programmed in. So maybe the errors aren't from osticket trying to run.

In IIS, I have my server name and account, Sites, Default Web Site, and osticket. On Default Website, the PHP Manager loads and looks like it works fine. That's where I manually told it it was PHP 8 and where the folder is, just like the video did. But on osticket, PHP Manager and the other things in there error out. I don't know if that's a problem. PHP Manager under osticket says "There was an error while performing this operation. Details: (It's blank.) FileName: \?\C:\inetpub\wwwroot\osticket\web.config Error: (It's blank.)

For the PHP error log, I tried remming those out, those .dll files. No change, I think. I even restarted the server.

I found this post, but don't know what to do with the info, if it's true. https://stackoverflow.com/questions/7851011/how-do-i-install-gd-on-my-windows-server-version-of-php "After PHP 8.0, GD extension name changed from php_gd2.dll to php_gd.dll"

And I found this post and tried copying in the php_xmlrpc.dll. Still no change.

https://stackoverflow.com/questions/65556577/enable-xml-rpc-on-xampp https://pecl.php.net/package/xmlrpc https://pecl.php.net/package/xmlrpc/1.0.0RC3/windows

I can't imagine osticket v1.17 was creating using PHP 8 that was in use with 1.16 I think, and that that was missing or had some error with these PHP dll files.

I'm just stuck though. :\

I found the sticky. And the httperr log. Nothing interesting there though. It's all this.
::1%0 58813 ::1%0 80 - - - - - - Timer_ConnectionIdle -

KevinTheJedi

osticketnoob22

#1 1.17.x is an RC; you should not be installing this in production yet. This is strictly for testing.
#2 You can only use PHP 8.0 for now. We hope to add PHP 8.1 support soon.
#3 The “error” you posted is not an error, just a warning so it unrelated.

You really need to find the appropriate error for us to assist. Without out an actual error we are blind as to what the issue can be.

Also, windows is not providing any further builds of PHP for IIS so I'd be weary of using IIS moving forward. For long term support and use you should really use a Linux server.

Cheers.

osticketnoob22

Yep, it's for testing.

It's PHP 8.0.22. That's correct, right? It should work?

Where should I look for errors? The ones I noticed right away were on the localhost/osticket webpage and in the PHP Manager for osticket (listed above), although the default website did work for the PHP manager. The PHP and IIS logs looked essentially empty. osticket 1.17rc3 + PHP 8.0.22 + MySql workbench 8.0.3. I didn't do anything with MySQL except start the software. I thought osticket probably created databases during the initial osticket set up process.

Daedalus01

osticketnoob22

I thought osticket probably created databases during the initial osticket set up process.

It actually does not. You have to create a user and a database and grant the user to have full access to the database.

osticketnoob22

Daedalus01 Good to know.

Off this video.
https://youtu.be/K7T_JjvEamg
I did the MySQL Workbench install, set up root and its password. I was wondering if osticket would work without the database there, but I see she's adding that at about 13min in on the video. So I can wait on that then. I need osticket to come up as a webpage still. Which means what's not working for me isn't a database issue. And then I do have the PHP and IIS log locations, but those were essentially empty.

What about the web config file in inetpub\wwwroot\osticket I swear that changed from what I saw yesterday. It looked like it was one webconfig file when I copied the upload/osticket folder over. But then I assumed IIS must have changed something in it somehow. Can IIS alter that webconfig file? And if something is wrong in that file, the localhost/osticket page won't load then, correct?

I do get a generic IIS page on just localhost in a browser.

osticketnoob22

I've got the wrong version of MySQL Workbench, right?

https://osticket.com/download/
osTicket Core, v1.17-rc3
Released August 05, 2022
Requirements:
HTTP server running Microsoft® IIS or Apache, PHP version 8.0.x, MySQL database version 5.5

But I grabbed mySQL Workbench 8.0 Version 8.0.30 build 2054668 CE (64 bits).

Would osticket be smart enough to know that's the wrong version before it even connects to anything with it? I thinking not. But it an error. I could have multiple errors.

osticketnoob22

osticketnoob22 That's MySQL Workbench for the version. How do I know what MySQL database version that uses?

Even if the database version matches the MySQL Workbench version, there is no version 5.5 here.
https://downloads.mysql.com/archives/workbench/

osticketnoob22

osticketnoob22 Yeah, that looks wrong.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -V
mysql Ver 8.0.30 for Win64 on x86_64 (MySQL Community Server - GPL)

Maybe MySQL Workbench just doesn't have 5.5, but some other MySQL software does.

osticketnoob22

osticketnoob22 Or I don't need "workbench."

https://downloads.mysql.com/archives/community/?version=5.5.41
but 5.5.6.2 is the highest version that's still 5.5.

KevinTheJedi

osticketnoob22

It's MySQL version 5.5 (or above). MySQL 8.0 is fine and recommended.

Cheers.

osticketnoob22

No change with MySQL 5.5, which isn't workbench. But I left workbench 8.0 still installed.

https://www.youtube.com/watch?v=vRf7WiRMHAk
Maybe it's something with this. This guy has the same IIS, Default Web Site, osticket set up on his left column. But he dlicked right into PHP manager under his osticket. I only get a working PHP Manager under default site. When I click into PHP Manager (or anything else) on osticket, I get
PHP Manager
There was an error while performing this operation.
Details: (blank)
Filename:\?\C:\inetpub\wwwroot\osticket\web.config
Error: (blank)

9:30 in, she doesn't click on anything under her ostick except browse *80.
https://www.youtube.com/watch?v=K7T_JjvEamg

osticketnoob22

It's something with IIS and my Default Web Site having everything working but nothing under that. I copied the upload folder to inetpub/wwwroot/ with the other osticket folder and called this osticket2. That's not working the same way in IIS. Starting and stopping the Default Web Site doesn't change anything. Restarting the whole server doesn't change anything. It's like the Default Web Site options or permissions didn't filter down to the osticket folders below.

KevinTheJedi

osticketnoob22

Then you'll have to either review IIS documentation or wait for someone IIS savvy to add their thoughts here.

Cheers.

osticketnoob22

osticketnoob22 In IIS, I tried making a new site under Sites. Although with an osticket3 folder in wwwroot, that shows up under Default Web Site as a folder and I tried to connect to that as a new site.

Daedalus01

osticketnoob22 One thing that I know about sites under IIS is that you have to create bindings to the hostname you want to use as well as DNS Entries. Thats how IIS knows which website the user is trying to access. Don't know if during the Windows install of osTicket that it does it automatically or not. That could be why it doesn't come up.

osticketnoob22

I got something. That was unexpected.
https://social.msdn.microsoft.com/Forums/en-US/7e5a2321-7a2a-4127-ab9b-c2f4c8e023b4/hosting-osticket-on-iis?forum=iis7general

I just renamed the web.config file so it doesn't exist. Refreshed IIS. This time when I clicked the PHP Manager on the osticket folder under Default Web Site and when I click on the *80 link to view it in in a browser.... It worked, I think.

mb84uk

Your 500.19 issue is probably because you haven't installed/enabled URL Rewrite in IIS. If you are using Web Deploy (https://www.iis.net/downloads/microsoft/web-deploy) you can install it from there. There is no configuration, just install and you are done.

osticketnoob22

mb84uk Look up. 🙂

osticketnoob22

F. Making me work for each step.

https://www.youtube.com/watch?v=K7T_JjvEamg
About 10:30 in on the video.

I have the initial osticket set up webpage showing
Gdlib Extension
PHP IMAP Extension -- Required for mail fetching
Intl Extension -- recommended for improved localization
APCu Extension -- (faster performance)
Zend OPcache Extension -- (faster performance)

So I got into the PHP Manager. It looks like Default Web Site also sets the osticket subfolder. Fine. I enabled these.
php_gd.dll
php_imap.dll
php_intl.dll
php_opcache.dll
php_zend_test.dll

Refreshed ISS. Reloaded the webpage. localhost/ostick on a new tab. Close,open the browser. Restarted the server. And then I found another web.config in the wwwroot folder, so I renamed that. That didn't return. But nothing I did got those removed on the osticket initial start up page. Yet that's what the video showed working.

osticketnoob22

osticketnoob22 My wandering last week is paying off. I got all but apcu green on the intial start up page. I had to go into the PHP program folder, edit the php .ini file and enable them. zend_extension=opcache was hanging out in a different spot. apcu she skipped in the video, so I'll pass too.