1.21.4 & inserting the default admin user to the databas

[KorayPeksayar]

Hello,
I have found a very minor bug.

Such as:
When doing a clean install, while inserting SQL statements from the zmschema.sql, MySQL may not install the default admin user and stop processing further.

That is because the original zmschema.sql created by zmconfig.pl does not have the exact same number of fields for the admin user as in the database User table schema.

I changed the default zmschema.sql to read:

Code: Select all

INSERT INTO Users VALUES ('', 'admin', PASSWORD( 'admin' ) , '', 1, 'View', 'Edit', 'Edit', 'Edit', 'Edit', '', '');

Inserting statements from the file is successful after this change.

In this case you would have to re-adjust the settings for the admin user using the web interface. This would be necessary however for the first run, to change the default password and etc.

Regards,
Koray

[zoneminder]

Ack! Thanks for pointing this out. I have updated the distribution to correct this problem.

Phil

[Lager Monster]

Thanx KorayPeksayar,
My admin user was not working from day 1.
Cutting & Pasting the SQL query code into phpMyAdmin fixed the problem, admin now works.