hmmm getting there â€¦ one small issueâ€¦.

tibetfreedom · Post by **tibetfreedom** » Sun Oct 24, 2010 12:21 pm

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

bb99 · Post by **bb99** » Sun Oct 24, 2010 12:35 pm

Check your options tabs for values, every complaint listed is associated with variables in there.

tibetfreedom · Post by **tibetfreedom** » Sun Oct 24, 2010 12:44 pm

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'

Pada · Post by **Pada** » Sun Oct 24, 2010 2:49 pm

Did you import the tables & created + granted the zmuser database access, as instructed on the installation guides?

tibetfreedom · Post by **tibetfreedom** » Sun Oct 24, 2010 3:22 pm

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 ?

Pada · Post by **Pada** » Sun Oct 24, 2010 3:37 pm

# $ 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;

tibetfreedom · Post by **tibetfreedom** » Sun Oct 24, 2010 4:10 pm

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

bb99 · Post by **bb99** » Sun Oct 24, 2010 4:47 pm

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

Pada · Post by **Pada** » Sun Oct 24, 2010 4:51 pm

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

tibetfreedom · Post by **tibetfreedom** » Sun Oct 24, 2010 5:30 pm

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,