error in step 5 ubuntu installation zoneminder

[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]

Sound like you already have a DB.

[Chris28]

ah ! allright....i see..... 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]

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]

You probably won’t need that step either. Should all be done.

[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]

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]

I use MariaDB these days.

[kaltertod]

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]

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.