search

meeting-room-booking-system / mrbs-code

MRBS application code
Other
124 stars 58 forks source link

INSTALLATION ISSUE #2000

Open jberanek opened 7 years ago

jberanek commented 7 years ago

Dear Team,

I am very new to PHP and MRBS, I tried installing it on a VM and I keep get error.Please I need direction on how to resolve this issue.

See the error message below. Parse error: syntax error, unexpected '10.0' (T_DNUMBER), expecting variable (T_VARIABLE) or '{' or '$' in C:\xampp\htdocs\mrbs\web\mysql.inc on line 496

Please find attached mysqli.inc

Kindly assist I need to deliver it ASAP.

Reported by: similee2017

Original Ticket: mrbs/support-requests/1284

Attachments: https://sourceforge.net/p/mrbs/support-requests/1284/attachment/mysqli.inc

jberanek commented 7 years ago

It looks like (a) you are using an old version of MRBS and (b) you have modified mysqli.inc.

You should not need to modify mysqli.inc. All you need to do is put the appropriate settings in config.inc.php. But I would recommend using the latest version (1.6.1) of MRBS anyway.

Original comment by: campbell-m

jberanek commented 7 years ago

Thank You Cambell. I will download the lastest version of MRBS. Thanks again.

Original comment by: similee2017

jberanek commented 7 years ago

Hello Campbell,

I have downloaded the lastest version, but I still have installation issues.

