@goddyd17 - Installing MySQL on the server doesn't mean PHP knows about it. If MySQL module is not showing up on the phpinfo output then it's not loaded.

Well can you provide the specific steps needed to tell PHP about MySql if that is what it takes for your installer to know about MySql (to allow me to proceed with the OSTicket install)?

We don't have a step by step instructions on setting up your server - @[deleted] reply covers the basics - I'll just add that make sure the extensions/modules actually exists in extension_dir.

extension_dir="c:\php\ext" ; or whatever yours is

extension=php_mysql.dll

extension=php_mysqli.dll

extension=php_pdo_mysql.dll

https://www.google.com/webhp?hl=en&q=iis+php+mysql+configuration(https://www.google.com/webhp?hl=en&q=iis+php+mysql+configuration)

As a secondary note: You asked if Apache was required. It is not. I actually run two OSTicket implementations under Windows Server 2007 running IIS.

I trust that you configured IIS? You do have to tell IIS to use PHP. If you google for something similar to "configure IIS with PHP" you should find many articles on how (and you can customize the search string with your server and IIS version)

We don't have a step by step instructions on setting up your server - @[deleted] reply covers the basics - I'll just add that make sure the extensions/modules actually exists in extension_dir.

https://www.google.com/webhp?hl=en&q=iis+php+mysql+configuration(https://www.google.com/webhp?hl=en&q=iis+php+mysql+configuration)

Every one of those are in the .ini file and uncommented. And yes - PHP was setup previously for IIS. Still though - your installer says PHP is installed fine but it doesn't recognize MySQL such that I can proceed with the install.

Ideas?

Get help from your system admin. or your host on how to configure PHP & MySQL correctly in your server environment.

Get help from your system admin. or your host on how to configure PHP & MySQL correctly in your server environment.

I am the system admin - MySQL is installed. I can run commands against it just fine and create test databases, etc. PHP is installed and the TEST.PHP file you had me create opened just fine. PHP.ini is configured for MySQL and IIS is configured for PHP.

All that said, your installer doesn't recognize MySQL but does recognize PHP. Can you actually offer any real help on that issue? If not, I have no way to actually install this application to test it in my environment.

The installer doesn't recognize MYSQL module/extension because it's not loaded. PHP info (see my previous reply) should have conclusively confirmed it for you. Nothing we can do on osTicket end, if PHP doesn't have MySQL support.

What you need to do is try to figure out why MySQL extension is not loading - see prior replies.

That said, I don't know after looking over the page a couple of times how to tell if the missing modules are included or not.

You should see a mysql or mysqli section on the resulting page.

I highly recommend iis.net's write up on how to configure php for MySQL.

They also mention enabling the dll's. But instead of php_mysql.dll they specifically say php_mysqli.dll and several others (see below).

extension=php_mysqli.dll

extension=php_mbstring.dll

extension=php_mcrypt.dll

You can find the how to at:

SOURCE: http://www.iis.net/learn/application-frameworks/install-and-configure-php-on-iis/install-and-configure-mysql-for-php-applications-on-iis-7-and-above(http://www.iis.net/learn/application-frameworks/install-and-configure-php-on-iis/install-and-configure-mysql-for-php-applications-on-iis-7-and-above)

It's also important to note that you must restart IIS after you make PHP configuration changes.

You should see a mysql or mysqli section on the resulting page.

I highly recommend iis.net's write up on how to configure php for MySQL.

They also mention enabling the dll's. But instead of php_mysql.dll they specifically say php_mysqli.dll and several others (see below).

extension=php_mysqli.dll

extension=php_mbstring.dll

extension=php_mcrypt.dll

You can find the how to at:

SOURCE: http://www.iis.net/learn/application-frameworks/install-and-configure-php-on-iis/install-and-configure-mysql-for-php-applications-on-iis-7-and-above(http://www.iis.net/learn/application-frameworks/install-and-configure-php-on-iis/install-and-configure-mysql-for-php-applications-on-iis-7-and-above)

It's also important to note that you must restart IIS after you make PHP configuration changes.

I see a mysqlnd entry, but not the mysql or mysqli in the test.php results. I will go through the IIS.net link you gave me with a fine tooth comb and see if something is missing. Not sure at this point.

I see a mysqlnd entry, but not the mysql or mysqli in the test.php results. I will go through the IIS.net link you gave me with a fine tooth comb and see if something is missing. Not sure at this point.

I figured out the issue - the extensions had to be in the root of the PHP folder. I thought them being in the ext folder was sufficient.

Proceeded with the install and the following came up - is this an issue?

Strict Standards: Non-static method Validator:() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\osTicket\setup\inc\class.installer.php on line 63

Strict Standards: Non-static method Passwd:() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\osTicket\setup\inc\class.installer.php on line 125

Strict Standards: Non-static method Misc:() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\osTicket\setup\inc\class.installer.php on line 155

Strict Standards: Non-static method Misc:() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\osTicket\setup\inc\class.installer.php on line 175

Below that it says congratulations that the install completed but to change permissions of the ost-config.php file (which I will do) but I didn't know about the other stuff above.

7 years later

Hello,
I have installed OsTicket on centos 7, but i unable to complete the installation due to one error. Kindly help.
Error is : MySQLi extensi
on for PHP — missing!

    somaningp
    This thread is from 2012.
    Please do not be a necromancer.
    Please start your own thread.
    Please upgrade to the required PHP 5.6+.
    It appeas that your version of PHP does not have the mysqli extension enabled. You will have to do that in your php.ini.
    Killing zombie thread with a head shot.

    Write a Reply...