Almost done with install 1.3.3

[wmo]

Hi all,

after posting a few problems and having gotten some feedback i'm now encountering the following problem.

I'm now facing the following problem:

Warning: include_once(/etc/zabbix/dbconfig.php) [function.include-once]: failed to open stream: Permission denied in /usr/share/zabbix/include/db.inc.php on line 24

Warning: include_once() [function.include]: Failed opening '/etc/zabbix/dbconfig.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/share/zabbix/include/db.inc.php on line 24

i don't see anything weird in the dbconfig.php or in the db.inc.php, but just in case i placed // before include_once in the db.inc.php file and i put in the DB/user/password information hard like this:

$DB_SERVER = "localhost";
$DB_DATABASE = "blabla";
$DB_USER= "zabbix";
$DB_PASSWD = "123456789";

if i do the above the error in my webbrowser disappears, but i CANNOT login to my zabbix.

If i do dpkg-reconfigure zabbix-server it gives me stuff about not configuring my mysql correctly, but i know for sure that my mysql is configured correctly, it got all the tables, it has the default user Admin, Default and Eugene.

Anyone got an idea?

[wmo]

Well here's an update:

i first installed 1.1.6 and it works all fine. Now i put in the following in my apt sources.list: deb http://mirror.opf.slu.cz/zabbix testing contrib

so i give the following command:
apt-get update
apt-get install zabbix-server zabbix-agent zabbix-frontend-php

it now begins downloading the latest (1.3 beta) and starts installing.
I give in all the neccasery info and when everything is completed i go to my url:
192.168.0.59/zabbix

and then (again) it gives me the db/php error's as stated above. Although 1.1.6 worked perfectly 1.3 seems to have problems with the db or php/db connection.

any suggestions? anyone? please

wmo

[wmo]

Error in query [select * from rights where userid=1] [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

This is my latest error. Although i can login, it says that the zabbix server is NOT running.

When i do /etc/init.d/zabbix-server restart it says that the mysql is NOT setup correctly.

If i do zabbix_installdb it all goes well, when i then do dpkg-reconfigure zabbix-server it gives me the mysql is NOT setup correctly.

I tried all kinds of patches:
shell> cd zabbix-1.3.3/upgrades/dbpatches/1.3
shell> cd mysql; cat patch.sql |mysql zabbix -u<username> -p<password>

Even this patch gives me an error:

ERROR 1054 (42S22) at line 126: Unknown column 'alarm_history' in 'field list'

Anyone got any suggestions ???

[vadim]

Try to use new(clean) db

Hello!

I had some errors with db too when i had server upgrade (1.3.2->1.3.3)
I think you need to create new db(or truncate existing).
For me that's helped in one of case.
Mybe that is solving

[clahti]

See this post for an upgrade script from 1.3.2 to 1.3.3

http://www.zabbix.com/forum/showthread.php?t=5412

/Christian