webERP Forum
Installing on a VPS - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Installation Issues (/forumdisplay.php?fid=13)
+--- Thread: Installing on a VPS (/showthread.php?tid=437)

Pages: 1 2


RE: Installing on a VPS - MacPhotoBiker - 12-07-2012 12:00 AM

Could you post the "core content" of the index.php here? At least a snippet from the beginning (and please make sure it does not contain any private information).


RE: Installing on a VPS - fkasmani - 12-07-2012 12:13 AM

(12-07-2012 12:00 AM)MacPhotoBiker Wrote:  Could you post the "core content" of the index.php here? At least a snippet from the beginning (and please make sure it does not contain any private information).

<?php
/* $Id: index.php 5701 2012-10-09 02:38:42Z exsonqu $*/
error_reporting(E_ALL);
ini_set('display_errors', 'On');

if (file_exists('../config.php')) {
echo '<br />A configuration webERP installation already exists - the file config.php in the webERP installation has been created and must be removed before this utility can be re-run';
exit;
}

// Start a session
if(!defined('SESSION_STARTED')) {
session_name('ba_session_id');
session_start();
define('SESSION_STARTED', true);
}

$_SESSION['MaxLogoSize'] = 10 * 1024; // Limit logo file size.

// Check if the page has been reloaded
if(!isset($_GET['sessions_checked']) || $_GET['sessions_checked'] != 'true') {
// Set session variable
$_SESSION['session_support'] = '<p class="good">Enabled</p>';
// Reload page
header('Location: index.php?sessions_checked=true');
exit(0);
} else {
// Check if session variable has been saved after reload
if(isset($_SESSION['session_support'])) {
$session_support = $_SESSION['session_support'];
} else {
$session_support = '<p class="bad">Disabled</p>';
}
}
$PathToRoot = '..';
$CompanyPath = $PathToRoot. '/companies';

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>WebERP Installation Wizard</title>
<link href="../css/gel/default.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">

function change_os(type) {
if(type == 'linux') {
document.getElementById('operating_system_linux').checked = true;
document.getElementById('operating_system_windows').checked = false;
document.getElementById('file_perms_box').style.display = 'block';
} else if(type == 'windows') {
document.getElementById('operating_system_linux').checked = false;
document.getElementById('operating_system_windows').checked = true;
document.getElementById('file_perms_box').style.display = 'none';
}
}
function change_data(type) {
if(type == 'demo') {
document.getElementById('db_file_demo').checked = true;
document.getElementById('db_file_new').checked = false;

} else if(type == 'new') {
document.getElementById('db_file_demo').checked = false;
document.getElementById('db_file_new').checked = true;

}
}

</script>
</head>
<body>

<form id="weberp_installation_wizard" action="save.php" method="post" enctype="multipart/form-data">
<div>
<input type="hidden" name="FormID" value="<?php echo $_SESSION['FormID']; ?>" />
<input type="hidden" name="url" value="" />
<input type="hidden" name="password_fieldname" value="admin_password" />
<input type="hidden" name="remember" id="remember" value="true" />
<input type="hidden" name="path_to_root" value="<?php echo $PathToRoot; ?>" />

<table cellpadding="0" cellspacing="0" border="0" width="750" style="margin-top: 10px;">
<tr>
<td class="content">
<div class="centre">
<h2>Welcome to the WebERP Installation Wizard.</h2>
<img src="<?php echo "../companies/weberpdemo/logo.jpg"; ?>" width="250" height="50" alt="Logo" />
</div>


