Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Installing osTicket to my web server

Hi!

I have downloaded and installed latest osticket version on my web server as instructed in the online installation guide (http://www.osticket.com/wiki/Installation).

After installing it I ran the setup in my browser (Internet Explorer 8.0), there, osticket showed me an error message that "Minimum requirements are not met" viz. "MySQL 4.4 or later is missing".

But I am using MySQL 5 on my web server still osticket is not detecting it.

Plz. suggest how to rectify this error...

thanx

Comments

  • As I see that you are using 1.7 RC2 I've moved your thread to the appropriate forum (from version 1.6 -> Troubleshooting to version 1.7 -> Installation and Setup Help). You also may want to pick up RC3 since it contains many bug fixes and several new features.

    That page is checking the loaded PHP modules and not finding the required module that lets PHP talk to MySQL. Since you haven't told us what OS your running I'm not entirely sure how to tell you how to fix your problem. So I'll cover both.

    Linux
    The easiest way would be to install the php5-mysql package, while you are at it if you are planning on running IMAP or POP you should also install the php5-imap package. [note: even if you are running POP you need to do this.] This is the command that I would use on my Debian server.

    apt-get install php5-mysql php5-imap


    Windows
    Simply locate your php.ini and enable the two extensions. (Note: you may need to go to the PHP webpage and download the extensions, it's been a long time since I have setup PHP on a new server and cannot remember for sure). You should find and uncomment (or add) the following in your php.ini:

    [PHP_IMAP]
    extension=php_imap.dll
    [PHP_MYSQL]
    extension=php_mysql.dll


    Enjoy.
  • I am using Windows server 2003.
  • Also

    1. I followed the method you elaborated in your reply for Windows installation, but still it's showing the same "missing error" on screen as I attached in my question.

    2. I wanna add to my question that is it necessary to have Apache server to run osticket ? I am using IIS on Windows server 2003.
  • shiv.kumar;29731 said:
    Also

    1. I followed the method you elaborated in your reply for Windows installation, but still it's showing the same "missing error" on screen as I attached in my question.

    2. I wanna add to my question that is it necessary to have Apache server to run osticket ? I am using IIS on Windows server 2003.
    I am having your exact same issue and I have already uncommented out those same 2 entries in the PHP.ini file. I am using Windows 2008 but that is the only difference.

    The screen also shows that gdlib and php imap extensions are not enabled, but both of those were uncommented out as well. Server reboot was already done as well.

    Options?
  • How to debug missing modules

    To find out for sure if the modules are getting loaded - do the following.

    1. Create a file info.php in the root osTicket directory, with the following content.

    <?php
    echo phpinfo();
    ?>


    2. Visit yourdomain.com/dir/info.php
    * Check for the missing modules
    * Make sure the correct php.ini is being edited/loaded.

    Please note that the web server (web service) need to be restarted for any php.ini changes to take effect.
  • peter;29762 said:
    To find out for sure if the modules are getting loaded - do the following.

    1. Create a file info.php in the root osTicket directory, with the following content.

    <?php
    echo phpinfo();
    ?>


    2. Visit yourdomain.com/dir/info.php
    * Check for the missing modules
    * Make sure the correct php.ini is being edited/loaded.

    Please note that the web server (web service) need to be restarted for any php.ini changes to take effect.
    I did this test and it worked just fine. It loaded a very long PHP version webpage with a great deal of info and, yes, the .ini file that I've been editing this entire time is the one that was referenced. 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.

    Of course the PHP modules are optional - the big thing stopping this for me is I am being told there is no MySQL installed despite the fact that 5.5 is loaded on this box.
  • @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.
  • peter;29767 said:
    @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 - @ntozier 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
  • 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)
  • peter;29785 said:
    We don't have a step by step instructions on setting up your server - @ntozier 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
    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.
  • peter;29790 said:
    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.
  • gaddyd17;29763 said:
    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

    It's also important to note that you must restart IIS after you make PHP configuration changes.
  • ntozier;29793 said:
    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

    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.
  • gaddyd17;29817 said:
    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::process() 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::hash() 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::randCode() 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::randNumber() 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.
Sign In or Register to comment.