Classroom bookings install help.

[profit10]

Hi,

 

I'm trying to install ClassRoomBookings on a Virtual Server 2012 running IIS with the latest PHP and mySQL installed and have ran into a problem.

 

I have followed the online documentation as is but when I goto localhost/classroombookings it doesn't work. I originally was getting a 404 error and made the change to $config['uri_protocol'] = 'PATH_INFO'; as seen in another post. I no longer get the 404 but am now getting a 500 Internal server error.

 

If anyone can help with this that would be great,

 

Thanks.

[webman]

Hi profit10

 

Enabling logging in the application might help identify where the problem is. Can you open the config.php file again, and change log_threshold to 4. Then, access the application again. A log file should be generated in system/logs, with the day's date on it. Opening that might have something obvious in, otherwise post some lines that have errors/warnings and I'll try to help

[profit10]

Hi,

 

Thanks for the reply.

 

I have changed the log_threshold to 4 but I'm not seeing any log files created and there are no lines with errors/warnings.

 

Here is my config.php:

 

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

 

// Full URL to your installation

$config['base_url'] = 'http://localhost/classroombookings/';

 

 

// Empty string if using .htaccess mod_rewrite

#$config['index_page'] = 'index.php';

$config['index_page'] = 'index.php';

 

// You shouldn't need to change any of these.

$config['layout'] = 'layout';

$config['language'] = 'english';

$config['uri_protocol'] = 'PATH_INFO';

$config['url_suffix'] = '';

$config['enable_query_strings'] = FALSE;

$config['controller_trigger'] = 'c';

$config['function_trigger'] = 'm';

$config['time_reference'] = 'local';

$config['log_threshold'] = 4;

$config['log_path'] = '';

$config['log_date_format'] = 'Y-m-d H:i:s';

$config['cache_path'] = '';

$config['encryption_key'] = '';

$config['sess_cookie_name'] = 'ci_session';

$config['sess_expiration'] = 7200;

$config['sess_encrypt_cookie'] = FALSE;

$config['sess_use_database'] = FALSE;

$config['sess_table_name'] = '';

$config['sess_match_ip'] = TRUE;

$config['sess_match_useragent'] = TRUE;

$config['cookie_prefix'] = '';

$config['cookie_domain'] = '';

$config['cookie_path'] = '/';

$config['global_xss_filtering'] = TRUE;

$config['enable_hooks'] = False;

$config['permitted_uri_chars'] = 'a-z 0-9~%.:_-';

$config['compress_output'] = FALSE;

$config['subclass_prefix'] = 'MY_';

$config['rewrite_short_tags'] = FALSE;

 

?>

[profit10]

Can anyone help at all?

[J_Parton]

can anyone explain how to deploy via IIS, keep getting errors

[webman]

Hi J_Parton! Can you respond to the following questions?

 

Are you using the latest version of classroombookings from the website?

What version of PHP are you using?

Does PHP work on your server?

What errors do you keep getting?

 

IIS is not officially supported but I'll do my best to try and help or advise where I can.

 

 

Thanks!

[J_Parton]

Hi Webman,

 

Yes

V7.0

Not sure how I would test that, server 2012r2

error 403.14 bus since installing php its error 500 fast cgi module

 

 

Thanks,

[webman]

OK, great!

 

To test PHP is working, create a plain text file called test.php with this contents:

 

 

and place it in the document root, or any web-accessible folder. Then visit this page in a browser - e.g. http://192.168.1.1/test.php. It should show a page detailing the PHP settings if it is set up and working. If not, you will still get an error and that means PHP isn't working.

 

Next steps are to check the web server error logs for any clues. I don't know where these will be - but I think IIS has a settings/properties screen that lets you configure the location, which should tell you where they are.

[J_Parton]

First step didn't work and all I have in logs is

 

2019-03-08 09:55:38 ::1 GET /test.php - 85 - ::1 Mozilla/5.0+(Windows+NT+6.3;+WOW64;+Trident/7.0;+rv:11.0)+like+Gecko - 500 0 3 1

[webman]

OK, it looks like there are some issues with it running the actual PHP language. Unfortuntaely at this stage it is beyond what I can help with, as I don't use IIS or have any facilities to test or try things.

 

What I would advise is to find a guide online for installing PHP 7 on your version of Windows and IIS, and follow every step until it is working.

[J_Parton]

okay, I've managed to get it to work on my local machine, ..if only I could start from scratch on the server I reckon it would work too but there are other html sites running too not sure if I could reset my php and handler on iis

[webman]

I'm not sure. If nothing else uses PHP then you could be fine... or perhaps try to work out what the differences are between your non-working server's configurations and your working one/an online guide? And then change settings/values until it works.

[J_Parton]

got it all working now thanks for your assistance, ..The computer must like me today haha, I'm sure I'll be back soon with another problem though

[webman]

Ah that's brilliant, glad it's sorted (for now)

[J_Parton]

I'm back haha, I made a database in sql server management studio, not sure how to connect it all up im hitting install page now

[webman]

Hi Unfortunately Microsoft SQL Server databases aren't supported either... Classroombookings requires either MySQL or MariaDB (all details on what is supported is on the requirements page).

[J_Parton]

makes sense

[J_Parton]

got mysql sorted and a database but what do I put into Host name?

[J_Parton]

I put in the server name: SR-001

databse name: crbs

User name: admin

password:****

 

but it says could not connect to the database

[webman]

For the hostname, try using 'localhost' or '127.0.0.1'. And make sure MySQL is running on port 3306.

[J_Parton]

still cant connect I ran a test script and I keep getting this

Connection failed: The server requested authentication method unknown to the client

[webman]

Hi! I haven't come across this before, but research is pointing to an issue with MySQL version 8 having a new password storage method that the current version of PHP doesn't have support for.

 

The easiest way around this seems to be to use MySQL 5.x (which uses the older but more widely supported password storage method) instead of 8.

 

An alternative is to change the MySQL config (my.ini or my.cnf file) to use the older method, restart the server, and re-create (delete old one first) the user.

 

[mysqld]
default-authentication-plugin=mysql_native_password

 

From here: https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/

 

But I haven't tested that and not 100% sure if it will cure the problem, or cause other issues!

[J_Parton]

Got it sorted, cheers. I recommend the reinstallation of version 5 the change of config doesn't work I tried that home.

[webman]

That's great, thank you! I'll upate the documentation and advise anyone else with the same problem to do the same

[J_Parton]

I'm going to be making Documentation myself for my apprentice work so I will happily send you the documentation once done for installation on a windows OS

 

Great system btw! definitely was worth the hassle it does everything we expected from it!