Opsview und Percona xtradb cluster

bei einem update ist mir aufgefallen das die Community Version von Opsview jetzt zwingend mysql-server-5.x braucht.

Da ich aber bei mir einen Percona xtradb Cluster am laufen habe will ich das natürlich nicht.

[stextbox id=“bash“] apt-get install opsview-core[/stextbox]
[stextbox id=“info“]Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libdbi1 librrd4 librrds-perl mysql-client-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5 opsview-base opsview-perl rrdtool snmp ttf-dejavu ttf-dejavu-extra
Suggested packages:
tinyca
The following packages will be REMOVED:
percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-server-5.5
The following NEW packages will be installed:
libdbi1 librrd4 librrds-perl mysql-client-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5 opsview-base opsview-core opsview-perl rrdtool snmp ttf-dejavu ttf-dejavu-extra
0 upgraded, 14 newly installed, 2 to remove and 0 not upgraded.
Need to get 36.2 MB/44.7 MB of archives.
After this operation, 22.4 MB disk space will be freed.
Do you want to continue [Y/n]? n
Abort.[/stextbox]

Da Opsview auch mit dem Percona xtradb cluster einwandfrei läuft muss man die Installation etwas anders angehen.

Nur die benötigten Pakete runter laden

[stextbox id=“bash“]apt-get install -d opsview[/stextbox]
[stextbox id=“info“]Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libdbi1 librrd4 librrds-perl mysql-client-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5 opsview-base opsview-core opsview-perl opsview-web rrdtool snmp ttf-dejavu ttf-dejavu-extra
Suggested packages:
tinyca
The following packages will be REMOVED:
percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-server-5.5
The following NEW packages will be installed:
libdbi1 librrd4 librrds-perl mysql-client-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5 opsview opsview-base opsview-core opsview-perl opsview-web rrdtool snmp ttf-dejavu ttf-dejavu-extra
0 upgraded, 16 newly installed, 2 to remove and 0 not upgraded.
Need to get 36.8 MB/45.2 MB of archives.
After this operation, 19.5 MB disk space will be freed.
Do you want to continue [Y/n]? y
WARNING: The following packages cannot be authenticated!
opsview-perl opsview-base opsview-core opsview-web opsview
Install these packages without verification [y/N]? y
Get:1 http://myrepository.secretisland.de/ wheezy/apr opsview-perl amd64 4.5.0.798-1wheezy1 [23.2 MB]
Get:2 http://ftp.de.debian.org/debian/ wheezy/main libdbi1 amd64 0.8.4-6 [31.7 kB]
Get:3 http://ftp.de.debian.org/debian/ wheezy/main librrd4 amd64 1.4.7-2 [322 kB]
Get:4 http://ftp.de.debian.org/debian/ wheezy/main librrds-perl amd64 1.4.7-2 [116 kB]
Get:5 http://ftp.de.debian.org/debian/ wheezy/main rrdtool amd64 1.4.7-2 [462 kB]
Get:6 http://ftp.de.debian.org/debian/ wheezy/main ttf-dejavu-extra all 2.33-3 [1,759 kB]
Get:7 http://ftp.de.debian.org/debian/ wheezy/main ttf-dejavu all 2.33-3 [30.6 kB]
Get:8 http://myrepository.secretisland.de/ wheezy/apr opsview-base amd64 4.5.0.397-1wheezy1 [7,655 kB]
Get:9 http://myrepository.secretisland.de/ wheezy/apr opsview-core amd64 3.20131016.0.14175-1wheezy1 [2,629 kB]
Get:10 http://myrepository.secretisland.de/ wheezy/apr opsview-web amd64 3.20131016.0.14175-1wheezy1 [544 kB]
Get:11 http://myrepository.secretisland.de/ wheezy/apr opsview amd64 3.20131016.0.14175-1wheezy1 [2,094 B]
Fetched 36.8 MB in 13s (2,830 kB/s)
Download complete and in download only mode[/stextbox]

Dann die nicht kritischen Pakete installieren.

