Page 1 of 1

Installation issue when connecting database.

Posted: Thu Apr 26, 2007 2:06 pm
by stsomeware
Script URL: http://www.mybluecomet.com/support
Version of script: .94
Hosting company: myself
URL of phpinfo.php: http://www.mybluecomet.com/support/phpinfo.php
URL of session_test.php: http://www.mybluecomet.com/support/session_test.php
What terms did you try when SEARCHING for a solution: install, database

Write your message below:

I am having a problem installing the new version of Hesk. I get though the first 2 screens of the install script, but when I try to connect to the database, I get a blank screen. I believe that it's hitting the database because if I put in an invalid password, it tells me that it failed to connect to the database. If I put in a correct password, then I get a blank screen. I have other PHP scripts running on this same server connecting to mySQL databases, so I am confused as to why I am having issues. Any help would be greatly appreciated.

Rich

Posted: Thu Apr 26, 2007 5:04 pm
by Klemen
Hi,

Check your hesk files if any error_log files have been created in either your "support" folder or inside the "install" folder - if so, open them in Notepad and see what they say inside.

Are you sure the username/password combination has rights to access the database (not just that it exists, but has access to the database)?

Also try editing file "hesk_settings.inc.php" manually and set

Code: Select all

$hesk_settings['debug_mode']="0";
to

Code: Select all

$hesk_settings['debug_mode']="1";
and see if you get any error codes then.

Come back with results.

Posted: Thu Apr 26, 2007 8:15 pm
by Klemen
Also try this:

Upload this file to the hesk folder and open it in browser. What message do you get?
http://www.phpjunkyard.com/extras/windows_writable.zip

Posted: Fri Apr 27, 2007 1:48 am
by stsomeware
Thanks for your help. After changing to debug mode, I was able to see errors instead of a blank page, even though it still didn't give me enough info to fix the issue. It wasn't until you asked me to upload the windows_writable.php did I see where you were going with this and you were correct. I didn't have write permissions granted to the hesk_settings.inc.php. Once I gave iusr permissions to write to that file, everything fell back into place and the script installed as designed. I hope this will help some other people that have this same issue. I was completely baffled. Everything looked fine on page 2 of the install, even though iusr didn't have permissions in IIS.

Thanks for a great looking script and prompt support.

Rich

Posted: Fri Apr 27, 2007 10:16 am
by Klemen
Yep, I did some research yesterday and found out that there's a IIS/PHP bug where IIS returns file as writable when in fact it's not (using PHP's is_writable() function). Will update the install file with this better writable function check.