Problems on installation of Zabbix 1.6 on Debian Etch

[gabrielnoc]

Hello people.

I'm getting a couple of errors while installing zabbix. I've already configured it and compiled it. But when I try to go to http://ip/zabbix/ there are a lot of errors on screen. I will put them here and some screenshots too. I've already configured the DB(MYSQL).

First on login screen:

Error in query [select * from rights where userid=2] [Unknown column 'userid' in 'where clause']
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/share/zabbix/include/db.inc.php on line 104

After login > Monitoring > Triggers:

SQL error: Unknown column 'value' in 'field list'
Query: insert into profiles (userid,idx,value,valuetype) values (1,'web.tr_status.hostid','0',0)
SQL error: Unknown column 'value' in 'field list'
Query: insert into profiles (userid,idx,value,valuetype) values (1,'web.tr_status.groupid','0',0)

I don't know what to do anymore. If anyone has a light to give me, I would appreciate.

Another thing that when I compiled it, it didn't create the zabbix_server.conf in the appropriate folder. So I copied from the source to the folder, so I could run the executable(./zabbix_server). Otherwise it didn't run.



Thanks.

[Aly]

If You have installed zabbix 1.6, then why you're trying to connect to zabbix with frontend from zabbix1.1.4?

[gabrielnoc]

I really don't know. It's my 1st time installing Zabbix. I use another softwares here where I work, like Nagios and BigBrother. I'm installing Zabbix to use the SLA feature.

I followed these steps to install:

http://blog.brendon.com/unix/installing-zabbix-v161-on-debian-etch/

But after step 5 it didn't make any sense to me. I jumped to the documentation that says to run ./configure (options) and ./make install

If you could explain me more about that or ask something it would help.

[gabrielnoc]

I think I understand what you talked about.

I just made a fresh install. Deleted all zabbix files that I installed and badaboom, no GUI @ http://ip/zabbix

Now I configured and did a make install. Copied files from zabbix-1.6.1/frontends/php/* to /var/www/zabbix. Then I put it on httpd.conf of apache2:

Alias /zabbix "/var/www/zabbix"

<Directory "/var/www/zabbix">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>

But nothing yet. I'll keep trying.

Edit: Woo, I think I got something working now. I restarted apache and an installation screen appeared, with some errors:

* Undefined index: TYPE[/var/www/zabbix/include/db.inc.php:606]
* Undefined index: TYPE[/var/www/zabbix/include/db.inc.php:606]
* Timezone for PHP is not set. Please set "date.timezone" option in php.ini.

[gabrielnoc]

Ok, I solved it. After you telling me I was on frontend 1.1.4 opened my mind.

After all of this, I added in db.inc.php this:

$DB_TYPE ="MYSQL";
$DB_SERVER ="localhost";
$DB_DATABASE ="zabbix";
$DB_USER ="root";
$DB_PWD ="password";

and changed the date.timezone in php.ini.

It's working now