Good afternoon all,
I’ve just completed migrating my site from Drupal to WordPress. and it seems that resulted in a loss of all images, and some of the posts and fonts didnt transfer well either. While I plan to go back through and remove bad formatting I doubt that I will take the time to re-cover the images, but chances are most of them were really old and no longer needed. New posts going forward will of course have new images. 🙂
MySQL 8 was released recently (to this writing) and of course that means people are going to start using it. Since I have seen a couple posts on the forums with people using MySQL 8 I decided to fire up a new VM and install the following:
- OS: Windows 2012 R2
- Webserver: IIS 8
- MySQL 8.0.12
- PHP 5.6.31
note: PHP 5.6 is still the recommended version of PHP for osTicket until 1.11 is released. You should not have this problem if you are running PHP 7.1.16+ or PHP 7.2.4+ but since osTicket does not support those versions yet.
After checking to make sure that: IIS was serving pages and PHP was working in IIS it was time to download and install osTicket. The new website downloader is neat and allows you to download a languages and plugins together which can be a time saver. As a reminder always install osTicket with out any language packs and then add your desired language packs.
Running the installer resulted in the following error:
Database Connection information `Unabled to connect to MySQL Server: Server sent charset unknown to the client.` Please report to the devs
To fix this you will need to locate and edit your MySQL configuration file (my.cnf or my.ini). Since this is a new MySQL 8 installation under windows it is at: C:\ProgramData\MySQL\MySQL Server 8.0\my.ini. Once you located the file locate # character-set-server=. Directly after it add the line:
Next you will need to restart MySQL. You might be able to do this with MySQL WorkBench or services.msc. My server had some patches that installed so I just restarted the server for the patches to finish.
Running the installer again of course resulted in another error message:
Database connection information `Unable to connect to MySQL Server: The server requested authentication method unknown to the client`
Starting with MySQL 8.0.4, the default authentication plugin for MySQL server was changed from mysql_native_password to caching_sha2_password. There are two things that you need to do in MySQL to fix this. First: if you are running an older version of PHP (pre 7.1.16) you will need to set default_authentication_plugin=mysql_native_password in my.cnf. Restart the server.
Next you will need to edit the user account. I could not do this in the most recent version of MySQL WorkBench using the ui. You can do this one of two ways:
1. delete and recreate the user. Make sure authentication is set to ‘Standard’. Make sure you give the same permissions back that the user had.
2. run the following SQL Query (edit this for your user)
alter user 'username'@'localhost' identified with mysql_native_password by 'password';
After doing this the installer ran fine.
You may have noticed that the content on this site has some underlined words. These are not spyware/spamware/virus, etc. It's actually a product called Infolinks. Infolinks is a way that some sites try to monetize their sites.
If you would like more information on Infolinks or want to add it to your site here is my referral URL:
This past Wednesday the devs over at the osTicket forums updated their forum software.
The new forum software is pretty similar to the old but there are no more categories. The site uses tags to determine how posts are organized. You can add tags to your post when you create it.
Unfortunately they could not transfer your passwords. Please use the lost password link to get the site to send you a password reset link to get in.