hi,
i spnt long time facing problems with instalation the main reason is i am not familier with php and the sitting of php (php.ini) and how to configure iis to work with php i think mysql is strait forward and with GUI tools you can easily configure the database and user account.
so installation document should include details about php instalation and sittings in php.ini
like required extintions that should be enabled
imap, crypt , mysql.dll and ...
here are som of the steps that i follow during instalation i note them down for referance i hop it will give you idea about instalation problems
(( sorry about my typo..:)))
========================================================
========================================================
1- dont use php installer use zip php back
2- in php.ini specify the DLL files directory
extension_dir = "c:\PHP\ext"
- install FastCGI for iis6 from www.iis.net(www.iis.net) and run the setup file
it will install fcgiext.dll fcgiconfig.js and fcgiext.ini in
C:\WINDOWS\system32\inetsrv
also it will configure iis Web Service Extension to include FastCGI Handler
5- open file fcgiext.ini and add the following at the end of the file
============
php=PHP
ExePath=C:\PHP\php-cgi.exe
============
reade the insturctions in fcgiext.ini for more details
6- you have to configure the web site to include the php extention in
Home Directory then Configure then add extintion .php
executable C:\WINDOWS\system32\inetsrv\fcgiext.dll
GET,HEAD,POST and all checks are there
restart the iisadmin service to maek sure every thing is fine
7- add index.php to documents in web site configurations
8- test php by running page contain <?php phpinfo(); ?>
9- install mysql server and use mysqladministrator to configure new database
9- upload the osticket files to web server and start the instalation
10- the problem with php enable mysql modules in php.ini file
-- stop and start everything from beginig again
- after unzip the php setup there wer php.ini-dest and php.ini-recommended i reaname php.ini-recommended to php.ini
- make sure
short_open_tag = On
in php.ini restart iis after change
- after filling instalation for wite page came this is the problem of mysql connection should enable mysql extinsions in php.ini
- make shure the extinsions directory configured in php.ini file in our case
extension_dir = ".\ext"
-configure the sittings.php file located in inclued directory to be read and write so the installation sittings will be stored there
after instalation you will be requisted to remove write permition from this folder.
- i did not face the problems of admin.php login as last time so i want to check php.ini_Old and php.ini_New
i only enabled mysql extinsions in php.ini and the connection to database is fine
- the final but not last problem is when you change email sitting it give you internal error ...
solution is to turn off mysql strict mode as follwo
comment the line and remove STRICT_TRANS_TABLES
# Set the SQL mode to strict
# sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" //stop strict mode
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
now problem with email fitch
- enable imap extinsion to
extension=php_imap.dll
- enable mycryp extinsion
extension=php_mcrypt.dll
========================================================