[stextbox id=“bash“]apt-get install libdbi1 librrd4 librrds-perl rrdtool snmp ttf-dejavu ttf-dejavu-extra[/stextbox]
[stextbox id=“info“]Reading package lists… Done
Building dependency tree
Reading state information… Done
The following NEW packages will be installed:
libdbi1 librrd4 librrds-perl rrdtool snmp ttf-dejavu ttf-dejavu-extra
0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/3,771 kB of archives.
After this operation, 9,873 kB of additional disk space will be used.
Selecting previously unselected package ttf-dejavu-extra.
(Reading database … 80647 files and directories currently installed.)
Unpacking ttf-dejavu-extra (from …/ttf-dejavu-extra_2.33-3_all.deb) …
Selecting previously unselected package ttf-dejavu.
Unpacking ttf-dejavu (from …/ttf-dejavu_2.33-3_all.deb) …
Selecting previously unselected package libdbi1.
Unpacking libdbi1 (from …/libdbi1_0.8.4-6_amd64.deb) …
Selecting previously unselected package librrd4.
Unpacking librrd4 (from …/librrd4_1.4.7-2_amd64.deb) …
Selecting previously unselected package librrds-perl.
Unpacking librrds-perl (from …/librrds-perl_1.4.7-2_amd64.deb) …
Selecting previously unselected package rrdtool.
Unpacking rrdtool (from …/rrdtool_1.4.7-2_amd64.deb) …
Selecting previously unselected package snmp.
Unpacking snmp (from …/snmp_5.4.3~dfsg-2.8_amd64.deb) …
Processing triggers for fontconfig …
Processing triggers for man-db …
Setting up ttf-dejavu-extra (2.33-3) …
Setting up ttf-dejavu (2.33-3) …
Setting up libdbi1 (0.8.4-6) …
Setting up librrd4 (1.4.7-2) …
Setting up librrds-perl (1.4.7-2) …
Setting up rrdtool (1.4.7-2) …
Setting up snmp (5.4.3~dfsg-2.8) …[/stextbox]

Anschließend wechselt man ins Verzeichnis wo apt die Pakete herunterlädt und installiert die Opsview Pakete Manuell ohne die MySQL dependencies

[stextbox id=“bash“]cd /var/cache/apt/archives
dpkg -i –ignore-depends=mysql-server-5.5 –ignore-depends=mysql-server-5.1 –ignore-depends=mysql-server-5.0 opsview-base_4.5.0.397-1wheezy1_amd64.deb
dpkg -i –ignore-depends=mysql-server-5.5 –ignore-depends=mysql-server-5.1 –ignore-depends=mysql-server-5.0 opsview-core_3.20131016.0.14175-1wheezy1_amd64.deb
dpkg -i –ignore-depends=mysql-server-5.5 –ignore-depends=mysql-server-5.1 –ignore-depends=mysql-server-5.0 opsview-web_3.20131016.0.14175-1wheezy1_amd64.deb
dpkg -i –ignore-depends=mysql-server-5.5 –ignore-depends=mysql-server-5.1 –ignore-depends=mysql-server-5.0 opsview_3.20131016.0.14175-1wheezy1_amd64.deb[/stextbox]

Und fertig.

Leider hat diese Methode auch einen winzigen Nachteil beim nächsten Upgrade bekommt man einen Fehler präsentiert.
[stextbox id=“bash“] apt-get upgrade[/stextbox]
[stextbox id=“info“]Reading package lists… Done
Building dependency tree
Reading state information… Done
You might want to run ‚apt-get -f install‘ to correct these.
The following packages have unmet dependencies:
opsview-base : Depends: mysql-server-5.5 or
mysql-server-5.1 or
mysql-server-5.0
E: Unmet dependencies. Try using -f.[/stextbox]

Eine wirklich dreckige Methode um das Problem zu umgehen ist die /var/lib/dpkg/status zu bearbeiten und dort bei dem Paket opsview-base die mysql Einträge zu entfernen.

Oder das opsview-base Paket zu entpacken und ohne die Depends von mysql-server-5.x neu zu erstellen und dann zu installieren.