<?php
if(isset($_SESSION['message']) AND $_SESSION['message'] != '') {
?><div style="width: 700px; padding: 10px; margin-bottom: 5px; border: 1px solid #FF0000; background-color: #FFDBDB;"><b>Error:</b> <?php echo $_SESSION['message']; ?></div><?php
}
?>
<table cellpadding="3" cellspacing="0" width="100%">
<tr>
<td colspan="8"><h3>Step 1</h3>Please check the following requirements are met before continuing...</td>
</tr>
<?php if($session_support != '<p class="good">Enabled</p>') { ?>
<tr>
<td colspan="8" style="font-size: 10px;"><p class="bad">Please note: PHP Session Support may appear disabled if your browser does not support cookies.</p></td>
</tr>
<?php } ?>
<tr>
<td style="color: #666666;">PHP Version &gt; 5.1.0</td>
<td>
<?php
$phpversion = mb_substr(PHP_VERSION, 0, 6);
if($phpversion > 5.1) {
?><p class="good">Yes</p><?php
} else {
?><p class="bad">No</p><?php
}
?>
</td>
<td style="color: #666666;">PHP Session Support</td>
<td><?php echo $session_support; ?></td>
<td style="color: #666666;">PHP Safe Mode</td>
<td>
<?php
if(ini_get('safe_mode')) {
?><p class="bad">Enabled</p><?php
} else {
?><p class="good">Disabled</p><?php
}
?>
</td>
</tr>
</table>
<table cellpadding="3" cellspacing="0" width="100%">
<tr>
<td colspan="8"><h3>Step 2</h3>Please check the following files/folders are writeable before continuing...</td>
</tr>
<tr>
<td style="color: #666666;">Configuration file</td>
<td><?php if(is_writable($PathToRoot)) {
echo '<p class="good">Writeable</p>';
} else {
echo '<p class="bad">Unwriteable</p>';
} ?>
</td>
<td style="color: #666666;"><?php echo 'Company data dirs ('. $CompanyPath. '/*)'; ?>
</td>
<td><?php if(is_writable($CompanyPath)) {
echo '<p class="good">Writeable</p>';
} else {
echo '<p class="bad">Unwriteable</p>';
}
?>
</td>
</tr>
</table>
<table cellpadding="3" cellspacing="0" width="100%">
<tr>
<td colspan="2"><h3>Step 3</h3>Please check your path settings...</td>
</tr>
<tr>
<td style="color: #666666;width:20%">
Absolute URL:
</td>
<td>
<?php
if (isset($_SESSION['ba_url'])) {
$IntstallUrl = $_SESSION['ba_url'];
} else {
// Try to guess installation URL
$GuessedURL = 'http://'.$_SERVER["SERVER_NAME"].$_SERVER["SCRIPT_NAME"];
$GuessedURL = trim(rtrim(dirname($GuessedURL), 'install'));
$IntstallUrl = $GuessedURL;
}
?>
<input type="text" tabindex="30" name="ba_url" style="width: 99%;" value="<?php echo $IntstallUrl;?>" />
</td>
</tr>
</table>
<table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td colspan="3"><h3>Step 4</h3>Please specify your operating system information below...</td>
</tr>
<tr>
<td >
Server Operating System:
</td>
<td>
<p style="cursor: pointer;" onclick="j change_os('linux');">
<input type="radio" tabindex="40" name="operating_system" id="operating_system_linux" onclick="document.getElementById('file_perms_box').style.display = 'block';" value="linux"
<?php
if(!isset($_SESSION['operating_system']) OR $_SESSION['operating_system'] == 'linux') {
echo ' checked="checked"';
} ?>
/>Linux/Unix based</p>
<br />
<p style="cursor: pointer;" onclick="j change_os('windows');">
<input type="radio" tabindex="41" name="operating_system" id="operating_system_windows" onclick="document.getElementById('file_perms_box').style.display = 'none';" value="windows"
<?php
if(isset($_SESSION['operating_system']) AND $_SESSION['operating_system'] == 'windows') {
echo ' checked="checked"'; }
?>
/>Windows</p>
</td>
<td>
<?php
if(isset($_SESSION['operating_system']) AND $_SESSION['operating_system'] == 'windows') {
echo '<div id="file_perms_box" style="margin:0; padding:0; display:none">';
} else {
echo '<div id="file_perms_box" style="margin:0; padding:0; display:block">';
}
?>

<input type="checkbox" tabindex="42" name="world_writeable" id="world_writeable" value="true"<?php if(isset($_SESSION['world_writeable']) AND $_SESSION['world_writeable'] == true) { echo 'checked="checked"'; } ?> />
<label for="world_writeable">
World-writeable file permissions (777)
</label>
<br />
<p>(Please note: this is only recommended for testing environments)</p>
<?php echo '</div>';?>
</td>
</tr>
</table>
<table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td colspan="5">Please enter your MySQL database server details below...</td>
</tr>
<tr>
<td style="color: #666666;">Host Name:</td>
<td>
<input type="text" tabindex="43" name="database_host" style="width: 98%;" value="<?php if(isset($_SESSION['database_host'])) {
echo $_SESSION['database_host'];
} else {
echo 'localhost';
} ?>" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td style="color: #666666;">Username:</td>
<td>
<input type="text" tabindex="44" name="database_username" size="20" value="<?php
if(isset($_SESSION['database_username'])) {
echo $_SESSION['database_username'];
} else {
echo 'root';
}
?>" />
</td>
</tr>
<tr>
<td style="color: #666666;">Password:</td>
<td>
<input type="password" tabindex="45" name="database_password" size="20"<?php if(isset($_SESSION['database_password'])) {
echo ' value = "'.$_SESSION['database_password'].'"';
} ?> />
</td>
<td>&nbsp;</td>
</tr>
<tr>

