ZoneMinder Forums

ZoneMinder Forums
https://forums.zoneminder.com/

hmmm getting there … one small issue….

https://forums.zoneminder.com/viewtopic.php?t=16637

Page 1 of 1

hmmm getting there … one small issue….

Posted: Sun Oct 24, 2010 12:21 pm
by tibetfreedom
when loading up http://127.0.0.1/zm/
Table 'zm.Config' doesn't exist
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/zm/includes/config.php on line 144

Notice: Use of undefined constant ZM_OPT_USE_AUTH - assumed 'ZM_OPT_USE_AUTH' in /var/www/zm/index.php on line 87

Notice: Use of undefined constant ZM_LANG_DEFAULT - assumed 'ZM_LANG_DEFAULT' in /var/www/zm/includes/lang.php on line 29

Notice: Use of undefined constant ZM_OPT_USE_AUTH - assumed 'ZM_OPT_USE_AUTH' in /var/www/zm/includes/actions.php on line 35

Notice: Use of undefined constant ZM_AUTH_HASH_LOGINS - assumed 'ZM_AUTH_HASH_LOGINS' in /var/www/zm/includes/actions.php on line 35

Notice: Use of undefined constant ZM_WEB_L_REFRESH_MAIN - assumed 'ZM_WEB_L_REFRESH_MAIN' in /var/www/zm/skins/classic/includes/config.php on line 91

Notice: Use of undefined constant ZM_WEB_L_REFRESH_CYCLE - assumed 'ZM_WEB_L_REFRESH_CYCLE' in /var/www/zm/skins/classic/includes/config.php on line 92

Notice: Use of undefined constant ZM_WEB_L_REFRESH_IMAGE - assumed 'ZM_WEB_L_REFRESH_IMAGE' in /var/www/zm/skins/classic/includes/config.php on line 93

Notice: Use of undefined constant ZM_WEB_L_REFRESH_STATUS - assumed 'ZM_WEB_L_REFRESH_STATUS' in /var/www/zm/skins/classic/includes/config.php on line 94

Notice: Use of undefined constant ZM_WEB_L_REFRESH_EVENTS - assumed 'ZM_WEB_L_REFRESH_EVENTS' in /var/www/zm/skins/classic/includes/config.php on line 95

Notice: Use of undefined constant ZM_WEB_L_DEFAULT_SCALE - assumed 'ZM_WEB_L_DEFAULT_SCALE' in /var/www/zm/skins/classic/includes/config.php on line 96

Notice: Use of undefined constant ZM_WEB_L_DEFAULT_RATE - assumed 'ZM_WEB_L_DEFAULT_RATE' in /var/www/zm/skins/classic/includes/config.php on line 97

Notice: Use of undefined constant ZM_WEB_L_VIDEO_BITRATE - assumed 'ZM_WEB_L_VIDEO_BITRATE' in /var/www/zm/skins/classic/includes/config.php on line 98

Notice: Use of undefined constant ZM_WEB_L_VIDEO_MAXFPS - assumed 'ZM_WEB_L_VIDEO_MAXFPS' in /var/www/zm/skins/classic/includes/config.php on line 99

Notice: Use of undefined constant ZM_WEB_L_SCALE_THUMBS - assumed 'ZM_WEB_L_SCALE_THUMBS' in /var/www/zm/skins/classic/includes/config.php on line 100

Notice: Use of undefined constant ZM_WEB_L_USE_STREAMS - assumed 'ZM_WEB_L_USE_STREAMS' in /var/www/zm/skins/classic/includes/config.php on line 101

Notice: Use of undefined constant ZM_WEB_L_EVENTS_VIEW - assumed 'ZM_WEB_L_EVENTS_VIEW' in /var/www/zm/skins/classic/includes/config.php on line 102

Notice: Use of undefined constant ZM_WEB_L_SHOW_PROGRESS - assumed 'ZM_WEB_L_SHOW_PROGRESS' in /var/www/zm/skins/classic/includes/config.php on line 103

Notice: Use of undefined constant ZM_WEB_L_AJAX_TIMEOUT - assumed 'ZM_WEB_L_AJAX_TIMEOUT' in /var/www/zm/skins/classic/includes/config.php on line 104

Notice: Use of undefined constant ZM_OPT_USE_AUTH - assumed 'ZM_OPT_USE_AUTH' in /var/www/zm/skins/classic/skin.php on line 39

Notice: Use of undefined constant ZM_AUTH_TYPE - assumed 'ZM_AUTH_TYPE' in /var/www/zm/skins/classic/skin.php on line 41
ZoneMinder Login

Posted: Sun Oct 24, 2010 12:35 pm
by bb99
Check your options tabs for values, every complaint listed is associated with variables in there.

Posted: Sun Oct 24, 2010 12:44 pm
by tibetfreedom
bb99 wrote:Check your options tabs for values, every complaint listed is associated with variables in there.
I tried logging in with admin:admin
I can;t log in at all and get these errors...
Table 'zm.Config' doesn't exist
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/zm/includes/config.php on line 144

Notice: Use of undefined constant ZM_OPT_USE_AUTH - assumed 'ZM_OPT_USE_AUTH' in /var/www/zm/index.php on line 87

Notice: Use of undefined constant ZM_LANG_DEFAULT - assumed 'ZM_LANG_DEFAULT' in /var/www/zm/includes/lang.php on line 29

Notice: Use of undefined constant ZM_OPT_USE_AUTH - assumed 'ZM_OPT_USE_AUTH' in /var/www/zm/includes/actions.php on line 35

Notice: Use of undefined constant ZM_AUTH_HASH_LOGINS - assumed 'ZM_AUTH_HASH_LOGINS' in /var/www/zm/includes/actions.php on line 35

Notice: Use of undefined constant ZM_AUTH_TYPE - assumed 'ZM_AUTH_TYPE' in /var/www/zm/includes/actions.php on line 46

Notice: Use of undefined constant ZM_AUTH_TYPE - assumed 'ZM_AUTH_TYPE' in /var/www/zm/includes/functions.php on line 43

Notice: Use of undefined constant ZM_AUTH_RELAY - assumed 'ZM_AUTH_RELAY' in /var/www/zm/includes/functions.php on line 59
An error has occurred and this operation cannot continue.
For full details check your web logs for the code '549FC8'

Posted: Sun Oct 24, 2010 2:49 pm
by Pada
Did you import the tables & created + granted the zmuser database access, as instructed on the installation guides?

Posted: Sun Oct 24, 2010 3:22 pm
by tibetfreedom
Pada wrote:Did you import the tables & created + granted the zmuser database access, as instructed on the installation guides?
I could not find any import script or import data…
I created a database and made sure it had a user which is also accessable via ZM using the default database user name and password.

I did not find any import script or any reference to it … ?

Can you point me to this ?

Posted: Sun Oct 24, 2010 3:37 pm
by Pada
# $ sudo mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql
# mysql -u root -p (this brings you into a mysql shell)
# > grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';
# > flush privileges;

Posted: Sun Oct 24, 2010 4:10 pm
by tibetfreedom
Pada wrote:
# $ sudo mysql -u root -p </usr> grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';
# > flush privileges;
odd must be in a different place …

/usr/share/zoneminder/db/zm_create.sql: No such file or directory

Posted: Sun Oct 24, 2010 4:47 pm
by bb99
In a terminal as Root:

Code: Select all

mysql mysql < /usr/share/zoneminder/db/zm_create.sql

mysqladmin reload

mysql mysql

grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';

\q

exit

Posted: Sun Oct 24, 2010 4:51 pm
by Pada
tibetfreedom, those mysql commands should be given in the setup guide.
If you've followed the guide properly you wouldn't have had this issue.

You can find the zm_create.sql file by running:

Code: Select all

sudo updatedb
locate zm_create.sql

Posted: Sun Oct 24, 2010 5:30 pm
by tibetfreedom
Pada wrote:tibetfreedom, those mysql commands should be given in the setup guide.
If you've followed the guide properly you wouldn't have had this issue.

You can find the zm_create.sql file by running:

Code: Select all

sudo updatedb
locate zm_create.sql
OH that works thanks…
Odd I can't connect to mysql from the command line but can use mysqladministrator…
thanks,
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited