do you happen to have multiple zabbix frontends on the same host open ?

Hi.

I changed:

if (!$userInfo)

in include/classes/api/services/CUser.php. Now the error is "Tha Session terminated, re-login, please".

So obviously something went wrong here. Can i create a valid user via mysql cli somehow?

thanks and cheers
t.

Hi richlv.

Only one Zabbix Frontend Installation on that host.

which browser ? could this be a duplicate of ZBX-8546 ?

I tried Firefox and Chrome current versions. Unchecking the Remember me for 30 days does not help in my case. As you can see
i have the zabbix cookie (attached screen).

Oh and the very same sessionid shows in the sessions table line two:

mysql> select * from sessions;
+----------------------------------+--------+------------+--------+
| sessionid                        | userid | lastaccess | status |
+----------------------------------+--------+------------+--------+
| 68ad8ead9714577fca23bf5dc2e3d768 |      2 | 1456777614 |      1 |
| 762d1777d0fe7cfbd2a36578e141fd91 |      2 | 1456778034 |      0 |
| 8afed3fdfee0dc9ae4ed70a09880f066 |      2 | 1456777625 |      0 |
| 97e5b42b911111ffd0dbf589c183e158 |      2 | 1456778040 |      0 |
| beb78911334df8ddd63738a33ff5909c |      2 | 1456777768 |      0 |
+----------------------------------+--------+------------+--------+
5 rows in set (0.00 sec)

The "status" columns means:
0, ZBX_SESSION_ACTIVE - Session active
1, ZBX_SESSION_PASSIVE - Session is not active

userid=2 must be "guest"
Records only for userid=2 should indicate that you never logged in as not guest.
At least it looks like so.

I'd try to clean out current frontend folder and fill it by frontend sources again to make sure everything is correct with zabbix code after the upgrade.
Then would try to compare db schema for current upgraded database and new one created from 3.0 schema sources.

And we are not sure that upgrade itself was performed correctly, so it could be a support case ...

Hello Oleksiy.

Thanks for your answer. You are right, userid 2 is guest. Just checked that. So it seems i can not login at all.

What puzzles me is if i enter a wrong password for the admin user i get: "Login name or password is incorrect." If i enter the correct password i end up with current situation.

As for the frontend folder. It's already a fresh frontend install.

Comparing the db schema seems to be a good idea. Can you give me a hand here? I already tried to import the users and users_groups table from a fresh 3.0 install. This leads to another error. See screen.

thanks and cheers
t.

I did a quick upgrade test 1.8 ->(patch) 2.0 ->(automatic) 3.0, and everything is ok.

To check schema - basically you need to export 2 databases using "mysqldump --no-data DBNAME" and then compare generated files using diff etc.

Something indeed went wrong with your upgrade.

That was bad idea to mix DB data from different sources.
Sorry, this is a bug tracker, see other options to get community help http://zabbix.org/wiki/Getting_help

I'm closing this issue for now as cannot reproduce.
Feel free to reopen if you will be able to prove that there indeed a bug.

Hello Oleksiy.

I'm redoing the hole thing now. First step is upgrading from 1.8.22 to 2.0.16. The database upgrade will take around 11 hours so i will get back to you tomorrow.

thanks and cheers
t.

It's possible i need support after upgrading from 1.8.to 2.0.

Hello.

This warnings/errors i had too the first time i did an db upgrade.

mysqltest mysql # time ./upgrade -p -D zabbix_server --force
 WARNING: backup your database before performing upgrade

 This is an UNSUPPORTED Zabbix upgrade script from 1.8 to 2.0 for MySQL
 It does the following things:
  1. Updates indexes that might require changes;
  2. Patches the database from 1.8 schema to 2.0 schema;
  3. Adds 'Disabled' and 'Debug' usergroup if any missing;
  4. Checks for hosts not belonging to any group and adds them to one if any found.

 Usage: pass required MySQL parameters to this script (like database, user, password etc).

Continue ? (y/n) y
Patching the database
Enter password: 
ERROR 1005 (HY000) at line 47: Can't create table 'zabbix_server.#sql-d68_91' (errno: 150)
ERROR 1506 (HY000) at line 51: Foreign key clause is not yet supported in conjunction with partitioning
ERROR 1005 (HY000) at line 168: Can't create table 'zabbix_server.#sql-d68_91' (errno: 150)
ERROR 1005 (HY000) at line 195: Can't create table 'zabbix_server.#sql-d68_91' (errno: 150)
ERROR 1005 (HY000) at line 213: Can't create table 'zabbix_server.#sql-d68_91' (errno: 150)
ERROR 1005 (HY000) at line 214: Can't create table 'zabbix_server.#sql-d68_91' (errno: 150)

I let it run for now.

thanks and cheers
t.

I've asked to reopen issue if you will be able to prove that there indeed is a bug.
We will appreciate your understanding that this is a bug report tracker, but not a place to discuss user problems.

CLOSED again.

Easy to reproduce - simple revoke INSERT access to auditlog table.
SQL error message lost inside frontend calls, user always see "Session terminated, re-login, please.".