new istall table "dbversion" was not found.

[fsardone]

Good evening everybody,
new to the party I have istalled Zabbix on a Xen DomU in debian under Xen Hypervisor (postrgresql/apache) following the website istructions.
I run in the subject issue when configuring Zabbix from the web interface:

• Unable to determine current Zabbix database version: the table "dbversion" was not found.

I did load the template and accessing the zabbix DB listing all the tables the table exixts:
zabbix=> \dt dbversion
List of relations
Schema | Name | Type | Owner
--------+-----------+-------+--------
public | dbversion | table | zabbix
(1 row)

zabbix=> \d dbversion
                Table "public.dbversion"
   Column    |  Type   | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
 dbversionid | bigint  |           | not null |
 mandatory   | integer |           | not null | 0
 optional    | integer |           | not null | 0
Indexes:
    "dbversion_pkey" PRIMARY KEY, btree (dbversionid)
​

So I am not sure what I am doing wrong here.
I did a search in teh forum but related issues were of different origin (lack of importing the scheme or lack of socket connection)
Any pointers please?
Kind regards
Fabio

[cyber]

permissions to DB?

[fsardone]

Thank Cyber,
It was ok, checked using -u zabbix.
But, as usual in IT start all over.
Dropped the DB from postregresql and run the template again.
This fixed the issue. Probably I must have missed some errors in the first run of the template creating the Db.

In any case .... Solved.
Appreciated the suggestion though!

Cheers
Fabio