Permissions issue

[Alexei]

What's your version of MySQL?

[peacestgt]

client:
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
server:
mysqld Ver 4.0.24_Debian-10sarge2-log for pc-linux-gnu on i386 (Source distribution)


Server version: Apache/2.0.54
Server built: Jul 28 2006 09:04:55

PHP 4.3.10-18 (cli) (built: Nov 3 2006 21:56:29)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

[peacestgt]

solution:

update to mysql 4.1.x
( mysql-server-4.1_4.1.11a-4sarge7_i386.deb )
and no problems )

[cptnzod]

Thank you for responding. However this did not help. If you are refering to selinux, I am not running it. I typped the command setenforce anyway and still have the problem. I searched the forum for 4 hours and tried all the suggestions and still cannot login as Admin!

Any other idea? I am so close to get this into production.

[Alexei]

Any other idea? I am so close to get this into production.

Hey... This is BETA and this release is not for use in production!

[Lovespider]

Try changing the 'div' operator to '/'.
However in my Debian distribution, I upgraded MySQL to solve this.

[cptnzod]

I am about to give up on this. I changed the div to / in db.inc.php. I am still getting the same error: [ERROR: Login name or password is incorrect]
I know the user is there and the MD5 password checks out as well. Any ideas before I punt?

thx

[cptnzod]

Well I guess its a punt. I will see if I can get the older revisions working.

[smoker]

Well I guess its a punt. I will see if I can get the older revisions working.

Has anybody else seen this issue?
I am currently running a zabbix 1.1.4 server and I have installed zabbix 1.3.2 along side it to see about moving to 1.4 once it is out.

I get the same password error as described by the above posts.

Running RH ES4 with mysql 4.1.20, with a new db and location for zabbix 1.3.2.

Not sure what other details would be of use, be delighted to provide details on request.

btw... Everybody loves Zabbix.

[nickp]

database corrupted message

Hi

I still get the index.php?message=Database%20corrupted,%20missed%2 0default%20user%20'guest'
message after changing the db.inc.php

Restarted services, even rebooted..

Am i missing something here?

[richlv]

1.3.8 on sles 10.
all checks in the installer are passed succesfully, but after clicking on "finish" i get a loop on url : http://10.196.5.14/zabbix/index.php?message=Database%20corrupted,%20missed%2 0default%20user%20'guest'

opera times out on this url, konqueror loops indefinitely (i don't get any message, just a blank page).

page source just has :
<script language="JavaScript" type="text/javascript">
<!--
window.location = 'index.php?message=Database corrupted, missed default user \'guest\'';
//-->
</script>

this is a completely fresh installation of operating system, db (mysql 5.0.18) and zabbix. both schema and data (and images, too) were imported succesfully.

any ideas ?

EDIT :

hmm. examining users table, it indeed did not contain guest user. which is weird, as data import went without any errors. adding that user manually opens the login window finally...

i will have to investigate this further tomorrow, though.

[richlv]

that's what i get for having fancy installation scripts. the script deleted guest user after importing the db. previous version did not complain about that

[cyc]

No users in user table

Hello,

I have exactly the same problem with the 1.4 version ... zabbix loops and reloads the url ...index.php?message=Database%20corrupted,%20misse d%20default%20user%20'guest'

I've looked into the zabbix database and found out, that the users table is without any rows at all. So is the "rights" table. I suspect I've missed some part of installation, but I cannot figure it out. The *sql script for generating database is without string "guest", so - from where could this guest user be inserted into the zabbix database?
And, being the users and rights tables completely empty - this means I don't have an admin user either, right?

The installation process went fine, at least it looked like it was OK. The part with setup.php had a happy end

Any clue what should I do? I've created a row with "guest" in the name field, the password was left blank. That didn't change anything

[Foxi]

Hello,

I have exactly the same problem with the 1.4 version ... zabbix loops and reloads the url ...index.php?message=Database%20corrupted,%20misse d%20default%20user%20'guest'

I've looked into the zabbix database and found out, that the users table is without any rows at all. So is the "rights" table. I suspect I've missed some part of installation, but I cannot figure it out. The *sql script for generating database is without string "guest", so - from where could this guest user be inserted into the zabbix database?
And, being the users and rights tables completely empty - this means I don't have an admin user either, right?

The installation process went fine, at least it looked like it was OK. The part with setup.php had a happy end

Any clue what should I do? I've created a row with "guest" in the name field, the password was left blank. That didn't change anything

Hi,
Zabbix loops because you didn't insert default configuration.
Loot at Zabbix 1.4 manual page 37 :

"ZABBIX comes with SQL scripts used to create the required database schema and also to insert a default configuration. There are separate scripts for MySQL and PostgreSQL.
For MySQL:
shell> mysql -u<username> -p<password>
mysql> create database zabbix;
mysql> quit;
shell> cd create/mysql
shell> cat schema.sql |mysql -u<username> -p<password> zabbix
shell> cd ../data
shell> cat data.sql |mysql -u<username> -p<password> zabbix
shell> cat images_mysql.sql |mysql -u<username> -p<password> zabbix
For PostgreSQL:
shell> psql -U <username>
psql> create database zabbix;
psql> \q
shell> cd create/postgresql
shell> cat schema.sql|psql -U <username> zabbix
shell> cd ../data
shell> cat data.sql|psql -U <username> zabbix
shell> cat images_pgsql.sql |psql -U <username> zabbix
For SQLite:
shell> cd create/sqlite
shell> cat schema.sql | sqlite3 /var/lib/sqlite/zabbix.db
shell> cd ../data
shell> cat data.sql | sqlite3 /var/lib/sqlite/zabbix.db
shell> cat images.sql | sqlite3 /var/lib/sqlite/zabbix.db"

Regards Foxi

[cyc]

Emm ...

You were completely right. I was busy searching for missing debian packages and somehow managed so skip that part of database setup

Zabbix now works fine, I'm getting used to it, thanks for help!