debian wheezy upgrade fails > mysql assumed permission

Forum for questions and support relating to the 1.25.x releases only.
Locked
Djamu
Posts: 1
Joined: Sun Feb 05, 2012 12:01 am

debian wheezy upgrade fails > mysql assumed permission

Post by Djamu »

Hi all,
I just tried to upgrade an existing install to 1.25.0 with the apt package manager that failed, and was able to produce a workaround
I found a recent bug report on the issue with full description ( identical setup ) which I wanted to post but it appears I'm not allowed to post anything that looks like a URL :twisted:

Anyway I found no reference of the issue here, so I thought I should mention it.

After an apt-get update && apt-get upgrade

Zoneminder update failed with a
DBD::mysql::st execute failed: Table 'zm.Logs' doesn't exist at /usr/share/perl5/ZoneMinder/Logger.pm line 609

I was able to solve the issue by manually running the contents of /usr/share/zoneminder/db/zm_update-1.24.4.sql in phpmyadmin.
As the package was still flagged as an incomplete install
I emptied the /usr/share/zoneminder/db/zm_update-1.24.4.sql file
and ran apt-get upgrade again
This resulted in apt reporting a successful upgrade

It seems something went wrong with the required permissions / I was unable to find the source of the problem.
moorsey
Posts: 53
Joined: Sun Jan 03, 2010 8:56 am

Re: debian wheezy upgrade fails > mysql assumed permission

Post by moorsey »

I tried this also (following your post, I didn't realise I could get ZM 1:25.0 in any repositories, thought I would have to build from source?! I'm running ubuntu), it looks like the mysql DB upgrade is ran as zmuser. But I checked this user out in phpmyadmin and it didn't have enough permissions to run the statement.

Anyway, my upgrade was a complete failure, anything I clicked on, rather than opening in a new window as usual, all pages opened in the same window, a little odd.

Also getting loads of:

ERR [Shared data size conflict in shared_data for monitor monitor, expected 328, got 316]

Finally, the logs feature failed with:

"ReferenceError: typeOf is not defined"

Anyway, I'm going back to a backup pre-upgrade, I shouldn't have gone messing really, I always tell myself not to mess with live servers, I should use VMs more :D
Locked