error in step 5 ubuntu installation zoneminder

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
Chris28
Posts: 6
Joined: Sun Jun 13, 2021 1:57 pm

error in step 5 ubuntu installation zoneminder

Post by Chris28 »

Hi everybody,


I did install Ubuntu 20.04 lts server and followed the installation guide , the Easy Way: Ubuntu 18.04 (Bionic).

in step 5, Configure the Zoneminder Database, i got an error: ERROR 1050 (42801) at line 1091: Table ´Sessions´already exists , after the following commando:

sudo mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql

I don´t want to screw it all up so perhaps anybody knows what´s going wrong here ?


Thanks !
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: error in step 5 ubuntu installation zoneminder

Post by Magic919 »

Sound like you already have a DB.
-
Chris28
Posts: 6
Joined: Sun Jun 13, 2021 1:57 pm

Re: error in step 5 ubuntu installation zoneminder

Post by Chris28 »

ah ! allright....i see....:D. Thank you !

Then i will continue the process tomorrow.

mysql -uroot -p -e "grant lock tables,alter,drop,select,insert,update,delete,create,index,alter routine,create routine, trigger,execute on zm.* to 'zmuser'@localhost identified by 'zmpass';"

Is this second step also necessary ?
SkippyDo
Posts: 219
Joined: Mon Nov 20, 2017 6:49 pm

Re: error in step 5 ubuntu installation zoneminder

Post by SkippyDo »

You could just drop that database and start over. This assumes, however, that the existing zm database isn't something that contains anything that you wish to retain (if you're doing a new install then that would likely be NO).
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: error in step 5 ubuntu installation zoneminder

Post by Magic919 »

You probably won’t need that step either. Should all be done.
-
kaltertod
Posts: 38
Joined: Fri Jun 03, 2022 9:42 pm

Re: error in step 5 ubuntu installation zoneminder

Post by kaltertod »

I prefer this guide when installing zoneminder on ubuntu 20.04 straight forward and works out of the box everytime.

https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.36.x
Chris28
Posts: 6
Joined: Sun Jun 13, 2021 1:57 pm

Re: error in step 5 ubuntu installation zoneminder

Post by Chris28 »

thanks everyone for replying.

No luck until now. Had some troubles with a lacking systemctl. etc. So now did start over again with ubuntu server 22.04.

That script looks good but is talking about Mariadb also.
Suppose i need to choose just one of them, wich one would be a better match . Mariadb or Mysql ?

Have a nice day.
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: error in step 5 ubuntu installation zoneminder

Post by Magic919 »

I use MariaDB these days.
-
kaltertod
Posts: 38
Joined: Fri Jun 03, 2022 9:42 pm

Re: error in step 5 ubuntu installation zoneminder

Post by kaltertod »

Chris28 wrote: Tue Jun 28, 2022 8:09 pm thanks everyone for replying.

No luck until now. Had some troubles with a lacking systemctl. etc. So now did start over again with ubuntu server 22.04.

That script looks good but is talking about Mariadb also.
Suppose i need to choose just one of them, wich one would be a better match . Mariadb or Mysql ?

Have a nice day.
I roll with MariaDB
Chris28
Posts: 6
Joined: Sun Jun 13, 2021 1:57 pm

Re: error in step 5 ubuntu installation zoneminder

Post by Chris28 »

I did manage to install Zoneminder, this time on Xubuntu 22.04 and with the script from kaltertod.
Thanks again for this script and everybody for your comments.

Have a nice day.
Post Reply