package zoneminder 1.25.0-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1 [ERROR 1142 (42000) at line 10: CREATE command denied to user 'zmuser'@'localhost']

[Stephan]

no further information

ProblemType: Package
DistroRelease: Ubuntu 12.04
Package: zoneminder 1.25.0-1
ProcVersionSignature: Ubuntu 3.2.0-17.26-generic 3.2.6
Uname: Linux 3.2.0-17-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 1.93-0ubuntu2
AptOrdering:
 libapr1: Install
 zoneminder: Configure
 libapr1: Configure
Architecture: amd64
Date: Fri Feb 24 22:29:28 2012
ErrorMessage: subprocess installed post-installation script returned error exit status 1
SourcePackage: zoneminder
Title: package zoneminder 1.25.0-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to precise on 2012-02-24 (0 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Aditya V (kroq-gar78)]

Woo, I just marked like a thousand duplicates O_O (sorry for the slightly offtopic...)

[Chris (gaddman)]

Workaround (based on http://www.zoneminder.com/wiki/index.php/Debian_Wheezy)

mysql -uroot -p
     GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY "zmpass";
     quit
sudo apt-get upgrade

[Mark Munro (mcwmunro)]

On 28/04/12 12:26, gaddman wrote:
> Workaround (based on
> http://www.zoneminder.com/wiki/index.php/Debian_Wheezy)
>
> mysql -uroot -p
> GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY "zmpass";
> quit
> sudo apt-get upgrade
>
This would never happen with a Micro$oft support issue. I'm so glad I'm
an Ubuntu User :-)

--
Mark Munro

[Aditya V (kroq-gar78)]

I think it's time for somebody to mark this as either a "High" or "Critical" issue

[Andy Wells (arwells87)]

gaddman (gaddman) wrote on 2012-04-28:
> Workaround (based on http://www.zoneminder.com/wiki/index.php/Debian_Wheezy)
>
> mysql -uroot -p
> GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY "zmpass";
> quit
> sudo apt-get upgrade

Thank you gaddman, this did the trick

and Thank you kroq-gar78, marking mine as a duplicate brought me here.
(many of the duplicates are being made by people upgrading to "Ubuntu 12.04 lts", following a script to submit the bug report)

[Fabian (frank-eff)]

Hey gaddman,

I'm a total noob and have no Idea how to apply this workaround. And the wiki didn't help either. Are those Terminal commands? How do I enter them? Could someone please take the time to quide a noob like me through this process?

Any help would be greatly appreciated and could help others, too!

[James A. Sterling III (jasiii)]

I can try (grin) and being new is not new

In the terminal window do the following
mysql -uroot -p (return) << gets you into the mysql shell with admin
privs if you do not know the password try your root pwd
GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY
"zmpass"; << should/must be case sensitive just copy and paste

Quit << gets you OUT of mysql
sudo apt-get upgrade << you will be prompted for the password

After a few minutes and lots of activity you should/may need to reboot

Then you should not see the error message

Hope this helps

Let me know if you have any more questions

Jim Sterling (still a new-be after more years then I can remember)

On 4/30/12 12:57 PM, "Fabian" <email address hidden> wrote:

>Hey gaddman,
>
>I'm a total noob and have no Idea how to apply this workaround. And the
>wiki didn't help either. Are those Terminal commands? How do I enter
>them? Could someone please take the time to quide a noob like me through
>this process?
>
>Any help would be greatly appreciated and could help others, too!
>
>--
>You received this bug notification because you are subscribed to a
>duplicate bug report (989259).
>https://bugs.launchpad.net/bugs/940632
>
>Title:
> package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
> installed post-installation script returned error exit status 1
>
>Status in ³zoneminder² package in Ubuntu:
> Confirmed
>Status in ³zoneminder² package in Debian:
> New
>
>Bug description:
> no further information
>
> ProblemType: Package
> DistroRelease: Ubuntu 12.04
> Package: zoneminder 1.25.0-1
> ProcVersionSignature: Ubuntu 3.2.0-17.26-generic 3.2.6
> Uname: Linux 3.2.0-17-generic x86_64
> NonfreeKernelModules: nvidia
> ApportVersion: 1.93-0ubuntu2
> AptOrdering:
> libapr1: Install
> zoneminder: Configure
> libapr1: Configure
> Architecture: amd64
> Date: Fri Feb 24 22:29:28 2012
> ErrorMessage: subprocess installed post-installation script returned
>error exit status 1
> SourcePackage: zoneminder
> Title: package zoneminder 1.25.0-1 failed to install/upgrade:
>subprocess installed post-installation script returned error exit status 1
> UpgradeStatus: Upgraded to precise on 2012-02-24 (0 days ago)
>
>To manage notifications about this bug go to:
>https://bugs.launchpad.net/ubuntu/+source/zoneminder/+bug/940632/+subscrip
>tions

[buddybamboo (buddybamboo)]

Thanks
This did the trick for me also.

Mahalo
George

________________________________
 From: Andy Wells <email address hidden>
To: <email address hidden>
Sent: Sunday, April 29, 2012 12:09 PM
Subject: [Bug 940632] Re: package zoneminder 1.25.0-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

gaddman (gaddman) wrote on 2012-04-28:
> Workaround (based on http://www.zoneminder.com/wiki/index.php/Debian_Wheezy)
>
> mysql -uroot -p
>    GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY "zmpass";
>    quit
> sudo apt-get upgrade

Thank you gaddman, this did the trick

and Thank you kroq-gar78, marking mine as a duplicate brought me here.
(many of the duplicates are being made by people upgrading to "Ubuntu 12.04 lts", following a script to submit the bug report)

--
You received this bug notification because you are subscribed to a
duplicate bug report (990859).
https://bugs.launchpad.net/bugs/940632

Title:
  package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
  installed post-installation script returned error exit status 1

Status in “zoneminder” package in Ubuntu:
  Confirmed
Status in “zoneminder” package in Debian:
  New

Bug description:
  no further information

  ProblemType: Package
  DistroRelease: Ubuntu 12.04
  Package: zoneminder 1.25.0-1
  ProcVersionSignature: Ubuntu 3.2.0-17.26-generic 3.2.6
  Uname: Linux 3.2.0-17-generic x86_64
  NonfreeKernelModules: nvidia
  ApportVersion: 1.93-0ubuntu2
  AptOrdering:
   libapr1: Install
   zoneminder: Configure
   libapr1: Configure
  Architecture: amd64
  Date: Fri Feb 24 22:29:28 2012
  ErrorMessage: subprocess installed post-installation script returned error exit status 1
  SourcePackage: zoneminder
  Title: package zoneminder 1.25.0-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
  UpgradeStatus: Upgraded to precise on 2012-02-24 (0 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/zoneminder/+bug/940632/+subscriptions

[Al Santiago (alsanti)]

Great, worked like a charm thanks..........

----- Original Message -----
From: "James A. Sterling III" <email address hidden>
To: <email address hidden>
Sent: Monday, April 30, 2012 1:38:20 PM
Subject: Re: [Bug 940632] Re: package zoneminder 1.25.0-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

I can try (grin) and being new is not new

In the terminal window do the following
mysql -uroot -p (return) << gets you into the mysql shell with admin
privs if you do not know the password try your root pwd
GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY
"zmpass"; << should/must be case sensitive just copy and paste

Quit << gets you OUT of mysql
sudo apt-get upgrade << you will be prompted for the password

After a few minutes and lots of activity you should/may need to reboot

Then you should not see the error message

Hope this helps

Let me know if you have any more questions

Jim Sterling (still a new-be after more years then I can remember)

On 4/30/12 12:57 PM, "Fabian" <email address hidden> wrote:

>Hey gaddman,
>
>I'm a total noob and have no Idea how to apply this workaround. And the
>wiki didn't help either. Are those Terminal commands? How do I enter
>them? Could someone please take the time to quide a noob like me through
>this process?
>
>Any help would be greatly appreciated and could help others, too!
>
>--
>You received this bug notification because you are subscribed to a
>duplicate bug report (989259).
>https://bugs.launchpad.net/bugs/940632
>
>Title:
> package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
> installed post-installation script returned error exit status 1
>
>Status in ³zoneminder² package in Ubuntu:
> Confirmed
>Status in ³zoneminder² package in Debian:
> New
>
>Bug description:
> no further information
>
> ProblemType: Package
> DistroRelease: Ubuntu 12.04
> Package: zoneminder 1.25.0-1
> ProcVersionSignature: Ubuntu 3.2.0-17.26-generic 3.2.6
> Uname: Linux 3.2.0-17-generic x86_64
> NonfreeKernelModules: nvidia
> ApportVersion: 1.93-0ubuntu2
> AptOrdering:
> libapr1: Install
> zoneminder: Configure
> libapr1: Configure
> Architecture: amd64
> Date: Fri Feb 24 22:29:28 2012
> ErrorMessage: subprocess installed post-installation script returned
>error exit status 1
> SourcePackage: zoneminder
> Title: package zoneminder 1.25.0-1 failed to install/upgrade:
>subprocess installed post-installation script returned error exit status 1
> UpgradeStatus: Upgraded to precise on 2012-02-24 (0 days ago)
>
>To manage notifications about this bug go to:
>https://bugs.launchpad.net/ubuntu/+source/zoneminder/+bug/940632/+subscrip
>tions

--
You received this bug notification because you are subscribed to a
duplicate bug report (990609).
https://bugs.launchpad.net/bugs/940632

Title:
package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
installed post-installation script returned error exit status 1

Status in “zoneminder” package in Ubuntu:
Confirmed
Status in “zoneminder” package in Debian:
New

Bug description:
no further information

ProblemType: P...

[Fabian (frank-eff)]

Thank you very much the detailed information on how to fix this bug! I forgot to enter the ";" at the end of each line, so naturally nothing happened. The fix worked!

[Kevin Lucas (yu210148)]

What ever you do don't issue the "drop table Logs;" line from the solution at http://www.zoneminder.com/wiki/index.php/Debian_Wheezy if you think in any way that you're already on the 1.25 version of the database. I've just rebuilt the database structure manually. Thankfully I had another machine running zoneminder I could use as a template. :)

kev.

[Mrb (perake-bergman)]

my solution was to use Updatemanager to
> uninstall the package
> reboot
> install the package

downside, you have to configure Zoneminder from scratch

[James A. Sterling III (jasiii)]

I *think* you need to follow the following (it did work for someone else)
Stuff from << on is just for comments

In the terminal window do the following
mysql -uroot -p (return) << gets you into the mysql shell with admin
privs if you do not know the password try your root pwd
GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' IDENTIFIED BY
"zmpass"; << should/must be case sensitive just copy and paste

Quit << gets you OUT of mysql

sudo apt-get upgrade << you will be prompted for the password

After a few minutes and lots of activity you should/may need to reboot

Then you should not see the error message

Hope this helps

Let me know if you have any more questions

Jim Sterling (still a new-be after more years then I can remember)

On 5/7/12 5:31 PM, "Dave Lentz" <email address hidden> wrote:

>** Summary changed:
>
>- package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
>installed post-installation script returned error exit status 1
>+ package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
>installed post-installation script returned error exit status 1 [ERROR
>1142 (42000) at line 10: CREATE command denied to user
>'zmuser'@'localhost']
>
>--
>You received this bug notification because you are subscribed to a
>duplicate bug report (989259).
>https://bugs.launchpad.net/bugs/940632
>
>Title:
> package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
> installed post-installation script returned error exit status 1 [ERROR
> 1142 (42000) at line 10: CREATE command denied to user
> 'zmuser'@'localhost']
>
>Status in ³zoneminder² package in Ubuntu:
> Confirmed
>Status in ³zoneminder² package in Debian:
> New
>
>Bug description:
> no further information
>
> ProblemType: Package
> DistroRelease: Ubuntu 12.04
> Package: zoneminder 1.25.0-1
> ProcVersionSignature: Ubuntu 3.2.0-17.26-generic 3.2.6
> Uname: Linux 3.2.0-17-generic x86_64
> NonfreeKernelModules: nvidia
> ApportVersion: 1.93-0ubuntu2
> AptOrdering:
> libapr1: Install
> zoneminder: Configure
> libapr1: Configure
> Architecture: amd64
> Date: Fri Feb 24 22:29:28 2012
> ErrorMessage: subprocess installed post-installation script returned
>error exit status 1
> SourcePackage: zoneminder
> Title: package zoneminder 1.25.0-1 failed to install/upgrade:
>subprocess installed post-installation script returned error exit status 1
> UpgradeStatus: Upgraded to precise on 2012-02-24 (0 days ago)
>
>To manage notifications about this bug go to:
>https://bugs.launchpad.net/ubuntu/+source/zoneminder/+bug/940632/+subscrip
>tions

[DAVID HARBRON (davidm0hjd)]

SORRY BUT I DONT NEED IT NOW AS I DONT HAVE THE PROGRAM ON NOW THANK YOU
FOR WHAT YOU HAVE DONE

[tom dunn (tomdunn)]

I added the zmuser as specified by gaddman in his reply above -- it installed with out error then.

[jantonz (jantonz)]

I did the trick and looks fine, but I get this somewhere in the log:

"Converting filters from PHP to JSON format
  PurgeWhenFull - failed, please check or report. Query is '{"sort_field":"Id","terms":[{"val":0,"attr":"Archived","op":"="},{"cnj":"and","val":95,"attr":"DiskPercent","op":">="}],"limit":5,"sort_asc":1}'
ERROR: Unknown type {. at /usr/bin/zmupdate.pl line 930
Conversion complete

Database successfully upgraded from version 1.24.4.

Database upgrade to version 1.25.0 successful.

Starting ZoneMinder: success"

Starting zoneminder: success, so I don't know if that error is related to the zoneminder bug. But as I saw that the error was "ERROR: Unknown type {. at /usr/bin/zmupdate.pl line 930", and zmupdate seems to mean ZoneMinder, I guess. I have to say, the upgrade finished OK, just this few strange lines that doesn't seem to affect the general upgrade. I just post it here because of the "please check or report".

[Vortex (ecbeachbum)]

I applied #4, upgraded to Ubuntu 12.04. Everything seemed fine, but I noticed my foscams weren't seen by zm and zm was stopped.

I tried to restart zm:

service zoneminder restart

and got:

mangrove@foscam:~$ service zoneminder restart
Stopping ZoneMinder: [sudo] password for mangrove:
Zoneminder already stopped

Starting ZoneMinder: failure

mangrove@foscam:~$

Attached are relevant (ie. today) portions of zm logs.

[Vortex (ecbeachbum)]

In the process of fixing intermittent Network Connection problems, I disabled "dnsmasq" (which is enabled by default in Ubuntu 12.04). This fixed both my network connectivity problems and my zoneminder problem in #19.

To disable dnsmasq, I used this method (found on the internet):

you need to edit /etc/NetworkManager/NetworkManager.conf and comment the “dns=dnsmasq” line.

Open a terminal, and run

sudo nano /etc/NetworkManager/NetworkManager.conf

Then, make sure that the line

    dns=dnsmasq

is commented like this:

    #dns=dnsmasq

Now, restart network manager with the following command, and everything should work properly.

    sudo restart network-manager

[Chrstian Froening (chfroening)]

Hoi,

upgraded from 10.04 to 12.04.
I checked to keep the old zm.conf during install, therefor the upgrade failed.
My Steps to resolving the issue was to change ZM_VERSION from 1.24.2 to 1.25.0 and everything ran fine.

If you use the distro zm.conf remember to Change ZM_DB_USER and ZM_DB_PASS to your values.

Cheers

[Johann Niemoller (x-jn)]

Thanks much appreciate

On 4 November 2012 15:09, Chrstian Froening <email address hidden> wrote:

> Hoi,
>
> upgraded from 10.04 to 12.04.
> I checked to keep the old zm.conf during install, therefor the upgrade
> failed.
> My Steps to resolving the issue was to change ZM_VERSION from 1.24.2 to
> 1.25.0 and everything ran fine.
>
> If you use the distro zm.conf remember to Change ZM_DB_USER and
> ZM_DB_PASS to your values.
>
> Cheers
>
> --
> You received this bug notification because you are subscribed to a
> duplicate bug report (1004894).
> https://bugs.launchpad.net/bugs/940632
>
> Title:
> package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
> installed post-installation script returned error exit status 1 [ERROR
> 1142 (42000) at line 10: CREATE command denied to user
> 'zmuser'@'localhost']
>
> Status in “zoneminder” package in Ubuntu:
> Confirmed
> Status in “zoneminder” package in Debian:
> Fix Released
>
> Bug description:
> no further information
>
> ProblemType: Package
> DistroRelease: Ubuntu 12.04
> Package: zoneminder 1.25.0-1
> ProcVersionSignature: Ubuntu 3.2.0-17.26-generic 3.2.6
> Uname: Linux 3.2.0-17-generic x86_64
> NonfreeKernelModules: nvidia
> ApportVersion: 1.93-0ubuntu2
> AptOrdering:
> libapr1: Install
> zoneminder: Configure
> libapr1: Configure
> Architecture: amd64
> Date: Fri Feb 24 22:29:28 2012
> ErrorMessage: subprocess installed post-installation script returned
> error exit status 1
> SourcePackage: zoneminder
> Title: package zoneminder 1.25.0-1 failed to install/upgrade: subprocess
> installed post-installation script returned error exit status 1
> UpgradeStatus: Upgraded to precise on 2012-02-24 (0 days ago)
>
> To manage notifications about this bug go to:
>
> https://bugs.launchpad.net/ubuntu/+source/zoneminder/+bug/940632/+subscriptions
>

--
* Johann Niemoller ( Ncor )* *
     P.O. Box 266 Northriding 2162, Johannesburg South Africa
<email address hidden> Mobile [phone] Oman Mobile [phone]
*

[buddybamboo (buddybamboo)]

LinkedIn
------------

I'd like to add you to my professional network on LinkedIn.

- Evert

Evert Huizinga
Owner at Keoki's Starband
Hawaiian Islands

Confirm that you know Evert Huizinga:
https://www.linkedin.com/e/-e2hfwg-hsgonu7l-37/isd/5847487139381530624/WAHeagL2/?hs=false&tok=0UEub7HEPOz681

--
You are receiving Invitation to Connect emails. Click to unsubscribe:
http://www.linkedin.com/e/-e2hfwg-hsgonu7l-37/XSsqeILUgHHqz9rb963dP9CUqFTFqXw_xGOpD6_/goo/940632%40bugs%2Elaunchpad%2Enet/20061/I6631755899_1/?hs=false&tok=3RN3GlXwvOz681

(c) 2012 LinkedIn Corporation. 2029 Stierlin Ct, Mountain View, CA 94043, USA.