package zabbix-server-mysql 1:1.6.4-2build1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

Thanks for your report.

The relevant error is
===
Setting up zabbix-server-mysql (1:1.6.4-2build1) ...
dbconfig-common: writing config to /etc/dbconfig-common/zabbix-server-mysql.conf

Creating config file /etc/dbconfig-common/zabbix-server-mysql.conf with new version

Creating config file /etc/zabbix/zabbix_server.conf with new version
granting access to database zabbix for zabbix@localhost: success.
verifying access for zabbix@localhost: success.
creating database zabbix: success.
verifying database zabbix exists: success.
populating database via sql... ^[

error encountered populating database:
mysql said: ERROR 2006 (HY000) at line 7441: MySQL server has gone away
frontend: Fatal IO error 2 (No such file or directory) on X server :0.0.
dpkg: error processing zabbix-server-mysql (--configure):
 subprocess installed post-installation script returned error exit status 1
===

Looks like you've killed the upgrade process during feeding of mysql ? Did you wait long enough while the process was populating mysql ?

Hi,

During the initial install, my machine crashed..... (power-outage ..)
After reboot, I completely uninstalled Zabbix server, but the prequisites
such as mysql werent uninstalled. I the did a reinstall of the Zabbix
server, and had it installed ok.

Also the web front-end worked ok, but reporting this error...

Thanks and regards!

Q

2010/1/14 Jean-Baptiste Lallement <email address hidden>

> Thanks for your report.
>
> The relevant error is
> ===
> Setting up zabbix-server-mysql (1:1.6.4-2build1) ...
> dbconfig-common: writing config to
> /etc/dbconfig-common/zabbix-server-mysql.conf
>
> Creating config file /etc/dbconfig-common/zabbix-server-mysql.conf with
> new version
>
> Creating config file /etc/zabbix/zabbix_server.conf with new version
> granting access to database zabbix for zabbix@localhost: success.
> verifying access for zabbix@localhost: success.
> creating database zabbix: success.
> verifying database zabbix exists: success.
> populating database via sql... ^[
>
> error encountered populating database:
> mysql said: ERROR 2006 (HY000) at line 7441: MySQL server has gone away
> frontend: Fatal IO error 2 (No such file or directory) on X server :0.0.
> dpkg: error processing zabbix-server-mysql (--configure):
> subprocess installed post-installation script returned error exit status 1
> ===
>
> Looks like you've killed the upgrade process during feeding of mysql ?
> Did you wait long enough while the process was populating mysql ?
>
> ** Changed in: zabbix (Ubuntu)
> Status: New => Incomplete
>
> --
> package zabbix-server-mysql 1:1.6.4-2build1 failed to install/upgrade:
> subprocess installed post-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/507664
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “zabbix” package in Ubuntu: Incomplete
>
> Bug description:
> system hung on mysql conf.
>
> ProblemType: Package
> Architecture: i386
> Date: Thu Jan 14 22:22:58 2010
> DistroRelease: Ubuntu 9.10
> ErrorMessage: subprocess installed post-installation script returned error
> exit status 1
> InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
> Package: zabbix-server-mysql 1:1.6.4-2build1
> ProcVersionSignature: Ubuntu 2.6.31-18.55-generic
> SourcePackage: zabbix
> Title: package zabbix-server-mysql 1:1.6.4-2build1 failed to
> install/upgrade: subprocess installed post-installation script returned
> error exit status 1
> Uname: Linux 2.6.31-18-generic i686
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/ubuntu/+source/zabbix/+bug/507664/+subscribe
>

The mysql error is likely due to a corrupted installation following the crash then. The easiest way to fix it is probably to completely uninstall mysql including the datafiles the reinstall it. The zabbix is just a side effect of the mysql failure I'm reaffecting the report.
Please set the status to 'Invalid' of it's not an issue anymore. Thanks in advance.

 We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!

I'm sorry, my knowledge of zabbix is little.... On other ubuntu
installations it worked as it should, so I consider this indeed closed.
Sorry to have not let you know!

2010/2/25 Jean-Baptiste Lallement <email address hidden>

> We are closing this bug report because it lacks the information we need
> to investigate the problem, as described in the previous comments.
> Please reopen it if you can give us the missing information, and don't
> hesitate to submit bug reports in the future. To reopen the bug report
> you can click on the current status, under the Status column, and change
> the Status back to "New". Thanks again!
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Status: Incomplete => Invalid
>
> --
> package zabbix-server-mysql 1:1.6.4-2build1 failed to install/upgrade:
> subprocess installed post-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/507664
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Invalid
>
> Bug description:
> system hung on mysql conf.
>
> ProblemType: Package
> Architecture: i386
> Date: Thu Jan 14 22:22:58 2010
> DistroRelease: Ubuntu 9.10
> ErrorMessage: subprocess installed post-installation script returned error
> exit status 1
> InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
> Package: zabbix-server-mysql 1:1.6.4-2build1
> ProcVersionSignature: Ubuntu 2.6.31-18.55-generic
> SourcePackage: zabbix
> Title: package zabbix-server-mysql 1:1.6.4-2build1 failed to
> install/upgrade: subprocess installed post-installation script returned
> error exit status 1
> Uname: Linux 2.6.31-18-generic i686
>
> To unsubscribe from this bug, go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/507664/+subscribe
>

sudo apt-get install zabbix-server-mysql zabbix-frontend-php

Setting up zabbix-server-mysql (1:1.8.2-1ubuntu1) ...
.....
dbconfig-common: writing config to /etc/dbconfig-common/zabbix-server-mysql.conf
chown: invalid user: `zabbix'
granting access to database zabbix for zabbix@localhost: success.
verifying access for zabbix@localhost: success.
creating database zabbix: success.
verifying database zabbix exists: success.
populating database via sql... (stop here)

Same with my machine, stops with populating database...
11.04 server fully updated

I am having the same problem here, Boban and ifone can you flag this issue as 'having it also'? The bug might get reopened that way.