Stuck in RHEL5

[walterheck]

Create a simple file in /var/www/html with just some text in <h1> tags or so, see if you can get that to display correctly. As long as you don't, your problem is with apache and you're on the wrong forum

After that, put a phpinfo() in that file and see if you can get that to display correctly. Once you get to that point, we can help you again.

good luck!

[zabbixnewbie]

Create a simple file in /var/www/html with just some text in <h1> tags or so, see if you can get that to display correctly. As long as you don't, your problem is with apache and you're on the wrong forum

After that, put a phpinfo() in that file and see if you can get that to display correctly. Once you get to that point, we can help you again.

good luck!

I had re-install my apache where the files were at /usr/local/apache2/htdocs/
I also already copy all the files from frontends/php to a zabbix folder.
I change the link to index.php, and I can see all the code through URL
Where's go wrong?Does it means my apache doesnt support php?

[walterheck]

Where's go wrong?Does it means my apache doesnt support php?

Yes, that's what it means. You'll have to install PHP and configure apache to use it. I really think you should seriously ask yourself wether you're ready for managing a monitoring server if you cannot get this to work. No offense buddy, just saying it like it is..

[zabbixnewbie]

Yes, that's what it means. You'll have to install PHP and configure apache to use it. I really think you should seriously ask yourself wether you're ready for managing a monitoring server if you cannot get this to work. No offense buddy, just saying it like it is..

Thanks for the advise. I manage to configure php to apache already but once i type the URL, the errors as below

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'zabbix'@'localhost' (using password: YES)[/usr/local/apache2/htdocs/zabbix/include/db.inc.php:58]
date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Kuala_Lumpur' for 'MYT/8.0/no DST' instead[/usr/local/apache2/htdocs/zabbix/include/page_header.php:149]
Timezone for PHP is not set. Please set "date.timezone" option in php.ini.

Any idea?

[MrKen]

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'zabbix'@'localhost' (using password: YES)[/usr/local/apache2/htdocs/zabbix/include/db.inc.php:58]

Means to check the database details in that file (db.inc.php) and compare those details with what you have in your zabbix_server.conf.

date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Kuala_Lumpur' for 'MYT/8.0/no DST' instead[/usr/local/apache2/htdocs/zabbix/include/page_header.php:149]

Means that Timezone for PHP is not set.

So what you need to do is to Please set "date.timezone" option in php.ini. You will probably find that in /etc.

After you have done that, just for good measure, Stop Zabbix, Stop Mysql, Restart Apache (do ps -ef after each step to be sure they stop). Restart Mysql, Restart Zabbix.
Then try the gui.

MrKen

[zabbixnewbie]

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'zabbix'@'localhost' (using password: YES)[/usr/local/apache2/htdocs/zabbix/include/db.inc.php:58]

Means to check the database details in that file (db.inc.php) and compare those details with what you have in your zabbix_server.conf.

date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Kuala_Lumpur' for 'MYT/8.0/no DST' instead[/usr/local/apache2/htdocs/zabbix/include/page_header.php:149]

Means that Timezone for PHP is not set.

So what you need to do is to Please set "date.timezone" option in php.ini. You will probably find that in /etc.

After you have done that, just for good measure, Stop Zabbix, Stop Mysql, Restart Apache (do ps -ef after each step to be sure they stop). Restart Mysql, Restart Zabbix.
Then try the gui.

MrKen

/etc/zabbix/zabbix_server.conf
PidFile=/tmp/zabbix_server.pid
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBSocket=/tmp/mysql.sock

/etc/php.ini
date.timezone = "Asia/Kuala_Lumpur"

After stop/start mysql, apache, yet the problem still exist.
I also check my database about the 'localhost' and 'password' and everything looks fine.

Mr.Ken,
Do you need any config files from so you can help to analyst my problem?

[MrKen]

And what does it say in /usr/local/apache2/htdocs/zabbix/include/db.inc.php ????

[zabbixnewbie]

And what does it say in /usr/local/apache2/htdocs/zabbix/include/db.inc.php ????

<?php
/*
** ZABBIX
** Copyright (C) 2000-2010 SIA Zabbix
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
**/
?>
<?php

if(!isset($DB)){
$DB = array();
if(isset($DB_TYPE)) $DB['TYPE'] = $DB_TYPE;
if(isset($DB_SERVER)) $DB['SERVER'] = $DB_SERVER;
if(isset($DB_PORT)) $DB['PORT'] = $DB_PORT;
if(isset($DB_DATABASE)) $DB['DATABASE'] = $DB_DATABASE;
if(isset($DB_USER)) $DB['USER'] = $DB_USER;
if(isset($DB_PASSWORD)) $DB['PASSWORD'] = $DB_PASSWORD;
}

function DBconnect(&$error){
$result = true;

global $DB;

$DB['DB'] = null;
$DB['TRANSACTIONS'] = 0;

//Stats
$DB['SELECT_COUNT'] = 0;
$DB['EXECUTE_COUNT'] = 0;

//SDI('type: '.$DB['TYPE'].'; server: '.$DB['SERVER'].'; port: '.$DB['PORT'].'; db: '.$DB['DATABASE'].'; usr: '.$DB['USER'].'
; pass: '.$DB['PASSWORD']);

if(!isset($DB['TYPE'])){
$error = "Unknown database type.";
$result = false;
}
else{
$DB['TYPE'] = zbx_strtoupper($DB['TYPE']);

switch($DB['TYPE']){
case 'MYSQL':
$mysql_server = $DB['SERVER'].( !empty($DB['PORT']) ? ':'.$DB['PORT'] : '');

if (!$DB['DB']= mysql_connect($mysql_server,$DB['USER'],$DB['PASSWORD'])){
$error = 'Error connecting to database ['.mysql_error().']';
$result = false;
}
else{
if (!mysql_select_db($DB['DATABASE'])){
$error = 'Error database selection ['.mysql_error().']';
$result = false;
}
else{
DBexecute('SET NAMES utf8');
DBexecute('SET CHARACTER SET utf8');
}
}
break;
case 'POSTGRESQL':
$pg_connection_string =
( !empty($DB['SERVER']) ? 'host=\''.$DB['SERVER'].'\' ' : '').
'dbname=\''.$DB['DATABASE'].'\' '.
( !empty($DB['USER']) ? 'user=\''.$DB['USER'].'\' ' : '').
( !empty($DB['PASSWORD']) ? 'password=\''.$DB['PASSWORD'].'\' ' : '').
( !empty($DB['PORT']) ? 'port='.$DB['PORT'] : '');

$DB['DB']= pg_connect($pg_connection_string);
if(!$DB['DB']){
$error = 'Error connecting to database';
$result = false;
}
break;
case 'ORACLE':
$connect = '';
if (!empty($DB['SERVER'])){
$connect = '//'.$DB['SERVER'];

if ($DB['PORT'] != '0')
$connect .= ':'.$DB['PORT'];

if ($DB['DATABASE'])
$connect .= '/'.$DB['DATABASE'];
}

$DB['DB']= ociplogon($DB['USER'], $DB['PASSWORD'], $connect);
// $DB['DB']= ociplogon($DB['USER'], $DB['PASSWORD'], '(DESCRIPTION=(ADDRESS=(PROTOCOL=T
CP)(HOST='.$DB['SERVER'].')(PORT=1521))(CONNECT_DATA=(SERVICE_NAME='.$DB['DATABASE'].')))');
if(!$DB['DB']){
$error = 'Error connecting to database';
$result = false;
}
break;
case 'SQLITE3':
$DB['TRANSACTIONS'] = 0;
if(!function_exists('init_db_access')){
function init_db_access(){
global $DB, $ZBX_SEM_ID;

$ZBX_SEM_ID = false;
if(function_exists('ftok') && function_exists('sem_get') && file_exis
ts($DB['DATABASE'])){
$ZBX_SEM_ID = sem_get(ftok($DB['DATABASE'], 'z'), 1);
}
}
}

if(!function_exists('lock_db_access')){
function lock_db_access(){
global $ZBX_SEM_ID;

if($ZBX_SEM_ID && function_exists('sem_acquire')){
sem_acquire($ZBX_SEM_ID);
}
}
}

if(!function_exists('unlock_db_access')){
function unlock_db_access(){
global $ZBX_SEM_ID;

if($ZBX_SEM_ID && function_exists('sem_release'))
sem_release($ZBX_SEM_ID);
}
}

if(!function_exists('free_db_access')){
function free_db_access(){
global $ZBX_SEM_ID;

if($ZBX_SEM_ID && function_exists('sem_remove'))
sem_remove($ZBX_SEM_ID);

$ZBX_SEM_ID = false;
}
}


if(file_exists($DB['DATABASE'])){
$DB['DB']= sqlite3_open($DB['DATABASE']);
if(!$DB['DB']){
$error = 'Error connecting to database';
$result = false;
}
}
else{
$error = 'Missing database';
$result = false;
}

init_db_access();
break;
default:
$error = 'Unsupported database';
$result = false;
}
}
if( false == $result )
$DB['DB']= null;

return $result;
}

function DBclose(){
global $DB;
$result = false;

if( isset($DB['DB']) && !empty($DB['DB']) ){
switch($DB['TYPE']){
case 'MYSQL':
$result = mysql_close($DB['DB']);
break;
case 'POSTGRESQL':
$result = pg_close($DB['DB']);
break;
case 'ORACLE':
$result = ocilogoff($DB['DB']);
break;
case 'SQLITE3':
$result = true;
sqlite3_close($DB['DB']);
free_db_access();
break;
default: break;
}
}

unset(
$GLOBALS['DB'],
$GLOBALS['DB_TYPE'],
$GLOBALS['DB_SERVER'],
$GLOBALS['DB_PORT'],
$GLOBALS['DB_DATABASE'],
$GLOBALS['DB_USER'],
$GLOBALS['DB_PASSWORD'],
$GLOBALS['SQLITE_TRANSACTION']
);

return $result;
}

function DBloadfile($file, &$error){
global $DB;

if(!file_exists($file)){
$error = 'DBloadfile. Missing file['.$file.']';
return false;
}

$fl = file($file);

foreach($fl as $n => $l) if(substr($l,0,2)=='--') unset($fl[$n]);

$fl = explode(";\n", implode("\n",$fl));
unset($fl[count($fl)-1]);

foreach($fl as $sql){
if(empty($sql)) continue;

if(!DBexecute($sql,0)){
$error = '';
return false;
}
}
return true;
}

function DBstart($strict=true){
global $DB;
//SDI('DBStart(): '.$DB['TRANSACTIONS']);
$DB['STRICT'] = $strict;

$DB['TRANSACTIONS']++;

if($DB['TRANSACTIONS']>1){
info('POSSIBLE ERROR: Used incorrect logic in database processing, started subtransaction!');
return $DB['TRANSACTION_STATE'];
}

$DB['TRANSACTION_STATE'] = true;

$result = false;
if(isset($DB['DB']) && !empty($DB['DB']))
switch($DB['TYPE']){
case 'MYSQL':
$result = DBexecute('begin');
break;
case 'POSTGRESQL':
$result = DBexecute('begin');
break;
case 'ORACLE':
$result = true;
// TODO OCI_DEFAULT
break;
case 'SQLITE3':
if(1 == $DB['TRANSACTIONS']){
lock_db_access();
$result = DBexecute('begin');
}
break;
}
return $result;
}


function DBend($result=null){
global $DB;
//SDI('DBend(): '.$DB['TRANSACTIONS']);
if($DB['TRANSACTIONS'] != 1){
$DB['TRANSACTIONS']--;

if($DB['TRANSACTIONS'] < 1){
$DB['TRANSACTIONS'] = 0;
$DB['TRANSACTION_STATE'] = false;
info('POSSIBLE ERROR: Used incorrect logic in database processing, transaction not started!')
;
}

if(!is_null($result))
$DB['TRANSACTION_STATE'] = $result && $DB['TRANSACTION_STATE'];

return $DB['TRANSACTION_STATE'];
}

$DB['TRANSACTIONS'] = 0;

if(is_null($result)){
$DBresult = $DB['TRANSACTION_STATE'];
}
else{
$DBresult = $result && $DB['TRANSACTION_STATE'];
}

//SDI('Result: '.$result);

if($DBresult){ // OK
$DBresult = DBcommit();
}

if(!$DBresult){ // FAIL
DBrollback();
}

$result = (!is_null($result) && $DBresult)?$result:$DBresult;

return $result;
}

function DBcommit(){
global $DB;

$result = false;
if( isset($DB['DB']) && !empty($DB['DB']) )
switch($DB['TYPE']){
case 'MYSQL':
$result = DBexecute('commit');
break;
case 'POSTGRESQL':
$result = DBexecute('commit');
break;
case 'ORACLE':
$result = ocicommit($DB['DB']);

break;
case 'SQLITE3':
$result = DBexecute('commit');
unlock_db_access();
break;
}

return $result;
}

function DBrollback(){
global $DB;

$result = false;
if( isset($DB['DB']) && !empty($DB['DB']) )
switch($DB['TYPE']){
case 'MYSQL':
$result = DBexecute('rollback');
break;
case 'POSTGRESQL':
$result = DBexecute('rollback');
break;
case 'ORACLE':
$result = ocirollback($DB['DB']);
break;
case 'SQLITE3':
$result = DBexecute('rollback');
unlock_db_access();
break;
}

return $result;
}

/* NOTE:
LIMIT and OFFSET records

Example: select 6-15 row.

MySQL:
SELECT a FROM tbl LIMIT 5,10
SELECT a FROM tbl LIMIT 10 OFFSET 5
PostgreSQL:
SELECT a FROM tbl LIMIT 10 OFFSET 5
Oracle:
SELECT a FROM tbe WHERE ROWNUM < 15 // ONLY < 15
SELECT * FROM (SELECT ROWNUM as RN, * FROM tbl) WHERE RN BETWEEN 6 AND 15
//*/

function &DBselect($query, $limit='NO', $offset=0){
global $DB;

$time_start=microtime(true);
$result = false;

if( isset($DB['DB']) && !empty($DB['DB']) ){
$DB['SELECT_COUNT']++;
//SDI('SQL['.$DB['SELECT_COUNT'].']: '.$query);
switch($DB['TYPE']){
case 'MYSQL':
if(zbx_numeric($limit)){
$query .= ' LIMIT '.intval($limit).' OFFSET '.intval($offset);
}

$result=mysql_query($query,$DB['DB']);
if(!$result){
error('Error in query ['.$query.'] ['.mysql_error().']');
}
break;
case 'POSTGRESQL':
if(zbx_numeric($limit)){
$query .= ' LIMIT '.intval($limit).' OFFSET '.intval($offset);
}

$result = pg_query($DB['DB'],$query);
if(!$result){
error('Error in query ['.$query.'] ['.pg_last_error().']');
}
break;
case 'ORACLE':
if(zbx_numeric($limit)){
$till = $offset + $limit;
$query = 'SELECT * FROM ('.$query.') WHERE rownum BETWEEN '.intval($offset).'
AND '.intval($till);
}

$result=OCIParse($DB['DB'],$query);
if(!$result){
$e=@ocierror();
error('SQL error ['.$e['message'].'] in ['.$e['sqltext'].']');
}
else if(!@OCIExecute($result,($DB['TRANSACTIONS']?OCI_DEFAULT:OCI_COMMIT_ON_SUCCESS))
){
$e=ocierror($result);
error('SQL error ['.$e['message'].'] in ['.$e['sqltext'].']');
}

break;
case 'SQLITE3':
if(!$DB['TRANSACTIONS']){
lock_db_access();
}

if(zbx_numeric($limit)){
$query .= ' LIMIT '.intval($limit).' OFFSET '.intval($offset);
}

if(!$result = sqlite3_query($DB['DB'],$query)){
error('Error in query ['.$query.'] ['.sqlite3_error($DB['DB']).']');
}
else{
$data = array();

while($row = sqlite3_fetch_array($result)){
foreach($row as $id => $name){
if(!zbx_strstr($id,'.')) continue;
$ids = explode('.',$id);
$row[array_pop($ids)] = $row[$id];
unset($row[$id]);
}
$data[] = $row;
}

sqlite3_query_close($result);

$result = &$data;
}
if(!$DB['TRANSACTIONS']){
unlock_db_access();
}
break;
}

if($DB['TRANSACTIONS'] && !$result){
$DB['TRANSACTION_STATE'] &= $result;
}
}
COpt::savesqlrequest(microtime(true)-$time_start,$query);

return $result;
}

function DBexecute($query, $skip_error_messages=0){
global $DB;
$result = false;

$time_start=microtime(true);
if( isset($DB['DB']) && !empty($DB['DB']) ){
$DB['EXECUTE_COUNT']++;
//SDI('SQL xec: '.$query);

switch($DB['TYPE']){
case 'MYSQL':
$result = mysql_query($query,$DB['DB']);
if(!$result){
error('Error in query ['.$query.'] ['.mysql_error().']');
}
break;
case 'POSTGRESQL':
$result = (bool) pg_query($DB['DB'],$query);
if(!$result){
error('Error in query ['.$query.'] ['.pg_last_error().']');
}
break;
case 'ORACLE':
$result=OCIParse($DB['DB'],$query);
if(!$result){
$e=@ocierror();
error('SQL error ['.$e['message'].'] in ['.$e['sqltext'].']');
}
else if(!@OCIExecute($result,($DB['TRANSACTIONS']?OCI_DEFAULT:OCI_COMMIT_ON_SUCCESS))
){
$e=ocierror($result);
error('SQL error ['.$e['message'].'] in ['.$e['sqltext'].']');
}
else{
/* It should be here. The function must return boolen */
$result = true;
}

break;
case 'SQLITE3':
if(!$DB['TRANSACTIONS']){
lock_db_access();
}

$result = sqlite3_exec($DB['DB'], $query);
if(!$result){
error('Error in query ['.$query.'] ['.sqlite3_error($DB['DB']).']');
}

if(!$DB['TRANSACTIONS']){
unlock_db_access();
}
break;
}

if($DB['TRANSACTIONS'] && !$result){
$DB['TRANSACTION_STATE'] &= $result;
}
}
COpt::savesqlrequest(microtime(true)-$time_start,$query);
return (bool) $result;
}

function DBfetch(&$cursor){
global $DB;

$result = false;

if(isset($DB['DB']) && !empty($DB['DB']))
switch($DB['TYPE']){
case 'MYSQL':
$result = mysql_fetch_assoc($cursor);
if(!$result){
mysql_free_result($cursor);
}
break;
case 'POSTGRESQL':
$result = pg_fetch_assoc($cursor);
if(!$result){
pg_free_result($cursor);
}
break;
case 'ORACLE':
if(ocifetchinto($cursor, $row, (OCI_ASSOC+OCI_RETURN_NULLS))){
$result = array();
foreach($row as $key => $value){
$field_type = zbx_strtolower(oci_field_type($cursor,$key));
$value = (str_in_array($field_type,array('varchar','varchar 2','blob','clob'))
&& is_null($value))?'':$value;

if(is_object($value) && (zbx_stristr($field_type, 'lob') !== false)){
$value = $value->load();
}

$result[zbx_strtolower($key)] = $value;
}
}
break;
case 'SQLITE3':
if($cursor){
$result = array_shift($cursor);
if(is_null($result)) $result = false;
}
break;
}
/*
if($result === false){
switch($DB['TYPE']){
case 'MYSQL': mysql_free_result($cursor); break;
case 'POSTGRESQL': pg_free_result($cursor); break;
case 'ORACLE': oci_free_statement($cursor); break;
}
}
//*/
return $result;
}

// string value prepearing
if(isset($DB['TYPE']) && $DB['TYPE'] == 'ORACLE') {
function zbx_dbstr($var){
if(is_array($var)){
foreach($var as $vnum => $value) $var[$vnum] = "'".preg_replace('/\'/','\'\'',$value)."'";
return $var;
}

return "'".preg_replace('/\'/','\'\'',$var)."'";
}

function zbx_dbcast_2bigint($field){
return ' CAST('.$field.' AS NUMBER(20)) ';
}
}
else if(isset($DB['TYPE']) && $DB['TYPE'] == "MYSQL") {
function zbx_dbstr($var){
if(is_array($var)){
foreach($var as $vnum => $value) $var[$vnum] = "'".mysql_real_escape_string($value)."'";
return $var;
}

return "'".mysql_real_escape_string($var)."'";
}

function zbx_dbcast_2bigint($field){
return ' CAST('.$field.' AS UNSIGNED) ';
}
}
else if(isset($DB['TYPE']) && $DB['TYPE'] == "POSTGRESQL") {
function zbx_dbstr($var){
if(is_array($var)){
foreach($var as $vnum => $value) $var[$vnum] = "'".pg_escape_string($value)."'";
return $var;
}

return "'".pg_escape_string($var)."'";
}

function zbx_dbcast_2bigint($field){
return ' CAST('.$field.' AS BIGINT) ';
}
}
else {
function zbx_dbstr($var){
if(is_array($var)){
foreach($var as $vnum => $value) $var[$vnum] = "'".addslashes($value)."'";
return $var;
}

return "'".addslashes($var)."'";
}

function zbx_dbcast_2bigint($field){
return ' CAST('.$field.' AS BIGINT) ';
}
}

function zbx_dbconcat($params){
global $DB;

switch($DB['TYPE']){
case "SQLITE3":
return implode(' || ',$params);
default:
return 'CONCAT('.implode(',',$params).')';
}
}

function zbx_sql_mod($x,$y){
global $DB;

switch($DB['TYPE']){
case "SQLITE3":
return ' ('.$x.' %% '.$y.')';
default:
return ' MOD('.$x.','.$y.')';
}
}

function DBid2nodeid($id_name){
global $DB;

switch($DB['TYPE']){
case "MYSQL":
$result = '('.$id_name.' div 100000000000000)';
break;
case "ORACLE":
$result = 'round('.$id_name.'/100000000000000)';
break;
default:
$result = '('.$id_name.'/100000000000000)';
}
return $result;
}

function id2nodeid($id_var){
return (int)bcdiv("$id_var",'100000000000000');
}

function DBin_node($id_name, $nodes = null){
if(is_null($nodes)) $nodes = get_current_nodeid();
else if(is_bool($nodes)) $nodes = get_current_nodeid($nodes);

if(empty($nodes)){
$nodes = array(0);
}
else if(!is_array($nodes)){
if(is_string($nodes)){
if(!preg_match('/^([0-9,]+)$/', $nodes))
fatal_error('Incorrect "nodes" for "DBin_node". Passed ['.$nodes.']');
}
else if(!zbx_ctype_digit($nodes)){
fatal_error('Incorrect type of "nodes" for "DBin_node". Passed ['.gettype($nodes).']');
}

$nodes = zbx_toArray($nodes);
}

$sql = '';
foreach($nodes as $nnum => $nodeid){
$sql.= '('.$id_name.' BETWEEN '.$nodeid.'00000000000000 AND '.$nodeid.'99999999999999)';
$sql.= ' OR ';
}

$sql = '('.trim($sql, 'OR ').')';
return $sql;
}

