DB Users 1.19.5 -> 1.21.0?
Posted: Tue Apr 12, 2005 3:33 pm
I'm currently doing final configuration of my second zoneminder box. The first used 1.19.5 and this one is using 1.21.0. I have a question about the database users between the two versions.
In 1.19.5, I defined a limited access user with access only to SELECT and a priviledged user with INSERT, DELETE, UPDATE, and SELECT. The readme for 1.21.0 has the following paragraph in it, which mentions two different users of this sort. However, the zmconfig.pl script does not prompt me for anything but the priviledged user. Looking at zmconfig.txt on both machines and I see that the spot for the two different users is gone in 1.21.0. Was two dual-user setup removed and the readme for 1.21.0 simply out of date or am I missing something?
In 1.19.5, I defined a limited access user with access only to SELECT and a priviledged user with INSERT, DELETE, UPDATE, and SELECT. The readme for 1.21.0 has the following paragraph in it, which mentions two different users of this sort. However, the zmconfig.pl script does not prompt me for anything but the priviledged user. Looking at zmconfig.txt on both machines and I see that the spot for the two different users is gone in 1.21.0. Was two dual-user setup removed and the readme for 1.21.0 simply out of date or am I missing something?
Code: Select all
Among the first questions zmconfig.pl asks you are to do with the database and the next thing you should do is create it and the associated database users. You may notice that there are two sets of users and passwords. This is because the streaming server and utility binaries require only read access to the database so you may wish to create both a full access user and a limited access user. You can of course set both to the full access user. The included schema (zmschema.sql) can be used to actually create the tables required. The database is usually called just 'zm'.