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

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.

osticketnoob22

Nice. I made it through the rest of the video. I've got a normal enough looking osticket page logged in.
https://www.youtube.com/watch?v=K7T_JjvEamg

osticketnoob22

osticketnoob22 The video doesn't mention it at the end. I do see this in my new osticket on the main page. There's a reminder to delete the setup folder in the osticket folder in wwwroot.

osticketnoob22

osticketnoob22 Also has a banner note to remove write access to ost-config.php in the osticket/include folder. So I did that under the usual Windows security permissions, from full, removed write which also removed modify I think. No more banner alerts on the next log in.

osticketnoob22

Looks good. Mission accomplished. The next step is seeing if it will actually do what I'd like it to do.

osticketnoob22

Close. MySQL is still the wrong version.
MySQL Version 8.0.30
but I'm supposed to have 5.5. How do I actually get version 5.5?

ramrajone

osticketnoob22
see Kevin's response, 8.0 is fine, but if you want to download other version you can get from : https://downloads.mysql.com/archives/community/

KevinTheJedi
15 hours agoJoined Sep 17, 2015
2 days ago
osticketnoob22

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

Cheers.