Hi,
I have dedicated server and i'm good with linux. I have setup centos 5.5
server with php 5.2.14 mysql 5. innodb enabled. gd installed.
I can install projectpier-0.8.0.3 just fine without issue, once i'm trying
to install pp086b2. having trouble with that... i'm going trouh
installation process, everything seems to be fine. at step 4(finish) it
tells me that it can't connect to DB.
Please let me know what i'm missing or some extensions needs to be
installed. better if you can give me whole list of needed extensions
installed.
Thanks in advance.
Paste the code below in a new file testdb.php and run it from your root. Edit the first 5 fields to suit your installation. If all is okay, use the same values in the setup of 0.8.6. This is the code that runs in the installation.
<?php
$database_host = 'your database host';
$database_user = 'your database user';
$database_pass = 'database user password';
$database_name = 'database name';
$database_prefix = 'PP_'; // cannot be empty in beta 2
$database_type = 'mysql'; // do not change
$database_charset = 'utf8'; // do not change
$connected = false;
if ($database_connection = @mysql_connect($database_host, $database_user, $database_pass)) {
$connected = @mysql_select_db($database_name, $database_connection);
} // if
if ($connected) {
echo 'Database connection has been established successfully<b'.'r>';
} else {
die('Failed to connect to database with data you provided');
} // if
// ---------------------------------------------------
// Check if we have at least 4.1
// ---------------------------------------------------
$mysql_version = mysql_get_server_info($database_connection);
if ($mysql_version && version_compare($mysql_version, '4.1', '<')) {
die('MySQL version is '.$mysql_version.'. PP needs 4.1 or higher. Choose another MySQL server or upgrade.');
}
// ---------------------------------------------------// Check if we have InnoDB support (transactions)
// ---------------------------------------------------
$inno = false;
if ($result = mysql_query("SHOW VARIABLES LIKE 'have_innodb'", $database_connection)) {
if ($row = mysql_fetch_assoc($result)) {
print_r($row);
$inno = strtolower($row['Value']) == 'yes';
} // if
} // if
if ($inno) {
echo '<b'.'r>InnoDB storage engine is supported';
} else {
echo '<b'.'r>InnoDB storage engine is not supported, this is okay for low volume installations';
} // if
@mysql_query("SET NAMES '$database_charset'", $database_connection);
@mysql_query('BEGIN WORK', $database_connection);
// Database construction
@mysql_query('COMMIT', $database_connection);
echo '<b'.'r>all okay';
?>