Help with installation on Windows 2003 Server R2

[mopa]

Hi all,

I have tried to install kayako on the above server and some went ok... some did not.
Issues I had;

• Couldn't change password for root in MySQL without PhpMyAdmin complaining with a #1045 error.
• PhPMyAdmin complained about an mcrypt.dll even though every detail about seemed ok (this was with php 4.4.7 (With PHP 5.2.3 I couldn't get it to work at all)
• When Kayako was up and running I could not import Language or templates. It seemed like the site only did a reload and then nothing happend.

Now I wan't to start all over to be sure everything is set up correct. I am now reinstalling Windows Server 2003 R2.
What I really would like is a guide on how to move on. And I mean every step. It is a little sad, that you are totally left to your self, when you are a novice and don't even have a guide.

Anyway are there anyone here that can help me with what to do and in which steps I need to do them:

ie.
Install server.
Install IIS,
Install PHP,
Install MySQL,
Install MySQL Tools
Install Zend,

And then set all the setting for IIS, PHP, MYSQL etc.
Any help or guide or link to such will be much appreciated

[neilcorke]

Have you tried tried Live Talk with Kayako Technical Support? They even have a category for installation.

I am currently in the process of installing this too, and found them very helpful and responsive.

Good luck!

[mopa]

No - I have now installed it all again but this time with PHP 5.
The only error I got was with PHPMyAdmin, but it was some errors in the php.ini - It is now solved. Everything is up and running but I still can't import languages and templates - I am clueless what is wrong?

(Ps. I will try to make a mini guide of waht I have done to get it all to work - so it might help others - but please be patient... I would like to get it all working before I do so)

[mopa]

1.Install Windows 2003 Server

2. Install IIS

3. Create new folder called “PHP” under C drive.

4. Extract PHP (5.2.3) files to PHP folder (did not use the installer but copied the binary files to this folder)

5. Install MySQL (5.0.41)

6. Install MySQL GUI Tools

7. Remember to move the PHP.ini file from C:\PHP to C:\Windows (If there is no php.ini maybe there is a php.ini-recommended – rename this to php.ini and move it to C:\Windows

8. Install Zend.

9. Go into IIS, go to web extensions, click on “add new web service extension”.

10. Extension name “PHP”, click browse, go to “C:\PHP\php5isapi.dll”, click OK, tick “set extension status to allowed”, click OK.

11. Do the same again but call this one MySQL and select “php_mysql.dll”. (This is because by default MySQL and PHP don’t talk to each other in the latest versions).

12. Right click your website and go to properties, go to “ISAPI filters” tab, click add, Name “PHP” extension “C:\PHP\php5isapi.dll”.

13. Click OK and restart computer and a green arrow should appear next to ISAPI filter to say it’s loaded. After you have restarted the server.

14. Go to IIS Documents, Add “setup.php”.

15. Go to IIS “Home directory”, click on “configuration”, click “Add”, Browse
to “php5isapi.dll” filter, name extension “.php”. Click OK.

16. Right click My Computer, got to Properties, Advanced, Enviroment Variables, Highlight “PATH”, Click Edit, Go to the very end of Variable value and enter in “;C:\PHP”. (Make sure a “;” is before C:\PHP).

17. Create folder called “Kayako” under “C:\Inetpub\wwwroot” for kayako files.

18. Extract “Upload” files from kayako setup to kayako folder you just created under C:\Inetpub\wwwroot.

19. Put license key in kayako folder under “C:\Inetpub\wwwroot\kayako”.

20. Open config folder under kayako and edit config.php file and change hostname to ‘localhost’, username = root, password = (password), DB name = kayako (Which we will create in a minute with MySQL Admin) Save!

21. Select kayako folder under C:\Inetpub\wwwroot and set IUSR_(Computername) to have modify under security in folder properties, then click Apply.

22. Go to C:\Program Files\MySQL\MySQL Server 5 and edit “my.ini” file.
Delete text between sql-mode = “ “ quotation marks.
(This is to allow the mysql connect problem to be resovled).

23. Edit the php.ini file located in \Windows directory – if it still is in C:\PHP then move it to C:\Windows.

Change:
session.save_path = \Temp

session.cookie_path = \

extension_dir = "C:\PHP\ext"

doc_root = "C:\Inetpub\wwwroot"

include_path = ".;c:\PHP\ext"
include_path = ".;c:\PHP"
include_path = ".;c:\php\includes"

Enable: extension=php_mysql.dll

short_open_tag = On

max_execution_time = 600

magic_quotes_gpc = On

...also make sure to remove the ; infront of:
extension=php_mbstring.dll
and
extension=php_mcrypt.dll

24. In MySQL Administrator - log in - go to catalog - right click - create new sheme - call it kayako.

25. Install Kayako by going to your site and hit index.php or /setup/index.php

NOTE: If you have problems uploading languages and templates try to rename your XML-files to something simple like “englishtemp.xml”. I couldn’t upload mine with the default name the files had, when you export them. But there were no problem doing so if I renamed the files to something simple.

This solution is an edited version of Brendan.main’s previous post:
http://forums.kayako.com/showthread....7419#post47419