1.37.47 Fresh Install Issues?
Posted: Fri Dec 08, 2023 12:57 am
Hi everyone,
I'm incredibly new to ZM (as well as linux in general, but open source NVR solutions that are Windows-based are basically nonexistent so tada, now I'm learning linux) and figured I'd give it a shot, but I'm having a hell of a time trying to get it up and running properly.
I installed via the repository and it pulled 1.37.47, and I followed the steps in the 'ZoneMinder 1.37.28 on Ubuntu Kinetic' video, but it seems I'm either missing something or messed something up. I will admit, I enabled authentication before changing my admin password which locked me out, so I had to start over and just uninstalled ZM (and tried my best to also uninstall MySQL, but I think that might be my issue - foreshadowing).
Anyway, I once again followed along with the video and have the console up so some things seem to be working, but I cannot add another user (I don't want to work in the default admin user account) - it gives me a " SQL-ERR '00000', statement was 'INSERT INTO `Users` (`Username`, `Name`, `Email`, `Phone`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Groups`, `Devices`, `Snapshots`, `System`, `MaxBandwidth`, `TokenMinExpiry`, `APIEnabled`, `HomeView`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'"
error, as well as a
"SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Email' cannot be null', statement was 'INSERT INTO `Users` (`Username`, `Name`, `Email`, `Phone`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Groups`, `Devices`, `Snapshots`, `System`, `MaxBandwidth`, `TokenMinExpiry`, `APIEnabled`, `HomeView`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' params:mloya,mloya,,,(redacted),,1,None,None,None,None,None,None,,None,,,1,console" error.
The only thing that I can imagine is happening is that it can't properly connect to the SQL server, which could be because I couldn't for the life of me get the password for the root user in order to drop the table when I was trying to uninstall it to start over.
I'm worried that I'm going to continue to run into issues once I start cameras, so I'd like to resolve these issues now.
Also, I'm worried about completely nuking my Ubuntu install because I just created a raid array via software, and I'm not sure if reimaging my boot drive would screw with that raid array and/or if I'd be able to restore the array without having to rebuild it upon the reimage. My hardware isn't anywhere near current gen (i7-4790) so it legitimately took 3/4 of a day to create the array, but I figured it would be decent enough to run an NVR box...
Any thoughts or tips would be sincerely appreciated. I just need something that works, I don't even care if it's the most up to date ver of ZM... Thanks in advance!
I'm incredibly new to ZM (as well as linux in general, but open source NVR solutions that are Windows-based are basically nonexistent so tada, now I'm learning linux) and figured I'd give it a shot, but I'm having a hell of a time trying to get it up and running properly.
I installed via the repository and it pulled 1.37.47, and I followed the steps in the 'ZoneMinder 1.37.28 on Ubuntu Kinetic' video, but it seems I'm either missing something or messed something up. I will admit, I enabled authentication before changing my admin password which locked me out, so I had to start over and just uninstalled ZM (and tried my best to also uninstall MySQL, but I think that might be my issue - foreshadowing).
Anyway, I once again followed along with the video and have the console up so some things seem to be working, but I cannot add another user (I don't want to work in the default admin user account) - it gives me a " SQL-ERR '00000', statement was 'INSERT INTO `Users` (`Username`, `Name`, `Email`, `Phone`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Groups`, `Devices`, `Snapshots`, `System`, `MaxBandwidth`, `TokenMinExpiry`, `APIEnabled`, `HomeView`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'"
error, as well as a
"SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Email' cannot be null', statement was 'INSERT INTO `Users` (`Username`, `Name`, `Email`, `Phone`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Groups`, `Devices`, `Snapshots`, `System`, `MaxBandwidth`, `TokenMinExpiry`, `APIEnabled`, `HomeView`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' params:mloya,mloya,,,(redacted),,1,None,None,None,None,None,None,,None,,,1,console" error.
The only thing that I can imagine is happening is that it can't properly connect to the SQL server, which could be because I couldn't for the life of me get the password for the root user in order to drop the table when I was trying to uninstall it to start over.
I'm worried that I'm going to continue to run into issues once I start cameras, so I'd like to resolve these issues now.
Also, I'm worried about completely nuking my Ubuntu install because I just created a raid array via software, and I'm not sure if reimaging my boot drive would screw with that raid array and/or if I'd be able to restore the array without having to rebuild it upon the reimage. My hardware isn't anywhere near current gen (i7-4790) so it legitimately took 3/4 of a day to create the array, but I figured it would be decent enough to run an NVR box...
Any thoughts or tips would be sincerely appreciated. I just need something that works, I don't even care if it's the most up to date ver of ZM... Thanks in advance!