Login Problem

[byqsri]

Hi
I'm newbie of zabbix.
I tried to install Zabbix.
The installation is gone ok but when I try to login from web I get this error:


"Error in query [select * from rights where userid=1] [Unknown colums 'userid' in where clause] ".

I think that the problem is about the database but I don't know what I can do.
Can someone help me?
Many Thanks
Marco

[marc]

seems like you haven't settled database correctly.
do the following... on mysql server..
mysql -uroot -Dzabbix; (if you have another username/password) change line
show tables;
there should be about 66 tables

desc users;
it should show you all columns from table users. first row is userid btw.

if you have verified your database is not settled correct. ^ above commands wont show you the expected results... start from scretch.

1.) read manual about setup
2.) in mysql
- drop database zabbix;
- create dataase zabbix;
3.) in zabbix-1.x.x directory
- cat create/schema/mysql.sql | mysql -uroot -pyourpasswd -Dzabbix
- cat create/data/data.sql | mysql -uroot -pyourpasswd -Dzabbix
- car create/data/images_mysql.sql | mysql -uroot -pyourpasswd -Dzabbix
4.) go to webinterface and proceed as described in manual.

hf.
marc

[byqsri]

I have checked the database structure and for me the problem is in the table "rights" where there isn't the "userid" coloumn.
However I have reloaded the database following the manual but the problem is the same.
Can you post me the right structure of the database?
Many Thanks
Marco

[byqsri]

Can anyone pass me the right schema of the database of Zabbit for MySql?
And the initial data to load?
I hope anyone help me
Many thanks
Marco

[byqsri]

It's very important to me to have Zabbix works fine
Can anyone help me giving me the correct database structure and the data to insert.
I have looked for in the older version but the database is different.
Many thanks
Marco

[Aly]

(MySQL) For zabbix 1.4.2 it's:

CREATE TABLE rights (
rightid bigint(20) unsigned NOT NULL default '0',
groupid bigint(20) unsigned NOT NULL default '0',
`type` int(11) NOT NULL default '0',
permission int(11) NOT NULL default '0',
id bigint(20) unsigned default NULL,
PRIMARY KEY (rightid),
KEY rights_1 (groupid)
) TYPE=InnoDB;

[byqsri]

I have this schema for 'rights' table but I get the error when i try to log from php:

Error in query [select * from rights where userid=1] [Unknown colums 'userid' in where clause]

[Aly]

What version of Zabbix you have installed?

P.S. try to use frontend from Nightly Build link

[byqsri]

I have installed the 1.4.1 on debian with Mysql 5.0 ,Apache 2 and php 5.3.
I have used the Sql file of these version.

[byqsri]

I have installed zabbix with the apt system of debian.

[Aly]

I have checked 1.3.8 and 1.4.x , none of them have that query in login script.

[byqsri]

I have found the problem. Using debian's apt system I install the version 1.1.4 of Zabbix not the version 1.4.1.
Sorry, Im very afraid.
Is it possible install the version 1.4.2 with apt system?
Many Thanks