After configuring the database setting, I just get a blank page when I try to access (http://localhost:1234/mrbs/web/).

Please advice me on the necessary steps. I attached the config file.

Original comment by: similee2017

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/83e59f6e/2afc/attachment/config.inc.php

jberanek commented 7 years ago

http://mrbs.sourceforge.net/view_text.php?section=Documentation&file=INSTALL

Generally, look in your web server/PHP error log, which should give you some clues.

Original comment by: jberanek

jberanek commented 7 years ago

Hello John,

Am new to PHP, where can I find the error log?

Original comment by: similee2017

jberanek commented 7 years ago

On the Xamp control panel, when I try to view the php_error_log, I get a 'the system cannot find path specified'. Please advice.

Original comment by: similee2017

jberanek commented 7 years ago

Hello,

Kindly advise on what the likely causes of this errror could be.

All am getting is just a blank pagewhen I browse to (http://localhost:1234/mrbs/web/). I have tried to locate the error log but no luck.

I seriously need your help guys, I need to deliver this demo tomorrow and am yet to get the application to work. Thanks.

Original comment by: similee2017

jberanek commented 7 years ago

The most likely cause is a syntax error in the config file caused by a typo, eg a missing semicolon.

Original comment by: campbell-m

jberanek commented 7 years ago

Thanks Campbell.

Am looking through the config file write now.

Original comment by: similee2017

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/83e59f6e/38b4/attachment/config.inc.php

jberanek commented 7 years ago

Hello Guys,

See the code in the config file. Please I know am really asking for too much. Can you help me identify the bug in this code.

<?php namespace MRBS;

// $Id$

/**

Configuration File

anything outside this file. *

configuration

If you want to change any of the other settings in systemdefaults.inc.php

areadefaults.inc.php, then copy the relevant lines into this file

This file will override the default settings and

the config file is preserved.

**/

/**

Timezone **/

// The timezone your meeting rooms run in. It is especially important // to

set this if you're using PHP 5 on Linux. In this configuration // if you don't, meetings in a

different DST than you are currently // in are offset by the DST offset incorrectly. // // Note

that timezones can be set on a per-area basis, so strictly speaking this // setting should be in

areadefaults.inc.php, but as it is so important to set // the right timezone it is included

here. // // When upgrading an existing installation, this should be set to the // timezone the web

server runs in. See the INSTALL document for more information. // // A list of valid timezones

can be found at http://php.net/manual/timezones.php // The following line must be uncommented by

removing the '//' at the beginning $timezone = "Africa/Lagos";

/***

settings **/ // Which database system: "pgsql"=PostgreSQL, "mysql"=MySQL $dbsys = "mysql"; // Hostname of database server. For pgsql, can use "" instead of localhost // to use

Unix Domain Sockets instead of TCP/IP. For mysql "localhost" // tells the system to use Unix

Domain Sockets, and $db_port will be ignored; // if you want to force TCP connection you can use

"127.0.0.1". $db_host = "10.0.9.187"; // If you need to use a non standard port for the database

connection you // can uncomment the following line and specify the port number $db_port = 1234; // Database name: $db_database = "mrbs"; // Schema name. This only applies to PostgreSQL and is

only necessary if you have more // than one schema in your database and also you are using the

same MRBS table names in // multiple schemas. //$db_schema = "public"; // Database login user

name: $db_login = "root"; // Database login password: $db_password = 'halogen'; // Prefix for table

names. This will allow multiple installations where only // one database is available $db_tblprefix = "mrbs"; // Set $db_persist to TRUE to use PHP persistent (pooled) database

connections. Note // that persistent connections are not recommended unless your system suffers

significant // performance problems without them. They can cause problems with transactions

and // locks (see http://php.net/manual/en/features.persistent-connections.php) and although //

MRBS tries to avoid those problems, it is generally better not to use persistent // connections

if you can. $db_persist = False;

/* Add lines from systemdefaults.inc.php and

areadefaults.inc.php below here to change the default configuration. Do NOT modify

systemdefaults.inc.php or areadefaults.inc.php. */

$auth ["admin"][] = "simi"; $auth ["session"] = "php"; $auth ["type"] = "config"; $auth ["user"] ["simi"] = "simi";

Original comment by: similee2017

jberanek commented 7 years ago

The default location for Apache web server logs in xampp would be "\apache\logs" I believe - you want to look in error.log.

I see the problem in your config file, spaces are significant in some PHP constructs so your:

$auth ["admin"][] = "simi";
$auth ["session"] = "php";
$auth ["type"] = "config";
$auth ["user"] ["simi"] = "simi";

needs to be:

$auth["admin"][] = "simi";
$auth["session"] = "php";
$auth["type"] = "config";
$auth["user"]["simi"] = "simi";

Original comment by: jberanek

jberanek commented 7 years ago

Thanks John and Campbell for your help so far.

I am still experiencing the same issue. I even tried to remove all the comments in the config file and level only the codes.

<?php namespace MRBS; $timezone = "Africa/Lagos"; $dbsys = "mysql"; $db_host = "10.0.9.187"; $db_port = 1234; $db_database = "mrbs"; $db_login = "root"; $db_password = 'halogen'; $db_tblprefix = "mrbs"; $db_persist = True; $auth["admin"][] = "simi"; $auth["session"] = "php"; $auth["type"] = "config"; $auth["user"]["simi"] = "simi";

The error log file

[Tue Aug 08 16:06:31.182055 2017] [php7:notice] [pid 1816:tid 1748] [client 10.0.9.187:49588] Uncaught exception 'MRBS\DBException' in C:\xampp\htdocs\mrbs\web\lib\MRBS\DB.php at line 67\nSQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.\r\n\nSQL: \nParams: \n#0 C:\xampp\htdocs\mrbs\web\lib\MRBS\DBFactory.php(25): MRBS\DB->__construct('12.0.0.1', 'root', 'halogen', 'mrbs', false, 1234)\n#1 C:\xampp\htdocs\mrbs\web\dbsys.inc(40): MRBS\DBFactory::create('mysql', '12.0.0.1', 'root', 'halogen', 'mrbs', false, 1234)\n#2 C:\xampp\htdocs\mrbs\web\dbsys.inc(74): MRBS\db()\n#3 C:\xampp\htdocs\mrbs\web\defaultincludes.inc(29): require_once('C:\\xampp\\htdocs...')\n#4 C:\xampp\htdocs\mrbs\web\index.php(9): require('C:\\xampp\\htdocs...')\n#5 {main}\nMRBS GET: Array\n(\n)\nMRBS POST: Array\n(\n)\n [Wed Aug 09 08:55:45.502370 2017] [ssl:warn] [pid 288:tid 404] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name [Wed Aug 09 08:55:45.689942 2017] [core:warn] [pid 288:tid 404] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run? [Wed Aug 09 08:55:45.893104 2017] [ssl:warn] [pid 288:tid 404] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name [Wed Aug 09 08:55:52.878700 2017] [mpm_winnt:notice] [pid 288:tid 404] AH00455: Apache/2.4.26 (Win32) OpenSSL/1.0.2l PHP/7.1.7 configured -- resuming normal operations [Wed Aug 09 08:55:52.878700 2017] [mpm_winnt:notice] [pid 288:tid 404] AH00456: Apache Lounge VC14 Server built: Jun 15 2017 12:39:41 [Wed Aug 09 08:55:52.878700 2017] [core:notice] [pid 288:tid 404] AH00094: Command line: 'C:\xampp\apache\bin\httpd.exe -d C:/xampp/apache' [Wed Aug 09 08:55:52.909940 2017] [mpm_winnt:notice] [pid 288:tid 404] AH00418: Parent: Created child process 1876 [Wed Aug 09 08:55:53.738228 2017] [ssl:warn] [pid 1876:tid 280] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name [Wed Aug 09 08:55:53.956866 2017] [ssl:warn] [pid 1876:tid 280] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name [Wed Aug 09 08:55:54.082150 2017] [mpm_winnt:notice] [pid 1876:tid 280] AH00354: Child: Starting 150 worker threads.

Please kindly assist. I do not understand what to make of this error.

Original comment by: similee2017

jberanek commented 7 years ago

It looks like you cannot connect to the MySQL server. Are you sure that your database settings are correct in the config file, especially $db_host and $db_port? Try commenting out those two lines and just relying on the system defaults.

Original comment by: campbell-m

jberanek commented 7 years ago

Campbell, you are a genuis!

Thanks it worked.

Thanks John and Campbell.

Original comment by: similee2017

jberanek commented 7 years ago

For future reference, my comment about spaces was incorrect, I was led astray by an online PHP syntax checker. It appears PHP is actually completely happy about those spaces.

Original comment by: jberanek

jberanek commented 7 years ago

Noted.

Original comment by: similee2017