Installation Issue on DB Install

marconotsopolo

I am trying to install onto my windows 2008 R2 server, PHP is all configured and I have been following the installation guide but seem to have hit a brick wall. I see some posts which have suggestions regarding the blank page after DB credentials are entered and I have done my best to follow but as said have not had much luck.

I have attached my IIS log file, config file and htaccess file for your review. The user in mysql has full access rights to create, alter etc so not sure what I am doing wrong and any help would be really appreciated.

Thanks
Mark

ethnar

Hello and welcome to the forums,

Please make sure to post the relevant messages from your error log, it's the most important place to look for reasons why something's failing.

If you're using Chrome or Firefox with Firebug, it's also helpful to start the console (F12) and check responses to requests send during the installation.

You should also check if the file /data/config.php is created and if the database was created and tables were added.

Kind regards,
Arek

marconotsopolo

Hi Thanks for your reply

I have run the F12 console in google and it appears I have an internal error 500 (see below)

Request URL:http://localhost/EPESI/setup.php?license=1&htaccess=1
Request Method:POST
Status Code:500 Internal Server Error
Request Headersview parsed
POST /EPESI/setup.php?license=1&htaccess=1 HTTP/1.1

Host: localhost
Connection: keep-alive
Content-Length: 86
Cache-Control: max-age=0
Origin: http://localhost
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.162 Safari/535.19

Content-Type: application/x-www-form-urlencoded
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Referer: http://localhost/EPESI/setup.php?license=1

Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-GB,en-US;q=0.8,en;q=0.6
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3
Query String Parametersview decoded
license:1
htaccess:1
Form Dataview decoded
host:localhost
engine:mysqlt
user:*******
password:*******
db:epesi
newdb:0
submit:Next
Response Headersview parsed
HTTP/1.1 500 Internal Server Error

Content-Type: text/html
Server: Microsoft-IIS/7.5
X-Powered-By: PHP/5.4.0
X-Powered-By: ASP.NET
Date: Mon, 23 Apr 2012 16:21:25 GMT
Content-Length: 518

The database has been created but no tables are present. the config file is also created, below is the content of the IIS log in the inetpub\logs\logfiles folder for your review as well but does not display much information regarding the reason for failure.

#Software: Microsoft Internet Information Services 7.5
#Version: 1.0
#Date: 2012-04-23 16:20:18
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2012-04-23 16:20:18 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 154
2012-04-23 16:20:40 ::1 POST /EPESI/setup.php license=1&htaccess=1 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 500 0 0 89
2012-04-23 16:20:40 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 4
2012-04-23 16:20:56 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 2
2012-04-23 16:21:25 ::1 POST /EPESI/setup.php license=1&htaccess=1 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 500 0 0 51
2012-04-23 16:21:25 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 2

Any help would be appreciated so we can evaluate your product.

Regards
Mark

ethnar

Hello,

[quote="marconotsopolo":tdtxovmc]Hi Thanks for your reply

I have run the F12 console in google and it appears I have an internal error 500 (see below)

Content-Type: application/x-www-form-urlencoded
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Referer: http://localhost/EPESI/setup.php?license=1

Content-Type: text/html
Server: Microsoft-IIS/7.5
X-Powered-By: PHP/5.4.0
X-Powered-By: ASP.NET
Date: Mon, 23 Apr 2012 16:21:25 GMT
Content-Length: 518
[/quote:tdtxovmc]
This is the request that is sent to the server. Status Code 500 means there was an error encountered while executing the script. Can you check and post what is the response you're receiving? (you switch to response using the tabbed navigation at the top).

[quote="marconotsopolo":tdtxovmc]The database has been created but no tables are present. the config file is also created, below is the content of the IIS log in the inetpub\logs\logfiles folder for your review as well but does not display much information regarding the reason for failure.[/quote:tdtxovmc]
The fact tables are not created may indicate that the problem is with SQL permissions, not a definitive cause but it's likely. Please double-check the permissions of DB user you're using in the setup.

[quote="marconotsopolo":tdtxovmc]#Software: Microsoft Internet Information Services 7.5
#Version: 1.0
#Date: 2012-04-23 16:20:18
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2012-04-23 16:20:18 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 154
2012-04-23 16:20:40 ::1 POST /EPESI/setup.php license=1&htaccess=1 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 500 0 0 89
2012-04-23 16:20:40 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 4
2012-04-23 16:20:56 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 2
2012-04-23 16:21:25 ::1 POST /EPESI/setup.php license=1&htaccess=1 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 500 0 0 51
2012-04-23 16:21:25 ::1 GET /favicon.ico - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1;+WOW64)+AppleWebKit/535.19+(KHTML,+like+Gecko)+Chrome/18.0.1025.162+Safari/535.19 404 0 2 2
[/quote:tdtxovmc]
The log posted is access log of http server. Very rarely there's any relevant error information to be found in access log.
The place to check is the error log. Alternatively, you could enable error reporting in your php.ini, it's likely the error will then be simply printed on the screen.

What happens here is there's an error triggered and we're not getting the message this error carries. Once we have the message it'll be much easier to tell what exactly is going on with the installation.

Kind regards,
Arek

marconotsopolo

Hi thanks again for the reply

I have double checked the permission and in sqlyog I am able to create,alter and delete databases so think this looks OK.

In looking at the response tab in chrome it does not appear to give any indication of issue (see below)

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title>epesi setup</title>
<link href="setup.css" type="text/css" rel="stylesheet"/>
</head>
<body>
<table id="banner" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="image"> </td>
<td class="back"> </td>
</tr>
</table>
<br>
<center>
<table id="main" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>

I will put on php error logging and see what other information I gain from this and revert back with something more conclusive.

Thanks
Mark

marconotsopolo

This is taken from the php error log;

[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Declaration of HTML_QuickForm_header::accept() should be compatible with HTML_QuickForm_element::accept(&$renderer, $required = false, $error = NULL) in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm\header.php on line 39
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Declaration of HTML_QuickForm_html::accept() should be compatible with HTML_QuickForm_element::accept(&$renderer, $required = false, $error = NULL) in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm\html.php on line 76
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Non-static method HTML_QuickForm_RuleRegistry::singleton() should not be called statically, assuming $this from incompatible context in C:\inetpub\wwwroot\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 1520
[23-Apr-2012 18:26:16 UTC] PHP Strict Standards: Only variables should be assigned by reference in C:\inetpub\wwwroot\epesi\setup.php on line 245
[23-Apr-2012 18:26:16 UTC] PHP Fatal error: Detection of epesi directory failed. Please define EPESI_DIR variable in config.php in C:\inetpub\wwwroot\epesi\include\config.php on line 68

Hope this helps identify where the problem may lie.

Thanks again for your help

Regards
Mark

ethnar

Hello,

This is exactly what we've been looking for!
The core of the issue is this message:[quote="marconotsopolo":2tdb9com][23-Apr-2012 18:26:16 UTC] PHP Fatal error: Detection of epesi directory failed. Please define EPESI_DIR variable in config.php in C:\inetpub\wwwroot\epesi\include\config.php on line 68[/quote:2tdb9com]What you need to do is to edit file:
C:\inetpub\wwwroot\epesi\data\config.php
and add line:

define('EPESI_DIR', 'C:\inetpub\wwwroot\epesi\');

before the closing ?> sign.
After that you can enter your EPESI url in the browser and the installation should continue.

Kind regards,
Arek

marconotsopolo

Hi, thanks for the reply again

I have added the suggested line and get the following error in the log file

[23-Apr-2012 19:20:36 UTC] PHP Parse error: syntax error, unexpected '\' (T_NS_SEPARATOR) in C:\inetpub\wwwroot\epesi\include\config.php on line 54

Thanks
Mark

marconotsopolo

I have changed the '\' to '/' and all appears to be working now, thanks very much for your help.

Kind regards
Mark

ethnar

Indeed, my mistake. I'm glad you got it sorted out.

Hope you will find our software to your liking.

Kind regards,
Arek

maxtian

Hi there.

I met this problem yesterday and I followed your steps, but it still exists.

Error message:
[quote:22dxiua5]
Strict Standards: Declaration of HTML_QuickForm_header::accept() should be compatible with HTML_QuickForm_element::accept(&$renderer, $required = false, $error = NULL) in D:\Runtime\php_www\php\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm\header.php on line 39

Strict Standards: Non-static method PEAR::isError() should not be called statically, assuming $this from incompatible context in D:\Runtime\php_www\php\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 636

Strict Standards: Declaration of HTML_QuickForm_html::accept() should be compatible with HTML_QuickForm_element::accept(&$renderer, $required = false, $error = NULL) in D:\Runtime\php_www\php\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm\html.php on line 76

Strict Standards: Non-static method HTML_QuickForm_RuleRegistry::singleton() should not be called statically, assuming $this from incompatible context in D:\Runtime\php_www\php\epesi\modules\Libs\QuickForm\3.2.11\HTML\QuickForm.php on line 1520

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\setup.php on line 245

Strict Standards: Declaration of dbTable::create() should be compatible with dbObject::create() in D:\Runtime\php_www\php\epesi\libs\adodb\adodb-xmlschema.inc.php on line 601

Strict Standards: Declaration of dbIndex::create() should be compatible with dbObject::create() in D:\Runtime\php_www\php\epesi\libs\adodb\adodb-xmlschema.inc.php on line 765

Strict Standards: Declaration of dbData::create() should be compatible with dbObject::create() in D:\Runtime\php_www\php\epesi\libs\adodb\adodb-xmlschema.inc.php on line 952

Strict Standards: Declaration of dbQuerySet::create() should be compatible with dbObject::create() in D:\Runtime\php_www\php\epesi\libs\adodb\adodb-xmlschema.inc.php on line 1203

Strict Standards: Only variables should be passed by reference in D:\Runtime\php_www\php\epesi\libs\adodb\adodb-xmlschema.inc.php on line 268

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1089

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1122

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1089

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1122

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1089

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1122

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1089

Strict Standards: Only variables should be assigned by reference in D:\Runtime\php_www\php\epesi\libs\phpgacl\gacl_api.class.php on line 1122
[/quote:22dxiua5]

jasiek

Here is the fix: viewtopic.php?f=3&t=347&p=1325&hilit=strict#p1326
it was posted on 25 May 2010 by Paul.
Please use search feature of this forum first.

Maxtian - you are abusing the forum. You post the same error all over the place:
viewtopic.php?f=3&t=1033&p=3669#p3669
viewtopic.php?f=3&t=960&p=3663#p3663
viewtopic.php?f=3&t=1030&p=3662#p3662

Once is enough, really. We monitor all forums, we will answer your question. You just make our life harder. Some really basic, general forum rules are here:
http://forum-services-review.toptenrevi ... -tips.html
especially:
[quote:gooaa3q4]2. Search the other posts to see if your topic is already covered.
11. Do not double post (post the same message twice in one thread) or cross post (place the same message across several forums).[/quote:gooaa3q4]

maxtian

[quote="Jasiek":1u6q9r76]Here is the fix: viewtopic.php?f=3&t=347&p=1325&hilit=strict#p1326
it was posted on 25 May 2010 by Paul.
Please use search feature of this forum first.

Maxtian - you are abusing the forum. You post the same error all over the place:
viewtopic.php?f=3&t=1033&p=3669#p3669
viewtopic.php?f=3&t=960&p=3663#p3663
viewtopic.php?f=3&t=1030&p=3662#p3662

Once is enough, really. We monitor all forums, we will answer your question. You just make our life harder. Some really basic, general forum rules are here:
http://forum-services-review.toptenrevi ... -tips.html
especially:
[quote:1u6q9r76]2. Search the other posts to see if your topic is already covered.
11. Do not double post (post the same message twice in one thread) or cross post (place the same message across several forums).[/quote:1u6q9r76][/quote:1u6q9r76]

First, let me apologize. I'am sorry for that. Second, I have to say I had already search some topics about this problem, but all of those cannot solve it which I met. Every single topic I posted here, I met them in different steps. So, I don't think those problems have the same root cause. Third, I solve it. I followed the error message and went deep into the source code and changed some codes. Finally, all tables had been created in my database. Now, I can run it on my local computer.

Another thing I have to say, if you have the architecture design such like UML diagram or other things, please show them. Actually, some designing document make people understand your product easily.

jasiek

Maxtian,

I am glad to hear you were finally able to run EPESI on your computer.
[quote:2bvnytr0]Third, I solve it. I followed the error message and went deep into the source code and changed some codes.[/quote:2bvnytr0]
Do you mind sharing with us the solution? What did you do to make it run? All errors point to a problem with php.ini and disabling reporting of STRICT errors.

Unfortunately we do not use UML diagrams in developing EPESI. I know that they may be helpful and maybe at some point we will create them and post them on our wiki: http://epesi.org/ - however at this moment this is not a priority for us (see also: http://martinfowler.com/articles/designDead.html regarding UML and Extreme Programming).

We use agile development approach (http://en.wikipedia.org/wiki/Agile_software_development) and document all functional requirements, feature requests and bugs in EPESI using our own Bugtracker - this tool is available in the FREE version of EPESI as well. We use whatever tools necessary to document and explain the design and how to solve the problem: narrative description, database schema description, screenshots and yes - sometimes even diagrams - but all of them are converted into PNG or JPG (rarely PDF) so that they can be attached to tickets as notes and viewed immediately using just a browser and EPESI. We found that using UML just for the sake of having UML does not help us in the development process and actually makes sharing of ideas more difficult.

[quote:2bvnytr0]Manifesto for Agile Software Development

We are uncovering better ways of developing software by doing it and helping others do it. Through this work we have come to value:

Individuals and interactions over processes and tools
Working software over comprehensive documentation
Customer collaboration over contract negotiation
Responding to change over following a plan

That is, while there is value in the items on the right, we value the items on the left more.[/quote:2bvnytr0]
from http://agilemanifesto.org/

We are aware that both end user documentation and developer's manual needs to be improved. Both are available on our wiki: http://epesi.org/

ethnar

Hello and welcome to the forums,

First of all, I apologize for the long wait time you've experienced.

The error message you've listed suggests that your mysql server is having issues accessing some of the files it's working on. You're using Win machine, so first thought is that file permissions are not an issue, but I've found this article that indicates there might be some mysql access issues on Windows 7:
http://beerpla.net/2010/01/05/how-to-fi ... n-windows/

Please let us know if this solution resolves the problem.

Kind regards,
Arek

jasiek

Hi,

The beginning of the error log shows the problem:
[quote:ggnl220w]Hide
Type: 256
Message: mysqlt error: [6: Error on delete[/quote:ggnl220w]

Looks to me like a permission problem in MySQL. Did you grant necessary (especially delete) permissions to this database to the user under which EPESI connects to the server?
Did you follow these guidelines?
viewtopic.php?f=3&t=496

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge