Ad Widget

**hispan1c** · 12-08-2009, 18:41

Hi John,

First of all, thanks a lot for making such a great tutorial, its really easy to understand even for a newbie

I setup a machine and did exactly what you have written, but when i get to this point :

sudo -u postgres psql postgres

sudo: no passwd entry for postgres

I think my server is saying that the "user" postgres is not existing or something? Should i have created that user account?

When i try this command with an admin account it says :
sudo -u zabbixadmin psql postgres

psql: could not connect to server

what am i doing wrong?

How can i check that postgres is running?

**johnusa** · 13-08-2009, 07:51

I too am a newbie which is why I wrote up, as best I could, what finally worked. I had terrible problems here as well so it took a while and got kind of confusing. postgres is the database administrator which is created when postgres is installed.
The trick is to get into the sql management as postgres and create the database zabbix and create a database user for it. I think the trick was logging in as root, then
sudo -u postgres psql postgres
\password postgres
TYPE IN THE NEW PASSWORD
\q
sudo -u postgres createuser --superuser zabbix
sudo -u postgres createdb zabbix

I was kept the user names for linux and the database the same and with the same passwords so that they might work in unison.

**hispan1c** · 16-08-2009, 01:09

Thanks for you reply, i found out what the problem was.

I installed the following package as you wrote in your tutorial :
sudo apt-get install postgresql-server-dev-8.3

But that isnt really the database server, just the development files.

to install the postgres database you have to install the following package :
sudo apt-get install postgresql

after i did this all worked properly

i think you made a small typo there in your tut

cheers

**johnusa** · 17-08-2009, 08:30

I installed PostgreSQL during the Ubuntu 9.04 server installation (ISO file).

"with: OpenSSH Server (for Putty and WinSCP) and PostgreSQL"

**hispan1c** · 18-08-2009, 01:35

My bad, i installed the desktop version of Ubuntu

The zabbix server is running smooth! cheers!

**russhenry715** · 24-08-2009, 14:05

Server not running

i have completed the above directions and i still can not get the following fixed

Parameter / Value / Details
ZABBIX server is running / No / -

I am not sure what i am doing wrong, i have checked all the above multiple times and still no luck, any help would be great - i am pretty sure i am doing something silly

Server = Ubuntu 9.04 x64
Zabbix = Zabbix 1.65
PostgreSQL 8.3.7

I have tried to reinstall a few times thinking that i missed a step, this is a fresh install

RH

**johnusa** · 24-08-2009, 14:50

A newer version of the Instructions

Install Ubuntu 9.04 (Jaunty)
IP = xxx.xxx.xxx.xxx
USER: zabbix / password123 ; this user matches PostGresSQL user zabbix
with: OpenSSH Server (for Putty and WinSCP) and PostgreSQL

LOGIN on as zabbix
sudo passwd root ( rootpass123 ) ; Set your own Root Password

reboot now

LOGIN on as root ; not necessary but I use root...
apt-get update
apt-get dist-upgrade
apt-get install gnustep-make
apt-get install build-essential

apt-get install linux-headers-$(uname -r)
aptitude install ntp ntp-simple ntpdate ; Time server service
Change/Add in file: /etc/ntp.conf ; I used WinSCP
server xxx.xxx.xxx.xxx.xxx ; local NTP server1

server xxx.xxx.xxx.xxx.xxx ; local NTP server2
/etc/init.d/ntp restart
reboot now

LOGIN on as zabbix
sudo apt-get install apache2
sudo apt-get install postgresql-server-dev-8.3

sudo apt-get install php5 php5-gd php5-pgsql snmp libsnmp-dev snmpd libcurl4-openssl-dev fping
sudo apt-get install libiksemel3 libiksemel-dev
sudo apt-get install phppgadmin
reboot now

LOGIN on as root
sudo -u postgres psql postgres
\password postgres
password123
\q
; Linux and Postgres Usernames (both = zabbix) are the same so they can work in unison

sudo -u postgres createuser --superuser zabbix
sudo -u postgres createdb zabbix
reboot now
================ Now you can login to psql without sudo... SEE: https://help.ubuntu.com/community/PostgreSQL

; Download Zabbix, I used my browser and WinSCP, place in /home/zabbix

LOGIN on as zabbix
tar zxvpf zabbix-1.6.5.tar.gz
cd zabbix-1.6.5/create/schema

cat postgresql.sql | psql zabbix
cd ../data
cat data.sql | psql zabbix
cat images_pgsql.sql | psql zabbix
cd ..
cd ..
sudo ./configure --enable-server --enable-agent --with-pgsql --with-net-snmp -with-jabber=/usr/ -with-libcurl # for PostgreSQL + Jabber + WEB monitoring

sudo make install

sudo nano /etc/services ; open zabbix's ports
Add at the end:
zabbix_agent 10050/tcp # Zabbix ports
zabbix_trap 10051/tcp

sudo mkdir /etc/zabbix
sudo chown -R zabbix.zabbix /etc/zabbix/
cp misc/conf/zabbix_* /etc/zabbix/

nano /etc/zabbix/zabbix_agentd.conf
Make sure that the Server parameter points to the server address, for the agent that runs on the

server it is like this: Server=127.0.0.1 change to xxx.xxx.xxx.xxx
AND REMOVE # from ListenIP=127.0.0.1 AND CHANGE IT to ListenIP=xxx.xxx.xxx.xxx

nano /etc/zabbix/zabbix_server.conf

For small sites this default file will do, however if you are into tweaking your config for your 10+ hosts site, this is the place.
Change this:
# Database user
DBUser=zabbix
# Database password

# Comment this line if no password used
DBPassword=password123
AND REMOVE # from ListenIP=127.0.0.1 AND CHANGE IT to ListenIP=10.20.10.239

sudo cp misc/init.d/debian/zabbix-server /etc/init.d

sudo cp misc/init.d/debian/zabbix-agent /etc/init.d

sudo nano /etc/init.d/zabbix-server ; change of destination path for later versions of Ubuntu...
Look for the following line:

DAEMON=/home/zabbix/bin/${NAME}
and replace it with:
DAEMON=/usr/sbin/${NAME} (old versions use /usr/bin/${NAME})
sudo nano /etc/init.d/zabbix-agent
***** DO THE SAME AGAIN LIKE ABOVE WITH FILE: zabbix-server

sudo chmod 755 /etc/init.d/zabbix-server
sudo update-rc.d zabbix-server defaults
sudo chmod 755 /etc/init.d/zabbix-agent
sudo update-rc.d zabbix-agent defaults

sudo /etc/init.d/zabbix-server start
sudo /etc/init.d/zabbix-agent start
ps -aux | grep zabbix
cd /home/zabbix/zabbix-1.6.5/
mkdir /home/zabbix/public_html
cp -R frontends/php/* /home/zabbix/public_html/

sudo nano /etc/apache2/sites-enabled/000-default ; Zabbix is default site
REPLACE: ====================================
DocumentRoot /var/www
<Directory />

Options FollowSymLinks
AllowOverride None
</Directory>
<Directory /var/www/>
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny

allow from all
</Directory>
REPLACE: ====================================
WITH: ====================================
DocumentRoot /home/zabbix/public_html
<Directory /home/zabbix/public_html>

AllowOverride FileInfo AuthConfig Limit Indexes
Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec
<Limit GET POST OPTIONS PROPFIND>
Order allow,deny
Allow from all

</Limit>
<LimitExcept GET POST OPTIONS PROPFIND>
Order deny,allow
Deny from all
</LimitExcept>
</Directory>
WITH: ====================================

sudo nano /etc/php5/apache2/php.ini
Change the following values:
max_execution_time = 300 ; Maximum execution time of each script, in seconds
date.timezone = Europe/Copenhagen ; Choose your time zone and remove the semi-colon...

sudo nano /usr/share/phppgadmin/conf/config.inc.php ; login for postgres user allowed in the Web-Admin module...
CHANGE:
$conf['extra_login_security'] = true;
TO:

$conf['extra_login_security'] = false;

sudo nano /etc/phppgadmin/apache.conf
CHANGE:
deny from all
TO:
allow from all

sudo /etc/init.d/apache2 restart OR reboot now

LOG ON to Zabbix: http://xxx.xxx.xxx.xxx --- Admin / zabbix
In ZABBIX: Configuration / Hosts / Zabbix server should be xxx.xxx.xxx.xxx instead of for 127.0.0.1

LOG ON to PostGreSQL Admin: http://xxx.xxx.xxx.xxx/phppgadmin --- postgres / password123

**russhenry715** · 24-08-2009, 18:44

errors

I reloaded the server with the above steps and i am getting a few errors
The ip that i used for xxx.xxx.xxx.xxx is the ip of my nic on the server
During the installation web frt sql wanted localhost, other than that i used the ip

Thanks again for the help

zabbix@net1:~/downloads/zabbix-1.6.5$ sudo update-rc.d zabbix-server defaults
update-rc.d: warning: /etc/init.d/zabbix-server missing LSB information
update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
Adding system startup for /etc/init.d/zabbix-server ...
/etc/rc0.d/K20zabbix-server -> ../init.d/zabbix-server
/etc/rc1.d/K20zabbix-server -> ../init.d/zabbix-server
/etc/rc6.d/K20zabbix-server -> ../init.d/zabbix-server
/etc/rc2.d/S20zabbix-server -> ../init.d/zabbix-server
/etc/rc3.d/S20zabbix-server -> ../init.d/zabbix-server
/etc/rc4.d/S20zabbix-server -> ../init.d/zabbix-server
/etc/rc5.d/S20zabbix-server -> ../init.d/zabbix-server

zabbix@net1:~/downloads/zabbix-1.6.5$ sudo update-rc.d zabbix-agent defaults
update-rc.d: warning: /etc/init.d/zabbix-agent missing LSB information
update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
Adding system startup for /etc/init.d/zabbix-agent ...
/etc/rc0.d/K20zabbix-agent -> ../init.d/zabbix-agent
/etc/rc1.d/K20zabbix-agent -> ../init.d/zabbix-agent
/etc/rc6.d/K20zabbix-agent -> ../init.d/zabbix-agent
/etc/rc2.d/S20zabbix-agent -> ../init.d/zabbix-agent
/etc/rc3.d/S20zabbix-agent -> ../init.d/zabbix-agent
/etc/rc4.d/S20zabbix-agent -> ../init.d/zabbix-agent
/etc/rc5.d/S20zabbix-agent -> ../init.d/zabbix-agent

**russhenry715** · 24-08-2009, 19:02

here are my scripts just in case

nano /etc/init.d/zabbix-server

#! /bin/sh
#
# Zabbix daemon start/stop script.
#
# Written by Alexei Vladishev <[email protected]>.

NAME=zabbix_server
PATH=/bin:/usr/bin:/sbin:/usr/sbin:/home/zabbix/bin
DAEMON=/usr/sbin/${NAME}
DESC="Zabbix server daemon"
PID=/var/tmp/$NAME.pid

test -f $DAEMON || exit 0

set -e

case "$1" in
start)
echo "Starting $DESC: $NAME"
start-stop-daemon --oknodo --start --pidfile $PID \
--exec $DAEMON
;;
stop)
echo "Stopping $DESC: $NAME"
start-stop-daemon --oknodo --stop --pidfile $PID \
--exec $DAEMON
;;
restart|force-reload)
#
# If the "reload" option is implemented, move the "force-reload"
# option to the "reload" entry above. If not, "force-reload" is
# just the same as "restart".
#
# echo -n "Restarting $DESC: zabbix_server"
$0 stop
$0 start
# start-stop-daemon --stop --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# sleep 1
# start-stop-daemon --start --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# echo "$NAME."
;;
*)
N=/etc/init.d/$NAME
# echo "Usage: $N {start|stop|restart|force-reload}" >&2
echo "Usage: $N {start|stop|restart|force-reload}" >&2
exit 1
;;
esac

exit 0

nano /etc/init.d/zabbix-agent

#! /bin/sh
#
# Zabbix agent start/stop script.
#
# Written by Alexei Vladishev <[email protected]>.

NAME=zabbix_agentd
PATH=/bin:/usr/bin:/sbin:/usr/sbin:/home/zabbix/bin
DAEMON=/usr/sbin/${NAME}
DESC="Zabbix agent daemon"
PID=/var/tmp/$NAME.pid

test -f $DAEMON || exit 0

set -e

case "$1" in
start)
echo "Starting $DESC: $NAME"
start-stop-daemon --oknodo --start --pidfile $PID \
--exec $DAEMON
;;
stop)
echo "Stopping $DESC: $NAME"
start-stop-daemon --oknodo --stop --pidfile $PID \
--exec $DAEMON
;;
restart|force-reload)
#
# If the "reload" option is implemented, move the "force-reload"
# option to the "reload" entry above. If not, "force-reload" is
# just the same as "restart".
#
# echo -n "Restarting $DESC: zabbix_agent"
$0 stop
$0 start
# start-stop-daemon --stop --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# sleep 1
# start-stop-daemon --start --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# echo "$NAME."
;;
*)
N=/etc/init.d/$NAME
# echo "Usage: $N {start|stop|restart|force-reload}" >&2
echo "Usage: $N {start|stop|restart|force-reload}" >&2
exit 1
;;
esac

exit 0

**russhenry715** · 26-08-2009, 20:50

I was wondering if anyone knew what the fix was for the above?

Thanks

**johnusa** · 27-08-2009, 13:07

I Googled: missing LSB information ubuntu and found some
subjects about some bugs, so from: root check or run

apt-get upgrade
apt-get dist-upgrade

================================================== =======
Here is a copy of my files if that helps
================================================== =======
sudo cp misc/init.d/debian/zabbix-server /etc/init.d
sudo cp misc/init.d/debian/zabbix-agent /etc/init.d

sudo nano /etc/init.d/zabbix-server SEE BELOW 1

sudo nano /etc/init.d/zabbix-agent SEE BELOW 2

sudo chmod 755 /etc/init.d/zabbix-server
sudo update-rc.d zabbix-server defaults

sudo chmod 755 /etc/init.d/zabbix-agent
sudo update-rc.d zabbix-agent defaults

================================================== =======
BELOW 1
================================================== =======
#! /bin/sh
#
# Zabbix daemon start/stop script.
#
# Written by Alexei Vladishev <[email protected]>.

NAME=zabbix_server
PATH=/bin:/usr/bin:/sbin:/usr/sbin:/home/zabbix/bin
DAEMON=/usr/sbin/${NAME}
DESC="Zabbix server daemon"
PID=/var/tmp/$NAME.pid

test -f $DAEMON || exit 0

set -e

case "$1" in
start)
echo "Starting $DESC: $NAME"
start-stop-daemon --oknodo --start --pidfile $PID \
--exec $DAEMON
;;
stop)
echo "Stopping $DESC: $NAME"
start-stop-daemon --oknodo --stop --pidfile $PID \
--exec $DAEMON
;;
restart|force-reload)
#
# If the "reload" option is implemented, move the "force-reload"
# option to the "reload" entry above. If not, "force-reload" is
# just the same as "restart".
#
# echo -n "Restarting $DESC: zabbix_server"
$0 stop
$0 start
# start-stop-daemon --stop --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# sleep 1
# start-stop-daemon --start --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# echo "$NAME."
;;
*)
N=/etc/init.d/$NAME
# echo "Usage: $N {start|stop|restart|force-reload}" >&2
echo "Usage: $N {start|stop|restart|force-reload}" >&2
exit 1
;;
esac

exit 0
================================================== =======
END BELOW 1
================================================== =======

================================================== ==================
BELOW 2
================================================== ==================
#! /bin/sh
#
# Zabbix agent start/stop script.
#
# Written by Alexei Vladishev <[email protected]>.

NAME=zabbix_agentd
PATH=/bin:/usr/bin:/sbin:/usr/sbin:/home/zabbix/bin
DAEMON=/usr/sbin/${NAME}
DESC="Zabbix agent daemon"
PID=/var/tmp/$NAME.pid

test -f $DAEMON || exit 0

set -e

case "$1" in
start)
echo "Starting $DESC: $NAME"
start-stop-daemon --oknodo --start --pidfile $PID \
--exec $DAEMON
;;
stop)
echo "Stopping $DESC: $NAME"
start-stop-daemon --oknodo --stop --pidfile $PID \
--exec $DAEMON
;;
restart|force-reload)
#
# If the "reload" option is implemented, move the "force-reload"
# option to the "reload" entry above. If not, "force-reload" is
# just the same as "restart".
#
# echo -n "Restarting $DESC: zabbix_agent"
$0 stop
$0 start
# start-stop-daemon --stop --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# sleep 1
# start-stop-daemon --start --quiet --pidfile \
# /tmp/$NAME.pid --user zabbix --exec $DAEMON
# echo "$NAME."
;;
*)
N=/etc/init.d/$NAME
# echo "Usage: $N {start|stop|restart|force-reload}" >&2
echo "Usage: $N {start|stop|restart|force-reload}" >&2
exit 1
;;
esac

exit 0
================================================== =======
END BELOW 2
================================================== =======

**russhenry715** · 27-08-2009, 16:56

I am still getting the same error

update-rc.d: warning: /etc/init.d/zabbix-agent missing LSB information

what version of ubuntu are u using? I have ubuntu 9.04 x64 installed with all updates

**johnusa** · 28-08-2009, 14:35

The Same
Install Ubuntu Server 9.04 (Jaunty) 64-bit ; ubuntu-9.04-server-amd64.iso

Try:
sudo cp /home/zabbix/zabbix-1.6.6/src/zabbix_agent/zabbix_agent /usr/sbin/
sudo cp /home/zabbix/zabbix-1.6.6/src/zabbix_agent/zabbix_agentd /usr/sbin/
sudo cp /home/zabbix/zabbix-1.6.6/src/zabbix_get/zabbix_get /usr/sbin/
sudo cp /home/zabbix/zabbix-1.6.6/src/zabbix_sender/zabbix_sender /usr/sbin/
sudo cp /home/zabbix/zabbix-1.6.6/src/zabbix_server/zabbix_server /usr/sbin/

sudo /etc/init.d/zabbix-server start
sudo /etc/init.d/zabbix-agent start
ps aux | grep zabbix ; check running zabbix services

**russhenry715** · 31-08-2009, 02:03

I finnaly got the server to start, found out the db had a connection error

the next problem i am having is the server agent is showing offline, any ideas to correct this?

here is the log file from /tmp/zabbix_agentd.log
4167:20090830:183355 zabbix_agentd started. ZABBIX 1.6.6 (revision 7836).
4168:20090830:183355 zabbix_agentd collector started
4170:20090830:183355 zabbix_agentd listener started
4171:20090830:183355 zabbix_agentd listener started
4172:20090830:183355 zabbix_agentd listener started
4173:20090830:183355 zabbix_agentd active check started [192.168.1.101:10051]

Ad Widget

Example of Zabbix 1.6.5 installation on a Ubuntu 9.04 (Jaunty) server.

Example of Zabbix 1.6.5 installation on a Ubuntu 9.04 (Jaunty) server.

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment