Page 1 of 1

1.21.4 & inserting the default admin user to the databas

Posted: Sat Nov 12, 2005 7:59 pm
by 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

Posted: Sun Nov 13, 2005 5:37 pm
by zoneminder
Ack! Thanks for pointing this out. I have updated the distribution to correct this problem.

Phil

Admin User not setup

Posted: Mon Dec 12, 2005 2:35 pm
by 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. :)