Ad Widget

**Atsushi** · 28-09-2018, 06:12

Is it possible to access a database using the mysql command and execute a select statement?
For example, in the environment I created, the following output was obtained.

Code:

$ mysql -uzabbix -p zabbix
Enter password:

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from users;
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
| userid | alias | name   | surname       | passwd                           | url | autologin | autologout | lang  | refresh | type | theme   | attempt_failed | attempt_ip | attempt_clock | rows_per_page |
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
|      1 | Admin | Zabbix | Administrator | 5fce1b3e34b520afeffb37ce08c7cd66 |     |         1 | 0          | ja_JP | 30s     |    3 | default |              0 |            |             0 |            50 |
|      2 | guest |        |               | d41d8cd98f00b204e9800998ecf8427e |     |         0 | 15m        | en_GB | 30s     |    1 | default |              0 |            |             0 |            50 |
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
2 rows in set (0.00 sec)

mysql> quit
Bye
$

In Ubuntu 18.04, the default setting when using MySQL seems to be different from the previous one.
For example, the security policy seems to have changed, too.
Has an error occurred when inputting initial data?

I have been able to successfully populate the initial data with the following procedure with the combination of Ubuntu 18.04.01 + MySQL database server 5.7.23-0ubuntu0.18.04.1 + Zabbix 3.4.14-1+bionic.

Code:

$ sudo mysql -uroot -p
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified with mysql_native_password by '<Your password>';
mysql> quit
$ zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix

**nzbrent** · 19-09-2020, 06:14

All output relating to database errors stem from missing zabbix-server-mysql package files.
The original create.sql.gz file must be present to populate the database tables. Ls check and if not present refer to a previous post https://www.zabbix.com/forum/zabbix-...e-or-directory. I followed the final suggestion by matz to update 'excludes' by updating /etc/dpkg/dpkg.cfg file.

.......Problem is dpkg exclude list, so:

**matz** · 19-09-2020, 09:13

nzbrent so, my solution solve your problem?

Ad Widget

User's table is empty

User's table is empty

Comment

Comment

Comment