function in_node( $id_var, $nodes = null ){
if(is_null($nodes))
$nodes = get_current_nodeid();

if(empty($nodes))
$nodes = 0;

if(zbx_numeric($nodes)){
$nodes = array($nodes);
}
else if(is_string($nodes)){
if(!preg_match('/^([0-9,]+)$/', $nodes))
fatal_error('Incorrect "nodes" for "in_node". Passed ['.$nodes.']');

$nodes = explode(',', $nodes);
}
else if(!is_array($nodes)){
fatal_error('Incorrect type of "nodes" for "in_node". Passed ['.gettype($nodes).']');
}

return uint_in_array(id2nodeid($id_var), $nodes);
}

function get_dbid($table,$field){
// PGSQL on transaction failure on all queries returns false..
global $DB, $ZBX_LOCALNODEID;
if(($DB['TYPE'] == 'POSTGRESQL') && $DB['TRANSACTIONS'] && !$DB['TRANSACTION_STATE']) return 0;
//------
$nodeid = get_current_nodeid(false);

$found = false;
do{
$min=bcadd(bcmul($nodeid,'100000000000000'),bcmul( $ZBX_LOCALNODEID,'100000000000'));
$max=bcadd(bcadd(bcmul($nodeid,'100000000000000'), bcmul($ZBX_LOCALNODEID,'100000000000')),'999999999 9
9');
$row = DBfetch(DBselect('SELECT nextid FROM ids WHERE nodeid='.$nodeid .' AND table_name='.zbx_dbstr(
$table).' AND field_name='.zbx_dbstr($field)));
if(!$row){
$row = DBfetch(DBselect('SELECT max('.$field.') AS id FROM '.$table.' WHERE '.$field.'>='.$mi
n.' AND '.$field.'<='.$max));
if(!$row || is_null($row['id'])){
DBexecute("INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES ($nodeid,'$ta
ble','$field',$min)");
}
else{
/* $ret1 = $row["id"];
if($ret1 >= $max) {
"Maximum number of id's was exceeded"
}
//*/

DBexecute("INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES ($nodeid,'$ta
ble','$field',".$row['id'].')');
}
continue;
}
else{
$ret1 = $row['nextid'];
if((bccomp($ret1,$min) < 0) || !(bccomp($ret1,$max) < 0)) {
DBexecute('DELETE FROM ids WHERE nodeid='.$nodeid.' AND table_name='.zbx_dbstr($table
).' AND field_name='.zbx_dbstr($field));
continue;
}

$sql = 'UPDATE ids SET nextid=nextid+1 WHERE nodeid='.$nodeid.' AND table_name='.zbx_dbstr($t
able).' AND field_name='.zbx_dbstr($field);
DBexecute($sql);

$row = DBfetch(DBselect('SELECT nextid FROM ids WHERE nodeid='.$nodeid.' AND table_name='.zbx
_dbstr($table).' AND field_name='.zbx_dbstr($field)));
if(!$row || is_null($row["nextid"])){
// Should never be here
continue;
}
else{
$ret2 = $row["nextid"];
if(bccomp(bcadd($ret1,1),$ret2) == 0){
$found = true;
}
}
}
}
while(false == $found);

return $ret2;
}

function create_id_by_nodeid($id,$nodeid=0){

global $ZBX_LOCALNODEID;
$nodeid = ($nodeid == 0)?get_current_nodeid(false):$nodeid;

$id=remove_nodes_from_id($id);
$id=bcadd($id,bcadd(bcmul($nodeid,'100000000000000 '),bcmul($ZBX_LOCALNODEID,'100000000000')));
return $id;
}

function remove_nodes_from_id($id){
return bcmod($id,'100000000000');
}

function check_db_fields(&$db_fields, &$args){
if(!is_array($args)) return false;

foreach($db_fields as $field => $def){
if(!isset($args[$field])){
if(is_null($def)){
return false;
}
else{
$args[$field] = $def;
}
}
}
return true;
}

function DBcondition($fieldname, &$array, $notin=false, $string=false){
global $DB;
$condition = '';

if(!is_array($array)){
info('DBcondition Error: ['.$fieldname.'] = '.$array);
$array = explode(',',$array);
if(empty($array))
return ' 1=0 ';
}

$in = $notin?' NOT IN ':' IN ';
$concat = $notin?' AND ':' OR ';

switch($DB['TYPE']) {
case 'SQLITE3':
case 'MYSQL':
case 'POSTGRESQL':
case 'ORACLE':
default:
$items = array_chunk($array, 950);
foreach($items as $id => $values){
if($string) $values = zbx_dbstr($values);

$condition.=!empty($condition)?')'.$concat.$fieldn ame.$in.'(':'';
$condition.= implode(',',$values);
}
break;
}

if(zbx_empty($condition)) $condition = $string?"'-1'":'-1';

return ' ('.$fieldname.$in.'('.$condition.')) ';
}

?>

[MrKen]

locate zabbix.conf.php

then check the db details in there.

[tchjts1]

/etc/php.ini[/B]
date.timezone = "Asia/Kuala_Lumpur"

This is minor, but I would remove the quotation marks around "Asia/Kuala_Lumpur" and restart httpd. I seem to recall where someone else here had some issues while using quotations around the location in php.ini

[zabbixnewbie]

locate zabbix.conf.php

then check the db details in there.

My machine have 2 places have the files;
/usr/local/apache2/htdocs/zabbix/conf/zabbix.conf.php
/home/zabbix/public_html/conf/zabbix.conf.php
/zabbix-1.8.2/frontends/php/conf/zabbix.conf.php

I think inside the /usr is the correct file, right?
<?php
/*
** ZABBIX
** Copyright (C) 2000-2005 SIA Zabbix
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
**/

global $DB;

$DB["TYPE"] = "MYSQL";
$DB["SERVER"] = "localhost";
$DB["PORT"] = "0";
$DB["DATABASE"] = "zabbix";
$DB["USER"] = "zabbix";
$DB["PASSWORD"] = "zabbix_password";
$ZBX_SERVER = "localhost";
$ZBX_SERVER_PORT = "10051";
$ZBX_SERVER_NAME = "";

$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
?>

[MrKen]

/etc/zabbix/zabbix_server.conf
PidFile=/tmp/zabbix_server.pid
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBSocket=/tmp/mysql.sock

The details in zabbix_server.conf need to be exactly the same as in zabbix.conf.php

Above, you have DBPassword=zabbix
but in zabbix.conf.php you have Password=zabbix_password

Edit zabbix.conf.php to have the same password, and also I would change $ZBX_SERVER = "localhost"; to the correct IP Address.

Also, be sure that your DBUser has the correct permissions to the database:

mysql> GRANT DROP,INDEX,CREATE,SELECT,INSERT,UPDATE,ALTER,DELET E ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'zabbix';

MrKen

[zabbixnewbie]

The details in zabbix_server.conf need to be exactly the same as in zabbix.conf.php

Above, you have DBPassword=zabbix
but in zabbix.conf.php you have Password=zabbix_password

Edit zabbix.conf.php to have the same password, and also I would change $ZBX_SERVER = "localhost"; to the correct IP Address.

Also, be sure that your DBUser has the correct permissions to the database:

mysql> GRANT DROP,INDEX,CREATE,SELECT,INSERT,UPDATE,ALTER,DELET E ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'zabbix';

MrKen

Thanks Mr.Ken.
I manage to get to it. But at the bottom has a n error
"Fatal error: Call to undefined function bccomp() in /usr/local/apache2/htdocs/zabbix/include/func.inc.php on line 878"

After I login it prompt me
"Fatal error: Call to undefined function bcadd() in /usr/local/apache2/htdocs/zabbix/include/db.inc.php on line 750"

What is this all about?

[MrKen]

Those errors have something to do with bcmath.

Try: yum resolvedep php*

After you log in to the frontend, be sure to go to Administration --> Installation and run through the pre-req checklist. But first, resolve your php problem.

[zabbixnewbie]

Those errors have something to do with bcmath.

Try: yum resolvedep php*

After you log in to the frontend, be sure to go to Administration --> Installation and run through the pre-req checklist. But first, resolve your php problem.

Whats your suggestion if my machine dont have live connection to internet that yum cannot be done?