[ZBX-10496] Database creation scripts are not included in RPM packages as specified in docs Created: 2016 Mar 03  Updated: 2024 Apr 10  Resolved: 2019 Mar 02

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 3.0.1
Fix Version/s: 3.0.26rc1, 4.0.6rc1, 4.2.0beta2, 4.2 (plan)

Type: Problem report Priority: Trivial
Reporter: George Machitidze Assignee: dimir
Resolution: Fixed Votes: 0
Labels: packaging
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL/Centos 7.0, Zabbix 3.x repository


Team: Team C
Sprint: Sprint 49 (Feb 2019)
Story Points: 0.125

 Description   

DB creation scripts are not included in v 3.x packages for Centos/RHEL 7, doesn't match situation described in docs: https://www.zabbix.com/documentation/3.0/manual/appendix/install/db_scripts

There are create.sql scripts in single files, but not separate ones:
/usr/share/doc/zabbix-server-pgsql-3.0.1/create.sql.gz
/usr/share/doc/zabbix-server-mysql-3.0.1/create.sql.gz



 Comments   
Comment by Oleksii Zagorskyi [ 2016 Mar 05 ]

https://www.zabbix.com/documentation/3.0/manual/appendix/install/db_scripts says:

If Zabbix was installed from distribution packages, refer to the distribution documentation.

https://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages says:

Then import initial schema and data.

  1. cd /usr/share/doc/zabbix-server-mysql-3.0.0
  2. zcat create.sql.gz | mysql -uroot zabbix

So, what is wrong?

Comment by George Machitidze [ 2016 Mar 06 ]

It's not specified in Database creation scripts appendix, needs clarification

Comment by Oleksii Zagorskyi [ 2016 Mar 06 ]

Packages can be provided by different sources/distros.
The part "refer to the distribution documentation." is sufficient to inform that if installed from packages then you need to check their documentation.
Adding an internal link to the 2nd page - it would be wrong, as for other source/distro packages it could mislead.

I don't see anything here to improve.

Comment by George Machitidze [ 2016 Mar 06 ]

Look, we've got zabbix rpm's, rpm's include documentation and these also point to installation page:

[root@zabbix ~]# cat `rpm -qlad zabbix*|grep README`
Please see http://www.zabbix.com/ for detailed information about Zabbix.
On-line Zabbix documentation is available at http://www.zabbix.com/documentation/3.0/manual/installation/install .
Please see http://www.zabbix.com/ for detailed information about Zabbix.
On-line Zabbix documentation is available at http://www.zabbix.com/documentation/3.0/manual/installation/install .
Please see http://www.zabbix.com/ for detailed information about Zabbix.
On-line Zabbix documentation is available at http://www.zabbix.com/documentation/3.0/manual/installation/install .
Please see http://www.zabbix.com/ for detailed information about Zabbix.
On-line Zabbix documentation is available at http://www.zabbix.com/documentation/3.0/manual/installation/install .
Please see http://www.zabbix.com/ for detailed information about Zabbix.
On-line Zabbix documentation is available at http://www.zabbix.com/documentation/3.0/manual/installation/install .
Please see http://www.zabbix.com/ for detailed information about Zabbix.
On-line Zabbix documentation is available at http://www.zabbix.com/documentation/3.0/manual/installation/install .

if someone is checking appendix doc - he'll be confused
if someone is checking rpm docs - same issue
install_from_packages also says "Create zabbix database and user on MySQL. For instructions on doing that, see database creation scripts for MySQL." and is pointing to appendix doc - also confusing

In previous versions we had three scripts, now there is only one, but mentioned only in one document

Comment by Oleksii Zagorskyi [ 2016 Mar 06 ]

ahh, README file in packages ..., ok, I'd agree that in packages the http://www.zabbix.com/documentation/3.0/manual/installation/install link should replaced by https://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages

I don't see much sense to change anything else. kodai, please take a look.

Comment by richlv [ 2016 Mar 06 ]

https://www.zabbix.com/documentation/3.0/manual/installation might be better as it would expose other subsections there more - like upgrade notes

Comment by dimir [ 2019 Feb 18 ]

I agree with richlv, but let's think how we could fix it.

Currently we just copy this file from SVN root directory:

https://www.zabbix.org/websvn/wsvn/zabbix.com/trunk/README

For the SVN repository manual installation seems like correct choice. For packages - not. So what are the options?

  1. use sed when creating packages to fix the link
  2. fix it in the repository by mentioning separate link for packages
  3. have separate README file for packages

I'd go for option #2, what are your thoughts?

Comment by dimir [ 2019 Feb 18 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-10496

We'll first fix it for 3.0 . The changed part is:

Please see http://www.zabbix.com/ for detailed information about Zabbix.

On-line Zabbix documentation is available at
http://www.zabbix.com/documentation/3.0/manual/ .

Zabbix installation instructions can be found at
http://www.zabbix.com/documentation/3.0/manual/installation/ .

If you are installing Zabbix from packages the instructions can be found at
http://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages .
Comment by dimir [ 2019 Feb 28 ]

Fixed in

  • pre-4.2.0beta2 (r90389)
  • pre-4.0.6rc1 (r90388)
  • pre-3.0.26rc1 (r90386)
Generated at Fri Apr 26 03:52:27 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.