<td colspan="2">
<input type="checkbox" tabindex="46" name="install_tables" id="install_tables" value="true"<?php if(!isset($_SESSION['install_tables'])) {
echo ' checked="checked"';
} elseif($_SESSION['install_tables'] == 'true') {
echo ' checked="checked"';
} ?> />
<label for="install_tables" style="color: #666666;">Install Tables</label>
<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<span style="font-size: 10px; color: #666666;">(Please note: May remove existing tables and data)</span>
</td>
</tr>
<tr>
<td colspan="5"><h3>Step 5</h3>Please enter the company database name below... note that in some shared hosting environments this will have to be of the format domain_company_database_name. This installation script will fail if the mysql user above does not have permissions to create the company database</td>
</tr>
<tr>
<td style="color: #666666;" colspan="1">Company Database Name:</td>
<td colspan="4">
<input type="text" tabindex="50" name="company_name" style="width: 99%;" value="<?php if(isset($_SESSION['company_name'])) { echo $_SESSION['company_name']; } else { echo 'weberpdemo'; } ?>" />
</td>
</tr>
<tr>
<td>
Install the test company :
</td>

<td>

<input type="checkbox" tabindex="51" name="DemoData" id="db_file_demo" value="demo"<?php if(!isset($_SESSION['db_file']) OR $_SESSION['db_file'] == 'demo') { echo ' checked="checked"'; } ?> />
<div style="cursor: pointer;" onclick="j change_data('demo');"> weberpdemo company</div>
</td>
</tr>
<tr>
<td>
Time Zone
</td>

<td>
<select name='timezone' tabindex="52">
<?php
include('timezone.php');
?>

</select>
</td>
</tr>
<tr>
<td>
Logo Image File (.jpg)
</td>

<td>
<input type="hidden" name="MAX_FILE_SIZE" <?php echo "value=\"" . $_SESSION['MaxLogoSize'] . "\"" ?> />
<input type="file" size="50" id="LogoFile" name="LogoFile" tabindex="53" />
</td>
</tr>
<tr>
<td colspan="5"><h3>Step 6</h3>Please enter your Administrator account details below...</td>
</tr>
<tr>
<td style="color: #666666;">Username:</td>
<td>
admin
<!--<input type="text" tabindex="60" name="admin_username" style="width: 98%;" value="<?php if(isset($_SESSION['admin_username'])) { echo $_SESSION['admin_username'];
} else {
echo 'admin'; } ?>" />-->
</td>
<td>&nbsp;</td>
<td style="color: #666666;">Password:</td>
<td>
<input type="password" tabindex="62" name="admin_password" style="width: 98%;"<?php if(isset($_SESSION['admin_password'])) { echo ' value = "'.$_SESSION['admin_password'].'"'; } ?> />
</td>
</tr>
<tr>
<td style="color: #666666;">Email:</td>
<td>
<input type="text" tabindex="61" name="admin_email" style="width: 98%;"<?php if(isset($_SESSION['admin_email'])) { echo ' value = "'.$_SESSION['admin_email'].'"'; } ?> />
</td>
<td>&nbsp;</td>
<td style="color: #666666;">Re-Password:</td>
<td>
<input type="password" tabindex="63" name="admin_repassword" style="width: 98%;"<?php if(isset($_SESSION['admin_password'])) { echo ' value = "'.$_SESSION['admin_password'].'"'; } ?> />
</td>
</tr>

<tr>
<td colspan="5" style="padding: 10px; padding-bottom: 0;"><h3 style="font-size: 0px;">&nbsp;</h3></td>
</tr>
<tr>
<td colspan="4">
<table cellpadding="0" cellspacing="0" width="100%" border="0">
<tr valign="top">
<td>Please note: &nbsp;</td>
<td>
WebERP is released under the
<a href="http://www.gnu.org/licenses/gpl.html" target="_blank" tabindex="64">GNU General Public License</a>
<br />
By clicking install, you are accepting the license.
</td>
</tr>
</table>
</td>
<?php //only show submit button if ready to go
if ($phpversion > 4.1 AND $_SESSION['session_support'] = '<p class="good">Enabled</p>'
AND is_writable($PathToRoot) AND is_writable($CompanyPath)){
echo '<td colspan="1" align="right">
<input type="submit" tabindex="20" name="submit" value="Install WebERP" class="submit" />
</td>';
} else {
echo '<td>FIX ERRORS FIRST</td></tr><tr><td colspan=5><h2>The installation cannot proceed until the above errors are resolved</h2></td>';
}
?>
</tr>
</table>

</td>
</tr>
</table>
</div>
</form>

<table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding: 10px 0px 10px 0px;">
<tr>
<td align="center" style="font-size: 10px;">
<!-- Please note: the below reference to the GNU GPL should not be removed, as it provides a link for users to read about warranty, etc. -->
<a href="http://www.weberp.org/" style="color: #000000;" target="_blank">WebERP</a>
is released under the
<a href="http://www.gnu.org/licenses/gpl.html" style="color: #000000;" target="_blank">GNU General Public License</a>
<!-- Please note: the above reference to the GNU GPL should not be removed, as it provides a link for users to read about warranty, etc. -->
</td>
</tr>
</table>

</body>
</html>


RE: Installing on a VPS - MacPhotoBiker - 12-07-2012 12:19 AM

OK, this is indeed the installation file. If only the raw content is shown, then PHP is probably not (properly?) installed on your VPS. At this point I´d suggest you contact support, and tell them what you tried so far.

Well, just one thing before you do so: Did you make sure ownership and read/write rights are correct (as I posted earlier, "chown..." and "chmod...")

Other than this, I believe your VPS support should be able to help you out. Keep us posted about any progress.


RE: Installing on a VPS - fkasmani - 12-07-2012 03:35 AM

Well, checked the settings and saw that PHP was not installed. Installed it using "yum install php" amd rebooted the VPS, pointed my browser to: "http://ipnumber/webERP/install/index.php" and things started good. Was redirected to
http://ipnumber/webERP/install/index.php?sessions_checked=true
and I saw the webERP logo, but Step 1 just gives the following error message and things seem to stop there:
Step 1
Please check the following requirements are met before continuing...
PHP Version > 5.1.0 Fatal error: Call to undefined function mb_substr() in /var/www/html/webERP/install/index.php on line 111
Huh


RE: Installing on a VPS - MacPhotoBiker - 12-07-2012 03:48 AM

fkasmani,
sorry to say, but you are just "shooting in the dark". Programmers call this approach "voodoo programming", i. e. trying to change stuff randomly, hoping that sooner or later it works out.

I mean no offense, but from your posts I´d say it´s obvious that currently you don´t have (yet) the skills to administrate a VPS.

Before struggling with your webERP, you should have your LAMP environment (Linux, Apache, MySql, PHP) properly set up. If you can´t do this yourself, the support team from your provider should be able to guide and help you.

I am sorry, but at this stage I don´t see the point to look more into "error messages", since these "errors" are obviously not webERP errors (or "bugs"), but errors caused by your poorly configured VPS. In your first post you mentioned that PHP would be "ready installed", but now it turns out this was never the case.

If you want to do it yourself, then start with the "Hello World" tutorials and examples that are available all over the internet, this would help you to understand how the whole thing works. Obviously, there will be some "learning curve". If you have no time (or no intention) to do so, then you need somebody to do it for you. If support of your VPS hoster does not help, then my advice is to switch to another provider the sooner the better. I know you "paid for one year", but how much money could this probably be? With the new provider make sure that LAMP works right from the beginning. And get a cpanel.


RE: Installing on a VPS - MacPhotoBiker - 12-08-2012 05:46 AM

I just set up a demo site for webERP. If you are interested, have a look here: https://www.justcorebusiness.com/demo/webERP/

I am amazed how fast and solid it runs, despite being a really complete and powerful piece of software,